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 

[mickjav]

Just Updated My Site With my First Mod Thanks to @Diego Andrés For all his help.

This is the first stage of a very large system

I've synced my personal DB with the site data for all artists Data
I have add the homepages for artists Which are searchable here

I have also added a like/fan system which will be expanded on in later version.

There are 5 artists "The Original Artists" Available in the Artists block top left these five have been updated with galleries and links.

I've also moded both the galleries and links sections to make attaching artist to both simple

There is also a edit system for the artists again this will be expanded as I learn more.

Thanks to all who have help be get this far.

[mickjav]

Stage 2 is well underway Think I'll be ready to add to main site this weekend

have added 600,000 recordings details on top of the 150,000 for artists details

NOTE THE LINKS ALL POINT TO MAIN SITE FOR RECORDINGS
https://www.databasedreams.co.uk/testing/index.php?action=music;area=artists;sa=home;art=-477275235

I am looking for somebody to build me some images this will be paid work

Images

• the post/no post on forum index I want this images to replace the index set but image will be edited for posts/no posts etc
  These are what I had built for my 2.0.19 forum
  off.png on2.pnp
  Both were for a dark background
• My Albums, My Singles Images will be sized for 20x20 what these are is each member will be able to add any recording to there list of recording which will at a later date be available in there profile
• Other image will be for Edit Recording

There may be more as I develop the system further PM Me if interested.

Also looking for somebody to help test these new system again pm if interested.

All the best mick

[mickjav]

Well I did it again...

Just moved version 1 of our newest section onto to main music & charts site.

after adding nearly 4 million records I now have the first of a number of systems for my charts this being the number 1's

https://www.databasedreams.co.uk/charts/index.php?action=music;area=charts;sa=numone.

I would like to thank all this who continue to help even when I ask silly questions lol

All the best mick

PS It's a work in progress I'm waiting on a new banner for it and the queries may need some tweaking to speed it up 

[Steve]

Geez mick, what you've put together is nothing short of impressive!

[mickjav]

We'll I've been at it again, Working Over Christmas   

But I think the result is worth all the headaches

https://www.databasedreams.co.uk/charts/index.php?action=music;area=charts;sa=weekly

This is the last major piece of my chart system, It's still not 100% complete as will be adding a Data Error reporting system plus A Chat system designed to work with the weekly charts, I was going to combine the 2 but can make the error Report system a classy tool on it's own.

As Always thanks goes out to those who have helped over the last year your all stars.

All the best mick.
Music & Charts Site Project

[Steve]

Very nice Mick! 

[mickjav]

Works have now been completed on the next phase Of DD Music & Charts

I would like to thank @Diego Andrés for the Amazing job he did on this mod.

History:
I had 2 options, both with their benefits and drawbacks

• Create a script that would update topics on mass for those within the charts for that week, this might have been 100-200 Topics. The drawback to that was the data would still be semi updated, and no additional systems could be used.
• Use BBCodes and get info from DB, Which is what I decided to do as Read below

As I went for option 2 I am now able to add some additional features to it
See Here: https://www.databasedreams.co.uk/support/index.php?topic=182.0

So what Diego has done for me is enable 4 bbcodes that use a file I added with functions to display
Album Info stored in my dB Awards, Info, Stats & Tracks.

You can see one result below "Please note, I still have the Colour formats to add"

https://www.databasedreams.co.uk/charts/albums-database/taylor-swift-album-midnights-2022/

This is what the old system looked like

https://www.databasedreams.co.uk/charts/albums-database/taylor-swift-album-1989-2014/
I will be updating above soon

This is also useable for groups, so members with the correct permissions can post one or more bbcodes but that will be very limited 

So in a nutshell, I have a system that is current to the visitor viewing it.

As already said I still have lots to do and intend working on it over easter.

[Steve]

I just signed up so I could look at some things I couldn't as a guest ...

Amazing, amazing job Mick!

[mickjav]

Thanks, Steve, but most of the heavy lifting has been done by @Diego Andrés It's still got a long ways to go.

There is a lot that guests just don't get to experience and a lot of available resources, plus members can interact with the wide system.

Hopefully one day it'll take off, but I still have a min of a year left on the development

[Steve]

I understand that and appropriate kudos to Diego as well. My comment still stands. In the meantime, okay to stay a member?

[mickjav]

I understand that and appropriate kudos to Diego as well. My comment still stands. In the meantime, okay to stay a member?

