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

EGameol

& ~: u7 F6 g) ]  L/ H% B
& l  P. F. k  j( s: D9 g. Y5 i上线送时间
9 V. Q$ t; ?0 E用查询分析器 必须在billing执行
: Q( ?4 i7 o; G0 A

1. CREATE TRIGGER [free] ON [dbo].[user_account]
   
2. after Insert
   ( j; ]# n# O, v2 k' }
3. as
   % y" T; B- _/ G+ z/ q
4. Update [user_account] set
   
5. [user_account].remain_time =999999,remain_freetime =999999,expire_freetime =2999-1-9
   7 H1 y2 |1 i! L( M' G
6. From Inserted
   
7. Where [user_account].user_id=inserted.user_id
   ) y" ?" x* T$ s7 A
8. and [user_account].group_id=inserted.group_id
   ' N1 \$ M3 g& R( v. e9 B, B
9. update  user_account set remain_time =999999,remain_freetime=999999,expire_freetime=2999-1-9
   
10. where expire_freetime =2006-1-9

复制代码

: x$ n/ Y: A  U
上线送商币
用查询分析器 必须在 cash

1. CREATE TRIGGER [free] ON [dbo].[user_cash]
   1 N/ s; b1 u/ ~9 a1 \, B
2. after Insert
   
3. as
   
4. Update [user_cash] set [user_cash].amount=900000000,free_amount=900000000
   0 t# a; ~8 s; Z% y. h' w2 e& B
5. From Inserted
   ' m( A( T9 R9 |2 Q& j6 m' c' ~
6. Where [user_cash].group_id=inserted.group_id
   4 g2 X" Q7 a. M7 l
7. and [user_cash].id=inserted.id
   " x' s( C4 _4 e

复制代码

查询GM号
& g) x/ y$ K& ^& ?  X- L

1. selectcharacter_namefromcharacter.dbo.user_characterwherecharacter_namelike%GM%

复制代码

, |4 @7 q& [8 J2 p9 S( W5 O