Вход | Регистрация | Обратная свзяь
23.10.2018 | 08:22
[ Новые сообщения · Участники · Правила форума · Поиск · RSS ]
  • Страница 1 из 2
  • 1
  • 2
  • »
Форум L2edit.Ru » Lineage 2 » Раздел для новичков » Самые нужные SQL запросы в Lineage 2
Самые нужные SQL запросы в Lineage 2
ОвощДата: Суббота, 10.07.2010, 22:20 | Сообщение # 1
Овощ
Группа: Администратор
Сообщений: 2494
Награды: 162
Репутация: 5547
Статус: Offline
Описание идёт сверху запроса.

Выкладывать только запросы, не фулдить!

Итемы/броня/оружие весит 0

Code
UPDATE `etcitem` SET `weight`=0 WHERE (SELECT item_id);
UPDATE `armor` SET `weight`=0 WHERE (SELECT item_id);
UPDATE `weapon` SET `weight`=0 WHERE (SELECT item_id);

Дроп адены 100%

Code
UPDATE `droplist` SET `chance`='1000000' WHERE `itemId`='57';

Продажа всего по 0 адены (в магазин)

Code
UPDATE `armor` SET price=0 where price > 1;
UPDATE `etcitem` SET price=0 where price > 1;
UPDATE `weapon` SET price=0 where price > 1;

У РБ будет 5к хп

Code
UPDATE `npc` SET `hp`='5000000' WHERE (SELECT id) AND npc.type='L2Raidboss';

Удалить всех мобов ниже 40 лвла

Code
DELETE spawnlist, npc FROM spawnlist, npc WHERE spawnlist.npc_templateid=npc.idTemplate AND npc.level<40 AND npc.type='L2Monster';

Удалить все материалы и рецепты нах из БД

Code
DELETE FROM droplist WHERE itemid IN (SELECT item_id FROM etcitem WHERE item_type= 'material' OR item_type= 'recipe' );

Назначить шанс выпадения рецептов

Code
UPDATE droplist SET chance='1000000' WHERE id IN (SELECT item_id FROM etcitem WHERE type='recipe');

Удалить все аккаунты и персонажей, которые не соизволили появиться в игре в течении 3 месяцев

Code
DELETE FROM characters WHERE lastAccess < 466560000;            
DELETE FROM accounts WHERE lastactive < 466560000;

Замутить во всех мобов дроп колов

Code
insert into droplist (mobId, itemid, chance, min, max,category) select id, 4037, 1000000, 1, 1, 52 from npc where type='L2Monster';

При создании персонажа, он будет в топ НГ

Code
REPLACE INTO char_templates VALUES (0, 'Human Fighter', 0, 40, 43, 30, 21, 11, 25, 4, 72, 3, 47, 330, 213, 33, 44, 33, 115, 81900, -71338, 258271, -3104, 0, '1.1', '1.188', 9, 23, '1.1', '1.188', 8, '23.5', 34, 26, 68, 4222, 5588);
REPLACE INTO char_templates VALUES (18, 'Elf Fighter', 1, 36, 36, 35, 23, 14, 26, 4, 72, 3, 47, 345, 249, 36, 46, 36, 125, 73000, 45978, 41196, -3440, 0, '1.15', '1.242', '7.5', 24, '1.15', '1.242', '7.5', 23, 34, 26, 68, 4222, 5588);
REPLACE INTO char_templates VALUES (31, 'DE Fighter', 2, 41, 32, 34, 25, 12, 26, 4, 72, 3, 47, 342, 226, 35, 45, 35, 122, 69000, 28377, 10916, -4224, 0, '1.14', '1.2312', '7.5', 24, '1.14', '1.2312', 7, '23.5', 34, 26, 68, 4222, 5588);
REPLACE INTO char_templates VALUES (44,'Orc Fighter', 3, 40, 47, 26, 18, 12, 27, 4, 72, 2, 48, 318, 226, 31, 42, 31, 117, 87000, -58192, -113408, -650, 0, '1.06', '1.144800', 11.0, 28.0 ,1.06, '1.144800', 7.0, 27.0, 34, 26, 257, 0, 5588);
REPLACE INTO char_templates VALUES (53, 'Dwarf Fighter', 4, 39, 45, 29, 20, 10, 27, 4, 72, 3, 48, 327, 203, 33, 43, 33, 115, 83000, 108512, -174026, -400, 1, '1.09', '1.487196', 9, 18, '1.09', '1.487196', 5, 19, 34, 26, 87, 4222, 5588);
REPLACE INTO char_templates VALUES (10, 'Human Mage', 0, 22, 27, 21, 41, 20, 39, 2, 48, 7, 54, 303, 333, 28, 40, 28, 120, 62500, -90890, 248027, -3570, 0, '1.01', '0.87264', '7.5', '22.8', '1.01', '0.87264', '6.5', '22.5', 1105, 1102, 177, 0, 5588);
REPLACE INTO char_templates VALUES (25, 'Elf Mage', 1, 21, 25, 24, 37, 23, 40, 2, 48, 6, 54, 312, 386, 30, 41, 30, 122, 62400, 46182, 41198, -3440, 0, '1.04', '0.89856', '7.5', 24, '1.04', '0.89856', '7.5', 23, 1105, 1102, 177, 0, 5588);
REPLACE INTO char_templates VALUES (38, 'DE Mage', 2, 23, 24, 23, 44, 19, 37, 2, 48, 7, 53, 309, 316, 29, 41, 29, 122, 61000, 28295, 11063, -4224, 0, '1.14', '1.2312', '7.5', 24, '1.03', '0.88992', 7, '23.5', 1105, 1102, 177, 0, 5588);
REPLACE INTO char_templates VALUES (49, 'Orc Mage', 3, 27, 31, 24, 31, 15, 42, 2, 48, 4, 56, 312, 265, 30, 41, 30, 121, 68000, -56682, -113730, -690, 0, '1.04', '0.89856', 7, '27.5', '1.04', '0.89856', 8, '25.5', 1105, 1102, 257, 0, 5588);

Добавить бижу в РБ, если вы удалили её

Code
INSERT INTO droplist VALUES ('29001', '6660', '1', '1', '12', '300000');
INSERT INTO droplist VALUES ('29006', '6662', '1', '1', '8', '300000');
INSERT INTO droplist VALUES ('29014', '6661', '1', '1', '9', '300000');
INSERT INTO droplist VALUES ('29022', '6659', '1', '1', '13', '1000000');
INSERT INTO droplist VALUES ('29020', '6658', '1', '1', '2', '1000000');
INSERT INTO droplist VALUES ('29019', '6656', '1', '1', '31', '1000000');
INSERT INTO droplist VALUES ('29028', '6657', '1', '1', '34', '1000000');

Добавить гвардам 50% П дефа, М дефа, П атаки и ХП

Code
UPDATE npc SET pdef = pdef * 1.5 WHERE type = 'L2Guard';
UPDATE npc SET hp = hp * 1.5 WHERE type = 'L2Guard';
UPDATE npc SET patk = patk * 1.5 WHERE type = 'L2Guard';
UPDATE npc SET mdef = mdef * 1.5 WHERE type = 'L2Guard';

Понизить у РБ П деф, М деф и ХП на 40%

Code
UPDATE npc SET pdef = pdef * 0.6 WHERE type = 'L2RaidBoss';
UPDATE npc SET hp = hp * 0.6 WHERE type = 'L2RaidBoss';
UPDATE npc SET mdef = mdef * 0.6 WHERE type = 'L2RaidBoss';

Увеличить время респауна мобов в 3 раза

Code
UPDATE `spawnlist` SET `respawnDelay` = `respawn_min_delay`*3;          
UPDATE `spawnlist` SET `respawnDelay` = `respawn_max_delay`*3;          
UPDATE `spawnlist` SET `respawnDelay` = `respawnDelay`*3;          
UPDATE `spawnlist` SET `respawnDelay` = `respawnDelay`*3;

Установить время респауна РБ от 1 часа до двух

Code
UPDATE `raidboss_spawnlist` SET `respawn_min_delay` = '3600';          
UPDATE `raidboss_spawnlist` SET `respawn_max_delay` = '7200';

Сделать всех петов сильнее (классная вещь) или сделай себе ручного антараса :v

Code
UPDATE `npc` SET `hp` = `hp` * 1.5 where type='L2Pet';
UPDATE `npc` SET `mp` = `mp` * 1.5 where type='L2Pet';
UPDATE `npc` SET `patk` = `patk` * 1.5 where type='L2Pet';
UPDATE `npc` SET `matk` = `matk` * 1.5 where type='L2Pet';
UPDATE `npc` SET `pdef` = `pdef` * 1.5 where type='L2Pet';
UPDATE `npc` SET `mdef` = `mdef` * 1.5 where type='L2Pet';
UPDATE `npc` SET `runspd` = `runspd` * 1.5 where type='L2Pet';

Удалить все вещи с определённым ID и определённого персонажа

Code
DELETE * FROM items WHERE item_id=(item id) AND owner_id=(character id)

Месторождение чаров в гиране с ТОП шмотом. (Для воинов это - тека и кристал дагер, для магов это - кармиан и хомка)

Code
UPDATE `char_templates` SET `x` = '83400',
`y` = '147943',
`z` = '-3404';
UPDATE `char_templates` SET `items1` = '420',
`items2` = '400',
`items3` = '2436',
`items4` = '6358',
`items5` = '2460' WHERE `char_templates`.`ClassId` =0 LIMIT 1 ;
UPDATE `char_templates` SET `items1` = '420',
`items2` = '400',
`items3` = '2436',
`items4` = '6358',
`items5` = '2460' WHERE `char_templates`.`ClassId` =18 LIMIT 1 ;
UPDATE `char_templates` SET `items1` = '420',
`items2` = '400',
`items3` = '2436',
`items4` = '6358',
`items5` = '2460' WHERE `char_templates`.`ClassId` =31 LIMIT 1 ;
UPDATE `char_templates` SET `items1` = '420',
`items2` = '400',
`items3` = '2436',
`items4` = '6358',
`items5` = '2460' WHERE `char_templates`.`ClassId` =44 LIMIT 1 ;
UPDATE `char_templates` SET `items1` = '420',
`items2` = '400',
`items3` = '2436',
`items4` = '6358',
`items5` = '2460' WHERE `char_templates`.`ClassId` =53 LIMIT 1 ;
UPDATE `char_templates` SET `items1` = '439',
`items2` = '471',
`items3` = '2430',
`items4` = '2454',
`items5` = '6313' WHERE `char_templates`.`ClassId` =10 LIMIT 1 ;
UPDATE `char_templates` SET `items1` = '439',
`items2` = '471',
`items3` = '2430',
`items4` = '2454',
`items5` = '6313' WHERE `char_templates`.`ClassId` =25 LIMIT 1 ;
UPDATE `char_templates` SET `items1` = '439',
`items2` = '471',
`items3` = '2430',
`items4` = '2454',
`items5` = '6313' WHERE `char_templates`.`ClassId` =38 LIMIT 1 ;
UPDATE `char_templates` SET `items1` = '439',
`items2` = '471',
`items3` = '2430',
`items4` = '2454',
`items5` = '6313' WHERE `char_templates`.`ClassId` =49 LIMIT 1 ;

Увеличение в 2 раза таких показателей, как Str,Int,Dex,Wit,Men,Con

Code
UPDATE `char_templates` SET `STR`='80' WHERE (SELECT ClassId) AND (str = '40');          
UPDATE `char_templates` SET `STR`='44' WHERE (SELECT ClassId) AND (str = '22');          
UPDATE `char_templates` SET `STR`='72' WHERE (SELECT ClassId) AND (str = '36');          
UPDATE `char_templates` SET `STR`='42' WHERE (SELECT ClassId) AND (str = '21');          
UPDATE `char_templates` SET `STR`='46' WHERE (SELECT ClassId) AND (str = '23');          
UPDATE `char_templates` SET `STR`='54' WHERE (SELECT ClassId) AND (str = '27');          
UPDATE `char_templates` SET `STR`='78' WHERE (SELECT ClassId) AND (str = '39');          
UPDATE `char_templates` SET `con`='86' WHERE (SELECT ClassId) AND (con = '43');          
UPDATE `char_templates` SET `con`='54' WHERE (SELECT ClassId) AND (con = '27');          
UPDATE `char_templates` SET `con`='72' WHERE (SELECT ClassId) AND (con = '36');          
UPDATE `char_templates` SET `con`='50' WHERE (SELECT ClassId) AND (con = '25');          
UPDATE `char_templates` SET `con`='64' WHERE (SELECT ClassId) AND (con = '32');          
UPDATE `char_templates` SET `con`='48' WHERE (SELECT ClassId) AND (con = '24');          
UPDATE `char_templates` SET `con`='94' WHERE (SELECT ClassId) AND (con = '47');          
UPDATE `char_templates` SET `con`='62' WHERE (SELECT ClassId) AND (con = '31');
UPDATE `char_templates` SET `con`='90' WHERE (SELECT ClassId) AND (con = '45');
UPDATE `char_templates` SET `con`='86' WHERE (SELECT ClassId) AND (con = '43');
UPDATE `char_templates` SET `_int`='42' WHERE (SELECT ClassId) AND (_int = '21');
UPDATE `char_templates` SET `_int`='82' WHERE (SELECT ClassId) AND (_int = '41');
UPDATE `char_templates` SET `_int`='46' WHERE (SELECT ClassId) AND (_int = '23');
UPDATE `char_templates` SET `_int`='74' WHERE (SELECT ClassId) AND (_int = '37');
UPDATE `char_templates` SET `_int`='50' WHERE (SELECT ClassId) AND (_int = '25');
UPDATE `char_templates` SET `_int`='88' WHERE (SELECT ClassId) AND (_int = '44');
UPDATE `char_templates` SET `_int`='36' WHERE (SELECT ClassId) AND (_int = '18');
UPDATE `char_templates` SET `_int`='62' WHERE (SELECT ClassId) AND (_int = '31');
UPDATE `char_templates` SET `_int`='40' WHERE (SELECT ClassId) AND (_int = '20');
UPDATE `char_templates` SET `men`='52' WHERE (SELECT ClassId) AND (men = '26');
UPDATE `char_templates` SET `men`='80' WHERE (SELECT ClassId) AND (men = '40');
UPDATE `char_templates` SET `men`='74' WHERE (SELECT ClassId) AND (men = '37');
UPDATE `char_templates` SET `men`='54' WHERE (SELECT ClassId) AND (men = '27');
UPDATE `char_templates` SET `men`='84' WHERE (SELECT ClassId) AND (men = '42');
UPDATE `char_templates` SET `men`='78' WHERE (SELECT ClassId) AND (men = '39');
UPDATE `char_templates` SET `men`='50' WHERE (SELECT ClassId) AND (men = '25');
UPDATE `char_templates` SET `STR`='80' WHERE (ClassId = '0') AND (str = '40');          
UPDATE `char_templates` SET `con`='86' WHERE (ClassId = '0') AND (con = '43');
UPDATE `char_templates` SET `_int`='42' WHERE (ClassId = '0') AND (_int = '21');
UPDATE `char_templates` SET `dex`='60' WHERE (ClassId = '0') AND (dex = '30');
UPDATE `char_templates` SET `wit`='22' WHERE (ClassId = '0') AND (wit = '11');
UPDATE `char_templates` SET `wit`='22' WHERE (SELECT ClassId) AND (wit = '11');
UPDATE `char_templates` SET `wit`='40' WHERE (SELECT ClassId) AND (wit = '20');
UPDATE `char_templates` SET `wit`='28' WHERE (SELECT ClassId) AND (wit = '14');
UPDATE `char_templates` SET `wit`='46' WHERE (SELECT ClassId) AND (wit = '23');
UPDATE `char_templates` SET `wit`='24' WHERE (SELECT ClassId) AND (wit = '12');
UPDATE `char_templates` SET `wit`='38' WHERE (SELECT ClassId) AND (wit = '19');
UPDATE `char_templates` SET `wit`='30' WHERE (SELECT ClassId) AND (wit = '15');
UPDATE `char_templates` SET `wit`='20' WHERE (SELECT ClassId) AND (wit = '10');
UPDATE `char_templates` SET `dex`='60' WHERE (SELECT ClassId) AND (dex = '30');
UPDATE `char_templates` SET `dex`='42' WHERE (SELECT ClassId) AND (dex = '21');
UPDATE `char_templates` SET `dex`='70' WHERE (SELECT ClassId) AND (dex = '35');
UPDATE `char_templates` SET `dex`='48' WHERE (SELECT ClassId) AND (dex = '24');
UPDATE `char_templates` SET `dex`='68' WHERE (SELECT ClassId) AND (dex = '34');
UPDATE `char_templates` SET `dex`='46' WHERE (SELECT ClassId) AND (dex = '23');
UPDATE `char_templates` SET `dex`='52' WHERE (SELECT ClassId) AND (dex = '26');
UPDATE `char_templates` SET `dex`='58' WHERE (SELECT ClassId) AND (dex = '29');

Все РБ станут 80 лвлом

Code
UPDATE npc SET `level`=80 WHERE `type`="L2RaidBoss"

Все гранд босы станут 80 лвлом

Code
UPDATE npc SET `level`=80 WHERE `type`="L2GrandBoss"

Настройка статов у гвардов

Code
UPDATE npc SET level='85' where type='L2Guard';
UPDATE npc SET hp='30000' where type='L2Guard';
UPDATE npc SET mp='30000' where type='L2Guard';
UPDATE npc SET patk='30000' where type='L2Guard';
UPDATE npc SET pdef='10000' where type='L2Guard';
UPDATE npc SET mdef='10000' where type='L2Guard';
UPDATE npc SET title='Customized Guard' where type='L2Guard';
UPDATE npc SET serverSideTitle='1' where type='L2Guard';
UPDATE npc SET serverSideTitle='1' where type='L2Guard';
UPDATE npc SET rhand='0' where type='L2Guard';
UPDATE npc SET lhand='0' where type='L2Guard';
UPDATE npc SET runspd='300' where type='L2Guard';
UPDATE npc SET ss='1' where type='L2Guard';
UPDATE npc SET bss='1' where type='L2Guard';
UPDATE npc SET ss_rate='100' where type='L2Guard';
UPDATE npc SET attackrange='100' where type='L2Guard';
UPDATE npc SET aggro='5000' where type='L2Guard';
UPDATE npc SET str='100' where type='L2Guard';
UPDATE npc SET con='100' where type='L2Guard';
UPDATE npc SET dex='100' where type='L2Guard';
UPDATE npc SET wit='100' where type='L2Guard';
UPDATE npc SET men='100' where type='L2Guard';
UPDATE npc SET str='100' where type='L2Guard';

