• This is a read only backup of the old Emudevs forum. If you want to have anything removed, please message me on Discord: KittyKaev

[SOLVED] Sql query Racial swap

Status
Not open for further replies.
B

Bigchocolate

Emulation Addict
So I just wrote this and turned out it didn't work, which the flag for the action is correct, had no issues running the query maybe its the revision of eluna I have but anyways, I was trying to build a racial swap npc with a gold price, also I cant figure out how to have a "learn spell" function in SAI since trinity doesn't have a definition for it, anyways if someone could point me in the right direction that would be greatly appreciated.


-- GOSSIP MENUS


INSERT INTO `gossip_menu_option` VALUES (56100, 1, 0, 'Horde Racials', 0, 1, 1, 56102, 0, 0, 0, 'Are you sure?', 0);
INSERT INTO `gossip_menu_option` VALUES (56100, 0, 0, 'Alliance Racials', 0, 1, 1, 56101, 0, 0, 0, 'Are you sure?', 0);
INSERT INTO `gossip_menu_option` VALUES (56101, 0, 0, 'Human', 0, 1, 1, 0, 0, 0, 1000000, 'Are you sure?', 0);
INSERT INTO `gossip_menu_option` VALUES (56101, 1, 0, 'Dwarf', 0, 1, 1, 0, 0, 0, 1000000, 'Are you sure?', 0);
INSERT INTO `gossip_menu_option` VALUES (56101, 2, 0, 'Night Elf', 0, 1, 1, 0, 0, 0, 1000000, 'Are you sure?', 0);
INSERT INTO `gossip_menu_option` VALUES (56101, 3, 0, 'Gnome', 0, 1, 1, 0, 0, 0, 1000000, 'Are you sure?', 0);
INSERT INTO `gossip_menu_option` VALUES (56101, 4, 0, 'Draenei', 0, 1, 1, 0, 0, 0, 1000000, 'Are you sure?', 0);
INSERT INTO `gossip_menu_option` VALUES (56102, 0, 0, 'Orc', 0, 1, 1, 0, 0, 0, 1000000, 'Are you sure?', 0);
INSERT INTO `gossip_menu_option` VALUES (56102, 1, 0, 'Troll', 0, 1, 1, 0, 0, 0, 1000000, 'Are you sure?', 0);
INSERT INTO `gossip_menu_option` VALUES (56102, 2, 0, 'Tauren', 0, 1, 1, 0, 0, 0, 1000000, 'Are you sure?', 0);
INSERT INTO `gossip_menu_option` VALUES (56102, 3, 0, 'Undead', 0, 1, 1, 0, 0, 0, 1000000, 'Are you sure?', 0);
INSERT INTO `gossip_menu_option` VALUES (56102, 4, 0, 'Blood Elf', 0, 1, 1, 0, 0, 0, 1000000, 'Are you sure?', 0);




-- ALLIANCE

-- HUMAN REMOVE SCRIPTS

