Register Members List Search Today's Posts Mark Forums Read

Reply
 
Thread Tools
  #1  
Old 18 Feb 2013, 19:08
aaphox aaphox is offline
 
Join Date: Oct 2006
ibProArcade MySQL script request

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.
Reply With Quote
Reply



Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Forum Jump


New To Site? Need Help?

All times are GMT. The time now is 10:54.

Layout Options | Width: Wide Color: