L2J_CE

Вы хотите отреагировать на этот пост ? Создайте аккаунт всего в несколько кликов или войдите на форум.
L2J_CE

L2J_CE Server


    [Fix] Для бафов в комунке.

    avatar
    rPAHb


    Сообщения : 22
    Дата регистрации : 2010-02-26

    [Fix] Для бафов в комунке. Empty [Fix] Для бафов в комунке.

    Сообщение  rPAHb Сб Фев 27, 2010 2:50 am

    Если у вас не работают какие-то бафы в комунке, то вам следует сделать следующее:

    1. Откройте таблицу nps_buffer
    2. Удалите оттуда все строки с ID 1000003
    3. Создайте текстовый файл .txt а после переименуйте его в .sql
    4. Откройте созданный .sql файл блокнотом и добавьте следующее:
    Код:
    INSERT INTO `npc_buffer` VALUES ('1000003', '265', '1', '57', '100', '265');
    INSERT INTO `npc_buffer` VALUES ('1000003', '266', '1', '57', '100', '266');
    INSERT INTO `npc_buffer` VALUES ('1000003', '267', '1', '57', '100', '267');
    INSERT INTO `npc_buffer` VALUES ('1000003', '268', '1', '57', '100', '268');
    INSERT INTO `npc_buffer` VALUES ('1000003', '269', '1', '57', '100', '269');
    INSERT INTO `npc_buffer` VALUES ('1000003', '270', '1', '57', '100', '270');
    INSERT INTO `npc_buffer` VALUES ('1000003', '271', '1', '57', '100', '271');
    INSERT INTO `npc_buffer` VALUES ('1000003', '272', '1', '57', '100', '272');
    INSERT INTO `npc_buffer` VALUES ('1000003', '273', '1', '57', '100', '273');
    INSERT INTO `npc_buffer` VALUES ('1000003', '274', '1', '57', '100', '274');
    INSERT INTO `npc_buffer` VALUES ('1000003', '275', '1', '57', '100', '275');
    INSERT INTO `npc_buffer` VALUES ('1000003', '276', '1', '57', '100', '276');
    INSERT INTO `npc_buffer` VALUES ('1000003', '277', '1', '57', '100', '277');
    INSERT INTO `npc_buffer` VALUES ('1000003', '304', '1', '57', '100', '304');
    INSERT INTO `npc_buffer` VALUES ('1000003', '305', '1', '57', '100', '305');
    INSERT INTO `npc_buffer` VALUES ('1000003', '306', '1', '57', '100', '306');
    INSERT INTO `npc_buffer` VALUES ('1000003', '307', '1', '57', '100', '307');
    INSERT INTO `npc_buffer` VALUES ('1000003', '308', '1', '57', '100', '308');
    INSERT INTO `npc_buffer` VALUES ('1000003', '309', '1', '57', '100', '309');
    INSERT INTO `npc_buffer` VALUES ('1000003', '310', '1', '57', '100', '310');
    INSERT INTO `npc_buffer` VALUES ('1000003', '311', '1', '57', '100', '311');
    INSERT INTO `npc_buffer` VALUES ('1000003', '349', '1', '57', '100', '349');
    INSERT INTO `npc_buffer` VALUES ('1000003', '363', '1', '57', '100', '363');
    INSERT INTO `npc_buffer` VALUES ('1000003', '364', '1', '57', '100', '364');
    INSERT INTO `npc_buffer` VALUES ('1000003', '365', '1', '57', '100', '365');
    INSERT INTO `npc_buffer` VALUES ('1000003', '366', '1', '57', '100', '366');
    INSERT INTO `npc_buffer` VALUES ('1000003', '367', '1', '57', '100', '367');
    INSERT INTO `npc_buffer` VALUES ('1000003', '529', '1', '57', '100', '529');
    INSERT INTO `npc_buffer` VALUES ('1000003', '530', '1', '57', '100', '530');
    INSERT INTO `npc_buffer` VALUES ('1000003', '825', '1', '57', '100', '825');
    INSERT INTO `npc_buffer` VALUES ('1000003', '826', '1', '57', '100', '826');
    INSERT INTO `npc_buffer` VALUES ('1000003', '827', '1', '57', '100', '827');
    INSERT INTO `npc_buffer` VALUES ('1000003', '828', '1', '57', '100', '828');
    INSERT INTO `npc_buffer` VALUES ('1000003', '829', '1', '57', '100', '829');
    INSERT INTO `npc_buffer` VALUES ('1000003', '830', '1', '57', '100', '830');
    INSERT INTO `npc_buffer` VALUES ('1000003', '1002', '3', '57', '100', '1002');
    INSERT INTO `npc_buffer` VALUES ('1000003', '1003', '3', '57', '100', '1003');
    INSERT INTO `npc_buffer` VALUES ('1000003', '1004', '3', '57', '100', '1004');
    INSERT INTO `npc_buffer` VALUES ('1000003', '1005', '3', '57', '100', '1005');
    INSERT INTO `npc_buffer` VALUES ('1000003', '1006', '3', '57', '100', '1006');
    INSERT INTO `npc_buffer` VALUES ('1000003', '1007', '3', '57', '100', '1007');
    INSERT INTO `npc_buffer` VALUES ('1000003', '1008', '3', '57', '100', '1008');
    INSERT INTO `npc_buffer` VALUES ('1000003', '1009', '3', '57', '100', '1009');
    INSERT INTO `npc_buffer` VALUES ('1000003', '1010', '3', '57', '100', '1010');
    INSERT INTO `npc_buffer` VALUES ('1000003', '1032', '3', '57', '100', '1032');
    INSERT INTO `npc_buffer` VALUES ('1000003', '1033', '3', '57', '100', '1033');
    INSERT INTO `npc_buffer` VALUES ('1000003', '1035', '4', '57', '100', '1035');
    INSERT INTO `npc_buffer` VALUES ('1000003', '1036', '2', '57', '100', '1036');
    INSERT INTO `npc_buffer` VALUES ('1000003', '1040', '3', '57', '100', '1040');
    INSERT INTO `npc_buffer` VALUES ('1000003', '1043', '1', '57', '100', '1043');
    INSERT INTO `npc_buffer` VALUES ('1000003', '1044', '3', '57', '100', '1044');
    INSERT INTO `npc_buffer` VALUES ('1000003', '1045', '6', '57', '100', '1045');
    INSERT INTO `npc_buffer` VALUES ('1000003', '1048', '6', '57', '100', '1048');
    INSERT INTO `npc_buffer` VALUES ('1000003', '1059', '3', '57', '100', '1059');
    INSERT INTO `npc_buffer` VALUES ('1000003', '1062', '2', '57', '100', '1062');
    INSERT INTO `npc_buffer` VALUES ('1000003', '1068', '3', '57', '100', '1068');
    INSERT INTO `npc_buffer` VALUES ('1000003', '1073', '2', '57', '100', '1073');
    INSERT INTO `npc_buffer` VALUES ('1000003', '1077', '3', '57', '100', '1077');
    INSERT INTO `npc_buffer` VALUES ('1000003', '1078', '6', '57', '100', '1078');
    INSERT INTO `npc_buffer` VALUES ('1000003', '1085', '3', '57', '100', '1085');
    INSERT INTO `npc_buffer` VALUES ('1000003', '1086', '2', '57', '100', '1086');
    INSERT INTO `npc_buffer` VALUES ('1000003', '1087', '3', '57', '100', '1087');
    INSERT INTO `npc_buffer` VALUES ('1000003', '1182', '3', '57', '100', '1182');
    INSERT INTO `npc_buffer` VALUES ('1000003', '1189', '3', '57', '100', '1189');
    INSERT INTO `npc_buffer` VALUES ('1000003', '1191', '3', '57', '100', '1191');
    INSERT INTO `npc_buffer` VALUES ('1000003', '1204', '2', '57', '100', '1204');
    INSERT INTO `npc_buffer` VALUES ('1000003', '1240', '3', '57', '100', '1240');
    INSERT INTO `npc_buffer` VALUES ('1000003', '1242', '3', '57', '100', '1242');
    INSERT INTO `npc_buffer` VALUES ('1000003', '1243', '3', '57', '100', '1243');
    INSERT INTO `npc_buffer` VALUES ('1000003', '1249', '3', '57', '100', '1249');
    INSERT INTO `npc_buffer` VALUES ('1000003', '1250', '3', '57', '100', '1250');
    INSERT INTO `npc_buffer` VALUES ('1000003', '1251', '2', '57', '100', '1251');
    INSERT INTO `npc_buffer` VALUES ('1000003', '1252', '3', '57', '100', '1252');
    INSERT INTO `npc_buffer` VALUES ('1000003', '1253', '3', '57', '100', '1253');
    INSERT INTO `npc_buffer` VALUES ('1000003', '1257', '3', '57', '100', '1257');
    INSERT INTO `npc_buffer` VALUES ('1000003', '1259', '4', '57', '100', '1259');
    INSERT INTO `npc_buffer` VALUES ('1000003', '1260', '3', '57', '100', '1260');
    INSERT INTO `npc_buffer` VALUES ('1000003', '1261', '2', '57', '100', '1261');
    INSERT INTO `npc_buffer` VALUES ('1000003', '1268', '4', '57', '100', '1268');
    INSERT INTO `npc_buffer` VALUES ('1000003', '1282', '2', '57', '100', '1282');
    INSERT INTO `npc_buffer` VALUES ('1000003', '1284', '3', '57', '100', '1284');
    INSERT INTO `npc_buffer` VALUES ('1000003', '1303', '2', '57', '100', '1303');
    INSERT INTO `npc_buffer` VALUES ('1000003', '1304', '3', '57', '100', '1304');
    INSERT INTO `npc_buffer` VALUES ('1000003', '1308', '3', '57', '100', '1308');
    INSERT INTO `npc_buffer` VALUES ('1000003', '1309', '3', '57', '100', '1309');
    INSERT INTO `npc_buffer` VALUES ('1000003', '1310', '4', '57', '100', '1310');
    INSERT INTO `npc_buffer` VALUES ('1000003', '1323', '1', '57', '100', '1323');
    INSERT INTO `npc_buffer` VALUES ('1000003', '1352', '1', '57', '100', '1352');
    INSERT INTO `npc_buffer` VALUES ('1000003', '1353', '1', '57', '100', '1353');
    INSERT INTO `npc_buffer` VALUES ('1000003', '1354', '1', '57', '100', '1354');
    INSERT INTO `npc_buffer` VALUES ('1000003', '1355', '1', '57', '100', '1355');
    INSERT INTO `npc_buffer` VALUES ('1000003', '1356', '1', '57', '100', '1356');
    INSERT INTO `npc_buffer` VALUES ('1000003', '1357', '1', '57', '100', '1357');
    INSERT INTO `npc_buffer` VALUES ('1000003', '1362', '1', '57', '100', '1362');
    INSERT INTO `npc_buffer` VALUES ('1000003', '1363', '1', '57', '100', '1363');
    INSERT INTO `npc_buffer` VALUES ('1000003', '1364', '1', '57', '100', '1364');
    INSERT INTO `npc_buffer` VALUES ('1000003', '1365', '1', '57', '100', '1365');
    INSERT INTO `npc_buffer` VALUES ('1000003', '1388', '3', '57', '100', '1388');
    INSERT INTO `npc_buffer` VALUES ('1000003', '1389', '3', '57', '100', '1389');
    INSERT INTO `npc_buffer` VALUES ('1000003', '1390', '3', '57', '100', '1390');
    INSERT INTO `npc_buffer` VALUES ('1000003', '1391', '3', '57', '100', '1391');
    INSERT INTO `npc_buffer` VALUES ('1000003', '1392', '3', '57', '100', '1392');
    INSERT INTO `npc_buffer` VALUES ('1000003', '1393', '3', '57', '100', '1393');
    INSERT INTO `npc_buffer` VALUES ('1000003', '1397', '3', '57', '100', '1397');
    INSERT INTO `npc_buffer` VALUES ('1000003', '1413', '1', '57', '100', '1413');
    INSERT INTO `npc_buffer` VALUES ('1000003', '1414', '1', '57', '100', '1414');
    INSERT INTO `npc_buffer` VALUES ('1000003', '1415', '1', '57', '100', '1415');
    INSERT INTO `npc_buffer` VALUES ('1000003', '1416', '1', '57', '100', '1416');
    INSERT INTO `npc_buffer` VALUES ('1000003', '1460', '1', '57', '100', '1460');
    INSERT INTO `npc_buffer` VALUES ('1000003', '1461', '1', '57', '100', '1461');
    INSERT INTO `npc_buffer` VALUES ('1000003', '1476', '2', '57', '100', '1476');
    INSERT INTO `npc_buffer` VALUES ('1000003', '1477', '2', '57', '100', '1477');
    INSERT INTO `npc_buffer` VALUES ('1000003', '1478', '2', '57', '100', '1478');
    INSERT INTO `npc_buffer` VALUES ('1000003', '1479', '2', '57', '100', '1479');
    INSERT INTO `npc_buffer` VALUES ('1000003', '1499', '1', '57', '100', '1499');
    INSERT INTO `npc_buffer` VALUES ('1000003', '1500', '1', '57', '100', '1500');
    INSERT INTO `npc_buffer` VALUES ('1000003', '1501', '1', '57', '100', '1501');
    INSERT INTO `npc_buffer` VALUES ('1000003', '1502', '1', '57', '100', '1502');
    INSERT INTO `npc_buffer` VALUES ('1000003', '1503', '1', '57', '100', '1503');
    INSERT INTO `npc_buffer` VALUES ('1000003', '1504', '1', '57', '100', '1504');
    INSERT INTO `npc_buffer` VALUES ('1000003', '4699', '13', '57', '100', '4699');
    INSERT INTO `npc_buffer` VALUES ('1000003', '4700', '13', '57', '100', '4700');
    INSERT INTO `npc_buffer` VALUES ('1000003', '4702', '13', '57', '100', '4702');
    INSERT INTO `npc_buffer` VALUES ('1000003', '4703', '13', '57', '100', '4703');
    INSERT INTO `npc_buffer` VALUES ('1000003', '21046', '1', '57', '100', '21046');
    5. Сохраняем
    6. Заливаем по новой в базу.

    Все работает!! Проверено!!

      Текущее время Пт Окт 04, 2024 7:21 am