Joined date and user_level bugs.

Sergeant Joined: Feb 27, 2003 Posts: 94

Probably because he added the port from NukeCops only in RC3 and he didn't check out everything. We at PortedMods.com found 3 fixes for bugs in this version

Posted: Sat Apr 05, 2003 4:30 am

b.t.w i replaced the original file with your usercp_register.php but i realized it doesn't work. i have a new user and joined date is 1049545105

http://www.turkrock.com/modules.php?name=Forums&file=profile&mode=viewprofile&u=1902

Sergeant Joined: Mar 15, 2003 Posts: 143

I've searched for "join date" and "joined date", and this is the thread I found that most suited my needs. Running 6.5 and I'm getting the date in seconds -- what NovemberRain said was "1049545105". It's in the SQL table itself, so it must be at user registration. Thus, I am looking for two things.

How to convert those numbers to the proper date.
How to stop it from happening with every new user.

Thanks!

Sergeant Joined: Mar 15, 2003 Posts: 143

Anyone?

Posted: Tue Jul 29, 2003 10:44 am

Here's mikem's workaround:

Open
includes/usercp_register.php

just below this:

Code:

//
// Get current date
//

add this line

Code:

$reg_date = date("M d, Y");

then just below that line you should see this line:

Code:

VALUES ($user_id, '" . str_replace("\'", "''", $username) . "', " . time() . ", '" . str_replace("\'", "''", $new_password) . "', '" . str_replace("\'", "''", $email) . "', '" . str_replace("\'", "''", $icq) . "', '" . str_replace("\'", "''", $website) . "', '" . str_replace("\'", "''", $occupation) . "', '" . str_replace("\'", "''", $location) . "', '" . str_replace("\'", "''", $interests) . "', '" . str_replace("\'", "''", $signature) . "', '$signature_bbcode_uid', $avatar_sql, $viewemail, '" . str_replace("\'", "''", str_replace(' ', '+', $aim)) . "', '" . str_replace("\'", "''", $yim) . "', '" . str_replace("\'", "''", $msn) . "', $attachsig, $allowsmilies, $allowhtml, $allowbbcode, $allowviewonline, $notifyreply, $notifypm, $popuppm, $user_timezone, '" . str_replace("\'", "''", $user_dateformat) . "', '" . str_replace("\'", "''", $user_lang) . "', $user_style, 0, 1, ";

change that line to this

Code:

VALUES ($user_id, '" . str_replace("\'", "''", $username) . "', '" . $reg_date . "', '" . str_replace("\'", "''", $new_password) . "', '" . str_replace("\'", "''", $email) . "', '" . str_replace("\'", "''", $icq) . "', '" . str_replace("\'", "''", $website) . "', '" . str_replace("\'", "''", $occupation) . "', '" . str_replace("\'", "''", $location) . "', '" . str_replace("\'", "''", $interests) . "', '" . str_replace("\'", "''", $signature) . "', '$signature_bbcode_uid', $avatar_sql, $viewemail, '" . str_replace("\'", "''", str_replace(' ', '+', $aim)) . "', '" . str_replace("\'", "''", $yim) . "', '" . str_replace("\'", "''", $msn) . "', $attachsig, $allowsmilies, $allowhtml, $allowbbcode, $allowviewonline, $notifyreply, $notifypm, $popuppm, $user_timezone, '" . str_replace("\'", "''", $user_dateformat) . "', '" . str_replace("\'", "''", $user_lang) . "', $user_style, 0, 1, ";

The only part I had to change in that big ole line was this:

Code:

" . time() . "

to this

Code:

'" . $reg_date . "'

that should generate the Date in the format expected now when a user signs up using the Forum registration.

mikem

By the way Nuke 6.6 & 6.7 are out and should have this and other bugs corrected.

Sergeant Joined: Mar 15, 2003 Posts: 143

I'm afraid that my changes aren't well-documented, being my first serious foray into Nukedom. So I'm afraid of losing them Very Happy

. However, I'm going to try 6.latest on a test site.

Implementing the workaround now...thanks for the info!

Edit: Is there a way to convert the existing database values from time() to date()?