Авторестарт сервера каждую неделю

Code
INSERT INTO `global_tasks` VALUES ("5", "restart", "TYPE_SHEDULED", "2147483647", "604800000", "86400000", "360");

Авторестарт сервера каждые 2 дня

Code
INSERT INTO `global_tasks` VALUES ("5", "restart", "TYPE_SHEDULED", "2147483647", "172800000", "86400000", "360");

Авторестарт сервера каждые 24 часа

Code
INSERT INTO `global_tasks` VALUES ("5", "restart", "TYPE_SHEDULED", "2147483647", "86400000", "86400000", "360");

Авторестарт сервера каждые 12 часов

Code
INSERT INTO `global_tasks` VALUES ("5", "restart", "TYPE_SHEDULED", "2147483647", "43200000", "43200000", "360");

Авторестарт сервера каждые 6 часов

Code
INSERT INTO `global_tasks` VALUES ("5", "restart", "TYPE_SHEDULED", "2147483647", "21600000", "21600000", "360");

Авторестарт сервера каждые 3 часа

Code
INSERT INTO `global_tasks` VALUES ("5", "restart", "TYPE_SHEDULED", "2147483647", "10800000", "10800000", "360");

Рейд босы всегда будут появляться с 70% хп

Code
UPDATE raidboss_spawnlist SET currentHp = currentHp * 0.7;

Newbie бафер (уже от грации) будет бафать вас от 1 лвла до 62

Code
UPDATE helper_buff_list SET lower_level=1;
UPDATE helper_buff_list SET upper_level=62;

Для заточки скилов вам не нужно будет тратить xp и exp

Code
UPDATE enchant_skill_trees SET sp=0;
UPDATE enchant_skill_trees SET exp=0;

Вы будете стартовать с вуден сетом, лучшим НГ оружием, набором сосок екстра перчатками и ботинками

Code
UPDATE char_creation_items SET itemId='736' WHERE itemId = 12753;        
-- kamael soe for simple soe (x10)

UPDATE char_creation_items SET itemId='219' WHERE itemId = 10;        
-- starting dagger for Sword Breaker
UPDATE char_creation_items SET itemId='311' WHERE itemId = 6;        
-- starting wand for Crucifix of Blessing
UPDATE char_creation_items SET itemId='68' WHERE itemId = 2369;        
-- starting sword for Falchion
UPDATE char_creation_items SET itemId='257' WHERE itemId = 2368;        
-- starting fists for Viper Fang
UPDATE char_creation_items SET itemId='155' WHERE itemId = 2370;        
-- starting fists for Flanged Mace

UPDATE char_creation_items SET itemId='1101' WHERE itemId = 425;        
-- starting mystics armor for Devotion armor
UPDATE char_creation_items SET itemId='1104' WHERE itemId = 461;        
-- starting mystics armor for Devotion armor

UPDATE char_creation_items SET itemId='23' WHERE itemId = 1146;        
-- starting fifghers armor for Wooden armor
UPDATE char_creation_items SET itemId='2386' WHERE itemId = 1147;        
-- starting fifghers armor for Wooden armor

INSERT INTO char_creation_items VALUES (0,43,1,'true');        
-- Wooden set helm
INSERT INTO char_creation_items VALUES (18,43,1,'true');        
-- Wooden set helm
INSERT INTO char_creation_items VALUES (31,43,1,'true');        
-- Wooden set helm
INSERT INTO char_creation_items VALUES (44,43,1,'true');        
-- Wooden set helm
INSERT INTO char_creation_items VALUES (53,43,1,'true');        
-- Wooden set helm
INSERT INTO char_creation_items VALUES (123,43,1,'true');        
-- Wooden set helm
INSERT INTO char_creation_items VALUES (124,43,1,'true');        
-- Wooden set helm

INSERT INTO char_creation_items VALUES (10,44,1,'true');        
-- Devotion set helm
INSERT INTO char_creation_items VALUES (25,44,1,'true');        
-- Devotion set helm
INSERT INTO char_creation_items VALUES (38,44,1,'true');        
-- Devotion set helm
INSERT INTO char_creation_items VALUES (49,44,1,'true');        
-- Devotion set helm

INSERT INTO char_creation_items VALUES (0,5590,1,'true');        
-- Random Boots (id:5590 - Squeaking Shoes)
INSERT INTO char_creation_items VALUES (18,5590,1,'true');        
-- Random Boots (id:5590 - Squeaking Shoes)
INSERT INTO char_creation_items VALUES (31,5590,1,'true');        
-- Random Boots (id:5590 - Squeaking Shoes)
INSERT INTO char_creation_items VALUES (44,5590,1,'true');        
-- Random Boots (id:5590 - Squeaking Shoes)
INSERT INTO char_creation_items VALUES (53,5590,1,'true');        
-- Random Boots (id:5590 - Squeaking Shoes)
INSERT INTO char_creation_items VALUES (123,5590,1,'true');        
-- Random Boots (id:5590 - Squeaking Shoes)
INSERT INTO char_creation_items VALUES (124,5590,1,'true');        
-- Random Boots (id:5590 - Squeaking Shoes)

INSERT INTO char_creation_items VALUES (10,5590,1,'true');        
-- Random Boots (id:5590 - Squeaking Shoes)
INSERT INTO char_creation_items VALUES (25,5590,1,'true');        
-- Random Boots (id:5590 - Squeaking Shoes)
INSERT INTO char_creation_items VALUES (38,5590,1,'true');        
-- Random Boots (id:5590 - Squeaking Shoes)
INSERT INTO char_creation_items VALUES (49,5590,1,'true');        
-- Random Boots (id:5590 - Squeaking Shoes)

INSERT INTO char_creation_items VALUES (0,51,1,'true');        
-- Random gloves (id:51 - Bracer Gloves)
INSERT INTO char_creation_items VALUES (18,51,1,'true');        
-- Random gloves (id:51 - Bracer Gloves)
INSERT INTO char_creation_items VALUES (31,51,1,'true');        
-- Random gloves id:51 - Bracer Gloves)
INSERT INTO char_creation_items VALUES (44,51,1,'true');        
-- Random gloves (id:51 - Bracer Gloves)
INSERT INTO char_creation_items VALUES (53,51,1,'true');        
-- Random gloves (id:51 - Bracer Gloves)
INSERT INTO char_creation_items VALUES (123,51,1,'true');        
-- Random gloves (id:51 - Bracer Gloves)
INSERT INTO char_creation_items VALUES (124,51,1,'true');        
-- Random gloves (id:51 - Bracer Gloves)

INSERT INTO char_creation_items VALUES (10,51,1,'true');        
-- Random gloves (id:51 - Bracer Gloves)
INSERT INTO char_creation_items VALUES (25,51,1,'true');        
-- Random gloves (id:51 - Bracer Gloves)
INSERT INTO char_creation_items VALUES (38,51,1,'true');        
-- Random gloves id:51 - Bracer Gloves)
INSERT INTO char_creation_items VALUES (49,51,1,'true');        
-- Random gloves (id:51 - Bracer Gloves)

INSERT INTO char_creation_items VALUES (0,5250,2,'true');        
-- shoots x2 (id:5250 - Greater Compressed Package of Soulshots: No-grade)
INSERT INTO char_creation_items VALUES (18,5250,2,'true');        
-- shoots x2 (id:5250 - Greater Compressed Package of Soulshots: No-grade)
INSERT INTO char_creation_items VALUES (31,5250,2,'true');        
-- shoots x2 (id:5250 - Greater Compressed Package of Soulshots: No-grade)
INSERT INTO char_creation_items VALUES (44,5250,2,'true');        
-- shoots x2 (id:5250 - Greater Compressed Package of Soulshots: No-grade)
INSERT INTO char_creation_items VALUES (53,5250,2,'true');        
-- shoots x2 (id:5250 - Greater Compressed Package of Soulshots: No-grade)
INSERT INTO char_creation_items VALUES (123,5250,2,'true');        
-- shoots x2 (id:5250 - Greater Compressed Package of Soulshots: No-grade)
INSERT INTO char_creation_items VALUES (124,5250,2,'true');        
-- shoots x2 (id:5250 - Greater Compressed Package of Soulshots: No-grade)

INSERT INTO char_creation_items VALUES (10,5262,1,'false');        
-- shoots (id:5262 - Greater Compressed Package of Blessed Spiritshots: No-grade)
INSERT INTO char_creation_items VALUES (25,5262,1,'false');        
-- shoots (id:5262 - Greater Compressed Package of Blessed Spiritshots: No-grade)
INSERT INTO char_creation_items VALUES (38,5262,1,'false');        
-- shoots (id:5262 - Greater Compressed Package of Blessed Spiritshots: No-grade)
INSERT INTO char_creation_items VALUES (49,5262,1,'false');        
-- shoots (id:5262 - Greater Compressed Package of Blessed Spiritshots: No-grade)

Месторождение чаров будет по заданным координатам

Code
UPDATE char_templates SET x=yourXcoordinate;
UPDATE char_templates SET y=yourYcoordinate;
UPDATE char_templates SET z=yourZcoordinate;

Добавить всем персонажам на 10% больше П дефа и М дефа

Code
UPDATE char_templates SET P_DEF = P_DEF * 1.1;
UPDATE char_templates SET M_DEF = M_DEF * 1.1;

Добавить персонажам на 20% больше спида

Code
UPDATE char_templates SET MOVE_SPD = MOVE_SPD * 1.2;

Увеличить персонажам СП на 20 лвле на 22%, на 40 лвле на 44%, на 76 лвле на 66%

Code
UPDATE lvlupgain SET defaultcpbase = Defaultcpbase * 1.66 WHERE class_lvl = '76';
UPDATE lvlupgain SET defaultcpbase = Defaultcpbase * 1.44 WHERE class_lvl = '40';
UPDATE lvlupgain SET defaultcpbase = Defaultcpbase * 1.22 WHERE class_lvl = '20';

МП регенерируется на 10% дольше

Code
UPDATE lvlupgain SET defaultmpmod = defaultmpmod * 10.0;

Телепорт будет стоить 0 аден

Code
UPDATE teleport SET price=0;

Убрать грейд пенальти (штраф на грейд итемов)

Code
DELETE FROM skill_trees WHERE skill_id = 239;

Добавить новым персонажам S шмот (магам - Аркану и ДК сет, воинам - ангел слеер и драконик сет)

Code
REPLACE INTO char_templates VALUES (0, "Human Fighter", 0, 40, 43, 30, 21, 11, 25, 4, 72, 3, 47, 330, 213, 33, 44, 33, 115, 81900, -71338, 258271, -3104, 0, "1.1", "1.188", 9, 23, "1.1", "1.188", 8, "23.5", 6379, 6381, 6380, 6382,6592);
REPLACE INTO char_templates VALUES (18, "Elf Fighter", 1, 36, 36, 35, 23, 14, 26, 4, 72, 3, 47, 345, 249, 36, 46, 36, 125, 73000, 45978, 41196, -3440, 0, "1.15", "1.242", "7.5", 24, "1.15", "1.242", "7.5", 23, 6379, 6381, 6380, 6382,6592);
REPLACE INTO char_templates VALUES (31, "DE Fighter", 2, 41, 32, 34, 25, 12, 26, 4, 72, 3, 47, 342, 226, 35, 45, 35, 122, 69000, 28377, 10916, -4224, 0, "1.14", "1.2312", "7.5", 24, "1.14", "1.2312", 7, "23.5", 6379, 6381, 6380, 6382,6592);
REPLACE INTO char_templates VALUES (44,'Orc Fighter', 3, 40, 47, 26, 18, 12, 27, 4, 72, 2, 48, 318, 226, 31, 42, 31, 117, 87000, -58192, -113408, -650, 0, "1.06", "1.144800", 11.0, 28.0,1.06, "1.144800", 7.0, 27.0, 6379, 6381, 6380, 6382, 6583);
REPLACE INTO char_templates VALUES (53, "Dwarf Fighter", 4, 39, 45, 29, 20, 10, 27, 4, 72, 3, 48, 327, 203, 33, 43, 33, 115, 83000, 108512, -174026, -400, 1, "1.09", "1.487196", 9, 18, "1.09", "1.487196", 5, 19, 6379, 6381, 6380, 6382, 6583);
REPLACE INTO char_templates VALUES (10, "Human Mage", 0, 22, 27, 21, 41, 20, 39, 2, 48, 7, 54, 303, 333, 28, 40, 28, 120, 62500, -90890, 248027, -3570, 0, "1.01", "0.87264", "7.5", "22.8", "1.01", "0.87264", "6.5", "22.5", 5779, 5767, 2407, 512, 6608);
REPLACE INTO char_templates VALUES (25, "Elf Mage", 1, 21, 25, 24, 37, 23, 40, 2, 48, 6, 54, 312, 386, 30, 41, 30, 122, 62400, 46182, 41198, -3440, 0, "1.04", "0.89856", "7.5", 24, "1.04", "0.89856", "7.5", 23, 5779, 5767, 2407, 512, 6608);
REPLACE INTO char_templates VALUES (38, "DE Mage", 2, 23, 24, 23, 44, 19, 37, 2, 48, 7, 53, 309, 316, 29, 41, 29, 122, 61000, 28295, 11063, -4224, 0, "1.14", "1.2312", "7.5", 24, "1.03", "0.88992", 7, "23.5", 5779, 5767, 2407, 512, 6608);
REPLACE INTO char_templates VALUES (49, "Orc Mage", 3, 27, 31, 24, 31, 15, 42, 2, 48, 4, 56, 312, 265, 30, 41, 30, 121, 68000, -56682, -113730, -690, 0, "1.04", "0.89856", 7, "27.5", "1.04", "0.89856", 8, "25.5", 5779, 5767, 2407, 512, 6608);

Удалить из дропа стрелы

Code
DELETE FROM droplist WHERE itemId='17';
DELETE FROM droplist WHERE itemId='1341';
DELETE FROM droplist WHERE itemId='1342';
DELETE FROM droplist WHERE itemId='1343';
DELETE FROM droplist WHERE itemId='1344';
DELETE FROM droplist WHERE itemId='1345';
DELETE FROM droplist WHERE itemId='4048';

Удалить из дропа банки

Code
DELETE FROM droplist WHERE itemId='1539';
DELETE FROM droplist WHERE itemId='5591';
DELETE FROM droplist WHERE itemId='5592';

Удалить из дропа кости

Code
DELETE FROM droplist WHERE itemId='2508';

Запрос на удаление вещи с определённым ID из дропа

Code
DELETE FROM `droplist` WHERE `itemId`=[color=red]Item_Id[/color];
Вёрстка макетов и создание клан сайтов на uCoz, STRESS - в ICQ
Хлеба и зрелищ
загрузка наград ...
 
ОвощДата: Четверг, 15.07.2010, 21:48 | Сообщение # 2
Овощ
Группа: Администратор
Сообщений: 2494
Награды: 162
Репутация: 5547
Статус: Offline
Удалить из дропа телепорты (сое)
Code
DELETE FROM droplist WHERE itemId='736';
DELETE FROM droplist WHERE itemId='1829';
DELETE FROM droplist WHERE itemId='1830';
DELETE FROM droplist WHERE itemId='737';
DELETE FROM droplist WHERE itemId='1538';

Удалить из дропа книжки и амулеты (для изучения скилов)

