Dubna - TBDev - La2 - WoW - AION - CS

�� !

mybb@mybb.ru (��) — Fri, 17 Sep 2010 17:19:27 +0400

�� ! �� (��, ��, �� .�.). �� . �� Lineage2? �� ! �� , �� ! �� !

�� FXv3_l2maxi.ru.rar c Getzilla

MySQL Backup v2.0 - �� MySQL

mybb@mybb.ru (��) — Fri, 17 Sep 2010 17:12:03 +0400

�� , �� (��) ��. �� , �� 100% �� . � �� , �� , �� , �� , ��-�� . �� . ��

�� MySQL_Backup_v2.0.rar c Getzilla

FAQ �� .

mybb@mybb.ru (��) — Fri, 17 Sep 2010 17:10:01 +0400

�� .

� �� FileEdit �� L2 FileEdit-Pro.exe c Getzilla
. �� , �� .

�� FileEdit � �� , �� :

1. � armorgrp.dat - �� .
2. � weapongrp.dat - �� .

�� , � �� armorgrp.dat.

�� FileEdit-�� armorgrp.dat �� "�� :\�� \Lineage2\system\".
�� :) �� , �� ID �� . � �� :

1 5288 0 3 8 4 0 dropitems.drop_MFighter_m009_t74_l_m00 mfighter.MFighter_m009_t74_l icon.armor_t74_l_i02 95 3320 23 1 0 11 1 Fighter.MFighter_m009_l 1 mfighter.MFighter_m009_t74_l 1 1 1 Fighter.FFighter_m012_l 1 FFighter.FFighter_m012_t74_l 1 1 1 DarkElf.MDarkElf_m004_l 1 MDarkElf.MDarkElf_m004_t74_l 1 1 1 DarkElf.FDarkElf_m008_l 1 FDarkElf.FDarkElf_m008_t74_l 1 1 1 Dwarf.MDwarf_m008_l 1 MDwarf.MDwarf_m008_t74_l 1 1 1 Dwarf.FDwarf_m008_l 1 FDwarf.FDwarf_m008_t74_l 1 1 1 Elf.MElf_m011_l 1 MElf.MElf_m011_t74_l 1 1 1 Elf.FElf_m011_l 1 FElf.FElf_m011_t74_l 1 1 1 Magic.MMagic_m012_l 1 MMagic.MMagic_m012_t74_l 1 1 1 Magic.FMagic_m011_l 1 FMagic.FMagic_m011_t74_l 1 1 1 Orc.MOrc_m006_l 1 MOrc.MOrc_m006_t74_l 1 1 1 Orc.FOrc_m006_l 1 FOrc.FOrc_m006_t74_l 1 1 1 Shaman.MShaman_m006_l 1 MShaman.MShaman_m006_t76_l 1 1 1 Shaman.FShaman_m006_l 1 FShaman.FShaman_m006_t76_l 1 1 0 0 0 0 1 1 LineageEffect.p_u002_a 1 ItemSound.itemdrop_armor_leather ItemSound.itemequip_armor_leather 1 0 2 4 0 107 0 0

�� : 1 0 2 4 0 107 0 0 � �� (4), �� .

�� .

�� weapongrp.dat �� .

� �� , �� FileEdit � �� weapongrp.dat �� "�� :\�� \Lineage2\system\".
� �� , �� , �� ID. � �� (Homunkuluss Sword)

0 84 1 1 7 10 0 LineageWeapons.homunkuluss_sword_m00_wp LineageWeaponsTex.homunkuluss_sword_t00_wp icon.weapon_homunkuluss_sword_i00 95 950 48 1 0 7 1 1 LineageWeapons.homunkuluss_sword_m00_wp 1 LineageWeaponsTex.homunkuluss_sword_t00_wp 4 ItemSound.sword_small_1 ItemSound.sword_big_1 ItemSound.sword_great_4 ItemSound.public_sword_shing_10 ItemSound.itemdrop_sword ItemSound.itemequip_sword 10 111 101 1 2 8 0 0 0 0 379 0 3 3 1000 0 -1 0 0.0000000 0.0000000 0.0000000 1.0000000 1.0000000 LineageWeapons.rangesample 1.2000000 0.8000000 0.8000000 16.0000000 0.0000000 0.0000000

