Jump to content
  • 0

How can I reset all the Stats of players using SQL?


Yummy

Question


  • Group:  Members
  • Topic Count:  38
  • Topics Per Day:  0.01
  • Content Count:  236
  • Reputation:   12
  • Joined:  03/07/12
  • Last Seen:  

Its urgent.

Link to comment
Share on other sites

3 answers to this question

Recommended Posts


  • Group:  Members
  • Topic Count:  9
  • Topics Per Day:  0.00
  • Content Count:  268
  • Reputation:   27
  • Joined:  12/06/11
  • Last Seen:  

On your ragnarok database find the "char" table in there you find all the details related to the character.

Link to comment
Share on other sites


  • Group:  Forum Moderator
  • Topic Count:  93
  • Topics Per Day:  0.02
  • Content Count:  10015
  • Reputation:   2348
  • Joined:  10/28/11
  • Last Seen:  

@kaito

erm...i think the topic starter already know which sql table to edit...just dunno how to write the SQL script to run.

@Remix..

try this

UPDATE `char` SET str=1,agi=1,vit=1,int=1,dex=1,luk=1,status_point=1000

status_point .. edit this value to what value of status point they should have upon reset...

anyway...you still can remove it as it might give wrong status point to certain player with low level and etc...

and make sure you run this while your server is offline

Link to comment
Share on other sites


  • Group:  Members
  • Topic Count:  9
  • Topics Per Day:  0.00
  • Content Count:  268
  • Reputation:   27
  • Joined:  12/06/11
  • Last Seen:  

Sorry. My bad didn't understand the topic :)

Link to comment
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.   Paste as plain text instead

  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.

×
×
  • Create New...