SQL Guide V2

[Chuck Norris]

If some of you are wondering why it is version two is because I am *nightmare* My account was hacked and now I can not get it back.

When making a armor set or items make sure the entry numbers are a set of numbers (eg. 5000-5010) When you do this it will make finding theses entry's much easier to find.

Do use this query every time before you make a sql.

DELETE FROM creature_names WHERE entry BETWEEN '5000' AND '5010';

DELETE FROM creature_proto WHERE entry BETWEEN '5000' AND '

'5010';

That will delete any items that have the same entry, and you will not get the error msg.
Error Code: 1062 - Duplicate entry '1000' for key 1

If you are not making any creatures then change were it says
creature_names and replace it with the name you need it to be.

(eg. creature_names to items)
DELETE FROMitems WHERE entry BETWEEN '5000' AND '5010';


If you want a name above the item in the sql then above the sql type in
/* */ and in between the /* */ place any name you would like.

/* Cloudburst War-Kilt */
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 (80092,4,3,-1,"Cloudburst War-Kilt","Cloudburst War-Kilt","Cloudburst War-Kilt","Cloudburst War-Kilt",40447,5,0,0000,0000,7,64,-1,0,70,0,0,0,0,0,0,0,0,1,0,4,56,0,0,7,77,0,0,0,0,0,0,5,41,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,944,0,0,0,0,0,0,0,0,0,7599,1,0,0,0,0,21633,1,0,0,0,0,15465,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1,"",0,0,0,0,0,5,0,0,0,0,0,600,0,0,0,0,8,0,8,0,0,0,3879,0,0,0,0);

If you would like to update use this query
UPDATE items SET field='#' WHERE (field='#');
Field=# means
DisplayID, Entry, name1, etc

If you would like to add a table use,

CREATE TABLE `

The whole code thing is acting up so add CREATE TABLE ` right before item_randomprop_groups

item_randomprop_groups` (`entry_id` int(30)NOT NULL,`randomprops_entryid`int(30)NOTNULL,`chance`float NOTNULL,
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
SET character_set_client = @saved_cs_client;

Again change the item_randomprop_groups to the table you will add to. Same with randomprops.
-Thanks to Gastricpenguin

If you want to create a dump file for your repack I would recommend you to use heidi SQL. You can chose if you want the sql to work with different kinds of mysql. (eg. mysql 5.0)

The sql will take about 5 mins if you have it set to mysql 5.0

If any one else has some thing to contribute then post below and I will add it to the guide.

[Clain]

On the part where you said

Again change the item_randomprop_groups to the table you will add to. Same with randomprops. 
-Thanks to Gastricpenguin

Are you talking about editing the part in red to make your own table or something else? If so, Tables have different structures, so you would need to edit the columns and all that