�� : 10 111 101 1 2 8 0 0 0 0 379 0 3 3 1000 0 -1 0 � �� (2) �� .

�� (4, 2 � �.�).

1. (0) Non-Grade
2. (1) D-Grade
3. (2) C-Grade
4. (3) B-Grade
5. (4) A-Grade
6. (5) S-Grade

�� , �� ID 5288 �� , �� A-Grade, � �� , �� C-Grade.

��! �� ID �� . �� : 0 84 �� ID ��.

�� ! �� Lineage 2 � � �� .

�� Sql ��. �� 3

mybb@mybb.ru (��) — Fri, 17 Sep 2010 16:28:00 +0400

��
�� No-Grade ��
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);

�� D Grade ��
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);

�� C Grade ��
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);

�� B Grade ��
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);

�� A Grade ��
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);

�� B Grade ��
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);

��
��: Arcana Mace � DC Robe Set
��: Angel Slayer � Drac Light Set
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);

��

�� 100%
UPDATE `droplist` SET `chance`='1000000' WHERE `itemId`='57';

�� 1� �� 10�� (�� 1)
UPDATE `droplist` SET `droplist`.`min`=1000000 WHERE `droplist`.`itemId`=57;
UPDATE `droplist` SET `droplist`.`max`=10000000 WHERE `droplist`.`itemId`=57;

�� (�� 0 ��)
UPDATE `armor` SET price=0 where price > 1;
UPDATE `etcitem` SET price=0 where price > 1;
UPDATE `weapon` SET price=0 where price > 1;

��
UPDATE teleport SET price=0;

�� 5 ��
UPDATE henna SET price=5;

��

�� 10%
UPDATE char_templates SET P_DEF = P_DEF * 1.1;
UPDATE char_templates SET M_DEF = M_DEF * 1.1;

�� 20%
UPDATE char_templates SET MOVE_SPD = MOVE_SPD * 1.2;

�� CP �� 22% �� 20 ��. �� 44% �� 40 ��. �� 66% �� 76 ��
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 ��
UPDATE lvlupgain SET defaultmpmod = defaultmpmod * 10.0;

�� (Str,Int,Dex,Wit,Men,Con) �� 2 ��
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');

�� Sql ��. �� 2

mybb@mybb.ru (��) — Fri, 17 Sep 2010 16:27:09 +0400

��

��
DELETE FROM droplist WHERE itemId='1864';
DELETE FROM droplist WHERE itemId='1865';
DELETE FROM droplist WHERE itemId='1866';
DELETE FROM droplist WHERE itemId='1868';
DELETE FROM droplist WHERE itemId='1869';
DELETE FROM droplist WHERE itemId='1870';
DELETE FROM droplist WHERE itemId='1871';
DELETE FROM droplist WHERE itemId='1872';
DELETE FROM droplist WHERE itemId='1873';
DELETE FROM droplist WHERE itemId='1874';
DELETE FROM droplist WHERE itemId='1875';
DELETE FROM droplist WHERE itemId='1876';
DELETE FROM droplist WHERE itemId='1877';
DELETE FROM droplist WHERE itemId='1878';
DELETE FROM droplist WHERE itemId='1879';
DELETE FROM droplist WHERE itemId='1880';
DELETE FROM droplist WHERE itemId='1881';
DELETE FROM droplist WHERE itemId='1882';
DELETE FROM droplist WHERE itemId='1884';
DELETE FROM droplist WHERE itemId='1885';
DELETE FROM droplist WHERE itemId='1895';
DELETE FROM droplist WHERE itemId='5549';
DELETE FROM droplist WHERE itemId='1886';
DELETE FROM droplist WHERE itemId='1887';
DELETE FROM droplist WHERE itemId='1888';
DELETE FROM droplist WHERE itemId='1890';
DELETE FROM droplist WHERE itemId='1891';
DELETE FROM droplist WHERE itemId='1892';
DELETE FROM droplist WHERE itemId='1893';
DELETE FROM droplist WHERE itemId='1889';
DELETE FROM droplist WHERE itemId='1894';
DELETE FROM droplist WHERE itemId='4039';
DELETE FROM droplist WHERE itemId='4040';
DELETE FROM droplist WHERE itemId='4041';
DELETE FROM droplist WHERE itemId='4042';
DELETE FROM droplist WHERE itemId='4043';
DELETE FROM droplist WHERE itemId='4044';
DELETE FROM droplist WHERE itemId='4046';
DELETE FROM droplist WHERE itemId='4047';
DELETE FROM droplist WHERE itemId='4045';
DELETE FROM droplist WHERE itemId='5550';
DELETE FROM droplist WHERE itemId='4048';

