pedro chaves Posted February 12, 2019 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
1 AnnieRuru Posted February 13, 2019 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
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)+";
Edited by pedro chaves1 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.