[HELP] Friend Request Glitch [HELP]

Chloroform

New Member
May 18, 2013
11
1
I am currently using my edited version of ubercms, and everytime a new user comes on the client and add's somebody they disconnect. I thought i had fixed this problem by running a query. this query only fixed the old users in the db, and still effected the new ones. Help anyone thanks!
 

St4nley

Member
Apr 13, 2013
469
76
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:
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
PHP:
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
Code:
update users set last_online = UNIX_TIMESTAMP();

Then Right Click On Users Click Design Table

Then Set this:
HRjQMiZ.png



to this :
luhNq8J.png
 

Users who are viewing this thread

Top