Форум администраторов игровых серверов › MMO › Другие игры / Other games › World of WarCraft v
как сделать чтоб все игроки вначале стартовали в столицах

Рейтинг темы:
  • 0 Голос(ов) - 0 в среднем
  • 1
  • 2
  • 3
  • 4
  • 5
Каскадный режим
как сделать чтоб все игроки вначале стартовали в столицах
qwertyuiopas Не в сети
Junior Member
**
Сообщений: 4
Тем: 2
Зарегистрирован: Jun 2009
Репутация: 0
#1
06-17-2009, 10:45 PM
как сделать чтоб все игроки вначале стартовали в столицах
алики в шторме
ордынцы в оригимаре если знаете то помагите плис
Поиск
Ответ
PROGRAMMATOR Не в сети
Administrator
*******
Сообщений: 6,450
Тем: 262
Зарегистрирован: Nov 2007
Репутация: 44,165
#2
06-17-2009, 11:41 PM
Телепортируетесь в нужную столицу, вводите .gps, получаете информацию о местоположении, запоминаете значения x, y и z.
Открываете базу данных mangos и находите таблицу playercreateinfo, открываете и вписываете полученные значения в position_x, position_y и position_z.

Нашел запрос, правда не помню, точно ли то что нужно, но думаю проверить не сложно Wink

PHP код:
<?php 

UPDATE playercreateinfo SET position_x='1551,975708', position_y='-4176,376465', position_z='40,345669', MAP='1', ZONE='1637' WHERE race='2';

UPDATE playercreateinfo SET position_x='1551,975708', position_y='-4176,376465', position_z='40,345669', MAP='1', ZONE='1637' WHERE race='5';

UPDATE playercreateinfo SET position_x='1551,975708', position_y='-4176,376465', position_z='40,345669', MAP='1', ZONE='1637' WHERE race='6';

UPDATE playercreateinfo SET position_x='1551,975708', position_y='-4176,376465', position_z='40,345669', MAP='1', ZONE='1637' WHERE race='8';

UPDATE playercreateinfo SET position_x='1551,975708', position_y='-4176,376465', position_z='40,345669', MAP='1', ZONE='1637' WHERE race='10';

UPDATE playercreateinfo SET position_x='-8923,254883', position_y='545,283936', position_z='94,239494', MAP='0', ZONE='1519' WHERE race='1';

UPDATE playercreateinfo SET position_x='-8923,254883', position_y='545,283936', position_z='94,239494', MAP='0', ZONE='1519' WHERE race='3';

UPDATE playercreateinfo SET position_x='-8923,254883', position_y='545,283936', position_z='94,239494', MAP='0', ZONE='1519' WHERE race='4';

UPDATE playercreateinfo SET position_x='-8923,254883', position_y='545,283936', position_z='94,239494', MAP='0', ZONE='1519' WHERE race='7';

UPDATE playercreateinfo SET position_x='-8923,254883', position_y='545,283936', position_z='94,239494', MAP='0', ZONE='1519' WHERE race='11';

Если нужно всем изменить, на одно и тоже значение, то можно воспользоваться SQL запросом:

PHP код:
<?php 

UPDATE `mangos`.`playercreateinfo` SET `position_x`='значения_X', `position_y`='значения_Y', `position_z`='значения_Z' WHERE `race`>'0';
Поиск
Ответ
qwertyuiopas Не в сети
Junior Member
**
Сообщений: 4
Тем: 2
Зарегистрирован: Jun 2009
Репутация: 0
#3
06-18-2009, 03:47 PM
сори что в этой теме я ишо не большой вопросик задам как сделать чтоб увсех были сразу проучины спелы и скилы ?
Поиск
Ответ
kiberk Не в сети
Senior Member
****
Сообщений: 429
Тем: 27
Зарегистрирован: May 2009
Репутация: 1,279
#4
06-18-2009, 04:19 PM
[CODE]/*
MySQL Data Transfer
Source Host: localhost
Source Database: mangos
Target Host: localhost
Target Database: mangos
Date: 07.02.2009 17:57:29
*/

