Fellria

Sice už se v tomdle nehrabu,ale trochu ti pomůžu. Nejdřžív si přes DB editor najdeš vehicle.dbc a otevřeš.V prvnim řádku v DBC editoru máš čísla:1,6,7,8....,tak to číslo přidej do vehicle data jako entry(flags nevim,ale dával sem 12 nebo 24 a spelly sou snad jasný.) Pak insertni record do vehicle seat data.V entry bude číslo ze 7mí tabulky v DBC editoru,takže pokud máš ID 1 ve vehicle data,tak pak ve vehicle seat data budeš mít entry 121(flags sem většinou dával 3) Dál si otevři creature template addon a pokud tam ještě nemáš záznam o npc,který chceš,aby byl vehicle,tak tam insertni novej record a do vehicle ID zadej entry z vehicle data a ulož. A teď už poslední věc.Otevři si npc spellclick spells.Do npc entry zadáš ID creatury,která má být vehicle.Do spell id zadej např. todle:60968(nebo jinej spell,co je na nasednutí)quest start/end/active je snad jasný a do cast flags zadej 1. Každy vehicle data maj jiný vlastnosti,takže pokud bude nějakej vadnej,tak zkus jiný ID.(nějaký má zaměřování nebo se s nim nedá otáčet atd.,takže je jich popřípadě třeba ozkoušet víc) Pokud by ti to stále nešlo,tak mi napiš na skype.

Přes EventAI jdou fáze udělat taky,ale nejjednodušší to máš,když mu dáš spelly z phasu 1 třeba do 75% života.Spelly,co má mít v phasu 2 do 40% života a spelly v phasu 3 do 0%,ale pokud to chceš přes ty fáze a máš aspon začáteční znalost EAI,tak bych ti s tim mohl pomoct.ICQ mam v profilu

Oprava Eye of Acherus,aby do něj po kliknutí šlo nasednout Je dobré mít i patch,který boužel nemam a nechci ho hledat,ale SQL oprava je zde. INSERT INTO `vehicle_seat_data` (`seat`,`flags`) VALUES ('261','3') INSERT INTO `vehicle_data` (`entry`,`flags`,`Spell1`,`Spell2`,`Spell3`,`Spell4`,`Spell5`,`Spell6`,`Spell7`,`Spell8`,`Spell9`,`Spell10`,`req_aura`) VALUES ('8','24','51859','54522','52006','51887','0','0','0','0','0','0','0') INSERT INTO `creature_template_addon` (`entry`,`mount`,`bytes1`,`bytes2`,`emote`,`moveflags`,`vehicle_id`,`passengers`,`auras`) VALUES ('28511','0','0','0','0','33562624','8','','') INSERT INTO `npc_spellclick_spells` (`npc_entry`,`spell_id`,`quest_start`,`quest_start_active`,`quest_end`,`cast_flags`) VALUES ('28511','52196','0','0','0','1') _________________

