How to delete all cashpoints?

[mrlongshen 22]

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

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

Edited November 11, 2015 by mrlongshen

[Winterfox 83]

@@mrlongshen

#CASHPOINTS = 0;

[Aeromesi 180]

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 22]

@@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 ? 

Edited November 11, 2015 by mrlongshen

[Aeromesi 180]

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

[mrlongshen 22]

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

[Winterfox 83]

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"

Edited November 11, 2015 by Winterfox

[mrlongshen 22]

@@Winterfox thanks for that information.

+1 for you 

[Aeromesi 180]

Always out-witting me @@Winterfox

[Winterfox 83]

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.