找回密码
 立即注册
查看: 6013|回复: 0

[技术文章] 挑战上线自动送点卡.商城币.和查询GM号SQL执行语句

[复制链接]

96

主题

3

回帖

1355

积分

超级版主

积分
1355
金钱
228
贡献
1028
注册时间
2023-11-3
发表于 2023-11-5 16:40:44 | 显示全部楼层 |阅读模式
本帖最后由 EGameol 于 2023-11-5 16:41 编辑
. q0 l8 D" M" ~- G; X, v+ s( Q4 p- w  W! s6 Y1 k
上线送时间
& `$ h/ M( M5 C" j! o- S用查询分析器 必须在billing执行0 G- U8 b1 @  \1 u% o+ t7 `
  1. CREATE TRIGGER [free] ON [dbo].[user_account]
    / M5 M# D. }, N+ K# T  N; |
  2. after Insert" n# |: E6 [2 Y. Z
  3. as; t, n* ~, k! W8 y
  4. Update [user_account] set
    # C8 W: b+ W& ]' z4 G' z9 h: a8 O- a
  5. [user_account].remain_time =999999,remain_freetime =999999,expire_freetime =2999-1-9  E' s' e8 h% ?+ X7 \
  6. From Inserted
    9 H0 ~- P5 E& E9 r
  7. Where [user_account].user_id=inserted.user_id" K  {& C+ ~" y" o
  8. and [user_account].group_id=inserted.group_id% |& o9 x6 y; i" d9 p' K
  9. update  user_account set remain_time =999999,remain_freetime=999999,expire_freetime=2999-1-9' d# f8 b# R0 [
  10. where expire_freetime =2006-1-9
复制代码
  ?6 F; g% C" z5 i) s1 h( x
  e& B/ C6 e) y5 A1 c4 z
上线送商币
# i9 z0 h: V% {$ r( C- b用查询分析器 必须在 cash6 M" f& d# p; l, I, o  k
, A# a) \$ ^2 l$ f
  1. CREATE TRIGGER [free] ON [dbo].[user_cash] 0 n! k+ g  W: u$ `/ Y7 E
  2. after Insert * |4 O$ O! O$ }, ?* T" G
  3. as # o* N/ x) j" ~, c. O
  4. Update [user_cash] set [user_cash].amount=900000000,free_amount=900000000
    0 j- j' i$ L) [. l) ^
  5. From Inserted 9 P' M% c1 w( C7 N
  6. Where [user_cash].group_id=inserted.group_id # p% a" R4 [0 {
  7. and [user_cash].id=inserted.id
    / q  m7 S8 {. r. Z0 A" [
复制代码
) {. D$ `4 k' x" @6 K/ f% ~4 m4 z
4 S) W+ ^# T1 o* g' X* ]& Y
查询GM号% v4 l) m% H. L
  1. selectcharacter_namefromcharacter.dbo.user_characterwherecharacter_namelike%GM%
复制代码

* o) n: l6 w3 Y1 D6 F  ?, C
( V6 x, `0 z6 J, v; ~# y: `# A9 c) @; @  p

' T" z4 u; x* B, S* e0 h" i# @- ]
您需要登录后才可以回帖 登录 | 立即注册

本版积分规则


Archiver|小黑屋|EGameol

GMT+8, 2026-11-19 10:34 , Processed in 0.063076 second(s), 25 queries .

Powered by Discuz! X3.5

© 2001-2026 Discuz! Team.

快速回复 返回顶部 返回列表