NinSheetMusic Forums

Important Stuff => Site News => Topic started by: The Deku Trombonist on October 05, 2014, 04:58:41 AM

Title: Site Upgrade
Post by: The Deku Trombonist on October 05, 2014, 04:58:41 AM
Today we have the first part of a site upgrade!

Most of the changes are behind the scenes, with the biggest change being a newly restructured database. For the computer nerds out there reading this, we've moved to a relational database model which is easier to maintain and upscale/modify as needed. What this basically means is that in the end it's easier to add new series and consoles and easier to add/edit sheets.

As part of today's upgrade, you'll also notice that the arranger list is now up to date (which a number of you have been asking for). This, as well as other lists will be dynamically updated from now on, so as soon as you've got your first sheet on the site, your name will magically appear on the list. You can edit your arranger name through your forum profile which will effect anywhere your name appears on the site.

If you see any issues, please let me know and I'll try and fix them as soon as possible. Happy NSMing!
Title: Re: Site Upgrade
Post by: Olimar12345 on October 05, 2014, 08:30:01 AM
OH YEAH!! (http://www.ninsheetm.us/browse/series/Pikmin)
Title: Re: Site Upgrade
Post by: DonValentino on October 05, 2014, 09:09:11 AM
Great! :J

Quote from: Olimar12345 on October 05, 2014, 08:30:01 AMOH YEAH!! (http://www.ninsheetm.us/browse/series/Pikmin)

Captain Olimar would be very proud indeed!

But tbh if Tales and Harvest Moon have a section, I must say that Earthbound/Mother deserves a standalone section too.
Title: Re: Site Upgrade
Post by: The Deku Trombonist on October 05, 2014, 05:09:11 PM
I was thinking about that but for some reason I never got around to it. I'll do it now.
Title: Re: Site Upgrade
Post by: Maelstrom on October 05, 2014, 06:44:59 PM
I just thought of something! How much work would it be to make all the arranger names on the side of the normal browsing list of sheets thing to link to the rest of their arrangements?
Title: Re: Site Upgrade
Post by: The Deku Trombonist on October 05, 2014, 07:24:17 PM
Yep, that can be done pretty easily.
Title: Re: Site Upgrade
Post by: Yugi on October 05, 2014, 07:27:40 PM
Can we remove the dead sections, such as Metal Gear Solid and Dragon Quest?
Title: Re: Site Upgrade
Post by: braix on October 05, 2014, 07:29:03 PM
we need a link to ninsheetm.us/browse on the main page
Title: Re: Site Upgrade
Post by: Sebastian on October 05, 2014, 07:29:51 PM
And with all the paper mario ones coming maybe a section for that would be nice...
Title: Re: Site Upgrade
Post by: Yugi on October 05, 2014, 07:34:02 PM
I don't see why Paper Mario songs don't fall under the mario category.

It's like making a Xenoblade section even though Xenoblade is only one game.
Title: Re: Site Upgrade
Post by: JDMEK5 on October 05, 2014, 07:34:37 PM
Quote from: mariolegofan on October 05, 2014, 07:29:51 PMAnd with all the paper mario ones coming maybe a section for that would be nice...
That's under Super Mario. (Which you already knew.) Rue the day we make individual sections for individual games/miniseries.

EDIT: Ninja'd.
Title: Re: Site Upgrade
Post by: Jamaha on October 05, 2014, 09:58:47 PM
Quote from: zoroark1264 on October 05, 2014, 07:29:03 PMwe need a link to ninsheetm.us/browse on the main page

There already is one, as "Sheet Music" in the navigation bar. Unless I'm misunderstanding something here.
Title: Re: Site Upgrade
Post by: braix on October 06, 2014, 04:11:37 AM
Quote from: Jamaha on October 05, 2014, 09:58:47 PMThere already is one, as "Sheet Music" in the navigation bar. Unless I'm misunderstanding something here.
okay
Title: Re: Site Upgrade
Post by: The Deku Trombonist on October 06, 2014, 04:29:26 AM
Removing dead sections? No.

As for splitting up current sections, I don't really see what the problem is. Potential series like Mario Kart or Paper Mario already have over 60 sheets each, and that's only going to increase. Why does everything have to be kept in as few giant sections as possible anyway?

Quote from: JDMEK5 on October 05, 2014, 07:34:37 PMRue the day we make individual sections for individual games/miniseries.
Is it really that bad? Wow, they're only sections...
Title: Re: Site Upgrade
Post by: Winter on October 06, 2014, 04:54:06 AM
I swear I swear I swear when I have stability in my life, you guys get me back. But I'm so happy that the site is flourishing in my absence as well! Amazing!
Title: Re: Site Upgrade
Post by: DonValentino on October 06, 2014, 06:15:44 AM
Quote from: DekuTrombonist on October 06, 2014, 04:29:26 AMAs for splitting up current sections, I don't really see what the problem is. Potential series like Mario Kart or Paper Mario already have over 60 sheets each, and that's only going to increase. Why does everything have to be kept in as few giant sections as possible anyway?
Is it really that bad? Wow, they're only sections...

But would it really be convenient to have separate sections for Mario Kart, Paper Mario, Mario & Luigi and Super Mario? I could understand Wario or Yoshi having their own one, but that much splitting would be excessive. imo it depends on the different series themselves rather than the number of sheets of a sub-series. That's why Layton, Tales, Dragon Quest or Harvest Moon have their own sections in first place, even if they don't have that many sheets.

I think now it's perfect as it is :J
Title: Re: Site Upgrade
Post by: mikey on October 06, 2014, 06:35:41 AM
Quote from: DonValentino on October 06, 2014, 06:15:44 AMBut would it really be convenient to have separate sections for Mario Kart, Paper Mario, Mario & Luigi and Super Mario?
...

yes
Title: Re: Site Upgrade
Post by: Sebastian on October 06, 2014, 07:11:32 AM
Quote from: DonValentino on October 06, 2014, 06:15:44 AMBut would it really be convenient to have separate sections for Mario Kart, Paper Mario, Mario & Luigi and Super Mario? I could understand Wario or Yoshi having their own one, but that much splitting would be excessive. imo it depends on the different series themselves rather than the number of sheets of a sub-series. That's why Layton, Tales, Dragon Quest or Harvest Moon have their own sections in first place, even if they don't have that many sheets.

I think now it's perfect as it is :J
I agree
And Paper Mario would just be Paper Mario, it'd be the TYYD, Super Paper Mario and Sticker Star.
There will eventually be around 200 Paper Mario songs.
Mario Kart too would be nice.
Title: Re: Site Upgrade
Post by: MaestroUGC on October 06, 2014, 07:32:44 AM
Since it's set-up to have the side bar organized by franchise, that could forward or open up to reveal subsections.

For ex: Hover over/click on Super Mario and it spread out to show sub-sections for the Main Series, Mario Kart, Mario Party, Paper Mario, Luigi's Mansion, etc.

We should also think about reorganizing the site to have the games ordered chronologically by release rather that alphabetically, since that's probably how most people would want to browse through the library.
Title: Re: Site Upgrade
Post by: DonValentino on October 06, 2014, 09:56:15 AM
Quote from: MaestroUGC on October 06, 2014, 07:32:44 AMSince it's set-up to have the side bar organized by franchise, that could forward or open up to reveal subsections.

For ex: Hover over/click on Super Mario and it spread out to show sub-sections for the Main Series, Mario Kart, Mario Party, Paper Mario, Luigi's Mansion, etc.

We should also think about reorganizing the site to have the games ordered chronologically by release rather that alphabetically, since that's probably how most people would want to browse through the library.

+100000000000
Title: Re: Site Upgrade
Post by: Maelstrom on October 06, 2014, 10:22:06 AM
Quote from: MaestroUGC on October 06, 2014, 07:32:44 AMWe should also think about reorganizing the site to have the games ordered chronologically by release rather that alphabetically, since that's probably how most people would want to browse through the library.
+∞
Title: Re: Site Upgrade
Post by: mikey on October 06, 2014, 10:27:25 AM
Quote from: maelstrom. on October 06, 2014, 10:22:06 AM+∞
+8

Actually I don't think either are optimal organization strategies tbh because with alphabetical you don't know whether articles are included in the title (EG is wind waker under W or T).  With chronological order I'm sorry, but I couldn't tell you which was made first, paper mario or super mario 64.
Of course I really shouldn't complain seeing as I can't think of a better idea.
Title: Re: Site Upgrade
Post by: SlowPokemon on October 06, 2014, 10:34:34 AM
No offense but you also think all Pokemon is crap after Gen III. Chronological order would be much more convenient for the rest of us, correct me if I'm wrong.
Title: Re: Site Upgrade
Post by: MaestroUGC on October 06, 2014, 10:44:03 AM
You never factor the articles in Titles as the first word when organizing something alphabetically. Anything beginning with "the" "a" "an" etc. would be organized:

Legend of Zelda, The
Legend of Zelda II, The
Legend of Zelda, The: A Link to the Past

etc.

And for ordering things chronologically all it would take is a quick Google search to double check dates.
Title: Re: Site Upgrade
Post by: mikey on October 06, 2014, 10:48:15 AM
Quote from: SlowPokemon on October 06, 2014, 10:34:34 AMNo offense
Yeah right
If you meant no offense you wouldn't have even said that I think all pokemon is crap after gen 3
why do you have a problem with me and why do you put words in my mouth?
Title: Re: Site Upgrade
Post by: MaestroUGC on October 06, 2014, 10:51:38 AM
Children, settle down, this is not an issue worth getting to an argument about.
Title: Re: Site Upgrade
Post by: Maelstrom on October 06, 2014, 11:00:30 AM
At the very least, games in the same series need to be put together in the "other" section. It may or may not help if subseries were categorized together and those were put in chronological order, like Mario Kart and Paper Mario. This might get too confusing, though.....
Title: Re: Site Upgrade
Post by: MaestroUGC on October 06, 2014, 12:07:43 PM
I don't think the sub-series themselves need to be ordered chronologically, but it wouldn't hurt, in fact I think sub-series should be ordered alphabetically in the drop-down menu or whatever. This is mainly an issue for stuff like the bajillion Mario games out there.

For ex:

Super Mario>
-Main Series (Super Mario Bros.)
-Mario Kart
-Paper Mario
-Mario and Luigi
-Mario Party
-Sports Games
-Misc.

This generally wouldn't be an issue for other Franchises like Zelda, Metroid, Kirby since they get very few games (if any) that are not part of their main series.

Everything in "Other" should at least organize smaller franchises and games together. It's pain wading through 20 or so games just to find one when it should only take a few clicks (or a simple search) to get to.

All this said I think the biggest priority once the site is revamped to function better is to optimize and make accessing the library as quick and painless as possible for guests, especially for people who stumble across the site for the first time.
Title: Re: Site Upgrade
Post by: blueflower999 on October 06, 2014, 05:35:41 PM
*whoever did this is my favorite person on the forums* (http://www.ninsheetm.us/browse/series/EarthBound)
Title: Re: Site Upgrade
Post by: Olimar12345 on October 06, 2014, 05:55:51 PM
It's got the capital "B" and everything! :J
Title: Re: Site Upgrade
Post by: The Deku Trombonist on October 06, 2014, 08:12:41 PM
Quote from: MaestroUGC on October 06, 2014, 07:32:44 AMSince it's set-up to have the side bar organized by franchise, that could forward or open up to reveal subsections.

For ex: Hover over/click on Super Mario and it spread out to show sub-sections for the Main Series, Mario Kart, Mario Party, Paper Mario, Luigi's Mansion, etc.
I think that side bar is going to disappear eventually, or at least its contents. It'll be replaced with cool things like most popular sheets of the month, miscellaneous stats, perhaps a featured sheet or sheet performance video etc etc. Also, I have already considered sub-sections but it's potentially a bit of work to make it work so it's definitely not a priority, if it it is to be done at all.


Quote from: MaestroUGC on October 06, 2014, 07:32:44 AMWe should also think about reorganizing the site to have the games ordered chronologically by release rather that alphabetically, since that's probably how most people would want to browse through the library.
That's heresay so I'm not going to go there. However, chronological order is on the to-do list as a browsing option. I'd still leave the default as ascending alphabetical though.


Quote from: MaestroUGC on October 06, 2014, 10:44:03 AMYou never factor the articles in Titles as the first word when organizing something alphabetically. Anything beginning with "the" "a" "an" etc. would be organized:
That would also require some interesting reworkings, if it was to be done with any degree of automation. I'm not really sure how many things that would effect either. For example, the examples you listed would not be effected seeing as all main Zelda games start with "The Legend..." except for Zelda II, which would still end up at the bottom and then there is Freshly Picked Tingle which would still be at the top. So this brings us back to what would it effect and a quick look at the sheet library says that it's only a couple of games near the bottom of the "Other" series.


Quote from: DonValentino on October 06, 2014, 06:15:44 AMBut would it really be convenient to have separate sections for Mario Kart, Paper Mario, Mario & Luigi and Super Mario? I could understand Wario or Yoshi having their own one, but that much splitting would be excessive. imo it depends on the different series themselves rather than the number of sheets of a sub-series. That's why Layton, Tales, Dragon Quest or Harvest Moon have their own sections in first place, even if they don't have that many sheets.

I think now it's perfect as it is :J
Anyway, the only reason I wanted to split up a couple of Mario ones is to improve usability for now, seeing as it's by far the biggest page on the site and that's a fair amount of stuff to scroll through if you just want to find a couple of sheets. They're not all going to be split up into tiny pieces. The examples you listed with Wario and Yoshi aren't very helpful either. Where does Yoshi's Island(Super Mario World 2) go? Or Wario Land (Super Mario Land 3)? And not simply from the point of view of correctness, but also for minimal confusion.


Quote from: blueflower999 on October 06, 2014, 05:35:41 PM*whoever did this is my favorite person on the forums* (http://www.ninsheetm.us/browse/series/EarthBound)
I guess that's me, yay.
Title: Re: Site Upgrade
Post by: Sebastian on October 07, 2014, 07:26:00 PM
Quote from: DekuTrombonist on October 06, 2014, 08:12:41 PMI think that side bar is going to disappear eventually, or at least its contents. It'll be replaced with cool things like most popular sheets of the month, miscellaneous stats, perhaps a featured sheet or sheet performance video etc etc. Also, I have already considered sub-sections but it's potentially a bit of work to make it work so it's definitely not a priority, if it it is to be done at all.

That's heresay so I'm not going to go there. However, chronological order is on the to-do list as a browsing option. I'd still leave the default as ascending alphabetical though.

That would also require some interesting reworkings, if it was to be done with any degree of automation. I'm not really sure how many things that would effect either. For example, the examples you listed would not be effected seeing as all main Zelda games start with "The Legend..." except for Zelda II, which would still end up at the bottom and then there is Freshly Picked Tingle which would still be at the top. So this brings us back to what would it effect and a quick look at the sheet library says that it's only a couple of games near the bottom of the "Other" series.

Anyway, the only reason I wanted to split up a couple of Mario ones is to improve usability for now, seeing as it's by far the biggest page on the site and that's a fair amount of stuff to scroll through if you just want to find a couple of sheets. They're not all going to be split up into tiny pieces. The examples you listed with Wario and Yoshi aren't very helpful either. Where does Yoshi's Island(Super Mario World 2) go? Or Wario Land (Super Mario Land 3)? And not simply from the point of view of correctness, but also for minimal confusion.

I guess that's me, yay.
Cool can't wait :)
Title: Re: Site Upgrade
Post by: JDMEK5 on October 08, 2014, 09:43:05 PM
Quote from: DekuTrombonist on October 06, 2014, 04:29:26 AMIs it really that bad? Wow, they're only sections...
No, I was just exaggerating again. I mean, subsections would work but I was talking about like individual pages for individual games/miniseries thereby causing every page to be super long even if there were no sheets. Like where it currently has "Super Mario, Pokemon, The Legend of Zelda, Super Smash Bros., etc." That would be a problem but I'm not at all against a neat-looking subsection method. Just thought I should clear that up.