Weekly Star Scale

Moonlight Soldier · Post by **Moonlight Soldier** » Sat Jan 08, 2005 1:01 pm

Is there a reason this hasn't been updated recently?

It hasn't been updated since Dec 26th 2004.

Cheers,

~Moonlight

Moonlight Soldier · Post by **Moonlight Soldier** » Sun Jan 09, 2005 2:34 pm

Am I going to get any sort of reply?

YouTube · Post by **derobert** » Mon Jan 10, 2005 8:33 am

Script didn't update the table for some reason. I think Phade is looking into it.

badmartialarts · Post by **badmartialarts** » Mon Jan 10, 2005 7:13 pm

It did the same thing last year, if I recall. It doesn't seem to like the year change.

Moonlight Soldier · Post by **Moonlight Soldier** » Mon Jan 10, 2005 9:19 pm

Well at least it's back up and working now. Thank you.

YouTube · Post by **derobert** » Tue Jan 11, 2005 8:04 pm

badmartialarts wrote:It did the same thing last year, if I recall. It doesn't seem to like the year change.

Thanks; I've forwarded that info on to phade just in case he didn't see it...

It's quite possible something is wrong with the year rollover; it's pretty weird code:

Code: Select all

	// Get the number of this week...
	$query = "select week(now(),3) as theweek";
	$result = mysql_query($query, $dbconn);
	$row = mysql_fetch_object($result);
	$thisweek = $row->theweek;
	
	// Get default year and week values...
	if ($thisweek-1<1) { 
		$query = "select week('" . (year("Y") -1) . "-12-31',3) as theweek";
		$result = mysql_query($query, $dbconn);
		$row = mysql_fetch_object($result);
		$week = $row->theweek;
		$year = date("Y")-1;
	}	// if
	else { 
		$week = $thisweek-1; 
		$year = date("Y");
	} // else

I think it does the same thing as

Code: Select all

	$time_last_week = time() - 604800; // == 7 days
	$week = date('W', $time_last_week);
	$year = date('Y', $time_last_week);

but I'm not sure.

Gemberkoekje · Post by **Gemberkoekje** » Tue Jan 11, 2005 11:20 pm

What exactly is the code trying to do?