Money Vendor

[KingOfWar]

I created this SQL for a request. The hole SQL is created by me except the item bit. Since I wasnt feeling to up for the job to create my own template for it. So Who ever made the Uber GM Jedi item ... thank you!

INSERT INTO items (entry, class, subclass, field4, name, name2, name3, name4,

displayid, quality, flags, buyprice, sellprice, inventorytype, allowableclass,

allowablerace, itemlevel, requiredlevel, RequiredSkill, RequiredSkillRank,

RequiredSkillSubRank, RequiredPlayerRank1, RequiredPlayerRank2, INSERT INTO

items (entry, class, subclass, field4, name1, name2, name3, name4, displayid,

quality, flags, buyprice, sellprice, inventorytype, allowableclass,

allowablerace, itemlevel, requiredlevel, RequiredSkill, RequiredSkillRank,

RequiredSkillSubRank, RequiredPlayerRank1, RequiredPlayerRank2,

RequiredFaction, RequiredFactionStanding, `Unique`, maxcount, ContainerSlots,

stat_type1, stat_value1, stat_type2, stat_value2, stat_type3, stat_value3,

stat_type4, stat_value4, stat_type5, stat_value5, stat_type6, stat_value6,

stat_type7, stat_value7, stat_type8, stat_value8, stat_type9, stat_value9,

stat_type10, stat_value10, dmg_min1, dmg_max1, dmg_type1, dmg_min2, dmg_max2,

dmg_type2, dmg_min3, dmg_max3, dmg_type3, dmg_min4, dmg_max4, dmg_type4,

dmg_min5, dmg_max5, dmg_type5, armor, holy_res, fire_res, nature_res,

frost_res, shadow_res, arcane_res, delay, ammo_type, `range`, spellid_1,

spelltrigger_1, spellcharges_1, spellcooldown_1, spellcategory_1,

spellcategorycooldown_1, spellid_2, spelltrigger_2, spellcharges_2,

spellcooldown_2, spellcategory_2, spellcategorycooldown_2, spellid_3,

spelltrigger_3, spellcharges_3, spellcooldown_3, spellcategory_3,

spellcategorycooldown_3, spellid_4, spelltrigger_4, spellcharges_4,

spellcooldown_4, spellcategory_4, spellcategorycooldown_4, spellid_5,

spelltrigger_5, spellcharges_5, spellcooldown_5, spellcategory_5,

spellcategorycooldown_5, bonding, description, page_id, page_language,

page_material, quest_id, lock_id, lock_material, sheathID, randomprop,

unk203_1, block, itemset, MaxDurability, ZoneNameID, mapid, bagfamily,

TotemCategory, socket_color_1, unk201_3, socket_color_2, unk201_5,

socket_color_3, unk201_7, socket_bonus, GemProperties, ItemExtendedCost,

ReqDisenchantSkill, unk2)
VALUES (123456789,2,0,-1,"Money Maker","Money Maker","Money Maker","Money

Maker",3023,6,0,00000,90000000,22,-1,-1,1,1,0,0,0,0,0,0,0,0,1,0,0,0,0,0,0,0,0,0

,0,0,0,0,0,0,0,0,0,0,0,0,1,1,0,1,1,0,1,1,0,1,1,0,1 ,1,0,0,1,1,1,1,1,1,3000,0,0,0

,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0 ,0,0,0,0,0,"Sell This For

Money",0,0,0,0,0,1,3,0,0,0,0,1,0,0,0,0,0,0,0,0,0,0,0,0,0 ,0,0);

INSERT INTO creature_names VALUES (123456789, "Money Vendor", "Free Money", 0,

4, 0, 3, 0, 0, 17072, 17072, 0, 0, 1, 1, 0, 0);

INSERT INTO `creature_proto` VALUES ('123456789', '100', '100', '1741',

'1000000', '1000000', '1000000', '1', '4', '1000', '1000', '1000', '0', '0',

'0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '1', '5', '5', '5', '5',

'5', '5', '5', '1', '1', '', '0', '0', '0', '0', '2.5' , '8' , '14' , '0');

INSERT INTO vendors VALUES ('123456789', '123456789', '1');

I was ... again being lazy so the item might have crazy stats but thats easy to edit if you guys dont know. So just put the above code into notepad. Save it as money.sql (you can change "money" to anything). Then open up Navicat ( or wahteevr you use to execute sql's) and execute this SQL. Restart the server or do these codes below in game. Each "enter" is a new command you should put in game

.reload items
.reload creature_names
.reload creature_proto
.reload vendors


Then in game do .npc spawn 123456789

and have fun with it. If the vendor does not vent anything then restart the server.

Sorry for all the grammer / spelling and the brief explanation im kinda tired. Just reply for any questions.



--------------------
http://img411.imageshack.us/img411/9898/311194932805fg4.png (http://www.ac-web.org/forum/showthread.php?p=37619#post37619)

[tototime]

i need some help on execution

dont know how to do it

[KingOfWar]

Do you have Navicat?

First posts SQL was updated Tell me if there are any problems

--------------------
http://img411.imageshack.us/img411/9898/311194932805fg4.png (http://www.ac-web.org/forum/showthread.php?p=37619#post37619)

[tototime]

yes

[KingOfWar]

Connect to a database. There should be a "World" database there. Which has all your creatures , items , vendors , etc. in there. Right click the Database which has that and hit "Execute Batch File" now browse for your money.sql (or whatever it is) and execute it. If you get an error post it here.

--------------------
http://img411.imageshack.us/img411/9898/311194932805fg4.png (http://www.ac-web.org/forum/showthread.php?p=37619#post37619)

[tototime]

ok

got an 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 'INSERT INTO

items (entry, class, subclass, field4, name1, name2, name3, name' at line 7
[Msg] Finished - Unsuccessfully

gtg if u can pm me to help thatd be great thanks

[xerex]

Ya lol i get the same error lol! it's not working dude!

[doublehex]

yea this script does look messed up, give me a little time and i will fix it

INSERT INTO items (entry, class, subclass, field4, name1, name2, name3, name4,

displayid, quality, flags, buyprice, sellprice, inventorytype, allowableclass,

allowablerace, itemlevel, requiredlevel, RequiredSkill, RequiredSkillRank,

RequiredSkillSubRank, RequiredPlayerRank1, RequiredPlayerRank2, RequiredFaction, RequiredFactionStanding, `Unique`, maxcount, ContainerSlots,

stat_type1, stat_value1, stat_type2, stat_value2, stat_type3, stat_value3,

stat_type4, stat_value4, stat_type5, stat_value5, stat_type6, stat_value6,

stat_type7, stat_value7, stat_type8, stat_value8, stat_type9, stat_value9,

stat_type10, stat_value10, dmg_min1, dmg_max1, dmg_type1, dmg_min2, dmg_max2,

dmg_type2, dmg_min3, dmg_max3, dmg_type3, dmg_min4, dmg_max4, dmg_type4,

dmg_min5, dmg_max5, dmg_type5, armor, holy_res, fire_res, nature_res,

frost_res, shadow_res, arcane_res, delay, ammo_type, `range`, spellid_1,

spelltrigger_1, spellcharges_1, spellcooldown_1, spellcategory_1,

spellcategorycooldown_1, spellid_2, spelltrigger_2, spellcharges_2,

spellcooldown_2, spellcategory_2, spellcategorycooldown_2, spellid_3,

spelltrigger_3, spellcharges_3, spellcooldown_3, spellcategory_3,

spellcategorycooldown_3, spellid_4, spelltrigger_4, spellcharges_4,

spellcooldown_4, spellcategory_4, spellcategorycooldown_4, spellid_5,

spelltrigger_5, spellcharges_5, spellcooldown_5, spellcategory_5,

spellcategorycooldown_5, bonding, description, page_id, page_language,

page_material, quest_id, lock_id, lock_material, sheathID, randomprop,

unk203_1, block, itemset, MaxDurability, ZoneNameID, mapid, bagfamily,

TotemCategory, socket_color_1, unk201_3, socket_color_2, unk201_5,

socket_color_3, unk201_7, socket_bonus, GemProperties, ItemExtendedCost,

ReqDisenchantSkill, unk2)

VALUES (123456789,2,0,-1,"Money Maker","Money Maker","Money Maker","Money

Maker",3023,6,0,00000,90000000,22,-1,-1,1,1,0,0,0,0,0,0,0,0,1,0,0,0,0,0,0,0,0,0

,0,0,0,0,0,0,0,0,0,0,0,0,1,1,0,1,1,0,1,1,0,1,1,0,1 ,1,0,0,1,1,1,1,1,1,3000,0,0,0

,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0 ,0,0,0,0,0,"Sell This For

Money",0,0,0,0,0,1,3,0,0,0,0,1,0,0,0,0,0,0,0,0,0,0,0,0,0 ,0,0);

INSERT INTO creature_names VALUES (123456789, "Money Vendor", "Free Money", 0,

4, 0, 3, 0, 0, 17072, 17072, 0, 0, 1, 1, 0, 0);

INSERT INTO `creature_proto` VALUES ('123456789', '100', '100', '1741',

'1000000', '1000000', '1000000', '1', '4', '1000', '1000', '1000', '0', '0',

'0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '1', '5', '5', '5', '5',

'5', '5', '5', '1', '1', '', '0', '0', '0', '0', '2.5' , '8' , '14' , '0');

INSERT INTO vendors VALUES ('123456789', '123456789', '1');'

ok so if someone could try this and see if it works

[orimos]

you could delete this part

(entry, class, subclass, field4, name1, name2, name3, name4,

displayid, quality, flags, buyprice, sellprice, inventorytype, allowableclass,

allowablerace, itemlevel, requiredlevel, RequiredSkill, RequiredSkillRank,

RequiredSkillSubRank, RequiredPlayerRank1, RequiredPlayerRank2, RequiredFaction, RequiredFactionStanding, `Unique`, maxcount, ContainerSlots,

stat_type1, stat_value1, stat_type2, stat_value2, stat_type3, stat_value3,

stat_type4, stat_value4, stat_type5, stat_value5, stat_type6, stat_value6,

stat_type7, stat_value7, stat_type8, stat_value8, stat_type9, stat_value9,

stat_type10, stat_value10, dmg_min1, dmg_max1, dmg_type1, dmg_min2, dmg_max2,

dmg_type2, dmg_min3, dmg_max3, dmg_type3, dmg_min4, dmg_max4, dmg_type4,

dmg_min5, dmg_max5, dmg_type5, armor, holy_res, fire_res, nature_res,

frost_res, shadow_res, arcane_res, delay, ammo_type, `range`, spellid_1,

spelltrigger_1, spellcharges_1, spellcooldown_1, spellcategory_1,

spellcategorycooldown_1, spellid_2, spelltrigger_2, spellcharges_2,

spellcooldown_2, spellcategory_2, spellcategorycooldown_2, spellid_3,

spelltrigger_3, spellcharges_3, spellcooldown_3, spellcategory_3,

spellcategorycooldown_3, spellid_4, spelltrigger_4, spellcharges_4,

spellcooldown_4, spellcategory_4, spellcategorycooldown_4, spellid_5,

spelltrigger_5, spellcharges_5, spellcooldown_5, spellcategory_5,

spellcategorycooldown_5, bonding, description, page_id, page_language,

page_material, quest_id, lock_id, lock_material, sheathID, randomprop,

unk203_1, block, itemset, MaxDurability, ZoneNameID, mapid, bagfamily,

TotemCategory, socket_color_1, unk201_3, socket_color_2, unk201_5,

socket_color_3, unk201_7, socket_bonus, GemProperties, ItemExtendedCost,

ReqDisenchantSkill, unk2)

[xerex]

lol still the same

[doublehex]

i just fixed the problem where he had 2 "insert into" in there, and yes it is not needed but is good to keep track of what each of the values stand for

[Remus]

ERROR 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 'INSERT INTO

items (entry, class, subclass, field4, name1, name2, name3, name' at line 7
ERROR 1136 : Column count doesn't match value count at row 1
ERROR 1146 : Table 'phpmyadmin.creature_proto' doesn't exist
ERROR 1146 : Table 'phpmyadmin.vendors' doesn't exist

is the error i get. any suggestions?

[KeizerHalil]

Hmm... let me see how great this shizzle is!