��
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';

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

�� (Cursed Bone)
DELETE FROM droplist WHERE itemId='2508';

�� (SOE)
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';

��
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;

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

��
DELETE FROM droplist WHERE itemid IN (SELECT item_id FROM etcitem WHERE item_type= 'spellbook' );

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

�� , �� , ��, �� , ��, �� , ��
DELETE FROM droplist
WHERE mobid NOT IN (SELECT id FROM npc WHERE TYPE = 'L2GrandBoss')
AND mobid NOT IN (SELECT id FROM npc WHERE TYPE = 'L2RaidBoss')
AND itemid NOT IN (SELECT item_id FROM weapon)
AND itemid NOT IN (SELECT item_id FROM armor)
AND itemid NOT IN (SELECT item_id FROM etcitem WHERE name LIKE 'adena')
AND itemid NOT IN (SELECT item_id FROM etcitem WHERE name LIKE '%life stone%')
AND itemid NOT IN (SELECT item_id FROM etcitem WHERE name LIKE '%seal stone%')
AND itemid NOT IN (SELECT item_id FROM etcitem WHERE name LIKE '%enchant%' AND item_type = 'scroll')

�� ID 57 (Adena) � 4037 (CoL)
DELETE FROM droplist WHERE itemId NOT IN (57,4037);

��

�� "��" (Return) ��
INSERT INTO skill_trees VALUES (0, 1050, 2, "Return", 0, 1);
INSERT INTO skill_trees VALUES (10, 1050, 2, "Return", 0, 1);
INSERT INTO skill_trees VALUES (18, 1050, 2, "Return", 0, 1);
INSERT INTO skill_trees VALUES (25, 1050, 2, "Return", 0, 1);
INSERT INTO skill_trees VALUES (31, 1050, 2, "Return", 0, 1);
INSERT INTO skill_trees VALUES (38, 1050, 2, "Return", 0, 1);
INSERT INTO skill_trees VALUES (44, 1050, 2, "Return", 0, 1);
INSERT INTO skill_trees VALUES (49, 1050, 2, "Return", 0, 1);
INSERT INTO skill_trees VALUES (53, 1050, 2, "Return", 0, 1);
INSERT INTO skill_trees VALUES (123, 1050, 2, "Return", 0, 1);
INSERT INTO skill_trees VALUES (124, 1050, 2, "Return", 0, 1);

��
INSERT INTO `clan_skills` VALUES
('��_��','370','3','Clan Vitality'),
('��_��','371','3','Clan Spirituality'),
('��_��','372','3','Clan Essence'),
('��_��','373','3','Clan Lifeblood'),
('��_��','374','3','Clan Morale'),
('��_��','375','3','Clan Clarity'),
('��_��','376','3','Clan Might'),
('��_��','377','3','Clan Aegis'),
('��_��','378','3','Clan Empowerment'),
('��_��','379','3','Clan Magic Protection'),
('��_��','380','3','Clan Guidance'),
('��_��','381','3','Clan Agility'),
('��_��','382','3','Clan Withstand-Attack'),
('��_��','383','3','Clan Shield Boost'),
('��_��','384','3','Clan Cyclonic Resistance'),
('��_��','385','3','Clan Magmatic Resistance'),
('��_��','386','3','Clan Fortitude'),
('��_��','387','3','Clan Freedom'),
('��_��','388','3','Clan Vigilance'),
('��_��','389','3','Clan March'),
('��_��','390','3','Clan Luck'),
('��_��','391','1','Clan Imperium');

�� SP
UPDATE enchant_skill_trees SET sp=0;
UPDATE enchant_skill_trees SET exp=0;

�� (Great Penalty)
DELETE FROM skill_trees WHERE skill_id = 239;

��

�� 1 �� 2 ��
UPDATE `raidboss_spawnlist` SET `respawn_min_delay` = '3600';
UPDATE `raidboss_spawnlist` SET `respawn_max_delay` = '7200';

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

�� (�� )
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');

�� SQL �� L2java

mybb@mybb.ru (��) — Fri, 17 Sep 2010 16:25:52 +0400

�� MySQL �� , �� , �� girl_claping

�� . �� SQL �� .
�� SQL ��.
1. �� .

INSERT INTO global_tasks (task,type,last_activation,param1,param2,param3) VALUES ('restart','TYPE_GLOBAL_TASK','0','1','04:50:00','600');

�� , �� 4:50 � �� 600 ��(�.�. � 5:00)
2. �� , � �� Weight Limit

INSERT INTO skill_trees VALUES (0, 150, 1, "Weight Limit", 0, 1);
INSERT INTO skill_trees VALUES (10, 150, 1, "Weight Limit", 0, 1);
INSERT INTO skill_trees VALUES (18, 150, 1, "Weight Limit", 0, 1);
INSERT INTO skill_trees VALUES (25, 150, 1, "Weight Limit", 0, 1);
INSERT INTO skill_trees VALUES (31, 150, 1, "Weight Limit", 0, 1);
INSERT INTO skill_trees VALUES (38, 150, 1, "Weight Limit", 0, 1);
INSERT INTO skill_trees VALUES (44, 150, 1, "Weight Limit", 0, 1);
INSERT INTO skill_trees VALUES (49, 150, 1, "Weight Limit", 0, 1);
INSERT INTO skill_trees VALUES (53, 150, 1, "Weight Limit"", 0, 1);

�� , VALUES - 'class', 'skill', 'lvlskill', 'skillname'
('ID �� ', 'id ��', '�� ', '�� ', ..........)
3. �� .

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);

4. �� , �� :

DELETE FROM `droplist` WHERE (`itemId`!='57') AND (`category`='-1')

5. �� 100% (�� 70%) - �� :

UPDATE `droplist` SET `droplist`.`chance`=1000000 WHERE `droplist`.`itemId`=57;

6. �� . � � �� : �� (57) � �� (4037)

DELETE FROM droplist WHERE itemId NOT IN (57,4037);

��, �� : �� ID �� , �� .
7. � �� , � �� 5 ��, �� :

update etcitem set price=5 where price > 5;
update weapon set price=5 where price > 5;
update armor set price=5 where price > 5;

��, � �� , � �� (weight)

update etcitem set weight=1 where weight > 1;
update weapon set weight=1 where weight > 1;
update armor set weight=1 where weight > 1;

�� , � �� ectitem,weapon,armor - �� .
�� : zenn(c)2008.
�� PvP ��, �� -�� , �� , �� "item_id=6570" <- ID �� (�� ) � "owner_id=268634479" <-ID �� :)

delete from items where item_id=6570 and owner_id=268634479;

�� : Hellbeaver
�� Sql ��
1.��o� �a�poc ^ yc�a�a��ae� �a�c �po�a �a 0.5%, ��e po��o� �a�c �po�a �e��e 0.5%

UPDATE `droplist` SET `chance` = '5000' WHERE `chance` <= '5000';

2.�� a�poc� ^ y�e��a�� pe�� pec�a��a �o�o� � 3 pa�a

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;

3.�� a�poc� ^ �e�a�� pe�� pec�a��a Pe��occo�: ��.�pe�� - 1 �ac, �a�c.�pe�� - 2 �aca

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

4.�� a�poc� ^ �o��a�� .a��. � �.a�� 5 pa�, ��.�a�. � �.�a�. � 2 pa�a y �p��occo�(A��, Ba�� .�.)

UPDATE `npc` SET `patk` = `patk`*0.2 WHERE `type` = 'L2GrandBoss';
UPDATE `npc` SET `matk` = `matk`*0.2 WHERE `type` = 'L2GrandBoss';
UPDATE `npc` SET `pdef` = `pdef`*0.5 WHERE `type` = 'L2GrandBoss';
UPDATE `npc` SET `mdef` = `mdef`*0.5 WHERE `type` = 'L2GrandBoss';

