开新区恢复初始数据方法(王城和全局都初始)

llllll

打开烈焰私服的数据库表，推荐用N11这个工具
1.  连接数据库
2. 双击需要清除的数据库
3.  单击查询
4.  新建查询
5.  把以下SQL语句复制进去，点击查询，等待navicat执行完毕.

• TRUNCATE TABLE characters;
• TRUNCATE TABLE guild_data;
• TRUNCATE TABLE guild_application;
• TRUNCATE TABLE guild_logs;
• TRUNCATE TABLE guild_ranks;
• TRUNCATE TABLE account_data;
• TRUNCATE TABLE guild_items;
• TRUNCATE TABLE guilds;
• TRUNCATE TABLE playervip;
• TRUNCATE TABLE playeronlinecount;
• TRUNCATE TABLE playermagics;
• TRUNCATE TABLE playeritemslog;
• TRUNCATE TABLE playeritems;
• TRUNCATE TABLE playercooldowns;
• TRUNCATE TABLE playercashlog;
• TRUNCATE TABLE playlog;
• update siege_warfare set guildid=0,attack_guildid=0 where entry=1;
• update world_global_variables set text='0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,' where entry=1;
  

然后关闭数据库，OK搞定！
数据库已经恢复原始状态.可以开新区了