so... I am wondering if my submissions are going through. I have a model, a sound, and a sprite, and the sprite was submitted in july!

(09-29-2017, 03:15 PM)DPS2004 Wrote: so... I am wondering if my submissions are going through. I have a model, a sound, and a sprite, and the sprite was submitted in july!

https://www.vg-resource.com/thread-26810.html

Another bug:

Sometimes I have a series of pictures that belong together and are too big for a whole sheet. Therefore, I separate them into single sheets and name them like this:

Story Arc 1/11
Story Arc 2/11
Story Arc 3/11
Story Arc 4/11
Story Arc 5/11
Story Arc 6/11
Story Arc 7/11
Story Arc 8/11
Story Arc 9/11
Story Arc 10/11
Story Arc 11/11

Well, this order is what I expected. In reality, it looks like this:

Story Arc 1/11
Story Arc 10/11
Story Arc 11/11
Story Arc 2/11
Story Arc 3/11
Story Arc 4/11
Story Arc 5/11
Story Arc 6/11
Story Arc 7/11
Story Arc 8/11
Story Arc 9/11

Can this be fixed?

Unfortunately, not easily. MySQL doesn't have a simple way to do natural sorting. Our usual fix is to pad the single-digit numbers with leading 0s (so you'd have Story Arc 01/11, 02/11, etc.).

Aw, dang it. Thanks for the info, then I'll have no choice but to revise these 70 sheets of mine.

Edit: I'll try some workarounds first, not really a fan of revising so many sheets.

Edit2: The workarounds I had in mind are either useless (*10/10) or look dumb and confusing (9,5-10/10). Anyway, I just put some zeros in the icon descriptions, but only for the arcs which reach or exceed at least 10 sheets.

Thiese are action-adventures, not adventures:
https://www.spriters-resource.com/nes/legendofzelda
https://www.spriters-resource.com/nes/th...stersquest
https://www.spriters-resource.com/wonder...fuuunemaki
https://www.spriters-resource.com/pc_com...ndydesktop

This is a platformer, not an adventure:
https://www.spriters-resource.com/game_b...urce=genre

This is a beat 'em up, not an adventure:
https://www.spriters-resource.com/3ds/se...sunjustsin

Fixed all of those, thanks.

Also, in reply to the part of your deleted post referencing that natural sorting in MySQL isn't impossible, I've looked into it. Most, if not all, of the workarounds for it rely on either the length of the string being sorted or the column being entirely numeric. There isn't a way to do it consistently with an unknown data set unless MySQL actually adds in a proper natural sort option.

Thanks for looking into it, I guess the icon descriptions have to consist completely of numbers then? Oh well, I can live with the current situation (only using zero digits when a sheet series hits 10 sheets).

I think that's going to be your best bet. I've been wishing for natural sorting in MySQL for years but maybe eventually they'll add it in.

They may be like this on purpose, but the Pokémon Ranger sequels aren't supposed to have numbers in their titles (2 and 3), like they do on TSR.

I'm having a strange error when submitting a specific zip file for a newly submitted game that it says that the game I'm submitting for has been rejected. But I looked at the page and the game is still there and lets me submit other files. Also if it was rejected I would have a PM in my inbox, which I don't, I tried resubmitting the file several times but that error kept coming up. It only seems to affect that one specific file from what I've tested so far. File size may be the issue as the file is 301 MB, due to one character having 1297 voice lines. I have no idea why this error is happening, I've been working very hard on this game and don't want all my hard work to go to waste. If you have any information on why this is happening please post in the comments or PM me.

If you need the game I'm posting for it's God Eater Resurrection, which I just submitted like an hour ago. It'd be very strange for a game to be rejected in less than an hour, let alone a Bandai Namco title that people actually know about.

I think I probably messed up an error check in there somewhere. The issue is definitely file size - it can’t be larger than 250 MB. What’s likely happening is that the script is ending with the first error it finds because the server is rejecting the oversized file. Just break it into two parts and you should be fine.

Thanks, that's nice to know. I could also convert the files, but I think it's best if they are kept in a .wav format, but .wav files take up a solid chunk of space. Thanks for letting me know what the issue was, and what the limit is. It's very important to know this, because I may be submitting other huge files in the future.

(10-17-2017, 07:25 AM)Warechu Wrote: Thanks, that's nice to know. I could also convert the files, but I think it's best if they are kept in a .wav format, but .wav files take up a solid chunk of space. Thanks for letting me know what the issue was, and what the limit is. It's very important to know this, because I may be submitting other huge files in the future.

If the files are normally OGG or MP3, then you can leave it like that (no sense in converting, they'd just take up more space and almost every program supports both nowadays), but if they're not, then WAV's the way to go.

I took a look at the code and I think I found a more graceful way of handling an uploaded file being larger than the max size. I just tested it and it seems to work so you should no longer incorrectly get a message stating the game you’re submitting to was rejected when uploading an oversize file.