PSP DoubleCheck anomaly

[bzm]

Hi,

A small issue with PSP DoubleCheck (proj=psp_d):

On my Usermain page (http://stats.free-dc.org/stats.php?p...rmain&name=bzm), I show up as number 10 overall.
On the Project Stats page (http://stats.free-dc.org/stats.php?page=proj&proj=psp_d), I am not in the top 10, and both "Joe_O" and "Joe O" are listed.
On the Users Stats page (http://stats.free-dc.org/stats.php?p...ers&proj=psp_d), I am number 10, and only "Joe_O" is listed.

I think me at number 11 and two Joes is correct
My first guess was an SQL "like" query where "_" is a wildcard character, but not sure that makes sense in this case.

Thanks!
bzm

[Bok]

Nah, it's just a name change. The 'Joe O' is a separate user in the database but it's marked for deletion, which I've now done. These 'marked for deletion' users are not considered whilst doing the rankings at all. The users page actually filters those out for display purposes but I've never gotten around to doing that elsewhere. I think it might be safe enough to run an automatic purge a some point soon actually. Code is all in there, just commented out.