pedro chaves Posted February 12, 2019 Group: Members Topic Count: 7 Topics Per Day: 0.00 Content Count: 15 Reputation: 0 Joined: 06/20/18 Last Seen: March 10, 2019 Share Posted February 12, 2019 (edited) 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 February 12, 2019 by pedro chaves Quote Link to comment Share on other sites More sharing options...
1 AnnieRuru Posted February 13, 2019 Group: Members Topic Count: 18 Topics Per Day: 0.00 Content Count: 2044 Reputation: 682 Joined: 10/09/12 Last Seen: December 20, 2020 Share Posted February 13, 2019 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 Quote Link to comment Share on other sites More sharing options...
Question
pedro chaves
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)+";
Link to comment
Share on other sites
1 answer to this question
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.