Zbroje a oblecenie

Staty a hodnoty pre zbroje a zbrane: staty_final.xls (Excel)

Specializace na zbroje

Noseni zbroji neni obmedzeno na povolani (class)

750 Plate * 8737 Mail * Leather 9077

SQL pre zbroje - naucene od zaciatku

/* PLATE */
## Human
INSERT INTO `pos_world`.`playercreateinfo_spell` (`race`, `class`, `Spell`, `Note`) VALUES ('1', '1', '750', 'Plate');
INSERT INTO `pos_world`.`playercreateinfo_spell` (`race`, `class`, `Spell`, `Note`) VALUES ('1', '2', '750', 'Plate');
INSERT INTO `pos_world`.`playercreateinfo_spell` (`race`, `class`, `Spell`, `Note`) VALUES ('1', '4', '750', 'Plate');
INSERT INTO `pos_world`.`playercreateinfo_spell` (`race`, `class`, `Spell`, `Note`) VALUES ('1', '5', '750', 'Plate');
INSERT INTO `pos_world`.`playercreateinfo_spell` (`race`, `class`, `Spell`, `Note`) VALUES ('1', '6', '750', 'Plate');
INSERT INTO `pos_world`.`playercreateinfo_spell` (`race`, `class`, `Spell`, `Note`) VALUES ('1', '8', '750', 'Plate');
INSERT INTO `pos_world`.`playercreateinfo_spell` (`race`, `class`, `Spell`, `Note`) VALUES ('1', '9', '750', 'Plate');
## Ork
INSERT INTO `pos_world`.`playercreateinfo_spell` (`race`, `class`, `Spell`, `Note`) VALUES ('2', '1', '750', 'Plate');
INSERT INTO `pos_world`.`playercreateinfo_spell` (`race`, `class`, `Spell`, `Note`) VALUES ('2', '3', '750', 'Plate');
INSERT INTO `pos_world`.`playercreateinfo_spell` (`race`, `class`, `Spell`, `Note`) VALUES ('2', '4', '750', 'Plate');
INSERT INTO `pos_world`.`playercreateinfo_spell` (`race`, `class`, `Spell`, `Note`) VALUES ('2', '6', '750', 'Plate');
INSERT INTO `pos_world`.`playercreateinfo_spell` (`race`, `class`, `Spell`, `Note`) VALUES ('2', '7', '750', 'Plate');
INSERT INTO `pos_world`.`playercreateinfo_spell` (`race`, `class`, `Spell`, `Note`) VALUES ('2', '9', '750', 'Plate');
## Dwarf
INSERT INTO `pos_world`.`playercreateinfo_spell` (`race`, `class`, `Spell`, `Note`) VALUES ('3', '1', '750', 'Plate');
INSERT INTO `pos_world`.`playercreateinfo_spell` (`race`, `class`, `Spell`, `Note`) VALUES ('3', '2', '750', 'Plate');
INSERT INTO `pos_world`.`playercreateinfo_spell` (`race`, `class`, `Spell`, `Note`) VALUES ('3', '3', '750', 'Plate');
INSERT INTO `pos_world`.`playercreateinfo_spell` (`race`, `class`, `Spell`, `Note`) VALUES ('3', '4', '750', 'Plate');
INSERT INTO `pos_world`.`playercreateinfo_spell` (`race`, `class`, `Spell`, `Note`) VALUES ('3', '5', '750', 'Plate');
INSERT INTO `pos_world`.`playercreateinfo_spell` (`race`, `class`, `Spell`, `Note`) VALUES ('3', '6', '750', 'Plate');
## Night elf
INSERT INTO `pos_world`.`playercreateinfo_spell` (`race`, `class`, `Spell`, `Note`) VALUES ('4', '1', '750', 'Plate');
INSERT INTO `pos_world`.`playercreateinfo_spell` (`race`, `class`, `Spell`, `Note`) VALUES ('4', '3', '750', 'Plate');
INSERT INTO `pos_world`.`playercreateinfo_spell` (`race`, `class`, `Spell`, `Note`) VALUES ('4', '4', '750', 'Plate');
INSERT INTO `pos_world`.`playercreateinfo_spell` (`race`, `class`, `Spell`, `Note`) VALUES ('4', '5', '750', 'Plate');
INSERT INTO `pos_world`.`playercreateinfo_spell` (`race`, `class`, `Spell`, `Note`) VALUES ('4', '6', '750', 'Plate');
INSERT INTO `pos_world`.`playercreateinfo_spell` (`race`, `class`, `Spell`, `Note`) VALUES ('4', '11', '750', 'Plate');
## Undead
INSERT INTO `pos_world`.`playercreateinfo_spell` (`race`, `class`, `Spell`, `Note`) VALUES ('5', '1', '750', 'Plate');
INSERT INTO `pos_world`.`playercreateinfo_spell` (`race`, `class`, `Spell`, `Note`) VALUES ('5', '4', '750', 'Plate');
INSERT INTO `pos_world`.`playercreateinfo_spell` (`race`, `class`, `Spell`, `Note`) VALUES ('5', '5', '750', 'Plate');
INSERT INTO `pos_world`.`playercreateinfo_spell` (`race`, `class`, `Spell`, `Note`) VALUES ('5', '6', '750', 'Plate');
INSERT INTO `pos_world`.`playercreateinfo_spell` (`race`, `class`, `Spell`, `Note`) VALUES ('5', '8', '750', 'Plate');
INSERT INTO `pos_world`.`playercreateinfo_spell` (`race`, `class`, `Spell`, `Note`) VALUES ('5', '9', '750', 'Plate');
## Taur
INSERT INTO `pos_world`.`playercreateinfo_spell` (`race`, `class`, `Spell`, `Note`) VALUES ('6', '1', '750', 'Plate');
INSERT INTO `pos_world`.`playercreateinfo_spell` (`race`, `class`, `Spell`, `Note`) VALUES ('6', '3', '750', 'Plate');
INSERT INTO `pos_world`.`playercreateinfo_spell` (`race`, `class`, `Spell`, `Note`) VALUES ('6', '6', '750', 'Plate');
INSERT INTO `pos_world`.`playercreateinfo_spell` (`race`, `class`, `Spell`, `Note`) VALUES ('6', '7', '750', 'Plate');
INSERT INTO `pos_world`.`playercreateinfo_spell` (`race`, `class`, `Spell`, `Note`) VALUES ('6', '11', '750', 'Plate');
## Gnome
INSERT INTO `pos_world`.`playercreateinfo_spell` (`race`, `class`, `Spell`, `Note`) VALUES ('7', '1', '750', 'Plate');
INSERT INTO `pos_world`.`playercreateinfo_spell` (`race`, `class`, `Spell`, `Note`) VALUES ('7', '4', '750', 'Plate');
INSERT INTO `pos_world`.`playercreateinfo_spell` (`race`, `class`, `Spell`, `Note`) VALUES ('7', '6', '750', 'Plate');
INSERT INTO `pos_world`.`playercreateinfo_spell` (`race`, `class`, `Spell`, `Note`) VALUES ('7', '8', '750', 'Plate');
INSERT INTO `pos_world`.`playercreateinfo_spell` (`race`, `class`, `Spell`, `Note`) VALUES ('7', '9', '750', 'Plate');
## Troll
INSERT INTO `pos_world`.`playercreateinfo_spell` (`race`, `class`, `Spell`, `Note`) VALUES ('8', '1', '750', 'Plate');
INSERT INTO `pos_world`.`playercreateinfo_spell` (`race`, `class`, `Spell`, `Note`) VALUES ('8', '3', '750', 'Plate');
INSERT INTO `pos_world`.`playercreateinfo_spell` (`race`, `class`, `Spell`, `Note`) VALUES ('8', '4', '750', 'Plate');
INSERT INTO `pos_world`.`playercreateinfo_spell` (`race`, `class`, `Spell`, `Note`) VALUES ('8', '5', '750', 'Plate');
INSERT INTO `pos_world`.`playercreateinfo_spell` (`race`, `class`, `Spell`, `Note`) VALUES ('8', '6', '750', 'Plate');
INSERT INTO `pos_world`.`playercreateinfo_spell` (`race`, `class`, `Spell`, `Note`) VALUES ('8', '7', '750', 'Plate');
INSERT INTO `pos_world`.`playercreateinfo_spell` (`race`, `class`, `Spell`, `Note`) VALUES ('8', '8', '750', 'Plate');
## Blood elf
INSERT INTO `pos_world`.`playercreateinfo_spell` (`race`, `class`, `Spell`, `Note`) VALUES ('10', '2', '750', 'Plate');
INSERT INTO `pos_world`.`playercreateinfo_spell` (`race`, `class`, `Spell`, `Note`) VALUES ('10', '3', '750', 'Plate');
INSERT INTO `pos_world`.`playercreateinfo_spell` (`race`, `class`, `Spell`, `Note`) VALUES ('10', '4', '750', 'Plate');
INSERT INTO `pos_world`.`playercreateinfo_spell` (`race`, `class`, `Spell`, `Note`) VALUES ('10', '5', '750', 'Plate');
INSERT INTO `pos_world`.`playercreateinfo_spell` (`race`, `class`, `Spell`, `Note`) VALUES ('10', '6', '750', 'Plate');
INSERT INTO `pos_world`.`playercreateinfo_spell` (`race`, `class`, `Spell`, `Note`) VALUES ('10', '8', '750', 'Plate');
INSERT INTO `pos_world`.`playercreateinfo_spell` (`race`, `class`, `Spell`, `Note`) VALUES ('10', '9', '750', 'Plate');
## Dranei
INSERT INTO `pos_world`.`playercreateinfo_spell` (`race`, `class`, `Spell`, `Note`) VALUES ('11', '1', '750', 'Plate');
INSERT INTO `pos_world`.`playercreateinfo_spell` (`race`, `class`, `Spell`, `Note`) VALUES ('11', '2', '750', 'Plate');
INSERT INTO `pos_world`.`playercreateinfo_spell` (`race`, `class`, `Spell`, `Note`) VALUES ('11', '3', '750', 'Plate');
INSERT INTO `pos_world`.`playercreateinfo_spell` (`race`, `class`, `Spell`, `Note`) VALUES ('11', '5', '750', 'Plate');
INSERT INTO `pos_world`.`playercreateinfo_spell` (`race`, `class`, `Spell`, `Note`) VALUES ('11', '6', '750', 'Plate');
INSERT INTO `pos_world`.`playercreateinfo_spell` (`race`, `class`, `Spell`, `Note`) VALUES ('11', '7', '750', 'Plate');
INSERT INTO `pos_world`.`playercreateinfo_spell` (`race`, `class`, `Spell`, `Note`) VALUES ('11', '8', '750', 'Plate');
 
