# HG changeset patch # User Dan # Date 1210218986 14400 # Node ID fcc1eac04772cd76d4f4c0d92def52dcff82c4dc # Parent 8f62a406d9d95fff285fe60d07efadb3cfe960cf Prepped for public distribution. diff -r 8f62a406d9d9 -r fcc1eac04772 LICENSE --- /dev/null Thu Jan 01 00:00:00 1970 +0000 +++ b/LICENSE Wed May 07 23:56:26 2008 -0400 @@ -0,0 +1,324 @@ +The GNU General Public License (GPL) + +Version 2, June 1991 + +Copyright (C) 1989, 1991 Free Software Foundation, Inc. +59 Temple Place, Suite 330, Boston, MA 02111-1307 USA + +Everyone is permitted to copy and distribute verbatim copies of this license +document, but changing it is not allowed. + +Preamble + +The licenses for most software are designed to take away your freedom to share +and change it. By contrast, the GNU General Public License is intended to +guarantee your freedom to share and change free software--to make sure the +software is free for all its users. This General Public License applies to +most of the Free Software Foundation's software and to any other program whose +authors commit to using it. (Some other Free Software Foundation software is +covered by the GNU Library General Public License instead.) You can apply it to +your programs, too. + +When we speak of free software, we are referring to freedom, not price. Our +General Public Licenses are designed to make sure that you have the freedom to +distribute copies of free software (and charge for this service if you wish), +that you receive source code or can get it if you want it, that you can change +the software or use pieces of it in new free programs; and that you know you +can do these things. + +To protect your rights, we need to make restrictions that forbid anyone to deny +you these rights or to ask you to surrender the rights. These restrictions +translate to certain responsibilities for you if you distribute copies of the +software, or if you modify it. + +For example, if you distribute copies of such a program, whether gratis or for +a fee, you must give the recipients all the rights that you have. You must +make sure that they, too, receive or can get the source code. And you must +show them these terms so they know their rights. + +We protect your rights with two steps: (1) copyright the software, and (2) +offer you this license which gives you legal permission to copy, distribute +and/or modify the software. + +Also, for each author's protection and ours, we want to make certain that +everyone understands that there is no warranty for this free software. If the +software is modified by someone else and passed on, we want its recipients to +know that what they have is not the original, so that any problems introduced +by others will not reflect on the original authors' reputations. + +Finally, any free program is threatened constantly by software patents. We +wish to avoid the danger that redistributors of a free program will +individually obtain patent licenses, in effect making the program proprietary. +To prevent this, we have made it clear that any patent must be licensed for +everyone's free use or not licensed at all. + +The precise terms and conditions for copying, distribution and modification +follow. + +TERMS AND CONDITIONS FOR COPYING, DISTRIBUTION AND MODIFICATION + +0. This License applies to any program or other work which contains a notice +placed by the copyright holder saying it may be distributed under the terms of +this General Public License. The "Program", below, refers to any such program +or work, and a "work based on the Program" means either the Program or any +derivative work under copyright law: that is to say, a work containing the +Program or a portion of it, either verbatim or with modifications and/or +translated into another language. (Hereinafter, translation is included +without limitation in the term "modification".) Each licensee is addressed as +"you". + +Activities other than copying, distribution and modification are not covered by +this License; they are outside its scope. The act of running the Program is +not restricted, and the output from the Program is covered only if its contents +constitute a work based on the Program (independent of having been made by +running the Program). Whether that is true depends on what the Program does. + +1. You may copy and distribute verbatim copies of the Program's source code as +you receive it, in any medium, provided that you conspicuously and +appropriately publish on each copy an appropriate copyright notice and +disclaimer of warranty; keep intact all the notices that refer to this License +and to the absence of any warranty; and give any other recipients of the +Program a copy of this License along with the Program. + +You may charge a fee for the physical act of transferring a copy, and you may +at your option offer warranty protection in exchange for a fee. + +2. You may modify your copy or copies of the Program or any portion of it, thus +forming a work based on the Program, and copy and distribute such modifications +or work under the terms of Section 1 above, provided that you also meet all of +these conditions: + + a) You must cause the modified files to carry prominent notices stating + that you changed the files and the date of any change. + + b) You must cause any work that you distribute or publish, that in whole or + in part contains or is derived from the Program or any part thereof, to be + licensed as a whole at no charge to all third parties under the terms of + this License. + + c) If the modified program normally reads commands interactively when run, + you must cause it, when started running for such interactive use in the + most ordinary way, to print or display an announcement including an + appropriate copyright notice and a notice that there is no warranty (or + else, saying that you provide a warranty) and that users may redistribute + the program under these conditions, and telling the user how to view a copy + of this License. (Exception: if the Program itself is interactive but does + not normally print such an announcement, your work based on the Program is + not required to print an announcement.) + +These requirements apply to the modified work as a whole. If identifiable +sections of that work are not derived from the Program, and can be reasonably +considered independent and separate works in themselves, then this License, and +its terms, do not apply to those sections when you distribute them as separate +works. But when you distribute the same sections as part of a whole which is a +work based on the Program, the distribution of the whole must be on the terms +of this License, whose permissions for other licensees extend to the entire +whole, and thus to each and every part regardless of who wrote it. + +Thus, it is not the intent of this section to claim rights or contest your +rights to work written entirely by you; rather, the intent is to exercise the +right to control the distribution of derivative or collective works based on +the Program. + +In addition, mere aggregation of another work not based on the Program with the +Program (or with a work based on the Program) on a volume of a storage or +distribution medium does not bring the other work under the scope of this +License. + +3. You may copy and distribute the Program (or a work based on it, under +Section 2) in object code or executable form under the terms of Sections 1 and +2 above provided that you also do one of the following: + + a) Accompany it with the complete corresponding machine-readable source + code, which must be distributed under the terms of Sections 1 and 2 above + on a medium customarily used for software interchange; or, + + b) Accompany it with a written offer, valid for at least three years, to + give any third party, for a charge no more than your cost of physically + performing source distribution, a complete machine-readable copy of the + corresponding source code, to be distributed under the terms of Sections 1 + and 2 above on a medium customarily used for software interchange; or, + + c) Accompany it with the information you received as to the offer to + distribute corresponding source code. (This alternative is allowed only + for noncommercial distribution and only if you received the program in + object code or executable form with such an offer, in accord with + Subsection b above.) + +The source code for a work means the preferred form of the work for making +modifications to it. For an executable work, complete source code means all +the source code for all modules it contains, plus any associated interface +definition files, plus the scripts used to control compilation and installation +of the executable. However, as a special exception, the source code +distributed need not include anything that is normally distributed (in either +source or binary form) with the major components (compiler, kernel, and so on) +of the operating system on which the executable runs, unless that component +itself accompanies the executable. + +If distribution of executable or object code is made by offering access to copy +from a designated place, then offering equivalent access to copy the source +code from the same place counts as distribution of the source code, even though +third parties are not compelled to copy the source along with the object code. + +4. You may not copy, modify, sublicense, or distribute the Program except as +expressly provided under this License. Any attempt otherwise to copy, modify, +sublicense or distribute the Program is void, and will automatically terminate +your rights under this License. However, parties who have received copies, or +rights, from you under this License will not have their licenses terminated so +long as such parties remain in full compliance. + +5. You are not required to accept this License, since you have not signed it. +However, nothing else grants you permission to modify or distribute the Program +or its derivative works. These actions are prohibited by law if you do not +accept this License. Therefore, by modifying or distributing the Program (or +any work based on the Program), you indicate your acceptance of this License to +do so, and all its terms and conditions for copying, distributing or modifying +the Program or works based on it. + +6. Each time you redistribute the Program (or any work based on the Program), +the recipient automatically receives a license from the original licensor to +copy, distribute or modify the Program subject to these terms and conditions. +You may not impose any further restrictions on the recipients' exercise of the +rights granted herein. You are not responsible for enforcing compliance by +third parties to this License. + +7. If, as a consequence of a court judgment or allegation of patent +infringement or for any other reason (not limited to patent issues), conditions +are imposed on you (whether by court order, agreement or otherwise) that +contradict the conditions of this License, they do not excuse you from the +conditions of this License. If you cannot distribute so as to satisfy +simultaneously your obligations under this License and any other pertinent +obligations, then as a consequence you may not distribute the Program at all. +For example, if a patent license would not permit royalty-free redistribution +of the Program by all those who receive copies directly or indirectly through +you, then the only way you could satisfy both it and this License would be to +refrain entirely from distribution of the Program. + +If any portion of this section is held invalid or unenforceable under any +particular circumstance, the balance of the section is intended to apply and +the section as a whole is intended to apply in other circumstances. + +It is not the purpose of this section to induce you to infringe any patents or +other property right claims or to contest validity of any such claims; this +section has the sole purpose of protecting the integrity of the free software +distribution system, which is implemented by public license practices. Many +people have made generous contributions to the wide range of software +distributed through that system in reliance on consistent application of that +system; it is up to the author/donor to decide if he or she is willing to +distribute software through any other system and a licensee cannot impose that +choice. + +This section is intended to make thoroughly clear what is believed to be a +consequence of the rest of this License. + +8. If the distribution and/or use of the Program is restricted in certain +countries either by patents or by copyrighted interfaces, the original +copyright holder who places the Program under this License may add an explicit +geographical distribution limitation excluding those countries, so that +distribution is permitted only in or among countries not thus excluded. In +such case, this License incorporates the limitation as if written in the body +of this License. + +9. The Free Software Foundation may publish revised and/or new versions of the +General Public License from time to time. Such new versions will be similar in +spirit to the present version, but may differ in detail to address new problems +or concerns. + +Each version is given a distinguishing version number. If the Program +specifies a version number of this License which applies to it and "any later +version", you have the option of following the terms and conditions either of +that version or of any later version published by the Free Software Foundation. +If the Program does not specify a version number of this License, you may +choose any version ever published by the Free Software Foundation. + +10. If you wish to incorporate parts of the Program into other free programs +whose distribution conditions are different, write to the author to ask for +permission. For software which is copyrighted by the Free Software Foundation, +write to the Free Software Foundation; we sometimes make exceptions for this. +Our decision will be guided by the two goals of preserving the free status of +all derivatives of our free software and of promoting the sharing and reuse of +software generally. + +NO WARRANTY + +11. BECAUSE THE PROGRAM IS LICENSED FREE OF CHARGE, THERE IS NO WARRANTY FOR +THE PROGRAM, TO THE EXTENT PERMITTED BY APPLICABLE LAW. EXCEPT WHEN OTHERWISE +STATED IN WRITING THE COPYRIGHT HOLDERS AND/OR OTHER PARTIES PROVIDE THE +PROGRAM "AS IS" WITHOUT WARRANTY OF ANY KIND, EITHER EXPRESSED OR IMPLIED, +INCLUDING, BUT NOT LIMITED TO, THE IMPLIED WARRANTIES OF MERCHANTABILITY AND +FITNESS FOR A PARTICULAR PURPOSE. THE ENTIRE RISK AS TO THE QUALITY AND +PERFORMANCE OF THE PROGRAM IS WITH YOU. SHOULD THE PROGRAM PROVE DEFECTIVE, +YOU ASSUME THE COST OF ALL NECESSARY SERVICING, REPAIR OR CORRECTION. + +12. IN NO EVENT UNLESS REQUIRED BY APPLICABLE LAW OR AGREED TO IN WRITING WILL +ANY COPYRIGHT HOLDER, OR ANY OTHER PARTY WHO MAY MODIFY AND/OR REDISTRIBUTE THE +PROGRAM AS PERMITTED ABOVE, BE LIABLE TO YOU FOR DAMAGES, INCLUDING ANY +GENERAL, SPECIAL, INCIDENTAL OR CONSEQUENTIAL DAMAGES ARISING OUT OF THE USE OR +INABILITY TO USE THE PROGRAM (INCLUDING BUT NOT LIMITED TO LOSS OF DATA OR DATA +BEING RENDERED INACCURATE OR LOSSES SUSTAINED BY YOU OR THIRD PARTIES OR A +FAILURE OF THE PROGRAM TO OPERATE WITH ANY OTHER PROGRAMS), EVEN IF SUCH HOLDER +OR OTHER PARTY HAS BEEN ADVISED OF THE POSSIBILITY OF SUCH DAMAGES. + +END OF TERMS AND CONDITIONS + +How to Apply These Terms to Your New Programs + +If you develop a new program, and you want it to be of the greatest possible +use to the public, the best way to achieve this is to make it free software +which everyone can redistribute and change under these terms. + +To do so, attach the following notices to the program. It is safest to attach +them to the start of each source file to most effectively convey the exclusion +of warranty; and each file should have at least the "copyright" line and a +pointer to where the full notice is found. + + One line to give the program's name and a brief idea of what it does. + + Copyright (C) + + This program is free software; you can redistribute it and/or modify it + under the terms of the GNU General Public License as published by the Free + Software Foundation; either version 2 of the License, or (at your option) + any later version. + + This program is distributed in the hope that it will be useful, but WITHOUT + ANY WARRANTY; without even the implied warranty of MERCHANTABILITY or + FITNESS FOR A PARTICULAR PURPOSE. See the GNU General Public License for + more details. + + You should have received a copy of the GNU General Public License along + with this program; if not, write to the Free Software Foundation, Inc., 59 + Temple Place, Suite 330, Boston, MA 02111-1307 USA + +Also add information on how to contact you by electronic and paper mail. + +If the program is interactive, make it output a short notice like this when it +starts in an interactive mode: + + Gnomovision version 69, Copyright (C) year name of author Gnomovision comes + with ABSOLUTELY NO WARRANTY; for details type 'show w'. This is free + software, and you are welcome to redistribute it under certain conditions; + type 'show c' for details. + +The hypothetical commands 'show w' and 'show c' should show the appropriate +parts of the General Public License. Of course, the commands you use may be +called something other than 'show w' and 'show c'; they could even be +mouse-clicks or menu items--whatever suits your program. + +You should also get your employer (if you work as a programmer) or your school, +if any, to sign a "copyright disclaimer" for the program, if necessary. Here +is a sample; alter the names: + + Yoyodyne, Inc., hereby disclaims all copyright interest in the program + 'Gnomovision' (which makes passes at compilers) written by James Hacker. + + signature of Ty Coon, 1 April 1989 + + Ty Coon, President of Vice + +This General Public License does not permit incorporating your program into +proprietary programs. If your program is a subroutine library, you may +consider it more useful to permit linking proprietary applications with the +library. If this is what you want to do, use the GNU Library General Public +License instead of this License. + diff -r 8f62a406d9d9 -r fcc1eac04772 README --- /dev/null Thu Jan 01 00:00:00 1970 +0000 +++ b/README Wed May 07 23:56:26 2008 -0400 @@ -0,0 +1,77 @@ +EnanoBot - the Enano CMS IRC bot +Copyright (c) 2008 Dan Fuhry + + This program is free software; you can redistribute it and/or modify it + under the terms of the GNU General Public License as published by the Free + Software Foundation; either version 2 of the License, or (at your option) + any later version. + + This program is distributed in the hope that it will be useful, but WITHOUT + ANY WARRANTY; without even the implied warranty of MERCHANTABILITY or + FITNESS FOR A PARTICULAR PURPOSE. See the GNU General Public License for + more details. + + You should have received a copy of the GNU General Public License along + with this program; if not, write to the Free Software Foundation, Inc., 59 + Temple Place, Suite 330, Boston, MA 02111-1307 USA + +EnanoBot is a bot I wrote for the Enano CMS IRC channel in #enano on freenode. It's +written in CLI PHP and you need to have shell access, a MySQL server, and a host +with a very permissive TOU or a reliable home connection to run this bot. + +FEATURES +-------------------- + + - Basic logging + - Privileged users - automatically opped and can speak through the bot, among + other things + - Snippets - use for automated help + - Web-based log viewer + - Web-based snippet manager + +REQUIREMENTS +-------------------- + + - MySQL server + - SSH access + - PHP on your shell server + - Working Enano installation + - The MySQL user Enano uses needs to have access to EnanoBot's database if it's + not the same one that you're using for Enano + +NOTE ON ISP RESTRICTIONS +-------------------- + +A lot of ISPs (webhosts) prohibit running IRC bots from your shell account. Check +with their terms of use before you enable this thing. Because this project is under +the GPL there is of course no warranty for it, and nobody from the Enano Project +can be responsible for your use of this bot. So make sure it's OK before you try to +run it. + +INSTALLING +-------------------- + +Copy config-sample.php to config.php and edit it. Then put irclogs.php and +snippets.php wherever your Enano installation is. You could probably modify snippets +to not use Enano pretty easily but securing it would be your job. Edit both irclogs +and snippets to set the EnanoBot root directory (where your config and enanobot.php +are). DO NOT put enanobot.php and config.php in your document root - you WILL get +hacked. + +To start it, run: + + $ php enanobot.php + +You may find it useful to make sure that it restarts if it dies. Once you've started +the bot and confirmed that it works, do something like: (and this is really hackish) + + $ while true; do php enanobot.php; done & + +This all assumes that you're on a Unix-based server. Things will be different on +Windows. + +AUTHOR +-------------------- + +Dan Fuhry + diff -r 8f62a406d9d9 -r fcc1eac04772 irclogs.php --- /dev/null Thu Jan 01 00:00:00 1970 +0000 +++ b/irclogs.php Wed May 07 23:56:26 2008 -0400 @@ -0,0 +1,329 @@ +load_theme('oxygen', 'bleu'); + +$template->header(); + +$q = $db->sql_query('USE `' . $mysql_dbname . '`;'); +if ( !$q ) + $db->_die(); + +$days_in_month = array( + 1 => 31, + 2 => ( intval(date('Y')) % 4 == 0 ? 29 : 28 ), + 3 => 31, + 4 => 30, + 5 => 31, + 6 => 30, + 7 => 31, + 8 => 31, + 9 => 30, + 10 => 31, + 11 => 30, + 12 => 31 + ); + +function irc_make_calendar($year = 0, $month = 0, $days_to_link = array()) +{ + global $session; + global $days_in_month, $channel; + + if ( $year < 1970 || $month < 1 || $month > 12 ) + { + $year = intval(date('Y')); + $month = intval(date('n')); + } + + $month = intval($month); + $year = intval($year); + + $this_month = mktime(0, 0, 1, $month, 1, $year); + + $next_month = mktime(0, 0, 1, ( $month + 1 ), 1, $year); + $next_year = mktime(0, 0, 1, $month, 1, ( $year + 1 ) ); + $prev_month = mktime(0, 0, 1, ( $month - 1 ), 1, $year); + $prev_year = mktime(0, 0, 1, $month, 1, ( $year - 1 ) ); + + $a_next_month = '>'; + $a_next_year = '>>'; + $a_prev_month = ( $year == 1970 && $month == 1 ) ? '<' : '<'; + $a_prev_year = ( $year == 1970 ) ? '<<' : '<<'; + + $dow = intval(date('w', $this_month)); + + $return = ''; + + $return .= '
+ + + + '; + + $return .= ''; + $class = 'row1'; + for ( $i = 0; $i < $dow; $i++ ) + { + $class = ( $class == 'row1' ) ? 'row3' : 'row1'; + $return .= ''; + } + + if ( $month == 2 ) + { + $days_in_this_month = ( $year % 4 == 0 ) ? 29 : 28; + } + else + { + $days_in_this_month = $days_in_month[$month]; + } + + for ( $i = 1; $i <= $days_in_this_month; $i++ ) + { + if ( $dow == 7 ) + { + $return .= ''; + if ( $i < $days_in_this_month ) + $return .= ''; + $dow = 0; + } + $dow++; + $class = ( $class == 'row1' ) ? 'row3' : 'row1'; + $a = "$i"; + if ( in_array($i, $days_to_link) ) + { + $a = '' . $i . ''; + } + $return .= ""; + } + + while ( $dow < 7 ) + { + $class = ( $class == 'row1' ) ? 'row3' : 'row1'; + $return .= ""; + $dow++; + } + + $return .= '
' . "$a_prev_year $a_prev_month " . date('F', $this_month) . ' ' . $year . " $a_next_month $a_next_year" . '
$a
'; + return $return; +} + +$get_valid_year = isset($_GET['year']); +$get_valid_month = ( isset($_GET['month']) && intval($_GET['month']) > 0 && intval($_GET['month']) < 13 ); + +$year = ( $get_valid_year ) ? intval($_GET['year']) : intval(date('Y')); +$month = ( $get_valid_month ) ? intval($_GET['month']) : intval(date('n')); + +function make_nick_color($username) +{ + if ( $username == '' ) + return ''; + $hash = substr(sha1($username), 0, 6); + $hash = enano_str_split($hash); + for ( $i = 0; $i < count($hash); $i++ ) + { + if ( $i % 2 == 1 ) + continue; + + // call this a cheap hack or whatever, but intval() doesn't accept 0x???? + $digit = eval("return 0x{$hash[$i]};"); + if ( $digit > 0x9 ) + $digit = "9"; + else + $digit = strval($digit); + $hash[$i] = $digit; + } + $color = implode('', $hash); + $span = "" . htmlspecialchars($username) . ""; + return $span; +} + +function irclog_autoparse_links($text) +{ + $sid = md5(microtime()); + preg_match_all('/((https?|ftp|irc):\/\/([^@\s\]"\':]+)?((([a-z0-9-]+\.)*)[a-z0-9-]+)(\/[A-z0-9_%\|~`!\!@#\$\^&\*\(\):;\.,\/-]*(\?(([a-' + . 'z0-9_-]+)(=[A-z0-9_%\|~`\!@#\$\^&\*\(\):;\.,\/-\[\]]*)?((&([a-z0-9_-]+)(=[A-z0-9_%\|~`!\!@#\$\^&\*\(\):;\.,\/-]*)?)*))' + . '?)?)?)/', $text, $matches); + foreach ( $matches[0] as $i => $match ) + { + $text = str_replace_once($match, "{AUTOLINK:$sid:$i}", $text); + } + $text = htmlspecialchars($text); + foreach ( $matches[0] as $i => $match ) + { + $match_short = $match; + if ( strlen($match) > 75 ) + { + $match_short = htmlspecialchars(substr($match, 0, 25)) . '...' . htmlspecialchars(substr($match, -25)); + } + $match = htmlspecialchars($match); + $text = str_replace_once("{AUTOLINK:$sid:$i}", "$match_short", $text); + } + return $text; +} + +function irclog_protect_emails($text) +{ + global $email; + preg_match_all('/([a-z0-9_-]+@(([a-z0-9-]+\.)*)[a-z0-9-]+)/', $text, $matches); + foreach ( $matches[0] as $match ) + { + $text = str_replace_once($match, $email->encryptEmail($match), $text); + } + return $text; +} + +function irclog_format_row($_, $row) +{ + static $class = 'row1'; + $class = ( $class == 'row1' ) ? 'row3' : 'row1'; + + $time = date('H:i', $row['timestamp']); + $nick = make_nick_color($row['nick']); + + $message = irclog_autoparse_links($row['line']); + $message = irclog_protect_emails($message); + $message = RenderMan::smilieyize($message); + if ( $row['nick'] == '' ) + $message = "" . $message . ""; + return " + $time + $nick + $message + \n"; +} + +if ( $get_valid_year && $get_valid_month && isset($_GET['day']) && isset($_GET['channel']) ) +{ + $days_in_this_month = $days_in_month[$month]; + if ( $month == 2 && $year !== intval(date('n')) ) + $days_in_this_month = ( $year % 4 == 0 ) ? 29 : 28; + $day = intval($_GET['day']); + if ( $day < 1 || $day > $days_in_this_month ) + { + $day = intval(date('j')); + } + // mode is view logs, and we have the date on which to display them + $channel = $db->escape($_GET['channel']); + if ( !preg_match('/^[a-z0-9_-]+$/i', $channel) ) + die('Channel contains XSS attempt'); + + $datekey = $year . '-' . + ( $month < 10 ? "0$month" : $month ) . '-' . + ( $day < 10 ? "0$day" : $day ); + + $q = $db->sql_query("SELECT * FROM irclog WHERE day='$datekey' AND channel = '#$channel' ORDER BY timestamp ASC;"); + if ( !$q ) + $db->_die(); + + echo '

< Back to date listings

'; + + if ( $db->numrows() < 1 ) + { + echo '

No chat logs for today.

'; + } + else + { + $count = $db->numrows(); + + $start = ( isset($_GET['start']) ) ? intval($_GET['start']) : 0; + + // ($q, $tpl_text, $num_results, $result_url, $start = 0, $perpage = 10, $callers = Array(), $header = '', $footer = '') + $html = paginate($q, '{id}', $count, $session->append_sid(scriptPath . "/irclogs.php?year=$year&month=$month&day=$day&channel=$channel&start=%s"), $start, 100, array('id' => 'irclog_format_row'), '

All times are UTC.

', '
'); + + echo $html; + } +} +else if ( isset($_GET['channel']) ) +{ + // show log calendar + $channel = $db->escape($_GET['channel']); + if ( !preg_match('/^[a-z0-9_-]+$/i', $channel) ) + die('Channel contains XSS attempt'); + + echo "

Chat logs for #$channel

"; + + echo '

< Back to channel list

'; + + $year = strval($year); + $month = strval($month); + + if ( $month < 10 ) + $month = "0" . $month; + + $q = $db->sql_query("SELECT day FROM irclog WHERE day LIKE '$year-$month-__' AND channel = '#$channel' GROUP BY day ORDER BY timestamp ASC;"); + if ( !$q ) + $db->_die(); + + $days = array(); + while ( $row = $db->fetchrow() ) + { + if ( !preg_match('/^[0-9]+-[0-9]+-([0-9]+)$/', $row['day'], $match) ) + { + continue; + } + $days[] = intval($match[1]); + } + + echo irc_make_calendar($year, $month, $days); +} +else +{ + // list channels + $q = $db->sql_query("SELECT channel FROM irclog GROUP BY channel;"); + if ( !$q ) + $db->_die(); + echo '

List of available channels

'; + if ( $row = $db->fetchrow() ) + { + echo '

'; + do + { + $channel = preg_replace('/^#/', '', $row['channel']); + echo '' . $row['channel'] . '
'; + } + while ( $row = $db->fetchrow() ); + echo '

'; + } + else + { + echo '

No channels logged.

'; + } +} + +$q = $db->sql_query('USE enano_www;'); +if ( !$q ) + $db->_die(); + +$template->footer(); + diff -r 8f62a406d9d9 -r fcc1eac04772 snippets.php --- /dev/null Thu Jan 01 00:00:00 1970 +0000 +++ b/snippets.php Wed May 07 23:56:26 2008 -0400 @@ -0,0 +1,162 @@ +user_level < USER_LEVEL_ADMIN ) +{ + die_friendly('Access denied', '

Admin rights needed to use this script.

'); +} + +$db->close(); +unset($db, $session, $paths, $template, $plugins); + +// We're authed. +// Load config +require(ENANOBOT_ROOT . 'config.php'); + +// check config +if ( empty($mysql_host) || empty($mysql_user) || empty($mysql_dbname) ) +{ + die("Bad config file - have a look at config-sample.php.\n"); +} + +// connect to MySQL +$mysql_conn = @mysql_connect($mysql_host, $mysql_user, $mysql_pass); +if ( !$mysql_conn ) +{ + $m_e = mysql_error(); + echo "Error connecting to MySQL: $m_e\n"; + exit(1); +} +$q = @mysql_query('USE `' . $mysql_dbname . '`;', $mysql_conn); +if ( !$q ) +{ + $m_e = mysql_error(); + echo "Error selecting database: $m_e\n"; + exit(1); +} + +function mysql_die() +{ + $m_e = mysql_error(); + die("MySQL error: $m_e"); +} + +?> + + + EnanoBot snippet management + + + +

EnanoBot snippet management

+
+
+ Add a snippet + + + + + + + + + + + + + +
Snippet code
+ all lowercase, no spaces; ex: mysnippet
Text
+ anything you want, keep it relatively short.
Channels
+ separate with pipe characters, ex: #enano|#enano-dev|#ubuntu
+
+
+ Edit existing snippets + + + + + + + + $row['snippet_id'], + 'snippet_code' => $_POST['snippet'][$row['snippet_id']]['code'], + 'snippet_text' => $_POST['snippet'][$row['snippet_id']]['text'], + 'snippet_channels' => $_POST['snippet'][$row['snippet_id']]['channels'] + ); + } + } + } + echo ' '; + echo ''; + echo ''; + echo ''; + echo ''; + echo '' . "\n "; + } + ?>
CodeSnippet textChannelsDelete
+
+
+ +
+
+ +