[SQL]Nova Montaria "Reins of the Grand Centaur"

XMikaelX

TecLob

Death

7 participantes

BGames :: Jogos :: World of Warcraft :: WoW | Server Files :: SQL Querys

[SQL]Nova Montaria "Reins of the Grand Centaur"Sex 24 Ago 2012 - 21:58

Dae Galera ! Desculpe eu ter me ausentado um tempo da bgames, Mais estou devolta com um tópico que tenho certeza que vão gosta.

"Reins of the Grand Centaur"

Prints :

[Tens de ter uma conta e sessão iniciada para poderes visualizar esta imagem]

Código:

DELETE FROM `creature_template` WHERE `entry`=31851 LIMIT 1;
DELETE FROM `creature_template` WHERE `entry`=31852 LIMIT 1;
INSERT INTO `creature_template` (`entry`, `difficulty_entry_1`, `difficulty_entry_2`, `difficulty_entry_3`, `KillCredit1`, `KillCredit2`, `modelid1`, `modelid2`, `modelid3`, `modelid4`, `name`, `subname`, `IconName`, `gossip_menu_id`, `minlevel`, `maxlevel`, `exp`, `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`, `spell5`, `spell6`, `spell7`, `spell8`, `PetSpellDataId`, `VehicleId`, `mingold`, `maxgold`, `AIName`, `MovementType`, `InhabitType`, `HoverHeight`, `Health_mod`, `Mana_mod`, `Armor_mod`, `RacialLeader`, `questItem1`, `questItem2`, `questItem3`, `questItem4`, `questItem5`, `questItem6`, `movementId`, `RegenHealth`, `equipment_id`, `mechanic_immune_mask`, `flags_extra`, `ScriptName`, `WDBVerified`) VALUES (31851, 0, 0, 0, 0, 0, 24857, 0, 0, 0, 'Great Centaur', '', '', 0, 70, 70, 2, 35, 35, 0, 0.666668, 0.95238, 1, 0, 252, 357, 0, 304, 1, 2000, 0, 1, 33536, 8, 0, 0, 0, 0, 0, 215, 320, 44, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '', 0, 3, 1, 1, 1, 1, 0, 0, 0, 0, 0, 0, 0, 0, 1, 3001, 0, 0, '', 12340);
INSERT INTO `creature_template` (`entry`, `difficulty_entry_1`, `difficulty_entry_2`, `difficulty_entry_3`, `KillCredit1`, `KillCredit2`, `modelid1`, `modelid2`, `modelid3`, `modelid4`, `name`, `subname`, `IconName`, `gossip_menu_id`, `minlevel`, `maxlevel`, `exp`, `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`, `spell5`, `spell6`, `spell7`, `spell8`, `PetSpellDataId`, `VehicleId`, `mingold`, `maxgold`, `AIName`, `MovementType`, `InhabitType`, `HoverHeight`, `Health_mod`, `Mana_mod`, `Armor_mod`, `RacialLeader`, `questItem1`, `questItem2`, `questItem3`, `questItem4`, `questItem5`, `questItem6`, `movementId`, `RegenHealth`, `equipment_id`, `mechanic_immune_mask`, `flags_extra`, `ScriptName`, `WDBVerified`) VALUES (31852, 0, 0, 0, 0, 0, 24857, 0, 0, 0, 'Great Centaur', '', '', 0, 70, 70, 2, 35, 35, 0, 0.666668, 0.95238, 1, 0, 252, 357, 0, 304, 1, 2000, 0, 1, 33536, 8, 0, 0, 0, 0, 0, 215, 320, 44, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '', 0, 3, 1, 1, 1, 1, 0, 0, 0, 0, 0, 0, 0, 0, 1, 3001, 0, 0, '', 12340);
DELETE FROM `item_template` WHERE `entry`=44230 LIMIT 1;
DELETE FROM `item_template` WHERE `entry`=44231 LIMIT 1;
INSERT INTO `item_template` (`entry`, `class`, `subclass`, `unk0`, `name`, `displayid`, `Quality`, `Flags`, `FlagsExtra`, `BuyCount`, `BuyPrice`, `SellPrice`, `InventoryType`, `AllowableClass`, `AllowableRace`, `ItemLevel`, `RequiredLevel`, `RequiredSkill`, `RequiredSkillRank`, `requiredspell`, `requiredhonorrank`, `RequiredCityRank`, `RequiredReputationFaction`, `RequiredReputationRank`, `maxcount`, `stackable`, `ContainerSlots`, `StatsCount`, `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`, `ScalingStatDistribution`, `ScalingStatValue`, `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`, `RangedModRange`, `spellid_1`, `spelltrigger_1`, `spellcharges_1`, `spellppmRate_1`, `spellcooldown_1`, `spellcategory_1`, `spellcategorycooldown_1`, `spellid_2`, `spelltrigger_2`, `spellcharges_2`, `spellppmRate_2`, `spellcooldown_2`, `spellcategory_2`, `spellcategorycooldown_2`, `spellid_3`, `spelltrigger_3`, `spellcharges_3`, `spellppmRate_3`, `spellcooldown_3`, `spellcategory_3`, `spellcategorycooldown_3`, `spellid_4`, `spelltrigger_4`, `spellcharges_4`, `spellppmRate_4`, `spellcooldown_4`, `spellcategory_4`, `spellcategorycooldown_4`, `spellid_5`, `spelltrigger_5`, `spellcharges_5`, `spellppmRate_5`, `spellcooldown_5`, `spellcategory_5`, `spellcategorycooldown_5`, `bonding`, `description`, `PageText`, `LanguageID`, `PageMaterial`, `startquest`, `lockid`, `Material`, `sheath`, `RandomProperty`, `RandomSuffix`, `block`, `itemset`, `MaxDurability`, `area`, `Map`, `BagFamily`, `TotemCategory`, `socketColor_1`, `socketContent_1`, `socketColor_2`, `socketContent_2`, `socketColor_3`, `socketContent_3`, `socketBonus`, `GemProperties`, `RequiredDisenchantSkill`, `ArmorDamageModifier`, `Duration`, `ItemLimitCategory`, `HolidayId`, `ScriptName`, `DisenchantID`, `FoodType`, `minMoneyLoot`, `maxMoneyLoot`, `WDBVerified`) VALUES (60444, 15, 5, -1, 'Reins of the Grand Centaur', 44588, 5, 4096, 2, 1, 0, 0, 0, -1, -1, 90, 90, 0, 150, 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, 0, 55884, 0, -1, 0, -1, 330, 3000, 59791, 6, 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, 1, 'Teaches you how to summon this mount.  This is a very fast mount.|cffff0000Be carefull it is huge and hard to get.', 0, 0, 0, 0, 0, 4, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, -1, 0, 0, 0, 0, '', 0, 0, 0, 0, 12340);
INSERT INTO `item_template` (`entry`, `class`, `subclass`, `unk0`, `name`, `displayid`, `Quality`, `Flags`, `FlagsExtra`, `BuyCount`, `BuyPrice`, `SellPrice`, `InventoryType`, `AllowableClass`, `AllowableRace`, `ItemLevel`, `RequiredLevel`, `RequiredSkill`, `RequiredSkillRank`, `requiredspell`, `requiredhonorrank`, `RequiredCityRank`, `RequiredReputationFaction`, `RequiredReputationRank`, `maxcount`, `stackable`, `ContainerSlots`, `StatsCount`, `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`, `ScalingStatDistribution`, `ScalingStatValue`, `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`, `RangedModRange`, `spellid_1`, `spelltrigger_1`, `spellcharges_1`, `spellppmRate_1`, `spellcooldown_1`, `spellcategory_1`, `spellcategorycooldown_1`, `spellid_2`, `spelltrigger_2`, `spellcharges_2`, `spellppmRate_2`, `spellcooldown_2`, `spellcategory_2`, `spellcategorycooldown_2`, `spellid_3`, `spelltrigger_3`, `spellcharges_3`, `spellppmRate_3`, `spellcooldown_3`, `spellcategory_3`, `spellcategorycooldown_3`, `spellid_4`, `spelltrigger_4`, `spellcharges_4`, `spellppmRate_4`, `spellcooldown_4`, `spellcategory_4`, `spellcategorycooldown_4`, `spellid_5`, `spelltrigger_5`, `spellcharges_5`, `spellppmRate_5`, `spellcooldown_5`, `spellcategory_5`, `spellcategorycooldown_5`, `bonding`, `description`, `PageText`, `LanguageID`, `PageMaterial`, `startquest`, `lockid`, `Material`, `sheath`, `RandomProperty`, `RandomSuffix`, `block`, `itemset`, `MaxDurability`, `area`, `Map`, `BagFamily`, `TotemCategory`, `socketColor_1`, `socketContent_1`, `socketColor_2`, `socketContent_2`, `socketColor_3`, `socketContent_3`, `socketBonus`, `GemProperties`, `RequiredDisenchantSkill`, `ArmorDamageModifier`, `Duration`, `ItemLimitCategory`, `HolidayId`, `ScriptName`, `DisenchantID`, `FoodType`, `minMoneyLoot`, `maxMoneyLoot`, `WDBVerified`) VALUES (60509, 4, 0, -1, 'Mount Food |cffffcc00(Carrot)', 21115, 4, 0, 0, 1, 0, 0, 12, -1, -1, 160, 80, 0, 0, 0, 0, 0, 0, 0, 4, 1, 0, 10, 7, 350, 5, 350, 6, 350, 18, 350, 32, 350, 36, 50, 3, 350, 4, 350, 38, 350, 0, 0, 0, 0, 350, 350, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 71540, 1, 0, 0, -1, 0, -1, 48777, 1, 0, 0, -1, 0, -1, 48777, 1, 0, 0, 0, 0, -1, 48777, 1, 0, 0, -1, 0, -1, 48777, 1, 0, 0, -1, 0, -1, 1, 'Use this to travel faster with your mount. This is best food for it!', 0, 0, 0, 0, 0, 4, 0, 0, 0, 0, 0, 200, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 375, 0, 0, 0, 0, '', 68, 0, 0, 0, 12340);

