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);