Friend request error?

[Cronus]

Hello,

after awhile the users if they accept friend request it will disconnect


i am using ubercms and fixs?

 

[XenonR]

You need to add a last online unix timestamp to the class.users.

 

[Cronus]

hmm? fully help?

 

[XenonR]

Go to your class.users.php file and find:

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'] . "')");

And replace all of that with:

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','', UNIX_TIMESTAMP() ,'" .$_SERVER['REMOTE_ADDR'] . "')");

When you've done that, run this into your database:

update users set last_online = UNIX_TIMESTAMP();

This should fix it, if not I don't know.