|
'$servers') AND (location like '%$location%') AND (services like '%$services%') AND (maxclients like '%$maxclients%') AND (comments like '%$comments%')";
$t = "ssg";
endif;
elseif (($maxclients != "") AND ($servers == "")) :
if ($clientselect == "less") :
$queryoa = "SELECT * FROM $table WHERE (name like '%$name%') AND (website like '%$website%') AND (servers like '%$servers%') AND (location like '%$location%') AND (services like '%$services%') AND (maxclients < '$maxclients') AND (comments like '%$comments%')";
$t = "mcl";
elseif ($clientselect == "equal") :
$queryoa = "SELECT * FROM $table WHERE (name like '%$name%') AND (website like '%$website%') AND (servers like '%$servers%') AND (location like '%$location%') AND (services like '%$services%') AND (maxclients = '$maxclients') AND (comments like '%$comments%')";
$t = "mce";
elseif ($clientselect == "greater") :
$queryoa = "SELECT * FROM $table WHERE (name like '%$name%') AND (website like '%$website%') AND (servers like '%$servers%') AND (location like '%$location%') AND (services like '%$services%') AND (maxclients > '$maxclients') AND (comments like '%$comments%')";
$t = "mcg";
endif;
elseif (($maxclients != "") AND ($servers != "")) :
if (($servselect == "less") AND ($clientselect == "less")) :
$queryoa = "SELECT * FROM $table WHERE (name like '%$name%') AND (website like '%$website%') AND (servers < '$servers') AND (location like '%$location%') AND (services like '%$services%') AND (maxclients < '$maxclients') AND (comments like '%$comments%')";
$t = "mlsl";
elseif (($servselect == "less") AND ($clientselect == "equal")) :
$queryoa = "SELECT * FROM $table WHERE (name like '%$name%') AND (website like '%$website%') AND (servers < '$servers') AND (location like '%$location%') AND (services like '%$services%') AND (maxclients = '$maxclients') AND (comments like '%$comments%')";
$t = "mesl";
elseif (($servselect == "less") AND ($clientselect == "greater")) :
$queryoa = "SELECT * FROM $table WHERE (name like '%$name%') AND (website like '%$website%') AND (servers < '$servers') AND (location like '%$location%') AND (services like '%$services%') AND (maxclients > '$maxclients') AND (comments like '%$comments%')";
$t = "mgsl";
elseif (($servselect == "equal") AND ($clientselect == "less")) :
$queryoa = "SELECT * FROM $table WHERE (name like '%$name%') AND (website like '%$website%') AND (servers = '$servers') AND (location like '%$location%') AND (services like '%$services%') AND (maxclients < '$maxclients') AND (comments like '%$comments%')";
$t = "mlse";
elseif (($servselect == "equal") AND ($clientselect == "equal")) :
$queryoa = "SELECT * FROM $table WHERE (name like '%$name%') AND (website like '%$website%') AND (servers = '$servers') AND (location like '%$location%') AND (services like '%$services%') AND (maxclients = '$maxclients') AND (comments like '%$comments%')";
$t = "mese";
elseif (($servselect == "equal") AND ($clientselect == "greater")) :
$queryoa = "SELECT * FROM $table WHERE (name like '%$name%') AND (website like '%$website%') AND (servers = '$servers') AND (location like '%$location%') AND (services like '%$services%') AND (maxclients > '$maxclients') AND (comments like '%$comments%')";
$t = "mgse";
elseif (($servselect == "greater") AND ($clientselect == "less")) :
$queryoa = "SELECT * FROM $table WHERE (name like '%$name%') AND (website like '%$website%') AND (servers > '$servers') AND (location like '%$location%') AND (services like '%$services%') AND (maxclients < '$maxclients') AND (comments like '%$comments%')";
$t = "mlsg";
elseif (($servselect == "greater") AND ($clientselect == "equal")) :
$queryoa = "SELECT * FROM $table WHERE (name like '%$name%') AND (website like '%$website%') AND (servers > '$servers') AND (location like '%$location%') AND (services like '%$services%') AND (maxclients = '$maxclients') AND (comments like '%$comments%')";
$t = "mesg";
elseif (($servselect == "greater") AND ($clientselect == "greater")) :
$queryoa = "SELECT * FROM $table WHERE (name like '%$name%') AND (website like '%$website%') AND (servers > '$servers') AND (location like '%$location%') AND (services like '%$services%') AND (maxclients > '$maxclients') AND (comments like '%$comments%')";
$t = "mgsg";
endif;
elseif (($maxclients == "") AND ($servers == "")) :
$queryoa = "SELECT * FROM $table WHERE (name like '%$name%') AND (website like '%$website%') AND (servers like '%$servers%') AND (location like '%$location%') AND (services like '%$services%') AND (maxclients like '%$maxclients%') AND (comments like '%$comments%')";
$t = "b";
elseif ((isset($maxclients) == false) OR (isset($servers) == false)) :
$t = "b";
endif;
if (isset($order) == true) :
$queryoa = $queryoa . "order by $order $direction, name";
endif;
$resultoa = MYSQL_QUERY($queryoa);
$n = MYSQL_NUMROWS($resultoa);
$np = ceil($n / $npp);
endif;
$limit = ($p - 1) * $npp;
if ($t == "ssl") :
$query = "SELECT * FROM $table WHERE (name like '%$name%') AND (website like '%$website%') AND (servers < '$servers') AND (location like '%$location%') AND (services like '%$services%') AND (maxclients like '%$maxclients%') AND (comments like '%$comments%')";
elseif ($t == "sse") :
$query = "SELECT * FROM $table WHERE (name like '%$name%') AND (website like '%$website%') AND (servers = '$servers') AND (location like '%$location%') AND (services like '%$services%') AND (maxclients like '%$maxclients%') AND (comments like '%$comments%')";
elseif ($t == "ssg") :
$query = "SELECT * FROM $table WHERE (name like '%$name%') AND (website like '%$website%') AND (servers > '$servers') AND (location like '%$location%') AND (services like '%$services%') AND (maxclients like '%$maxclients%') AND (comments like '%$comments%')";
elseif ($t == "mcl") :
$query = "SELECT * FROM $table WHERE (name like '%$name%') AND (website like '%$website%') AND (servers like '%$servers%') AND (location like '%$location%') AND (services like '%$services%') AND (maxclients < '$maxclients') AND (comments like '%$comments%')";
elseif ($t == "mce") :
$query = "SELECT * FROM $table WHERE (name like '%$name%') AND (website like '%$website%') AND (servers like '%$servers%') AND (location like '%$location%') AND (services like '%$services%') AND (maxclients = '$maxclients') AND (comments like '%$comments%')";
elseif ($t == "mcg") :
$query = "SELECT * FROM $table WHERE (name like '%$name%') AND (website like '%$website%') AND (servers like '%$servers%') AND (location like '%$location%') AND (services like '%$services%') AND (maxclients > '$maxclients') AND (comments like '%$comments%')";
elseif ($t == "mlsl") :
$query = "SELECT * FROM $table WHERE (name like '%$name%') AND (website like '%$website%') AND (servers < '$servers') AND (location like '%$location%') AND (services like '%$services%') AND (maxclients < '$maxclients') AND (comments like '%$comments%')";
elseif ($t == "mesl") :
$query = "SELECT * FROM $table WHERE (name like '%$name%') AND (website like '%$website%') AND (servers < '$servers') AND (location like '%$location%') AND (services like '%$services%') AND (maxclients = '$maxclients') AND (comments like '%$comments%')";
elseif ($t == "mgsl") :
$query = "SELECT * FROM $table WHERE (name like '%$name%') AND (website like '%$website%') AND (servers < '$servers') AND (location like '%$location%') AND (services like '%$services%') AND (maxclients > '$maxclients') AND (comments like '%$comments%')";
elseif ($t == "mlse") :
$query = "SELECT * FROM $table WHERE (name like '%$name%') AND (website like '%$website%') AND (servers = '$servers') AND (location like '%$location%') AND (services like '%$services%') AND (maxclients < '$maxclients') AND (comments like '%$comments%')";
elseif ($t == "mese") :
$query = "SELECT * FROM $table WHERE (name like '%$name%') AND (website like '%$website%') AND (servers = '$servers') AND (location like '%$location%') AND (services like '%$services%') AND (maxclients = '$maxclients') AND (comments like '%$comments%')";
elseif ($t == "mgse") :
$query = "SELECT * FROM $table WHERE (name like '%$name%') AND (website like '%$website%') AND (servers = '$servers') AND (location like '%$location%') AND (services like '%$services%') AND (maxclients > '$maxclients') AND (comments like '%$comments%')";
elseif ($t == "mlsg") :
$query = "SELECT * FROM $table WHERE (name like '%$name%') AND (website like '%$website%') AND (servers > '$servers') AND (location like '%$location%') AND (services like '%$services%') AND (maxclients < '$maxclients') AND (comments like '%$comments%')";
elseif ($t == "mesg") :
$query == "SELECT * FROM $table WHERE (name like '%$name%') AND (website like '%$website%') AND (servers > '$servers') AND (location like '%$location%') AND (services like '%$services%') AND (maxclients = '$maxclients') AND (comments like '%$comments%')";
elseif ($t == "mgsg") :
$query = "SELECT * FROM $table WHERE (name like '%$name%') AND (website like '%$website%') AND (servers > '$servers') AND (location like '%$location%') AND (services like '%$services%') AND (maxclients > '$maxclients') AND (comments like '%$comments%')";
elseif ($t == "b") :
$query = "SELECT * FROM $table WHERE (name like '%$name%') AND (website like '%$website%') AND (servers like '%$servers%') AND (location like '%$location%') AND (services like '%$services%') AND (maxclients like '%$maxclients%') AND (comments like '%$comments%')";
endif;
if (isset($order) == true) :
if ($order != "") :
$query = $query . " order by $order $direction, name";
endif;
endif;
$query = $query . " limit $limit, $npp";
$result = MYSQL_QUERY($query);
$number = MYSQL_NUMROWS($result);
$i = 0;
IF ($number == 0) :
PRINT " No Networks matched your search! ";
ELSEIF ($number > 0) :
if ($number == 1) :
PRINT "$n network matched your search.
";
elseif ($number > 1) :
PRINT " $n networks matched your search.";
if ($p != $np) :
$top = $p * $npp;
else :
$top = $limit + $number;
endif;
$limit++;
PRINT "Displaying matches $limit to $top.
";
endif;
PRINT " ";
PRINT "| Network Name | No. of Servers | Max Clients | ";
WHILE ($i < $number):
$name1 = mysql_result($result,$i,"name");
$website1 = mysql_result($result,$i,"website");
$servers1 = mysql_result($result,$i,"servers");
$location1 = mysql_result($result,$i,"location");
$services1 = mysql_result($result,$i,"services");
$maxclients1 = mysql_result($result,$i,"maxclients");
$comments1 = mysql_result($result,$i,"comments");
PRINT "| $name1 | $servers1 | $maxclients1 | ";
PRINT "| $services1 | List Servers | ";
PRINT "| $location1 | ";
PRINT "| $comments1 | ";
if ($number > 1) :
PRINT "| | ";
endif;
$i++;
ENDWHILE;
PRINT " ";
if ($np > 1) :
if ($p > 1) :
$p--;
PRINT "Previous";
$p++;
endif;
$i1 = 1;
while ($i1 <= $np) :
PRINT " Page $i1 ";
$i1++;
endwhile;
if ($p < $np) :
$p++;
PRINT "Next";
endif;
endif;
PRINT "";
ENDIF;
MYSQL_CLOSE();
?>
|
|
|
