[Help] Adding Disconnection

[JayC]

So users have made complaints that when they accept or decline a friend request they disconnect!

 

[Ghost]

Truncate the messenger_friends table, any table with messenger_ Truncate that table.

 

[Cronus]

I am using ubercms and I get this error soo help!

 

[Ghost]

Truncate the messenger_friends table, any table with messenger_ Truncate that table.

I am using ubercms and I get this error soo help!

 

[JayC]

Yes Great Thanks WTML! It worked!

 

[Cronus]

I did that but it will starting doing it again later.

 

[JayC]

Yeah it did.. lmfao. I was just coming back to post it didn't work :l Any idea?

 

[St4nley]

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 :

 

[JayC]

Thanks! Hopes this works