Engineering

SQL Dopyt

 
##Suroviny
 
UPDATE `pos_world`.`item_template` SET 
`name` = 'Kus latky',
`BuyPrice` = '40',
`SellPrice` = '0',
`class` = '7',
`subclass` = '5'
 
WHERE `item_template`.`entry` =2589 ;
 
UPDATE `pos_world`.`item_template` SET 
`name` = 'Kus opracovaneho dreva',
`BuyPrice` = '350',
`SellPrice` = '0',
`class` = '7',
`subclass` = '1'
 
WHERE `item_template`.`entry` =4399 ;
 
UPDATE `pos_world`.`item_template` SET 
`name` = 'Tavidlo',
`BuyPrice` = '500',
`SellPrice` = '0',
`class` = '7',
`subclass` = '11'
 
WHERE `item_template`.`entry` =2880 ;
 
 
UPDATE `pos_world`.`item_template` SET 
`name` = 'Silne tavidlo',
`BuyPrice` = '1000',
`SellPrice` = '0',
`class` = '7',
`subclass` = '11'
 
WHERE `item_template`.`entry` =3466;
 
 
UPDATE `pos_world`.`item_template` SET 
`name` = 'Malachit',
`BuyPrice` = '0',
`SellPrice` = '0',
`class` = '3',
`subclass` = '7'
 
WHERE `item_template`.`entry` =774 ;
 
 
 
UPDATE `pos_world`.`item_template` SET 
`name` = 'Zeleny achat',
`BuyPrice` = '0',
`SellPrice` = '0',
`class` = '3',
`subclass` = '7'
 
WHERE `item_template`.`entry` =1206 ;
 
UPDATE `pos_world`.`item_template` SET 
`name` = 'Ocarovany kov',
`BuyPrice` = '10000',
`SellPrice` = '0',
`class` = '7',
`subclass` = '1'
 
WHERE `item_template`.`entry` =4404 ;
 
 
##Mezivyrobky
 
UPDATE `pos_world`.`item_template` SET 
`name` = 'Hruby strelny prach',
`BuyPrice` = '0',
`SellPrice` = '0',
`class` = '7',
`subclass` = '1'
 
WHERE `item_template`.`entry` =4357 ;
 
UPDATE `pos_world`.`item_template` SET 
`name` = 'Obycejne srouby',
`BuyPrice` = '0',
`SellPrice` = '0',
`class` = '7',
`subclass` = '1'
 
WHERE `item_template`.`entry` =4359 ;
 
UPDATE `pos_world`.`item_template` SET 
`name` = 'Obycejna trubka',
`BuyPrice` = '0',
`SellPrice` = '0',
`class` = '7',
`subclass` = '1' 
 
WHERE `item_template`.`entry` =4361 ;
 
UPDATE `pos_world`.`item_template` SET 
`name` = 'Jemny strelny prach',
`BuyPrice` = '0',
`SellPrice` = '0',
`class` = '7',
`subclass` = '1'
 
WHERE `item_template`.`entry` =4364 ;
 
 
UPDATE `pos_world`.`item_template` SET 
`name` = 'Strojek',
`BuyPrice` = '0',
`SellPrice` = '0',
`class` = '7',
`subclass` = '1'
 
 
WHERE `item_template`.`entry` =4363;
 
UPDATE `pos_world`.`item_template` SET 
`name` = 'Akumulator',
`BuyPrice` = '0',
`SellPrice` = '0',
`class` = '7',
`subclass` = '1'
 
WHERE `item_template`.`entry` =4371;
 
##Vyrobky
 
 
 
 UPDATE `pos_world`.`item_template` SET 
`class` = '7',
`subclass` = '2',
`name` = 'Granat',
`displayid` = '25482',
`BuyCount` = '1',
`Flags` = '0 ',
`BuyPrice` = '0',
`SellPrice` = '0',
`InventoryType` = '12',
`RequiredLevel` = '0',
`RequiredSkill` = '202',
`RequiredSkillRank` = '10',
`delay` = '0',
`spellid_1` = '19769',
`spelltrigger_1` = '0',
`spellcharges_1` = '-1',
`spellppmRate_1` = '-1',
`spellcooldown_1` = '0',
`spellcategory_1` = '0',
`spellcategorycooldown_1` = '0',
`BagFamily` = '128 ',
`Duration` = '-864000' 
 
WHERE `item_template`.`entry` =8067  ;
 
 
UPDATE `pos_world`.`item_template` SET 
`class` = '7',
`subclass` = '2',
`name` = 'Bomba',
`displayid` = '18062',
`BuyCount` = '1',
`BuyPrice` = '0',
`SellPrice` = '0',
`InventoryType` = '12',
`Flags` = '0 ',
`RequiredLevel` = '0',
`RequiredSkill` = '202',
`RequiredSkillRank` = '10',
`delay` = '0',
`spellid_1` = '23063',
`spelltrigger_1` = '0',
`spellcharges_1` = '-1',
`spellppmRate_1` = '-1',
`spellcooldown_1` = '0',
`spellcategory_1` = '0',
`spellcategorycooldown_1` = '0',
`BagFamily` = '128 ',
`Duration` = '-864000' 
 
WHERE `item_template`.`entry` =4358;
 
 
UPDATE `pos_world`.`item_template` SET 
`class` = '7',
`subclass` = '2',
`name` = 'Mina',
`displayid` = '7367',
`BuyCount` = '1',
`BuyPrice` = '0',
`SellPrice` = '0',
`InventoryType` = '0',
`Flags` = '64 ',
`RequiredLevel` = '0',
`RequiredSkill` = '202',
`RequiredSkillRank` = '10',
`delay` = '0',
`spellid_1` = '49066',
`spelltrigger_1` = '0',
`spellcharges_1` = '-1',
`spellppmRate_1` = '-1',
`spellcooldown_1` = '0',
`spellcategory_1` = '0',
`spellcategorycooldown_1` = '0',
`BagFamily` = '128 ',
`Duration` = '0' 
 
WHERE `item_template`.`entry` =4360  ;
 
 
UPDATE `pos_world`.`item_template` SET 
`class` = '4',
`subclass` = '0',
`name` = 'Raketomet',
`displayid` = '40556',
`BuyCount` = '1',
`BuyPrice` = '0',
`SellPrice` = '0',
`Flags` = '0 ',
`InventoryType` = '12',
`RequiredLevel` = '0',
`RequiredSkill` = '202',
`RequiredSkillRank` = '10',
`delay` = '0',
`StatsCount` = '1',
`stat_type1` = '4',
`stat_value1` = '-15',
`stat_type2` = '0',
`stat_value2` = '0',
`stat_type3` = '0',
`stat_value3` = '0',
`spellid_1` = '46567',
`spelltrigger_1` = '0',
`spellcharges_1` = '-1',
`spellppmRate_1` = '-1',
`spellcooldown_1` = '0',
`spellcategory_1` = '0',
`spellcategorycooldown_1` = '0',
`BagFamily` = '128 ',
`Duration` = '0' 
 
WHERE `item_template`.`entry` =4362  ;
 
UPDATE `pos_world`.`item_template` SET 
`class` = '2',
`subclass` = '14',
`name` = 'Naradi',
`displayid` = '7494',
`BuyCount` = '1',
`BuyPrice` = '0',
`Flags` = '0 ',
`SellPrice` = '0',
`InventoryType` = '21',
`RequiredLevel` = '0',
`RequiredSkill` = '202',
`RequiredSkillRank` = '10',
`delay` = '0',
`BagFamily` = '128 ',
`Duration` = '0' 
 
WHERE `item_template`.`entry` =6219;
 
 
 UPDATE `pos_world`.`item_template` SET 
`class` = '4',
`subclass` = '0',
`name` = 'Oslepovac',
`displayid` = '7326',
`BuyCount` = '1',
`BuyPrice` = '0',
`Flags` = '0 ',
`SellPrice` = '0',
`InventoryType` = '12',
`RequiredLevel` = '0',
`RequiredSkill` = '202',
`RequiredSkillRank` = '10',
`delay` = '0',
`spellid_1` = '2094',
`spelltrigger_1` = '0',
`spellcharges_1` = '-100',
`spellppmRate_1` = '-1',
`spellcooldown_1` = '120000',
`spellcategory_1` = '0',
`spellcategorycooldown_1` = '0',
`BagFamily` = '128 ',
`Duration` = '0' 
 
WHERE `item_template`.`entry` =4405 ;
 
UPDATE `pos_world`.`item_template` SET 
`class` = '7',
`subclass` = '2',
`name` = 'Antimagicka bomba',
`displayid` = '27453',
`BuyCount` = '1',
`BuyPrice` = '0',
`SellPrice` = '0',
`InventoryType` = '12',
`Flags` = '0 ',
`RequiredLevel` = '0',
`RequiredSkill` = '202',
`RequiredSkillRank` = '10',
`delay` = '0',
`spellid_1` = '19821',
`spelltrigger_1` = '0',
`spellcharges_1` = '-1',
`spellppmRate_1` = '-1',
`spellcooldown_1` = '0',
`spellcategory_1` = '0',
`spellcategorycooldown_1` = '0',
`BagFamily` = '128 ',
`Duration` = '-864000' 
 
WHERE `item_template`.`entry` =4370;
 
 
 UPDATE `pos_world`.`item_template` SET 
`class` = '7',
`subclass` = '2',
`name` = 'Tristivi granat',
`displayid` = '25482',
`BuyCount` = '1',
`BuyPrice` = '0',
`SellPrice` = '0',
`InventoryType` = '12',
`Flags` = '0 ',
`RequiredLevel` = '0',
`RequiredSkill` = '202',
`RequiredSkillRank` = '10',
`delay` = '0',
`spellid_1` = '19784',
`spelltrigger_1` = '0',
`spellcharges_1` = '-1',
`spellppmRate_1` = '-1',
`spellcooldown_1` = '0',
`spellcategory_1` = '0',
`spellcategorycooldown_1` = '0',
`BagFamily` = '128 ',
`Duration` = '-864000' 
 
WHERE `item_template`.`entry` =8068  ;
 
 UPDATE `pos_world`.`item_template` SET 
`class` = '2',
`subclass` = '3',
`name` = 'Puska',
`displayid` = '20744',
`Quality` = '3',
`BuyCount` = '1',
`Flags` = '0 ',
`BuyPrice` = '0',
`SellPrice` = '0',
`InventoryType` = '15',
`RequiredLevel` = '0',
`RequiredSkill` = '0',
`RequiredSkillRank` = '0',
`BagFamily` = '128 ',
`Duration` = '0' 
 
WHERE `item_template`.`entry` =4401  ;
 
UPDATE `pos_world`.`item_template` SET 
`class` = '4',
`subclass` = '0',
`name` = 'Ozivovac',
`displayid` = '31201',
`BuyCount` = '1',
`BuyPrice` = '0',
`SellPrice` = '0',
`StatsCount` = '0',
`stat_type1` = '0',
`stat_value1` = '0',
`stat_type2` = '0',
`stat_value2` = '0',
`stat_type3` = '0',
`stat_value3` = '0',
`InventoryType` = '12',
`RequiredLevel` = '0',
`RequiredSkill` = '202',
`RequiredSkillRank` = '10',
`delay` = '0',
`spellid_1` = '8342',
`spelltrigger_1` = '0',
`spellcharges_1` = '-100',
`spellppmRate_1` = '-1',
`spellcooldown_1` = '0',
`spellcategory_1` = '0',
`spellcategorycooldown_1` = '0',
`BagFamily` = '128 ',
`Duration` = '0' 
 
WHERE `item_template`.`entry` =4372 ;

SQL Dopyt

 
 
 
 
 
/* Aliance - 5518 */
 
INSERT INTO `npc_trainer` (`entry`, `spell`, `spellcost`, `reqskill`, `reqskillvalue`, `reqlevel`) VALUES
(5518 , 7430, 0, 202, 5, 0),
(5518 , 3922, 0, 202, 10, 0),
(5518 , 3923, 0, 202, 15, 0);
 
/* Aliance - 26991*/
 
INSERT INTO `npc_trainer` (`entry`, `spell`, `spellcost`, `reqskill`, `reqskillvalue`, `reqlevel`) VALUES
(26991, 3924, 0, 202, 15, 0),
(26991, 3926, 0, 202, 20, 0),
(26991, 3929, 0, 202, 25, 0),
(26991, 3930, 0, 202, 30, 0),
(26991, 26416, 0, 202, 30, 0),
(26991, 26417, 0, 202, 30, 0),
(26991, 26418, 0, 202, 30, 0),
(26991, 3928, 0, 202, 40, 0),
(26991, 3977, 0, 202, 45, 0);
 
/* Aliance - 26907*/
 
INSERT INTO `npc_trainer` (`entry`, `spell`, `spellcost`, `reqskill`, `reqskillvalue`, `reqlevel`) VALUES
(26907, 3937, 0, 202, 55, 0),
(26907, 3925, 0, 202, 75, 0),
(26907, 3939, 0, 202, 65, 0),
(26907, 3938, 0, 202, 50, 0);
 
 
/* Horda - 8736*/
 
INSERT INTO `npc_trainer` (`entry`, `spell`, `spellcost`, `reqskill`, `reqskillvalue`, `reqlevel`) VALUES
(8736, 7430, 0, 202, 5, 0),
(8736, 3922, 0, 202, 10, 0),
(8736, 3923, 0, 202, 15, 0);
 
/*Horda - 11031*/
 
INSERT INTO `npc_trainer` (`entry`, `spell`, `spellcost`, `reqskill`, `reqskillvalue`, `reqlevel`) VALUES
(11031, 3924, 0, 202, 15, 0),
(11031, 3926, 0, 202, 20, 0),
(11031, 3929, 0, 202, 25, 0),
(11031, 3930, 0, 202, 30, 0),
(11031, 26416, 0, 202, 30, 0),
(11031, 26417, 0, 202, 30, 0),
(11031, 26418, 0, 202, 30, 0),
(11031, 3928, 0, 202, 40, 0),
(11031, 3977, 0, 202, 45, 0);
 
/* Horda - 11017*/
 
INSERT INTO `npc_trainer` (`entry`, `spell`, `spellcost`, `reqskill`, `reqskillvalue`, `reqlevel`) VALUES
(11017, 3937, 0, 202, 55, 0),
(11017, 3925, 0, 202, 75, 0),
(11017, 3939, 0, 202, 65, 0),
(11017, 3938, 0, 202, 50, 0);

Ucitele

Aliance : 5518< 26991< 26907
Horda : 8736< 11031< 11017

Kovařství

SQL Dopyt

 
 
##Brneni - Medene
 
UPDATE `pos_world`.`item_template` SET 
`name` = 'Medeny hrudni plat',
`description` = 'Kvalitni prace',
`Quality` = '1'
 
WHERE `item_template`.`entry` =10421;
 
 
 
