SQL Query for eCoins/wCoins

[CAPITOL]

Anyone wanna share a script which can insert eCoins/wCoins for all online players?

[MentaL]

[Erickson Camejo]

what you meant? procedure for give WC/GP for X online time? or just you will add coint to all account in your DB?

[CAPITOL]

Just a simple query to give Coins for all accounts online

[KarLi]

So it has to be only for players who are 'currently in the server playing?"

[CAPITOL]

So it has to be only for players who are 'currently in the server playing?"

Yes, just wanted to reward players who is online when inserted

[KarLi]

I tried to make query example but some things dont work..
so it should be something like


Update MEMB_CREDITS memb___id IF ConnectStat = 1 FROM MEMB_STAT Set credits = credits + 100

but honestly you should do it manually on memb_credits just by checking who's online at MEMB_STAT its faster than figuring out the query

[Erickson Camejo]

I tried to make query example but some things dont work..
so it should be something like


Update MEMB_CREDITS memb___id IF ConnectStat = 1 FROM MEMB_STAT Set credits = credits + 100

but honestly you should do it manually on memb_credits just by checking who's online at MEMB_STAT its faster than figuring out the query

ive tryin too and noting happened XD, i remember some procedure for give automaticaly X credtis per x time you want.