[RELEASE] Item Creator for ArcEmu

[zwhit]

Zack's Item Creator V1

Zack's Item Creator is automatic and only works for ArcEmu.

Will make a V2 of MaNGOS soon.

But here's the source code for V1:

@echo off
echo Made by zwhit
if exist %name%.sql del %name%.sql

color 0B
echo.
echo    IMORTANT: Always type something in, if you dont need\want to type 0
echo.
ECHO    Insert please: 
echo.


set /p entry= Desired entry ID (used to spawn): 
set /p name= Name: 
echo.
echo Item Classes
echo.
echo 0    Consumable    
echo 1    Container    
echo 2    Weapon    
echo 3    Jewelry    
echo 4    Armor    
echo 5    Reagent    
echo 6    Projectile    
echo 7    Trade Goods    
echo 8    Generic    
echo 9    Recipe    
echo 10    Money    
echo 11    Quiver    
echo 12    Quest    
echo 13    Key    
echo 14    Permanent    
echo 15    Miscellaneous    
echo.
set /p class= Class (item type): 
echo.
echo Item Subclasses
echo.
echo 0    Axe
echo 1    Two-Handed Axe
echo 2    Bow
echo 3    Gun
echo 4    Mace
echo 5    Two-Handed Mace
echo 6    Polearm
echo 7    Sword
echo 8    Two-Handed Sword
echo 10    Staff
echo 13    Fist
echo 14    Miscellaneous
echo 15    Dagger
echo 16    Thrown
echo 18    Crossbow
echo 19    Wand
echo 20    Fishing Pole
echo.
set /p subclass= SubClass (item type subclass): 
set /p displayid= Display ID (How it Looks): 
set /p quality= Quality (1-5): 
set /p buyprice= Buy Price: 
set /p sellprice= Sell Price: 
set /p inventorytype= Inventory Type (0=none,1=head....etc.): 
echo.
echo Character Classes
echo.
echo 1     Warrior
echo 2     Paladin
echo 3     Hunter
echo 4     Rogue
echo 5     Priest
echo 6     Death Knight
echo 7     Shaman
echo 8     Mage
echo 9     Warlock
echo 11     Druid
echo.
set /p allowableclass= Allowable Class (-1 for all): 
echo.
echo Character Races
echo.
echo 1    Human
echo 2    Orc
echo 3    Dwarf
echo 4    Night Elf
echo 5    Scourge
echo 6    Tauren
echo 7    Gnome
echo 8    Troll
echo 9    Goblin
echo 10    Blood Elf
echo 11    Draenei
echo 12    FelOrc
echo 13    Naga
echo 14    Broken
echo 15    Skeleton
echo 16    Vrykul
echo 17    Tuskarr
echo 18    Forest Troll
echo 19    Taunka
echo 20    Northrend Skeleton
echo 21    Ice Troll
echo.
set /p allowablerace= Allowable Race (-1 for all): 
set /p itemlevel= Item Level (the level of the item): 
set /p requiredlevel= Required Level (Level you have to be to wield): 
set /p requiredskill= Required Skill (skill id): 
set /p requiredskilllvl= Required Skill Level (skill level): 
set /p unique= Unique Equiped (0=can dual wield, 1=can only wield 1): 
set /p maxcount= Maxcount (total amount you can have in your inventory,0=infinite): 
set /p containerslots= Amount of Slots in Bag (only for bags)(1-36): 


echo.
echo Stat Type Values -
echo 0=Mana
echo 1=Health
echo 3=Agility
echo 4=Strength
echo 5=Intellect
echo 6=Spirit
echo 7=Stamina
echo 11=Weapon Skill
echo 12=Defense
echo 13=Dodge
echo 14=Parry
echo 15=Block
echo 16=Melee Hit
echo 17=Range Hit
echo 18=Spell Hit
echo 19=Melee Crit
echo 20=Range Crit
echo 21=Spell Crit
echo 22=Melee Hit Avoid
echo 23=Range Hit Avoid
echo 24=Spell Hit Avoid
echo 22=Melee Crit Avoid
echo 26=Range Crit Avoid
echo 27=Spell Crit Avoid
echo 28=Melee Haste
echo 29=Range Haste
echo 30=Spell Haste
echo 31=Hit Rating
echo 32=Crit Strike
echo 33=Hit Avoid
echo 34=Crit Avoid
echo 35=Resilience
echo 36=Haste
echo 37=Expertise Rating
echo.
echo STATS ARE ALL OPTIONAL
echo.


