[HELP] Coins automatic

[DXtrmeHack]

Can any1 help how to send coins automatic?
I mean when someone created a character. they have coins automatically.

Where to edit at database. pls help

Thank you

[guesswho-.-]

add a sql job that updates the user_cash table

[DXtrmeHack]

Originally Posted by guesswho-.-

add a sql job that updates the user_cash table

Do you got any of sql that updates its user_cash?

thank you

[guesswho-.-]

just write it yourself, I never needed that. if you want to give it only one time then there are multiple options to do it
one is to add a column in the table and make the default value 0, then when you update the record with a value, change that column to 1.
make the job update entries with the value == 0

[DXtrmeHack]

its really complicated.
sir can you help me step by step?

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:
Code:
UPDATE user_cash SET free_amount=100000press "ok"

add new step again

step name: wait
type: Transact-SQL script (T-SQL)
run as: keep it empty
database: cash
command:
Code:
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
__________________

Is steps working? any1 knew?

[baica123]

you can do this









Have fun!!!

[DXtrmeHack]

Originally Posted by guesswho-.-

add a sql job that updates the user_cash table

Originally Posted by baica123

you can do this









Have fun!!!

Thank you bro.

[WendX]

Hello! guys, how i enable coins automatic to all characters online? example:
10 players online. this players received 10 coins per hour (60min). 100 coins = 10 hours

[guesswho-.-]

Select all the accounts that are online (login_flag <> 0), make a cursor and fetch all the rows and update the user cash based on their user number

[WendX]

thanks for the answer.
but i dont know how i see players online. you can teach me what process need to enable players online php?

[guesswho-.-]

I dont know php but the sql query for players online would be something like this

select count(*) from USER_PROFILE where login_flag <> 0

[freez00]

Originally Posted by guesswho-.-

I dont know php but the sql query for players online would be something like this

select count(*) from USER_PROFILE where login_flag <> 0

Don't forget the database name:
select count(*) from dbo.ACCOUNT.USER_PROFILE where login_flag <> 0

You can also use != instead of <> if you prefer.