|
|
|
 |
|
|
 |
|
 |
 |
|
 |
 |
|
 |
|
| Support::General Support Post all topics here having to do with errors while trying to connect to an EQEMu server but not about the setup/running of the Server itself. |
04-19-2006, 10:12 PM
|
|
Hill Giant
|
|
Join Date: Jul 2004
Posts: 196
|
|
Thank You Befeldia, i was thinking to do it, the problem is that i must to do a complete list of eqemu commands on SQL queries and it takes a little time, but i think that i ll do a program that make it for me taking old commads file and giving out a sql file with all queries for insert commands on DB.
|
 |
|
 |
04-19-2006, 10:51 PM
|
|
Hill Giant
|
|
Join Date: Jul 2004
Posts: 196
|
|
these are the query needed if anybody want use it...i have used standar values on old addon.ini, if u want use it for lock u server and need all status commands to 200 like i am going to do, u can use:
UPDATE commands set access=200;
Code:
INSERT INTO commands(command,access) VALUES ('setaaxp',100)
INSERT INTO commands(command,access) VALUES ('setaapts',100)
INSERT INTO commands(command,access) VALUES ('level',10)
INSERT INTO commands(command,access) VALUES ('damage',100)
INSERT INTO commands(command,access) VALUES ('heal',10)
INSERT INTO commands(command,access) VALUES ('npcspecialattk',100)
INSERT INTO commands(command,access) VALUES ('kill',100)
INSERT INTO commands(command,access) VALUES ('timeofday',80)
INSERT INTO commands(command,access) VALUES ('date',80)
INSERT INTO commands(command,access) VALUES ('haste',100)
INSERT INTO commands(command,access) VALUES ('weather',80)
INSERT INTO commands(command,access) VALUES ('shutdown',200)
INSERT INTO commands(command,access) VALUES ('setxp',100)
INSERT INTO commands(command,access) VALUES ('summonitem',0)
INSERT INTO commands(command,access) VALUES ('itemsearch',0)
INSERT INTO commands(command,access) VALUES ('finditem',0)
INSERT INTO commands(command,access) VALUES ('search',0)
INSERT INTO commands(command,access) VALUES ('spawn',10)
INSERT INTO commands(command,access) VALUES ('delacct',200)
INSERT INTO commands(command,access) VALUES ('size',80)
INSERT INTO commands(command,access) VALUES ('worldshutdown',200)
INSERT INTO commands(command,access) VALUES ('chat',200)
INSERT INTO commands(command,access) VALUES ('appearance',150)
INSERT INTO commands(command,access) VALUES ('zoneshutdown',150)
INSERT INTO commands(command,access) VALUES ('zonebootup',150)
INSERT INTO commands(command,access) VALUES ('emote',80)
INSERT INTO commands(command,access) VALUES ('summon',100)
INSERT INTO commands(command,access) VALUES ('kick',150)
INSERT INTO commands(command,access) VALUES ('mana',10)
INSERT INTO commands(command,access) VALUES ('npcloot',80)
INSERT INTO commands(command,access) VALUES ('findspell',20)
INSERT INTO commands(command,access) VALUES ('spfind',20)
INSERT INTO commands(command,access) VALUES ('castspell',20)
INSERT INTO commands(command,access) VALUES ('cast',20)
INSERT INTO commands(command,access) VALUES ('invul',80)
INSERT INTO commands(command,access) VALUES ('invulnerable',80)
INSERT INTO commands(command,access) VALUES ('setskill',20)
INSERT INTO commands(command,access) VALUES ('setskillall',20)
INSERT INTO commands(command,access) VALUES ('setallskill',20)
INSERT INTO commands(command,access) VALUES ('save',100)
INSERT INTO commands(command,access) VALUES ('depop',100)
INSERT INTO commands(command,access) VALUES ('depopcorpses',100)
INSERT INTO commands(command,access) VALUES ('depopzone',100)
INSERT INTO commands(command,access) VALUES ('repop',100)
INSERT INTO commands(command,access) VALUES ('spawnstatus',100)
INSERT INTO commands(command,access) VALUES ('listnpcs',100)
INSERT INTO commands(command,access) VALUES ('listnpccorpses',100)
INSERT INTO commands(command,access) VALUES ('listplayercorpses',100)
INSERT INTO commands(command,access) VALUES ('deletenpccorpses',100)
INSERT INTO commands(command,access) VALUES ('deleteplayercorpses',150)
INSERT INTO commands(command,access) VALUES ('showbuffs',100)
INSERT INTO commands(command,access) VALUES ('nukebuffs',100)
INSERT INTO commands(command,access) VALUES ('hideme',80)
INSERT INTO commands(command,access) VALUES ('deletecorpse',150)
INSERT INTO commands(command,access) VALUES ('sendzonespawns',200)
INSERT INTO commands(command,access) VALUES ('flymode',20)
INSERT INTO commands(command,access) VALUES ('race',20)
INSERT INTO commands(command,access) VALUES ('texture',10)
INSERT INTO commands(command,access) VALUES ('gender',10)
INSERT INTO commands(command,access) VALUES ('zheader',80)
INSERT INTO commands(command,access) VALUES ('zsky',80)
INSERT INTO commands(command,access) VALUES ('zcolor',80)
INSERT INTO commands(command,access) VALUES ('zcolour',80)
INSERT INTO commands(command,access) VALUES ('zuwcoords',100)
INSERT INTO commands(command,access) VALUES ('zsafecoords',100)
INSERT INTO commands(command,access) VALUES ('zclip',80)
INSERT INTO commands(command,access) VALUES ('zsave',200)
INSERT INTO commands(command,access) VALUES ('npccast',80)
INSERT INTO commands(command,access) VALUES ('dbspawn2',200)
INSERT INTO commands(command,access) VALUES ('npctypespawn',10)
INSERT INTO commands(command,access) VALUES ('attack',150)
INSERT INTO commands(command,access) VALUES ('zstats',80)
INSERT INTO commands(command,access) VALUES ('lock',150)
INSERT INTO commands(command,access) VALUES ('unlock',150)
INSERT INTO commands(command,access) VALUES ('motd',150)
INSERT INTO commands(command,access) VALUES ('makepet',20)
INSERT INTO commands(command,access) VALUES ('crashtest',201)
INSERT INTO commands(command,access) VALUES ('showpetspell',250)
INSERT INTO commands(command,access) VALUES ('freeze',100)
INSERT INTO commands(command,access) VALUES ('unfreeze',100)
INSERT INTO commands(command,access) VALUES ('pvp',100)
INSERT INTO commands(command,access) VALUES ('permaclass',80)
INSERT INTO commands(command,access) VALUES ('permarace',80)
INSERT INTO commands(command,access) VALUES ('permagender',80)
INSERT INTO commands(command,access) VALUES ('gm',100)
INSERT INTO commands(command,access) VALUES ('gmspeed',100)
INSERT INTO commands(command,access) VALUES ('movechar',100)
INSERT INTO commands(command,access) VALUES ('title',100)
INSERT INTO commands(command,access) VALUES ('copychar',200)
INSERT INTO commands(command,access) VALUES ('serverinfo',201)
INSERT INTO commands(command,access) VALUES ('npcstats',80)
INSERT INTO commands(command,access) VALUES ('memspell',100)
INSERT INTO commands(command,access) VALUES ('zone',10)
Last edited by Arex; 04-20-2006 at 06:53 AM..
|
 |
