[Sommaire] [Imprimer]

   1  <?php
   2  //----------------------------------------------------------------------

   3  //  CrawlTrack 2.2.1

   4  //----------------------------------------------------------------------

   5  // Crawler Tracker for website

   6  //----------------------------------------------------------------------

   7  // Author: Jean-Denis Brun

   8  //----------------------------------------------------------------------

   9  // Website: www.crawltrack.fr

  10  //----------------------------------------------------------------------

  11  // That script is distributed under GNU GPL license

  12  //----------------------------------------------------------------------

  13  // file: menusite.php

  14  //----------------------------------------------------------------------

  15  
  16  if (!defined('IN_CRAWLT'))
  17  {
  18      echo"<h1>Hacking attempt !!!!</h1>";
  19      exit();
  20  }
  21  //initialize array

  22  $listsite=array();
  23  $urlsite=array();
  24  $listidsite=array();
  25  $nbrpagestotal=array();
  26  
  27  
  28  if($_SESSION['rightsite']==0)
  29      {
  30          
  31      //mysql requete    

  32      $sqlsite = "SELECT * FROM crawlt_site";    
  33      $requetesite = mysql_query($sqlsite, $connexion) or die("MySQL query error");
  34      
  35      $nbrresult=mysql_num_rows($requetesite);
  36          
  37      if($nbrresult>=1)
  38              {    
  39      
  40          while ($ligne = mysql_fetch_object($requetesite))                                                                              
  41              {
  42              $sitename=$ligne->name;
  43              $siteurl=$ligne->url; 
  44              $siteid=$ligne->id_site;
  45              $listsite[]=$sitename;
  46              $urlsite[$siteid]=$siteurl;
  47              $listidsite[]=$siteid;
  48              }
  49  
  50          //preparation of site list display

  51          $nbrsite=sizeof($listsite);
  52          $nbrsiteaf=0;
  53  
  54  
  55          //display

  56          echo"<div class=\"menusite\" align=\"centrer\">\n";
  57  
  58          echo"<div width=\"444px\" z-index:0>\n";
  59          echo"<form action=\"index.php\" method=\"POST\" z-index:0>\n";
  60  
  61          echo "<input type=\"hidden\" name ='navig' value=\"$navig\">\n";
  62          echo "<input type=\"hidden\" name ='search' value=\"$search\">\n";        
  63          echo "<input type=\"hidden\" name ='period' value=\"$period\">\n";
  64          echo "<input type=\"hidden\" name ='crawler' value=\"$crawler\">\n";
  65          echo"<select onchange=\"form.submit()\" size=\"1\" name=\"site\"  style=\" font-size:13px; font-weight:bold; color: #003399;
  66          font-family: Verdana,Geneva, Arial, Helvetica, Sans-Serif; \">\n";
  67          do
  68              {            
  69              //calculation of the number of pages of the site

  70              $site2=$listidsite[$nbrsiteaf];
  71              $sqlstats = "SELECT COUNT(DISTINCT crawlt_pages_id_page) FROM crawlt_visits 
  72              WHERE  crawlt_site_id_site='".sql_quote($site2)."'";            
  73              $requetestats = mysql_query($sqlstats, $connexion);    
  74              $ligne = mysql_fetch_row($requetestats);
  75              $nbrpagestotal[$site2]=$ligne[0];    
  76              
  77              if($listidsite[$nbrsiteaf]==$site)
  78                  {
  79                  echo"<option value=\"$listidsite[$nbrsiteaf]\" selected style=\" font-size:13px; font-weight:bold; color: #003399;
  80                  font-family: Verdana,Geneva, Arial, Helvetica, Sans-Serif;\">".$listsite[$nbrsiteaf]."&nbsp;&bull;&nbsp;".$nbrpagestotal[$site2]." &nbsp;".$language['page']."</option>\n";
  81                  }
  82              else
  83                  {
  84                  echo"<option value=\"$listidsite[$nbrsiteaf]\" style=\" font-size:13px; font-weight:bold; color: #003399;
  85                  font-family: Verdana,Geneva, Arial, Helvetica, Sans-Serif;\">".$listsite[$nbrsiteaf]."&nbsp;&bull;&nbsp;".$nbrpagestotal[$site2]." &nbsp;".$language['page']."</option>\n";
  86                  }        
  87              $nbrsiteaf++;
  88              }
  89      
  90          while($nbrsiteaf<$nbrsite);
  91  
  92          echo"</select></form></div></div>\n";
  93          }    
  94      }
  95  else
  96      {
  97  
  98      //mysql requete    

  99      $site=$_SESSION['rightsite'];    
 100                  
 101      $sqlsite = "SELECT * FROM crawlt_site
 102      WHERE id_site='".sql_quote($site)."'";
 103  
 104      
 105      $requetesite = mysql_query($sqlsite, $connexion) or die("MySQL query error");
 106      
 107      $nbrresult=mysql_num_rows($requetesite);
 108          
 109      if($nbrresult>=1)
 110          {        
 111      
 112          while ($ligne = mysql_fetch_object($requetesite))                                                                              
 113              {
 114              $sitename=$ligne->name; 
 115              }
 116              
 117              
 118          $sqlstats = "SELECT COUNT(DISTINCT crawlt_pages_id_page) FROM crawlt_visits 
 119          WHERE  crawlt_site_id_site='".sql_quote($site)."'";            
 120          $requetestats = mysql_query($sqlstats, $connexion) or die("MySQL query error");    
 121          $ligne = mysql_fetch_row($requetestats);
 122          $nbrpagestotal[$site]=$ligne[0];            
 123              
 124              
 125  
 126          //display

 127          echo"<div class=\"menusite\" >\n";
 128  
 129          echo"<div width=\"244px\" align=\"centrer\">\n";
 130          echo"<form action=\"index.php\" method=\"POST\" >\n";
 131  
 132          echo "<input type=\"hidden\" name ='navig' value=\"$navig\">\n";
 133          echo "<input type=\"hidden\" name ='search' value=\"$search\">\n";        
 134          echo "<input type=\"hidden\" name ='period' value=\"$period\">\n";
 135          echo "<input type=\"hidden\" name ='crawler' value=\"$crawler\">\n";
 136          echo"<select size=\"1\" name=\"site\"  style=\" font-size:13px; font-weight:bold; color: #003399;
 137          font-family: Verdana,Geneva, Arial, Helvetica, Sans-Serif; width:244px;\">\n";
 138          echo"<option value=\"$site\" selected style=\" font-size:13px; font-weight:bold; color: #003399;
 139              font-family: Verdana,Geneva, Arial, Helvetica, Sans-Serif;\">".$sitename."&nbsp;&bull;&nbsp;".$nbrpagestotal[$site]." &nbsp;".$language['page']."</option>\n";
 140  
 141  
 142          echo"</select></form></div>\n";
 143          
 144          echo"</div>\n";
 145          
 146          }
 147  
 148      }
 149          
 150  ?>