开测F后想清除数据,但又想保留测试时玩家帐号的SQL语句,防止有些玩家恶意抢注。在99这上面的复制的内容后面都带有乱码的,所以附上一个文本文件让大家下载使用 dedecms.com
本文来自织梦
-- 以下的SQL语句请在SQL的lin2world中的查询分析器中执行 copyright dedecms
-- 清除GM帐号信息
delete from builder_account
-- 清除公告信息
delete from login_announce
-- 以下清除相关的玩家数据信息
delete from pet_data
delete from pledge
delete from pledge_crest
delete from pledge_rank
delete from ssq_user_data
delete from ssq_data
delete from ssq_join_data
delete from user_activeskill
delete from user_ban
delete from user_blocklist
delete from user_data
delete from user_deleted
delete from user_friend
delete from user_henna
delete from user_history
delete from user_item
delete from user_log
delete from user_macro
delete from user_macroinfo
delete from user_newbie
delete from user_nobless
delete from user_recipe
delete from user_skill
delete from user_sociality
delete from user_subjob
delete from war_declare
delete from castle_tax
delete from castle_war
delete from lotto_game
delete from lotto_items
delete from manor_data
delete from manor_data_n
delete from manor_info
delete from nobless_achievements
delete from monrace_ticket
delete from monrace_mon
copyright dedecms
-- 更新城镇为初始状态
update castle set pledge_id=0, next_ware_time=0, tax_rate=0, status=0, shop_income=0, shop_income_temp=0, tax_rate_to_change=-1, tax_child_rate_to_change=-1
内容来自dedecms
-- 清除人物在线统计数据
delete from lin2db.dbo.user_count
-- 解除封杀的帐号
update lin2db.dbo.user_account set block_flag=0, block_flag2=0 copyright dedecms
-- 使用PHPBS的用户才使用
delete from lin2db.dbo.ppll_banaccount
内容来自dedecms
1.76精品传奇_1.76天下毁灭_1.76复古传奇_英雄合击_中变靓装传奇_无忧传奇
传奇花屏补丁,花屏补丁,土城花屏补丁,盟重土城花屏补丁下载,土城花屏补丁下载,沙巴克花屏补丁,传奇土城花屏补丁下载
网站每天发布最新、最好的传奇版本下载和与传奇服务端配套开区传奇模版,网游技术教程全部免费下载!
无忧网络是目前唯一家所有的传奇服务端,传奇私服花屏补丁,盟重花屏补丁和传奇客户端下载都经过站长亲自测试并配有真实测试图!
所有的工具软件和传奇版本在发布之前,都会经过站长亲自测试,保证chuanqisf可以进入游戏,所有软件都无毒无插件!
本站声明:本站所有技术资料与下载资源均为网络搜集整理,并不代表本站的观点与立场,如有侵犯您的权益,请来信指出,本站将立即改正Copyright © 2002-2014 无忧网络 版权所有蜀ICP备09041899号