Code
DELETE FROM `droplist` WHERE `itemId`=1047;
DELETE FROM `droplist` WHERE `itemId`=1048;
DELETE FROM `droplist` WHERE `itemId`=1049;
DELETE FROM `droplist` WHERE `itemId`=1050;
DELETE FROM `droplist` WHERE `itemId`=1047;
DELETE FROM `droplist` WHERE `itemId`=1050;
DELETE FROM `droplist` WHERE `itemId`=1051;
DELETE FROM `droplist` WHERE `itemId`=1052;
DELETE FROM `droplist` WHERE `itemId`=1053;
DELETE FROM `droplist` WHERE `itemId`=1054;
DELETE FROM `droplist` WHERE `itemId`=1055;
DELETE FROM `droplist` WHERE `itemId`=1056;
DELETE FROM `droplist` WHERE `itemId`=1057;
DELETE FROM `droplist` WHERE `itemId`=1058;
DELETE FROM `droplist` WHERE `itemId`=1059;
DELETE FROM `droplist` WHERE `itemId`=1095;
DELETE FROM `droplist` WHERE `itemId`=1096;
DELETE FROM `droplist` WHERE `itemId`=1097;
DELETE FROM `droplist` WHERE `itemId`=1098;
DELETE FROM `droplist` WHERE `itemId`=1099;
DELETE FROM `droplist` WHERE `itemId`=1150;
DELETE FROM `droplist` WHERE `itemId`=1151;
DELETE FROM `droplist` WHERE `itemId`=1152;
DELETE FROM `droplist` WHERE `itemId`=1377;
DELETE FROM `droplist` WHERE `itemId`=1378;
DELETE FROM `droplist` WHERE `itemId`=1379;
DELETE FROM `droplist` WHERE `itemId`=1380;
DELETE FROM `droplist` WHERE `itemId`=1380;
DELETE FROM `droplist` WHERE `itemId`=1382;
DELETE FROM `droplist` WHERE `itemId`=1383;
DELETE FROM `droplist` WHERE `itemId`=1384;
DELETE FROM `droplist` WHERE `itemId`=1385;
DELETE FROM `droplist` WHERE `itemId`=1386;
DELETE FROM `droplist` WHERE `itemId`=1387;
DELETE FROM `droplist` WHERE `itemId`=1388;
DELETE FROM `droplist` WHERE `itemId`=1389;
DELETE FROM `droplist` WHERE `itemId`=1390;
DELETE FROM `droplist` WHERE `itemId`=1391;
DELETE FROM `droplist` WHERE `itemId`=1392;
DELETE FROM `droplist` WHERE `itemId`=1393;
DELETE FROM `droplist` WHERE `itemId`=1394;
DELETE FROM `droplist` WHERE `itemId`=1395;
DELETE FROM `droplist` WHERE `itemId`=1396;
DELETE FROM `droplist` WHERE `itemId`=1397;
DELETE FROM `droplist` WHERE `itemId`=1398;
DELETE FROM `droplist` WHERE `itemId`=1399;
DELETE FROM `droplist` WHERE `itemId`=1400;
DELETE FROM `droplist` WHERE `itemId`=1401;
DELETE FROM `droplist` WHERE `itemId`=1402;
DELETE FROM `droplist` WHERE `itemId`=1403;
DELETE FROM `droplist` WHERE `itemId`=1404;
DELETE FROM `droplist` WHERE `itemId`=1405;
DELETE FROM `droplist` WHERE `itemId`=1406;
DELETE FROM `droplist` WHERE `itemId`=1407;
DELETE FROM `droplist` WHERE `itemId`=1408;
DELETE FROM `droplist` WHERE `itemId`=1409;
DELETE FROM `droplist` WHERE `itemId`=1410;
DELETE FROM `droplist` WHERE `itemId`=1411;
DELETE FROM `droplist` WHERE `itemId`=1412;
DELETE FROM `droplist` WHERE `itemId`=1413;
DELETE FROM `droplist` WHERE `itemId`=1414;
DELETE FROM `droplist` WHERE `itemId`=1415;
DELETE FROM `droplist` WHERE `itemId`=1416;
DELETE FROM `droplist` WHERE `itemId`=1417;
DELETE FROM `droplist` WHERE `itemId`=1418;
DELETE FROM `droplist` WHERE `itemId`=1512;
DELETE FROM `droplist` WHERE `itemId`=1513;
DELETE FROM `droplist` WHERE `itemId`=1514;
DELETE FROM `droplist` WHERE `itemId`=1516;
DELETE FROM `droplist` WHERE `itemId`=1515;
DELETE FROM `droplist` WHERE `itemId`=1517;
DELETE FROM `droplist` WHERE `itemId`=1518;
DELETE FROM `droplist` WHERE `itemId`=1519;
DELETE FROM `droplist` WHERE `itemId`=1520;
DELETE FROM `droplist` WHERE `itemId`=1521;
DELETE FROM `droplist` WHERE `itemId`=1522;
DELETE FROM `droplist` WHERE `itemId`=1523;
DELETE FROM `droplist` WHERE `itemId`=1524;
DELETE FROM `droplist` WHERE `itemId`=1525;
DELETE FROM `droplist` WHERE `itemId`=1526;
DELETE FROM `droplist` WHERE `itemId`=1527;
DELETE FROM `droplist` WHERE `itemId`=1528;
DELETE FROM `droplist` WHERE `itemId`=1528;
DELETE FROM `droplist` WHERE `itemId`=1530;
DELETE FROM `droplist` WHERE `itemId`=1531;
DELETE FROM `droplist` WHERE `itemId`=1532;
DELETE FROM `droplist` WHERE `itemId`=1533;
DELETE FROM `droplist` WHERE `itemId`=1534;
DELETE FROM `droplist` WHERE `itemId`=1535;
DELETE FROM `droplist` WHERE `itemId`=1536;
DELETE FROM `droplist` WHERE `itemId`=1537;
DELETE FROM `droplist` WHERE `itemId`=1667;
DELETE FROM `droplist` WHERE `itemId`=1668;
DELETE FROM `droplist` WHERE `itemId`=1669;
DELETE FROM `droplist` WHERE `itemId`=1670;
DELETE FROM `droplist` WHERE `itemId`=1671;
DELETE FROM `droplist` WHERE `itemId`=1856;
DELETE FROM `droplist` WHERE `itemId`=3038;
DELETE FROM `droplist` WHERE `itemId`=3039;
DELETE FROM `droplist` WHERE `itemId`=3040;
DELETE FROM `droplist` WHERE `itemId`=3041;
DELETE FROM `droplist` WHERE `itemId`=3042;
DELETE FROM `droplist` WHERE `itemId`=3043;
DELETE FROM `droplist` WHERE `itemId`=3044;
DELETE FROM `droplist` WHERE `itemId`=3045;
DELETE FROM `droplist` WHERE `itemId`=3046;
DELETE FROM `droplist` WHERE `itemId`=3047;
DELETE FROM `droplist` WHERE `itemId`=3048;
DELETE FROM `droplist` WHERE `itemId`=3049;
DELETE FROM `droplist` WHERE `itemId`=3050;
DELETE FROM `droplist` WHERE `itemId`=3051;
DELETE FROM `droplist` WHERE `itemId`=3052;
DELETE FROM `droplist` WHERE `itemId`=3053;
DELETE FROM `droplist` WHERE `itemId`=3054;
DELETE FROM `droplist` WHERE `itemId`=3055;
DELETE FROM `droplist` WHERE `itemId`=3056;
DELETE FROM `droplist` WHERE `itemId`=3057;
DELETE FROM `droplist` WHERE `itemId`=3058;
DELETE FROM `droplist` WHERE `itemId`=3059;
DELETE FROM `droplist` WHERE `itemId`=3060;
DELETE FROM `droplist` WHERE `itemId`=3061;
DELETE FROM `droplist` WHERE `itemId`=3062;
DELETE FROM `droplist` WHERE `itemId`=3063;
DELETE FROM `droplist` WHERE `itemId`=3064;
DELETE FROM `droplist` WHERE `itemId`=3065;
DELETE FROM `droplist` WHERE `itemId`=3066;
DELETE FROM `droplist` WHERE `itemId`=3067;
DELETE FROM `droplist` WHERE `itemId`=3068;
DELETE FROM `droplist` WHERE `itemId`=3069;
DELETE FROM `droplist` WHERE `itemId`=3070;
DELETE FROM `droplist` WHERE `itemId`=3071;
DELETE FROM `droplist` WHERE `itemId`=3072;
DELETE FROM `droplist` WHERE `itemId`=3073;
DELETE FROM `droplist` WHERE `itemId`=3074;
DELETE FROM `droplist` WHERE `itemId`=3075;
DELETE FROM `droplist` WHERE `itemId`=3076;
DELETE FROM `droplist` WHERE `itemId`=3077;
DELETE FROM `droplist` WHERE `itemId`=3078;
DELETE FROM `droplist` WHERE `itemId`=3079;
DELETE FROM `droplist` WHERE `itemId`=3080;
DELETE FROM `droplist` WHERE `itemId`=3081;
DELETE FROM `droplist` WHERE `itemId`=3082;
DELETE FROM `droplist` WHERE `itemId`=3083;
DELETE FROM `droplist` WHERE `itemId`=3084;
DELETE FROM `droplist` WHERE `itemId`=3085;
DELETE FROM `droplist` WHERE `itemId`=3086;
DELETE FROM `droplist` WHERE `itemId`=3087;
DELETE FROM `droplist` WHERE `itemId`=3088;
DELETE FROM `droplist` WHERE `itemId`=3089;
DELETE FROM `droplist` WHERE `itemId`=3090;
DELETE FROM `droplist` WHERE `itemId`=3091;
DELETE FROM `droplist` WHERE `itemId`=3092;
DELETE FROM `droplist` WHERE `itemId`=3093;
DELETE FROM `droplist` WHERE `itemId`=3094;
DELETE FROM `droplist` WHERE `itemId`=3095;
DELETE FROM `droplist` WHERE `itemId`=3096;
DELETE FROM `droplist` WHERE `itemId`=3097;
DELETE FROM `droplist` WHERE `itemId`=3098;
DELETE FROM `droplist` WHERE `itemId`=3099;
DELETE FROM `droplist` WHERE `itemId`=3100;
DELETE FROM `droplist` WHERE `itemId`=3101;
DELETE FROM `droplist` WHERE `itemId`=3102;
DELETE FROM `droplist` WHERE `itemId`=3103;
DELETE FROM `droplist` WHERE `itemId`=3104;
DELETE FROM `droplist` WHERE `itemId`=3105;
DELETE FROM `droplist` WHERE `itemId`=3106;
DELETE FROM `droplist` WHERE `itemId`=3107;
DELETE FROM `droplist` WHERE `itemId`=3108;
DELETE FROM `droplist` WHERE `itemId`=3109;
DELETE FROM `droplist` WHERE `itemId`=3110;
DELETE FROM `droplist` WHERE `itemId`=3111;
DELETE FROM `droplist` WHERE `itemId`=3112;
DELETE FROM `droplist` WHERE `itemId`=3113;
DELETE FROM `droplist` WHERE `itemId`=3114;
DELETE FROM `droplist` WHERE `itemId`=3115;
DELETE FROM `droplist` WHERE `itemId`=3116;
DELETE FROM `droplist` WHERE `itemId`=3117;
DELETE FROM `droplist` WHERE `itemId`=3118;
DELETE FROM `droplist` WHERE `itemId`=3429;
DELETE FROM `droplist` WHERE `itemId`=3430;
DELETE FROM `droplist` WHERE `itemId`=3431;
DELETE FROM `droplist` WHERE `itemId`=3432;
DELETE FROM `droplist` WHERE `itemId`=3941;
DELETE FROM `droplist` WHERE `itemId`=3942;
DELETE FROM `droplist` WHERE `itemId`=3944;
DELETE FROM `droplist` WHERE `itemId`=4200;
DELETE FROM `droplist` WHERE `itemId`=4201;
DELETE FROM `droplist` WHERE `itemId`=4202;
DELETE FROM `droplist` WHERE `itemId`=4203;
DELETE FROM `droplist` WHERE `itemId`=4206;
DELETE FROM `droplist` WHERE `itemId`=4207;
DELETE FROM `droplist` WHERE `itemId`=4208;
DELETE FROM `droplist` WHERE `itemId`=4906;
DELETE FROM `droplist` WHERE `itemId`=4907;
DELETE FROM `droplist` WHERE `itemId`=4908;
DELETE FROM `droplist` WHERE `itemId`=4909;
DELETE FROM `droplist` WHERE `itemId`=4910;
DELETE FROM `droplist` WHERE `itemId`=4911;
DELETE FROM `droplist` WHERE `itemId`=4912;
DELETE FROM `droplist` WHERE `itemId`=4913;
DELETE FROM `droplist` WHERE `itemId`=4914;
DELETE FROM `droplist` WHERE `itemId`=4916;
DELETE FROM `droplist` WHERE `itemId`=4917;
DELETE FROM `droplist` WHERE `itemId`=4918;
DELETE FROM `droplist` WHERE `itemId`=4919;
DELETE FROM `droplist` WHERE `itemId`=4920;
DELETE FROM `droplist` WHERE `itemId`=4922;
DELETE FROM `droplist` WHERE `itemId`=4923;
DELETE FROM `droplist` WHERE `itemId`=4924;
DELETE FROM `droplist` WHERE `itemId`=4928;
DELETE FROM `droplist` WHERE `itemId`=4929;
DELETE FROM `droplist` WHERE `itemId`=4930;
DELETE FROM `droplist` WHERE `itemId`=4931;
DELETE FROM `droplist` WHERE `itemId`=4932;
DELETE FROM `droplist` WHERE `itemId`=4933;
DELETE FROM `droplist` WHERE `itemId`=4934;
DELETE FROM `droplist` WHERE `itemId`=4935;
DELETE FROM `droplist` WHERE `itemId`=5013;
DELETE FROM `droplist` WHERE `itemId`=5014;
DELETE FROM `droplist` WHERE `itemId`=5015;
DELETE FROM `droplist` WHERE `itemId`=5809;
DELETE FROM `droplist` WHERE `itemId`=5810;
DELETE FROM `droplist` WHERE `itemId`=5811;
DELETE FROM `droplist` WHERE `itemId`=5812;
DELETE FROM `droplist` WHERE `itemId`=5813;
DELETE FROM `droplist` WHERE `itemId`=5814;
DELETE FROM `droplist` WHERE `itemId`=5815;
DELETE FROM `droplist` WHERE `itemId`=5816;
DELETE FROM `droplist` WHERE `itemId`=6350;
DELETE FROM `droplist` WHERE `itemId`=6351;
DELETE FROM `droplist` WHERE `itemId`=6352;
DELETE FROM `droplist` WHERE `itemId`=6395;
DELETE FROM `droplist` WHERE `itemId`=6396;
DELETE FROM `droplist` WHERE `itemId`=6397;
DELETE FROM `droplist` WHERE `itemId`=6398;
DELETE FROM `droplist` WHERE `itemId`=7638;
DELETE FROM `droplist` WHERE `itemId`=7639;
DELETE FROM `droplist` WHERE `itemId`=7640;
DELETE FROM `droplist` WHERE `itemId`=7641;
DELETE FROM `droplist` WHERE `itemId`=7642;
DELETE FROM `droplist` WHERE `itemId`=7643;
DELETE FROM `droplist` WHERE `itemId`=7644;
DELETE FROM `droplist` WHERE `itemId`=7645;
DELETE FROM `droplist` WHERE `itemId`=7646;
DELETE FROM `droplist` WHERE `itemId`=7647;
DELETE FROM `droplist` WHERE `itemId`=7648;
DELETE FROM `droplist` WHERE `itemId`=7649;
DELETE FROM `droplist` WHERE `itemId`=7650;
DELETE FROM `droplist` WHERE `itemId`=7651;
DELETE FROM `droplist` WHERE `itemId`=7652;
DELETE FROM `droplist` WHERE `itemId`=7653;
DELETE FROM `droplist` WHERE `itemId`=7654;
DELETE FROM `droplist` WHERE `itemId`=7655;
DELETE FROM `droplist` WHERE `itemId`=7656;
DELETE FROM `droplist` WHERE `itemId`=7657;
DELETE FROM `droplist` WHERE `itemId`=7658;
DELETE FROM `droplist` WHERE `itemId`=7659;
DELETE FROM `droplist` WHERE `itemId`=7660;
DELETE FROM `droplist` WHERE `itemId`=7661;
DELETE FROM `droplist` WHERE `itemId`=7652;
DELETE FROM `droplist` WHERE `itemId`=7663;
DELETE FROM `droplist` WHERE `itemId`=7664;
DELETE FROM `droplist` WHERE `itemId`=7665;
DELETE FROM `droplist` WHERE `itemId`=7666;
DELETE FROM `droplist` WHERE `itemId`=7667;
DELETE FROM `droplist` WHERE `itemId`=7668;
DELETE FROM `droplist` WHERE `itemId`=7669;
DELETE FROM `droplist` WHERE `itemId`=7670;
DELETE FROM `droplist` WHERE `itemId`=7671;
DELETE FROM `droplist` WHERE `itemId`=7672;
DELETE FROM `droplist` WHERE `itemId`=7673;
DELETE FROM `droplist` WHERE `itemId`=7674;
DELETE FROM `droplist` WHERE `itemId`=7675;
DELETE FROM `droplist` WHERE `itemId`=7676;
DELETE FROM `droplist` WHERE `itemId`=7835;
DELETE FROM `droplist` WHERE `itemId`=8380;
DELETE FROM `droplist` WHERE `itemId`=8381;
DELETE FROM `droplist` WHERE `itemId`=8382;
DELETE FROM `droplist` WHERE `itemId`=8383;
DELETE FROM `droplist` WHERE `itemId`=8384;
DELETE FROM `droplist` WHERE `itemId`=8385;
DELETE FROM `droplist` WHERE `itemId`=8386;
DELETE FROM `droplist` WHERE `itemId`=8387;
DELETE FROM `droplist` WHERE `itemId`=8388;
DELETE FROM `droplist` WHERE `itemId`=8389;
DELETE FROM `droplist` WHERE `itemId`=8390;
DELETE FROM `droplist` WHERE `itemId`=8391;
DELETE FROM `droplist` WHERE `itemId`=8392;
DELETE FROM `droplist` WHERE `itemId`=8393;
DELETE FROM `droplist` WHERE `itemId`=8394;
DELETE FROM `droplist` WHERE `itemId`=8395;
DELETE FROM `droplist` WHERE `itemId`=8396;
DELETE FROM `droplist` WHERE `itemId`=8397;
DELETE FROM `droplist` WHERE `itemId`=8398;
DELETE FROM `droplist` WHERE `itemId`=8399;
DELETE FROM `droplist` WHERE `itemId`=8400;
DELETE FROM `droplist` WHERE `itemId`=8401;
DELETE FROM `droplist` WHERE `itemId`=8402;
DELETE FROM `droplist` WHERE `itemId`=8616;
DELETE FROM `droplist` WHERE `itemId`=8617;
DELETE FROM `droplist` WHERE `itemId`=8877;
DELETE FROM `droplist` WHERE `itemId`=8878;
DELETE FROM `droplist` WHERE `itemId`=8879;
DELETE FROM `droplist` WHERE `itemId`=8880;
DELETE FROM `droplist` WHERE `itemId`=8881;
DELETE FROM `droplist` WHERE `itemId`=8882;
DELETE FROM `droplist` WHERE `itemId`=8883;
DELETE FROM `droplist` WHERE `itemId`=8884;
DELETE FROM `droplist` WHERE `itemId`=8885;
DELETE FROM `droplist` WHERE `itemId`=8886;
DELETE FROM `droplist` WHERE `itemId`=8888;
DELETE FROM `droplist` WHERE `itemId`=8889;
DELETE FROM `droplist` WHERE `itemId`=8890;
DELETE FROM `droplist` WHERE `itemId`=8891;
DELETE FROM `droplist` WHERE `itemId`=8945;
DELETE FROM `droplist` WHERE `itemId`=8946;