INSERT INTO `smart_scripts` VALUES (65000, 0, 0, 0, 62, 0, 100, 0, 56101, 0, 0, 0, 28, 58984, 0, 0, 0, 0, 0, 7, 0, 0, 0, 0, 0, 0, 0, 'HUMAN REMOVE SMARTAI');
INSERT INTO `smart_scripts` VALUES (65000, 0, 1, 0, 62, 0, 100, 0, 56101, 0, 0, 0, 28, 20589, 0, 0, 0, 0, 0, 7, 0, 0, 0, 0, 0, 0, 0, 'HUMAN REMOVE SMARTAI');
INSERT INTO `smart_scripts` VALUES (65000, 0, 2, 0, 62, 0, 100, 0, 56101, 0, 0, 0, 28, 20594, 0, 0, 0, 0, 0, 7, 0, 0, 0, 0, 0, 0, 0, 'HUMAN REMOVE SMARTAI');
INSERT INTO `smart_scripts` VALUES (65000, 0, 3, 0, 62, 0, 100, 0, 56101, 0, 0, 0, 28, 28880, 0, 0, 0, 0, 0, 7, 0, 0, 0, 0, 0, 0, 0, 'HUMAN REMOVE SMARTAI');
INSERT INTO `smart_scripts` VALUES (65000, 0, 4, 0, 62, 0, 100, 0, 56101, 0, 0, 0, 28, 33697, 0, 0, 0, 0, 0, 7, 0, 0, 0, 0, 0, 0, 0, 'HUMAN REMOVE SMARTAI');
INSERT INTO `smart_scripts` VALUES (65000, 0, 5, 0, 62, 0, 100, 0, 56101, 0, 0, 0, 28, 26297, 0, 0, 0, 0, 0, 7, 0, 0, 0, 0, 0, 0, 0, 'HUMAN REMOVE SMARTAI');
INSERT INTO `smart_scripts` VALUES (65000, 0, 6, 0, 62, 0, 100, 0, 56101, 0, 0, 0, 28, 20549, 0, 0, 0, 0, 0, 7, 0, 0, 0, 0, 0, 0, 0, 'HUMAN REMOVE SMARTAI');
INSERT INTO `smart_scripts` VALUES (65000, 0, 7, 0, 62, 0, 100, 0, 56101, 0, 0, 0, 28, 7744, 0, 0, 0, 0, 0, 7, 0, 0, 0, 0, 0, 0, 0, 'HUMAN REMOVE SMARTAI');
INSERT INTO `smart_scripts` VALUES (65000, 0, 8, 0, 62, 0, 100, 0, 56101, 0, 0, 0, 28, 20577, 0, 0, 0, 0, 0, 7, 0, 0, 0, 0, 0, 0, 0, 'HUMAN REMOVE SMARTAI');
INSERT INTO `smart_scripts` VALUES (65000, 0, 9, 0, 62, 0, 100, 0, 56101, 0, 0, 0, 28, 69179, 0, 0, 0, 0, 0, 7, 0, 0, 0, 0, 0, 0, 0, 'HUMAN REMOVE SMARTAI');


-- DWARF REMOVE SCRIPTS

INSERT INTO `smart_scripts` VALUES (65000, 0, 10, 0, 62, 0, 100, 0, 56101, 1, 0, 0, 28, 58984, 0, 0, 0, 0, 0, 7, 0, 0, 0, 0, 0, 0, 0, 'DWARF REMOVE SMARTAI');
INSERT INTO `smart_scripts` VALUES (65000, 0, 11, 0, 62, 0, 100, 0, 56101, 1, 0, 0, 28, 20589, 0, 0, 0, 0, 0, 7, 0, 0, 0, 0, 0, 0, 0, 'DWARF REMOVE SMARTAI');
INSERT INTO `smart_scripts` VALUES (65000, 0, 12, 0, 62, 0, 100, 0, 56101, 1, 0, 0, 28, 59752, 0, 0, 0, 0, 0, 7, 0, 0, 0, 0, 0, 0, 0, 'DWARF REMOVE SMARTAI');
INSERT INTO `smart_scripts` VALUES (65000, 0, 13, 0, 62, 0, 100, 0, 56101, 1, 0, 0, 28, 28880, 0, 0, 0, 0, 0, 7, 0, 0, 0, 0, 0, 0, 0, 'DWARF REMOVE SMARTAI');
INSERT INTO `smart_scripts` VALUES (65000, 0, 14, 0, 62, 0, 100, 0, 56101, 1, 0, 0, 28, 33697, 0, 0, 0, 0, 0, 7, 0, 0, 0, 0, 0, 0, 0, 'DWARF REMOVE SMARTAI');
INSERT INTO `smart_scripts` VALUES (65000, 0, 15, 0, 62, 0, 100, 0, 56101, 1, 0, 0, 28, 26297, 0, 0, 0, 0, 0, 7, 0, 0, 0, 0, 0, 0, 0, 'DWARF REMOVE SMARTAI');
INSERT INTO `smart_scripts` VALUES (65000, 0, 16, 0, 62, 0, 100, 0, 56101, 1, 0, 0, 28, 20549, 0, 0, 0, 0, 0, 7, 0, 0, 0, 0, 0, 0, 0, 'DWARF REMOVE SMARTAI');
INSERT INTO `smart_scripts` VALUES (65000, 0, 17, 0, 62, 0, 100, 0, 56101, 1, 0, 0, 28, 7744, 0, 0, 0, 0, 0, 7, 0, 0, 0, 0, 0, 0, 0, 'DWARF REMOVE SMARTAI');
INSERT INTO `smart_scripts` VALUES (65000, 0, 18, 0, 62, 0, 100, 0, 56101, 1, 0, 0, 28, 20577, 0, 0, 0, 0, 0, 7, 0, 0, 0, 0, 0, 0, 0, 'DWARF REMOVE SMARTAI');
INSERT INTO `smart_scripts` VALUES (65000, 0, 19, 0, 62, 0, 100, 0, 56101, 1, 0, 0, 28, 69179, 0, 0, 0, 0, 0, 7, 0, 0, 0, 0, 0, 0, 0, 'DWARF REMOVE SMARTAI');

