$find = "SELECT * FROM factoids WHERE name='".mysql_real_escape_string($factname)."'"; $result = mysql_query($find) or die(mysql_error()); while ($row = mysql_fetch_assoc($result)) { list($valuetype, $rowvalue) = explode(" ", $row["value"], 2); $date = $row["date"]; $increase = "UPDATE factoids SET requests = requests + 1, date = '$date' WHERE name='".mysql_real_escape_string($factname)."'"; $increquests = mysql_query($increase) or die(mysql_error()); list($var0, $var1, $var2, $var3, $var4, $var5, $var6, $var7, $var8, $var9) = explode(" ", $msgwithoutident, 10); $output = $rowvalue; $output = str_replace('$who', $data->nick, $output); for ($i = 0; $i <= 9; $i++) { $str = 'var' . $i; $output = str_replace('$' . $i, $$str, $output); } if ($valuetype == "") { $irc->message(SMARTIRC_TYPE_ACTION, $data->channel, $output); } elseif ($valuetype == "") { $irc->message(SMARTIRC_TYPE_CHANNEL, $data->channel, $output); } else { $irc->message(SMARTIRC_TYPE_CHANNEL, $data->channel, $factname." is ".$output); } // end if } //end while