Créditos : darksoke

Re: [SQL]Nova Montaria "Reins of the Grand Centaur"Sáb 25 Ago 2012 - 1:51

Obrigada Death por postar essa mount.
GRATA!

Re: [SQL]Nova Montaria "Reins of the Grand Centaur"Sáb 25 Ago 2012 - 10:00

Deu Erro Pode Coloca o Codigo Numa Pasta Chamado .sql Ajudaria Mais

Re: [SQL]Nova Montaria "Reins of the Grand Centaur"Ter 4 Set 2012 - 20:12

e aqui tambem deu error : /

Re: [SQL]Nova Montaria "Reins of the Grand Centaur"Ter 4 Set 2012 - 20:19

Brigadão death pela mount, vo testa-la aki!!!

Re: [SQL]Nova Montaria "Reins of the Grand Centaur"Ter 4 Set 2012 - 22:47

Error Code : 1054
Unknown column 'HoverHeight' in 'field list'

Error Code : 1062
Duplicate entry '60509' for key 'PRIMARY'[/code]

Re: [SQL]Nova Montaria "Reins of the Grand Centaur"Ter 4 Set 2012 - 22:50

Olá,
estou enferrujado no assunto,
mais creio que a coluna hoverheight não existe,
e você ja tem uma montaria com o mesmo ID