5.�� a�poc� ^ �o��a�� .a��. � �.a�� 3 pa�a, ��.�a�. � �.�a�. � 1.2 pa� y M��o�o�

UPDATE `npc` SET `patk` = `patk`*0.33 WHERE `type` = 'L2Minion';
UPDATE `npc` SET `matk` = `matk`*0.33 WHERE `type` = 'L2Minion';
UPDATE `npc` SET `pdef` = `pdef`*0.8 WHERE `type` = 'L2Minion';
UPDATE `npc` SET `mdef` = `mdef`*0.8 WHERE `type` = 'L2Minion';

6.�� ^ �� .��, �.��. � ��.��, �.�� 1.2 ��

UPDATE `npc` SET `patk` = `patk`*0.8 WHERE `type` = 'L2Monster';
UPDATE `npc` SET `matk` = `matk`*0.8 WHERE `type` = 'L2Monster';
UPDATE `npc` SET `pdef` = `pdef`*0.8 WHERE `type` = 'L2Monster';
UPDATE `npc` SET `mdef` = `mdef`*0.8 WHERE `type` = 'L2Monster';

7.�� ^ �� .��. � �.�� 3 ��, ��.��. � �.��. � 1.2 ��

UPDATE `npc` SET `patk` = `patk`*0.33 WHERE `type` = 'L2RaidBoss';
UPDATE `npc` SET `matk` = `matk`*0.33 WHERE `type` = 'L2RaidBoss';
UPDATE `npc` SET `pdef` = `pdef`*0.8 WHERE `type` = 'L2RaidBoss';
UPDATE `npc` SET `mdef` = `mdef`*0.8 WHERE `type` = 'L2RaidBoss';

�� sourcemod (��)

mybb@mybb.ru (��) — Fri, 17 Sep 2010 14:03:26 +0400