/* MAIL */
## Human
INSERT INTO `pos_world`.`playercreateinfo_spell` (`race`, `class`, `Spell`, `Note`) VALUES ('1', '1', '8737', 'Mail');
INSERT INTO `pos_world`.`playercreateinfo_spell` (`race`, `class`, `Spell`, `Note`) VALUES ('1', '2', '8737', 'Mail');
INSERT INTO `pos_world`.`playercreateinfo_spell` (`race`, `class`, `Spell`, `Note`) VALUES ('1', '4', '8737', 'Mail');
INSERT INTO `pos_world`.`playercreateinfo_spell` (`race`, `class`, `Spell`, `Note`) VALUES ('1', '5', '8737', 'Mail');
INSERT INTO `pos_world`.`playercreateinfo_spell` (`race`, `class`, `Spell`, `Note`) VALUES ('1', '6', '8737', 'Mail');
INSERT INTO `pos_world`.`playercreateinfo_spell` (`race`, `class`, `Spell`, `Note`) VALUES ('1', '8', '8737', 'Mail');
INSERT INTO `pos_world`.`playercreateinfo_spell` (`race`, `class`, `Spell`, `Note`) VALUES ('1', '9', '8737', 'Mail');
## Ork
INSERT INTO `pos_world`.`playercreateinfo_spell` (`race`, `class`, `Spell`, `Note`) VALUES ('2', '1', '8737', 'Mail');
INSERT INTO `pos_world`.`playercreateinfo_spell` (`race`, `class`, `Spell`, `Note`) VALUES ('2', '3', '8737', 'Mail');
INSERT INTO `pos_world`.`playercreateinfo_spell` (`race`, `class`, `Spell`, `Note`) VALUES ('2', '4', '8737', 'Mail');
INSERT INTO `pos_world`.`playercreateinfo_spell` (`race`, `class`, `Spell`, `Note`) VALUES ('2', '6', '8737', 'Mail');
INSERT INTO `pos_world`.`playercreateinfo_spell` (`race`, `class`, `Spell`, `Note`) VALUES ('2', '7', '8737', 'Mail');
INSERT INTO `pos_world`.`playercreateinfo_spell` (`race`, `class`, `Spell`, `Note`) VALUES ('2', '9', '8737', 'Mail');
## Dwarf
INSERT INTO `pos_world`.`playercreateinfo_spell` (`race`, `class`, `Spell`, `Note`) VALUES ('3', '1', '8737', 'Mail');
INSERT INTO `pos_world`.`playercreateinfo_spell` (`race`, `class`, `Spell`, `Note`) VALUES ('3', '2', '8737', 'Mail');
INSERT INTO `pos_world`.`playercreateinfo_spell` (`race`, `class`, `Spell`, `Note`) VALUES ('3', '3', '8737', 'Mail');
INSERT INTO `pos_world`.`playercreateinfo_spell` (`race`, `class`, `Spell`, `Note`) VALUES ('3', '4', '8737', 'Mail');
INSERT INTO `pos_world`.`playercreateinfo_spell` (`race`, `class`, `Spell`, `Note`) VALUES ('3', '5', '8737', 'Mail');
INSERT INTO `pos_world`.`playercreateinfo_spell` (`race`, `class`, `Spell`, `Note`) VALUES ('3', '6', '8737', 'Mail');
## Night elf
INSERT INTO `pos_world`.`playercreateinfo_spell` (`race`, `class`, `Spell`, `Note`) VALUES ('4', '1', '8737', 'Mail');
INSERT INTO `pos_world`.`playercreateinfo_spell` (`race`, `class`, `Spell`, `Note`) VALUES ('4', '3', '8737', 'Mail');
INSERT INTO `pos_world`.`playercreateinfo_spell` (`race`, `class`, `Spell`, `Note`) VALUES ('4', '4', '8737', 'Mail');
INSERT INTO `pos_world`.`playercreateinfo_spell` (`race`, `class`, `Spell`, `Note`) VALUES ('4', '5', '8737', 'Mail');
INSERT INTO `pos_world`.`playercreateinfo_spell` (`race`, `class`, `Spell`, `Note`) VALUES ('4', '6', '8737', 'Mail');
INSERT INTO `pos_world`.`playercreateinfo_spell` (`race`, `class`, `Spell`, `Note`) VALUES ('4', '11', '8737', 'Mail');
## Undead
INSERT INTO `pos_world`.`playercreateinfo_spell` (`race`, `class`, `Spell`, `Note`) VALUES ('5', '1', '8737', 'Mail');
INSERT INTO `pos_world`.`playercreateinfo_spell` (`race`, `class`, `Spell`, `Note`) VALUES ('5', '4', '8737', 'Mail');
INSERT INTO `pos_world`.`playercreateinfo_spell` (`race`, `class`, `Spell`, `Note`) VALUES ('5', '5', '8737', 'Mail');
INSERT INTO `pos_world`.`playercreateinfo_spell` (`race`, `class`, `Spell`, `Note`) VALUES ('5', '6', '8737', 'Mail');
INSERT INTO `pos_world`.`playercreateinfo_spell` (`race`, `class`, `Spell`, `Note`) VALUES ('5', '8', '8737', 'Mail');
INSERT INTO `pos_world`.`playercreateinfo_spell` (`race`, `class`, `Spell`, `Note`) VALUES ('5', '9', '8737', 'Mail');
## Taur
INSERT INTO `pos_world`.`playercreateinfo_spell` (`race`, `class`, `Spell`, `Note`) VALUES ('6', '1', '8737', 'Mail');
INSERT INTO `pos_world`.`playercreateinfo_spell` (`race`, `class`, `Spell`, `Note`) VALUES ('6', '3', '8737', 'Mail');
INSERT INTO `pos_world`.`playercreateinfo_spell` (`race`, `class`, `Spell`, `Note`) VALUES ('6', '6', '8737', 'Mail');
INSERT INTO `pos_world`.`playercreateinfo_spell` (`race`, `class`, `Spell`, `Note`) VALUES ('6', '7', '8737', 'Mail');
INSERT INTO `pos_world`.`playercreateinfo_spell` (`race`, `class`, `Spell`, `Note`) VALUES ('6', '11', '8737', 'Mail');
## Gnome
INSERT INTO `pos_world`.`playercreateinfo_spell` (`race`, `class`, `Spell`, `Note`) VALUES ('7', '1', '8737', 'Mail');
INSERT INTO `pos_world`.`playercreateinfo_spell` (`race`, `class`, `Spell`, `Note`) VALUES ('7', '4', '8737', 'Mail');
INSERT INTO `pos_world`.`playercreateinfo_spell` (`race`, `class`, `Spell`, `Note`) VALUES ('7', '6', '8737', 'Mail');
INSERT INTO `pos_world`.`playercreateinfo_spell` (`race`, `class`, `Spell`, `Note`) VALUES ('7', '8', '8737', 'Mail');
INSERT INTO `pos_world`.`playercreateinfo_spell` (`race`, `class`, `Spell`, `Note`) VALUES ('7', '9', '8737', 'Mail');
## Troll
INSERT INTO `pos_world`.`playercreateinfo_spell` (`race`, `class`, `Spell`, `Note`) VALUES ('8', '1', '8737', 'Mail');
INSERT INTO `pos_world`.`playercreateinfo_spell` (`race`, `class`, `Spell`, `Note`) VALUES ('8', '3', '8737', 'Mail');
INSERT INTO `pos_world`.`playercreateinfo_spell` (`race`, `class`, `Spell`, `Note`) VALUES ('8', '4', '8737', 'Mail');
INSERT INTO `pos_world`.`playercreateinfo_spell` (`race`, `class`, `Spell`, `Note`) VALUES ('8', '5', '8737', 'Mail');
INSERT INTO `pos_world`.`playercreateinfo_spell` (`race`, `class`, `Spell`, `Note`) VALUES ('8', '6', '8737', 'Mail');
INSERT INTO `pos_world`.`playercreateinfo_spell` (`race`, `class`, `Spell`, `Note`) VALUES ('8', '7', '8737', 'Mail');
INSERT INTO `pos_world`.`playercreateinfo_spell` (`race`, `class`, `Spell`, `Note`) VALUES ('8', '8', '8737', 'Mail');
## Blood elf
INSERT INTO `pos_world`.`playercreateinfo_spell` (`race`, `class`, `Spell`, `Note`) VALUES ('10', '2', '8737', 'Mail');
INSERT INTO `pos_world`.`playercreateinfo_spell` (`race`, `class`, `Spell`, `Note`) VALUES ('10', '3', '8737', 'Mail');
INSERT INTO `pos_world`.`playercreateinfo_spell` (`race`, `class`, `Spell`, `Note`) VALUES ('10', '4', '8737', 'Mail');
INSERT INTO `pos_world`.`playercreateinfo_spell` (`race`, `class`, `Spell`, `Note`) VALUES ('10', '5', '8737', 'Mail');
INSERT INTO `pos_world`.`playercreateinfo_spell` (`race`, `class`, `Spell`, `Note`) VALUES ('10', '6', '8737', 'Mail');
INSERT INTO `pos_world`.`playercreateinfo_spell` (`race`, `class`, `Spell`, `Note`) VALUES ('10', '8', '8737', 'Mail');
INSERT INTO `pos_world`.`playercreateinfo_spell` (`race`, `class`, `Spell`, `Note`) VALUES ('10', '9', '8737', 'Mail');
## Dranei
INSERT INTO `pos_world`.`playercreateinfo_spell` (`race`, `class`, `Spell`, `Note`) VALUES ('11', '1', '8737', 'Mail');
INSERT INTO `pos_world`.`playercreateinfo_spell` (`race`, `class`, `Spell`, `Note`) VALUES ('11', '2', '8737', 'Mail');
INSERT INTO `pos_world`.`playercreateinfo_spell` (`race`, `class`, `Spell`, `Note`) VALUES ('11', '3', '8737', 'Mail');
INSERT INTO `pos_world`.`playercreateinfo_spell` (`race`, `class`, `Spell`, `Note`) VALUES ('11', '5', '8737', 'Mail');
INSERT INTO `pos_world`.`playercreateinfo_spell` (`race`, `class`, `Spell`, `Note`) VALUES ('11', '6', '8737', 'Mail');
INSERT INTO `pos_world`.`playercreateinfo_spell` (`race`, `class`, `Spell`, `Note`) VALUES ('11', '7', '8737', 'Mail');
INSERT INTO `pos_world`.`playercreateinfo_spell` (`race`, `class`, `Spell`, `Note`) VALUES ('11', '8', '8737', 'Mail');
 
/* Leather */
## Human
INSERT INTO `pos_world`.`playercreateinfo_spell` (`race`, `class`, `Spell`, `Note`) VALUES ('1', '1', '9077', 'Leather');
INSERT INTO `pos_world`.`playercreateinfo_spell` (`race`, `class`, `Spell`, `Note`) VALUES ('1', '2', '9077', 'Leather');
INSERT INTO `pos_world`.`playercreateinfo_spell` (`race`, `class`, `Spell`, `Note`) VALUES ('1', '4', '9077', 'Leather');
INSERT INTO `pos_world`.`playercreateinfo_spell` (`race`, `class`, `Spell`, `Note`) VALUES ('1', '5', '9077', 'Leather');
INSERT INTO `pos_world`.`playercreateinfo_spell` (`race`, `class`, `Spell`, `Note`) VALUES ('1', '6', '9077', 'Leather');
INSERT INTO `pos_world`.`playercreateinfo_spell` (`race`, `class`, `Spell`, `Note`) VALUES ('1', '8', '9077', 'Leather');
INSERT INTO `pos_world`.`playercreateinfo_spell` (`race`, `class`, `Spell`, `Note`) VALUES ('1', '9', '9077', 'Leather');
## Ork
INSERT INTO `pos_world`.`playercreateinfo_spell` (`race`, `class`, `Spell`, `Note`) VALUES ('2', '1', '9077', 'Leather');
INSERT INTO `pos_world`.`playercreateinfo_spell` (`race`, `class`, `Spell`, `Note`) VALUES ('2', '3', '9077', 'Leather');
INSERT INTO `pos_world`.`playercreateinfo_spell` (`race`, `class`, `Spell`, `Note`) VALUES ('2', '4', '9077', 'Leather');
INSERT INTO `pos_world`.`playercreateinfo_spell` (`race`, `class`, `Spell`, `Note`) VALUES ('2', '6', '9077', 'Leather');
INSERT INTO `pos_world`.`playercreateinfo_spell` (`race`, `class`, `Spell`, `Note`) VALUES ('2', '7', '9077', 'Leather');
INSERT INTO `pos_world`.`playercreateinfo_spell` (`race`, `class`, `Spell`, `Note`) VALUES ('2', '9', '9077', 'Leather');
## Dwarf
INSERT INTO `pos_world`.`playercreateinfo_spell` (`race`, `class`, `Spell`, `Note`) VALUES ('3', '1', '9077', 'Leather');
INSERT INTO `pos_world`.`playercreateinfo_spell` (`race`, `class`, `Spell`, `Note`) VALUES ('3', '2', '9077', 'Leather');
INSERT INTO `pos_world`.`playercreateinfo_spell` (`race`, `class`, `Spell`, `Note`) VALUES ('3', '3', '9077', 'Leather');
INSERT INTO `pos_world`.`playercreateinfo_spell` (`race`, `class`, `Spell`, `Note`) VALUES ('3', '4', '9077', 'Leather');
INSERT INTO `pos_world`.`playercreateinfo_spell` (`race`, `class`, `Spell`, `Note`) VALUES ('3', '5', '9077', 'Leather');
INSERT INTO `pos_world`.`playercreateinfo_spell` (`race`, `class`, `Spell`, `Note`) VALUES ('3', '6', '9077', 'Leather');
## Night elf
INSERT INTO `pos_world`.`playercreateinfo_spell` (`race`, `class`, `Spell`, `Note`) VALUES ('4', '1', '9077', 'Leather');
INSERT INTO `pos_world`.`playercreateinfo_spell` (`race`, `class`, `Spell`, `Note`) VALUES ('4', '3', '9077', 'Leather');
INSERT INTO `pos_world`.`playercreateinfo_spell` (`race`, `class`, `Spell`, `Note`) VALUES ('4', '4', '9077', 'Leather');
INSERT INTO `pos_world`.`playercreateinfo_spell` (`race`, `class`, `Spell`, `Note`) VALUES ('4', '5', '9077', 'Leather');
INSERT INTO `pos_world`.`playercreateinfo_spell` (`race`, `class`, `Spell`, `Note`) VALUES ('4', '6', '9077', 'Leather');
INSERT INTO `pos_world`.`playercreateinfo_spell` (`race`, `class`, `Spell`, `Note`) VALUES ('4', '11', '9077', 'Leather');
## Undead
INSERT INTO `pos_world`.`playercreateinfo_spell` (`race`, `class`, `Spell`, `Note`) VALUES ('5', '1', '9077', 'Leather');
INSERT INTO `pos_world`.`playercreateinfo_spell` (`race`, `class`, `Spell`, `Note`) VALUES ('5', '4', '9077', 'Leather');
INSERT INTO `pos_world`.`playercreateinfo_spell` (`race`, `class`, `Spell`, `Note`) VALUES ('5', '5', '9077', 'Leather');
INSERT INTO `pos_world`.`playercreateinfo_spell` (`race`, `class`, `Spell`, `Note`) VALUES ('5', '6', '9077', 'Leather');
INSERT INTO `pos_world`.`playercreateinfo_spell` (`race`, `class`, `Spell`, `Note`) VALUES ('5', '8', '9077', 'Leather');
INSERT INTO `pos_world`.`playercreateinfo_spell` (`race`, `class`, `Spell`, `Note`) VALUES ('5', '9', '9077', 'Leather');
## Taur
INSERT INTO `pos_world`.`playercreateinfo_spell` (`race`, `class`, `Spell`, `Note`) VALUES ('6', '1', '9077', 'Leather');
INSERT INTO `pos_world`.`playercreateinfo_spell` (`race`, `class`, `Spell`, `Note`) VALUES ('6', '3', '9077', 'Leather');
INSERT INTO `pos_world`.`playercreateinfo_spell` (`race`, `class`, `Spell`, `Note`) VALUES ('6', '6', '9077', 'Leather');
INSERT INTO `pos_world`.`playercreateinfo_spell` (`race`, `class`, `Spell`, `Note`) VALUES ('6', '7', '9077', 'Leather');
INSERT INTO `pos_world`.`playercreateinfo_spell` (`race`, `class`, `Spell`, `Note`) VALUES ('6', '11', '9077', 'Leather');
## Gnome
INSERT INTO `pos_world`.`playercreateinfo_spell` (`race`, `class`, `Spell`, `Note`) VALUES ('7', '1', '9077', 'Leather');
INSERT INTO `pos_world`.`playercreateinfo_spell` (`race`, `class`, `Spell`, `Note`) VALUES ('7', '4', '9077', 'Leather');
INSERT INTO `pos_world`.`playercreateinfo_spell` (`race`, `class`, `Spell`, `Note`) VALUES ('7', '6', '9077', 'Leather');
INSERT INTO `pos_world`.`playercreateinfo_spell` (`race`, `class`, `Spell`, `Note`) VALUES ('7', '8', '9077', 'Leather');
INSERT INTO `pos_world`.`playercreateinfo_spell` (`race`, `class`, `Spell`, `Note`) VALUES ('7', '9', '9077', 'Leather');
## Troll
INSERT INTO `pos_world`.`playercreateinfo_spell` (`race`, `class`, `Spell`, `Note`) VALUES ('8', '1', '9077', 'Leather');
INSERT INTO `pos_world`.`playercreateinfo_spell` (`race`, `class`, `Spell`, `Note`) VALUES ('8', '3', '9077', 'Leather');
INSERT INTO `pos_world`.`playercreateinfo_spell` (`race`, `class`, `Spell`, `Note`) VALUES ('8', '4', '9077', 'Leather');
INSERT INTO `pos_world`.`playercreateinfo_spell` (`race`, `class`, `Spell`, `Note`) VALUES ('8', '5', '9077', 'Leather');
INSERT INTO `pos_world`.`playercreateinfo_spell` (`race`, `class`, `Spell`, `Note`) VALUES ('8', '6', '9077', 'Leather');
INSERT INTO `pos_world`.`playercreateinfo_spell` (`race`, `class`, `Spell`, `Note`) VALUES ('8', '7', '9077', 'Leather');
INSERT INTO `pos_world`.`playercreateinfo_spell` (`race`, `class`, `Spell`, `Note`) VALUES ('8', '8', '9077', 'Leather');
## Blood elf
INSERT INTO `pos_world`.`playercreateinfo_spell` (`race`, `class`, `Spell`, `Note`) VALUES ('10', '2', '9077', 'Leather');
INSERT INTO `pos_world`.`playercreateinfo_spell` (`race`, `class`, `Spell`, `Note`) VALUES ('10', '3', '9077', 'Leather');
INSERT INTO `pos_world`.`playercreateinfo_spell` (`race`, `class`, `Spell`, `Note`) VALUES ('10', '4', '9077', 'Leather');
INSERT INTO `pos_world`.`playercreateinfo_spell` (`race`, `class`, `Spell`, `Note`) VALUES ('10', '5', '9077', 'Leather');
INSERT INTO `pos_world`.`playercreateinfo_spell` (`race`, `class`, `Spell`, `Note`) VALUES ('10', '6', '9077', 'Leather');
INSERT INTO `pos_world`.`playercreateinfo_spell` (`race`, `class`, `Spell`, `Note`) VALUES ('10', '8', '9077', 'Leather');
INSERT INTO `pos_world`.`playercreateinfo_spell` (`race`, `class`, `Spell`, `Note`) VALUES ('10', '9', '9077', 'Leather');
## Dranei
INSERT INTO `pos_world`.`playercreateinfo_spell` (`race`, `class`, `Spell`, `Note`) VALUES ('11', '1', '9077', 'Leather');
INSERT INTO `pos_world`.`playercreateinfo_spell` (`race`, `class`, `Spell`, `Note`) VALUES ('11', '2', '9077', 'Leather');
INSERT INTO `pos_world`.`playercreateinfo_spell` (`race`, `class`, `Spell`, `Note`) VALUES ('11', '3', '9077', 'Leather');
INSERT INTO `pos_world`.`playercreateinfo_spell` (`race`, `class`, `Spell`, `Note`) VALUES ('11', '5', '9077', 'Leather');
INSERT INTO `pos_world`.`playercreateinfo_spell` (`race`, `class`, `Spell`, `Note`) VALUES ('11', '6', '9077', 'Leather');
INSERT INTO `pos_world`.`playercreateinfo_spell` (`race`, `class`, `Spell`, `Note`) VALUES ('11', '7', '9077', 'Leather');
INSERT INTO `pos_world`.`playercreateinfo_spell` (`race`, `class`, `Spell`, `Note`) VALUES ('11', '8', '9077', 'Leather');
 