-- NIGHTELF

INSERT INTO `smart_scripts` VALUES (65000, 0, 20, 0, 62, 0, 100, 0, 56101, 2, 0, 0, 28, 20594, 0, 0, 0, 0, 0, 7, 0, 0, 0, 0, 0, 0, 0, 'NIGHTELF REMOVE SMARTAI');
INSERT INTO `smart_scripts` VALUES (65000, 0, 21, 0, 62, 0, 100, 0, 56101, 2, 0, 0, 28, 20589, 0, 0, 0, 0, 0, 7, 0, 0, 0, 0, 0, 0, 0, 'NIGHTELF REMOVE SMARTAI');
INSERT INTO `smart_scripts` VALUES (65000, 0, 22, 0, 62, 0, 100, 0, 56101, 2, 0, 0, 28, 59752, 0, 0, 0, 0, 0, 7, 0, 0, 0, 0, 0, 0, 0, 'NIGHTELF REMOVE SMARTAI');
INSERT INTO `smart_scripts` VALUES (65000, 0, 23, 0, 62, 0, 100, 0, 56101, 2, 0, 0, 28, 28880, 0, 0, 0, 0, 0, 7, 0, 0, 0, 0, 0, 0, 0, 'NIGHTELF REMOVE SMARTAI');
INSERT INTO `smart_scripts` VALUES (65000, 0, 24, 0, 62, 0, 100, 0, 56101, 2, 0, 0, 28, 33697, 0, 0, 0, 0, 0, 7, 0, 0, 0, 0, 0, 0, 0, 'NIGHTELF REMOVE SMARTAI');
INSERT INTO `smart_scripts` VALUES (65000, 0, 25, 0, 62, 0, 100, 0, 56101, 2, 0, 0, 28, 26297, 0, 0, 0, 0, 0, 7, 0, 0, 0, 0, 0, 0, 0, 'NIGHTELF REMOVE SMARTAI');
INSERT INTO `smart_scripts` VALUES (65000, 0, 26, 0, 62, 0, 100, 0, 56101, 2, 0, 0, 28, 20549, 0, 0, 0, 0, 0, 7, 0, 0, 0, 0, 0, 0, 0, 'NIGHTELF REMOVE SMARTAI');
INSERT INTO `smart_scripts` VALUES (65000, 0, 27, 0, 62, 0, 100, 0, 56101, 2, 0, 0, 28, 7744, 0, 0, 0, 0, 0, 7, 0, 0, 0, 0, 0, 0, 0, 'NIGHTELF REMOVE SMARTAI');
INSERT INTO `smart_scripts` VALUES (65000, 0, 28, 0, 62, 0, 100, 0, 56101, 2, 0, 0, 28, 20577, 0, 0, 0, 0, 0, 7, 0, 0, 0, 0, 0, 0, 0, 'NIGHTELF REMOVE SMARTAI');
INSERT INTO `smart_scripts` VALUES (65000, 0, 29, 0, 62, 0, 100, 0, 56101, 2, 0, 0, 28, 69179, 0, 0, 0, 0, 0, 7, 0, 0, 0, 0, 0, 0, 0, 'NIGHTELF REMOVE SMARTAI');

-- GNOME

