#61
|
||||
|
||||
Yeah, that's what I meant. The same problem that previously affected the displaying of discs in tracklists.
|
#62
|
||||
|
||||
Ah, yeah. Unfortunately when we sort by strings/text rather than numbers, computers regard "10" to be lower than "2" (although some programs such as Windows Explorer can detect numbers in strings and sort correctly).
We do have natural sorting functions (natsort() in PHP) to do this, but MySQL ORDER BY doesn't support it so I guess we'll have to perform an extra sorting step within PHP. It should be doable. |
#63
|
||||
|
||||
One problem with the scan titles, is that all the ones whose titles were entered solely with the open text bar, have an extra space in front of them so they sort wrong. What we'll have to do, is write some code to query them all, and eat the leading whitespaces.
|
#64
|
||||
|
||||
0.11.6
- Artist links are now publicly viewable. - Unlinked artists can be added to groups (note, all artist editing is still restricted to staff/trusted editors for the time being.) - Scan caption sorting fixed. The problem was some extra whitespace at the beginning of the custom captions. - You can now add additional notes to reprints while editing the reprint directly. These show up at the beginning of the notes field. - Adjusted some of the colors in the release type color key. - Made a few modifications to search to speed up the track title queries. - Modified the most viewed albums statistic so that it includes both album page and gallery page views. This fixes an inconsistency, where the 30-day window viewcount was higher than the total viewcount. - Added the album release frequency table to the stats pages. - Any tracklist with no title is now called "Untitled". This'll make it possible to fix them. - A few cosmetic changes may also be noticed. |
#65
|
||||
|
||||
I guess this is the place to point out a few (minor) bugs, so I thought I'll do that, they are all related to the Artists' page.
You have a Masharu Iwata in your Database. I think it's pretty obvious what to change here. Konami Kukeiha Club also appears two times, one time as Konami Kukeiha Club and one time as Kukeiha Club. For "More than Mario" you've listed a composer called Kazou Ishikawa. I'm not sure whether he's spelled wrong in the album or just here, but it's Kozue Ishikawa actually. |
#66
|
||||
|
||||
Hey, FPI. Those are nice catches. I took care of Masaharu Iwata, and finished taking care of Kozue Ishikawa.
As for KKC, there are two of them: - Konami Kukeiha Club is the sound team that composed game music. - Kukeiha Club is the band that was formed by members of KKC, and made some albums. Of course, the difference is pretty subtle. |
#67
|
||||
|
||||
Quote:
Quote:
|
#68
|
||||
|
||||
I would like to insist that if features are disabled when a user is not logged in, they are made aware of why the features aren't working. I was boggled when I couldn't view full scans or add any new scans. Only to later realize I wasn't logged in.
|
#69
|
||||
|
||||
Quote:
So, I'd like there to be some kind of warning too, but we can't really afford to make it so difficult for our site to be correctly indexed, so this is going to require creative solution. |
#70
|
||||
|
||||
I changed it so that the edit menu gives guests a little message stating that you need to be logged in to edit. It's not a link, so it won't affect the indexing.
|
#71
|
||||
|
||||
One other thing I noticed. I guess it's not really a bug, but it bothered me a bit:
I noticed you have only a limited space for the artist field (and probably for some other fields, too), which means that you can't put all artists in the field. It's not a big deal at the moment, since you can put everything in the notes-field of course (as suggested in the description), but with the new artist links in the works that doesn't make much sense, because that would mean the discography for some of them would be somewhat incomplete in a few cases. |
#72
|
||||
|
||||
I'd been meaning to do that, so I just doubled the size of the composer/aranger/performer fields. That should be plenty.
|
#73
|
||||
|
||||
Hehe, I agree! Thanks for that!
|
#74
|
||||
|
||||
If you add too many artists however you'll end up stretching the field, as evident in this entry: http://www.vgmdb.net/db/albums.php?id=4608.
|
#75
|
||||
|
||||
Quote:
|
#76
|
||||
|
||||
I'll have to let Gigablah handle that one.
Meanwhile, might as well advance 1 more tick: 0.11.7 - Awesome new display filter added to artist pages. This way, you can filter the discography based on release type. - New fields added to artist display (bloodtype, death, etc.) - New topbar navigation style - Some site navigation changes - Fixed a bug where some fields weren't correctly pulling certain information from the parent album when a reprint was created. - Added more info to the child albums pulldown (date, media, foreign printing.) - Reprints now have their own notes field, which displays above the parent's notes. - Artist field sizes doubled to accomodate albums with a lot of credits. - Added top artist view statistics to the stats page. - Changed to a numeric display format on stats page. |
#77
|
||||
|
||||
Another small thing:
Yasuhiro Kawamaki does not exist, I mistyped Yasuhiro Kawakami in "Super Famicom Magazine Vol.9". I tried to change that, but after the linking was done, it seems I can't change the information anymore. It's fixed in the notes so far. Sorry for the trouble. |
#78
|
||||
|
||||
Yeah, one an album is linked, any changes to that field don't show up anymore (though they do show up on the gallery page.) We'll have to think of a way to handle this case until the artist linking system is usable by the public.
Meanwhile, I've deleted Kawamaki and created new links to the correct artist. |
#79
|
||||
|
||||
Quote:
Also, if you guys haven't, go and try out the discography filter in the artist profile pages. I'm rather proud of it :3 |
#80
|
||||
|
||||
Uh, I screwed up again, this time in Super Famicom Magazine Vol.10.
I tried to add a tracklist, but forgot a track, but it seems after you add a tracklist, you can't add a track anymore. I tried it with adding the tracklist from scratch again, but instead of replacing the old one, I got two english ones, and since the system understand that there are only 39 tracks in Tracklist 1, it only adds 39 to the second one as well (ok, not really, the 40 tracks are shown, but the play lenght doesn't change) So I would like to request that someone delete both tracklists, so that I can add one which actually works and is somewhat correct. |
#81
|
||||
|
||||
I deleted the 39-track tracklist for you.
I noticed that, like you said, when I switched between the tracklists, the track times weren't updated. However, when I deleted the bad tracklist, the other one fixed itself. So, it looks like that, when the tracklists are switched, the only things that are updated are the track names, not the track times. This may or may not be a bug, depending on how you look at it. Just pulling the track names without changing the times should be fine, because the only thing that should switch between tracklists are the names, so any reason that the times should be updated means that there's an error in one of the tracklists. But, as FPI showed, if one tracklist is messed up, it can screw up other tracklists too. |
#82
|
||||
|
||||
Many thanks for that!
I think the best way to fix that would be to implement the possibility to add tracks in the "Edit Tracklist" menu. So far, you can add/change tracknames and the running time for each track, but if you set up the tracklist before with 39 tracks in total, you can't do anything about it anymore. At the time I noticed my mistake, it kind of surprised me, actually. On a minor note, it also shouldn't be possible to add two different tracklists for the same language, that doesn't seem to make much sense, but these are pretty minor details at the moment I would guess. The site is really coming along nicely so far. |
#83
|
||||
|
||||
Quote:
|
#84
|
|||
|
|||
Quote:
Btw, what is those crazy / that appear elsewhere. |
#85
|
||||
|
||||
Done. Though I'm not really sure where the /'s you're referring to are?
|
#86
|
||||
|
||||
isdapi: Do a manual refresh to update the CSS definitions, the slashes will disappear.
|
#87
|
||||
|
||||
Hey, everyone. I'm settled in at my new place, and am back online now, so things should be getting back to normal.
The way the tracktimes work, is that they are always taken from the default tracklist, so if the default listing is changed to a new tracklist that has no times, then they no longer display. This behaviour can seem a bit strange, and I think we ultimately want to change it to something that makes more sense. It's true that adding and deleting tracks isn't supported, but I think the easiest and cleanest way to handle that kind of edit is to delete the old tracklist and just paste in the new one. |
#88
|
||||
|
||||
Need a deletion of the misnumbered tracklist here: http://www.vgmdb.net/db/albums.php?id=5397
Went off the website tracklist, which was double-spaced, and ended up with tracks 01, 03, 05, etc. I already readded the list with proper numbers. Thanks. |
#89
|
||||
|
||||
Looks like a re-design of the tracklist submission interface and process is in order
|
#90
|
||||
|
||||
A happy accident then. Glad to (inadvertently) help.
|
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Banjo-Kazooie Beta's | ᄐv๑–X² | Album Discussions | 12 | Mar 5, 2014 08:52 AM |
I think I may have some beta/unreleased Final Fantasy XII music | qualitydisc.com | Video Game Music Discussion | 2 | Oct 2, 2013 07:41 PM |
A Note on Beta | Secret Squirrel | News and Announcements | 0 | Sep 26, 2007 07:38 PM |
Welcome to VGMdb Beta | Secret Squirrel | News and Announcements | 1 | Sep 16, 2007 07:12 PM |
VGMdb Alpha Bug Reports | Secret Squirrel | Questions and Comments | 28 | Sep 11, 2007 09:19 AM |