[Scrub]

Doing a search for:

PHP Code:

$user=$DB_site->query_first("SELECT 


would be alot faster. .

But in my hacked user.php, this is where it is:

PHP Code:

// ###################### Start edit #######################
if ($action=="edit") {

$user=$DB_site->query_first("SELECT user.*,FROM_UNIXTIME(joindate) AS joindate,FROM_UNIXTIME(lastvisit) AS lastvisit,FROM_UNIXTIME(lastactivity) AS lastactivity,FROM_UNIXTIME(lastpost) AS lastpost,FROM_UNIXTIME(awaydate) AS awaydate,
                               avatar.avatarpath,NOT ISNULL(customavatar.avatardata) AS hascustomavatar
                               FROM user
                               LEFT JOIN avatar ON avatar.avatarid=user.avatarid
                               LEFT JOIN customavatar ON customavatar.userid=user.userid
                               WHERE user.userid=$userid");

  if ($user[coppauser]==1) {
    echo "<P><b>THIS IS A COPPA USER. DO NOT CHANGE TO USERGROUP TO REGISTERED USER UNLESS YOU HAVE RECEIVED PARENTAL CONSENT</b></p>";
  }