INSERT INTO `smart_scripts` VALUES (65000, 0, 30, 0, 62, 0, 100, 0, 56101, 3, 0, 0, 28, 20594, 0, 0, 0, 0, 0, 7, 0, 0, 0, 0, 0, 0, 0, 'GNOME REMOVE SMARTAI');
INSERT INTO `smart_scripts` VALUES (65000, 0, 31, 0, 62, 0, 100, 0, 56101, 3, 0, 0, 28, 58984, 0, 0, 0, 0, 0, 7, 0, 0, 0, 0, 0, 0, 0, 'GNOME REMOVE SMARTAI');
INSERT INTO `smart_scripts` VALUES (65000, 0, 32, 0, 62, 0, 100, 0, 56101, 3, 0, 0, 28, 59752, 0, 0, 0, 0, 0, 7, 0, 0, 0, 0, 0, 0, 0, 'GNOME REMOVE SMARTAI');
INSERT INTO `smart_scripts` VALUES (65000, 0, 33, 0, 62, 0, 100, 0, 56101, 3, 0, 0, 28, 28880, 0, 0, 0, 0, 0, 7, 0, 0, 0, 0, 0, 0, 0, 'GNOME REMOVE SMARTAI');
INSERT INTO `smart_scripts` VALUES (65000, 0, 34, 0, 62, 0, 100, 0, 56101, 3, 0, 0, 28, 33697, 0, 0, 0, 0, 0, 7, 0, 0, 0, 0, 0, 0, 0, 'GNOME REMOVE SMARTAI');
INSERT INTO `smart_scripts` VALUES (65000, 0, 35, 0, 62, 0, 100, 0, 56101, 3, 0, 0, 28, 26297, 0, 0, 0, 0, 0, 7, 0, 0, 0, 0, 0, 0, 0, 'GNOME REMOVE SMARTAI');
INSERT INTO `smart_scripts` VALUES (65000, 0, 36, 0, 62, 0, 100, 0, 56101, 3, 0, 0, 28, 20549, 0, 0, 0, 0, 0, 7, 0, 0, 0, 0, 0, 0, 0, 'GNOME REMOVE SMARTAI');
INSERT INTO `smart_scripts` VALUES (65000, 0, 37, 0, 62, 0, 100, 0, 56101, 3, 0, 0, 28, 7744, 0, 0, 0, 0, 0, 7, 0, 0, 0, 0, 0, 0, 0, 'GNOME REMOVE SMARTAI');
INSERT INTO `smart_scripts` VALUES (65000, 0, 38, 0, 62, 0, 100, 0, 56101, 3, 0, 0, 28, 20577, 0, 0, 0, 0, 0, 7, 0, 0, 0, 0, 0, 0, 0, 'GNOME REMOVE SMARTAI');
INSERT INTO `smart_scripts` VALUES (65000, 0, 39, 0, 62, 0, 100, 0, 56101, 3, 0, 0, 28, 69179, 0, 0, 0, 0, 0, 7, 0, 0, 0, 0, 0, 0, 0, 'GNOME REMOVE SMARTAI');

-- DRAENEI

INSERT INTO `smart_scripts` VALUES (65000, 0, 40, 0, 62, 0, 100, 0, 56101, 4, 0, 0, 28, 20594, 0, 0, 0, 0, 0, 7, 0, 0, 0, 0, 0, 0, 0, 'GNOME REMOVE SMARTAI');
INSERT INTO `smart_scripts` VALUES (65000, 0, 41, 0, 62, 0, 100, 0, 56101, 4, 0, 0, 28, 58984, 0, 0, 0, 0, 0, 7, 0, 0, 0, 0, 0, 0, 0, 'GNOME REMOVE SMARTAI');
INSERT INTO `smart_scripts` VALUES (65000, 0, 42, 0, 62, 0, 100, 0, 56101, 4, 0, 0, 28, 59752, 0, 0, 0, 0, 0, 7, 0, 0, 0, 0, 0, 0, 0, 'GNOME REMOVE SMARTAI');
INSERT INTO `smart_scripts` VALUES (65000, 0, 43, 0, 62, 0, 100, 0, 56101, 4, 0, 0, 28, 20589, 0, 0, 0, 0, 0, 7, 0, 0, 0, 0, 0, 0, 0, 'GNOME REMOVE SMARTAI');
INSERT INTO `smart_scripts` VALUES (65000, 0, 44, 0, 62, 0, 100, 0, 56101, 4, 0, 0, 28, 33697, 0, 0, 0, 0, 0, 7, 0, 0, 0, 0, 0, 0, 0, 'GNOME REMOVE SMARTAI');
INSERT INTO `smart_scripts` VALUES (65000, 0, 45, 0, 62, 0, 100, 0, 56101, 4, 0, 0, 28, 26297, 0, 0, 0, 0, 0, 7, 0, 0, 0, 0, 0, 0, 0, 'GNOME REMOVE SMARTAI');
INSERT INTO `smart_scripts` VALUES (65000, 0, 46, 0, 62, 0, 100, 0, 56101, 4, 0, 0, 28, 20549, 0, 0, 0, 0, 0, 7, 0, 0, 0, 0, 0, 0, 0, 'GNOME REMOVE SMARTAI');
INSERT INTO `smart_scripts` VALUES (65000, 0, 47, 0, 62, 0, 100, 0, 56101, 4, 0, 0, 28, 7744, 0, 0, 0, 0, 0, 7, 0, 0, 0, 0, 0, 0, 0, 'GNOME REMOVE SMARTAI');
INSERT INTO `smart_scripts` VALUES (65000, 0, 48, 0, 62, 0, 100, 0, 56101, 4, 0, 0, 28, 20577, 0, 0, 0, 0, 0, 7, 0, 0, 0, 0, 0, 0, 0, 'GNOME REMOVE SMARTAI');
INSERT INTO `smart_scripts` VALUES (65000, 0, 49, 0, 62, 0, 100, 0, 56101, 4, 0, 0, 28, 69179, 0, 0, 0, 0, 0, 7, 0, 0, 0, 0, 0, 0, 0, 'GNOME REMOVE SMARTAI');


