I ended up putting in 2 databases, keeping one I knew worked for one version and then making the "newest" mangos point to the next one....fairly easy just change the name of the mangos DB in the mangos.conf to point where ever you want. Like the next database you have (for the next version of mangos) just name it mangosBC or something. I named mine mangos3522 or what ever version of mangos core I was messing with. The realm DB doesn't change much, although there was a fix and you had to enable BC in the table once.
I don't think I have a complete list of GM commands but I'll look for one. I also have a text file that tells what parts of the database to export to keep chars when you update the entire DB and then you pull in the char data again.
The stuff that I have that doesn't show right on gmisland are the new things from 2.1 of WoW, I think we both are running 2.0.12. My gmisland is actually pretty fair and seems good. I have Rev 4 of the silvermoon DB, is that what you have?
Regarding the program to view/add for the DB, all I've ever used was sqlyog program. Did you create accounts using that or a web page? that sqlyog works to log on the database, shows the realm, mangos, etc. and you can edit, backup, change, all parts of it. If you used it to make accts, then you have seen the best that I know of right now if not, connect using sqlyog and then in the bottom right window, click on table data (#3 i think) then click show all. In the right pane, click and expand mangos and browse through there. Like the creatures are in creature_template (i think - working from memory
) items in items_template. I think that is what you are looking for, if I understand anyway.
There seems to be new compiled versions of mangos quite frequently but they often require something to be change in the database. The most recent one I tried, a column had to be named "guid" instead of "entry", or something like that.....I decided to wait a bit before I jump to another mangos version, maybe when they release silvermoon DB 5 or something. Different people compile them and add something all the time but I have found you have to keep up on the posts most of the time b/c something changes... ah well.
One of the newest mangos cores says it will run 2.0.12 to 2.1 but I haven't tried it at all. I think for now I'm sticking to 2.0.12. It usually means a lot of work for me at home to update and if it doesn't work, a nasty re-install.
One more thing on the multiple WoW's on a pc....in order to patch after you remane a folder, all you have to do is run the patch from inside the directory. Patches look for the default install folder and if it's not there, you get an error, but running from whatever wow folder you want updated, it will work fine.