set /p statt1= Stat Type (1st): 
set /p statv1= Stat Value (1st): 
set /p statt2= Stat Type (2nd): 
set /p statv2= Stat Value (2nd): 
set /p statt3= Stat Type (3rd): 
set /p statv3= Stat Value (3rd): 
set /p statt4= Stat Type (4th): 
set /p statv4= Stat Value (4th): 
set /p statt5= Stat Type (5th): 
set /p statv5= Stat Value (5th): 
set /p statt6= Stat Type (6th): 
set /p statv6= Stat Value (6th): 
set /p statt7= Stat Type (7th): 
set /p statv7= Stat Value (7th): 
set /p statt8= Stat Type (8th): 
set /p statv8= Stat Value (8th): 
set /p statt9= Stat Type (9th): 
set /p statv9= Stat Value (9th): 
set /p statt10= Stat Type (10th): 
set /p statv10= Stat Value (10th): 
set /p dmg_min1= Minimum Damage: 
set /p dmg_max1= Maximum Damage: 


echo.
echo Damage Type Values -
echo 0=normal
echo 1=holy
echo 2=fire
echo 3=nature
echo 4=frost
echo 5=shadow
echo 6=arcane
echo.
echo The Following 3 are only mandatory if you are making a WEAPON
echo if you are not, then skip this whole damage part
echo.


set /p dmg_type1= Damage Type (1st): 
set /p dmg_min1= Minimum Damage (1st): 
set /p dmg_max1= Maximum Damage (1st): 


echo.
echo All the Following Damage Values are optional, if you don't want, then type 0
echo.


set /p dmg_type2= Damage Type (2nd): 
set /p dmg_min2= Minimum Damage (2nd): 
set /p dmg_max2= Maximum Damage (2nd) 
set /p dmg_type3= Damage Type (3rd): 
set /p dmg_min3= Minimum Damage (3rd): 
set /p dmg_max3= Maximum Damage (3rd): 
set /p dmg_type4= Damage Type (4th): 
set /p dmg_min4= Minimum Damage (4th): 
set /p dmg_max4= Maximum Damage (4th): 
set /p dmg_type5= Damage Type (5th): 
set /p dmg_min5= Minimum Damage (5th): 
set /p dmg_max5= Maximum Damage (5th): 
set /p armor= Armor: 
set /p delay= Attack Delay (in millisecs, 1000 = 1 sec): 
set /p ammo_type= Ammo Type (only for ranged weapons): 
set /p range= Range (how far you can attack from): 
set /p holy_res= Holy Resistance: 
set /p fire_res= Fire Resistance: 
set /p nature_res= Nature Resistance: 
set /p frost_res= Frost Resistance: 
set /p shadow_res= Shadow Resistance: 
set /p arcane_res= Arcane Resistance: 


echo.
echo Binding Values -
echo 0=none
echo 1=bind on pickup
echo 2=bind on equip
echo 3=bind on use
echo 4=quest item
echo.


