Belfedia
05-12-2006, 06:56 AM
Tiff search this :
INSERT INTO `commands` VALUES ('setaaxp', 200);
INSERT INTO `commands` VALUES ('setaapts', 200);
INSERT INTO `commands` VALUES ('level', 200);
INSERT INTO `commands` VALUES ('damage', 200);
INSERT INTO `commands` VALUES ('heal', 200);
INSERT INTO `commands` VALUES ('npcspecialattk', 200);
INSERT INTO `commands` VALUES ('kill', 200);
INSERT INTO `commands` VALUES ('timeofday', 200);
INSERT INTO `commands` VALUES ('date', 200);
INSERT INTO `commands` VALUES ('haste', 200);
INSERT INTO `commands` VALUES ('weather', 100);
INSERT INTO `commands` VALUES ('shutdown', 200);
INSERT INTO `commands` VALUES ('setxp', 200);
INSERT INTO `commands` VALUES ('summonitem', 200);
INSERT INTO `commands` VALUES ('itemsearch', 200);
INSERT INTO `commands` VALUES ('finditem', 200);
INSERT INTO `commands` VALUES ('search', 200);
INSERT INTO `commands` VALUES ('spawn', 200);
INSERT INTO `commands` VALUES ('delacct', 200);
INSERT INTO `commands` VALUES ('size', 200);
INSERT INTO `commands` VALUES ('worldshutdown', 200);
INSERT INTO `commands` VALUES ('chat', 200);
INSERT INTO `commands` VALUES ('appearance', 200);
INSERT INTO `commands` VALUES ('zoneshutdown', 200);
INSERT INTO `commands` VALUES ('zonebootup', 200);
INSERT INTO `commands` VALUES ('emote', 200);
INSERT INTO `commands` VALUES ('summon', 200);
INSERT INTO `commands` VALUES ('kick', 200);
INSERT INTO `commands` VALUES ('mana', 200);
INSERT INTO `commands` VALUES ('npcloot', 200);
INSERT INTO `commands` VALUES ('findspell', 200);
INSERT INTO `commands` VALUES ('spfind', 200);
INSERT INTO `commands` VALUES ('castspell', 200);
INSERT INTO `commands` VALUES ('cast', 200);
INSERT INTO `commands` VALUES ('invul', 200);
INSERT INTO `commands` VALUES ('invulnerable', 200);
INSERT INTO `commands` VALUES ('setskill', 200);
INSERT INTO `commands` VALUES ('setskillall', 200);
INSERT INTO `commands` VALUES ('setallskill', 200);
INSERT INTO `commands` VALUES ('save', 0);
INSERT INTO `commands` VALUES ('depop', 200);
INSERT INTO `commands` VALUES ('depopcorpses', 200);
INSERT INTO `commands` VALUES ('depopzone', 200);
INSERT INTO `commands` VALUES ('repop', 150);
INSERT INTO `commands` VALUES ('spawnstatus', 200);
INSERT INTO `commands` VALUES ('listnpcs', 200);
INSERT INTO `commands` VALUES ('listnpccorpses', 200);
INSERT INTO `commands` VALUES ('listplayercorpses', 200);
INSERT INTO `commands` VALUES ('deletenpccorpses', 200);
INSERT INTO `commands` VALUES ('deleteplayercorpses', 200);
INSERT INTO `commands` VALUES ('showbuffs', 200);
INSERT INTO `commands` VALUES ('nukebuffs', 200);
INSERT INTO `commands` VALUES ('hideme', 200);
INSERT INTO `commands` VALUES ('deletecorpse', 200);
INSERT INTO `commands` VALUES ('sendzonespawns', 200);
INSERT INTO `commands` VALUES ('flymode', 100);
INSERT INTO `commands` VALUES ('race', 200);
INSERT INTO `commands` VALUES ('texture', 200);
INSERT INTO `commands` VALUES ('gender', 200);
INSERT INTO `commands` VALUES ('zheader', 200);
INSERT INTO `commands` VALUES ('zsky', 200);
INSERT INTO `commands` VALUES ('zcolor', 200);
INSERT INTO `commands` VALUES ('zcolour', 200);
INSERT INTO `commands` VALUES ('zuwcoords', 200);
INSERT INTO `commands` VALUES ('zsafecoords', 200);
INSERT INTO `commands` VALUES ('zclip', 200);
INSERT INTO `commands` VALUES ('zsave', 200);
INSERT INTO `commands` VALUES ('npccast', 200);
INSERT INTO `commands` VALUES ('dbspawn2', 200);
INSERT INTO `commands` VALUES ('npctypespawn', 200);
INSERT INTO `commands` VALUES ('attack', 200);
INSERT INTO `commands` VALUES ('zstats', 200);
INSERT INTO `commands` VALUES ('lock', 200);
INSERT INTO `commands` VALUES ('unlock', 200);
INSERT INTO `commands` VALUES ('motd', 200);
INSERT INTO `commands` VALUES ('makepet', 200);
INSERT INTO `commands` VALUES ('crashtest', 200);
INSERT INTO `commands` VALUES ('showpetspell', 200);
INSERT INTO `commands` VALUES ('freeze', 200);
INSERT INTO `commands` VALUES ('unfreeze', 200);
INSERT INTO `commands` VALUES ('pvp', 200);
INSERT INTO `commands` VALUES ('permaclass', 200);
INSERT INTO `commands` VALUES ('permarace', 200);
INSERT INTO `commands` VALUES ('permagender', 200);
INSERT INTO `commands` VALUES ('gm', 200);
INSERT INTO `commands` VALUES ('gmspeed', 10);
INSERT INTO `commands` VALUES ('movechar', 100);
INSERT INTO `commands` VALUES ('title', 200);
INSERT INTO `commands` VALUES ('copychar', 200);
INSERT INTO `commands` VALUES ('serverinfo', 200);
INSERT INTO `commands` VALUES ('npcstats', 200);
INSERT INTO `commands` VALUES ('memspell', 200);
INSERT INTO `commands` VALUES ('zone', 100);
INSERT INTO `commands` VALUES ('goto', 100);
INSERT INTO `commands` VALUES ('flag', 200);
INSERT INTO `commands` VALUES ('guild', 200);
INSERT INTO `commands` VALUES ('guilds', 200);
INSERT INTO `commands` VALUES ('ginfo', 200);
INSERT INTO `commands` VALUES ('manaburn', 200);
INSERT INTO `commands` VALUES ('serversidename', 200);
INSERT INTO `commands` VALUES ('spellinfo', 200);
INSERT INTO `commands` VALUES ('uptime', 200);
INSERT INTO `commands` VALUES ('doanim', 200);
INSERT INTO `commands` VALUES ('equipitem', 200);
INSERT INTO `commands` VALUES ('delpetition', 200);
INSERT INTO `commands` VALUES ('findnpctype', 200);
INSERT INTO `commands` VALUES ('fixmob', 200);
INSERT INTO `commands` VALUES ('gassign', 200);
INSERT INTO `commands` VALUES ('interrupt', 200);
INSERT INTO `commands` VALUES ('iteminfo', 200);
INSERT INTO `commands` VALUES ('lastname', 200);
INSERT INTO `commands` VALUES ('listpetition', 200);
INSERT INTO `commands` VALUES ('log', 200);
INSERT INTO `commands` VALUES ('los', 200);
INSERT INTO `commands` VALUES ('manastat', 200);
INSERT INTO `commands` VALUES ('ai', 200);
INSERT INTO `commands` VALUES ('npcedit', 200);
INSERT INTO `commands` VALUES ('peekinv', 200);
INSERT INTO `commands` VALUES ('petitioninfo', 200);
INSERT INTO `commands` VALUES ('setitemstatus', 200);
INSERT INTO `commands` VALUES ('setlanguage', 200);
INSERT INTO `commands` VALUES ('showskills', 200);
INSERT INTO `commands` VALUES ('showstats', 200);
INSERT INTO `commands` VALUES ('spon', 200);
INSERT INTO `commands` VALUES ('spoff', 200);
INSERT INTO `commands` VALUES ('stun', 200);
INSERT INTO `commands` VALUES ('synctod', 200);
INSERT INTO `commands` VALUES ('time', 200);
INSERT INTO `commands` VALUES ('timezone', 200);
INSERT INTO `commands` VALUES ('viewmessage', 200);
INSERT INTO `commands` VALUES ('viewmessages', 200);
INSERT INTO `commands` VALUES ('viewnpctype', 200);
INSERT INTO `commands` VALUES ('viewpetition', 200);
INSERT INTO `commands` VALUES ('zonelock', 200);
INSERT INTO `commands` VALUES ('zunderworld', 200);
INSERT INTO `commands` VALUES ('corpse', 200);
INSERT INTO `commands` VALUES ('fov', 200);
INSERT INTO `commands` VALUES ('spawnfix', 150);
INSERT INTO `commands` VALUES ('scribespells', 200);
INSERT INTO `commands` VALUES ('zonestatus', 200);
INSERT INTO `commands` VALUES ('setpass', 200);
INSERT INTO `commands` VALUES ('setadventurepoints', 200);
INSERT INTO `commands` VALUES ('reloadzps', 200);
INSERT INTO `commands` VALUES ('reloadzonepoints', 200);
INSERT INTO `commands` VALUES ('reloadquest', 200);
INSERT INTO `commands` VALUES ('reloadqst', 200);
INSERT INTO `commands` VALUES ('reloadpl', 200);
INSERT INTO `commands` VALUES ('qglobal', 200);
INSERT INTO `commands` VALUES ('nukeitem', 200);
INSERT INTO `commands` VALUES ('npcshout', 200);
INSERT INTO `commands` VALUES ('npcsay', 200);
INSERT INTO `commands` VALUES ('npcemote', 200);
INSERT INTO `commands` VALUES ('name', 200);
INSERT INTO `commands` VALUES ('charbackup', 200);
INSERT INTO `commands` VALUES ('aggro', 200);
INSERT INTO `commands` VALUES ('ban', 200);
This from my server and you need to change status (200).
rojadruid
05-12-2006, 07:32 AM
wow not only did that not answer my question, the second post's link is broken. Thank you try your flame again later, oh and search is not a button I haven't used.
If you had read the link you would have found that #5 in the below is what you where looking for.
************Cut and paste from the above link**************
World HTTP things which work:
Lock/Unlock world.
View connected zones, launchers, and players.
Configure launcher.
Start and stop zones under launcher control.
Edit command access levels.
View list of guilds.
View accounts, with characters and some info.
Change an account's status.
************Cut and paste from the above link**************
johane
05-14-2006, 05:44 PM
you missunder stood my question completly i know how to change command accsess lvls, however my question was what is the data base equivalent for #goto, because the data base list of commands is diffrent from the ingame #name of it. like #finditems is search in the data base commands list.
OK, so you are looking for a set of SQL statements that will implement the same functions as the various '#' commands do in game, such as a set of SQL that will move a PC to a new location etc?
Perhaps you could look inside the source for the server and see the SQL that is used there. My personal opinion is that you'll want to be very careful not to bork your database though.
vBulletin® v3.8.11, Copyright ©2000-2025, vBulletin Solutions Inc.