openfirst-cvscommit

[<xt...@us...>]

Update of /cvsroot/openfirst/logger
In directory sc8-pr-cvs1:/tmp/cvs-serv13990

Modified Files:
	index.php logger.php rawdata.php reset.php track.php 
Log Message:
Replace mysql functions with new database functions, allowing multiple database types to be used easily.

Index: index.php
===================================================================
RCS file: /cvsroot/openfirst/logger/index.php,v
retrieving revision 1.3
retrieving revision 1.4
diff -C2 -d -r1.3 -r1.4
*** index.php	28 Jun 2003 15:23:48 -0000	1.3
--- index.php	23 Aug 2003 20:30:12 -0000	1.4
***************
*** 41,51 ****
  
    if (isset($_GET['DELETE'])) {
!     mysql_query("DELETE FROM ofirst_logger WHERE IPAddress = '".$_GET['DELETE']."'") or die(mysql_error());
    }
  
  
  
!   $query = mysql_query("SELECT * FROM ofirst_logger GROUP BY IPAddress LIMIT $min,$max");
!   $amount = mysql_num_rows($query);
  
  ?>
--- 41,51 ----
  
    if (isset($_GET['DELETE'])) {
!     ofirst_dbquery("DELETE FROM ofirst_logger WHERE IPAddress = '".$_GET['DELETE']."'") or die(ofirst_dberror());
    }
  
  
  
!   $query = ofirst_dbquery("SELECT * FROM ofirst_logger GROUP BY IPAddress LIMIT $min,$max");
!   $amount = ofirst_dbnum_rows($query);
  
  ?>
***************
*** 76,80 ****
    <?
  
!   while($log = mysql_fetch_object($query)){
      echo "<tr>";
      echo " <td>$log->ID</td>";
--- 76,80 ----
    <?
  
!   while($log = ofirst_dbfetch_object($query)){
      echo "<tr>";
      echo " <td>$log->ID</td>";

Index: logger.php
===================================================================
RCS file: /cvsroot/openfirst/logger/logger.php,v
retrieving revision 1.5
retrieving revision 1.6
diff -C2 -d -r1.5 -r1.6
*** logger.php	21 Aug 2003 13:06:48 -0000	1.5
--- logger.php	23 Aug 2003 20:30:12 -0000	1.6
***************
*** 45,49 ****
    }
  
!   mysql_query("INSERT INTO ofirst_logger (IPAddress,Date,Location,QueryString,HostLookup,Browser,Member)
                                   values('".$IP."'
                                   ,'".$DATE."'
--- 45,49 ----
    }
  
!   ofirst_dbquery("INSERT INTO ofirst_logger (IPAddress,Date,Location,QueryString,HostLookup,Browser,Member)
                                   values('".$IP."'
                                   ,'".$DATE."'
***************
*** 52,56 ****
                                   ,'".$HOST."'
                                   ,'".$BROWSER."'
!                                  ,'".$MEMBER."')") or die(mysql_error());
  
  ?>
--- 52,56 ----
                                   ,'".$HOST."'
                                   ,'".$BROWSER."'
!                                  ,'".$MEMBER."')") or die(ofirst_dberror());
  
  ?>

Index: rawdata.php
===================================================================
RCS file: /cvsroot/openfirst/logger/rawdata.php,v
retrieving revision 1.5
retrieving revision 1.6
diff -C2 -d -r1.5 -r1.6
*** rawdata.php	28 Jun 2003 15:23:48 -0000	1.5
--- rawdata.php	23 Aug 2003 20:30:12 -0000	1.6
***************
*** 38,46 ****
  
    if (isset($_GET['DELETE'])) {
!     mysql_query("DELETE FROM ofirst_logger WHERE ID = '".$_GET['DELETE']."'");
    }
  
!   $query = mysql_query("SELECT * FROM ofirst_logger LIMIT $min,$max");
!   $amount = mysql_num_rows($query);
  ?>
  <h1>View Log Information</h1>
--- 38,46 ----
  
    if (isset($_GET['DELETE'])) {
!     ofirst_dbquery("DELETE FROM ofirst_logger WHERE ID = '".$_GET['DELETE']."'");
    }
  
!   $query = ofirst_dbquery("SELECT * FROM ofirst_logger LIMIT $min,$max");
!   $amount = ofirst_dbnum_rows($query);
  ?>
  <h1>View Log Information</h1>
***************
*** 64,68 ****
    </tr>
  <?
!   while($log = mysql_fetch_object($query)){
      echo "<tr>";
  	echo " <td>$log->ID</td>";
--- 64,68 ----
    </tr>
  <?
!   while($log = ofirst_dbfetch_object($query)){
      echo "<tr>";
  	echo " <td>$log->ID</td>";

Index: reset.php
===================================================================
RCS file: /cvsroot/openfirst/logger/reset.php,v
retrieving revision 1.4
retrieving revision 1.5
diff -C2 -d -r1.4 -r1.5
*** reset.php	28 Jun 2003 15:23:48 -0000	1.4
--- reset.php	23 Aug 2003 20:30:12 -0000	1.5
***************
*** 31,35 ****
    if (isset($_POST['confirm'])) {
      if(isset($user->user) == true && $user->membertype == 'administrator') {
!       mysql_query("DELETE FROM ofirst_logger");
        echo "<p>Logger system has been reset</p>";
      } else {
--- 31,35 ----
    if (isset($_POST['confirm'])) {
      if(isset($user->user) == true && $user->membertype == 'administrator') {
!       ofirst_dbquery("DELETE FROM ofirst_logger");
        echo "<p>Logger system has been reset</p>";
      } else {

Index: track.php
===================================================================
RCS file: /cvsroot/openfirst/logger/track.php,v
retrieving revision 1.7
retrieving revision 1.8
diff -C2 -d -r1.7 -r1.8
*** track.php	21 Aug 2003 13:06:48 -0000	1.7
--- track.php	23 Aug 2003 20:30:12 -0000	1.8
***************
*** 30,38 ****
  
    if (isset($_GET['DELETE'])) {
!     mysql_query("DELETE FROM ofirst_logger WHERE IPAddress = '".$_GET['ID']."'") or die(mysql_error());
    }
  
!   $query = mysql_query("SELECT * FROM ofirst_logger WHERE IPAddress='".$_GET['ID']."'");
!   $amount = mysql_num_rows($query);
  ?>
  <h1>View Log Information</h1>
--- 30,38 ----
  
    if (isset($_GET['DELETE'])) {
!     ofirst_dbquery("DELETE FROM ofirst_logger WHERE IPAddress = '".$_GET['ID']."'") or die(ofirst_dberror());
    }
  
!   $query = ofirst_dbquery("SELECT * FROM ofirst_logger WHERE IPAddress='".$_GET['ID']."'");
!   $amount = ofirst_dbnum_rows($query);
  ?>
  <h1>View Log Information</h1>
***************
*** 52,56 ****
    </tr>
  <?
!   while($log = mysql_fetch_object($query)) {
      echo "<tr>";
  	echo " <td>$log->ID</td>";
--- 52,56 ----
    </tr>
  <?
!   while($log = ofirst_dbfetch_object($query)) {
      echo "<tr>";
  	echo " <td>$log->ID</td>";