|
 |
|
|
|
04-20-2006, 05:36 AM
|
|
Hill Giant
|
|
Join Date: Jul 2004
Posts: 196
|
|
i forget to add ; at end of each line, this is the code that works perfectly...
Code:
INSERT INTO commands(command,access) VALUES ('setaaxp',100);
INSERT INTO commands(command,access) VALUES ('setaapts',100);
INSERT INTO commands(command,access) VALUES ('level',10);
INSERT INTO commands(command,access) VALUES ('damage',100);
INSERT INTO commands(command,access) VALUES ('heal',10);
INSERT INTO commands(command,access) VALUES ('npcspecialattk',100);
INSERT INTO commands(command,access) VALUES ('kill',100);
INSERT INTO commands(command,access) VALUES ('timeofday',80);
INSERT INTO commands(command,access) VALUES ('date',80);
INSERT INTO commands(command,access) VALUES ('haste',100);
INSERT INTO commands(command,access) VALUES ('weather',80);
INSERT INTO commands(command,access) VALUES ('shutdown',200);
INSERT INTO commands(command,access) VALUES ('setxp',100);
INSERT INTO commands(command,access) VALUES ('summonitem',0);
INSERT INTO commands(command,access) VALUES ('itemsearch',0);
INSERT INTO commands(command,access) VALUES ('finditem',0);
INSERT INTO commands(command,access) VALUES ('search',0);
INSERT INTO commands(command,access) VALUES ('spawn',10);
INSERT INTO commands(command,access) VALUES ('delacct',200);
INSERT INTO commands(command,access) VALUES ('size',80);
INSERT INTO commands(command,access) VALUES ('worldshutdown',200);
INSERT INTO commands(command,access) VALUES ('chat',200);
INSERT INTO commands(command,access) VALUES ('appearance',150);
INSERT INTO commands(command,access) VALUES ('zoneshutdown',150);
INSERT INTO commands(command,access) VALUES ('zonebootup',150);
INSERT INTO commands(command,access) VALUES ('emote',80);
INSERT INTO commands(command,access) VALUES ('summon',100);
INSERT INTO commands(command,access) VALUES ('kick',150);
INSERT INTO commands(command,access) VALUES ('mana',10);
INSERT INTO commands(command,access) VALUES ('npcloot',80);
INSERT INTO commands(command,access) VALUES ('findspell',20);
INSERT INTO commands(command,access) VALUES ('spfind',20);
INSERT INTO commands(command,access) VALUES ('castspell',20);
INSERT INTO commands(command,access) VALUES ('cast',20);
INSERT INTO commands(command,access) VALUES ('invul',80);
INSERT INTO commands(command,access) VALUES ('invulnerable',80);
INSERT INTO commands(command,access) VALUES ('setskill',20);
INSERT INTO commands(command,access) VALUES ('setskillall',20);
INSERT INTO commands(command,access) VALUES ('setallskill',20);
INSERT INTO commands(command,access) VALUES ('save',100);
INSERT INTO commands(command,access) VALUES ('depop',100);
INSERT INTO commands(command,access) VALUES ('depopcorpses',100);
INSERT INTO commands(command,access) VALUES ('depopzone',100);
INSERT INTO commands(command,access) VALUES ('repop',100);
INSERT INTO commands(command,access) VALUES ('spawnstatus',100);
INSERT INTO commands(command,access) VALUES ('listnpcs',100);
INSERT INTO commands(command,access) VALUES ('listnpccorpses',100);
INSERT INTO commands(command,access) VALUES ('listplayercorpses',100);
INSERT INTO commands(command,access) VALUES ('deletenpccorpses',100);
INSERT INTO commands(command,access) VALUES ('deleteplayercorpses',150);
INSERT INTO commands(command,access) VALUES ('showbuffs',100);
INSERT INTO commands(command,access) VALUES ('nukebuffs',100);
INSERT INTO commands(command,access) VALUES ('hideme',80);
INSERT INTO commands(command,access) VALUES ('deletecorpse',150);
INSERT INTO commands(command,access) VALUES ('sendzonespawns',200);
INSERT INTO commands(command,access) VALUES ('flymode',20);
INSERT INTO commands(command,access) VALUES ('race',20);
INSERT INTO commands(command,access) VALUES ('texture',10);
INSERT INTO commands(command,access) VALUES ('gender',10);
INSERT INTO commands(command,access) VALUES ('zheader',80);
INSERT INTO commands(command,access) VALUES ('zsky',80);
INSERT INTO commands(command,access) VALUES ('zcolor',80);
INSERT INTO commands(command,access) VALUES ('zcolour',80);
INSERT INTO commands(command,access) VALUES ('zuwcoords',100);
INSERT INTO commands(command,access) VALUES ('zsafecoords',100);
INSERT INTO commands(command,access) VALUES ('zclip',80);
INSERT INTO commands(command,access) VALUES ('zsave',200);
INSERT INTO commands(command,access) VALUES ('npccast',80);
INSERT INTO commands(command,access) VALUES ('dbspawn2',200);
INSERT INTO commands(command,access) VALUES ('npctypespawn',10);
INSERT INTO commands(command,access) VALUES ('attack',150);
INSERT INTO commands(command,access) VALUES ('zstats',80);
INSERT INTO commands(command,access) VALUES ('lock',150);
INSERT INTO commands(command,access) VALUES ('unlock',150);
INSERT INTO commands(command,access) VALUES ('motd',150);
INSERT INTO commands(command,access) VALUES ('makepet',20);
INSERT INTO commands(command,access) VALUES ('crashtest',201)
INSERT INTO commands(command,access) VALUES ('showpetspell',250);
INSERT INTO commands(command,access) VALUES ('freeze',100);
INSERT INTO commands(command,access) VALUES ('unfreeze',100);
INSERT INTO commands(command,access) VALUES ('pvp',100);
INSERT INTO commands(command,access) VALUES ('permaclass',80);
INSERT INTO commands(command,access) VALUES ('permarace',80);
INSERT INTO commands(command,access) VALUES ('permagender',80);
INSERT INTO commands(command,access) VALUES ('gm',100);
INSERT INTO commands(command,access) VALUES ('gmspeed',100);
INSERT INTO commands(command,access) VALUES ('movechar',100);
INSERT INTO commands(command,access) VALUES ('title',100);
INSERT INTO commands(command,access) VALUES ('copychar',200);
INSERT INTO commands(command,access) VALUES ('serverinfo',201);
INSERT INTO commands(command,access) VALUES ('npcstats',80);
INSERT INTO commands(command,access) VALUES ('memspell',100);
INSERT INTO commands(command,access) VALUES ('zone',10);
|
|
|
|
Posting Rules
|
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
HTML code is Off
|
|
|
All times are GMT -4. The time now is 10:58 PM.
|
|
 |
|
 |
|
|
|
 |
|
 |
|
 |
Hybrid Mode
