All pastes #81289 Raw Edit

Anonymous

public text v1 · immutable
·published 2006-07-07 09:58 UTC
rendered paste body
<?php
require ('connection.php');
@$name = $_GET["name"]; 
$len=(strlen($name));
if (empty($name)) {
echo "<b>Please enter a search parameter </b>" ;
    exit();
    }
if (($len<1)) {
echo "<b>Please enter at least 3 characters  </b>" ;
    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 "<div style=position:absolute;top:0px;left:0px>";
echo "<img src=map/adenmap.jpg>";
echo "</div>";

$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 "<div style=\"position:absolute;top:".$y."px;left:".$x."px\">";
	echo "<img src=".$target." title=\"$mname x:$valx y:$valy z:$valz lvl:$level\">";
	echo "</div>";
		} 
	
	$i++;
}
$conn=mysql_close(); 
?>