UPDATE `pos_world`.`item_template` SET 
`name` = 'Medeny zapestnik',
`description` = 'Kvalitni prace',
`Quality` = '1'
 
WHERE `item_template`.`entry` =2853;
 
 
 
UPDATE `pos_world`.`item_template` SET 
`name` = 'Medene kalhoty',
`description` = 'Kvalitni prace',
`Quality` = '1'
 
WHERE `item_template`.`entry` =2852;
 
 
 
UPDATE `pos_world`.`item_template` SET 
`name` = 'Medene okovane boty',
`description` = 'Kvalitni prace',
`Quality` = '1'
 
WHERE `item_template`.`entry` =3469;
 
 
 
UPDATE `pos_world`.`item_template` SET 
`name` = 'Medeny pasek',
`description` = 'Kvalitni prace',
`Quality` = '1'
 
WHERE `item_template`.`entry` =2851;
 
 
 
UPDATE `pos_world`.`item_template` SET 
`name` = 'Medene rukavice',
`description` = 'Kvalitni prace',
`Quality` = '1'
 
WHERE `item_template`.`entry` =3472;
 
##Brneni - Bronzove
 
 
UPDATE `pos_world`.`item_template` SET 
`name` = 'Bronzove torso',
`description` = 'Kvalitni prace',
`Quality` = '2'
 
WHERE `item_template`.`entry` =2866;
 
 
 
UPDATE `pos_world`.`item_template` SET 
`name` = 'Bronzove kalhoty',
`description` = 'Kvalitni prace',
`Quality` = '2'
 
WHERE `item_template`.`entry` =2865;
 
 
 
UPDATE `pos_world`.`item_template` SET 
`name` = 'Bronzove naremeniky',
`description` = 'Kvalitni prace',
`Quality` = '2'
 
WHERE `item_template`.`entry` =3480;
 
 
 
UPDATE `pos_world`.`item_template` SET 
`name` = 'Bronzove zapestniky',
`description` = 'Kvalitni prace',
`Quality` = '2'
 
WHERE `item_template`.`entry` =2868;
 
 
 
UPDATE `pos_world`.`item_template` SET 
`name` = 'Bronzovve boty ',
`description` = 'Kvalitni prace',
`Quality` = '2'
 
WHERE `item_template`.`entry` =6350;
 
##Brneni Zelezne
 
UPDATE `pos_world`.`item_template` SET 
`name` = 'Zelezne kalhoty',
`description` = 'Kvalitni prace',
`Quality` = '3'
 
WHERE `item_template`.`entry` =3842;
 
 
UPDATE `pos_world`.`item_template` SET 
`name` = 'Zelezny kiris',
`description` = 'Kvalitni prace',
`Quality` = '3'
 
WHERE `item_template`.`entry` =7914;
 
 
UPDATE `pos_world`.`item_template` SET 
`name` = 'Zelezne narameniky',
`description` = 'Kvalitni prace',
`Quality` = '3'
 
WHERE `item_template`.`entry` =3840;
 
 
 
UPDATE `pos_world`.`item_template` SET 
`name` = 'Zelezne zapestniky',
`description` = 'Kvalitni prace',
`Quality` = '3'
 
WHERE `item_template`.`entry` =3835;
 
 
 
 
UPDATE `pos_world`.`item_template` SET 
`name` = 'Zelezna helma',
`description` = 'Kvalitni prace',
`Quality` = '3'
 
WHERE `item_template`.`entry` =3836;
 
 
 
 
UPDATE `pos_world`.`item_template` SET 
`name` = 'Zelezne boty',
`description` = 'Kvalitni prace',
`Quality` = '3'
 
WHERE `item_template`.`entry` =7916;
 
##Zbrane
 
 
UPDATE `pos_world`.`item_template` SET 
`name` = 'Medeny dvojrucny mec',
`description` = 'Kvalitni prace',
`Quality` = '1'
 
WHERE `item_template`.`entry` =7955;
 
 
UPDATE `pos_world`.`item_template` SET 
`name` = 'Medena dyka',
`description` = 'Kvalitni prace',
`Quality` = '1'
 
WHERE `item_template`.`entry` =7166;
 
 
 
UPDATE `pos_world`.`item_template` SET 
`name` = 'Postribrena sekera',
`description` = 'Kvalitni prace',
`Quality` = '1'
 
WHERE `item_template`.`entry` =3489;
 
 
 
UPDATE `pos_world`.`item_template` SET 
`name` = 'Zdobena dyka',
`description` = 'Kvalitni prace',
`Quality` = '2'
 
WHERE `item_template`.`entry` =3848;
 
 
UPDATE `pos_world`.`item_template` SET 
`name` = 'Primitivni mec',
`description` = 'Kvalitni prace',
`Quality` = '2'
 
WHERE `item_template`.`entry` =2850;
 
 
UPDATE `pos_world`.`item_template` SET 
`name` = 'Obojrucni bronzova sekera',
`description` = 'Kvalitni prace',
`Quality` = '2'
 
WHERE `item_template`.`entry` =7958;
 
 
UPDATE `pos_world`.`item_template` SET 
`name` = 'Medene sipky',
`description` = 'Kvalitni prace',
`Quality` = '2'
 
WHERE `item_template`.`entry` =29201;
 
 
UPDATE `pos_world`.`item_template` SET 
`name` = 'Zdobene kladivo',
`description` = 'Kvalitni prace',
`Quality` = '2'
 
WHERE `item_template`.`entry` =3491;
 
 
UPDATE `pos_world`.`item_template` SET 
`name` = 'Postribrene kladivo',
`description` = 'Kvalitni prace',
`Quality` = '3'
 
WHERE `item_template`.`entry` =3851;
 
##Suroviny
 
 
UPDATE `pos_world`.`item_template` SET 
`name` = 'Brusny kamen',
`BuyPrice` = '0',
`SellPrice` = '0'
 
WHERE `item_template`.`entry` =3470;
 
UPDATE `pos_world`.`item_template` SET 
`name` = 'Lepsi brusny kamen',
`BuyPrice` = '0',
`SellPrice` = '0'
 
WHERE `item_template`.`entry` =3478;
 
 
UPDATE `pos_world`.`item_template` SET 
`name` = 'Kvalitni brusny kamen',
`BuyPrice` = '0',
`SellPrice` = '0'
 
WHERE `item_template`.`entry` =3486;
 
 
 
 
 
UPDATE `pos_world`.`item_template` SET 
`name` = 'Vystuz do bot',
`BuyPrice` = '150',
`SellPrice` = '0'
 
WHERE `item_template`.`entry` =5637;
 
 
UPDATE `pos_world`.`item_template` SET 
`name` = 'Brousek',
`BuyPrice` = '0',
`SellPrice` = '0'
 
WHERE `item_template`.`entry` =2862;
 
 
UPDATE `pos_world`.`item_template` SET 
`name` = 'Vyvazovadlo',
`BuyPrice` = '0',
`SellPrice` = '0'
 
WHERE `item_template`.`entry` =3239;

SQL Dopyt

 
/* Aliance 5511 Medene*/
 
INSERT INTO `npc_trainer` (`entry`, `spell`, `spellcost`, `reqskill`, `reqskillvalue`, `reqlevel`) VALUES
(5511 , 3320, 0, 164, 5, 0),
(5511 , 3326, 0, 164, 5, 0),
(5511 , 3337, 0, 164, 10, 0),
(5511 , 3319, 0, 164, 15, 0),
(5511 , 3323, 0, 164, 20, 0),
(5511 , 2661, 0, 164, 25, 0);
 
/* Aliance 26988 Bronzove*/
 
INSERT INTO `npc_trainer` (`entry`, `spell`, `spellcost`, `reqskill`, `reqskillvalue`, `reqlevel`) VALUES
(26988, 2670, 0, 164, 30, 0),
(26988, 2668, 0, 164, 35, 0),
(26988, 3328, 0, 164, 40, 0),
(26988, 2672, 0, 164, 45, 0),
(26988, 7817, 0, 164, 50, 0);
 
/* Aliance 26904 Zelezne*/
INSERT INTO `npc_trainer` (`entry`, `spell`, `spellcost`, `reqskill`, `reqskillvalue`, `reqlevel`) VALUES
(26904 , 3506, 0, 164, 55, 0),
(26904 , 9813, 0, 164, 60, 0),
(26904 , 3504, 0, 164, 65, 0),
(26904 , 3501, 0, 164, 70, 0),
(26904 , 3502, 0, 164, 75, 0);
 
/* Aliance 4258 Zbrane*/
INSERT INTO `npc_trainer` (`entry`, `spell`, `spellcost`, `reqskill`, `reqskillvalue`, `reqlevel`) VALUES
(4258, 9983, 0, 164, 15, 0),
(4258, 8880, 0, 164, 20, 0),
(4258, 3294, 0, 164, 25, 0),
(4258, 3491, 0, 164, 30, 0),
(4258, 2742, 0, 164, 35, 0),
(4258, 9987, 0, 164, 45, 0),
(4258, 34979, 0, 164, 55, 0),
(4258, 3296, 0, 164, 60, 0),
(4258, 3494, 0, 164, 75, 0);
 
 
/* Horda  3174 Medene*/
 
INSERT INTO `npc_trainer` (`entry`, `spell`, `spellcost`, `reqskill`, `reqskillvalue`, `reqlevel`) VALUES
(3174, 3320, 0, 164, 5, 0),
(3174, 3326, 0, 164, 5, 0),
(3174, 3337, 0, 164, 10, 0),
(3174, 3319, 0, 164, 15, 0),
(3174, 3323, 0, 164, 20, 0),
(3174, 2661, 0, 164, 25, 0);
 
/* Horda 4596 Bronzove*/
 
INSERT INTO `npc_trainer` (`entry`, `spell`, `spellcost`, `reqskill`, `reqskillvalue`, `reqlevel`) VALUES
(4596, 2670, 0, 164, 30, 0),
(4596, 2668, 0, 164, 35, 0),
(4596, 3328, 0, 164, 40, 0),
(4596, 2672, 0, 164, 45, 0),
(4596, 7817, 0, 164, 50, 0);
 
/* Horda 3478Zelezne*/
INSERT INTO `npc_trainer` (`entry`, `spell`, `spellcost`, `reqskill`, `reqskillvalue`, `reqlevel`) VALUES
(3478, 3506, 0, 164, 55, 0),
(3478, 9813, 0, 164, 60, 0),
(3478, 3504, 0, 164, 65, 0),
(3478, 3501, 0, 164, 70, 0),
(3478, 3502, 0, 164, 75, 0);
 
/* Horda 3355 Zbrane*/
INSERT INTO `npc_trainer` (`entry`, `spell`, `spellcost`, `reqskill`, `reqskillvalue`, `reqlevel`) VALUES
(3355, 9983, 0, 164, 15, 0),
(3355, 8880, 0, 164, 20, 0),
(3355, 3294, 0, 164, 25, 0),
(3355, 3491, 0, 164, 30, 0),
(3355, 2742, 0, 164, 35, 0),
(3355, 9987, 0, 164, 45, 0),
(3355, 34979, 0, 164, 55, 0),
(3355, 3296, 0, 164, 65, 0),
(3355, 3494, 0, 164, 75, 0);

Ucitele :

Aliance : 5511(medene zborje), 26988(bronzove zbroje), 26904(zelezne zbroje), 4258(zbrane), 1681 (smelteni)
Horda : 3174(medene zboje), 4596(bronzove zbroje), 3478(zelezne zbroje), 3355(zbrane), 4605 (smelteni)

Alchemie

SQL Dopyt

 
 
 
##Prisady
 
UPDATE `rp_mangos`.`item_template` SET 
`name` = 'Prazdna lahvicka',
`BuyPrice` = '35',
`SellPrice` = '0',
`Quality` = '1'
 
WHERE `item_template`.`entry` =3371;
 
 
 
UPDATE `rp_mangos`.`item_template` SET 
`name` = 'Medvedi koren', 
`BuyPrice` = '50',
`SellPrice` = '0',
`Quality` = '1'
 
WHERE `item_template`.`entry` =2449;
 
UPDATE `rp_mangos`.`item_template` SET 
`name` = 'List Stribrniku', 
`BuyPrice` = '50',
`SellPrice` = '0',
`Quality` = '1'
 
WHERE `item_template`.`entry` =765;
 
 
UPDATE `rp_mangos`.`item_template` SET 
`name` = 'Belokvet', 
`BuyPrice` = '50',
`SellPrice` = '0',
`Quality` = '1'
 
WHERE `item_template`.`entry` =2447;
 
 
UPDATE `rp_mangos`.`item_template` SET 
`name` = 'Carokvet', 
`BuyPrice` = '100',
`SellPrice` = '0',
`Quality` = '1'
 
WHERE `item_template`.`entry` =785;
 
 
 
 
UPDATE `rp_mangos`.`item_template` SET 
`name` = 'Zelensky list',
`BuyPrice` = '100',
`SellPrice` = '0',
`Quality` = '1'
 
WHERE `item_template`.`entry` =2452;
 
 
 
UPDATE `rp_mangos`.`item_template` SET 
`name` = 'Lahvicka medvedi krve',  
`BuyPrice` = '0',
`SellPrice` = '0',
`Quality` = '1'
 
WHERE `item_template`.`entry` =5635;
 
 
 
UPDATE `rp_mangos`.`item_template` SET 
`name` = 'Hadi trn',  
`BuyPrice` = '50',
`SellPrice` = '0',
`Quality` = '1'
 
WHERE `item_template`.`entry` =2450;
 
UPDATE `rp_mangos`.`item_template` SET 
`name` = 'Lih',  
`BuyPrice` = '50',
`SellPrice` = '0',
`Quality` = '1'
 
WHERE `item_template`.`entry` =3164;
 
 
 
##Lektvary
 
 UPDATE `pos_world`.`item_template` SET 
`name` = 'Lektvar bystrosti',  ##+15 AGI
`BuyPrice` = '0',
`SellPrice` = '0',
`InventoryType` = '12',
`spellid_1` = '11328',
`spellcooldown_1` = '0',
`spellcharges_1` = '-1',
`Duration` = '0' 
 
WHERE `item_template`.`entry` =2458;
 
 UPDATE `pos_world`.`item_template` SET 
`name` = 'Lektvar sily', ##+25 STR
`BuyPrice` = '0',
`SellPrice` = '0',
`InventoryType` = '12',
`spellid_1` = '11405', 
`spellcooldown_1` = '0',
`spellcharges_1` = '-1',
`Duration` = '0' 
 
WHERE `item_template`.`entry` =2454;
 
 
 
 UPDATE `pos_world`.`item_template` SET 
`name` = 'Lecivy Lektvar', ##500 Heal
`BuyPrice` = '100',
`SellPrice` = '0',
`InventoryType` = '12',
`spellid_1` = '2024', 
`spellcooldown_1` = '0',
`spellcharges_1` = '-1',
`Duration` = '0' 
 
