Aces High Bulletin Board

Help and Support Forums => Technical Support => Topic started by: The Fugitive on October 14, 2012, 09:32:15 AM

Title: Scores Page error
Post by: The Fugitive on October 14, 2012, 09:32:15 AM
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.
Title: Re: Scores Page error
Post by: Pand on October 14, 2012, 10:57:45 AM
It also appears the (I believe twice daily) cronjob that recalculates ranks is also not executing.
Title: Re: Scores Page error
Post by: Skuzzy on October 15, 2012, 06:19:20 AM
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.
Title: Re: Scores Page error
Post by: Pand on October 15, 2012, 08:01:17 AM
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!  
Title: Re: Scores Page error
Post by: Skuzzy on October 15, 2012, 08:49:34 AM
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?
Title: Re: Scores Page error
Post by: Pand on October 15, 2012, 09:30:42 AM
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!
Title: Re: Scores Page error
Post by: Pand on October 15, 2012, 10:21:49 AM
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.
Title: Re: Scores Page error
Post by: The Fugitive on October 15, 2012, 12:22:21 PM
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.
Title: Re: Scores Page error
Post by: Lusche on October 15, 2012, 12:31:36 PM
Yup, my individual rank numbers haven't changed as well, and I found players with rank 0 but with many hours of playtime.
Title: Re: Scores Page error
Post by: Skuzzy on October 15, 2012, 01:01:33 PM
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.
Title: Re: Scores Page error
Post by: tunnelrat on October 15, 2012, 01:28:47 PM
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.
Title: Re: Scores Page error
Post by: tunnelrat on October 15, 2012, 01:35:51 PM
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!!!

(http://1.bp.blogspot.com/-x_hDAzBLND4/UGkZtPhF95I/AAAAAAAAAeU/EwzjGe-pq30/s1600/awkward-hug11.jpg)
Title: Re: Scores Page error
Post by: Skuzzy on October 15, 2012, 01:53:27 PM
Whatever you did fixed the Invalid query: Table 'AH2Data.Squads' doesn't exist error too!!!

(http://1.bp.blogspot.com/-x_hDAzBLND4/UGkZtPhF95I/AAAAAAAAAeU/EwzjGe-pq30/s1600/awkward-hug11.jpg)

I just got through fixing it......I think.
Title: Re: Scores Page error
Post by: Pand on October 15, 2012, 03:50:16 PM
All my scripts are working properly via my previous method... thanks Skuzzy!  :salute
Title: Re: Scores Page error
Post by: Skuzzy on March 04, 2013, 01:56:19 PM
Ok, fixed.

Back to putting some more scripts together to facilitate this.  Never ending process.
Title: Re: Scores Page error
Post by: tunnelrat on March 04, 2013, 01:57:11 PM
Ok, fixed.

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

(http://1.bp.blogspot.com/-x_hDAzBLND4/UGkZtPhF95I/AAAAAAAAAeU/EwzjGe-pq30/s1600/awkward-hug11.jpg)
Title: Re: Scores Page error
Post by: Pand on March 04, 2013, 01:57:41 PM
Ok, fixed.

Back to putting some more scripts together to facilitate this.  Never ending process.
Now that's a quick turnaround!  :salute