-- HORDE

-- ORC

INSERT INTO `smart_scripts` VALUES (65000, 0, 50, 0, 62, 0, 100, 0, 56102, 0, 0, 0, 28, 20594, 0, 0, 0, 0, 0, 7, 0, 0, 0, 0, 0, 0, 0, 'ORC REMOVE SMARTAI');
INSERT INTO `smart_scripts` VALUES (65000, 0, 51, 0, 62, 0, 100, 0, 56102, 0, 0, 0, 28, 58984, 0, 0, 0, 0, 0, 7, 0, 0, 0, 0, 0, 0, 0, 'ORC REMOVE SMARTAI');
INSERT INTO `smart_scripts` VALUES (65000, 0, 52, 0, 62, 0, 100, 0, 56102, 0, 0, 0, 28, 59752, 0, 0, 0, 0, 0, 7, 0, 0, 0, 0, 0, 0, 0, 'ORC REMOVE SMARTAI');
INSERT INTO `smart_scripts` VALUES (65000, 0, 53, 0, 62, 0, 100, 0, 56102, 0, 0, 0, 28, 20589, 0, 0, 0, 0, 0, 7, 0, 0, 0, 0, 0, 0, 0, 'ORC REMOVE SMARTAI');
INSERT INTO `smart_scripts` VALUES (65000, 0, 54, 0, 62, 0, 100, 0, 56102, 0, 0, 0, 28, 28880, 0, 0, 0, 0, 0, 7, 0, 0, 0, 0, 0, 0, 0, 'ORC REMOVE SMARTAI');
INSERT INTO `smart_scripts` VALUES (65000, 0, 55, 0, 62, 0, 100, 0, 56102, 0, 0, 0, 28, 26297, 0, 0, 0, 0, 0, 7, 0, 0, 0, 0, 0, 0, 0, 'ORC REMOVE SMARTAI');
INSERT INTO `smart_scripts` VALUES (65000, 0, 56, 0, 62, 0, 100, 0, 56102, 0, 0, 0, 28, 20549, 0, 0, 0, 0, 0, 7, 0, 0, 0, 0, 0, 0, 0, 'ORC REMOVE SMARTAI');
INSERT INTO `smart_scripts` VALUES (65000, 0, 57, 0, 62, 0, 100, 0, 56102, 0, 0, 0, 28, 7744, 0, 0, 0, 0, 0, 7, 0, 0, 0, 0, 0, 0, 0, 'ORC REMOVE SMARTAI');
INSERT INTO `smart_scripts` VALUES (65000, 0, 58, 0, 62, 0, 100, 0, 56102, 0, 0, 0, 28, 20577, 0, 0, 0, 0, 0, 7, 0, 0, 0, 0, 0, 0, 0, 'ORC REMOVE SMARTAI');
INSERT INTO `smart_scripts` VALUES (65000, 0, 59, 0, 62, 0, 100, 0, 56102, 0, 0, 0, 28, 69179, 0, 0, 0, 0, 0, 7, 0, 0, 0, 0, 0, 0, 0, 'ORC REMOVE SMARTAI');

-- TROLL

