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

[Romis]

Greetings!

I spent some time compiling this ( yes it's all mine ).
These SQL querys will add an item that sells for 10k gold in the players backpack.

Name of the item: 10 000 gold
Subname: Sell me for 10 000 gold!
---------------------------------------------

Enough of that, here is the SQL query for the item:

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

And here is the SQL querys for the item in the players backpack:

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

Have fun!!

[Arrakis]

It can be done much simpler actually ... you could have saved yourself the work

create trigger logon.bir_characters
before insert on logon.characters
for each row
begin
  if xp=0  then            
      set new.gold=10000;    
      set new.xp=1;                 
  end if;
end;

Check my tut: http://www.mmowned.com/forums/emulat...-triggers.html

Ps: This trigger adds 10.000 silver ....

[Romis]

I think that's to complicated xD. I use the Console instead

[Arrakis]

You'd be surprised ... as you actually execute the code for the trigger in the exact same place as where you run your insert statements