Cheat Engine

Would you like to react to this message? Create an account in a few clicks or log in to continue.
Cheat Engine

The Underground Site of Cheat Engine


    Fix for NPC Disappearance

    avatar
    HTHR
    Guest


    Fix for NPC Disappearance Empty Fix for NPC Disappearance

    Post  HTHR Thu May 21, 2009 2:10 am

    There you go. Run it while the server is down or when you start your DB for the first time.

    Code:

    SET FOREIGN_KEY_CHECKS = 0;
    ALTER TABLE characters AUTO_INCREMENT = 30001;
    UPDATE `characters` SET id = id + 30000;
    UPDATE `buddies` SET characterid = characterid + 30000;
    UPDATE `cheatlog` SET cid= cid+ 30000;
    UPDATE `gmlog` SET cid= cid+ 30000;
    UPDATE `famelog` SET characterid = characterid + 30000;
    UPDATE `famelog` SET characterid_to = characterid_to + 30000;
    UPDATE `inventoryitems` SET characterid = characterid + 30000;
    UPDATE `keymap` SET characterid = characterid + 30000;
    UPDATE `queststatus` SET characterid = characterid + 30000;
    UPDATE `savedlocations` SET characterid = characterid + 30000;
    UPDATE `skills` SET characterid = characterid + 30000;
    SET FOREIGN_KEY_CHECKS = 1;

    Note: The problem happens to the Xotic DB for some odd reason.

    JvIaple's Fix in the source!

      Current date/time is Fri Mar 29, 2024 1:35 am