How to delete all cashpoints?

[mrlongshen]

Can someone post any method how to delete cashpoint using sql or script?

By the way, how to check player cashpoint in sql database? 

 

[Winterfox]

@@mrlongshen

#CASHPOINTS = 0;

 

[Aeromesi]

Here's a script @@mrlongshen.
 

- script CashReset -1,{OnPCLoginEvent: if( !#CashReset ) { #CASHPOINTS = 0;#CashReset++;} elseend;}


That way when they login the next time Cash Points will be 0'd out.

I'm curious what happened? Some abuse of Cash Point script?

 

[mrlongshen]

@@Winterfox thanks alot

@@Aeromesi Thanks bro ! hehe.

There are some player have many cash. About 10k above. its all my fault actually. haha

I use some script from @@Winterfox, mvp and pvp reward that get a cash point haha. So the problem is there are player have imba cashpoint hehe. I need to reset back. I know they will angry, but I have give them some special item. hehe 

.

By the way how to check player cashpoint or kafrapoint ? 

 

[Aeromesi]

Go into your SQL Database and check the login table, since CASHPOINTS are account bound it wouldn't be in the char table.

 

[mrlongshen]

@@Aeromesi there are no such table for cash point..

 

[Winterfox]

Here's a script @@mrlongshen.

- script CashReset -1,{OnPCLoginEvent: if( !#CashReset ) { #CASHPOINTS = 0;#CashReset++;} elseend;}


That way when they login the next time Cash Points will be 0'd out.

I'm curious what happened? Some abuse of Cash Point script?

You could make that a bit better like that:

- script CashReset -1,{ OnPCLoginEvent: if( #CashReset ) end; #CASHPOINTS = 0; #CashReset = 1;}

@@Aeromesi there are no such table for cash point..

The table you are searching for is acc_reg_num_db where account_id is the account of the user of course, key is #CASHPOINTS and value is the current amount of cashpoints the user has. If there is no entry for a specific user that means he has 0.

The same applies to kafra points you just have to switch the key to #KAFRAPOINTS.

Instead of a script you also could use this sql query to delete all cashpoints:

DELETE FROM acc_reg_num_db WHERE key = "#CASHPOINTS"

 

[mrlongshen]

@@Winterfox thanks for that information.

+1 for you 

 

[Aeromesi]

Always out-witting me @@Winterfox

 

[Winterfox]

Always out-witting me @@Winterfox

Don't worry others do that to me too. But i think that is good it shows that noone is an island and there is allways space to improve.