2 replies to this topic

[demonise]

Hello, I made a GM commands book on WoW-V so that some of my staff could have it handy in their bag to look at when they needed a good refreshment on them. But when I try to execute it into my Database (Navicat), I get this error.

[Err] 1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ' 0, 3)' at line 2

This is what I'm trying to execute

INSERT INTO item_template (entry, class, subclass, name, displayid, Quality, BuyCount, BuyPrice, SellPrice, InventoryType, AllowableClass, AllowableRace, ItemLevel, RequiredLevel, RequiredSkill, RequiredSkillRank, requiredspell, RequiredReputationFaction, RequiredReputationRank, maxcount, stackable, description, PageText, LanguageID, PageMaterial)
VALUES (66003, 15, 0, "Common GM commands", 7139, 6, 0, 0, 0, 0, -1, -1, 0, 0, 0, 0, 0, 0, 0, 0, 1, "Refer to this for assistance", , 0, 3);

INSERT INTO page_text (entry, text, next_page) VALUES
('', '$N, Welcome to the GM command guide for dummies! Here you will find a list of common GM commands. Enjoy! $B            Do not include the <>$B$B- .lookup item <Item name here> $B- .additem <The item ID by the item you looked up>$B- .mod money <amount in copper, 100 = 1 Silver or 1000 = 10 silver>$B- .mod morph <1-30k>$B- .mod hp <any value>$B- .mod mana <any value>$B- .mod rage <any value>$B- .mod runicpower <any power>$B- .mod energy <any value>$B- .mod speed <.1-50>$B- .mod swim <.1-50>$B- .mod scale <.1-10>$B- .mod gender <male/female>$B', '1'), 
('1', '- .tele <location name>$B- .appear <persons name>$B- .summon <persons name>$B- .die <kills the selected target>$B- .rev <revives the selected target; Void on NPC\'s>$B- .gm on <turns your GM tag on>$B- .gm off <turns your GM tag off>$B- .lookup object <looks up objects given the name>$B- .gob add <spawns the object by the ID>$B- .lookup creature <looks up creatures given the name>$B- .npc add <spawns the NPC given the ID>$B- .gm fly on <turns fly mode on>$B- .gm fly off <turns fly mode off>$B- .lookup title <looks up the title given the name>$B- .title add <adds title based on its ID>$B- .lookup spell <looks up the spell given the name>$B- .learn <learns the spell given the ID>$B$B     This book will be handy in times of need!', '2'), 
('2', '      Made by Armsspec, AKA server Owner :)', '0');

Any help is highly appreciated!  ;D

[Rochet2]

You have not set the textid in the creator.

Replace 123123 with your preferred unused entry from page_text table.

SET @Page_Text_Entry = 123123;

INSERT INTO item_template (entry, class, subclass, name, displayid, Quality, BuyCount, BuyPrice, SellPrice, InventoryType, AllowableClass, AllowableRace, ItemLevel, RequiredLevel, RequiredSkill, RequiredSkillRank, requiredspell, RequiredReputationFaction, RequiredReputationRank, maxcount, stackable, description, PageText, LanguageID, PageMaterial)
VALUES (66003, 15, 0, "Common GM commands", 7139, 6, 0, 0, 0, 0, -1, -1, 0, 0, 0, 0, 0, 0, 0, 0, 1, "Refer to this for assistance", @Page_Text_Entry, 0, 3);

INSERT INTO page_text (entry, text, next_page) VALUES
(@Page_Text_Entry, '$N, Welcome to the GM command guide for dummies! Here you will find a list of common GM commands. Enjoy! $B            Do not include the <>$B$B- .lookup item <Item name here> $B- .additem <The item ID by the item you looked up>$B- .mod money <amount in copper, 100 = 1 Silver or 1000 = 10 silver>$B- .mod morph <1-30k>$B- .mod hp <any value>$B- .mod mana <any value>$B- .mod rage <any value>$B- .mod runicpower <any power>$B- .mod energy <any value>$B- .mod speed <.1-50>$B- .mod swim <.1-50>$B- .mod scale <.1-10>$B- .mod gender <male/female>$B', '1'), 
(@Page_Text_Entry+1, '- .tele <location name>$B- .appear <persons name>$B- .summon <persons name>$B- .die <kills the selected target>$B- .rev <revives the selected target; Void on NPC\'s>$B- .gm on <turns your GM tag on>$B- .gm off <turns your GM tag off>$B- .lookup object <looks up objects given the name>$B- .gob add <spawns the object by the ID>$B- .lookup creature <looks up creatures given the name>$B- .npc add <spawns the NPC given the ID>$B- .gm fly on <turns fly mode on>$B- .gm fly off <turns fly mode off>$B- .lookup title <looks up the title given the name>$B- .title add <adds title based on its ID>$B- .lookup spell <looks up the spell given the name>$B- .learn <learns the spell given the ID>$B$B     This book will be handy in times of need!', '2'), 
(@Page_Text_Entry+2, '      Made by Armsspec, AKA server Owner :)', '0');

[demonise]

Thank you very much! I don't know why I missed that in the creator...>>" stupid me.... :P