/* END */

Kožené zbroje sa vyznačujú ľahkosťou a účinným faktorom pri ochrane pred prípadným zranením. Výroba kožených zbrojí je komplikovaná a vyžaduje precíznu prácu majstra. Hodnota výroby takejto zbroje je 4000 bodov.

SQL kód

 
/* LEATHER */
/* CHEST */
 
/* Opotrebovane */
UPDATE `item_template` SET 
 
`BuyPrice` = '4500',
`SellPrice` = '2250',
`armor` = '1125',
`StatsCount` = '2',
`stat_type1` = '30',
`stat_value1` = '-62',
`stat_type2` = '35',
`stat_value2` = '20',
`frost_res` = '5'
 
 
WHERE `item_template`.`class` =4 AND `subclass` =2 AND `Quality` =0 AND `InventoryType` = 5;
 
/* Primitivne */
 
UPDATE `item_template` SET 
 
`BuyPrice` = '4800',
`SellPrice` = '2400',
`armor` = '1200',
`StatsCount` = '2',
`stat_type1` = '30',
`stat_value1` = '-62',
`stat_type2` = '35',
`stat_value2` = '20',
`frost_res` = '5'
 
WHERE `item_template`.`class` =4 AND `subclass` =2 AND `Quality` =1 AND `InventoryType` = 5;
 
/* Kvalitne */
UPDATE `item_template` SET 
 
`BuyPrice` = '6000',
`SellPrice` = '3000',
`armor` = '1500',
`StatsCount` = '2',
`stat_type1` = '30',
`stat_value1` = '-62',
`stat_type2` = '35',
`stat_value2` = '20',
`frost_res` = '5'
 
WHERE `item_template`.`class` =4 AND `subclass` =2 AND `Quality` =2 AND `InventoryType` = 5;
 
/* Vzacne */
UPDATE `item_template` SET 
 
`BuyPrice` = '7500',
`SellPrice` = '3750',
`armor` = '1875',
`StatsCount` = '2',
`stat_type1` = '30',
`stat_value1` = '-62',
`stat_type2` = '35',
`stat_value2` = '20',
`frost_res` = '5'
 
 
WHERE `item_template`.`class` =4 AND `subclass` =2 AND `Quality` =3 AND `InventoryType` = 5;
 
/* Magicke */
UPDATE `item_template` SET 
 
`BuyPrice` = '6000',
`SellPrice` = '3000',
`armor` = '1500',
`StatsCount` = '2',
`stat_type1` = '30',
`stat_value1` = '-62',
`stat_type2` = '35',
`stat_value2` = '20',
`frost_res` = '5'
 
WHERE `item_template`.`class` =4 AND `subclass` =2 AND `Quality` =4 AND `InventoryType` = 5;
 
/* Legendarne */
UPDATE `item_template` SET 
 
`BuyPrice` = '9000',
`SellPrice` = '4500',
`armor` = '2250',
`StatsCount` = '2',
`stat_type1` = '30',
`stat_value1` = '-62',
`stat_type2` = '35',
`stat_value2` = '20',
`frost_res` = '5'
 
WHERE `item_template`.`class` =4 AND `subclass` =2 AND `Quality` =5 AND `InventoryType` = 5;
 
/* Artefakty */
UPDATE `item_template` SET 
 
`BuyPrice` = '6000',
`SellPrice` = '3000',
`armor` = '1500',
`StatsCount` = '2',
`stat_type1` = '30',
`stat_value1` = '-62',
`stat_type2` = '35',
`stat_value2` = '20',
`frost_res` = '5'
 
WHERE `item_template`.`class` =4 AND `subclass` =2 AND `Quality` =6 AND `InventoryType` = 5;
 
 
/* ********************************** */
 
/* FEET */
 
/* Opotrebovane */
UPDATE `item_template` SET 
 
`BuyPrice` = '2250',
`SellPrice` = '1125',
`armor` = '560',
`StatsCount` = '2',
`stat_type1` = '30',
`stat_value1` = '-62',
`stat_type2` = '35',
`stat_value2` = '20',
`frost_res` = '5'
 
WHERE `item_template`.`class` =4 AND `subclass` =2 AND `Quality` =0 AND `InventoryType` = 8;
 
/* Primitivne */
 
UPDATE `item_template` SET 
 
`BuyPrice` = '2400',
`SellPrice` = '1200',
`armor` = '600',
`StatsCount` = '2',
`stat_type1` = '30',
`stat_value1` = '-62',
`stat_type2` = '35',
`stat_value2` = '20',
`frost_res` = '5'
 
 
WHERE `item_template`.`class` =4 AND `subclass` =2 AND `Quality` =1 AND `InventoryType` = 8;
 
/* Kvalitne */
UPDATE `item_template` SET 
 
`BuyPrice` = '3000',
`SellPrice` = '1500',
`armor` = '750',
`StatsCount` = '2',
`stat_type1` = '30',
`stat_value1` = '-62',
`stat_type2` = '35',
`stat_value2` = '20',
`frost_res` = '5'
 
 
WHERE `item_template`.`class` =4 AND `subclass` =2 AND `Quality` =2 AND `InventoryType` = 8;
 
/* Vzacne */
UPDATE `item_template` SET 
 
`BuyPrice` = '3750',
`SellPrice` = '1875',
`armor` = '940',
`StatsCount` = '2',
`stat_type1` = '30',
`stat_value1` = '-62',
`stat_type2` = '35',
`stat_value2` = '20',
`frost_res` = '5'
 
 
WHERE `item_template`.`class` =4 AND `subclass` =2 AND `Quality` =3 AND `InventoryType` = 8;
 
/* Magicke */
UPDATE `item_template` SET 
 
`BuyPrice` = '3000',
`SellPrice` = '1500',
`armor` = '750',
`StatsCount` = '2',
`stat_type1` = '30',
`stat_value1` = '-62',
`stat_type2` = '35',
`stat_value2` = '20',
`frost_res` = '5'
 
 
WHERE `item_template`.`class` =4 AND `subclass` =2 AND `Quality` =4 AND `InventoryType` = 8;
 
/* Legendarne */
UPDATE `item_template` SET 
 
`BuyPrice` = '4500',
`SellPrice` = '2250',
`armor` = '1125',
`StatsCount` = '2',
`stat_type1` = '30',
`stat_value1` = '-62',
`stat_type2` = '35',
`stat_value2` = '20',
`frost_res` = '5'
 
 
WHERE `item_template`.`class` =4 AND `subclass` =2 AND `Quality` =5 AND `InventoryType` = 8;
 
/* Artefakty */
UPDATE `item_template` SET 
 
`BuyPrice` = '3000',
`SellPrice` = '1500',
`armor` = '750',
`StatsCount` = '2',
`stat_type1` = '30',
`stat_value1` = '-62',
`stat_type2` = '35',
`stat_value2` = '20',
`frost_res` = '5'
 
 
WHERE `item_template`.`class` =4 AND `subclass` =2 AND `Quality` =6 AND `InventoryType` = 8;
 
 
/* ********************************** */
 
/* HANDS */
 
/* Opotrebovane */
UPDATE `item_template` SET 
 
`BuyPrice` = '1125',
`SellPrice` = '560',
`armor` = '281',
`StatsCount` = '2',
`stat_type1` = '30',
`stat_value1` = '-62',
`stat_type2` = '35',
`stat_value2` = '20',
`frost_res` = '5'
 
WHERE `item_template`.`class` =4 AND `subclass` =2 AND `Quality` =0 AND `InventoryType` = 10;
 
/* Primitivne */
 
UPDATE `item_template` SET 
 
`BuyPrice` = '1200',
`SellPrice` = '600',
`armor` = '300',
`StatsCount` = '2',
`stat_type1` = '30',
`stat_value1` = '-62',
`stat_type2` = '35',
`stat_value2` = '20',
`frost_res` = '5'
 
 
WHERE `item_template`.`class` =4 AND `subclass` =2 AND `Quality` =1 AND `InventoryType` = 10;
 
/* Kvalitne */
UPDATE `item_template` SET 
 
`BuyPrice` = '1500',
`SellPrice` = '750',
`armor` = '375',
`StatsCount` = '2',
`stat_type1` = '30',
`stat_value1` = '-62',
`stat_type2` = '35',
`stat_value2` = '20',
`frost_res` = '5'
 
WHERE `item_template`.`class` =4 AND `subclass` =2 AND `Quality` =2 AND `InventoryType` = 10;
 
/* Vzacne */
UPDATE `item_template` SET 
 
`BuyPrice` = '1875',
`SellPrice` = '935',
`armor` = '470',
`StatsCount` = '2',
`stat_type1` = '30',
`stat_value1` = '-62',
`stat_type2` = '35',
`stat_value2` = '20',
`frost_res` = '5'
 
 
WHERE `item_template`.`class` =4 AND `subclass` =2 AND `Quality` =3 AND `InventoryType` = 10;
 
/* Magicke */
UPDATE `item_template` SET 
 
`BuyPrice` = '1500',
`SellPrice` = '750',
`armor` = '375',
`StatsCount` = '2',
`stat_type1` = '30',
`stat_value1` = '-62',
`stat_type2` = '35',
`stat_value2` = '20',
`frost_res` = '5'
 
WHERE `item_template`.`class` =4 AND `subclass` =2 AND `Quality` =4 AND `InventoryType` = 10;
 
/* Legendarne */
UPDATE `item_template` SET 
 
`BuyPrice` = '2250',
`SellPrice` = '1125',
`armor` = '560',
`StatsCount` = '2',
`stat_type1` = '30',
`stat_value1` = '-62',
`stat_type2` = '35',
`stat_value2` = '20',
`frost_res` = '5'
 
 
WHERE `item_template`.`class` =4 AND `subclass` =2 AND `Quality` =5 AND `InventoryType` = 10;
 
/* Artefakty */
UPDATE `item_template` SET 
 
`BuyPrice` = '1500',
`SellPrice` = '750',
`armor` = '375',
`StatsCount` = '2',
`stat_type1` = '30',
`stat_value1` = '-62',
`stat_type2` = '35',
`stat_value2` = '20',
`frost_res` = '5'
 
 
WHERE `item_template`.`class` =4 AND `subclass` =2 AND `Quality` =6 AND `InventoryType` = 10;
 
 
/* -------------------------- */
 
 
/* HEAD */
 
/* Opotrebovane */
UPDATE `item_template` SET 
 
`BuyPrice` = '2250',
`SellPrice` = '1125',
`armor` = '560',
`StatsCount` = '2',
`stat_type1` = '30',
`stat_value1` = '-62',
`stat_type2` = '35',
`stat_value2` = '20',
`frost_res` = '5'
 
WHERE `item_template`.`class` =4 AND `subclass` =2 AND `Quality` =0 AND `InventoryType` = 1;
 
/* Primitivne */
 
UPDATE `item_template` SET 
 
`BuyPrice` = '2400',
`SellPrice` = '1200',
`armor` = '600',
`StatsCount` = '2',
`stat_type1` = '30',
`stat_value1` = '-62',
`stat_type2` = '35',
`stat_value2` = '20',
`frost_res` = '5'
 
WHERE `item_template`.`class` =4 AND `subclass` =2 AND `Quality` =1 AND `InventoryType` = 1;
 
/* Kvalitne */
UPDATE `item_template` SET 
 
`BuyPrice` = '3000',
`SellPrice` = '1500',
`armor` = '750',
`StatsCount` = '2',
`stat_type1` = '30',
`stat_value1` = '-62',
`stat_type2` = '35',
`stat_value2` = '20',
`frost_res` = '5'
 
 
WHERE `item_template`.`class` =4 AND `subclass` =2 AND `Quality` =2 AND `InventoryType` = 1;
 
/* Vzacne */
UPDATE `item_template` SET 
 
`BuyPrice` = '3750',
`SellPrice` = '1875',
`armor` = '940',
`StatsCount` = '2',
`stat_type1` = '30',
`stat_value1` = '-62',
`stat_type2` = '35',
`stat_value2` = '20',
`frost_res` = '5'
 
 
WHERE `item_template`.`class` =4 AND `subclass` =2 AND `Quality` =3 AND `InventoryType` = 1;
 
/* Magicke */
UPDATE `item_template` SET 
 
`BuyPrice` = '3000',
`SellPrice` = '1500',
`armor` = '750',
`StatsCount` = '2',
`stat_type1` = '30',
`stat_value1` = '-62',
`stat_type2` = '35',
`stat_value2` = '20',
`frost_res` = '5'
 
WHERE `item_template`.`class` =4 AND `subclass` =2 AND `Quality` =4 AND `InventoryType` = 1;
 
/* Legendarne */
UPDATE `item_template` SET 
 
`BuyPrice` = '4500',
`SellPrice` = '2250',
`armor` = '1125',
`StatsCount` = '2',
`stat_type1` = '30',
`stat_value1` = '-62',
`stat_type2` = '35',
`stat_value2` = '20',
`frost_res` = '5'
 
 
WHERE `item_template`.`class` =4 AND `subclass` =2 AND `Quality` =5 AND `InventoryType` = 1;
 
/* Artefakty */
UPDATE `item_template` SET 
 
`BuyPrice` = '3000',
`SellPrice` = '1500',
`armor` = '750',
`StatsCount` = '2',
`stat_type1` = '30',
`stat_value1` = '-62',
`stat_type2` = '35',
`stat_value2` = '20',
`frost_res` = '5'
 
 
WHERE `item_template`.`class` =4 AND `subclass` =2 AND `Quality` =6 AND `InventoryType` = 1;
 
/* ----------------------------------------- */
 
/* LEGS */
 
/* Opotrebovane */
UPDATE `item_template` SET 
 
`BuyPrice` = '4500',
`SellPrice` = '2250',
`armor` = '1125',
`StatsCount` = '2',
`stat_type1` = '30',
`stat_value1` = '-62',
`stat_type2` = '35',
`stat_value2` = '20',
`frost_res` = '5'
 
 
WHERE `item_template`.`class` =4 AND `subclass` =2 AND `Quality` =0 AND `InventoryType` = 7;
 
/* Primitivne */
 
UPDATE `item_template` SET 
 
`BuyPrice` = '4800',
`SellPrice` = '2400',
`armor` = '1200',
`StatsCount` = '2',
`stat_type1` = '30',
`stat_value1` = '-62',
`stat_type2` = '35',
`stat_value2` = '20',
`frost_res` = '5'
 
 
WHERE `item_template`.`class` =4 AND `subclass` =2 AND `Quality` =1 AND `InventoryType` = 7;
 
