Problem with Site Info Block?

Client Joined: Sep 10, 2004 Posts: 166

Hi Raven,

I just noticed that the # of new members registered yesterday on my site is showing like ten 10 times what it should be showing, but just for yesterday.... it seemed to be working just fine up until now. Do you know if there are any problems with that part of the code?

Thanks!

Brent [ Only registered users can see links on this board! Get registered or login! ]

Site Admin/Owner Joined: Aug 27, 2002 Posts: 17088

- So does mine. It must have something to do with the date routine. I'll look into it.

Posted: Wed Dec 01, 2004 11:16 am

OK, thank you!

Posted: Wed Dec 01, 2004 11:50 am

BTW, this is original nuke code, not mine. It has always, and still does, have an error in the Yesterday routine. I had tried to patch it before and it apparently was working on all days except the first. I will attempt once again. Replace this section of code with this

Code:

$Today = getdate();


//Formatting Current Date


$month = $Today['month'];


$mday = $Today['mday'];


$year = $Today['year'];


//Formatting Previous Date


$pmonth = $Today['month'];


$pmday = $Today['mday'];


//$pmday = $mday-1;


$pyear = $Today['year'];


//Month conversion into numeric mode


if ($pmonth=="January") { $pmonth=1; } else


if ($pmonth=="February") { $pmonth=2; } else


if ($pmonth=="March") { $pmonth=3; } else


if ($pmonth=="April") { $pmonth=4; } else


if ($pmonth=="May") { $pmonth=5; } else


if ($pmonth=="June") { $pmonth=6; } else


if ($pmonth=="July") { $pmonth=7; } else


if ($pmonth=="August") { $pmonth=8; } else


if ($pmonth=="September") { $pmonth=9; } else


if ($pmonth=="October") { $pmonth=10; } else


if ($pmonth=="November") { $pmonth=11; } else


if ($pmonth=="December") { $pmonth=12; };


$test = mktime (0,0,0,$pmonth,$pmday,$pyear,1);





//Creating SQL parameter


$curDate2 = "%".$month[0].$month[1].$month[2]."%".$mday."%".$year."%";


$preday = strftime ("%d",$test);


$premonth = strftime ("%B",$test);


$preyear = strftime ("%Y",$test);


$curDateP = "%".$premonth[0].$premonth[1].$premonth[2]."%".$preday."%".$preyear."%";





//Executing SQL Today


$row = $db->sql_fetchrow($db->sql_query("SELECT COUNT(user_id) AS userCount FROM $user_prefix"._users." WHERE user_regdate LIKE '$curDate2'"));


$userCount = $row['userCount'];


//end





//Executing SQL Yesterday


$row2 = $db->sql_fetchrow($db->sql_query("SELECT COUNT(user_id) AS userCount FROM $user_prefix"._users." WHERE user_regdate LIKE '$curDateP'"));


$userCount2 = $row2['userCount'];


//end

Posted: Wed Dec 01, 2004 11:58 am

Awesome, that seems to do the trick. Thanks Raven!

Brent

Posted: Wed Dec 01, 2004 11:59 am

If it is still okay tomorrow I will update the download.