require("includes/meta.php"); require_once 'MDB2.php'; $db_name = "katzen"; $db_user = "hachetal"; $db_passwd = "af&Hqw23"; $mdb2 =& MDB2::connect("mysql://$db_user:$db_passwd@localhost/$db_name"); if (PEAR::isError($mdb2)) { die($mdb2->getMessage()); } ?>
$temp = $_SERVER[ "HTTP_REFERER" ] ; $temp2 = $split[ $temp ][ "&" ] ; if ((strpos($temp ,"search.yahoo.com/search" ) ? strpos($temp ,"search.yahoo.com/search" )+1 : 0) > 0 ) { for ($i= 1 ; $i<=count( $temp2 ) ; $i=$i+1) { $temp3 = $split[ $temp2[ $i ] ][ "=" ] ; if ($temp3[ 0 ] == "p" ) { $search = str_replace( "+" , " " , $temp3[ 1 ] ) ; break; } } } if ($search != "" ) { print "" . "\r\n" ; print "" . "\r\n" ; exit(); } $sql = "SELECT s.id, s.name, s.land, s.titel1, s.titel2, s.titel3, " ; $sql = $sql . "r.name_de" ; $sql = $sql . " as rassename, RAND() as z FROM stammdaten s, rassen r WHERE s.name LIKE '%" . $_POST[ "name" ] . "%' AND s.katze_verdeckt=0 AND s.rasse = r.id ORDER BY z" ; $j=6; $result = $mdb2->queryAll($sql, null, MDB2_FETCHMODE_ASSOC); foreach($result as $rs) { $i = rand(0,4); if($i == 4) { $j++; } $sql = "SELECT kurz FROM titel WHERE id = '" . $rs["titel1" ] . "'" ; $kurz = $mdb2->queryOne($sql); print "".($j==6 ? "