SET FOREIGN_KEY_CHECKS=0;
-- ----------------------------
-- Table structure for playercreateinfo_spell
-- ----------------------------
DROP TABLE IF EXISTS `playercreateinfo_spell`;
CREATE TABLE `playercreateinfo_spell` (
`race` tinyint(3) unsigned NOT NULL DEFAULT '0',
`class` tinyint(3) unsigned NOT NULL DEFAULT '0',
`Spell` mediumint(8) unsigned NOT NULL DEFAULT '0',
`Note` varchar(255) DEFAULT NULL,
PRIMARY KEY (`race`,`class`,`Spell`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records
-- ----------------------------
INSERT INTO `playercreateinfo_spell` VALUES ('1', '1', '81', 'Dodge');
INSERT INTO `playercreateinfo_spell` VALUES ('1', '1', '107', 'Block');
INSERT INTO `playercreateinfo_spell` VALUES ('1', '1', '197', 'Two-Handed Axes');
INSERT INTO `playercreateinfo_spell` VALUES ('1', '1', '264', 'Bows');
INSERT INTO `playercreateinfo_spell` VALUES ('1', '1', '5011', 'Crossbows');
INSERT INTO `playercreateinfo_spell` VALUES ('1', '1', '1180', 'Daggers');
INSERT INTO `playercreateinfo_spell` VALUES ('1', '1', '266', 'Guns');
INSERT INTO `playercreateinfo_spell` VALUES ('1', '1', '15590', 'First Weapons');
INSERT INTO `playercreateinfo_spell` VALUES ('1', '1', '200', 'Polearms');
INSERT INTO `playercreateinfo_spell` VALUES ('1', '1', '227', 'Staves');
INSERT INTO `playercreateinfo_spell` VALUES ('1', '1', '2567', 'Throw');
INSERT INTO `playercreateinfo_spell` VALUES ('1', '1', '199', 'Two-Handed Maces');
INSERT INTO `playercreateinfo_spell` VALUES ('1', '1', '202', 'Two-Handed Swords');
INSERT INTO `playercreateinfo_spell` VALUES ('1', '1', '196', 'One-Handed Axes');
INSERT INTO `playercreateinfo_spell` VALUES ('1', '1', '198', 'One-Handed Maces');
INSERT INTO `playercreateinfo_spell` VALUES ('1', '1', '201', 'One-Handed Swords');
INSERT INTO `playercreateinfo_spell` VALUES ('1', '1', '203', 'Unarmed');
INSERT INTO `playercreateinfo_spell` VALUES ('1', '1', '204', 'Defense');
INSERT INTO `playercreateinfo_spell` VALUES ('1', '1', '522', 'SPELLDEFENSE (DND)');
INSERT INTO `playercreateinfo_spell` VALUES ('1', '1', '668', 'Language Common');
INSERT INTO `playercreateinfo_spell` VALUES ('1', '1', '1843', 'Disarm');
INSERT INTO `playercreateinfo_spell` VALUES ('1', '1', '2382', 'Generic');
INSERT INTO `playercreateinfo_spell` VALUES ('1', '1', '2457', 'Battle Stance');
INSERT INTO `playercreateinfo_spell` VALUES ('1', '1', '2479', 'Honorless Target');
INSERT INTO `playercreateinfo_spell` VALUES ('1', '1', '3050', 'Detect');
INSERT INTO `playercreateinfo_spell` VALUES ('1', '1', '3365', 'Opening');
INSERT INTO `playercreateinfo_spell` VALUES ('1', '1', '5301', 'Defensive State (DND)');
INSERT INTO `playercreateinfo_spell` VALUES ('1', '1', '6233', 'Closing');
INSERT INTO `playercreateinfo_spell` VALUES ('1', '1', '6246', 'Closing');
INSERT INTO `playercreateinfo_spell` VALUES ('1', '1', '6247', 'Opening');
INSERT INTO `playercreateinfo_spell` VALUES ('1', '1', '6477', 'Opening');
INSERT INTO `playercreateinfo_spell` VALUES ('1', '1', '6478', 'Opening');
INSERT INTO `playercreateinfo_spell` VALUES ('1', '1', '6603', 'Attack');
INSERT INTO `playercreateinfo_spell` VALUES ('1', '1', '7266', 'Duel');
INSERT INTO `playercreateinfo_spell` VALUES ('1', '1', '7267', 'Grovel');
INSERT INTO `playercreateinfo_spell` VALUES ('1', '1', '7355', 'Stuck');
INSERT INTO `playercreateinfo_spell` VALUES ('1', '1', '8386', 'Attacking');
INSERT INTO `playercreateinfo_spell` VALUES ('1', '1', '8737', 'Mail');
INSERT INTO `playercreateinfo_spell` VALUES ('1', '1', '9077', 'Leather');
INSERT INTO `playercreateinfo_spell` VALUES ('1', '1', '9078', 'Cloth');
INSERT INTO `playercreateinfo_spell` VALUES ('1', '1', '9116', 'Shield');
INSERT INTO `playercreateinfo_spell` VALUES ('1', '1', '9125', 'Generic');
INSERT INTO `playercreateinfo_spell` VALUES ('1', '1', '20597', 'Sword Specialization');
INSERT INTO `playercreateinfo_spell` VALUES ('1', '1', '20598', 'The Human Spirit');
INSERT INTO `playercreateinfo_spell` VALUES ('1', '1', '20599', 'Diplomacy');
INSERT INTO `playercreateinfo_spell` VALUES ('1', '1', '20864', 'Mace Specialization');
INSERT INTO `playercreateinfo_spell` VALUES ('1', '1', '21651', 'Opening');
INSERT INTO `playercreateinfo_spell` VALUES ('1', '1', '21652', 'Closing');
INSERT INTO `playercreateinfo_spell` VALUES ('1', '1', '22027', 'Remove Insignia');
INSERT INTO `playercreateinfo_spell` VALUES ('1', '1', '22810', 'Opening - No Text');
INSERT INTO `playercreateinfo_spell` VALUES ('1', '1', '32215', 'Victorious State');
INSERT INTO `playercreateinfo_spell` VALUES ('1', '1', '45927', 'Summon Friend');
INSERT INTO `playercreateinfo_spell` VALUES ('1', '1', '58985', 'Perception');
INSERT INTO `playercreateinfo_spell` VALUES ('1', '1', '59752', 'Every Man for Himself');
INSERT INTO `playercreateinfo_spell` VALUES ('1', '1', '61437', 'Opening');
INSERT INTO `playercreateinfo_spell` VALUES ('1', '2', '200', 'Polearms');
INSERT INTO `playercreateinfo_spell` VALUES ('1', '2', '196', 'One-Handed Axes');
INSERT INTO `playercreateinfo_spell` VALUES ('1', '2', '201', 'One-Handed Swords');
INSERT INTO `playercreateinfo_spell` VALUES ('1', '2', '197', 'Two-Handed Axes');
INSERT INTO `playercreateinfo_spell` VALUES ('1', '2', '202', 'Two-Handed Swords');
INSERT INTO `playercreateinfo_spell` VALUES ('1', '2', '81', 'Dodge');
INSERT INTO `playercreateinfo_spell` VALUES ('1', '2', '107', 'Block');
INSERT INTO `playercreateinfo_spell` VALUES ('1', '2', '198', 'One-Handed Maces');
INSERT INTO `playercreateinfo_spell` VALUES ('1', '2', '199', 'Two-Handed Maces');
INSERT INTO `playercreateinfo_spell` VALUES ('1', '2', '203', 'Unarmed');
INSERT INTO `playercreateinfo_spell` VALUES ('1', '2', '204', 'Defense');
INSERT INTO `playercreateinfo_spell` VALUES ('1', '2', '522', 'SPELLDEFENSE (DND)');
INSERT INTO `playercreateinfo_spell` VALUES ('1', '2', '668', 'Language Common');
INSERT INTO `playercreateinfo_spell` VALUES ('1', '2', '1843', 'Disarm');
INSERT INTO `playercreateinfo_spell` VALUES ('1', '2', '2382', 'Generic');
INSERT INTO `playercreateinfo_spell` VALUES ('1', '2', '2479', 'Honorless Target');
INSERT INTO `playercreateinfo_spell` VALUES ('1', '2', '3050', 'Detect');
INSERT INTO `playercreateinfo_spell` VALUES ('1', '2', '3365', 'Opening');
INSERT INTO `playercreateinfo_spell` VALUES ('1', '2', '6233', 'Closing');
INSERT INTO `playercreateinfo_spell` VALUES ('1', '2', '6246', 'Closing');
INSERT INTO `playercreateinfo_spell` VALUES ('1', '2', '6247', 'Opening');
INSERT INTO `playercreateinfo_spell` VALUES ('1', '2', '6477', 'Opening');
INSERT INTO `playercreateinfo_spell` VALUES ('1', '2', '6478', 'Opening');
INSERT INTO `playercreateinfo_spell` VALUES ('1', '2', '6603', 'Attack');
INSERT INTO `playercreateinfo_spell` VALUES ('1', '2', '7266', 'Duel');
INSERT INTO `playercreateinfo_spell` VALUES ('1', '2', '7267', 'Grovel');
INSERT INTO `playercreateinfo_spell` VALUES ('1', '2', '7355', 'Stuck');
INSERT INTO `playercreateinfo_spell` VALUES ('1', '2', '8386', 'Attacking');
INSERT INTO `playercreateinfo_spell` VALUES ('1', '2', '8737', 'Mail');
INSERT INTO `playercreateinfo_spell` VALUES ('1', '2', '9077', 'Leather');
INSERT INTO `playercreateinfo_spell` VALUES ('1', '2', '9078', 'Cloth');
INSERT INTO `playercreateinfo_spell` VALUES ('1', '2', '9116', 'Shield');
INSERT INTO `playercreateinfo_spell` VALUES ('1', '2', '9125', 'Generic');
INSERT INTO `playercreateinfo_spell` VALUES ('1', '2', '20597', 'Sword Specialization');
INSERT INTO `playercreateinfo_spell` VALUES ('1', '2', '20598', 'The Human Spirit');
INSERT INTO `playercreateinfo_spell` VALUES ('1', '2', '20599', 'Diplomacy');
INSERT INTO `playercreateinfo_spell` VALUES ('1', '2', '20864', 'Mace Specialization');
INSERT INTO `playercreateinfo_spell` VALUES ('1', '2', '21651', 'Opening');
INSERT INTO `playercreateinfo_spell` VALUES ('1', '2', '21652', 'Closing');
INSERT INTO `playercreateinfo_spell` VALUES ('1', '2', '22027', 'Remove Insignia');
INSERT INTO `playercreateinfo_spell` VALUES ('1', '2', '22810', 'Opening - No Text');
INSERT INTO `playercreateinfo_spell` VALUES ('1', '2', '27762', 'Libram');
INSERT INTO `playercreateinfo_spell` VALUES ('1', '2', '45927', 'Summon Friend');
INSERT INTO `playercreateinfo_spell` VALUES ('1', '2', '58985', 'Perception');
INSERT INTO `playercreateinfo_spell` VALUES ('1', '2', '59752', 'Every Man for Himself');
INSERT INTO `playercreateinfo_spell` VALUES ('1', '2', '61437', 'Opening');
INSERT INTO `playercreateinfo_spell` VALUES ('1', '4', '264', 'Bows');
INSERT INTO `playercreateinfo_spell` VALUES ('1', '4', '5011', 'Crossbows');
INSERT INTO `playercreateinfo_spell` VALUES ('1', '4', '198', 'One-Handed Maces');
INSERT INTO `playercreateinfo_spell` VALUES ('1', '4', '201', 'One-Handed Swords');
INSERT INTO `playercreateinfo_spell` VALUES ('1', '4', '266', 'Guns');
INSERT INTO `playercreateinfo_spell` VALUES ('1', '4', '15590', 'First Weapons');
INSERT INTO `playercreateinfo_spell` VALUES ('1', '4', '81', 'Dodge');
INSERT INTO `playercreateinfo_spell` VALUES ('1', '4', '203', 'Unarmed');
INSERT INTO `playercreateinfo_spell` VALUES ('1', '4', '204', 'Defense');
INSERT INTO `playercreateinfo_spell` VALUES ('1', '4', '522', 'SPELLDEFENSE (DND)');
INSERT INTO `playercreateinfo_spell` VALUES ('1', '4', '668', 'Language Common');
INSERT INTO `playercreateinfo_spell` VALUES ('1', '4', '1180', 'Daggers');
INSERT INTO `playercreateinfo_spell` VALUES ('1', '4', '1843', 'Disarm');
INSERT INTO `playercreateinfo_spell` VALUES ('1', '4', '2382', 'Generic');
INSERT INTO `playercreateinfo_spell` VALUES ('1', '4', '2479', 'Honorless Target');
INSERT INTO `playercreateinfo_spell` VALUES ('1', '4', '2567', 'Thrown');
INSERT INTO `playercreateinfo_spell` VALUES ('1', '4', '2764', 'Throw');
INSERT INTO `playercreateinfo_spell` VALUES ('1', '4', '3050', 'Detect');
INSERT INTO `playercreateinfo_spell` VALUES ('1', '4', '3365', 'Opening');
INSERT INTO `playercreateinfo_spell` VALUES ('1', '4', '6233', 'Closing');
INSERT INTO `playercreateinfo_spell` VALUES ('1', '4', '6246', 'Closing');
INSERT INTO `playercreateinfo_spell` VALUES ('1', '4', '6247', 'Opening');
INSERT INTO `playercreateinfo_spell` VALUES ('1', '4', '6477', 'Opening');
INSERT INTO `playercreateinfo_spell` VALUES ('1', '4', '6478', 'Opening');
INSERT INTO `playercreateinfo_spell` VALUES ('1', '4', '6603', 'Attack');
INSERT INTO `playercreateinfo_spell` VALUES ('1', '4', '7266', 'Duel');
INSERT INTO `playercreateinfo_spell` VALUES ('1', '4', '7267', 'Grovel');
INSERT INTO `playercreateinfo_spell` VALUES ('1', '4', '7355', 'Stuck');
INSERT INTO `playercreateinfo_spell` VALUES ('1', '4', '8386', 'Attacking');
INSERT INTO `playercreateinfo_spell` VALUES ('1', '4', '9077', 'Leather');
INSERT INTO `playercreateinfo_spell` VALUES ('1', '4', '9078', 'Cloth');
INSERT INTO `playercreateinfo_spell` VALUES ('1', '4', '9125', 'Generic');
INSERT INTO `playercreateinfo_spell` VALUES ('1', '4', '16092', 'Defensive State (DND)');
INSERT INTO `playercreateinfo_spell` VALUES ('1', '4', '20597', 'Sword Specialization');
INSERT INTO `playercreateinfo_spell` VALUES ('1', '4', '20598', 'The Human Spirit');
INSERT INTO `playercreateinfo_spell` VALUES ('1', '4', '20599', 'Diplomacy');
INSERT INTO `playercreateinfo_spell` VALUES ('1', '4', '20864', 'Mace Specialization');
INSERT INTO `playercreateinfo_spell` VALUES ('1', '4', '21184', 'Rogue Passive (DND)');
INSERT INTO `playercreateinfo_spell` VALUES ('1', '4', '21651', 'Opening');
INSERT INTO `playercreateinfo_spell` VALUES ('1', '4', '21652', 'Closing');
INSERT INTO `playercreateinfo_spell` VALUES ('1', '4', '22027', 'Remove Insignia');
INSERT INTO `playercreateinfo_spell` VALUES ('1', '4', '22810', 'Opening - No Text');
INSERT INTO `playercreateinfo_spell` VALUES ('1', '4', '45927', 'Summon Friend');
INSERT INTO `playercreateinfo_spell` VALUES ('1', '4', '58985', 'Perception');
INSERT INTO `playercreateinfo_spell` VALUES ('1', '4', '59752', 'Every Man for Himself');
INSERT INTO `playercreateinfo_spell` VALUES ('1', '4', '61437', 'Opening');
INSERT INTO `playercreateinfo_spell` VALUES ('1', '5', '1180', 'Daggers');
INSERT INTO `playercreateinfo_spell` VALUES ('1', '5', '227', 'Staves');
INSERT INTO `playercreateinfo_spell` VALUES ('1', '5', '81', 'Dodge');
INSERT INTO `playercreateinfo_spell` VALUES ('1', '5', '198', 'One-Handed Maces');
INSERT INTO `playercreateinfo_spell` VALUES ('1', '5', '203', 'Unarmed');
INSERT INTO `playercreateinfo_spell` VALUES ('1', '5', '204', 'Defense');
INSERT INTO `playercreateinfo_spell` VALUES ('1', '5', '522', 'SPELLDEFENSE (DND)');
INSERT INTO `playercreateinfo_spell` VALUES ('1', '5', '668', 'Language Common');
INSERT INTO `playercreateinfo_spell` VALUES ('1', '5', '1843', 'Disarm');
INSERT INTO `playercreateinfo_spell` VALUES ('1', '5', '2382', 'Generic');
INSERT INTO `playercreateinfo_spell` VALUES ('1', '5', '2479', 'Honorless Target');
INSERT INTO `playercreateinfo_spell` VALUES ('1', '5', '3050', 'Detect');
INSERT INTO `playercreateinfo_spell` VALUES ('1', '5', '3365', 'Opening');
INSERT INTO `playercreateinfo_spell` VALUES ('1', '5', '5009', 'Wands');
INSERT INTO `playercreateinfo_spell` VALUES ('1', '5', '5019', 'Shoot');
INSERT INTO `playercreateinfo_spell` VALUES ('1', '5', '6233', 'Closing');
INSERT INTO `playercreateinfo_spell` VALUES ('1', '5', '6246', 'Closing');
INSERT INTO `playercreateinfo_spell` VALUES ('1', '5', '6247', 'Opening');
INSERT INTO `playercreateinfo_spell` VALUES ('1', '5', '6477', 'Opening');
INSERT INTO `playercreateinfo_spell` VALUES ('1', '5', '6478', 'Opening');
INSERT INTO `playercreateinfo_spell` VALUES ('1', '5', '6603', 'Attack');
INSERT INTO `playercreateinfo_spell` VALUES ('1', '5', '7266', 'Duel');
INSERT INTO `playercreateinfo_spell` VALUES ('1', '5', '7267', 'Grovel');
INSERT INTO `playercreateinfo_spell` VALUES ('1', '5', '7355', 'Stuck');
INSERT INTO `playercreateinfo_spell` VALUES ('1', '5', '8386', 'Attacking');
INSERT INTO `playercreateinfo_spell` VALUES ('1', '5', '9078', 'Cloth');
INSERT INTO `playercreateinfo_spell` VALUES ('1', '5', '9125', 'Generic');
INSERT INTO `playercreateinfo_spell` VALUES ('1', '5', '20597', 'Sword Specialization');
INSERT INTO `playercreateinfo_spell` VALUES ('1', '5', '20598', 'The Human Spirit');
INSERT INTO `playercreateinfo_spell` VALUES ('1', '5', '20599', 'Diplomacy');
INSERT INTO `playercreateinfo_spell` VALUES ('1', '5', '20864', 'Mace Specialization');
INSERT INTO `playercreateinfo_spell` VALUES ('1', '5', '21651', 'Opening');
INSERT INTO `playercreateinfo_spell` VALUES ('1', '5', '21652', 'Closing');
INSERT INTO `playercreateinfo_spell` VALUES ('1', '5', '22027', 'Remove Insignia');
INSERT INTO `playercreateinfo_spell` VALUES ('1', '5', '22810', 'Opening - No Text');
INSERT INTO `playercreateinfo_spell` VALUES ('1', '5', '45927', 'Summon Friend');
INSERT INTO `playercreateinfo_spell` VALUES ('1', '5', '58985', 'Perception');
INSERT INTO `playercreateinfo_spell` VALUES ('1', '5', '59752', 'Every Man for Himself');
INSERT INTO `playercreateinfo_spell` VALUES ('1', '5', '61437', 'Opening');
INSERT INTO `playercreateinfo_spell` VALUES ('1', '6', '81', 'Dodge');
INSERT INTO `playercreateinfo_spell` VALUES ('1', '6', '196', 'One-Handed Axes');
INSERT INTO `playercreateinfo_spell` VALUES ('1', '6', '197', 'Two-Handed Axes');
INSERT INTO `playercreateinfo_spell` VALUES ('1', '6', '200', 'Polearms');
INSERT INTO `playercreateinfo_spell` VALUES ('1', '6', '201', 'One-Handed Swords');
INSERT INTO `playercreateinfo_spell` VALUES ('1', '6', '202', 'Two-Handed Swords');
INSERT INTO `playercreateinfo_spell` VALUES ('1', '6', '203', 'Unarmed');
INSERT INTO `playercreateinfo_spell` VALUES ('1', '6', '204', 'Defense');
INSERT INTO `playercreateinfo_spell` VALUES ('1', '6', '522', 'SPELLDEFENSE (DND)');
INSERT INTO `playercreateinfo_spell` VALUES ('1', '6', '668', 'Language Common');
INSERT INTO `playercreateinfo_spell` VALUES ('1', '6', '674', 'Dual Wield');
INSERT INTO `playercreateinfo_spell` VALUES ('1', '6', '750', 'Plate Mail');
INSERT INTO `playercreateinfo_spell` VALUES ('1', '6', '1843', 'Disarm');
INSERT INTO `playercreateinfo_spell` VALUES ('1', '6', '2382', 'Generic');
INSERT INTO `playercreateinfo_spell` VALUES ('1', '6', '2479', 'Honorless Target');
INSERT INTO `playercreateinfo_spell` VALUES ('1', '6', '3050', 'Detect');
INSERT INTO `playercreateinfo_spell` VALUES ('1', '6', '3127', 'Parry');
INSERT INTO `playercreateinfo_spell` VALUES ('1', '6', '3275', 'Linen Bandage');
INSERT INTO `playercreateinfo_spell` VALUES ('1', '6', '3276', 'Heavy Linen Bandage');
INSERT INTO `playercreateinfo_spell` VALUES ('1', '6', '3277', 'Wool Bandage');
INSERT INTO `playercreateinfo_spell` VALUES ('1', '6', '3278', 'Heavy Wool Bandage');
INSERT INTO `playercreateinfo_spell` VALUES ('1', '6', '3365', 'Opening');
INSERT INTO `playercreateinfo_spell` VALUES ('1', '6', '6233', 'Closing');
INSERT INTO `playercreateinfo_spell` VALUES ('1', '6', '6246', 'Closing');
INSERT INTO `playercreateinfo_spell` VALUES ('1', '6', '6247', 'Opening');
INSERT INTO `playercreateinfo_spell` VALUES ('1', '6', '6477', 'Opening');
INSERT INTO `playercreateinfo_spell` VALUES ('1', '6', '6478', 'Opening');
INSERT INTO `playercreateinfo_spell` VALUES ('1', '6', '6603', 'Attack');
INSERT INTO `playercreateinfo_spell` VALUES ('1', '6', '7266', 'Duel');
INSERT INTO `playercreateinfo_spell` VALUES ('1', '6', '7267', 'Grovel');
INSERT INTO `playercreateinfo_spell` VALUES ('1', '6', '7355', 'Stuck');
INSERT INTO `playercreateinfo_spell` VALUES ('1', '6', '7928', 'Silk Bandage');
INSERT INTO `playercreateinfo_spell` VALUES ('1', '6', '7929', 'Heavy Silk Bandage');
INSERT INTO `playercreateinfo_spell` VALUES ('1', '6', '7934', 'Anti-Venom');
INSERT INTO `playercreateinfo_spell` VALUES ('1', '6', '8386', 'Attacking');
INSERT INTO `playercreateinfo_spell` VALUES ('1', '6', '8737', 'Mail');
INSERT INTO `playercreateinfo_spell` VALUES ('1', '6', '9077', 'Leather');
INSERT INTO `playercreateinfo_spell` VALUES ('1', '6', '9078', 'Cloth');
INSERT INTO `playercreateinfo_spell` VALUES ('1', '6', '9125', 'Generic');
INSERT INTO `playercreateinfo_spell` VALUES ('1', '6', '10840', 'Mageweave Bandage');
INSERT INTO `playercreateinfo_spell` VALUES ('1', '6', '10841', 'Heavy Mageweave Bandage');
INSERT INTO `playercreateinfo_spell` VALUES ('1', '6', '10846', 'First Aid');
INSERT INTO `playercreateinfo_spell` VALUES ('1', '6', '18629', 'Runecloth Bandage');
INSERT INTO `playercreateinfo_spell` VALUES ('1', '6', '18630', 'Heavy Runecloth Bandage');
INSERT INTO `playercreateinfo_spell` VALUES ('1', '6', '20597', 'Sword Specialization');
INSERT INTO `playercreateinfo_spell` VALUES ('1', '6', '20598', 'The Human Spirit');
INSERT INTO `playercreateinfo_spell` VALUES ('1', '6', '20599', 'Diplomacy');
INSERT INTO `playercreateinfo_spell` VALUES ('1', '6', '20864', 'Mace Specialization');
INSERT INTO `playercreateinfo_spell` VALUES ('1', '6', '21651', 'Opening');
INSERT INTO `playercreateinfo_spell` VALUES ('1', '6', '21652', 'Closing');
INSERT INTO `playercreateinfo_spell` VALUES ('1', '6', '22027', 'Remove Insignia');
INSERT INTO `playercreateinfo_spell` VALUES ('1', '6', '22810', 'Opening - No Text');
INSERT INTO `playercreateinfo_spell` VALUES ('1', '6', '33391', 'Journeyman Riding');
INSERT INTO `playercreateinfo_spell` VALUES ('1', '6', '45462', 'Plague Strike');
INSERT INTO `playercreateinfo_spell` VALUES ('1', '6', '45477', 'Icy Touch');
INSERT INTO `playercreateinfo_spell` VALUES ('1', '6', '45902', 'Blood Strike');
INSERT INTO `playercreateinfo_spell` VALUES ('1', '6', '45903', 'Offensive State (DND)');
INSERT INTO `playercreateinfo_spell` VALUES ('1', '6', '45927', 'Summon Friend');
INSERT INTO `playercreateinfo_spell` VALUES ('1', '6', '47541', 'Death Coil');
INSERT INTO `playercreateinfo_spell` VALUES ('1', '6', '48266', 'Blood Presence');
INSERT INTO `playercreateinfo_spell` VALUES ('1', '6', '49410', 'Forceful Deflection');
INSERT INTO `playercreateinfo_spell` VALUES ('1', '6', '49576', 'Death Grip');
INSERT INTO `playercreateinfo_spell` VALUES ('1', '6', '52665', 'Sigil');
INSERT INTO `playercreateinfo_spell` VALUES ('1', '6', '58985', 'Perception');
INSERT INTO `playercreateinfo_spell` VALUES ('1', '6', '59752', 'Every Man for Himself');
INSERT INTO `playercreateinfo_spell` VALUES ('1', '6', '59879', 'Blood Plague');
INSERT INTO `playercreateinfo_spell` VALUES ('1', '6', '59921', 'Frost Fever');
INSERT INTO `playercreateinfo_spell` VALUES ('1', '6', '61437', 'Opening');
INSERT INTO `playercreateinfo_spell` VALUES ('1', '6', '61455', 'Runic Focus');
INSERT INTO `playercreateinfo_spell` VALUES ('1', '8', '1180', 'Daggers');
INSERT INTO `playercreateinfo_spell` VALUES ('1', '8', '201', 'One-Handed Swords');
INSERT INTO `playercreateinfo_spell` VALUES ('1', '8', '81', 'Dodge');
INSERT INTO `playercreateinfo_spell` VALUES ('1', '8', '203', 'Unarmed');
INSERT INTO `playercreateinfo_spell` VALUES ('1', '8', '204', 'Defense');
INSERT INTO `playercreateinfo_spell` VALUES ('1', '8', '227', 'Staves');
INSERT INTO `playercreateinfo_spell` VALUES ('1', '8', '522', 'SPELLDEFENSE (DND)');
INSERT INTO `playercreateinfo_spell` VALUES ('1', '8', '668', 'Language Common');
INSERT INTO `playercreateinfo_spell` VALUES ('1', '8', '1843', 'Disarm');
INSERT INTO `playercreateinfo_spell` VALUES ('1', '8', '2382', 'Generic');
INSERT INTO `playercreateinfo_spell` VALUES ('1', '8', '2479', 'Honorless Target');
INSERT INTO `playercreateinfo_spell` VALUES ('1', '8', '3050', 'Detect');
INSERT INTO `playercreateinfo_spell` VALUES ('1', '8', '3365', 'Opening');
INSERT INTO `playercreateinfo_spell` VALUES ('1', '8', '5009', 'Wands');
INSERT INTO `playercreateinfo_spell` VALUES ('1', '8', '5019', 'Shoot');
INSERT INTO `playercreateinfo_spell` VALUES ('1', '8', '6233', 'Closing');
INSERT INTO `playercreateinfo_spell` VALUES ('1', '8', '6246', 'Closing');
INSERT INTO `playercreateinfo_spell` VALUES ('1', '8', '6247', 'Opening');
INSERT INTO `playercreateinfo_spell` VALUES ('1', '8', '6477', 'Opening');
INSERT INTO `playercreateinfo_spell` VALUES ('1', '8', '6478', 'Opening');
INSERT INTO `playercreateinfo_spell` VALUES ('1', '8', '6603', 'Attack');
INSERT INTO `playercreateinfo_spell` VALUES ('1', '8', '7266', 'Duel');
INSERT INTO `playercreateinfo_spell` VALUES ('1', '8', '7267', 'Grovel');
INSERT INTO `playercreateinfo_spell` VALUES ('1', '8', '7355', 'Stuck');
INSERT INTO `playercreateinfo_spell` VALUES ('1', '8', '8386', 'Attacking');
INSERT INTO `playercreateinfo_spell` VALUES ('1', '8', '9078', 'Cloth');
INSERT INTO `playercreateinfo_spell` VALUES ('1', '8', '9125', 'Generic');
INSERT INTO `playercreateinfo_spell` VALUES ('1', '8', '20597', 'Sword Specialization');
INSERT INTO `playercreateinfo_spell` VALUES ('1', '8', '20598', 'The Human Spirit');
INSERT INTO `playercreateinfo_spell` VALUES ('1', '8', '20599', 'Diplomacy');
INSERT INTO `playercreateinfo_spell` VALUES ('1', '8', '20864', 'Mace Specialization');
INSERT INTO `playercreateinfo_spell` VALUES ('1', '8', '21651', 'Opening');
INSERT INTO `playercreateinfo_spell` VALUES ('1', '8', '21652', 'Closing');
INSERT INTO `playercreateinfo_spell` VALUES ('1', '8', '22027', 'Remove Insignia');
INSERT INTO `playercreateinfo_spell` VALUES ('1', '8', '22810', 'Opening - No Text');
INSERT INTO `playercreateinfo_spell` VALUES ('1', '8', '45927', 'Summon Friend');
INSERT INTO `playercreateinfo_spell` VALUES ('1', '8', '58985', 'Perception');
INSERT INTO `playercreateinfo_spell` VALUES ('1', '8', '59752', 'Every Man for Himself');
INSERT INTO `playercreateinfo_spell` VALUES ('1', '8', '61437', 'Opening');
INSERT INTO `playercreateinfo_spell` VALUES ('1', '9', '201', 'One-Handed Swords');
INSERT INTO `playercreateinfo_spell` VALUES ('1', '9', '227', 'Staves');
INSERT INTO `playercreateinfo_spell` VALUES ('1', '9', '81', 'Dodge');
INSERT INTO `playercreateinfo_spell` VALUES ('1', '9', '203', 'Unarmed');
INSERT INTO `playercreateinfo_spell` VALUES ('1', '9', '204', 'Defense');
INSERT INTO `playercreateinfo_spell` VALUES ('1', '9', '522', 'SPELLDEFENSE (DND)');
INSERT INTO `playercreateinfo_spell` VALUES ('1', '9', '668', 'Language Common');
INSERT INTO `playercreateinfo_spell` VALUES ('1', '9', '1180', 'Daggers');
INSERT INTO `playercreateinfo_spell` VALUES ('1', '9', '1843', 'Disarm');
INSERT INTO `playercreateinfo_spell` VALUES ('1', '9', '2382', 'Generic');
INSERT INTO `playercreateinfo_spell` VALUES ('1', '9', '2479', 'Honorless Target');
INSERT INTO `playercreateinfo_spell` VALUES ('1', '9', '3050', 'Detect');
INSERT INTO `playercreateinfo_spell` VALUES ('1', '9', '3365', 'Opening');
INSERT INTO `playercreateinfo_spell` VALUES ('1', '9', '5009', 'Wands');
INSERT INTO `playercreateinfo_spell` VALUES ('1', '9', '5019', 'Shoot');
INSERT INTO `playercreateinfo_spell` VALUES ('1', '9', '6233', 'Closing');
INSERT INTO `playercreateinfo_spell` VALUES ('1', '9', '6246', 'Closing');
INSERT INTO `playercreateinfo_spell` VALUES ('1', '9', '6247', 'Opening');
INSERT INTO `playercreateinfo_spell` VALUES ('1', '9', '6477', 'Opening');
INSERT INTO `playercreateinfo_spell` VALUES ('1', '9', '6478', 'Opening');
INSERT INTO `playercreateinfo_spell` VALUES ('1', '9', '6603', 'Attack');
INSERT INTO `playercreateinfo_spell` VALUES ('1', '9', '7266', 'Duel');
INSERT INTO `playercreateinfo_spell` VALUES ('1', '9', '7267', 'Grovel');
INSERT INTO `playercreateinfo_spell` VALUES ('1', '9', '7355', 'Stuck');
INSERT INTO `playercreateinfo_spell` VALUES ('1', '9', '8386', 'Attacking');
INSERT INTO `playercreateinfo_spell` VALUES ('1', '9', '9078', 'Cloth');
INSERT INTO `playercreateinfo_spell` VALUES ('1', '9', '9125', 'Generic');
INSERT INTO `playercreateinfo_spell` VALUES ('1', '9', '20597', 'Sword Specialization');
INSERT INTO `playercreateinfo_spell` VALUES ('1', '9', '20598', 'The Human Spirit');
INSERT INTO `playercreateinfo_spell` VALUES ('1', '9', '20599', 'Diplomacy');
INSERT INTO `playercreateinfo_spell` VALUES ('1', '9', '20864', 'Mace Specialization');
INSERT INTO `playercreateinfo_spell` VALUES ('1', '9', '21651', 'Opening');
INSERT INTO `playercreateinfo_spell` VALUES ('1', '9', '21652', 'Closing');
INSERT INTO `playercreateinfo_spell` VALUES ('1', '9', '22027', 'Remove Insignia');
INSERT INTO `playercreateinfo_spell` VALUES ('1', '9', '22810', 'Opening - No Text');
INSERT INTO `playercreateinfo_spell` VALUES ('1', '9', '45927', 'Summon Friend');
INSERT INTO `playercreateinfo_spell` VALUES ('5', '9', '58284', 'Chaos Bolt Passive');
INSERT INTO `playercreateinfo_spell` VALUES ('1', '9', '58985', 'Perception');
INSERT INTO `playercreateinfo_spell` VALUES ('1', '9', '59752', 'Every Man for Himself');
INSERT INTO `playercreateinfo_spell` VALUES ('1', '9', '61437', 'Opening');
INSERT INTO `playercreateinfo_spell` VALUES ('2', '1', '81', 'Dodge');
INSERT INTO `playercreateinfo_spell` VALUES ('2', '1', '107', 'Block');
INSERT INTO `playercreateinfo_spell` VALUES ('2', '1', '264', 'Bows');
INSERT INTO `playercreateinfo_spell` VALUES ('2', '1', '5011', 'Crossbows');
INSERT INTO `playercreateinfo_spell` VALUES ('2', '1', '1180', 'Daggers');
INSERT INTO `playercreateinfo_spell` VALUES ('2', '1', '266', 'Guns');
INSERT INTO `playercreateinfo_spell` VALUES ('2', '1', '15590', 'First Weapons');
INSERT INTO `playercreateinfo_spell` VALUES ('2', '1', '200', 'Polearms');
INSERT INTO `playercreateinfo_spell` VALUES ('2', '1', '227', 'Staves');
INSERT INTO `playercreateinfo_spell` VALUES ('2', '1', '2567', 'Throw');
INSERT INTO `playercreateinfo_spell` VALUES ('2', '1', '199', 'Two-Handed Maces');
INSERT INTO `playercreateinfo_spell` VALUES ('2', '1', '202', 'Two-Handed Swords');
INSERT INTO `playercreateinfo_spell` VALUES ('2', '1', '198', 'One-Handed Maces');
INSERT INTO `playercreateinfo_spell` VALUES ('2', '1', '196', 'One-Handed Axes');
INSERT INTO `playercreateinfo_spell` VALUES ('2', '1', '197', 'Two-Handed Axes');
INSERT INTO `playercreateinfo_spell` VALUES ('2', '1', '201', 'One-Handed Swords');
INSERT INTO `playercreateinfo_spell` VALUES ('2', '1', '203', 'Unarmed');
INSERT INTO `playercreateinfo_spell` VALUES ('2', '1', '204', 'Defense');
INSERT INTO `playercreateinfo_spell` VALUES ('2', '1', '522', 'SPELLDEFENSE (DND)');
INSERT INTO `playercreateinfo_spell` VALUES ('2', '1', '669', 'Language Orcish');
INSERT INTO `playercreateinfo_spell` VALUES ('2', '1', '1843', 'Disarm');
INSERT INTO `playercreateinfo_spell` VALUES ('2', '1', '2382', 'Generic');
INSERT INTO `playercreateinfo_spell` VALUES ('2', '1', '2457', 'Battle Stance');
INSERT INTO `playercreateinfo_spell` VALUES ('2', '1', '2479', 'Honorless Target');
INSERT INTO `playercreateinfo_spell` VALUES ('2', '1', '3050', 'Detect');
INSERT INTO `playercreateinfo_spell` VALUES ('2', '1', '3365', 'Opening');
INSERT INTO `playercreateinfo_spell` VALUES ('2', '1', '5301', 'Defensive State (DND)');
INSERT INTO `playercreateinfo_spell` VALUES ('2', '1', '6233', 'Closing');
INSERT INTO `playercreateinfo_spell` VALUES ('2', '1', '6246', 'Closing');
INSERT INTO `playercreateinfo_spell` VALUES ('2', '1', '6247', 'Opening');
INSERT INTO `playercreateinfo_spell` VALUES ('2', '1', '6477', 'Opening');
INSERT INTO `playercreateinfo_spell` VALUES ('2', '1', '6478', 'Opening');
INSERT INTO `playercreateinfo_spell` VALUES ('2', '1', '6603', 'Attack');
INSERT INTO `playercreateinfo_spell` VALUES ('2', '1', '7266', 'Duel');
INSERT INTO `playercreateinfo_spell` VALUES ('2', '1', '7267', 'Grovel');
INSERT INTO `playercreateinfo_spell` VALUES ('2', '1', '7355', 'Stuck');
INSERT INTO `playercreateinfo_spell` VALUES ('2', '1', '8386', 'Attacking');
INSERT INTO `playercreateinfo_spell` VALUES ('2', '1', '8737', 'Mail');
INSERT INTO `playercreateinfo_spell` VALUES ('2', '1', '9077', 'Leather');
INSERT INTO `playercreateinfo_spell` VALUES ('2', '1', '9078', 'Cloth');
INSERT INTO `playercreateinfo_spell` VALUES ('2', '1', '9116', 'Shield');
INSERT INTO `playercreateinfo_spell` VALUES ('2', '1', '9125', 'Generic');
INSERT INTO `playercreateinfo_spell` VALUES ('2', '1', '20572', 'Blood Fury');
INSERT INTO `playercreateinfo_spell` VALUES ('2', '1', '20573', 'Hardiness');
INSERT INTO `playercreateinfo_spell` VALUES ('2', '1', '20574', 'Axe Specialization');
INSERT INTO `playercreateinfo_spell` VALUES ('2', '1', '21563', 'Command');
INSERT INTO `playercreateinfo_spell` VALUES ('2', '1', '21651', 'Opening');
INSERT INTO `playercreateinfo_spell` VALUES ('2', '1', '21652', 'Closing');
INSERT INTO `playercreateinfo_spell` VALUES ('2', '1', '22027', 'Remove Insignia');
INSERT INTO `playercreateinfo_spell` VALUES ('2', '1', '22810', 'Opening - No Text');
INSERT INTO `playercreateinfo_spell` VALUES ('2', '1', '32215', 'Victorious State');
INSERT INTO `playercreateinfo_spell` VALUES ('2', '1', '45927', 'Summon Friend');
INSERT INTO `playercreateinfo_spell` VALUES ('2', '1', '61437', 'Opening');
INSERT INTO `playercreateinfo_spell` VALUES ('2', '3', '201', 'One-Handed Swords');
INSERT INTO `playercreateinfo_spell` VALUES ('2', '3', '5011', 'Crossbows');
INSERT INTO `playercreateinfo_spell` VALUES ('2', '3', '1180', 'Daggers');
INSERT INTO `playercreateinfo_spell` VALUES ('2', '3', '266', 'Guns');
INSERT INTO `playercreateinfo_spell` VALUES ('2', '3', '15590', 'First Weapons');
INSERT INTO `playercreateinfo_spell` VALUES ('2', '3', '200', 'Polearms ');
INSERT INTO `playercreateinfo_spell` VALUES ('2', '3', '227', 'Staves');
INSERT INTO `playercreateinfo_spell` VALUES ('2', '3', '2567', 'Throw');
INSERT INTO `playercreateinfo_spell` VALUES ('2', '3', '197', 'Two-Handed Axes');
INSERT INTO `playercreateinfo_spell` VALUES ('2', '3', '202', 'Two-Handed Swords');
INSERT INTO `playercreateinfo_spell` VALUES ('2', '3', '75', 'Auto Shot');
INSERT INTO `playercreateinfo_spell` VALUES ('2', '3', '81', 'Dodge');
INSERT INTO `playercreateinfo_spell` VALUES ('2', '3', '196', 'One-Handed Axes');
INSERT INTO `playercreateinfo_spell` VALUES ('2', '3', '203', 'Unarmed');
INSERT INTO `playercreateinfo_spell` VALUES ('2', '3', '204', 'Defense');
INSERT INTO `playercreateinfo_spell` VALUES ('2', '3', '264', 'Bows');
INSERT INTO `playercreateinfo_spell` VALUES ('2', '3', '522', 'SPELLDEFENSE (DND)');
INSERT INTO `playercreateinfo_spell` VALUES ('2', '3', '669', 'Language Orcish');
INSERT INTO `playercreateinfo_spell` VALUES ('2', '3', '1843', 'Disarm');
INSERT INTO `playercreateinfo_spell` VALUES ('2', '3', '2382', 'Generic');
INSERT INTO `playercreateinfo_spell` VALUES ('2', '3', '2479', 'Honorless Target');
INSERT INTO `playercreateinfo_spell` VALUES ('2', '3', '3050', 'Detect');
INSERT INTO `playercreateinfo_spell` VALUES ('2', '3', '3365', 'Opening');
INSERT INTO `playercreateinfo_spell` VALUES ('2', '3', '6233', 'Closing');
INSERT INTO `playercreateinfo_spell` VALUES ('2', '3', '6246', 'Closing');
INSERT INTO `playercreateinfo_spell` VALUES ('2', '3', '6247', 'Opening');
INSERT INTO `playercreateinfo_spell` VALUES ('2', '3', '6477', 'Opening');
INSERT INTO `playercreateinfo_spell` VALUES ('2', '3', '6478', 'Opening');
INSERT INTO `playercreateinfo_spell` VALUES ('2', '3', '6603', 'Attack');
INSERT INTO `playercreateinfo_spell` VALUES ('2', '3', '7266', 'Duel');
INSERT INTO `playercreateinfo_spell` VALUES ('2', '3', '7267', 'Grovel');
INSERT INTO `playercreateinfo_spell` VALUES ('2', '3', '7355', 'Stuck');
INSERT INTO `playercreateinfo_spell` VALUES ('2', '3', '8386', 'Attacking');
INSERT INTO `playercreateinfo_spell` VALUES ('2', '3', '9077', 'Leather');
INSERT INTO `playercreateinfo_spell` VALUES ('2', '3', '9078', 'Cloth');
INSERT INTO `playercreateinfo_spell` VALUES ('2', '3', '9125', 'Generic');
INSERT INTO `playercreateinfo_spell` VALUES ('2', '3', '13358', 'Defensive State (DND)');
INSERT INTO `playercreateinfo_spell` VALUES ('2', '3', '20572', 'Blood Fury');
INSERT INTO `playercreateinfo_spell` VALUES ('2', '3', '20573', 'Hardiness');
INSERT INTO `playercreateinfo_spell` VALUES ('2', '3', '20574', 'Axe Specialization');
INSERT INTO `playercreateinfo_spell` VALUES ('2', '3', '20576', 'Command');
INSERT INTO `playercreateinfo_spell` VALUES ('2', '3', '21651', 'Opening');
INSERT INTO `playercreateinfo_spell` VALUES ('2', '3', '21652', 'Closing');
INSERT INTO `playercreateinfo_spell` VALUES ('2', '3', '22027', 'Remove Insignia');
INSERT INTO `playercreateinfo_spell` VALUES ('2', '3', '22810', 'Opening - No Text');
INSERT INTO `playercreateinfo_spell` VALUES ('2', '3', '24949', 'Defensive State 2 (DND)');
INSERT INTO `playercreateinfo_spell` VALUES ('2', '3', '34082', 'Advantaged State (DND)');
INSERT INTO `playercreateinfo_spell` VALUES ('2', '3', '45927', 'Summon Friend');
INSERT INTO `playercreateinfo_spell` VALUES ('2', '3', '61437', 'Opening');
INSERT INTO `playercreateinfo_spell` VALUES ('2', '4', '266', 'Guns');
INSERT INTO `playercreateinfo_spell` VALUES ('2', '4', '15590', 'First Weapons');
INSERT INTO `playercreateinfo_spell` VALUES ('2', '4', '264', 'Bows');
INSERT INTO `playercreateinfo_spell` VALUES ('2', '4', '5011', 'Crossbows');
INSERT INTO `playercreateinfo_spell` VALUES ('2', '4', '198', 'One-Handed Maces');
INSERT INTO `playercreateinfo_spell` VALUES ('2', '4', '201', 'One-Handed Swords');
INSERT INTO `playercreateinfo_spell` VALUES ('2', '4', '81', 'Dodge');
INSERT INTO `playercreateinfo_spell` VALUES ('2', '4', '203', 'Unarmed');
INSERT INTO `playercreateinfo_spell` VALUES ('2', '4', '204', 'Defense');
INSERT INTO `playercreateinfo_spell` VALUES ('2', '4', '522', 'SPELLDEFENSE (DND)');
INSERT INTO `playercreateinfo_spell` VALUES ('2', '4', '669', 'Language Orcish');
INSERT INTO `playercreateinfo_spell` VALUES ('2', '4', '1180', 'Daggers');
INSERT INTO `playercreateinfo_spell` VALUES ('2', '4', '1843', 'Disarm');
INSERT INTO `playercreateinfo_spell` VALUES ('2', '4', '2382', 'Generic');
INSERT INTO `playercreateinfo_spell` VALUES ('2', '4', '2479', 'Honorless Target');
INSERT INTO `playercreateinfo_spell` VALUES ('2', '4', '2567', 'Thrown');
INSERT INTO `playercreateinfo_spell` VALUES ('2', '4', '2764', 'Throw');
INSERT INTO `playercreateinfo_spell` VALUES ('2', '4', '3050', 'Detect');
INSERT INTO `playercreateinfo_spell` VALUES ('2', '4', '3365', 'Opening');
INSERT INTO `playercreateinfo_spell` VALUES ('2', '4', '6233', 'Closing');
INSERT INTO `playercreateinfo_spell` VALUES ('2', '4', '6246', 'Closing');
INSERT INTO `playercreateinfo_spell` VALUES ('2', '4', '6247', 'Opening');
INSERT INTO `playercreateinfo_spell` VALUES ('2', '4', '6477', 'Opening');
INSERT INTO `playercreateinfo_spell` VALUES ('2', '4', '6478', 'Opening');
INSERT INTO `playercreateinfo_spell` VALUES ('2', '4', '6603', 'Attack');
INSERT INTO `playercreateinfo_spell` VALUES ('2', '4', '7266', 'Duel');
INSERT INTO `playercreateinfo_spell` VALUES ('2', '4', '7267', 'Grovel');
INSERT INTO `playercreateinfo_spell` VALUES ('2', '4', '7355', 'Stuck');
INSERT INTO `playercreateinfo_spell` VALUES ('2', '4', '8386', 'Attacking');
INSERT INTO `playercreateinfo_spell` VALUES ('2', '4', '9077', 'Leather');
INSERT INTO `playercreateinfo_spell` VALUES ('2', '4', '9078', 'Cloth');
INSERT INTO `playercreateinfo_spell` VALUES ('2', '4', '9125', 'Generic');
INSERT INTO `playercreateinfo_spell` VALUES ('2', '4', '16092', 'Defensive State (DND)');
INSERT INTO `playercreateinfo_spell` VALUES ('2', '4', '20572', 'Blood Fury');
INSERT INTO `playercreateinfo_spell` VALUES ('2', '4', '20573', 'Hardiness');
INSERT INTO `playercreateinfo_spell` VALUES ('2', '4', '20574', 'Axe Specialization');
INSERT INTO `playercreateinfo_spell` VALUES ('2', '4', '21184', 'Rogue Passive (DND)');
INSERT INTO `playercreateinfo_spell` VALUES ('2', '4', '21563', 'Command');
INSERT INTO `playercreateinfo_spell` VALUES ('2', '4', '21651', 'Opening');
INSERT INTO `playercreateinfo_spell` VALUES ('2', '4', '21652', 'Closing');
INSERT INTO `playercreateinfo_spell` VALUES ('2', '4', '22027', 'Remove Insignia');
INSERT INTO `playercreateinfo_spell` VALUES ('2', '4', '22810', 'Opening - No Text');
INSERT INTO `playercreateinfo_spell` VALUES ('2', '4', '45927', 'Summon Friend');
INSERT INTO `playercreateinfo_spell` VALUES ('2', '4', '61437', 'Opening');
INSERT INTO `playercreateinfo_spell` VALUES ('2', '6', '81', 'Dodge');
INSERT INTO `playercreateinfo_spell` VALUES ('2', '6', '196', 'One-Handed Axes');
INSERT INTO `playercreateinfo_spell` VALUES ('2', '6', '197', 'Two-Handed Axes');
INSERT INTO `playercreateinfo_spell` VALUES ('2', '6', '200', 'Polearms');
INSERT INTO `playercreateinfo_spell` VALUES ('2', '6', '201', 'One-Handed Swords');
INSERT INTO `playercreateinfo_spell` VALUES ('2', '6', '202', 'Two-Handed Swords');
INSERT INTO `playercreateinfo_spell` VALUES ('2', '6', '203', 'Unarmed');
INSERT INTO `playercreateinfo_spell` VALUES ('2', '6', '204', 'Defense');
INSERT INTO `playercreateinfo_spell` VALUES ('2', '6', '522', 'SPELLDEFENSE (DND)');
INSERT INTO `playercreateinfo_spell` VALUES ('2', '6', '669', 'Language Orcish');
INSERT INTO `playercreateinfo_spell` VALUES ('2', '6', '674', 'Dual Wield');
INSERT INTO `playercreateinfo_spell` VALUES ('2', '6', '750', 'Plate Mail');
INSERT INTO `playercreateinfo_spell` VALUES ('2', '6', '1843', 'Disarm');
INSERT INTO `playercreateinfo_spell` VALUES ('2', '6', '2382', 'Generic');
INSERT INTO `playercreateinfo_spell` VALUES ('2', '6', '2479', 'Honorless Target');
INSERT INTO `playercreateinfo_spell` VALUES ('2', '6', '3050', 'Detect');
INSERT INTO `playercreateinfo_spell` VALUES ('2', '6', '3127', 'Parry');
INSERT INTO `playercreateinfo_spell` VALUES ('2', '6', '3275', 'Linen Bandage');
INSERT INTO `playercreateinfo_spell` VALUES ('2', '6', '3276', 'Heavy Linen Bandage');
INSERT INTO `playercreateinfo_spell` VALUES ('2', '6', '3277', 'Wool Bandage');
INSERT INTO `playercreateinfo_spell` VALUES ('2', '6', '3278', 'Heavy Wool Bandage');
INSERT INTO `playercreateinfo_spell` VALUES ('2', '6', '3365', 'Opening');
INSERT INTO `playercreateinfo_spell` VALUES ('2', '6', '6233', 'Closing');
INSERT INTO `playercreateinfo_spell` VALUES ('2', '6', '6246', 'Closing');
INSERT INTO `playercreateinfo_spell` VALUES ('2', '6', '6247', 'Opening');
INSERT INTO `playercreateinfo_spell` VALUES ('2', '6', '6477', 'Opening');
INSERT INTO `playercreateinfo_spell` VALUES ('2', '6', '6478', 'Opening');
INSERT INTO `playercreateinfo_spell` VALUES ('2', '6', '6603', 'Attack');
INSERT INTO `playercreateinfo_spell` VALUES ('2', '6', '7266', 'Duel');
INSERT INTO `playercreateinfo_spell` VALUES ('2', '6', '7267', 'Grovel');
INSERT INTO `playercreateinfo_spell` VALUES ('2', '6', '7355', 'Stuck');
INSERT INTO `playercreateinfo_spell` VALUES ('2', '6', '7928', 'Silk Bandage');
INSERT INTO `playercreateinfo_spell` VALUES ('2', '6', '7929', 'Heavy Silk Bandage');
INSERT INTO `playercreateinfo_spell` VALUES ('2', '6', '7934', 'Anti-Venom');
INSERT INTO `playercreateinfo_spell` VALUES ('2', '6', '8386', 'Attacking');
INSERT INTO `playercreateinfo_spell` VALUES ('2', '6', '8737', 'Mail');
INSERT INTO `playercreateinfo_spell` VALUES ('2', '6', '9077', 'Leather');
INSERT INTO `playercreateinfo_spell` VALUES ('2', '6', '9078', 'Cloth');
INSERT INTO `playercreateinfo_spell` VALUES ('2', '6', '9125', 'Generic');
INSERT INTO `playercreateinfo_spell` VALUES ('2', '6', '10840', 'Mageweave Bandage');
INSERT INTO `playercreateinfo_spell` VALUES ('2', '6', '10841', 'Heavy Mageweave Bandage');
INSERT INTO `playercreateinfo_spell` VALUES ('2', '6', '10846', 'First Aid');
INSERT INTO `playercreateinfo_spell` VALUES ('2', '6', '18629', 'Runecloth Bandage');
INSERT INTO `playercreateinfo_spell` VALUES ('2', '6', '18630', 'Heavy Runecloth Bandage');
INSERT INTO `playercreateinfo_spell` VALUES ('2', '6', '20572', 'Blood Fury');
INSERT INTO `playercreateinfo_spell` VALUES ('2', '6', '20573', 'Hardiness');
INSERT INTO `playercreateinfo_spell` VALUES ('2', '6', '20574', 'Axe Specialization');
INSERT INTO `playercreateinfo_spell` VALUES ('2', '6', '21651', 'Opening');
INSERT INTO `playercreateinfo_spell` VALUES ('2', '6', '21652', 'Closing');
INSERT INTO `playercreateinfo_spell` VALUES ('2', '6', '22027', 'Remove Insignia');
INSERT INTO `playercreateinfo_spell` VALUES ('2', '6', '22810', 'Opening - No Text');
INSERT INTO `playercreateinfo_spell` VALUES ('2', '6', '33391', 'Journeyman Riding');
INSERT INTO `playercreateinfo_spell` VALUES ('2', '6', '45462', 'Plague Strike');
INSERT INTO `playercreateinfo_spell` VALUES ('2', '6', '45477', 'Icy Touch');
INSERT INTO `playercreateinfo_spell` VALUES ('2', '6', '45902', 'Blood Strike');
INSERT INTO `playercreateinfo_spell` VALUES ('2', '6', '45903', 'Offensive State (DND)');
INSERT INTO `playercreateinfo_spell` VALUES ('2', '6', '45927', 'Summon Friend');
INSERT INTO `playercreateinfo_spell` VALUES ('2', '6', '47541', 'Death Coil');
INSERT INTO `playercreateinfo_spell` VALUES ('2', '6', '48266', 'Blood Presence');
INSERT INTO `playercreateinfo_spell` VALUES ('2', '6', '49410', 'Forceful Deflection');
INSERT INTO `playercreateinfo_spell` VALUES ('2', '6', '49576', 'Death Grip');
INSERT INTO `playercreateinfo_spell` VALUES ('2', '6', '52665', 'Sigil');
INSERT INTO `playercreateinfo_spell` VALUES ('2', '6', '54562', 'Command');
INSERT INTO `playercreateinfo_spell` VALUES ('2', '6', '59879', 'Blood Plague');
INSERT INTO `playercreateinfo_spell` VALUES ('2', '6', '59921', 'Frost Fever');
INSERT INTO `playercreateinfo_spell` VALUES ('2', '6', '61437', 'Opening');
INSERT INTO `playercreateinfo_spell` VALUES ('2', '6', '61455', 'Runic Focus');
INSERT INTO `playercreateinfo_spell` VALUES ('2', '7', '197', 'Two-Handed Axes');
INSERT INTO `playercreateinfo_spell` VALUES ('2', '7', '196', 'One-Handed Axes');
INSERT INTO `playercreateinfo_spell` VALUES ('2', '7', '1180', 'Daggers');
INSERT INTO `playercreateinfo_spell` VALUES ('2', '7', '15590', 'First Weapons');
INSERT INTO `playercreateinfo_spell` VALUES ('2', '7', '199', 'Two-Handed Maces');
INSERT INTO `playercreateinfo_spell` VALUES ('2', '7', '81', 'Dodge');
INSERT INTO `playercreateinfo_spell` VALUES ('2', '7', '107', 'Block');
INSERT INTO `playercreateinfo_spell` VALUES ('2', '7', '198', 'One-Handed Maces');
INSERT INTO `playercreateinfo_spell` VALUES ('2', '7', '203', 'Unarmed');
INSERT INTO `playercreateinfo_spell` VALUES ('2', '7', '204', 'Defense');
INSERT INTO `playercreateinfo_spell` VALUES ('2', '7', '227', 'Staves');
INSERT INTO `playercreateinfo_spell` VALUES ('2', '7', '522', 'SPELLDEFENSE (DND)');
INSERT INTO `playercreateinfo_spell` VALUES ('2', '7', '669', 'Language Orcish');
INSERT INTO `playercreateinfo_spell` VALUES ('2', '7', '1843', 'Disarm');
INSERT INTO `playercreateinfo_spell` VALUES ('2', '7', '2382', 'Generic');
INSERT INTO `playercreateinfo_spell` VALUES ('2', '7', '2479', 'Honorless Target');
INSERT INTO `playercreateinfo_spell` VALUES ('2', '7', '3050', 'Detect');
INSERT INTO `playercreateinfo_spell` VALUES ('2', '7', '3365', 'Opening');
INSERT INTO `playercreateinfo_spell` VALUES ('2', '7', '6233', 'Closing');
INSERT INTO `playercreateinfo_spell` VALUES ('2', '7', '6246', 'Closing');
INSERT INTO `playercreateinfo_spell` VALUES ('2', '7', '6247', 'Opening');
INSERT INTO `playercreateinfo_spell` VALUES ('2', '7', '6477', 'Opening');
INSERT INTO `playercreateinfo_spell` VALUES ('2', '7', '6478', 'Opening');
INSERT INTO `playercreateinfo_spell` VALUES ('2', '7', '6603', 'Attack');
INSERT INTO `playercreateinfo_spell` VALUES ('2', '7', '7266', 'Duel');
INSERT INTO `playercreateinfo_spell` VALUES ('2', '7', '7267', 'Grovel');
INSERT INTO `playercreateinfo_spell` VALUES ('2', '7', '7355', 'Stuck');
INSERT INTO `playercreateinfo_spell` VALUES ('2', '7', '8386', 'Attacking');
INSERT INTO `playercreateinfo_spell` VALUES ('2', '7', '9077', 'Leather');
INSERT INTO `playercreateinfo_spell` VALUES ('2', '7', '9078', 'Cloth');
INSERT INTO `playercreateinfo_spell` VALUES ('2', '7', '9116', 'Shield');
INSERT INTO `playercreateinfo_spell` VALUES ('2', '7', '9125', 'Generic');
INSERT INTO `playercreateinfo_spell` VALUES ('2', '7', '20573', 'Hardiness');
INSERT INTO `playercreateinfo_spell` VALUES ('2', '7', '20574', 'Axe Specialization');
INSERT INTO `playercreateinfo_spell` VALUES ('2', '7', '21563', 'Command');
INSERT INTO `playercreateinfo_spell` VALUES ('2', '7', '21651', 'Opening');
INSERT INTO `playercreateinfo_spell` VALUES ('2', '7', '21652', 'Closing');
INSERT INTO `playercreateinfo_spell` VALUES ('2', '7', '22027', 'Remove Insignia');
INSERT INTO `playercreateinfo_spell` VALUES ('2', '7', '22810', 'Opening - No Text');
INSERT INTO `playercreateinfo_spell` VALUES ('2', '7', '27763', 'Totem');
INSERT INTO `playercreateinfo_spell` VALUES ('2', '7', '33697', 'Blood Fury');
INSERT INTO `playercreateinfo_spell` VALUES ('2', '7', '45927', 'Summon Friend');
INSERT INTO `playercreateinfo_spell` VALUES ('2', '7', '61437', 'Opening');
INSERT INTO `playercreateinfo_spell` VALUES ('2', '9', '201', 'One-Handed Swords');
INSERT INTO `playercreateinfo_spell` VALUES ('2', '9', '227', 'Staves');
INSERT INTO `playercreateinfo_spell` VALUES ('2', '9', '81', 'Dodge');
INSERT INTO `playercreateinfo_spell` VALUES ('2', '9', '203', 'Unarmed');
INSERT INTO `playercreateinfo_spell` VALUES ('2', '9', '204', 'Defense');
INSERT INTO `playercreateinfo_spell` VALUES ('2', '9', '522', 'SPELLDEFENSE (DND)');
INSERT INTO `playercreateinfo_spell` VALUES ('2', '9', '669', 'Language Orcish');
INSERT INTO `playercreateinfo_spell` VALUES ('2', '9', '1180', 'Daggers');
INSERT INTO `playercreateinfo_spell` VALUES ('2', '9', '1843', 'Disarm');
INSERT INTO `playercreateinfo_spell` VALUES ('2', '9', '2382', 'Generic');
INSERT INTO `playercreateinfo_spell` VALUES ('2', '9', '2479', 'Honorless Target');
INSERT INTO `playercreateinfo_spell` VALUES ('2', '9', '3050', 'Detect');
INSERT INTO `playercreateinfo_spell` VALUES ('2', '9', '3365', 'Opening');
INSERT INTO `playercreateinfo_spell` VALUES ('2', '9', '5009', 'Wands');
INSERT INTO `playercreateinfo_spell` VALUES ('2', '9', '5019', 'Shoot');
INSERT INTO `playercreateinfo_spell` VALUES ('2', '9', '6233', 'Closing');
INSERT INTO `playercreateinfo_spell` VALUES ('2', '9', '6246', 'Closing');
INSERT INTO `playercreateinfo_spell` VALUES ('2', '9', '6247', 'Opening');
INSERT INTO `playercreateinfo_spell` VALUES ('2', '9', '6477', 'Opening');
INSERT INTO `playercreateinfo_spell` VALUES ('2', '9', '6478', 'Opening');
INSERT INTO `playercreateinfo_spell` VALUES ('2', '9', '6603', 'Attack');
INSERT INTO `playercreateinfo_spell` VALUES ('2', '9', '7266', 'Duel');
INSERT INTO `playercreateinfo_spell` VALUES ('2', '9', '7267', 'Grovel');
INSERT INTO `playercreateinfo_spell` VALUES ('2', '9', '7355', 'Stuck');
INSERT INTO `playercreateinfo_spell` VALUES ('2', '9', '8386', 'Attacking');
INSERT INTO `playercreateinfo_spell` VALUES ('2', '9', '9078', 'Cloth');
INSERT INTO `playercreateinfo_spell` VALUES ('2', '9', '9125', 'Generic');
INSERT INTO `playercreateinfo_spell` VALUES ('2', '9', '20573', 'Hardiness');
INSERT INTO `playercreateinfo_spell` VALUES ('2', '9', '20574', 'Axe Specialization');
INSERT INTO `playercreateinfo_spell` VALUES ('2', '9', '20575', 'Command');
INSERT INTO `playercreateinfo_spell` VALUES ('2', '9', '21651', 'Opening');
INSERT INTO `playercreateinfo_spell` VALUES ('2', '9', '21652', 'Closing');
INSERT INTO `playercreateinfo_spell` VALUES ('2', '9', '22027', 'Remove Insignia');
INSERT INTO `playercreateinfo_spell` VALUES ('2', '9', '22810', 'Opening - No Text');
INSERT INTO `playercreateinfo_spell` VALUES ('2', '9', '33702', 'Blood Fury');
INSERT INTO `playercreateinfo_spell` VALUES ('2', '9', '45927', 'Summon Friend');
INSERT INTO `playercreateinfo_spell` VALUES ('2', '9', '58284', 'Chaos Bolt Passive');
INSERT INTO `playercreateinfo_spell` VALUES ('2', '9', '61437', 'Opening');
INSERT INTO `playercreateinfo_spell` VALUES ('3', '1', '81', 'Dodge');
INSERT INTO `playercreateinfo_spell` VALUES ('3', '1', '107', 'Block');
INSERT INTO `playercreateinfo_spell` VALUES ('3', '1', '15590', 'First Weapons');
INSERT INTO `playercreateinfo_spell` VALUES ('3', '1', '200', 'Polearms');
INSERT INTO `playercreateinfo_spell` VALUES ('3', '1', '2567', 'Throw');
INSERT INTO `playercreateinfo_spell` VALUES ('3', '1', '199', 'Two-Handed Maces');
INSERT INTO `playercreateinfo_spell` VALUES ('3', '1', '202', 'Two-Handed Swords');
INSERT INTO `playercreateinfo_spell` VALUES ('3', '1', '264', 'Bows');
INSERT INTO `playercreateinfo_spell` VALUES ('3', '1', '5011', 'Crossbows');
INSERT INTO `playercreateinfo_spell` VALUES ('3', '1', '266', 'Guns');
INSERT INTO `playercreateinfo_spell` VALUES ('3', '1', '1180', 'Daggers');
INSERT INTO `playercreateinfo_spell` VALUES ('3', '1', '201', 'One-Handed Swords');
INSERT INTO `playercreateinfo_spell` VALUES ('3', '1', '227', 'Staves');
INSERT INTO `playercreateinfo_spell` VALUES ('3', '1', '196', 'One-Handed Axes');
INSERT INTO `playercreateinfo_spell` VALUES ('3', '1', '197', 'Two-Handed Axes');
INSERT INTO `playercreateinfo_spell` VALUES ('3', '1', '198', 'One-Handed Maces');
INSERT INTO `playercreateinfo_spell` VALUES ('3', '1', '203', 'Unarmed');
INSERT INTO `playercreateinfo_spell` VALUES ('3', '1', '204', 'Defense');
INSERT INTO `playercreateinfo_spell` VALUES ('3', '1', '522', 'SPELLDEFENSE (DND)');
INSERT INTO `playercreateinfo_spell` VALUES ('3', '1', '668', 'Language Common');
INSERT INTO `playercreateinfo_spell` VALUES ('3', '1', '672', 'Language Dwarven');
INSERT INTO `playercreateinfo_spell` VALUES ('3', '1', '1843', 'Disarm');
INSERT INTO `playercreateinfo_spell` VALUES ('3', '1', '2382', 'Generic');
INSERT INTO `playercreateinfo_spell` VALUES ('3', '1', '2457', 'Battle Stance');
INSERT INTO `playercreateinfo_spell` VALUES ('3', '1', '2479', 'Honorless Target');
INSERT INTO `playercreateinfo_spell` VALUES ('3', '1', '2481', 'Find Treasure');
INSERT INTO `playercreateinfo_spell` VALUES ('3', '1', '3050', 'Detect');
INSERT INTO `playercreateinfo_spell` VALUES ('3', '1', '3365', 'Opening');
INSERT INTO `playercreateinfo_spell` VALUES ('3', '1', '5301', 'Defensive State (DND)');
INSERT INTO `playercreateinfo_spell` VALUES ('3', '1', '6233', 'Closing');
INSERT INTO `playercreateinfo_spell` VALUES ('3', '1', '6246', 'Closing');
INSERT INTO `playercreateinfo_spell` VALUES ('3', '1', '6247', 'Opening');
INSERT INTO `playercreateinfo_spell` VALUES ('3', '1', '6477', 'Opening');
INSERT INTO `playercreateinfo_spell` VALUES ('3', '1', '6478', 'Opening');
INSERT INTO `playercreateinfo_spell` VALUES ('3', '1', '6603', 'Attack');
INSERT INTO `playercreateinfo_spell` VALUES ('3', '1', '7266', 'Duel');
INSERT INTO `playercreateinfo_spell` VALUES ('3', '1', '7267', 'Grovel');
INSERT INTO `playercreateinfo_spell` VALUES ('3', '1', '7355', 'Stuck');
INSERT INTO `playercreateinfo_spell` VALUES ('3', '1', '8386', 'Attacking');
INSERT INTO `playercreateinfo_spell` VALUES ('3', '1', '8737', 'Mail');
INSERT INTO `playercreateinfo_spell` VALUES ('3', '1', '9077', 'Leather');
INSERT INTO `playercreateinfo_spell` VALUES ('3', '1', '9078', 'Cloth');
INSERT INTO `playercreateinfo_spell` VALUES ('3', '1', '9116', 'Shield');
INSERT INTO `playercreateinfo_spell` VALUES ('3', '1', '9125', 'Generic');
INSERT INTO `playercreateinfo_spell` VALUES ('3', '1', '20594', 'Stoneform');
INSERT INTO `playercreateinfo_spell` VALUES ('3', '1', '20595', 'Gun Specialization');
INSERT INTO `playercreateinfo_spell` VALUES ('3', '1', '20596', 'Frost Resistance');
INSERT INTO `playercreateinfo_spell` VALUES ('3', '1', '21651', 'Opening');
INSERT INTO `playercreateinfo_spell` VALUES ('3', '1', '21652', 'Closing');
INSERT INTO `playercreateinfo_spell` VALUES ('3', '1', '22027', 'Remove Insignia');
INSERT INTO `playercreateinfo_spell` VALUES ('3', '1', '22810', 'Opening - No Text');
INSERT INTO `playercreateinfo_spell` VALUES ('3', '1', '32215', 'Victorious State');
INSERT INTO `playercreateinfo_spell` VALUES ('3', '1', '45927', 'Summon Friend');
INSERT INTO `playercreateinfo_spell` VALUES ('3', '1', '59224', 'Mace Specialization');
INSERT INTO `playercreateinfo_spell` VALUES ('3', '1', '61437', 'Opening');
INSERT INTO `playercreateinfo_spell` VALUES ('3', '2', '197', 'Two-Handed Axes');
INSERT INTO `playercreateinfo_spell` VALUES ('3', '2', '202', 'Two-Handed Swords');
INSERT INTO `playercreateinfo_spell` VALUES ('3', '2', '196', 'One-Handed Axes');
INSERT INTO `playercreateinfo_spell` VALUES ('3', '2', '201', 'One-Handed Swords');
INSERT INTO `playercreateinfo_spell` VALUES ('3', '2', '200', 'Polearms');
INSERT INTO `playercreateinfo_spell` VALUES ('3', '2', '81', 'Dodge');
INSERT INTO `playercreateinfo_spell` VALUES ('3', '2', '107', 'Block');
INSERT INTO `playercreateinfo_spell` VALUES ('3', '2', '198', 'One-Handed Maces');
INSERT INTO `playercreateinfo_spell` VALUES ('3', '2', '199', 'Two-Handed Maces');
INSERT INTO `playercreateinfo_spell` VALUES ('3', '2', '203', 'Unarmed');
INSERT INTO `playercreateinfo_spell` VALUES ('3', '2', '204', 'Defense');
INSERT INTO `playercreateinfo_spell` VALUES ('3', '2', '522', 'SPELLDEFENSE (DND)');
INSERT INTO `playercreateinfo_spell` VALUES ('3', '2', '668', 'Language Common');
INSERT INTO `playercreateinfo_spell` VALUES ('3', '2', '672', 'Language Dwarven');
INSERT INTO `playercreateinfo_spell` VALUES ('3', '2', '1843', 'Disarm');
INSERT INTO `playercreateinfo_spell` VALUES ('3', '2', '2382', 'Generic');
INSERT INTO `playercreateinfo_spell` VALUES ('3', '2', '2479', 'Honorless Target');
INSERT INTO `playercreateinfo_spell` VALUES ('3', '2', '2481', 'Find Treasure');
INSERT INTO `playercreateinfo_spell` VALUES ('3', '2', '3050', 'Detect');
INSERT INTO `playercreateinfo_spell` VALUES ('3', '2', '3365', 'Opening');
INSERT INTO `playercreateinfo_spell` VALUES ('3', '2', '6233', 'Closing');
INSERT INTO `playercreateinfo_spell` VALUES ('3', '2', '6246', 'Closing');
INSERT INTO `playercreateinfo_spell` VALUES ('3', '2', '6247', 'Opening');
INSERT INTO `playercreateinfo_spell` VALUES ('3', '2', '6477', 'Opening');
INSERT INTO `playercreateinfo_spell` VALUES ('3', '2', '6478', 'Opening');
INSERT INTO `playercreateinfo_spell` VALUES ('3', '2', '6603', 'Attack');
INSERT INTO `playercreateinfo_spell` VALUES ('3', '2', '7266', 'Duel');
INSERT INTO `playercreateinfo_spell` VALUES ('3', '2', '7267', 'Grovel');
INSERT INTO `playercreateinfo_spell` VALUES ('3', '2', '7355', 'Stuck');
INSERT INTO `playercreateinfo_spell` VALUES ('3', '2', '8386', 'Attacking');
INSERT INTO `playercreateinfo_spell` VALUES ('3', '2', '8737', 'Mail');
INSERT INTO `playercreateinfo_spell` VALUES ('3', '2', '9077', 'Leather');
INSERT INTO `playercreateinfo_spell` VALUES ('3', '2', '9078', 'Cloth');
INSERT INTO `playercreateinfo_spell` VALUES ('3', '2', '9116', 'Shield');
INSERT INTO `playercreateinfo_spell` VALUES ('3', '2', '9125', 'Generic');
INSERT INTO `playercreateinfo_spell` VALUES ('3', '2', '20594', 'Stoneform');
INSERT INTO `playercreateinfo_spell` VALUES ('3', '2', '20595', 'Gun Specialization');
INSERT INTO `playercreateinfo_spell` VALUES ('3', '2', '20596', 'Frost Resistance');
INSERT INTO `playercreateinfo_spell` VALUES ('3', '2', '21651', 'Opening');
INSERT INTO `playercreateinfo_spell` VALUES ('3', '2', '21652', 'Closing');
INSERT INTO `playercreateinfo_spell` VALUES ('3', '2', '22027', 'Remove Insignia');
INSERT INTO `playercreateinfo_spell` VALUES ('3', '2', '22810', 'Opening - No Text');
INSERT INTO `playercreateinfo_spell` VALUES ('3', '2', '27762', 'Libram');
INSERT INTO `playercreateinfo_spell` VALUES ('3', '2', '45927', 'Summon Friend')...
Больше не могу...©
Поиск
Ответ
JanusLee Не в сети
Banned
Сообщений: 268
Тем: 1
Зарегистрирован: Jun 2009
#5
07-11-2009, 10:47 PM
Есть вопрос ! А как зделать наоборот ??? Я вот подумал у меня есть 2 базы , 313 и 309 что если я из 309(нормальное расположение стартовых локация) перекопирую в 313(Fun by Kiberk) у меня получиться ??? :pare:
Поиск
Ответ


Возможно похожие темы ...
Тема Автор Ответы Просмотры Последний пост
  Как сделать Чтоб появлялись в своих городах все рассы, а не в одном городе!! Franklin 4 2,382 09-18-2011, 06:26 PM
Последний пост: Franklin
  Как сделать рейты?(В теме посмотрите вопрос) woloss 12 8,031 02-24-2010, 11:37 AM
Последний пост: VoltVolt
  Надо кач 50х сделать)) kassdffas 3 2,683 01-17-2010, 11:38 PM
Последний пост: Perfecto
  Как сделать игрока враждебным ? Чешипузик 7 3,894 12-25-2009, 04:10 PM
Последний пост: Чешипузик
  Как сделать чтобы игроки стартовали с максимум скилами оружия дефенса и т.д Lifevagon 3 3,527 09-04-2009, 08:36 AM
Последний пост: Lifevagon
  Как сделать накат на базу аков и персонажей??? Tecktonik 12 5,757 08-08-2009, 01:44 PM
Последний пост: PuShKinG
  Народ плиз помогите как сделать АукБот на своём сервере 3.0.9 Goordes 3 25,377 07-30-2009, 08:04 PM
Последний пост: Goordes
  Как сделать Dump базы? MooN 2 2,701 06-13-2009, 12:04 PM
Последний пост: PuShKinG
  Как лучше сделать? StGhost 0 1,885 04-16-2009, 12:39 PM
Последний пост: StGhost
  Как сделать себя админом в WOW Anegin 2 19,085 01-18-2009, 08:23 PM
Последний пост: virus

Перейти к форуму:


Пользователи, просматривающие эту тему: 1 Гость(ей)