/* Kvalitne */
UPDATE `item_template` SET 
 
`BuyPrice` = '6000',
`SellPrice` = '3000',
`armor` = '1500',
`StatsCount` = '2',
`stat_type1` = '30',
`stat_value1` = '-62',
`stat_type2` = '35',
`stat_value2` = '20',
`frost_res` = '5'
 
WHERE `item_template`.`class` =4 AND `subclass` =2 AND `Quality` =2 AND `InventoryType` = 7;
 
/* Vzacne */
UPDATE `item_template` SET 
 
`BuyPrice` = '7500',
`SellPrice` = '3750',
`armor` = '1875',
`StatsCount` = '2',
`stat_type1` = '30',
`stat_value1` = '-62',
`stat_type2` = '35',
`stat_value2` = '20',
`frost_res` = '5'
 
 
WHERE `item_template`.`class` =4 AND `subclass` =2 AND `Quality` =3 AND `InventoryType` = 7;
 
/* Magicke */
UPDATE `item_template` SET 
 
`BuyPrice` = '6000',
`SellPrice` = '3000',
`armor` = '1500',
`StatsCount` = '2',
`stat_type1` = '30',
`stat_value1` = '-62',
`stat_type2` = '35',
`stat_value2` = '20',
`frost_res` = '5'
 
 
WHERE `item_template`.`class` =4 AND `subclass` =2 AND `Quality` =4 AND `InventoryType` = 7;
 
/* Legendarne */
UPDATE `item_template` SET 
 
`BuyPrice` = '9000',
`SellPrice` = '4500',
`armor` = '2250',
`StatsCount` = '2',
`stat_type1` = '30',
`stat_value1` = '-62',
`stat_type2` = '35',
`stat_value2` = '20',
`frost_res` = '5'
 
 
WHERE `item_template`.`class` =4 AND `subclass` =2 AND `Quality` =5 AND `InventoryType` = 7;
 
/* Artefakty */
UPDATE `item_template` SET 
 
`BuyPrice` = '6000',
`SellPrice` = '3000',
`armor` = '1500',
`StatsCount` = '2',
`stat_type1` = '30',
`stat_value1` = '-62',
`stat_type2` = '35',
`stat_value2` = '20',
`frost_res` = '5'
 
 
WHERE `item_template`.`class` =4 AND `subclass` =2 AND `Quality` =6 AND `InventoryType` = 7;
 
/* -------------------------- */
 
 
/* SHOULDERS */
 
/* Opotrebovane */
UPDATE `item_template` SET 
 
`BuyPrice` = '2250',
`SellPrice` = '1125',
`armor` = '560',
`StatsCount` = '2',
`stat_type1` = '30',
`stat_value1` = '-62',
`stat_type2` = '35',
`stat_value2` = '20',
`frost_res` = '5'
 
 
WHERE `item_template`.`class` =4 AND `subclass` =2 AND `Quality` =0 AND `InventoryType` = 3;
 
/* Primitivne */
 
UPDATE `item_template` SET 
 
`BuyPrice` = '2400',
`SellPrice` = '1200',
`armor` = '600',
`StatsCount` = '2',
`stat_type1` = '30',
`stat_value1` = '-62',
`stat_type2` = '35',
`stat_value2` = '20',
`frost_res` = '5'
 
 
WHERE `item_template`.`class` =4 AND `subclass` =2 AND `Quality` =1 AND `InventoryType` = 3;
 
/* Kvalitne */
UPDATE `item_template` SET 
 
`BuyPrice` = '3000',
`SellPrice` = '1500',
`armor` = '750',
`StatsCount` = '2',
`stat_type1` = '30',
`stat_value1` = '-62',
`stat_type2` = '35',
`stat_value2` = '20',
`frost_res` = '5'
 
 
WHERE `item_template`.`class` =4 AND `subclass` =2 AND `Quality` =2 AND `InventoryType` = 3;
 
/* Vzacne */
UPDATE `item_template` SET 
 
`BuyPrice` = '3750',
`SellPrice` = '1875',
`armor` = '940',
`StatsCount` = '2',
`stat_type1` = '30',
`stat_value1` = '-62',
`stat_type2` = '35',
`stat_value2` = '20',
`frost_res` = '5'
 
 
WHERE `item_template`.`class` =4 AND `subclass` =2 AND `Quality` =3 AND `InventoryType` = 3;
 
/* Magicke */
UPDATE `item_template` SET 
 
`BuyPrice` = '3000',
`SellPrice` = '1500',
`armor` = '750',
`StatsCount` = '2',
`stat_type1` = '30',
`stat_value1` = '-62',
`stat_type2` = '35',
`stat_value2` = '20',
`frost_res` = '5'
 
 
WHERE `item_template`.`class` =4 AND `subclass` =2 AND `Quality` =4 AND `InventoryType` = 3;
 
/* Legendarne */
UPDATE `item_template` SET 
 
`BuyPrice` = '4500',
`SellPrice` = '2250',
`armor` = '1125',
`StatsCount` = '2',
`stat_type1` = '30',
`stat_value1` = '-62',
`stat_type2` = '35',
`stat_value2` = '20',
`frost_res` = '5'
 
 
WHERE `item_template`.`class` =4 AND `subclass` =2 AND `Quality` =5 AND `InventoryType` = 3;
 
/* Artefakty */
UPDATE `item_template` SET 
 
`BuyPrice` = '3000',
`SellPrice` = '1500',
`armor` = '750',
`StatsCount` = '2',
`stat_type1` = '30',
`stat_value1` = '-62',
`stat_type2` = '35',
`stat_value2` = '20',
`frost_res` = '5'
 
WHERE `item_template`.`class` =4 AND `subclass` =2 AND `Quality` =6 AND `InventoryType` = 3;
 
 
/* ------------------------- */
 
/* WAIST */
 
/* Opotrebovane */
UPDATE `item_template` SET 
 
`BuyPrice` = '1125',
`SellPrice` = '560',
`armor` = '281',
`StatsCount` = '2',
`stat_type1` = '30',
`stat_value1` = '-62',
`stat_type2` = '35',
`stat_value2` = '20',
`frost_res` = '5'
 
 
WHERE `item_template`.`class` =4 AND `subclass` =2 AND `Quality` =0 AND `InventoryType` = 6;
 
/* Primitivne */
 
UPDATE `item_template` SET 
 
`BuyPrice` = '1200',
`SellPrice` = '600',
`armor` = '300',
`StatsCount` = '2',
`stat_type1` = '30',
`stat_value1` = '-62',
`stat_type2` = '35',
`stat_value2` = '20',
`frost_res` = '5'
 
 
WHERE `item_template`.`class` =4 AND `subclass` =2 AND `Quality` =1 AND `InventoryType` = 6;
 
/* Kvalitne */
UPDATE `item_template` SET 
 
`BuyPrice` = '1500',
`SellPrice` = '750',
`armor` = '375',
`StatsCount` = '2',
`stat_type1` = '30',
`stat_value1` = '-62',
`stat_type2` = '35',
`stat_value2` = '20',
`frost_res` = '5'
 
 
WHERE `item_template`.`class` =4 AND `subclass` =2 AND `Quality` =2 AND `InventoryType` = 6;
 
/* Vzacne */
UPDATE `item_template` SET 
 
`BuyPrice` = '1875',
`SellPrice` = '935',
`armor` = '470',
`StatsCount` = '2',
`stat_type1` = '30',
`stat_value1` = '-62',
`stat_type2` = '35',
`stat_value2` = '20',
`frost_res` = '5'
 
 
WHERE `item_template`.`class` =4 AND `subclass` =2 AND `Quality` =3 AND `InventoryType` = 6;
 
/* Magicke */
UPDATE `item_template` SET 
 
`BuyPrice` = '1500',
`SellPrice` = '750',
`armor` = '375',
`StatsCount` = '2',
`stat_type1` = '30',
`stat_value1` = '-62',
`stat_type2` = '35',
`stat_value2` = '20',
`frost_res` = '5'
 
WHERE `item_template`.`class` =4 AND `subclass` =2 AND `Quality` =4 AND `InventoryType` = 6;
 
/* Legendarne */
UPDATE `item_template` SET 
 
`BuyPrice` = '2250',
`SellPrice` = '1125',
`armor` = '560',
`StatsCount` = '2',
`stat_type1` = '30',
`stat_value1` = '-62',
`stat_type2` = '35',
`stat_value2` = '20',
`frost_res` = '5'
 
WHERE `item_template`.`class` =4 AND `subclass` =2 AND `Quality` =5 AND `InventoryType` = 6;
 
/* Artefakty */
UPDATE `item_template` SET 
 
`BuyPrice` = '1500',
`SellPrice` = '750',
`armor` = '375',
`StatsCount` = '2',
`stat_type1` = '30',
`stat_value1` = '-62',
`stat_type2` = '35',
`stat_value2` = '20',
`frost_res` = '5'
 
 
WHERE `item_template`.`class` =4 AND `subclass` =2 AND `Quality` =6 AND `InventoryType` = 6;
 
/* -------------------------- */
 
 
/* WRIST */
 
/* Opotrebovane */
UPDATE `item_template` SET 
 
`BuyPrice` = '1125',
`SellPrice` = '560',
`armor` = '281',
`StatsCount` = '2',
`stat_type1` = '30',
`stat_value1` = '-62',
`stat_type2` = '35',
`stat_value2` = '20',
`frost_res` = '5'
 
 
WHERE `item_template`.`class` =4 AND `subclass` =2 AND `Quality` =0 AND `InventoryType` = 9;
 
/* Primitivne */
 
UPDATE `item_template` SET 
 
`BuyPrice` = '1200',
`SellPrice` = '600',
`armor` = '300',
`StatsCount` = '2',
`stat_type1` = '30',
`stat_value1` = '-62',
`stat_type2` = '35',
`stat_value2` = '20',
`frost_res` = '5'
 
 
WHERE `item_template`.`class` =4 AND `subclass` =2 AND `Quality` =1 AND `InventoryType` = 9;
 
/* Kvalitne */
UPDATE `item_template` SET 
 
`BuyPrice` = '1500',
`SellPrice` = '750',
`armor` = '375',
`StatsCount` = '2',
`stat_type1` = '30',
`stat_value1` = '-62',
`stat_type2` = '35',
`stat_value2` = '20',
`frost_res` = '5'
 
 
WHERE `item_template`.`class` =4 AND `subclass` =2 AND `Quality` =2 AND `InventoryType` = 9;
 
/* Vzacne */
UPDATE `item_template` SET 
 
`BuyPrice` = '1875',
`SellPrice` = '935',
`armor` = '470',
`StatsCount` = '2',
`stat_type1` = '30',
`stat_value1` = '-62',
`stat_type2` = '35',
`stat_value2` = '20',
`frost_res` = '5'
 
WHERE `item_template`.`class` =4 AND `subclass` =2 AND `Quality` =3 AND `InventoryType` = 9;
 
/* Magicke */
UPDATE `item_template` SET 
 
`BuyPrice` = '1500',
`SellPrice` = '750',
`armor` = '375',
`StatsCount` = '2',
`stat_type1` = '30',
`stat_value1` = '-62',
`stat_type2` = '35',
`stat_value2` = '20',
`frost_res` = '5'
 
 
WHERE `item_template`.`class` =4 AND `subclass` =2 AND `Quality` =4 AND `InventoryType` = 9;
 
/* Legendarne */
UPDATE `item_template` SET 
 
`BuyPrice` = '2250',
`SellPrice` = '1125',
`armor` = '560',
`StatsCount` = '2',
`stat_type1` = '30',
`stat_value1` = '-62',
`stat_type2` = '35',
`stat_value2` = '20',
`frost_res` = '5'
 
WHERE `item_template`.`class` =4 AND `subclass` =2 AND `Quality` =5 AND `InventoryType` = 9;
 
/* Artefakty */
UPDATE `item_template` SET 
 
`BuyPrice` = '1500',
`SellPrice` = '750',
`armor` = '375',
`StatsCount` = '2',
`stat_type1` = '30',
`stat_value1` = '-62',
`stat_type2` = '35',
`stat_value2` = '20',
`frost_res` = '5'
 
 
WHERE `item_template`.`class` =4 AND `subclass` =2 AND `Quality` =6 AND `InventoryType` = 9;
 
/* -------------------------- */

Leather

MAIL (Kroužkové zbroje)

Krúžkové a inak vystužené zbroje. Výroba týchto zbrojí je síce prácna a nákladná, ale vždy výhodnejšia a lacnejšia ako pri platových brneniach. Hodnota výroby je 3000.

SQL kód

 
/* MAIL */
/* CHEST */
 
/* Opotrebovane */
UPDATE `item_template` SET 
 
`BuyPrice` = '6750',
`SellPrice` = '3375',
`armor` = '2250',
`StatsCount` = '4',
`stat_type1` = '30',
`stat_value1` = '-188',
`stat_type2` = '3',
`stat_value2` = '-5',
`stat_type3` = '35',
`stat_value3` = '29',
`stat_type4` = '29',
`stat_value4` = '-188'
 
WHERE `item_template`.`class` =4 AND `subclass` =3 AND `Quality` =0 AND `InventoryType` = 5;
 
/* Primitivne */
 
UPDATE `item_template` SET 
 
`BuyPrice` = '7200',
`SellPrice` = '3600',
`armor` = '2400',
`StatsCount` = '4',
`stat_type1` = '30',
`stat_value1` = '-188',
`stat_type2` = '3',
`stat_value2` = '-5',
`stat_type3` = '35',
`stat_value3` = '29',
`stat_type4` = '29',
`stat_value4` = '-188'
 
WHERE `item_template`.`class` =4 AND `subclass` =3 AND `Quality` =1 AND `InventoryType` = 5;
 
/* Kvalitne */
UPDATE `item_template` SET 
 
`BuyPrice` = '9000',
`SellPrice` = '4500',
`armor` = '3000',
`StatsCount` = '4',
`stat_type1` = '30',
`stat_value1` = '-188',
`stat_type2` = '3',
`stat_value2` = '-5',
`stat_type3` = '35',
`stat_value3` = '29',
`stat_type4` = '29',
`stat_value4` = '-188'
 
WHERE `item_template`.`class` =4 AND `subclass` =3 AND `Quality` =2 AND `InventoryType` = 5;
 
/* Vzacne */
UPDATE `item_template` SET 
 
`BuyPrice` = '11250',
`SellPrice` = '5600',
`armor` = '3750',
`StatsCount` = '4',
`stat_type1` = '30',
`stat_value1` = '-188',
`stat_type2` = '3',
`stat_value2` = '-5',
`stat_type3` = '35',
`stat_value3` = '29',
`stat_type4` = '29',
`stat_value4` = '-188'
 
WHERE `item_template`.`class` =4 AND `subclass` =3 AND `Quality` =3 AND `InventoryType` = 5;
 
/* Magicke */
UPDATE `item_template` SET 
 
`BuyPrice` = '9000',
`SellPrice` = '4500',
`armor` = '3000',
`StatsCount` = '4',
`stat_type1` = '30',
`stat_value1` = '-188',
`stat_type2` = '3',
`stat_value2` = '-5',
`stat_type3` = '35',
`stat_value3` = '29',
`stat_type4` = '29',
`stat_value4` = '-188'
 
