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