| [ 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: admincrawlersuppress.php 14 //---------------------------------------------------------------------- 15 16 if (!defined('IN_CRAWLT_ADMIN')) 17 { 18 echo"<h1>Hacking attempt !!!!</h1>"; 19 exit(); 20 } 21 22 if(isset($_POST['suppresscrawler'])) 23 { 24 $suppresscrawler = (int)$_POST['suppresscrawler']; 25 } 26 else 27 { 28 $suppresscrawler = 0; 29 } 30 31 if(isset($_POST['suppresscrawlerok'])) 32 { 33 $suppresscrawlerok = (int)$_POST['suppresscrawlerok']; 34 } 35 else 36 { 37 $suppresscrawlerok = 0; 38 } 39 40 if($suppresscrawler==1) 41 { 42 43 if(isset($_POST['crawlertosuppress'])) 44 { 45 $crawlertosuppress = $_POST['crawlertosuppress']; 46 } 47 else 48 { 49 header("Location:../index.php"); 50 } 51 52 if(isset($_POST['idcrawlertosuppress'])) 53 { 54 $idcrawlertosuppress = (int)$_POST['idcrawlertosuppress']; 55 } 56 else 57 { 58 header("Location:../index.php"); 59 } 60 61 62 63 if($suppresscrawlerok==1) 64 { 65 //crawler suppression 66 67 //database connection 68 $connexion = mysql_connect($crawlthost,$crawltuser,$crawltpassword) or die("MySQL connection to database problem"); 69 $selection = mysql_select_db($crawltdb) or die("MySQL database selection problem"); 70 71 //database query to suppress the crawler 72 73 $sqldelete = "DELETE FROM crawlt_crawler WHERE id_crawler= '".sql_quote($idcrawlertosuppress)."'"; 74 $requetedelete = mysql_query($sqldelete, $connexion) or die("MySQL query error"); 75 76 77 $sqldelete2="DELETE FROM crawlt_visits WHERE crawlt_crawler_id_crawler= '".sql_quote($idcrawlertosuppress)."'"; 78 $requetedelete2 = mysql_query($sqldelete2, $connexion) or die("MySQL query error"); 79 80 //database query to optimize the table 81 $sqloptimize = "OPTIMIZE TABLE crawlt_visits"; 82 $requeteoptimize = mysql_query($sqloptimize, $connexion) or die("MySQL query error"); 83 84 //emptied the cache table 85 $sqlcache = "TRUNCATE TABLE crawlt_cache"; 86 $requetecache = mysql_query($sqlcache, $connexion) or die("MySQL query error"); 87 88 if($requetedelete && $requetedelete2) 89 { 90 echo"<br><br><h1>".$language['crawler_suppress_ok']."</h1>\n"; 91 92 echo"<div class=\"form\">\n"; 93 echo"<form action=\"index.php\" method=\"POST\" >\n"; 94 echo "<input type=\"hidden\" name ='navig' value='6'>\n"; 95 echo"<input name='ok' type='submit' value='OK' size='20'>\n"; 96 echo"</form>\n"; 97 echo"</div>\n"; 98 } 99 else 100 { 101 echo"<br><br><h1>".$language['crawler_suppress_no_ok']."</h1>\n"; 102 103 echo"<div class=\"form\">\n"; 104 echo"<form action=\"index.php\" method=\"POST\" >\n"; 105 echo "<input type=\"hidden\" name ='navig' value='6'>\n"; 106 echo"<input name='ok' type='submit' value='OK' size='20'>\n"; 107 echo"</form>\n"; 108 echo"</div>\n"; 109 } 110 111 } 112 else 113 { 114 //validation of suppression 115 116 //display 117 118 $crawlertosuppress = stripslashes($crawlertosuppress); 119 $crawlertosuppressdisplay=htmlentities($crawlertosuppress); 120 121 echo"<br><br><h1>".$language['crawler_suppress_validation']."</h1>\n"; 122 echo"<h1>".$language['crawler_name'].": $crawlertosuppressdisplay</h1>\n"; 123 124 echo"<div class=\"form\">\n"; 125 echo"<form action=\"index.php\" method=\"POST\" >\n"; 126 echo "<input type=\"hidden\" name ='navig' value='6'>\n"; 127 echo "<input type=\"hidden\" name ='validform' value=\"10\">"; 128 echo "<input type=\"hidden\" name ='suppresscrawler' value=\"1\">\n"; 129 echo "<input type=\"hidden\" name ='suppresscrawlerok' value=\"1\">\n"; 130 echo "<input type=\"hidden\" name ='crawlertosuppress' value=\"$crawlertosuppress\">\n"; 131 echo "<input type=\"hidden\" name ='idcrawlertosuppress' value=\"$idcrawlertosuppress\">\n"; 132 echo"<table class=\"centrer\">\n"; 133 echo"<tr>\n"; 134 echo"<td colspan=\"2\">\n"; 135 echo"<input name='ok' type='submit' value=' ".$language['yes']." ' size='20'>\n"; 136 echo"</td>\n"; 137 echo"</tr>\n"; 138 echo"</table>\n"; 139 echo"</form>\n"; 140 echo"</div>"; 141 142 echo"<div class=\"form\">\n"; 143 echo"<form action=\"index.php\" method=\"POST\" >\n"; 144 echo "<input type=\"hidden\" name ='navig' value='6'>\n"; 145 echo "<input type=\"hidden\" name ='validform' value=\"10\">"; 146 echo "<input type=\"hidden\" name ='suppresscrawler' value=\"0\">\n"; 147 echo "<input type=\"hidden\" name ='suppresscrawlerok' value=\"0\">\n"; 148 echo"<table class=\"centrer\">\n"; 149 echo"<tr>\n"; 150 echo"<td colspan=\"2\">\n"; 151 echo"<input name='ok' type='submit' value=' ".$language['no']." ' size='20'>\n"; 152 echo"</td>\n"; 153 echo"</tr>\n"; 154 echo"</table>\n"; 155 echo"</form>\n"; 156 echo"</div>"; 157 158 } 159 160 } 161 else 162 { 163 164 165 //database connection 166 167 if(isset($crawlthost)) 168 { 169 $connexion = mysql_connect($crawlthost,$crawltuser,$crawltpassword) or die("MySQL connection to database problem"); 170 $selection = mysql_select_db($crawltdb) or die("MySQL database selection problem"); 171 172 } 173 else 174 { 175 $connexion = mysql_connect($host,$user,$password) or die("MySQL connection to database problem"); 176 $selection = mysql_select_db($db) or die("MySQL database selection problem"); 177 } 178 179 //database query to get crawler list 180 181 $sqldeletecrawler = "SELECT * FROM crawlt_crawler"; 182 183 $requetedeletecrawler = mysql_query($sqldeletecrawler, $connexion) or die("MySQL query error"); 184 185 $nbrresult=mysql_num_rows($requetedeletecrawler); 186 if($nbrresult>=1) 187 { 188 189 while ($ligne = mysql_fetch_object($requetedeletecrawler)) 190 { 191 $idcrawler=$ligne->id_crawler; 192 $crawlername=$ligne->crawler_name; 193 $crawlerua=$ligne->crawler_user_agent; 194 $crawlerip=$ligne->crawler_ip; 195 $namecrawler[$idcrawler]=$crawlername; 196 if($crawlerua!='') 197 { 198 $uacrawler[$idcrawler]=$crawlerua; 199 } 200 else 201 { 202 $uacrawler[$idcrawler]=$crawlerip; 203 } 204 } 205 206 asort($namecrawler); 207 $current=current($namecrawler); 208 do { 209 $listidcrawler[]=key($namecrawler); 210 } 211 while($current=next($namecrawler)); 212 213 214 //display 215 216 echo"<br><br><h1>".$language['crawler_suppress']."</h1>\n"; 217 218 echo"<div class='tableau' align='center' width='550px'>\n"; 219 echo"<table cellpadding='0px' cellspacing='0' width='550px'>\n"; 220 echo"<tr><th class='tableau2' colspan='3'>\n"; 221 echo"".$language['crawler_list']."\n"; 222 echo"</th></tr>\n"; 223 224 foreach ($listidcrawler as $crawler1) 225 { 226 227 echo"<tr><td class='tableau32' width='15%'>\n"; 228 echo"".$namecrawler[$crawler1]."\n"; 229 echo"</td><td class='tableau35' width='70%'>\n"; 230 $ua="$uacrawler[$crawler1]"; 231 $long = strlen ($ua); 232 if ( $long>80) 233 { 234 $ua = substr ("$uacrawler[$crawler1]",0,80); 235 $ua=$ua."..."; 236 } 237 238 $uadisplay=htmlentities($ua); 239 echo"$uadisplay\n"; 240 echo"</td><td class='tableau45' width='15%'>\n"; 241 echo"<form action=\"index.php\" method=\"POST\" >\n"; 242 echo "<input type=\"hidden\" name ='period' value=\"$period\">\n"; 243 echo "<input type=\"hidden\" name ='navig' value=\"$navig\">\n"; 244 echo "<input type=\"hidden\" name ='validform' value=\"10\">\n"; 245 echo "<input type=\"hidden\" name ='suppresscrawler' value=\"1\">\n"; 246 echo "<input type=\"hidden\" name ='crawlertosuppress' value=\"".$namecrawler[$crawler1]."\">\n"; 247 echo "<input type=\"hidden\" name ='idcrawlertosuppress' value=\"$crawler1\">\n"; 248 echo"<input type='submit' class='button45' value='".$language['suppress_crawler']."'>\n"; 249 echo"</form>\n"; 250 echo"</td></tr>\n"; 251 } 252 echo"</table></div>\n"; 253 echo"<br>\n"; 254 } 255 else 256 { 257 //display 258 259 echo"<br><br><h1>".$language['crawler_suppress']."</h1>\n"; 260 261 echo"<div class='tableau' align='center' width='550px'>\n"; 262 echo"<table cellpadding='0px' cellspacing='0' width='550px'>\n"; 263 echo"<tr><th class='tableau2' colspan='3'>\n"; 264 echo"".$language['crawler_list']."\n"; 265 echo"</th></tr>\n"; 266 echo"</table></div>\n"; 267 echo"<br>\n"; 268 } 269 270 271 } 272 ?>
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 |