WHERE `item_template`.`class` =4 AND `subclass` =3 AND `Quality` =4 AND `InventoryType` = 5;
 
/* Legendarne */
UPDATE `item_template` SET 
 
`BuyPrice` = '13500',
`SellPrice` = '6750',
`armor` = '4500',
`StatsCount` = '4',
`stat_type1` = '30',
`stat_value1` = '-188',
`stat_type2` = '3',
`stat_value2` = '-5',
`stat_type3` = '35',
`stat_value3` = '29',
`stat_type4` = '29',
`stat_value4` = '-188'
 
WHERE `item_template`.`class` =4 AND `subclass` =3 AND `Quality` =5 AND `InventoryType` = 5;
 
/* Artefakty */
UPDATE `item_template` SET 
 
`BuyPrice` = '9000',
`SellPrice` = '4500',
`armor` = '3000',
`StatsCount` = '4',
`stat_type1` = '30',
`stat_value1` = '-188',
`stat_type2` = '3',
`stat_value2` = '-5',
`stat_type3` = '35',
`stat_value3` = '29',
`stat_type4` = '29',
`stat_value4` = '-188'
 
WHERE `item_template`.`class` =4 AND `subclass` =3 AND `Quality` =6 AND `InventoryType` = 5;
 
 
/* ********************************** */
 
/* FEET */
 
/* Opotrebovane */
UPDATE `item_template` SET 
 
`BuyPrice` = '3400',
`SellPrice` = '1700',
`armor` = '1125',
`StatsCount` = '4',
`stat_type1` = '30',
`stat_value1` = '-188',
`stat_type2` = '3',
`stat_value2` = '-5',
`stat_type3` = '35',
`stat_value3` = '29',
`stat_type4` = '29',
`stat_value4` = '-188'
 
WHERE `item_template`.`class` =4 AND `subclass` =3 AND `Quality` =0 AND `InventoryType` = 8;
 
/* Primitivne */
 
UPDATE `item_template` SET 
 
`BuyPrice` = '3600',
`SellPrice` = '1800',
`armor` = '1200',
`StatsCount` = '4',
`stat_type1` = '30',
`stat_value1` = '-188',
`stat_type2` = '3',
`stat_value2` = '-5',
`stat_type3` = '35',
`stat_value3` = '29',
`stat_type4` = '29',
`stat_value4` = '-188'
 
WHERE `item_template`.`class` =4 AND `subclass` =3 AND `Quality` =1 AND `InventoryType` = 8;
 
/* Kvalitne */
UPDATE `item_template` SET 
 
`BuyPrice` = '4500',
`SellPrice` = '2250',
`armor` = '1500',
`StatsCount` = '4',
`stat_type1` = '30',
`stat_value1` = '-188',
`stat_type2` = '3',
`stat_value2` = '-5',
`stat_type3` = '35',
`stat_value3` = '29',
`stat_type4` = '29',
`stat_value4` = '-188'
WHERE `item_template`.`class` =4 AND `subclass` =3 AND `Quality` =2 AND `InventoryType` = 8;
 
/* Vzacne */
UPDATE `item_template` SET 
 
`BuyPrice` = '5600',
`SellPrice` = '2550',
`armor` = '1875',
`StatsCount` = '4',
`stat_type1` = '30',
`stat_value1` = '-188',
`stat_type2` = '3',
`stat_value2` = '-5',
`stat_type3` = '35',
`stat_value3` = '29',
`stat_type4` = '29',
`stat_value4` = '-188'
 
WHERE `item_template`.`class` =4 AND `subclass` =3 AND `Quality` =3 AND `InventoryType` = 8;
 
/* Magicke */
UPDATE `item_template` SET 
 
`BuyPrice` = '4500',
`SellPrice` = '2250',
`armor` = '1500',
`StatsCount` = '4',
`stat_type1` = '30',
`stat_value1` = '-188',
`stat_type2` = '3',
`stat_value2` = '-5',
`stat_type3` = '35',
`stat_value3` = '29',
`stat_type4` = '29',
`stat_value4` = '-188'
 
WHERE `item_template`.`class` =4 AND `subclass` =3 AND `Quality` =4 AND `InventoryType` = 8;
 
/* Legendarne */
UPDATE `item_template` SET 
 
`BuyPrice` = '6750',
`SellPrice` = '3375',
`armor` = '2250',
`StatsCount` = '4',
`stat_type1` = '30',
`stat_value1` = '-188',
`stat_type2` = '3',
`stat_value2` = '-5',
`stat_type3` = '35',
`stat_value3` = '29',
`stat_type4` = '29',
`stat_value4` = '-188'
 
WHERE `item_template`.`class` =4 AND `subclass` =3 AND `Quality` =5 AND `InventoryType` = 8;
 
/* Artefakty */
UPDATE `item_template` SET 
 
`BuyPrice` = '4500',
`SellPrice` = '2250',
`armor` = '1500',
`StatsCount` = '4',
`stat_type1` = '30',
`stat_value1` = '-188',
`stat_type2` = '3',
`stat_value2` = '-5',
`stat_type3` = '35',
`stat_value3` = '29',
`stat_type4` = '29',
`stat_value4` = '-188'
 
WHERE `item_template`.`class` =4 AND `subclass` =3 AND `Quality` =6 AND `InventoryType` = 8;
 
 
/* ********************************** */
 
/* HANDS */
 
/* Opotrebovane */
UPDATE `item_template` SET 
 
`BuyPrice` = '1700',
`SellPrice` = '850',
`armor` = '560',
`StatsCount` = '4',
`stat_type1` = '30',
`stat_value1` = '-188',
`stat_type2` = '3',
`stat_value2` = '-5',
`stat_type3` = '35',
`stat_value3` = '29',
`stat_type4` = '29',
`stat_value4` = '-188'
 
WHERE `item_template`.`class` =4 AND `subclass` =3 AND `Quality` =0 AND `InventoryType` = 10;
 
/* Primitivne */
 
UPDATE `item_template` SET 
 
`BuyPrice` = '1800',
`SellPrice` = '900',
`armor` = '600',
`StatsCount` = '4',
`stat_type1` = '30',
`stat_value1` = '-188',
`stat_type2` = '3',
`stat_value2` = '-5',
`stat_type3` = '35',
`stat_value3` = '29',
`stat_type4` = '29',
`stat_value4` = '-188'
 
WHERE `item_template`.`class` =4 AND `subclass` =3 AND `Quality` =1 AND `InventoryType` = 10;
 
/* Kvalitne */
UPDATE `item_template` SET 
 
`BuyPrice` = '2250',
`SellPrice` = '1125',
`armor` = '750',
`StatsCount` = '4',
`stat_type1` = '30',
`stat_value1` = '-188',
`stat_type2` = '3',
`stat_value2` = '-5',
`stat_type3` = '35',
`stat_value3` = '29',
`stat_type4` = '29',
`stat_value4` = '-188'
 
WHERE `item_template`.`class` =4 AND `subclass` =3 AND `Quality` =2 AND `InventoryType` = 10;
 
/* Vzacne */
UPDATE `item_template` SET 
 
`BuyPrice` = '2800',
`SellPrice` = '1400',
`armor` = '940',
`StatsCount` = '4',
`stat_type1` = '30',
`stat_value1` = '-188',
`stat_type2` = '3',
`stat_value2` = '-5',
`stat_type3` = '35',
`stat_value3` = '29',
`stat_type4` = '29',
`stat_value4` = '-188'
 
WHERE `item_template`.`class` =4 AND `subclass` =3 AND `Quality` =3 AND `InventoryType` = 10;
 
/* Magicke */
UPDATE `item_template` SET 
 
`BuyPrice` = '2250',
`SellPrice` = '1125',
`armor` = '750',
`StatsCount` = '4',
`stat_type1` = '30',
`stat_value1` = '-188',
`stat_type2` = '3',
`stat_value2` = '-5',
`stat_type3` = '35',
`stat_value3` = '29',
`stat_type4` = '29',
`stat_value4` = '-188'
 
WHERE `item_template`.`class` =4 AND `subclass` =3 AND `Quality` =4 AND `InventoryType` = 10;
 
/* Legendarne */
UPDATE `item_template` SET 
 
`BuyPrice` = '3400',
`SellPrice` = '1700',
`armor` = '1125',
`StatsCount` = '4',
`stat_type1` = '30',
`stat_value1` = '-188',
`stat_type2` = '3',
`stat_value2` = '-5',
`stat_type3` = '35',
`stat_value3` = '29',
`stat_type4` = '29',
`stat_value4` = '-188'
 
WHERE `item_template`.`class` =4 AND `subclass` =3 AND `Quality` =5 AND `InventoryType` = 10;
 
/* Artefakty */
UPDATE `item_template` SET 
 
`BuyPrice` = '2250',
`SellPrice` = '1125',
`armor` = '750',
`StatsCount` = '4',
`stat_type1` = '30',
`stat_value1` = '-188',
`stat_type2` = '3',
`stat_value2` = '-5',
`stat_type3` = '35',
`stat_value3` = '29',
`stat_type4` = '29',
`stat_value4` = '-188'
 
WHERE `item_template`.`class` =4 AND `subclass` =3 AND `Quality` =6 AND `InventoryType` = 10;
 
 
/* -------------------------- */
 
 
/* HEAD */
 
/* Opotrebovane */
UPDATE `item_template` SET 
 
`BuyPrice` = '3400',
`SellPrice` = '1700',
`armor` = '1125',
`StatsCount` = '4',
`stat_type1` = '30',
`stat_value1` = '-188',
`stat_type2` = '3',
`stat_value2` = '-5',
`stat_type3` = '35',
`stat_value3` = '29',
`stat_type4` = '29',
`stat_value4` = '-188'
 
WHERE `item_template`.`class` =4 AND `subclass` =3 AND `Quality` =0 AND `InventoryType` = 1;
 
/* Primitivne */
 
UPDATE `item_template` SET 
 
`BuyPrice` = '3600',
`SellPrice` = '1800',
`armor` = '1200',
`StatsCount` = '4',
`stat_type1` = '30',
`stat_value1` = '-188',
`stat_type2` = '3',
`stat_value2` = '-5',
`stat_type3` = '35',
`stat_value3` = '29',
`stat_type4` = '29',
`stat_value4` = '-188'
 
WHERE `item_template`.`class` =4 AND `subclass` =3 AND `Quality` =1 AND `InventoryType` = 1;
 
/* Kvalitne */
UPDATE `item_template` SET 
 
`BuyPrice` = '4500',
`SellPrice` = '2250',
`armor` = '1500',
`StatsCount` = '4',
`stat_type1` = '30',
`stat_value1` = '-188',
`stat_type2` = '3',
`stat_value2` = '-5',
`stat_type3` = '35',
`stat_value3` = '29',
`stat_type4` = '29',
`stat_value4` = '-188'
 
WHERE `item_template`.`class` =4 AND `subclass` =3 AND `Quality` =2 AND `InventoryType` = 1;
 
/* Vzacne */
UPDATE `item_template` SET 
 
`BuyPrice` = '5600',
`SellPrice` = '2550',
`armor` = '1875',
`StatsCount` = '4',
`stat_type1` = '30',
`stat_value1` = '-188',
`stat_type2` = '3',
`stat_value2` = '-5',
`stat_type3` = '35',
`stat_value3` = '29',
`stat_type4` = '29',
`stat_value4` = '-188'
 
WHERE `item_template`.`class` =4 AND `subclass` =3 AND `Quality` =3 AND `InventoryType` = 1;
 
/* Magicke */
UPDATE `item_template` SET 
 
`BuyPrice` = '4500',
`SellPrice` = '2250',
`armor` = '1500',
`StatsCount` = '4',
`stat_type1` = '30',
`stat_value1` = '-188',
`stat_type2` = '3',
`stat_value2` = '-5',
`stat_type3` = '35',
`stat_value3` = '29',
`stat_type4` = '29',
`stat_value4` = '-188'
 
WHERE `item_template`.`class` =4 AND `subclass` =3 AND `Quality` =4 AND `InventoryType` = 1;
 
/* Legendarne */
UPDATE `item_template` SET 
 
`BuyPrice` = '6750',
`SellPrice` = '3375',
`armor` = '2250',
`StatsCount` = '4',
`stat_type1` = '30',
`stat_value1` = '-188',
`stat_type2` = '3',
`stat_value2` = '-5',
`stat_type3` = '35',
`stat_value3` = '29',
`stat_type4` = '29',
`stat_value4` = '-188'
 
WHERE `item_template`.`class` =4 AND `subclass` =3 AND `Quality` =5 AND `InventoryType` = 1;
 
/* Artefakty */
UPDATE `item_template` SET 
 
`BuyPrice` = '4500',
`SellPrice` = '2250',
`armor` = '1500',
`StatsCount` = '4',
`stat_type1` = '30',
`stat_value1` = '-188',
`stat_type2` = '3',
`stat_value2` = '-5',
`stat_type3` = '35',
`stat_value3` = '29',
`stat_type4` = '29',
`stat_value4` = '-188'
 
WHERE `item_template`.`class` =4 AND `subclass` =3 AND `Quality` =6 AND `InventoryType` = 1;
 
 
/* ----------------------------------------- */
 
/* LEGS */
 
/* Opotrebovane */
UPDATE `item_template` SET 
 
`BuyPrice` = '6750',
`SellPrice` = '3375',
`armor` = '2250',
`StatsCount` = '4',
`stat_type1` = '30',
`stat_value1` = '-188',
`stat_type2` = '3',
`stat_value2` = '-5',
`stat_type3` = '35',
`stat_value3` = '29',
`stat_type4` = '29',
`stat_value4` = '-188'
 
WHERE `item_template`.`class` =4 AND `subclass` =3 AND `Quality` =0 AND `InventoryType` = 7;
 
/* Primitivne */
 
UPDATE `item_template` SET 
 
`BuyPrice` = '7200',
`SellPrice` = '3600',
`armor` = '2400',
`StatsCount` = '4',
`stat_type1` = '30',
`stat_value1` = '-188',
`stat_type2` = '3',
`stat_value2` = '-5',
`stat_type3` = '35',
`stat_value3` = '29',
`stat_type4` = '29',
`stat_value4` = '-188'
 
WHERE `item_template`.`class` =4 AND `subclass` =3 AND `Quality` =1 AND `InventoryType` = 7;
 
/* Kvalitne */
UPDATE `item_template` SET 
 
`BuyPrice` = '9000',
`SellPrice` = '4500',
`armor` = '3000',
`StatsCount` = '4',
`stat_type1` = '30',
`stat_value1` = '-188',
`stat_type2` = '3',
`stat_value2` = '-5',
`stat_type3` = '35',
`stat_value3` = '29',
`stat_type4` = '29',
`stat_value4` = '-188'
 
WHERE `item_template`.`class` =4 AND `subclass` =3 AND `Quality` =2 AND `InventoryType` = 7;
 
/* Vzacne */
UPDATE `item_template` SET 
 
`BuyPrice` = '11250',
`SellPrice` = '5600',
`armor` = '3750',
`StatsCount` = '4',
`stat_type1` = '30',
`stat_value1` = '-188',
`stat_type2` = '3',
`stat_value2` = '-5',
`stat_type3` = '35',
`stat_value3` = '29',
`stat_type4` = '29',
`stat_value4` = '-188'
 
