Help with ubercms/phx?

Cronus

Cerberus Founder/Developer
Jul 19, 2013
449
25
Hey so I followed 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:
HRjQMiZ.png



to this :
luhNq8J.png




But I get this:

UberCMS has encountered an error
Incorrect time value: '' for column 'last_online' at row 1
 

Ghost

Legacy, it's all anyone leaves behind.
Jun 8, 2012
1,640
503
Follow this thread,

by Br4d

If that doesn't work do this
Change the last_online column to double and restart your emulator.​
 

Cronus

Cerberus Founder/Developer
Jul 19, 2013
449
25
Change the last_online column to double and restart your emulator. what do you mean can you help me out on that
 

Users who are viewing this thread

Top