An Error OccuredphpBB was unable to query the forums database");
}
$row = @mysql_fetch_array($result);
if(!$row)
{
error_die("That user does not exist. Please go back and search again.");
}
$userid = $row[user_id];
if(isset($addquery)) {
$addquery.=" AND p.poster_id=$userid AND u.username='$search_username'";
$subquery.=" AND p.poster_id=$userid AND u.username='$search_username'";
}
else {
$addquery.=" p.poster_id=$userid AND u.username='$search_username'";
$subquery.=" p.poster_id=$userid AND u.username='$search_username'";
}
}
if(isset($addquery)) {
switch ($searchboth) {
case "both" :
$query .= " WHERE ( $subquery OR $addquery ) AND ";
break;
case "title" :
$query .= " WHERE ( $subquery ) AND ";
break;
case "text" :
$query .= " WHERE ( $addquery ) AND ";
break;
}
}
else
{
$query.=" WHERE ";
}
$query .= " p.post_id = pt.post_id
AND p.topic_id = t.topic_id
AND p.forum_id = f.forum_id
AND p.poster_id = u.user_id
AND f.forum_type != 1";
// 100100 bartvb Uncomment the following GROUP BY line to show matching topics instead of all matching posts.
// $query .= " GROUP BY t.topic_id";
$query .= " ORDER BY $sortby";
$query .= " LIMIT 200";
if(!$result = mysql_query($query,$db))
{
die("An Error OccuredphpBB was unable to query the forums database ".mysql_error($db)." $query");
}
if(!$row = @mysql_fetch_array($result))
{
die($l_nomatches);
}
?>