MACJIEHOK

по чём щас сборку отдашь?

видео что ты можешь сделать вот такое за 4 часа http://forummaxi.ru/index.php?showtopic=34285 сколько возьмёшь за работу?

Куплю рабочий сайт анонс серверов l2. C посещаемостью от 1.5 и выше ссылки, цены и контакты в лс

Ребята кто может скинуть SW 13 php 5.2\? с меня спасибка

если надо будет то хватит) дай ссылочку в лс пожалуйста

http://svoj-server.com/index.php?option=com_content&view=article&id=87&Itemid=63 не реклама ставишь свой сервер на данный ДЦ и 1 гиг от досса бесплатно. почитай там много че есть

не буду создавать тему напишу тут. кто знает где заказывать досс на проекты л2?

я это всё брал с другого сайта и это лежит у меня где то уже месяц

я там я этого не видел туда вообще не заходил.)

Добавляем скил Noblesse Blessingt всем персонажам INSERT INTO skill_trees VALUES (0,1323,2,'Noblesse Blessing',0,1); INSERT INTO skill_trees VALUES (10,1323,2,'Noblesse Blessing',0,1); INSERT INTO skill_trees VALUES (18,1323,2,'Noblesse Blessing',0,1); INSERT INTO skill_trees VALUES (25,1323,2,'Noblesse Blessing',0,1); INSERT INTO skill_trees VALUES (31,1323,2,'Noblesse Blessing',0,1); INSERT INTO skill_trees VALUES (38,1323,2,'Noblesse Blessing',0,1); INSERT INTO skill_trees VALUES (44,1323,2,'Noblesse Blessing',0,1); INSERT INTO skill_trees VALUES (49,1323,2,'Noblesse Blessing',0,1); INSERT INTO skill_trees VALUES (53,1323,2,'Noblesse Blessing',0,1); Увеличить статы (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'); -- Для заточки скилов вам не нужно будет тратить exp и sp UPDATE enchant_skill_trees SET exp=0; UPDATE enchant_skill_trees SET sp=0; Удалить все аккаунты и персонажей, которые не соизволили появиться в игре в течении 3 месяцев DELETE FROM characters WHERE lastAccess < 466560000; DELETE FROM accounts WHERE lastactive < 466560000;

удалите тему случайно сделал глюк был

Решил создать Тему с sql запросами таких как: Новые персонажи в TOP NG шмоте: 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); При старте персонаж в A и S грейде 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); Снижение цен во всех магазинах до 1 адены: DELETE FROM `droplist` WHERE (`itemId`!='57') AND (`category`='-1') Вытаскиваем чара из под текстур UPDATE characters SET z=-3464, y=148505, x=83036 WHERE char_name='ник чара'; Спавн проф кота во всех городах DELETE FROM spawnlist WHERE npc_templateid=31228; INSERT INTO `spawnlist` (`location`, `count`, `npc_templateid`, `locx`, `locy`, `locz`, `randomx`, `randomy`, `heading`, `respawn_delay`, `loc_id`) VALUES ('', 1, 31228, 151316, 47070, -3408, 0, 0, 35000, 1, 0), ('', 1, 31228, 147672, 46354, -3434, 0, 0, 35000, 1, 0), ('', 1, 31228, 147916, 26588, -2205, 0, 0, 35000, 1, 0), ('', 1, 31228, 81918, 148303, -3467, 0, 0, 35000, 1, 0), ('', 1, 31228, 82336, 53273, -1496, 0, 0, 35000, 1, 0), ('', 1, 31228, 18098, 145191, -3051, 0, 0, 35000, 1, 0), ('', 1, 31228, 111581, 219323, -3546, 0, 0, 35000, 1, 0), ('', 1, 31228, -14144, 124022, -3117, 0, 0, 35000, 1, 0), ('', 1, 31228, 147991, -56573, -2781, 0, 0, 35000, 1, 0), ('', 1, 31228, 87082, -142146, -1341, 0, 0, 35000, 1, 0), ('', 1, 31228, -82031, 150182, -3129, 0, 0, 35000, 1, 0), ('', 1, 31228, 116093, 76552, -2730, 0, 0, 35000, 1, 0), ('', 1, 31228, 17187, 169861, -3499, 0, 0, 35000, 1, 0), ('', 1, 31228, 44452, -47589, -797, 0, 0, 35000, 1, 0);