WHERE `item_template`.`class` =4 AND `subclass` =3 AND `Quality` =3 AND `InventoryType` = 7;
 
/* Magicke */
UPDATE `item_template` SET 
 
`BuyPrice` = '9000',
`SellPrice` = '4500',
`armor` = '3000',
`StatsCount` = '4',
`stat_type1` = '30',
`stat_value1` = '-188',
`stat_type2` = '3',
`stat_value2` = '-5',
`stat_type3` = '35',
`stat_value3` = '29',
`stat_type4` = '29',
`stat_value4` = '-188'
 
WHERE `item_template`.`class` =4 AND `subclass` =3 AND `Quality` =4 AND `InventoryType` = 7;
 
/* Legendarne */
UPDATE `item_template` SET 
 
`BuyPrice` = '13500',
`SellPrice` = '6750',
`armor` = '4500',
`StatsCount` = '4',
`stat_type1` = '30',
`stat_value1` = '-188',
`stat_type2` = '3',
`stat_value2` = '-5',
`stat_type3` = '35',
`stat_value3` = '29',
`stat_type4` = '29',
`stat_value4` = '-188'
 
WHERE `item_template`.`class` =4 AND `subclass` =3 AND `Quality` =5 AND `InventoryType` = 7;
 
/* Artefakty */
UPDATE `item_template` SET 
 
`BuyPrice` = '9000',
`SellPrice` = '4500',
`armor` = '3000',
`StatsCount` = '4',
`stat_type1` = '30',
`stat_value1` = '-188',
`stat_type2` = '3',
`stat_value2` = '-5',
`stat_type3` = '35',
`stat_value3` = '29',
`stat_type4` = '29',
`stat_value4` = '-188'
 
WHERE `item_template`.`class` =4 AND `subclass` =3 AND `Quality` =6 AND `InventoryType` = 7;
 
/* -------------------------- */
 
 
/* SHOULDERS */
 
/* Opotrebovane */
UPDATE `item_template` SET 
 
`BuyPrice` = '3400',
`SellPrice` = '1700',
`armor` = '1125',
`StatsCount` = '4',
`stat_type1` = '30',
`stat_value1` = '-188',
`stat_type2` = '3',
`stat_value2` = '-5',
`stat_type3` = '35',
`stat_value3` = '29',
`stat_type4` = '29',
`stat_value4` = '-188'
 
WHERE `item_template`.`class` =4 AND `subclass` =3 AND `Quality` =0 AND `InventoryType` = 3;
 
/* Primitivne */
 
UPDATE `item_template` SET 
 
`BuyPrice` = '3600',
`SellPrice` = '1800',
`armor` = '1200',
`StatsCount` = '4',
`stat_type1` = '30',
`stat_value1` = '-188',
`stat_type2` = '3',
`stat_value2` = '-5',
`stat_type3` = '35',
`stat_value3` = '29',
`stat_type4` = '29',
`stat_value4` = '-188'
 
WHERE `item_template`.`class` =4 AND `subclass` =3 AND `Quality` =1 AND `InventoryType` = 3;
 
/* Kvalitne */
UPDATE `item_template` SET 
 
`BuyPrice` = '4500',
`SellPrice` = '2250',
`armor` = '1500',
`StatsCount` = '4',
`stat_type1` = '30',
`stat_value1` = '-188',
`stat_type2` = '3',
`stat_value2` = '-5',
`stat_type3` = '35',
`stat_value3` = '29',
`stat_type4` = '29',
`stat_value4` = '-188'
 
WHERE `item_template`.`class` =4 AND `subclass` =3 AND `Quality` =2 AND `InventoryType` = 3;
 
/* Vzacne */
UPDATE `item_template` SET 
 
`BuyPrice` = '5600',
`SellPrice` = '2550',
`armor` = '1875',
`StatsCount` = '4',
`stat_type1` = '30',
`stat_value1` = '-188',
`stat_type2` = '3',
`stat_value2` = '-5',
`stat_type3` = '35',
`stat_value3` = '29',
`stat_type4` = '29',
`stat_value4` = '-188'
 
WHERE `item_template`.`class` =4 AND `subclass` =3 AND `Quality` =3 AND `InventoryType` = 3;
 
/* Magicke */
UPDATE `item_template` SET 
 
`BuyPrice` = '4500',
`SellPrice` = '2250',
`armor` = '1500',
`StatsCount` = '4',
`stat_type1` = '30',
`stat_value1` = '-188',
`stat_type2` = '3',
`stat_value2` = '-5',
`stat_type3` = '35',
`stat_value3` = '29',
`stat_type4` = '29',
`stat_value4` = '-188'
 
WHERE `item_template`.`class` =4 AND `subclass` =3 AND `Quality` =4 AND `InventoryType` = 3;
 
/* Legendarne */
UPDATE `item_template` SET 
 
`BuyPrice` = '6750',
`SellPrice` = '3375',
`armor` = '2250',
`StatsCount` = '4',
`stat_type1` = '30',
`stat_value1` = '-188',
`stat_type2` = '3',
`stat_value2` = '-5',
`stat_type3` = '35',
`stat_value3` = '29',
`stat_type4` = '29',
`stat_value4` = '-188'
 
WHERE `item_template`.`class` =4 AND `subclass` =3 AND `Quality` =5 AND `InventoryType` = 3;
 
/* Artefakty */
UPDATE `item_template` SET 
 
`BuyPrice` = '4500',
`SellPrice` = '2250',
`armor` = '1500',
`StatsCount` = '4',
`stat_type1` = '30',
`stat_value1` = '-188',
`stat_type2` = '3',
`stat_value2` = '-5',
`stat_type3` = '35',
`stat_value3` = '29',
`stat_type4` = '29',
`stat_value4` = '-188'
 
WHERE `item_template`.`class` =4 AND `subclass` =3 AND `Quality` =6 AND `InventoryType` = 3;
 
/* ------------------- */
 
/* WAIST */
 
/* Opotrebovane */
UPDATE `item_template` SET 
 
`BuyPrice` = '1700',
`SellPrice` = '850',
`armor` = '560',
`StatsCount` = '4',
`stat_type1` = '30',
`stat_value1` = '-188',
`stat_type2` = '3',
`stat_value2` = '-5',
`stat_type3` = '35',
`stat_value3` = '29',
`stat_type4` = '29',
`stat_value4` = '-188'
 
WHERE `item_template`.`class` =4 AND `subclass` =3 AND `Quality` =0 AND `InventoryType` = 6;
 
/* Primitivne */
 
UPDATE `item_template` SET 
 
`BuyPrice` = '1800',
`SellPrice` = '900',
`armor` = '600',
`StatsCount` = '4',
`stat_type1` = '30',
`stat_value1` = '-188',
`stat_type2` = '3',
`stat_value2` = '-5',
`stat_type3` = '35',
`stat_value3` = '29',
`stat_type4` = '29',
`stat_value4` = '-188'
 
WHERE `item_template`.`class` =4 AND `subclass` =3 AND `Quality` =1 AND `InventoryType` = 6;
 
/* Kvalitne */
UPDATE `item_template` SET 
 
`BuyPrice` = '2250',
`SellPrice` = '1125',
`armor` = '750',
`StatsCount` = '4',
`stat_type1` = '30',
`stat_value1` = '-188',
`stat_type2` = '3',
`stat_value2` = '-5',
`stat_type3` = '35',
`stat_value3` = '29',
`stat_type4` = '29',
`stat_value4` = '-188'
 
WHERE `item_template`.`class` =4 AND `subclass` =3 AND `Quality` =2 AND `InventoryType` = 6;
 
/* Vzacne */
UPDATE `item_template` SET 
 
`BuyPrice` = '2800',
`SellPrice` = '1400',
`armor` = '940',
`StatsCount` = '4',
`stat_type1` = '30',
`stat_value1` = '-188',
`stat_type2` = '3',
`stat_value2` = '-5',
`stat_type3` = '35',
`stat_value3` = '29',
`stat_type4` = '29',
`stat_value4` = '-188'
 
WHERE `item_template`.`class` =4 AND `subclass` =3 AND `Quality` =3 AND `InventoryType` = 6;
 
/* Magicke */
UPDATE `item_template` SET 
 
`BuyPrice` = '2250',
`SellPrice` = '1125',
`armor` = '750',
`StatsCount` = '4',
`stat_type1` = '30',
`stat_value1` = '-188',
`stat_type2` = '3',
`stat_value2` = '-5',
`stat_type3` = '35',
`stat_value3` = '29',
`stat_type4` = '29',
`stat_value4` = '-188'
 
WHERE `item_template`.`class` =4 AND `subclass` =3 AND `Quality` =4 AND `InventoryType` = 6;
 
/* Legendarne */
UPDATE `item_template` SET 
 
`BuyPrice` = '3400',
`SellPrice` = '1700',
`armor` = '1125',
`StatsCount` = '4',
`stat_type1` = '30',
`stat_value1` = '-188',
`stat_type2` = '3',
`stat_value2` = '-5',
`stat_type3` = '35',
`stat_value3` = '29',
`stat_type4` = '29',
`stat_value4` = '-188'
 
WHERE `item_template`.`class` =4 AND `subclass` =3 AND `Quality` =5 AND `InventoryType` = 6;
 
/* Artefakty */
UPDATE `item_template` SET 
 
`BuyPrice` = '2250',
`SellPrice` = '1125',
`armor` = '750',
`StatsCount` = '4',
`stat_type1` = '30',
`stat_value1` = '-188',
`stat_type2` = '3',
`stat_value2` = '-5',
`stat_type3` = '35',
`stat_value3` = '29',
`stat_type4` = '29',
`stat_value4` = '-188'
 
WHERE `item_template`.`class` =4 AND `subclass` =3 AND `Quality` =6 AND `InventoryType` = 6;
 
/* -------------------------- */
 
 
/* WRIST */
 
/* Opotrebovane */
UPDATE `item_template` SET 
 
`BuyPrice` = '1700',
`SellPrice` = '850',
`armor` = '560',
`StatsCount` = '4',
`stat_type1` = '30',
`stat_value1` = '-188',
`stat_type2` = '3',
`stat_value2` = '-5',
`stat_type3` = '35',
`stat_value3` = '29',
`stat_type4` = '29',
`stat_value4` = '-188'
 
WHERE `item_template`.`class` =4 AND `subclass` =3 AND `Quality` =0 AND `InventoryType` = 9;
 
/* Primitivne */
 
UPDATE `item_template` SET 
 
`BuyPrice` = '1800',
`SellPrice` = '900',
`armor` = '600',
`StatsCount` = '4',
`stat_type1` = '30',
`stat_value1` = '-188',
`stat_type2` = '3',
`stat_value2` = '-5',
`stat_type3` = '35',
`stat_value3` = '29',
`stat_type4` = '29',
`stat_value4` = '-188'
 
WHERE `item_template`.`class` =4 AND `subclass` =3 AND `Quality` =1 AND `InventoryType` = 9;
 
/* Kvalitne */
UPDATE `item_template` SET 
 
`BuyPrice` = '2250',
`SellPrice` = '1125',
`armor` = '750',
`StatsCount` = '4',
`stat_type1` = '30',
`stat_value1` = '-188',
`stat_type2` = '3',
`stat_value2` = '-5',
`stat_type3` = '35',
`stat_value3` = '29',
`stat_type4` = '29',
`stat_value4` = '-188'
 
WHERE `item_template`.`class` =4 AND `subclass` =3 AND `Quality` =2 AND `InventoryType` = 9;
 
/* Vzacne */
UPDATE `item_template` SET 
 
`BuyPrice` = '2800',
`SellPrice` = '1400',
`armor` = '940',
`StatsCount` = '4',
`stat_type1` = '30',
`stat_value1` = '-188',
`stat_type2` = '3',
`stat_value2` = '-5',
`stat_type3` = '35',
`stat_value3` = '29',
`stat_type4` = '29',
`stat_value4` = '-188'
 
WHERE `item_template`.`class` =4 AND `subclass` =3 AND `Quality` =3 AND `InventoryType` = 9;
 
/* Magicke */
UPDATE `item_template` SET 
 
`BuyPrice` = '2250',
`SellPrice` = '1125',
`armor` = '750',
`StatsCount` = '4',
`stat_type1` = '30',
`stat_value1` = '-188',
`stat_type2` = '3',
`stat_value2` = '-5',
`stat_type3` = '35',
`stat_value3` = '29',
`stat_type4` = '29',
`stat_value4` = '-188'
 
WHERE `item_template`.`class` =4 AND `subclass` =3 AND `Quality` =4 AND `InventoryType` = 9;
 
/* Legendarne */
UPDATE `item_template` SET 
 
`BuyPrice` = '3400',
`SellPrice` = '1700',
`armor` = '1125',
`StatsCount` = '4',
`stat_type1` = '30',
`stat_value1` = '-188',
`stat_type2` = '3',
`stat_value2` = '-5',
`stat_type3` = '35',
`stat_value3` = '29',
`stat_type4` = '29',
`stat_value4` = '-188'
 
WHERE `item_template`.`class` =4 AND `subclass` =3 AND `Quality` =5 AND `InventoryType` = 9;
 
/* Artefakty */
UPDATE `item_template` SET 
 
`BuyPrice` = '2250',
`SellPrice` = '1125',
`armor` = '750',
`StatsCount` = '4',
`stat_type1` = '30',
`stat_value1` = '-188',
`stat_type2` = '3',
`stat_value2` = '-5',
`stat_type3` = '35',
`stat_value3` = '29',
`stat_type4` = '29',
`stat_value4` = '-188'
WHERE `item_template`.`class` =4 AND `subclass` =3 AND `Quality` =6 AND `InventoryType` = 9;
 
/* -------------------------- */

Mail

PLATE

Drahé a ťažké, no trvácne a bezpečné. Trvanlivosť 75-150. Redukcia rýchlosti (MANGOS) porovnateľná s chôdzou. To sa netýka mountov.

Mať ťažkú zbroj a meč znamená “byť niekto“.

SQL kod

SQL kód

 
/* PLATE */
/* CHEST */
 
/* Opotrebovane */
UPDATE `item_template` SET 
 
`BuyPrice` = '11250',
`SellPrice` = '5625',
`armor` = '3750',
`StatsCount` = '4',
`stat_type1` = '30',
`stat_value1` = '-375',
`stat_type2` = '3',
`stat_value2` = '-10',
`stat_type3` = '35',
`stat_value3` = '39',
`stat_type4` = '29',
`stat_value4` = '-375'
 
WHERE `item_template`.`class` =4 AND `subclass` =4 AND `Quality` =0 AND `InventoryType` = 5;
 
/* Primitivne */
 
UPDATE `item_template` SET 
 
`BuyPrice` = '12000',
`SellPrice` = '6000',
`armor` = '4000',
`StatsCount` = '4',
`stat_type1` = '30',
`stat_value1` = '-375',
`stat_type2` = '3',
`stat_value2` = '-10',
`stat_type3` = '35',
`stat_value3` = '39',
`stat_type4` = '29',
`stat_value4` = '-375'
 
WHERE `item_template`.`class` =4 AND `subclass` =4 AND `Quality` =1 AND `InventoryType` = 5;
 
/* Kvalitne */
UPDATE `item_template` SET 
 