moje SQL oprava Gossip menu option INSERT INTO `gossip_menu_option` (`menu_id`,`id`,`option_text`,`option_id`,`npc_option_npcflag`,`action_script_id`) VALUES ('65525','0','I\'m ready to fight!','1','1','336695') INSERT INTO `gossip_menu_option` (`menu_id`,`id`,`option_text`,`option_id`,`npc_option_npcflag`,`action_script_id`) VALUES ('65526','0','I\'m ready to fight!','1','1','336696') INSERT INTO `gossip_menu_option` (`menu_id`,`id`,`option_text`,`option_id`,`npc_option_npcflag`,`action_script_id`) VALUES ('65527','0','I am ready to fight!','1','1','336697') INSERT INTO `gossip_menu_option` (`menu_id`,`id`,`option_text`,`option_id`,`npc_option_npcflag`,`action_script_id`) VALUES ('65528','0','I\'m ready to fight!','1','1','336698') INSERT INTO `gossip_menu_option` (`menu_id`,`id`,`option_text`,`option_id`,`npc_option_npcflag`,`action_script_id`) VALUES ('65529','0','I\'m ready to fight','1','1','336699') Gossip scripts INSERT INTO `gossip_scripts` (`id`,`delay`,`command`,`datalong`,`datalong2`,`dataint`,`x`,`y`,`z`,`o`) VALUES ('336696','3','10','336696','300000','0','8336.29','720.436','553.701','0.22') INSERT INTO `gossip_scripts` (`id`,`delay`,`command`,`datalong`,`datalong2`,`dataint`,`x`,`y`,`z`,`o`) VALUES ('336697','3','10','336697','300000','0','8336.29','720.436','553.701','0.22') INSERT INTO `gossip_scripts` (`id`,`delay`,`command`,`datalong`,`datalong2`,`dataint`,`x`,`y`,`z`,`o`) VALUES ('336698','3','10','336698','300000','0','8336.29','720.436','553.701','0.22') INSERT INTO `gossip_scripts` (`id`,`delay`,`command`,`datalong`,`datalong2`,`x`,`y`,`z`,`o`) VALUES ('336699','3','10','336699','300000','8336.29','720.436','553.701','0.22') INSERT INTO `gossip_scripts` (`id`,`delay`,`command`,`datalong`,`datalong2`,`dataint`,`x`,`y`,`z`,`o`) VALUES ('336695','3','10','336695','300000','0','8336.29','720.436','553.701','0.22') NPC: REPLACE 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 (336699, 0, 0, 0, 96369, 0, 28856, 0, 28856, 0, 'Undercity Valiant', '', '', 0, 80, 80, 50000, 50000, 0, 0, 9730, 25, 25, 0, 1, 1.14286, 1, 0, 420, 630, 0, 157, 1, 2000, 2000, 1, 0, 0, 0, 0, 0, 0, 0, 336, 504, 126, 10, 2048, 0, 0, 0, 0, 0, 0, 0, 0, 0, 63010, 65147, 0, 0, 0, 0, 0, '', 0, 3, 3.96825, 1, 0, 0, 0, 0, 0, 0, 0, 48, 1, 1900, 0, 2, 'generic_creature'); REPLACE 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 (336698, 0, 0, 0, 96369, 0, 28851, 0, 28851, 0, 'Orgrimmar Valiant', '', '', 0, 80, 80, 50000, 50000, 0, 0, 9730, 25, 25, 0, 1, 1.14286, 1, 0, 420, 630, 0, 157, 1, 2000, 2000, 1, 0, 0, 0, 0, 0, 0, 0, 336, 504, 126, 10, 2048, 0, 0, 0, 0, 0, 0, 0, 0, 0, 63010, 65147, 0, 0, 0, 0, 0, '', 0, 3, 3.96825, 1, 0, 0, 0, 0, 0, 0, 0, 0, 1, 1891, 0, 2, 'generic_creature'); REPLACE 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 (336697, 0, 0, 0, 96369, 0, 28855, 0, 28855, 0, 'Thunder Bluff Valiant', '', '', 0, 80, 80, 50000, 50000, 0, 0, 9730, 25, 25, 0, 1, 1.14286, 1, 0, 420, 630, 0, 157, 1, 2000, 2000, 1, 0, 0, 0, 0, 0, 0, 0, 336, 504, 126, 10, 2048, 0, 0, 0, 0, 0, 0, 0, 0, 0, 63010, 65147, 0, 0, 0, 0, 0, '', 0, 3, 3.96825, 1, 0, 0, 0, 0, 0, 0, 0, 76, 1, 1899, 0, 2, 'generic_creature'); REPLACE 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 (336696, 0, 0, 0, 96369, 0, 28853, 0, 28853, 0, 'Silvermoon Valiant', '', '', 0, 80, 80, 50000, 50000, 0, 0, 9730, 25, 25, 0, 1, 1.14286, 1, 0, 420, 630, 0, 157, 1, 2000, 2000, 1, 0, 0, 0, 0, 0, 0, 0, 336, 504, 126, 10, 2048, 0, 0, 0, 0, 0, 0, 0, 0, 0, 63010, 65147, 0, 0, 0, 0, 0, '', 0, 3, 3.96825, 1, 0, 0, 0, 0, 0, 0, 0, 48, 1, 1898, 0, 2, 'generic_creature'); REPLACE 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 (336695, 0, 0, 0, 96369, 0, 28852, 0, 28852, 0, 'Sen\'jin Valiant', '', '', 0, 80, 80, 50000, 50000, 0, 0, 9730, 25, 25, 0, 1, 1.14286, 1, 0, 420, 630, 0, 157, 1, 2000, 2000, 1, 0, 0, 0, 0, 0, 0, 0, 336, 504, 126, 10, 2048, 0, 0, 0, 0, 0, 0, 0, 0, 0, 63010, 65147, 0, 0, 0, 0, 0, '', 0, 3, 3.96825, 1, 0, 0, 0, 0, 0, 0, 0, 48, 1, 1890, 0, 2, 'generic_creature'); REPLACE 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 (36963, 0, 0, 0, 0, 0, 23179, 0, 23186, 0, 'Valiant of one capital city defeated!', '', '', 0, 1, 1, 1, 1, 0, 0, 17, 35, 35, 0, 1, 1.14286, 1, 0, 1, 2, 0, 0, 1, 2000, 2000, 1, 0, 0, 0, 0, 0, 0, 0, 1, 2, 0, 7, 0, 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, ''); INSERT INTO `creature_template_addon` (`entry`,`mount`,`bytes1`,`bytes2`,`emote`,`moveflags`,`vehicle_id`,`passengers`,`auras`) VALUES ('336698','14335','0','0','0','0','0','','63432 0') INSERT INTO `creature_template_addon` (`entry`,`mount`,`bytes1`,`bytes2`,`emote`,`moveflags`,`vehicle_id`,`passengers`,`auras`) VALUES ('336695','14343','0','1','0','0','0','','64723 0') INSERT INTO `creature_template_addon` (`entry`,`mount`,`bytes1`,`bytes2`,`emote`,`moveflags`,`vehicle_id`,`passengers`,`auras`) VALUES ('336699','28605','0','0','0','0','0','','63429 0') INSERT INTO `creature_template_addon` (`entry`,`mount`,`bytes1`,`bytes2`,`emote`,`moveflags`,`vehicle_id`,`passengers`,`auras`) VALUES ('336697','28556','0','0','0','0','0','','63435 0') INSERT INTO `creature_template_addon` (`entry`,`mount`,`bytes1`,`bytes2`,`emote`,`moveflags`,`vehicle_id`,`passengers`,`auras`) VALUES ('336696','28607','0','0','0','0','0','','63402 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 (996633, 0, 0, 0, 0, 0, 28955, 0, 28955, 0, 'Darnassus Valiant', '', '', 10457, 80, 80, 50000, 50000, 0, 0, 9730, 21, 21, 1, 1, 1.14286, 1, 0, 420, 630, 0, 157, 1, 2000, 2000, 1, 2, 0, 0, 0, 0, 0, 0, 336, 504, 126, 10, 2048, 0, 0, 0, 0, 0, 0, 0, 0, 0, 63010, 65147, 0, 0, 0, 0, 0, '', 0, 3, 3.96825, 1, 0, 0, 0, 0, 0, 0, 0, 48, 1, 1911, 0, 0, 'generic_creature'); Kód: INSERT INTO `gossip_menu_option` (`menu_id`,`id`,`option_icon`,`option_text`,`option_id`,`npc_option_npcflag`,`action_menu_id`,`action_poi_id`,`action_script_id`,`box_coded`,`box_money`,`box_text`,`cond_1`,`cond_1_val_1`,`cond_1_val_2`,`cond_2`,`cond_2_val_1`,`cond_2_val_2`,`cond_3`,`cond_3_val_1`,`cond_3_val_2`) VALUES ('10457','0','0','I\'am ready for fight!','1','1','0','0','10457','0','0','','0','0','0','0','0','0','0','0','0') Kód: 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 (996632, 0, 0, 0, 0, 0, 28854, 0, 28854, 0, 'Stormwind Valiant', '', '', 10464, 80, 80, 50000, 50000, 0, 0, 9730, 21, 21, 1, 1, 1.14286, 1, 0, 420, 630, 0, 157, 1, 2000, 2000, 1, 0, 0, 0, 0, 0, 0, 0, 336, 504, 126, 10, 2048, 0, 0, 0, 0, 0, 0, 0, 0, 0, 63010, 65147, 0, 0, 0, 0, 0, '', 0, 3, 3.96825, 1, 0, 0, 0, 0, 0, 0, 0, 0, 1, 1912, 0, 2, 'generic_creature'); Kód: INSERT INTO `gossip_menu_option` (`menu_id`,`id`,`option_icon`,`option_text`,`option_id`,`npc_option_npcflag`,`action_menu_id`,`action_poi_id`,`action_script_id`,`box_coded`,`box_money`,`box_text`,`cond_1`,`cond_1_val_1`,`cond_1_val_2`,`cond_2`,`cond_2_val_1`,`cond_2_val_2`,`cond_3`,`cond_3_val_1`,`cond_3_val_2`) VALUES ('10464','0','0','I\'am ready for fight!','1','1','0','0','10464','0','0','','0','0','0','0','0','0','0','0','0') Kód: INSERT INTO `gossip_menu_option` (`menu_id`,`id`,`option_icon`,`option_text`,`option_id`,`npc_option_npcflag`,`action_menu_id`,`action_poi_id`,`action_script_id`,`box_coded`,`box_money`,`box_text`,`cond_1`,`cond_1_val_1`,`cond_1_val_2`,`cond_2`,`cond_2_val_1`,`cond_2_val_2`,`cond_3`,`cond_3_val_1`,`cond_3_val_2`) VALUES ('65534','0','0','I\'am ready for fight!','1','1','0','0','996631','0','0','','0','0','0','0','0','0','0','0','0') Kód: REPLACE 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 (996631, 0, 0, 0, 0, 0, 28848, 0, 28848, 0, 'Exodar Valiant', '', '', 65534, 80, 80, 50000, 50000, 0, 0, 9730, 35, 21, 1, 1, 1.14286, 1, 0, 420, 630, 0, 157, 1, 2000, 2000, 1, 0, 0, 0, 0, 0, 0, 0, 336, 504, 126, 10, 2048, 0, 0, 0, 0, 0, 0, 0, 0, 0, 63010, 65147, 0, 0, 0, 0, 0, '', 0, 3, 3.96825, 1, 0, 0, 0, 0, 0, 0, 0, 76, 1, 1913, 0, 2, 'generic_creature'); Kód: REPLACE 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 (996630, 0, 0, 0, 0, 0, 28849, 0, 28849, 0, 'Gnomeregan Valiant', '', '', 65535, 80, 80, 50000, 50000, 0, 0, 9730, 35, 21, 1, 1, 1.14286, 1, 0, 420, 630, 0, 157, 1, 2000, 2000, 1, 0, 0, 0, 0, 0, 0, 0, 336, 504, 126, 10, 2048, 0, 0, 0, 0, 0, 0, 0, 0, 0, 63010, 65147, 0, 0, 0, 0, 0, '', 0, 3, 3.96825, 1, 0, 0, 0, 0, 0, 0, 0, 48, 1, 1910, 0, 2, 'generic_creature'); Kód: INSERT INTO `gossip_menu_option` (`menu_id`,`id`,`option_icon`,`option_text`,`option_id`,`npc_option_npcflag`,`action_menu_id`,`action_poi_id`,`action_script_id`,`box_coded`,`box_money`,`box_text`,`cond_1`,`cond_1_val_1`,`cond_1_val_2`,`cond_2`,`cond_2_val_1`,`cond_2_val_2`,`cond_3`,`cond_3_val_1`,`cond_3_val_2`) VALUES ('65533','0','0','I\'am ready for fight!','1','1','0','0','996630','0','0','','0','0','0','0','0','0','0','0','0') Kód: INSERT INTO `gossip_menu_option` (`menu_id`,`id`,`option_icon`,`option_text`,`option_id`,`npc_option_npcflag`,`action_menu_id`,`action_poi_id`,`action_script_id`,`box_coded`,`box_money`,`box_text`,`cond_1`,`cond_1_val_1`,`cond_1_val_2`,`cond_2`,`cond_2_val_1`,`cond_2_val_2`,`cond_3`,`cond_3_val_1`,`cond_3_val_2`) VALUES ('65532','0','0','I\'am ready for fight!','1','1','0','0','996644','0','0','','0','0','0','0','0','0','0','0','0') Kód: REPLACE 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 (996644, 0, 0, 0, 0, 0, 28850, 0, 28850, 0, 'Ironforge Valiant', '', '', 65532, 80, 80, 50000, 50000, 0, 0, 9730, 35, 21, 1, 1, 1.14286, 1, 0, 420, 630, 0, 157, 1, 2000, 2000, 1, 0, 0, 0, 0, 0, 0, 0, 336, 504, 126, 10, 2048, 0, 0, 0, 0, 0, 0, 0, 0, 0, 63010, 65147, 0, 0, 0, 0, 0, '', 0, 3, 3.96825, 1, 0, 0, 0, 0, 0, 0, 0, 48, 1, 1914, 0, 2, 'generic_creature'); _________________ Nahoru Fellria Předmět příspěvku: Re: The Grand melee-aliNapsal: stř 26. kvě 2010 14:05:35 Game Master Registrován: pon 01. bře 2010 13:15:40 Příspěvky: 83 gossip scripts Kód: INSERT INTO `gossip_scripts` (`id`,`delay`,`command`,`datalong`,`datalong2`,`dataint`,`x`,`y`,`z`,`o`) VALUES ('996644','3','10','996644','300000','0','8659.29','722.92','547.96','2.87') Kód: INSERT INTO `gossip_scripts` (`id`,`delay`,`command`,`datalong`,`datalong2`,`dataint`,`x`,`y`,`z`,`o`) VALUES ('996630','3','10','996630','300000','0','8659.29','722.92','547.96','2.87') Kód: INSERT INTO `gossip_scripts` (`id`,`delay`,`command`,`datalong`,`datalong2`,`dataint`,`x`,`y`,`z`,`o`) VALUES ('996631','3','10','996631','300000','0','8659.29','722.92','547.96','2.87') Kód: INSERT INTO `gossip_scripts` (`id`,`delay`,`command`,`datalong`,`datalong2`,`dataint`,`x`,`y`,`z`,`o`) VALUES ('10464','3','10','996633','300000','0','8659.29','722.92','547.96','2.87') Kód: INSERT INTO `gossip_scripts` (`id`,`delay`,`command`,`datalong`,`datalong2`,`dataint`,`x`,`y`,`z`,`o`) VALUES ('10457','3','10','996632','300000','0','8659.29','722.92','547.52','2.87') _________________ Nahoru Fellria Předmět příspěvku: Re: The Grand melee-aliNapsal: stř 26. kvě 2010 14:19:58 Game Master Registrován: pon 01. bře 2010 13:15:40 Příspěvky: 83 template addon Kód: INSERT INTO `creature_template_addon` (`entry`,`mount`,`bytes1`,`bytes2`,`emote`,`moveflags`,`vehicle_id`,`passengers`,`auras`) VALUES ('996632','29043','0','0','0','0','0','','62596 0') Kód: INSERT INTO `creature_template_addon` (`entry`,`mount`,`bytes1`,`bytes2`,`emote`,`moveflags`,`vehicle_id`,`passengers`,`auras`) VALUES ('996633','14333','0','0','0','0','0','','63405 0') Kód: INSERT INTO `creature_template_addon` (`entry`,`mount`,`bytes1`,`bytes2`,`emote`,`moveflags`,`vehicle_id`,`passengers`,`auras`) VALUES ('996631','28606','0','0','0','0','0','','63422 0') Kód: INSERT INTO `creature_template_addon` (`entry`,`mount`,`bytes1`,`bytes2`,`emote`,`moveflags`,`vehicle_id`,`passengers`,`auras`) VALUES ('996644','28612','0','0','0','0','0','','63426 0') Kód: INSERT INTO `creature_template_addon` (`entry`,`mount`,`bytes1`,`bytes2`,`emote`,`moveflags`,`vehicle_id`,`passengers`,`auras`) VALUES ('996630','28571','0','0','0','0','0','','63395 0') _________________ Nahoru Fellria Předmět příspěvku: Re: The Grand melee-aliNapsal: stř 26. kvě 2010 17:49:54 Game Master Registrován: pon 01. bře 2010 13:15:40 Příspěvky: 83 kill kredit: Kód: REPLACE 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 (96369, 0, 0, 0, 0, 0, 23179, 0, 23186, 0, 'Valint of one capital city defeated!', '', '', 0, 1, 1, 1, 1, 0, 0, 17, 35, 35, 0, 1, 1.14286, 1, 0, 1, 2, 0, 0, 1, 2000, 2000, 1, 0, 0, 0, 0, 0, 0, 0, 1, 2, 0, 7, 0, 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, ''); ůprava templatů pro kill kredit: Kód: REPLACE 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 (996633, 0, 0, 0, 96369, 0, 28955, 0, 28955, 0, 'Darnassus Valiant', '', '', 0, 80, 80, 50000, 50000, 0, 0, 9730, 25, 25, 1, 1, 1.14286, 1, 0, 420, 630, 0, 157, 1, 2000, 2000, 1, 0, 0, 0, 0, 0, 0, 0, 336, 504, 126, 10, 2048, 0, 0, 0, 0, 0, 0, 0, 0, 0, 63010, 65147, 0, 0, 0, 0, 0, '', 0, 3, 3.96825, 1, 0, 0, 0, 0, 0, 0, 0, 48, 1, 1911, 0, 0, 'generic_creature'); Kód: REPLACE 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 (996632, 0, 0, 0, 96369, 0, 28854, 0, 28854, 0, 'Stormwind Valiant', '', '', 0, 80, 80, 50000, 50000, 0, 0, 9730, 25, 25, 1, 1, 1.14286, 1, 0, 420, 630, 0, 157, 1, 2000, 2000, 1, 0, 0, 0, 0, 0, 0, 0, 336, 504, 126, 10, 2048, 0, 0, 0, 0, 0, 0, 0, 0, 0, 63010, 65147, 0, 0, 0, 0, 0, '', 0, 3, 3.96825, 1, 0, 0, 0, 0, 0, 0, 0, 0, 1, 1912, 0, 2, 'generic_creature'); Kód: REPLACE 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 (996631, 0, 0, 0, 96369, 0, 28848, 0, 28848, 0, 'Exodar Valiant', '', '', 0, 80, 80, 50000, 50000, 0, 0, 9730, 25, 25, 1, 1, 1.14286, 1, 0, 420, 630, 0, 157, 1, 2000, 2000, 1, 0, 0, 0, 0, 0, 0, 0, 336, 504, 126, 10, 2048, 0, 0, 0, 0, 0, 0, 0, 0, 0, 63010, 65147, 0, 0, 0, 0, 0, '', 0, 3, 3.96825, 1, 0, 0, 0, 0, 0, 0, 0, 76, 1, 1913, 0, 2, 'generic_creature'); Kód: REPLACE 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 (996630, 0, 0, 0, 96369, 0, 28849, 0, 28849, 0, 'Gnomeregan Valiant', '', '', 0, 80, 80, 50000, 50000, 0, 0, 9730, 25, 25, 1, 1, 1.14286, 1, 0, 420, 630, 0, 157, 1, 2000, 2000, 1, 0, 0, 0, 0, 0, 0, 0, 336, 504, 126, 10, 2048, 0, 0, 0, 0, 0, 0, 0, 0, 0, 63010, 65147, 0, 0, 0, 0, 0, '', 0, 3, 3.96825, 1, 0, 0, 0, 0, 0, 0, 0, 48, 1, 1910, 0, 2, 'generic_creature'); Kód: REPLACE 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 (996644, 0, 0, 0, 96369, 0, 28850, 0, 28850, 0, 'Ironforge Valiant', '', '', 0, 80, 80, 50000, 50000, 0, 0, 9730, 25, 25, 1, 1, 1.14286, 1, 0, 420, 630, 0, 157, 1, 2000, 2000, 1, 0, 0, 0, 0, 0, 0, 0, 336, 504, 126, 10, 2048, 0, 0, 0, 0, 0, 0, 0, 0, 0, 63010, 65147, 0, 0, 0, 0, 0, '', 0, 3, 3.96825, 1, 0, 0, 0, 0, 0, 0, 0, 48, 1, 1914, 0, 2, 'generic_creature'); _________________

