2026-09-07

20260907更新日志-增加账号记录,必须在A库执行否则将会产生错误, FLD_RAWID为uid对应的账号

SQL语句
ALTER TABLE [TBL_ACCOUNT] ADD [FLD_RAWID] [nchar] (25)
2026-09-01

20260901更新日志

SQL语句
--增加额外伤害
ALTER TABLE [SYS_Stditems] ADD [ExtraDamage] int
go

--更新恢复石的用户装备数据,如无此功能可以忽略
UPDATE TBL_ITEM SET FLD_COLOR = FLD_DESC1 * 65536 + FLD_DESC0, FLD_DESC0 = 0, FLD_DESC1 = 0 WHERE ((FLD_INDEX - 1) IN (SELECT idx FROM sys_stditems WHERE stdmode = 201))
UPDATE TBL_SAVEDITEM SET FLD_COLOR = FLD_DESC1 * 65536 + FLD_DESC0, FLD_DESC0 = 0, FLD_DESC1 = 0 WHERE ((FLD_INDEX - 1) IN (SELECT idx FROM sys_stditems WHERE stdmode = 201))
UPDATE TBL_ITEMMARKET SET FLD_COLOR = FLD_DESC1 * 65536 + FLD_DESC0, FLD_DESC0 = 0, FLD_DESC1 = 0 WHERE ((FLD_INDEX - 1) IN (SELECT idx FROM sys_stditems WHERE stdmode = 201))
UPDATE TBL_DHLBOX SET FLD_COLOR = FLD_DESC1 * 65536 + FLD_DESC0, FLD_DESC0 = 0, FLD_DESC1 = 0 WHERE ((FLD_INDEX - 1) IN (SELECT idx FROM sys_stditems WHERE stdmode = 201))
UPDATE TBL_PETITEM SET FLD_COLOR = FLD_DESC1 * 65536 + FLD_DESC0, FLD_DESC0 = 0, FLD_DESC1 = 0 WHERE ((FLD_INDEX - 1) IN (SELECT idx FROM sys_stditems WHERE stdmode = 201))
go