[ Index ]
 

Code source de Cr@wltr@ck 2.2.1

Accédez au Source d'autres logiciels libresSoutenez Angelica Josefina !

title

Body

[fermer]

/include/ -> display-all-pages.php (source)

   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: display-all-pages.php

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

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

  22  $nbrcrawlerpage=array();
  23  $nbvisits=array();
  24  $lastdatedisplay=array();
  25  
  26  $crawlencode=urlencode($crawler);
  27  $cachename=$navig.$period.$site.$order.$crawlencode.$displayall.$firstdayweek.$localday.$graphpos.$crawltlang;
  28  
  29  //start the caching if fopen exist

  30  if(function_exists('fopen'))
  31      {
  32      $ch = new cache($cachename);
  33      }
  34  
  35  //database connection

  36  $connexion = mysql_connect($crawlthost,$crawltuser,$crawltpassword) or die("MySQL connection to database problem");
  37  $selection = mysql_select_db($crawltdb) or die("MySQL database selection problem");
  38  
  39  //include menu 

  40  include "include/menumain.php";
  41  include "include/menusite.php";
  42  include "include/timecache.php"; 
  43  //order case    

  44  if($order==0)
  45      {    
  46      //case date

  47      $orderby="maxdate DESC";    
  48      }
  49  elseif($order==1 OR $order==4)
  50      {
  51      //case pages viewed

  52      $orderby="maxcrawler DESC";         
  53      }
  54  elseif($order==2)
  55      {
  56      //case visits

  57      $orderby="maxvisites DESC";                   
  58      }
  59  elseif($order==3)
  60      {
  61      //case crawlers

  62      $orderby="url_page ASC";        
  63      }
  64  //date format

  65  if($period == 0 OR $period >= 1000)
  66      {
  67      $datequery= "DATE_FORMAT(MAX(FROM_UNIXTIME(UNIX_TIMESTAMP(date)-($times*3600))), '%H&nbsp;hr&nbsp;%i&nbsp;mn')";
  68      }
  69  else
  70      {
  71      $datequery= "DATE_FORMAT(MAX(FROM_UNIXTIME(UNIX_TIMESTAMP(date)-($times*3600))), '%d/%m/%Y<br>%H&nbsp;hr&nbsp;%i&nbsp;mn')";    
  72      }
  73  //limite to 

  74  if($displayall=='no')
  75      {
  76      $limitquery='LIMIT '.$rowdisplay;
  77      }
  78  else
  79      {
  80      $limitquery='';
  81      }
  82  //date for the mysql query

  83  if($period>=10)
  84      {
  85      $datetolookfor=" date >'".sql_quote($daterequest)."' 
  86      AND  date <'".sql_quote($daterequest2)."'";    
  87      }
  88  else
  89      {
  90      $datetolookfor=" date >'".sql_quote($daterequest)."'";
  91      }       
  92   //requete to count the number of crawler per page and to list the page viewed and to count the number of visits per page and to have the date of last visit for each pages          

  93  
  94  $sqlstats = "SELECT  url_page, COUNT(DISTINCT crawler_name) as maxcrawler,  COUNT(DISTINCT id_visit) as maxvisites,
  95  MAX(FROM_UNIXTIME(UNIX_TIMESTAMP(date)-($times*3600), '%Y-%m-%d %H:%i:%s')) as maxdate,
  96  $datequery 
  97  FROM crawlt_visits, crawlt_crawler, crawlt_pages
  98  WHERE crawlt_visits.crawlt_crawler_id_crawler=crawlt_crawler.id_crawler 
  99  AND  crawlt_visits.crawlt_pages_id_page=crawlt_pages.id_page 
 100  AND $datetolookfor    
 101  AND crawlt_visits.crawlt_site_id_site='".sql_quote($site)."'    
 102  GROUP BY crawlt_pages_id_page
 103  ORDER BY $orderby 
 104  $limitquery";
 105          
 106  $requetestats = mysql_query($sqlstats, $connexion) or die("MySQL query error");
 107  
 108      
 109  $nbrresult=mysql_num_rows($requetestats);
 110  if($nbrresult>=1)
 111      {
 112      $onlyarchive=0;
 113      
 114      while ($ligne = mysql_fetch_row($requetestats))  
 115              {
 116              $nbrcrawlerpage[$ligne[0]]=$ligne[1];
 117              $nbvisits[$ligne[0]]=$ligne[2];
 118              $lastdatedisplay[$ligne[0]]=$ligne[4]; 
 119              }           
 120  
 121   
 122       //first we check if that calculation has not already been done

 123      if( isset($_SESSION['nbrtotpages-'.$cachename]) && isset($_SESSION['nbrtotcrawlers-'.$cachename]) && isset($_SESSION['nbrtotvisits-'.$cachename]))
 124          { 
 125          $nbrtotpages = $_SESSION['nbrtotpages-'.$cachename];
 126          $nbrtotcrawlers = $_SESSION['nbrtotcrawlers-'.$cachename];
 127          $nbrtotvisits = $_SESSION['nbrtotvisits-'.$cachename];  
 128          }
 129      else
 130          {    
 131          $sqlstats2 = "SELECT COUNT(DISTINCT crawlt_pages_id_page), COUNT(DISTINCT crawler_name), COUNT(DISTINCT id_visit) FROM crawlt_visits, crawlt_crawler
 132          WHERE crawlt_visits.crawlt_crawler_id_crawler=crawlt_crawler.id_crawler
 133          AND $datetolookfor         
 134          AND crawlt_visits.crawlt_site_id_site='".sql_quote($site)."'"; 
 135          
 136          $requetestats2 = mysql_query($sqlstats2, $connexion) or die("MySQL query error");
 137          $ligne2 = mysql_fetch_row($requetestats2);
 138          $nbrtotpages=$ligne2[0];
 139          $nbrtotcrawlers=$ligne2[1];
 140          $nbrtotvisits=$ligne2[2];
 141          
 142          $_SESSION['nbrtotpages-'.$cachename] = $nbrtotpages;
 143          $_SESSION['nbrtotcrawlers-'.$cachename] = $nbrtotcrawlers;
 144          $_SESSION['nbrtotvisits-'.$cachename] = $nbrtotvisits;           
 145          }  
 146  
 147   
 148  //use of datas in archive

 149  $usearchive=0;
 150  if($period==3 OR ($period>=200 && $period<300) OR $period==5)
 151      {
 152      $beginperiod =  mktime(0,0,0,$monthbeginserver, 1, $yearbeginserver);        
 153      
 154      //data request

 155      $sqlarchive="SELECT mois, nbr_visits, pages_view FROM crawlt_archive";
 156      
 157      $requetearchive = mysql_query($sqlarchive, $connexion) or die("MySQL query error");
 158          
 159      $nbrresult=mysql_num_rows($requetearchive);
 160      if($nbrresult>=1)
 161          {
 162          while ($ligne = mysql_fetch_row($requetearchive))                                                                              
 163              {
 164              $sitetodisplay = explode('-',$ligne[0]);
 165              if($sitetodisplay[1]==$site)
 166                  {
 167                  $data=$sitetodisplay[0];
 168                  $archivdate=explode('/',$data);
 169                  $archivperiod =mktime(0,0,0,$archivdate[0], 1, $archivdate[1]);
 170                  if($archivperiod >=$beginperiod)
 171                      {
 172                      $nbrtotvisits=$nbrtotvisits+$ligne[1];
 173                      $usearchive=1;
 174                      }
 175  
 176                  }
 177              }
 178          }
 179              
 180      }    
 181      
 182     
 183          
 184   
 185      //display----------------------------------------------------------------------------------------------------

 186      echo"<div class=\"content\">\n";
 187      echo crawltbackforward('nbr_pages',$period,$daytodaylocal,$monthtodaylocal,$yeartodaylocal,$daybeginlocal,$monthbeginlocal,$yearbeginlocal,$dayendweek,$monthendweek,$yearendweek,$crawler,$navig,$site,$graphpos);   
 188      echo"</div>\n";
 189      
 190      if($graphpos==0 && $period != 5)
 191          {    
 192          //graph

 193          echo"<div align='center'>\n";
 194          echo"<a href=\"index.php?navig=$navig&amp;graphpos=1&amp;period=$period&amp;site=$site&amp;crawler=$crawlencode\">\n";        
 195          echo"<img src=\"./graphs/page-graph.php?nbrpageview=$nbrtotpages&amp;nbrpagestotal=$nbrpagestotal[$site]&amp;crawltlang=$crawltlang\" alt=\"graph\"  width=\"500px\" height=\"175px\" style=\"border:0\"/>\n";
 196          echo"</a>\n";        
 197          echo"</div>\n";    
 198          }        
 199      
 200      echo"<div class='tableau' align='center' onmouseover=\"javascript:montre();\">\n";    
 201      echo"<table   cellpadding='0px' cellspacing='0' width='550px'>\n";
 202      echo"<tr><th class='tableau1'>\n";
 203      echo"".$language['nbr_pages']."\n";
 204      echo"</th>\n";        
 205      echo"<th class='tableau1'>\n";
 206      echo"".$language['nbr_tot_visits']."\n";
 207      echo"</th>\n";
 208      echo"<th class='tableau2'>\n";
 209      echo"".$language['nbr_tot_crawlers']."\n";
 210      echo"</th></tr>\n";
 211      if($usearchive==0)
 212          {
 213          echo"<tr><td class='tableau3'>".numbdisp($nbrtotpages)."</td>\n";    
 214          echo"<td class='tableau3'>".numbdisp($nbrtotvisits)."</td>\n";
 215          echo"<td class='tableau5'>".numbdisp($nbrtotcrawlers)."</td></tr>\n";    
 216          echo"</table></div><br>\n";
 217          }
 218      else
 219          {
 220          echo"<tr><td class='tableau3'>".numbdisp($nbrtotpages)."*</td>\n";    
 221          echo"<td class='tableau3'>".numbdisp($nbrtotvisits)."</td>\n";
 222          echo"<td class='tableau5'>".numbdisp($nbrtotcrawlers)."*</td></tr>\n";
 223          echo"</table>\n";
 224          echo"<p>*".$language['use-archive']."</p></div><br>\n";
 225          }
 226  
 227       if($period != 5)
 228          {
 229          //graph

 230          echo"<div class='graphvisits'>\n";    
 231          //mapgraph

 232          include "include/mapgraph.php"; 
 233          echo"<img src=\"./graphs/visit-graph.php?crawltlang=$crawltlang&period=$period&navig=$navig&graphname=$graphname\" USEMAP=\"#visit\" alt=\"graph\" width=\"700\" heigth=\"300\"  border=\"0\"/>\n";
 234          echo"</div>\n";   
 235              echo"<div class='imprimgraph'>\n";       
 236          echo"&nbsp;<br><br><br><br><br><br></div>\n"; 
 237          }
 238      
 239      if($graphpos==1 && $period != 5)
 240          {    
 241          //graph

 242          echo"<br><h2>".$language['pc-page-view']."</h2>\n";    
 243          echo"<div align='center'>\n";
 244          echo"<a href=\"index.php?navig=$navig&amp;graphpos=0&amp;period=$period&amp;site=$site&amp;crawler=$crawlencode\">\n";        
 245          echo"<img src=\"./graphs/page-graph.php?nbrpageview=$nbrtotpages&amp;nbrpagestotal=$nbrpagestotal[$site]&amp;crawltlang=$crawltlang\" alt=\"graph\"  width=\"500px\" height=\"175px\" style=\"border:0\"/>\n";
 246          echo"</a>\n";        
 247          echo"</div>\n";    
 248          }
 249          
 250                 
 251      //change text if more than x crawlers    and display limited (value of x can be change in function.php,,it's displaynumber)

 252      if($nbrtotpages>=$rowdisplay && $displayall=='no' && $period !=5)
 253          {
 254          echo"<br><h2>";
 255          printf($language['100_visit_per-crawler'],$rowdisplay);
 256          echo"<br>\n";
 257           $crawlencode = urlencode($crawler);
 258          echo"<span class=\"smalltext\"><a href=\"index.php?navig=$navig&period=$period&site=$site&crawler=$crawlencode&order=$order&displayall=yes&graphpos=$graphpos\">".$language['show_all']."</a></span></h2>";
 259             }
 260      else
 261          {
 262          echo"<h2>".$language['visit_per-crawler']."</h2>\n";
 263          }        
 264          
 265          
 266          
 267          
 268          
 269      echo"<div class='tableau' align='center'>\n";    
 270      echo"<table   cellpadding='0px' cellspacing='0' width='100%'>\n";
 271      if($order==3)
 272          {
 273          echo"<tr><th class='tableau1' colspan=\"2\">\n";
 274          echo"<form action=\"index.php\" method=\"POST\" >\n";
 275          echo "<input type=\"hidden\" name ='order' value=\"3\">\n";            
 276          echo "<input type=\"hidden\" name ='period' value=\"$period\">\n";
 277          echo "<input type=\"hidden\" name ='graphpos' value=\"$graphpos\">\n";        
 278          echo "<input type=\"hidden\" name ='navig' value=\"$navig\">\n";
 279          echo "<input type=\"hidden\" name ='crawler' value=\"$crawler\">\n";
 280          echo "<input type=\"hidden\" name ='site' value=\"$site\">\n";        
 281          echo"<input type='submit' class='orderselect' value='".$language['nbr_pages']."'>\n";
 282          echo"</form>\n";        
 283          echo"</th>\n";
 284          }
 285      else
 286          {
 287          echo"<tr><th class='tableau1' colspan=\"2\">\n";
 288          echo"<form action=\"index.php\" method=\"POST\" >\n";
 289          echo "<input type=\"hidden\" name ='order' value=\"3\">\n";            
 290          echo "<input type=\"hidden\" name ='period' value=\"$period\">\n";
 291          echo "<input type=\"hidden\" name ='graphpos' value=\"$graphpos\">\n";        
 292          echo "<input type=\"hidden\" name ='navig' value=\"$navig\">\n";
 293          echo "<input type=\"hidden\" name ='crawler' value=\"$crawler\">\n";
 294          echo "<input type=\"hidden\" name ='site' value=\"$site\">\n";        
 295          echo"<input type='submit' class='order' value='".$language['nbr_pages']."'>\n";
 296          echo"</form>\n";        
 297          echo"</th>\n";
 298          }    
 299          
 300      if($order==2)
 301              {
 302              echo"<th class='tableau1'>\n";
 303              echo"<form action=\"index.php\" method=\"POST\" >\n";
 304              echo "<input type=\"hidden\" name ='order' value=\"2\">\n";            
 305              echo "<input type=\"hidden\" name ='period' value=\"$period\">\n";
 306              echo "<input type=\"hidden\" name ='graphpos' value=\"$graphpos\">\n";            
 307              echo "<input type=\"hidden\" name ='navig' value=\"$navig\">\n";
 308              echo "<input type=\"hidden\" name ='crawler' value=\"$crawler\">\n";
 309              echo "<input type=\"hidden\" name ='site' value=\"$site\">\n";            
 310              echo"<input type='submit' class='orderselect' value='".$language['nbr_visits']."'>\n";
 311              echo"</form>\n";            
 312              echo"</th>\n";
 313              }
 314          else
 315              {
 316              echo"<th class='tableau1'>\n";
 317              echo"<form action=\"index.php\" method=\"POST\" >\n";
 318              echo "<input type=\"hidden\" name ='order' value=\"2\">\n";            
 319              echo "<input type=\"hidden\" name ='period' value=\"$period\">\n";
 320              echo "<input type=\"hidden\" name ='graphpos' value=\"$graphpos\">\n";            
 321              echo "<input type=\"hidden\" name ='navig' value=\"$navig\">\n";
 322              echo "<input type=\"hidden\" name ='crawler' value=\"$crawler\">\n";
 323              echo "<input type=\"hidden\" name ='site' value=\"$site\">\n";            
 324              echo"<input type='submit' class='order' value='".$language['nbr_visits']."'>\n";
 325              echo"</form>\n";
 326              echo"</th>\n";
 327              }            
 328      if($order==1)
 329              {
 330              if($period !=5)
 331                  {            
 332                  echo"<th class='tableau1' >\n";
 333                  }
 334              else
 335                  {
 336                  echo"<th class='tableau2' >\n";                
 337                  }
 338              echo"<form action=\"index.php\" method=\"POST\" >\n";
 339              echo "<input type=\"hidden\" name ='order' value=\"1\">\n";            
 340              echo "<input type=\"hidden\" name ='period' value=\"$period\">\n";
 341              echo "<input type=\"hidden\" name ='graphpos' value=\"$graphpos\">\n";           
 342              echo "<input type=\"hidden\" name ='navig' value=\"$navig\">\n";
 343              echo "<input type=\"hidden\" name ='crawler' value=\"$crawler\">\n";
 344              echo "<input type=\"hidden\" name ='site' value=\"$site\">\n";            
 345              echo"<input type='submit' class='orderselect' value='".$language['crawler_name']."'>\n";
 346              echo"</form>\n";            
 347              echo"</th>\n";
 348              echo"</th>\n";
 349              }
 350          else
 351              {
 352              if($period !=5)
 353                  {            
 354                  echo"<th class='tableau1' >\n";
 355                  }
 356              else
 357                  {
 358                  echo"<th class='tableau2' >\n";                
 359                  }
 360              echo"<form action=\"index.php\" method=\"POST\" >\n";
 361              echo "<input type=\"hidden\" name ='order' value=\"1\">\n";            
 362              echo "<input type=\"hidden\" name ='period' value=\"$period\">\n";
 363              echo "<input type=\"hidden\" name ='graphpos' value=\"$graphpos\">\n";            
 364              echo "<input type=\"hidden\" name ='navig' value=\"$navig\">\n";
 365              echo "<input type=\"hidden\" name ='crawler' value=\"$crawler\">\n";
 366              echo "<input type=\"hidden\" name ='site' value=\"$site\">\n";            
 367              echo"<input type='submit' class='order' value='".$language['crawler_name']."'>\n";
 368              echo"</form>\n";            
 369              echo"</th>\n";
 370              }
 371      if($period !=5)
 372          {
 373          if($order==0)
 374                  {
 375                  echo"<th class='tableau2'>\n";            
 376                  echo"<form action=\"index.php\" method=\"POST\" >\n";
 377                  echo "<input type=\"hidden\" name ='order' value=\"0\">\n";            
 378                  echo "<input type=\"hidden\" name ='period' value=\"$period\">\n";
 379                  echo "<input type=\"hidden\" name ='graphpos' value=\"$graphpos\">\n";            
 380                  echo "<input type=\"hidden\" name ='navig' value=\"$navig\">\n";
 381                  echo "<input type=\"hidden\" name ='crawler' value=\"$crawler\">\n";
 382                  echo "<input type=\"hidden\" name ='site' value=\"$site\">\n";            
 383                  echo"<input type='submit' class='orderselect' value='".$language['date_visits']."'>\n";
 384                  echo"</form>\n";
 385                  echo"</th></tr>\n";
 386                  }
 387              else
 388                  {
 389                  echo"<th class='tableau2'>\n";
 390                  echo"<form action=\"index.php\" method=\"POST\" >\n";
 391                  echo "<input type=\"hidden\" name ='order' value=\"0\">\n";            
 392                  echo "<input type=\"hidden\" name ='period' value=\"$period\">\n";
 393                  echo "<input type=\"hidden\" name ='graphpos' value=\"$graphpos\">\n";            
 394                  echo "<input type=\"hidden\" name ='navig' value=\"$navig\">\n";
 395                  echo "<input type=\"hidden\" name ='crawler' value=\"$crawler\">\n";
 396                  echo "<input type=\"hidden\" name ='site' value=\"$site\">\n";            
 397                  echo"<input type='submit' class='order' value='".$language['date_visits']."'>\n";
 398                  echo"</form>\n";
 399                  echo"</th></tr>\n";
 400                  }
 401          }
 402      else
 403          {
 404          echo"</tr>\n";
 405          }
 406      //counter for alternate color lane

 407      $comptligne=2;
 408      
 409      
 410      foreach ($nbvisits as $key => $value)
 411          {
 412          $crawldisplay = crawltcutkeyword($key,'60');
 413          
 414          $nbrpage=$nbrcrawlerpage[$key];
 415          
 416          $crawlencode=urlencode($key);
 417          
 418          //to avoid problem if the url is enter in the database with http://

 419          if (!eregi("^http://", $urlsite[$site]))
 420              {
 421              $urlpage="http://".$urlsite[$site].$key;
 422              }
 423          else
 424              {
 425              $urlpage= $urlsite[$site].$key;
 426              } 
 427      
 428          if ($comptligne%2 ==0)
 429              {
 430              echo"<tr><td class='tableau3g'";
 431              if($keywordcut==1)
 432                  {
 433                  echo"onmouseover=\"javascript:montre('smenu".($comptligne+40)."');\"   onmouseout=\"javascript:montre();\"";
 434                  }
 435              echo">&nbsp;&nbsp;<a href='index.php?navig=4&amp;period=".$period."&amp;site=".$site."&amp;crawler=".$crawlencode."&amp;graphpos=".$graphpos."' rel='nofollow'>".$crawldisplay."</a></td>\n";
 436              echo"<td class='tableau6' width=\"8%\">\n"; 
 437                
 438              echo"<a href='".$urlpage."' rel='nofollow'><img src=\"./images/page.png\" width=\"16\" height=\"16\" border=\"0\" ></a>\n";
 439              echo"</td> \n";
 440              echo"<td class='tableau3'>".numbdisp($nbvisits[$key])."</td>\n";
 441                          
 442              if($period !=5)
 443                  {
 444                  echo"<td class='tableau3' width='60px'>".numbdisp($nbrpage)."</td> \n";
 445                  echo"<td class='tableau5'>".$lastdatedisplay[$key]."</td></tr>\n";
 446                  }
 447              else
 448                  {
 449                  echo"<td class='tableau5' width='60px'>".numbdisp($nbrpage)."</td> \n";
 450                  echo"</tr> \n";
 451                  }
 452              }
 453          else
 454              {
 455              echo"<tr><td class='tableau30g'";
 456              if($keywordcut==1)
 457                  {
 458                  echo"onmouseover=\"javascript:montre('smenu".($comptligne+40)."');\"   onmouseout=\"javascript:montre();\"";
 459                  }                
 460              echo">&nbsp;&nbsp;<a href='index.php?navig=4&amp;period=".$period."&amp;site=".$site."&amp;crawler=".$crawlencode."&amp;graphpos=".$graphpos."' rel='nofollow'>".$crawldisplay."</a></td>\n";
 461              echo"<td class='tableau60' width=\"8%\">\n"; 
 462              echo"<a href='".$urlpage."' rel='nofollow'><img src=\"./images/page.png\" width=\"16\" height=\"16\" border=\"0\" ></a>\n";
 463              echo"</td> \n";                
 464              echo"<td class='tableau30'>".numbdisp($nbvisits[$key])."</td>\n";
 465                          
 466              if($period !=5)
 467                  {
 468                  echo"<td class='tableau30' width='60px'>".numbdisp($nbrpage)."</td> \n";           
 469                  echo"<td class='tableau50'>".$lastdatedisplay[$key]."</td></tr>\n";
 470                  }
 471              else
 472                  {
 473                  echo"<td class='tableau50' width='60px'>".numbdisp($nbrpage)."</td> \n";
 474                  echo"</tr> \n";
 475                  }                    
 476              }                
 477          if($keywordcut==1)
 478              {
 479              if($period==0 OR $period>=1000)
 480                  {
 481                  $step=25;
 482                  }
 483              else
 484                  {
 485                  $step=30;
 486                  }                
 487              echo"<div id=\"smenu".($comptligne+40)."\"  style=\"display:none; font-size:14px; font-weight:bold; color:#ff0000; font-family:Verdana,Geneva, Arial, Helvetica, Sans-Serif; text-align:left; border:2px solid navy; position:absolute; top:".(800+(($comptligne-3)*$step))."px; left:5px; background:#fff;\">\n";      
 488              echo"&nbsp;".crawltcuturl($key,'92')."&nbsp;\n";
 489              echo"</div>\n";
 490              }           
 491          $comptligne++;
 492  
 493      
 494          }
 495  
 496      echo"</table>\n";
 497      echo"<br>\n";
 498          
 499      }
 500  else //case no visits (or visits in archive)
 501      {    
 502      //use of datas in archive

 503      $usearchive=0;
 504      $nbrtotvisits=0;
 505      if($period==3 OR ($period>=200 && $period<300) OR $period==5)
 506          {
 507          $beginperiod =  mktime(0,0,0,$monthbeginserver, 1, $yearbeginserver);        
 508          $endperiod =  mktime(0,0,0,$monthbeginserver, 1, ($yearbeginserver+1));
 509          //data request

 510          $sqlarchive="SELECT mois, nbr_visits, pages_view, top_visits_1,top_visits_2,top_visits_3,top_pages_view_1,top_pages_view_2,top_pages_view_3 FROM crawlt_archive";
 511          
 512          $requetearchive = mysql_query($sqlarchive, $connexion) or die("MySQL query error");
 513              
 514          $nbrresult=mysql_num_rows($requetearchive);
 515          if($nbrresult>=1)
 516              {
 517              $i=0;
 518              while ($ligne = mysql_fetch_row($requetearchive))                                                                              
 519                  {
 520                  $sitetodisplay = explode('-',$ligne[0]);
 521                  if($sitetodisplay[1]==$site)
 522                      {
 523                      $data=$sitetodisplay[0];
 524                      $archivdate=explode('/',$data);
 525                      $archivperiod =mktime(0,0,0,$archivdate[0], 1, $archivdate[1]);
 526                      if($archivperiod >=$beginperiod && $archivperiod<$endperiod)
 527                          {
 528                          $listid[]=$i;        
 529                          $month[]=$sitetodisplay[0];
 530                          $visit[]=$ligne[1];
 531                          $page[]=$ligne[2];
 532                          $topvisit[]=$ligne[3]."<br>&nbsp;&nbsp;".$ligne[4]."<br>&nbsp;&nbsp;".$ligne[5];
 533                          $toppage[]=$ligne[6]."<br>&nbsp;&nbsp;".$ligne[7]."<br>&nbsp;&nbsp;".$ligne[8];
 534                          $i++;
 535                          $usearchive=1;
 536                          }
 537      
 538                      }
 539                  }
 540              }
 541                  
 542          }    
 543      
 544      if($usearchive==0)
 545          {
 546          echo"<div class=\"content\">\n";
 547          echo crawltbackforward('nbr_pages',$period,$daytodaylocal,$monthtodaylocal,$yeartodaylocal,$daybeginlocal,$monthbeginlocal,$yearbeginlocal,$dayendweek,$monthendweek,$yearendweek,$crawler,$navig,$site,$graphpos);
 548          echo"<h1>".$language['no_visit']."</h1>\n";
 549          echo"<br>\n";    
 550          }
 551      else
 552          { 
 553          $onlyarchive=1;
 554                     
 555          echo"<div class=\"content\">\n"; 
 556          echo crawltbackforward('nbr_pages',$period,$daytodaylocal,$monthtodaylocal,$yeartodaylocal,$daybeginlocal,$monthbeginlocal,$yearbeginlocal,$dayendweek,$monthendweek,$yearendweek,$crawler,$navig,$site,$graphpos);
 557          echo"<h1>".$language['archive']."</h1><br>\n";
 558          
 559          echo"<div width='100%' align='center'>\n";    
 560          echo"<table   cellpadding='0px' cellspacing='0' width='100%'>\n";
 561          echo"<tr><th class='tableau11'>\n";
 562          echo"".$language['month2']."\n";
 563          echo"</th>\n";        
 564          echo"<th class='tableau11'>\n";
 565          echo"".$language['nbr_tot_visits']."\n";
 566          echo"</th>\n";
 567          echo"<th class='tableau11'>\n";
 568          echo"".$language['nbr_tot_pages']."\n";
 569          echo"</th>\n";
 570          echo"<th class='tableau11'>\n";
 571          echo"".$language['top_visits']."\n";
 572          echo"</th>\n";
 573          echo"<th class='tableau22'>\n";
 574          echo"".$language['top_pages']."\n";
 575          echo"</th></tr>\n";
 576  
 577  
 578          //counter for alternate color lane

 579          $comptligne=2;
 580  
 581          foreach ($listid as $id)
 582              {
 583                  if ($comptligne%2 ==0)
 584                      {            
 585                      echo"<tr><td class='tableau33'>&nbsp;".$month[$id]."&nbsp;</td>\n";
 586                      echo"<td class='tableau33'>".numbdisp($visit[$id])."</td>\n";
 587                      echo"<td class='tableau33'>".numbdisp($page[$id])."</td> \n";
 588                      echo"<td class='tableau33g'>&nbsp;&nbsp;".$topvisit[$id]."</td> \n";
 589                      echo"<td class='tableau55g'>&nbsp;&nbsp;".$toppage[$id]."</td></tr>\n";
 590                      }
 591                  else
 592                      {            
 593                      echo"<tr><td class='tableau330'>&nbsp;".$month[$id]."&nbsp;</td>\n";
 594                      echo"<td class='tableau330'>".numbdisp($visit[$id])."</td>\n";
 595                      echo"<td class='tableau330'>".numbdisp($page[$id])."</td> \n";
 596                      echo"<td class='tableau330g'>&nbsp;&nbsp;".$topvisit[$id]."</td> \n";
 597                      echo"<td class='tableau550g'>&nbsp;&nbsp;".$toppage[$id]."</td></tr>\n";
 598                      }   
 599              $comptligne++;                     
 600              }
 601      
 602          echo"</table></div><br>\n";        
 603  
 604          //graph

 605          echo"<div class='graphvisits' >\n";    
 606          //mapgraph

 607          include "include/mapgraph.php";
 608          echo"<img src=\"./graphs/visit-graph.php?crawltlang=$crawltlang&period=$period&navig=$navig&graphname=$graphname\" USEMAP=\"#visit\" alt=\"graph\" width=\"700\" heigth=\"300\"  border=\"0\"/>\n";
 609          echo"<div class='imprimgraph'>\n";       
 610          echo"&nbsp;<br><br><br><br><br><br></div>\n";         
 611          echo"</div><br><br>\n";     
 612          }
 613  
 614      }
 615  
 616  ?>


Généré le : Thu Sep 6 14:14:11 2007 par Balluche grâce à PHPXref 0.7