How to make a SQL+More

[LJN]

So you want to make a vendor on wow-v but you can only have up to 6 items and you want more or you need to modify a SQL to work with your DB.

Im going to show you all the SQL forms and how to make them.

This is the item SQL, the only thing that has changed in the new ver. is name1 if you have a older ver. take the 1 out.

TO write a SQL after the VALUES you must type like this...

VALUES ('x', 'x', 'x', 'x,' 'x', 'x,' 'x'); Spaces after each , and have ' between each x

Also

To delete a range of entries or items in a table you can use this format:
DELETE FROM `Table` WHERE `Field` BETWEEN '#min' AND '#max';

One example is: DELETE FROM `items` WHERE `entry` BETWEEN '41025' AND '41049';

If you wanted to update a table or column, you can use this format:
UPDATE `Table` SET `field`='#' WHERE `Field`= '#';

One example would be:
UPDATE `creature_names` SET `rank`='3' WHERE `entry`= '22917';
-From gastricpenguin

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 ((94000,4,3,-1,"Apocalypse","Apocalypse","Apocalypse","Apocalypse",45167,5,0,0000,0000,1,64,-1,100,70,0,0,0,0,0,0,0,0,1,0,4,63,7,65,5,37,31,25,32,32,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,850,15,15,15,15,15,15,0,0,0,18378,1,0,0,0,0,38429,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1,"The veil has been lifted",0,0,0,0,0,5,0,0,0,0,0,95,0,0,0,0,1,0,4,0,4,0,104,0,0,0,0);)

So you got the item SQL but you dont like the Name or Item Display Find so for the name find name1 count how many words there are go down and find VALUES and then count untell you have that same number then change it were it says Apocalypse. Example-


entry(1), class(2), subclass(3), field4(4), name1(5), name2(6), name3(7),

94000(1),4(2),3(3),-1(4),"Apocalypse(5)","Apocalypse(6)","Apocalypse(7)

creature names SQL

INSERT INTO creature_names (entry, name, subname, mouseFlags, Flags1, type, family, rank, unk4, spelldataid, male_displayid, female_displayid, male_displayid2, female_displayid2, unknown_float1, unknown_float2, civilian, leader) VALUES

creature proto

INSERT INTO creature_proto (entry, minlevel, maxlevel, faction, minhealth, maxhealth, mana, scale, npcflags, attacktime, mindamage, maxdamage, rangedattacktime, rangedmindamage, rangedmaxdamage, mountdisplayid, equipmodel1, equipinfo1, equipslot1, equipmodel2, equipinfo2, equipslot2, equipmodel3, equipinfo3, equipslot3, respawntime, armor, resistance1, resistance2, resistance3, resistance4, resistance5, resistance6, combat_reach, bounding_radius, auras, boss, money, invisibility_type, death_state, walk_speed, run_speed, fly_speed, extra_a9_flags) VALUES

Vendor Items.
So you want a Vendor In creature names and proto you must have The NPCflags set to 130 in both or it will not be a vendor.
+do not add to many items to a vendor WoW will crash.

INSERT INTO vendors (entry, item, amount) VALUES

How to set your SQL up.
So your making a Vendor and you have custom items in the SQL you must have the items frist then creature name and then creature proto. Next use the vendor item SQL and your SQL will be fine.

Next there are Tons of SQL's to show but i taught you the basics. Now if you want a SQl go into your DB and select a table.



Now select the table right click and select



Make sure the table is checked



Go into




make sure make sure the export is INSERT
find were you saved it to and you have your SQL that you can use the make New items Game objects Intances++++



Now you made a Obstacle Course and you want to Release it on mmowned. so what you do is find that game object ID that you have in your obstacle course
and use Heidi SQL because it has a search button.
K go to Game Object spawns go to the search box and type that ID in. It should show up with the Game Objects. make sure you have the right GO map location for your obstacle course. Then Export the SQl make sure make sure the export is INSERT.
Then your done.



Sorry if you did not unserstand this SQL is hard to explain.

[Mitchy]

Wow! Great work! Never seen a guide on this, and many people may not understand how to do this

-self-writen
-great explanations
-nice colors
-pictures showing the steps

+Rep Great work!

[Illidan1]

Really nice mate, +Rep x4, (I think i can..)
You must spread some Reputation around before giving it to *Nightmare* again. damn

[iccy]

Wow! Great work! Never seen a guide on this, and many people may not understand how to do this

-self-writen
-great explanations
-nice colors
-pictures showing the steps

+Rep Great work!

yeah very good guide, you deserve +Rep

[Gastricpenguin]

man :P You beat me to writing a SQL guide. Although i would have made it a little differe. Anyway, here are some key points you can add to your guide:

To delete a range of entries or items in a table you can use this format:
DELETE FROM `Table` WHERE `Field` BETWEEN '#min' AND '#max';

One example is: DELETE FROM `items` WHERE `entry` BETWEEN '41025' AND '41049';

If you wanted to update a table or column, you can use this format:
UPDATE `Table` SET `field`='#' WHERE `Field`= '#';

One example would be:
UPDATE `creature_names` SET `rank`='3' WHERE `entry`= '22917';

[LJN]

Ok adding to guide now.

[Xx Killjoy xX]

Awesome guide good job +rep