|
COINS
go to your database
make new job
give it a name
go to steps
add new step
step name: give coins
type: Transact-SQL script (T-SQL)
run as: keep it empty
database: cash
command: UPDATE user_cash SET free_amount=100000
press "ok"
add new step again
step name: wait
type: Transact-SQL script (T-SQL)
run as: keep it empty
database: cash
command: WAITFOR DELAY '000:00:02';
press advanced set,
On success action: Go to step: [1]
On failure action: Go to step: [1]
Now go back to your step 1 and pres "edit"
press advanced
On success action: Go to step: [2]
On failure action: Go to step: [2]
and run the script
Now all players will get 100.000 coins every 2 seconds
|