WHERE `item_template`.`entry` =118;
 
 
 UPDATE `pos_world`.`item_template` SET 
`name` = 'Lektvar kamene', ##2000 Armour/1,5 min
`BuyPrice` = '0',
`SellPrice` = '0',
`InventoryType` = '12',
`spellid_1` = '17540', 
`spellcooldown_1` = '0',
`spellcharges_1` = '-1',
`Duration` = '0' 
 
WHERE `item_template`.`entry` =3382;
 
 
 UPDATE `pos_world`.`item_template` SET 
`name` = 'Lektvar magicke Moci',  ##500 Many
`BuyPrice` = '100',
`SellPrice` = '0',
`InventoryType` = '12',
`spellid_1` = '2023',
`spellcooldown_1` = '0',
`spellcharges_1` = '-1',
`Duration` = '0' 
 
WHERE `item_template`.`entry` =2455;
 
 
 UPDATE `pos_world`.`item_template` SET 
`name` = 'Lektvar moudrosti', ##Regen many
`BuyPrice` = '0',
`SellPrice` = '0',
`InventoryType` = '12',
`spellid_1` = '24363',
`spellcooldown_1` = '0',
`spellcharges_1` = '-1',
`Duration` = '0' 
 
WHERE `item_template`.`entry` =2456;
 
 
 UPDATE `pos_world`.`item_template` SET 
`name` = 'Molotov', ##500 DMG
`BuyPrice` = '0',
`SellPrice` = '0',
`InventoryType` = '12',
`spellid_1` = '11667',
`spellcooldown_1` = '0',
`spellcharges_1` = '-1',
`Duration` = '0' 
 
WHERE `item_template`.`entry` =4596;
 
 
 UPDATE `pos_world`.`item_template` SET 
`name` = 'Lektvar obriho vzrustu', ##+8STR a Velikost
`BuyPrice` = '0',
`SellPrice` = '0',
`InventoryType` = '12',
`spellid_1` = '8212',
`spellcooldown_1` = '0',
`spellcharges_1` = '-1',
`Duration` = '0' 
 
WHERE `item_template`.`entry` =2457;
 
 
 UPDATE `pos_world`.`item_template` SET 
`name` = 'Lektvar rychlosti', ##Movment Speed
`BuyPrice` = '0',
`SellPrice` = '0',
`InventoryType` = '12',
`spellid_1` = '2379',
`spellcooldown_1` = '0',
`spellcharges_1` = '-1',
`Duration` = '0' 
 
WHERE `item_template`.`entry` =2459;
 
 
 UPDATE `pos_world`.`item_template` SET 
`name` = 'Lektvar zurivosti medveda', ##Rage
`BuyPrice` = '0',
`SellPrice` = '0',
`InventoryType` = '12',
`spellid_1` = '6613',
`spellcooldown_1` = '0',
`spellcharges_1` = '-1',
`Duration` = '0' 
 
WHERE `item_template`.`entry` =5631;
 
 
 UPDATE `pos_world`.`item_template` SET 
`name` = 'Rybi elixir', ##Přeměna na rybu
`BuyPrice` = '0',
`SellPrice` = '0',
`InventoryType` = '0',
`spellid_1` = '24347',
`spellcooldown_1` = '0',
`spellcharges_1` = '-1',
`Duration` = '0' 
 
WHERE `item_template`.`entry` =6662;
 
 UPDATE `pos_world`.`item_template` SET 
`name` = '"Specialni" Lecivi Lektvara', ##30s self stun
`BuyPrice` = '0',
`SellPrice` = '0',
`InventoryType` = '0',
`spellid_1` = '9032',
`spellcooldown_1` = '0',
`spellcharges_1` = '-1',
`description` = 'Vypada jako posilujci lektvar. (pouziti pravim tracitkem)',
`Duration` = '0' 
 
WHERE `item_template`.`entry` =858;
 
 UPDATE `pos_world`.`item_template` SET 
`name` = 'Lektvar ocisteni', ##Ocisteni jedu nebo kledby 
`BuyPrice` = '0',
`SellPrice` = '0',
`InventoryType` = '0',
`spellid_1` = '17550',  
`spellcooldown_1` = '0',
`spellcharges_1` = '-1',
`Duration` = '0' 
 
WHERE `item_template`.`entry` =5997;

SQL Dopyt

 
 
 
 
 
 
/* Aliance - 4160*/
INSERT INTO `npc_trainer` (`entry`, `spell`, `spellcost`, `reqskill`, `reqskillvalue`, `reqlevel`) VALUES
 
(4160, 3170, 0, 171, 10, 0),
(4160, 2331, 0, 171, 15, 0),
(4160, 7183, 0, 171, 20, 0),
(4160, 2330, 0, 171, 25, 0),
(4160, 4508, 0, 171, 30, 0);
 
/* Aliance - 5177*/
INSERT INTO `npc_trainer` (`entry`, `spell`, `spellcost`, `reqskill`, `reqskillvalue`, `reqlevel`) VALUES
 
(5177, 3230, 0, 171, 30, 0),
(5177, 2332, 0, 171, 40, 0),
(5177, 2334, 0, 171, 40, 0),
(5177, 2337, 0, 171, 50, 0),
(5177, 2329, 0, 171, 50, 0),
(5177, 6617, 0, 171, 30, 0),
(5177, 8240, 0, 171, 60, 0),
(5177, 2335, 0, 171, 70, 0);
 
 
/* Horda - 27029*/
INSERT INTO `npc_trainer` (`entry`, `spell`, `spellcost`, `reqskill`, `reqskillvalue`, `reqlevel`) VALUES
 
(27029, 3170, 0, 171, 10, 0),
(27029, 2331, 0, 171, 15, 0),
(27029, 7183, 0, 171, 20, 0),
(27029, 2330, 0, 171, 25, 0),
(27029, 4508, 0, 171, 30, 0);
 
/* Horda - 3347 */
INSERT INTO `npc_trainer` (`entry`, `spell`, `spellcost`, `reqskill`, `reqskillvalue`, `reqlevel`) VALUES
 
(3347 , 3230, 0, 171, 30, 0),
(3347 , 2334, 0, 171, 40, 0),
(3347 , 2332, 0, 171, 40, 0),
(3347 , 2337, 0, 171, 50, 0),
(3347 , 2329, 0, 171, 50, 0),
(3347 , 6617, 0, 171, 30, 0),
(3347 , 8240, 0, 171, 60, 0),
(3347 , 2335, 0, 171, 70, 0);

Ucitele

Aliance : 4160 < 5177
Horda : 27029 < 3347

Šití

SQL Dopyt

 
 
 
 
/* Latkove - Qualiti 1 */
 
UPDATE `pos_world`.`item_template` SET 
`description` = 'Kvalitni prace',
`name` = 'Hnede triko'
 
WHERE `item_template`.`entry` =4344;
 
 
UPDATE `pos_world`.`item_template` SET 
`description` = 'Kvalitni prace',
`name` = 'Kratka kape'
 
 
WHERE `item_template`.`entry` =2570;
 
UPDATE `pos_world`.`item_template` SET 
`description` = 'Kvalitni prace',
`name` = 'Modre kalhoty'
 
 
WHERE `item_template`.`entry` =10045;
 
UPDATE `pos_world`.`item_template` SET 
`description` = 'Kvalitni prace',
`name` = 'Bila kosile'
 
 
WHERE `item_template`.`entry` =2576;
 
UPDATE `pos_world`.`item_template` SET 
`description` = 'Kvalitni prace',
`name` = 'Hnede vesta'
 
 WHERE `item_template`.`entry` =2568;
 
UPDATE `pos_world`.`item_template` SET 
`description` = 'Kvalitni prace',
`name` = 'Pasek'
 
 WHERE `item_template`.`entry` =7026;
 
UPDATE `pos_world`.`item_template` SET 
`description` = 'Kvalitni prace',
`name` = 'Černe boty'
 
WHERE `item_template`.`entry` =10046;
 
UPDATE `pos_world`.`item_template` SET
`description` = 'Kvalitni prace', 
`name` = 'Modre triko'
 
 
WHERE `item_template`.`entry` =2577;
 
UPDATE `pos_world`.`item_template` SET
`description` = 'Kvalitni prace', 
`name` = 'Cervene triko'
 
 
WHERE `item_template`.`entry` =2575;
 
UPDATE `pos_world`.`item_template` SET
`description` = 'Kvalitni prace', 
`name` = 'Domaci obleceni'
 
WHERE `item_template`.`entry` =6786;
 
UPDATE `pos_world`.`item_template` SET
`description` = 'Kvalitni prace', 
`name` = 'Zelene triko'
 
WHERE `item_template`.`entry` =2579;
 
/* Vlnene - Qualiti 1 */
 
UPDATE `pos_world`.`item_template` SET 
`description` = 'Kvalitni prace',
`name` = 'Sede triko'
 
WHERE `item_template`.`entry` =2587;
 
UPDATE `pos_world`.`item_template` SET
`description` = 'Kvalitni prace', 
`name` = 'Cervene elegantni tricko'
 
WHERE `item_template`.`entry` =4330;
 
UPDATE `pos_world`.`item_template` SET 
`description` = 'Kvalitni prace',
`name` = 'Svatebni saty'
 
WHERE `item_template`.`entry` =6787;
 
 
/* Latkove kvalitni - Qualiti 2 */
 
 
UPDATE `pos_world`.`item_template` SET
`description` = 'Kvalitni prace', 
`name` = 'Kvalitni kalhoty',
`Quality` = '2'
 
 
WHERE `item_template`.`entry` =4343;
 
 
UPDATE `pos_world`.`item_template` SET 
`description` = 'Kvalitni prace',
`name` = 'Hneda roba',
`Quality` = '2'
 
WHERE `item_template`.`entry` =6238;
 
UPDATE `pos_world`.`item_template` SET
`description` = 'Kvalitni prace', 
`name` = 'Bila roba',
`Quality` = '2'
 
WHERE `item_template`.`entry` =6241;
 
UPDATE `pos_world`.`item_template` SET
`description` = 'Kvalitni prace', 
`name` = 'Hnede rukavice',
`Quality` = '2'
 
WHERE `item_template`.`entry` =4307;
 
UPDATE `pos_world`.`item_template` SET
`description` = 'Kvalitni prace', 
`name` = 'Cervena roba',
`Quality` = '2'
 
WHERE `item_template`.`entry` =2572;
 
 
 
UPDATE `pos_world`.`item_template` SET 
`description` = 'Kvalitni prace',
`name` = 'Modra vesta',
`Quality` = '2'
 
WHERE `item_template`.`entry` =6240;
 
UPDATE `pos_world`.`item_template` SET
`description` = 'Kvalitni prace', 
`name` = 'Cervena vesta',
`Quality` = '2'
 
WHERE `item_template`.`entry` =6239;
 
 
UPDATE `pos_world`.`item_template` SET
`description` = 'Kvalitni prace', 
`name` = 'Zelene latkove nalokerniky',
`Quality` = '2'
 
WHERE `item_template`.`entry` =4308;
 
 
UPDATE `pos_world`.`item_template` SET 
`description` = 'Kvalitni prace',
`name` = 'Kvalitni kape',
`Quality` = '2'
 
WHERE `item_template`.`entry` =2580;
 
 
UPDATE `pos_world`.`item_template` SET 
`description` = 'Kvalitni prace',
`name` = 'Kvalitni boty',
`Quality` = '2'
 
WHERE `item_template`.`entry` =2569;
 
 
UPDATE `pos_world`.`item_template` SET
`description` = 'Kvalitni prace', 
`name` = 'Kozena vesta',
`Quality` = '2'
 
WHERE `item_template`.`entry` =2578;
 
 
UPDATE `pos_world`.`item_template` SET
`description` = 'Kvalitni prace', 
`name` = 'Modra roba',
`Quality` = '2'
 
WHERE `item_template`.`entry` =6242;
 
 
UPDATE `pos_world`.`item_template` SET
`description` = 'Kvalitni prace', 
`name` = 'Kratke kalhoty',
`Quality` = '2'
 
 
WHERE `item_template`.`entry` =4309;
 
UPDATE `pos_world`.`item_template` SET
`description` = 'Kvalitni prace', 
`name` = 'Modra sukne',
`Quality` = '2'
 
 
WHERE `item_template`.`entry` =10047;
 
UPDATE `pos_world`.`item_template` SET 
`description` = 'Kvalitni prace',
`name` = 'Kvalitni kozene boty',
`Quality` = '2'
 
 
WHERE `item_template`.`entry` =4312;
 
/* Vlnene - Qualiti 3 */
 
 
UPDATE `pos_world`.`item_template` SET 
`description` = 'Kvalitni prace',
`name` = 'Vlnena kape',
`Quality` = '3'
 
WHERE `item_template`.`entry` =2584;
 
 
 
UPDATE `pos_world`.`item_template` SET 
`description` = 'Kvalitni prace',
`name` = 'Zelena vlnena vesta',
`Quality` = '3'
 
WHERE `item_template`.`entry` =2582;
 
 
 
UPDATE `pos_world`.`item_template` SET 
`description` = 'Kvalitni prace',
`name` = 'Vlnena rukavice',
`Quality` = '3'
 
WHERE `item_template`.`entry` =4310;
 
 
 
UPDATE `pos_world`.`item_template` SET 
`description` = 'Kvalitni prace',
`name` = 'Zdobena vlnena kape',
`Quality` = '3'
 
WHERE `item_template`.`entry` =5542;
 
 
 
UPDATE `pos_world`.`item_template` SET
`description` = 'Kvalitni prace', 
`name` = 'Cervene vlnene boty',
`Quality` = '3'
 
WHERE `item_template`.`entry` =4313;
 
 
 
UPDATE `pos_world`.`item_template` SET 
`description` = 'Kvalitni prace',
`name` = 'Vlnene boty',
`Quality` = '3'
 
WHERE `item_template`.`entry` =2583;
 
 
 
UPDATE `pos_world`.`item_template` SET
`description` = 'Kvalitni prace', 
`name` = 'Kalhoty s ksandami',
`Quality` = '3'
 
WHERE `item_template`.`entry` =6263;
 
 
 
UPDATE `pos_world`.`item_template` SET
`description` = 'Kvalitni prace', 
`name` = 'Zdobena kape',
`Quality` = '3'
 
WHERE `item_template`.`entry` =4311;
 
 
 
UPDATE `pos_world`.`item_template` SET 
`description` = 'Kvalitni prace',
`name` = 'Pohrebni saty',
`Quality` = '3'
 
WHERE `item_template`.`entry` =2585;
 
UPDATE `pos_world`.`item_template` SET 
`description` = 'Kvalitni prace',
`name` = 'Vlenene narameniky',
`Quality` = '3'
 