Удалить из дропа всё, кроме РБ бижи, адены и колов

Code
DELETE FROM droplist WHERE itemId NOT IN (57,4037,8191,6662,6661,6660,6659,6658,6657,6656);

Удалить из спаунлиста НПС с ID 7777

Code
DELETE FROM spawnlist WHERE npc_templateid="[color=red]7777[/color]";
Вёрстка макетов и создание клан сайтов на uCoz, STRESS - в ICQ
Хлеба и зрелищ
загрузка наград ...
 
ОвощДата: Среда, 21.07.2010, 22:31 | Сообщение # 3
Овощ
Группа: Администратор
Сообщений: 2494
Награды: 162
Репутация: 5547
Статус: Offline
Новые персонажи будут рождаться в топ Д шмоте
Code
REPLACE INTO char_templates VALUES (0, "Human Fighter", 0, 40, 43, 30, 21, 11, 25, 4, 72, 3, 47, 330, 213, 33, 44, 33, 115, 81900, -71338, 258271, -3104, 0, "1.1", "1.188", 9, 23, "1.1", "1.188", 8, "23.5", 395, 2424, 2448, 417,225);
REPLACE INTO char_templates VALUES (18, "Elf Fighter", 1, 36, 36, 35, 23, 14, 26, 4, 72, 3, 47, 345, 249, 36, 46, 36, 125, 73000, 45978, 41196, -3440, 0, "1.15", "1.242", "7.5", 24, "1.15", "1.242", "7.5", 23, 395, 2424, 2448, 417,225);
REPLACE INTO char_templates VALUES (31, "DE Fighter", 2, 41, 32, 34, 25, 12, 26, 4, 72, 3, 47, 342, 226, 35, 45, 35, 122, 69000, 28377, 10916, -4224, 0, "1.14", "1.2312", "7.5", 24, "1.14", "1.2312", 7, "23.5", 395, 2424, 2448, 417,225);
REPLACE INTO char_templates VALUES (44,'Orc Fighter', 3, 40, 47, 26, 18, 12, 27, 4, 72, 2, 48, 318, 226, 31, 42, 31, 117, 87000, -58192, -113408, -650, 0, "1.06", "1.144800", 11.0, 28.0,1.06, "1.144800", 7.0, 27.0, 395, 2424, 2448, 417, 2499);
REPLACE INTO char_templates VALUES (53, "Dwarf Fighter", 4, 39, 45, 29, 20, 10, 27, 4, 72, 3, 48, 327, 203, 33, 43, 33, 115, 83000, 1082426, -174026, -400, 1, "1.09", "1.487196", 9, 18, "1.09", "1.487196", 5, 19, 395, 2424, 2448, 417, 2499);
REPLACE INTO char_templates VALUES (10, "Human Mage", 0, 22, 27, 21, 41, 20, 39, 2, 48, 7, 54, 303, 333, 28, 40, 28, 120, 62500, -90890, 248027, -3570, 0, "1.01", "0.87264", "7.5", "22.8", "1.01", "0.87264", "6.5", "22.5", 437, 470, 2450, 2426, 188);
REPLACE INTO char_templates VALUES (25, "Elf Mage", 1, 21, 25, 24, 37, 23, 40, 2, 48, 6, 54, 312, 386, 30, 41, 30, 122, 62400, 46182, 41198, -3440, 0, "1.04", "0.89856", "7.5", 24, "1.04", "0.89856", "7.5", 23, 437, 470, 2450, 2426, 188);
REPLACE INTO char_templates VALUES (38, "DE Mage", 2, 23, 24, 23, 44, 19, 37, 2, 48, 7, 53, 309, 316, 29, 41, 29, 122, 61000, 28295, 11063, -4224, 0, "1.14", "1.2312", "7.5", 24, "1.03", "0.88992", 7, "23.5", 437, 470, 2450, 2426, 188);
REPLACE INTO char_templates VALUES (49, "Orc Mage", 3, 27, 31, 24, 31, 15, 42, 2, 48, 4, 56, 312, 265, 30, 41, 30, 121, 68000, -56682, -113730, -690, 0, "1.04", "0.89856", 7, "27.5", "1.04", "0.89856", 8, "25.5", 437, 470, 2450, 2426, 188);

Новые персонажи будут рождаться в топ С шмоте

Code
REPLACE INTO char_templates VALUES (0, "Human Fighter", 0, 40, 43, 30, 21, 11, 25, 4, 72, 3, 47, 330, 213, 33, 44, 33, 115, 81900, -71338, 258271, -3104, 0, "1.1", "1.188", 9, 23, "1.1", "1.188", 8, "23.5", 401, 2437, 2461, 499,6358);
REPLACE INTO char_templates VALUES (18, "Elf Fighter", 1, 36, 36, 35, 23, 14, 26, 4, 72, 3, 47, 345, 249, 36, 46, 36, 125, 73000, 45978, 41196, -3440, 0, "1.15", "1.242", "7.5", 24, "1.15", "1.242", "7.5", 23, 401, 2437, 2461, 499,6358);
REPLACE INTO char_templates VALUES (31, "DE Fighter", 2, 41, 32, 34, 25, 12, 26, 4, 72, 3, 47, 342, 226, 35, 45, 35, 122, 69000, 28377, 10916, -4224, 0, "1.14", "1.2312", "7.5", 24, "1.14", "1.2312", 7, "23.5", 401, 2437, 2461, 499,6358);
REPLACE INTO char_templates VALUES (44,'Orc Fighter', 3, 40, 47, 26, 18, 12, 27, 4, 72, 2, 48, 318, 226, 31, 42, 31, 117, 87000, -58192, -113408, -650, 0, "1.06", "1.144800", 11.0, 28.0,1.06, "1.144800", 7.0, 27.0, 401, 2437, 2461, 499, 4710);
REPLACE INTO char_templates VALUES (53, "Dwarf Fighter", 4, 39, 45, 29, 20, 10, 27, 4, 72, 3, 48, 327, 203, 33, 43, 33, 115, 83000, 108471, -174026, -400, 1, "1.09", "1.487196", 9, 18, "1.09", "1.487196", 5, 19, 401, 2437, 2461, 499, 4710);
REPLACE INTO char_templates VALUES (10, "Human Mage", 0, 22, 27, 21, 41, 20, 39, 2, 48, 7, 54, 303, 333, 28, 40, 28, 120, 62500, -90890, 248027, -3570, 0, "1.01", "0.87264", "7.5", "22.8", "1.01", "0.87264", "6.5", "22.5", 2430, 2454, 439, 471, 6313);
REPLACE INTO char_templates VALUES (25, "Elf Mage", 1, 21, 25, 24, 37, 23, 40, 2, 48, 6, 54, 312, 386, 30, 41, 30, 122, 62400, 46182, 41198, -3440, 0, "1.04", "0.89856", "7.5", 24, "1.04", "0.89856", "7.5", 23, 2430, 2454, 439, 471, 6313);
REPLACE INTO char_templates VALUES (38, "DE Mage", 2, 23, 24, 23, 44, 19, 37, 2, 48, 7, 53, 309, 316, 29, 41, 29, 122, 61000, 28295, 11063, -4224, 0, "1.14", "1.2312", "7.5", 24, "1.03", "0.88992", 7, "23.5", 2430, 2454, 439, 471, 6313);
REPLACE INTO char_templates VALUES (49, "Orc Mage", 3, 27, 31, 24, 31, 15, 42, 2, 48, 4, 56, 312, 265, 30, 41, 30, 121, 68000, -56682, -113730, -690, 0, "1.04", "0.89856", 7, "27.5", "1.04", "0.89856", 8, "25.5", 2430, 2454, 439, 471, 6313);

Новые персонажи будут рождаться в топ Б шмоте

Code
REPLACE INTO char_templates VALUES (0, "Human Fighter", 0, 40, 43, 30, 21, 11, 25, 4, 72, 3, 47, 330, 213, 33, 44, 33, 115, 81900, -71338, 258271, -3104, 0, "1.1", "1.188", 9, 23, "1.1", "1.188", 8, "23.5", 2392, 5739, 5723, 2417,6359);
REPLACE INTO char_templates VALUES (18, "Elf Fighter", 1, 36, 36, 35, 23, 14, 26, 4, 72, 3, 47, 345, 249, 36, 46, 36, 125, 73000, 45978, 41196, -3440, 0, "1.15", "1.242", "7.5", 24, "1.15", "1.242", "7.5", 23, 2392, 5739, 5723, 2417,6359);
REPLACE INTO char_templates VALUES (31, "DE Fighter", 2, 41, 32, 34, 25, 12, 26, 4, 72, 3, 47, 342, 226, 35, 45, 35, 122, 69000, 28377, 10916, -4224, 0, "1.14", "1.2312", "7.5", 24, "1.14", "1.2312", 7, "23.5", 2392, 5739, 5723, 2417,6359);
REPLACE INTO char_templates VALUES (44,'Orc Fighter', 3, 40, 47, 26, 18, 12, 27, 4, 72, 2, 48, 318, 226, 31, 42, 31, 117, 87000, -58192, -113408, -650, 0, "1.06", "1.144800", 11.0, 28.0,1.06, "1.144800", 7.0, 27.0, 2392, 5739, 5723, 2417, 4719);
REPLACE INTO char_templates VALUES (53, "Dwarf Fighter", 4, 39, 45, 29, 20, 10, 27, 4, 72, 3, 48, 327, 203, 33, 43, 33, 115, 83000, 1082415, -174026, -400, 1, "1.09", "1.487196", 9, 18, "1.09", "1.487196", 5, 19, 2392, 5739, 5723, 2417, 4719);
REPLACE INTO char_templates VALUES (10, "Human Mage", 0, 22, 27, 21, 41, 20, 39, 2, 48, 7, 54, 303, 333, 28, 40, 28, 120, 62500, -90890, 248027, -3570, 0, "1.01", "0.87264", "7.5", "22.8", "1.01", "0.87264", "6.5", "22.5", 5732, 5716, 2406, 2415, 7722);
REPLACE INTO char_templates VALUES (25, "Elf Mage", 1, 21, 25, 24, 37, 23, 40, 2, 48, 6, 54, 312, 386, 30, 41, 30, 122, 62400, 46182, 41198, -3440, 0, "1.04", "0.89856", "7.5", 24, "1.04", "0.89856", "7.5", 23, 5732, 5716, 2406, 2415, 7722);
REPLACE INTO char_templates VALUES (38, "DE Mage", 2, 23, 24, 23, 44, 19, 37, 2, 48, 7, 53, 309, 316, 29, 41, 29, 122, 61000, 28295, 11063, -4224, 0, "1.14", "1.2312", "7.5", 24, "1.03", "0.88992", 7, "23.5", 5732, 5716, 2406, 2415, 7722);
REPLACE INTO char_templates VALUES (49, "Orc Mage", 3, 27, 31, 24, 31, 15, 42, 2, 48, 4, 56, 312, 265, 30, 41, 30, 121, 68000, -56682, -113730, -690, 0, "1.04", "0.89856", 7, "27.5", "1.04", "0.89856", 8, "25.5", 5732, 5716, 2406, 2415, 7722);

Новые персонажи будут рождаться в топ А шмоте

Code
REPLACE INTO char_templates VALUES (0, "Human Fighter", 0, 40, 43, 30, 21, 11, 25, 4, 72, 3, 47, 330, 213, 33, 44, 33, 115, 81900, -71338, 258271, -3104, 0, "1.1", "1.188", 9, 23, "1.1", "1.188", 8, "23.5", 2395, 5787, 5775, 2419,8682);
REPLACE INTO char_templates VALUES (18, "Elf Fighter", 1, 36, 36, 35, 23, 14, 26, 4, 72, 3, 47, 345, 249, 36, 46, 36, 125, 73000, 45978, 41196, -3440, 0, "1.15", "1.242", "7.5", 24, "1.15", "1.242", "7.5", 23, 2395, 5787, 5775, 2419,8682);
REPLACE INTO char_templates VALUES (31, "DE Fighter", 2, 41, 32, 34, 25, 12, 26, 4, 72, 3, 47, 342, 226, 35, 45, 35, 122, 69000, 28377, 10916, -4224, 0, "1.14", "1.2312", "7.5", 24, "1.14", "1.2312", 7, "23.5", 2395, 5787, 5775, 2419,8682);
REPLACE INTO char_templates VALUES (44,'Orc Fighter', 3, 40, 47, 26, 18, 12, 27, 4, 72, 2, 48, 318, 226, 31, 42, 31, 117, 87000, -58192, -113408, -650, 0, "1.06", "1.144800", 11.0, 28.0,1.06, "1.144800", 7.0, 27.0, 2395, 5787, 5775, 2419, 8788);
REPLACE INTO char_templates VALUES (53, "Dwarf Fighter", 4, 39, 45, 29, 20, 10, 27, 4, 72, 3, 48, 327, 203, 33, 43, 33, 115, 83000, 108512, -174026, -400, 1, "1.09", "1.487196", 9, 18, "1.09", "1.487196", 5, 19, 2395, 5787, 5775, 2419, 8788);
REPLACE INTO char_templates VALUES (10, "Human Mage", 0, 22, 27, 21, 41, 20, 39, 2, 48, 7, 54, 303, 333, 28, 40, 28, 120, 62500, -90890, 248027, -3570, 0, "1.01", "0.87264", "7.5", "22.8", "1.01", "0.87264", "6.5", "22.5", 5779, 5767, 2407, 512, 5643);
REPLACE INTO char_templates VALUES (25, "Elf Mage", 1, 21, 25, 24, 37, 23, 40, 2, 48, 6, 54, 312, 386, 30, 41, 30, 122, 62400, 46182, 41198, -3440, 0, "1.04", "0.89856", "7.5", 24, "1.04", "0.89856", "7.5", 23, 5779, 5767, 2407, 512, 5643);
REPLACE INTO char_templates VALUES (38, "DE Mage", 2, 23, 24, 23, 44, 19, 37, 2, 48, 7, 53, 309, 316, 29, 41, 29, 122, 61000, 28295, 11063, -4224, 0, "1.14", "1.2312", "7.5", 24, "1.03", "0.88992", 7, "23.5", 5779, 5767, 2407, 512, 5643);
REPLACE INTO char_templates VALUES (49, "Orc Mage", 3, 27, 31, 24, 31, 15, 42, 2, 48, 4, 56, 312, 265, 30, 41, 30, 121, 68000, -56682, -113730, -690, 0, "1.04", "0.89856", 7, "27.5", "1.04", "0.89856", 8, "25.5", 5779, 5767, 2407, 512, 5643);

Новые персонажи будут рождаться в топ S шмоте

Code
REPLACE INTO char_templates VALUES (0, "Human Fighter", 0, 40, 43, 30, 21, 11, 25, 4, 72, 3, 47, 330, 213, 33, 44, 33, 115, 81900, -71338, 258271, -3104, 0, "1.1", "1.188", 9, 23, "1.1", "1.188", 8, "23.5", 6379, 6381, 6380, 6382,6592);
REPLACE INTO char_templates VALUES (18, "Elf Fighter", 1, 36, 36, 35, 23, 14, 26, 4, 72, 3, 47, 345, 249, 36, 46, 36, 125, 73000, 45978, 41196, -3440, 0, "1.15", "1.242", "7.5", 24, "1.15", "1.242", "7.5", 23, 6379, 6381, 6380, 6382,6592);
REPLACE INTO char_templates VALUES (31, "DE Fighter", 2, 41, 32, 34, 25, 12, 26, 4, 72, 3, 47, 342, 226, 35, 45, 35, 122, 69000, 28377, 10916, -4224, 0, "1.14", "1.2312", "7.5", 24, "1.14", "1.2312", 7, "23.5", 6379, 6381, 6380, 6382,6592);
REPLACE INTO char_templates VALUES (44,'Orc Fighter', 3, 40, 47, 26, 18, 12, 27, 4, 72, 2, 48, 318, 226, 31, 42, 31, 117, 87000, -58192, -113408, -650, 0, "1.06", "1.144800", 11.0, 28.0,1.06, "1.144800", 7.0, 27.0, 6379, 6381, 6380, 6382, 6583);
REPLACE INTO char_templates VALUES (53, "Dwarf Fighter", 4, 39, 45, 29, 20, 10, 27, 4, 72, 3, 48, 327, 203, 33, 43, 33, 115, 83000, 1086386, -174026, -400, 1, "1.09", "1.487196", 9, 18, "1.09", "1.487196", 5, 19, 6379, 6381, 6380, 6382, 6583);
REPLACE INTO char_templates VALUES (10, "Human Mage", 0, 22, 27, 21, 41, 20, 39, 2, 48, 7, 54, 303, 333, 28, 40, 28, 120, 62500, -90890, 248027, -3570, 0, "1.01", "0.87264", "7.5", "22.8", "1.01", "0.87264", "6.5", "22.5", 6385, 6384, 6383, 6386, 6608);
REPLACE INTO char_templates VALUES (25, "Elf Mage", 1, 21, 25, 24, 37, 23, 40, 2, 48, 6, 54, 312, 386, 30, 41, 30, 122, 62400, 46182, 41198, -3440, 0, "1.04", "0.89856", "7.5", 24, "1.04", "0.89856", "7.5", 23, 6385, 6384, 6383, 6386, 6608);
REPLACE INTO char_templates VALUES (38, "DE Mage", 2, 23, 24, 23, 44, 19, 37, 2, 48, 7, 53, 309, 316, 29, 41, 29, 122, 61000, 28295, 11063, -4224, 0, "1.14", "1.2312", "7.5", 24, "1.03", "0.88992", 7, "23.5", 6385, 6384, 6383, 6386, 6608);
REPLACE INTO char_templates VALUES (49, "Orc Mage", 3, 27, 31, 24, 31, 15, 42, 2, 48, 4, 56, 312, 265, 30, 41, 30, 121, 68000, -56682, -113730, -690, 0, "1.04", "0.89856", 7, "27.5", "1.04", "0.89856", 8, "25.5", 6385, 6384, 6383, 6386, 6608);