INSERT INTO `smart_scripts` VALUES (65000, 0, 60, 0, 62, 0, 100, 0, 56102, 1, 0, 0, 28, 20594, 0, 0, 0, 0, 0, 7, 0, 0, 0, 0, 0, 0, 0, 'TROLL REMOVE SMARTAI');
INSERT INTO `smart_scripts` VALUES (65000, 0, 61, 0, 62, 0, 100, 0, 56102, 1, 0, 0, 28, 58984, 0, 0, 0, 0, 0, 7, 0, 0, 0, 0, 0, 0, 0, 'TROLL REMOVE SMARTAI');
INSERT INTO `smart_scripts` VALUES (65000, 0, 62, 0, 62, 0, 100, 0, 56102, 1, 0, 0, 28, 59752, 0, 0, 0, 0, 0, 7, 0, 0, 0, 0, 0, 0, 0, 'TROLL REMOVE SMARTAI');
INSERT INTO `smart_scripts` VALUES (65000, 0, 63, 0, 62, 0, 100, 0, 56102, 1, 0, 0, 28, 20589, 0, 0, 0, 0, 0, 7, 0, 0, 0, 0, 0, 0, 0, 'TROLL REMOVE SMARTAI');
INSERT INTO `smart_scripts` VALUES (65000, 0, 64, 0, 62, 0, 100, 0, 56102, 1, 0, 0, 28, 28880, 0, 0, 0, 0, 0, 7, 0, 0, 0, 0, 0, 0, 0, 'TROLL REMOVE SMARTAI');
INSERT INTO `smart_scripts` VALUES (65000, 0, 65, 0, 62, 0, 100, 0, 56102, 1, 0, 0, 28, 33697, 0, 0, 0, 0, 0, 7, 0, 0, 0, 0, 0, 0, 0, 'TROLL REMOVE SMARTAI');
INSERT INTO `smart_scripts` VALUES (65000, 0, 66, 0, 62, 0, 100, 0, 56102, 1, 0, 0, 28, 20549, 0, 0, 0, 0, 0, 7, 0, 0, 0, 0, 0, 0, 0, 'TROLL REMOVE SMARTAI');
INSERT INTO `smart_scripts` VALUES (65000, 0, 67, 0, 62, 0, 100, 0, 56102, 1, 0, 0, 28, 7744, 0, 0, 0, 0, 0, 7, 0, 0, 0, 0, 0, 0, 0, 'TROLL REMOVE SMARTAI');
INSERT INTO `smart_scripts` VALUES (65000, 0, 68, 0, 62, 0, 100, 0, 56102, 1, 0, 0, 28, 20577, 0, 0, 0, 0, 0, 7, 0, 0, 0, 0, 0, 0, 0, 'TROLL REMOVE SMARTAI');
INSERT INTO `smart_scripts` VALUES (65000, 0, 69, 0, 62, 0, 100, 0, 56102, 1, 0, 0, 28, 69179, 0, 0, 0, 0, 0, 7, 0, 0, 0, 0, 0, 0, 0, 'TROLL REMOVE SMARTAI');

-- TAUREN

INSERT INTO `smart_scripts` VALUES (65000, 0, 70, 0, 62, 0, 100, 0, 56102, 2, 0, 0, 28, 20594, 0, 0, 0, 0, 0, 7, 0, 0, 0, 0, 0, 0, 0, 'TROLL REMOVE SMARTAI');
INSERT INTO `smart_scripts` VALUES (65000, 0, 71, 0, 62, 0, 100, 0, 56102, 2, 0, 0, 28, 58984, 0, 0, 0, 0, 0, 7, 0, 0, 0, 0, 0, 0, 0, 'TROLL REMOVE SMARTAI');
INSERT INTO `smart_scripts` VALUES (65000, 0, 72, 0, 62, 0, 100, 0, 56102, 2, 0, 0, 28, 59752, 0, 0, 0, 0, 0, 7, 0, 0, 0, 0, 0, 0, 0, 'TROLL REMOVE SMARTAI');
INSERT INTO `smart_scripts` VALUES (65000, 0, 73, 0, 62, 0, 100, 0, 56102, 2, 0, 0, 28, 20589, 0, 0, 0, 0, 0, 7, 0, 0, 0, 0, 0, 0, 0, 'TROLL REMOVE SMARTAI');
INSERT INTO `smart_scripts` VALUES (65000, 0, 74, 0, 62, 0, 100, 0, 56102, 2, 0, 0, 28, 28880, 0, 0, 0, 0, 0, 7, 0, 0, 0, 0, 0, 0, 0, 'TROLL REMOVE SMARTAI');
INSERT INTO `smart_scripts` VALUES (65000, 0, 75, 0, 62, 0, 100, 0, 56102, 2, 0, 0, 28, 33697, 0, 0, 0, 0, 0, 7, 0, 0, 0, 0, 0, 0, 0, 'TROLL REMOVE SMARTAI');
INSERT INTO `smart_scripts` VALUES (65000, 0, 76, 0, 62, 0, 100, 0, 56102, 2, 0, 0, 28, 26297, 0, 0, 0, 0, 0, 7, 0, 0, 0, 0, 0, 0, 0, 'TROLL REMOVE SMARTAI');
INSERT INTO `smart_scripts` VALUES (65000, 0, 77, 0, 62, 0, 100, 0, 56102, 2, 0, 0, 28, 7744, 0, 0, 0, 0, 0, 7, 0, 0, 0, 0, 0, 0, 0, 'TROLL REMOVE SMARTAI');
INSERT INTO `smart_scripts` VALUES (65000, 0, 78, 0, 62, 0, 100, 0, 56102, 2, 0, 0, 28, 20577, 0, 0, 0, 0, 0, 7, 0, 0, 0, 0, 0, 0, 0, 'TROLL REMOVE SMARTAI');
INSERT INTO `smart_scripts` VALUES (65000, 0, 79, 0, 62, 0, 100, 0, 56102, 2, 0, 0, 28, 69179, 0, 0, 0, 0, 0, 7, 0, 0, 0, 0, 0, 0, 0, 'TROLL REMOVE SMARTAI');