Dyť neni problém si ho udělat.

Ahoj,Unyfiende. Můžeš sem,prosím,ještě napsat,jak moc je tvá znalost SQL rozsáhlá?Umíš např. s Gossipem,EventAI atd.?

Už jsme se dohodli,ale na ICQ jsem ti napsal¨Zdar.Až tu budeš,tak mi napiš a dohodnem se¨.Hodně štěstí a ten server nevlastnim.

Už jsem ti napsal na ICQ,tak se snad nějak dohodnem . (316237461)

v DBC souborech si najdeš volný vehicle ID a vehicle seat data,který k tomu patří a přidáš záznam v SQLku. Dyžtak moje ICQ:316237461 Skype:Fellria

Kdyby jste někdo chtěl pomoct vytvořit si vlastní,tak ať mi napíše,už sem na to přišel :-).

Tak jsem našel opravu na vehicle.Jedná se o draky v Oculusu. Oprava je na 3.3.2. /* the Oculus chain quests (13124, 13126, 13127 and 13128) */ DELETE FROM spell_script_target where entry IN (49460, 49346, 49464); DELETE FROM npc_spellclick_spells where npc_entry IN (27755, 27692, 27756); DELETE FROM creature_template_addon where entry IN (27755, 27692, 27756); /* Amber Drake */ INSERT INTO spell_script_target VALUES (49460, 1, 27755); INSERT INTO npc_spellclick_spells VALUES (27755, 49459, 0, 0, 0, 1); INSERT INTO creature_template_addon VALUES (27755, 0, 0, 0, 0, 0, 29, NULL, '53112 0 53112 1'); REPLACE INTO vehicle_data VALUES (29, 12, 49840, 49838, 49592, 0, 0, 0, 0, 0, 0, 0, 0); REPLACE INTO vehicle_seat_data VALUES (422, 3); /* Emerald Drake */ INSERT INTO spell_script_target VALUES (49346, 1, 27692); INSERT INTO npc_spellclick_spells VALUES (27692, 49427, 0, 0, 0, 1); INSERT INTO creature_template_addon VALUES (27692, 0, 0, 0, 0, 0, 39, NULL, '53112 0 53112 1'); REPLACE INTO vehicle_data VALUES (39, 12, 50328, 50341, 50344, 0, 0, 0, 0, 0, 0, 0, 0); REPLACE INTO vehicle_seat_data VALUES (662, 3); /* Ruby Drake */ INSERT INTO spell_script_target VALUES (49464, 1, 27756); INSERT INTO npc_spellclick_spells VALUES (27756, 49463, 0, 0, 0, 1); INSERT INTO creature_template_addon VALUES (27756, 0, 0, 0, 0, 0, 43, NULL, '53112 0 53112 1'); REPLACE INTO vehicle_data VALUES (43, 12, 50232, 50248, 50240, 0, 0, 0, 0, 0, 0, 0, 0); REPLACE INTO vehicle_seat_data VALUES (742, 3); /* Belgaristrasz and his companions give Drake, after completed quest (13124) */ UPDATE creature_template SET npcflag = npcflag|1 WHERE entry IN (27657, 27658, 27659); UPDATE `creature_template` SET `gossip_menu_id` = 27657 WHERE `entry` = 27657; UPDATE `creature_template` SET `gossip_menu_id` = 27658 WHERE `entry` = 27658; UPDATE `creature_template` SET `gossip_menu_id` = 27659 WHERE `entry` = 27659; DELETE FROM gossip_scripts WHERE id IN (27657, 27658, 27659); INSERT INTO gossip_scripts VALUES (27657,0,17,37815,1,0,0,0,0,0),(27658,0,17,37860,1,0,0,0,0,0),(27659,0,17,37859,1,0,0,0,0,0); DELETE FROM gossip_menu_option WHERE menu_id IN (27657, 27658, 27659); INSERT INTO gossip_menu_option VALUES (27657,0,0,'Take the Emerald Essence if you want to fly on the wings of the Green Flight.',1,1,0,0,27657,0,0,NULL,9,13126,0,16,37815,1,0,0,0), (27657,1,0,'Take the Emerald Essence if you want to fly on the wings of the Green Flight.',1,1,0,0,27657,0,0,NULL,9,13127,0,16,37815,1,0,0,0), (27657,2,0,'Take the Emerald Essence if you want to fly on the wings of the Green Flight.',1,1,0,0,27657,0,0,NULL,9,13128,0,16,37815,1,0,0,0), (27659,0,0,'Take the Amber Essence if you want to fly on the wings of the Bronze Flight.',1,1,0,0,27659,0,0,NULL,9,13126,0,16,37859,1,0,0,0), (27659,1,0,'Take the Amber Essence if you want to fly on the wings of the Bronze Flight.',1,1,0,0,27659,0,0,NULL,9,13127,0,16,37859,1,0,0,0), (27659,2,0,'Take the Amber Essence if you want to fly on the wings of the Bronze Flight.',1,1,0,0,27659,0,0,NULL,9,13128,0,16,37859,1,0,0,0), (27658,1,0,'Take the Ruby Essence if you want to fly on the wings of the Red Flight.',1,1,0,0,27658,0,0,NULL,9,13126,0,16,37860,1,0,0,0), (27658,2,0,'Take the Ruby Essence if you want to fly on the wings of the Red Flight.',1,1,0,0,27658,0,0,NULL,9,13127,0,16,37860,1,0,0,0), (27658,3,0,'Take the Ruby Essence if you want to fly on the wings of the Red Flight.',1,1,0,0,27658,0,0,NULL,9,13128,0,16,37860,1,0,0,0), (27658,0,0,'GOSSIP_OPTION_QUESTGIVER',2,2,0,0,0,0,0,NULL,0,0,0,0,0,0,0,0,0); /* hack for broken Nexus Portal */ UPDATE gameobject_template SET data0 = 49665 WHERE entry = 189985; UPDATE spell_target_position SET id = 49665 WHERE id = 49305; zdroj: getmangos.com

Opravdu?Píšou jenom toto: [9661] Implement dual talent specializations in talent switch part. http://github.com/mangos/mangos/commits/master?page=2 My už tam stejně vehicle patch máme,ale potřebuju prostě udělat svoje vlastní vozidlo. Omlouvam se za dvojí příspěvěk,napsali sme to s Broskví nastejno

Nám taky jedou,ale ne všechny. Hodily by se i na eventy,napadaj mě s nima dobrý :-).

Google it?Už jsem hledal dost,ale nic nenašel.

Ahoj Napsal by sem,prosím,někdo návod,jak vytvořit vehicle(vozidlo)? Našěl jsem jenom návod na TC2 a zkusil jsem to podle toho udělat,ale přijde mi to zcela rozdílé. Něco už jsem zkoušel a mam tam šipku na nasednutí,ta boužel po kliknutí nefunguje. Děkuji všem za pomoc. Fellria