WHERE `item_template`.`entry` =4314;
 
UPDATE `pos_world`.`item_template` SET
`description` = 'Kvalitni prace', 
`name` = 'Hnede kvalitni kalhoty',
`Quality` = '3'
 
WHERE `item_template`.`entry` =4316;
 
UPDATE `pos_world`.`item_template` SET
`description` = 'Kvalitni prace', 
`name` = 'Elegantni zluta roba',
`Quality` = '3'
 
WHERE `item_template`.`entry` =6264;
 
/* Batohy */
 
 
UPDATE `pos_world`.`item_template` SET
 
`BuyPrice` = '0',
`SellPrice` = '0',
`name` = 'Pytel'
 
WHERE `item_template`.`entry` =4238;
 
 
 
UPDATE `pos_world`.`item_template` SET
 
`BuyPrice` = '0',
`SellPrice` = '0', 
`name` = 'Cerveny pytel'
 
WHERE `item_template`.`entry` =5762;
 
 
 
UPDATE `pos_world`.`item_template` SET 
`BuyPrice` = '0',
`SellPrice` = '0',
`name` = 'Vlneny pytel'
 
WHERE `item_template`.`entry` =4240;
 
UPDATE `pos_world`.`item_template` SET
`BuyPrice` = '0',
`SellPrice` = '0', 
`name` = 'Zeleny vlneny pytel'
 
WHERE `item_template`.`entry` =4241;
 
UPDATE `pos_world`.`item_template` SET
`BuyPrice` = '0',
`SellPrice` = '0', 
`name` = 'Cerveny vlneny pytel'
 
WHERE `item_template`.`entry` =5763;
 
 
 
/* Suroviny, Mezivyrobky */
 
 
 
UPDATE `pos_world`.`item_template` SET 
`name` = 'Kvalitni vlna',
`BuyPrice` = '0',
`SellPrice` = '0'
 
WHERE `item_template`.`entry` =2997;
 
UPDATE `pos_world`.`item_template` SET 
`name` = 'Kvalitni platno',
`BuyPrice` = '0',
`SellPrice` = '0'
 
WHERE `item_template`.`entry` =2996;
 
UPDATE `pos_world`.`item_template` SET
`BuyPrice` = '20',
`SellPrice` = '0', 
`name` = 'Nit'
 
WHERE `item_template`.`entry` =2320;
 
 
UPDATE `pos_world`.`item_template` SET 
`BuyPrice` = '150',
`SellPrice` = '0',
`name` = 'Belidlo'
 
WHERE `item_template`.`entry` =2324;
 
UPDATE `pos_world`.`item_template` SET 
`BuyPrice` = '150',
`SellPrice` = '0',
`name` = 'Cervena barva'
 
WHERE `item_template`.`entry` =2604;
 
 
UPDATE `pos_world`.`item_template` SET
`BuyPrice` = '150',
`SellPrice` = '0', 
`name` = 'Modra barva'
 
WHERE `item_template`.`entry` =6260;
 
 
UPDATE `pos_world`.`item_template` SET
`BuyPrice` = '150',
`SellPrice` = '0', 
`name` = 'Zelene barva'
 
WHERE `item_template`.`entry` =2605;
 
UPDATE `pos_world`.`item_template` SET
`BuyPrice` = '150',
`SellPrice` = '0', 
`name` = 'Seda barva'
 
WHERE `item_template`.`entry` =4340;
 
UPDATE `pos_world`.`item_template` SET 
`BuyPrice` = '25',
`SellPrice` = '0',
`name` = 'Kvalitni nit'
 
WHERE `item_template`.`entry` =2321;
 
UPDATE `pos_world`.`item_template` SET 
`name` = 'Perla',
`BuyPrice` = '0',
`SellPrice` = '0'
 
WHERE `item_template`.`entry` =5498;
 
 
UPDATE `pos_world`.`item_template` SET 
`name` = 'Kus vlny',
`BuyPrice` = '50',
`SellPrice` = '0'
 
WHERE `item_template`.`entry` =2592 ;

SQL Dopyt

 
 
/* Aliance - 1103  */
INSERT INTO `npc_trainer` (`entry`, `spell`, `spellcost`, `reqskill`, `reqskillvalue`, `reqlevel`) VALUES
(1103 , 2964, 0, 197, 1, 0),
(1103 , 2963, 0, 197, 2, 0),
(1103 , 3915, 0, 197, 3, 0),
(1103 , 2387, 0, 197, 4, 0),
(1103 , 12044, 0, 197, 5, 0),
(1103 , 2393, 0, 197, 6, 0),
(1103 , 2385, 0, 197, 7, 0),
(1103 , 8776, 0, 197, 8, 0),
(1103 , 12045, 0, 197, 9, 0),
(1103 , 2394, 0, 197, 10, 0),
(1103 , 2392, 0, 197, 11, 0),
(1103 , 8465, 0, 197, 12, 0),
(1103 , 2396, 0, 197, 13, 0);
 
 
/* Aliance - 28699*/
INSERT INTO `npc_trainer` (`entry`, `spell`, `spellcost`, `reqskill`, `reqskillvalue`, `reqlevel`) VALUES
(28699, 3914, 0, 197, 15, 0),
(28699, 7623, 0, 197, 16, 0),
(28699, 7624, 0, 197, 17, 0),
(28699, 3840, 0, 197, 18, 0),
(28699, 2389, 0, 197, 19, 0),
(28699, 7630, 0, 197, 20, 0),
(28699, 7629, 0, 197, 21, 0),
(28699, 3841, 0, 197, 22, 0),
(28699, 2397, 0, 197, 23, 0),
(28699, 2386, 0, 197, 24, 0),
(28699, 2395, 0, 197, 25, 0),
(28699, 7633, 0, 197, 26, 0),
(28699, 3842, 0, 197, 27, 0),
(28699, 12046, 0, 197, 28, 0),
(28699, 3845, 0, 197, 29, 0);
 
/* Aliance - 5153*/
INSERT INTO `npc_trainer` (`entry`, `spell`, `spellcost`, `reqskill`, `reqskillvalue`, `reqlevel`) VALUES
(5153, 2402, 0, 197, 30, 0),
(5153, 2406, 0, 197, 34, 0),
(5153, 3866, 0, 197, 38, 0),
(5153, 2399, 0, 197, 42, 0),
(5153, 3843, 0, 197, 46, 0),
(5153, 6521, 0, 197, 50, 0),
(5153, 3847, 0, 197, 54, 0),
(5153, 2401, 0, 197, 58, 0),
(5153, 7639, 0, 197, 62, 0),
(5153, 3844, 0, 197, 66, 0),
(5153, 2403, 0, 197, 70, 0),
(5153, 3848, 0, 197, 71, 0),
(5153, 3850, 0, 197, 72, 0),
(5153, 7643, 0, 197, 75, 0),
(5153, 3755, 0, 197, 25, 0),/* Pytle */
(5153, 6686, 0, 197, 30, 0),
(5153, 3758, 0, 197, 45, 0),
(5153, 6688, 0, 197, 50, 0),
(5153, 3757, 0, 197, 60, 0);
 
 
/* Horda- 3704*/
INSERT INTO `npc_trainer` (`entry`, `spell`, `spellcost`, `reqskill`, `reqskillvalue`, `reqlevel`) VALUES
(3704, 2964, 0, 197, 1, 0),
(3704, 2963, 0, 197, 2, 0),
(3704, 3915, 0, 197, 3, 0),
(3704, 2387, 0, 197, 4, 0),
(3704, 12044, 0, 197, 5, 0),
(3704, 2393, 0, 197, 6, 0),
(3704, 2385, 0, 197, 7, 0),
(3704, 8776, 0, 197, 8, 0),
(3704, 12045, 0, 197, 9, 0),
(3704, 2394, 0, 197, 10, 0),
(3704, 2392, 0, 197, 11, 0),
(3704, 8465, 0, 197, 12, 0),
(3704, 2396, 0, 197, 13, 0);
 
 
/* Horda - 16640*/
INSERT INTO `npc_trainer` (`entry`, `spell`, `spellcost`, `reqskill`, `reqskillvalue`, `reqlevel`) VALUES
(16640, 3914, 0, 197, 14, 0),
(16640, 7623, 0, 197, 15, 0),
(16640, 7624, 0, 197, 16, 0),
(16640, 3840, 0, 197, 17, 0),
(16640, 2389, 0, 197, 18, 0),
(16640, 7630, 0, 197, 19, 0),
(16640, 7629, 0, 197, 20, 0),
(16640, 3841, 0, 197, 21, 0),
(16640, 2397, 0, 197, 22, 0),
(16640, 2386, 0, 197, 23, 0),
(16640, 2395, 0, 197, 24, 0),
(16640, 7633, 0, 197, 25, 0),
(16640, 3842, 0, 197, 26, 0),
(16640, 12046, 0, 197, 27, 0),
(16640, 3845, 0, 197, 28, 0);
 
/* Horda - 26969*/
INSERT INTO `npc_trainer` (`entry`, `spell`, `spellcost`, `reqskill`, `reqskillvalue`, `reqlevel`) VALUES
(26969, 2402, 0, 197, 30, 0),
(26969, 2406, 0, 197, 34, 0),
(26969, 3866, 0, 197, 38, 0),
(26969, 2399, 0, 197, 42, 0),
(26969, 3843, 0, 197, 44, 0),
(26969, 6521, 0, 197, 50, 0),
(26969, 3847, 0, 197, 54, 0),
(26969, 2401, 0, 197, 58, 0),
(26969, 7639, 0, 197, 62, 0),
(26969, 3844, 0, 197, 66, 0),
(26969, 2403, 0, 197, 70, 0),
(26969, 3848, 0, 197, 71, 0),
(26969, 3850, 0, 197, 72, 0),
(26969, 7643, 0, 197, 75, 0),
(26969, 3755, 0, 197, 25, 0),
(26969, 6686, 0, 197, 30, 0),
(26969, 3758, 0, 197, 45, 0),
(26969, 6688, 0, 197, 50, 0),
(26969, 3757, 0, 197, 60, 0);

Ucitele:

Aliance : 1103<28699<5153
HOrda : 3704<16640<26969

Kožedělství

SQL Dopyt

 
/* Suroviny */
 
 
UPDATE `pos_world`.`item_template` SET 
`name` = 'Kus kuze',
`BuyPrice` = '0',
`SellPrice` = '0',
`description` = 'K siti nepouzitelny'
 
WHERE `item_template`.`entry` =2934;
 
 
UPDATE `pos_world`.`item_template` SET 
`name` = 'Pevna kuze',
`BuyPrice` = '0',
`SellPrice` = '0'
 
WHERE `item_template`.`entry` =4234;
 
UPDATE `pos_world`.`item_template` SET 
`name` = 'Jemna kuze',
`BuyPrice` = '0',
`SellPrice` = '0'
 
WHERE `item_template`.`entry` =2318;
 
UPDATE `pos_world`.`item_template` SET 
`name` = 'Lehka kuze',
`BuyPrice` = '0',
`SellPrice` = '0'
 
WHERE `item_template`.`entry` =4231;
 
UPDATE `pos_world`.`item_template` SET 
`name` = 'Kodi kuze',
`BuyPrice` = '0',
`SellPrice` = '0'
 
WHERE `item_template`.`entry` =5082;
 
UPDATE `pos_world`.`item_template` SET 
`name` = 'Supina',
`BuyPrice` = '0',
`SellPrice` = '0'
 
WHERE `item_template`.`entry` =5784;
 
 
UPDATE `pos_world`.`item_template` SET 
`name` = 'Cerna supina',
`BuyPrice` = '0',
`SellPrice` = '0'
 
WHERE `item_template`.`entry` =7286;
 
 
UPDATE `pos_world`.`item_template` SET 
`name` = 'Kvalitni kuze',
`BuyPrice` = '0',
`SellPrice` = '0'
 
WHERE `item_template`.`entry` =2319;
 
 
 
UPDATE `pos_world`.`item_template` SET 
`name` = 'Jesteri Supina',
`BuyPrice` = '0',
`SellPrice` = '0'
 
WHERE `item_template`.`entry` =6470;
 
 
 
UPDATE `pos_world`.`item_template` SET 
`name` = 'Cerna jesteri supina',
`BuyPrice` = '0',
`SellPrice` = '0'
 
WHERE `item_template`.`entry` =6471;
 
 
 
UPDATE `pos_world`.`item_template` SET 
`name` = 'Cervena supina',
`BuyPrice` = '0',
`SellPrice` = '0'
 
WHERE `item_template`.`entry` =7287;
 
 
 
 
/* Vyrobky z kvalitni kuze - Quality 1 */
 
 
 
 
 
UPDATE `pos_world`.`item_template` SET 
`description` = 'Kvalitni prace',
`name` = 'Kozene vysoke boty'
 
WHERE `item_template`.`entry` =2302;
 
UPDATE `pos_world`.`item_template` SET
`description` = 'Kvalitni prace', 
`name` = 'Kozene naloketniky'
 
WHERE `item_template`.`entry` =7277;
 
 
UPDATE `pos_world`.`item_template` SET
`description` = 'Kvalitni prace', 
`name` = 'Kozene kape'
 
WHERE `item_template`.`entry` =7276;
 
UPDATE `pos_world`.`item_template` SET
`description` = 'Kvalitni prace', 
`name` = 'Kozene vesta'
 
WHERE `item_template`.`entry` =5957;
 
UPDATE `pos_world`.`item_template` SET
`description` = 'Kvalitni prace', 
`name` = 'Kozeny pasek'
 
WHERE `item_template`.`entry` =4237;
 
 
 
 
/* Vyrobky z kvalitni kuze - Quality 2 */
 
 
 
UPDATE `pos_world`.`item_template` SET
`description` = 'Kvalitni prace', 
`name` = 'Cerne kratke kalhoty',
`Quality` = '2'
 
 
WHERE `item_template`.`entry` =7280;
 
UPDATE `pos_world`.`item_template` SET
`description` = 'Kvalitni prace', 
`name` = 'Seda kozena vesta',
`Quality` = '2'
 
WHERE `item_template`.`entry` =2300;
 
UPDATE `pos_world`.`item_template` SET
`description` = 'Kvalitni prace', 
`name` = 'Sede kozene boty',
`Quality` = '2'
 
WHERE `item_template`.`entry` =2309;
 
UPDATE `pos_world`.`item_template` SET
`description` = 'Kvalitni prace', 
`name` = 'Sede kozene rukavice',
`Quality` = '2'
 
WHERE `item_template`.`entry` =4239;
 
UPDATE `pos_world`.`item_template` SET
`description` = 'Kvalitni prace', 
`name` = 'Seda kape',
`Quality` = '2'
 
WHERE `item_template`.`entry` =2310;
 