Автоизучение скилов после 81 лвла

Code
INSERT INTO `skill_trees` VALUES (88, 759, 1, 'Archer''s Will', 0, 81);
INSERT INTO `skill_trees` VALUES (88, 758, 1, 'Fighter''s Will', 0, 81);
INSERT INTO `skill_trees` VALUES (88, 757, 1, 'Protection of Alignment', 0, 82);
INSERT INTO `skill_trees` VALUES (88, 756, 1, 'Protection of Elemental', 0, 82);
INSERT INTO `skill_trees` VALUES (88, 755, 1, 'Protection of Rune', 0, 82);
INSERT INTO `skill_trees` VALUES (88, 775, 1, 'Weapon Blockade', 0, 83);
INSERT INTO `skill_trees` VALUES (89, 759, 1, 'Archer''s Will', 0, 81);
INSERT INTO `skill_trees` VALUES (89, 758, 1, 'Fighters Will', 0, 81);
INSERT INTO `skill_trees` VALUES (89, 757, 1, 'Protection of Alignment', 0, 82);
INSERT INTO `skill_trees` VALUES (89, 756, 1, 'Protection of Elemental', 0, 82);
INSERT INTO `skill_trees` VALUES (89, 755, 1, 'Protection of Rune', 0, 82);
INSERT INTO `skill_trees` VALUES (89, 774, 1, 'Dread Pool', 0, 83);
INSERT INTO `skill_trees` VALUES (90, 759, 1, 'Archer''s Will', 0, 81);
INSERT INTO `skill_trees` VALUES (90, 758, 1, 'Fighters Will', 0, 81);
INSERT INTO `skill_trees` VALUES (90, 757, 1, 'Protection of Alignment', 0, 82);
INSERT INTO `skill_trees` VALUES (90, 756, 1, 'Protection of Elemental', 0, 82);
INSERT INTO `skill_trees` VALUES (90, 755, 1, 'Protection of Rune', 0, 82);
INSERT INTO `skill_trees` VALUES (90, 760, 1, 'Anti Magic Armor', 0, 83);
INSERT INTO `skill_trees` VALUES (90, 785, 1, 'Flame Icon', 0, 83);
INSERT INTO `skill_trees` VALUES (90, 784, 1, 'Spirit of Phoenix', 0, 83);
INSERT INTO `skill_trees` VALUES (91, 759, 1, 'Archer''s Will', 0, 81);
INSERT INTO `skill_trees` VALUES (91, 758, 1, 'Fighters Will', 0, 81);
INSERT INTO `skill_trees` VALUES (91, 757, 1, 'Protection of Alignment', 0, 82);
INSERT INTO `skill_trees` VALUES (91, 756, 1, 'Protection of Elemental', 0, 82);
INSERT INTO `skill_trees` VALUES (91, 755, 1, 'Protection of Rune', 0, 82);
INSERT INTO `skill_trees` VALUES (91, 760, 1, 'Anti Magic Armor', 0, 81);
INSERT INTO `skill_trees` VALUES (91, 761, 1, 'Seed of Revenge', 0, 83);
INSERT INTO `skill_trees` VALUES (91, 763, 1, 'Hell Scream', 0, 83);
INSERT INTO `skill_trees` VALUES (91, 762, 1, 'Insane Crusher', 0, 83);
INSERT INTO `skill_trees` VALUES (92, 759, 1, 'Archer''s Will', 0, 81);
INSERT INTO `skill_trees` VALUES (92, 758, 1, 'Fighters Will', 0, 81);
INSERT INTO `skill_trees` VALUES (92, 757, 1, 'Protection of Alignment', 0, 82);
INSERT INTO `skill_trees` VALUES (92, 756, 1, 'Protection of Elemental', 0, 82);
INSERT INTO `skill_trees` VALUES (92, 755, 1, 'Protection of Rune', 0, 83);
INSERT INTO `skill_trees` VALUES (92, 771, 1, 'Flame Hawk', 0, 83);
INSERT INTO `skill_trees` VALUES (93, 759, 1, 'Archer''s Will', 0, 81);
INSERT INTO `skill_trees` VALUES (93, 758, 1, 'Fighters Will', 0, 81);
INSERT INTO `skill_trees` VALUES (93, 757, 1, 'Protection of Alignment', 0, 82);
INSERT INTO `skill_trees` VALUES (93, 756, 1, 'Protection of Elemental', 0, 82);
INSERT INTO `skill_trees` VALUES (93, 755, 1, 'Protection of Rune', 0, 82);
INSERT INTO `skill_trees` VALUES (93, 768, 1, 'Exciting Adventure', 0, 83);
INSERT INTO `skill_trees` VALUES (93, 767, 1, 'Expose Weak Point', 0, 81);
INSERT INTO `skill_trees` VALUES (93, 766, 1, 'Sixth Sense', 0, 81);
INSERT INTO `skill_trees` VALUES (94, 757, 1, 'Protection of Alignment', 0, 82);
INSERT INTO `skill_trees` VALUES (94, 756, 1, 'Protection of Elemental', 0, 82);
INSERT INTO `skill_trees` VALUES (94, 755, 1, 'Protection of Rune', 0, 82);
INSERT INTO `skill_trees` VALUES (94, 1492, 1, 'Flame Armor', 0, 83);
INSERT INTO `skill_trees` VALUES (95, 757, 1, 'Protection of Alignment', 0, 82);
INSERT INTO `skill_trees` VALUES (95, 756, 1, 'Protection of Elemental', 0, 82);
INSERT INTO `skill_trees` VALUES (95, 755, 1, 'Protection of Rune', 0, 82);
INSERT INTO `skill_trees` VALUES (95, 1495, 1, 'Vampiric Mist', 0, 83);
INSERT INTO `skill_trees` VALUES (96, 757, 1, 'Protection of Alignment', 0, 82);
INSERT INTO `skill_trees` VALUES (96, 756, 1, 'Protection of Elemental', 0, 82);
INSERT INTO `skill_trees` VALUES (96, 755, 1, 'Protection of Rune', 0, 82);
INSERT INTO `skill_trees` VALUES (96, 1496, 1, 'Servitor Barrier', 0, 81);
INSERT INTO `skill_trees` VALUES (96, 1497, 1, 'Excessive Loyalty', 0, 81);
INSERT INTO `skill_trees` VALUES (96, 1498, 1, 'Mutual Response', 0, 81);
INSERT INTO `skill_trees` VALUES (97, 757, 1, 'Protection of Alignment', 0, 82);
INSERT INTO `skill_trees` VALUES (97, 756, 1, 'Protection of Elemental', 0, 82);
INSERT INTO `skill_trees` VALUES (97, 755, 1, 'Protection of Rune', 0, 82);
INSERT INTO `skill_trees` VALUES (97, 1505, 1, 'Sublime Self Sacrifice', 0, 83);
INSERT INTO `skill_trees` VALUES (98, 757, 1, 'Protection of Alignment', 0, 82);
INSERT INTO `skill_trees` VALUES (98, 756, 1, 'Protection of Elemental', 0, 82);
INSERT INTO `skill_trees` VALUES (98, 755, 1, 'Protection of Rune', 0, 82);
INSERT INTO `skill_trees` VALUES (99, 759, 1, 'Archer''s Will', 0, 81);
INSERT INTO `skill_trees` VALUES (99, 758, 1, 'Fighters Will', 0, 81);
INSERT INTO `skill_trees` VALUES (99, 757, 1, 'Protection of Alignment', 0, 82);
INSERT INTO `skill_trees` VALUES (99, 756, 1, 'Protection of Elemental', 0, 82);
INSERT INTO `skill_trees` VALUES (99, 755, 1, 'Protection of Rune', 0, 82);
INSERT INTO `skill_trees` VALUES (99, 760, 1, 'Anti Magic Armor', 0, 81);
INSERT INTO `skill_trees` VALUES (99, 786, 1, 'Evas Will', 0, 83);
INSERT INTO `skill_trees` VALUES (99, 787, 1, 'Touch of Eva', 0, 83);
INSERT INTO `skill_trees` VALUES (100, 759, 1, 'Archer''s Will', 0, 81);
INSERT INTO `skill_trees` VALUES (100, 758, 1, 'Fighters Will', 0, 81);
INSERT INTO `skill_trees` VALUES (100, 757, 1, 'Protection of Alignment', 0, 82);
INSERT INTO `skill_trees` VALUES (100, 756, 1, 'Protection of Elemental', 0, 82);
INSERT INTO `skill_trees` VALUES (100, 755, 1, 'Protection of Rune', 0, 82);
INSERT INTO `skill_trees` VALUES (101, 759, 1, 'Archer''s Will', 0, 81);
INSERT INTO `skill_trees` VALUES (101, 758, 1, 'Fighter''s Will', 0, 81);
INSERT INTO `skill_trees` VALUES (101, 757, 1, 'Protection of Alignment', 0, 82);
INSERT INTO `skill_trees` VALUES (101, 756, 1, 'Protection of Elemental', 0, 82);
INSERT INTO `skill_trees` VALUES (101, 755, 1, 'Protection of Rune', 0, 82);
INSERT INTO `skill_trees` VALUES (101, 767, 1, 'Expose Weak Point', 0, 81);
INSERT INTO `skill_trees` VALUES (101, 766, 1, 'Sixth Sense', 0, 81);
INSERT INTO `skill_trees` VALUES (101, 769, 1, 'Wind Riding', 0, 83);
INSERT INTO `skill_trees` VALUES (102, 759, 1, 'Archer''s Will', 0, 81);
INSERT INTO `skill_trees` VALUES (102, 758, 1, 'Fighter''s Will', 0, 81);
INSERT INTO `skill_trees` VALUES (102, 757, 1, 'Protection of Alignment', 0, 82);
INSERT INTO `skill_trees` VALUES (102, 756, 1, 'Protection of Elemental', 0, 82);
INSERT INTO `skill_trees` VALUES (102, 755, 1, 'Protection of Rune', 0, 82);
INSERT INTO `skill_trees` VALUES (102, 772, 1, 'Arrow Rain', 0, 83);
INSERT INTO `skill_trees` VALUES (103, 757, 1, 'Protection of Alignment', 0, 82);
INSERT INTO `skill_trees` VALUES (103, 756, 1, 'Protection of Elemental', 0, 82);
INSERT INTO `skill_trees` VALUES (103, 755, 1, 'Protection of Rune', 0, 82);
INSERT INTO `skill_trees` VALUES (103, 1493, 1, 'Frost Armor', 0, 83);
INSERT INTO `skill_trees` VALUES (104, 757, 1, 'Protection of Alignment', 0, 82);
INSERT INTO `skill_trees` VALUES (104, 756, 1, 'Protection of Elemental', 0, 82);
INSERT INTO `skill_trees` VALUES (104, 755, 1, 'Protection of Rune', 0, 82);
INSERT INTO `skill_trees` VALUES (104, 1496, 1, 'Servitor Barrier', 0, 81);
INSERT INTO `skill_trees` VALUES (104, 1497, 1, 'Excessive Loyalty', 0, 81);
INSERT INTO `skill_trees` VALUES (104, 1498, 1, 'Mutual Response', 0, 81);
INSERT INTO `skill_trees` VALUES (105, 757, 1, 'Protection of Alignment', 0, 82);
INSERT INTO `skill_trees` VALUES (105, 756, 1, 'Protection of Elemental', 0, 82);
INSERT INTO `skill_trees` VALUES (105, 755, 1, 'Protection of Rune', 0, 82);
INSERT INTO `skill_trees` VALUES (105, 1506, 1, 'Blessing of Eva', 0, 83);
INSERT INTO `skill_trees` VALUES (106, 757, 1, 'Protection of Alignment', 0, 82);
INSERT INTO `skill_trees` VALUES (106, 756, 1, 'Protection of Elemental', 0, 82);
INSERT INTO `skill_trees` VALUES (106, 755, 1, 'Protection of Rune', 0, 82);
INSERT INTO `skill_trees` VALUES (106, 760, 1, 'Anti Magic Armor', 0, 81);
INSERT INTO `skill_trees` VALUES (106, 788, 1, 'Pain of Shilen', 0, 83);
INSERT INTO `skill_trees` VALUES (106, 789, 1, 'Touch of Shilen', 0, 83);
INSERT INTO `skill_trees` VALUES (107, 759, 1, 'Archer''s Will', 0, 81);
INSERT INTO `skill_trees` VALUES (107, 758, 1, 'Fighter''s Will', 0, 81);
INSERT INTO `skill_trees` VALUES (107, 757, 1, 'Protection of Alignment', 0, 82);
INSERT INTO `skill_trees` VALUES (107, 756, 1, 'Protection of Elemental', 0, 82);
INSERT INTO `skill_trees` VALUES (107, 755, 1, 'Protection of Rune', 0, 82);
INSERT INTO `skill_trees` VALUES (107, 766, 1, 'Sixth Sense', 0, 81);
INSERT INTO `skill_trees` VALUES (108, 759, 1, 'Archer''s Will', 0, 81);
INSERT INTO `skill_trees` VALUES (108, 758, 4, 'Fighter''s Will', 0, 81);
INSERT INTO `skill_trees` VALUES (108, 757, 1, 'Protection of Alignment', 0, 82);
INSERT INTO `skill_trees` VALUES (108, 756, 1, 'Protection of Elemental', 0, 82);
INSERT INTO `skill_trees` VALUES (108, 755, 1, 'Protection of Rune', 0, 82);
INSERT INTO `skill_trees` VALUES (108, 767, 1, 'Expose Weak Point', 0, 81);
INSERT INTO `skill_trees` VALUES (108, 770, 1, 'Ghost Walking', 0, 83);
INSERT INTO `skill_trees` VALUES (108, 766, 1, 'Sixth Sense', 0, 81);
INSERT INTO `skill_trees` VALUES (109, 759, 1, 'Archer''s Will', 0, 81);
INSERT INTO `skill_trees` VALUES (109, 758, 1, 'Fighter''s Will', 0, 81);
INSERT INTO `skill_trees` VALUES (109, 757, 1, 'Protection of Alignment', 0, 82);
INSERT INTO `skill_trees` VALUES (109, 756, 1, 'Protection of Elemental', 0, 82);
INSERT INTO `skill_trees` VALUES (109, 755, 1, 'Protection of Rune', 0, 82);
INSERT INTO `skill_trees` VALUES (109, 773, 1, 'Ghost Piercing', 0, 83);
INSERT INTO `skill_trees` VALUES (110, 757, 1, 'Protection of Alignment', 0, 82);
INSERT INTO `skill_trees` VALUES (110, 756, 1, 'Protection of Elemental', 0, 82);
INSERT INTO `skill_trees` VALUES (110, 755, 1, 'Protection of Rune', 0, 82);
INSERT INTO `skill_trees` VALUES (110, 1494, 1, 'Hurricane Armor', 0, 83);
INSERT INTO `skill_trees` VALUES (111, 757, 1, 'Protection of Alignment', 0, 82);
INSERT INTO `skill_trees` VALUES (111, 756, 1, 'Protection of Elemental', 0, 82);
INSERT INTO `skill_trees` VALUES (111, 755, 1, 'Protection of Rune', 0, 82);
INSERT INTO `skill_trees` VALUES (111, 1496, 1, 'Servitor Barrier', 0, 81);
INSERT INTO `skill_trees` VALUES (111, 1497, 1, 'Excessive Loyalty', 0, 81);
INSERT INTO `skill_trees` VALUES (111, 1498, 1, 'Mutual Response', 0, 81);
INSERT INTO `skill_trees` VALUES (112, 757, 1, 'Protection of Alignment', 0, 82);
INSERT INTO `skill_trees` VALUES (112, 756, 1, 'Protection of Elemental', 0, 82);
INSERT INTO `skill_trees` VALUES (112, 755, 1, 'Protection of Rune', 0, 82);
INSERT INTO `skill_trees` VALUES (112, 1507, 1, 'Lord of Vampire', 0, 83);
INSERT INTO `skill_trees` VALUES (113, 759, 1, 'Archer''s Will', 0, 81);
INSERT INTO `skill_trees` VALUES (113, 758, 1, 'Fighter''s Will', 0, 81);
INSERT INTO `skill_trees` VALUES (113, 757, 1, 'Protection of Alignment', 0, 82);
INSERT INTO `skill_trees` VALUES (113, 756, 1, 'Protection of Elemental', 0, 82);
INSERT INTO `skill_trees` VALUES (113, 755, 1, 'Protection of Rune', 0, 82);
INSERT INTO `skill_trees` VALUES (113, 777, 1, 'Demolition Impact', 0, 83);
INSERT INTO `skill_trees` VALUES (114, 759, 1, 'Archer''s Will', 0, 81);
INSERT INTO `skill_trees` VALUES (114, 758, 1, 'Fighter''s Will', 0, 81);
INSERT INTO `skill_trees` VALUES (114, 757, 1, 'Protection of Alignment', 0, 82);
INSERT INTO `skill_trees` VALUES (114, 756, 1, 'Protection of Elemental', 0, 82);
INSERT INTO `skill_trees` VALUES (114, 755, 1, 'Protection of Rune', 0, 82);
INSERT INTO `skill_trees` VALUES (114, 776, 1, 'Force of Destruction', 0, 83);
INSERT INTO `skill_trees` VALUES (115, 757, 1, 'Protection of Alignment', 0, 82);
INSERT INTO `skill_trees` VALUES (115, 756, 1, 'Protection of Elemental', 0, 82);
INSERT INTO `skill_trees` VALUES (115, 755, 1, 'Protection of Rune', 0, 82);
INSERT INTO `skill_trees` VALUES (115, 1509, 1, 'Seal of Limit', 0, 83);
INSERT INTO `skill_trees` VALUES (116, 757, 1, 'Protection of Alignment', 0, 82);
INSERT INTO `skill_trees` VALUES (116, 756, 1, 'Protection of Elemental', 0, 82);
INSERT INTO `skill_trees` VALUES (116, 755, 1, 'Protection of Rune', 0, 82);
INSERT INTO `skill_trees` VALUES (117, 759, 1, 'Archer''s Will', 0, 81);
INSERT INTO `skill_trees` VALUES (117, 758, 1, 'Fighter''s Will', 0, 81);
INSERT INTO `skill_trees` VALUES (117, 757, 1, 'Protection of Alignment', 0, 82);
INSERT INTO `skill_trees` VALUES (117, 756, 1, 'Protection of Elemental', 0, 82);
INSERT INTO `skill_trees` VALUES (117, 755, 1, 'Protection of Rune', 0, 82);
INSERT INTO `skill_trees` VALUES (118, 759, 1, 'Archer''s Will', 0, 81);
INSERT INTO `skill_trees` VALUES (118, 758, 1, 'Fighter''s Will', 0, 81);
INSERT INTO `skill_trees` VALUES (118, 757, 1, 'Protection of Alignment', 0, 82);
INSERT INTO `skill_trees` VALUES (118, 756, 1, 'Protection of Elemental', 0, 82);
INSERT INTO `skill_trees` VALUES (118, 755, 1, 'Protection of Rune', 0, 82);
INSERT INTO `skill_trees` VALUES (118, 778, 1, 'Golem Armor', 0, 83);
INSERT INTO `skill_trees` VALUES (131, 759, 1, 'Archer''s Will', 0, 81);
INSERT INTO `skill_trees` VALUES (131, 758, 1, 'Fighter''s Will', 0, 81);
INSERT INTO `skill_trees` VALUES (131, 757, 1, 'Protection of Alignment', 0, 82);
INSERT INTO `skill_trees` VALUES (131, 756, 1, 'Protection of Elemental', 0, 82);
INSERT INTO `skill_trees` VALUES (131, 755, 1, 'Protection of Rune', 0, 82);
INSERT INTO `skill_trees` VALUES (132, 759, 1, 'Archer''s Will', 0, 81);
INSERT INTO `skill_trees` VALUES (132, 758, 1, 'Fighter''s Will', 0, 81);
INSERT INTO `skill_trees` VALUES (132, 757, 1, 'Protection of Alignment', 0, 82);
INSERT INTO `skill_trees` VALUES (132, 756, 1, 'Protection of Elemental', 0, 82);
INSERT INTO `skill_trees` VALUES (132, 755, 1, 'Protection of Rune', 0, 82);
INSERT INTO `skill_trees` VALUES (132, 791, 1, 'Lightning Shock', 0, 83);
INSERT INTO `skill_trees` VALUES (133, 759, 1, 'Archer''s Will', 0, 81);
INSERT INTO `skill_trees` VALUES (133, 758, 1, 'Fighter''s Will', 0, 81);
INSERT INTO `skill_trees` VALUES (133, 757, 1, 'Protection of Alignment', 0, 82);
INSERT INTO `skill_trees` VALUES (133, 756, 1, 'Protection of Elemental', 0, 82);
INSERT INTO `skill_trees` VALUES (133, 755, 1, 'Protection of Rune', 0, 82);
INSERT INTO `skill_trees` VALUES (133, 791, 1, 'Lightning Shock', 0, 83);
INSERT INTO `skill_trees` VALUES (134, 759, 1, 'Archer''s Will', 0, 81);
INSERT INTO `skill_trees` VALUES (134, 758, 1, 'Fighter''s Will', 0, 81);
INSERT INTO `skill_trees` VALUES (134, 757, 1, 'Protection of Alignment', 0, 82);
INSERT INTO `skill_trees` VALUES (134, 756, 1, 'Protection of Elemental', 0, 82);
INSERT INTO `skill_trees` VALUES (134, 755, 1, 'Protection of Rune', 0, 82);
INSERT INTO `skill_trees` VALUES (134, 790, 1, 'Wild Shot', 0, 83);
INSERT INTO `skill_trees` VALUES (117, 915, 1, 'Dance of Berserker', 0, 83);
INSERT INTO `skill_trees` VALUES (89, 767, 1, 'Expose Weak Point', 0, 81);
INSERT INTO `skill_trees` VALUES (89, 917, 1, 'Champion''s Favor', 0, 81);
INSERT INTO `skill_trees` VALUES (88, 767, 1, 'Expose Weak Point', 0, 81);
INSERT INTO `skill_trees` VALUES (88, 917, 1, 'Champion''s Favor', 0, 81);
INSERT INTO `skill_trees` VALUES (88, 919, 1, 'Maximum Focus Sonic', 0, 83);
INSERT INTO `skill_trees` VALUES (90, 766, 1, 'Sixth Sense', 0, 81);
INSERT INTO `skill_trees` VALUES (90, 913, 1, 'Deflect Magic', 0, 81);
INSERT INTO `skill_trees` VALUES (90, 912, 1, 'Summon Imperial Phoenix', 0, 83);
INSERT INTO `skill_trees` VALUES (91, 766, 1, 'Sixth Sense', 0, 81);
INSERT INTO `skill_trees` VALUES (91, 913, 1, 'Deflect Magic', 0, 81);
INSERT INTO `skill_trees` VALUES (92, 924, 1, 'Seven Arrow', 0, 81);
INSERT INTO `skill_trees` VALUES (92, 946, 1, 'Silent Mind', 0, 81);
INSERT INTO `skill_trees` VALUES (93, 922, 1, 'Hide', 0, 81);
INSERT INTO `skill_trees` VALUES (93, 923, 1, 'Dual Dagger Mastery', 0, 81);
INSERT INTO `skill_trees` VALUES (94, 945, 1, 'Magician''s Will', 0, 81);
INSERT INTO `skill_trees` VALUES (94, 1467, 1, 'Meteor', 0, 81);
INSERT INTO `skill_trees` VALUES (94, 1532, 1, 'Enlightenment', 0, 81);
INSERT INTO `skill_trees` VALUES (95, 945, 1, 'Magician''s Will', 0, 81);
INSERT INTO `skill_trees` VALUES (95, 1467, 1, 'Meteor', 0, 81);
INSERT INTO `skill_trees` VALUES (95, 1532, 1, 'Enlightenment', 0, 81);
INSERT INTO `skill_trees` VALUES (96, 945, 1, 'Magician''s Will', 0, 81);
INSERT INTO `skill_trees` VALUES (96, 929, 1, 'Spirit of the Cat', 0, 83);
INSERT INTO `skill_trees` VALUES (97, 945, 1, 'Magician''s Will', 0, 81);
INSERT INTO `skill_trees` VALUES (97, 1533, 1, 'Enlightenment', 0, 81);
INSERT INTO `skill_trees` VALUES (97, 1540, 1, 'Turn to Stone', 0, 81);
INSERT INTO `skill_trees` VALUES (98, 945, 1, 'Magician''s Will', 0, 81);
INSERT INTO `skill_trees` VALUES (98, 1533, 1, 'Enlightenment', 0, 81);
INSERT INTO `skill_trees` VALUES (98, 1540, 1, 'Turn to Stone', 0, 81);
INSERT INTO `skill_trees` VALUES (98, 1542, 1, 'Counter Critical', 0, 83);
INSERT INTO `skill_trees` VALUES (99, 766, 1, 'Sixth Sense', 0, 81);
INSERT INTO `skill_trees` VALUES (99, 913, 1, 'Deflect Magic', 0, 81);
INSERT INTO `skill_trees` VALUES (100, 766, 1, 'Sixth Sense', 0, 81);
INSERT INTO `skill_trees` VALUES (100, 913, 1, 'Deflect Magic', 0, 81);
INSERT INTO `skill_trees` VALUES (100, 914, 1, 'Song of Purification', 0, 83);
INSERT INTO `skill_trees` VALUES (101, 922, 1, 'Hide', 0, 81);
INSERT INTO `skill_trees` VALUES (101, 923, 1, 'Dual Dagger Mastery', 0, 81);
INSERT INTO `skill_trees` VALUES (102, 924, 1, 'Seven Arrow', 0, 81);
INSERT INTO `skill_trees` VALUES (102, 946, 1, 'Silent Mind', 0, 81);
INSERT INTO `skill_trees` VALUES (103, 945, 1, 'Magician''s Will', 0, 81);
INSERT INTO `skill_trees` VALUES (103, 1468, 1, 'Star Fall', 0, 81);
INSERT INTO `skill_trees` VALUES (103, 1532, 1, 'Enlightenment', 0, 81);
INSERT INTO `skill_trees` VALUES (104, 945, 1, 'Magician''s Will', 0, 81);
INSERT INTO `skill_trees` VALUES (104, 931, 1, 'Spirit of the Unicorn', 0, 83);
INSERT INTO `skill_trees` VALUES (105, 945, 1, 'Magician''s Will', 0, 81);
INSERT INTO `skill_trees` VALUES (105, 1533, 1, 'Enlightenment', 0, 81);
INSERT INTO `skill_trees` VALUES (105, 1540, 1, 'Turn to Stone', 0, 81);
INSERT INTO `skill_trees` VALUES (106, 766, 1, 'Sixth Sense', 0, 81);
INSERT INTO `skill_trees` VALUES (106, 913, 1, 'Deflect Magic', 0, 81);
INSERT INTO `skill_trees` VALUES (107, 913, 1, 'Magician''s Will', 0, 81);
INSERT INTO `skill_trees` VALUES (108, 758, 1, 'Fighter''s Will', 0, 81);
INSERT INTO `skill_trees` VALUES (108, 922, 1, 'Hide', 0, 81);
INSERT INTO `skill_trees` VALUES (108, 923, 1, 'Dual Dagger Mastery', 0, 81);
INSERT INTO `skill_trees` VALUES (109, 924, 1, 'Seven Arrow', 0, 81);
INSERT INTO `skill_trees` VALUES (109, 946, 1, 'Silent Mind', 0, 81);
INSERT INTO `skill_trees` VALUES (110, 945, 1, 'Magician''s Will', 0, 81);
INSERT INTO `skill_trees` VALUES (110, 1468, 1, 'Star Fall', 0, 81);
INSERT INTO `skill_trees` VALUES (110, 1532, 1, 'Enlightenment', 0, 81);
INSERT INTO `skill_trees` VALUES (111, 945, 1, 'Magician''s Will', 0, 81);
INSERT INTO `skill_trees` VALUES (112, 945, 1, 'Magician''s Will', 0, 81);
INSERT INTO `skill_trees` VALUES (112, 1533, 1, 'Enlightenment', 0, 81);
INSERT INTO `skill_trees` VALUES (112, 1540, 1, 'Turn to Stone', 0, 81);
INSERT INTO `skill_trees` VALUES (113, 767, 1, 'Expose Weak Point', 0, 81);
INSERT INTO `skill_trees` VALUES (113, 917, 1, 'Champion''s Favor', 0, 81);
INSERT INTO `skill_trees` VALUES (114, 767, 1, 'Expose Weak Point', 0, 81);
INSERT INTO `skill_trees` VALUES (114, 917, 1, 'Champion''s Favor', 0, 81);
INSERT INTO `skill_trees` VALUES (114, 918, 1, 'Maximum Focus Force', 0, 83);
INSERT INTO `skill_trees` VALUES (115, 945, 1, 'Magician''s Will', 0, 81);
INSERT INTO `skill_trees` VALUES (115, 1533, 1, 'Enlightenment', 0, 81);
INSERT INTO `skill_trees` VALUES (115, 1540, 1, 'Turn to Stone', 0, 81);
INSERT INTO `skill_trees` VALUES (115, 949, 1, 'Onslaught of Pa''agrio', 0, 83);
INSERT INTO `skill_trees` VALUES (116, 945, 1, 'Magician''s Will', 0, 81);
INSERT INTO `skill_trees` VALUES (116, 1533, 1, 'Enlightenment', 0, 81);
INSERT INTO `skill_trees` VALUES (116, 1540, 1, 'Turn to Stone', 0, 81);
INSERT INTO `skill_trees` VALUES (116, 1543, 1, 'Great Fury', 0, 81);
INSERT INTO `skill_trees` VALUES (118, 767, 1, 'Expose Weak Point', 0, 81);
INSERT INTO `skill_trees` VALUES (118, 917, 1, 'Champion''s Favor', 0, 81);
INSERT INTO `skill_trees` VALUES (117, 767, 1, 'Expose Weak Point', 0, 81);
INSERT INTO `skill_trees` VALUES (117, 917, 1, 'Champion''s Favor', 0, 81);
INSERT INTO `skill_trees` VALUES (117, 947, 1, 'Lucky Strike', 0, 83);
INSERT INTO `skill_trees` VALUES (131, 767, 1, 'Expose Weak Point', 0, 81);
INSERT INTO `skill_trees` VALUES (131, 917, 1, 'Champion''s Favor', 0, 81);
INSERT INTO `skill_trees` VALUES (131, 948, 1, 'Eye for Eye', 0, 83);
INSERT INTO `skill_trees` VALUES (132, 766, 1, 'Sixth Sense', 0, 81);
INSERT INTO `skill_trees` VALUES (132, 767, 1, 'Expose Weak Point', 0, 81);
INSERT INTO `skill_trees` VALUES (132, 1532, 1, 'Enlightenment', 0, 81);
INSERT INTO `skill_trees` VALUES (133, 766, 1, 'Sixth Sense', 0, 81);
INSERT INTO `skill_trees` VALUES (133, 767, 1, 'Expose Weak Point', 0, 81);
INSERT INTO `skill_trees` VALUES (133, 1532, 1, 'Enlightenment', 0, 81);
INSERT INTO `skill_trees` VALUES (107, 930, 1, 'Spirit of the Demon', 0, 83);
Вёрстка макетов и создание клан сайтов на uCoz, STRESS - в ICQ
Хлеба и зрелищ
загрузка наград ...
 
