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

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

[复制链接]

96

主题

3

回帖

1111

积分

超级版主

积分
1111
金钱
228
贡献
784
注册时间
2023-11-3
发表于 2023-11-5 16:40:44 | 显示全部楼层 |阅读模式
本帖最后由 EGameol 于 2023-11-5 16:41 编辑 7 I: Y7 i2 C! ^6 k1 |

0 U6 u9 L( f, Q; N上线送时间' f/ {& i. p3 Q5 ?2 T1 h
用查询分析器 必须在billing执行/ d8 c5 H1 c5 H' D/ _4 r- o' v( L
  1. CREATE TRIGGER [free] ON [dbo].[user_account]2 ]0 A% ^1 l! q. d
  2. after Insert
    7 q5 D; Y# `" h$ A
  3. as
    1 F0 ~; ?9 _  `) V
  4. Update [user_account] set5 d+ {7 ^9 R8 g' O! |) D$ j1 X7 O
  5. [user_account].remain_time =999999,remain_freetime =999999,expire_freetime =2999-1-9
    ' t! L7 j0 B  s6 n* M& E  L
  6. From Inserted& \2 f# h+ R5 F: {' r
  7. Where [user_account].user_id=inserted.user_id. \, }. G1 y5 f1 J5 a) Z- {
  8. and [user_account].group_id=inserted.group_id" B2 i6 ^+ @6 q, F: G) e- G
  9. update  user_account set remain_time =999999,remain_freetime=999999,expire_freetime=2999-1-9
    - i( W; j& b" c1 @' @6 y; g
  10. where expire_freetime =2006-1-9
复制代码
* q5 Z8 q5 d8 ~3 x
; y) Q; w( A! m$ L) N# ~% }
上线送商币
5 V- Z2 O/ f+ t# R* U  L用查询分析器 必须在 cash4 }0 H% E/ H1 Y8 S7 C3 U

( `( q7 O4 i/ v/ f7 c7 e2 m
  1. CREATE TRIGGER [free] ON [dbo].[user_cash] ! h9 W: k5 A5 l3 l9 U( y# a. q
  2. after Insert % d. y1 X7 D& l8 |3 F
  3. as
    6 L( f5 T2 r: ]1 z4 n
  4. Update [user_cash] set [user_cash].amount=900000000,free_amount=900000000+ }6 B4 {9 R3 ?6 a* M
  5. From Inserted
    & I* \# ?" h* O
  6. Where [user_cash].group_id=inserted.group_id / F" s7 Q* c1 [0 e. n( k' m
  7. and [user_cash].id=inserted.id- e! [0 R7 p9 K+ |3 y. G" X! d
复制代码

4 a  L+ F# Z: z# K( i2 _& E* |8 D9 U
6 D( B! u/ U6 d9 i4 a1 J0 G: ~查询GM号  d. d6 O2 v% s6 O
  1. selectcharacter_namefromcharacter.dbo.user_characterwherecharacter_namelike%GM%
复制代码

6 g/ _& w2 c1 M* X
# G: |6 g8 W1 ~
% ~8 s- S6 z; b6 ^4 O, h( @* N8 n. }  q
您需要登录后才可以回帖 登录 | 立即注册

本版积分规则


Archiver|小黑屋|EGameol

GMT+8, 2025-10-27 00:53 , Processed in 0.047753 second(s), 22 queries .

Powered by Discuz! X3.5

Copyright © 2001-2020, Tencent Cloud.

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