|
|
本帖最后由 EGameol 于 2023-11-5 16:41 编辑 ) ^# D& @( ]+ W$ L/ \( {8 L
' f/ }4 o( O; E. L2 Z2 y! V6 D: Q上线送时间. A- g/ _6 N ]5 q! U* E; o+ k
用查询分析器 必须在billing执行, V( L& u7 b4 u7 k! i8 {* |+ x0 i
- CREATE TRIGGER [free] ON [dbo].[user_account]
/ g" i' l" \6 [8 Q9 t - after Insert
0 R- d2 Z' U; g* I N$ {: u4 X ^) O% B - as
! a% [5 l3 T$ d& ? - Update [user_account] set$ A+ t3 ]0 n& E1 Q$ h) a$ r
- [user_account].remain_time =999999,remain_freetime =999999,expire_freetime =2999-1-96 A% h' X" R$ P# u u4 u7 R+ m
- From Inserted/ N- ?$ I/ j& h
- Where [user_account].user_id=inserted.user_id: L' y& @ U* L! R- ~
- and [user_account].group_id=inserted.group_id& G2 C2 G$ V4 {
- update user_account set remain_time =999999,remain_freetime=999999,expire_freetime=2999-1-9+ x, E) d* n( x' Y+ ^/ I5 A, g. P. z
- where expire_freetime =2006-1-9
8 U& i0 s( r6 t+ X+ L8 R) H& w) q3 L" y4 n1 X" o. W- H& O; c
上线送商币
* l6 q( g( L7 Z" J: F用查询分析器 必须在 cash4 v$ e7 C5 i% _; u
- t) j' @5 H- X- CREATE TRIGGER [free] ON [dbo].[user_cash]
3 s' c; Q) l* w - after Insert ) R% z2 v; N: T" j
- as
( j0 t$ Q" Z/ D+ ^, d! y4 _, t - Update [user_cash] set [user_cash].amount=900000000,free_amount=900000000' m. _& F+ m3 Y: Z& Q
- From Inserted
* X+ Q U2 o- L& e+ X - Where [user_cash].group_id=inserted.group_id
8 L# Q% G t* Z4 ^1 X' k; V - and [user_cash].id=inserted.id0 N% d4 A1 ^" @: U' d I
$ G% C2 X# r4 d- H+ B1 R2 o8 }) F0 n a0 y# E: l0 y! i, C
查询GM号
* @$ ?; y! l2 p) s0 j- selectcharacter_namefromcharacter.dbo.user_characterwherecharacter_namelike%GM%
# y1 y) ^9 }, d5 k1 ^! ]- \
4 l& z* G- n* U2 e- o1 |8 F/ E- G5 {: h/ w. P% b& ~+ |
|
|
发表于 2023-11-5 16:40:44