挑战上线自动送点卡.商城币.和查询GM号SQL执行语句

EGameol

上线送时间
6 ~$ i7 y- r$ H: B用查询分析器 必须在billing执行

1. CREATE TRIGGER [free] ON [dbo].[user_account]
   - {7 g3 c0 X3 e( i1 U1 K4 e
2. after Insert
   
3. as
   7 O; z( l1 J$ t  k% x3 R2 O
4. Update [user_account] set
   
5. [user_account].remain_time =999999,remain_freetime =999999,expire_freetime =2999-1-9
   
6. From Inserted
   1 L( ?( c9 p9 G% g/ L6 Q
7. Where [user_account].user_id=inserted.user_id
   9 T/ J' D6 V! Q' j. P9 n% _
8. and [user_account].group_id=inserted.group_id
   / j+ U+ z6 P+ @& _9 N5 L
9. update  user_account set remain_time =999999,remain_freetime=999999,expire_freetime=2999-1-9
   - T5 ~0 n, N! d; X
10. where expire_freetime =2006-1-9

复制代码

! T: g5 R! V$ x3 N, C! [6 A9 d1 e
8 p$ v6 D# B+ E# ?3 t上线送商币
) j+ \% v* o+ j8 T用查询分析器 必须在 cash
) L6 S# |0 F6 B9 z; D3 U0 T% o
# ]; s; ~' n& {6 |

1. CREATE TRIGGER [free] ON [dbo].[user_cash]
   , u! I9 E6 a; {6 k5 x2 R( p
2. after Insert
   
3. as
   
4. Update [user_cash] set [user_cash].amount=900000000,free_amount=900000000
   
5. From Inserted
   / X' K! |! d8 b, x, t! j
6. Where [user_cash].group_id=inserted.group_id
   8 j; f/ D& e# a# }! d
7. and [user_cash].id=inserted.id
   3 M9 l( f$ w8 E* q5 G! b- A! S8 \

复制代码

+ W% {6 W; v/ }1 U( e0 t  u! h1 ?8 f
2 I4 ?9 g+ H( T! q" T' z* S: k) `, x查询GM号

1. selectcharacter_namefromcharacter.dbo.user_characterwherecharacter_namelike%GM%

复制代码

: E+ B9 K+ P1 g


3 W( K8 d6 Y6 a