Author Topic: Any PHP / Mysql people on here?  (Read 6370 times)

jason

  • LANSE Admin
  • LANSE Elder
  • *****
  • Posts: 7304
    • http://www.lanse.co.uk
Any PHP / Mysql people on here?
« Reply #15 on: July 25, 2006, 02:40:08 PM »
there isn't

it's worked out by the hack at the top of the stats.php
i5-2500k
Asus P8P67
2x 4gb DDR3 1600 hz OCZ
1 x Dell Perc 6/i
4 x Samsung 2TB (raid 5)
1 x WD VelociRaptor WD3000HLFS
Asus 5870 1gb PCI-E

Trogwar

  • Guest
Any PHP / Mysql people on here?
« Reply #16 on: July 25, 2006, 03:37:43 PM »
Updated "stats.html" for wow_style:

jason

  • LANSE Admin
  • LANSE Elder
  • *****
  • Posts: 7304
    • http://www.lanse.co.uk
Any PHP / Mysql people on here?
« Reply #17 on: July 25, 2006, 03:57:39 PM »
Thanks Trog.

Please can you swap the last two column headers over - they are sorting the wrong columns!
i5-2500k
Asus P8P67
2x 4gb DDR3 1600 hz OCZ
1 x Dell Perc 6/i
4 x Samsung 2TB (raid 5)
1 x WD VelociRaptor WD3000HLFS
Asus 5870 1gb PCI-E

Trogwar

  • Guest
Re: Any PHP / Mysql people on here?
« Reply #18 on: July 25, 2006, 04:30:16 PM »
Yeah, here's fixed one: column order corrected and sorting by "last 60 day" disabled.

Trogwar

  • Guest
Re: Any PHP / Mysql people on here?
« Reply #19 on: July 25, 2006, 04:40:34 PM »
Erm... This one even:  :roll:

jason

  • LANSE Admin
  • LANSE Elder
  • *****
  • Posts: 7304
    • http://www.lanse.co.uk
Any PHP / Mysql people on here?
« Reply #20 on: July 25, 2006, 04:54:06 PM »
ta
i5-2500k
Asus P8P67
2x 4gb DDR3 1600 hz OCZ
1 x Dell Perc 6/i
4 x Samsung 2TB (raid 5)
1 x WD VelociRaptor WD3000HLFS
Asus 5870 1gb PCI-E

Trogwar

  • Guest
Re: Any PHP / Mysql people on here?
« Reply #21 on: July 26, 2006, 11:46:52 AM »
New version of stats.php and stats.html here. Now sorting by 'Last 60 Days' column allowed.

I use temporary table to calculate 60 days raid attendance since MySQL doesn't support nested queries until version 4.1. So I guess it's much better if I make single query instead multiple queries for each member. And this allows us to sort by this column as well.

Anyway, files attached. You can compare perfomance by setting "Debug" variable in config.php file (works only for default template).

jason

  • LANSE Admin
  • LANSE Elder
  • *****
  • Posts: 7304
    • http://www.lanse.co.uk
Any PHP / Mysql people on here?
« Reply #22 on: July 26, 2006, 12:41:45 PM »
Nice one Trog - works a treat
i5-2500k
Asus P8P67
2x 4gb DDR3 1600 hz OCZ
1 x Dell Perc 6/i
4 x Samsung 2TB (raid 5)
1 x WD VelociRaptor WD3000HLFS
Asus 5870 1gb PCI-E

Trogwar

  • Guest
Any PHP / Mysql people on here?
« Reply #23 on: July 27, 2006, 11:21:47 AM »
I found a bug when someone has never attend in raids over sixty days he disappeared from stats table at all even when you click "show all" link. Here's fixed stats.php  8)

jason

  • LANSE Admin
  • LANSE Elder
  • *****
  • Posts: 7304
    • http://www.lanse.co.uk
Any PHP / Mysql people on here?
« Reply #24 on: July 27, 2006, 11:35:41 AM »
thanks
i5-2500k
Asus P8P67
2x 4gb DDR3 1600 hz OCZ
1 x Dell Perc 6/i
4 x Samsung 2TB (raid 5)
1 x WD VelociRaptor WD3000HLFS
Asus 5870 1gb PCI-E