Please enter a search parameter " ; exit(); } if (($len<1)) { echo "Please enter at least 3 characters " ; exit(); } $query = "SELECT npc_templateid, locx, locy, locz, npc. id, name, level FROM spawnlist, npc WHERE npc_templateid = npc.id AND (name like '%$name%' or level = '$name') limit 1000 "; echo "

"; echo "

"; $result = mysql_query($query); $i=0; while (mysql_fetch_row($result)>$i){ $mname=mysql_result($result,$i,5); $valx=mysql_result($result,$i,1); $valy=mysql_result($result,$i,2); $valz=mysql_result($result,$i,3); $level=mysql_result($result,$i,6); $x=($valx + 125000)/200; $y=($valy + 240500)/200; if ($level>=1 and $level<=9) $target =("map/2.png"); elseif ($level>=10 and $level<=19) $target=("map/7.png"); elseif ($level>=20 and $level<=29) $target=("map/3.png"); elseif ($level>=30 and $level<=39) $target=("map/1.png"); elseif ($level>=40 and $level<=49) $target=("map/0.png"); elseif ($level>=50 and $level<=59) $target=("map/4.png"); elseif ($level>=60 and $level<=69) $target=("map/5.png"); elseif ($level>=70 and $level<=85) $target=("map/6.png"); if ($valx<>0) { echo "

"; echo " $\"$mname$ "; echo "

"; } $i++; } $conn=mysql_close(); ?>