RevCMS & Phoenix Emulator - Disconnecting Friend Requests

[zMagenta]

Hi!

I'm running on RevCMS and Phoenix Emulator. I keep having this errors, when users accept friend requests, the user who sent and the user who accepts get disconnected.

Any ideas?

 

[Brop]

What emulator are you using? New or old.

 

[Puridee]

Hi!

I'm running on RevCMS and Phoenix Emulator. I keep having this errors, when users accept friend requests, the user who sent and the user who accepts get disconnected.

Any ideas?

Either the database or the Phoenix version you are using is out of date. Update both just to be positive.

 

[zMagenta]

Either the database or the Phoenix version you are using is out of date. Update both just to be positive.

I'm using the latest DB and Emulator.

 

[Puridee]

I'm using the latest DB and Emulator.

Have you tried restarting the emulator, if so I believe the problem is in your database.

 

[Brad]

Find this in Class.users.php

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

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

update users set last_online = UNIX_TIMESTAMP();

Then Right Click On Users Click Design Table

Then Set this:

to this :

Should work it worked For me

 

[Rahmat]

Find this in Class.users.php

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

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

update users set last_online = UNIX_TIMESTAMP();

Then Right Click On Users Click Design Table

Then Set this:

to this :

Should work it worked For me

What about GTE ?