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

EGameol

- {( D0 n; w3 W: g; [& A( H8 a; y上线送时间
用查询分析器 必须在billing执行

1. CREATE TRIGGER [free] ON [dbo].[user_account]
   
2. after Insert
   
3. as
   
4. Update [user_account] set
   
5. [user_account].remain_time =999999,remain_freetime =999999,expire_freetime =2999-1-9
   ( s6 z3 I* u9 J* B3 P+ f6 {6 E
6. From Inserted
   
7. Where [user_account].user_id=inserted.user_id
   
8. and [user_account].group_id=inserted.group_id
   5 p" C6 d1 J; q  m+ w9 y
9. update  user_account set remain_time =999999,remain_freetime=999999,expire_freetime=2999-1-9
   7 E) f. @7 n% d1 ~' A, m3 q  x
10. where expire_freetime =2006-1-9

复制代码

: Z- r$ w6 }1 j: Z
6 f4 }* s, I3 ~1 S上线送商币
- R. P4 Q/ q* ]0 N9 W: \' \用查询分析器 必须在 cash

- i" K& ?3 @" v* V

1. CREATE TRIGGER [free] ON [dbo].[user_cash]
   9 H% h9 d0 C+ j: @* }
2. after Insert
   
3. as
   
4. Update [user_cash] set [user_cash].amount=900000000,free_amount=900000000
   
5. From Inserted
   2 W% P, \5 k) r9 ^! q8 T
6. Where [user_cash].group_id=inserted.group_id
   
7. and [user_cash].id=inserted.id
   2 }& o( ]6 N4 T$ n' h8 w5 e& `$ m! ]

复制代码

& O1 v0 P1 l; W/ i4 }
查询GM号
7 z  [. l7 A8 ~1 L9 S, v. Y

1. selectcharacter_namefromcharacter.dbo.user_characterwherecharacter_namelike%GM%

复制代码

& C  v. f& t. o2 I
9 n4 w( S9 ~8 E/ ~& E9 R4 f8 }/ N
$ t6 d( G# p( L- |; l
: g( s, F0 r9 {& b( X7 `. Q