Até mais

Re: [SQL]Nova Montaria "Reins of the Grand Centaur"Ter 4 Set 2012 - 22:52

como faço entao pra bota-la no server? tem outro jeito nao?

Re: [SQL]Nova Montaria "Reins of the Grand Centaur"Sáb 8 Set 2012 - 14:38

funcionou perfeitamente aqui, usei o navicat, vlw death leva meu +rep.

O id da mount é 60444

[Tens de ter uma conta e sessão iniciada para poderes visualizar esta imagem]

Re: [SQL]Nova Montaria "Reins of the Grand Centaur"Dom 18 Nov 2012 - 17:59

Para quem ainda não está conseguindo add a montaria aki vai uma solução:

[Tens de ter uma conta e sessão iniciada para poderes visualizar este link]

Re: [SQL]Nova Montaria "Reins of the Grand Centaur"

Tópicos semelhantes

World of Warcraft lança nova montaria
[Ajuda] Montaria
De Criatura Para Montaria
[Duvida]Montaria voadora
[SQL] Montaria Custom Senjay's spectron alive

Ir para:

Permissões neste sub-fórum

Não podes responder a tópicos

Inicie sessão para responder

Fórum de Desenvolvimento de Jogos e Programação

[SQL]Nova Montaria "Reins of the Grand Centaur"

description[SQL]Nova Montaria "Reins of the Grand Centaur"Sex 24 Ago 2012 - 21:58

descriptionRe: [SQL]Nova Montaria "Reins of the Grand Centaur"Sáb 25 Ago 2012 - 1:51

descriptionRe: [SQL]Nova Montaria "Reins of the Grand Centaur"Sáb 25 Ago 2012 - 10:00

descriptionRe: [SQL]Nova Montaria "Reins of the Grand Centaur"Ter 4 Set 2012 - 20:12

descriptionRe: [SQL]Nova Montaria "Reins of the Grand Centaur"Ter 4 Set 2012 - 20:19

descriptionRe: [SQL]Nova Montaria "Reins of the Grand Centaur"Ter 4 Set 2012 - 22:47

descriptionRe: [SQL]Nova Montaria "Reins of the Grand Centaur"Ter 4 Set 2012 - 22:50

descriptionRe: [SQL]Nova Montaria "Reins of the Grand Centaur"Ter 4 Set 2012 - 22:52

descriptionRe: [SQL]Nova Montaria "Reins of the Grand Centaur"Sáb 8 Set 2012 - 14:38

descriptionRe: [SQL]Nova Montaria "Reins of the Grand Centaur"Dom 18 Nov 2012 - 17:59

descriptionRe: [SQL]Nova Montaria "Reins of the Grand Centaur"