Topic: Points Updated

Author: Nelson Original Message Posted: Feb 7 2009 12:02PM

Single points from last night are now updated. Congratulations to Shane who is now ranked Master.

And for future reference, Ali is an amateur, not rookie.


Author: Tongue180 Reply #1 Posted: Feb 7 2009 1:06PM

Congrats Shane. Seems to be a weird bug with the points though.

If you look here, Shane should be at 2398.

http://www.vancouverfoosball.net/s_t_results.asp?iid=357

If you look at his singles history it shows 2368 because it misorders the 2 final matches played.
http://www.vancouverfoosball.net/singles_history.asp?id=33


Author: Aged Whine & Cheese Reply #2 Posted: Feb 7 2009 9:57PM

I put Ali at Rookie because there is no way he should have gone Amateur in the 4 tournaments he has played. That sounds like an arbitrary points reset way back when he first came out and those arbitrary resets without discussion are BS, in my opinion.
Tim


Author: KidLightning Reply #3 Posted: Feb 8 2009 3:43AM

You're correct Jeff, there is a problem with the system, I know where the problems lies, when I run the query manually there is 5 instances of my scores for the tournament date, and one of them is correct which is 2398 but the query uses the function
Last(points_after) field which apparently is 2368. I need to talk to Skye to fix this problem. Everyone is affected by this. What we are missing is a field that distinguishes the most current record.

Example:

field 1 = Player ID
field 2 = point after calculation
field 3 = points accumulated of deducted
field 4 = players name
field 5 = rank
field 6 = rank title


33 2331 24 Chow, Shane 5 Pro
33 2368 -32 Chow, Shane 6 Master
33 2378 47 Chow, Shane 5 Pro
33 2398 30 Chow, Shane 6 Master
33 2400 28 Chow, Shane 6 Master

The 4th line should be shown, instead the 2nd line is shown.

Any Ideas Skye.



Author: The Next One. Reply #4 Posted: Feb 8 2009 7:05PM

I told ya Kid Lightning that you'd go master that night. What's up Nelson? i said that you should win on friday way to unfufill my predictions.

The points system caps off at 2400, kinda like when I had to manually edit Tims points. After you manually edit the points past 2400 it seems to work ok.


This thread does not accept replies because:

The last post to this thread is more than 30 days old.