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 on 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 Thu May 23, 2019 1:19 pm