Database sorter?

[Solid Grayser: Paint Eater]

So um. My database has somewhat been a mess in Rpgm. is there a way to quickly organize the inventory so i can keep track of stuff?
I have events sorted by item ID, So its realistically unreasonable for me to re sort everything by hand.

Sorry if it sounds confusing. TLDR:
Say I have a broadsword of iron as weapon ID 34, and I want to move both it as well as all events relating to weapon id 34 to "55".

[kittylitterproduction]

Unrealistic. Would break every other part of the game.

[Caethyril]

I don't know of a way to sort database items either. You might be able to sort how they are displayed in-game, though. I found this plugin that apparently shows the inventory in alphabetical order, if that's of interest: https://forums.rpgmakerweb.com/index.php?threads/msx-alphabetical-sort.73991/

All events will refer to database entries by their ID, unless you use some plugin that bases things on names instead. This one looks like it may help with that: http://rmrk.net/index.php?topic=50819.0

Otherwise...I've re-sorted a database manually before: I found going through my game and noting down every place where items were added/removed/checked before actually changing the database order helped a lot. It still took a while, though. (Never. Again.)

You weren't to know, but even if you've planned out all your skills/items/etc in advance, it's generally good practice (for this reason) to leave a few blank slots in each database list. So, for example, before starting set aside maybe 10 slots per weapon type, maybe 20 slots right at the top of the list for uniques, etc. It helps to have an idea of how big your game's going to be, but you get the idea.

Same thing goes for other aspects, like if you have a variable tracking your progress through a quest. Increment the variable by 5 or 10 or something for each step, not just 1. That way, if you get a good idea later on for some extra stuff to add in part way through, it's as easy as filling in the gaps! =)

[Solid Grayser: Paint Eater]

Appreciate the help.
Funnily enough, I did try to plan ahead and add 10 or so gaps between weapons but then I added more and more to my game and now everything's a mess. Same with skills and whatnot. I suppose I'll just be more careful next time.

[Iguana Guy]

Would love it if that could be done as well, but as stated, it would mess up a game project pretty bad if everything was moved around by an auto sort program. At least it doesn't affect the game in any way having items/weapons scattered in the database.

[Slim Jimmy]

Actually, if you look into databases of professional RPGs, their data's kind of a mess too, with lots of unused stuff, whole blocks entirely blank records meant for tentative entries, and tables that don't exactly sequence the way it looks like in the finished game (so far I've only peered into the Fallout, Arcanum, Elder Scrolls, and Baldur's Gate series but the patterns are pretty consistent). I would advice remaking the database when you start developing a "gold" version if it bothers you that much.

[JohnDoeNews]

What you might do is not wanting to sort them by type, or name, but by lvl. I assume you start with the first scenes and build up to the end, so I also asume you make weapons in order of low level to high.

What you should do, if you ever start a new project with the same database, is sort them before you even start making events. That is what I did. I made like 20 or more projects I never finished, but the database was many times re-used.

Now I have all recourses first, then all ingredients, then all food, then poitions etc, and that won't ever change again. So I all quest items, collectibles and unique items can just be added on the bottom.