Jump to content
  • 0
Sign in to follow this  
mrlongshen

How to delete all cashpoints?

Question

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 by mrlongshen

Share this post


Link to post
Share on other sites

9 answers to this question

Recommended Posts

  • 0

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?

Share this post


Link to post
Share on other sites
  • 0

@@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 by mrlongshen

Share this post


Link to post
Share on other sites
  • 0

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

Share this post


Link to post
Share on other sites
  • 0

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 by Winterfox

Share this post


Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Answer this question...

×   Pasted as rich text.   Restore formatting

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Loading...
Sign in to follow this  

×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.