`BuyPrice` = '15000',
`SellPrice` = '7500',
`armor` = '5000',
`StatsCount` = '4',
`stat_type1` = '30',
`stat_value1` = '-375',
`stat_type2` = '3',
`stat_value2` = '-10',
`stat_type3` = '35',
`stat_value3` = '39',
`stat_type4` = '29',
`stat_value4` = '-375'
 
WHERE `item_template`.`class` =4 AND `subclass` =4 AND `Quality` =2 AND `InventoryType` = 5;
 
/* Vzacne */
UPDATE `item_template` SET 
 
`BuyPrice` = '18750',
`SellPrice` = '9375',
`armor` = '6250',
`StatsCount` = '4',
`stat_type1` = '30',
`stat_value1` = '-375',
`stat_type2` = '3',
`stat_value2` = '-10',
`stat_type3` = '35',
`stat_value3` = '39',
`stat_type4` = '29',
`stat_value4` = '-375'
 
WHERE `item_template`.`class` =4 AND `subclass` =4 AND `Quality` =3 AND `InventoryType` = 5;
 
/* Magicke */
UPDATE `item_template` SET 
 
`BuyPrice` = '15000',
`SellPrice` = '7500',
`armor` = '5000',
`StatsCount` = '4',
`stat_type1` = '30',
`stat_value1` = '-375',
`stat_type2` = '3',
`stat_value2` = '-10',
`stat_type3` = '35',
`stat_value3` = '39',
`stat_type4` = '29',
`stat_value4` = '-375'
WHERE `item_template`.`class` =4 AND `subclass` =4 AND `Quality` =4 AND `InventoryType` = 5;
 
/* Legendarne */
UPDATE `item_template` SET 
 
`BuyPrice` = '22500',
`SellPrice` = '11250',
`armor` = '7500',
`StatsCount` = '4',
`stat_type1` = '30',
`stat_value1` = '-375',
`stat_type2` = '3',
`stat_value2` = '-10',
`stat_type3` = '35',
`stat_value3` = '39',
`stat_type4` = '29',
`stat_value4` = '-375'
 
WHERE `item_template`.`class` =4 AND `subclass` =4 AND `Quality` =5 AND `InventoryType` = 5;
 
/* Artefakty */
UPDATE `item_template` SET 
 
`BuyPrice` = '15000',
`SellPrice` = '7500',
`armor` = '5000',
`StatsCount` = '4',
`stat_type1` = '30',
`stat_value1` = '-375',
`stat_type2` = '3',
`stat_value2` = '-10',
`stat_type3` = '35',
`stat_value3` = '39',
`stat_type4` = '29',
`stat_value4` = '-375'
 
WHERE `item_template`.`class` =4 AND `subclass` =4 AND `Quality` =6 AND `InventoryType` = 5;
 
 
/* ********************************** */
 
/* FEET */
 
/* Opotrebovane */
UPDATE `item_template` SET 
 
`BuyPrice` = '5600',
`SellPrice` = '2800',
`armor` = '1900',
`StatsCount` = '4',
`stat_type1` = '30',
`stat_value1` = '-375',
`stat_type2` = '3',
`stat_value2` = '-10',
`stat_type3` = '35',
`stat_value3` = '39',
`stat_type4` = '29',
`stat_value4` = '-375'
 
WHERE `item_template`.`class` =4 AND `subclass` =4 AND `Quality` =0 AND `InventoryType` = 8;
 
/* Primitivne */
 
UPDATE `item_template` SET 
 
`BuyPrice` = '6000',
`SellPrice` = '3000',
`armor` = '2000',
`StatsCount` = '4',
`stat_type1` = '30',
`stat_value1` = '-375',
`stat_type2` = '3',
`stat_value2` = '-10',
`stat_type3` = '35',
`stat_value3` = '39',
`stat_type4` = '29',
`stat_value4` = '-375'
 
WHERE `item_template`.`class` =4 AND `subclass` =4 AND `Quality` =1 AND `InventoryType` = 8;
 
/* Kvalitne */
UPDATE `item_template` SET 
 
`BuyPrice` = '7500',
`SellPrice` = '3750',
`armor` = '2500',
`StatsCount` = '4',
`stat_type1` = '30',
`stat_value1` = '-375',
`stat_type2` = '3',
`stat_value2` = '-10',
`stat_type3` = '35',
`stat_value3` = '39',
`stat_type4` = '29',
`stat_value4` = '-375'
 
WHERE `item_template`.`class` =4 AND `subclass` =4 AND `Quality` =2 AND `InventoryType` = 8;
 
/* Vzacne */
UPDATE `item_template` SET 
 
`BuyPrice` = '9400',
`SellPrice` = '4700',
`armor` = '3100',
`StatsCount` = '4',
`stat_type1` = '30',
`stat_value1` = '-375',
`stat_type2` = '3',
`stat_value2` = '-10',
`stat_type3` = '35',
`stat_value3` = '39',
`stat_type4` = '29',
`stat_value4` = '-375'
 
WHERE `item_template`.`class` =4 AND `subclass` =4 AND `Quality` =3 AND `InventoryType` = 8;
 
/* Magicke */
UPDATE `item_template` SET 
 
`BuyPrice` = '7500',
`SellPrice` = '3750',
`armor` = '2500',
`StatsCount` = '4',
`stat_type1` = '30',
`stat_value1` = '-375',
`stat_type2` = '3',
`stat_value2` = '-10',
`stat_type3` = '35',
`stat_value3` = '39',
`stat_type4` = '29',
`stat_value4` = '-375'
 
WHERE `item_template`.`class` =4 AND `subclass` =4 AND `Quality` =4 AND `InventoryType` = 8;
 
/* Legendarne */
UPDATE `item_template` SET 
 
`BuyPrice` = '6000',
`SellPrice` = '3000',
`armor` = '3750',
`StatsCount` = '4',
`stat_type1` = '30',
`stat_value1` = '-375',
`stat_type2` = '3',
`stat_value2` = '-10',
`stat_type3` = '35',
`stat_value3` = '39',
`stat_type4` = '29',
`stat_value4` = '-375'
 
WHERE `item_template`.`class` =4 AND `subclass` =4 AND `Quality` =5 AND `InventoryType` = 8;
 
/* Artefakty */
UPDATE `item_template` SET 
 
`BuyPrice` = '5600',
`SellPrice` = '2550',
`armor` = '2500',
`StatsCount` = '4',
`stat_type1` = '30',
`stat_value1` = '-375',
`stat_type2` = '3',
`stat_value2` = '-10',
`stat_type3` = '35',
`stat_value3` = '39',
`stat_type4` = '29',
`stat_value4` = '-375'
 
WHERE `item_template`.`class` =4 AND `subclass` =4 AND `Quality` =6 AND `InventoryType` = 8;
 
 
/* ********************************** */
 
/* HANDS */
 
/* Opotrebovane */
UPDATE `item_template` SET 
 
`BuyPrice` = '2800',
`SellPrice` = '1400',
`armor` = '940',
`StatsCount` = '4',
`stat_type1` = '30',
`stat_value1` = '-375',
`stat_type2` = '3',
`stat_value2` = '-10',
`stat_type3` = '35',
`stat_value3` = '39',
`stat_type4` = '29',
`stat_value4` = '-375'
 
WHERE `item_template`.`class` =4 AND `subclass` =4 AND `Quality` =0 AND `InventoryType` = 10;
 
/* Primitivne */
 
UPDATE `item_template` SET 
 
`BuyPrice` = '3000',
`SellPrice` = '1500',
`armor` = '1000',
`StatsCount` = '4',
`stat_type1` = '30',
`stat_value1` = '-375',
`stat_type2` = '3',
`stat_value2` = '-10',
`stat_type3` = '35',
`stat_value3` = '39',
`stat_type4` = '29',
`stat_value4` = '-375'
 
WHERE `item_template`.`class` =4 AND `subclass` =4 AND `Quality` =1 AND `InventoryType` = 10;
 
/* Kvalitne */
UPDATE `item_template` SET 
 
`BuyPrice` = '3750',
`SellPrice` = '1875',
`armor` = '1250',
`StatsCount` = '4',
`stat_type1` = '30',
`stat_value1` = '-375',
`stat_type2` = '3',
`stat_value2` = '-10',
`stat_type3` = '35',
`stat_value3` = '39',
`stat_type4` = '29',
`stat_value4` = '-375'
 
WHERE `item_template`.`class` =4 AND `subclass` =4 AND `Quality` =2 AND `InventoryType` = 10;
 
/* Vzacne */
UPDATE `item_template` SET 
 
`BuyPrice` = '4700',
`SellPrice` = '2350',
`armor` = '1600',
`StatsCount` = '4',
`stat_type1` = '30',
`stat_value1` = '-375',
`stat_type2` = '3',
`stat_value2` = '-10',
`stat_type3` = '35',
`stat_value3` = '39',
`stat_type4` = '29',
`stat_value4` = '-375'
 
WHERE `item_template`.`class` =4 AND `subclass` =4 AND `Quality` =3 AND `InventoryType` = 10;
 
/* Magicke */
UPDATE `item_template` SET 
 
`BuyPrice` = '3750',
`SellPrice` = '1875',
`armor` = '1250',
`StatsCount` = '4',
`stat_type1` = '30',
`stat_value1` = '-375',
`stat_type2` = '3',
`stat_value2` = '-10',
`stat_type3` = '35',
`stat_value3` = '39',
`stat_type4` = '29',
`stat_value4` = '-375'
 
WHERE `item_template`.`class` =4 AND `subclass` =4 AND `Quality` =4 AND `InventoryType` = 10;
 
/* Legendarne */
UPDATE `item_template` SET 
 
`BuyPrice` = '5600',
`SellPrice` = '2550',
`armor` = '1900',
`StatsCount` = '4',
`stat_type1` = '30',
`stat_value1` = '-375',
`stat_type2` = '3',
`stat_value2` = '-10',
`stat_type3` = '35',
`stat_value3` = '39',
`stat_type4` = '29',
`stat_value4` = '-375'
 
WHERE `item_template`.`class` =4 AND `subclass` =4 AND `Quality` =5 AND `InventoryType` = 10;
 
/* Artefakty */
UPDATE `item_template` SET 
 
`BuyPrice` = '3750',
`SellPrice` = '1875',
`armor` = '1250',
`StatsCount` = '4',
`stat_type1` = '30',
`stat_value1` = '-375',
`stat_type2` = '3',
`stat_value2` = '-10',
`stat_type3` = '35',
`stat_value3` = '39',
`stat_type4` = '29',
`stat_value4` = '-375'
 
WHERE `item_template`.`class` =4 AND `subclass` =4 AND `Quality` =6 AND `InventoryType` = 10;
 
 
/* -------------------------- */
 
 
/* HEAD */
 
/* Opotrebovane */
UPDATE `item_template` SET 
 
`BuyPrice` = '5600',
`SellPrice` = '2800',
`armor` = '1900',
`StatsCount` = '4',
`stat_type1` = '30',
`stat_value1` = '-375',
`stat_type2` = '3',
`stat_value2` = '-10',
`stat_type3` = '35',
`stat_value3` = '39',
`stat_type4` = '29',
`stat_value4` = '-375'
 
WHERE `item_template`.`class` =4 AND `subclass` =4 AND `Quality` =0 AND `InventoryType` = 1;
 
/* Primitivne */
 
UPDATE `item_template` SET 
 
`BuyPrice` = '6000',
`SellPrice` = '3000',
`armor` = '2000',
`StatsCount` = '4',
`stat_type1` = '30',
`stat_value1` = '-375',
`stat_type2` = '3',
`stat_value2` = '-10',
`stat_type3` = '35',
`stat_value3` = '39',
`stat_type4` = '29',
`stat_value4` = '-375'
 
WHERE `item_template`.`class` =4 AND `subclass` =4 AND `Quality` =1 AND `InventoryType` = 1;
 
/* Kvalitne */
UPDATE `item_template` SET 
 
`BuyPrice` = '7500',
`SellPrice` = '3750',
`armor` = '2500',
`StatsCount` = '4',
`stat_type1` = '30',
`stat_value1` = '-375',
`stat_type2` = '3',
`stat_value2` = '-10',
`stat_type3` = '35',
`stat_value3` = '39',
`stat_type4` = '29',
`stat_value4` = '-375'
 
WHERE `item_template`.`class` =4 AND `subclass` =4 AND `Quality` =2 AND `InventoryType` = 1;
 
/* Vzacne */
UPDATE `item_template` SET 
 
`BuyPrice` = '9400',
`SellPrice` = '4700',
`armor` = '3100',
`StatsCount` = '4',
`stat_type1` = '30',
`stat_value1` = '-375',
`stat_type2` = '3',
`stat_value2` = '-10',
`stat_type3` = '35',
`stat_value3` = '39',
`stat_type4` = '29',
`stat_value4` = '-375'
 
WHERE `item_template`.`class` =4 AND `subclass` =4 AND `Quality` =3 AND `InventoryType` = 1;
 
/* Magicke */
UPDATE `item_template` SET 
 
`BuyPrice` = '7500',
`SellPrice` = '3750',
`armor` = '2500',
`StatsCount` = '4',
`stat_type1` = '30',
`stat_value1` = '-375',
`stat_type2` = '3',
`stat_value2` = '-10',
`stat_type3` = '35',
`stat_value3` = '39',
`stat_type4` = '29',
`stat_value4` = '-375'
 
WHERE `item_template`.`class` =4 AND `subclass` =4 AND `Quality` =4 AND `InventoryType` = 1;
 
/* Legendarne */
UPDATE `item_template` SET 
 
`BuyPrice` = '6000',
`SellPrice` = '3000',
`armor` = '3750',
`StatsCount` = '4',
`stat_type1` = '30',
`stat_value1` = '-375',
`stat_type2` = '3',
`stat_value2` = '-10',
`stat_type3` = '35',
`stat_value3` = '39',
`stat_type4` = '29',
`stat_value4` = '-375'
 
WHERE `item_template`.`class` =4 AND `subclass` =4 AND `Quality` =5 AND `InventoryType` = 1;
 
/* Artefakty */
UPDATE `item_template` SET 
 
`BuyPrice` = '5600',
`SellPrice` = '2550',
`armor` = '2500',
`StatsCount` = '4',
`stat_type1` = '30',
`stat_value1` = '-375',
`stat_type2` = '3',
`stat_value2` = '-10',
`stat_type3` = '35',
`stat_value3` = '39',
`stat_type4` = '29',
`stat_value4` = '-375'
 
WHERE `item_template`.`class` =4 AND `subclass` =4 AND `Quality` =6 AND `InventoryType` = 1;
 
/* ----------------------------------------- */
 
/* LEGS */
 
/* Opotrebovane */
UPDATE `item_template` SET 
 
`BuyPrice` = '11250',
`SellPrice` = '5625',
`armor` = '3750',
`StatsCount` = '4',
`stat_type1` = '30',
`stat_value1` = '-375',
`stat_type2` = '3',
`stat_value2` = '-10',
`stat_type3` = '35',
`stat_value3` = '39',
`stat_type4` = '29',
`stat_value4` = '-375'
 
WHERE `item_template`.`class` =4 AND `subclass` =4 AND `Quality` =0 AND `InventoryType` = 7;
 
/* Primitivne */
 
UPDATE `item_template` SET 
 
