Cheat Engine

The Underground Site of Cheat Engine


    Fix for NPC Disappearance

    Share

    HTHR
    Guest

    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 Tue May 22, 2018 5:27 am