UPDATE `pos_world`.`item_template` SET
`description` = 'Kvalitni prace', 
`name` = 'Bila vesta',
`Quality` = '2'
 
WHERE `item_template`.`entry` =2311;
 
UPDATE `pos_world`.`item_template` SET
`description` = 'Kvalitni prace', 
`name` = 'Kvalitni kozene naloketniky',
`Quality` = '2'
 
WHERE `item_template`.`entry` =7281;
 
UPDATE `pos_world`.`item_template` SET
`description` = 'Kvalitni prace', 
`name` = 'Kvalitni kozeny pasek',
`Quality` = '2'
 
WHERE `item_template`.`entry` =4246;
 
UPDATE `pos_world`.`item_template` SET
`description` = 'Kvalitni prace', 
`name` = 'Vysoke kozene boty',
`Quality` = '2'
 
WHERE `item_template`.`entry` =2307;
 
UPDATE `pos_world`.`item_template` SET
`description` = 'Kvalitni prace', 
`name` = 'Lemovana kape',
`Quality` = '2'
 
WHERE `item_template`.`entry` =2308;
 
 
 
/* Vyrobky z lehke kuze - Quality 3 */
 
 
 
 
UPDATE `pos_world`.`item_template` SET
`description` = 'Kvalitni prace', 
`name` = 'Sede kalhoty z lehke kuze',
`Quality` = '3'
 
WHERE `item_template`.`entry` =4242;
 
 
UPDATE `pos_world`.`item_template` SET
`description` = 'Kvalitni prace', 
`name` = 'Rukavice z lehke kuze',
`Quality` = '3'
 
WHERE `item_template`.`entry` =2312;
 
 
 
UPDATE `pos_world`.`item_template` SET
`description` = 'Kvalitni prace', 
`name` = 'Vesta z lehke kuze',
`Quality` = '3'
 
WHERE `item_template`.`entry` =4243;
 
 
 
UPDATE `pos_world`.`item_template` SET
`description` = 'Kvalitni prace', 
`name` = 'Zdobena vesta z lehke kuze',
`Quality` = '3'
 
WHERE `item_template`.`entry` =6709;
 
 
UPDATE `pos_world`.`item_template` SET
`description` = 'Kvalitni prace', 
`name` = 'Kape z lehke kuze zdobena supinami',
`Quality` = '3'
 
WHERE `item_template`.`entry` =6466;
 
 
UPDATE `pos_world`.`item_template` SET
`description` = 'Kvalitni prace', 
`name` = 'Kalhoty z lehke kuze',
`Quality` = '3'
 
WHERE `item_template`.`entry` =7282;
 
 
UPDATE `pos_world`.`item_template` SET
`description` = 'Kvalitni prace', 
`name` = 'Vesta prokladana supinami',
`Quality` = '3'
 
WHERE `item_template`.`entry` =5781;
 
 
 
 
/* Vyrobky z supin - Quality 3 */
 
 
UPDATE `pos_world`.`item_template` SET
`description` = 'Kvalitni prace', 
`name` = 'Pasek prokladany supinami',
`Quality` = '3'
 
WHERE `item_template`.`entry` =5780;
 
 
UPDATE `pos_world`.`item_template` SET
`description` = 'Kvalitni prace', 
`name` = 'Rukavice z raptorich supin',
`Quality` = '3'
 
WHERE `item_template`.`entry` =6467;
 
 
UPDATE `pos_world`.`item_template` SET
`description` = 'Kvalitni prace', 
`name` = 'Pasek z supin',
`Quality` = '3'
 
WHERE `item_template`.`entry` =6468;
 
 
 
 
/* Vyrobky z pevne kuze - Quality 3 */
 
 
 
UPDATE `pos_world`.`item_template` SET
`description` = 'Kvalitni prace', 
`name` = 'Kape z pevne kuze prokladana supinami',
`Quality` = '3'
 
WHERE `item_template`.`entry` =7283;
 
UPDATE `pos_world`.`item_template` SET
`description` = 'Kvalitni prace', 
`name` = 'Zdobema vesta lovce',
`Quality` = '3'
 
WHERE `item_template`.`entry` =20575;
 
UPDATE `pos_world`.`item_template` SET
`description` = 'Kvalitni prace', 
`name` = 'Boty z pevne kuze',
`Quality` = '3'
 
WHERE `item_template`.`entry` =2315;
 
UPDATE `pos_world`.`item_template` SET
`description` = 'Kvalitni prace', 
`name` = 'Vesta z pevne kuze',
`Quality` = '3'
 
WHERE `item_template`.`entry` =2317;
 
UPDATE `pos_world`.`item_template` SET
`description` = 'Kvalitni prace', 
`name` = 'Kalhoty z pevne kuze',
`Quality` = '3'
 
WHERE `item_template`.`entry` =5958;
 
UPDATE `pos_world`.`item_template` SET
`description` = 'Kvalitni prace', 
`name` = 'Kape z pevne kuze',
`Quality` = '3'
 
WHERE `item_template`.`entry` =2316;
 
UPDATE `pos_world`.`item_template` SET
`description` = 'Kvalitni prace', 
`name` = 'Cerne kalhoty z pevne kuze',
`Quality` = '3'
 
WHERE `item_template`.`entry` =5961;
 
UPDATE `pos_world`.`item_template` SET
`description` = 'Kvalitni prace', 
`name` = 'Lovecke torso',
`Quality` = '4'
 
WHERE `item_template`.`entry` =2314;
 
UPDATE `pos_world`.`item_template` SET
`description` = 'Kvalitni prace', 
`name` = 'Zdobene rukavice z pevne kuze',
`Quality` = '3'
 
WHERE `item_template`.`entry` =7284;
 
 
/* Batohy */
 
 
UPDATE `pos_world`.`item_template` SET 
`BuyPrice` = '0',
`SellPrice` = '0',
`name` = 'Kozeny pytel'
 
WHERE `item_template`.`entry` =5081;
 
/* Záplaty */
 
 
UPDATE `pos_world`.`item_template` SET 
`name` = 'Kozena zaplata',
`BuyPrice` = '0',
`SellPrice` = '0',
`spellid_1` = '10344'
 
WHERE `item_template`.`entry` =2304;
 
UPDATE `pos_world`.`item_template` SET 
`name` = 'Zaplata z pevne kuze',
`BuyPrice` = '0',
`SellPrice` = '0',
`spellid_1` = '19057'
 
WHERE `item_template`.`entry` =2313;
 
/* Toulec */
 
 
UPDATE `pos_world`.`item_template` SET 
`BuyPrice` = '0',
`SellPrice` = '0',
`name` = 'Toulec'
 
WHERE `item_template`.`entry` =7278;
 
/* Vak na kule */
 
 
UPDATE `pos_world`.`item_template` SET 
`BuyPrice` = '0',
`SellPrice` = '0',
`name` = 'Vak na kule'
 
WHERE `item_template`.`entry` =7279;

SQL Dopyt

 
 
/* Aliance 11097 */
INSERT INTO `npc_trainer` (`entry`, `spell`, `spellcost`, `reqskill`, `reqskillvalue`, `reqlevel`) VALUES
(11097 , 2153, 0, 165, 4, 0),
(11097 , 3753, 0, 165, 5, 0),
(11097 , 9064, 0, 165, 8, 0),
(11097 , 2160, 0, 165, 12, 0),
(11097 , 2161, 0, 165, 15, 0),
(11097 , 3756, 0, 165, 20, 0),
(11097 , 2162, 0, 165, 25, 0),
(11097 , 2163, 0, 165, 25, 0),
(11097 , 9065, 0, 165, 30, 0),
(11097 , 3763, 0, 165, 30, 0),
(11097 , 2159, 0, 165, 33, 0),
(11097 , 2158, 0, 165, 35, 0);
 
/* Aliance 5564*/
INSERT INTO `npc_trainer` (`entry`, `spell`, `spellcost`, `reqskill`, `reqskillvalue`, `reqlevel`) VALUES
(5564, 3759, 0, 165, 25, 0),
(5564, 2164, 0, 165, 30, 0),
(5564, 3761, 0, 165, 35, 0),
(5564, 8322, 0, 165, 40, 0),
(5564, 7953, 0, 165, 45, 0),
(5564, 6703, 0, 165, 50, 0),
(5564, 6702, 0, 165, 60, 0),
(5564, 7954, 0, 165, 65, 0),
(5564, 9072, 0, 165, 70, 0),
(5564, 7955, 0, 165, 75, 0);
 
 
/* Aliance 5127*/
INSERT INTO `npc_trainer` (`entry`, `spell`, `spellcost`, `reqskill`, `reqskillvalue`, `reqlevel`) VALUES
(5127, 9070, 0, 165, 25, 0),
(5127, 24940, 0, 165, 35, 0),
(5127, 2167, 0, 165, 45, 0),
(5127, 2169, 0, 165, 50, 0),
(5127, 7133, 0, 165, 65, 0),
(5127, 2168, 0, 165, 70, 0),
(5127, 7135, 0, 165, 75, 0),
(5127, 2166, 0, 165, 75, 0),
(5127, 5244, 0, 165, 25, 0),
(5127, 2165, 0, 165, 20, 0),
(5127, 2152, 0, 165, 30, 0),
(5127, 9060, 0, 165, 30, 0),
(5127, 9062, 0, 165, 40, 0);
 
 
/* Horda 3069*/
INSERT INTO `npc_trainer` (`entry`, `spell`, `spellcost`, `reqskill`, `reqskillvalue`, `reqlevel`) VALUES
(3069, 2153, 0, 165, 4, 0),
(3069, 3753, 0, 165, 5, 0),
(3069, 9064, 0, 165, 8, 0),
(3069, 2160, 0, 165, 12, 0),
(3069, 2161, 0, 165, 15, 0),
(3069, 3756, 0, 165, 20, 0),
(3069, 2162, 0, 165, 25, 0),
(3069, 2163, 0, 165, 25, 0),
(3069, 9065, 0, 165, 30, 0),
(3069, 3763, 0, 165, 30, 0),
(3069, 2159, 0, 165, 33, 0),
(3069, 2158, 0, 165, 35, 0);
 
/* Horda 4588*/
INSERT INTO `npc_trainer` (`entry`, `spell`, `spellcost`, `reqskill`, `reqskillvalue`, `reqlevel`) VALUES
(4588, 3759, 0, 165, 25, 0),
(4588, 2164, 0, 165, 30, 0),
(4588, 3761, 0, 165, 35, 0),
(4588, 8322, 0, 165, 40, 0),
(4588, 7953, 0, 165, 45, 0),
(4588, 6703, 0, 165, 50, 0),
(4588, 6702, 0, 165, 60, 0),
(4588, 7954, 0, 165, 65, 0),
(4588, 9072, 0, 165, 70, 0),
(4588, 7955, 0, 165, 75, 0);
 
 
/* Horda 18754*/
INSERT INTO `npc_trainer` (`entry`, `spell`, `spellcost`, `reqskill`, `reqskillvalue`, `reqlevel`) VALUES
(18754, 9070, 0, 165, 25, 0),
(18754, 24940, 0, 165, 35, 0),
(18754, 2167, 0, 165, 45, 0),
(18754, 2169, 0, 165, 50, 0),
(18754, 7133, 0, 165, 65, 0),
(18754, 2168, 0, 165, 70, 0),
(18754, 7135, 0, 165, 75, 0),
(18754, 2166, 0, 165, 75, 0),
(18754, 5244, 0, 165, 25, 0),
(18754, 2165, 0, 165, 20, 0),
(18754, 2152, 0, 165, 30, 0),
(18754, 9060, 0, 165, 30, 0),
(18754, 9062, 0, 165, 40, 0);

Ucitele:

Aliance : 11097<5564<5127
Horda : 3069<4588<18754

Vaření

SQL Dopyt

 
/*Maso */
 
UPDATE `rp_mangos`.`item_template` SET 
`BuyPrice` = '0',
`SellPrice` = '0',
`name` = 'Syrove vlci maso'
 
WHERE `item_template`.`entry` =1015;
 
UPDATE `rp_mangos`.`item_template` SET 
`BuyPrice` = '0',
`SellPrice` = '0',
`name` = 'Vlci kebab'
 
WHERE `item_template`.`entry` =1017;
 
UPDATE `rp_mangos`.`item_template` SET 
`BuyPrice` = '0',
`SellPrice` = '0',
`name` = 'Vlci stejk'
 
WHERE `item_template`.`entry` =12209;
 
UPDATE `rp_mangos`.`item_template` SET 
`BuyPrice` = '0',
`SellPrice` = '0',
`name` = 'Syrove maso z diviny'
 
WHERE `item_template`.`entry` =27668;
 
UPDATE `rp_mangos`.`item_template` SET 
`name` = 'Pecena divina'
 
WHERE `item_template`.`entry` =27635;
 
UPDATE `rp_mangos`.`item_template` SET 
`BuyPrice` = '0',
`SellPrice` = '0',
`name` = 'Syrove medvedi maso'
 
 WHERE `item_template`.`entry` =769;
 
UPDATE `rp_mangos`.`item_template` SET 
`name` = 'Medvedi stejk na paprice'
 
 WHERE `item_template`.`entry` =2681;
 
UPDATE `rp_mangos`.`item_template` SET
`BuyPrice` = '0',
`SellPrice` = '0', 
`name` = 'Maso z kralika'
 
WHERE `item_template`.`entry` =23676;
 
UPDATE `rp_mangos`.`item_template` SET 
`name` = 'Kralik na smetane'
 
 
WHERE `item_template`.`entry` =24105;
 
UPDATE `rp_mangos`.`item_template` SET
`BuyPrice` = '0',
`SellPrice` = '0', 
`name` = 'Syrove maso' 
 
WHERE `item_template`.`entry` =2672;
 
UPDATE `rp_mangos`.`item_template` SET 
`name` = 'Spalene stehynka'
 
WHERE `item_template`.`entry` =2679;
 
UPDATE `rp_mangos`.`item_template` SET 
`name` = 'Maso na prirodno'
 
WHERE `item_template`.`entry` =2680;
 
UPDATE `rp_mangos`.`item_template` SET 
`BuyPrice` = '0',
`SellPrice` = '0',
`name` = 'Maso z kozoroha'
 
WHERE `item_template`.`entry` =2886;
 
UPDATE `rp_mangos`.`item_template` SET 
`name` = 'Kozorozi pecene'
 
WHERE `item_template`.`entry` =2888;
 
UPDATE `rp_mangos`.`item_template` SET
`BuyPrice` = '0',
`SellPrice` = '0', 
`name` = 'Syrove leopardi maso'
 
WHERE `item_template`.`entry` =3173;
 
UPDATE `rp_mangos`.`item_template` SET 
`name` = 'Pecena leopardi zebirka'
 
WHERE `item_template`.`entry` =6890;
 