`BuyPrice` = '12000',
`SellPrice` = '6000',
`armor` = '4000',
`StatsCount` = '4',
`stat_type1` = '30',
`stat_value1` = '-375',
`stat_type2` = '3',
`stat_value2` = '-10',
`stat_type3` = '35',
`stat_value3` = '39',
`stat_type4` = '29',
`stat_value4` = '-375'
 
WHERE `item_template`.`class` =4 AND `subclass` =4 AND `Quality` =1 AND `InventoryType` = 7;
 
/* Kvalitne */
UPDATE `item_template` SET 
 
`BuyPrice` = '15000',
`SellPrice` = '7500',
`armor` = '5000',
`StatsCount` = '4',
`stat_type1` = '30',
`stat_value1` = '-375',
`stat_type2` = '3',
`stat_value2` = '-10',
`stat_type3` = '35',
`stat_value3` = '39',
`stat_type4` = '29',
`stat_value4` = '-375'
 
WHERE `item_template`.`class` =4 AND `subclass` =4 AND `Quality` =2 AND `InventoryType` = 7;
 
/* Vzacne */
UPDATE `item_template` SET 
 
`BuyPrice` = '18750',
`SellPrice` = '9375',
`armor` = '6250',
`StatsCount` = '4',
`stat_type1` = '30',
`stat_value1` = '-375',
`stat_type2` = '3',
`stat_value2` = '-10',
`stat_type3` = '35',
`stat_value3` = '39',
`stat_type4` = '29',
`stat_value4` = '-375'
WHERE `item_template`.`class` =4 AND `subclass` =4 AND `Quality` =3 AND `InventoryType` = 7;
 
/* Magicke */
UPDATE `item_template` SET 
 
`BuyPrice` = '15000',
`SellPrice` = '7500',
`armor` = '5000',
`StatsCount` = '4',
`stat_type1` = '30',
`stat_value1` = '-375',
`stat_type2` = '3',
`stat_value2` = '-10',
`stat_type3` = '35',
`stat_value3` = '39',
`stat_type4` = '29',
`stat_value4` = '-375'
 
WHERE `item_template`.`class` =4 AND `subclass` =4 AND `Quality` =4 AND `InventoryType` = 7;
 
/* Legendarne */
UPDATE `item_template` SET 
 
`BuyPrice` = '22500',
`SellPrice` = '11250',
`armor` = '7500',
`StatsCount` = '4',
`stat_type1` = '30',
`stat_value1` = '-375',
`stat_type2` = '3',
`stat_value2` = '-10',
`stat_type3` = '35',
`stat_value3` = '39',
`stat_type4` = '29',
`stat_value4` = '-375'
 
WHERE `item_template`.`class` =4 AND `subclass` =4 AND `Quality` =5 AND `InventoryType` = 7;
 
/* Artefakty */
UPDATE `item_template` SET 
 
`BuyPrice` = '15000',
`SellPrice` = '7500',
`armor` = '5000',
`StatsCount` = '4',
`stat_type1` = '30',
`stat_value1` = '-375',
`stat_type2` = '3',
`stat_value2` = '-10',
`stat_type3` = '35',
`stat_value3` = '39',
`stat_type4` = '29',
`stat_value4` = '-375'
 
WHERE `item_template`.`class` =4 AND `subclass` =4 AND `Quality` =6 AND `InventoryType` = 7;
 
/* -------------------------- */
 
 
/* SHOULDERS */
 
/* Opotrebovane */
UPDATE `item_template` SET 
 
`BuyPrice` = '5600',
`SellPrice` = '2800',
`armor` = '1900',
`StatsCount` = '4',
`stat_type1` = '30',
`stat_value1` = '-375',
`stat_type2` = '3',
`stat_value2` = '-10',
`stat_type3` = '35',
`stat_value3` = '39',
`stat_type4` = '29',
`stat_value4` = '-375'
 
WHERE `item_template`.`class` =4 AND `subclass` =4 AND `Quality` =0 AND `InventoryType` = 3;
 
/* Primitivne */
 
UPDATE `item_template` SET 
 
`BuyPrice` = '6000',
`SellPrice` = '3000',
`armor` = '2000',
`StatsCount` = '4',
`stat_type1` = '30',
`stat_value1` = '-375',
`stat_type2` = '3',
`stat_value2` = '-10',
`stat_type3` = '35',
`stat_value3` = '39',
`stat_type4` = '29',
`stat_value4` = '-375'
 
WHERE `item_template`.`class` =4 AND `subclass` =4 AND `Quality` =1 AND `InventoryType` = 3;
 
/* Kvalitne */
UPDATE `item_template` SET 
 
`BuyPrice` = '7500',
`SellPrice` = '3750',
`armor` = '2500',
`StatsCount` = '4',
`stat_type1` = '30',
`stat_value1` = '-375',
`stat_type2` = '3',
`stat_value2` = '-10',
`stat_type3` = '35',
`stat_value3` = '39',
`stat_type4` = '29',
`stat_value4` = '-375'
 
WHERE `item_template`.`class` =4 AND `subclass` =4 AND `Quality` =2 AND `InventoryType` = 3;
 
/* Vzacne */
UPDATE `item_template` SET 
 
`BuyPrice` = '9400',
`SellPrice` = '4700',
`armor` = '3100',
`StatsCount` = '4',
`stat_type1` = '30',
`stat_value1` = '-375',
`stat_type2` = '3',
`stat_value2` = '-10',
`stat_type3` = '35',
`stat_value3` = '39',
`stat_type4` = '29',
`stat_value4` = '-375'
 
WHERE `item_template`.`class` =4 AND `subclass` =4 AND `Quality` =3 AND `InventoryType` = 3;
 
/* Magicke */
UPDATE `item_template` SET 
 
`BuyPrice` = '7500',
`SellPrice` = '3750',
`armor` = '2500',
`StatsCount` = '4',
`stat_type1` = '30',
`stat_value1` = '-375',
`stat_type2` = '3',
`stat_value2` = '-10',
`stat_type3` = '35',
`stat_value3` = '39',
`stat_type4` = '29',
`stat_value4` = '-375'
 
WHERE `item_template`.`class` =4 AND `subclass` =4 AND `Quality` =4 AND `InventoryType` = 3;
 
/* Legendarne */
UPDATE `item_template` SET 
 
`BuyPrice` = '6000',
`SellPrice` = '3000',
`armor` = '3750',
`StatsCount` = '4',
`stat_type1` = '30',
`stat_value1` = '-375',
`stat_type2` = '3',
`stat_value2` = '-10',
`stat_type3` = '35',
`stat_value3` = '39',
`stat_type4` = '29',
`stat_value4` = '-375'
 
WHERE `item_template`.`class` =4 AND `subclass` =4 AND `Quality` =5 AND `InventoryType` = 3;
 
/* Artefakty */
UPDATE `item_template` SET 
 
`BuyPrice` = '5600',
`SellPrice` = '2550',
`armor` = '2500',
`StatsCount` = '4',
`stat_type1` = '30',
`stat_value1` = '-375',
`stat_type2` = '3',
`stat_value2` = '-10',
`stat_type3` = '35',
`stat_value3` = '39',
`stat_type4` = '29',
`stat_value4` = '-375'
 
WHERE `item_template`.`class` =4 AND `subclass` =4 AND `Quality` =6 AND `InventoryType` = 3;
 
/* ------------------------ */
 
/* WAIST */
 
/* Opotrebovane */
UPDATE `item_template` SET 
 
`BuyPrice` = '2800',
`SellPrice` = '1400',
`armor` = '940',
`StatsCount` = '4',
`stat_type1` = '30',
`stat_value1` = '-375',
`stat_type2` = '3',
`stat_value2` = '-10',
`stat_type3` = '35',
`stat_value3` = '39',
`stat_type4` = '29',
`stat_value4` = '-375'
 
WHERE `item_template`.`class` =4 AND `subclass` =4 AND `Quality` =0 AND `InventoryType` = 6;
 
/* Primitivne */
 
UPDATE `item_template` SET 
 
`BuyPrice` = '3000',
`SellPrice` = '1500',
`armor` = '1000',
`StatsCount` = '4',
`stat_type1` = '30',
`stat_value1` = '-375',
`stat_type2` = '3',
`stat_value2` = '-10',
`stat_type3` = '35',
`stat_value3` = '39',
`stat_type4` = '29',
`stat_value4` = '-375'
 
WHERE `item_template`.`class` =4 AND `subclass` =4 AND `Quality` =1 AND `InventoryType` = 6;
 
/* Kvalitne */
UPDATE `item_template` SET 
 
`BuyPrice` = '3750',
`SellPrice` = '1875',
`armor` = '1250',
`StatsCount` = '4',
`stat_type1` = '30',
`stat_value1` = '-375',
`stat_type2` = '3',
`stat_value2` = '-10',
`stat_type3` = '35',
`stat_value3` = '39',
`stat_type4` = '29',
`stat_value4` = '-375'
 
WHERE `item_template`.`class` =4 AND `subclass` =4 AND `Quality` =2 AND `InventoryType` = 6;
 
/* Vzacne */
UPDATE `item_template` SET 
 
`BuyPrice` = '4700',
`SellPrice` = '2350',
`armor` = '1600',
`StatsCount` = '4',
`stat_type1` = '30',
`stat_value1` = '-375',
`stat_type2` = '3',
`stat_value2` = '-10',
`stat_type3` = '35',
`stat_value3` = '39',
`stat_type4` = '29',
`stat_value4` = '-375'
WHERE `item_template`.`class` =4 AND `subclass` =4 AND `Quality` =3 AND `InventoryType` = 6;
 
/* Magicke */
UPDATE `item_template` SET 
 
`BuyPrice` = '3750',
`SellPrice` = '1875',
`armor` = '1250',
`StatsCount` = '4',
`stat_type1` = '30',
`stat_value1` = '-375',
`stat_type2` = '3',
`stat_value2` = '-10',
`stat_type3` = '35',
`stat_value3` = '39',
`stat_type4` = '29',
`stat_value4` = '-375'
 
WHERE `item_template`.`class` =4 AND `subclass` =4 AND `Quality` =4 AND `InventoryType` = 6;
 
/* Legendarne */
UPDATE `item_template` SET 
 
`BuyPrice` = '5600',
`SellPrice` = '2550',
`armor` = '1900',
`StatsCount` = '4',
`stat_type1` = '30',
`stat_value1` = '-375',
`stat_type2` = '3',
`stat_value2` = '-10',
`stat_type3` = '35',
`stat_value3` = '39',
`stat_type4` = '29',
`stat_value4` = '-375'
 
WHERE `item_template`.`class` =4 AND `subclass` =4 AND `Quality` =5 AND `InventoryType` = 6;
 
/* Artefakty */
UPDATE `item_template` SET 
 
`BuyPrice` = '3750',
`SellPrice` = '1875',
`armor` = '1250',
`StatsCount` = '4',
`stat_type1` = '30',
`stat_value1` = '-375',
`stat_type2` = '3',
`stat_value2` = '-10',
`stat_type3` = '35',
`stat_value3` = '39',
`stat_type4` = '29',
`stat_value4` = '-375'
 
WHERE `item_template`.`class` =4 AND `subclass` =4 AND `Quality` =6 AND `InventoryType` = 6;
 
/* -------------------------- */
 
 
/* WRIST */
 
/* Opotrebovane */
UPDATE `item_template` SET 
 
`BuyPrice` = '2800',
`SellPrice` = '1400',
`armor` = '940',
`StatsCount` = '4',
`stat_type1` = '30',
`stat_value1` = '-375',
`stat_type2` = '3',
`stat_value2` = '-10',
`stat_type3` = '35',
`stat_value3` = '39',
`stat_type4` = '29',
`stat_value4` = '-375'
 
WHERE `item_template`.`class` =4 AND `subclass` =4 AND `Quality` =0 AND `InventoryType` = 9;
 
/* Primitivne */
 
UPDATE `item_template` SET 
 
`BuyPrice` = '3000',
`SellPrice` = '1500',
`armor` = '1000',
`StatsCount` = '4',
`stat_type1` = '30',
`stat_value1` = '-375',
`stat_type2` = '3',
`stat_value2` = '-10',
`stat_type3` = '35',
`stat_value3` = '39',
`stat_type4` = '29',
`stat_value4` = '-375'
 
WHERE `item_template`.`class` =4 AND `subclass` =4 AND `Quality` =1 AND `InventoryType` = 9;
 
/* Kvalitne */
UPDATE `item_template` SET 
 
`BuyPrice` = '3750',
`SellPrice` = '1875',
`armor` = '1250',
`StatsCount` = '4',
`stat_type1` = '30',
`stat_value1` = '-375',
`stat_type2` = '3',
`stat_value2` = '-10',
`stat_type3` = '35',
`stat_value3` = '39',
`stat_type4` = '29',
`stat_value4` = '-375'
 
WHERE `item_template`.`class` =4 AND `subclass` =4 AND `Quality` =2 AND `InventoryType` = 9;
 
/* Vzacne */
UPDATE `item_template` SET 
 
`BuyPrice` = '4700',
`SellPrice` = '2350',
`armor` = '1600',
`StatsCount` = '4',
`stat_type1` = '30',
`stat_value1` = '-375',
`stat_type2` = '3',
`stat_value2` = '-10',
`stat_type3` = '35',
`stat_value3` = '39',
`stat_type4` = '29',
`stat_value4` = '-375'
 
WHERE `item_template`.`class` =4 AND `subclass` =4 AND `Quality` =3 AND `InventoryType` = 9;
 
/* Magicke */
UPDATE `item_template` SET 
 
`BuyPrice` = '3750',
`SellPrice` = '1875',
`armor` = '1250',
`StatsCount` = '4',
`stat_type1` = '30',
`stat_value1` = '-375',
`stat_type2` = '3',
`stat_value2` = '-10',
`stat_type3` = '35',
`stat_value3` = '39',
`stat_type4` = '29',
`stat_value4` = '-375'
 
WHERE `item_template`.`class` =4 AND `subclass` =4 AND `Quality` =4 AND `InventoryType` = 9;
 
/* Legendarne */
UPDATE `item_template` SET 
 
`BuyPrice` = '5600',
`SellPrice` = '2550',
`armor` = '1900',
`StatsCount` = '4',
`stat_type1` = '30',
`stat_value1` = '-375',
`stat_type2` = '3',
`stat_value2` = '-10',
`stat_type3` = '35',
`stat_value3` = '39',
`stat_type4` = '29',
`stat_value4` = '-375'
 
WHERE `item_template`.`class` =4 AND `subclass` =4 AND `Quality` =5 AND `InventoryType` = 9;
 
/* Artefakty */
UPDATE `item_template` SET 
 
`BuyPrice` = '3750',
`SellPrice` = '1875',
`armor` = '1250',
`StatsCount` = '4',
`stat_type1` = '30',
`stat_value1` = '-375',
`stat_type2` = '3',
`stat_value2` = '-10',
`stat_type3` = '35',
`stat_value3` = '39',
`stat_type4` = '29',
`stat_value4` = '-375'
 
WHERE `item_template`.`class` =4 AND `subclass` =4 AND `Quality` =6 AND `InventoryType` = 9;
 
/* ------------------------- */

Plate

Zbroje a oblecenie

Specializace na zbroje

Košile a trika

CLOTH

LEATHER

MAIL (Kroužkové zbroje)

PLATE

SQL kod