返回上一页
游戏技术

传奇开区清理数据SQL脚本

[注意] 需要清理的表(假设使用Access或SQLite)

-- 清理角色数据
DELETE FROM Tbl_Character;
DELETE FROM Tbl_Quest;
DELETE FROM Tbl_Inventory;
DELETE FROM Tbl_Skill;
-- 清理行会数据
DELETE FROM Tbl_Guild;
DELETE FROM Tbl_GuildMember;
-- 清理排行榜日志
DELETE FROM Tbl_RankLog;
-- 重置全局变量
UPDATE Tbl_Global SET Value=0 WHERE Key='G_SERVER_START';

[工具] 批处理脚本示例(.bat)

@echo off
echo 正在清理数据...
"D:\MirServer\Database\ClearDB.exe" /silent
echo 清理完成!
pause

也可以使用sqlcmdsqlite3命令行工具执行。