Ravens PHP Scripts: Forums
 

 

View next topic
View previous topic
Post new topic   Reply to topic    Ravens PHP Scripts And Web Hosting Forum Index -> How To's
Author Message
johny
New Member
New Member


Joined: Jul 19, 2003
Posts: 8
Location: Between the Alps and the Balkans

PostPosted: Sat Jul 19, 2003 7:51 am Reply with quote

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!, 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.
 
View user's profile Send private message Send e-mail Visit poster's website
Raven
Site Admin/Owner


Joined: Aug 27, 2002
Posts: 17086

PostPosted: Sat Jul 19, 2003 7:56 am Reply with quote

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.
 
View user's profile Send private message
johny
PostPosted: Sat Jul 19, 2003 9:35 am Reply with quote

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
PostPosted: Sat Jul 19, 2003 9:47 am Reply with quote

If I'm understanding you correctly, yes.
 
johny
PostPosted: Sat Jul 19, 2003 10:11 am Reply with quote

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
PostPosted: Sat Jul 19, 2003 10:23 am Reply with quote

Try changing the format of the date on a member that joined yesterday using phpmyadmin. Does it show now?
 
johny
PostPosted: Sat Jul 19, 2003 10:29 am Reply with quote

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
PostPosted: Sat Jul 19, 2003 1:45 pm Reply with quote

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
PostPosted: Sat Jul 19, 2003 2:13 pm Reply with quote

$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
PostPosted: Sat Jul 19, 2003 2:18 pm Reply with quote

Just got back in. Glad you resolved it!
 
johny
PostPosted: Sat Jul 19, 2003 2:56 pm Reply with quote

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
PostPosted: Sun Jul 20, 2003 6:43 am Reply with quote

How do the dates post on News items?
 
johny
PostPosted: Sun Jul 20, 2003 7:44 am Reply with quote

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
New Member


Joined: Jul 11, 2003
Posts: 4

PostPosted: Fri Aug 01, 2003 10:35 pm Reply with quote

I have the same problem with...

Hits New Today:
Hits New Yesterday:

Any ideas on how to fix this?
 
View user's profile Send private message
Display posts from previous:       
Post new topic   Reply to topic    Ravens PHP Scripts And Web Hosting Forum Index -> How To's

View next topic
View previous topic
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
You can attach files in this forum
You can download files in this forum


Powered by phpBB © 2001-2007 phpBB Group
All times are GMT - 6 Hours
 
Forums ©