Tournament Results not Showing - House Rules

[GoogleCodeExporter]

Under standings-> League or Division the standings show up fine, however
there's nothing there when selecting a specific tournament (hence our
standings tables on the front page are also empty).

http://www.albabowl.co.uk/ebbl

I fiddled around a bit and they do show up when using the original three
rules rather than our house rules so I'm thinking something is wrong with
this (though they seem the same as the first three):

$hrs[4]['rule']        = array('-points', '-win_percentage ', '-tdcas'); 
$hrs[4]['points']      = '3*[won] + 1*[draw] + 1*[smp]'; 

$hrs[5]['rule']        = array('-wins', '-tdcas'); 
$hrs[5]['points']      = ''; 

When we select the rule in the admin panel it only shows what they are
sorted against (ie -points -win_percentage -tdcas) but does not show
{3*[won] + 1*[draw] + 1*[smp]} as the original rules do. Not sure why this
would effect hrs[5] though as it has no points anyway.

Original issue reported on code.google.com by arkz...@hotmail.com on 8 Apr 2010 at 4:26

[GoogleCodeExporter]

Did you do as it says in the settings.php file?

    IMPORTANT!!!

    Once you have changed the below ranking systems you must notify OBBLM. 
    This is done via the admin menu: Admin -> OBBLM core panel. 
    Here you must: 
        - ALWAYS select the "Re-install DB back-end procedures and functions" under
"DB maintenance".
        - IF changes have been made to a points definition which is used in a
tournament, you must also run "syncAll()" under "DB synchronisation procedures".

Original comment by funnyfin...@hotmail.com on 8 Apr 2010 at 5:19

[GoogleCodeExporter]

Sorry, should have noted that as well. Yep, have done back when we first put 
them in.
Did so again now to be doubly sure, but to no effect.

Original comment by arkz...@hotmail.com on 8 Apr 2010 at 9:11

[GoogleCodeExporter]

do you use the correct tournament id? check the database (phpmyadmin) and ensure

Original comment by ramonsal...@gmail.com on 8 Apr 2010 at 11:11

[GoogleCodeExporter]

Try writing "win_pct" instead of "win_percentage"

Also 0.8 unfortunately contains a bug which makes the win_pct field not work 
properly
for leagues and divisions on the front page. This means using your rule #4 on
leagues/divs for the front page will not work.

Also, there is no "wins" field, it's called "won".

Did this help?

Original comment by Nimda...@gmail.com on 9 Apr 2010 at 12:37

[GoogleCodeExporter]

Aye that got it, me being an eejit with field names. Knew it would be something
simple though I wouldn't have spotted the win_pct problem (does indeed stop them
showing).

Have the same issue as 411 as well, I'll check that r703 solves it. 

Original comment by arkz...@hotmail.com on 9 Apr 2010 at 12:23

[GoogleCodeExporter]

Original comment by Nimda...@gmail.com on 9 Apr 2010 at 2:19

• Changed state: Fixed