l2jnews создай свой сервер Lineage 2 сборки,база знаний

Скачать Counter-Strike 1.6

Чат

Популярные файлы

Статистика сайта

Сейчас онлайн пользователи:

Сборник полезных запросов mySQL для вашего собственного сервера л2

Начальная зона - Глудин:

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, -83063, 150791, -3133, 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, -83063, 150791, -3133, 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, -83063, 150791, -3133, 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, -83063, 150791, -3133, 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, -83063, 150791, -3133, 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, -83063, 150791, -3133, 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, -83063, 150791, -3133, 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, -83063, 150791, -3133, 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, -83063, 150791, -3133, 0, "1.04", "0.89856", 7, "27.5", "1.04", "0.89856", 8, "25.5", 1105, 1102, 257, 0, 5588);

Изменяем начальную зону (все появляются по координатам 140425, -124265, -1929):

DELETE FROM char_templates WHERE ClassId=0;
DELETE FROM char_templates WHERE ClassId=10;
DELETE FROM char_templates WHERE ClassId=18;
DELETE FROM char_templates WHERE ClassId=25;
DELETE FROM char_templates WHERE ClassId=31;
DELETE FROM char_templates WHERE ClassId=38;
DELETE FROM char_templates WHERE ClassId=44;
DELETE FROM char_templates WHERE ClassId=49;
DELETE FROM char_templates WHERE ClassId=53;

INSERT INTO `char_templates` VALUES
(0, 'Human Fighter', 0, 40, 43, 30, 21, 11, 25, 4, 80, 6, 41, 300, 333, 33, 44, 33, 115, 81900, 140425, -124265, -1929, 0, 1.10, 1.188000, 9.0, 23.0, 1.10, 1.188000, 8.0, 23.5, 1147, 1146, 10, 2369, 5588),
(10, 'Human Mage', 0, 22, 27, 21, 41, 20, 39, 3, 54, 6, 41, 300, 333, 28, 40, 28, 120, 62500, 140425, -124265, -1929, 0, 1.01, 0.872640, 7.5, 22.8, 1.01, 0.872640, 6.5, 22.5, 425, 461, 6, 5588, 0),
(18, 'Elf Fighter', 1, 36, 36, 35, 23, 14, 26, 4, 80, 6, 41, 300, 333, 36, 46, 36, 125, 73000, 140425, -124265, -1929, 0, 1.15, 1.242000, 7.5, 24.0, 1.15, 1.242000, 7.5, 23.0, 1147, 1146, 10, 2369, 5588),
(25, 'Elf Mage', 1, 21, 25, 24, 37, 23, 40, 3, 54, 6, 41, 300, 333, 30, 41, 30, 122, 62400, 140425, -124265, -1929, 0, 1.04, 0.898560, 7.5, 24.0, 1.04, 0.898560, 7.5, 23.0, 425, 461, 6, 5588, 0),
(31, 'DE Fighter', 2, 41, 32, 34, 25, 12, 26, 4, 80, 6, 41, 300, 333, 35, 45, 35, 122, 69000, 140425, -124265, -1929, 0, 1.14, 1.231200, 7.5, 24.0, 1.14, 1.231200, 7.0, 23.5, 1147, 1146, 10, 2369, 5588),
(38, 'DE Mage', 2, 23, 24, 23, 44, 19, 37, 3, 54, 6, 41, 300, 333, 29, 41, 29, 122, 61000, 140425, -124265, -1929, 0, 1.14, 1.231200, 7.5, 24.0, 1.03, 0.889920, 7.0, 23.5, 425, 461, 6, 5588, 0),
(44, 'Orc Fighter', 3, 40, 47, 26, 18, 12, 27, 4, 80, 6, 41, 300, 333, 31, 42, 31, 117, 87000, 140425, -124265, -1929, 0, 1.06, 1.144800, 11.0, 28.0, 1.06, 1.144800, 7.0, 27.0, 1147, 1146, 2368, 2369, 5588),
(49, 'Orc Mage', 3, 27, 31, 24, 31, 15, 42, 3, 54, 6, 41, 300, 333, 30, 41, 30, 121, 68000, 140425, -124265, -1929, 0, 1.04, 0.898560, 7.0, 27.5, 1.04, 0.898560, 8.0, 25.5, 425, 461, 2368, 5588, 0),
(53, 'Dwarf Fighter', 4, 39, 45, 29, 20, 10, 27, 4, 80, 6, 41, 300, 333, 33, 43, 33, 115, 83000, 140425, -124265, -1929, 1, 1.09, 1.487196, 9.0, 18.0, 1.09, 1.487196, 5.0, 19.0, 1147, 1146, 10, 2370, 5588);

Убрать вес всех вещей (установить вес на 1)

Увеличиваем время возрождения РБ в 3 раза:

Эти запросы увеличивают патак и матак в 0.2 раза (т.е. понижают в 5 раз) и увеличивают пдеф и мдеф в 0.5 раз (т.е. понижают в 2 раза) у нпц L2Grandboss - Антарас, баюм, Валакас... (также может быть L2Minion - у миньенов, L2Monster - у мобов, L2RaidBoss - у рейд боссов)

