Log in

View Full Version : commands?


tiff
05-10-2006, 10:09 PM
anyone know a list that has the #commands converted to the DB list? I ask this because I am trying to set the status of #goto to 0 however I can not for the life of me find the command in my database it is not listed and I have no idea which one it is. any help would be very apreciated.

rojadruid
05-11-2006, 05:53 AM
anyone know a list that has the #commands converted to the DB list? I ask this because I am trying to set the status of #goto to 0 however I can not for the life of me find the command in my database it is not listed and I have no idea which one it is. any help would be very apreciated.

Wiki wiki wiki where art thou dear wiki.

http://www.eqemulator.net/wiki/wikka.php?wakka=Dev065Release

kouhei
05-11-2006, 11:45 AM
Wiki wiki wiki where art thou dear wiki.

http://www.eqemulator.net/wiki/wikka.php?wakka=Dev065Release


Here are thie winki. http://www.eqemulator.net/wiki/wikk...a=Dev065Release (http://www.eqemulator.net/wiki/wikka.php?wakka=Dev065Release)

Did you miss me.

tiff
05-11-2006, 02:39 PM
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.

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**************

tiff
05-14-2006, 04:41 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.

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.

buddywarrior
05-14-2006, 08:14 PM
I think I know what Tiff is saying.

That DBlist of ingame commands isn't accurate for me. Like #goto doesnt work .. But #size works just fine. #castspell doesnt but #gmspeed does... I think thats what he/she's getting at.


I believe the list Belfedia posted, is a list of commands that can be added to your db. .. I know in my eq/commands table, some of those are not available.

shamanistik
05-14-2006, 08:20 PM
goto work here, didn't change anything, except the Z axis maybe in some dungeons, buggy, can't move after a goto.

But in other zones or using 0 0 0 as x y z always work here

Belfedia
05-15-2006, 02:56 AM
If you miss a command in DB (you want put a status)
you can add this in DB if the command is on source.
it work if you put a status in db.

#goto working on my server.