You're welcome :DOriginally Posted by Mrdevy
You're welcome :D
public function addUser($username, $passwordHash, $email, $rank, $figure, $sex, $motto, $homeroom, $id) {
global $db, $core;
if($this->stmt = $db->prepare("INSERT INTO users (username,password,mail,auth_ticket,rank,look,gender,motto,home_room,credits,activity_points,last_online,account_created,ip_last,ip_reg) VALUES ('" . $username . "','" . $passwordHash . "','" . $email . "','','" . $rank . "','" . $figure . "','" . $sex . "', '" . $motto . "', '" . $homeroom . "','15000','1000','','" . date('d-M-Y') . "', '".$_SERVER['REMOTE_ADDR']."', '".$_SERVER['REMOTE_ADDR']."')")) {
$this->stmt = $db->prepare("INSERT INTO user_info (user_id,bans,cautions,reg_timestamp,login_timestamp,cfhs,cfhs_abusive) VALUES ('" . $id . "','0','0','" . time(). "','" . time() . "','0','0')");
$this->stmt->execute();
$this->stmt->close();
}
else {
$db->databaseError($db->error);
}
}
Finally got it working. But it says i created the account on 1/1/1970? Ive checked the account_created table, if i put the numbers inside the user_info it works. How do i make sure that users who have logged in its automatically inserted into user_info table?
Last edited by Mario1134; 01-07-13 at 10:17 PM.
Why does it say that i registered on 1/1/1970
Because you probably used a date that actually doesn't excist.
No i did, because if i insert my reg_timestamp from users into user_info it shows i registered on 28/06/2013.
I think its to do with the queries, not sure though.
You'll have to use a unix timestamp in your user_info.
Use strtotime().
Where do I put this?
Reply With Quote