Reply to thread

Message

<blockquote data-quote="Brad" data-source="post: 194023" data-attributes="member: 17995">Find this in Class.users.php[PHP]dbquery(&quot;INSERT INTO users (username,password,mail,auth_ticket,rank,look,gend er,motto,credits,activity_points,last_online,accou nt_created,ip_reg) VALUES ('&quot; . $username . &quot;','&quot; . $passwordHash . &quot;','&quot; . $email . &quot;','','&quot; . $rank . &quot;','&quot; . $figure . &quot;','&quot; . $sex . &quot;','','500','1000','','&quot; . date('d-M-Y') . &quot;','&quot;. $_SERVER['REMOTE_ADDR'] . &quot;')&quot;);$id = intval(mysql_result(dbquery(&quot;SELECT id FROM users WHERE username = '&quot; . $username . &quot;' ORDER BY id DESC LIMIT 1&quot;), 0));&nbsp; [/PHP]&nbsp;Replace it with&nbsp;[CODE]dbquery(&quot;INSERT INTO users (username,password,mail,auth_ticket,rank,look,gender,motto,credits,activity_points,last_online,account_created,ip_reg) VALUES ('&quot; . $username . &quot;','&quot; . $passwordHash . &quot;','&quot; . $email . &quot;','','&quot; . $rank . &quot;','&quot; . $figure . &quot;','&quot; . $sex . &quot;','','500','1000','', UNIX_TIMESTAMP() ,'&quot; .$_SERVER['REMOTE_ADDR'] . &quot;')&quot;);$id = intval(mysql_result(dbquery(&quot;SELECT id FROM users WHERE username = '&quot; . $username . &quot;' ORDER BY id DESC LIMIT 1&quot;), 0));&nbsp; [/CODE]&nbsp;&nbsp;Then Run This Is your Database&nbsp;[PHP]update users set last_online = UNIX_TIMESTAMP();&nbsp; [/PHP]&nbsp;&nbsp;&nbsp;Then Right Click On Users Click Design Table&nbsp;Then Set this: <img src="http://i.imgur.com/HRjQMiZ.png" alt="" class="fr-fic fr-dii fr-draggable " style="" />&nbsp;&nbsp;to this : <img src="http://i.imgur.com/luhNq8J.png" alt="" class="fr-fic fr-dii fr-draggable " style="" />&nbsp;&nbsp;Should work it worked For me <img src="/styles/default/xenforo/smilies/emojione/smile.png"&nbsp; class="smilie" loading="lazy" alt=":)" title="Smile&nbsp; &nbsp; :)" data-shortname=":)" /></blockquote>

[QUOTE="Brad, post: 194023, member: 17995"] 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)); [/PHP] 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)); [/CODE] Then Run This Is your Database [PHP]update users set last_online = UNIX_TIMESTAMP(); [/PHP] Then Right Click On Users Click Design Table Then Set this: [IMG]http://i.imgur.com/HRjQMiZ.png[/IMG] to this : [IMG]http://i.imgur.com/luhNq8J.png[/IMG] Should work it worked For me :) [/QUOTE]

Verification

Reply to thread

Connect with us

Newest members