🗑️ Reset EO Database | DuaSelipar Tools

Warning: Make sure all tables in this script exist in your database before running. If any table does not exist, execution will stop.
Tip: Always backup your database first!

💾 Old Database Structure

Classic EO database (2014/older). Includes auto-increment reset for account & cq_user.

TRUNCATE TABLE account;
ALTER TABLE account AUTO_INCREMENT = 1000000;
TRUNCATE TABLE account_pwd;
TRUNCATE TABLE account_old;
TRUNCATE TABLE cq_ad_log;
TRUNCATE TABLE cq_addresslist;
TRUNCATE TABLE cq_advert_log;
TRUNCATE TABLE cq_building;
TRUNCATE TABLE cq_card;
TRUNCATE TABLE cq_card2;
TRUNCATE TABLE cq_card3;
TRUNCATE TABLE cq_castle;
TRUNCATE TABLE cq_castleitem;
TRUNCATE TABLE cq_castlemap;
TRUNCATE TABLE cq_deluser;
TRUNCATE TABLE cq_donation_dynasort_rec;
TRUNCATE TABLE cq_enemy;
TRUNCATE TABLE cq_eudemon;
ALTER TABLE cq_eudemon AUTO_INCREMENT = 2000000000;
TRUNCATE TABLE cq_family;
TRUNCATE TABLE cq_family_attr;
TRUNCATE TABLE cq_flower;
TRUNCATE TABLE cq_friend;
TRUNCATE TABLE cq_ip_log;
TRUNCATE TABLE cq_item;
ALTER TABLE cq_item AUTO_INCREMENT = 10000;
TRUNCATE TABLE cq_leaveword;
TRUNCATE TABLE cq_magic;
TRUNCATE TABLE cq_partner;
TRUNCATE TABLE cq_pet;
TRUNCATE TABLE cq_pk_item;
TRUNCATE TABLE cq_shortcut_key;
TRUNCATE TABLE cq_skill;
TRUNCATE TABLE cq_special_status;
TRUNCATE TABLE cq_suspicion_event;
TRUNCATE TABLE cq_suspicion_log;
TRUNCATE TABLE cq_suspicion_punish;
TRUNCATE TABLE cq_synattr;
TRUNCATE TABLE cq_syndicate;
TRUNCATE TABLE cq_taskdetail;
TRUNCATE TABLE cq_totem_add;
TRUNCATE TABLE cq_tutor;
TRUNCATE TABLE cq_tutor_contributions;
TRUNCATE TABLE cq_tutorexp;
TRUNCATE TABLE cq_user;
ALTER TABLE cq_user AUTO_INCREMENT = 1000000;

-- Legion War
REPLACE INTO `cq_dynanpc` VALUES (21150, 0, 2, 'LegionPole', 10, 9800, 0000, 0000, -1, 1100, 473, 614, 8410410, 0000, 0000, 0000, 0000, 0000, 0000, 0000, 805987127, 0, 0, 1000, 'None', 8410450, 66000000, 66000000, 0000, 17, 0000, 0003, 0003, 0003, 0003, 0, 0, 'None', 'None', 0, 0, 0, 0, 0, 0, 0, 0);
REPLACE INTO `cq_dynanpc` VALUES (21151, 0, 2, 'LegionShield', 124, 9837, 0000, 0000, -1, 1100, 461, 269, 0000, 0000, 0000, 0000, 0000, 0000, 0000, 0000, 10000000, 0, 0, 1000, 'None', 8410460, 207000000, 207000000, 0000, 17, 0000, 0003, 0003, 0003, 0003, 0, 0, 'None', 'None', 0, 0, 0, 0, 0, 0, 0, 0);

-- Castle
REPLACE INTO `cq_dynanpc` VALUES (51182, 0, 0, 'CastleMap', 48, 99900, 0000, 0000, -1, 0600, 97, 105, 3800900, 0000, 0000, 0000, 0000, 0000, 0000, 0000, 0, 0, 0, 0, 'None', 0000, 0000, 0000, 0000, 01, 0000, 0000, 0000, 0000, 0000, 0, 0, 'None', 'Castle', 1000000, 0, 0, 12, 0, 0, 0, 0);
REPLACE INTO `cq_dynanpc` VALUES (51183, 0, 0, 'CastleMap', 48, 99900, 0000, 0000, -1, 0600, 97, 112, 3800900, 0000, 0000, 0000, 0000, 0000, 0000, 0000, 0, 0, 0, 0, 'None', 0000, 0000, 0000, 0000, 01, 0000, 0000, 0000, 0000, 0000, 0, 0, 'None', 'Castle', 1000000, 0, 0, 12, 0, 0, 0, 0);
REPLACE INTO `cq_dynanpc` VALUES (51184, 0, 0, 'CastleMap', 48, 99900, 0000, 0000, -1, 0600, 101, 105, 3800900, 0000, 0000, 0000, 0000, 0000, 0000, 0000, 0, 0, 0, 0, 'None', 0000, 0000, 0000, 0000, 01, 0000, 0000, 0000, 0000, 0000, 0, 0, 'None', 'Castle', 1000000, 0, 0, 12, 0, 0, 0, 0);
... (remaining REPLACE rows unchanged) ...

