-
lvl 5 slow mount
Sorry, i know it's a bit lame but i am learning and thought i'd share :)
This is a lvl 5 slow mount that requires no riding skill. it is account bound and seems to work good.
Code:
UPDATE `items` SET `entry` = '888887', `class` = '15', `subclass` = '5', `field4` = '-1', `name1` = 'Palomino mount', `displayid` = '25132', `quality` = '7', `flags` = '0', `faction` = '0', `buyprice` = '0', `sellprice` = '0', `inventorytype` = '0', `allowableclass` = '-1', `allowablerace` = '-1', `itemlevel` = '5', `requiredlevel` = '5', `RequiredSkill` = '0', `RequiredSkillRank` = '0', `RequiredSpell` = '0', `RequiredPlayerRank1` = '0', `RequiredPlayerRank2` = '0', `RequiredFaction` = '0', `RequiredFactionStanding` = '0', `Unique` = '0', `maxcount` = '1', `ContainerSlots` = '0', `itemstatscount` = '10', `stat_type1` = '0', `stat_value1` = '0', `stat_type2` = '0', `stat_value2` = '0', `stat_type3` = '0', `stat_value3` = '0', `stat_type4` = '0', `stat_value4` = '0', `stat_type5` = '0', `stat_value5` = '0', `stat_type6` = '0', `stat_value6` = '0', `stat_type7` = '0', `stat_value7` = '0', `stat_type8` = '0', `stat_value8` = '0', `stat_type9` = '0', `stat_value9` = '0', `stat_type10` = '0', `stat_value10` = '0', `ScaledStatsDistributionId` = '0', `ScaledStatsDistributionFlags` = '0', `dmg_min1` = '0', `dmg_max1` = '0', `dmg_type1` = '0', `dmg_min2` = '0', `dmg_max2` = '0', `dmg_type2` = '0', `armor` = '0', `holy_res` = '0', `fire_res` = '0', `nature_res` = '0', `frost_res` = '0', `shadow_res` = '0', `arcane_res` = '0', `delay` = '0', `ammo_type` = '0', `range` = '0', `spellid_1` = '55884', `spelltrigger_1` = '0', `spellcharges_1` = '0', `spellcooldown_1` = '-1', `spellcategory_1` = '330', `spellcategorycooldown_1` = '3000', `spellid_2` = '471', `spelltrigger_2` = '6', `spellcharges_2` = '0', `spellcooldown_2` = '0', `spellcategory_2` = '0', `spellcategorycooldown_2` = '0', `spellid_3` = '0', `spelltrigger_3` = '0', `spellcharges_3` = '0', `spellcooldown_3` = '-1', `spellcategory_3` = '0', `spellcategorycooldown_3` = '-1', `spellid_4` = '0', `spelltrigger_4` = '0', `spellcharges_4` = '0', `spellcooldown_4` = '-1', `spellcategory_4` = '0', `spellcategorycooldown_4` = '-1', `spellid_5` = '0', `spelltrigger_5` = '0', `spellcharges_5` = '0', `spellcooldown_5` = '-1', `spellcategory_5` = '0', `spellcategorycooldown_5` = '-1', `bonding` = '1', `description` = 'Wanna ride?', `page_id` = '0', `page_language` = '0', `page_material` = '0', `quest_id` = '0', `lock_id` = '0', `lock_material` = '-1', `sheathID` = '0', `randomprop` = '0', `randomsuffix` = '0', `block` = '0', `itemset` = '0', `MaxDurability` = '0', `ZoneNameID` = '0', `mapid` = '0', `bagfamily` = '0', `TotemCategory` = '0', `socket_color_1` = '0', `unk201_3` = '0', `socket_color_2` = '0', `unk201_5` = '0', `socket_color_3` = '0', `unk201_7` = '0', `socket_bonus` = '0', `GemProperties` = '0', `ReqDisenchantSkill` = '-1', `ArmorDamageModifier` = '0', `existingduration` = '0', `ItemLimitCategoryId` = '0', `HolidayId` = '0' WHERE `entry` = 888887 LIMIT 1;
this is the code that my software wrote out, i hope it is right, i'm not sure though since the layout seems wrong....
-
nice thanks, i'll give it a try today
-
sorry, i should have mentioned this is for arcemu.. also i just found out that this is the wrong kind of sql.... this is only for updating an existing entry and not to create one... can any one tell me how to make the write one?
-
-
-
nice! i don't have an arcemu server and i wish i did... but never the less, great find!
-
Nice work :) Gotta start some where hehe +rep for the effort :)
-
Nice that you are learning, editing and playing around in the DB is a great way to start developing! The key to being a good developer is being able to have fun(Even if you don't always have fun).
To make a new item you change "UPDATE" to "INSERT". And the format has to be changed. This is your version.:
Code:
UPDATE `items` SET `entry` = '888887', `class` = '15', `subclass` = '5', `field4` = '-1', `name1` = 'Palomino mount', `displayid` = '25132', `quality` = '7', `flags` = '0', `faction` = '0', `buyprice` = '0', `sellprice` = '0', `inventorytype` = '0', `allowableclass` = '-1', `allowablerace` = '-1', `itemlevel` = '5', `requiredlevel` = '5', `RequiredSkill` = '0', `RequiredSkillRank` = '0', `RequiredSpell` = '0', `RequiredPlayerRank1` = '0', `RequiredPlayerRank2` = '0', `RequiredFaction` = '0', `RequiredFactionStanding` = '0', `Unique` = '0', `maxcount` = '1', `ContainerSlots` = '0', `itemstatscount` = '10', `stat_type1` = '0', `stat_value1` = '0', `stat_type2` = '0', `stat_value2` = '0', `stat_type3` = '0', `stat_value3` = '0', `stat_type4` = '0', `stat_value4` = '0', `stat_type5` = '0', `stat_value5` = '0', `stat_type6` = '0', `stat_value6` = '0', `stat_type7` = '0', `stat_value7` = '0', `stat_type8` = '0', `stat_value8` = '0', `stat_type9` = '0', `stat_value9` = '0', `stat_type10` = '0', `stat_value10` = '0', `ScaledStatsDistributionId` = '0', `ScaledStatsDistributionFlags` = '0', `dmg_min1` = '0', `dmg_max1` = '0', `dmg_type1` = '0', `dmg_min2` = '0', `dmg_max2` = '0', `dmg_type2` = '0', `armor` = '0', `holy_res` = '0', `fire_res` = '0', `nature_res` = '0', `frost_res` = '0', `shadow_res` = '0', `arcane_res` = '0', `delay` = '0', `ammo_type` = '0', `range` = '0', `spellid_1` = '55884', `spelltrigger_1` = '0', `spellcharges_1` = '0', `spellcooldown_1` = '-1', `spellcategory_1` = '330', `spellcategorycooldown_1` = '3000', `spellid_2` = '471', `spelltrigger_2` = '6', `spellcharges_2` = '0', `spellcooldown_2` = '0', `spellcategory_2` = '0', `spellcategorycooldown_2` = '0', `spellid_3` = '0', `spelltrigger_3` = '0', `spellcharges_3` = '0', `spellcooldown_3` = '-1', `spellcategory_3` = '0', `spellcategorycooldown_3` = '-1', `spellid_4` = '0', `spelltrigger_4` = '0', `spellcharges_4` = '0', `spellcooldown_4` = '-1', `spellcategory_4` = '0', `spellcategorycooldown_4` = '-1', `spellid_5` = '0', `spelltrigger_5` = '0', `spellcharges_5` = '0', `spellcooldown_5` = '-1', `spellcategory_5` = '0', `spellcategorycooldown_5` = '-1', `bonding` = '1', `description` = 'Wanna ride?', `page_id` = '0', `page_language` = '0', `page_material` = '0', `quest_id` = '0', `lock_id` = '0', `lock_material` = '-1', `sheathID` = '0', `randomprop` = '0', `randomsuffix` = '0', `block` = '0', `itemset` = '0', `MaxDurability` = '0', `ZoneNameID` = '0', `mapid` = '0', `bagfamily` = '0', `TotemCategory` = '0', `socket_color_1` = '0', `unk201_3` = '0', `socket_color_2` = '0', `unk201_5` = '0', `socket_color_3` = '0', `unk201_7` = '0', `socket_bonus` = '0', `GemProperties` = '0', `ReqDisenchantSkill` = '-1', `ArmorDamageModifier` = '0', `existingduration` = '0', `ItemLimitCategoryId` = '0', `HolidayId` = '0' WHERE `entry` = 888887 LIMIT 1;
This is my version, you can exclude the whole table buildup, but it is good incase your layout is different.
Code:
INSERT INTO items (entry, class, subclass, field4, name1, displayid, quality, flags, buyprice, sellprice, inventorytype, allowableclass, allowablerace, itemlevel, requiredlevel, RequiredSkill, RequiredSkillRank, RequiredSpell, 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, 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, randomsuffix, 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, ArmorDamageModifier, itemstatscount)
VALUES (551212, 15, 5, -1, "Mount for the Little", 25132, 7, 0, 0, 0, 0, 0, -1, -1, 5, 5, 0, 0, 0, 0, 0, 0, 0, 0, 0, 4, 0, 7, 0, 31, 0, 32, 0, 38, 0, 1, 0, 1, 0, 1, 0, 1, 0, 1, 0, 876, 1098, 0, 100, 132, 5, 0, 0, 0, 0, 0, 65, 0, 3600, 0, 0, 0, 0, 0, 0, 0, 0, 30505, 2, 0, 0, 0, 0, 37412, 2, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, "Sleepy?", 0, 0, 0, 0, 0, 1, 1, 0, 0, 0, 0, 200, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 10);
THIS IS NOT A WORKING MOUNT :P