��
�� . � �� "!ban bail" �� "sm_ban"
��
name - ��
#userid - ID �� , �� users
#steamid - Steamid �� , �� : � �� _ . �� : "#STEAM_0:1:4433", #STEAM_0_1_4433
# - �� #
@all - ��
@bots - ��
@alive - ��
@dead - ��
@humans - �� -��, ��
@aim - �� , ��
@me - ��
@!me - �� .
�� ..
� �� - sm_kick @all [...] , � [...] �� ..
�� , �� - sm_kick @alive [...]
�� @all, � �� , �� #, �� @all �� #@all
�� Counter-Strike:
@ct �� @cts - ��
@t �� @ts - ��
��
��
sm_addban basebans rcon <��> [��] �� .
sm_admin adminmenu admin ��
sm_ban basebans ban <��|��> <��|0> [��] ��
sm_banip basebans rcon <��> [��] �� ip
sm_cancelvote basecommands vote ��
sm_cvar basecommands cvar �� cvar ��
sm_execcfg basecommands config <�� > �� cfg
sm_help adminhelp admin [search] �� , �� .
sm_kick basecommands kick <#userid|name> [��] ��
sm_map basecommands map <�� > ��
sm_rcon basecommands rcon <��> �� rcon �� , �� rcon � server.cfg
sm_reloadadmins basecommands config �� .
sm_unban basebans unban �� Steam ID.
sm_who basecommands admin [#userid|name] �� , �� id �� .
sm_beacon basefuncommands slay <��> ��, �� , ��
sm_burn basefuncommands slay <��> [��] �� , � �� , ��
sm_chat basechat chat <��> �� , ��
sm_csay basechat chat <��> ��
sm_gag basecomm chat <��> ��
sm_hsay basechat chat <��> �� ..
sm_msay basechat chat <��> �� ..
sm_mute basecomm chat <��> ��
sm_play basefuncommands admin <��> <��> ��
sm_psay basechat chat <��> <��> �� , ��
sm_say basechat chat <��> ��
sm_silence basecomm chat <��> ��
sm_slap basefuncommands slay <��> [damage] "��" ��, � �� , �� .
sm_slay basefuncommands slay <��> ��
sm_tsay basechat chat [color] <��> �� , �� , ��
sm_ungag basecomm chat <��> ��
sm_unmute basecomm chat <��> ��
sm_unsilence basecomm chat <��> ��
sm_vote basevotes vote <��> [��1] [��2] [��3] ... ��
sm_votealltalk basefunvotes vote ��
sm_voteban basevotes vote, ban <��> [��] �� 30 ��
sm_voteburn basefunvotes vote, slay <��> �� "��" ��
sm_voteff basefunvotes vote �� (�� )
sm_votegravity basefunvotes vote <��> [amount2] [amount3] ... �� sv_gravity.
sm_votekick basevotes vote, kick <��> [��] ��
sm_votemap basevotes vote, map <��> [map2] [map3] ... ��
sm_voteslay basefunvotes vote, slay <��> ��

Players Votes v.1.5.0

mybb@mybb.ru (��) — Fri, 17 Sep 2010 14:01:53 +0400

Players Votes

��:
�� . �� votekick, �� voteban, �� votemute � �� timelimit votemap
��: say votekick, voteban, votemap � votemute �� .

��:
SourceMod 1.2 � ��

��:

SourceBans ��: �� votebans �� SourceBans, � �� SB.

Voteban ��: �� .

�� : �� . �� adminmenu_sorting.txt � admin overrides �� "pv_menu"

Immunity: �� votekick, ban, � mute �� :

sm_playersvotes_immunity:
�� votekick � voteban. 0 �� . -1 �� .

sm_playersvotes_immunegroups:
�� votekick � voteban

�� 1: ��

sm_playersvotes_immunity "50.0" (�� )
sm_playersvotes_immunegroups ""

�� 2: �� (� �� Full Admins � Clan Members �� , �� )

sm_playersvotes_immunity "-1.0"
sm_playersvotes_immunegroups "Full Admins; Clan Members"

�� : votemap �� . �� playersvotes �� maplists.cfg:

��:
/* For playersvotes plugin */
"playersvotes"
{
"file" "maplist.txt"
}
�� : �� , �� votemap, �� .

��(CVAR's):
sm_votekick_ratio - �� votekick
sm_voteban_ratio - �� voteban
sm_votemap_ratio - �� votemap
sm_votemute_ratio - �� votemute

sm_votekick_minimum - �� votekick, -1 �� votekick
sm_voteban_minimum - �� voteban, -1 �� voteban
sm_votemap_minimum - �� votemap, -1 �� votemap
sm_votemute_minimum - �� votemute, -1 �� votemute

sm_votekick_delay - �� votekick ��
sm_voteban_delay - �� voteban ��
sm_votemap_delay - �� votemap ��
sm_votemute_delay - �� votemute ��

sm_votekick_limit - �� . �� . 0 �� . -1 ��
sm_voteban_limit - �� . �� . 0 �� . -1 ��
sm_votemap_limit - �� . �� . 0 �� . -1 ��
sm_votemute_limit - �� . �� . 0 �� . -1 ��

sm_playersvotes_interval - ��

sm_voteban_time - �� . 0 ��

sm_voteban_reasons - �� . (��: "Hacking; Spamming; Griefing")

sm_playersvotes_immunity - �� votekick � voteban. 0 �� . -1 ��

sm_playersvotes_immunegroups - �� . "" ��

sm_votemap_lastmaps - ��

sm_votemap_extend - �� . -1 ��

sm_votemap_max_extends - �� . -1 ��

sm_votemap_immediate - 1 �� . 0 �� nextmap
sm_votekick_team_restrict - �� kick. 1 ��, 0 ��

sm_voteban_team_restrict - restrict ban votes to teams. 1 ��, 0 ��

sm_votemute_team_restrict- restrict mute votes to teams. 1 ��, 0 ��

sm_playersvotes_menu_timeout - �� . 0 ��

��:

1.�� playersvotes_data_files_1.5.zip c Getzilla

2.�� .�� addons � cfg.�� \cstrike\

3.�� .

�� JAVA �� Windows � 0-�� 0-��!

mybb@mybb.ru (��) — Fri, 17 Sep 2010 04:14:10 +0400

� ��, ��!
�� ! ( � �� L2open 1289 �� )
��: �� !( �� Windows XP )( �� Mysql, navicat ) - �� !

1. �� !
a) �� Vertrigo 221

�) �� Java

�) �� .NET Flamework 4

�) �� L2Open(1289) Epilogue

2. �� Vertrigo'�
�� , �� !
�� (�� ), ��

, �� (� �� ) ��

��

�� root � �� vertrigo, �� "��"

, �� , �� !

4. �� Java .

5. �� .NET Flamework

�.�. �� !

6. � �� !

�) ��

�) �� , �� tools � ��

�� vars.txt �� (�� )

� �� mysql'�(�� , � �� F:\VertrigoServ\Mysql\bin ), �� , ��

� ��!

�) �� , �� ENTER �� "n" , �� "f" � � �� , �� , �� !

�) �� F:\L2Open1289\LoginServer\config\network ( �� , �� ) �� loginserver.ini, ��

�� !

�) �� F:\L2Open1289\LoginServer � �� RegisterGameServer.bat � �� , �� ! �� hexid.txt �� F:\L2Open1289\GameServer\config ( �� =) )

�) �� F:\L2Open1289\GameServer\config\network � �� server.ini � �� , ��

��!!!

�) ��
� �� F:\L2Open1289\LoginServer � �� startLoginServer.bat
�� F:\L2Open1289\GameServer � �� startGameServer.bat
�� !

�) �� system �� l2.ini (�� ip � 127.0.0.1 �� )
�� F:\L2Open1289\GameServer\config � ��

�� , �� ! ��!
�� , �� , �� =), �� 20 !!!

�� - ��

mybb@mybb.ru (��) — Fri, 17 Sep 2010 02:08:05 +0400

��, �� .
�� .
�� - �� (!) ��.
�� - �� upload.php

��

print("<tr><td class=rowhead style='padding: 3px'>".$tracker_lang['description']."</td><td>");

��

// description_mod
$video_ = "�� \\n��: \\n�� : \\n�� : \\n��: \\n��: \\n� ��: \\n\\n� ��: \\n\\n��: \\n��: \\n��: \\n��: \\n��: \\n\\n��\\n��: \\n��: \\n��: \\n��: \\n��: \\n";

$audio_ = "��: \\n��: \\n�� : \\n��: \\n\\n��:\\n\\n\\n��: (��, ��)\\n��: \\n";

$book_="��:\\n��:\\n��:\\n��:\\n��:\\n��:\\n��:\\n�� :\\n��:\\n";

$audiobook_="��: \\n��: \\n�� : \\n��: \\n��: \\n\\n� ��:\\n\\n\\n��: \\n��: \\n";

$game_ = "��: \\n�� : \\n��: \\n��: \\n��: \\n\\n�� : \\n\\n\\n�� : \\n\\n\\n�� : \\n\\n";

$soft_ = "��:\\n�� :\\n��:\\n�� :\\n��:\\n��:\\n��. ��:\\n";

$pic_ = "��:\\n��(�):\\n��:\\n�� :\\n�� :\\n��:(��\\��\\B&W)\\n\\n��:\\n";

$w = 80;
$h = 30;

print("<tr><td class=rowhead style='padding: 3px'>�� ".$tracker_lang['description']."<br><b>");
print("<br><input style=\"width: ".$w."px; height: ".$h."px\" type=button onclick='changeText(\"".$video_."\")' value=Video>\n");
print("<br><input style=\"width: ".$w."px; height: ".$h."px\" type=button onclick='changeText(\"".$audio_."\")' value=Audio>\n");
print("<br><input style=\"width: ".$w."px; height: ".$h."px\" type=button onclick='changeText(\"".$soft_."\")' value=soft>\n");
print("<br><input style=\"width: ".$w."px; height: ".$h."px\" type=button onclick='changeText(\"".$book_."\")' value=Book>\n");
print("<br><input style=\"width: ".$w."px; height: ".$h."px\" type=button onclick='changeText(\"".$audiobook_."\")' value=AudioBook>\n");
print("<br><input style=\"width: ".$w."px; height: ".$h."px\" type=button onclick='changeText(\"".$game_."\")' value=Game>\n");
print("<br><input style=\"width: ".$w."px; height: ".$h."px\" type=button onclick='changeText(\"".$pic_."\")' value=Pic>\n");
print("</td><td>");
// end description_mod

� ��

</td></tr> </table> </form>

��

<script type="text/javascript"> function changeText(text){ document.getElementById('descr').value = text; } </script>

�� :
� functions_global.php

��

