Indie-Resource.com

Code: Select all

/* These variables came from a run of the mill form POST.  Each is a separate field so I can do a very variable search of potential pvp targets or the like. I feel them to be pretty self explanatory as to what they represent except stones which is my game currency and tribe which is sort of like a guild for my project.
*/
$splayer = $_POST['player'];
$slevelmin = $_POST['levelmin'];
$slevelmax = $_POST['levelmax'];
$stribe = $_POST['tribe'];
$sstonemin = $_POST['stonemin'];
$sstonemax = $_POST['stonemax'];

/* if player is blank its picks by name for any player that's not the session player.  if not blank it uses LIKE and  wildcards the searched name
This variable is the only one that I couldn't potentially leave blank for the query because I needed something to AND off of.
*/
if ($splayer == '')
{
$q1= " name <> '$player'";
}
else
{
$q1 = " name LIKE '%$splayer%'";
}
///if level is blank  it will write nothing into the query. if not blank it writes that piece of code for the query.  The rest of these work similar to this//
if ($slevelmin == '')
{
$q2= '';
}
else
{
$q2 = " AND level >=  '$slevelmin' ";
}

if ($slevelmax == '')
{
$q3= '';
}
else
{
$q3 = " AND level <=  '$slevelmax'";
}

if ($stribe == '')
{
$q4= '';
}
else
{
$q4 = " AND tribe LIKE  '%$stribe%' ";
}


if ($sstonemin == '')
{
$q5= '';
}
else
{
$q5 = " AND stonesnow >=  '$sstonemin' ";
}

if ($sstonemax == '')
{
$q6= '';
}
else
{
$q6 = " AND stonesnow <=  '$sstonemax' ";
}
/*
So now we have the query which has all the "q" varibles in place.  $q1 cannot be blank because the rest of it use it as a point to AND off of
Now a player should be able to search any number of the provided fields and come up with a fairly decent result no matter what they fill in or leave blank.
*/

$squery="SELECT name, level, tribe, stonesnow from player where $q1 $q2 $q3 $q4 $q5 $q6 Order by name Limit 25";
$squery2=mysql_query($squery) or die("Found no players that match your request!");

 while($squery3=mysql_fetch_array($squery2))
{

echo "The search information in whatever format" ;
}