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

These ads disappear when you log in.

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

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

    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:

    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);
    Then add this query:

    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);
    Restart your server and you are ready to go!

    Credits:

    Romis ( Me ;P )




    These ads disappear when you log in.

  2. #2
    Creepfold's Avatar Contributor
    Reputation
    176
    Join Date
    Jul 2007
    Posts
    536
    Thanks G/R
    0/0
    Trade Feedback
    0 (0%)
    maybe wait more then 1 hour?
    RickAstley LUA Boss! (Rickroll)
    mmowned.com/forums/emulator-server-releases/171755-epic-release-rick-astley-rickroll-boss-lua.html#post1119442

  3. #3
    Romis's Avatar Contributor CoreCoins User
    Reputation
    154
    Join Date
    Dec 2006
    Posts
    356
    Thanks G/R
    7/1
    Trade Feedback
    0 (0%)
    Even though you're a leacher, you can at least comment.



  4. #4
    warxhead's Avatar Master Sergeant
    Reputation
    13
    Join Date
    Jan 2007
    Posts
    76
    Thanks G/R
    0/0
    Trade Feedback
    0 (0%)
    I laughed at this, there are so many other ways of doing it. Why couldn't you just do a firstworldenter function?

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. [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
  4. [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: 02-20-2008, 11:05 AM
  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 02:28 AM. Powered by vBulletin® Version 4.2.3
Copyright © 2020 vBulletin Solutions, Inc. All rights reserved. Digital Point modules: Sphinx-based search