Jump to content
  • 0

SQL PVP Suport (please)


pedro chaves

Question


  • Group:  Members
  • Topic Count:  7
  • Topics Per Day:  0.00
  • Content Count:  15
  • Reputation:   0
  • Joined:  06/20/18
  • Last Seen:  

I will make a PVP Ranking, and my cp read it from table.

How i can command for in game, save my sql infs on my table? i try it but he duplicate, and triplicate... please help me

 

The script is like it, but the string is  "+FAMEPOINTS+" "+KARMAPOINTS+" 

 

query_sql("REPLACE INTO `pvpm_data` (`charid`, `name`, `kills`, `dies`, `karma`) VALUES ("+getcharid(0)+","+strcharinfo(0)+", "+FAMEPOINTS+","+REBORNPOINTS+","+KARMAPOINTS+") WHERE charid == "+getcharid(0)+";

 

Edited by pedro chaves
Link to comment
Share on other sites

1 answer to this question

Recommended Posts

  • 1

  • Group:  Members
  • Topic Count:  18
  • Topics Per Day:  0.00
  • Content Count:  2044
  • Reputation:   682
  • Joined:  10/09/12
  • Last Seen:  

hmm ... looking back at this script, I forgot to index the point(11) field

 

although my current method has evolved to a little bit more complex ..
https://annieruru.blogspot.com/2019/01/another-approach-to-write-pvp-ladder.html
use method 1, which most people does

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...