UPDATE `rp_mangos`.`item_template` SET
`BuyPrice` = '0',
`SellPrice` = '0', 
`name` = 'Jemne maso z plaza'
 
WHERE `item_template`.`entry` =27669;
 
 
UPDATE `rp_mangos`.`item_template` SET 
`name` = 'Duseny plaz na cesneku'
 
WHERE `item_template`.`entry` =27636;
 
UPDATE `rp_mangos`.`item_template` SET
`BuyPrice` = '0',
`SellPrice` = '0', 
`name` = 'Berani tuhe maso'
 
WHERE `item_template`.`entry` =2673;
 
 
UPDATE `rp_mangos`.`item_template` SET
`name` = 'Berani pecene'
 
WHERE `item_template`.`entry` =2684;
 
 
UPDATE `rp_mangos`.`item_template` SET
`BuyPrice` = '0',
`SellPrice` = '0', 
`name` = 'Maso z plaza'
 
WHERE `item_template`.`entry` =2924;
 
UPDATE `rp_mangos`.`item_template` SET
`name` = 'Peceny plaz'
 
WHERE `item_template`.`entry` =3662;
 
UPDATE `rp_mangos`.`item_template` SET
`BuyPrice` = '0',
`SellPrice` = '0', 
`name` = 'Kvalitni syrove medvedi maso'
 
WHERE `item_template`.`entry` =3730;
 
UPDATE `rp_mangos`.`item_template` SET
`name` = 'Medvedi kotleta'
 
WHERE `item_template`.`entry` =3726;
 
UPDATE `rp_mangos`.`item_template` SET
`BuyPrice` = '0',
`SellPrice` = '0', 
`name` = 'Kanci zebirka'
 
WHERE `item_template`.`entry` =2677;
 
UPDATE `rp_mangos`.`item_template` SET
`name` = 'Gulas z divocaka'
 
WHERE `item_template`.`entry` =2687;
 
 
 
 
 
 
/*Chleby */
 
 
UPDATE `rp_mangos`.`item_template` SET 
`name` = 'Bily chleb'
 
WHERE `item_template`.`entry` =46691;
 
 
UPDATE `rp_mangos`.`item_template` SET 
`name` = 'Cerny chleb'
 
WHERE `item_template`.`entry` =30816;
 
UPDATE `rp_mangos`.`item_template` SET
`BuyPrice` = '15',
`SellPrice` = '0', 
`name` = 'Mouka'
 
WHERE `item_template`.`entry` =30817;
 
UPDATE `rp_mangos`.`item_template` SET
`BuyPrice` = '15',
`SellPrice` = '0', 
`name` = 'Mleko'
 
WHERE `item_template`.`entry` =1179;
 
UPDATE `rp_mangos`.`item_template` SET
`BuyPrice` = '20',
`SellPrice` = '0', 
`name` = 'Dochucovadlo'
 
WHERE `item_template`.`entry` =2678;
 
/*Ostatni */
 
 
UPDATE `rp_mangos`.`item_template` SET
`BuyPrice` = '20',
`SellPrice` = '0', 
`name` = 'Vejce'
 
WHERE `item_template`.`entry` =6889;
 
 
UPDATE `rp_mangos`.`item_template` SET 
`name` = 'Varene vejce'
 
WHERE `item_template`.`entry` =6888;
 
 
UPDATE `rp_mangos`.`item_template` SET
`BuyPrice` = '0',
`SellPrice` = '0', 
`name` = 'Losos'
 
WHERE `item_template`.`entry` =6303;
 
 
UPDATE `rp_mangos`.`item_template` SET 
`name` = 'Peceny Losos'
 
WHERE `item_template`.`entry` =787;
 
 
UPDATE `rp_mangos`.`item_template` SET 
`name` = 'Dort',
`Quality` = '5'
 
WHERE `item_template`.`entry` =33924;
 
 
UPDATE `rp_mangos`.`item_template` SET 
`BuyPrice` = '25',
`SellPrice` = '0',
`name` = 'Cukr'
 
WHERE `item_template`.`entry` =2593;
 
 
UPDATE `rp_mangos`.`item_template` SET
`BuyPrice` = '25',
`SellPrice` = '0', 
`name` = 'Ozdoby'
 
WHERE `item_template`.`entry` =785;
 
 
UPDATE `rp_mangos`.`item_template` SET 
`name` = 'Bylinkovy caj'
 
WHERE `item_template`.`entry` =7676;

SQL Dopyt

 
 
 
 
/* Aliance - 17246*/
DELETE FROM `rp_mangos`.`npc_trainer` WHERE `npc_trainer`.`entry` = 17246;
INSERT INTO `npc_trainer` (`entry`, `spell`, `spellcost`, `reqskill`, `reqskillvalue`, `reqlevel`) VALUES
(17246, 2550, 0, 185, 0, 0),/* COOKING*/
(17246, 15853, 0, 185, 10, 0),/* Vlci stejk  */
(17246, 2549, 0, 185, 25, 0),/* Vlci kebab  */
(17246, 2539, 0, 185, 10, 0),/* Maso na prirodno */
(17246, 2538, 0, 185, 0, 0),/* Pecene stehynka - mal by vediet od zaciatku */
(17246, 33276, 0, 185, 15, 0),/* Pecena divina */
(17246, 2540, 0, 185, 30, 0),/* Medvedi stejk */
(17246, 33277, 0, 185, 20, 0),/* Kralik na smetane  */
(17246, 2541, 0, 185, 35, 0),/* Berani pecene */
(17246, 3370, 0, 185, 40, 0),/* Peceny plaz */
(17246, 2546, 0, 185, 45, 0),/* Gulas z divocaka */
(17246, 2795, 0, 185, 50, 0),/* Stejk z kozoroha */
(17246, 3397, 0, 185, 55, 0),/* Kvalitni medvedi maso */
(17246, 8607, 0, 185, 60, 0),/* Leopardi zebirka */
(17246, 33278, 0, 185, 75, 0);/* Jemna maso plaza */
 
 
/* Aliance - 1430*/
DELETE FROM `rp_mangos`.`npc_trainer` WHERE `npc_trainer`.`entry` = 1430;
INSERT INTO `npc_trainer` (`entry`, `spell`, `spellcost`, `reqskill`, `reqskillvalue`, `reqlevel`) VALUES
 
(1430, 2550, 0, 185, 0, 0),/* COOKING*/
(1430, 65454, 0, 185, 10, 0),/* Bíly chleb */
(1430, 37836, 0, 185, 15, 0),/* Cerny chleb */
(1430, 8604, 0, 185, 0, 0),/* VArene vejce */
(1430, 43779, 0, 185, 75, 0),/* DORT */
(1430, 9513, 0, 185, 75, 0),/* Caj */
(1430, 7827, 0, 185, 5, 0),/* Pstruh Morsky */
(1430, 7755, 0, 185, 15, 0),/* Uhor*/
(1430, 7752, 0, 185, 25, 0);/* Losos*/
 
/*ZATIM NEPOUZITO*/
DELETE FROM `rp_mangos`.`npc_trainer` WHERE `npc_trainer`.`entry` = 1430;
INSERT INTO `npc_trainer` (`entry`, `spell`, `spellcost`, `reqskill`, `reqskillvalue`, `reqlevel`) VALUES
(1430, 7753, 0, 185, 30, 0),/* Pyrana*/
(1430, 7827, 0, 185, 5, 0),/* Pstruh Morsky */
(1430, 7755, 0, 185, 15, 0),/* Uhor*/
(1430, 7752, 0, 185, 25, 0),/* Losos*/
(1430, 25704, 0, 185, 10, 0),/* Sumecek Troli */
(1430, 8238, 0, 185, 40, 0),/* Das Usaty */
(1430, 2545, 0, 185, 45, 0),/* Rak Ledoun */
(1430, 18243, 0, 185, 50, 0),/* Rybi Polevka */
(1430, 18239, 0, 185, 75, 0),/* Hruzoun hlubinny */
(1430, 20916, 0, 185, 60, 0);/* Pstruh Horsky*/
 
 
 
/* Horda - 1382*/
DELETE FROM `rp_mangos`.`npc_trainer` WHERE `npc_trainer`.`entry` = 1382;
INSERT INTO `npc_trainer` (`entry`, `spell`, `spellcost`, `reqskill`, `reqskillvalue`, `reqlevel`) VALUES
 
(1382, 2550, 0, 185, 0, 0),/* COOKING*/
(1382, 15853, 0, 185, 10, 0),/* Vlci stejk  */
(1382, 2549, 0, 185, 25, 0),/* Vlci kebab  */
(1382, 2539, 0, 185, 10, 0),/* Maso na prirodno */
(1382, 2538, 0, 185, 0, 0),/* Pecene stehynka - mal by vediet od zaciatku */
(1382, 33276, 0, 185, 15, 0),/* Pecena divina */
(1382, 2540, 0, 185, 30, 0),/* Medvedi stejk */
(1382, 33277, 0, 185, 20, 0),/* Kralik na smetane  */
(1382, 2541, 0, 185, 35, 0),/* Berani pecene */
(1382, 3370, 0, 185, 70, 0),/* Peceny plaz */
(1382, 2546, 0, 185, 45, 0),/* Gulas z divocaka */
(1382, 2795, 0, 185, 50, 0),/* Stejk z kozoroha */
(1382, 3397, 0, 185, 55, 0),/* Kvalitni medvedi maso */
(1382, 8607, 0, 185, 60, 0),/* Leopardi zebirka */
(1382, 33278, 0, 185, 75, 0);/* Jemna maso plaza */
 
/* Horda- 8306*/
DELETE FROM `rp_mangos`.`npc_trainer` WHERE `npc_trainer`.`entry` = 8306;
INSERT INTO `npc_trainer` (`entry`, `spell`, `spellcost`, `reqskill`, `reqskillvalue`, `reqlevel`) VALUES
(8306, 2550, 0, 185, 0, 0),/* COOKING*/
(8306, 65454, 0, 185, 10, 0),/* Bíly chleb */
(8306, 37836, 0, 185, 15, 0),/* Cerny chleb */
(8306, 8604, 0, 185, 0, 0),/* Varene vejce */
(8306, 43779, 0, 185, 75, 0),/* DORT */
(8306, 9513, 0, 185, 75, 0),/* Caj */
(8306, 7827, 0, 185, 5, 0),/* Pstruh Morsky */
(8306, 7755, 0, 185, 15, 0),/* Uhor*/
(8306, 7752, 0, 185, 25, 0);/* Losos*/
 
/*ZATIM NEPOUZITO*/
DELETE FROM `rp_mangos`.`npc_trainer` WHERE `npc_trainer`.`entry` = 8306;
INSERT INTO `npc_trainer` (`entry`, `spell`, `spellcost`, `reqskill`, `reqskillvalue`, `reqlevel`) VALUES
(8306, 7753, 0, 185, 30, 0),/* Pyrana*/
(8306, 7827, 0, 185, 5, 0),/* Pstruh Morsky */
(8306, 7755, 0, 185, 15, 0),/* Uhor*/
(8306, 7752, 0, 185, 25, 0),/* Losos*/
(8306, 25704, 0, 185, 10, 0),/* Sumecek Troli */
(8306, 8238, 0, 185, 40, 0),/* Das Usaty */
(8306, 2545, 0, 185, 45, 0),/* Rak Ledoun */
(8306, 18243, 0, 185, 50, 0),/* Rybi Polevka */
(8306, 18239, 0, 185, 75, 0),/* Hruzoun hlubinny */
(8306, 20916, 0, 185, 60, 0);/* Pstruh Horsky*/

Učitelé

Aliance : 17246(masa), 1430(zbytek)
Horda : 1382(masa), 8306(zbytek)

Skining

http://www.wowhead.com/?spell=52158 Skin, loot templaty pro urcity typ zvere

SQL Dopyt

 
/*VLK */
 
UPDATE `pos_world`.`creature_template` SET
`lootid` = '1817',
`skinloot` = '1817'
WHERE `creature_template`. `entry`  = 1817; /* Chory vlk */
UPDATE `pos_world`.`creature_template` SET
`lootid` = '1922',
`skinloot` = '1922'
WHERE `creature_template`. `entry`  = 1922; /* VLK DRAVY */
UPDATE `pos_world`.`creature_template` SET
`lootid` = '6000199',
`skinloot` = '6000199'
WHERE `creature_template`. `entry`  = 6000199; /* SEVERSKY VLK */
UPDATE `pos_world`.`creature_template` SET
`lootid` = '6000120',
`skinloot` = '6000120'
WHERE `creature_template`. `entry`  = 6000120; /* DIVOKY VLK */
 
/* NAJPRV PREMAZANIE */
DELETE FROM `skinning_loot_template` WHERE `skinning_loot_template`.`entry` = 1817;
DELETE FROM `skinning_loot_template` WHERE `skinning_loot_template`.`entry` = 1922;
DELETE FROM `skinning_loot_template` WHERE `skinning_loot_template`.`entry` = 6000199;
DELETE FROM `skinning_loot_template` WHERE `skinning_loot_template`.`entry` = 6000120;
####################################################################################
DELETE FROM `creature_loot_template` WHERE `creature_loot_template`.`entry` = 1817;
DELETE FROM `creature_loot_template` WHERE `creature_loot_template`.`entry` = 1922;
DELETE FROM `creature_loot_template` WHERE `creature_loot_template`.`entry` = 6000199;
DELETE FROM `creature_loot_template` WHERE `creature_loot_template`.`entry` = 6000120;
 
INSERT INTO `pos_world`.`skinning_loot_template` (`entry` ,`item` ,`ChanceOrQuestChance`,`groupid`,`mincountOrRef` ,`maxcount` ,`lootcondition` ,`condition_value1` ,`condition_value2`) VALUES 
/* Chory vlk */
('1817', '2934', '100', '0', '5', '10', '0', '0', '0'), /* Kus kuze */
('1817', '3627', '100', '0', '1', '4', '0', '0', '0'), /* Vlci tesak */
('1817', '24281', '100', '0', '1', '4', '0', '0', '0'), /* Zahnuta kost z vlka */
/* Vlk dravy */
('1922', '4231', '100', '0', '1', '1', '0', '0', '0'), /* Lehka kuze z predatora */
('1922', '2672', '50', '0', '1', '3', '0', '0', '0'), /* Syrove maso */
('1922', '1015', '100', '0', '1', '1', '0', '0', '0'), /* Syrove vlci maso */
('1922', '3627', '100', '0', '1', '4', '0', '0', '0'), /* Vlci tesak */
('1922', '24281', '100', '0', '1', '4', '0', '0', '0'), /* Zahnuta kost z vlka */
/* Seversky vlk */
('6000199', '4231', '100', '0', '1', '1', '0', '0', '0'), /* Lehka kuze z predatora */
('6000199', '2672', '50', '0', '1', '3', '0', '0', '0'), /* Syrove maso */
('6000199', '1015', '100', '0', '1', '1', '0', '0', '0'), /* Syrove vlci maso */
('6000199', '3627', '100', '0', '1', '4', '0', '0', '0'), /* Vlci tesak */
('6000199', '24281', '100', '0', '1', '4', '0', '0', '0'), /* Zahnuta kost z vlka */
/* Divoky vlk */
('6000120', '4231', '100', '0', '1', '1', '0', '0', '0'), /* Lehka kuze z predatora */
('6000120', '2672', '50', '0', '1', '3', '0', '0', '0'),  /* Syrove maso */
('6000120', '1015', '100', '0', '1', '1', '0', '0', '0'), /* Syrove vlci maso */
('6000120', '3627', '100', '0', '1', '4', '0', '0', '0'), /* Vlci tesak */
('6000120', '24281', '100', '0', '1', '4', '0', '0', '0'); /* Zahnuta kost z vlka */
 
