Cronus
Cerberus Founder/Developer
- Jul 19, 2013
- 449
- 25
Hey so I followed this:
But I get this:
Ubercms2 Friend Request D/C Fix-
MAKE SURE YOUR USERS TABLE IN DATABASE IS EMPTY! OR IT WILL NOT SAVE ~CREDITS TO Br4d
if your not using Ubercms Just Skip To the database Part
Find this in Class.users.php
PHP:
Code:
dbquery("INSERT INTO users (username,password,mail,auth_ticket,rank,look,gend er,motto,credits,activity_points,last_online,accou nt_created,ip_reg) VALUES ('" . $username . "','" . $passwordHash . "','" . $email . "','','" . $rank . "','" . $figure . "','" . $sex . "','','500','1000','','" . date('d-M-Y') . "','". $_SERVER['REMOTE_ADDR'] . "')");$id = intval(mysql_result(dbquery("SELECT id FROM users WHERE username = '" . $username . "' ORDER BY id DESC LIMIT 1"), 0))
Replace it with
Code:
dbquery("INSERT INTO users (username,password,mail,auth_ticket,rank,look,gender,motto,credits,activity_points,last_online,account_created,ip_reg) VALUES ('" . $username . "','" . $passwordHash . "','" . $email . "','','" . $rank . "','" . $figure . "','" . $sex . "','','500','1000','', UNIX_TIMESTAMP() ,'" .$_SERVER['REMOTE_ADDR'] . "')");
$id = intval(mysql_result(dbquery("SELECT id FROM users WHERE username = '" . $username . "' ORDER BY id DESC LIMIT 1"), 0));
Then Run This Is your Database
PHP:
update users set last_online = UNIX_TIMESTAMP();
Then Right Click On Users Click Design Table
Then Set this:
to this :
MAKE SURE YOUR USERS TABLE IN DATABASE IS EMPTY! OR IT WILL NOT SAVE ~CREDITS TO Br4d
if your not using Ubercms Just Skip To the database Part
Find this in Class.users.php
PHP:
Code:
dbquery("INSERT INTO users (username,password,mail,auth_ticket,rank,look,gend er,motto,credits,activity_points,last_online,accou nt_created,ip_reg) VALUES ('" . $username . "','" . $passwordHash . "','" . $email . "','','" . $rank . "','" . $figure . "','" . $sex . "','','500','1000','','" . date('d-M-Y') . "','". $_SERVER['REMOTE_ADDR'] . "')");$id = intval(mysql_result(dbquery("SELECT id FROM users WHERE username = '" . $username . "' ORDER BY id DESC LIMIT 1"), 0))
Replace it with
Code:
dbquery("INSERT INTO users (username,password,mail,auth_ticket,rank,look,gender,motto,credits,activity_points,last_online,account_created,ip_reg) VALUES ('" . $username . "','" . $passwordHash . "','" . $email . "','','" . $rank . "','" . $figure . "','" . $sex . "','','500','1000','', UNIX_TIMESTAMP() ,'" .$_SERVER['REMOTE_ADDR'] . "')");
$id = intval(mysql_result(dbquery("SELECT id FROM users WHERE username = '" . $username . "' ORDER BY id DESC LIMIT 1"), 0));
Then Run This Is your Database
PHP:
update users set last_online = UNIX_TIMESTAMP();
Then Right Click On Users Click Design Table
Then Set this:
to this :
But I get this:
UberCMS has encountered an error
Incorrect time value: '' for column 'last_online' at row 1
Incorrect time value: '' for column 'last_online' at row 1