Database Dreams - Music And Chart

[mickjav]

Database Dreams Home Page

Database Dreams - Music And Charts

My site originally started life as a creataforum Site, After purchasing the site I moved it onto Hostit I have started what will be a long upgrade project, The site it hoped to include the following

• Main Site with Sub PHP Pages for downloads, Development Schedules Etc
• Should it need it later a support forum.
• At present the only forums installed are the music & charts (More About them below).
• I will be installing a second set of forums called The Librarian basic info on homepage, This forum will be edited into a version of one of my databases for myself and anybody else interested.
• Once above works completed I intend building a project management system, this will not include a forum

About me I've been designing Access databases for over 20 years and have decided the current project will be my last in access from now on I will be working with PHP & MYSQL.

Database Dreams - Music and charts is a forum where we post analysis outputted of charts from around the world, from mine and other users Access Db's and share things like albums and track Data and more using the downloads mod, You can request a artist have a home page, chat about music/artists Etc

Mods Installed

• Downloads Pro
• Gallery Pro
• Welcome: https://custom.simplemachines.org/mods/index.php?mod=789
• Home Button: https://custom.simplemachines.org/mods/index.php?mod=2870
• badge awards: https://www.smfhacks.com/badgeawards.php
• Contact Page: https://custom.simplemachines.org/mods/index.php?mod=377  (Added 07 August 2021)
• The Site has it's own Help system using pages (I am currently updating this)
• SMF Links https://custom.simplemachines.org/mods/index.php?mod=381 (Added 07 August 2021)
• There are around 40 pages used for projects etc
• A Custom block has been created for users galleries and download (I may move that to the profile itself)
• Custom blocks have been create for my projects and things like recommended posts & Freeware Etc
• Added Awesome Post Ratings (08 August 2021)
• Added Emoji Pro (08 August 2021)
• Added Related Topics https://custom.simplemachines.org/mods/index.php?mod=189 (09 August 2021)
• Added hashtags https://www.smfhacks.com/hashtags.php (09 August 2021)

Please note non music chart related Access Downloads will be moved onto the main sites downloads system I haven't built yet lol

[mickjav]

I have just enabled the next part of my dastardly plan, My Access Programs Support Forums

I still have a few downloads to move across but the structure is complete.

I will post a complete list of mods ASAIC

I have not enabled the Ad Seller Pro As To be honest I still have to figure out how to use all the fiddly bits.

mick

[mickjav]

We did It Again! Thanks to work on the Sub Categories Page by @Diego Andrés, Have sorted paging errors and really pleased with the look, Also resorted the Categories by name.

Artists Galleries

[Doug Heffernan]

It looks very nice and well-organised.

[mickjav]

Thanks Just sorted error with bottom paging placement    Now I'll be spending months adding all the pictures I've collected over the last 25 years 

[Doug Heffernan]

Thanks Just sorted error with bottom paging placement    Now I'll be spending months adding all the pictures I've collected over the last 25 years 

It sounds like a lot of fun

[Steve]

Love love love the color scheme! 

[TwitchisMental]

Thanks Just sorted error with bottom paging placement    Now I'll be spending months adding all the pictures I've collected over the last 25 years 

Oh geez thats alot of pictures haha.

Good work on your site .

[Mick.]

I have an issue with this.
Your site is NOT mobile friendly in any way 

[mickjav]

I have an issue with this.
Your site is NOT mobile friendly in any way 

It display's on my tab just fine and just checked On phone I forgot to disable the left blocks on mobile other than that it displays ok, But there are plans for a new theme which part of the contract will be mobile friendly.

regarding new theme I haven't made up my mind or seen anything that comes close to what I want.

[mickjav]

Updated the left block and looking good 

[TwitchisMental]

Updated the left block and looking good 

I am not sure if this is what Mick. is specifically calling out, but this is what the main website looks from a phone -



An easy way to resolve this would be using a flex grid.

Example - https://codepen.io/taniarascia/pen/rOLEGe

[Mick.]

Well, there's more to it.

The forum index as well

[mickjav]

As I said I intend getting a new theme sorted once I can afford.

