[Summary view] [Print] [Text view]

   1  <?php
   2  // ************************************************************************

   3  // mroovca stats

   4  // version: 0.5.0 - 28 Feb 2006

   5  // author: przyjazn (MirekW)

   6  // licence: GNU GPL

   7  // ************************************************************************

   8  
   9      if (!$conf_access) { return; };
  10  ?>
  11  
  12  <!--
  13  // *************************************************************

  14  // * Lastvisitors                                             *

  15  // *************************************************************

  16  -->
  17  <?php
  18      // prepare data

  19  
  20      $q = "SELECT DATE_FORMAT(ts,'%a %d-%m-%Y %H:%i:%S'), clientname, clientip, useragent, referer, requesthost, requesturi FROM ".$settings['dbprefix']."logdata";
  21      $q .= " WHERE id_configure=$conf_id_configure".$conf_q_excluded;
  22      if (!$conf_reload) { $q .= " AND reloaded=0"; };
  23      $q .= " ORDER BY ts DESC LIMIT 100;";
  24      $result = dblib_query( $dbh, $q, $settings["dbresult"] );
  25      unset($values);
  26      $values = array();
  27      if ( dblib_isset($result) )
  28      {
  29          while ($row = dblib_fetch_row($result))
  30          {
  31              array_push( $values, $row );
  32          };
  33      };
  34  ?>
  35  
  36      <tr>
  37          <td align="center">
  38              <br />
  39              <table cellspacing="1" cellpadding="0" border="1" bgcolor="#E0E0E0" width="<?= $table_width ?>">
  40              <tr>
  41              <th bgcolor="<?php echo $c_blue[3]; ?>" colspan="4">&nbsp;<?= $stringlist["details1"].' '.$table["details1"].' '.$stringlist["details2"] ?>&nbsp;</th>
  42              </tr>
  43              <!--
  44              <tr>
  45                  <th bgcolor="<?php echo $c_blue[3]; ?>">&nbsp;<?= $stringlist["details_no"] ?>&nbsp;</th>
  46                  <th bgcolor="<?php echo $c_blue[3]; ?>" width="125">&nbsp;<?= $stringlist["details_date"] ?>&nbsp;</th>
  47                  <th bgcolor="<?php echo $c_blue[3]; ?>">&nbsp;<?= $stringlist["details_host"] ?>&nbsp;</th>
  48                  <th bgcolor="<?php echo $c_blue[3]; ?>">&nbsp;<?= $stringlist["details_item"] ?>&nbsp;</th>
  49              </tr>
  50              -->
  51              <?php
  52                  $counter = 1;
  53                  foreach( $values as $row )
  54                  {
  55              ?>
  56                      <tr>
  57                          <td colspan="4" align="left">
  58                              <table border="0" cellspacing="0">
  59                                  <tr>
  60                                      <td><font size="1">&nbsp;<?= $counter ?>.&nbsp;</font></td>
  61                                      <td><font size="1">&nbsp;<?= $row[0] ?>&nbsp;</font></td>
  62                                      <td align="right"><font size="1">&nbsp;host:</font></td>
  63                                      <td><font size="1">&nbsp;<?= $row[1]!="" ? $row[1] : $row[2] ?>&nbsp;&nbsp;&nbsp;<?php  if ($row[1]!="") { echo '('.$row[2].')&nbsp;'; }; ?></font></td>
  64                                  </tr>
  65                                  <tr>
  66                                      <td>&nbsp;</td>
  67                                      <td>&nbsp;</td>
  68                                      <td align="right"><font size="1">&nbsp;useragent:</font></td>
  69                                      <td><font size="1">&nbsp;<?= $row[3] ?>&nbsp;</font></td>
  70                                  </tr>
  71                                  <tr>
  72                                      <td>&nbsp;</td>
  73                                      <td>&nbsp;</td>
  74                                      <td align="right"><font size="1">&nbsp;address:</font></td>
  75                                      <td><font size="1">&nbsp;<?= $row[5].$row[6] ?>&nbsp;</font></td>
  76                                  </tr>
  77                                  <tr>
  78                                      <td>&nbsp;</td>
  79                                      <td>&nbsp;</td>
  80                                      <td align="right"><font size="1">&nbsp;referer:</font></td>
  81                                      <td><font size="1">&nbsp;<?= $row[4] ?>&nbsp;</font></td>
  82                                  </tr>
  83                              </table>
  84                          </td>
  85                      </tr>
  86              <?php
  87                  ++$counter;
  88                  };
  89              ?>
  90              </table>
  91          </td>
  92      </tr>
  93  
  94