Override challenge
Submitted by elsarius on Thu, 06/12/2007 - 11:53
A bit of help would be appreciated...
If a player makes a challenge but doesn't make themselves available to play, and also doesn't cancel the challenge, how can you either:
- cancel the challenge
- erase the match result once their opponent has auto-forfeited (restore ranks and ELO ratings)
Thanks
manualy remove challenge
To do this you need to manually edit your SQL database.This is for an unhosted ladder of course, and version 0.7.9, which does not support ELO rankings but hopefully the method is similar.
First, erase the challenge from the _challenges table (note players ID numbers). Next, clear each player's challenge restriction in the _player table by changing the column 'chall_flag' from 1 to 0. Also, set the 'chall_date' to zero.
To erase the result if it has already posted, erase the entire row in the _results table. To restore the rankings you have to either edit each player manually, or write a simple SQL statement to do it. You need to edit the 'Position" column in the _player table. For ELO, you probably just have to guess what they were before the challenge and enter those values.
This happens way too often! I wish there was an automatic loss of position option for forfeiters.