oIVERSONoДата: Воскресенье, 01.08.2010, 21:43 | Сообщение # 4
oIVERSONo
Группа: Постоянный
Сообщений: 69
Награды: 0
Репутация: 0
Статус: Offline
а куда их поставит?
загрузка наград ...
 
DeMoNДата: Воскресенье, 01.08.2010, 21:45 | Сообщение # 5
DeMoN
Группа: Постоянный
Сообщений: 619
Награды: 20
Репутация: 120
Статус: Offline
Если вы в плане заливать, открываете navicat, выбираете свою базу, по ней правой клавишей -> Console
Туда вводите запрос и нажимаете enter.
загрузка наград ...
 
oIVERSONoДата: Воскресенье, 01.08.2010, 22:36 | Сообщение # 6
oIVERSONo
Группа: Постоянный
Сообщений: 69
Награды: 0
Репутация: 0
Статус: Offline
mysql> UPDATE `etcitem` SET `weight`=0 WHERE (SELECT item_id);
UPDATE `armor` SET `weight`=0 WHERE (SELECT item_id);
UPDATE `weapon` SET `weight`=0 WHERE (SELECT item_id);
Query OK, 0 rows affected
Rows matched: 6881 Changed: 0 Warnings: 0

Query OK, 0 rows affected
Rows matched: 1014 Changed: 0 Warnings: 0

Query OK, 0 rows affected
Rows matched: 1313 Changed: 0 Warnings: 0

mysql>

в чем ошибка?
загрузка наград ...

 
DeMoNДата: Воскресенье, 01.08.2010, 22:42 | Сообщение # 7
DeMoN
Группа: Постоянный
Сообщений: 619
Награды: 20
Репутация: 120
Статус: Offline
Ошибок 0, все нормально.
загрузка наград ...
 
ОвощДата: Воскресенье, 01.08.2010, 22:44 | Сообщение # 8
Овощ
Группа: Администратор
Сообщений: 2494
Награды: 162
Репутация: 5547
Статус: Offline
:)
Вёрстка макетов и создание клан сайтов на uCoz, STRESS - в ICQ
Хлеба и зрелищ
загрузка наград ...
 
oIVERSONoДата: Воскресенье, 01.08.2010, 23:02 | Сообщение # 9
oIVERSONo
Группа: Постоянный
Сообщений: 69
Награды: 0
Репутация: 0
Статус: Offline
>( сорь он так должен работат?)
загрузка наград ...
 
DeMoNДата: Воскресенье, 01.08.2010, 23:03 | Сообщение # 10
DeMoN
Группа: Постоянный
Сообщений: 619
Награды: 20
Репутация: 120
Статус: Offline
Угу. Учим англ.
Warnings: 0
загрузка наград ...
 