Изменение времени проведения осады (sql запросом)

Сделать ТОП НГ при старте для всех классов

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

Удалить у определенного персонажа с owner_id (смотреть в базе characters) определенной вещи - например Адены (ид=57)

Добавить всем мобам в дроп определенный (Фестиваль адена ид=6673, минимум дроп=2, максимум дроп=3, категория=0, шанс 100% - 1000000)

Вайп на вашем собственном java сервере (Этот скрипт очищал базу от пользователей, не игравших более X дней, вероятно если поставить на 0 - очистит все.):

-- more than ... days
-- задать количество дней (x)
SET @dt = X;
DELETE FROM accounts WHERE DATEDIFF( CURRENT_DATE( ) , FROM_UNIXTIME( `lastactive` /1000 ) ) >= @dt;
DELETE FROM accounts WHERE login NOT IN (SELECT account_name FROM characters);
DELETE FROM characters WHERE account_name NOT IN (SELECT login FROM accounts);
DELETE FROM character_friends WHERE charId NOT IN (SELECT charId FROM characters);
DELETE FROM character_hennas WHERE charId NOT IN (SELECT charId FROM characters);
DELETE FROM character_macroses WHERE charId NOT IN (SELECT charId FROM characters);
DELETE FROM character_quests WHERE charId NOT IN (SELECT charId FROM characters);
DELETE FROM character_recipebook WHERE charId NOT IN (SELECT charId FROM characters);
DELETE FROM character_shortcuts WHERE charId NOT IN (SELECT charId FROM characters);
DELETE FROM character_skills WHERE charId NOT IN (SELECT charId FROM characters);
DELETE FROM character_skills_save WHERE charId NOT IN (SELECT charId FROM characters);
DELETE FROM character_subclasses WHERE charId NOT IN (SELECT charId FROM characters);
DELETE FROM character_raid_points WHERE charId NOT IN (SELECT charId FROM characters);
DELETE FROM clan_data WHERE leader_id NOT IN (SELECT charId FROM characters);
DELETE FROM clan_privs WHERE clan_id NOT IN (SELECT clan_id FROM clan_data);
DELETE FROM clan_skills WHERE clan_id NOT IN (SELECT clan_id FROM clan_data);
UPDATE clan_subpledges SET leader_id = 0 where leader_id NOT IN (SELECT charid from characters);
DELETE FROM pets WHERE item_obj_id NOT IN (SELECT object_id FROM items WHERE owner_id IN (SELECT charId FROM characters));
DELETE FROM items WHERE owner_id NOT IN (SELECT charId FROM characters) AND owner_id NOT IN (SELECT clan_id FROM clan_data);
DELETE FROM seven_signs WHERE charId NOT IN (SELECT charId FROM characters);
UPDATE characters SET clanid = 0, title = "", clan_privs = 0 where clanid NOT IN (SELECT clan_id FROM clan_data);
UPDATE clanhall SET ownerId = 0, paidUntil = 0 where ownerId NOT IN (SELECT clan_id FROM clan_data);
DELETE FROM forums WHERE forum_owner_id NOT IN (SELECT clan_id FROM clan_data) AND forum_owner_id != 0;
DELETE FROM posts WHERE post_ownerid NOT IN (SELECT charId FROM characters);
DELETE FROM topic WHERE topic_ownerid NOT IN (SELECT charId FROM characters);
DELETE FROM olympiad_nobles WHERE charId NOT IN (SELECT charId FROM characters);
DELETE FROM heroes WHERE charId NOT IN (SELECT charId FROM characters);
DELETE FROM item_attributes WHERE itemId NOT IN (SELECT object_id FROM items);
DELETE FROM siege_clans WHERE clan_id NOT IN (SELECT clan_id FROM clan_data);
DELETE FROM obj_restrictions WHERE obj_Id NOT IN (SELECT charId FROM characters);
DELETE FROM couples WHERE player1Id NOT IN (SELECT charId FROM characters);
DELETE FROM couples WHERE player2Id NOT IN (SELECT charId FROM characters);

Удаление всего ненужного на PVP сервере (Удаляет все ненужное: рецепты, куски, ресурсы, материалы, книжки...)

DELETE FROM droplist WHERE itemId='1864';
DELETE FROM droplist WHERE itemId='1865';
DELETE FROM droplist WHERE itemId='1866';
DELETE FROM droplist WHERE itemId='1867';
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='1883';
DELETE FROM droplist WHERE itemId='1884';
DELETE FROM droplist WHERE itemId='1885';
DELETE FROM droplist WHERE itemId='1886';
DELETE FROM droplist WHERE itemId='1887';
DELETE FROM droplist WHERE itemId='1888';
DELETE FROM droplist WHERE itemId='1889';
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='1894';
DELETE FROM droplist WHERE itemId='1895';

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='18

Администрация не несёт ответственности за содержащие файлы на данном портале.
Все материалы на сайте принадлежат исключительно их владельцам!
Главный администратор сайта TheNega |

| Sitemap | Sitemap-Forum | RSS лента