lvl 5 slow palomino mout

[jagodragon]

sorry, i'm not sure if this is the right spot or not or even if any one will care 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....

[jagodragon]

after 70+ views i hope some one has tried it atleast...

any ways, 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?

[demerda]

*right one

[Hellgawd]

Remove 'UPDATE' and put 'INSERT INTO'. That's it, and it should (theoretically) work.
This is cool though, never knew there was this mount. +3 rep