挑战上线自动送点卡.商城币.和查询GM号SQL执行语句
本帖最后由 EGameol 于 2023-11-5 16:41 编辑上线送时间
用查询分析器 必须在billing执行
CREATE TRIGGER ON .
after Insert
as
Update set
.remain_time =999999,remain_freetime =999999,expire_freetime =2999-1-9
From Inserted
Where .user_id=inserted.user_id
and .group_id=inserted.group_id
updateuser_account set remain_time =999999,remain_freetime=999999,expire_freetime=2999-1-9
where expire_freetime =2006-1-9
上线送商币
用查询分析器 必须在 cash
CREATE TRIGGER ON .
after Insert
as
Update set .amount=900000000,free_amount=900000000
From Inserted
Where .group_id=inserted.group_id
and .id=inserted.id
查询GM号
selectcharacter_namefromcharacter.dbo.user_characterwherecharacter_namelike%GM%
页:
[1]