[RELEASE] Query; Every player starts with a item that sells for 10k gold.

[Romis]

Hi there!
I bet you all want to add an item wich sells for 10k gold in the players backpacks, but you have no idea how?

Well i've come here to fix your problem

First, you need to right click your database and click '' console ''

then add this query:

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 (800005,6,2,-1,"10 000 Gold","10 000 Gold","10 000 Gold","10 000 Gold",35360,5,0,999999999,100000000,24,-1,-1,2,1,0,0,0,0,0,0,0,1,1,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,0,0,0,0,0,0,0,0,0,0,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,1,"Sell me for 10 000 gold!",0,0,0,0,0,2,0,0,0,0,0,0,0,0,1,0,0,0,0,0,0,0,0,0,0,0,0);

Then add this query:

INSERT INTO playercreateinfo_items (indexid, protoid, slotid, amount) VALUES (1,800005,26,1);
INSERT INTO playercreateinfo_items (indexid, protoid, slotid, amount) VALUES (2,800005,26,1);
INSERT INTO playercreateinfo_items (indexid, protoid, slotid, amount) VALUES (3,800005,26,1);
INSERT INTO playercreateinfo_items (indexid, protoid, slotid, amount) VALUES (4,800005,26,1);
INSERT INTO playercreateinfo_items (indexid, protoid, slotid, amount) VALUES (5,800005,26,1);
INSERT INTO playercreateinfo_items (indexid, protoid, slotid, amount) VALUES (6,800005,26,1);
INSERT INTO playercreateinfo_items (indexid, protoid, slotid, amount) VALUES (7,800005,26,1);
INSERT INTO playercreateinfo_items (indexid, protoid, slotid, amount) VALUES (8,800005,26,1);
INSERT INTO playercreateinfo_items (indexid, protoid, slotid, amount) VALUES (9,800005,26,1);
INSERT INTO playercreateinfo_items (indexid, protoid, slotid, amount) VALUES (10,800005,26,1);
INSERT INTO playercreateinfo_items (indexid, protoid, slotid, amount) VALUES (11,800005,26,1);
INSERT INTO playercreateinfo_items (indexid, protoid, slotid, amount) VALUES (12,800005,26,1);
INSERT INTO playercreateinfo_items (indexid, protoid, slotid, amount) VALUES (13,800005,26,1);
INSERT INTO playercreateinfo_items (indexid, protoid, slotid, amount) VALUES (14,800005,26,1);
INSERT INTO playercreateinfo_items (indexid, protoid, slotid, amount) VALUES (15,800005,26,1);
INSERT INTO playercreateinfo_items (indexid, protoid, slotid, amount) VALUES (16,800005,26,1);
INSERT INTO playercreateinfo_items (indexid, protoid, slotid, amount) VALUES (17,800005,26,1);
INSERT INTO playercreateinfo_items (indexid, protoid, slotid, amount) VALUES (18,800005,26,1);
INSERT INTO playercreateinfo_items (indexid, protoid, slotid, amount) VALUES (19,800005,26,1);
INSERT INTO playercreateinfo_items (indexid, protoid, slotid, amount) VALUES (20,800005,26,1);
INSERT INTO playercreateinfo_items (indexid, protoid, slotid, amount) VALUES (21,800005,26,1);
INSERT INTO playercreateinfo_items (indexid, protoid, slotid, amount) VALUES (22,800005,26,1);
INSERT INTO playercreateinfo_items (indexid, protoid, slotid, amount) VALUES (23,800005,26,1);
INSERT INTO playercreateinfo_items (indexid, protoid, slotid, amount) VALUES (24,800005,26,1);
INSERT INTO playercreateinfo_items (indexid, protoid, slotid, amount) VALUES (25,800005,26,1);
INSERT INTO playercreateinfo_items (indexid, protoid, slotid, amount) VALUES (26,800005,26,1);
INSERT INTO playercreateinfo_items (indexid, protoid, slotid, amount) VALUES (27,800005,26,1);
INSERT INTO playercreateinfo_items (indexid, protoid, slotid, amount) VALUES (28,800005,26,1);
INSERT INTO playercreateinfo_items (indexid, protoid, slotid, amount) VALUES (29,800005,26,1);
INSERT INTO playercreateinfo_items (indexid, protoid, slotid, amount) VALUES (30,800005,26,1);
INSERT INTO playercreateinfo_items (indexid, protoid, slotid, amount) VALUES (31,800005,26,1);
INSERT INTO playercreateinfo_items (indexid, protoid, slotid, amount) VALUES (32,800005,26,1);
INSERT INTO playercreateinfo_items (indexid, protoid, slotid, amount) VALUES (34,800005,26,1);
INSERT INTO playercreateinfo_items (indexid, protoid, slotid, amount) VALUES (35,800005,26,1);
INSERT INTO playercreateinfo_items (indexid, protoid, slotid, amount) VALUES (36,800005,26,1);
INSERT INTO playercreateinfo_items (indexid, protoid, slotid, amount) VALUES (37,800005,26,1);
INSERT INTO playercreateinfo_items (indexid, protoid, slotid, amount) VALUES (38,800005,26,1);
INSERT INTO playercreateinfo_items (indexid, protoid, slotid, amount) VALUES (39,800005,26,1);
INSERT INTO playercreateinfo_items (indexid, protoid, slotid, amount) VALUES (40,800005,26,1);
INSERT INTO playercreateinfo_items (indexid, protoid, slotid, amount) VALUES (41,800005,26,1);
INSERT INTO playercreateinfo_items (indexid, protoid, slotid, amount) VALUES (42,800005,26,1);
INSERT INTO playercreateinfo_items (indexid, protoid, slotid, amount) VALUES (43,800005,26,1);
INSERT INTO playercreateinfo_items (indexid, protoid, slotid, amount) VALUES (44,800005,26,1);
INSERT INTO playercreateinfo_items (indexid, protoid, slotid, amount) VALUES (45,800005,26,1);
INSERT INTO playercreateinfo_items (indexid, protoid, slotid, amount) VALUES (46,800005,26,1);
INSERT INTO playercreateinfo_items (indexid, protoid, slotid, amount) VALUES (47,800005,26,1);
INSERT INTO playercreateinfo_items (indexid, protoid, slotid, amount) VALUES (48,800005,26,1);
INSERT INTO playercreateinfo_items (indexid, protoid, slotid, amount) VALUES (49,800005,26,1);
INSERT INTO playercreateinfo_items (indexid, protoid, slotid, amount) VALUES (50,800005,26,1);
INSERT INTO playercreateinfo_items (indexid, protoid, slotid, amount) VALUES (51,800005,26,1);
INSERT INTO playercreateinfo_items (indexid, protoid, slotid, amount) VALUES (52,800005,26,1);
INSERT INTO playercreateinfo_items (indexid, protoid, slotid, amount) VALUES (53,800005,26,1);
INSERT INTO playercreateinfo_items (indexid, protoid, slotid, amount) VALUES (54,800005,26,1);
INSERT INTO playercreateinfo_items (indexid, protoid, slotid, amount) VALUES (55,800005,26,1);

Restart your server and you are ready to go!

Credits:

Romis ( Me ;P )

[Creepfold]

maybe wait more then 1 hour?

[Romis]

Even though you're a leacher, you can at least comment.

[warxhead]

I laughed at this, there are so many other ways of doing it. Why couldn't you just do a firstworldenter function?