/* Lyska */
 
UPDATE `pos_world`.`creature_template` SET
`lootid` = '20058',
`skinloot` = '20058'
WHERE `creature_template`. `entry`  = 20058; /* Polarni liska */
 
/* NAJPRV PREMAZANIE */
DELETE FROM `skinning_loot_template` WHERE `skinning_loot_template`.`entry` = 20058;
####################################################################################
DELETE FROM `creature_loot_template` WHERE `creature_loot_template`.`entry` = 20058;
 
INSERT INTO `pos_world`.`skinning_loot_template` (`entry` ,`item` ,`ChanceOrQuestChance`,`groupid`,`mincountOrRef` ,`maxcount` ,`lootcondition` ,`condition_value1` ,`condition_value2`) VALUES 
/* lyska */
('20058', '2934', '100', '0', '1', '5', '0', '0', '0'), /* Kus kuze */
('20058', '2672', '50', '0', '1', '1', '0', '0', '0'), /* Syrove maso */
('20058', '1015', '100', '0', '1', '1', '0', '0', '0'); /* Syrove vlci maso */
 
/* Medved */
 
UPDATE `pos_world`.`creature_template` SET
`lootid` = '26482',
`skinloot` = '26482'
WHERE `creature_template`. `entry`  = 26482; /* Snezny medved */
 
UPDATE `pos_world`.`creature_template` SET
`lootid` = '27131',
`skinloot` = '27131'
WHERE `creature_template`. `entry`  = 27131; /* Medved Grizzly */
UPDATE `pos_world`.`creature_template` SET
`lootid` = '6000104',
`skinloot` = '6000104'
WHERE `creature_template`. `entry`  = 6000104; /* Chory Medved */
UPDATE `pos_world`.`creature_template` SET
`lootid` = '6000121',
`skinloot` = '6000121'
WHERE `creature_template`. `entry`  = 6000121; /* Divoky medved */
 
##UPDATE `pos_world`.`creature_template` SET
##`lootid` = '6000206',
##`skinloot` = '6000206'
##WHERE `creature_template`. `entry`  = 6000206; /* Mrtva medvedice */
##UPDATE `pos_world`.`creature_template` SET
##`lootid` = '26613',
##`skinloot` = '26613'
##WHERE `creature_template`. `entry`  = 26613; /* Mlade snezneho medveda */
 
/* NAJPRV PREMAZANIE */
DELETE FROM `skinning_loot_template` WHERE `skinning_loot_template`.`entry` = 26482;
DELETE FROM `skinning_loot_template` WHERE `skinning_loot_template`.`entry` = 27131;
DELETE FROM `skinning_loot_template` WHERE `skinning_loot_template`.`entry` = 6000104;
DELETE FROM `skinning_loot_template` WHERE `skinning_loot_template`.`entry` = 6000121;
####################################################################################
DELETE FROM `creature_loot_template` WHERE `creature_loot_template`.`entry` = 26482;
DELETE FROM `creature_loot_template` WHERE `creature_loot_template`.`entry` = 27131;
DELETE FROM `creature_loot_template` WHERE `creature_loot_template`.`entry` = 6000104;
DELETE FROM `creature_loot_template` WHERE `creature_loot_template`.`entry` = 6000121;
 
INSERT INTO `pos_world`.`skinning_loot_template` (`entry` ,`item` ,`ChanceOrQuestChance`,`groupid`,`mincountOrRef` ,`maxcount` ,`lootcondition` ,`condition_value1` ,`condition_value2`) VALUES 
 /* Snezny medved */
('26482', '2672', '50', '0', '1', '3', '0', '0', '0'),  /* Syrove maso */
('26482', '36788', '100', '0', '1', '1', '0', '0', '0'),  /* kuze snezneho medveda */
('26482', '769', '100', '0', '2', '4', '0', '0', '0'), /* Syrove medvedi maso */
('26482', '3730', '100', '0', '1', '1', '0', '0', '0'), /* Kvalitni syrove medvedi maso */
('26482', '5635', '100', '0', '1', '1', '0', '0', '0'), /* Lahvicka medvedi kreve */
/* Medved Grizzly */
('27131', '2672', '50', '0', '1', '3', '0', '0', '0'),  /* Syrove maso */
('27131', '4234', '100', '0', '1', '1', '0', '0', '0'), /* Pevna kuze */
('27131', '769', '100', '0', '2', '4', '0', '0', '0'), /* Syrove medvedi maso */
('27131', '3730', '100', '0', '1', '1', '0', '0', '0'), /* Kvalitni syrove medvedi maso */
('27131', '5635', '100', '0', '1', '1', '0', '0', '0'), /* Lahvicka medvedi kreve */
/* Chory Medved */
('6000104', '2934', '100', '0', '10', '20', '0', '0', '0'), /* Kus kuze */
/* Divoky medved */
('6000121', '2672', '50', '0', '1', '3', '0', '0', '0'),  /* Syrove maso */
('6000121', '4234', '100', '0', '1', '1', '0', '0', '0'), /* Pevna kuze */
('6000121', '769', '100', '0', '2', '4', '0', '0', '0'), /* Syrove medvedi maso */
('6000121', '3730', '100', '0', '1', '1', '0', '0', '0'), /* Kvalitni syrove medvedi maso */
('6000121', '5635', '100', '0', '1', '1', '0', '0', '0'); /* Lahvicka medvedi kreve */
 
 /* Lan */
 
UPDATE `pos_world`.`creature_template` SET
`lootid` = '883',
`skinloot` = '883'
WHERE `creature_template`. `entry`  = 883;
 
/* NAJPRV PREMAZANIE */
DELETE FROM `skinning_loot_template` WHERE `skinning_loot_template`.`entry` = 883;
####################################################################################
DELETE FROM `creature_loot_template` WHERE `creature_loot_template`.`entry` = 883;
 
INSERT INTO `pos_world`.`skinning_loot_template` (`entry` ,`item` ,`ChanceOrQuestChance`,`groupid`,`mincountOrRef` ,`maxcount` ,`lootcondition` ,`condition_value1` ,`condition_value2`) VALUES 
/* Lan */
 
('883', '2934', '100', '0', '1', '4', '0', '0', '0'), /* Kus kuze */
('883', '2318', '100', '0', '1', '1', '0', '0', '0'), /* Jemna kuze */
('883', '27668', '100', '0', '1', '1', '0', '0', '0'); /* Syrove maso z diviny */
 
/* Hlodavci */
 
UPDATE `pos_world`.`creature_template` SET
`lootid` = '30094',
`skinloot` = '30094'
WHERE `creature_template`. `entry`  = 30094; /* krysa */
 
UPDATE `pos_world`.`creature_template` SET
`lootid` = '31889',
`skinloot` = '31889'
WHERE `creature_template`. `entry`  = 31889; /* veverka */
 
UPDATE `pos_world`.`creature_template` SET
`lootid` = '17467',
`skinloot` = '17467'
WHERE `creature_template`. `entry`  = 17467; /* Skunk */
 
UPDATE `pos_world`.`creature_template` SET
`lootid` = '721',
`skinloot` = '721'
WHERE `creature_template`. `entry`  = 721; /* Kralik */
 
/* NAJPRV PREMAZANIE */
DELETE FROM `skinning_loot_template` WHERE `skinning_loot_template`.`entry` = 30094;
DELETE FROM `skinning_loot_template` WHERE `skinning_loot_template`.`entry` = 31889;
DELETE FROM `skinning_loot_template` WHERE `skinning_loot_template`.`entry` = 31928;
DELETE FROM `skinning_loot_template` WHERE `skinning_loot_template`.`entry` = 721;
####################################################################################
DELETE FROM `creature_loot_template` WHERE `creature_loot_template`.`entry` = 30094;
DELETE FROM `creature_loot_template` WHERE `creature_loot_template`.`entry` = 31889;
DELETE FROM `creature_loot_template` WHERE `creature_loot_template`.`entry` = 31928;
DELETE FROM `creature_loot_template` WHERE `creature_loot_template`.`entry` = 721;
 
INSERT INTO `pos_world`.`skinning_loot_template` (`entry` ,`item` ,`ChanceOrQuestChance`,`groupid`,`mincountOrRef` ,`maxcount` ,`lootcondition` ,`condition_value1` ,`condition_value2`) VALUES 
/* Krysa */
('30094', '2934', '100', '0', '1', '1', '0', '0', '0'), /* Kus kuze */
('30094', '2672', '100', '0', '1', '1', '0', '0', '0'), /* Syrove Maso */
/* Veverka */
('31889', '2934', '100', '0', '1', '1', '0', '0', '0'), /* Kus kuze */
('31889', '2672', '100', '0', '1', '1', '0', '0', '0'), /* Syrove Maso */
/* Skunk */
('31928', '17467', '100', '0', '1', '2', '0', '0', '0'), /* Kus kuze */
('31928', '2318', '100', '0', '1', '1', '0', '0', '0'), /* Jemna kuze */
('31928', '2672', '100', '0', '1', '1', '0', '0', '0'), /* Syrove Maso */
/* Kralik */
('721', '2934', '100', '0', '1', '2', '0', '0', '0'), /* Kus kuze */
('721', '2318', '100', '0', '1', '1', '0', '0', '0'), /* Jemna kuze */
('721', '23676', '100', '0', '1', '1', '0', '0', '0'); /* Maso z kralika */
 
 
/* Kozoroh */
 
UPDATE `pos_world`.`creature_template` SET
`lootid` = '17130',
`skinloot` = '17130'
WHERE `creature_template`. `entry`  = 17130; /* Cerny kozoroh */ 
 
UPDATE `pos_world`.`creature_template` SET
`lootid` = '17131',
`skinloot` = '17131'
WHERE `creature_template`. `entry`  = 17131; /* Kozoroh pruhovany */ 
 
/* NAJPRV PREMAZANIE */
DELETE FROM `skinning_loot_template` WHERE `skinning_loot_template`.`entry` = 17130;
DELETE FROM `skinning_loot_template` WHERE `skinning_loot_template`.`entry` = 17131;
####################################################################################
DELETE FROM `creature_loot_template` WHERE `creature_loot_template`.`entry` = 17130;
DELETE FROM `creature_loot_template` WHERE `creature_loot_template`.`entry` = 17131;
 
INSERT INTO `pos_world`.`skinning_loot_template` (`entry` ,`item` ,`ChanceOrQuestChance`,`groupid`,`mincountOrRef` ,`maxcount` ,`lootcondition` ,`condition_value1` ,`condition_value2`) VALUES 
/* Cerny kozoroh */
('17130', '27660', '100', '0', '1', '1', '0', '0', '0'), /* Maso z kozoroha */
('17130', '29751', '100', '0', '1', '1', '0', '0', '0'), /* Roh kozoroha */
('17130', '2318', '100', '0', '1', '1', '0', '0', '0'), /* Jemna kuze */
('17130', '2886', '100', '0', '1', '1', '0', '0', '0'), /* Maso z kozoroha */
/* Kozoroh pruhovany */
('17131', '27660', '100', '0', '1', '1', '0', '0', '0'), /* Maso z kozoroha */
('17131', '29751', '100', '0', '1', '1', '0', '0', '0'), /* Roh kozoroha */
('17131', '2318', '100', '0', '1', '1', '0', '0', '0'), /* Jemna kuze */
('17131', '2886', '100', '0', '1', '1', '0', '0', '0'); /* Maso z kozoroha */
 
/* Zmije */
 
UPDATE `pos_world`.`creature_template` SET
`lootid` = '6000203',
`skinloot` = '6000203'
WHERE `creature_template`. `entry`  = 6000203;
 
/* NAJPRV PREMAZANIE */
DELETE FROM `skinning_loot_template` WHERE `skinning_loot_template`.`entry` = 31930;
####################################################################################
DELETE FROM `creature_loot_template` WHERE `creature_loot_template`.`entry` = 31930;
 
INSERT INTO `pos_world`.`skinning_loot_template` (`entry` ,`item` ,`ChanceOrQuestChance`,`groupid`,`mincountOrRef` ,`maxcount` ,`lootcondition` ,`condition_value1` ,`condition_value2`) VALUES 
/* Zmije */
('31930', '2672', '50', '0', '1', '1', '0', '0', '0'),  /* Syrove maso */
('31930', '27669', '100', '0', '1', '1', '0', '0', '0'),  /* Jemne maso z plaza */
('31930', '7287', '50', '254', '1', '1', '0', '0', '0'), /* Cervena supina */
('31930', '7286', '50', '254', '1', '1', '0', '0', '0'); /* Cerna supina */
 
/* Jelen */
 
UPDATE `pos_world`.`creature_template` SET
`lootid` = '27485',
`skinloot` = '27485'
WHERE `creature_template`. `entry`  = 27485; 
 
/* NAJPRV PREMAZANIE */
DELETE FROM `skinning_loot_template` WHERE `skinning_loot_template`.`entry` = 27485;
####################################################################################
DELETE FROM `creature_loot_template` WHERE `creature_loot_template`.`entry` = 27485;
 
INSERT INTO `pos_world`.`skinning_loot_template` (`entry` ,`item` ,`ChanceOrQuestChance`,`groupid`,`mincountOrRef` ,`maxcount` ,`lootcondition` ,`condition_value1` ,`condition_value2`) VALUES 
 /* Jelen */
('27485', '37104', '100', '0', '1', '2', '0', '0', '0'), /* Rohy jelena */
('27485', '2934', '100', '0', '1', '2', '0', '0', '0'), /* Kus kuze */
('27485', '2318', '50', '0', '1', '1', '0', '0', '0'), /* Jemna kuze */
('27485', '2319', '100', '0', '1', '1', '0', '0', '0'), /* Kvalitni kuze */
('27485', '27668', '100', '0', '2', '2', '0', '0', '0'); /* Syrove maso z diviny */
 
/*Leopard*/
 
