[Sql] Celestial Steed for Mangos servers

[wickedmage]

If your looking for the Celestial Steed i give it to you know here it is you can either download it or you can copy the query for it hope you like it and have fun

MEGAUPLOAD - The leading online storage and file delivery service

INSERT INTO item_template VALUES ('54811','15','5','-1','Celestial Steed','67452','4','32768','0','1','0','0','0','26 2143','32767','20','20','762','75','0','0','0','0' ,'0','0','1','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','0','0','0','0',' 0','0','0','0','0','100','483','0','-1','0','-1','330','3000','75614','6','0','0','-1','0','3000','0','0','0','0','0','0','0','0','0', '0','0','0','0','0','0','0','0','0','0','0','0','0 ','1','Teaches you how to summon this mount.','0','0','0','0','0','7','0','0','0','0','0 ','0','0','0','0','0','0','0','0','0','0','0','0', '0','-1','0','0','0','0','internalitemhandler','0','0',' 0','0');
INSERT INTO `creature_template` (`entry`, `difficulty_entry_1`, `difficulty_entry_2`, `difficulty_entry_3`, `KillCredit1`, `KillCredit2`, `modelid_A`, `modelid_A2`, `modelid_H`, `modelid_H2`, `name`, `subname`, `IconName`, `gossip_menu_id`, `minlevel`, `maxlevel`, `minhealth`, `maxhealth`, `minmana`, `maxmana`, `armor`, `faction_A`, `faction_H`, `npcflag`, `speed_walk`, `speed_run`, `scale`, `rank`, `mindmg`, `maxdmg`, `dmgschool`, `attackpower`, `dmg_multiplier`, `baseattacktime`, `rangeattacktime`, `unit_class`, `unit_flags`, `dynamicflags`, `family`, `trainer_type`, `trainer_spell`, `trainer_class`, `trainer_race`, `minrangedmg`, `maxrangedmg`, `rangedattackpower`, `type`, `type_flags`, `lootid`, `pickpocketloot`, `skinloot`, `resistance1`, `resistance2`, `resistance3`, `resistance4`, `resistance5`, `resistance6`, `spell1`, `spell2`, `spell3`, `spell4`, `PetSpellDataId`, `mingold`, `maxgold`, `AIName`, `MovementType`, `InhabitType`, `unk16`, `unk17`, `RacialLeader`, `questItem1`, `questItem2`, `questItem3`, `questItem4`, `questItem5`, `questItem6`, `movementId`, `RegenHealth`, `equipment_id`, `mechanic_immune_mask`, `flags_extra`, `ScriptName`) VALUES
(40625, 0, 0, 0, 0, 0, 31958, 0, 31958, 0, 'Celestial Steed', '', '', 0, 1, 1, 0, 0, 0, 0, 0, 35, 35, 0, 1, 1.14286, 1, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 12, 0, 0, 0, 0, 0, 0, 0, 1, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '', 0, 3, 1, 1, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, '');

[streetkiller]

Those code boxes are very annoying to read.

[Endedlife]

+rep to whoever explains what all those values mean

[TheSpidey]

This link explains pretty well what each column means
Item template - TCWiki

[wickedmage]

the values i put on here are what you load into your query and execute it so you can use this in your server

---------- Post added at 10:25 PM ---------- Previous post was at 10:24 PM ----------

i put the query in here in case you don't want to download it its much easier just to download it

[Harambeqt]

Goodjob leecing this from Mangos forum.

deservs -rep for not giving creds lol

[wickedmage]

lol thats funny i never got it from mangos...one of my friends gave me the start out code for it

[XxDarkRazielxX]

I need the Scripted for the Celestial Steed.. Can someone also send me a link on where to get quest scripts? I mean I just made a wow server but.. I am lacking.. And I need help.. Please help.. Just links to whatever you think it's best please..

[Kirsebaer]

Would one for Arc :P