Yeah no problem.

[mickjav]

Have completed Stage 2 or is it 3 lol of the Albums Database, Again Thanks to @Diego Andrés For his work on this section.

https://www.databasedreams.co.uk/charts/albums-database/various-artists-album-now-that-s-what-i-call-timeless-the-songs-2022/

Plus I have added a most popular tracks List complete with a list of albums that track is on.

https://www.databasedreams.co.uk/charts/index.php?action=music;area=album;sa=top

Currently looking at adding a module to the ST Shop, Which will allow me to create some prize items

https://custom.simplemachines.org/index.php?mod=1794

Still got a mass of work left to do, but most of that now is behind the scenes.

All the best mick.

[Julius_2000]

Just had a look at your site and searched for an artist's picture. I noticed that there's a hover effect setting a white border which makes the formatting jerking.

Maybe you'd want to edit this selector

Code Select Expand

.fn-container img {
border-width: 0px;
}
to
   

Code Select Expand

.fn-container img {
        border: 2px solid transparent;
}

[mickjav]

Thanks will sort it.

[mickjav]

You can't look at the main site, so have removed the link from my profile sig.

You can check out the test site, "There may be errors"

Gallery System Update
Still have work to do in this system
https://www.databasedreams.co.uk/testing/index.php?action=gallery;sa=view;id=24760;gpid=24309

• Altered the gallery system, so images are able to be added from all music sections that use pictures.
• Updated permissions, so members of specific group can now create gallery sets Via artists main page I.E. Main, Tours/concerts, Album Covers, Videos.
• Added a many-to-many table, so pictures can be shared between galleries.
• Made it easier to copy pictures by adding a button to the view picture page
• Altered the Copy picture so it no longer created another image set, It now uses the many-to-many table.
• Edited all code that created a copy of images I.E. set as thumbnail, copy image
• Added Connections to stats showing all gallieries that picture is in.

Links section
https://www.databasedreams.co.uk/testing/index.php?action=music;area=people;sa=person;pers=672
Updated add/edit links so links can be added from people, tour venue sites Atc

New Sections:
Tours Concerts

Report System in progress
Help System "Not Started"
Awards System "Still a few pages to add"
Personal charts system "Not Started"
Gigging system "Not Started"

I have updated the Albums database, taking it away from the forums and creating it's own page
https://www.databasedreams.co.uk/testing/index.php?action=music;area=album;sa=albums;rec=1637532409;art=-477275235

Artists homepages have been updated

Plus so many other updates it's hard to remember them lol

I'm only able to spend between 6-10 hours a week on the code as I'm also adding data to all sections I have another 4 million chart entries to sort and add plus another 100k album tracks to add

So I'm not expecting it to be ready until July next year as I'm unable to give access to main site to others while in maintenance mode unless this mode is updated for 2.1.4 Allow Access in Maintenance Mode

Also added a managers section to aprovals of all music items, pictures, Links

[mickjav]

I may create a mod for this once I have it working fully.

This does require a lot of data as it's a page system

Features:

• Any page can be turned off too general members/Guests
• uses action & sa to display page correctly
• portal page that don't use action can have a help page "See image below"
• help pages are able to have multiple topics.
• Topics can be moved up/down
• FAQ System will be included
• found helpful system "using the topics likes table"

Menu button will only be visible for pages with active help entry in main help table


image below shows my testing site homepage system "it's a work in progress"


topics entry system BBC Code can be used making it more interesting

[mickjav]

2024-2025 redesign update

Finally got my albums' system working.

Features:

• All tracks can be rated 1-5
• Album can be rated 1-10
• Votes can be changed after 10 mins
• votes locked after 2 days

Planned additions reliant on other systems
members of managers groups will be able too:

• Add Genre /styles
• Add Info I.E. Producer, songwriters Act.

above, currently added via my db export

Example Test Site https://www.databasedreams.co.uk/testing/index.php?action=music;area=album;sa=albums;rec=-1489224253;art=-477275235

[mickjav]

Gonna start posting with updates as I bring each new section online or get them to a level where they are usable.

I'm currently working on a fan system that only allows members who have joined an artists fan club to view  or add any of the following, fan topics, fan gallery, fan links plus a banner system a ban system.

I'll post the help page image with each section as I'm only allowing current members in until I complete all main section.

Below is the homepage help page which is used to allow visitors to jump to any page of interest.