L2J_CE

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

L2J_CE Server


Участников: 3

    ЗАПРОС

    SarGos
    SarGos
    SarGos


    Сообщения : 493
    Дата регистрации : 2010-03-08
    Возраст : 29
    Откуда : Украина
    • Сообщение 1

    ЗАПРОС Empty ЗАПРОС

    Сообщение  SarGos Вт Июл 13, 2010 8:58 pm

    Дайте пожалуйста запрос чтобы все созданые чары(новые) получили топ нг
    в инете лазил, нашол но в запросе ерор чтото не сходиться, дайте пожалуйста запрос для сказки!
    Зарания спасибо ! Smile
    • Вернуться к началу
    vooinn
    avatar
    vooinn


    Сообщения : 57
    Дата регистрации : 2010-05-31
    • Сообщение 2

    ЗАПРОС Empty Re: ЗАПРОС

    Сообщение  vooinn Ср Июл 14, 2010 12:17 pm

    поверь самому переписать быстрее )))))
    char_creation_items
    смени ид там и все
    • Вернуться к началу
    NikolasCH
    NikolasCH
    NikolasCH


    Сообщения : 118
    Дата регистрации : 2010-03-23
    • Сообщение 3

    ЗАПРОС Empty Re: ЗАПРОС

    Сообщение  NikolasCH Ср Июл 14, 2010 5:38 pm

    Код:
    REPLACE INTO char_creation_items
      (classId, itemId, amount, equipped)
    VALUES
      (-1, 5588, 1, "false");

    REPLACE INTO char_creation_items
      (classId, itemId, amount, equipped)
    VALUES
      (-1, 12753, 10, "false");

    REPLACE INTO char_creation_items
      (classId, itemId, amount, equipped)
    VALUES
      (-1, 10650, 5, "false");

    REPLACE INTO char_creation_items
      (classId, itemId, amount, equipped)
    VALUES
      (0, 219, 1, "false");

    REPLACE INTO char_creation_items
      (classId, itemId, amount, equipped)
    VALUES
      (0, 23, 1, "true");

    REPLACE INTO char_creation_items
      (classId, itemId, amount, equipped)
    VALUES
      (0, 2386, 1, "true");

    REPLACE INTO char_creation_items
      (classId, itemId, amount, equipped)
    VALUES
      (0, 43, 1, "true");

    REPLACE INTO char_creation_items
      (classId, itemId, amount, equipped)
    VALUES
      (0, 68, 1, "true");

    REPLACE INTO char_creation_items
      (classId, itemId, amount, equipped)
    VALUES
      (10, 177, 1, "true");

    REPLACE INTO char_creation_items
      (classId, itemId, amount, equipped)
    VALUES
      (10, 1101, 1, "true");

    REPLACE INTO char_creation_items
      (classId, itemId, amount, equipped)
    VALUES
      (10, 1104, 1, "true");

    REPLACE INTO char_creation_items
      (classId, itemId, amount, equipped)
    VALUES
      (10, 44, 1, "true");

    REPLACE INTO char_creation_items
      (classId, itemId, amount, equipped)
    VALUES
      (18, 219, 1, "false");

    REPLACE INTO char_creation_items
      (classId, itemId, amount, equipped)
    VALUES
      (18, 23, 1, "true");

    REPLACE INTO char_creation_items
      (classId, itemId, amount, equipped)
    VALUES
      (18, 2386, 1, "true");

    REPLACE INTO char_creation_items
      (classId, itemId, amount, equipped)
    VALUES
      (18, 43, 1, "true");

    REPLACE INTO char_creation_items
      (classId, itemId, amount, equipped)
    VALUES
      (18, 68, 1, "true");

    REPLACE INTO char_creation_items
      (classId, itemId, amount, equipped)
    VALUES
      (25, 177, 1, "true");

    REPLACE INTO char_creation_items
      (classId, itemId, amount, equipped)
    VALUES
      (25, 1101, 1, "true");

    REPLACE INTO char_creation_items
      (classId, itemId, amount, equipped)
    VALUES
      (25, 1104, 1, "true");

    REPLACE INTO char_creation_items
      (classId, itemId, amount, equipped)
    VALUES
      (25, 44, 1, "true");

    REPLACE INTO char_creation_items
      (classId, itemId, amount, equipped)
    VALUES
      (31, 219, 1, "false");

    REPLACE INTO char_creation_items
      (classId, itemId, amount, equipped)
    VALUES
      (31, 23, 1, "true");

    REPLACE INTO char_creation_items
      (classId, itemId, amount, equipped)
    VALUES
      (31, 2386, 1, "true");

    REPLACE INTO char_creation_items
      (classId, itemId, amount, equipped)
    VALUES
      (31, 43, 1, "true");

    REPLACE INTO char_creation_items
      (classId, itemId, amount, equipped)
    VALUES
      (31, 68, 1, "true");

    REPLACE INTO char_creation_items
      (classId, itemId, amount, equipped)
    VALUES
      (38, 177, 1, "true");

    REPLACE INTO char_creation_items
      (classId, itemId, amount, equipped)
    VALUES
      (38, 1101, 1, "true");

    REPLACE INTO char_creation_items
      (classId, itemId, amount, equipped)
    VALUES
      (38, 1104, 1, "true");

    REPLACE INTO char_creation_items
      (classId, itemId, amount, equipped)
    VALUES
      (38, 44, 1, "true");

    REPLACE INTO char_creation_items
      (classId, itemId, amount, equipped)
    VALUES
      (44, 23, 1, "true");

    REPLACE INTO char_creation_items
      (classId, itemId, amount, equipped)
    VALUES
      (44, 2386, 1, "true");

    REPLACE INTO char_creation_items
      (classId, itemId, amount, equipped)
    VALUES
      (44, 43, 1, "true");

    REPLACE INTO char_creation_items
      (classId, itemId, amount, equipped)
    VALUES
      (44, 257, 1, "true");

    REPLACE INTO char_creation_items
      (classId, itemId, amount, equipped)
    VALUES
      (44, 68, 1, "false");

    REPLACE INTO char_creation_items
      (classId, itemId, amount, equipped)
    VALUES
      (49, 1101, 1, "true");

    REPLACE INTO char_creation_items
      (classId, itemId, amount, equipped)
    VALUES
      (49, 1104, 1, "true");

    REPLACE INTO char_creation_items
      (classId, itemId, amount, equipped)
    VALUES
      (49, 44, 1, "true");

    REPLACE INTO char_creation_items
      (classId, itemId, amount, equipped)
    VALUES
      (49, 257, 1, "true");

    REPLACE INTO char_creation_items
      (classId, itemId, amount, equipped)
    VALUES
      (53, 219, 1, "false");

    REPLACE INTO char_creation_items
      (classId, itemId, amount, equipped)
    VALUES
      (53, 23, 1, "true");

    REPLACE INTO char_creation_items
      (classId, itemId, amount, equipped)
    VALUES
      (53, 2386, 1, "true");

    REPLACE INTO char_creation_items
      (classId, itemId, amount, equipped)
    VALUES
      (53, 43, 1, "true");

    REPLACE INTO char_creation_items
      (classId, itemId, amount, equipped)
    VALUES
      (53, 87, 1, "true");

    REPLACE INTO char_creation_items
      (classId, itemId, amount, equipped)
    VALUES
      (123, 219, 1, "false");

    REPLACE INTO char_creation_items
      (classId, itemId, amount, equipped)
    VALUES
      (123, 23, 1, "true");

    REPLACE INTO char_creation_items
      (classId, itemId, amount, equipped)
    VALUES
      (123, 2386, 1, "true");

    REPLACE INTO char_creation_items
      (classId, itemId, amount, equipped)
    VALUES
      (123, 43, 1, "true");

    REPLACE INTO char_creation_items
      (classId, itemId, amount, equipped)
    VALUES
      (123, 68, 1, "true");

    REPLACE INTO char_creation_items
      (classId, itemId, amount, equipped)
    VALUES
      (124, 219, 1, "false");

    REPLACE INTO char_creation_items
      (classId, itemId, amount, equipped)
    VALUES
      (124, 23, 1, "true");

    REPLACE INTO char_creation_items
      (classId, itemId, amount, equipped)
    VALUES
      (124, 2386, 1, "true");

    REPLACE INTO char_creation_items
      (classId, itemId, amount, equipped)
    VALUES
      (124, 43, 1, "true");

    REPLACE INTO char_creation_items
      (classId, itemId, amount, equipped)
    VALUES
      (124, 68, 1, "true");

    • Вернуться к началу
    SarGos
    SarGos
    SarGos


    Сообщения : 493
    Дата регистрации : 2010-03-08
    Возраст : 29
    Откуда : Украина
    • Сообщение 4

    ЗАПРОС Empty Re: ЗАПРОС

    Сообщение  SarGos Чт Июл 15, 2010 2:25 am

    NikolasCH пишет:
    Код:
    REPLACE INTO char_creation_items
      (classId, itemId, amount, equipped)
    VALUES
      (-1, 5588, 1, "false");

    REPLACE INTO char_creation_items
      (classId, itemId, amount, equipped)
    VALUES
      (-1, 12753, 10, "false");

    REPLACE INTO char_creation_items
      (classId, itemId, amount, equipped)
    VALUES
      (-1, 10650, 5, "false");

    REPLACE INTO char_creation_items
      (classId, itemId, amount, equipped)
    VALUES
      (0, 219, 1, "false");

    REPLACE INTO char_creation_items
      (classId, itemId, amount, equipped)
    VALUES
      (0, 23, 1, "true");

    REPLACE INTO char_creation_items
      (classId, itemId, amount, equipped)
    VALUES
      (0, 2386, 1, "true");

    REPLACE INTO char_creation_items
      (classId, itemId, amount, equipped)
    VALUES
      (0, 43, 1, "true");

    REPLACE INTO char_creation_items
      (classId, itemId, amount, equipped)
    VALUES
      (0, 68, 1, "true");

    REPLACE INTO char_creation_items
      (classId, itemId, amount, equipped)
    VALUES
      (10, 177, 1, "true");

    REPLACE INTO char_creation_items
      (classId, itemId, amount, equipped)
    VALUES
      (10, 1101, 1, "true");

    REPLACE INTO char_creation_items
      (classId, itemId, amount, equipped)
    VALUES
      (10, 1104, 1, "true");

    REPLACE INTO char_creation_items
      (classId, itemId, amount, equipped)
    VALUES
      (10, 44, 1, "true");

    REPLACE INTO char_creation_items
      (classId, itemId, amount, equipped)
    VALUES
      (18, 219, 1, "false");

    REPLACE INTO char_creation_items
      (classId, itemId, amount, equipped)
    VALUES
      (18, 23, 1, "true");

    REPLACE INTO char_creation_items
      (classId, itemId, amount, equipped)
    VALUES
      (18, 2386, 1, "true");

    REPLACE INTO char_creation_items
      (classId, itemId, amount, equipped)
    VALUES
      (18, 43, 1, "true");

    REPLACE INTO char_creation_items
      (classId, itemId, amount, equipped)
    VALUES
      (18, 68, 1, "true");

    REPLACE INTO char_creation_items
      (classId, itemId, amount, equipped)
    VALUES
      (25, 177, 1, "true");

    REPLACE INTO char_creation_items
      (classId, itemId, amount, equipped)
    VALUES
      (25, 1101, 1, "true");

    REPLACE INTO char_creation_items
      (classId, itemId, amount, equipped)
    VALUES
      (25, 1104, 1, "true");

    REPLACE INTO char_creation_items
      (classId, itemId, amount, equipped)
    VALUES
      (25, 44, 1, "true");

    REPLACE INTO char_creation_items
      (classId, itemId, amount, equipped)
    VALUES
      (31, 219, 1, "false");

    REPLACE INTO char_creation_items
      (classId, itemId, amount, equipped)
    VALUES
      (31, 23, 1, "true");

    REPLACE INTO char_creation_items
      (classId, itemId, amount, equipped)
    VALUES
      (31, 2386, 1, "true");

    REPLACE INTO char_creation_items
      (classId, itemId, amount, equipped)
    VALUES
      (31, 43, 1, "true");

    REPLACE INTO char_creation_items
      (classId, itemId, amount, equipped)
    VALUES
      (31, 68, 1, "true");

    REPLACE INTO char_creation_items
      (classId, itemId, amount, equipped)
    VALUES
      (38, 177, 1, "true");

    REPLACE INTO char_creation_items
      (classId, itemId, amount, equipped)
    VALUES
      (38, 1101, 1, "true");

    REPLACE INTO char_creation_items
      (classId, itemId, amount, equipped)
    VALUES
      (38, 1104, 1, "true");

    REPLACE INTO char_creation_items
      (classId, itemId, amount, equipped)
    VALUES
      (38, 44, 1, "true");

    REPLACE INTO char_creation_items
      (classId, itemId, amount, equipped)
    VALUES
      (44, 23, 1, "true");

    REPLACE INTO char_creation_items
      (classId, itemId, amount, equipped)
    VALUES
      (44, 2386, 1, "true");

    REPLACE INTO char_creation_items
      (classId, itemId, amount, equipped)
    VALUES
      (44, 43, 1, "true");

    REPLACE INTO char_creation_items
      (classId, itemId, amount, equipped)
    VALUES
      (44, 257, 1, "true");

    REPLACE INTO char_creation_items
      (classId, itemId, amount, equipped)
    VALUES
      (44, 68, 1, "false");

    REPLACE INTO char_creation_items
      (classId, itemId, amount, equipped)
    VALUES
      (49, 1101, 1, "true");

    REPLACE INTO char_creation_items
      (classId, itemId, amount, equipped)
    VALUES
      (49, 1104, 1, "true");

    REPLACE INTO char_creation_items
      (classId, itemId, amount, equipped)
    VALUES
      (49, 44, 1, "true");

    REPLACE INTO char_creation_items
      (classId, itemId, amount, equipped)
    VALUES
      (49, 257, 1, "true");

    REPLACE INTO char_creation_items
      (classId, itemId, amount, equipped)
    VALUES
      (53, 219, 1, "false");

    REPLACE INTO char_creation_items
      (classId, itemId, amount, equipped)
    VALUES
      (53, 23, 1, "true");

    REPLACE INTO char_creation_items
      (classId, itemId, amount, equipped)
    VALUES
      (53, 2386, 1, "true");

    REPLACE INTO char_creation_items
      (classId, itemId, amount, equipped)
    VALUES
      (53, 43, 1, "true");

    REPLACE INTO char_creation_items
      (classId, itemId, amount, equipped)
    VALUES
      (53, 87, 1, "true");

    REPLACE INTO char_creation_items
      (classId, itemId, amount, equipped)
    VALUES
      (123, 219, 1, "false");

    REPLACE INTO char_creation_items
      (classId, itemId, amount, equipped)
    VALUES
      (123, 23, 1, "true");

    REPLACE INTO char_creation_items
      (classId, itemId, amount, equipped)
    VALUES
      (123, 2386, 1, "true");

    REPLACE INTO char_creation_items
      (classId, itemId, amount, equipped)
    VALUES
      (123, 43, 1, "true");

    REPLACE INTO char_creation_items
      (classId, itemId, amount, equipped)
    VALUES
      (123, 68, 1, "true");

    REPLACE INTO char_creation_items
      (classId, itemId, amount, equipped)
    VALUES
      (124, 219, 1, "false");

    REPLACE INTO char_creation_items
      (classId, itemId, amount, equipped)
    VALUES
      (124, 23, 1, "true");

    REPLACE INTO char_creation_items
      (classId, itemId, amount, equipped)
    VALUES
      (124, 2386, 1, "true");

    REPLACE INTO char_creation_items
      (classId, itemId, amount, equipped)
    VALUES
      (124, 43, 1, "true");

    REPLACE INTO char_creation_items
      (classId, itemId, amount, equipped)
    VALUES
      (124, 68, 1, "true");

    спасибо =) выручил
    • Вернуться к началу
      Текущее время Пт Окт 04, 2024 3:27 am