2.3 [REQ] SQL Queries - Amani War Bear and Turbo Charged Fyling Machine

[Kiljaden]

I need the Amani War Bear and Turbo Charged Fyling Machine (2.3 new mounts) sql queries. Please post them here... I searched and didn't find anything useful.

[MentaL]

[darkrens15]

i have them for you



step 1 just put this code in a notepad file and save it like amaniwarbearandengeneeringmount.sql

step 2 put it in your database with Navicat or SQLyog

insert into `items` values('33809','15','0','-1','Amani War Bear','Amani War Bear','Amani War Bear','Amani War Bear','37593','4','64','0','0','0','-1','-1','70','70','762','150','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','0','0','0','0','0','0','0','0','0','0','0','0','0','43688','0','0','0','330','3000','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','-1','0','0','0','0','0','0','0',NULL,'0',NULL,NULL,'0',NULL,'0',NULL,'0',NULL,NULL,NULL,'0','-1','0');

insert into `creature_names` values('24379','Amani War Bear','','0','0','10','0','0','0',NULL,'22464','22462','0','0','1','1',NULL,NULL);

insert into `creature_proto` values('24379','1','1','35','64','64','53','1.15','0','2000','3','3.87','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','1','1','0','0','2','0','0','2.5','8','14','0');


insert into `creature_names` (`entry`, `name`, `subname`, `mouseFlags`, `Flags1`, `type`, `family`, `rank`, `unk4`, `spelldataid`, `male_displayid`, `female_displayid`, `male_displayid2`, `female_displayid2`, `unknown_float1`, `unknown_float2`, `civilian`, `leader`) values('24653','Flying Machine','','0','0','0','0','0','0',NULL,'22719','0','0','0','0','0',NULL,NULL);
insert into `creature_names` (`entry`, `name`, `subname`, `mouseFlags`, `Flags1`, `type`, `family`, `rank`, `unk4`, `spelldataid`, `male_displayid`, `female_displayid`, `male_displayid2`, `female_displayid2`, `unknown_float1`, `unknown_float2`, `civilian`, `leader`) values('24654','Turbo-Charged Flying Machine','','0','0','0','0','0','0',NULL,'22720','0','0','0','0','0',NULL,NULL);
insert into `items` (`entry`, `class`, `subclass`, `field4`, `name1`, `name2`, `name3`, `name4`, `displayid`, `quality`, `flags`, `buyprice`, `sellprice`, `inventorytype`, `allowableclass`, `allowablerace`, `itemlevel`, `requiredlevel`, `RequiredSkill`, `RequiredSkillRank`, `RequiredSkillSubRank`, `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`, `dmg_min3`, `dmg_max3`, `dmg_type3`, `dmg_min4`, `dmg_max4`, `dmg_type4`, `dmg_min5`, `dmg_max5`, `dmg_type5`, `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`, `unk203_1`, `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`, `ItemExtendedCost`, `ArenaRankRequirement`, `ReqDisenchantSkill`, `unk2`) values('34060','15','0','-1','Flying Machine Control','Flying Machine Control','Flying Machine Control','Flying Machine Control','47773','4','64','2000000','400000','0','-1','-1','70','70','202','350','0','0','0','0','7','1','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','0','0','0','0','0','0','44153','0','0','0','330','3000','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','Requires expert riding skill or higher to use.','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','-1','0');
insert into `items` (`entry`, `class`, `subclass`, `field4`, `name1`, `name2`, `name3`, `name4`, `displayid`, `quality`, `flags`, `buyprice`, `sellprice`, `inventorytype`, `allowableclass`, `allowablerace`, `itemlevel`, `requiredlevel`, `RequiredSkill`, `RequiredSkillRank`, `RequiredSkillSubRank`, `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`, `dmg_min3`, `dmg_max3`, `dmg_type3`, `dmg_min4`, `dmg_max4`, `dmg_type4`, `dmg_min5`, `dmg_max5`, `dmg_type5`, `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`, `unk203_1`, `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`, `ItemExtendedCost`, `ArenaRankRequirement`, `ReqDisenchantSkill`, `unk2`) values('34061','15','0','-1','Turbo-Charged Flying Machine Control','Turbo-Charged Flying Machine Control','Turbo-Charged Flying Machine Control','Turbo-Charged Flying Machine Control','47774','4','64','2000000','400000','0','-1','-1','70','70','202','375','0','0','0','0','7','1','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','0','0','0','0','0','0','44151','0','0','0','330','3000','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','Requires artisan riding skill or higher to use.','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','-1','0');

I have also the cenarion war hippogryph, ask when you need it :D

[Kirth]

i have them for you



step 1 just put this code in a notepad file and save it like amaniwarbearandengeneeringmount.sql

step 2 put it in your database with Navicat or SQLyog



I have also the cenarion war hippogryph, ask when you need it :D

Doesn't work. COuld you post a working one please? (One thats usable with an already excisting db?)

[darkrens15]

use navicat and use the overwrite button
it works with the latest database etc.

[nandina]

I have also the cenarion war hippogryph, ask when you need it :D

could you please? :D
thanks

[beileroord]

Guess this works for U 2 :

REPLACE INTO creature_names
  (entry, name, subname, mouseFlags, Flags1, type, family, rank, unk4, spelldataid, male_displayid, female_displayid, male_displayid2, female_displayid2, unknown_float1, unknown_float2, civilian, leader)
VALUES
  (24488, "Cenarion War Hippogryph", "", 0, 0, 10, 0, 0, 0, NULL, 22473, 0, 0, 0, 1, 1, NULL, NULL);

[Paco44]

beileroord, you need to give the creature_proto along with that.

[gregon13]

creature_proto(cal) is important i assumed it would be as simple as just the info of the creature not including Creature_proto

[Paco44]

Without this proto, the spell doesn't know what to cast.

[gregon13]

ahh now i understand how important the creature_proto is

[Paco44]

Look in the table creature_proto, mostly all you see is stats of the creature that were not covered in the names. The more important columns are:

scale
npcflags

This regulates the size of the mount, and what the mount is intended to do.

[phluke311]

Thanx darkrens15....This was very helpful.

[darkrens15]

your welcome

[Ricroh]

where is the overwrite button on navicat 8 ?