Now i present new version dbscript 4.2.4
http://filebeam.com/f6b79c2f34f271f980ad2e81945e0207
managing DB , (any changes to db) including patches and dumps
can crosslinking tables
allow GM right to edit some selected data
can be used GMs (not knowing SQL or another language) for simple fixes
allow managing Files and sharing on server
have serverstatus (online , offline , world, realmd, db, ftp ...etc)
Official site- dj.chg.su/dbscript
Video (how to install)
http://code.google.com/p/db-script/downloads/detail?name=dbscript%204.2.4%20full.zip&can=2&q=
http://code.google.com/p/db-script/downloads/detail?name=dbscript_4_install.ogv&can=2&q=
SVN (outdated)
http://code.google.com/p/db-script/source/checkout
Please tell me what components using your Linux, and version OS?
Apache, Php, Mysql , Zend optimizer?
Actions checked and supported on database:
+View commands, and change plevel for use it.
+Programm use aliases, not direct connect to tables (you can select only needed tables), and
program automatically fix some inside settings with every Mangos update
+Editing teleporting spells (change coords)
+editing creatures spawns,creatures, it loot
+editing gameobjects spawns, loot
+editing items and any loot type tables
+editing quests,quest-related items,creatures,go (but Quice still do it better)
+editing accounts and bans
+editing any NPC, vendor inventory, trainer spellbook
+dbc can be viewed if it saved as csv (!)
+direct executing sql queries with logs of course
+changing SQL, and DAT headers, it structure
+dblinker for automatic creating connection list can be used in service
+characters (simple version) can be edited any no in'data' fields (mass change works with DATA and separator 'space')
+you can view,change or remove: level,class,race,money,name,honor,kills, pet, spells, items (hard to add),.....
and adding spells for pet )) .
+guilds - can editing any guild and guild bank data
...
everything you plugin with dblinker can be viewed,edited if you want.
Multiinstancing programm
If you want use program for 10 servers and with one userset,or other config just place all copies in one folder , and enable multi-instance in every copy
If you planning create multiinstance after install: (not recommened)
Next you must remove inside _conf files of program to outside _conf folder.
Outside _conf files have higher priority, and applied by all program copies
Inside _conf work only with one copy program.