💾 New Database Structure

For EO server with cq_user_new, cq_vip, othercard, etc. Reset auto-increment for main tables as needed.

-- account table
TRUNCATE TABLE account;
TRUNCATE TABLE account_pwd;
TRUNCATE TABLE cq_vip;
ALTER TABLE account AUTO_INCREMENT = 1000000;
-- main table
TRUNCATE TABLE cq_activitynewshoprecord;
TRUNCATE TABLE cq_delcount;
TRUNCATE TABLE cq_deluser;
TRUNCATE TABLE cq_donation_dynasort_rec;
TRUNCATE TABLE cq_enemy;
TRUNCATE TABLE cq_eudemon;
ALTER TABLE cq_eudemon AUTO_INCREMENT = 2000000000;
TRUNCATE TABLE cq_eudlookinfo;
TRUNCATE TABLE cq_faceinfo;
TRUNCATE TABLE cq_friend;
TRUNCATE TABLE cq_goddess;
TRUNCATE TABLE cq_goddessservant;
TRUNCATE TABLE cq_hairinfo;
TRUNCATE TABLE cq_item;
ALTER TABLE cq_item AUTO_INCREMENT = 10000;
TRUNCATE TABLE cq_magic;
TRUNCATE TABLE cq_mailinfo;
TRUNCATE TABLE cq_newcard;
TRUNCATE TABLE cq_newcard2;
TRUNCATE TABLE cq_newtaskdetail;
TRUNCATE TABLE cq_packpetinfo;
TRUNCATE TABLE cq_partner;
TRUNCATE TABLE cq_skill;
TRUNCATE TABLE cq_special_status;
TRUNCATE TABLE cq_suspicion_event;
TRUNCATE TABLE cq_suspicion_log;
TRUNCATE TABLE cq_suspicion_punish;
TRUNCATE TABLE cq_syndicate;
TRUNCATE TABLE cq_synattr;
TRUNCATE TABLE cq_taskdetail;
TRUNCATE TABLE cq_titleid;
TRUNCATE TABLE cq_totem_add;
TRUNCATE TABLE cq_tutor;
TRUNCATE TABLE cq_tutor_contributions;
TRUNCATE TABLE cq_tutorexp;
TRUNCATE TABLE cq_user_new;
TRUNCATE TABLE othercard;
TRUNCATE TABLE othercard_log;
ALTER TABLE cq_user_new AUTO_INCREMENT = 1000000;

-- Celebrity Hall Statue
UPDATE cq_npc
SET
  data1 = 0, data2 = 0, data3 = 0,
  newdata1 = 0, newdata2 = 0, newdata3 = 0,
  newdata4 = 0, newdata5 = 0, newdata6 = 0,
  newdata7 = 0, newdata8 = 0,
  datastr = ''
WHERE (id BETWEEN 11000 AND 11199 OR id BETWEEN 10200 AND 10999);

-- PK Statue
UPDATE cq_npc
SET
  data1 = 0, data2 = 0, data3 = 0,
  newdata1 = 0, newdata2 = 0, newdata3 = 0,
  newdata6 = 0, newdata7 = 0,
  datastr = ''
WHERE id = 12850;

-- Divine Fire Statue
UPDATE cq_npc
SET
  data1 = 0, data2 = 0, data3 = 0,
  newdata1 = 0, newdata2 = 0, newdata3 = 0,
  newdata4 = 0, newdata6 = 0, newdata7 = 0, newdata8 = 0,
  datastr = '', newstrdata1 = '', newstrdata2 = ''
WHERE id BETWEEN 12116 AND 12118;

REPLACE INTO `cq_dynanpc` VALUES (21150, 0, 2, 'Legion~Pole', 10, 9800, 0000, 0000, -1, 1100, 473, 614, 8410410, 0000, 0000, 0000, 0000, 0000, 0000, 0000, 1566716339, 0, 0, 1000, 'none', 8410450, 247125255, 247125255, 0000, 17, 0000, 0003, 0003, 0003, 0003, 0, 0, 'none', 'none', 0, 0, 0, 0, 0, 0, 0, 0, 0, '', 0, 0, 0, 0, 0, 0, 0, 0, '', '', 0);
REPLACE INTO `cq_dynanpc` VALUES (21151, 0, 2, 'Legion~Shield', 124, 9837, 0000, 0000, -1, 1100, 461, 269, 0000, 0000, 0000, 0000, 0000, 0000, 0000, 0000, 0, 0, 0, 1000, 'none', 8410460, 741375765, 741375765, 0000, 17, 0000, 0003, 0003, 0003, 0003, 0, 0, 'none', 'none', 0, 0, 0, 0, 0, 0, 0, 0, 0, '', 0, 0, 0, 0, 0, 0, 0, 0, '', '', 0);