ARTYRДата: Среда, 18.08.2010, 09:48 | Сообщение # 11
ARTYR
Группа: Постоянный
Сообщений: 131
Награды: 2
Репутация: 3
Статус: Offline
Скелы 80+
Code
INSERT INTO `skill_trees` VALUES (88, 759, 1, 'Archer''s Will', 0, 81);
INSERT INTO `skill_trees` VALUES (88, 758, 1, 'Fighter''s Will', 0, 81);
INSERT INTO `skill_trees` VALUES (88, 757, 1, 'Protection of Alignment', 0, 82);
INSERT INTO `skill_trees` VALUES (88, 756, 1, 'Protection of Elemental', 0, 82);
INSERT INTO `skill_trees` VALUES (88, 755, 1, 'Protection of Rune', 0, 82);
INSERT INTO `skill_trees` VALUES (88, 775, 1, 'Weapon Blockade', 0, 83);
INSERT INTO `skill_trees` VALUES (89, 759, 1, 'Archer''s Will', 0, 81);
INSERT INTO `skill_trees` VALUES (89, 758, 1, 'Fighters Will', 0, 81);
INSERT INTO `skill_trees` VALUES (89, 757, 1, 'Protection of Alignment', 0, 82);
INSERT INTO `skill_trees` VALUES (89, 756, 1, 'Protection of Elemental', 0, 82);
INSERT INTO `skill_trees` VALUES (89, 755, 1, 'Protection of Rune', 0, 82);
INSERT INTO `skill_trees` VALUES (89, 774, 1, 'Dread Pool', 0, 83);
INSERT INTO `skill_trees` VALUES (90, 759, 1, 'Archer''s Will', 0, 81);
INSERT INTO `skill_trees` VALUES (90, 758, 1, 'Fighters Will', 0, 81);
INSERT INTO `skill_trees` VALUES (90, 757, 1, 'Protection of Alignment', 0, 82);
INSERT INTO `skill_trees` VALUES (90, 756, 1, 'Protection of Elemental', 0, 82);
INSERT INTO `skill_trees` VALUES (90, 755, 1, 'Protection of Rune', 0, 82);
INSERT INTO `skill_trees` VALUES (90, 760, 1, 'Anti Magic Armor', 0, 83);
INSERT INTO `skill_trees` VALUES (90, 785, 1, 'Flame Icon', 0, 83);
INSERT INTO `skill_trees` VALUES (90, 784, 1, 'Spirit of Phoenix', 0, 83);
INSERT INTO `skill_trees` VALUES (91, 759, 1, 'Archer''s Will', 0, 81);
INSERT INTO `skill_trees` VALUES (91, 758, 1, 'Fighters Will', 0, 81);
INSERT INTO `skill_trees` VALUES (91, 757, 1, 'Protection of Alignment', 0, 82);
INSERT INTO `skill_trees` VALUES (91, 756, 1, 'Protection of Elemental', 0, 82);
INSERT INTO `skill_trees` VALUES (91, 755, 1, 'Protection of Rune', 0, 82);
INSERT INTO `skill_trees` VALUES (91, 760, 1, 'Anti Magic Armor', 0, 81);
INSERT INTO `skill_trees` VALUES (91, 761, 1, 'Seed of Revenge', 0, 83);
INSERT INTO `skill_trees` VALUES (91, 763, 1, 'Hell Scream', 0, 83);
INSERT INTO `skill_trees` VALUES (91, 762, 1, 'Insane Crusher', 0, 83);
INSERT INTO `skill_trees` VALUES (92, 759, 1, 'Archer''s Will', 0, 81);
INSERT INTO `skill_trees` VALUES (92, 758, 1, 'Fighters Will', 0, 81);
INSERT INTO `skill_trees` VALUES (92, 757, 1, 'Protection of Alignment', 0, 82);
INSERT INTO `skill_trees` VALUES (92, 756, 1, 'Protection of Elemental', 0, 82);
INSERT INTO `skill_trees` VALUES (92, 755, 1, 'Protection of Rune', 0, 83);
INSERT INTO `skill_trees` VALUES (92, 771, 1, 'Flame Hawk', 0, 83);
INSERT INTO `skill_trees` VALUES (93, 759, 1, 'Archer''s Will', 0, 81);
INSERT INTO `skill_trees` VALUES (93, 758, 1, 'Fighters Will', 0, 81);
INSERT INTO `skill_trees` VALUES (93, 757, 1, 'Protection of Alignment', 0, 82);
INSERT INTO `skill_trees` VALUES (93, 756, 1, 'Protection of Elemental', 0, 82);
INSERT INTO `skill_trees` VALUES (93, 755, 1, 'Protection of Rune', 0, 82);
INSERT INTO `skill_trees` VALUES (93, 768, 1, 'Exciting Adventure', 0, 83);
INSERT INTO `skill_trees` VALUES (93, 767, 1, 'Expose Weak Point', 0, 81);
INSERT INTO `skill_trees` VALUES (93, 766, 1, 'Sixth Sense', 0, 81);
INSERT INTO `skill_trees` VALUES (94, 757, 1, 'Protection of Alignment', 0, 82);
INSERT INTO `skill_trees` VALUES (94, 756, 1, 'Protection of Elemental', 0, 82);
INSERT INTO `skill_trees` VALUES (94, 755, 1, 'Protection of Rune', 0, 82);
INSERT INTO `skill_trees` VALUES (94, 1492, 1, 'Flame Armor', 0, 83);
INSERT INTO `skill_trees` VALUES (95, 757, 1, 'Protection of Alignment', 0, 82);
INSERT INTO `skill_trees` VALUES (95, 756, 1, 'Protection of Elemental', 0, 82);
INSERT INTO `skill_trees` VALUES (95, 755, 1, 'Protection of Rune', 0, 82);
INSERT INTO `skill_trees` VALUES (95, 1495, 1, 'Vampiric Mist', 0, 83);
INSERT INTO `skill_trees` VALUES (96, 757, 1, 'Protection of Alignment', 0, 82);
INSERT INTO `skill_trees` VALUES (96, 756, 1, 'Protection of Elemental', 0, 82);
INSERT INTO `skill_trees` VALUES (96, 755, 1, 'Protection of Rune', 0, 82);
INSERT INTO `skill_trees` VALUES (96, 1496, 1, 'Servitor Barrier', 0, 81);
INSERT INTO `skill_trees` VALUES (96, 1497, 1, 'Excessive Loyalty', 0, 81);
INSERT INTO `skill_trees` VALUES (96, 1498, 1, 'Mutual Response', 0, 81);
INSERT INTO `skill_trees` VALUES (97, 757, 1, 'Protection of Alignment', 0, 82);
INSERT INTO `skill_trees` VALUES (97, 756, 1, 'Protection of Elemental', 0, 82);
INSERT INTO `skill_trees` VALUES (97, 755, 1, 'Protection of Rune', 0, 82);
INSERT INTO `skill_trees` VALUES (97, 1505, 1, 'Sublime Self Sacrifice', 0, 83);
INSERT INTO `skill_trees` VALUES (98, 757, 1, 'Protection of Alignment', 0, 82);
INSERT INTO `skill_trees` VALUES (98, 756, 1, 'Protection of Elemental', 0, 82);
INSERT INTO `skill_trees` VALUES (98, 755, 1, 'Protection of Rune', 0, 82);
INSERT INTO `skill_trees` VALUES (99, 759, 1, 'Archer''s Will', 0, 81);
INSERT INTO `skill_trees` VALUES (99, 758, 1, 'Fighters Will', 0, 81);
INSERT INTO `skill_trees` VALUES (99, 757, 1, 'Protection of Alignment', 0, 82);
INSERT INTO `skill_trees` VALUES (99, 756, 1, 'Protection of Elemental', 0, 82);
INSERT INTO `skill_trees` VALUES (99, 755, 1, 'Protection of Rune', 0, 82);
INSERT INTO `skill_trees` VALUES (99, 760, 1, 'Anti Magic Armor', 0, 81);
INSERT INTO `skill_trees` VALUES (99, 786, 1, 'Evas Will', 0, 83);
INSERT INTO `skill_trees` VALUES (99, 787, 1, 'Touch of Eva', 0, 83);
INSERT INTO `skill_trees` VALUES (100, 759, 1, 'Archer''s Will', 0, 81);
INSERT INTO `skill_trees` VALUES (100, 758, 1, 'Fighters Will', 0, 81);
INSERT INTO `skill_trees` VALUES (100, 757, 1, 'Protection of Alignment', 0, 82);
INSERT INTO `skill_trees` VALUES (100, 756, 1, 'Protection of Elemental', 0, 82);
INSERT INTO `skill_trees` VALUES (100, 755, 1, 'Protection of Rune', 0, 82);
INSERT INTO `skill_trees` VALUES (101, 759, 1, 'Archer''s Will', 0, 81);
INSERT INTO `skill_trees` VALUES (101, 758, 1, 'Fighter''s Will', 0, 81);
INSERT INTO `skill_trees` VALUES (101, 757, 1, 'Protection of Alignment', 0, 82);
INSERT INTO `skill_trees` VALUES (101, 756, 1, 'Protection of Elemental', 0, 82);
INSERT INTO `skill_trees` VALUES (101, 755, 1, 'Protection of Rune', 0, 82);
INSERT INTO `skill_trees` VALUES (101, 767, 1, 'Expose Weak Point', 0, 81);
INSERT INTO `skill_trees` VALUES (101, 766, 1, 'Sixth Sense', 0, 81);
INSERT INTO `skill_trees` VALUES (101, 769, 1, 'Wind Riding', 0, 83);
INSERT INTO `skill_trees` VALUES (102, 759, 1, 'Archer''s Will', 0, 81);
INSERT INTO `skill_trees` VALUES (102, 758, 1, 'Fighter''s Will', 0, 81);
INSERT INTO `skill_trees` VALUES (102, 757, 1, 'Protection of Alignment', 0, 82);
INSERT INTO `skill_trees` VALUES (102, 756, 1, 'Protection of Elemental', 0, 82);
INSERT INTO `skill_trees` VALUES (102, 755, 1, 'Protection of Rune', 0, 82);
INSERT INTO `skill_trees` VALUES (102, 772, 1, 'Arrow Rain', 0, 83);
INSERT INTO `skill_trees` VALUES (103, 757, 1, 'Protection of Alignment', 0, 82);
INSERT INTO `skill_trees` VALUES (103, 756, 1, 'Protection of Elemental', 0, 82);
INSERT INTO `skill_trees` VALUES (103, 755, 1, 'Protection of Rune', 0, 82);
INSERT INTO `skill_trees` VALUES (103, 1493, 1, 'Frost Armor', 0, 83);
INSERT INTO `skill_trees` VALUES (104, 757, 1, 'Protection of Alignment', 0, 82);
INSERT INTO `skill_trees` VALUES (104, 756, 1, 'Protection of Elemental', 0, 82);
INSERT INTO `skill_trees` VALUES (104, 755, 1, 'Protection of Rune', 0, 82);
INSERT INTO `skill_trees` VALUES (104, 1496, 1, 'Servitor Barrier', 0, 81);
INSERT INTO `skill_trees` VALUES (104, 1497, 1, 'Excessive Loyalty', 0, 81);
INSERT INTO `skill_trees` VALUES (104, 1498, 1, 'Mutual Response', 0, 81);
INSERT INTO `skill_trees` VALUES (105, 757, 1, 'Protection of Alignment', 0, 82);
INSERT INTO `skill_trees` VALUES (105, 756, 1, 'Protection of Elemental', 0, 82);
INSERT INTO `skill_trees` VALUES (105, 755, 1, 'Protection of Rune', 0, 82);
INSERT INTO `skill_trees` VALUES (105, 1506, 1, 'Blessing of Eva', 0, 83);
INSERT INTO `skill_trees` VALUES (106, 757, 1, 'Protection of Alignment', 0, 82);
INSERT INTO `skill_trees` VALUES (106, 756, 1, 'Protection of Elemental', 0, 82);
INSERT INTO `skill_trees` VALUES (106, 755, 1, 'Protection of Rune', 0, 82);
INSERT INTO `skill_trees` VALUES (106, 760, 1, 'Anti Magic Armor', 0, 81);
INSERT INTO `skill_trees` VALUES (106, 788, 1, 'Pain of Shilen', 0, 83);
INSERT INTO `skill_trees` VALUES (106, 789, 1, 'Touch of Shilen', 0, 83);
INSERT INTO `skill_trees` VALUES (107, 759, 1, 'Archer''s Will', 0, 81);
INSERT INTO `skill_trees` VALUES (107, 758, 1, 'Fighter''s Will', 0, 81);
INSERT INTO `skill_trees` VALUES (107, 757, 1, 'Protection of Alignment', 0, 82);
INSERT INTO `skill_trees` VALUES (107, 756, 1, 'Protection of Elemental', 0, 82);
INSERT INTO `skill_trees` VALUES (107, 755, 1, 'Protection of Rune', 0, 82);
INSERT INTO `skill_trees` VALUES (107, 766, 1, 'Sixth Sense', 0, 81);
INSERT INTO `skill_trees` VALUES (108, 759, 1, 'Archer''s Will', 0, 81);
INSERT INTO `skill_trees` VALUES (108, 758, 4, 'Fighter''s Will', 0, 81);
INSERT INTO `skill_trees` VALUES (108, 757, 1, 'Protection of Alignment', 0, 82);
INSERT INTO `skill_trees` VALUES (108, 756, 1, 'Protection of Elemental', 0, 82);
INSERT INTO `skill_trees` VALUES (108, 755, 1, 'Protection of Rune', 0, 82);
INSERT INTO `skill_trees` VALUES (108, 767, 1, 'Expose Weak Point', 0, 81);
INSERT INTO `skill_trees` VALUES (108, 770, 1, 'Ghost Walking', 0, 83);
INSERT INTO `skill_trees` VALUES (108, 766, 1, 'Sixth Sense', 0, 81);
INSERT INTO `skill_trees` VALUES (109, 759, 1, 'Archer''s Will', 0, 81);
INSERT INTO `skill_trees` VALUES (109, 758, 1, 'Fighter''s Will', 0, 81);
INSERT INTO `skill_trees` VALUES (109, 757, 1, 'Protection of Alignment', 0, 82);
INSERT INTO `skill_trees` VALUES (109, 756, 1, 'Protection of Elemental', 0, 82);
INSERT INTO `skill_trees` VALUES (109, 755, 1, 'Protection of Rune', 0, 82);
INSERT INTO `skill_trees` VALUES (109, 773, 1, 'Ghost Piercing', 0, 83);
INSERT INTO `skill_trees` VALUES (110, 757, 1, 'Protection of Alignment', 0, 82);
INSERT INTO `skill_trees` VALUES (110, 756, 1, 'Protection of Elemental', 0, 82);
INSERT INTO `skill_trees` VALUES (110, 755, 1, 'Protection of Rune', 0, 82);
INSERT INTO `skill_trees` VALUES (110, 1494, 1, 'Hurricane Armor', 0, 83);
INSERT INTO `skill_trees` VALUES (111, 757, 1, 'Protection of Alignment', 0, 82);
INSERT INTO `skill_trees` VALUES (111, 756, 1, 'Protection of Elemental', 0, 82);
INSERT INTO `skill_trees` VALUES (111, 755, 1, 'Protection of Rune', 0, 82);
INSERT INTO `skill_trees` VALUES (111, 1496, 1, 'Servitor Barrier', 0, 81);
INSERT INTO `skill_trees` VALUES (111, 1497, 1, 'Excessive Loyalty', 0, 81);
INSERT INTO `skill_trees` VALUES (111, 1498, 1, 'Mutual Response', 0, 81);
INSERT INTO `skill_trees` VALUES (112, 757, 1, 'Protection of Alignment', 0, 82);
INSERT INTO `skill_trees` VALUES (112, 756, 1, 'Protection of Elemental', 0, 82);
INSERT INTO `skill_trees` VALUES (112, 755, 1, 'Protection of Rune', 0, 82);
INSERT INTO `skill_trees` VALUES (112, 1507, 1, 'Lord of Vampire', 0, 83);
INSERT INTO `skill_trees` VALUES (113, 759, 1, 'Archer''s Will', 0, 81);
INSERT INTO `skill_trees` VALUES (113, 758, 1, 'Fighter''s Will', 0, 81);
INSERT INTO `skill_trees` VALUES (113, 757, 1, 'Protection of Alignment', 0, 82);
INSERT INTO `skill_trees` VALUES (113, 756, 1, 'Protection of Elemental', 0, 82);
INSERT INTO `skill_trees` VALUES (113, 755, 1, 'Protection of Rune', 0, 82);
INSERT INTO `skill_trees` VALUES (113, 777, 1, 'Demolition Impact', 0, 83);
INSERT INTO `skill_trees` VALUES (114, 759, 1, 'Archer''s Will', 0, 81);
INSERT INTO `skill_trees` VALUES (114, 758, 1, 'Fighter''s Will', 0, 81);
INSERT INTO `skill_trees` VALUES (114, 757, 1, 'Protection of Alignment', 0, 82);
INSERT INTO `skill_trees` VALUES (114, 756, 1, 'Protection of Elemental', 0, 82);
INSERT INTO `skill_trees` VALUES (114, 755, 1, 'Protection of Rune', 0, 82);
INSERT INTO `skill_trees` VALUES (114, 776, 1, 'Force of Destruction', 0, 83);
INSERT INTO `skill_trees` VALUES (115, 757, 1, 'Protection of Alignment', 0, 82);
INSERT INTO `skill_trees` VALUES (115, 756, 1, 'Protection of Elemental', 0, 82);
INSERT INTO `skill_trees` VALUES (115, 755, 1, 'Protection of Rune', 0, 82);
INSERT INTO `skill_trees` VALUES (115, 1509, 1, 'Seal of Limit', 0, 83);
INSERT INTO `skill_trees` VALUES (116, 757, 1, 'Protection of Alignment', 0, 82);
INSERT INTO `skill_trees` VALUES (116, 756, 1, 'Protection of Elemental', 0, 82);
INSERT INTO `skill_trees` VALUES (116, 755, 1, 'Protection of Rune', 0, 82);
INSERT INTO `skill_trees` VALUES (117, 759, 1, 'Archer''s Will', 0, 81);
INSERT INTO `skill_trees` VALUES (117, 758, 1, 'Fighter''s Will', 0, 81);
INSERT INTO `skill_trees` VALUES (117, 757, 1, 'Protection of Alignment', 0, 82);
INSERT INTO `skill_trees` VALUES (117, 756, 1, 'Protection of Elemental', 0, 82);
INSERT INTO `skill_trees` VALUES (117, 755, 1, 'Protection of Rune', 0, 82);
INSERT INTO `skill_trees` VALUES (118, 759, 1, 'Archer''s Will', 0, 81);
INSERT INTO `skill_trees` VALUES (118, 758, 1, 'Fighter''s Will', 0, 81);
INSERT INTO `skill_trees` VALUES (118, 757, 1, 'Protection of Alignment', 0, 82);
INSERT INTO `skill_trees` VALUES (118, 756, 1, 'Protection of Elemental', 0, 82);
INSERT INTO `skill_trees` VALUES (118, 755, 1, 'Protection of Rune', 0, 82);
INSERT INTO `skill_trees` VALUES (118, 778, 1, 'Golem Armor', 0, 83);
INSERT INTO `skill_trees` VALUES (131, 759, 1, 'Archer''s Will', 0, 81);
INSERT INTO `skill_trees` VALUES (131, 758, 1, 'Fighter''s Will', 0, 81);
INSERT INTO `skill_trees` VALUES (131, 757, 1, 'Protection of Alignment', 0, 82);
INSERT INTO `skill_trees` VALUES (131, 756, 1, 'Protection of Elemental', 0, 82);
INSERT INTO `skill_trees` VALUES (131, 755, 1, 'Protection of Rune', 0, 82);
INSERT INTO `skill_trees` VALUES (132, 759, 1, 'Archer''s Will', 0, 81);
INSERT INTO `skill_trees` VALUES (132, 758, 1, 'Fighter''s Will', 0, 81);
INSERT INTO `skill_trees` VALUES (132, 757, 1, 'Protection of Alignment', 0, 82);
INSERT INTO `skill_trees` VALUES (132, 756, 1, 'Protection of Elemental', 0, 82);
INSERT INTO `skill_trees` VALUES (132, 755, 1, 'Protection of Rune', 0, 82);
INSERT INTO `skill_trees` VALUES (132, 791, 1, 'Lightning Shock', 0, 83);
INSERT INTO `skill_trees` VALUES (133, 759, 1, 'Archer''s Will', 0, 81);
INSERT INTO `skill_trees` VALUES (133, 758, 1, 'Fighter''s Will', 0, 81);
INSERT INTO `skill_trees` VALUES (133, 757, 1, 'Protection of Alignment', 0, 82);
INSERT INTO `skill_trees` VALUES (133, 756, 1, 'Protection of Elemental', 0, 82);
INSERT INTO `skill_trees` VALUES (133, 755, 1, 'Protection of Rune', 0, 82);
INSERT INTO `skill_trees` VALUES (133, 791, 1, 'Lightning Shock', 0, 83);
INSERT INTO `skill_trees` VALUES (134, 759, 1, 'Archer''s Will', 0, 81);
INSERT INTO `skill_trees` VALUES (134, 758, 1, 'Fighter''s Will', 0, 81);
INSERT INTO `skill_trees` VALUES (134, 757, 1, 'Protection of Alignment', 0, 82);
INSERT INTO `skill_trees` VALUES (134, 756, 1, 'Protection of Elemental', 0, 82);
INSERT INTO `skill_trees` VALUES (134, 755, 1, 'Protection of Rune', 0, 82);
INSERT INTO `skill_trees` VALUES (134, 790, 1, 'Wild Shot', 0, 83);
INSERT INTO `skill_trees` VALUES (117, 915, 1, 'Dance of Berserker', 0, 83);
INSERT INTO `skill_trees` VALUES (89, 767, 1, 'Expose Weak Point', 0, 81);
INSERT INTO `skill_trees` VALUES (89, 917, 1, 'Champion''s Favor', 0, 81);
INSERT INTO `skill_trees` VALUES (88, 767, 1, 'Expose Weak Point', 0, 81);
INSERT INTO `skill_trees` VALUES (88, 917, 1, 'Champion''s Favor', 0, 81);
INSERT INTO `skill_trees` VALUES (88, 919, 1, 'Maximum Focus Sonic', 0, 83);
INSERT INTO `skill_trees` VALUES (90, 766, 1, 'Sixth Sense', 0, 81);
INSERT INTO `skill_trees` VALUES (90, 913, 1, 'Deflect Magic', 0, 81);
INSERT INTO `skill_trees` VALUES (90, 912, 1, 'Summon Imperial Phoenix', 0, 83);
INSERT INTO `skill_trees` VALUES (91, 766, 1, 'Sixth Sense', 0, 81);
INSERT INTO `skill_trees` VALUES (91, 913, 1, 'Deflect Magic', 0, 81);
INSERT INTO `skill_trees` VALUES (92, 924, 1, 'Seven Arrow', 0, 81);
INSERT INTO `skill_trees` VALUES (92, 946, 1, 'Silent Mind', 0, 81);
INSERT INTO `skill_trees` VALUES (93, 922, 1, 'Hide', 0, 81);
INSERT INTO `skill_trees` VALUES (93, 923, 1, 'Dual Dagger Mastery', 0, 81);
INSERT INTO `skill_trees` VALUES (94, 945, 1, 'Magician''s Will', 0, 81);
INSERT INTO `skill_trees` VALUES (94, 1467, 1, 'Meteor', 0, 81);
INSERT INTO `skill_trees` VALUES (94, 1532, 1, 'Enlightenment', 0, 81);
INSERT INTO `skill_trees` VALUES (95, 945, 1, 'Magician''s Will', 0, 81);
INSERT INTO `skill_trees` VALUES (95, 1467, 1, 'Meteor', 0, 81);
INSERT INTO `skill_trees` VALUES (95, 1532, 1, 'Enlightenment', 0, 81);
INSERT INTO `skill_trees` VALUES (96, 945, 1, 'Magician''s Will', 0, 81);
INSERT INTO `skill_trees` VALUES (96, 929, 1, 'Spirit of the Cat', 0, 83);
INSERT INTO `skill_trees` VALUES (97, 945, 1, 'Magician''s Will', 0, 81);
INSERT INTO `skill_trees` VALUES (97, 1533, 1, 'Enlightenment', 0, 81);
INSERT INTO `skill_trees` VALUES (97, 1540, 1, 'Turn to Stone', 0, 81);
INSERT INTO `skill_trees` VALUES (98, 945, 1, 'Magician''s Will', 0, 81);
INSERT INTO `skill_trees` VALUES (98, 1533, 1, 'Enlightenment', 0, 81);
INSERT INTO `skill_trees` VALUES (98, 1540, 1, 'Turn to Stone', 0, 81);
INSERT INTO `skill_trees` VALUES (98, 1542, 1, 'Counter Critical', 0, 83);
INSERT INTO `skill_trees` VALUES (99, 766, 1, 'Sixth Sense', 0, 81);
INSERT INTO `skill_trees` VALUES (99, 913, 1, 'Deflect Magic', 0, 81);
INSERT INTO `skill_trees` VALUES (100, 766, 1, 'Sixth Sense', 0, 81);
INSERT INTO `skill_trees` VALUES (100, 913, 1, 'Deflect Magic', 0, 81);
INSERT INTO `skill_trees` VALUES (100, 914, 1, 'Song of Purification', 0, 83);
INSERT INTO `skill_trees` VALUES (101, 922, 1, 'Hide', 0, 81);
INSERT INTO `skill_trees` VALUES (101, 923, 1, 'Dual Dagger Mastery', 0, 81);
INSERT INTO `skill_trees` VALUES (102, 924, 1, 'Seven Arrow', 0, 81);
INSERT INTO `skill_trees` VALUES (102, 946, 1, 'Silent Mind', 0, 81);
INSERT INTO `skill_trees` VALUES (103, 945, 1, 'Magician''s Will', 0, 81);
INSERT INTO `skill_trees` VALUES (103, 1468, 1, 'Star Fall', 0, 81);
INSERT INTO `skill_trees` VALUES (103, 1532, 1, 'Enlightenment', 0, 81);
INSERT INTO `skill_trees` VALUES (104, 945, 1, 'Magician''s Will', 0, 81);
INSERT INTO `skill_trees` VALUES (104, 931, 1, 'Spirit of the Unicorn', 0, 83);
INSERT INTO `skill_trees` VALUES (105, 945, 1, 'Magician''s Will', 0, 81);
INSERT INTO `skill_trees` VALUES (105, 1533, 1, 'Enlightenment', 0, 81);
INSERT INTO `skill_trees` VALUES (105, 1540, 1, 'Turn to Stone', 0, 81);
INSERT INTO `skill_trees` VALUES (106, 766, 1, 'Sixth Sense', 0, 81);
INSERT INTO `skill_trees` VALUES (106, 913, 1, 'Deflect Magic', 0, 81);
INSERT INTO `skill_trees` VALUES (107, 913, 1, 'Magician''s Will', 0, 81);
INSERT INTO `skill_trees` VALUES (108, 758, 1, 'Fighter''s Will', 0, 81);
INSERT INTO `skill_trees` VALUES (108, 922, 1, 'Hide', 0, 81);
INSERT INTO `skill_trees` VALUES (108, 923, 1, 'Dual Dagger Mastery', 0, 81);
INSERT INTO `skill_trees` VALUES (109, 924, 1, 'Seven Arrow', 0, 81);
INSERT INTO `skill_trees` VALUES (109, 946, 1, 'Silent Mind', 0, 81);
INSERT INTO `skill_trees` VALUES (110, 945, 1, 'Magician''s Will', 0, 81);
INSERT INTO `skill_trees` VALUES (110, 1468, 1, 'Star Fall', 0, 81);
INSERT INTO `skill_trees` VALUES (110, 1532, 1, 'Enlightenment', 0, 81);
INSERT INTO `skill_trees` VALUES (111, 945, 1, 'Magician''s Will', 0, 81);
INSERT INTO `skill_trees` VALUES (112, 945, 1, 'Magician''s Will', 0, 81);
INSERT INTO `skill_trees` VALUES (112, 1533, 1, 'Enlightenment', 0, 81);
INSERT INTO `skill_trees` VALUES (112, 1540, 1, 'Turn to Stone', 0, 81);
INSERT INTO `skill_trees` VALUES (113, 767, 1, 'Expose Weak Point', 0, 81);
INSERT INTO `skill_trees` VALUES (113, 917, 1, 'Champion''s Favor', 0, 81);
INSERT INTO `skill_trees` VALUES (114, 767, 1, 'Expose Weak Point', 0, 81);
INSERT INTO `skill_trees` VALUES (114, 917, 1, 'Champion''s Favor', 0, 81);
INSERT INTO `skill_trees` VALUES (114, 918, 1, 'Maximum Focus Force', 0, 83);
INSERT INTO `skill_trees` VALUES (115, 945, 1, 'Magician''s Will', 0, 81);
INSERT INTO `skill_trees` VALUES (115, 1533, 1, 'Enlightenment', 0, 81);
INSERT INTO `skill_trees` VALUES (115, 1540, 1, 'Turn to Stone', 0, 81);
INSERT INTO `skill_trees` VALUES (115, 949, 1, 'Onslaught of Pa''agrio', 0, 83);
INSERT INTO `skill_trees` VALUES (116, 945, 1, 'Magician''s Will', 0, 81);
INSERT INTO `skill_trees` VALUES (116, 1533, 1, 'Enlightenment', 0, 81);
INSERT INTO `skill_trees` VALUES (116, 1540, 1, 'Turn to Stone', 0, 81);
INSERT INTO `skill_trees` VALUES (116, 1543, 1, 'Great Fury', 0, 81);
INSERT INTO `skill_trees` VALUES (118, 767, 1, 'Expose Weak Point', 0, 81);
INSERT INTO `skill_trees` VALUES (118, 917, 1, 'Champion''s Favor', 0, 81);
INSERT INTO `skill_trees` VALUES (117, 767, 1, 'Expose Weak Point', 0, 81);
INSERT INTO `skill_trees` VALUES (117, 917, 1, 'Champion''s Favor', 0, 81);
INSERT INTO `skill_trees` VALUES (117, 947, 1, 'Lucky Strike', 0, 83);
INSERT INTO `skill_trees` VALUES (131, 767, 1, 'Expose Weak Point', 0, 81);
INSERT INTO `skill_trees` VALUES (131, 917, 1, 'Champion''s Favor', 0, 81);
INSERT INTO `skill_trees` VALUES (131, 948, 1, 'Eye for Eye', 0, 83);
INSERT INTO `skill_trees` VALUES (132, 766, 1, 'Sixth Sense', 0, 81);
INSERT INTO `skill_trees` VALUES (132, 767, 1, 'Expose Weak Point', 0, 81);
INSERT INTO `skill_trees` VALUES (132, 1532, 1, 'Enlightenment', 0, 81);
INSERT INTO `skill_trees` VALUES (133, 766, 1, 'Sixth Sense', 0, 81);
INSERT INTO `skill_trees` VALUES (133, 767, 1, 'Expose Weak Point', 0, 81);
INSERT INTO `skill_trees` VALUES (133, 1532, 1, 'Enlightenment', 0, 81);
INSERT INTO `skill_trees` VALUES (107, 930, 1, 'Spirit of the Demon', 0, 83);
загрузка наград ...
 
