Prepped for public distribution.
authorDan
Wed, 07 May 2008 23:56:26 -0400
changeset 5 fcc1eac04772
parent 4 8f62a406d9d9
child 6 a802bb5b3e08
Prepped for public distribution.
LICENSE
README
irclogs.php
snippets.php
--- /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) <year> <name of author>
+
+    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.
+
--- /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 <dan@enanocms.org>
+
--- /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 @@
+<?php
+
+/**
+ * EnanoBot - copyright (C) 2008 Dan Fuhry
+ * All rights reserved.
+ */
+
+/*****************************************************************
+ * YOU NEED TO SET THE PATH TO THE REST OF THE EnanoBot FILES HERE.
+ * Include a trailing slash.
+ * This script MUST be placed in an Enano installation directory.
+ *****************************************************************/
+
+define('ENANOBOT_ROOT', './');
+
+// 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");
+}
+
+$title_append = '';
+if ( isset($_GET['channel']) )
+  $title_append .= ' - #' . $_GET['channel'];
+
+$title = "Enano IRC logs$title_append";
+require('includes/common.php');
+
+// unset($template);
+// $template = new template();
+// $template->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 href="' . htmlspecialchars($session->append_sid(scriptPath . '/irclogs.php?year=' . date('Y', $next_month) . '&month=' . date('n', $next_month) . '&channel=' . $channel)) . '">&gt;</a>';
+  $a_next_year = '<a href="' . htmlspecialchars($session->append_sid(scriptPath . '/irclogs.php?year=' . date('Y', $next_year) . '&month=' . $month . '&channel=' . $channel)) . '">&gt;&gt;</a>';
+  $a_prev_month = ( $year == 1970 && $month == 1 ) ? '&lt;' : '<a href="' . htmlspecialchars($session->append_sid(scriptPath . '/irclogs.php?year=' . date('Y', $prev_month) . '&month=' . date('n', $prev_month) . '&channel=' . $channel)) . '">&lt;</a>';
+  $a_prev_year  = ( $year == 1970 ) ? '&lt;&lt;' : '<a href="' . htmlspecialchars($session->append_sid(scriptPath . '/irclogs.php?year=' . date('Y', $prev_year) . '&month=' . $month . '&channel=' . $channel)) . '">&lt;&lt;</a>';
+  
+  $dow = intval(date('w', $this_month));
+  
+  $return = '';
+  
+  $return .= '<div class="tblholder" style="display: table; text-align: center;">
+          <table border="0" cellspacing="1" cellpadding="6">
+            <tr>
+              <th colspan="7">' . "$a_prev_year $a_prev_month " . date('F', $this_month) . ' ' . $year . " $a_next_month $a_next_year" . '</th>
+            </tr>';
+  
+  $return .= '<tr>';
+  $class = 'row1';
+  for ( $i = 0; $i < $dow; $i++ )
+  {
+    $class = ( $class == 'row1' ) ? 'row3' : 'row1';
+    $return .= '<td class="' . $class . '"></td>';
+  }
+  
+  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 .= '</tr>';
+      if ( $i < $days_in_this_month )
+        $return .= '<tr>';
+      $dow = 0;
+    }
+    $dow++;
+    $class = ( $class == 'row1' ) ? 'row3' : 'row1';
+    $a = "<span style=\"color: #808080;\">$i</span>";
+    if ( in_array($i, $days_to_link) )
+    {
+      $a = '<a class="wikilink-nonexistent" href="' . htmlspecialchars($session->append_sid(scriptPath . '/irclogs.php?year=' . $year . '&month=' . $month . '&day=' . $i . '&channel=' . $channel)) . '"><b>' . $i . '</b></a>';
+    }
+    $return .= "<td class=\"$class\">$a</td>";
+  }
+  
+  while ( $dow < 7 )
+  {
+    $class = ( $class == 'row1' ) ? 'row3' : 'row1';
+    $return .= "<td class=\"$class\"></td>";
+    $dow++;
+  }
+
+  $return .= '</table></div>';
+  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 = "<span style=\"color: #$color;\">" . htmlspecialchars($username) . "</span>";
+  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}", "<a href=\"$match\">$match_short</a>", $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 = "<span style=\"color: #808080;\">" . $message . "</span>";
+  return "              <tr>
+            <td class=\"$class\">$time</td>
+            <td class=\"$class\">$nick</td>
+            <td class=\"$class\">$message</td>
+          </tr>\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 '<p><a href="' . htmlspecialchars($session->append_sid(scriptPath . "/irclogs.php?year=$year&month=$month&channel=$channel")) . '">&lt; Back to date listings</a></p>';
+  
+  if ( $db->numrows() < 1 )
+  {
+    echo '<p>No chat logs for today.</p>';
+  }
+  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'), '<p>All times are UTC.</p><div class="tblholder"><table border="0" cellspacing="1" cellpadding="4">', '</table></div>');
+    
+    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 "<h3>Chat logs for #$channel</h3>";
+  
+  echo '<p><a href="' . htmlspecialchars($session->append_sid(scriptPath . "/irclogs.php")) . '">&lt; Back to channel list</a></p>';
+
+  $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 '<h3>List of available channels</h3>';
+  if ( $row = $db->fetchrow() )
+  {
+    echo '<p>';
+    do
+    {
+      $channel = preg_replace('/^#/', '', $row['channel']);
+      echo '<a href="' . htmlspecialchars($session->append_sid(scriptPath . "/irclogs.php?channel={$channel}")) . '">' . $row['channel'] . '</a><br />';
+    }
+    while ( $row = $db->fetchrow() );
+    echo '</p>';
+  }
+  else
+  {
+    echo '<p>No channels logged.</p>';
+  }
+}
+
+$q = $db->sql_query('USE enano_www;');
+if ( !$q )
+  $db->_die();
+
+$template->footer();
+
--- /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 @@
+<?php
+
+/**
+ * EnanoBot - copyright (C) 2008 Dan Fuhry
+ * All rights reserved.
+ */
+
+/*****************************************************************
+ * YOU NEED TO SET THE PATH TO THE REST OF THE EnanoBot FILES HERE.
+ * Include a trailing slash.
+ * This script MUST be placed in an Enano installation directory.
+ *****************************************************************/
+
+define('ENANOBOT_ROOT', './');
+
+// load Enano for auth
+require('includes/common.php');
+if ( $session->user_level < USER_LEVEL_ADMIN )
+{
+  die_friendly('Access denied', '<p>Admin rights needed to use this script.</p>');
+}
+
+$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");
+}
+
+?><!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.1//EN" "http://www.w3.org/TR/xhtml11/DTD/xhtml11.dtd">
+<html>
+  <head>
+    <title>EnanoBot snippet management</title>
+    <meta http-equiv="Content-type" content="text/html; charset=utf-8" />
+  </head>
+  <body>
+    <h1>EnanoBot snippet management</h1>
+    <form action="enanobot-snippets.php" method="post" enctype="multipart/form-data">
+      <fieldset>
+        <legend>Add a snippet</legend>
+        <table border="1" cellspacing="0" cellpadding="4">
+          <tr>
+            <td>Snippet code<br />
+                <small>all lowercase, no spaces; ex: mysnippet</small></td>
+            <td><input type="text" name="snippet_add_code" size="100" tabindex="1" /></td>
+          </tr>
+          <tr>
+            <td>Text<br />
+                <small>anything you want, keep it relatively short.</small></td>
+            <td><input type="text" name="snippet_add_text" size="100" tabindex="2" /></td>
+          </tr>
+          <tr>
+            <td>Channels<br />
+                <small>separate with pipe characters, ex: #enano|#enano-dev|#ubuntu</small></td>
+            <td><input type="text" name="snippet_add_channels" size="100" tabindex="3" /></td>
+          </tr>
+        </table>
+      </fieldset>
+      <fieldset>
+        <legend>Edit existing snippets</legend>
+        <table border="1" cellspacing="0" cellpadding="4">
+          <tr>
+            <th>Code</th>
+            <th>Snippet text</th>
+            <th>Channels</th>
+            <th>Delete</th>
+          </tr>
+        <?php
+            if ( !empty($_POST['snippet_add_code']) && !empty($_POST['snippet_add_text']) && !empty($_POST['snippet_add_channels']) )
+            {
+              $code = mysql_real_escape_string($_POST['snippet_add_code']);
+              $text = mysql_real_escape_string($_POST['snippet_add_text']);
+              $channels = mysql_real_escape_string($_POST['snippet_add_channels']);
+              $q2 = @mysql_query("INSERT INTO snippets(snippet_code, snippet_text, snippet_channels) VALUES
+                                    ( '$code', '$text', '$channels' );", $mysql_conn);
+              if ( !$q2 )
+                mysql_die();
+            }
+            $q = @mysql_query('SELECT snippet_id, snippet_code, snippet_text, snippet_channels FROM snippets ORDER BY snippet_code ASC;');
+            if ( !$q )
+              mysql_die();
+            while ( $row = @mysql_fetch_assoc($q) )
+            {
+              if ( isset($_POST['snippet']) && @is_array(@$_POST['snippet']) )
+              {
+                if ( isset($_POST['snippet'][$row['snippet_id']]) )
+                {
+                  // delete it?
+                  if ( isset($_POST['snippet'][$row['snippet_id']]['delete']) )
+                  {
+                    $q2 = mysql_query("DELETE FROM snippets WHERE snippet_id = {$row['snippet_id']};", $mysql_conn);
+                    if ( !$q2 )
+                      mysql_die();
+                    continue;
+                  }
+                  // has it changed?
+                  else if ( $_POST['snippet'][$row['snippet_id']]['code'] != $row['snippet_code'] ||
+                       $_POST['snippet'][$row['snippet_id']]['text'] != $row['snippet_text'] ||
+                       $_POST['snippet'][$row['snippet_id']]['channels'] != $row['snippet_channels'] )
+                  {
+                    // yeah, update it.
+                    $code = mysql_real_escape_string($_POST['snippet'][$row['snippet_id']]['code']);
+                    $text = mysql_real_escape_string($_POST['snippet'][$row['snippet_id']]['text']);
+                    $channels = mysql_real_escape_string($_POST['snippet'][$row['snippet_id']]['channels']);
+                    $q2 = mysql_query("UPDATE snippets SET snippet_code = '$code', snippet_text = '$text', snippet_channels = '$channels' WHERE snippet_id = {$row['snippet_id']};", $mysql_conn);
+                    if ( !$q2 )
+                      mysql_die();
+                    $row = array(
+                        'snippet_id' => $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 '  <tr>';
+              echo '<td><input type="text" name="snippet[' . $row['snippet_id'] . '][code]" value="' . htmlspecialchars($row['snippet_code']) . '" /></td>';
+              echo '<td><input type="text" size="100" name="snippet[' . $row['snippet_id'] . '][text]" value="' . htmlspecialchars($row['snippet_text']) . '" /></td>';
+              echo '<td><input type="text" name="snippet[' . $row['snippet_id'] . '][channels]" value="' . htmlspecialchars($row['snippet_channels']) . '" /></td>';
+              echo '<td style="text-align: center;"><input type="checkbox" name="snippet[' . $row['snippet_id'] . '][delete]" /></td>';
+              echo '</tr>' . "\n        ";
+            }
+          ?></table>
+      </fieldset>
+      <div style="text-align: center; margin-top: 20px;">
+        <input type="submit" value="Save changes" />
+      </div>
+    </form>
+  </body>
+</html><?php
+
+mysql_close($mysql_conn);
+