开区前清理传奇3私服内测时玩家所留下的数据,是每个新开传奇3私服必须做的事情.
这部分工作是非常重要,也是非常繁琐的一件事情,这里我提供点SQL命令,这样可大大的减少GM朋友们的工作量,而且数据清理的相当干净.不会因为漏删除某内测数据,而使开区带来不必要的麻烦.
当然,这里的表名也许会和你有点不一样,你可以自行把你数据库的表名替换一下就行了.
USE GAME3g
DELETE FROM TBL_CHARACTER
DELETE FROM TBL_ABILITY
DELETE FROM TBL_FACEIMG
DELETE FROM TBL_MAGIC
DELETE FROM TBL_ITEMMARKET
DELETE FROM TBL_QUEST
DELETE FROM TBL_SUBHUMAN
DELETE FROM TBL_SAVEDITEM
DELETE FROM UserHumanEx
DELETE FROM TBL_ITEM
DELETE FROM TBL_MagicEx
DELETE FROM TBL_ItemEx
DELETE FROM TBL_SUBHUMAN
DELETE FROM TBL_DATA
DELETE FROM TBL_LottoUser
DELETE FROM TBL_LottoServer
DELETE UserHumanEx
INSERT INTO TBL_DATA (FLD_GCTYPE) VALUES (攻城类型)
INSERT INTO TBL_DATA (FLD_GCTYPE) VALUES (神界圣域)
INSERT INTO TBL_DATA (FLD_GCTYPE,FLD_FL1,FLD_FL2,FLD_FL3) VALUES (屠魔神殿,1,0,0)
INSERT INTO TBL_LottoServer (fld_name,fld_sequence) values (Current,1)
INSERT INTO TBL_LottoServer (fld_name,fld_sequence,fld_num1,fld_num2,fld_num3) values (lotto,1,3,5,8)
本文出自:
搜传奇3转载请注明来处：http://www.so373.com/showarticle.asp?id=96