stelerbd77Дата: Четверг, 19.08.2010, 14:51 | Сообщение # 12
stelerbd77
Группа: Постоянный
Сообщений: 3
Награды: 0
Репутация: 0
Статус: Offline
не пашит на грацыи чтоб в нг топе шмоте поевляется и пухи!!
5555555555555
загрузка наград ...
 
ProgaverДата: Четверг, 19.08.2010, 15:14 | Сообщение # 13
Progaver
Группа: Постоянный
Сообщений: 48
Награды: 1
Репутация: 1
Статус: Offline
Кстати нужная вещь, автору + в репу


загрузка наград ...
 
anton_chikovДата: Пятница, 15.10.2010, 11:11 | Сообщение # 14
anton_chikov
Группа: Постоянный
Сообщений: 137
Награды: 8
Репутация: 0
Статус: Offline
Вот я добавил ГТ-глобальный телепорт, но я его запарюсь ставить по всему миру в lineage 2 ,скажите пожалуйста как быстро проставить его ?
Через запрос базу данных

загрузка наград ...
 
ОвощДата: Пятница, 15.10.2010, 15:37 | Сообщение # 15
Овощ
Группа: Администратор
Сообщений: 2494
Награды: 162
Репутация: 5547
Статус: Offline
В любом случае тебе понадобятся координаты в каждом месте, где он установится.
Быстрее не получится.
Вёрстка макетов и создание клан сайтов на uCoz, STRESS - в ICQ
Хлеба и зрелищ
загрузка наград ...
 
anton_chikovДата: Пятница, 15.10.2010, 16:17 | Сообщение # 16
anton_chikov
Группа: Постоянный
Сообщений: 137
Награды: 8
Репутация: 0
Статус: Offline
а координаты где храняться?

загрузка наград ...
 
ОвощДата: Пятница, 15.10.2010, 21:35 | Сообщение # 17
Овощ
Группа: Администратор
Сообщений: 2494
Награды: 162
Репутация: 5547
Статус: Offline
/loc
Вёрстка макетов и создание клан сайтов на uCoz, STRESS - в ICQ
Хлеба и зрелищ
загрузка наград ...
 
BizonДата: Суббота, 16.10.2010, 02:02 | Сообщение # 18
Bizon
Группа: Постоянный
Сообщений: 14
Награды: 0
Репутация: 0
Статус: Offline
координаты писать долго к тому ж надо точно знать Z координату, чтоб потом твой ГГК не провалился под землю... самый быстрый вариант это в игре делаешь макрос //spawn id (вместо id вводишь цифры своего ггк) и через админский тп летаешь и ставишь его именно туда куда приперло... если руки прямые уложиться минут в 5 biggrin
загрузка наград ...
 
TIFIДата: Суббота, 23.10.2010, 23:45 | Сообщение # 19
TIFI
Группа: Постоянный
Сообщений: 10
Награды: 0
Репутация: 0
Статус: Offline
Все понел в чом ошибка в конце не ставил ";"
-=TI[F]I=-
загрузка наград ...
 
ОвощДата: Вторник, 02.11.2010, 21:44 | Сообщение # 20
Овощ
Группа: Администратор
Сообщений: 2494
Награды: 162
Репутация: 5547
Статус: Offline
Изменить титул всех NPC
Code
update npc SET title = 'l2eit.ru' where id between 1 and 99999;
update npc SET serverSideTitle = '1' where id between 1 and 99999;
update npc SET serverSideName = '1' where id between 1 and 99999;
Вёрстка макетов и создание клан сайтов на uCoz, STRESS - в ICQ
Хлеба и зрелищ
загрузка наград ...
 
FAQДата: Четверг, 09.12.2010, 20:48 | Сообщение # 21
FAQ
Группа: Заблокированные
Сообщений: 105
Награды: 4
Репутация: 9
Статус: Offline
Респ Автору)) biggrin
1.Мб Смож Мне зделать весь дроп удалить У всех Мобов!!!
2.И ищо как зделать скил ТП в Определенну зону,и Зделать Ево начальним)) (Например Гиран Хербор,МНЕ ТУДА НУЖНО)
Второй Главней tongue

загрузка наград ...

Сообщение отредактировал k911 - Четверг, 09.12.2010, 20:53
 
ОвощДата: Четверг, 09.12.2010, 20:53 | Сообщение # 22
Овощ
Группа: Администратор
Сообщений: 2494
Награды: 162
Репутация: 5547
Статус: Offline
Убрать весь дроп, кроме аден:
Code
DELETE FROM droplist WHERE itemId NOT IN (57);
Вёрстка макетов и создание клан сайтов на uCoz, STRESS - в ICQ
Хлеба и зрелищ
загрузка наград ...
 
FAQДата: Четверг, 09.12.2010, 21:40 | Сообщение # 23
FAQ
Группа: Заблокированные
Сообщений: 105
Награды: 4
Репутация: 9
Статус: Offline
Спс а Вот как Со скилом Мона както Зделать?

загрузка наград ...
 
ОвощДата: Четверг, 09.12.2010, 21:41 | Сообщение # 24
Овощ
Группа: Администратор
Сообщений: 2494
Награды: 162
Репутация: 5547
Статус: Offline
мануал видел в интернете. гугли.
Вёрстка макетов и создание клан сайтов на uCoz, STRESS - в ICQ
Хлеба и зрелищ
загрузка наград ...
 
FAQДата: Четверг, 09.12.2010, 21:43 | Сообщение # 25
FAQ
Группа: Заблокированные
Сообщений: 105
Награды: 4
Репутация: 9
Статус: Offline
Quote (Снус-Мумрик)
мануал видел в интернете. гугли.

Дай силочку плз... tongue

загрузка наград ...

Сообщение отредактировал k911 - Четверг, 09.12.2010, 21:45
 
Форум L2edit.Ru » Lineage 2 » Раздел для новичков » Самые нужные SQL запросы в Lineage 2
  • Страница 1 из 2
  • 1
  • 2
  • »
Поиск:


Копирование материалов запрещено!
© 2011 L2Edit.ru | Sitemap.xml
Хостинг от uCoz