Hits Not Incrementing

johny · Posted: Sat Jul 19, 2003 7:51 am

Hi,

i thought to post here since the topic is about the user info block.I have a different problem though.
I am admin on a

Only registered users can see links on this board!
Get registered or login to the forums!

, and we're using php-nuke for a couple of months now. First we used 6.5 now upgraded to 6.7. There has always been a strange problem though, on the user info block.
The Membership: New Yesterday remained always 0, while new Today had the right value.

We have done a lot of work on the site (including an attempt to integrate our older phpbb forum into php-nuke) but noone has ever touched that block.

I took your block because i liked it, and because i hoped it would have solved the problem, but unfortunately no improvement Sad

.

Now new today is stuck to 0 too, even though we've had 3 new users today and 6 yesterday.

also hits new today, and yesterday dont have nothing after (not even a 0) them like :

Hits New Today:
Hits New Yesterday:

Any suggestion on what might be going on is really welcome.

P.S. I don't know if its relevant, but i just remembered i changed somewhere at modules/Your_account/index.php the date format users register. for ex. Jul 17, 2003 to 19 Jul, 2003.

Raven · Posted: Sat Jul 19, 2003 7:56 am

I would imagine that's it. One way to find out is to temporarily replace the Your_Account/index.php file with the original and see if the user info block straightens out.

johny · Posted: Sat Jul 19, 2003 9:35 am

Thanks for your quick reply.

I forgot to say i made that change (the date change) only yesterday... Confused

,
while as i said the problem has been present for more than two months now, but has never been on the things to do list.

I noticed $user_regdate because i was editing the Your_Account/index.php in order to add your account autoactivation hack. (Which works wonderfully by the way Laughing

)
I could change
$user_regdate = date("d M, Y");
back to
$user_regdate = date("M d, Y");

but to tell the truth i'm just feeling too confortable with autoactivation to replace the whole file.

Another thing, i could get into the database and manually change the date of the users that have registered in the last two days (everybody else already has d M, Y). So date wont be a problem anymore, am i right?

Raven · Posted: Sat Jul 19, 2003 9:47 am

If I'm understanding you correctly, yes.

johny · Posted: Sat Jul 19, 2003 10:11 am

Done. Now the situation is better than before -New users today shows the correct nr, but new users yesterday is still stuck at 0, like it has been in the last two months.

Anëtarë:
I fundit: BISH
Sot: 7
Dje: 0
Gjithsej: 148

Any idea what may be wrong?

PS. Hits today and hits yesterday don't have any numbers beside them at all.

Raven · Posted: Sat Jul 19, 2003 10:23 am

Try changing the format of the date on a member that joined yesterday using phpmyadmin. Does it show now?

johny · Posted: Sat Jul 19, 2003 10:29 am

I did that already, i told you.

UPDATE `nuke_users` SET `user_regdate` = 'Jul 18, 2003' WHERE `user_regdate` = '18 Jul, 2003' LIMIT 5

did that for 19 july also ...

Every member (all 148) have this format now

or wasn't this you were referring to?

johny · Posted: Sat Jul 19, 2003 1:45 pm

while trying to "debug" the block i found out sth interesting
this is the part of the code that creates the sql parameter to maqe the query,

Quote:

$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'];
$jonpmonth = $pmonth;
//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
$test = mktime (0,0,0,$pmonth,$pmday,$pyear,1);
$curDate2 = "%".$month[0].$month[1].$month[2]."%".$mday."%".$year."%";
$preday = strftime ("%d",$test);
$premonth = strftime ("%B",$test);
$preyear = strftime ("%Y",$test);
$curDate3 = "%".$premonth[0].$premonth[1].$premonth[2]."%".$preday."%".$preyear."%";

but look what happens with the dates after the code is executed

$curDate2 = %Jul%19%2003%
$curDate3 = %kor%18%2003%

the yesterday date is in albanian language! ( in albanian July = korrik)

Now my board default language is albanian, but in the database all registration dates are in English.

I don't like the fact that the dates are different languages... if they were coherent it would have been better i think.
bug?

johny · Posted: Sat Jul 19, 2003 2:13 pm

$result = sql_query("SELECT hits FROM $prefix"._stats_date." WHERE year='$t_year' AND month='$t_month' AND date='$t_date'", $dbi);

i was browsing my database and saw that nuke_stats_date and nuke_stats_month Tables were completely empty, while nuke_stats_hour and nuke_stats_year had information in them, here i think should be my fault...

Raven i want to thank you for your help, i really appreceate it. I always try to solve problems by myself, but i'm new to php, and i think your experience can help me a lot.

Ty very much
joni

Raven · Posted: Sat Jul 19, 2003 2:18 pm

Just got back in. Glad you resolved it!

johny · Posted: Sat Jul 19, 2003 2:56 pm

I just figured out where the problems are, but i'm sorry i don't think i'm capable of finding the solutions Sad

I need your help

Raven · Posted: Sun Jul 20, 2003 6:43 am

How do the dates post on News items?

johny · Posted: Sun Jul 20, 2003 7:44 am

In the albanian language with this format, this is the last post:

E diel , 20 korrik @ 06:31:48 EDT nga Delphin (38 herë lexuar)

translated to

Sunday, 20 July @ 06:31:48 EDT

Winters · New Member Joined: Jul 11, 2003 Posts: 4

I have the same problem with...

Hits New Today:
Hits New Yesterday:

Any ideas on how to fix this?