[Ircphpstats-devel] [CVS] Module phpstats: Change committed
Status: Inactive
Brought to you by:
mrvolta
Menu
▾
▴
[Ircphpstats-devel] [CVS] Module phpstats: Change committed
|
From: Mr. v. <mr...@us...> - 2003-03-09 21:37:37
|
Committer : volta <mr...@us...>
CVSROOT : /cvsroot/ircphpstats
Module : phpstats
Commit time: 2003-03-09 21:37:34 UTC
Added files:
LICENSE base64.php classes.php command_handlers.php functions.php
sqlfunctions.php tables.sql
Log message:
Initial import
---------------------- diff included ----------------------
Index: phpstats/LICENSE
diff -u /dev/null phpstats/LICENSE:1.1
--- /dev/null Sun Mar 9 13:37:36 2003
+++ phpstats/LICENSE Sun Mar 9 13:37:24 2003
@@ -0,0 +1,335 @@
+ GNU GENERAL PUBLIC LICENSE
+ 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.
+
+ GNU GENERAL PUBLIC LICENSE
+ 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
+
Index: phpstats/base64.php
diff -u /dev/null phpstats/base64.php:1.1
--- /dev/null Sun Mar 9 13:37:36 2003
+++ phpstats/base64.php Sun Mar 9 13:37:24 2003
@@ -0,0 +1,90 @@
+<?
+/*
+ base64 conversion.
+ PHP Stats Service is copyright (c) 2002-2003 volta.
+ E-mail: <vo...@gm...>
+ This program is free but copyrighted software; see the file LICENSE for
+ details.
+ $Id: base64.php,v 1.1 2003/03/09 21:37:24 mrvolta Exp $
+*/
+
+$a = 1;
+$convert2y = array(
+ 'A','B','C','D','E','F','G','H','I','J','K','L','M','N','O','P',
+ 'Q','R','S','T','U','V','W','X','Y','Z','a','b','c','d','e','f',
+ 'g','h','i','j','k','l','m','n','o','p','q','r','s','t','u','v',
+ 'w','x','y','z','0','1','2','3','4','5','6','7','8','9','[',']'
+);
+
+// Need that simple convertion because each() doesn't like strings (which are
+// actually arrays of chars), blame php
+function string2array ($string) {
+ $i = 0;
+ while($string[$i]) {
+ $array[$i] = $string[$i];
+ $i++;
+ };
+ return $array;
+};
+
+// Idea from quakenet's L source
+function base64toint ($base64) {
+ $base64 = string2array($base64);
+ $a = 0;
+ $n = 0;
+ while(list($key,$val) = each($base64)) {
+ $b = 0;
+ $asc_base64 = ord($val);
+ if (($asc_base64 >= 65) && ($asc_base64 <=90))
+ $b = $asc_base64 - 65;
+ elseif (($asc_base64 >= 48) && ($asc_base64 <= 57))
+ $b = $asc_base64 + 4;
+ elseif (($asc_base64 >= 97) && ($asc_base64 <= 122))
+ $b = $asc_base64 - 71;
+ elseif ("]" == $val)
+ $b = 63;
+ elseif ("[" == $val)
+ $b = 62;
+ $a += $b * pow(64,(count($base64) - 1 - $n++));
+ };
+ return $a;
+};
+
+// Idea also from qnet's L
+function inttobase64 ($number,$count) {
+ while ($count > 0) {
+ $number2 = $number % (64 ^ ($count - 1) - 1);
+ if (25 >= $number2)
+ $a = $number2 + 65;
+ elseif (51 >= $number2)
+ $a = $number2 + 71;
+ elseif (61 >= $number2)
+ $a = $number2 -4;
+ elseif (62 == $number2)
+ $a = 91;
+ elseif (63 == $number2)
+ $a = 93;
+ $number = $number / (64 ^ ($count - 1) - 1);
+ $array[$count--] = chr($a);
+ };
+ $array = array_reverse($array);
+ $string = "";
+ while (list($key,$val) = each($array)) {
+ $string = $string . $val;
+ };
+ return $string;
+};
+
+// php's long2ip() is buggy, rather use this one from one of the notes in php's manual
+function mylong2ip($long) {
+ if ($long > pow(2, 31))
+ $long -= pow(2, 32);
+ $ip = array();
+ for ($i = 0; $i < 4; $i++) {
+ $ip[] = $long >> (24 - ($i * 8));
+ $long -= $ip[$i] << (24 - ($i * 8));
+ if ($ip[$i] < 0) $ip[$i] += 256;
+ }
+ return join(".", $ip);
+};
+?>
\ No newline at end of file
Index: phpstats/classes.php
diff -u /dev/null phpstats/classes.php:1.1
--- /dev/null Sun Mar 9 13:37:36 2003
+++ phpstats/classes.php Sun Mar 9 13:37:24 2003
@@ -0,0 +1,367 @@
+<?
+/*
+ client, channel and server classes.
+ PHP Stats Service is copyright (c) 2002-2003 volta.
+ E-mail: <vo...@gm...>
+ This program is free but copyrighted software; see the file LICENSE for
+ details.
+ $Id: classes.php,v 1.1 2003/03/09 21:37:24 mrvolta Exp $
+*/
+
+$a = 1;
+/* definitions needed for binary modes */
+define(UMODE_D,1);
+define(UMODE_I,2);
+define(UMODE_O,4);
+define(UMODE_S,8);
+define(UMODE_W,16);
+define(UMODE_K,32);
+define(UMODE_G,64);
+define(UMODE_X,128);
+
+/* clients are saved in an array of objects with the numeric as key */
+class client {
+ var $nick;
+ var $timestamp;
+ var $username;
+ var $account;
+ var $host;
+ var $umode;
+ var $ip;
+ var $userinfo;
+ var $away;
+ var $channels = array(); // joined channels as array with the name as value
+ function client ($nick,$timestamp,$username,$host,$umode,$account,$ip,$userinfo) {
+ $this->nick = $nick;
+ $this->timestamp = $timestamp;
+ $this->username = $username;
+ $this->host = $host;
+ $this->umode = $this->modestring2binary($umode);
+ $this->account = $account;
+ $this->ip = $ip;
+ $this->userinfo = $userinfo;
+ $this->away = "";
+ }
+ function modestring2binary ($mode) {
+ if ($mode == "") return 0;
+ $array = string2array($mode);
+ $binary = 0;
+ foreach ($array as $key => $val) {
+ switch ($val) {
+ case "d": $binary = $binary ^ UMODE_D; break;
+ case "i": $binary = $binary ^ UMODE_I; break;
+ case "o": $binary = $binary ^ UMODE_O; break;
+ case "s": $binary = $binary ^ UMODE_S; break;
+ case "w": $binary = $binary ^ UMODE_W; break;
+ case "k": $binary = $binary ^ UMODE_K; break;
+ case "g": $binary = $binary ^ UMODE_G; break;
+ case "x": $binary = $binary ^ UMODE_X; break;
+ //default: echo "unknown usermode: $val\n";
+ };
+ };
+ return $binary;
+ }
+ function changenick ($newnick,$timestamp) {
+ $this->nick = $newnick;
+ $this->timestamp = $timestamp;
+ }
+ function away ($reason) {
+ $this->away = $reason;
+ }
+ function back () {
+ $this->away = "";
+ }
+ function account ($account) {
+ $this->account = $account;
+ }
+ function addmode ($mode,$numeric) {
+ $newmode = $this->umode | $this->modestring2binary($mode);
+ $this->umode = $newmode;
+ sql_clientchangemode($numeric,$newmode);
+ }
+ function remmode ($mode,$numeric) {
+ $newmode = $this->umode & ~$this->modestring2binary($mode);
+ $this->umode = $newmode;
+ sql_clientchangemode($numeric,$newmode);
+ }
+ function returnnick () {
+ return $this->nick;
+ }
+ function addchan($channel) {
+ $this->channels[] = $channel;
+ }
+ function remchan($channel) {
+ foreach ($this->channels as $key => $val) {
+ if ($val == $channel) unset($this->channels[$key]);
+ };
+ }
+ function getchannels () {
+ return $this->channels;
+ }
+};
+
+/* definitions needed for binary modes */
+DEFINE(CMODE_K,1);
+DEFINE(CMODE_L,2);
+DEFINE(CMODE_I,4);
+DEFINE(CMODE_M,8);
+DEFINE(CMODE_N,16);
+DEFINE(CMODE_P,32);
+DEFINE(CMODE_S,64);
+DEFINE(CMODE_T,128);
+DEFINE(CMODE_R,256);
+
+/* channels are saved in an array of objects with the channelname as key */
+class channel {
+ var $createts;
+ var $modes;
+ var $limit;
+ var $key;
+ var $topic;
+ var $topicts;
+ var $topicby;
+ var $users = array(); // users as array with the numeric as key and the status flag as value
+ var $bans = array(); // bans as array with the ban as value
+ function channel ($createts,$modes,$limit,$key,$founder,$founder_status) {
+ $this->createts = $createts;
+ if ($founder != NULL && $founder_status != NULL) {
+ $this->users[$founder] = $founder_status;
+ }
+ $this->modes = $this->modestring2binary($modes);
+ $this->limit = $limit;
+ $this->key = $key;
+ $this->topic = NULL;
+ $this->topicby = NULL;
+ }
+ function modestring2binary ($mode) {
+ if ($mode == "") return 0;
+ $array = string2array($mode);
+ $binary = 0;
+ foreach ($array as $key => $val) {
+ switch ($val) {
+ case "k": $binary = $binary ^ CMODE_K; break;
+ case "l": $binary = $binary ^ CMODE_L; break;
+ case "i": $binary = $binary ^ CMODE_I; break;
+ case "m": $binary = $binary ^ CMODE_M; break;
+ case "n": $binary = $binary ^ CMODE_N; break;
+ case "p": $binary = $binary ^ CMODE_P; break;
+ case "s": $binary = $binary ^ CMODE_S; break;
+ case "t": $binary = $binary ^ CMODE_T; break;
+ case "r": $binary = $binary ^ CMODE_R; break;
+ //default: echo "unknown channelmode: $val\n";
+ };
+ };
+ return $binary;
+ }
+ function changetopic ($source,$topic) {
+ global $client;
+ $this->topic = $topic;
+ $this->topicby = $client[$source]->returnnick();
+ $this->topicts = time();
+ }
+ function joincreate ($user) {
+ $this->users[$user] = "o";
+ }
+ function joinuser ($user) {
+ $this->users[$user] = "";
+ }
+ function partuser ($user) {
+ unset($this->users[$user]);
+ }
+ function addmode ($mode,$channelname) {
+ $newmode = $this->modes | $this->modestring2binary($mode);
+ $this->modes = $newmode;
+ sql_changechannelmode($channelname,$newmode);
+ }
+ function remmode ($mode,$channelname) {
+ $newmode = $this->modes & ~$this->modestring2binary($mode);
+ $this->modes = $newmode;
+ sql_changechannelmode($channelname,$newmode);
+ }
+ function burstjoin ($user,$status) {
+ $this->users[$user] = $status;
+ }
+ function returnts () {
+ return $this->createts;
+ }
+ function changets ($ts,$channelname) {
+ $this->createts = $ts;
+ sql_changechannelts($channelname,$ts);
+ }
+ function burst_younger ($modes,$limit,$key,$channelname) {
+ $newmode = $this->modestring2binary($modes);
+ sql_changechannelmode($channelname,$newmode);
+ $this->modes = $newmode;
+ $this->limit = $limit;
+ sql_changelimit($channelname,$limit);
+ $this->key = $key;
+ sql_changekey($channelname,$key);
+ // deop/devoice all users
+ foreach ($this->users as $key => $val) {
+ if ($val == "ov" or $val == "o" or $val == "v") {
+ $this->users[$key] = "";
+ };
+ };
+ sql_burstyounger($channelname);
+ // remove all bans
+ foreach ($this->bans as $key => $val) {
+ unset($this->bans[$key]);
+ };
+ }
+ function burst_same ($modes,$limit,$key,$channelname) {
+ if ($limit != NULL) { $this->limit = $limit; sql_changelimit($channelname,$limit); };
+ if ($key != NULL) { $this->key = $key; sql_changekey($channelname,$key); };
+ $newmode = $this->modes | $this->modestring2binary($modes);
+ $this->modes = $newmode;
+ sql_changechannelmode($channelname,$newmode);
+ }
+ function addban ($ban,$channelname,$setby,$timestamp) {
+ $this->bans[] = $ban;
+ sql_addban($channelname,$ban,$setby,$timestamp);
+ }
+ function remban ($ban,$channelname) {
+ foreach ($this->bans as $key => $val) {
+ if ($val == $ban) {
+ unset($this->bans[$key]);
+ sql_remban($channelname,$val);
+ return;
+ };
+ };
+ }
+ function addkey ($key,$channelname) {
+ $this->key = $key;
+ sql_changekey($channelname,$key);
+ }
+ function remkey ($channelname) {
+ $this->key = NULL;
+ sql_changekey($channelname,NULL);
+ }
+ function addlimit ($limit,$channelname) {
+ $this->limit = $limit;
+ sql_changelimit($channelname,$limit);
+ }
+ function remlimit ($channelname) {
+ $this->limit = NULL;
+ sql_changelimit($channelname,NULL);
+ }
+ function giveop ($numeric,$channelname) {
+ if ($this->users[$numeric] == "v") $newmode = "ov";
+ else $newmode = "o";
+ $this->users[$numeric] = $newmode;
+ sql_giveop($channelname,$numeric,$newmode);
+ }
+ function remop ($numeric,$channelname) {
+ $newmode = str_replace("o","",$this->users[$numeric]);
+ $this->users[$numeric] = $newmode;
+ sql_remop($channelname,$numeric,$newmode);
+ }
+ function givevoice ($numeric,$channelname) {
+ if ($this->users[$numeric] == "o") $newmode = "ov";
+ else $newmode = "v";
+ $this->users[$numeric] = $newmode;
+ sql_givevoice($channelname,$numeric,$newmode);
+ }
+ function remvoice ($numeric,$channelname) {
+ $newmode = str_replace("v","",$this->users[$numeric]);
+ $this->users[$numeric] = $newmode;
+ sql_remvoice($channelname,$numeric,$newmode);
+ }
+ function isempty () {
+ if (count($this->users) == 0) return true;
+ else return false;
+ }
+ function remallbans () {
+ foreach ($this->bans as $key => $val) {
+ unset($this->bans[$val]);
+ };
+ }
+ function deopall () {
+ foreach ($this->users as $key => $val) {
+ $this->remop($key);
+ };
+ }
+ function devoiceall () {
+ foreach ($this->users as $key => $val) {
+ $this->remvoice($key);
+ };
+ }
+};
+
+/* servers are saved in an array of objects with the numeric as key */
+class server {
+ var $servername;
+ var $hopcount;
+ var $startts;
+ var $linkts;
+ var $protocol;
+ var $maxconn;
+ var $mode;
+ var $description;
+ var $users = array(); // all users on that server saved in an array with the numeric as value
+ var $links = array(); // all servers linked with the numeric as value (this will lead to a tree structure, which can be processed with a recursive algorithm)
+ function server ($servername,$hops,$startts,$linkts,$protocol,$maxconn,$mode,$desc) {
+ $this->servername = $servername;
+ $this->hopcount = $hops;
+ $this->startts = $startts;
+ $this->linkts = $linkts;
+ $this->protocol = $protocol;
+ $this->maxconn = $maxconn;
+ $this->mode = $mode;
+ $this->description = $desc;
+ }
+ function returnname () {
+ return $this->servername;
+ }
+ function adduser ($numeric) {
+ $this->users[] = $numeric;
+ }
+ function remuser ($numeric) {
+ foreach ($this->users as $key => $val) {
+ if ($val == $numeric) {
+ unset($this->users[$key]);
+ return;
+ };
+ };
+ }
+ function linkserver ($snumeric) {
+ $this->links[] = $snumeric;
+ }
+ function remlink ($key) {
+ unset($this->links[$key]);
+ }
+ function returnname () {
+ return $this->servername;
+ }
+ // Recursive procedure to remove all servers, that are behind the squitted server.
+ // This also effects clients and channels.
+ function clearserver ($numeric) {
+ global $server,$client,$channel,$usernumber,$channelnumber,$servernumber;
+ // remove all clients and check if channels are empty
+ foreach ($this->users as $key1 => $val1) {
+ $this->remuser($val1);
+ foreach ($client[$val1]->channels as $key2 => $val2) {
+ $channel[$val2]->partuser($val1);
+ sql_partuser($val2,$val1);
+ if ($channel[$val2]->isempty()) {
+ unset($channel[$val2]);
+ sql_removechannel($val2);
+ sql_channelnumber(--$channelnumber);
+ };
+ };
+ unset($client[$val1]);
+ sql_unregisterclient($val1);
+ sql_usernumber(--$usernumber);
+ };
+
+ // remove all servers behind
+ foreach ($this->links as $key => $val) {
+ $server[$val]->clearserver($val);
+ unset($this->links[$key]);
+ unset($server[$val]);
+ sql_servernumber(--$servernumber);
+ sql_removeserver($val);
+ sql_remlink($numeric,$val);
+ };
+ }
+};
+?>
\ No newline at end of file
Index: phpstats/command_handlers.php
diff -u /dev/null phpstats/command_handlers.php:1.1
--- /dev/null Sun Mar 9 13:37:36 2003
+++ phpstats/command_handlers.php Sun Mar 9 13:37:24 2003
@@ -0,0 +1,130 @@
+<?
+/*
+ Command handlers.
+ PHP Stats Service is copyright (c) 2002-2003 volta.
+ E-mail: <vo...@gm...>
+ This program is free but copyrighted software; see the file LICENSE for
+ details.
+ $Id: command_handlers.php,v 1.1 2003/03/09 21:37:24 mrvolta Exp $
+*/
+
+$a = 1;
+require("functions.php"); if (!isset($b)) die("Error: Could not include functions.php\n"); else unset($b);
+$hdir = "handlers";
+require("$hdir/uplinkserver.php"); if (!isset($b)) die("Error: Could not include $hdir/uplinkserver.php\n"); else unset($b);
+require("$hdir/pass.php"); if (!isset($b)) die("Error: Could not include $hdir/pass.php\n"); else unset($b);
+require("$hdir/ping.php"); if (!isset($b)) die("Error: Could not include $hdir/ping.php\n"); else unset($b);
+require("$hdir/version.php"); if (!isset($b)) die("Error: Could not include $hdir/version.php\n"); else unset($b);
+require("$hdir/end_of_burst.php"); if (!isset($b)) die("Error: Could not include $hdir/end_of_burst.php\n"); else unset($b);
+require("$hdir/end_of_burst_ack.php"); if (!isset($b)) die("Error: Could not include $hdir/end_of_burst_ack.php\n"); else unset($b);
+require("$hdir/server.php"); if (!isset($b)) die("Error: Could not include $hdir/server.php\n"); else unset($b);
+require("$hdir/nick.php"); if (!isset($b)) die("Error: Could not include $hdir/nick.php\n"); else unset($b);
+require("$hdir/away.php"); if (!isset($b)) die("Error: Could not include $hdir/away.php\n"); else unset($b);
+require("$hdir/account.php"); if (!isset($b)) die("Error: Could not include $hdir/account.php\n"); else unset($b);
+require("$hdir/quit.php"); if (!isset($b)) die("Error: Could not include $hdir/quit.php\n"); else unset($b);
+require("$hdir/kill.php"); if (!isset($b)) die("Error: Could not include $hdir/kill.php\n"); else unset($b);
+require("$hdir/mode.php"); if (!isset($b)) die("Error: Could not include $hdir/mode.php\n"); else unset($b);
+require("$hdir/create.php"); if (!isset($b)) die("Error: Could not include $hdir/create.php\n"); else unset($b);
+require("$hdir/topic.php"); if (!isset($b)) die("Error: Could not include $hdir/topic.php\n"); else unset($b);
+require("$hdir/join.php"); if (!isset($b)) die("Error: Could not include $hdir/join.php\n"); else unset($b);
+require("$hdir/part.php"); if (!isset($b)) die("Error: Could not include $hdir/part.php\n"); else unset($b);
+require("$hdir/kick.php"); if (!isset($b)) die("Error: Could not include $hdir/kick.php\n"); else unset($b);
+require("$hdir/burst.php"); if (!isset($b)) die("Error: Could not include $hdir/burst.php\n"); else unset($b);
+require("$hdir/clearmode.php"); if (!isset($b)) die("Error: Could not include $hdir/clearmode.php\n"); else unset($b);
+require("$hdir/squit.php"); if (!isset($b)) die("Error: Could not include $hdir/squit.php\n"); else unset($b);
+require("$hdir/info.php"); if (!isset($b)) die("Error: Could not include $hdir/info.php\n"); else unset($b);
+unset($hdir);
+
+function commandhandler ($text) {
+ $array = explode(" ",$text);
+
+ // First parameter variable for SERVER and PASS
+ if ($array[0] == "SERVER") {
+ uplinkserver($array);
+ return;
+ };
+ if ($array[0] == "PASS") {
+ pass($array);
+ return;
+ };
+
+ // Else: P10 tokens
+ $source = $array[0];
+ switch ($array[1]) {
+ case "P": break; // PRIVMSG *ignored*
+ case "H": break; // WHO *ignored*
+ case "W": break; // WHOIS *ignored*
+ case "X": break; // WHOWAS *ignored*
+ case "USER": break; // USER *ignored*
+ case "N": nick($source,$array); break; // NICK
+ case "S": server($source,$array); break; // SERVER
+ case "LIST": break; // LIST *ignored*
+ case "T": topic($source,$array); break; // TOPIC
+ case "I": break; // INVITE *ignored*
+ case "V": version($source,$array); break; // VERSION
+ case "Q": quit($source,$array); break; // QUIT
+ case "SQ": squit($source,$array); break; // SQUIT
+ case "D": kill($source,$array); break; // KILL
+ case "F": info($source,$array); break; // INFO
+ case "LI": break; // LINKS *ignored*
+ case "R": break; // STATS *ignored*
+ case "HELP": break; // HELP *ignored*
+ case "Y": break; // ERROR *ignored*
+ case "A": away($source,$array); break; // AWAY
+ case "CO": break; // CONNECT *ignored*
+ case "MAP": break; // MAP *ignored*
+ case "G": ping($source,$array); break; // PING
+ case "Z": break; // PONG *ignored*
+ case "OPER": break; // OPER *ignored*
+ case "PA": break; // PASS *ignored*
+ case "WA": break; // WALLOPS *ignored*
+ case "WU": break; // WALLUSERS *ignored*
+ case "DS": break; // DESYNCH *ignored*
+ case "TI": break; // TIME *ignored*
+ case "SE": break; // SETTIME *ignored*
+ case "RI": break; // RPING *ignored*
+ case "RO": break; // RPONG *ignored*
+ case "E": break; // NAMES *ignored*
+ case "AD": break; // ADMIN *ignored*
+ case "TR": break; // TRACE *ignored*
+ case "O": break; // NOTICE *ignored*
+ case "WC": break; // WALLCHOPS *ignored*
+ case "WV": break; // WALLVOICES *ignored*
+ case "CP": break; // CPRIVMSG *ignored*
+ case "CN": break; // CNOTICE *ignored*
+ case "J": dojoin($source,$array); break; // JOIN
+ case "L": part($source,$array); break; // PART
+ case "LU": break; // LUSERS *ignored*
+ case "MO": break; // MOTD *ignored*
+ case "M": mode($source,$array); break; // MODE
+ case "K": kick($source,$array); break; // KICK
+ case "USERHOST": break; // USERHOST *ignored*
+ case "USERIP": break; // USERIP *ignored*
+ case "ISON": break; // ISON *ignored*
+ case "SQUERY": break; // SQUERY *ignored*
+ case "SERVLIST": break; // SERVLIST *ignored*
+ case "SERVSET": break; // SERVSET *ignored*
+ case "REHASH": break; // REHASH *ignored*
+ case "RESTART": break; // RESTART *ignored*
+ case "CLOSE": break; // CLOSE *ignored*
+ case "DIE": break; // DIE *ignored*
+ case "HASH": break; // HASH *ignored*
+ case "DNS": break; // DNS *ignored*
+ case "U": break; // SILENCE *ignored*
+ case "GL": break; // GLINE
+ case "B": burst($source,$array); break; // BURST
+ case "UP": break; // UPING *ignored*
+ case "C": create($source,$array); break; // CREATE
+ case "DE": break; // DESTRUCT *ignored
+ case "EB": end_of_burst($source,$array); break; // END_OF_BURST
+ case "EA": end_of_burst_ack($source,$array); break; // END_OF_BURST_ACK
+ case "PROTO": break; // PROTO *ignored*
+ case "JU": break; // JUPE
+ case "OM": mode($source,$array); break; // OPMODE
+ case "CM": clearmode($source,$array); break; // CLEARMODE
+ case "AC": account($source,$array); break; // ACCOUNT
+ case "LL": break; // ASLL *ignored*
+ //default: echo "Invalid command handler: $text";
+ };
+};
+?>
\ No newline at end of file
Index: phpstats/functions.php
diff -u /dev/null phpstats/functions.php:1.1
--- /dev/null Sun Mar 9 13:37:36 2003
+++ phpstats/functions.php Sun Mar 9 13:37:24 2003
@@ -0,0 +1,30 @@
+<?
+/*
+ Misc. functions.
+ PHP Stats Service is copyright (c) 2002-2003 volta.
+ E-mail: <vo...@gm...>
+ This program is free but copyrighted software; see the file LICENSE for
+ details.
+ $Id: functions.php,v 1.1 2003/03/09 21:37:24 mrvolta Exp $
+*/
+
+$b = 1;
+function send_to_uplink ($text) {
+ global $socket;
+ // remove all control codes, that might break debugging
+ $textdebug = ereg_replace("(\002|\003|\015|\022|\031)","",$text);
+ echo date("H:i:s") . " (Out) " . SERVERNUM . " " . $textdebug . "\n";
+ fputs($socket,SERVERNUM . " " . $text . "\r\n");
+};
+function send_raw_to_uplink ($text) {
+ global $socket;
+ // remove all control codes, that might break debugging
+ $textdebug = ereg_replace("(\002|\003|\015|\022|\031)","",$text);
+ echo date("H:i:s") . " (Out) " . $textdebug . "\n";
+ fputs($socket,$text . "\r\n");
+};
+function close_socket () {
+ global $socket;
+ fclose($socket);
+};
+?>
\ No newline at end of file
Index: phpstats/sqlfunctions.php
diff -u /dev/null phpstats/sqlfunctions.php:1.1
--- /dev/null Sun Mar 9 13:37:36 2003
+++ phpstats/sqlfunctions.php Sun Mar 9 13:37:24 2003
@@ -0,0 +1,275 @@
+<?
+/*
+ SQL functions.
+ PHP Stats Service is copyright (c) 2002-2003 volta.
+ E-mail: <vo...@gm...>
+ This program is free but copyrighted software; see the file LICENSE for
+ details.
+ $Id: sqlfunctions.php,v 1.1 2003/03/09 21:37:24 mrvolta Exp $
+*/
+
+$a = 1;
+/*
+ * Client-related commands
+ */
+function sql_registerclient ($numeric,$snumeric,$client) {
+ global $database;
+ $nick = $client->nick;
+ $timestamp = $client->timestamp;
+ $username = $client->username;
+ $host = $client->host;
+ $umode = $client->umode;
+ $account = $client->account;
+ $ip = $client->ip;
+ $userinfo = str_replace("'","\'",$client->userinfo);
+ $query = "INSERT INTO clients (numeric,nickname,timestamp,username,account,hostname,modes,ip,userinfo,server) ";
+ $query .= "VALUES ('$numeric','$nick',$timestamp,'$username','$account','$host',$umode,'$ip','$userinfo','$snumeric');";
+ pg_exec($database,$query);
+};
+
+function sql_changenick ($numeric,$newnick,$ts) {
+ global $database;
+ $query = "UPDATE clients SET nickname = '$newnick', timestamp = $ts WHERE numeric = '$numeric';";
+ pg_exec($database,$query);
+};
+
+function sql_away ($numeric,$awayreason) {
+ global $database;
+ $awayreason = str_replace("'","\'",$awayreason);
+ $query = "UPDATE clients SET away = '$awayreason' WHERE numeric = '$numeric';";
+ pg_exec($database,$query);
+};
+
+function sql_back ($numeric) {
+ global $database;
+ $query = "UPDATE clients SET away = '' WHERE numeric = '$numeric';";
+ pg_exec($database,$query);
+};
+
+function sql_account ($numeric,$account) {
+ global $database;
+ $query = "UPDATE clients SET account = '$account' WHERE numeric = '$numeric';";
+ pg_exec($database,$query);
+};
+
+function sql_clientchangemode ($numeric,$newmode) {
+ global $database;
+ $query = "UPDATE clients SET modes = $newmode WHERE numeric = '$numeric';";
+ pg_exec($database,$query);
+};
+
+function sql_unregisterclient ($numeric) {
+ global $database;
+ $query = "DELETE FROM clients WHERE numeric = '$numeric';";
+ pg_exec($database,$query);
+};
+
+/*
+ * Channel-related commands
+ */
+function sql_createchannel ($name,$channel) {
+ global $database;
+ $name = str_replace("'","\'",$name);
+ $createts = $channel->createts;
+ $modes = $channel->modes;
+ if ($channel->limit == NULL) $limit = 0;
+ else $limit = $channel->limit;
+ $key = str_replace("'","\'",$channel->key);
+ $query = "INSERT INTO channels (name,createts,modes,climit,key) ";
+ $query .= "VALUES ('$name',$createts,$modes,$limit,'$key');";
+ pg_exec($database,$query);
+};
+
+function sql_removechannel ($name) {
+ global $database;
+ $name = str_replace("'","\'",$name);
+ $query = "DELETE FROM channels WHERE name = '$name';";
+ pg_exec($database,$query);
+ $query = "DELETE FROM bans WHERE channelname = '$name';";
+ pg_exec($database,$query);
+};
+
+function sql_changetopic ($name,$topic,$topicby,$timestamp) {
+ global $database;
+ $topic = str_replace("'","\'",$topic);
+ $name = str_replace("'","\'",$name);
+ $query = "UPDATE channels SET topic = '$topic', topicby = '$topicby', topicts = '$timestamp' WHERE name = '$name';";
+ pg_exec($database,$query);
+};
+
+function sql_joinuser ($channelname,$numeric,$status) {
+ global $database;
+ $channelname = str_replace("'","\'",$channelname);
+ if ($status == "") $statusint = 0;
+ elseif ($status == "v") $statusint = 1;
+ elseif ($status == "o") $statusint = 2;
+ elseif ($status == "ov" or $status == "vo") $statusint = 3;
+ $query = "INSERT INTO channels_users (channelname,numeric,status) VALUES ('$channelname','$numeric','$statusint');";
+ pg_exec($database,$query);
+};
+
+function sql_partuser ($channelname,$numeric) {
+ global $database;
+ $channelname = str_replace("'","\'",$channelname);
+ $query = "DELETE FROM channels_users WHERE channelname = '$channelname' AND numeric = '$numeric';";
+ pg_exec($database,$query);
+};
+
+function sql_changechannelmode ($channelname,$newmode) {
+ global $database;
+ $channelname = str_replace("'","\'",$channelname);
+ $query = "UPDATE channels SET modes = $newmode WHERE name = '$channelname';";
+ pg_exec($database,$query);
+};
+
+function sql_changekey ($channelname,$newkey) {
+ global $database;
+ $channelname = str_replace("'","\'",$channelname);
+ if ($newkey == NULL) $newkey = "";
+ $query = "UPDATE channels SET key = '$newkey' WHERE name = '$channelname';";
+ pg_exec($database,$query);
+};
+
+function sql_changelimit ($channelname,$newlimit) {
+ global $database;
+ $channelname = str_replace("'","\'",$channelname);
+ if ($newlimit == NULL) $newlimit = 0;
+ $query = "UPDATE channels SET climit = $newlimit WHERE name = '$channelname';";
+ pg_exec($database,$query);
+};
+
+function sql_giveop ($channelname,$numeric,$newmode) {
+ global $database;
+ if ($newmode == "ov") $newmodeint = 3;
+ elseif ($newmode == "o") $newmodeint = 2;
+ $channelname = str_replace("'","\'",$channelname);
+ $query = "UPDATE channels_users SET status = $newmodeint WHERE channelname = '$channelname' AND numeric = '$numeric';";
+ pg_exec($database,$query);
+};
+
+function sql_remop ($channelname,$numeric,$newmode) {
+ global $database;
+ if ($newmode == "v") $newmodeint = 1;
+ elseif ($newmode == "") $newmodeint = 0;
+ $channelname = str_replace("'","\'",$channelname);
+ $query = "UPDATE channels_users SET status = $newmodeint WHERE channelname = '$channelname' AND numeric = '$numeric';";
+ pg_exec($database,$query);
+};
+
+function sql_givevoice ($channelname,$numeric,$newmode) {
+ global $database;
+ if ($newmode == "v") $newmodeint = 1;
+ elseif ($newmode == "ov") $newmodeint = 3;
+ $channelname = str_replace("'","\'",$channelname);
+ $query = "UPDATE channels_users SET status = $newmodeint WHERE channelname = '$channelname' AND numeric = '$numeric';";
+ pg_exec($database,$query);
+};
+
+function sql_remvoice ($channelname,$numeric,$newmode) {
+ global $database;
+ if ($newmode == "o") $newmodeint = 2;
+ elseif ($newmode == "") $newmodeint = 0;
+ $channelname = str_replace("'","\'",$channelname);
+ $query = "UPDATE channels_users SET status = $newmodeint WHERE channelname = '$channelname' AND numeric = '$numeric';";
+ pg_exec($database,$query);
+};
+
+function sql_addban ($channelname,$banstring,$setby,$timestamp) {
+ global $database;
+ $channelname = str_replace("'","\'",$channelname);
+ $query = "INSERT INTO bans (channelname,banmask,setby,settime) ";
+ $query .= "VALUES ('$channelname','$banstring','$setby',$timestamp);";
+ pg_exec($database,$query);
+};
+
+function sql_remban ($channelname,$banstring) {
+ global $database;
+ $channelname = str_replace("'","\'",$channelname);
+ $query = "DELETE FROM bans WHERE channelname = '$channelname' AND banmask = '$banstring';";
+ pg_exec($database,$query);
+};
+
+function sql_changechannelts ($channelname,$newts) {
+ global $database;
+ $channelname = str_replace("'","\'",$channelname);
+ $query = "UPDATE channels SET createts = $newts WHERE name = '$channelname';";
+ pg_exec($database,$query);
+};
+
+function sql_burstyounger ($channelname) {
+ global $database;
+ $channelname = str_replace("'","\'",$channelname);
+ $query = "UPDATE channels_users SET status = 0 WHERE channelname = '$channelname';";
+ pg_exec($database,$query);
+};
+
+/*
+ * Server-related commands
+ */
+function sql_registerserver ($numeric,$server) {
+ global $database;
+ $servername = $server->servername;
+ $hops = $server->hopcount;
+ $startts = $server->startts;
+ $linkts = $server->linkts;
+ $protocol = $server->protocol;
+ $maxconn = $server->maxconn;
+ $mode = $server->mode;
+ $desc = str_replace("'","\'",$server->description);
+ $query = "INSERT INTO servers (numeric,name,hops,startts,linkts,protocol,maxconn,description) ";
+ $query .= "VALUES ('$numeric','$servername',$hops,$startts,$linkts,'$protocol',$maxconn,'$desc');";
+ pg_exec($database,$query);
+};
+
+function sql_linkserver ($server1,$server2) {
+ global $database;
+ $query = "INSERT INTO serverlinks (server1,server2) VALUES ('$server1','$server2');";
+ pg_exec($database,$query);
+};
+
+function sql_remlink ($server1,$server2) {
+ global $database;
+ $query = "DELETE FROM serverlinks WHERE server1 = '$server1' AND server2 = '$server2';";
+ pg_exec($database,$query);
+};
+
+function sql_removeserver ($numeric) {
+ global $database;
+ $query = "DELETE FROM servers WHERE numeric = '$numeric';";
+ pg_exec($database,$query);
+};
+
+/*
+ * Misc. variables function
+ */
+function sql_running () {
+ global $database;
+ $query = "INSERT INTO variables (running,isbursted,number_users,number_channels,number_servers) ";
+ $query .= "VALUES ('t','f',0,0,0);";
+ pg_exec($database,$query);
+};
+
+function sql_isbursted ($bool) {
+ global $database;
+ $query = "UPDATE variables SET isbursted = '$bool';";
+ pg_exec($database,$query);
+};
+
+function sql_usernumber ($number) {
+ global $database;
+ $query = "UPDATE variables SET number_users = $number;";
+ pg_exec($database,$query);
+};
+
+function sql_channelnumber ($number) {
+ global $database;
+ $query = "UPDATE variables SET number_channels = $number;";
+ pg_exec($database,$query);
+};
+
+function sql_servernumber ($number) {
+ global $database;
+ $query = "UPDATE variables SET number_servers = $number;";
+ pg_exec($database,$query);
+};
+?>
\ No newline at end of file
Index: phpstats/tables.sql
diff -u /dev/null phpstats/tables.sql:1.1
--- /dev/null Sun Mar 9 13:37:36 2003
+++ phpstats/tables.sql Sun Mar 9 13:37:24 2003
@@ -0,0 +1,70 @@
+-- $Id: tables.sql,v 1.1 2003/03/09 21:37:24 mrvolta Exp $
+-- all data types were set with IRCU's default definitions
+
+CREATE TABLE clients (
+ numeric VARCHAR(5) NOT NULL UNIQUE,
+ nickname VARCHAR(9) NOT NULL,
+ timestamp INT4 NOT NULL,
+ username VARCHAR(10) NOT NULL,
+ account VARCHAR(12) DEFAULT '' NOT NULL,
+ hostname TEXT NOT NULL,
+ modes SMALLINT DEFAULT 0 NOT NULL,
+ ip VARCHAR(15) NOT NULL,
+ userinfo VARCHAR(50) NOT NULL,
+ away VARCHAR(160) DEFAULT '' NOT NULL,
+ server VARCHAR(2) NOT NULL
+);
+
+CREATE TABLE channels (
+ name VARCHAR(200) NOT NULL UNIQUE,
+ createts INT4 NOT NULL,
+ modes SMALLINT NOT NULL,
+ climit BIGINT DEFAULT 0 NOT NULL,
+ key VARCHAR(24) DEFAULT '' NOT NULL,
+ topic VARCHAR(160) DEFAULT '' NOT NULL,
+ topicby VARCHAR(9) DEFAULT '' NOT NULL,
+ topicts INT4 DEFAULT 0 NOT NULL
+);
+
+CREATE TABLE channels_users (
+ channelname VARCHAR(200) NOT NULL,
+ numeric VARCHAR(5) NOT NULL,
+ -- 0 for nothing, 1 for voice, 2 for op, 3 for voiceop
+ status VARCHAR(1) NOT NULL
+);
+
+CREATE TABLE bans (
+ channelname VARCHAR(200) NOT NULL,
+ banmask TEXT NOT NULL,
+ -- may also be a servername, that's why ircu's HOSTLEN
+ setby VARCHAR(63) NOT NULL,
+ settime INT4 NOT NULL
+);
+
+CREATE TABLE servers (
+ numeric VARCHAR(2) NOT NULL UNIQUE,
+ -- HOSTLEN, like mentioned above
+ name VARCHAR(63) NOT NULL UNIQUE,
+ hops SMALLINT NOT NULL,
+ startts INT4 NOT NULL,
+ linkts INT4 NOT NULL,
+ protocol VARCHAR(3) NOT NULL,
+ maxconn INT4 NOT NULL,
+ -- REALLEN
+ description VARCHAR(50) NOT NULL
+);
+
+CREATE TABLE serverlinks (
+ server1 VARCHAR(2) NOT NULL,
+ server2 VARCHAR(2) NOT NULL
+);
+
+CREATE TABLE variables (
+ -- t or f
+ running VARCHAR(1) NOT NULL,
+ isbursted VARCHAR(1) DEFAULT 'f' NOT NULL,
+
+ number_users INT4 NOT NULL,
+ number_channels INT4 NOT NULL,
+ number_servers SMALLINT NOT NULL
+);
\ No newline at end of file
----------------------- End of diff -----------------------
|
