Location: PHPKode > projects > FreeWebshop > accesslogadmin.php
<?php
/*  orderadmin.php
    Copyright 2006, 2007, 2008 Elmar Wenners
    Support site: http://www.chaozz.nl

    This file is part of FreeWebshop.org.

    FreeWebshop.org 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.

    FreeWebshop.org 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 FreeWebshop.org; if not, write to the Free Software
    Foundation, Inc., 51 Franklin St, Fifth Floor, Boston, MA  02110-1301  USA

*/
?>
<?php if ($index_refer <> 1) { exit(); } ?>
<?php
// admin check
if (IsAdmin() == false) {
  PutWindow($gfx_dir, $txt['general12'], $txt['general2'], "warning.gif", "50");
}
else {    
    // access per page
    $access_per_page = 20; // change this if you want
    
    if ($access_per_page > 0) {
       if (!empty($_GET['num_page'])) {
          $num_page = $_GET['num_page'];
       }
       else { $num_page = 1; }
       $start_record = ($num_page -1) * $access_per_page;
       $limit    = " LIMIT $start_record, $access_per_page"; 
    }
    else { $limit = ""; }   
    
    if (isset($action)) {
	    if ($action == "clear") {
		    $query = "DELETE FROM `".$dbtablesprefix."accesslog`";
		    $sql = mysql_query($query) or die(mysql_error());
		    PutWindow($gfx_dir, $txt['general13'], $txt['accesslogadmin9'], "notify.gif", "50");
		}
	}
	    
    $query = "SELECT * FROM `".$dbtablesprefix."accesslog` ORDER BY `id` DESC";
    $sql = mysql_query($query) or die(mysql_error());
    $num_access = mysql_num_rows($sql);
    $sql = mysql_query($query.$limit) or die(mysql_error());
    ?>


    <table width="100%" class="datatable">
      <caption><?php echo $txt['accesslogadmin1']; ?></caption>
     <tr> 
      <th><?php echo $txt['accesslogadmin2']; ?></th>
      <th><?php echo $txt['accesslogadmin4']; ?></th>
      <th><?php echo $txt['accesslogadmin5']; ?></th>
     </tr>

    <?php
    if (mysql_num_rows($sql) == 0) {
        echo "<tr><td colspan=\"5\">".$txt['accesslogadmin7']."</td></tr>";
    }
    else {
        while ($row = mysql_fetch_row($sql)) {
              echo "<tr><td>$row[1]</td><td>$row[2]</td><td>$row[3]</td></tr>\n";
        }
    } 
    echo "</table>";
    
  // page code
  if ($access_per_page > 0 && $num_access > $access_per_page) {
	  
	  $page_counter = 0;
	  $num_pages = 0;
	  $rest_access = $num_access;
	  
	  echo "<br /><h4>".$txt['browse11'].": ";
	  
	  for($i = 0; $i < $num_access; $i++) { 
		  $page_counter++;
		  if ($page_counter == $access_per_page) {
			  $num_pages++;
			  $page_counter = 0;
			  $rest_access = $rest_access - $access_per_page;
			  if ($num_pages == $num_page) {
				  echo "<b>[$num_pages]</b>";
			  }
			  else { echo "<a href=\"index.php?page=accesslogadmin&action=$action&num_page=$num_pages\">[$num_pages]</a>"; }
			  echo " ";
		  }
      }
      // the rest (if any)
      if ($rest_access > 0) {
		  $num_pages++;
		  if ($num_pages == $num_page) {
			  echo "<b>[$num_pages]</b>";
		  }
		  else { echo "<a href=\"index.php?page=accesslogadmin&action=$action&num_page=$num_pages\">[$num_pages]</a>"; }
	  }
	      
      echo "</h4>"; 
  }           
?>
    <br />
    <br />
    <h4><a href="?page=accesslogadmin&action=clear"><?php echo $txt['accesslogadmin8']; ?></a></h4>
<?php } ?>    
Return current item: FreeWebshop