| [ Index ] |
|
Code source de Cr@wltr@ck 2.2.1 |
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-crawlers.php 14 //---------------------------------------------------------------------- 15 if (!defined('IN_CRAWLT')) 16 { 17 echo"<h1>Hacking attempt !!!!</h1>"; 18 exit(); 19 } 20 //initialize array 21 $nbrcrawlerpage=array(); 22 $nbvisits=array(); 23 $lastdatedisplay=array(); 24 $values=array(); 25 //cache name 26 $crawlencode=urlencode($crawler); 27 $cachename=$navig.$period.$site.$order.$crawlencode.$displayall.$firstdayweek.$localday.$graphpos.$crawltlang; 28 //start the caching if fopen exist 29 if(function_exists('fopen')) 30 { 31 $ch = new cache($cachename); 32 } 33 //database connection 34 $connexion = mysql_connect($crawlthost,$crawltuser,$crawltpassword) or die("MySQL connection to database problem"); 35 $selection = mysql_select_db($crawltdb) or die("MySQL database selection problem"); 36 //include menu 37 include "include/menumain.php"; 38 include "include/menusite.php"; 39 include "include/timecache.php"; 40 //order case 41 if($order==0) 42 { 43 //case date 44 $orderby="maxdate DESC"; 45 } 46 elseif($order==1 OR $order==4) 47 { 48 //case pages viewed 49 $orderby="maxpages DESC"; 50 } 51 elseif($order==2) 52 { 53 //case visits 54 $orderby="maxvisites DESC"; 55 } 56 elseif($order==3) 57 { 58 //case crawlers 59 $orderby="crawler_name ASC"; 60 } 61 //date format 62 if($period == 0 OR $period >= 1000) 63 { 64 $datequery= "DATE_FORMAT(MAX(FROM_UNIXTIME(UNIX_TIMESTAMP(date)-($times*3600))), '%H hr %i mn')"; 65 } 66 else 67 { 68 $datequery= "DATE_FORMAT(MAX(FROM_UNIXTIME(UNIX_TIMESTAMP(date)-($times*3600))), '%d/%m/%Y<br>%H hr %i mn')"; 69 } 70 //limite to (value can be modified in the function.php file) 71 if($displayall=='no') 72 { 73 $limitquery='LIMIT '.$rowdisplay; 74 } 75 else 76 { 77 $limitquery=''; 78 } 79 //date for the mysql query 80 if($period>=10) 81 { 82 $datetolookfor=" date >'".sql_quote($daterequest)."' 83 AND date <'".sql_quote($daterequest2)."'"; 84 } 85 else 86 { 87 $datetolookfor=" date >'".sql_quote($daterequest)."'"; 88 } 89 //requete to count the number of page per crawler and to list the crawler and to count the number of visits per crawler and to have the date of last visit for each crawler 90 $sqlstats = "SELECT crawler_name, COUNT(DISTINCT crawlt_pages_id_page) as maxpages, COUNT(DISTINCT id_visit) as maxvisites , 91 MAX(FROM_UNIXTIME(UNIX_TIMESTAMP(date)-($times*3600), '%Y-%m-%d %H:%i:%s')) as maxdate, 92 $datequery 93 FROM crawlt_visits, crawlt_crawler 94 WHERE crawlt_visits.crawlt_crawler_id_crawler=crawlt_crawler.id_crawler 95 AND $datetolookfor 96 AND crawlt_visits.crawlt_site_id_site='".sql_quote($site)."' 97 GROUP BY crawler_name 98 ORDER BY $orderby 99 $limitquery"; 100 101 $requetestats = mysql_query($sqlstats, $connexion) or die("MySQL query error"); 102 103 $nbrresult=mysql_num_rows($requetestats); 104 if($nbrresult>=1) 105 { 106 $onlyarchive=0; 107 108 while ($ligne = mysql_fetch_row($requetestats)) 109 { 110 $nbrcrawlerpage[$ligne[0]]=$ligne[1]; 111 $nbvisits[$ligne[0]]=$ligne[2]; 112 $lastdatedisplay[$ligne[0]]=$ligne[4]; 113 } 114 115 //requete to count the total number of pages viewed ,total number of visits and total number of crawler 116 117 //first we check if that calculation has not already been done 118 if( isset($_SESSION['nbrtotpages-'.$cachename]) && isset($_SESSION['nbrtotcrawlers-'.$cachename]) && isset($_SESSION['nbrtotvisits-'.$cachename])) 119 { 120 $nbrtotpages = $_SESSION['nbrtotpages-'.$cachename]; 121 $nbrtotcrawlers = $_SESSION['nbrtotcrawlers-'.$cachename]; 122 $nbrtotvisits = $_SESSION['nbrtotvisits-'.$cachename]; 123 } 124 else 125 { 126 $sqlstats2 = "SELECT COUNT(DISTINCT crawlt_pages_id_page), COUNT(DISTINCT crawler_name), COUNT(DISTINCT id_visit) FROM crawlt_visits, crawlt_crawler 127 WHERE crawlt_visits.crawlt_crawler_id_crawler=crawlt_crawler.id_crawler 128 AND $datetolookfor 129 AND crawlt_visits.crawlt_site_id_site='".sql_quote($site)."'"; 130 131 $requetestats2 = mysql_query($sqlstats2, $connexion) or die("MySQL query error"); 132 $ligne2 = mysql_fetch_row($requetestats2); 133 $nbrtotpages=$ligne2[0]; 134 $nbrtotcrawlers=$ligne2[1]; 135 $nbrtotvisits=$ligne2[2]; 136 137 $_SESSION['nbrtotpages-'.$cachename] = $nbrtotpages; 138 $_SESSION['nbrtotcrawlers-'.$cachename] = $nbrtotcrawlers; 139 $_SESSION['nbrtotvisits-'.$cachename] = $nbrtotvisits; 140 } 141 142 //use of datas in archive 143 $usearchive=0; 144 if($period==3 OR ($period>=200 && $period<300) OR $period==5) 145 { 146 $beginperiod = mktime(0,0,0,$monthbeginserver, 1, $yearbeginserver); 147 148 //data request 149 $sqlarchive="SELECT mois, nbr_visits, pages_view FROM crawlt_archive"; 150 151 $requetearchive = mysql_query($sqlarchive, $connexion) or die("MySQL query error"); 152 153 $nbrresult=mysql_num_rows($requetearchive); 154 if($nbrresult>=1) 155 { 156 while ($ligne = mysql_fetch_row($requetearchive)) 157 { 158 $sitetodisplay = explode('-',$ligne[0]); 159 if($sitetodisplay[1]==$site) 160 { 161 $data=$sitetodisplay[0]; 162 $archivdate=explode('/',$data); 163 $archivperiod =mktime(0,0,0,$archivdate[0], 1, $archivdate[1]); 164 if($archivperiod >=$beginperiod) 165 { 166 $nbrtotvisits=$nbrtotvisits+$ligne[1]; 167 $usearchive=1; 168 } 169 170 } 171 } 172 } 173 174 } 175 176 //query & treatment to prepare the display of the top 5 and group the other in the 'Other' category in the crawler graph 177 $sqlstats = "SELECT crawler_name, COUNT(DISTINCT id_visit) as maxvisites FROM crawlt_visits, crawlt_crawler 178 WHERE crawlt_visits.crawlt_crawler_id_crawler=crawlt_crawler.id_crawler 179 AND $datetolookfor 180 AND crawlt_visits.crawlt_site_id_site='".sql_quote($site)."' 181 GROUP BY crawler_name 182 ORDER BY maxvisites DESC 183 LIMIT 5"; 184 185 $requetestats = mysql_query($sqlstats, $connexion) or die("MySQL query error"); 186 187 $totaltop5 = 0; 188 189 while ($ligne = mysql_fetch_row($requetestats)) 190 { 191 if(strlen("$ligne[0]")>15) 192 { 193 $values[substr("$ligne[0]",0,15)."..."]=$ligne[1]; 194 } 195 else 196 { 197 $values[$ligne[0]]=$ligne[1]; 198 } 199 $totaltop5 = $totaltop5 + $ligne[1]; 200 } 201 202 If ($totaltop5 < $nbrtotvisits) 203 { 204 $values[$language['other']] = ($nbrtotvisits -$totaltop5); 205 } 206 207 208 //prepare datas to be transfert to graph file 209 $datatransferttograph=addslashes(urlencode(serialize($values))); 210 //insert the values in the graph table 211 $piegraphname="crawler-".$cachename; 212 213 //check if this graph exit already in the table 214 $sql = "SELECT name FROM crawlt_graph 215 WHERE name= '".sql_quote($piegraphname)."'"; 216 217 218 $requete = mysql_query($sql, $connexion) or die("MySQL query error"); 219 $nbrresult=mysql_num_rows($requete); 220 if($nbrresult >=1) 221 { 222 $sql2 ="UPDATE crawlt_graph SET graph_values='".sql_quote($datatransferttograph)."' 223 WHERE name= '".sql_quote($piegraphname)."'"; 224 } 225 else 226 { 227 $sql2 ="INSERT INTO crawlt_graph (name,graph_values) VALUES ( '".sql_quote($piegraphname)."','".sql_quote($datatransferttograph)."')"; 228 } 229 $requete2 = mysql_query($sql2, $connexion) or die("MySQL query error"); 230 231 232 //display---------------------------------------------------------------------------------------------------- 233 echo"<div class=\"content\">\n"; 234 echo crawltbackforward('crawler_name',$period,$daytodaylocal,$monthtodaylocal,$yeartodaylocal,$daybeginlocal,$monthbeginlocal,$yearbeginlocal,$dayendweek,$monthendweek,$yearendweek,$crawler,$navig,$site,$graphpos); 235 echo"</div>\n"; 236 237 if($graphpos==0) 238 { 239 //graph 240 echo"<div align=\"center\">\n"; 241 echo"<a href=\"index.php?navig=$navig&graphpos=1&period=$period&site=$site&crawler=$crawlencode\">\n"; 242 echo"<img src=\"./graphs/crawler-graph.php?graphname=$piegraphname\" alt=\"graph\" width=\"450\" heigth=\"175\" style=\"border:0\"/>\n"; 243 echo"</a>\n"; 244 echo"</div>\n"; 245 } 246 247 //summary table display 248 echo"<div class='tableau' align='center' onmouseout=\"javascript:montre();\">\n"; 249 echo"<table cellpadding='0px' cellspacing='0' width='550px'>\n"; 250 echo"<tr><th class='tableau1' >\n"; 251 echo"".$language['nbr_tot_crawlers']."\n"; 252 echo"</th>\n"; 253 echo"<th class='tableau1'>\n"; 254 echo"".$language['nbr_tot_visits']."\n"; 255 echo"</th>\n"; 256 echo"<th class='tableau2'>\n"; 257 echo"".$language['nbr_tot_pages']."\n"; 258 echo"</th></tr>\n"; 259 if($usearchive==0) 260 { 261 echo"<tr><td class='tableau3'>".numbdisp($nbrtotcrawlers)."</td>\n"; 262 echo"<td class='tableau3'>".numbdisp($nbrtotvisits)."</td>\n"; 263 echo"<td class='tableau5'>".numbdisp($nbrtotpages)."</td></tr>\n"; 264 echo"</table></div><br>\n"; 265 } 266 else 267 { 268 echo"<tr><td class='tableau3'>".numbdisp($nbrtotcrawlers)."*</td>\n"; 269 echo"<td class='tableau3'>".numbdisp($nbrtotvisits)."</td>\n"; 270 echo"<td class='tableau5'>".numbdisp($nbrtotpages)."*</td></tr>\n"; 271 echo"</table>\n"; 272 echo"<p>*".$language['use-archive']."</p></div><br>\n"; 273 } 274 if($period != 5) 275 { 276 //graph 277 echo"<div class='graphvisits' >\n"; 278 //mapgraph 279 include "include/mapgraph.php"; 280 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"; 281 echo"</div>\n"; 282 echo"<div class='imprimgraph'>\n"; 283 echo" <br><br><br><br><br><br></div>\n"; 284 } 285 286 if($graphpos==1) 287 { 288 //graph 289 echo"<br><h2>".$language['crawler_name']."</h2>\n"; 290 echo"<div align=\"center\">\n"; 291 echo"<a href=\"index.php?navig=$navig&graphpos=0&period=$period&site=$site&crawler=$crawlencode\">\n"; 292 echo"<img src=\"./graphs/crawler-graph.php?graphname=$piegraphname\" alt=\"graph\" width=\"450\" heigth=\"175\" style=\"border:0\"/>\n"; 293 echo"</a>\n"; 294 echo"</div>\n"; 295 } 296 297 298 //change text if more than x crawlers and display limited (value of x can be change in function.php,,it's displaynumber) 299 if($nbrtotcrawlers>=$rowdisplay && $displayall=='no') 300 { 301 echo"<br><h2>"; 302 printf($language['100_visit_per-crawler'],$rowdisplay); 303 echo"<br>\n"; 304 $crawlencode = urlencode($crawler); 305 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>"; 306 } 307 else 308 { 309 echo"<h2>".$language['visit_per-crawler']."</h2>\n"; 310 } 311 312 313 314 echo"<div class='tableau' align='center'>\n"; 315 echo"<table cellpadding='0px' cellspacing='0' width='100%'>\n"; 316 if($order==3) 317 { 318 echo"<tr><th class='tableau1'>\n"; 319 echo"<form action=\"index.php\" method=\"POST\" >\n"; 320 echo "<input type=\"hidden\" name ='order' value=\"3\">\n"; 321 echo "<input type=\"hidden\" name ='period' value=\"$period\">\n"; 322 echo "<input type=\"hidden\" name ='graphpos' value=\"$graphpos\">\n"; 323 echo "<input type=\"hidden\" name ='navig' value=\"$navig\">\n"; 324 echo "<input type=\"hidden\" name ='crawler' value=\"$crawler\">\n"; 325 echo "<input type=\"hidden\" name ='site' value=\"$site\">\n"; 326 echo"<input type='submit' class='orderselect' value='".$language['crawler_name']."'>\n"; 327 echo"</form>\n"; 328 echo"</th>\n"; 329 } 330 else 331 { 332 echo"<tr><th class='tableau1'>\n"; 333 echo"<form action=\"index.php\" method=\"POST\" >\n"; 334 echo "<input type=\"hidden\" name ='order' value=\"3\">\n"; 335 echo "<input type=\"hidden\" name ='period' value=\"$period\">\n"; 336 echo "<input type=\"hidden\" name ='graphpos' value=\"$graphpos\">\n"; 337 echo "<input type=\"hidden\" name ='navig' value=\"$navig\">\n"; 338 echo "<input type=\"hidden\" name ='crawler' value=\"$crawler\">\n"; 339 echo "<input type=\"hidden\" name ='site' value=\"$site\">\n"; 340 echo"<input type='submit' class='order' value='".$language['crawler_name']."'>\n"; 341 echo"</form>\n"; 342 echo"</th>\n"; 343 } 344 345 if($order==2) 346 { 347 echo"<th class='tableau1'>\n"; 348 echo"<form action=\"index.php\" method=\"POST\" >\n"; 349 echo "<input type=\"hidden\" name ='order' value=\"2\">\n"; 350 echo "<input type=\"hidden\" name ='period' value=\"$period\">\n"; 351 echo "<input type=\"hidden\" name ='graphpos' value=\"$graphpos\">\n"; 352 echo "<input type=\"hidden\" name ='navig' value=\"$navig\">\n"; 353 echo "<input type=\"hidden\" name ='crawler' value=\"$crawler\">\n"; 354 echo "<input type=\"hidden\" name ='site' value=\"$site\">\n"; 355 echo"<input type='submit' class='orderselect' value='".$language['nbr_visits']."'>\n"; 356 echo"</form>\n"; 357 echo"</th>\n"; 358 } 359 else 360 { 361 echo"<th class='tableau1'>\n"; 362 echo"<form action=\"index.php\" method=\"POST\" >\n"; 363 echo "<input type=\"hidden\" name ='order' value=\"2\">\n"; 364 echo "<input type=\"hidden\" name ='period' value=\"$period\">\n"; 365 echo "<input type=\"hidden\" name ='graphpos' value=\"$graphpos\">\n"; 366 echo "<input type=\"hidden\" name ='navig' value=\"$navig\">\n"; 367 echo "<input type=\"hidden\" name ='crawler' value=\"$crawler\">\n"; 368 echo "<input type=\"hidden\" name ='site' value=\"$site\">\n"; 369 echo"<input type='submit' class='order' value='".$language['nbr_visits']."'>\n"; 370 echo"</form>\n"; 371 echo"</th>\n"; 372 } 373 if($order==1) 374 { 375 echo"<th class='tableau1'>\n"; 376 echo"<form action=\"index.php\" method=\"POST\" >\n"; 377 echo "<input type=\"hidden\" name ='order' value=\"1\">\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['nbr_pages']."'>\n"; 384 echo"</form>\n"; 385 echo"</th>\n"; 386 echo"</th>\n"; 387 } 388 else 389 { 390 echo"<th class='tableau1'>\n"; 391 echo"<form action=\"index.php\" method=\"POST\" >\n"; 392 echo "<input type=\"hidden\" name ='order' value=\"1\">\n"; 393 echo "<input type=\"hidden\" name ='period' value=\"$period\">\n"; 394 echo "<input type=\"hidden\" name ='graphpos' value=\"$graphpos\">\n"; 395 echo "<input type=\"hidden\" name ='navig' value=\"$navig\">\n"; 396 echo "<input type=\"hidden\" name ='crawler' value=\"$crawler\">\n"; 397 echo "<input type=\"hidden\" name ='site' value=\"$site\">\n"; 398 echo"<input type='submit' class='order' value='".$language['nbr_pages']."'>\n"; 399 echo"</form>\n"; 400 echo"</th>\n"; 401 } 402 403 if($order==4) 404 { 405 echo"<th class='tableau1'>\n"; 406 echo"<form action=\"index.php\" method=\"POST\" >\n"; 407 echo "<input type=\"hidden\" name ='order' value=\"4\">\n"; 408 echo "<input type=\"hidden\" name ='period' value=\"$period\">\n"; 409 echo "<input type=\"hidden\" name ='graphpos' value=\"$graphpos\">\n"; 410 echo "<input type=\"hidden\" name ='navig' value=\"$navig\">\n"; 411 echo "<input type=\"hidden\" name ='crawler' value=\"$crawler\">\n"; 412 echo "<input type=\"hidden\" name ='site' value=\"$site\">\n"; 413 echo"<input type='submit' class='orderselect' value='".$language['pc-page-view']."'>\n"; 414 echo"</form>\n"; 415 echo"</th>\n"; 416 } 417 else 418 { 419 echo"<th class='tableau1'>\n"; 420 echo"<form action=\"index.php\" method=\"POST\" >\n"; 421 echo "<input type=\"hidden\" name ='order' value=\"4\">\n"; 422 echo "<input type=\"hidden\" name ='period' value=\"$period\">\n"; 423 echo "<input type=\"hidden\" name ='graphpos' value=\"$graphpos\">\n"; 424 echo "<input type=\"hidden\" name ='navig' value=\"$navig\">\n"; 425 echo "<input type=\"hidden\" name ='crawler' value=\"$crawler\">\n"; 426 echo "<input type=\"hidden\" name ='site' value=\"$site\">\n"; 427 echo"<input type='submit' class='order' value='".$language['pc-page-view']."'>\n"; 428 echo"</form>\n"; 429 echo"</th>\n"; 430 } 431 432 433 434 435 if($order==0) 436 { 437 echo"<th class='tableau2'>\n"; 438 echo"<form action=\"index.php\" method=\"POST\" >\n"; 439 echo "<input type=\"hidden\" name ='order' value=\"0\">\n"; 440 echo "<input type=\"hidden\" name ='period' value=\"$period\">\n"; 441 echo "<input type=\"hidden\" name ='graphpos' value=\"$graphpos\">\n"; 442 echo "<input type=\"hidden\" name ='navig' value=\"$navig\">\n"; 443 echo "<input type=\"hidden\" name ='crawler' value=\"$crawler\">\n"; 444 echo "<input type=\"hidden\" name ='site' value=\"$site\">\n"; 445 echo"<input type='submit' class='orderselect' value='".$language['date_visits']."'>\n"; 446 echo"</form>\n"; 447 echo"</th></tr>\n"; 448 } 449 else 450 { 451 echo"<th class='tableau2'>\n"; 452 echo"<form action=\"index.php\" method=\"POST\" >\n"; 453 echo "<input type=\"hidden\" name ='order' value=\"0\">\n"; 454 echo "<input type=\"hidden\" name ='period' value=\"$period\">\n"; 455 echo "<input type=\"hidden\" name ='graphpos' value=\"$graphpos\">\n"; 456 echo "<input type=\"hidden\" name ='navig' value=\"$navig\">\n"; 457 echo "<input type=\"hidden\" name ='crawler' value=\"$crawler\">\n"; 458 echo "<input type=\"hidden\" name ='site' value=\"$site\">\n"; 459 echo"<input type='submit' class='order' value='".$language['date_visits']."'>\n"; 460 echo"</form>\n"; 461 echo"</th></tr>\n"; 462 } 463 //counter for alternate color lane 464 $comptligne=2; 465 466 foreach ($nbvisits as $key => $value) 467 { 468 $crawldisplay=htmlentities($key); 469 470 $nbrpage=$nbrcrawlerpage[$key]; 471 472 if ($comptligne%2 ==0) 473 { 474 echo"<tr><td class='tableau3'><a href='index.php?navig=2&period=".$period."&site=".$site."&crawler=".$key."&graphpos=".$graphpos."'>".$crawldisplay."</a></td>\n"; 475 echo"<td class='tableau3'>".numbdisp($nbvisits[$key])."</td>\n"; 476 echo"<td class='tableau3'>".numbdisp($nbrpage)."</td> \n"; 477 $pcvis = round(($nbrpage / $nbrpagestotal[$site])*100,1); 478 echo"<td class='tableau3'>".$pcvis."%</td> \n"; 479 echo"<td class='tableau5'>".$lastdatedisplay[$key]."</td></tr>\n"; 480 } 481 else 482 { 483 echo"<tr><td class='tableau30'><a href='index.php?navig=2&period=".$period."&site=".$site."&crawler=".$key."&graphpos=".$graphpos."'>".$crawldisplay."</a></td>\n"; 484 echo"<td class='tableau30'>".numbdisp($nbvisits[$key])."</td>\n"; 485 echo"<td class='tableau30'>".numbdisp($nbrpage)."</td> \n"; 486 $pcvis = round(($nbrpage / $nbrpagestotal[$site])*100,1); 487 echo"<td class='tableau30'>".$pcvis."%</td> \n"; 488 echo"<td class='tableau50'>".$lastdatedisplay[$key]."</td></tr>\n"; 489 } 490 491 $comptligne++; 492 } 493 echo"</table>\n"; 494 echo"<br>\n"; 495 496 } 497 else //case no visits (or visits in archive) 498 { 499 //use of datas in archive 500 $usearchive=0; 501 $nbrtotvisits=0; 502 if($period==3 OR ($period>=200 && $period<300) OR $period==5) 503 { 504 $beginperiod = mktime(0,0,0,$monthbeginserver, 1, $yearbeginserver); 505 $endperiod = mktime(0,0,0,$monthbeginserver, 1, ($yearbeginserver+1)); 506 //data request 507 $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"; 508 509 $requetearchive = mysql_query($sqlarchive, $connexion) or die("MySQL query error"); 510 511 $nbrresult=mysql_num_rows($requetearchive); 512 if($nbrresult>=1) 513 { 514 $i=0; 515 while ($ligne = mysql_fetch_row($requetearchive)) 516 { 517 $sitetodisplay = explode('-',$ligne[0]); 518 if($sitetodisplay[1]==$site) 519 { 520 $data=$sitetodisplay[0]; 521 $archivdate=explode('/',$data); 522 $archivperiod =mktime(0,0,0,$archivdate[0], 1, $archivdate[1]); 523 if($archivperiod >=$beginperiod && $archivperiod<$endperiod) 524 { 525 $listid[]=$i; 526 $month[]=$sitetodisplay[0]; 527 $visit[]=$ligne[1]; 528 $page[]=$ligne[2]; 529 $topvisit[]=$ligne[3]."<br> ".$ligne[4]."<br> ".$ligne[5]; 530 $toppage[]=$ligne[6]."<br> ".$ligne[7]."<br> ".$ligne[8]; 531 $i++; 532 $usearchive=1; 533 } 534 535 } 536 } 537 } 538 539 } 540 541 if($usearchive==0) 542 { 543 echo"<div class=\"content\">\n"; 544 echo crawltbackforward('crawler_name',$period,$daytodaylocal,$monthtodaylocal,$yeartodaylocal,$daybeginlocal,$monthbeginlocal,$yearbeginlocal,$dayendweek,$monthendweek,$yearendweek,$crawler,$navig,$site,$graphpos); 545 echo"<h1>".$language['no_visit']."</h1>\n"; 546 echo"<br>\n"; 547 } 548 else 549 { 550 $onlyarchive=1; 551 552 echo"<div class=\"content\">\n"; 553 echo crawltbackforward('crawler_name',$period,$daytodaylocal,$monthtodaylocal,$yeartodaylocal,$daybeginlocal,$monthbeginlocal,$yearbeginlocal,$dayendweek,$monthendweek,$yearendweek,$crawler,$navig,$site,$graphpos); 554 echo"<h1>".$language['archive']."</h1><br>\n"; 555 556 echo"<div width='100%' align='center'>\n"; 557 echo"<table cellpadding='0px' cellspacing='0' width='100%'>\n"; 558 echo"<tr><th class='tableau11'>\n"; 559 echo"".$language['month2']."\n"; 560 echo"</th>\n"; 561 echo"<th class='tableau11'>\n"; 562 echo"".$language['nbr_tot_visits']."\n"; 563 echo"</th>\n"; 564 echo"<th class='tableau11'>\n"; 565 echo"".$language['nbr_tot_pages']."\n"; 566 echo"</th>\n"; 567 echo"<th class='tableau11'>\n"; 568 echo"".$language['top_visits']."\n"; 569 echo"</th>\n"; 570 echo"<th class='tableau22'>\n"; 571 echo"".$language['top_pages']."\n"; 572 echo"</th></tr>\n"; 573 574 575 //counter for alternate color lane 576 $comptligne=2; 577 578 foreach ($listid as $id) 579 { 580 if ($comptligne%2 ==0) 581 { 582 echo"<tr><td class='tableau33'> ".$month[$id]." </td>\n"; 583 echo"<td class='tableau33'>".numbdisp($visit[$id])."</td>\n"; 584 echo"<td class='tableau33'>".numbdisp($page[$id])."</td> \n"; 585 echo"<td class='tableau33g'> ".$topvisit[$id]."</td> \n"; 586 echo"<td class='tableau55g'> ".$toppage[$id]."</td></tr>\n"; 587 } 588 else 589 { 590 echo"<tr><td class='tableau330'> ".$month[$id]." </td>\n"; 591 echo"<td class='tableau330'>".numbdisp($visit[$id])."</td>\n"; 592 echo"<td class='tableau330'>".numbdisp($page[$id])."</td> \n"; 593 echo"<td class='tableau330g'> ".$topvisit[$id]."</td> \n"; 594 echo"<td class='tableau550g'> ".$toppage[$id]."</td></tr>\n"; 595 } 596 $comptligne++; 597 } 598 599 echo"</table></div><br>\n"; 600 601 //graph 602 echo"<div class='graphvisits' >\n"; 603 //mapgraph 604 include "include/mapgraph.php"; 605 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"; 606 echo"<div class='imprimgraph'>\n"; 607 echo" <br><br><br><br><br><br></div>\n"; 608 echo"</div><br><br>\n"; 609 } 610 611 } 612 613 614 ?>
titre
Description
Corps
titre
Description
Corps
titre
Description
Corps
titre
Corps
| Généré le : Thu Sep 6 14:14:11 2007 | par Balluche grâce à PHPXref 0.7 |