PDA

View Full Version : lvl 5 slow mount



jagodragon
28-01-10, 12:34 PM
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.

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....

thewhiteboy
28-01-10, 01:13 PM
nice thanks, i'll give it a try today

jagodragon
28-01-10, 03:05 PM
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?

Dimman
28-01-10, 06:02 PM
Nice keep it up :) +rep

jagodragon
28-01-10, 06:46 PM
thanks i intend to :)

colvinjmathew
17-02-10, 09:13 AM
nice! i don't have an arcemu server and i wish i did... but never the less, great find!

ZomgEary
19-02-10, 06:36 PM
Nice work :) Gotta start some where hehe +rep for the effort :)

Fatbeard
19-02-10, 07:20 PM
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.:


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.


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