-- UNDEAD

INSERT INTO `smart_scripts` VALUES (65000, 0, 80, 0, 62, 0, 100, 0, 56102, 3, 0, 0, 28, 20594, 0, 0, 0, 0, 0, 7, 0, 0, 0, 0, 0, 0, 0, 'TROLL REMOVE SMARTAI');
INSERT INTO `smart_scripts` VALUES (65000, 0, 81, 0, 62, 0, 100, 0, 56102, 3, 0, 0, 28, 58984, 0, 0, 0, 0, 0, 7, 0, 0, 0, 0, 0, 0, 0, 'TROLL REMOVE SMARTAI');
INSERT INTO `smart_scripts` VALUES (65000, 0, 82, 0, 62, 0, 100, 0, 56102, 3, 0, 0, 28, 59752, 0, 0, 0, 0, 0, 7, 0, 0, 0, 0, 0, 0, 0, 'TROLL REMOVE SMARTAI');
INSERT INTO `smart_scripts` VALUES (65000, 0, 83, 0, 62, 0, 100, 0, 56102, 3, 0, 0, 28, 20589, 0, 0, 0, 0, 0, 7, 0, 0, 0, 0, 0, 0, 0, 'TROLL REMOVE SMARTAI');
INSERT INTO `smart_scripts` VALUES (65000, 0, 84, 0, 62, 0, 100, 0, 56102, 3, 0, 0, 28, 28880, 0, 0, 0, 0, 0, 7, 0, 0, 0, 0, 0, 0, 0, 'TROLL REMOVE SMARTAI');
INSERT INTO `smart_scripts` VALUES (65000, 0, 85, 0, 62, 0, 100, 0, 56102, 3, 0, 0, 28, 33697, 0, 0, 0, 0, 0, 7, 0, 0, 0, 0, 0, 0, 0, 'TROLL REMOVE SMARTAI');
INSERT INTO `smart_scripts` VALUES (65000, 0, 86, 0, 62, 0, 100, 0, 56102, 3, 0, 0, 28, 26297, 0, 0, 0, 0, 0, 7, 0, 0, 0, 0, 0, 0, 0, 'TROLL REMOVE SMARTAI');
INSERT INTO `smart_scripts` VALUES (65000, 0, 88, 0, 62, 0, 100, 0, 56102, 3, 0, 0, 28, 20549, 0, 0, 0, 0, 0, 7, 0, 0, 0, 0, 0, 0, 0, 'TROLL REMOVE SMARTAI');
INSERT INTO `smart_scripts` VALUES (65000, 0, 89, 0, 62, 0, 100, 0, 56102, 3, 0, 0, 28, 69179, 0, 0, 0, 0, 0, 7, 0, 0, 0, 0, 0, 0, 0, 'TROLL REMOVE SMARTAI');

-- BLOODELF

