| [ 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:mapgraph2.php 14 //---------------------------------------------------------------------- 15 16 //initialize array 17 $axexlabel=array(); 18 $axex=array(); 19 $googlevisit=array(); 20 $yahoovisit=array(); 21 $msnvisit=array(); 22 $askvisit=array(); 23 $yahoozerolink=array(); 24 $msnzerolink=array(); 25 $yahoozeropage=array(); 26 $msnzeropage=array(); 27 $deliciouszerolink=array(); 28 $yahoolink=array(); 29 $yahoopage=array(); 30 $msnlink=array(); 31 $msnpage=array(); 32 $deliciouslink=array(); 33 $yahoo=array(); 34 $msn=array(); 35 $datatransfert1=array(); 36 $google1=array(); 37 $msn1=array(); 38 $yahoo1=array(); 39 $ask1=array(); 40 $datatransfert2=array(); 41 $msn2=array(); 42 $yahoo2=array(); 43 $datatransfert3=array(); 44 $delicious=array(); 45 $datatransfert4=array(); 46 //prepare X axis label 47 //number of days (or months) for the period 48 $nbday2=0; 49 $date=$datebeginlocalcut[0]; 50 51 if($period==0 OR $period>=1000) 52 { 53 $nbday=8; 54 $daterequestseo = date("Y-m-d H:i:s",(strtotime($daterequest)- 604800)); 55 $datebeginlocalseo = date("Y-m-d H:i:s",(strtotime($datebeginlocal)- 604800)); 56 $datebeginlocalcutseo = explode(' ', $datebeginlocalseo); 57 $date=$datebeginlocalcutseo[0]; 58 } 59 elseif($period==1 OR ($period>=300 && $period<400)) 60 { 61 $nbday=7; 62 $daterequestseo=$daterequest; 63 } 64 elseif($period==2 OR ($period>=100 && $period<200)) 65 { 66 $nbday=date("t",mktime(0,0,0,$monthrequest,$dayrequest,$yearrequest)); 67 $daterequestseo=$daterequest; 68 } 69 elseif($period==3 OR ($period >= 200 && $period<300)) 70 { 71 $nbday=12; 72 $daterequestseo=$daterequest; 73 } 74 elseif($period==4) 75 { 76 $nbday=8; 77 $daterequestseo=$daterequest; 78 } 79 80 81 82 do { 83 84 $date2=$date; 85 $date20 = explode('-', $date); 86 $yeardate = $date20[0]; 87 $monthdate = $date20[1]; 88 $daydate = $date20[2]; 89 90 if($nbday==7) 91 { 92 if($firstdayweek =='Monday') 93 { 94 $day="day".$nbday2; 95 } 96 else 97 { 98 //case first week day is sunday 99 $nbday3=$nbday2+6; 100 if($nbday3>6) 101 { 102 $nbday3=$nbday3-7; 103 } 104 $day="day".$nbday3; 105 } 106 $axexlabel[$daydate."-".$monthdate."-".$yeardate]=$language[$day]." ".$daydate; 107 $axex[]=$daydate."-".$monthdate."-".$yeardate; 108 $askvisit[$daydate."-".$monthdate."-".$yeardate]=0; 109 $googlevisit[$daydate."-".$monthdate."-".$yeardate]=0; 110 $msnlink[$daydate."-".$monthdate."-".$yeardate]=0; 111 $msnpage[$daydate."-".$monthdate."-".$yeardate]=0; 112 $msnvisit[$daydate."-".$monthdate."-".$yeardate]=0; 113 $yahoolink[$daydate."-".$monthdate."-".$yeardate]=0; 114 $yahoopage[$daydate."-".$monthdate."-".$yeardate]=0; 115 $yahoovisit[$daydate."-".$monthdate."-".$yeardate]=0; 116 $deliciouslink[$daydate."-".$monthdate."-".$yeardate]=0; 117 $datatransfert[$language[$day]." ".$daydate]='0-0-0-0'; 118 if(nbdayfromtoday($date)==0) 119 { 120 $totperiod[$daydate."-".$monthdate."-".$yeardate]=0; 121 } 122 else 123 { 124 $totperiod[$daydate."-".$monthdate."-".$yeardate]=999+nbdayfromtoday($date); 125 } 126 } 127 elseif($nbday==12) 128 { 129 $actualmonth=date("m"); 130 $actualyear=date("Y"); 131 $yearmonth=$monthdate."/".$yeardate; 132 if($monthdate>=$actualmonth && $yeardate==$actualyear) 133 { 134 $totperiod[$yearmonth]=2; 135 } 136 else 137 { 138 $totperiod[$yearmonth]=99+($actualmonth-$monthdate)+(12*($actualyear-$yeardate)); 139 } 140 $axexlabel[$yearmonth]=$yearmonth; 141 $axex[]=$yearmonth; 142 $askvisit[$yearmonth]=0; 143 $googlevisit[$yearmonth]=0; 144 $msnlink[$yearmonth]=0; 145 $msnpage[$yearmonth]=0; 146 $msnvisit[$yearmonth]=0; 147 $yahoolink[$yearmonth]=0; 148 $yahoopage[$yearmonth]=0; 149 $yahoovisit[$yearmonth]=0; 150 $deliciouslink[$yearmonth]=0; 151 $datatransfert[$yearmonth]='0-0-0-0'; 152 } 153 else 154 { 155 $axexlabel[$daydate."-".$monthdate."-".$yeardate]=$daydate."-".$monthdate."-".substr("$yeardate",2,4); 156 $axex[]=$daydate."-".$monthdate."-".$yeardate; 157 $askvisit[$daydate."-".$monthdate."-".$yeardate]=0; 158 $googlevisit[$daydate."-".$monthdate."-".$yeardate]=0; 159 $msnlink[$daydate."-".$monthdate."-".$yeardate]=0; 160 $msnpage[$daydate."-".$monthdate."-".$yeardate]=0; 161 $msnvisit[$daydate."-".$monthdate."-".$yeardate]=0; 162 $yahoolink[$daydate."-".$monthdate."-".$yeardate]=0; 163 $yahoopage[$daydate."-".$monthdate."-".$yeardate]=0; 164 $yahoovisit[$daydate."-".$monthdate."-".$yeardate]=0; 165 $deliciouslink[$daydate."-".$monthdate."-".$yeardate]=0; 166 $datatransfert[$daydate."-".$monthdate."-".substr("$yeardate",2,4)]='0-0-0-0'; 167 if(nbdayfromtoday($date)==0) 168 { 169 $totperiod[$daydate."-".$monthdate."-".$yeardate]=0; 170 } 171 else 172 { 173 $totperiod[$daydate."-".$monthdate."-".$yeardate]=999+nbdayfromtoday($date); 174 } 175 } 176 if($nbday==12) 177 { 178 $monthdate1=$monthdate + 1; 179 $ts = mktime(0,0,0,$monthdate1, 15, $yeardate); 180 } 181 else 182 { 183 $ts = mktime(0,0,0,$monthdate, $daydate, $yeardate) + 86400; 184 } 185 $date = date("Y-m-d",$ts); 186 //case change summer time to winter time 187 if($date==$date2) 188 { 189 $date = date("Y-m-d",($ts+7200)); 190 } 191 $nbday2++; 192 } 193 while($nbday2<$nbday); 194 195 196 //mysql requete 197 198 if($typegraph =='entry') 199 { 200 //requete to count the number of entry 201 if($period ==3) //case one year 202 { 203 $sqlgoogle = "SELECT FROM_UNIXTIME(UNIX_TIMESTAMP(date)-($times*3600), '%Y%m') , crawlt_id_crawler,COUNT(id_visit) FROM crawlt_visits_human 204 WHERE date >='".sql_quote($daterequestseo)."' 205 AND crawlt_site_id_site='".sql_quote($site)."' 206 AND crawlt_id_crawler='1' 207 GROUP BY FROM_UNIXTIME(UNIX_TIMESTAMP(date)-($times*3600), '%Y%m')"; 208 209 $requetegoogle = mysql_query($sqlgoogle, $connexion) or die("MySQL query error"); 210 211 while ($ligne = mysql_fetch_row($requetegoogle)) 212 { 213 $year=substr($ligne[0],0,4); 214 $month=substr($ligne[0],4,2); 215 $yearmonth=$month."/".$year; 216 $googlevisit[$yearmonth]= $ligne[2]; 217 } 218 219 $sqlyahoo = "SELECT FROM_UNIXTIME(UNIX_TIMESTAMP(date)-($times*3600), '%Y%m') , crawlt_id_crawler,COUNT(id_visit) FROM crawlt_visits_human 220 WHERE date >='".sql_quote($daterequestseo)."' 221 AND crawlt_site_id_site='".sql_quote($site)."' 222 AND crawlt_id_crawler='2' 223 GROUP BY FROM_UNIXTIME(UNIX_TIMESTAMP(date)-($times*3600), '%Y%m')"; 224 225 $requeteyahoo = mysql_query($sqlyahoo, $connexion) or die("MySQL query error"); 226 227 while ($ligne = mysql_fetch_row($requeteyahoo)) 228 { 229 $year=substr($ligne[0],0,4); 230 $month=substr($ligne[0],4,2); 231 $yearmonth=$month."/".$year; 232 $yahoovisit[$yearmonth]= $ligne[2]; 233 } 234 235 $sqlmsn = "SELECT FROM_UNIXTIME(UNIX_TIMESTAMP(date)-($times*3600), '%Y%m') , crawlt_id_crawler,COUNT(id_visit) FROM crawlt_visits_human 236 WHERE date >='".sql_quote($daterequestseo)."' 237 AND crawlt_site_id_site='".sql_quote($site)."' 238 AND crawlt_id_crawler='3' 239 GROUP BY FROM_UNIXTIME(UNIX_TIMESTAMP(date)-($times*3600), '%Y%m')"; 240 241 $requetemsn = mysql_query($sqlmsn, $connexion) or die("MySQL query error"); 242 243 while ($ligne = mysql_fetch_row($requetemsn)) 244 { 245 $year=substr($ligne[0],0,4); 246 $month=substr($ligne[0],4,2); 247 $yearmonth=$month."/".$year; 248 $msnvisit[$yearmonth]= $ligne[2]; 249 } 250 251 $sqlask = "SELECT FROM_UNIXTIME(UNIX_TIMESTAMP(date)-($times*3600), '%Y%m') , crawlt_id_crawler,COUNT(id_visit) FROM crawlt_visits_human 252 WHERE date >='".sql_quote($daterequestseo)."' 253 AND crawlt_site_id_site='".sql_quote($site)."' 254 AND crawlt_id_crawler='4' 255 GROUP BY FROM_UNIXTIME(UNIX_TIMESTAMP(date)-($times*3600), '%Y%m')"; 256 257 $requeteask = mysql_query($sqlask, $connexion) or die("MySQL query error"); 258 259 while ($ligne = mysql_fetch_row($requeteask)) 260 { 261 $year=substr($ligne[0],0,4); 262 $month=substr($ligne[0],4,2); 263 $yearmonth=$month."/".$year; 264 $askvisit[$yearmonth]= $ligne[2]; 265 } 266 267 } 268 elseif($period >= 200 && $period<300) //case one year back and forward 269 { 270 $sqlgoogle = "SELECT FROM_UNIXTIME(UNIX_TIMESTAMP(date)-($times*3600), '%Y%m') , crawlt_id_crawler,COUNT(id_visit) FROM crawlt_visits_human 271 WHERE date >='".sql_quote($daterequestseo)."' 272 AND date <'".sql_quote($daterequest2)."' 273 AND crawlt_site_id_site='".sql_quote($site)."' 274 AND crawlt_id_crawler='1' 275 GROUP BY FROM_UNIXTIME(UNIX_TIMESTAMP(date)-($times*3600), '%Y%m')"; 276 277 $requetegoogle = mysql_query($sqlgoogle, $connexion) or die("MySQL query error"); 278 279 while ($ligne = mysql_fetch_row($requetegoogle)) 280 { 281 $year=substr($ligne[0],0,4); 282 $month=substr($ligne[0],4,2); 283 $yearmonth=$month."/".$year; 284 $googlevisit[$yearmonth]= $ligne[2]; 285 } 286 287 $sqlyahoo = "SELECT FROM_UNIXTIME(UNIX_TIMESTAMP(date)-($times*3600), '%Y%m') , crawlt_id_crawler,COUNT(id_visit) FROM crawlt_visits_human 288 WHERE date >='".sql_quote($daterequestseo)."' 289 AND date <'".sql_quote($daterequest2)."' 290 AND crawlt_site_id_site='".sql_quote($site)."' 291 AND crawlt_id_crawler='2' 292 GROUP BY FROM_UNIXTIME(UNIX_TIMESTAMP(date)-($times*3600), '%Y%m')"; 293 294 $requeteyahoo = mysql_query($sqlyahoo, $connexion) or die("MySQL query error"); 295 296 while ($ligne = mysql_fetch_row($requeteyahoo)) 297 { 298 $year=substr($ligne[0],0,4); 299 $month=substr($ligne[0],4,2); 300 $yearmonth=$month."/".$year; 301 $yahoovisit[$yearmonth]= $ligne[2]; 302 } 303 304 $sqlmsn = "SELECT FROM_UNIXTIME(UNIX_TIMESTAMP(date)-($times*3600), '%Y%m') , crawlt_id_crawler,COUNT(id_visit) FROM crawlt_visits_human 305 WHERE date >='".sql_quote($daterequestseo)."' 306 AND date <'".sql_quote($daterequest2)."' 307 AND crawlt_site_id_site='".sql_quote($site)."' 308 AND crawlt_id_crawler='3' 309 GROUP BY FROM_UNIXTIME(UNIX_TIMESTAMP(date)-($times*3600), '%Y%m')"; 310 311 $requetemsn = mysql_query($sqlmsn, $connexion) or die("MySQL query error"); 312 313 while ($ligne = mysql_fetch_row($requetemsn)) 314 { 315 $year=substr($ligne[0],0,4); 316 $month=substr($ligne[0],4,2); 317 $yearmonth=$month."/".$year; 318 $msnvisit[$yearmonth]= $ligne[2]; 319 } 320 321 $sqlask = "SELECT FROM_UNIXTIME(UNIX_TIMESTAMP(date)-($times*3600), '%Y%m') , crawlt_id_crawler,COUNT(id_visit) FROM crawlt_visits_human 322 WHERE date >='".sql_quote($daterequestseo)."' 323 AND date <'".sql_quote($daterequest2)."' 324 AND crawlt_site_id_site='".sql_quote($site)."' 325 AND crawlt_id_crawler='4' 326 GROUP BY FROM_UNIXTIME(UNIX_TIMESTAMP(date)-($times*3600), '%Y%m')"; 327 328 $requeteask = mysql_query($sqlask, $connexion) or die("MySQL query error"); 329 330 while ($ligne = mysql_fetch_row($requeteask)) 331 { 332 $year=substr($ligne[0],0,4); 333 $month=substr($ligne[0],4,2); 334 $yearmonth=$month."/".$year; 335 $askvisit[$yearmonth]= $ligne[2]; 336 } 337 338 } 339 else 340 { 341 $sqlgoogle = "SELECT FROM_UNIXTIME(UNIX_TIMESTAMP(date)-($times*3600), '%d-%m-%Y') , crawlt_id_crawler,COUNT(id_visit) FROM crawlt_visits_human 342 WHERE date >='".sql_quote($daterequestseo)."' 343 AND crawlt_site_id_site='".sql_quote($site)."' 344 AND crawlt_id_crawler='1' 345 GROUP BY FROM_UNIXTIME(UNIX_TIMESTAMP(date)-($times*3600), '%d-%m-%Y')"; 346 347 $requetegoogle = mysql_query($sqlgoogle, $connexion) or die("MySQL query error"); 348 349 while ($ligne = mysql_fetch_row($requetegoogle)) 350 { 351 $googlevisit[$ligne[0]]= $ligne[2]; 352 } 353 354 $sqlyahoo = "SELECT FROM_UNIXTIME(UNIX_TIMESTAMP(date)-($times*3600), '%d-%m-%Y') , crawlt_id_crawler,COUNT(id_visit) FROM crawlt_visits_human 355 WHERE date >='".sql_quote($daterequestseo)."' 356 AND crawlt_site_id_site='".sql_quote($site)."' 357 AND crawlt_id_crawler='2' 358 GROUP BY FROM_UNIXTIME(UNIX_TIMESTAMP(date)-($times*3600), '%d-%m-%Y')"; 359 360 $requeteyahoo = mysql_query($sqlyahoo, $connexion) or die("MySQL query error"); 361 362 while ($ligne = mysql_fetch_row($requeteyahoo)) 363 { 364 $yahoovisit[$ligne[0]]= $ligne[2]; 365 } 366 367 $sqlmsn = "SELECT FROM_UNIXTIME(UNIX_TIMESTAMP(date)-($times*3600), '%d-%m-%Y') , crawlt_id_crawler,COUNT(id_visit) FROM crawlt_visits_human 368 WHERE date >='".sql_quote($daterequestseo)."' 369 AND crawlt_site_id_site='".sql_quote($site)."' 370 AND crawlt_id_crawler='3' 371 GROUP BY FROM_UNIXTIME(UNIX_TIMESTAMP(date)-($times*3600), '%d-%m-%Y')"; 372 373 $requetemsn = mysql_query($sqlmsn, $connexion) or die("MySQL query error"); 374 375 while ($ligne = mysql_fetch_row($requetemsn)) 376 { 377 $msnvisit[$ligne[0]]= $ligne[2]; 378 } 379 380 $sqlask = "SELECT FROM_UNIXTIME(UNIX_TIMESTAMP(date)-($times*3600), '%d-%m-%Y') , crawlt_id_crawler,COUNT(id_visit) FROM crawlt_visits_human 381 WHERE date >='".sql_quote($daterequestseo)."' 382 AND crawlt_site_id_site='".sql_quote($site)."' 383 AND crawlt_id_crawler='4' 384 GROUP BY FROM_UNIXTIME(UNIX_TIMESTAMP(date)-($times*3600), '%d-%m-%Y')"; 385 386 $requeteask = mysql_query($sqlask, $connexion) or die("MySQL query error"); 387 388 while ($ligne = mysql_fetch_row($requeteask)) 389 { 390 $askvisit[$ligne[0]]= $ligne[2]; 391 } 392 } 393 394 395 } 396 else 397 { 398 //request to count the number of link, index page and bookmark 399 400 if($period==3) //case one year 401 { 402 403 $yahoozerolinkexist=0; 404 $yahoozeropageexist=0; 405 $msnzerolinkexist=0; 406 $msnzeropageexist=0; 407 $deliciouszerolinkexist=0; 408 409 410 if($typegraph=='link') 411 { 412 //request to count the number of day with link=0 during the period 413 414 //yahoo 415 $sql = "SELECT FROM_UNIXTIME(UNIX_TIMESTAMP(date)-($times*3600), '%Y%m'), COUNT(linkyahoo) FROM crawlt_seo_position 416 WHERE date >='".sql_quote($daterequestseo)."' 417 AND id_site='".sql_quote($site)."' 418 AND linkyahoo = '0' 419 GROUP BY FROM_UNIXTIME(UNIX_TIMESTAMP(date)-($times*3600), '%Y%m')"; 420 421 $requete = mysql_query($sql, $connexion) or die("MySQL query error"); 422 $nbrresult=mysql_num_rows($requete); 423 if($nbrresult>=1) 424 { 425 while ($ligne = mysql_fetch_row($requete)) 426 { 427 $year=substr($ligne[0],0,4); 428 $month=substr($ligne[0],4,2); 429 $yearmonth=$month."/".$year; 430 $yahoozerolink[$yearmonth]= $ligne[1]; 431 } 432 $yahoozerolinkexist=1; 433 } 434 435 //msn 436 $sql = "SELECT FROM_UNIXTIME(UNIX_TIMESTAMP(date)-($times*3600), '%Y%m'), COUNT(linkmsn) FROM crawlt_seo_position 437 WHERE date >='".sql_quote($daterequestseo)."' 438 AND id_site='".sql_quote($site)."' 439 AND linkmsn = '0' 440 GROUP BY FROM_UNIXTIME(UNIX_TIMESTAMP(date)-($times*3600), '%Y%m')"; 441 442 $requete = mysql_query($sql, $connexion) or die("MySQL query error"); 443 $nbrresult=mysql_num_rows($requete); 444 if($nbrresult>=1) 445 { 446 while ($ligne = mysql_fetch_row($requete)) 447 { 448 $year=substr($ligne[0],0,4); 449 $month=substr($ligne[0],4,2); 450 $yearmonth=$month."/".$year; 451 $msnzerolink[$yearmonth]= $ligne[1]; 452 } 453 $msnzerolinkexist=1; 454 } 455 456 } 457 elseif($typegraph=='page') 458 { 459 //request to count the number of day with page=0 during the period 460 461 //yahoo 462 $sql = "SELECT FROM_UNIXTIME(UNIX_TIMESTAMP(date)-($times*3600), '%Y%m'), COUNT(pageyahoo) FROM crawlt_seo_position 463 WHERE date >='".sql_quote($daterequestseo)."' 464 AND id_site='".sql_quote($site)."' 465 AND pageyahoo = '0' 466 GROUP BY FROM_UNIXTIME(UNIX_TIMESTAMP(date)-($times*3600), '%Y%m')"; 467 468 $requete = mysql_query($sql, $connexion) or die("MySQL query error"); 469 $nbrresult=mysql_num_rows($requete); 470 if($nbrresult>=1) 471 { 472 while ($ligne = mysql_fetch_row($requete)) 473 { 474 $year=substr($ligne[0],0,4); 475 $month=substr($ligne[0],4,2); 476 $yearmonth=$month."/".$year; 477 $yahoozeropage[$yearmonth]= $ligne[1]; 478 } 479 $yahoozeropageexist=1; 480 } 481 //msn 482 $sql = "SELECT FROM_UNIXTIME(UNIX_TIMESTAMP(date)-($times*3600), '%Y%m'), COUNT(pagemsn) FROM crawlt_seo_position 483 WHERE date >='".sql_quote($daterequestseo)."' 484 AND id_site='".sql_quote($site)."' 485 AND pagemsn = '0' 486 GROUP BY FROM_UNIXTIME(UNIX_TIMESTAMP(date)-($times*3600), '%Y%m')"; 487 488 $requete = mysql_query($sql, $connexion) or die("MySQL query error"); 489 $nbrresult=mysql_num_rows($requete); 490 if($nbrresult>=1) 491 { 492 while ($ligne = mysql_fetch_row($requete)) 493 { 494 $year=substr($ligne[0],0,4); 495 $month=substr($ligne[0],4,2); 496 $yearmonth=$month."/".$year; 497 $msnzeropage[$yearmonth]= $ligne[1]; 498 } 499 $msnzeropageexist=1; 500 } 501 502 } 503 elseif($typegraph=='bookmark') 504 { 505 //request to count the number of day with bookmark=0 during the period 506 507 //del.icio.us 508 $sql = "SELECT FROM_UNIXTIME(UNIX_TIMESTAMP(date)-($times*3600), '%Y%m'), COUNT(nbrdelicious) FROM crawlt_seo_position 509 WHERE date >='".sql_quote($daterequestseo)."' 510 AND id_site='".sql_quote($site)."' 511 AND nbrdelicious = '0' 512 GROUP BY FROM_UNIXTIME(UNIX_TIMESTAMP(date)-($times*3600), '%Y%m')"; 513 514 $requete = mysql_query($sql, $connexion) or die("MySQL query error"); 515 $nbrresult=mysql_num_rows($requete); 516 if($nbrresult>=1) 517 { 518 while ($ligne = mysql_fetch_row($requete)) 519 { 520 $year=substr($ligne[0],0,4); 521 $month=substr($ligne[0],4,2); 522 $yearmonth=$month."/".$year; 523 $deliciouszerolink[$yearmonth]= $ligne[1]; 524 } 525 $deliciouszerolinkexist=1; 526 } 527 528 } 529 530 531 532 //request to count the number of link, index page and bookmarks 533 534 $sqlseograph = "SELECT FROM_UNIXTIME(UNIX_TIMESTAMP(date)-($times*3600), '%Y%m') , SUM(linkyahoo),SUM(pageyahoo), COUNT(linkyahoo), COUNT(pageyahoo) , SUM(linkmsn),SUM(pagemsn), COUNT(linkmsn), COUNT(pagemsn), SUM(nbrdelicious),COUNT(nbrdelicious) FROM crawlt_seo_position 535 WHERE date >='".sql_quote($daterequestseo)."' 536 AND id_site='".sql_quote($site)."' 537 GROUP BY FROM_UNIXTIME(UNIX_TIMESTAMP(date)-($times*3600), '%Y%m')"; 538 539 540 $requeteseograph = mysql_query($sqlseograph, $connexion) or die("MySQL query error"); 541 542 while ($ligne = mysql_fetch_row($requeteseograph)) 543 { 544 $year=substr($ligne[0],0,4); 545 $month=substr($ligne[0],4,2); 546 $yearmonth=$month."/".$year; 547 548 549 if($yahoozerolinkexist==1) 550 { 551 if($ligne[3]== @$yahoozerolink[$yearmonth]) 552 { 553 $yahoolink[$yearmonth]=0; 554 } 555 else 556 { 557 $yahoolink[$yearmonth]= round($ligne[1]/($ligne[3]-@$yahoozerolink[$yearmonth])); 558 } 559 } 560 else 561 { 562 $yahoolink[$yearmonth]= round($ligne[1]/$ligne[3]); 563 } 564 565 if($yahoozeropageexist==1) 566 { 567 if($ligne[4]== @$yahoozeropage[$yearmonth]) 568 { 569 $yahoopage[$yearmonth]=0; 570 } 571 else 572 { 573 $yahoopage[$yearmonth]= round($ligne[2]/($ligne[4]-@$yahoozeropage[$yearmonth])); 574 } 575 } 576 else 577 { 578 $yahoopage[$yearmonth]= round($ligne[2]/$ligne[4]); 579 } 580 581 582 if($msnzerolinkexist==1) 583 { 584 if($ligne[7]== @$msnzerolink[$yearmonth]) 585 { 586 $msnlink[$yearmonth]=0; 587 } 588 else 589 { 590 $msnlink[$yearmonth]= round($ligne[5]/($ligne[7]-@$msnzerolink[$yearmonth])); 591 } 592 } 593 else 594 { 595 $msnlink[$yearmonth]= round($ligne[5]/$ligne[7]); 596 } 597 598 if($msnzeropageexist==1) 599 { 600 if($ligne[8]== @$msnzeropage[$yearmonth]) 601 { 602 $msnpage[$yearmonth]=0; 603 } 604 else 605 { 606 $msnpage[$yearmonth]= round($ligne[6]/($ligne[8]-@$msnzeropage[$yearmonth])); 607 } 608 } 609 else 610 { 611 $msnpage[$yearmonth]= round($ligne[6]/$ligne[8]); 612 } 613 614 if($deliciouszerolinkexist==1) 615 { 616 if($ligne[10]== @$deliciouszerolink[$yearmonth]) 617 { 618 $deliciouslink[$yearmonth]=0; 619 } 620 else 621 { 622 $deliciouslink[$yearmonth]= round($ligne[9]/($ligne[10]-@$deliciouszerolink[$yearmonth])); 623 } 624 } 625 else 626 { 627 $deliciouslink[$yearmonth]= round($ligne[9]/$ligne[10]); 628 } 629 630 } 631 632 } 633 elseif($period >= 200 && $period<300) //case one year back and forward 634 { 635 $yahoozerolinkexist=0; 636 $yahoozeropageexist=0; 637 $msnzerolinkexist=0; 638 $msnzeropageexist=0; 639 $deliciouszerolinkexist=0; 640 641 642 if($typegraph=='link') 643 { 644 //request to count the number of day with link=0 during the period 645 646 //yahoo 647 $sql = "SELECT FROM_UNIXTIME(UNIX_TIMESTAMP(date)-($times*3600), '%Y%m'), COUNT(linkyahoo) FROM crawlt_seo_position 648 WHERE date >='".sql_quote($daterequestseo)."' 649 AND date <'".sql_quote($daterequest2)."' 650 AND id_site='".sql_quote($site)."' 651 AND linkyahoo = '0' 652 GROUP BY FROM_UNIXTIME(UNIX_TIMESTAMP(date)-($times*3600), '%Y%m')"; 653 654 $requete = mysql_query($sql, $connexion) or die("MySQL query error"); 655 $nbrresult=mysql_num_rows($requete); 656 if($nbrresult>=1) 657 { 658 while ($ligne = mysql_fetch_row($requete)) 659 { 660 $year=substr($ligne[0],0,4); 661 $month=substr($ligne[0],4,2); 662 $yearmonth=$month."/".$year; 663 $yahoozerolink[$yearmonth]= $ligne[1]; 664 } 665 $yahoozerolinkexist=1; 666 } 667 668 //msn 669 $sql = "SELECT FROM_UNIXTIME(UNIX_TIMESTAMP(date)-($times*3600), '%Y%m'), COUNT(linkmsn) FROM crawlt_seo_position 670 WHERE date >='".sql_quote($daterequestseo)."' 671 AND date <'".sql_quote($daterequest2)."' 672 AND id_site='".sql_quote($site)."' 673 AND linkmsn = '0' 674 GROUP BY FROM_UNIXTIME(UNIX_TIMESTAMP(date)-($times*3600), '%Y%m')"; 675 676 $requete = mysql_query($sql, $connexion) or die("MySQL query error"); 677 $nbrresult=mysql_num_rows($requete); 678 if($nbrresult>=1) 679 { 680 while ($ligne = mysql_fetch_row($requete)) 681 { 682 $year=substr($ligne[0],0,4); 683 $month=substr($ligne[0],4,2); 684 $yearmonth=$month."/".$year; 685 $msnzerolink[$yearmonth]= $ligne[1]; 686 } 687 $msnzerolinkexist=1; 688 } 689 } 690 elseif($typegraph=='page') 691 { 692 //request to count the number of day with page=0 during the period 693 694 //yahoo 695 $sql = "SELECT FROM_UNIXTIME(UNIX_TIMESTAMP(date)-($times*3600), '%Y%m'), COUNT(pageyahoo) FROM crawlt_seo_position 696 WHERE date >='".sql_quote($daterequestseo)."' 697 AND date <'".sql_quote($daterequest2)."' 698 AND id_site='".sql_quote($site)."' 699 AND pageyahoo = '0' 700 GROUP BY FROM_UNIXTIME(UNIX_TIMESTAMP(date)-($times*3600), '%Y%m')"; 701 702 $requete = mysql_query($sql, $connexion) or die("MySQL query error"); 703 $nbrresult=mysql_num_rows($requete); 704 if($nbrresult>=1) 705 { 706 while ($ligne = mysql_fetch_row($requete)) 707 { 708 $year=substr($ligne[0],0,4); 709 $month=substr($ligne[0],4,2); 710 $yearmonth=$month."/".$year; 711 $yahoozeropage[$yearmonth]= $ligne[1]; 712 } 713 $yahoozeropageexist=1; 714 } 715 716 //msn 717 $sql = "SELECT FROM_UNIXTIME(UNIX_TIMESTAMP(date)-($times*3600), '%Y%m'), COUNT(pagemsn) FROM crawlt_seo_position 718 WHERE date >='".sql_quote($daterequestseo)."' 719 AND date <'".sql_quote($daterequest2)."' 720 AND id_site='".sql_quote($site)."' 721 AND pagemsn = '0' 722 GROUP BY FROM_UNIXTIME(UNIX_TIMESTAMP(date)-($times*3600), '%Y%m')"; 723 724 $requete = mysql_query($sql, $connexion) or die("MySQL query error"); 725 $nbrresult=mysql_num_rows($requete); 726 if($nbrresult>=1) 727 { 728 while ($ligne = mysql_fetch_row($requete)) 729 { 730 $year=substr($ligne[0],0,4); 731 $month=substr($ligne[0],4,2); 732 $yearmonth=$month."/".$year; 733 $msnzeropage[$yearmonth]= $ligne[1]; 734 } 735 $msnzeropageexist=1; 736 } 737 738 } 739 elseif($typegraph=='bookmark') 740 { 741 //request to count the number of day with bookmark=0 during the period 742 743 //del.icio.us 744 $sql = "SELECT FROM_UNIXTIME(UNIX_TIMESTAMP(date)-($times*3600), '%Y%m'), COUNT(nbrdelicious) FROM crawlt_seo_position 745 WHERE date >='".sql_quote($daterequestseo)."' 746 AND date <'".sql_quote($daterequest2)."' 747 AND id_site='".sql_quote($site)."' 748 AND nbrdelicious = '0' 749 GROUP BY FROM_UNIXTIME(UNIX_TIMESTAMP(date)-($times*3600), '%Y%m')"; 750 751 $requete = mysql_query($sql, $connexion) or die("MySQL query error"); 752 $nbrresult=mysql_num_rows($requete); 753 if($nbrresult>=1) 754 { 755 while ($ligne = mysql_fetch_row($requete)) 756 { 757 $year=substr($ligne[0],0,4); 758 $month=substr($ligne[0],4,2); 759 $yearmonth=$month."/".$year; 760 $deliciouszerolink[$yearmonth]= $ligne[1]; 761 } 762 $deliciouszerolinkexist=1; 763 } 764 765 766 } 767 768 $sqlseograph = "SELECT FROM_UNIXTIME(UNIX_TIMESTAMP(date)-($times*3600), '%Y%m') , SUM(linkyahoo),SUM(pageyahoo),COUNT(linkyahoo), COUNT(pageyahoo), SUM(linkmsn),SUM(pagemsn), COUNT(linkmsn), COUNT(pagemsn), SUM(nbrdelicious),COUNT(nbrdelicious) FROM crawlt_seo_position 769 WHERE date >='".sql_quote($daterequestseo)."' 770 AND date <'".sql_quote($daterequest2)."' 771 AND id_site='".sql_quote($site)."' 772 GROUP BY FROM_UNIXTIME(UNIX_TIMESTAMP(date)-($times*3600), '%Y%m')"; 773 774 $requeteseograph = mysql_query($sqlseograph, $connexion) or die("MySQL query error"); 775 776 while ($ligne = mysql_fetch_row($requeteseograph)) 777 { 778 $year=substr($ligne[0],0,4); 779 $month=substr($ligne[0],4,2); 780 $yearmonth=$month."/".$year; 781 782 if($yahoozerolinkexist==1) 783 { 784 if($ligne[3]== @$yahoozerolink[$yearmonth]) 785 { 786 $yahoolink[$yearmonth]=0; 787 } 788 else 789 { 790 $yahoolink[$yearmonth]= round($ligne[1]/($ligne[3]-@$yahoozerolink[$yearmonth])); 791 } 792 } 793 else 794 { 795 $yahoolink[$yearmonth]= round($ligne[1]/$ligne[3]); 796 } 797 798 if($yahoozeropageexist==1) 799 { 800 if($ligne[4]== @$yahoozeropage[$yearmonth]) 801 { 802 $yahoopage[$yearmonth]=0; 803 } 804 else 805 { 806 $yahoopage[$yearmonth]= round($ligne[2]/($ligne[4]-@$yahoozeropage[$yearmonth])); 807 } 808 } 809 else 810 { 811 $yahoopage[$yearmonth]= round($ligne[2]/$ligne[4]); 812 } 813 814 815 if($msnzerolinkexist==1) 816 { 817 if($ligne[7]== @$msnzerolink[$yearmonth]) 818 { 819 $msnlink[$yearmonth]=0; 820 } 821 else 822 { 823 $msnlink[$yearmonth]= round($ligne[5]/($ligne[7]-@$msnzerolink[$yearmonth])); 824 } 825 } 826 else 827 { 828 $msnlink[$yearmonth]= round($ligne[5]/$ligne[7]); 829 } 830 831 if($msnzeropageexist==1) 832 { 833 if($ligne[8]== @$msnzeropage[$yearmonth]) 834 { 835 $msnpage[$yearmonth]=0; 836 } 837 else 838 { 839 $msnpage[$yearmonth]= round($ligne[6]/($ligne[8]-@$msnzeropage[$yearmonth])); 840 } 841 } 842 else 843 { 844 $msnpage[$yearmonth]= round($ligne[6]/$ligne[8]); 845 } 846 847 if($deliciouszerolinkexist==1) 848 { 849 if($ligne[10]== @$deliciouszerolink[$yearmonth]) 850 { 851 $deliciouslink[$yearmonth]=0; 852 } 853 else 854 { 855 $deliciouslink[$yearmonth]= round($ligne[9]/($ligne[10]-@$deliciouszerolink[$yearmonth])); 856 } 857 } 858 else 859 { 860 $deliciouslink[$yearmonth]= round($ligne[9]/$ligne[10]); 861 } 862 863 } 864 865 } 866 else 867 { 868 if($period>=10) 869 { 870 $sqlseograph = "SELECT FROM_UNIXTIME(UNIX_TIMESTAMP(date)-($times*3600), '%d-%m-%Y'), linkyahoo, pageyahoo, linkmsn, pagemsn,nbrdelicious FROM crawlt_seo_position 871 WHERE date >='".sql_quote($daterequestseo)."' 872 AND date <='".sql_quote($daterequest2)."' 873 AND id_site='".sql_quote($site)."'"; 874 } 875 else 876 { 877 $sqlseograph = "SELECT FROM_UNIXTIME(UNIX_TIMESTAMP(date)-($times*3600), '%d-%m-%Y'), linkyahoo, pageyahoo, linkmsn, pagemsn, nbrdelicious FROM crawlt_seo_position 878 WHERE date >='".sql_quote($daterequestseo)."' 879 AND id_site='".sql_quote($site)."'"; 880 } 881 882 $requeteseograph = mysql_query($sqlseograph, $connexion) or die("MySQL query error"); 883 884 while ($ligne = mysql_fetch_row($requeteseograph)) 885 { 886 $yahoolink[$ligne[0]]=$ligne[1]; 887 $yahoopage[$ligne[0]]=$ligne[2]; 888 $msnlink[$ligne[0]]=$ligne[3]; 889 $msnpage[$ligne[0]]=$ligne[4]; 890 $deliciouslink[$ligne[0]]=$ligne[5]; 891 } 892 } 893 894 } 895 896 897 898 //create table for graph 899 900 901 if($typegraph =='link') 902 { 903 foreach($axex as $data) 904 { 905 $yahoo[]=$yahoolink[$data]; 906 $msn[]=$msnlink[$data]; 907 $datatransfert1[$axexlabel[$data]]= $yahoolink[$data]."-".$msnlink[$data]; 908 } 909 //prepare datas to be transfert to graph file 910 $datatransferttograph=addslashes(urlencode(serialize($datatransfert1))); 911 } 912 elseif($typegraph =='entry') 913 { 914 foreach($axex as $data) 915 { 916 $google1[]=$googlevisit[$data]; 917 918 $msn1[]=$msnvisit[$data]; 919 920 $yahoo1[]=$yahoovisit[$data]; 921 922 $ask1[]=$askvisit[$data]; 923 924 $datatransfert2[$axexlabel[$data]]= $googlevisit[$data]."-". $msnvisit[$data]."-".$yahoovisit[$data]."-".$askvisit[$data]; 925 } 926 //prepare datas to be transfert to graph file 927 $datatransferttograph=addslashes(urlencode(serialize($datatransfert2))); 928 929 } 930 elseif($typegraph =='page') 931 { 932 foreach($axex as $data) 933 { 934 935 $yahoo2[]=$yahoopage[$data]; 936 $msn2[]=$msnpage[$data]; 937 $datatransfert3[$axexlabel[$data]]=$yahoopage[$data]."-".$msnpage[$data]; 938 } 939 //prepare datas to be transfert to graph file 940 $datatransferttograph=addslashes(urlencode(serialize($datatransfert3))); 941 942 } 943 elseif($typegraph =='bookmark') 944 { 945 foreach($axex as $data) 946 { 947 $delicious[]=$deliciouslink[$data]; 948 $datatransfert4[$axexlabel[$data]]=$deliciouslink[$data]; 949 } 950 //prepare datas to be transfert to graph file 951 $datatransferttograph=addslashes(urlencode(serialize($datatransfert4))); 952 953 } 954 //insert the values in the graph table 955 $graphname=$typegraph."-".$cachename; 956 957 //check if this graph exit already in the table 958 $sql = "SELECT name FROM crawlt_graph 959 WHERE name= '".sql_quote($graphname)."'"; 960 961 962 $requete = mysql_query($sql, $connexion) or die("MySQL query error"); 963 $nbrresult=mysql_num_rows($requete); 964 if($nbrresult >=1) 965 { 966 $sql2 ="UPDATE crawlt_graph SET graph_values='".sql_quote($datatransferttograph)."' 967 WHERE name= '".sql_quote($graphname)."'"; 968 } 969 else 970 { 971 $sql2 ="INSERT INTO crawlt_graph (name,graph_values) VALUES ( '".sql_quote($graphname)."','".sql_quote($datatransferttograph)."')"; 972 } 973 $requete2 = mysql_query($sql2, $connexion) or die("MySQL query error"); 974 975 //map graph 976 if($period==3 OR ($period >= 200 && $period<300)) 977 { 978 $widthzone=67; 979 $x2=132.3; 980 $y=31; 981 $y2=211; 982 } 983 elseif($period==2 OR ($period>=100 && $period<200)) 984 { 985 if($nbday==28) 986 { 987 $widthzone=28.7; 988 $x2=94; 989 $y=31; 990 $y2=211; 991 } 992 elseif($nbday==29) 993 { 994 $widthzone=27.7; 995 $x2=93; 996 $y=31; 997 $y2=211; 998 } 999 elseif($nbday==30) 1000 { 1001 $widthzone=26.8; 1002 $x2=92.1; 1003 $y=31; 1004 $y2=211; 1005 } 1006 else 1007 { 1008 $widthzone=26; 1009 $x2=91.3; 1010 $y=31; 1011 $y2=211; 1012 } 1013 } 1014 elseif($period==0 OR $period==4 OR $period>=1000) 1015 { 1016 $widthzone=100.75; 1017 $x2=166.05; 1018 $y=31; 1019 $y2=211; 1020 } 1021 elseif($period==1 OR ($period>=300 && $period<400)) 1022 { 1023 $widthzone=115.14; 1024 $x2=180.44; 1025 $y=31; 1026 $y2=211; 1027 } 1028 if($typegraph=='link') 1029 { 1030 echo"<MAP ID=\"seolink\" NAME=\"seolink\">\n"; 1031 $iday=0; 1032 $x=65.3; 1033 do { 1034 echo"<AREA SHAPE=\"RECT\" COORDS=\"".$x.",".$y.",".$x2.",".$y2."\" onmouseover=\"javascript:montre('smenu".($iday+9)."');\" onmouseout=\"javascript:montre();\""; 1035 $dateday=$axex[$iday]; 1036 $periodtogo = $totperiod[$dateday]; 1037 echo"href=\"index.php?navig=$navig&period=$periodtogo&site=$site&graphpos=$graphpos\">\n"; 1038 $x=$x+$widthzone; 1039 $x2=$x2+$widthzone; 1040 $iday++; 1041 } 1042 while($iday<$nbday); 1043 echo"</MAP>\n"; 1044 1045 $iday=0; 1046 do { 1047 echo"<div id=\"smenu".($iday+9)."\" style=\"display:none; font-size:13px; color:#003399; font-family:Verdana,Geneva, Arial, Helvetica, Sans-Serif; text-align:left; border:2px solid navy; position:absolute; top:8px; left:300px; background:#eee;\">\n"; 1048 echo" ".$language['nbr_tot_link'].": ".$axexlabel[$axex[$iday]]." \n"; 1049 echo" ".$language['msn'].": ".$msn[$iday]."\n"; 1050 echo" ".$language['yahoo'].": ".$yahoo[$iday]." \n"; 1051 echo"</div>\n"; 1052 $iday++; 1053 } 1054 while($iday<$nbday); 1055 } 1056 elseif($typegraph=='page') 1057 { 1058 echo"<MAP ID=\"seopage\" NAME=\"seopage\">\n"; 1059 $iday=0; 1060 $x=65.3; 1061 do { 1062 echo"<AREA SHAPE=\"RECT\" COORDS=\"".$x.",".$y.",".$x2.",".$y2."\" onmouseover=\"javascript:montre('smenu".($iday+70)."');\" onmouseout=\"javascript:montre();\""; 1063 $dateday=$axex[$iday]; 1064 $periodtogo = $totperiod[$dateday]; 1065 echo"href=\"index.php?navig=$navig&period=$periodtogo&site=$site&graphpos=$graphpos\">\n"; 1066 $x=$x+$widthzone; 1067 $x2=$x2+$widthzone; 1068 $iday++; 1069 } 1070 while($iday<$nbday); 1071 echo"</MAP>\n"; 1072 1073 $iday=0; 1074 do { 1075 echo"<div id=\"smenu".($iday+70)."\" style=\"display:none; font-size:13px; color:#003399; font-family:Verdana,Geneva, Arial, Helvetica, Sans-Serif; text-align:left; border:2px solid navy; position:absolute; top:8px; left:300px; background:#eee;\">\n"; 1076 echo" ".$language['nbr_tot_pages_index'].": ".$axexlabel[$axex[$iday]]." \n"; 1077 echo" ".$language['msn'].": ".$msn2[$iday]."\n"; 1078 echo" ".$language['yahoo'].": ".$yahoo2[$iday]." \n"; 1079 echo"</div>\n"; 1080 $iday++; 1081 } 1082 while($iday<$nbday); 1083 } 1084 elseif($typegraph=='entry') 1085 { 1086 echo"<MAP ID=\"seoentry\" NAME=\"seoentry\">\n"; 1087 $iday=0; 1088 $x=65.3; 1089 do { 1090 echo"<AREA SHAPE=\"RECT\" COORDS=\"".$x.",".$y.",".$x2.",".$y2."\" onmouseover=\"javascript:montre('smenu".($iday+131)."');\" onmouseout=\"javascript:montre();\""; 1091 $dateday=$axex[$iday]; 1092 $periodtogo = $totperiod[$dateday]; 1093 echo"href=\"index.php?navig=$navig&period=$periodtogo&site=$site&graphpos=$graphpos\">\n"; 1094 $x=$x+$widthzone; 1095 $x2=$x2+$widthzone; 1096 $iday++; 1097 } 1098 while($iday<$nbday); 1099 echo"</MAP>\n"; 1100 1101 $iday=0; 1102 do { 1103 echo"<div id=\"smenu".($iday+131)."\" style=\"display:none; font-size:13px; color:#003399; font-family:Verdana,Geneva, Arial, Helvetica, Sans-Serif; text-align:left; border:2px solid navy; position:absolute; top:8px; left:300px; background:#eee;\">\n"; 1104 echo" ".$language['nbr_tot_visit_seo'].": ".$axexlabel[$axex[$iday]]." \n"; 1105 echo" ".$language['ask'].": ".$ask1[$iday]."\n"; 1106 echo" ".$language['google'].": ".$google1[$iday]."\n"; 1107 echo" ".$language['msn'].": ".$msn1[$iday]."\n"; 1108 echo" ".$language['yahoo'].": ".$yahoo1[$iday]." \n"; 1109 echo"</div>\n"; 1110 $iday++; 1111 } 1112 while($iday<$nbday); 1113 } 1114 elseif($typegraph=='bookmark') 1115 { 1116 echo"<MAP ID=\"bookmark\" NAME=\"bookmark\">\n"; 1117 $iday=0; 1118 $x=65.3; 1119 do { 1120 echo"<AREA SHAPE=\"RECT\" COORDS=\"".$x.",".$y.",".$x2.",".$y2."\" onmouseover=\"javascript:montre('smenu".($iday+192)."');\" onmouseout=\"javascript:montre();\""; 1121 $dateday=$axex[$iday]; 1122 $periodtogo = $totperiod[$dateday]; 1123 echo"href=\"index.php?navig=$navig&period=$periodtogo&site=$site&graphpos=$graphpos\">\n"; 1124 $x=$x+$widthzone; 1125 $x2=$x2+$widthzone; 1126 $iday++; 1127 } 1128 while($iday<$nbday); 1129 echo"</MAP>\n"; 1130 1131 $iday=0; 1132 do { 1133 echo"<div id=\"smenu".($iday+192)."\" style=\"display:none; font-size:13px; color:#003399; font-family:Verdana,Geneva, Arial, Helvetica, Sans-Serif; text-align:left; border:2px solid navy; position:absolute; top:8px; left:300px; background:#eee;\">\n"; 1134 echo" ".$language['nbr_tot_bookmark'].": ".$axexlabel[$axex[$iday]]." \n"; 1135 echo" ".$language['delicious'].": ".$delicious[$iday]." \n"; 1136 echo"</div>\n"; 1137 $iday++; 1138 } 1139 while($iday<$nbday); 1140 } 1141 1142 1143 1144 ?>
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 |