Решил создать Тему с sql запросами таких как: Новые персонажи в TOP NG шмоте: 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); При старте персонаж в A и S грейде 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); Снижение цен во всех магазинах до 1 адены: DELETE FROM `droplist` WHERE (`itemId`!='57') AND (`category`='-1') Вытаскиваем чара из под текстур UPDATE characters SET z=-3464, y=148505, x=83036 WHERE char_name='ник чара'; Спавн проф кота во всех городах DELETE FROM spawnlist WHERE npc_templateid=31228; INSERT INTO `spawnlist` (`location`, `count`, `npc_templateid`, `locx`, `locy`, `locz`, `randomx`, `randomy`, `heading`, `respawn_delay`, `loc_id`) VALUES ('', 1, 31228, 151316, 47070, -3408, 0, 0, 35000, 1, 0), ('', 1, 31228, 147672, 46354, -3434, 0, 0, 35000, 1, 0), ('', 1, 31228, 147916, 26588, -2205, 0, 0, 35000, 1, 0), ('', 1, 31228, 81918, 148303, -3467, 0, 0, 35000, 1, 0), ('', 1, 31228, 82336, 53273, -1496, 0, 0, 35000, 1, 0), ('', 1, 31228, 18098, 145191, -3051, 0, 0, 35000, 1, 0), ('', 1, 31228, 111581, 219323, -3546, 0, 0, 35000, 1, 0), ('', 1, 31228, -14144, 124022, -3117, 0, 0, 35000, 1, 0), ('', 1, 31228, 147991, -56573, -2781, 0, 0, 35000, 1, 0), ('', 1, 31228, 87082, -142146, -1341, 0, 0, 35000, 1, 0), ('', 1, 31228, -82031, 150182, -3129, 0, 0, 35000, 1, 0), ('', 1, 31228, 116093, 76552, -2730, 0, 0, 35000, 1, 0), ('', 1, 31228, 17187, 169861, -3499, 0, 0, 35000, 1, 0), ('', 1, 31228, 44452, -47589, -797, 0, 0, 35000, 1, 0);

Решил создать Тему с sql запросами таких как: Новые персонажи в TOP NG шмоте: 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); При старте персонаж в A и S грейде 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); Снижение цен во всех магазинах до 1 адены: DELETE FROM `droplist` WHERE (`itemId`!='57') AND (`category`='-1') Вытаскиваем чара из под текстур UPDATE characters SET z=-3464, y=148505, x=83036 WHERE char_name='ник чара'; Спавн проф кота во всех городах DELETE FROM spawnlist WHERE npc_templateid=31228; INSERT INTO `spawnlist` (`location`, `count`, `npc_templateid`, `locx`, `locy`, `locz`, `randomx`, `randomy`, `heading`, `respawn_delay`, `loc_id`) VALUES ('', 1, 31228, 151316, 47070, -3408, 0, 0, 35000, 1, 0), ('', 1, 31228, 147672, 46354, -3434, 0, 0, 35000, 1, 0), ('', 1, 31228, 147916, 26588, -2205, 0, 0, 35000, 1, 0), ('', 1, 31228, 81918, 148303, -3467, 0, 0, 35000, 1, 0), ('', 1, 31228, 82336, 53273, -1496, 0, 0, 35000, 1, 0), ('', 1, 31228, 18098, 145191, -3051, 0, 0, 35000, 1, 0), ('', 1, 31228, 111581, 219323, -3546, 0, 0, 35000, 1, 0), ('', 1, 31228, -14144, 124022, -3117, 0, 0, 35000, 1, 0), ('', 1, 31228, 147991, -56573, -2781, 0, 0, 35000, 1, 0), ('', 1, 31228, 87082, -142146, -1341, 0, 0, 35000, 1, 0), ('', 1, 31228, -82031, 150182, -3129, 0, 0, 35000, 1, 0), ('', 1, 31228, 116093, 76552, -2730, 0, 0, 35000, 1, 0), ('', 1, 31228, 17187, 169861, -3499, 0, 0, 35000, 1, 0), ('', 1, 31228, 44452, -47589, -797, 0, 0, 35000, 1, 0);

сделай оружие для этого сета

хз хз... мой хостинг на котором я щас сам всё сделал когда я захотел к ним переехать

пользуюсь давно http://svoj-server.com не реклама администрация знает своё дело и даже больше.. помогают со всеми проблемами включая даже сайт мой совет это http://svoj-server.com цены минимальные и сервера хорошие ...

svoj-server.com пользуюсь очень давно администрация знает свою работу и даже больше! помогает можно сказать во всём! сами переписывают сервера и т д.

Кто поможет поставить на L2j-Сhrome дополненя? крылья оружие броню... чтоб было красиво... 200 р дам у меня не получается ..... ICQ 692593365

кто может поставить этти драные оружия и тд..... я ставлю и их не видно может у кого есть крылья и т д? кто может поделиться и установить? дуду благодарен можно шаравые сказать которые знаете.... для интерлюд

в клиент залил патч но всё равно.... качал шаравую

залил в базу так же в сервер и в клиент всё сделал как надо пишу Ид итема написано что типо удачно я его взял но в инвентаре его нет. что может быть? как испраивть?)

http://l2maxi.ru/jav...arms-wings.html вот пример что можно скачать и установить всё что надо это переделать SQL и всё

почему 2к?) они в шаре все лежат

Кто может дать SQL чтоб все персонажи появлялись не а Acc lvl 127 Типо все админы а с Acc lvl 45 Именно 45!!!!! чтоб при старте было! очень нуж дам 50р вот ICQ запрос чтоб удалить все персонажей с Acclvl 100 DELETE FROM `accounts` WHERE (`access_level`='100'); а как сделать чтоб все при старте появлялись с 45,?Сборка L2j-Chrome