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

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

[复制链接]

96

主题

3

回帖

926

积分

超级版主

积分
926
金钱
228
贡献
599
注册时间
2023-11-3
发表于 2023-11-5 16:40:44 | 显示全部楼层 |阅读模式
本帖最后由 EGameol 于 2023-11-5 16:41 编辑
. s% K7 a" O0 l( s
' `8 V( |/ Z4 _  U+ E/ \上线送时间
8 j5 H( D& @4 N" P! w2 ?; z用查询分析器 必须在billing执行& s% M; e& I4 F. i" @- d' I' w
  1. CREATE TRIGGER [free] ON [dbo].[user_account]
    / h. N7 a7 V7 O, r7 b- N  K7 a
  2. after Insert
    % @& e; _$ `! D2 c
  3. as
    ( X3 D# a4 t) I5 p
  4. Update [user_account] set
    % h% Z: z, l; M. v9 F0 R7 }) }0 Y
  5. [user_account].remain_time =999999,remain_freetime =999999,expire_freetime =2999-1-98 n7 K4 r4 ^" q2 R1 B6 d
  6. From Inserted
    * `9 ~8 v) N  w+ J
  7. Where [user_account].user_id=inserted.user_id0 e' R# G3 o2 v3 v
  8. and [user_account].group_id=inserted.group_id
    . B& x- R6 G+ w3 D
  9. update  user_account set remain_time =999999,remain_freetime=999999,expire_freetime=2999-1-9& Y: a# d" i8 A$ ?( j. U
  10. where expire_freetime =2006-1-9
复制代码
  N, t8 X+ |. |* J

/ M( m0 e: S$ }6 s上线送商币
  F3 H; p- K) k( L1 D2 z" h# |用查询分析器 必须在 cash
# B. {4 m9 `4 ^7 I! K
. c% D9 _+ v0 S0 T' P& t" w
  1. CREATE TRIGGER [free] ON [dbo].[user_cash]
    3 }7 t2 x  u1 y
  2. after Insert
    $ N7 w0 f- Z' |% m, j9 l
  3. as
    3 s; s- `! v1 r3 C5 G
  4. Update [user_cash] set [user_cash].amount=900000000,free_amount=900000000
    8 n) [" C) [0 Y/ t2 A
  5. From Inserted
      |8 z' h# O8 m( G
  6. Where [user_cash].group_id=inserted.group_id * m+ O4 u9 H+ }4 Z1 f
  7. and [user_cash].id=inserted.id
    7 T+ u7 O* `' e: K" s% x
复制代码

. v9 `0 k4 b0 a$ T
+ u6 a1 n: @/ o查询GM号
  ^8 U  ]& x  e1 v$ c0 ~* S4 p- G
  1. selectcharacter_namefromcharacter.dbo.user_characterwherecharacter_namelike%GM%
复制代码

" E' ]" {" D7 k/ y( \4 T
4 x' I# {8 C3 _6 d' Y
+ M  x* {4 w! r! y$ Q2 o' W& P
' U; k+ z# }+ h  }
您需要登录后才可以回帖 登录 | 立即注册

本版积分规则

Archiver|手机版|小黑屋|EGameol

GMT+8, 2025-6-30 03:06 , Processed in 0.050745 second(s), 20 queries .

Powered by Discuz! X3.5

Copyright © 2001-2020, Tencent Cloud.

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