Scores Page error

[The Fugitive]

When you try to get your squads ranking from this page http://bbs.hitechcreations.com/scores/mysqdrank.php you get this error....

Invalid query: Table 'AH2Data.Squads' doesn't exist

It does work off the main page "Scores and Ranks", however when you try to open the "kills" page you get a 404 error.

[Pand]

It also appears the (I believe twice daily) cronjob that recalculates ranks is also not executing.

[Skuzzy]

The old BBS score pages have not been supported since the pages were moved to the WEB page.

The ranker runs once a day and is running, but if you use the BBS score pages, there is a good chance you will not see any change.

I probably should go ahead and take those old pages down.

[Pand]

The old pages have worked as long as I have been querying them--- the first time something has broken was Friday the 12th (fugitive's post)... please don't take them away!  

[Skuzzy]

The old pages have worked as long as I have been querying them--- the first time something has broken was Friday the 12th (fugitive's post)... please don't take them away!  

They broke due to the move of the Late War arena to another ISP.  The old pages have not had any support for over a year.  They just happened to work.

Why is that a problem?

[Pand]

I use scripts to pull and parse the scoring for our squadron that executes daily, I'll show you last months final here: http://www.horizonx.org/tourstats/Pand,EZRhino_LWTour152.html

I'll have to re-write to pull from the new pages--- which I can do, not a huge issue but will take some time.   Do the new pages allow passing of variables in the url... example below... my script would pass  $squadco as Pand and $tour as LWTour153.   This would be my initial pull to list and parse all members of the squadron.

http://bbs.hitechcreations.com/newscores/sqdscore.php?action=1&Submit=Get+Ranks&playername=$squadco&selectTour=$tour

Thanks for the info!

[Pand]

Ok, I am looking to migrate to the new scoring pages, but need help with a few items if you have time...

Assuming this is the main url for scoring now:   http://www.hitechcreations.com/component/option,com_ahscore/Itemid,223/view,pilotranks/index.php

Questions:
1.  Can you tell me the direct url I would use (with in-line php variables) to display the list of all members in squadron Pand during LWTour153.

2.  Can you tell me the direct url I would use (with in-line php variables) to display the scoring of pilot Pand during LWTour153.

Observations:
1.  When pulling the score of a pilot on the above url, the 'kills' link at the bottom still points to the bbs scoring page.  Will that change also? 
http://bbs.hitechcreations.com/newscores/killstat.php?selectTour=LWTour153&player=Pand&kt=57.   

2.  You had mentioned earlier the job to recalculate scoring is running, but I'm still showing my same fighter rank of "2636" which is showing the same before I flew at all for this tour back on Friday.

[The Fugitive]

Skuzzy, it doesn't look like the scores have updated all weekend, and the squad "kills" page still sends you to a 404 error page.

[Lusche]

Yup, my individual rank numbers haven't changed as well, and I found players with rank 0 but with many hours of playtime.

[Skuzzy]

Yup, my individual rank numbers haven't changed as well, and I found players with rank 0 but with many hours of playtime.

There was a bug in the ranker utilities preventing it from completing.  Fixed and you should see the results in the next hour, or so.

[tunnelrat]

Skuzzy, we used to be able to pull stats programmatically from the old page... but we're having trouble doing so from the new page.

What we'd like to do is basically be able to retrieve stats with a direct URL, such as:

http://www.hitechcreations.com/component/option,com_ahscore/Itemid,223/view,pilotranks/index.php?pilot=blah,tour=blahblah

Or something of that nature... 

Right now, it appears to be limited to javascript:('pilot', 'tour') for postPilotScore.js and postPilotRank.js

We use the information to calculate milestones squad awards such as accuracy, K/D ratio, kills by type, etc...

If you can help, I will send you a Hannah Montana poster or beer, your choice.

[tunnelrat]

There was a bug in the ranker utilities preventing it from completing.  Fixed and you should see the results in the next hour, or so.

Whatever you did fixed the Invalid query: Table 'AH2Data.Squads' doesn't exist error too!!!

[Skuzzy]

Whatever you did fixed the Invalid query: Table 'AH2Data.Squads' doesn't exist error too!!!

(Image removed from quote.)

I just got through fixing it......I think.

[Pand]

All my scripts are working properly via my previous method... thanks Skuzzy! 

[Skuzzy]

Ok, fixed.

Back to putting some more scripts together to facilitate this.  Never ending process.