[Ircphpstats-devel] [CVS] Module phpstats: Change committed

[Mr. v. <mr...@us...>]

Committer  : volta <mr...@us...>
CVSROOT    : /cvsroot/ircphpstats
Module     : phpstats
Commit time: 2003-06-05 08:40:17 UTC

Modified files:
     sqlfunctions.php

Log message:

More changes in the sql functions.
Ready for release ...

---------------------- diff included ----------------------
Index: phpstats/sqlfunctions.php
diff -u phpstats/sqlfunctions.php:1.1 phpstats/sqlfunctions.php:1.2
--- phpstats/sqlfunctions.php:1.1	Sun Mar  9 13:37:24 2003
+++ phpstats/sqlfunctions.php	Thu Jun  5 01:40:05 2003
@@ -5,10 +5,69 @@
 	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 $
+    $Id: sqlfunctions.php,v 1.2 2003/06/05 08:40:05 mrvolta Exp $
 */
 
 $a = 1;
+/*
+ * Misc. function
+ */
+function sql_init() {
+    global $database;
+    // The SQL connect
+    echo "Connecting to the pgsql database ...\n";
+    if (SQLPASS == "foo") {
+        $connstring = "host=" . SQLHOST . " port=" . SQLPORT . " dbname=" . SQLDBNAME . " user=" . SQLUSER;
+    }
+    else {
+        $connstring = "host=" . SQLHOST . " port=" . SQLPORT . " dbname=" . SQLDBNAME . " user=" . SQLUSER . " password=" . SQLPASS;
+    };
+    $database = @pg_connect($connstring) or die("Error: $php_errormsg\n");
+    // cleanup all tables
+    pg_exec($database,"DELETE FROM clients;");
+    pg_exec($database,"DELETE FROM channels;");
+    pg_exec($database,"DELETE FROM servers;");
+    pg_exec($database,"DELETE FROM channels_users;");
+    pg_exec($database,"DELETE FROM bans;");
+    pg_exec($database,"DELETE FROM serverlinks;");
+    pg_exec($database,"DELETE FROM variables;");
+    
+    $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_die () {
+    global $database;
+    $query = "UPDATE variables SET running = 'f';";
+    pg_exec($database,$query);
+    pg_close($database);
+};
+
+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);
+};
+
 /* 
  * Client-related commands
  */
@@ -236,40 +295,6 @@
 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);
 };
 ?>
----------------------- End of diff -----------------------