| [ 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-seo.php 14 //---------------------------------------------------------------------- 15 if (!defined('IN_CRAWLT')) 16 { 17 echo"<h1>Hacking attempt !!!!</h1>"; 18 exit(); 19 } 20 //initialize array 21 $nbrtag=array(); 22 $listkeyworddelicious = array(); 23 $listtag=array(); 24 $values=array(); 25 26 $cachename=$navig.$period.$site.$firstdayweek.$localday.$graphpos.$crawltlang; 27 28 //start the caching if fopen exist 29 if(function_exists('fopen')) 30 { 31 $ch = new cache($cachename); 32 } 33 34 //database connection 35 $connexion = mysql_connect($crawlthost,$crawltuser,$crawltpassword) or die("MySQL connection to database problem"); 36 $selection = mysql_select_db($crawltdb) or die("MySQL database selection problem"); 37 38 //include menu 39 include "include/menumain.php"; 40 include "include/menusite.php"; 41 include "include/timecache.php"; 42 //request to get the msn and yahoo positions data and the number of Delicious bookmarks, Technorati link and Delicious keywords 43 if($period>=10) 44 { 45 $sqlseo = "SELECT linkyahoo, pageyahoo, linkmsn, pagemsn, nbrdelicious,tagdelicious FROM crawlt_seo_position 46 WHERE id_site='".sql_quote($site)."' 47 AND date >='".sql_quote($daterequestseo)."' 48 AND date <'".sql_quote($daterequest2seo)."' 49 ORDER BY date"; 50 } 51 else 52 { 53 $sqlseo = "SELECT linkyahoo, pageyahoo, linkmsn, pagemsn, nbrdelicious,tagdelicious FROM crawlt_seo_position 54 WHERE id_site='".sql_quote($site)."' 55 AND date >='".sql_quote($daterequestseo)."' 56 ORDER BY date"; 57 } 58 59 60 $linkyahoo = 0; 61 $pageyahoo = 0; 62 $linkmsn = 0; 63 $pagemsn = 0; 64 $linkdelicious=0; 65 $tagdelicious=''; 66 $nbrzerolinkyahoo=0; 67 $nbrzeropageyahoo=0; 68 $nbrzerolinkmsn=0; 69 $nbrzeropagemsn=0; 70 $nbrzerolinkdelicious=0; 71 72 73 $requeteseo = mysql_query($sqlseo, $connexion) or die("MySQL query error"); 74 $nbrresult=mysql_num_rows($requeteseo); 75 if($nbrresult>=1) 76 { 77 $i=1; 78 while ($ligneseo = mysql_fetch_row($requeteseo)) 79 { 80 $linkyahoo = $linkyahoo + $ligneseo[0]; 81 $pageyahoo = $pageyahoo + $ligneseo[1]; 82 $linkmsn = $linkmsn + $ligneseo[2]; 83 $pagemsn = $pagemsn + $ligneseo[3]; 84 $linkdelicious= $linkdelicious + $ligneseo[4]; 85 86 if($ligneseo[0]==0) 87 { 88 $nbrzerolinkyahoo++; 89 } 90 if($ligneseo[1]==0) 91 { 92 $nbrzeropageyahoo++; 93 } 94 if($ligneseo[2]==0) 95 { 96 $nbrzerolinkmsn++; 97 } 98 if($ligneseo[3]==0) 99 { 100 $nbrzeropagemsn++; 101 } 102 if($ligneseo[4]==0) 103 { 104 $nbrzerolinkdelicious++; 105 } 106 107 $tabtag=@unserialize($ligneseo[5]); 108 if(is_array($tabtag)) 109 { 110 foreach ($tabtag as $key => $value) 111 { 112 $nbrtag[$key]=$tabtag[$key]; 113 } 114 $checktagdelicious=1; 115 } 116 else 117 { 118 $checktagdelicious=0; 119 } 120 } 121 122 if($linkdelicious!=0 && $checktagdelicious == 1) 123 { 124 arsort($nbrtag); 125 foreach ($nbrtag as $key => $value) 126 { 127 $listtag[] = $key; 128 } 129 130 foreach($listtag as $tag) 131 { 132 if( isutf8($tag)) 133 { 134 $tag2 = utf8_decode($tag); 135 } 136 else 137 { 138 $tag2=$tag; 139 } 140 $tagdelicious=$tagdelicious.$tag2."(".$nbrtag[$tag]."), "; 141 if(strlen($tagdelicious)> (55*$i +(4*($i-1)))) 142 { 143 $tagdelicious=$tagdelicious."<br>"; 144 $i++; 145 } 146 147 } 148 $tagdelicious= rtrim($tagdelicious,"<br>"); 149 $tagdelicious= rtrim($tagdelicious," "); 150 $tagdelicious= rtrim($tagdelicious,","); 151 } 152 else 153 { 154 $tagdelicious='-'; 155 } 156 157 //calculate average on the period (removing the day with 0 as result) 158 159 if( $nbrzerolinkyahoo== $nbrresult) 160 { 161 $linkyahoo=0; 162 } 163 else 164 { 165 $linkyahoo = round($linkyahoo / ($nbrresult-$nbrzerolinkyahoo)); 166 } 167 if( $nbrzeropageyahoo== $nbrresult) 168 { 169 $pageyahoo=0; 170 } 171 else 172 { 173 $pageyahoo = round($pageyahoo / ($nbrresult-$nbrzeropageyahoo)); 174 } 175 176 if( $nbrzerolinkmsn== $nbrresult) 177 { 178 $linkmsn=0; 179 } 180 else 181 { 182 $linkmsn = round($linkmsn / ($nbrresult-$nbrzerolinkmsn)); 183 } 184 if( $nbrzeropagemsn== $nbrresult) 185 { 186 $pagemsn=0; 187 } 188 else 189 { 190 $pagemsn = round($pagemsn / ($nbrresult-$nbrzeropagemsn)); 191 } 192 if( $nbrzerolinkdelicious== $nbrresult) 193 { 194 $linkdelicious=0; 195 } 196 else 197 { 198 $linkdelicious = round($linkdelicious/ ($nbrresult-$nbrzerolinkdelicious)); 199 } 200 201 } 202 203 //request to have the number of Googlebot visits 204 if($period>=10) 205 { 206 $sqlgoogle = "SELECT crawler_name, COUNT(DISTINCT id_visit), crawlt_crawler_id_crawler FROM crawlt_visits, crawlt_crawler 207 WHERE crawlt_visits.crawlt_crawler_id_crawler=crawlt_crawler.id_crawler 208 AND date >'".sql_quote($daterequest)."' 209 AND date <'".sql_quote($daterequest2)."' 210 AND crawlt_visits.crawlt_site_id_site='".sql_quote($site)."' 211 AND crawler_name= 'GoogleBot' 212 GROUP BY crawler_name"; 213 } 214 else 215 { 216 $sqlgoogle = "SELECT crawler_name, COUNT(DISTINCT id_visit), crawlt_crawler_id_crawler FROM crawlt_visits, crawlt_crawler 217 WHERE crawlt_visits.crawlt_crawler_id_crawler=crawlt_crawler.id_crawler 218 AND date >'".sql_quote($daterequest)."' 219 AND crawlt_visits.crawlt_site_id_site='".sql_quote($site)."' 220 AND crawler_name= 'GoogleBot' 221 GROUP BY crawler_name"; 222 } 223 224 $requetegoogle = mysql_query($sqlgoogle, $connexion) or die("MySQL query error"); 225 $nbrresult=mysql_num_rows($requetegoogle); 226 if($nbrresult>=1) 227 { 228 $lignegoogle = mysql_fetch_row($requetegoogle); 229 $visitgoogle=$lignegoogle[1]; 230 } 231 else 232 { 233 $visitgoogle= 0; 234 } 235 236 //request to have the number of MsnBot visits 237 if($period>=10) 238 { 239 $sqlmsn = "SELECT crawler_name, COUNT(DISTINCT id_visit), crawlt_crawler_id_crawler FROM crawlt_visits, crawlt_crawler 240 WHERE crawlt_visits.crawlt_crawler_id_crawler=crawlt_crawler.id_crawler 241 AND date >'".sql_quote($daterequest)."' 242 AND date <'".sql_quote($daterequest2)."' 243 AND crawlt_visits.crawlt_site_id_site='".sql_quote($site)."' 244 AND crawler_name= 'MSN Bot' 245 GROUP BY crawler_name"; 246 } 247 else 248 { 249 $sqlmsn = "SELECT crawler_name, COUNT(DISTINCT id_visit), crawlt_crawler_id_crawler FROM crawlt_visits, crawlt_crawler 250 WHERE crawlt_visits.crawlt_crawler_id_crawler=crawlt_crawler.id_crawler 251 AND date >'".sql_quote($daterequest)."' 252 AND crawlt_visits.crawlt_site_id_site='".sql_quote($site)."' 253 AND crawler_name= 'MSN Bot' 254 GROUP BY crawler_name"; 255 } 256 257 $requetemsn = mysql_query($sqlmsn, $connexion) or die("MySQL query error"); 258 $nbrresult=mysql_num_rows($requetemsn); 259 if($nbrresult>=1) 260 { 261 $lignemsn = mysql_fetch_row($requetemsn); 262 $visitmsn=$lignemsn[1]; 263 } 264 else 265 { 266 $visitmsn=0; 267 } 268 269 //request to have the number of Slurp Inktomi (Yahoo) visits 270 if($period>=10) 271 { 272 $sqlyahoo = "SELECT crawler_name, COUNT(DISTINCT id_visit), crawlt_crawler_id_crawler FROM crawlt_visits, crawlt_crawler 273 WHERE crawlt_visits.crawlt_crawler_id_crawler=crawlt_crawler.id_crawler 274 AND date >'".sql_quote($daterequest)."' 275 AND date <'".sql_quote($daterequest2)."' 276 AND crawlt_visits.crawlt_site_id_site='".sql_quote($site)."' 277 AND crawler_name= 'Slurp Inktomi (Yahoo)' 278 GROUP BY crawler_name"; 279 } 280 else 281 { 282 $sqlyahoo = "SELECT crawler_name, COUNT(DISTINCT id_visit), crawlt_crawler_id_crawler FROM crawlt_visits, crawlt_crawler 283 WHERE crawlt_visits.crawlt_crawler_id_crawler=crawlt_crawler.id_crawler 284 AND date >'".sql_quote($daterequest)."' 285 AND crawlt_visits.crawlt_site_id_site='".sql_quote($site)."' 286 AND crawler_name= 'Slurp Inktomi (Yahoo)' 287 GROUP BY crawler_name"; 288 } 289 290 $requeteyahoo = mysql_query($sqlyahoo, $connexion) or die("MySQL query error"); 291 $nbrresult=mysql_num_rows($requeteyahoo); 292 if($nbrresult>=1) 293 { 294 $ligneyahoo = mysql_fetch_row($requeteyahoo); 295 $visityahoo=$ligneyahoo[1]; 296 } 297 else 298 { 299 $visityahoo = 0; 300 } 301 302 //request to have the number of Ask Jeeves/Teoma (Ask) visits 303 if($period>=10) 304 { 305 $sqlask = "SELECT crawler_name, COUNT(DISTINCT id_visit), crawlt_crawler_id_crawler FROM crawlt_visits, crawlt_crawler 306 WHERE crawlt_visits.crawlt_crawler_id_crawler=crawlt_crawler.id_crawler 307 AND date >'".sql_quote($daterequest)."' 308 AND date <'".sql_quote($daterequest2)."' 309 AND crawlt_visits.crawlt_site_id_site='".sql_quote($site)."' 310 AND crawler_name= 'Ask Jeeves/Teoma' 311 GROUP BY crawler_name"; 312 } 313 else 314 { 315 $sqlask = "SELECT crawler_name, COUNT(DISTINCT id_visit), crawlt_crawler_id_crawler FROM crawlt_visits, crawlt_crawler 316 WHERE crawlt_visits.crawlt_crawler_id_crawler=crawlt_crawler.id_crawler 317 AND date >'".sql_quote($daterequest)."' 318 AND crawlt_visits.crawlt_site_id_site='".sql_quote($site)."' 319 AND crawler_name= 'Ask Jeeves/Teoma' 320 GROUP BY crawler_name"; 321 } 322 323 $requeteask = mysql_query($sqlask, $connexion) or die("MySQL query error"); 324 $nbrresult=mysql_num_rows($requeteask); 325 if($nbrresult>=1) 326 { 327 $ligneask = mysql_fetch_row($requeteask); 328 $visitask=$ligneask[1]; 329 } 330 else 331 { 332 $visitask = 0; 333 } 334 335 336 337 338 //cleaning of the crawlt_visits_human table 339 include "include/cleaning-double-entry.php"; 340 341 //request to have the visits send by Google 342 if($period>=10) 343 { 344 $sqlgoogle2 = "SELECT id_visit, crawlt_id_crawler FROM crawlt_visits_human 345 WHERE date >'".sql_quote($daterequest)."' 346 AND date <'".sql_quote($daterequest2)."' 347 AND crawlt_site_id_site='".sql_quote($site)."' 348 AND crawlt_id_crawler= '1' "; 349 } 350 else 351 { 352 $sqlgoogle2 = "SELECT id_visit, crawlt_id_crawler FROM crawlt_visits_human 353 WHERE date >'".sql_quote($daterequest)."' 354 AND crawlt_site_id_site='".sql_quote($site)."' 355 AND crawlt_id_crawler= '1' "; 356 } 357 358 $requetegoogle2 = mysql_query($sqlgoogle2, $connexion) or die("MySQL query error"); 359 $visitsendgoogle=mysql_num_rows($requetegoogle2); 360 361 362 363 //request to have the visits send by MSN 364 if($period>=10) 365 { 366 $sqlmsn2 = "SELECT id_visit, crawlt_id_crawler FROM crawlt_visits_human 367 WHERE date >'".sql_quote($daterequest)."' 368 AND date <'".sql_quote($daterequest2)."' 369 AND crawlt_site_id_site='".sql_quote($site)."' 370 AND crawlt_id_crawler= '3' "; 371 } 372 else 373 { 374 $sqlmsn2 = "SELECT id_visit, crawlt_id_crawler FROM crawlt_visits_human 375 WHERE date >'".sql_quote($daterequest)."' 376 AND crawlt_site_id_site='".sql_quote($site)."' 377 AND crawlt_id_crawler= '3' "; 378 } 379 380 $requetemsn2 = mysql_query($sqlmsn2, $connexion) or die("MySQL query error"); 381 $visitsendmsn=mysql_num_rows($requetemsn2); 382 383 //request to have the visits send by Yahoo 384 if($period>=10) 385 { 386 $sqlyahoo2 = "SELECT id_visit, crawlt_id_crawler FROM crawlt_visits_human 387 WHERE date >'".sql_quote($daterequest)."' 388 AND date <'".sql_quote($daterequest2)."' 389 AND crawlt_site_id_site='".sql_quote($site)."' 390 AND crawlt_id_crawler= '2' "; 391 } 392 else 393 { 394 $sqlyahoo2 = "SELECT id_visit, crawlt_id_crawler FROM crawlt_visits_human 395 WHERE date >'".sql_quote($daterequest)."' 396 AND crawlt_site_id_site='".sql_quote($site)."' 397 AND crawlt_id_crawler= '2' "; 398 } 399 400 $requeteyahoo2 = mysql_query($sqlyahoo2, $connexion) or die("MySQL query error"); 401 $visitsendyahoo=mysql_num_rows($requeteyahoo2); 402 403 //request to have the visits send by Ask 404 if($period>=10) 405 { 406 $sqlask2 = "SELECT id_visit, crawlt_id_crawler FROM crawlt_visits_human 407 WHERE date >'".sql_quote($daterequest)."' 408 AND date <'".sql_quote($daterequest2)."' 409 AND crawlt_site_id_site='".sql_quote($site)."' 410 AND crawlt_id_crawler= '4' "; 411 } 412 else 413 { 414 $sqlask2 = "SELECT id_visit, crawlt_id_crawler FROM crawlt_visits_human 415 WHERE date >'".sql_quote($daterequest)."' 416 AND crawlt_site_id_site='".sql_quote($site)."' 417 AND crawlt_id_crawler= '4' "; 418 } 419 420 $requeteask2 = mysql_query($sqlask2, $connexion) or die("MySQL query error"); 421 $visitsendask=mysql_num_rows($requeteask2); 422 423 //display 424 echo"<div class=\"content\">\n"; 425 echo crawltbackforward('index',$period,$daytodaylocal,$monthtodaylocal,$yeartodaylocal,$daybeginlocal,$monthbeginlocal,$yearbeginlocal,$dayendweek,$monthendweek,$yearendweek,$crawler,$navig,$site,$graphpos); 426 echo"</div>\n"; 427 428 //backling and index page table 429 echo"<div class='tableaularge' align='center'>\n"; 430 echo"<table cellpadding='0px' cellspacing='0' width='100%'>\n"; 431 echo"<tr onmouseover=\"javascript:montre();\">\n"; 432 echo"<th class='tableau10' colspan=\"3\">\n"; 433 echo"".$language['searchengine']."\n"; 434 echo"</th></tr><tr>\n"; 435 echo"<th class='tableau1' width=\"20%\" >\n"; 436 echo" \n"; 437 echo"</th>\n"; 438 echo"<th class='tableau1' width=\"40%\">\n"; 439 echo"".$language['nbr_tot_link']."\n"; 440 echo"</th>\n"; 441 echo"<th class='tableau2' width=\"40%\">\n"; 442 echo"".$language['nbr_tot_pages_index']."\n"; 443 echo"</th></tr>\n"; 444 echo"<tr><td class='tableau3g' > <a href=\"http://msdn.microsoft.com/live/search/\">".$language['msn']."</a>\n"; 445 if($period==0 && ($linkmsn==0 OR $pagemsn==0)) 446 { 447 echo"<a href=\"./php/searchenginespositionrefresh.php?retry=msn&navig=$navig&period=$period&site=$site&crawler=$crawlencode&graphpos=$graphpos\"><img src=\"./images/refresh.png\" width=\"16\" height=\"16\" border=\"0\" ></a></td>\n"; 448 } 449 else 450 { 451 echo"</td>\n"; 452 } 453 if($linkmsn==0) 454 { 455 echo"<td class='tableau3' >-</td>\n"; 456 } 457 else 458 { 459 echo"<td class='tableau3'>".numbdisp($linkmsn)."</td>\n"; 460 } 461 if($pagemsn==0) 462 { 463 echo"<td class='tableau5'>-</td></tr>\n"; 464 } 465 else 466 { 467 echo"<td class='tableau5'>".numbdisp($pagemsn)."</td></tr>\n"; 468 } 469 echo"<tr><td class='tableau30g'> <a href=\"http://developer.yahoo.net/about\">".$language['yahoo']."</a>\n"; 470 if($period==0 && ($linkyahoo==0 OR $pageyahoo==0)) 471 { 472 echo"<a href=\"./php/searchenginespositionrefresh.php?retry=yahoo&navig=$navig&period=$period&site=$site&crawler=$crawlencode&graphpos=$graphpos\"><img src=\"./images/refresh.png\" width=\"16\" height=\"16\" border=\"0\" ></a></td>\n"; 473 } 474 else 475 { 476 echo"</td>\n"; 477 } 478 if($linkyahoo==0) 479 { 480 echo"<td class='tableau30' >-</td>\n"; 481 } 482 else 483 { 484 echo"<td class='tableau30'>".numbdisp($linkyahoo)."</td>\n"; 485 } 486 if($pageyahoo==0) 487 { 488 echo"<td class='tableau50'>-</td></tr>\n"; 489 } 490 else 491 { 492 echo"<td class='tableau50'>".numbdisp($pageyahoo)."</td></tr>\n"; 493 } 494 495 echo"</table><br>\n"; 496 497 498 echo"<table cellpadding='0px' cellspacing='0' width='100%'>\n"; 499 echo"<tr onmouseover=\"javascript:montre();\">\n"; 500 echo"<th class='tableau10' colspan=\"3\">\n"; 501 echo"".$language['social-bookmark']."\n"; 502 echo"</th></tr><tr>\n"; 503 echo"<th class='tableau1' width=\"24%\">\n"; 504 echo" \n"; 505 echo"</th>\n"; 506 echo"<th class='tableau1' width=\"20%\">\n"; 507 echo"".$language['nbr_tot_bookmark']."\n"; 508 echo"</th>\n"; 509 echo"<th class='tableau2'width=\"56%\">\n"; 510 echo"".$language['tag']."\n"; 511 echo"</th></tr>\n"; 512 echo"<tr><td class='tableau3g' > <a href=\"http://del.icio.us/help/api/\">".$language['delicious']."</a>\n"; 513 if($period==0 && $linkdelicious==0) 514 { 515 echo"<a href=\"./php/searchenginespositionrefresh.php?retry=delicious&navig=$navig&period=$period&site=$site&crawler=$crawlencode&graphpos=$graphpos\"><img src=\"./images/refresh.png\" width=\"16\" height=\"16\" border=\"0\" ></a></td>\n"; 516 } 517 else 518 { 519 echo"</td>\n"; 520 } 521 if($linkdelicious==0) 522 { 523 echo"<td class='tableau3' >-</td>\n"; 524 } 525 else 526 { 527 echo"<td class='tableau3'>".numbdisp($linkdelicious)."</td>\n"; 528 } 529 if($tagdelicious==' ') 530 { 531 echo"<td class='tableau5'>-</td></tr>\n"; 532 } 533 else 534 { 535 echo"<td class='tableau5'>".$tagdelicious."</td></tr>\n"; 536 } 537 echo"</table><br>\n"; 538 539 540 echo"<table cellpadding='0px' cellspacing='0' width='100%'>\n"; 541 echo"<tr onmouseover=\"javascript:montre();\">\n"; 542 echo"<th class='tableau10' colspan=\"3\">\n"; 543 echo"".$language['nbr_visits']."\n"; 544 echo"</th></tr><tr>\n"; 545 echo"<th class='tableau1' >\n"; 546 echo"".$language['searchengine']."\n"; 547 echo"</th>\n"; 548 echo"<th class='tableau1' >\n"; 549 echo"".$language['nbr_visits_crawler']."\n"; 550 echo"</th>\n"; 551 echo"<th class='tableau2' >\n"; 552 echo"".$language['nbr_tot_visit_seo']."\n"; 553 echo"</th></tr>\n"; 554 echo"<tr><td class='tableau3'>".$language['ask']."</td>\n"; 555 echo"<td class='tableau3'>".numbdisp($visitask)."</td>\n"; 556 echo"<td class='tableau5'>".numbdisp($visitsendask)."</td></tr>\n"; 557 echo"<tr><td class='tableau30'>".$language['google']."</td>\n"; 558 echo"<td class='tableau30'>".numbdisp($visitgoogle)."</td>\n"; 559 echo"<td class='tableau50'>".numbdisp($visitsendgoogle)."</td></tr>\n"; 560 echo"<tr><td class='tableau3'>".$language['msn']."</td>\n"; 561 echo"<td class='tableau3'>".numbdisp($visitmsn)."</td>\n"; 562 echo"<td class='tableau5'>".numbdisp($visitsendmsn)."</td></tr>\n"; 563 echo"<tr><td class='tableau30'>".$language['yahoo']."</td>\n"; 564 echo"<td class='tableau30'>".numbdisp($visityahoo)."</td>\n"; 565 echo"<td class='tableau50'>".numbdisp($visitsendyahoo)."</td></tr>\n"; 566 567 echo"</table></div><br>\n"; 568 569 if(($visitgoogle + $visitmsn + $visityahoo + $visitask)>0) 570 { 571 //graph 572 $values[$language['google']]=$visitgoogle; 573 $values[$language['msn']]=$visitmsn; 574 $values[$language['yahoo']]=$visityahoo; 575 $values[$language['ask']]=$visitask; 576 //prepare datas to be transfert to graph file 577 $datatransferttograph=addslashes(urlencode(serialize($values))); 578 //insert the values in the graph table 579 $piegraphname1="crawlervisits-".$cachename; 580 581 //check if this graph exit already in the table 582 $sql = "SELECT name FROM crawlt_graph 583 WHERE name= '".sql_quote($piegraphname1)."'"; 584 585 586 $requete = mysql_query($sql, $connexion) or die("MySQL query error"); 587 $nbrresult=mysql_num_rows($requete); 588 if($nbrresult >=1) 589 { 590 $sql2 ="UPDATE crawlt_graph SET graph_values='".sql_quote($datatransferttograph)."' 591 WHERE name= '".sql_quote($piegraphname1)."'"; 592 } 593 else 594 { 595 $sql2 ="INSERT INTO crawlt_graph (name,graph_values) VALUES ( '".sql_quote($piegraphname1)."','".sql_quote($datatransferttograph)."')"; 596 } 597 $requete2 = mysql_query($sql2, $connexion) or die("MySQL query error"); 598 } 599 600 if(($visitsendgoogle + $visitsendmsn + $visitsendyahoo + $visitsendask)>0) 601 { 602 //graph 603 $values2[$language['google']]=$visitsendgoogle; 604 $values2[$language['msn']]=$visitsendmsn; 605 $values2[$language['yahoo']]=$visitsendyahoo; 606 $values2[$language['ask']]=$visitsendask; 607 //prepare datas to be transfert to graph file 608 $datatransferttograph=addslashes(urlencode(serialize($values2))); 609 //insert the values in the graph table 610 $piegraphname="searchengine-".$cachename; 611 612 //check if this graph exit already in the table 613 $sql = "SELECT name FROM crawlt_graph 614 WHERE name= '".sql_quote($piegraphname)."'"; 615 616 617 $requete = mysql_query($sql, $connexion) or die("MySQL query error"); 618 $nbrresult=mysql_num_rows($requete); 619 if($nbrresult >=1) 620 { 621 $sql2 ="UPDATE crawlt_graph SET graph_values='".sql_quote($datatransferttograph)."' 622 WHERE name= '".sql_quote($piegraphname)."'"; 623 } 624 else 625 { 626 $sql2 ="INSERT INTO crawlt_graph (name,graph_values) VALUES ( '".sql_quote($piegraphname)."','".sql_quote($datatransferttograph)."')"; 627 } 628 $requete2 = mysql_query($sql2, $connexion) or die("MySQL query error"); 629 } 630 631 if(($visitgoogle + $visitmsn + $visityahoo + $visitask)>0 && ($visitsendgoogle + $visitsendmsn + $visitsendyahoo + $visitsendask)>0) 632 { 633 //graph 634 echo"<div align=\"center\" width=\"100%\">\n"; 635 echo"<img src=\"./graphs/crawler-graph.php?graphname=$piegraphname1&crawltlang=$crawltlang\" alt=\"graph\" width=\"450\" heigth=\"175\" style=\"border:0\"/><img src=\"./graphs/crawler-graph.php?graphname=$piegraphname&crawltlang=$crawltlang\" alt=\"graph\" width=\"450\" heigth=\"175\" style=\"border:0\"/>\n"; 636 echo"</div>\n"; 637 } 638 elseif(($visitgoogle + $visitmsn + $visityahoo + $visitask)>0 && ($visitsendgoogle + $visitsendmsn + $visitsendyahoo + $visitsendask)==0) 639 { 640 //graph 641 echo"<div align=\"center\" width=\"100%\">\n"; 642 echo"<img src=\"./graphs/crawler-graph.php?graphname=$piegraphname1&crawltlang=$crawltlang\" alt=\"graph\" width=\"450\" heigth=\"175\" style=\"border:0\"/>\n"; 643 echo"</div>\n"; 644 } 645 elseif(($visitgoogle + $visitmsn + $visityahoo + $visitask)==0 && ($visitsendgoogle + $visitsendmsn + $visitsendyahoo + $visitsendask)>0) 646 { 647 //graph 648 echo"<div align=\"center\" width=\"100%\">\n"; 649 echo"<img src=\"./graphs/crawler-graph.php?graphname=$piegraphname&crawltlang=$crawltlang\" alt=\"graph\" width=\"450\" heigth=\"175\" style=\"border:0\"/>\n"; 650 echo"</div>\n"; 651 } 652 if($period != 5) 653 { 654 //graph 655 echo"<div class='graphvisits'>\n"; 656 //mapgraph 657 $typegraph='link'; 658 include "include/mapgraph2.php"; 659 echo"<img src=\"./graphs/seo-graph.php?typegraph=$typegraph&crawltlang=$crawltlang&period=$period&graphname=$graphname\" USEMAP=\"#seolink\" border=\"0\" alt=\"graph\" width=\"100%\" heigth=\"100%\"/>\n"; 660 echo" </div><br>\n"; 661 echo"<div class='imprimgraph'>\n"; 662 echo" <br><br><br><br><br><br><br><br><br><br><br><br><br><br></div>\n"; 663 //graph 664 echo"<div class='graphvisits'>\n"; 665 //mapgraph 666 $typegraph='page'; 667 include "include/mapgraph2.php"; 668 echo"<img src=\"./graphs/seo-graph.php?typegraph=$typegraph&crawltlang=$crawltlang&period=$period&graphname=$graphname\" USEMAP=\"#seopage\" border=\"0\" alt=\"graph\" width=\"100%\" heigth=\"100%\"/>\n"; 669 echo" </div><br>\n"; 670 echo"<div class='imprimgraph'>\n"; 671 echo" <br><br><br><br></div>\n"; 672 //graph 673 echo"<div class='graphvisits'>\n"; 674 //mapgraph 675 $typegraph='bookmark'; 676 include "include/mapgraph2.php"; 677 echo"<img src=\"./graphs/seo-graph.php?typegraph=$typegraph&crawltlang=$crawltlang&period=$period&graphname=$graphname\" USEMAP=\"#bookmark\" border=\"0\" alt=\"graph\" width=\"100%\" heigth=\"100%\"/>\n"; 678 echo" </div><br>\n"; 679 echo"<div class='imprimgraph'>\n"; 680 echo" <br><br><br><br></div>\n"; 681 682 //graph 683 echo"<div class='graphvisits'>\n"; 684 //mapgraph 685 $typegraph='entry'; 686 include "include/mapgraph2.php"; 687 echo"<img src=\"./graphs/seo-graph.php?typegraph=$typegraph&crawltlang=$crawltlang&period=$period&graphname=$graphname\" USEMAP=\"#seoentry\" border=\"0\" alt=\"graph\" width=\"100%\" heigth=\"100%\"/>\n"; 688 echo" <br><br>\n"; 689 echo" </div><br>\n"; 690 echo"<div class='imprimgraph'>\n"; 691 echo" <br><br><br><br>\n"; 692 } 693 else 694 { 695 echo"<div>\n"; 696 } 697 //mysql connexion close 698 mysql_close($connexion); 699 ?>
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 |