UPDATE `pos_world`.`creature_template` SET
`lootid` = '6000200',
`skinloot` = '6000200'
WHERE `creature_template`. `entry`  = 6000200; 
 
/* NAJPRV PREMAZANIE */
DELETE FROM `skinning_loot_template` WHERE `skinning_loot_template`.`entry` = 6000200;
####################################################################################
DELETE FROM `creature_loot_template` WHERE `creature_loot_template`.`entry` = 6000200;
 
INSERT INTO `pos_world`.`skinning_loot_template` (`entry` ,`item` ,`ChanceOrQuestChance`,`groupid`,`mincountOrRef` ,`maxcount` ,`lootcondition` ,`condition_value1` ,`condition_value2`) VALUES 
 /*Leopard*/
 
('6000200', '43851', '100', '0', '1', '1', '0', '0', '0'), /* Kuze snezneho leoparda */
('6000200', '3173', '100', '0', '1', '1', '0', '0', '0'); /* Syrove leopardi maso */
 
/*Ryba*/
 
UPDATE `pos_world`.`creature_template` SET
`lootid` = '905',
`skinloot` = '905'
WHERE `creature_template`. `entry`  = 905;
 
/* NAJPRV PREMAZANIE */
DELETE FROM `skinning_loot_template` WHERE `skinning_loot_template`.`entry` = 905;
####################################################################################
DELETE FROM `creature_loot_template` WHERE `creature_loot_template`.`entry` = 905;
 
INSERT INTO `pos_world`.`skinning_loot_template` (`entry` ,`item` ,`ChanceOrQuestChance`,`groupid`,`mincountOrRef` ,`maxcount` ,`lootcondition` ,`condition_value1` ,`condition_value2`) VALUES 
 /* Ryba */
 
('905', '6303', '100', '0', '1', '1', '0', '0', '0'), /* Syrova ryba */
('905', '5784', '100', '0', '1', '1', '0', '0', '0'); /* Supina */
 
/* Beran */
 
UPDATE `pos_world`.`creature_template` SET
`lootid` = '24049',
`skinloot` = '24049'
WHERE `creature_template`. `entry`  = 24049; /* Horsky beran - hnedy */
UPDATE `pos_world`.`creature_template` SET
`lootid` = '31936',
`skinloot` = '31936'
WHERE `creature_template`. `entry`  = 29958; /* Agresivni Beran - Tur */
UPDATE `pos_world`.`creature_template` SET
`lootid` = '31921',
`skinloot` = '31921'
WHERE `creature_template`. `entry`  = 31921; /* Beran z vysociny - biely */
 
/* NAJPRV PREMAZANIE */
DELETE FROM `skinning_loot_template` WHERE `skinning_loot_template`.`entry` = 24049;
DELETE FROM `skinning_loot_template` WHERE `skinning_loot_template`.`entry` = 29958;
DELETE FROM `skinning_loot_template` WHERE `skinning_loot_template`.`entry` = 31921;
####################################################################################
DELETE FROM `creature_loot_template` WHERE `creature_loot_template`.`entry` = 24049;
DELETE FROM `creature_loot_template` WHERE `creature_loot_template`.`entry` = 29958;
DELETE FROM `creature_loot_template` WHERE `creature_loot_template`.`entry` = 31921;
 
INSERT INTO `pos_world`.`skinning_loot_template` (`entry` ,`item` ,`ChanceOrQuestChance`,`groupid`,`mincountOrRef` ,`maxcount` ,`lootcondition` ,`condition_value1` ,`condition_value2`) VALUES 
/* Horsky Beran */
('24049', '25415', '100', '0', '1', '1', '0', '0', '0'), /* Roh berana */
('24049', '2673', '100', '0', '1', '1', '0', '0', '0'), /* Tvrde maso berana */
('24049', '2319', '100', '0', '1', '1', '0', '0', '0'), /* Kvalitni kuze */
('24049', '2934', '100', '0', '1', '5', '0', '0', '0'), /* Kus kuze */
 
/* Agresivni Beran */
('31936', '25415', '100', '0', '1', '1', '0', '0', '0'), /* Roh berana */
('31936', '2673', '100', '0', '1', '1', '0', '0', '0'), /* Tvrde maso berana */
('31936', '2319', '100', '0', '1', '1', '0', '0', '0'), /* Kvalitni kuze */
('31936', '2934', '100', '0', '5', '10', '0', '0', '0'), /* Kus kuze */
 
/* Beran z vysociny */
('31921', '25415', '100', '0', '1', '1', '0', '0', '0'), /* Roh berana */
('31921', '2673', '100', '0', '1', '1', '0', '0', '0'), /* Tvrde maso berana */
('31921', '2319', '100', '0', '1', '1', '0', '0', '0'), /* Kvalitni kuze */
('31921', '2934', '100', '0', '1', '5', '0', '0', '0'); /* Kus kuze */
 
 
/* Kanec */
 
UPDATE `pos_world`.`creature_template` SET
`lootid` = '1190',
`skinloot` = '1190'
WHERE `creature_template`. `entry`  = 1190; /* Kanec */
 
/* NAJPRV PREMAZANIE */
DELETE FROM `skinning_loot_template` WHERE `skinning_loot_template`.`entry` = 1190;
####################################################################################
DELETE FROM `creature_loot_template` WHERE `creature_loot_template`.`entry` = 1190;
 
INSERT INTO `pos_world`.`skinning_loot_template` (`entry` ,`item` ,`ChanceOrQuestChance`,`groupid`,`mincountOrRef` ,`maxcount` ,`lootcondition` ,`condition_value1` ,`condition_value2`) VALUES 
/* Kanec */
 
('1190', '25440', '100', '0', '1', '1', '0', '0', '0'), /* Prasknuty kel */
('1190', '2934', '100', '0', '1', '4', '0', '0', '0'), /* Kus kuze */
('1190', '2319', '100', '0', '1', '1', '0', '0', '0'), /* Kvalitni kuze */
('1190', '27668', '100', '0', '2', '2', '0', '0', '0'), /* Syrove maso z diviny */
('1190', '2677', '100', '0', '1', '2', '0', '0', '0');  /* Kanci rebirka */
 
/* Krokodil */
 
UPDATE `pos_world`.`creature_template` SET
`lootid` = '1693',
`skinloot` = '1693'
WHERE `creature_template`. `entry`  = 1693;
 
/* NAJPRV PREMAZANIE */
DELETE FROM `skinning_loot_template` WHERE `skinning_loot_template`.`entry` = 1693;
####################################################################################
DELETE FROM `creature_loot_template` WHERE `creature_loot_template`.`entry` = 1693;
 
INSERT INTO `pos_world`.`skinning_loot_template` (`entry` ,`item` ,`ChanceOrQuestChance`,`groupid`,`mincountOrRef` ,`maxcount` ,`lootcondition` ,`condition_value1` ,`condition_value2`) VALUES 
('1693', '2924', '100', '0', '1', '1', '0', '0', '0'), /* Maso z plaza */
('1693', '6470', '50', '255', '1', '1', '0', '0', '0'), /* Jesteri supina */
('1693', '6471', '50', '255', '1', '1', '0', '0', '0'); /* Cerna jesteri supina */

Suroviny

Šití

2589 - Kus látky
2320 - Nit
2324 - Belidlo
2604 - Cervena barva
6260 - Modra barva
2605 - Zelena barba
4340 - Seda barva
2321 - Kvalitni nit
5498 - Perla
2592 - Kus vlny
5637 - Vystuz do bot

Engineering

2589 - Kus látky
4399 - Kus opracovaneho dreva
2880 - Tavidlo
4404 - Magicky kov
3466 - Silne tavidlo

Vareni

30817 - Mouka
1179 - Mleko
2678 - Dochucovadlo
6889 - Vejce
2593 - Cukr
785 - Ozdoby

Game Objekty

Mining

:!: Lockid je pre vsetky rudy 38

2835 Obycejny kamen
- GO: 1731, 1732, 1733, 1735 (100%)
774 Malachit
- GO: 1731 (20%)
2770 Kus medi
- GO: 1731 (50%)
2836 Obohaceny kamen
- GO: 1732 (50%)
2771 Kus cinu
- GO: 1732 (50%)
1206 Zeleny achat
- GO: 1732 (20%), 1733 (20%)
2775 Kus stribra
- GO: 1733 (50%)
2772 Kus zeleza
- GO: 1735 (50%)

Herbalism

:!: Lockid je pre vsetky rastliny 29

765 - List GO: 1617
2447 - Kvet GO: 1618
2449 - Koren GO: 1619
785 - Lotus GO: 1620
2452 - Mesicni kvet GO: 1621, 1620
2450 - Ostny GO: 1621

Ucitele

SQL Dopyt

 
 UPDATE `pos_world`.`creature_template` SET
`subname` = 'Mechanik',
`minlevel` = '70',
`maxlevel` = '70',
`minhealth` = '3000',
`maxhealth` = '3000',
`armor` = '5000',
`faction_A` = '35', /*neutral */ 
`faction_H` = '35', /* neutral*/ 
`npcflag` = '211',
`speed` = '1',
`mindmg` = '100',
`maxdmg` = '200',
`attackpower` = '150',
`unit_flags` = '0',
`trainer_type` =  '2',
`trainer_spell` = '4036', /* spell profese */ 
`minrangedmg` = '0',
`maxrangedmg` = '0',
`rangedattackpower` = '0',
`flags_extra` = '0' 
WHERE `creature_template`.`entry` =5518 ;

Obchodnici

5510- Aliance Skladnik
3369 - Horda Sklanik

SQL Dopyt

 
 
 
/* ENG */
INSERT INTO `pos_world`.`npc_vendor` (`entry` ,`item` ,`maxcount` ,`incrtime` ,`ExtendedCost`)VALUES 
('5518', '4399 ', '1', '3600', '0'),
('5518', '2880 ', '1', '3600', '0'),
('5518', '3466 ', '1', '3600', '0');
 
 
 
/* Alchemy*/
INSERT INTO `pos_world`.`npc_vendor` (`entry` ,`item` ,`maxcount` ,`incrtime` ,`ExtendedCost`)VALUES 
('4160 ', '3371 ', '1', '3600', '0'),
('4160 ', '3164 ', '1', '3600', '0'),
('5518', '2880 ', '1', '3600', '0'),
('4160 ', '3466 ', '1', '3600', '0');
 
 
/* Krejci*/
INSERT INTO `pos_world`.`npc_vendor` (`entry` ,`item` ,`maxcount` ,`incrtime` ,`ExtendedCost`)VALUES 
('1103 ', '2589 ', '5', '3600', '0'),
('1103 ', '2320 ', '5', '3600', '0'),
('1103 ', '2604 ', '1', '3600', '0'),
('1103 ', '6260 ', '1', '3600', '0'),
('1103 ', '2605 ', '1', '3600', '0'),
('1103 ', '4340 ', '1', '3600', '0'),
('1103 ', '2321 ', '1', '3600', '0'),
('1103 ', '2324 ', '1', '3600', '0');
 
 
/* Kuchar*/
INSERT INTO `pos_world`.`npc_vendor` (`entry` ,`item` ,`maxcount` ,`incrtime` ,`ExtendedCost`)VALUES 
('17246', '30817 ', '1', '3600', '0'),
('17246', '1179 ', '1', '3600', '0'),
('17246', '2678 ', '1', '3600', '0'),
('17246', '6889 ', '1', '3600', '0'),
('17246', '2593 ', '1', '3600', '0');
 
 
/* Skladnik - Aliance*/
INSERT INTO `pos_world`.`npc_vendor` (`entry` ,`item` ,`maxcount` ,`incrtime` ,`ExtendedCost`)VALUES 
('5510', '2589 ', '50', '300', '0'),
('5510', '2320 ', '50', '300', '0'),
('5510', '2324 ', '0', '0', '0'),
('5510', '2604 ', '0', '0', '0'),
('5510', '6260 ', '0', '0', '0'),
('5510', '2605 ', '0', '0', '0'),
('5510', '5637', '0', '0', '0'),
('5510', '4340 ', '0', '0', '0'),
('5510', '2321 ', '50', '300', '0'),
('5510', '4399 ', '0', '0', '0'),
('5510', '2880 ', '0', '0', '0'),
('5510', '3371 ', '0', '0', '0'),
('5510', '3164 ', '0', '0', '0'),
('5510', '30817 ', '0', '0', '0'),
('5510', '1179 ', '0', '0', '0'),
('5510', '2678 ', '0', '0', '0'),
('5510', '6889 ', '0', '0', '0'),
('5510', '2593 ', '0', '0', '0'),
('5510', '3466 ', '0', '0', '0'),
('5510', '785 ', '0', '0', '0');
 
 
 
/* Skladnik - Horda*/
INSERT INTO `pos_world`.`npc_vendor` (`entry` ,`item` ,`maxcount` ,`incrtime` ,`ExtendedCost`)VALUES 
('3369 ', '2589 ', '50', '300', '0'),
('3369 ', '2320 ', '50', '300', '0'),
('3369 ', '2324 ', '0', '0', '0'),
('3369 ', '2604 ', '0', '0', '0'),
('3369 ', '6260 ', '0', '0', '0'),
('3369 ', '2605 ', '0', '0', '0'),
('3369 ', '5637', '0', '0', '0'),
('3369 ', '4340 ', '0', '0', '0'),
('3369 ', '2321 ', '50', '300', '0'),
('3369 ', '4399 ', '0', '0', '0'),
('3369 ', '2880 ', '0', '0', '0'),
('3369 ', '3371 ', '0', '0', '0'),
('3369 ', '3164 ', '0', '0', '0'),
('3369 ', '30817 ', '0', '0', '0'),
('3369 ', '1179 ', '0', '0', '0'),
('3369 ', '2678 ', '0', '0', '0'),
('3369 ', '6889 ', '0', '0', '0'),
('3369 ', '2593 ', '0', '0', '0'),
('3369 ', '3466 ', '0', '0', '0'),
('3369 ', '785 ', '0', '0', '0');

Nastaveni prodejnich cen vyrobku na 0

Potreba nahrat po kazdem nahrani sql zbrani, zboji.

SQL Dopyt

 
 
UPDATE `pos_world`.`item_template` SET
`SellPrice` = '0'
WHERE `item_template`.`description` ='Kvalitni prace';

Diskuse, Pomoc

Tak jsem to hodil sem, aby si to vsichni mohli prohlednout a pripadne mi pomoc. Nazvy obecne jsou hodne orientacni, delal jsem je ve spechu. Takze by mi moc pomohlo kdybyste si to prohledli a opravili preklepy, nebo cele jmeno zmenili. Dale pokud by nekdo mel zajem prevest to sql do textu, aby si to mohli precist vsichni. Pripomink piste sem pod tento odstavec, prosim strucne a prehledne :!: Jmena upravujte ale nic jineho bez dimluvy nemente.

Pripominka1
Pripominka2