# quotes

Sorted with most recent first. show columns from exeter; +-----------+----------+------+-----+---------+-------+---------------------------------+ | Field | Type | Null | Key | Default | Extra | Privileges | +-----------+----------+------+-----+---------+-------+---------------------------------+ | id | int(11) | YES | | NULL | | select,insert,update,references | | mask | text | YES | | NULL | | select,insert,update,references | | quote | text | YES | | NULL | | select,insert,update,references | | timestamp | datetime | YES | | NULL | | select,insert,update,references | +-----------+----------+------+-----+---------+-------+---------------------------------+ 4 rows in set (0.03 sec) */ } $chan = $channel; $channel = "#" . $channel; if (isset($filter)) { $sql = "SELECT * FROM quotes WHERE quote LIKE '%$filter%' AND channel='$channel' ORDER BY timestamp DESC"; } else { $sql = "SELECT * FROM quotes WHERE channel='$channel' ORDER BY timestamp DESC"; } if ($remote) { $sql .= " LIMIT 20"; } $results = mysql_query($sql); if ($results && mysql_num_rows($results)) { $count = mysql_num_rows($results); if (!$remote) { $quoted = array(); $quoter = array(); echo ""; echo ""; $class = 0; } if (!empty($page)) { mysql_data_seek($results, $page * 100); } else { $page = 0; } $counter = 0; while (($quote = mysql_fetch_object($results)) && ($counter < 100)) { if (!$remote) { $counter++; echo ""; echo ""; if (empty($quoter[$quote->nick])) { $quoter[$quote->nick] = 1; } else { $quoter[$quote->nick]++; } $quote_text = htmlentities($quote->quote); $quotes = @preg_split("/ \| /", $quote_text); $newquote = ""; foreach ($quotes as $q) { $q = trim($q); //no timestamps $q = preg_replace('/^\[?[0-9:.]+\]?/', '', $q); //$q = preg_replace('/^((<|\\[|\$)*.*?)( )(.*?(>|\\]|\$)+:?)/', "\\1 \\4", $q); //hilight nicks if (!preg_match("/^\* /", $q)) { if (preg_match('/^((<|\\[|\$)*[@%+]?([^\]>\\$]+?)[@%+]?(>|\\]|\\))+:?)/', $q, $matches)) { if (empty($quoted[$matches[3]])) { $quoted[$matches[3]] = 1; } else { $quoted[$matches[3]] = $quoted[$matches[3]] + 1; } } $q = preg_replace('/^((<|\\[|\$)*[^\]>\\$]+?(>|\\]|\\))+:?)/', "\\1", $q); } else { if (preg_match('/^\* [@%+]?(\S+)[@%+]?/', $q, $matches)) { if (empty($quoted[$matches[1]])) { $quoted[$matches[1]] = 1; } else { $quoted[$matches[1]] = $quoted[$matches[1]] + 1; } } $q = preg_replace('/^\* (\S+)/', "* \\1", $q); } //$newquote .= preg_replace('/ /', " ", $q); $newquote .= $q; $newquote .= "
"; } $quote_text = preg_replace('/ \| /', "
", $quote_text); echo ""; echo ""; } else { //remote echo $quote->quote . "\n"; } } if (!$remote) { echo "

#	Added by	When	Quote
id\">id\">" . $quote->id . "	"; echo "host . "\">"; echo $quote->nick; echo ""; echo "	"; echo date("H:i j M y", $quote->timestamp); echo "	" . $newquote . "

"; echo "$count results
"; if ($page > 0) { echo "<< Prev page "; } if (($counter + ($page * 100)) < $count) { echo "Next page >>"; } echo "

"; echo ""; echo "

"; arsort($quoted); $i = 0; echo "

Top 5 Quoted

"; echo "on this page of results

"; foreach($quoted as $q => $count) { echo "$q was quoted $count times
"; if (++$i > 5) { break; } } echo "

"; echo "

Top 5 Quoters

"; echo "on this page of results

"; arsort($quoter); $i = 0; foreach($quoter as $q => $count) { echo "$q added $count quotes
"; if (++$i > 5) { break; } } echo "

"; } } else echo "oops: no results
" . mysql_error(); if ($remote) { exit; } $result = mysql_query("SELECT DISTINCT channel FROM quotes ORDER BY channel"); echo "

Other channels
:: "; while ($chan = mysql_fetch_object($result)) { $chanlink = preg_replace("/#(.+)/", "\\1", $chan->channel); echo "$chan->channel :: "; } ?>