[TwitchisMental]

As I said I intend getting a new theme sorted once I can afford.

For your main page I have an easy fix.

Open your css file and add this to the bottom of it -

Code Select Expand

/* Grid */

.column {
  flex-basis: 100%;
}

@media screen and (min-width: 800px) {
  .row {
    display: flex;
    flex-direction: row;
    flex-wrap: nowrap;
  }
  .column {
    flex: 1;
  }
  ._25 {
    flex: 2.5;
  }
  ._5 {
    flex: 5;
  }
}
Now on your main html page. You will just need to add the grid to the page.

So for example your picture paragraph picture setup. Replace the <main> section with the following -

Code Select Expand

<main>
 <div class="row">
  <div class="column">
    <img title="DD Admin" src="https://www.databasedreams.co.uk/images/MickSpainMain.jpg" alt="DD Admin" width="200" height="275">
  </div>
  <div class="column">
    I started working with Microsoft Office back in 1995<br><br>To be honest I still don't know what made me start working with access<br><br>Once I got the bug I just couldn't stop, I designed a lot of programs in the early days, looking at them now I wonder how they worked as well as they did.<br><br> One of my first programs was called chart tracker elite which was released in 2004 and was downloaded thousands of times as you will see I am now redesigning this program making it even more useful, It will now include a copy of <a href="https://www.databasedreams.co.uk/charts/index.php?action=ezportal;sa=page;p=36">Apollo</a> plus a large number of additional features for more information please see the Chart Tracker Elite 2525 homepage <a href="https://www.databasedreams.co.uk/charts/index.php?action=ezportal;sa=page;p=37">Here</a>
<p>I took a break for a few years but could never shake the bug so returned to designing programs in 2018</p>
<p>2021 Onwards</p>
<p>Once works are completed on <a href="https://www.databasedreams.co.uk/charts/index.php?action=ezportal;sa=page;p=37">Chart Tracker Elite 2525</a> I will not be creating any new projects with access, I will instead be working with PHP and MYSQL on this site.</p>

  </div>
  <div class="column">
    <img title="The Power behind the thrown" src="https://www.databasedreams.co.uk/images/SpainCarolMain.jpg" alt="Carol" width="200" height="264">
  </div>
</div>
 
</main>
This will get the main section to be layed out in a grid like fashion. Once it gets to a smaller screen it will actually stack on each other.

As you can see here(note I did not add the grid to everything) -



Now a wee bit more work may be required to get the menu and header to be responsive.

[mickjav]

Thanks Hadn't thought about that page that was my first attempt at a page with includes and a css thanks for the help.

mick

[mickjav]

One of the issues I do have with finding a new theme is finding one that can work with these pages I.E. MY Chart Analysis as there are over 700 topics with the format I don't want to mess with them.

https://www.databasedreams.co.uk/charts/weekly-charts-analysis/uk-singlesalbums-charts-24-dec-2021-to-30-dec-2021-analysis/

I have checked these on my phone and seem to display OK but may have to split the albums and singles into single topics instead of one, the guy who posts the us charts has already done that 

[mickjav]

Well Am a very happy chappy for the first time I have a site without errors Except a minor theme switcher/Install error

Thanks to @Diego Andrés for upgrading the site I would highly recommend him for any works related to SMF.

Thanks to @vbgamer45 he's saved me more time than I can count.

And of course the theme's designers.

Think I got most installed just have one more Mod to do 

https://www.databasedreams.co.uk/charts/index.php

[mickjav]

Finally got the landing page of Music And Charts Finished 

https://www.databasedreams.co.uk/charts/index.php

It's not all using the db at present but will be starting works on a completely new system that I hope will replace my Chart Tracker Elite 2525 Local Db bringing it online but that will I expect take 2 years to complete for now I'll be adding bit's here and there.

Thanks to all those who Have helped me get it this far.

All the best mick

[mickjav]

Lots of pictures, but nicely done!

Thanks

I'm currently working on some new toys 

https://www.databasedreams.co.uk/testing/index.php?action=music;area=artists;sa=home;art=-477275235

Note: this is a test site as such there may be errors