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

User Tag List

Results 1 to 4 of 4
  1. #1
    Romis's Avatar Contributor
    Reputation
    154
    Join Date
    Dec 2006
    Posts
    356
    Thanks G/R
    7/1
    Trade Feedback
    0 (0%)
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

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

    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:

    Code:
    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:

    Code:
    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!!

    These ads disappear when you log in.

  2. #2
    Arrakis's Avatar Master Sergeant
    Reputation
    52
    Join Date
    Jan 2008
    Posts
    123
    Thanks G/R
    0/0
    Trade Feedback
    0 (0%)
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    It can be done much simpler actually ... you could have saved yourself the work

    Code:
    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 ....

  3. #3
    Romis's Avatar Contributor
    Reputation
    154
    Join Date
    Dec 2006
    Posts
    356
    Thanks G/R
    7/1
    Trade Feedback
    0 (0%)
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    I think that's to complicated xD. I use the Console instead

  4. #4
    Arrakis's Avatar Master Sergeant
    Reputation
    52
    Join Date
    Jan 2008
    Posts
    123
    Thanks G/R
    0/0
    Trade Feedback
    0 (0%)
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    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

Similar Threads

  1. White Item That Sells For Over 400g Possible?
    By Nastya in forum World of Warcraft Guides
    Replies: 15
    Last Post: 03-13-2009, 06:00 PM
  2. [Release] Players Start with Season 1 Weapons
    By Lilltimmy in forum World of Warcraft Emulator Servers
    Replies: 6
    Last Post: 06-28-2008, 11:58 AM
  3. [RELEASE] Query; Every player starts with a item that sells for 10k gold.
    By Romis in forum World of Warcraft Emulator Servers
    Replies: 3
    Last Post: 03-03-2008, 07:34 AM
  4. [Question] How to make players start with gear/money/items?
    By hukabuka in forum World of Warcraft Emulator Servers
    Replies: 11
    Last Post: 02-23-2008, 08:13 PM
  5. [Help] Need code 4 players to start with 1 item.
    By jokerjokes in forum World of Warcraft Emulator Servers
    Replies: 1
    Last Post: 12-21-2007, 11:18 PM
All times are GMT -5. The time now is 01:21 AM. Powered by vBulletin® Version 4.2.3
Copyright © 2020 vBulletin Solutions, Inc. All rights reserved. User Alert System provided by Advanced User Tagging (Pro) - vBulletin Mods & Addons Copyright © 2020 DragonByte Technologies Ltd.
Digital Point modules: Sphinx-based search