aaphox
02-18-2013, 12:08 AM
Hi, I am wondering if anyone can help me.
I am using the latest version of ibproarcade and for the past while have been using the setting to allow games to store every high score that a user gets.
Due to requests I have now changed to the setting which allows only the highest score a user gets to appear on the high scores.
However I am having trouble finding a way to delete every users additional scores from the high scores to leave only their highest score. Due to my lack of mysql knowledge i have been manually deleting scores via phpmyadmin but this is ridiculously time consuming.
I am looking for help creating a script that will accomplish the following:
To delete all scores that are less than their highest score of each user from the database.
I assume the function should probably be something like this: (although I don't know if it is possible)
DELETE other rows from table 'SCORES' of 'USERID' IF 'USERID' has 'SCORE' value greater than value of 'SCORE'.
Thank you very much in advance, and I hope this is understandable.
I am using the latest version of ibproarcade and for the past while have been using the setting to allow games to store every high score that a user gets.
Due to requests I have now changed to the setting which allows only the highest score a user gets to appear on the high scores.
However I am having trouble finding a way to delete every users additional scores from the high scores to leave only their highest score. Due to my lack of mysql knowledge i have been manually deleting scores via phpmyadmin but this is ridiculously time consuming.
I am looking for help creating a script that will accomplish the following:
To delete all scores that are less than their highest score of each user from the database.
I assume the function should probably be something like this: (although I don't know if it is possible)
DELETE other rows from table 'SCORES' of 'USERID' IF 'USERID' has 'SCORE' value greater than value of 'SCORE'.
Thank you very much in advance, and I hope this is understandable.