Author Topic: Scores Page error  (Read 744 times)

Offline The Fugitive

  • Plutonium Member
  • *******
  • Posts: 18264
      • Fugi's Aces Help
Scores Page error
« 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.

Offline Pand

  • Silver Member
  • ****
  • Posts: 901
      • Pand's Fighter Wing
Re: Scores Page error
« Reply #1 on: October 14, 2012, 10:57:45 AM »
It also appears the (I believe twice daily) cronjob that recalculates ranks is also not executing.

Regards,

Pandemonium
"HORDE not HOARD. Unless someone has a dragon sitting on top of a bunch of La7s somewhere." -80hd

Offline Skuzzy

  • Support Member
  • Administrator
  • *****
  • Posts: 31462
      • HiTech Creations Home Page
Re: Scores Page error
« Reply #2 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.
Roy "Skuzzy" Neese
support@hitechcreations.com

Offline Pand

  • Silver Member
  • ****
  • Posts: 901
      • Pand's Fighter Wing
Re: Scores Page error
« Reply #3 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!  
« Last Edit: October 15, 2012, 08:17:30 AM by Pand »

Regards,

Pandemonium
"HORDE not HOARD. Unless someone has a dragon sitting on top of a bunch of La7s somewhere." -80hd

Offline Skuzzy

  • Support Member
  • Administrator
  • *****
  • Posts: 31462
      • HiTech Creations Home Page
Re: Scores Page error
« Reply #4 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?
Roy "Skuzzy" Neese
support@hitechcreations.com

Offline Pand

  • Silver Member
  • ****
  • Posts: 901
      • Pand's Fighter Wing
Re: Scores Page error
« Reply #5 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!

Regards,

Pandemonium
"HORDE not HOARD. Unless someone has a dragon sitting on top of a bunch of La7s somewhere." -80hd

Offline Pand

  • Silver Member
  • ****
  • Posts: 901
      • Pand's Fighter Wing
Re: Scores Page error
« Reply #6 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.

Regards,

Pandemonium
"HORDE not HOARD. Unless someone has a dragon sitting on top of a bunch of La7s somewhere." -80hd

Offline The Fugitive

  • Plutonium Member
  • *******
  • Posts: 18264
      • Fugi's Aces Help
Re: Scores Page error
« Reply #7 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.

Offline Lusche

  • Radioactive Member
  • *******
  • Posts: 23939
      • Last.FM Profile
Re: Scores Page error
« Reply #8 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.
Steam: DrKalv
E:D Snailman

In November 2025, Lusche will return for a 20th anniversary tour. Get your tickets now!

Offline Skuzzy

  • Support Member
  • Administrator
  • *****
  • Posts: 31462
      • HiTech Creations Home Page
Re: Scores Page error
« Reply #9 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.
Roy "Skuzzy" Neese
support@hitechcreations.com

Offline tunnelrat

  • Silver Member
  • ****
  • Posts: 1739
Re: Scores Page error
« Reply #10 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.
In-Game: 80hd
The Spartans do not enquire how many the enemy are but where they are.

Offline tunnelrat

  • Silver Member
  • ****
  • Posts: 1739
Re: Scores Page error
« Reply #11 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!!!

In-Game: 80hd
The Spartans do not enquire how many the enemy are but where they are.

Offline Skuzzy

  • Support Member
  • Administrator
  • *****
  • Posts: 31462
      • HiTech Creations Home Page
Re: Scores Page error
« Reply #12 on: October 15, 2012, 01:53:27 PM »
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.
Roy "Skuzzy" Neese
support@hitechcreations.com

Offline Pand

  • Silver Member
  • ****
  • Posts: 901
      • Pand's Fighter Wing
Re: Scores Page error
« Reply #13 on: October 15, 2012, 03:50:16 PM »
All my scripts are working properly via my previous method... thanks Skuzzy!  :salute

Regards,

Pandemonium
"HORDE not HOARD. Unless someone has a dragon sitting on top of a bunch of La7s somewhere." -80hd

Offline Skuzzy

  • Support Member
  • Administrator
  • *****
  • Posts: 31462
      • HiTech Creations Home Page
Re: Scores Page error
« Reply #14 on: March 04, 2013, 01:56:19 PM »
Ok, fixed.

Back to putting some more scripts together to facilitate this.  Never ending process.
Roy "Skuzzy" Neese
support@hitechcreations.com