| [ 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: search.php 14 //---------------------------------------------------------------------- 15 16 if (!defined('IN_CRAWLT')) 17 { 18 echo"<h1>Hacking attempt !!!!</h1>"; 19 exit(); 20 } 21 //initialize array 22 $list=array(); 23 //database connection 24 $connexion = mysql_connect($crawlthost,$crawltuser,$crawltpassword) or die("MySQL connection to database problem"); 25 $selection = mysql_select_db($crawltdb) or die("MySQL database selection problem"); 26 27 //include menu 28 include "include/menumain.php"; 29 include "include/menusite.php"; 30 31 echo"<div class=\"content\">\n"; 32 33 //test if form valid 34 if($crawler=="" && $validform==1) 35 { 36 $validform=0; 37 } 38 39 //test form for navigation 40 41 if($validform==0) 42 { 43 if($crawler==0) 44 { 45 $crawler=""; 46 } 47 echo"<h1>".$language['search2']."</h1>\n"; 48 echo"<table width=\"720px\" align=\"center\">\n"; 49 echo"<tr><td>\n"; 50 echo"<div class=\"form2\" align=\"centrer\">\n"; 51 echo"<form action=\"index.php\" method=\"POST\" >\n"; 52 echo "<input type=\"hidden\" name ='validform' value=\"1\">"; 53 echo "<input type=\"hidden\" name ='navig' value=\"5\">"; 54 echo "<input type=\"hidden\" name ='search' value=\"1\">"; 55 echo "<input type=\"hidden\" name ='site' value=\"$site\">"; 56 echo "<input type=\"hidden\" name ='period' value=\"$period\">"; 57 echo"<table align=\"centrer\" width=\"300px\">\n"; 58 echo"<tr>\n"; 59 echo"<td><h1>".$language['search_crawler']."</h1></td></tr>\n"; 60 echo"<tr><td align='center'>".$language['crawler_name'].":<input name='crawler' value='$crawler' type='text' size='20'/></td>\n"; 61 echo"</tr>\n"; 62 echo"<tr>\n"; 63 echo"<td align='center'>\n"; 64 echo"<br>\n"; 65 echo"<input name='ok' type='submit' value=' ".$language['go_search']." ' size='20'>\n"; 66 echo"</td>\n"; 67 echo"</tr>\n"; 68 echo"</table>\n"; 69 echo"</form></div>\n"; 70 71 echo"</td><td>\n"; 72 73 echo"<div class=\"form2\" align=\"centrer\">\n"; 74 echo"<form action=\"index.php\" method=\"POST\" >\n"; 75 echo "<input type=\"hidden\" name ='validform' value=\"1\">"; 76 echo "<input type=\"hidden\" name ='navig' value=\"5\">"; 77 echo "<input type=\"hidden\" name ='search' value=\"2\">"; 78 echo "<input type=\"hidden\" name ='site' value=\"$site\">"; 79 echo "<input type=\"hidden\" name ='period' value=\"$period\">"; 80 echo"<table align=\"centrer\" width=\"300px\">\n"; 81 echo"<tr>\n"; 82 echo"<td><h1>".$language['search_page']."</h1></td></tr>\n"; 83 echo"<tr><td align='center'>".$language['page'].":<input name='crawler' value='$crawler' type='text' size='20'/></td>\n"; 84 echo"</tr>\n"; 85 echo"<tr>\n"; 86 echo"<td align='center'>\n"; 87 echo"<br>\n"; 88 echo"<input name='ok' type='submit' value=' ".$language['go_search']." ' size='20'>\n"; 89 echo"</td>\n"; 90 echo"</tr>\n"; 91 echo"</table>\n"; 92 echo"</form></div>\n"; 93 94 echo"</td></tr><tr><td> </td></tr><tr><td>\n"; 95 96 echo"<div class=\"form2\" align=\"centrer\">\n"; 97 echo"<form action=\"index.php\" method=\"POST\" >\n"; 98 echo "<input type=\"hidden\" name ='validform' value=\"1\">"; 99 echo "<input type=\"hidden\" name ='navig' value=\"5\">"; 100 echo "<input type=\"hidden\" name ='search' value=\"5\">"; 101 echo "<input type=\"hidden\" name ='site' value=\"$site\">"; 102 echo "<input type=\"hidden\" name ='period' value=\"$period\">"; 103 echo"<table align=\"centrer\" width=\"300px\">\n"; 104 echo"<tr>\n"; 105 echo"<td><h1>".$language['search_user_agent']."</h1></td></tr>\n"; 106 echo"<tr><td align='center'>".$language['crawler_user_agent']."<input name='crawler' value='$crawler' type='text' size='20'/></td>\n"; 107 echo"</tr>\n"; 108 echo"<tr>\n"; 109 echo"<td align='center'>\n"; 110 echo"<br>\n"; 111 echo"<input name='ok' type='submit' value=' ".$language['go_search']." ' size='20'>\n"; 112 echo"</td>\n"; 113 echo"</tr>\n"; 114 echo"</table>\n"; 115 echo"</form></div>\n"; 116 117 echo"</td><td>\n"; 118 119 echo"<div class=\"form2\" align=\"centrer\">\n"; 120 echo"<form action=\"index.php\" method=\"POST\" >\n"; 121 echo "<input type=\"hidden\" name ='validform' value=\"1\">"; 122 echo "<input type=\"hidden\" name ='navig' value=\"5\">"; 123 echo "<input type=\"hidden\" name ='search' value=\"3\">"; 124 echo "<input type=\"hidden\" name ='site' value=\"$site\">"; 125 echo "<input type=\"hidden\" name ='period' value=\"$period\">"; 126 echo"<table align=\"centrer\" width=\"300px\">\n"; 127 echo"<tr>\n"; 128 echo"<td><h1>".$language['search_user']."</h1></td></tr>\n"; 129 echo"<tr><td align='center'>".$language['Origin'].":<input name='crawler' value='$crawler' type='text' size='20'/></td>\n"; 130 echo"</tr>\n"; 131 echo"<tr>\n"; 132 echo"<td align='center'>\n"; 133 echo"<br>\n"; 134 echo"<input name='ok' type='submit' value=' ".$language['go_search']." ' size='20'>\n"; 135 echo"</td>\n"; 136 echo"</tr>\n"; 137 echo"</table>\n"; 138 echo"</form></div>\n"; 139 140 141 echo"</td></tr><tr><td> </td></tr><tr><td colspan=\"2\">\n"; 142 143 echo"<div class=\"form2\" align=\"centrer\">\n"; 144 echo"<form action=\"index.php\" method=\"POST\" >\n"; 145 echo "<input type=\"hidden\" name ='validform' value=\"1\">"; 146 echo "<input type=\"hidden\" name ='navig' value=\"5\">"; 147 echo "<input type=\"hidden\" name ='search' value=\"7\">"; 148 echo "<input type=\"hidden\" name ='site' value=\"$site\">"; 149 echo "<input type=\"hidden\" name ='period' value=\"$period\">"; 150 echo"<table align=\"centrer\" width=\"300px\">\n"; 151 echo"<tr>\n"; 152 echo"<td><h1>".$language['search_ip']."</h1></td></tr>\n"; 153 echo"<tr><td align='center'>".$language['crawler_ip']."<input name='crawler' value='$crawler' type='text' size='20'/></td>\n"; 154 echo"</tr>\n"; 155 echo"<tr>\n"; 156 echo"<td align='center'>\n"; 157 echo"<br>\n"; 158 echo"<input name='ok' type='submit' value=' ".$language['go_search']." ' size='20'>\n"; 159 echo"</td>\n"; 160 echo"</tr>\n"; 161 echo"</table>\n"; 162 echo"</form></div>\n"; 163 164 echo"</td></tr></table><br><br>\n"; 165 166 } 167 else 168 { 169 if($search==7) 170 { 171 //test to see if the IP address is correct 172 $modele="^[0-9]{1,3}[.][0-9]{1,3}[.][0-9]{1,3}[.][0-9]{1,3}$"; 173 $crawler=strtolower($crawler); 174 if (ereg($modele, $crawler)) 175 { 176 $validaddress=1; 177 } 178 else 179 { 180 $validaddress=0; 181 } 182 183 if($validaddress==0) 184 { 185 echo"<h1>".$language['search_ip']."</h1><br><br>\n"; 186 echo"<p>".$language['ip_no_ok']."</p><br><br>\n"; 187 188 //continue 189 190 echo"<form action=\"index.php\" method=\"POST\" >\n"; 191 echo "<input type=\"hidden\" name ='navig' value='5'>\n"; 192 echo "<input type=\"hidden\" name ='crawler' value='$crawler'>\n"; 193 echo"<table class=\"centrer\">\n"; 194 echo"<tr>\n"; 195 echo"<td colspan=\"2\">\n"; 196 echo"<input name='ok' type='submit' value='OK ' size='20'>\n"; 197 echo"</td>\n"; 198 echo"</tr>\n"; 199 echo"</table>\n"; 200 echo"</form><br>\n"; 201 202 203 204 } 205 else 206 { 207 //ip search 208 $ipexplode= explode('.',$crawler); 209 210 if($ipexplode[0]>255 OR $ipexplode[1]>255 OR $ipexplode[2]>255 OR $ipexplode[3]>255) 211 { 212 213 echo"<h1>".$language['search_ip']."</h1><br><br>\n"; 214 echo"<p>".$language['ip_no_ok']."</p><br><br>\n"; 215 216 //continue 217 218 echo"<form action=\"index.php\" method=\"POST\" >\n"; 219 echo "<input type=\"hidden\" name ='navig' value='5'>\n"; 220 echo "<input type=\"hidden\" name ='crawler' value='$crawler'>\n"; 221 echo"<table class=\"centrer\">\n"; 222 echo"<tr>\n"; 223 echo"<td colspan=\"2\">\n"; 224 echo"<input name='ok' type='submit' value='OK ' size='20'>\n"; 225 echo"</td>\n"; 226 echo"</tr>\n"; 227 echo"</table>\n"; 228 echo"</form><br>\n"; 229 230 } 231 else 232 { 233 234 //maxMind GeoIp calculation formula 235 $ip2=(16777216*$ipexplode[0]) + (65536*$ipexplode[1]) + (256*$ipexplode[2]) + $ipexplode[3]; 236 237 $sqlstats = "SELECT country_code FROM crawlt_ip_data 238 WHERE ip_from <= '".sql_quote($ip2)."' 239 AND ip_to >= '".sql_quote($ip2)."'"; 240 241 242 $requetestats = mysql_query($sqlstats, $connexion) or die("MySQL query error"); 243 244 $nbrresult1=mysql_num_rows($requetestats); 245 246 if($nbrresult1>=1) 247 { 248 $ligne = mysql_fetch_row($requetestats); 249 $code=$ligne[0]; 250 } 251 else 252 { 253 $code='xx'; 254 } 255 256 $crawlerdisplay= htmlentities( $crawler); 257 258 echo"<h1>".$language['search_ip']."</h1><br><br>\n"; 259 260 echo"<div class='tableau' align='center'>\n"; 261 echo"<table cellpadding='0px' cellspacing='0' width='100%'>\n"; 262 echo"<tr><th class='tableau1'>\n"; 263 echo"".$language['ip']."\n"; 264 echo"</th>\n"; 265 echo"<th class='tableau2'>\n"; 266 echo"".$language['crawler_country']."\n"; 267 echo"</th></tr>\n"; 268 echo"<td class='tableau3'>".$crawlerdisplay."</td>\n"; 269 echo"<td class='tableau5'>\n"; 270 echo"<img src=\"./images/flags/$code.gif\" width=\"16px\" height=\"11px\" border=\"0\" alt=\"$country[$code]\"> $country[$code]<br>\n"; 271 echo"</td></tr> \n"; 272 echo"</table></div><br>\n"; 273 echo"<p align='center'><span class='smalltext'>".$language['maxmind']." <a href='http://maxmind.com'>http://maxmind.com</a></span></p>\n"; 274 } 275 } 276 } 277 else 278 { 279 280 281 282 283 //mysql requete 284 if($search!=2) 285 { 286 //case crawler, we search in the whole crawler database 287 $sqlstats = "SELECT crawler_name, crawler_info, crawler_user_agent FROM crawlt_crawler 288 ORDER BY crawler_name ASC"; 289 } 290 else 291 { 292 //case page, we search in the visit database 293 294 295 $sqlstats = "SELECT crawler_name, crawler_info, crawler_user_agent, url_page FROM crawlt_visits,crawlt_crawler,crawlt_pages 296 WHERE crawlt_visits.crawlt_crawler_id_crawler=crawlt_crawler.id_crawler 297 AND crawlt_visits.crawlt_pages_id_page=crawlt_pages.id_page 298 AND crawlt_visits.crawlt_site_id_site='".sql_quote($site)."' 299 ORDER BY crawlt_visits.date ASC"; 300 } 301 302 $requetestats = mysql_query($sqlstats, $connexion) or die("MySQL query error"); 303 304 $nbrresult=mysql_num_rows($requetestats); 305 if($nbrresult>=1) 306 { 307 308 if($search==1) 309 { 310 311 while ($ligne = mysql_fetch_row($requetestats)) 312 { 313 $crawlername=$ligne[0]; 314 if(eregi($crawler,$crawlername)) 315 { 316 $list[]=$crawlername; 317 } 318 } 319 320 //cut the url to avoid oversize display 321 $crawldisplaylength = strlen("$crawler"); 322 $cutvalue = 0; 323 $crawlerdisplay=''; 324 while ($cutvalue <= $crawldisplaylength) 325 { 326 $cutvalue2 = $cutvalue + 55; 327 $crawlerdisplay= $crawlerdisplay.htmlentities(substr($crawler,$cutvalue,55)); 328 if ($cutvalue2 <= $crawldisplaylength) 329 { 330 $crawlerdisplay = $crawlerdisplay.'<br>'; 331 } 332 $cutvalue = $cutvalue2; 333 } 334 335 echo"<br><br><h1>".$language['search2']."</h1>\n"; 336 echo"<h1>".$language['search_crawler']."</h1>\n"; 337 echo"<h2>".$language['result_crawler_1']."".$crawlerdisplay."</h2><br>\n"; 338 339 340 if(isset($list)) 341 { 342 $list=array_unique($list); 343 sort($list); 344 345 //change text if more than 100 answers 346 $nbrtotanswer=sizeof($list); 347 if($nbrtotanswer>100) 348 { 349 echo"<br><br><h2>".$language['to_many_answer']."</h2>\n"; 350 } 351 352 echo"<div class='tableau' align='center'>"; 353 echo"<table cellpadding='0px' cellspacing='0' width='450px'>\n"; 354 echo"<tr><td class='tableau2'>".$language['result_crawler']."</td><tr>\n"; 355 356 //counter for alternate color lane 357 $comptligne=2; 358 359 //counter to limite number of datas displayed 360 $comptdata=0; 361 362 363 foreach ($list as $crawl) 364 { 365 366 367 //cut the url to avoid oversize display 368 $crawldisplaylength = strlen("$crawl"); 369 $cutvalue = 0; 370 $crawldisplay=''; 371 while ($cutvalue <= $crawldisplaylength) 372 { 373 $cutvalue2 = $cutvalue +80; 374 $crawldisplay= $crawldisplay.htmlentities(substr($crawl,$cutvalue,80)); 375 if ($cutvalue2 <= $crawldisplaylength) 376 { 377 $crawldisplay = $crawldisplay.'<br>'; 378 } 379 $cutvalue = $cutvalue2; 380 } 381 382 383 if($comptdata<100) 384 { 385 if ($comptligne%2 ==0) 386 { 387 echo"<tr><td class='tableau5'><a href='index.php?navig=2&period=3&site=".$site."&crawler=".$crawl."'>".$crawldisplay."</a></td><tr>\n"; 388 } 389 else 390 { 391 echo"<tr><td class='tableau50'><a href='index.php?navig=2&period=3&site=".$site."&crawler=".$crawl."'>".$crawldisplay."</a></td><tr>\n"; 392 } 393 } 394 395 $comptligne++; 396 $comptdata++; 397 } 398 echo"</table></div><br>"; 399 } 400 else 401 { 402 echo"<br><br><h2>".$language['no_answer']."</h2>\n"; 403 } 404 } 405 elseif($search==2) 406 { 407 while ($ligne = mysql_fetch_row($requetestats)) 408 { 409 $pagename=$ligne[3]; 410 if(eregi($crawler,$pagename)) 411 { 412 $list[]=$pagename; 413 } 414 } 415 416 //cut the url to avoid oversize display 417 $crawldisplaylength = strlen("$crawler"); 418 $cutvalue = 0; 419 $crawlerdisplay=''; 420 while ($cutvalue <= $crawldisplaylength) 421 { 422 $cutvalue2 = $cutvalue + 55; 423 $crawlerdisplay= $crawlerdisplay.htmlentities(substr($crawler,$cutvalue,55)); 424 if ($cutvalue2 <= $crawldisplaylength) 425 { 426 $crawlerdisplay = $crawlerdisplay.'<br>'; 427 } 428 $cutvalue = $cutvalue2; 429 } 430 431 echo"<br><br><h1>".$language['search2']."</h1>\n"; 432 echo"<h1>".$language['search_page']."</h1>\n"; 433 echo"<h2>".$language['result_crawler_1']."".$crawlerdisplay."</h2><br>\n"; 434 435 if(isset($list)) 436 { 437 $list=array_unique($list); 438 sort($list); 439 //change text if more than 100 answers 440 $nbrtotanswer=sizeof($list); 441 if($nbrtotanswer>100) 442 { 443 echo"<br><br><h2>".$language['to_many_answer']."</h2>\n"; 444 } 445 446 echo"<div class='tableau' align='center'>"; 447 echo"<table cellpadding='0px' cellspacing='0' width='450px'>\n"; 448 echo"<tr><td class='tableau2'>".$language['result_page']."</td><tr>\n"; 449 450 //counter for alternate color lane 451 $comptligne=2; 452 453 //counter to limite number of datas displayed 454 $comptdata=0; 455 456 457 foreach ($list as $crawl) 458 { 459 //cut the url to avoid oversize display 460 $crawldisplaylength = strlen("$crawl"); 461 $cutvalue = 0; 462 $crawldisplay=''; 463 while ($cutvalue <= $crawldisplaylength) 464 { 465 $cutvalue2 = $cutvalue + 80; 466 $crawldisplay= $crawldisplay.htmlentities(substr($crawl,$cutvalue,80)); 467 if ($cutvalue2 <= $crawldisplaylength) 468 { 469 $crawldisplay = $crawldisplay.'<br>'; 470 } 471 $cutvalue = $cutvalue2; 472 } 473 474 $crawlencode=urlencode($crawl); 475 476 if($comptdata<100) 477 { 478 if ($comptligne%2 ==0) 479 { 480 echo"<tr><td class='tableau5'><a href='index.php?navig=4&period=3&site=".$site."&crawler=".$crawlencode."'>".$crawldisplay."</a></td><tr>\n"; 481 } 482 else 483 { 484 echo"<tr><td class='tableau50'><a href='index.php?navig=4&period=3&site=".$site."&crawler=".$crawlencode."'>".$crawldisplay."</a></td><tr>\n"; 485 } 486 } 487 $comptligne++; 488 $comptdata++; 489 } 490 echo"</table></div><br>"; 491 } 492 else 493 { 494 echo"<br><br><h2>".$language['no_answer']."</h2>\n"; 495 } 496 } 497 elseif($search==3) 498 { 499 while ($ligne = mysql_fetch_row($requetestats)) 500 { 501 $crawlerinfo=$ligne[1]; 502 if(eregi($crawler,$crawlerinfo)) 503 { 504 $list[]=$crawlerinfo; 505 } 506 } 507 508 509 //cut the url to avoid oversize display 510 $crawldisplaylength = strlen("$crawler"); 511 $cutvalue = 0; 512 $crawlerdisplay=''; 513 while ($cutvalue <= $crawldisplaylength) 514 { 515 $cutvalue2 = $cutvalue + 55; 516 $crawlerdisplay= $crawlerdisplay.htmlentities(substr($crawler,$cutvalue,55)); 517 if ($cutvalue2 <= $crawldisplaylength) 518 { 519 $crawlerdisplay = $crawlerdisplay.'<br>'; 520 } 521 $cutvalue = $cutvalue2; 522 } 523 524 echo"<br><br><h1>".$language['search2']."</h1>\n"; 525 echo"<h1>".$language['search_user']."</h1>\n"; 526 echo"<h2>".$language['result_crawler_1']."".$crawlerdisplay."</h2><br>\n"; 527 528 529 if(isset($list)) 530 { 531 $list=array_unique($list); 532 sort($list); 533 //change text if more than 100 answers 534 $nbrtotanswer=sizeof($list); 535 if($nbrtotanswer>100) 536 { 537 echo"<br><br><h2>".$language['to_many_answer']."</h2>\n"; 538 } 539 540 echo"<div class='tableau' align='center'>"; 541 echo"<table cellpadding='0px' cellspacing='0' width='450px'>\n"; 542 echo"<tr><td class='tableau2'>".$language['result_user']."</td><tr>\n"; 543 544 //counter for alternate color lane 545 $comptligne=2; 546 547 //counter to limite number of datas displayed 548 $comptdata=0; 549 550 551 foreach ($list as $crawl) 552 { 553 554 //cut the url to avoid oversize display 555 $crawldisplaylength = strlen("$crawl"); 556 $cutvalue = 0; 557 $crawldisplay=''; 558 while ($cutvalue <= $crawldisplaylength) 559 { 560 $cutvalue2 = $cutvalue + 80; 561 $crawldisplay= $crawldisplay.htmlentities(substr($crawl,$cutvalue,80)); 562 if ($cutvalue2 <= $crawldisplaylength) 563 { 564 $crawldisplay = $crawldisplay.'<br>'; 565 } 566 $cutvalue = $cutvalue2; 567 } 568 569 if($comptdata<100) 570 { 571 $crawl2=urlencode($crawl); 572 if ($comptligne%2 ==0) 573 { 574 echo"<tr><td class='tableau5'><a href='index.php?validform=1&search=4&navig=5&period=3&site=".$site."&crawler=".$crawl2."'>".$crawldisplay."</a></td><tr>\n"; 575 } 576 else 577 { 578 echo"<tr><td class='tableau50'><a href='index.php?validform=1&search=4&navig=5&period=3&site=".$site."&crawler=".$crawl2."'>".$crawldisplay."</a></td><tr>\n"; 579 } 580 } 581 582 $comptligne++; 583 $comptdata++; 584 } 585 echo"</table></div><br>"; 586 } 587 else 588 { 589 echo"<br><br><h2>".$language['no_answer']."</h2>\n"; 590 } 591 592 } 593 elseif($search==5) 594 { 595 while ($ligne = mysql_fetch_row($requetestats)) 596 { 597 $crawlerua2=$ligne[2]; 598 if(eregi($crawler,$crawlerua2)) 599 { 600 $list[]=$crawlerua2; 601 } 602 } 603 604 //cut the url to avoid oversize display 605 $crawldisplaylength = strlen("$crawler"); 606 $cutvalue = 0; 607 $crawlerdisplay=''; 608 while ($cutvalue <= $crawldisplaylength) 609 { 610 $cutvalue2 = $cutvalue + 80; 611 $crawlerdisplay= $crawlerdisplay.htmlentities(substr($crawler,$cutvalue,80)); 612 if ($cutvalue2 <= $crawldisplaylength) 613 { 614 $crawlerdisplay = $crawlerdisplay.'<br>'; 615 } 616 $cutvalue = $cutvalue2; 617 } 618 619 echo"<br><br><h1>".$language['search2']."</h1>\n"; 620 echo"<h1>".$language['search_user_agent']."</h1>\n"; 621 echo"<h2>".$language['result_crawler_1']."".$crawlerdisplay."</h2><br>\n"; 622 623 624 if(isset($list)) 625 { 626 $list=array_unique($list); 627 sort($list); 628 //change text if more than 100 answers 629 $nbrtotanswer=sizeof($list); 630 if($nbrtotanswer>100) 631 { 632 echo"<br><br><h2>".$language['to_many_answer']."</h2>\n"; 633 } 634 635 echo"<div class='tableau' align='center'>"; 636 echo"<table cellpadding='0px' cellspacing='0' width='450px'>\n"; 637 echo"<tr><td class='tableau2'>".$language['result_ua']."</td><tr>\n"; 638 639 //counter for alternate color lane 640 $comptligne=2; 641 642 //counter to limite number of datas displayed 643 $comptdata=0; 644 645 646 foreach ($list as $crawl) 647 { 648 649 //cut the url to avoid oversize display 650 $crawldisplaylength = strlen("$crawl"); 651 $cutvalue = 0; 652 $crawldisplay=''; 653 while ($cutvalue <= $crawldisplaylength) 654 { 655 $cutvalue2 = $cutvalue + 80; 656 $crawldisplay= $crawldisplay.htmlentities(substr($crawl,$cutvalue,80)); 657 if ($cutvalue2 <= $crawldisplaylength) 658 { 659 $crawldisplay = $crawldisplay.'<br>'; 660 } 661 $cutvalue = $cutvalue2; 662 } 663 664 if($comptdata<100) 665 { 666 $crawl2=urlencode($crawl); 667 if ($comptligne%2 ==0) 668 { 669 echo"<tr><td class='tableau5'><a href='index.php?validform=1&search=6&navig=5&period=3&site=".$site."&crawler=".$crawl2."'>".$crawldisplay."</a></td><tr>\n"; 670 } 671 else 672 { 673 echo"<tr><td class='tableau50'><a href='index.php?validform=1&search=6&navig=5&period=3&site=".$site."&crawler=".$crawl2."'>".$crawldisplay."</a></td><tr>\n"; 674 } 675 } 676 677 $comptligne++; 678 $comptdata++; 679 } 680 echo"</table></div><br>"; 681 } 682 else 683 { 684 echo"<br><br><h2>".$language['no_answer']."</h2>\n"; 685 } 686 687 } 688 689 elseif($search == 6) 690 { 691 //database connection 692 $connexion = mysql_connect($crawlthost,$crawltuser,$crawltpassword) or die("MySQL connection to database problem"); 693 $selection = mysql_select_db($crawltdb) or die("MySQL database selection problem"); 694 695 $sqlexist = "SELECT crawler_name,crawler_user_agent, crawler_info, crawler_url FROM crawlt_crawler 696 WHERE crawler_user_agent='".sql_quote($crawler)."'"; 697 698 $requeteexist = mysql_query($sqlexist, $connexion or die("MySQL query error")); 699 700 $ligne2 = mysql_fetch_row($requeteexist); 701 //crawler already exist 702 $crawlernamedisplay=htmlentities($ligne2[0]); 703 $useragdisplay=htmlentities($ligne2[1]); 704 $crawlerinfodisplay=htmlentities($ligne2[2]); 705 $crawlerurldisplay=htmlentities($ligne2[3]); 706 707 echo"<br><br><h1>".$language['search2']."</h1>\n"; 708 echo"<h1>".$language['search_user_agent']."</h1>\n"; 709 echo"<p>".$language['exist_data']."</p>\n"; 710 echo"<h5>".$language['crawler_name2']." <a href='index.php?navig=2&period=3&site=".$site."&crawler=$ligne2[0]'>".$crawlernamedisplay."</a></h5>"; 711 echo"<h5>".$language['crawler_user_agent']." ".$useragdisplay."</h5>"; 712 echo"<h5>".$language['crawler_user']." ".$crawlerinfodisplay."</h5>"; 713 echo"<h5>".$language['crawler_url2']." <a href=\"$ligne->crawler_url\">".$crawlerurldisplay."</a></h5>"; 714 715 echo"<div class=\"form\">\n"; 716 echo"<form action=\"index.php\" method=\"POST\" >\n"; 717 echo "<input type=\"hidden\" name ='navig' value='5'>\n"; 718 echo"<input name='ok' type='submit' value='OK' size='20'>\n"; 719 echo"</form>\n"; 720 echo"</div>\n"; 721 } 722 else 723 { 724 725 $crawler=urldecode($crawler); 726 while ($ligne = mysql_fetch_row($requetestats)) 727 { 728 $crawlerinfo=$ligne[1]; 729 $crawlername=$ligne[0]; 730 if($crawlerinfo == $crawler) 731 { 732 $list[]=$crawlername; 733 } 734 } 735 736 //cut the url to avoid oversize display 737 $crawldisplaylength = strlen("$crawler"); 738 $cutvalue = 0; 739 $crawlerdisplay=''; 740 while ($cutvalue <= $crawldisplaylength) 741 { 742 $cutvalue2 = $cutvalue + 55; 743 $crawlerdisplay= $crawlerdisplay.htmlentities(substr($crawler,$cutvalue,55)); 744 if ($cutvalue2 <= $crawldisplaylength) 745 { 746 $crawlerdisplay = $crawlerdisplay.'<br>'; 747 } 748 $cutvalue = $cutvalue2; 749 } 750 751 echo"<br><br><h1>".$language['search2']."</h1>\n"; 752 echo"<h1>".$language['search_user']."</h1>\n"; 753 echo"<h2>".$language['result_user_1']."".$crawlerdisplay."</h2><br>\n"; 754 755 756 if(isset($list)) 757 { 758 $list=array_unique($list); 759 sort($list); 760 //change text if more than 100 answers 761 $nbrtotanswer=sizeof($list); 762 if($nbrtotanswer>100) 763 { 764 echo"<br><br><h2>".$language['to_many_answer']."</h2>\n"; 765 } 766 767 echo"<div class='tableau' align='center'>"; 768 echo"<table cellpadding='0px' cellspacing='0' width='450px'>\n"; 769 echo"<tr><td class='tableau2'>".$language['result_user_crawler']."</td><tr>\n"; 770 771 //counter for alternate color lane 772 $comptligne=2; 773 774 //counter to limite number of datas displayed 775 $comptdata=0; 776 777 778 foreach ($list as $crawl) 779 { 780 //cut the url to avoid oversize display 781 $crawldisplaylength = strlen("$crawl"); 782 $cutvalue = 0; 783 $crawldisplay=''; 784 while ($cutvalue <= $crawldisplaylength) 785 { 786 $cutvalue2 = $cutvalue + 80; 787 $crawldisplay= $crawldisplay.htmlentities(substr($crawl,$cutvalue,80)); 788 if ($cutvalue2 <= $crawldisplaylength) 789 { 790 $crawldisplay = $crawldisplay.'<br>'; 791 } 792 $cutvalue = $cutvalue2; 793 } 794 795 if($comptdata<100) 796 { 797 if ($comptligne%2 ==0) 798 { 799 echo"<tr><td class='tableau5'><a href='index.php?navig=2&period=3&site=".$site."&crawler=".$crawl."'>".$crawldisplay."</a></td><tr>\n"; 800 } 801 else 802 { 803 echo"<tr><td class='tableau50'><a href='index.php?navig=2&period=3&site=".$site."&crawler=".$crawl."'>".$crawldisplay."</a></td><tr>\n"; 804 } 805 } 806 807 $comptligne++; 808 $comptdata++; 809 } 810 echo"</table></div><br>"; 811 } 812 else 813 { 814 echo"<br><br><h2>".$language['no_answer']."</h2>\n"; 815 } 816 } 817 818 819 } 820 821 } 822 } 823 824 825 ?>
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 |