INSERT INTO `smart_scripts` VALUES (65000, 0, 90, 0, 62, 0, 100, 0, 56102, 4, 0, 0, 28, 20594, 0, 0, 0, 0, 0, 7, 0, 0, 0, 0, 0, 0, 0, 'TROLL REMOVE SMARTAI');
INSERT INTO `smart_scripts` VALUES (65000, 0, 91, 0, 62, 0, 100, 0, 56102, 4, 0, 0, 28, 58984, 0, 0, 0, 0, 0, 7, 0, 0, 0, 0, 0, 0, 0, 'TROLL REMOVE SMARTAI');
INSERT INTO `smart_scripts` VALUES (65000, 0, 92, 0, 62, 0, 100, 0, 56102, 4, 0, 0, 28, 59752, 0, 0, 0, 0, 0, 7, 0, 0, 0, 0, 0, 0, 0, 'TROLL REMOVE SMARTAI');
INSERT INTO `smart_scripts` VALUES (65000, 0, 93, 0, 62, 0, 100, 0, 56102, 4, 0, 0, 28, 20589, 0, 0, 0, 0, 0, 7, 0, 0, 0, 0, 0, 0, 0, 'TROLL REMOVE SMARTAI');
INSERT INTO `smart_scripts` VALUES (65000, 0, 94, 0, 62, 0, 100, 0, 56102, 4, 0, 0, 28, 28880, 0, 0, 0, 0, 0, 7, 0, 0, 0, 0, 0, 0, 0, 'TROLL REMOVE SMARTAI');
INSERT INTO `smart_scripts` VALUES (65000, 0, 95, 0, 62, 0, 100, 0, 56102, 4, 0, 0, 28, 33697, 0, 0, 0, 0, 0, 7, 0, 0, 0, 0, 0, 0, 0, 'TROLL REMOVE SMARTAI');
INSERT INTO `smart_scripts` VALUES (65000, 0, 96, 0, 62, 0, 100, 0, 56102, 4, 0, 0, 28, 26297, 0, 0, 0, 0, 0, 7, 0, 0, 0, 0, 0, 0, 0, 'TROLL REMOVE SMARTAI');
INSERT INTO `smart_scripts` VALUES (65000, 0, 97, 0, 62, 0, 100, 0, 56102, 4, 0, 0, 28, 7744, 0, 0, 0, 0, 0, 7, 0, 0, 0, 0, 0, 0, 0, 'TROLL REMOVE SMARTAI');
INSERT INTO `smart_scripts` VALUES (65000, 0, 98, 0, 62, 0, 100, 0, 56102, 4, 0, 0, 28, 20577, 0, 0, 0, 0, 0, 7, 0, 0, 0, 0, 0, 0, 0, 'TROLL REMOVE SMARTAI');
INSERT INTO `smart_scripts` VALUES (65000, 0, 99, 0, 62, 0, 100, 0, 56102, 4, 0, 0, 28, 20549, 0, 0, 0, 0, 0, 7, 0, 0, 0, 0, 0, 0, 0, 'TROLL REMOVE SMARTAI');
Click to expand...

- - - Updated - - -

also I just realized that its posted in craftweb "rip" only thread that came up with the search bar
 
Rochet2

Rochet2

Moderator / Eluna Dev
I dont think smart AI is flexible enough to do this. Unsure if you are switching races or just the spells.
Could be that the core has checks on relog for the racials so they might be restored to default on relog.
There is no learning or unlearning on smart ai and unaura is not enough for unlearning.
The code looks alright to me. You sure you enabled smart AI for the creature 65000? And make sure it has no C++ scripts.
 
B

Bigchocolate

Emulation Addict
well the definition is to remove the spell, not just unaura, but ill go back and recheck that npc I wrote that script right before bed, but function is supposed to work, sadly though there is no learn spell option for smart scripts

- - - Updated - - -

also this is the creature data
INSERT INTO `creature_template` VALUES (65000, 0, 0, 0, 0, 0, 1438, 0, 0, 0, 'Shady Slim', 'The Drunk', 'LootAll', 56100, 90, 90, 0, 1161, 3, 1, 1.14286, 1.25, 0, 0, 0, 0, 1, 1, 1, 2, 2048, 0, 0, 0, 0, 0, 0, 7, 138936390, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'SmartAI', 0, 3, 1, 15, 15, 15, 1, 1, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 2, '', 0);
Click to expand...


also its just the spells im switching that script on handles the removal of the spells
 
Status
Not open for further replies.
Top