RM数据库研究（一）
C:\Documents and Settings\Administrator>isql -U sa -P aa333666 -d redmoon
1> select count(*) FROM [redmoon].[dbo].[tblSpecialItem1](nolock) where gameid='
juese1'
2> go
-----------
46
(1 row affected)
1> quit
--还原数据库 将数据库 'redmoon' 从版本 539 转换为当前版本 661。
RESTORE FILELISTONLY
FROM DISK = 'C:\RedMoonSvr\20230521.bak'
RESTORE DATABASE redmoon
FROM DISK = 'C:\RedMoonSvr\20230521.bak'
WITH
MOVE 'redmoon_Data' TO 'C:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\DATA\redmoon_Data.mdf',
MOVE 'redmoon_Log' TO 'C:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\DATA\redmoon_Log.LDF';
GO
备份数据库
isql -U sa -P aa333666 -d master -Q"BACKUP DATABASE redmoon to disk='E:\BeiFen\redmoon0812.bak'"
isql -U sa -P aa333666 -d master -Q"BACKUP DATABASE AccountsInfo to disk='E:\BeiFen\AccountsInfo0812'"
恢复数据库
isql -U sa -P aa333666 -d master -Q"RESTORE DATABASE AccountsInfo from disk='E:\BeiFen\AccountsInfo0812'"
处理恢复后连接用户问题
isql -U sa -P aa333666 -d master -Q"sp_change_users_login 'update_one','登录名','登录名'"
--sql server加日志
DECLARE @var varchar(300)
DECLARE @cmd varchar(600)
SET @var = '['+CONVERT(varchar(100),GETDATE(),21)+']'+cast(1 as varchar(10))+','+cast(2 as varchar(10))+','+cast(3 as varchar(10))+','+cast(4 as varchar(10))+','+cast(5 as varchar(10))
--打印日志
SET @cmd = 'echo ' + @var + ' >> C:\sqllog\HYsp1_'+CONVERT(varchar(100),GETDATE(),12)+'.txt'
EXEC master..xp_cmdshell @cmd,no_output
远程访问SQL SERVER 2000数据库：
打开“企业管理器”，选择相应的SQL服务器，在右键菜单中选择“属性”，选择“常规”选项卡中的“网络配置”按钮，在打开的窗口中将“启动 WinSock 代理”勾上，然后设置“WinSock 代理地址”、“WinSock 代理端口”（与默认端口1433不同），这样，就可以通过ip,port 来访问远程SQL SERVER 2000数据库了。
RMS_LEVEL1000MAIL 依赖的对象tblGameID1、tblMail1、tblSpecialItem1
千级奖励
RMS_PICKUPITEM 依赖的对象tblSpecialItem1
拾取物品存储过程
RMS_TESTING 依赖的对象diamond、tblGameID1、tblGameIDRebirth、tblSpecialItem1
-- 游戏物品吃用即时更新效果的存储
-- 最多能设置10样物品
RMS_xiajia 依赖的对象paimaitable、tblMail1、tblSpecialItem1
拍卖下架
RMS_dataosha 依赖的对象tblMail1、tblSpecialItem1
大逃杀
RMS_REBIRTH 依赖的对象tblGameID1、tblGameIDRebirth、tblSpecialItem1
转生存储过程
RMS_SENDMAIL 依赖的对象tblMail1
RMS_SENDMAIL1 依赖的对象tblGameIDRebirth、tblMail1
加钻石，ZS1字段
RMS_ITEMDREAMBOX_USEITEM 依赖的对象RMS_SENDGROWTHITEMMAIL、tblSpecialItem1、tblItemDreamBox1、tblItemDreamBoxLog1
宝石箱、开启生化宝箱
--获取所有的用户表名 137张
use redmoon
SELECT NAME FROM SYSOBJECTS WHERE TYPE = 'U' ORDER BY NAME
dtproperties
T_SYS_CONFIG
T_SYS_MENU
T_SYS_VER
tblAccountsStatsLog
tblAgency
tblAgitList1
tblAgitListLog1
tblAgitSafeList1
tblAllAt
tblAllAtTest
tblArmy1
tblArmyAllianceList1
tblArmyBase1
tblArmyBaseGuardList1
tblArmyBaseLog1
tblArmyJoinSanctionList1
tblArmyList1
tblArmyListLog1
tblArmyMemberList1
tblArmyReconEvent
tblArmyShopList1
tblArmyShopListLog1
tblArmyWarList1
tblArmyWarListLog1
tblAutoBilling
tblBankLog
tblBasket
tblBattleLeagueEntry
tblBattleMatchEntryLog
tblBattleMatchInfoLog
tblBattleMatchServerEntry
tblBattleMatchUserPoint
tblBattleMatchUserPointLog
tblBattleZoneChampionLog
tblBattleZonePay
tblBattleZonePay1
tblBattleZonePayLog
tblBattleZonePayLog1
tblBattleZoneScore
tblBattleZoneScoreLog
tblBillID
tblBillIDStatistics
tblBillIDtemp
tblBonus2Log1
tblChatLog1
tblChatLogList1
tblCoupon
tblCoupon2
tblCouponCreate
tblCouponData
tblCouponPowwow
tblCouponPowwow_WarBible
tblCouponType
tblCurrentBattleMatchEntry
tblCurrentBattleMatchInfo
tblCurrentBattleZoneScore
tblDailyConnectLog1
tblDeletedGameID1
tblDumbList1
tblEventLog
tblExchange01temp
tblExchange02temp
tblExchange1_001
tblExchange1_002
tblExciteGame
tblFixedPaylog
tblFreeID
tblFullBackup
tblGameID1
tblGameParty
tblGamePartyResult1
tblGMCommandLog1
tblGroupInfo1
tblHiredSoldierList1
tblIdxZipcode
tblIndependenceDayEvent1
tblInterruptlog
tblItemLog1
tblItemLotteryList1
tblJustTest
tblLegalProtection1
tblMail1
tblMedalResult1
tblMegaPassLog
tblMrkUserInfo
tblneo1
tblneowizevent1
tblneowizeventAll
tblOccupiedBillID
tblOperatorConnectionLog
tblOperatorID
tblOperatorLog
tblPasswordLog
tblPayLog
tblPayLogUS
tblPayLogUS_2005
tblPCBangEvent
tblPostcdw
tblPPPCorp
tblPPPCorpIP
tblRecommend
tblRecommendEvent
tblRecommendlog
tblRedmoonCode
tblRedmoonEvent
tblRegBasket
tblRegCount
tblRegister
tblRegister_Warbible
tblRiceRank
tblShop
tblShopBillLog
tblShopBillLog2
tblShopEvent
tblShopEventCfg
tblShopEventLog
tblShopIP
tblShopStatistics
tblShopTimeUseLog
tblSpecialItem1
tblSpecialItemGrowthLog1
tblSpecialItemLimit1
tblSpecialItemLog1
tblSpecialItemShop1
tblSpecialItemShopLog1
tblSubArmyList1
tblUserBillLog
tblUserBillLog2
tblUserCountLog1_200503
tblUserLog1_200503
tblUserSanctionList1
tblUserStat1
tblUSRMAdmin
tblVerifyLog
tblVerifyLog2
tblVersion
--查看数据库中所有存储过程 Name存储过程名字,Definition存储过程内容 169个
SELECT Name FROM sys.sql_modules AS m INNER JOIN sys.all_objects AS o ON m.object_id = o.object_id WHERE o.[type] = 'P'
RMS_ARMY_WRITEARMYLOG
RMS_ARMY_WRITEARMYSHOPLOG
RMS_ARMY_WRITEWARLOG
RMS_Accounts_Info_Log
RMS_AppleEvent
RMS_BEGINCAPTAINYQUEST
RMS_BEGINSPYQUEST
RMS_BEGINUSESHOPTIME
RMS_CHANGEGAMEID
RMS_DAILYLOG
RMS_DECREASESHOPTIME
RMS_DECREASESHOPTIMELIMIT
RMS_DECREASESPECIALITEMDURABILITY
ZB版本：
declare @DecreaseDurability int
declare @iMapID int
select @iMapID=Map From tblGameID1 Where GameID=@GameID
if (@iMapID=35 OR @iMapID=69 OR @iMapID=70 OR @iMapID=45) return--35 闹市区 1 PK场
set @DecreaseDurability = 0
HY版本：
declare @DecreaseDurability int
set @DecreaseDurability = 0
RMS_DOITEMGROWTH
RMS_DecreasePoisonPillsDurability
RMS_ELECTCHAMPIONANDCLEANUPBATTLEMATCH
RMS_ELECTCHAMPIONANDCLEANUPBATTLEZONE
RMS_EQUIPITEM穿上装备
ZB版本：
if @FromWindowKind != 2 and @ToWindowKind = 2 and ( (@ToWindowIndex >= 0 and @ToWindowIndex < 14) or (@ToWindowIndex = 100) )
HY版本：
if @FromWindowKind != 2 and @ToWindowKind = 2 and ( (@ToWindowIndex >= 0 and @ToWindowIndex < 20) or (@ToWindowIndex = 100) )
RMS_EXTENDFREEDATE
RMS_GROUP_ADDGROUPMEMBER
RMS_GROUP_CHANGEUSERMAPNUMBER
RMS_GROUP_CREATENEWGROUP
RMS_GROUP_DELETEGROUP
RMS_GROUP_DELETEGROUPMEMBER
RMS_GROUP_DELETEMAPMEMBER
RMS_INCREASEBATTLEMATCHSCORE
RMS_INCREASEBATTLEZONESCORE
RMS_INCREASEBONUSQUESTCOUNT
RMS_INITIALIZEBILLBATTLEMATCH
RMS_INITIALIZEBILLBATTLEZONE
RMS_INSERTBATTLEMATCHENTRY
RMS_ITEMLOTTERY_INITIALIZE
RMS_ITEMLOTTERY_USEITEM
RMS_KASAMSPACESHIPMAIL
RMS_LEGALPROTECT_DELETE
RMS_LEGALPROTECT_SAVE
RMS_LEVEL1000MAIL
RMS_MEDALRESULT
RMS_MOVEITEMFROMTIMETOUSER
RMS_MOVEITEMFROMUSERTOTIME
RMS_MOVEUSERWINDOWITEM
RMS_PCSHOP_UPDATEEVENTUSETIME
RMS_PICKUPITEM捡物品
RMS_REMOVEALLMAPITEM
RMS_REMOVEMAPITEM
RMS_REMOVEONEITEM消耗1个物品
例如 双击快捷栏第2个格子，使用1次超级魔法针剂-4H,6=@ItemKind,300=@ItemIndex,@WindowKind=1,@WindowIndex=1,@Position=1
RMS_SENDBATTLEPRIZETMAIL
RMS_SENDBATTLETICKETMAIL
RMS_SENDMAIL
RMS_SENDNORMALITEMMAIL
RMS_SENDPOISONMAIL
RMS_SENDSPECIALITEMMAIL
RMS_SETBATTLEMATCHENTRY
RMS_SETBATTLEMATCHMEMBERCOUNT
RMS_SETBATTLEZONEPAY
RMS_SHOP_BUYSPECIALITEM
RMS_SHOP_CHANGESPECIALITEM
RMS_SHOP_SELLSPECIALITEM
RMS_TRYMAKEMYSTERYPILL
RMS_USEARTIFICIALMYSTERYPILL
RMS_USEMYSTERYPILL
RMS_USERDB_SETUSEREXP更新角色目前经验值
RMS_USERDB_SETUSERITEM更新角色水币、银行水币等角色数据
RMS_USERDB_SETUSERLEVELUP更新角色等级、技能点数等角色数据
RMS_ARMY_BREAKUPARMY
RMS_DECREASEBILLFREETIMER
RMS_ARMY_REMOVEAGIT
RMS_EXCHANGE_SENDEXCHANGEGAIN
RMS_ARMY_REMOVEARMYMEMBER
RMS_INITBONUS2
RMS_ARMY_REMOVEARMYSHOP
RMS_LOG_CREATENEXTDEATHLOGTABLE
RMS_ARMY_SENDEXPIRATIONNOTICE
RMS_LOG_CREATENEXTITEMLOGTABLE
RMS_LOG_CREATENEXTLEVELLOGTABLE
RMS_LOG_CREATENEXTMAILLOGTABLE
RMS_LOG_CREATENEXTPLAYLOGTABLE
RMS_LOG_CREATENEXTUCOUNTLOGTABLE
RMS_LOG_CREATENEXTUSERLOGTABLE
BILL_PROCESS_COUPON
RMS_ADDBATTLEMATCHUSERPOINT
RMS_ADDBATTLEMATCHUSERPOINT2
RMS_ADDBONUSINITQUEST
RMS_ADDSPECIALITEM
RMS_ARMY_ADDARMYBASEGAIN
RMS_ARMY_ADDARMYINITMEMBER
RMS_ARMY_ADDARMYMEMBER
dt_generateansiname
RMS_ARMY_ADDARMYSHOPGAIN
dt_adduserobject
RMS_ARMY_ADDHIREDSOLDIER
dt_setpropertybyid
RMS_ARMY_ADDREJOINSANCTION
dt_getobjwithprop
RMS_ARMY_ADDSUBARMYMEMBER
dt_getpropertiesbyid
RMS_ARMY_ADJUSTARMYWAR
dt_setpropertybyid_u
RMS_ARMY_BEGINCONTROLARMYSHOP
dt_getobjwithprop_u
RMS_ARMY_BEGINWAR
dt_getpropertiesbyid_u
RMS_ARMY_BREAKARMYALLIANCE
dt_dropuserobjectbyid
RMS_ARMY_BREAKUPRESERVEARMY
dt_droppropertiesbyid
RMS_ARMY_CANCELARMYCREATIONINFO
dt_verstamp006
RMS_ARMY_CANCELCREATEARMY
dt_getpropertiesbyid_vcs
RMS_ARMY_CHANGEAGITOWNER
dt_displayoaerror
RMS_ARMY_CHANGEARMYBASEOWNER
dt_adduserobject_vcs
RMS_ARMY_CHANGEARMYCOMMANDER
dt_addtosourcecontrol
RMS_ARMY_CHANGEARMYNOTICE
dt_checkinobject
RMS_ARMY_CHANGEARMYPASSWORD
dt_checkoutobject
RMS_ARMY_CHANGEARMYWARSCORE
dt_isundersourcecontrol
RMS_ARMY_CHANGEPERMISSION
dt_removefromsourcecontrol
RMS_ARMY_CHANGESHOPOWNER
dt_validateloginparams
RMS_ARMY_CHANGESUBARMYCOMMANDER
dt_vcsenabled
RMS_ARMY_CHANGESUBARMYNOTICE
dt_whocheckedout
RMS_ARMY_CHECKAGITCLOSURE
dt_addtosourcecontrol_u
RMS_ARMY_CREATEARMY
dt_checkinobject_u
RMS_ARMY_CREATEARMYFROMRSARMY
dt_checkoutobject_u
RMS_ARMY_CREATERESERVEARMY
dt_displayoaerror_u
RMS_ARMY_CREATESUBARMY
dt_getpropertiesbyid_vcs_u
RMS_ARMY_DECLAREWAR
dt_isundersourcecontrol_u
RMS_ARMY_DELETESAFEITEM
dt_validateloginparams_u
RMS_ARMY_DOARMYALLIANCE
dt_whocheckedout_u
RMS_ARMY_ENDWAR
RMS_ARMY_ENDWARRESULT
RMS_ARMY_EXTENDACTIVITYDURATION
RMS_ARMY_EXTENDAGITEXPIRATION
RMS_ARMY_FAILEDENDWARAGREEMENT
RMS_ARMY_FINISHCREATEARMY
RMS_ARMY_INITIALIZEARMYBASE
RMS_ARMY_INSERTAGITWARCODE
RMS_ARMY_INSERTSAFEITEM
RMS_ARMY_REMOVEARMYAGIT
RMS_ARMY_REMOVEARMYINITMEMBER
RMS_ARMY_REMOVEHIREDSOLDIER
RMS_ARMY_REMOVEREJOINSANCTION
RMS_ARMY_REMOVESUBARMY
RMS_ARMY_REMOVESUBARMYMEMBER
RMS_ARMY_RENTEMPTYAGIT
RMS_ARMY_SENDARMYBASEGAIN
RMS_ARMY_SENDARMYSHOPGAIN
RMS_ARMY_SETARMYSHOPTEX
RMS_ARMY_UPDATESAFEITEM
RMS_ARMY_UPDATESAFEMONEY
RMS_ARMY_WRITEAGITLOG
RMS_ARMY_WRITEARMYBASELOG
HYRM版本
--获取所有的用户表名 153张
use redmoon
SELECT NAME FROM SYSOBJECTS WHERE TYPE = 'U' ORDER BY NAME
NAME
dtproperties
My_Cai_Piao_List
My_Check
My_Login_Log
My_Shop_Event
My_Shop_Gold
My_Shop_Points
My_Shop_Water
My_Special_Equip_List
T_SYS_CONFIG
T_SYS_MENU
T_SYS_VER
tblAccountsStatsLog
tblAgency
tblAgitList1
tblAgitListLog1
tblAgitSafeList1
tblAllAt
tblAllAtTest
tblArmy1
tblArmyAllianceList1
tblArmyBase1
tblArmyBaseGuardList1
tblArmyBaseLog1
tblArmyJoinSanctionList1
tblArmyList1
tblArmyListLog1
tblArmyMemberList1
tblArmyReconEvent
tblArmyShopList1
tblArmyShopListLog1
tblArmyWarList1
tblArmyWarListLog1
tblAutoBilling
tblBankLog
tblBasket
tblBattleLeagueEntry
tblBattleMatchEntryLog
tblBattleMatchInfoLog
tblBattleMatchServerEntry
tblBattleMatchUserPoint
tblBattleMatchUserPointLog
tblBattleZoneChampionLog
tblBattleZonePay
tblBattleZonePay1
tblBattleZonePayLog
tblBattleZonePayLog1
tblBattleZoneScore
tblBattleZoneScoreLog
tblBillID
tblBillIDStatistics
tblBillIDtemp
tblBonus2Log1
tblChatLog1
tblChatLogList1
tblCoupon
tblCoupon2
tblCouponCreate
tblCouponData
tblCouponPowwow
tblCouponPowwow_WarBible
tblCouponType
tblCurrentBattleMatchEntry
tblCurrentBattleMatchInfo
tblCurrentBattleZoneScore
tblDailyConnectLog1
tblDeathLog1_200407
tblDeletedGameID1
tblDumbList1
tblEventLog
tblExchange01temp
tblExchange02temp
tblExchange1_001
tblExchange1_002
tblExciteGame
tblFixedPaylog
tblFreeID
tblFullBackup
tblGameID1
tblGameIDX
tblGameParty
tblGamePartyResult1
tblGamePlayLog1_200405
tblGamePlayLog1_200406
tblGMCommandLog1
tblGroupInfo1
tblHiredSoldierList1
tblIdxZipcode
tblIndependenceDayEvent1
tblInterruptlog
tblItemLog1
tblItemLog1_200302
tblItemLotteryList1
tblJustTest
tblLegalProtection1
tblLevelLog1_200405
tblMail1
tblMailLog1_200405
tblMedalResult1
tblMegaPassLog
tblMrkUserInfo
tblneo1
tblneowizevent1
tblneowizeventAll
tblOccupiedBillID
tblOperatorConnectionLog
tblOperatorID
tblOperatorLog
tblPasswordLog
tblPayLog
tblPayLogUS
tblPayLogUS_2002
tblPayLogUS_2003
tblPCBangEvent
tblPostcdw
tblPPPCorp
tblPPPCorpIP
tblRecommend
tblRecommendEvent
tblRecommendlog
tblRedmoonCode
tblRedmoonEvent
tblRegBasket
tblRegCount
tblRegister
tblRegister_Warbible
tblRiceRank
tblShop
tblShopBillLog
tblShopBillLog2
tblShopEvent
tblShopEventCfg
tblShopEventLog
tblShopIP
tblShopStatistics
tblShopTimeUseLog
tblSpecialItem1
tblSpecialItemGrowthLog1
tblSpecialItemLimit1
tblSpecialItemLog1
tblSpecialItemShop1
tblSpecialItemShopLog1
tblSubArmyList1
tblUserBillLog
tblUserBillLog2
tblUserCountLog1_200405
tblUserLog1_200407
tblUserSanctionList1
tblUserStat1
tblUSRMAdmin
tblVerifyLog
tblVerifyLog2
tblVersion
--查看数据库中所有存储过程 Name存储过程名字,Definition存储过程内容 185个
SELECT Name FROM sys.sql_modules AS m INNER JOIN sys.all_objects AS o ON m.object_id = o.object_id WHERE o.[type] = 'P'
Name
RMS_ARMY_WRITEARMYLOG
dt_checkinobject
RMS_ARMY_WRITEARMYSHOPLOG
dt_checkoutobject
RMS_ARMY_WRITEWARLOG
dt_isundersourcecontrol
RMS_Accounts_Info_Log
dt_removefromsourcecontrol
RMS_AppleEvent
dt_validateloginparams
RMS_BEGINCAPTAINYQUEST
dt_vcsenabled
RMS_BEGINSPYQUEST
dt_whocheckedout
RMS_BEGINUSESHOPTIME
dt_getpropertiesbyid_vcs_u
RMS_CHANGEGAMEID
dt_displayoaerror_u
RMS_DAILYLOG
My_Check_Hacker
dt_addtosourcecontrol_u
RMS_DECREASESHOPTIME
dt_checkinobject_u
RMS_DECREASESHOPTIMELIMIT
dt_checkoutobject_u
RMS_DECREASESPECIALITEMDURABILITY
dt_isundersourcecontrol_u
RMS_DOITEMGROWTH
dt_validateloginparams_u
RMS_DecreasePoisonPillsDurability
dt_whocheckedout_u
RMS_ELECTCHAMPIONANDCLEANUPBATTLEMATCH
RMS_ELECTCHAMPIONANDCLEANUPBATTLEZONE
RMS_EQUIPITEM
RMS_EXTENDFREEDATE
RMS_GROUP_ADDGROUPMEMBER
RMS_GROUP_CHANGEUSERMAPNUMBER
RMS_GROUP_CREATENEWGROUP
RMS_GROUP_DELETEGROUP
RMS_GROUP_DELETEGROUPMEMBER
RMS_GROUP_DELETEMAPMEMBER
RMS_INCREASEBATTLEMATCHSCORE
RMS_INCREASEBATTLEZONESCORE
RMS_INCREASEBONUSQUESTCOUNT
RMS_INITIALIZEBILLBATTLEMATCH
RMS_INITIALIZEBILLBATTLEZONE
RMS_INSERTBATTLEMATCHENTRY
RMS_ITEMLOTTERY_INITIALIZE
My_Use_Exp_Card
RMS_ITEMLOTTERY_USEITEM
My_Extract_Money
RMS_KASAMSPACESHIPMAIL
RMS_LEGALPROTECT_DELETE
My_Use_Money_Box
RMS_LEGALPROTECT_SAVE
RMS_LEVEL1000MAIL
RMS_MEDALRESULT
My_Pick_Up_Item
RMS_MOVEITEMFROMTIMETOUSER
RMS_MOVEITEMFROMUSERTOTIME
RMS_MOVEUSERWINDOWITEM
RMS_PCSHOP_UPDATEEVENTUSETIME
RMS_PICKUPITEM
RMS_REMOVEALLMAPITEM
RMS_REMOVEMAPITEM
RMS_REMOVEONEITEM
RMS_SENDBATTLEPRIZETMAIL
RMS_SENDBATTLETICKETMAIL
RMS_SENDMAIL
RMS_SENDNORMALITEMMAIL
RMS_SENDPOISONMAIL
RMS_SENDSPECIALITEMMAIL
RMS_SETBATTLEMATCHENTRY
RMS_SETBATTLEMATCHMEMBERCOUNT
RMS_SETBATTLEZONEPAY
RMS_SHOP_BUYSPECIALITEM
RMS_SHOP_CHANGESPECIALITEM
RMS_SHOP_SELLSPECIALITEM
My_Ide_Item
RMS_TRYMAKEMYSTERYPILL
My_Del_Item
RMS_USEARTIFICIALMYSTERYPILL
RMS_USEMYSTERYPILL
RMS_USERDB_SETUSEREXP
RMS_USERDB_SETUSERITEM
My_Up_Bonus
RMS_USERDB_SETUSERLEVELUP
RMS_ARMY_BREAKUPARMY
RMS_DECREASEBILLFREETIMER
My_Timing_Min_Exp
RMS_ARMY_REMOVEAGIT
RMS_EXCHANGE_SENDEXCHANGEGAIN
RMS_ARMY_REMOVEARMYMEMBER
RMS_INITBONUS2
RMS_ARMY_REMOVEARMYSHOP
RMS_LOG_CREATENEXTDEATHLOGTABLE
RMS_ARMY_SENDEXPIRATIONNOTICE
RMS_LOG_CREATENEXTITEMLOGTABLE
RMS_LOG_CREATENEXTLEVELLOGTABLE
RMS_LOG_CREATENEXTMAILLOGTABLE
RMS_LOG_CREATENEXTPLAYLOGTABLE
RMS_LOG_CREATENEXTUCOUNTLOGTABLE
RMS_LOG_CREATENEXTUSERLOGTABLE
BILL_PROCESS_COUPON
RMS_ADDBATTLEMATCHUSERPOINT
RMS_ADDBATTLEMATCHUSERPOINT2
RMS_ADDBONUSINITQUEST
RMS_ADDSPECIALITEM
RMS_ARMY_ADDARMYBASEGAIN
RMS_ARMY_ADDARMYINITMEMBER
RMS_ARMY_ADDARMYMEMBER
RMS_ARMY_ADDARMYSHOPGAIN
RMS_ARMY_ADDHIREDSOLDIER
RMS_ARMY_ADDREJOINSANCTION
RMS_ARMY_ADDSUBARMYMEMBER
RMS_ARMY_ADJUSTARMYWAR
RMS_ARMY_BEGINCONTROLARMYSHOP
RMS_ARMY_BEGINWAR
RMS_ARMY_BREAKARMYALLIANCE
RMS_ARMY_BREAKUPRESERVEARMY
RMS_ARMY_CANCELARMYCREATIONINFO
RMS_ARMY_CANCELCREATEARMY
RMS_ARMY_CHANGEAGITOWNER
RMS_ARMY_CHANGEARMYBASEOWNER
RMS_ARMY_CHANGEARMYCOMMANDER
RMS_ARMY_CHANGEARMYNOTICE
RMS_ARMY_CHANGEARMYPASSWORD
RMS_ARMY_CHANGEARMYWARSCORE
RMS_ARMY_CHANGEPERMISSION
RMS_ARMY_CHANGESHOPOWNER
RMS_ARMY_CHANGESUBARMYCOMMANDER
RMS_ARMY_CHANGESUBARMYNOTICE
RMS_ARMY_CHECKAGITCLOSURE
RMS_ARMY_CREATEARMY
RMS_ARMY_CREATEARMYFROMRSARMY
RMS_ARMY_CREATERESERVEARMY
RMS_ARMY_CREATESUBARMY
RMS_ARMY_DECLAREWAR
RMS_ARMY_DELETESAFEITEM
RMS_ARMY_DOARMYALLIANCE
RMS_ARMY_ENDWAR
My_Grow_Up
RMS_ARMY_ENDWARRESULT
RMS_ARMY_EXTENDACTIVITYDURATION
RMS_ARMY_EXTENDAGITEXPIRATION
RMS_ARMY_FAILEDENDWARAGREEMENT
RMS_ARMY_FINISHCREATEARMY
RMS_ARMY_INITIALIZEARMYBASE
RMS_ARMY_INSERTAGITWARCODE
dt_generateansiname
RMS_ARMY_INSERTSAFEITEM
My_Shop_Buy
dt_adduserobject
RMS_ARMY_REMOVEARMYAGIT
My_Shop_Sell
dt_setpropertybyid
RMS_ARMY_REMOVEARMYINITMEMBER
dt_getobjwithprop
RMS_ARMY_REMOVEHIREDSOLDIER
My_Mop_Drop_Add_Item
dt_getpropertiesbyid
RMS_ARMY_REMOVEREJOINSANCTION
dt_setpropertybyid_u
RMS_ARMY_REMOVESUBARMY
dt_getobjwithprop_u
RMS_ARMY_REMOVESUBARMYMEMBER
dt_getpropertiesbyid_u
RMS_ARMY_RENTEMPTYAGIT
dt_dropuserobjectbyid
RMS_ARMY_SENDARMYBASEGAIN
dt_droppropertiesbyid
RMS_ARMY_SENDARMYSHOPGAIN
dt_verstamp006
RMS_ARMY_SETARMYSHOPTEX
My_Login_Write
dt_verstamp007
RMS_ARMY_UPDATESAFEITEM
My_Get_Login_Ip_Cnt
dt_getpropertiesbyid_vcs
RMS_ARMY_UPDATESAFEMONEY
dt_displayoaerror
RMS_ARMY_WRITEAGITLOG
dt_adduserobject_vcs
RMS_ARMY_WRITEARMYBASELOG
dt_addtosourcecontrol
--4h魔化针剂 cd信息的存储字段
--3:14398000.8:14398000:50.17:14398000:125.25:14398000.42:14398000:50.
--3:14089985.8:14089985:50.17:14089985:125.25:14089985.42:14089985:50.
--update [redmoon].[dbo].[tblGameID1] set [SETimer]='' where gameid='123'
update [redmoon].[dbo].[tblGameID1] set [SETimer]='3:14089985.8:14089985:50.17:14089985:125.25:14089985.42:14089985:50.' where gameid='123'
tblSpecialItem1表：
Itemkind是物品种类，特装和生化是6；
ItemIndex是物品编号；
ItemDurability是物品耐久度，特装的话，4为9色；
Position是物品位置，0为地上，1为人物身上；
Map，X，Y分别为物品所在地图、坐标（当Position为0时有效）
Tilekind好像是物品存在与否，1为物品所有人 ID
Windowkind是物品在人物的何处，1为物品栏即F3，2为装备栏即F4，3为快捷栏即F8；
WindowIndex为物品所在栏的位置顺序，0为第一格
AttackGrade StrengthGrade SpiritGrade DexterityGrade PowerGrade为生化的五个属性
AttackGrad是等级，0-无 1-R 2-G 3-S 4-P
StrengthGrade SpiritGrade DexterityGrade PowerGrade分别是力，意，敏，骨四个属性。
elseIf rs("itemindex")=114 then
wupinname="重生之枪"
elseIf rs("itemindex")=134 then
wupinname="重生之枪R"
elseIf rs("itemindex")=154 then
wupinname="重生之枪G"
elseif rs("itemindex")=174 then
wupinname="重生之枪S"
if rs("itemindex")=194 then
wupinname="重生之枪P"
--sql server加日志 穿上装备日志RMS_EQUIPITEM_240908
DECLARE @var varchar(300)
DECLARE @cmd varchar(600)
SET @var = '['+CONVERT(varchar(100),GETDATE(),21)+']'+@GameID+','+cast(@ItemKind as varchar(10))+','+cast(@ItemIndex as varchar(20))+','+cast(@FromPosition as varchar(10))+','+cast(@FromWindowKind as varchar(20))+','+cast(@FromWindowIndex as varchar(20))+','+cast(@ToPosition as varchar(10))+','+cast(@ToWindowKind as varchar(20))+','+cast(@ToWindowIndex as varchar(20))
--打印日志
SET @cmd = 'echo ' + @var + ' >> C:\sqllog\RMS_EQUIPITEM_'+CONVERT(varchar(100),GETDATE(),12)+'.txt'
EXEC master..xp_cmdshell @cmd,no_output
--sql server加日志 捡物品日志RMS_PICKUPITEM_240908
DECLARE @var varchar(300)
DECLARE @cmd varchar(600)
SET @var = '['+CONVERT(varchar(100),GETDATE(),21)+']'+@GameID+','+cast(@ItemKind as varchar(10))+','+cast(@ItemIndex as varchar(10))+','+cast(@Map as varchar(10))+','+cast(@WindowKind as varchar(10))+','+cast(@WindowIndex as varchar(10))
--打印日志
SET @cmd = 'echo ' + @var + ' >> C:\sqllog\RMS_PICKUPITEM_'+CONVERT(varchar(100),GETDATE(),12)+'.txt'
EXEC master..xp_cmdshell @cmd,no_output
--sql server加日志 消耗1个道具日志RMS_REMOVEONEITEM_240908
DECLARE @var varchar(300)
DECLARE @cmd varchar(600)
SET @var = '['+CONVERT(varchar(100),GETDATE(),21)+']'+@GameID+','+cast(@ItemKind as varchar(10))+','+cast(@ItemIndex as varchar(10))+','+cast(@WindowKind as varchar(10))+','+cast(@WindowIndex as varchar(10))+','+cast(@Position as varchar(10))
--打印日志
SET @cmd = 'echo ' + @var + ' >> C:\sqllog\RMS_REMOVEONEITEM_'+CONVERT(varchar(100),GETDATE(),12)+'.txt'
EXEC master..xp_cmdshell @cmd,no_output
穿上装备日志RMS_EQUIPITEM_240908
[2024-09-08 13:51:01.327]江南红月,6,95依里甲,1人物身上,1物品栏即F3,6第7格,1人物身上,2装备栏即F4,17第18格
[2024-09-08 13:51:03.980]江南红月,6,97依里裤,1,1,12,1,2,19
[2024-09-08 13:56:26.200]江南红月,6,98依里盾,1,1,6,1,2,5
[2024-09-08 13:56:33.310]江南红月,6,96依里头,1,1,12,1,2,18
[2024-09-08 13:56:34.530]江南红月,6,98依里盾,1,1,18,1,2,5
[2024-09-08 13:58:04.153]江南红月,6,98依里盾,1,1,12,1,2,19
[2024-09-08 13:58:06.543]江南红月,6,98依里盾,1,1,12,1,2,19
[2024-09-08 13:58:13.217]江南红月,6,400光环1,1,1,6,1,2,15
[2024-09-08 13:58:28.607]江南红月,6,97依里裤,1,1,18,1,2,18
[2024-09-08 13:59:34.060]江南红月,6,97依里裤,1,1,0,1,2,18
产出道具日志RMS_ADDSPECIALITEM_240909
[2024-09-09 11:08:13.780]6,102生化裤,0地上,29住宅区 3
[2024-09-09 11:17:07.483]6,102,0,29
[2024-09-09 11:23:15.687]6,111教皇杖,0,29
[2024-09-09 11:31:22.233]6,113虚无弓,0,29
[2024-09-09 11:31:29.717]6,104生化盾牌,0,29
[2024-09-09 11:41:52.043]6,108皇族项链,0,29
[2024-09-09 11:43:23.903]6,112毁灭矛,0,29
[2024-09-09 11:48:11.403]6,200生命水,0,29
[2024-09-09 11:50:22.233]6,100生化头盔,0,29
[2024-09-09 11:52:42.013]6,108,0,29
[2024-09-09 11:56:21.387]6,107皇族戒指,0,29
[2024-09-09 11:56:29.403]6,104,0,29
[2024-09-09 11:59:45.263]6,103生化靴,0,29
[2024-09-09 12:01:44.780]6,200,0,29
[2024-09-09 12:02:29.293]6,104,0,29
[2024-09-09 12:04:50.183]6,104,0,29
[2024-09-09 12:07:51.153]6,104,0,29
[2024-09-09 12:10:29.090]6,100,0,29
[2024-09-09 12:13:28.390]6,101生化甲,0,29
捡物品日志RMS_PICKUPITEM_240908
[2024-09-08 14:09:59.997]江南红月,6,23疾风靴,81喜玛拉雅 医院,1物品栏即F3,1第2格
[2024-09-08 14:10:00.060]江南红月,6,23疾风靴,81喜玛拉雅 医院,1,1
[2024-09-08 14:10:01.810]江南红月,6,23疾风靴,81喜玛拉雅 医院,1,1
[2024-09-08 14:10:03.420]江南红月,6,96依里头,81喜玛拉雅 医院,1,2
[2024-09-08 14:10:03.467]江南红月,6,96依里头,81喜玛拉雅 医院,1,2
捡物品日志RMS_PICKUPITEM_240909
[2024-09-09 10:39:28.653]江南红月,6,101生化甲,29住宅区 3,1物品栏即F3,0第1格
[2024-09-09 10:39:28.683]江南红月,6,101,29,1,0
[2024-09-09 10:39:28.700]江南红月,6,101,29,1,0
[2024-09-09 10:39:28.730]江南红月,6,101,29,1,0
[2024-09-09 10:39:28.747]江南红月,6,101,29,1,0
[2024-09-09 11:08:14.763]江南红月,6,102生化裤,29,1,0
[2024-09-09 11:08:14.793]江南红月,6,102,29,1,0
[2024-09-09 11:08:14.827]江南红月,6,102,29,1,0
[2024-09-09 11:17:10.763]江南红月,6,102,29,1,0
[2024-09-09 11:17:10.810]江南红月,6,102,29,1,0
[2024-09-09 11:31:29.263]江南红月,6,113虚无弓,29,1,1
[2024-09-09 11:31:29.340]江南红月,6,113,29,1,1
[2024-09-09 11:31:33.140]江南红月,6,104生化盾牌,29,1,2
[2024-09-09 11:31:33.217]江南红月,6,104,29,1,2
[2024-09-09 11:31:33.233]江南红月,6,104,29,1,2
[2024-09-09 11:31:33.250]江南红月,6,104,29,1,2
[2024-09-09 11:31:33.280]江南红月,6,104,29,1,2
[2024-09-09 11:50:25.403]江南红月,6,100生化头盔,29,1,3
[2024-09-09 11:50:25.433]江南红月,6,100,29,1,3
[2024-09-09 11:50:25.467]江南红月,6,100,29,1,3
[2024-09-09 11:52:44.793]江南红月,6,108皇族项链,29,1,4
[2024-09-09 11:52:44.857]江南红月,6,108,29,1,4
[2024-09-09 11:56:32.560]江南红月,6,104,29,1,2
[2024-09-09 11:56:32.623]江南红月,6,104,29,1,2
[2024-09-09 12:34:42.030]江南红月,6,104,29,1,2
[2024-09-09 12:34:42.060]江南红月,6,104,29,1,2
[2024-09-09 12:34:42.090]江南红月,6,104,29,1,2
[2024-09-09 12:42:12.043]江南红月,6,103,29,1,5
[2024-09-09 12:42:12.107]江南红月,6,103,29,1,5
[2024-09-09 12:50:41.310]江南红月,6,104,29,1,2
[2024-09-09 12:50:41.373]江南红月,6,104,29,1,2
[2024-09-09 12:53:11.780]江南红月,6,104,29,1,2
[2024-09-09 12:53:11.810]江南红月,6,104,29,1,2
[2024-09-09 12:53:11.827]江南红月,6,104,29,1,2
[2024-09-09 12:53:11.840]江南红月,6,104,29,1,2
消耗1个道具日志RMS_REMOVEONEITEM_240908
[2024-09-08 15:24:03.123]juese1,6,300超级魔法针剂-4H,3快捷栏即F8,0第1格,1人物身上
[2024-09-08 13:51:11.700]江南红月,6,312超级魔法针剂-24H,1物品栏即F3,5第6格,1人物身上
[2024-09-08 13:56:16.107]江南红月,6,67极药,1,5,1
[2024-09-08 14:55:07.497]江南红月,6,301洗黑道具,1,0,1
[2024-09-08 14:55:49.390]江南红月,6,301,1,0,1
消耗1个道具日志RMS_REMOVEONEITEM_240909
[2024-09-09 00:12:06.967]江南红月,6,312,1,3,1
[2024-09-09 10:54:35.170]江南红月,6,121生化甲R,1,0,1
[2024-09-09 10:54:44.920]江南红月,6,101生化甲,1,0,1
[2024-09-09 10:54:56.937]江南红月,6,101,1,0,1
[2024-09-09 11:13:58.933]江南红月,6,122生化裤R,1,0,1
[2024-09-09 16:07:51.607]江南红月,6,200生命水,3快捷栏即F8,6第7格,1人物身上
[2024-09-09 16:08:04.043]江南红月,6,200,3,6,1
更新角色等级、技能点数等角色数据的日志RMS_USERDB_SETUSERLEVELUP_240908
[2024-09-08 14:18:40.840]江南红月,1000等级,0目前经验值,1810技能点数,131071
[2024-09-08 14:23:27.060]江南红月,1000,0,1810,131071
[2024-09-08 14:57:25.153]江南红月,1000,0,1810,131071
RMS_USERDB_SETUSERLEVELUP_240909
[2024-09-09 10:33:38.467]江南红月,1000,0,437,131071
[2024-09-09 10:33:41.467]江南红月,1000,0,437,131071
[2024-09-09 10:33:47.123]江南红月,1000,0,437,131071
[2024-09-09 10:33:59.623]江南红月,1000,0,371,131071
更新角色目前经验值的日志
RMS_USERDB_SETUSEREXP_240908
[2024-09-08 13:53:12.420]江南红月,629860000
[2024-09-08 13:53:47.140]江南红月,742757000
[2024-09-08 14:08:13.683]江南红月,178132625
[2024-09-08 14:08:31.700]江南红月,213234625
[2024-09-08 14:09:37.653]江南红月,412793310
[2024-09-08 14:09:43.670]江南红月,733425310
[2024-09-08 14:10:38.793]江南红月,1054057310
[2024-09-08 14:17:13.513]江南红月,2035765310
[2024-09-08 14:17:19.530]江南红月,*
[2024-09-08 14:17:25.543]江南红月,-656041986
[2024-09-08 14:18:25.577]江南红月,-349865986
[2024-09-08 14:18:49.590]江南红月,626808000
[2024-09-08 14:18:55.623]江南红月,1253616000
[2024-09-08 14:19:01.640]江南红月,*
[2024-09-08 14:19:07.653]江南红月,*
[2024-09-08 14:23:26.623]江南红月,*
[2024-09-08 14:23:32.640]江南红月,1311506000
[2024-09-08 14:23:38.653]江南红月,*
[2024-09-08 14:52:28.217]江南红月,*
[2024-09-08 14:52:43.280]江南红月,-711223296
[2024-09-08 14:52:49.293]江南红月,-332767296
[2024-09-08 14:57:30.700]江南红月,756912000
[2024-09-08 15:03:12.077]江南红月,757014600
[2024-09-08 15:03:18.090]江南红月,757113800
RMS_USERDB_SETUSEREXP_240909
[2024-09-09 10:31:50.810]江南红月,757167400
[2024-09-09 10:31:56.827]江南红月,757177000
[2024-09-09 10:32:02.840]江南红月,757211400
[2024-09-09 10:33:43.170]江南红月,-727379668
[2024-09-09 10:33:49.187]江南红月,800
[2024-09-09 10:37:27.653]江南红月,-727305268
[2024-09-09 10:37:33.670]江南红月,-727181268
[2024-09-09 10:37:39.687]江南红月,-727106868
[2024-09-09 10:37:45.700]江南红月,-727007668
[2024-09-09 10:37:51.717]江南红月,-726908468
[2024-09-09 10:37:57.733]江南红月,-726678468
RMS_DECREASESPECIALITEMDURABILITY_240909
[2024-09-09 16:07:46.827]江南红月,6,96依里头,2装备栏即F4,0第1格
[2024-09-09 16:07:46.857]江南红月,6,92智慧项链,2,1
[2024-09-09 16:07:46.873]江南红月,6,23疾风靴,2,4
[2024-09-09 16:07:46.890]江南红月,6,98依里盾,2,5
[2024-09-09 16:07:46.920]江南红月,6,90智慧之泪,2,9
[2024-09-09 16:07:46.937]江南红月,6,90,2,10
[2024-09-09 16:07:46.950]江南红月,6,90,2,11
[2024-09-09 16:08:01.200]江南红月,6,96,2,0
[2024-09-09 16:08:01.230]江南红月,6,92,2,1
[2024-09-09 16:08:01.247]江南红月,6,23,2,4
[2024-09-09 16:08:01.280]江南红月,6,98,2,5
[2024-09-09 16:08:01.293]江南红月,6,90,2,9
[2024-09-09 16:08:01.310]江南红月,6,90,2,10
[2024-09-09 16:08:01.340]江南红月,6,90,2,11