开新区恢复初始数据方法(王城和全局都初始)
打开烈焰私服的数据库表，推荐用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搞定！
数据库已经恢复原始状态.可以开新区了
页:
[1]