User Joined Date not showing correctly

New Member Joined: Jan 07, 2007 Posts: 22

Hey guys,

I am having a problem that the date a user joined is not showing correctly in the members list. Initially i thought it was a 2.10.00 bug which was fixed by 2.10.01 as the user accounts which weren't showing correctly were deleted and the users re-registered after I patched the site to 2.10.01. A user has since registered and the same error has occured, the enclosed pic shows the members list and the error in the joined date column.

Anybody have any ideas what may be causing this? I've noticed that the the affected user is the only one with a website and location defined in their profile, but the other users prior to the upgrade hadn't defined websites or locations.
Very confusing.

Cheers

Gandlers

Posted: Thu May 17, 2007 3:20 pm

You don´t need to delete users with such a date. I´m pretty sure it has nothing to do with the website entry. I had the same issue with standard nuke and found tools like that:
[ Only registered users can see links on this board! Get registered or login! ]

D M d, Y g:i a edit user and check/change the date.

Posted: Thu May 17, 2007 4:05 pm

I looked at the Member_List code, and it is using the field user_regdate from the _users table for the column. It is possible that got messed up somehow. Are you using the standard Your_Account module or something else like CNBYA?

I would follow Susann's advice and check the user_dateformat and user_regdate fields in your _user table to see if they are messed up.

That number looks like a UNIX timestamp that has not been formatted into a human readable date.

Posted: Thu May 17, 2007 6:15 pm

we are using the standard "your_account".

I have had a look in the sql database and in the user_regdate field it has the numerical string (unixtimestamp), and in the user_dateformat field it has the actual date of registration rather than "D M d, Y g:i a" like all the other working accounts have.

Anyone have any ideas what may have caused this as im new to this PHPNuke malarky and things like this make me feel really out of my depth as i havent got a clue how to find and fix the fault. Is it possible that the user could be causing this during registration?

Oh Susann, I actually deleted the accounts as they were not showing to add into usergroups in NSN groups. That fault seemed to be fixed by the patch, but I thought the same of the timestamp fault. Smile

Thanks for your advice

G

Posted: Thu May 17, 2007 6:32 pm

I am not real sure how that could have gotten like that. The code in Your_Account is pretty straightforward. Did the user sign up through the phpBB forums registration or through a link on the home page (Your_Account)?

I would just edit that users row in phpMyAdmin as follows:

change the user_regdate field to the English date (May 17, 2007)
change the user_dateformat field back to D M d, Y g:i a

Do you know this user?

Posted: Thu May 17, 2007 6:46 pm

It happens sometimes and mods can cause this. You only need to change this 2 things.
With the converter tool you are able to find and change the user_regdate easily if it happens again.
Btw: The NSN groups works fine.

Posted: Thu May 17, 2007 7:47 pm

Yeah, I don't recall us making any changes to Members List or Forums code for 2.10.01, so not sure... Even Your Account, there were no changes between 2.10.00 and 2.10.01.

Posted: Sun May 27, 2007 12:21 pm

@gandlers

I´ve found out that all new users with a wrong register date used the forums registration and there the Coppa.
No, I don´t know a permanent fix at the moment. Don´t let them register trough the forums. Change the path.
If you have still this problem check with phpMyAdmin the username within the tracked IPs you`ll find out how they registered.
There are other ways too e.g. the logfiles.

Posted: Sun May 27, 2007 12:36 pm

At one time I removed the login and registration from the forum template on my site so that they could only login through Your_Account.

Posted: Sun May 27, 2007 12:40 pm

But how can you use the Coppa without forums registration ?

Posted: Sun May 27, 2007 12:44 pm

I don't.

Posted: Mon Jan 21, 2008 2:35 am

Hey guys,

just digging up this old thread as we have has a few "bots" recently registering an posting viagra adverts etc.

How would I go about removing the login/register from hte forums, I have searched the code, but cant seem to find it. I know its probably looking me right in the face, but this PHP Nuke stuff is a bit advanced with complex syntax that hurts my head Smile

G

Posted: Mon Jan 21, 2008 2:52 am

Try this code by evaders:
FIND in includes/usercp_register.php

Code:







if ( !defined('IN_PHPBB') )


{


        die("Hacking attempt");


        exit;


}

AFTER, ADD

Code:




if ($mode == "register") {


   Header("Location: account-new_user.html");


   die();


}

Posted: Tue Jan 22, 2008 7:33 am

tried that, there is still the option to register.

What I want to do is remove the Register bit from the forum and only allow users to resiter by the info block.

G

Posted: Tue Jan 22, 2008 11:23 am

But they are redirected to Your Account with the forums link to register.
A link to your site would be great.
I quess the link is in the overall header of your forums template.