<?php
session_start();
mysql_connect("localhost", "name", "pass");
mysql_select_db("database");
//Datenbank mit tabelle 'hirn' und Spalten 'antwort', 'frage'.
$say = urldecode(mysql_real_escape_string($_GET['say']));
//Eingabe
$sql = "SELECT antwort FROM hirn WHERE frage LIKE '%$say%'";
$erg = mysql_query($sql);
$row = mysql_fetch_object($erg);
echo mysql_error();
if (mysql_num_rows($erg) > 0){
$num = mysql_num_rows($erg);
$zufall = rand(1, $num);
while ($row = mysql_fetch_object($erg)) {
$c_say = $row->antwort;
$e++;
if ($e == $zufall) {
break;
}
}
$out = "F (".mysql_num_rows($erg).")-(".$e.") ";
//Phrase erkannt
} else {
$sql = "SELECT antwort FROM hirn WHERE MATCH (frage) AGAINST ('$say' IN BOOLEAN MODE)";
$erg = mysql_query($sql);
$row = mysql_fetch_object($erg);
if (mysql_num_rows($erg)==0){
$sql = "SELECT antwort FROM hirn WHERE MATCH (antwort) AGAINST ('$say' IN BOOLEAN MODE)";
$erg=mysql_query($sql);
$row=mysql_fetch_object($erg);
if (mysql_num_rows($erg) > 0){
if (mysql_num_rows($erg)==1) {
$row = mysql_fetch_object($erg);
$c_say = $row->antwort;
$e=1;
} else {
$num = mysql_num_rows($erg);
$zufall = rand(1, $num);
while ($row = mysql_fetch_object($erg)) {
$c_say = $row->antwort;
$e++;
if ($e == $zufall) {
break;
}
//Match BOOLEAN MODE
}
}
$out = "2 (".mysql_num_rows($erg).")-(".$e.") ";
}else {
$sql="SELECT antwort FROM hirn ORDER BY RAND() LIMIT 1";
$erg=mysql_query($sql);
$row=mysql_fetch_object($erg);
$c_say = $row->antwort;
$out = "z (".mysql_num_rows($erg).") ";
//Zufallsantwort
}
} else {
$num = mysql_num_rows($erg);
$zufall = rand(0, $num);
while ($row = mysql_fetch_object($erg)) {
$c_say = $row->antwort;
$e++;
if ($e == $zufall) {
break;
}
}
$out = "1 (".mysql_num_rows($erg).")-(".$e.") ";
}
}
if ($_SESSION['last']!=""){
$oo=$_SESSION['last'];
$sql="SELECT id FROM hirn WHERE frage='$oo' AND antwort='$say'";
$erg=mysql_query($sql);
if (mysql_num_rows($erg)<1){
$sql="INSERT INTO hirn (frage,antwort) VALUES ('$oo', '$say');";
//mysql_query($sql); //lernen (Auskommentiert, da nicht Jedermann seinen Mist eintragen soll.)
}
}
$_SESSION['last']=$c_say;
//Das zuletzt gesagte merken.
mysql_close();
echo $c_say;
?>