<textarea name="<?=$name;?>" wrap="virtual" rows="15" cols="85" onKeyPress="if(use_kb) return decode(event);" onFocus="storeCaret(this);" onselect="storeCaret(this);" onclick="storeCaret(this);" onkeyup="storeCaret(this);">

��

<textarea id="descr" name="<?=$name;?>" wrap="virtual" rows="15" cols="85" onKeyPress="if(use_kb) return decode(event);" onFocus="storeCaret(this);" onselect="storeCaret(this);" onclick="storeCaret(this);" onkeyup="storeCaret(this);">

(�� id="descr")

�� , �� , �� .

��

mybb@mybb.ru (��) — Fri, 17 Sep 2010 01:46:32 +0400

1. mIRC - �� irc.lanpolis.ru , �� #Dubna-Prank.bv.du

2. �� . �� icq - 461977939

��

mybb@mybb.ru (��) — Fri, 17 Sep 2010 01:29:23 +0400

�� .
1.�� .
2.�� .
3.�� . �� , � �� !
4. �� - ��. �� , �� , �� . �� .
5.�� . �� , �� , �� , �� . �� .

�� 
1. �� , �� .
2. � �� , �� .
3. �� , �� .
4. �� : �� - �� . �� - �� .
5. ��, �� , �� .
�� . �� -�� , �� .
6. �� , �� (�� ). �� .( �� )

�� 
1. �� .

��
1. ��, �� - ��, �� .
2. �� , �� , �� , �� .
�� , ��, � �� .
3. �� , �� , �� , � �� (�� )
4. ��-�� , ��, ��. �� , �� .
5. �� , �� !
6. �� y� �� p��y� ��p��, �� ; �� ; �� .
7. �� . ��, �� .
8. �� 640x480 �� 40��. �� .
9. �� , �� , �� . �� , � �� , �� .
10. �� , �� , �� , �� .
11. �� , �� .
12. �� , �� . ��, �� .
13. �� , �� 3-� ��
14. �� , ��/�� .
15. �� e-mail (icq), � �� . �� .( �� )
16. �� . �� -�� , �� , �� .
17. �� "�� ". �� , �� .
18. �� (� �� , � �� ).
19. �� (�� ).
20. �� . �� - �� .

�� 
�� : �� .
�� , �� , � �� ; �� , �� ; �� .
�� , �� .
��:
��, �� , �� , � �� .
��, �� , � � �� /�� , �� , � �� , �� :
� �� ; (��! �� !)
� �� ;
� �� ;
� �� ;
� �� "�� " (��);
� �� (�� );
� �� ;

��, �� , �� , �� , �� .
�� .
�� "�� ".

�� :
1. � �� :
� ��, �� ;
� �� , �� (�� "�� ");
� �� , �� (�� "65r7tgu6547");
� ��, �� ;
� ��, �� ;
� ��, �� (�� ). �� , � �� BB �� , �� "��";

�� .

�� , �� .
��, �� , �� .
�� .

�� , �� , �� !

�� !!!

mybb@mybb.ru (��) — Fri, 17 Sep 2010 01:12:47 +0400

�� - ��, � �� - ��!!!

��

mybb@mybb.ru (��) — Thu, 16 Sep 2010 20:05:00 +0400

�� , ��....

��

mybb@mybb.ru (��) — Thu, 16 Sep 2010 19:50:07 +0400

�� , � �� !
�� !

Dubna - TBDev - La2 - WoW - AION - CS

��������� ��� ������ ���������� ���������!

MySQL Backup v2.0 - �������� ������� ������ MySQL

FAQ �� ��������� ������ �����.

�������� Sql �������. ����� 3

�������� Sql �������. ����� 2

�������� SQL ������� L2java

������� sourcemod (��������)

Players Votes v.1.5.0

��������� JAVA ������� ��� Windows � 0-�� ��� 0-��!

��� - ��������� ��������

�� ������

������� ������

�������� ������!!!

������� ������

����� �����������

�� !

MySQL Backup v2.0 - �� MySQL

FAQ �� .

�� Sql ��. �� 3

�� Sql ��. �� 2

�� SQL �� L2java

�� sourcemod (��)

�� JAVA �� Windows � 0-�� 0-��!

�� - ��

��

��

�� !!!

��

��