set /p bonding= Binding: 
set /p desc= Description: 
set /p sheath= Sheath (where it is when u aren't wielding it): 
set /p block= Block Value: 
set /p itemset= Itemset: 
set /p maxdurability= Max Durability (0 Never breaks): 
echo.
ECHO 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`, `ScaledStatsDistributionId`, `ScaledStatsDistributionFlags`, `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`, `ReqDisenchantSkill`, `unk2`, `ItemLimitCategoryId`) VALUES ('%entry%', %class%, %subclass%, -1, '%name%', '', '', '', '%displayid%', %quality%, 0, %buyprice%, %sellprice%, %inventorytype%, %allowableClass%, %allowableRace%, %itemlevel%, %requiredlevel%, %requiredskill%, %requiredskilllvl%, 0, 0, 0, 0, 0, %unique%, %maxcount%, %containerslots%, %statt1%, %statv1%, %statt2%, %statv2%, %statt3%, %statv3%, %statt4%, %statv4%, %statt5%, %statv5%, %statt6%, %statv6%, %statt7%, %statv7%, %statt8%, %statv8%, %statt9%, %statv9%, %statt10%, %statv10%, '0', '0', '%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%', 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, %bonding%, '%desc%', 0, 0, 0, 0, 0, 0, %sheath%, 0, 0, %block%, %itemset%, %maxdurability%, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, -1, 0, '0');>>%name%.sql
echo.
echo.
echo Collected info: 
echo.
echo Entry: %entry%
echo Name: %name%
echo class: %class%
echo Subclass: %subclass%
echo Display ID: %displayid%
echo Quality: %quiality%
echo Buy Price: %buyprice%
echo Sell Price: %sellprice%
echo Inventory Type: %inventorytype%
echo Allowable Class: %allowableclass%
echo Allowable Race: %allowablerace%
echo Item Level: %itemlevel%
echo Required Level: %requiredlevel%
echo Required Skill: %requiredskill%
echo Required Skill Levelup: %requiredskilllvl%
echo Unique: %unique%
echo Maxcount: %maxcount%
echo Container Slots: %containerslots%
echo Stat Type (1st): %statt1%
echo Stat Value (1st): %statv1%
echo Stat Type (2nd): %statt2%
echo Stat Value (2nd): %statv2%
echo Stat Type (3rd): %statt3%
echo Stat Value (3rd): %statv3%
echo Stat Type (4th): %statt4%
echo Stat Value (4th): %statv4%
echo Stat Type (5th): %statt5%
echo Stat Value (5th): %statv5%
echo Stat Type (6th): %statt6%
echo Stat Value (6th): %statv6%
echo Stat Type (7th): %statt7%
echo Stat Value (7th): %statv7%
echo Stat Type (8th): %statt8%
echo Stat Value (8th): %statv8%
echo Stat Type (9th): %statt9%
echo Stat Value (9th): %statv9%
echo Stat Type (10th): %statt10%
echo Stat Value (10th): %statv10%
echo Damage Type (1st): %dmg_type1%
echo Damage Minimum (1st): %dmg_min1%
echo Damage Maximum (1st): %dmg_max1%
echo Damage Type (2nd): %dmg_type1%
echo Damage Minimum (2nd): %dmg_min1%
echo Damage Maximum (2nd): %dmg_max1%
echo Damage Type (3rd): %dmg_type1%
echo Damage Minimum (3rd): %dmg_min1%
echo Damage Maximum (3rd): %dmg_max1%
echo Damage Type (4th): %dmg_type1%
echo Damage Minimum (4th): %dmg_min1%
echo Damage Maximum (4th): %dmg_max1%
echo Damage Type (5th): %dmg_type1%
echo Damage Minimum (5th): %dmg_min1%
echo Damage Maximum (5th): %dmg_max1%
echo Armor: %armor%
echo Delay: %delay%
echo Ammo Type: %ammo_type%
echo Range: %range%
echo Holy Resistance: %holy_res%
echo Fire Resistance: %fire_res%
echo Nature Resistance: %nature_res%
echo Frost Resistance: %frost_res%
echo Shadow Resistance: %shadow_res%
echo Arcane Resistance: %arcane_res%
echo Binding: %bonding%
echo Sheath: %sheath%
echo Block: %block%
echo Itemset: %itemset%
echo Max Durability: %MaxDurability%
echo.
echo.
echo.


echo Press Enter To Create.
pause


Echo Building...


echo.
echo If any errors make sure you put info in right and not to high!
echo.
echo.
ECHO Done.
echo.
echo Made by zwhit

pause

Copy and paste this code into notepad and save as Item Creator.bat, then run it. Make sure MySQL is running.
I'm not sure if my V1 will work for your database or not.

Or here's the download:
Item Creator.bat


REMEMBER: THIS ONLY WORKS FOR ArcEmu AT THE MOMENT!

[Jonthe838]

does this work or is this a virus like some of the others? :P

[zwhit]

No, it isnt a virus, :P.
I made it myself from scratch.

[zwhit]

And yes it should work.

Worked for me.

[Blackboy0]

Good job
+Rep from me!

[zwhit]

Thanks dude!

wewts first +rep

[Blackboy0]

Glad to be of service.

[Ground Zero]

Silly Leecher....
This is a repost of rofldestroyers with the EXACT Same source.
http://www.mmowned.com/forums/emulat...m-creator.html
Do not steal other peoples work.

@echo off
echo Made by Rofldestroyer
if exist %name%.sql del %name%.sql

color 0B
echo.
echo    IMORTANT: Always type something in, if you dont need\want to type 0
echo.
ECHO    Insert please: 
echo.


set /p entry= Desired entry ID (used to spawn): 
set /p name= Name: 
echo.
echo Item Classes
echo.
echo 0    Consumable    
echo 1    Container    
echo 2    Weapon    
echo 3    Jewelry    
echo 4    Armor    
echo 5    Reagent    
echo 6    Projectile    
echo 7    Trade Goods    
echo 8    Generic    
echo 9    Recipe    
echo 10    Money    
echo 11    Quiver    
echo 12    Quest    
echo 13    Key    
echo 14    Permanent    
echo 15    Miscellaneous    
echo.
set /p class= Class (item type): 
echo.
echo Item Subclasses
echo.
echo 0    Axe
echo 1    Two-Handed Axe
echo 2    Bow
echo 3    Gun
echo 4    Mace
echo 5    Two-Handed Mace
echo 6    Polearm
echo 7    Sword
echo 8    Two-Handed Sword
echo 10    Staff
echo 13    Fist
echo 14    Miscellaneous
echo 15    Dagger
echo 16    Thrown
echo 18    Crossbow
echo 19    Wand
echo 20    Fishing Pole
echo.
set /p subclass= SubClass (item type subclass): 
set /p displayid= Display ID (How it Looks): 
set /p quality= Quality (1-5): 
set /p buyprice= Buy Price: 
set /p sellprice= Sell Price: 
set /p inventorytype= Inventory Type (0=none,1=head....etc.): 
echo.
echo Character Classes
echo.
echo 1     Warrior
echo 2     Paladin
echo 3     Hunter
echo 4     Rogue
echo 5     Priest
echo 6     Death Knight
echo 7     Shaman
echo 8     Mage
echo 9     Warlock
echo 11     Druid
echo.
set /p allowableclass= Allowable Class (-1 for all): 
echo.
echo Character Races
echo.
echo 1    Human
echo 2    Orc
echo 3    Dwarf
echo 4    Night Elf
echo 5    Scourge
echo 6    Tauren
echo 7    Gnome
echo 8    Troll
echo 9    Goblin
echo 10    Blood Elf
echo 11    Draenei
echo 12    FelOrc
echo 13    Naga
echo 14    Broken
echo 15    Skeleton
echo 16    Vrykul
echo 17    Tuskarr
echo 18    Forest Troll
echo 19    Taunka
echo 20    Northrend Skeleton
echo 21    Ice Troll
echo.
set /p allowablerace= Allowable Race (-1 for all): 
set /p itemlevel= Item Level (the level of the item): 
set /p requiredlevel= Required Level (Level you have to be to wield): 
set /p requiredskill= Required Skill (skill id): 
set /p requiredskilllvl= Required Skill Level (skill level): 
set /p unique= Unique Equiped (0=can dual wield, 1=can only wield 1): 
set /p maxcount= Maxcount (total amount you can have in your inventory,0=infinite): 
set /p containerslots= Amount of Slots in Bag (only for bags)(1-36): 


echo.
echo Stat Type Values -
echo 0=Mana
echo 1=Health
echo 3=Agility
echo 4=Strength
echo 5=Intellect
echo 6=Spirit
echo 7=Stamina
echo 11=Weapon Skill
echo 12=Defense
echo 13=Dodge
echo 14=Parry
echo 15=Block
echo 16=Melee Hit
echo 17=Range Hit
echo 18=Spell Hit
echo 19=Melee Crit
echo 20=Range Crit
echo 21=Spell Crit
echo 22=Melee Hit Avoid
echo 23=Range Hit Avoid
echo 24=Spell Hit Avoid
echo 22=Melee Crit Avoid
echo 26=Range Crit Avoid
echo 27=Spell Crit Avoid
echo 28=Melee Haste
echo 29=Range Haste
echo 30=Spell Haste
echo 31=Hit Rating
echo 32=Crit Strike
echo 33=Hit Avoid
echo 34=Crit Avoid
echo 35=Resilience
echo 36=Haste
echo 37=Expertise Rating
echo.
echo STATS ARE ALL OPTIONAL
echo.


set /p statt1= Stat Type (1st): 
set /p statv1= Stat Value (1st): 
set /p statt2= Stat Type (2nd): 
set /p statv2= Stat Value (2nd): 
set /p statt3= Stat Type (3rd): 
set /p statv3= Stat Value (3rd): 
set /p statt4= Stat Type (4th): 
set /p statv4= Stat Value (4th): 
set /p statt5= Stat Type (5th): 
set /p statv5= Stat Value (5th): 
set /p statt6= Stat Type (6th): 
set /p statv6= Stat Value (6th): 
set /p statt7= Stat Type (7th): 
set /p statv7= Stat Value (7th): 
set /p statt8= Stat Type (8th): 
set /p statv8= Stat Value (8th): 
set /p statt9= Stat Type (9th): 
set /p statv9= Stat Value (9th): 
set /p statt10= Stat Type (10th): 
set /p statv10= Stat Value (10th): 
set /p dmg_min1= Minimum Damage: 
set /p dmg_max1= Maximum Damage: 


echo.
echo Damage Type Values -
echo 0=normal
echo 1=holy
echo 2=fire
echo 3=nature
echo 4=frost
echo 5=shadow
echo 6=arcane
echo.
echo The Following 3 are only mandatory if you are making a WEAPON
echo if you are not, then skip this whole damage part
echo.


set /p dmg_type1= Damage Type (1st): 
set /p dmg_min1= Minimum Damage (1st): 
set /p dmg_max1= Maximum Damage (1st): 


echo.
echo All the Following Damage Values are optional, if you don't want, then type 0
echo.


set /p dmg_type2= Damage Type (2nd): 
set /p dmg_min2= Minimum Damage (2nd): 
set /p dmg_max2= Maximum Damage (2nd) 
set /p dmg_type3= Damage Type (3rd): 
set /p dmg_min3= Minimum Damage (3rd): 
set /p dmg_max3= Maximum Damage (3rd): 
set /p dmg_type4= Damage Type (4th): 
set /p dmg_min4= Minimum Damage (4th): 
set /p dmg_max4= Maximum Damage (4th): 
set /p dmg_type5= Damage Type (5th): 
set /p dmg_min5= Minimum Damage (5th): 
set /p dmg_max5= Maximum Damage (5th): 
set /p armor= Armor: 
set /p delay= Attack Delay (in millisecs, 1000 = 1 sec): 
set /p ammo_type= Ammo Type (only for ranged weapons): 
set /p range= Range (how far you can attack from): 
set /p holy_res= Holy Resistance: 
set /p fire_res= Fire Resistance: 
set /p nature_res= Nature Resistance: 
set /p frost_res= Frost Resistance: 
set /p shadow_res= Shadow Resistance: 
set /p arcane_res= Arcane Resistance: 


echo.
echo Binding Values -
echo 0=none
echo 1=bind on pickup
echo 2=bind on equip
echo 3=bind on use
echo 4=quest item
echo.


set /p bonding= Binding: 
set /p desc= Description: 
set /p sheath= Sheath (where it is when u aren't wielding it): 
set /p block= Block Value: 
set /p itemset= Itemset: 
set /p maxdurability= Max Durability (0 Never breaks): 
echo.
ECHO 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`, `ScaledStatsDistributionId`, `ScaledStatsDistributionFlags`, `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`, `ReqDisenchantSkill`, `unk2`, `ItemLimitCategoryId`) VALUES ('%entry%', %class%, %subclass%, -1, '%name%', '', '', '', '%displayid%', %quality%, 0, %buyprice%, %sellprice%, %inventorytype%, %allowableClass%, %allowableRace%, %itemlevel%, %requiredlevel%, %requiredskill%, %requiredskilllvl%, 0, 0, 0, 0, 0, %unique%, %maxcount%, %containerslots%, %statt1%, %statv1%, %statt2%, %statv2%, %statt3%, %statv3%, %statt4%, %statv4%, %statt5%, %statv5%, %statt6%, %statv6%, %statt7%, %statv7%, %statt8%, %statv8%, %statt9%, %statv9%, %statt10%, %statv10%, '0', '0', '%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%', 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, %bonding%, '%desc%', 0, 0, 0, 0, 0, 0, %sheath%, 0, 0, %block%, %itemset%, %maxdurability%, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, -1, 0, '0');>>%name%.sql
echo.
echo.
echo Collected info: 
echo.
echo Entry: %entry%
echo Name: %name%
echo class: %class%
echo Subclass: %subclass%
echo Display ID: %displayid%
echo Quality: %quiality%
echo Buy Price: %buyprice%
echo Sell Price: %sellprice%
echo Inventory Type: %inventorytype%
echo Allowable Class: %allowableclass%
echo Allowable Race: %allowablerace%
echo Item Level: %itemlevel%
echo Required Level: %requiredlevel%
echo Required Skill: %requiredskill%
echo Required Skill Levelup: %requiredskilllvl%
echo Unique: %unique%
echo Maxcount: %maxcount%
echo Container Slots: %containerslots%
echo Stat Type (1st): %statt1%
echo Stat Value (1st): %statv1%
echo Stat Type (2nd): %statt2%
echo Stat Value (2nd): %statv2%
echo Stat Type (3rd): %statt3%
echo Stat Value (3rd): %statv3%
echo Stat Type (4th): %statt4%
echo Stat Value (4th): %statv4%
echo Stat Type (5th): %statt5%
echo Stat Value (5th): %statv5%
echo Stat Type (6th): %statt6%
echo Stat Value (6th): %statv6%
echo Stat Type (7th): %statt7%
echo Stat Value (7th): %statv7%
echo Stat Type (8th): %statt8%
echo Stat Value (8th): %statv8%
echo Stat Type (9th): %statt9%
echo Stat Value (9th): %statv9%
echo Stat Type (10th): %statt10%
echo Stat Value (10th): %statv10%
echo Damage Type (1st): %dmg_type1%
echo Damage Minimum (1st): %dmg_min1%
echo Damage Maximum (1st): %dmg_max1%
echo Damage Type (2nd): %dmg_type1%
echo Damage Minimum (2nd): %dmg_min1%
echo Damage Maximum (2nd): %dmg_max1%
echo Damage Type (3rd): %dmg_type1%
echo Damage Minimum (3rd): %dmg_min1%
echo Damage Maximum (3rd): %dmg_max1%
echo Damage Type (4th): %dmg_type1%
echo Damage Minimum (4th): %dmg_min1%
echo Damage Maximum (4th): %dmg_max1%
echo Damage Type (5th): %dmg_type1%
echo Damage Minimum (5th): %dmg_min1%
echo Damage Maximum (5th): %dmg_max1%
echo Armor: %armor%
echo Delay: %delay%
echo Ammo Type: %ammo_type%
echo Range: %range%
echo Holy Resistance: %holy_res%
echo Fire Resistance: %fire_res%
echo Nature Resistance: %nature_res%
echo Frost Resistance: %frost_res%
echo Shadow Resistance: %shadow_res%
echo Arcane Resistance: %arcane_res%
echo Binding: %bonding%
echo Sheath: %sheath%
echo Block: %block%
echo Itemset: %itemset%
echo Max Durability: %MaxDurability%
echo.
echo.
echo.


echo Press Enter To Create.
pause


Echo Building...


echo.
echo If any errors make sure you put info in right and not to high!
echo.
echo.
ECHO Done.
echo.
echo Made by Rofldestroyer
pause

[bsod-staff14]

Yea true at least edit it so its not as noticible.

[rofldestroyer]

you fail.... because u leeched mine... noob

and for everyone else that didn't im going to release my mangos version soon
and can someone tell me the mangos column and antrix columns so i can make it for those?