online database editor?
Dbscript - tool for online editing any database
Can connect with any mysql servers (1 or more), and can be optimized for any game database.
Any actions is logged to one of logs, any database and column (!) have build-in right check
tables have read and write ability, supporting file based tables (CSV) , if mysql down service can work offline (check log, editing configs, using files...) .
Check this demo with username ENG and Pass ENG
Selected language - english, for russian users Login TEST,and pass TEST.
http://dj.chg.su/inside/
Program 2 years tested on Mangos server testers with good result
Actions checked and supported on Mangos database:
+View commands, and change plevel for use it.
+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
(this - only in full version, in future add it to test version)
+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
+you can view,change or remove: name,honor,kills, pet, spells, items (hard to add),
and adding spells for pet )) .
+guilds - can editing any guild and guild bank data
***Warning:you can edit DATA field character manually but it NO recommended!
...
everything you plugin with dblinker can be viewed,edited if you want.
Download
3.4.67 DBscript Full
http://dj.chg.su/data/dbscript_3.4.67_f ... --alex.rar
if you want test at home - download program and latest patch
***manually open langset.cfg select default line and replace russian to english. (ONLY if english is not default,older versions)
Requirements:Apache ,Mysql 5 or higher, Php 5, Zend optimizer
OS:Linux, Windows
any new uploads can be found here
http://www.forum.1wow.ru/showthread.php?t=6693
Ohh forgot
About program- is a tool partially 'close' code,partially free code
Demo is free, no time limit.
On Linux program work in beta mode,with minimun limitations .
Programm still developing and be better in future.
We need a testers , ...and donates
Programm originally written in native russian.Maybe in 1-3 parts you can see words in unknown language - just ignore it.
In next release i fix these bugs!
Russian thread
http://www.forum.1wow.ru/forumdisplay.php?f=50
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
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.
PS. This program can be used with any mysql database and any CSV database.
It can be free copied.
PPS. Programs does NOT execute desctructive commands and block it if possible
Example - if user with privilegies added database 'mysql' or 'information_schema' (system tables mysql,hidden by default) - this tables be ignored in service, and displaying message about illegal operation.
PPPS. Installer not exist, its only planned.
If i forgot something need for all - just reply there - i regular see this forum.