How to fix Phx Friend Request Bug

[Brad]

if your not using Ubercms Just Skip To the database Part

Find this in Class.users.php
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

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 :

Should work it worked For me

 

[GodFather]

Thank you for this will help the noobs

 

[Brad]

Thank you for this will help the noobs

haha

 

[Flint]

I don't get what this bug is about i haven't seen any bugs?

 

[Brad]

I don't get what this bug is about i haven't seen any bugs?

when an person accepts an Friend request they disconnect it only happens with the latest Phx Database but its still a good Fix.

 

[Flint]

when an person accepts an Friend request they disconnect it only happens with the latest Phx Database but its still a good Fix.

Oh okay thanks i just tested it without the fix and it did dc me, i've just installed it and works perfectly thanks man

 

[Brad]

Oh okay thanks i just tested it without the fix and it did dc me, i've just installed it and works perfectly thanks man

your Welcome Just helping People

 

[GodFather]

Getting a error that says incorrect time value when i save

 

[Flint]

This stopped working the next day and i found that the way it was before was fine :S

 

[GodFather]

getting this error when i register;

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