| [ 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: adminmail.php 14 //---------------------------------------------------------------------- 15 16 if (!defined('IN_CRAWLT_ADMIN')) 17 { 18 echo"<h1>Hacking attempt !!!!</h1>"; 19 exit(); 20 } 21 //initialize array 22 $listaddresstosuppress=array(); 23 $listaddress=array(); 24 $listaddresstokeep=array(); 25 26 echo"<h1>".$language['mail']."</h1>\n"; 27 28 if($crawltmail==1) 29 { 30 if($validsite==1) 31 { 32 //update the crawlt_config_table 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 $sqlupdatemail ="UPDATE crawlt_config SET mail='0'"; 39 40 $requeteupdatemail = mysql_query($sqlupdatemail, $connexion) or die("MySQL query error"); 41 42 echo"<br><br><p>".$language['update']."</p><br><br>"; 43 44 //continue 45 46 47 echo"<form action=\"index.php\" method=\"POST\" >\n"; 48 echo "<input type=\"hidden\" name ='navig' value='6'>\n"; 49 echo"<table class=\"centrer\">\n"; 50 echo"<tr>\n"; 51 echo"<td colspan=\"2\">\n"; 52 echo"<input name='ok' type='submit' value='OK ' size='20'>\n"; 53 echo"</td>\n"; 54 echo"</tr>\n"; 55 echo"</table>\n"; 56 echo"</form><br>\n"; 57 } 58 elseif($validsite ==2) //add the first email address 59 { 60 61 62 echo"<br><br><p>".$language['set_up_mail5']."</p>\n"; 63 echo"</div>\n"; 64 65 66 echo"<div class=\"form\">\n"; 67 echo"<form action=\"index.php\" method=\"POST\" >\n"; 68 echo "<input type=\"hidden\" name ='navig' value='6'>\n"; 69 echo "<input type=\"hidden\" name ='validform' value=\"20\">"; 70 echo "<input type=\"hidden\" name ='validsite' value=\"3\">"; 71 echo"<table class=\"centrer\">\n"; 72 echo"<tr>\n"; 73 echo"<td>".$language['email-address']."</td>\n"; 74 echo"<td><input name='sitename' value='$sitename' type='text' maxlength='45' size='50'/></td>\n"; 75 echo"</tr>\n"; 76 echo"<tr>\n"; 77 echo"<td colspan=\"2\">\n"; 78 echo"<br>\n"; 79 echo"<input name='ok' type='submit' value=' OK ' size='20'>\n"; 80 echo"</td>\n"; 81 echo"</tr>\n"; 82 echo"</table>\n"; 83 echo"</form><br>\n"; 84 } 85 elseif($validsite ==3) //add a new email address 86 { 87 //valid address 88 89 $sitename=strtolower($sitename); 90 if(check_email($sitename)) 91 { 92 $validaddress=1; 93 } 94 else 95 { 96 $validaddress=0; 97 } 98 if($validaddress==0) 99 { 100 echo"<br><br><p>".$language['address_no_ok']."</p>"; 101 102 103 $validsite=0; 104 echo"<div class=\"form\">\n"; 105 echo"<form action=\"index.php\" method=\"POST\" >\n"; 106 echo "<input type=\"hidden\" name ='validform' value='20'>\n"; 107 echo "<input type=\"hidden\" name ='navig' value='6'>\n"; 108 echo "<input type=\"hidden\" name ='validsite' value=\"2\">"; 109 echo "<input type=\"hidden\" name ='sitename' value='$sitename'>\n"; 110 echo"<input name='ok' type='submit' value=' ".$language['back_to_form']." ' size='20'>\n"; 111 echo"</form>\n"; 112 echo"</div><br>\n"; 113 } 114 else 115 { 116 //database connection 117 $connexion = mysql_connect($crawlthost,$crawltuser,$crawltpassword) or die("MySQL connection to database problem"); 118 $selection = mysql_select_db($crawltdb) or die("MySQL database selection problem"); 119 120 $sql ="SELECT addressmail FROM crawlt_config"; 121 $requete = mysql_query($sql, $connexion) or die("MySQL query error"); 122 123 $ligne = mysql_fetch_array($requete,MYSQL_ASSOC); 124 $addressmail = $ligne['addressmail']; 125 126 $sitename = $addressmail.",".$sitename; 127 128 //update the crawlt_config_table 129 130 //database connection 131 $connexion = mysql_connect($crawlthost,$crawltuser,$crawltpassword) or die("MySQL connection to database problem"); 132 $selection = mysql_select_db($crawltdb) or die("MySQL database selection problem"); 133 134 $sqlupdatemail ="UPDATE crawlt_config SET addressmail='".sql_quote($sitename)."'"; 135 136 $requeteupdatemail = mysql_query($sqlupdatemail, $connexion) or die("MySQL query error"); 137 138 echo"<br><br><p>".$language['update']."</p><br><br>"; 139 140 //continue 141 142 echo"<form action=\"index.php\" method=\"POST\" >\n"; 143 echo "<input type=\"hidden\" name ='navig' value='6'>\n"; 144 echo"<table class=\"centrer\">\n"; 145 echo"<tr>\n"; 146 echo"<td colspan=\"2\">\n"; 147 echo"<input name='ok' type='submit' value='OK ' size='20'>\n"; 148 echo"</td>\n"; 149 echo"</tr>\n"; 150 echo"</table>\n"; 151 echo"</form><br>\n"; 152 153 } 154 155 } 156 elseif($validsite ==4) //choice of email address to suppress 157 { 158 //database connection 159 $connexion = mysql_connect($crawlthost,$crawltuser,$crawltpassword) or die("MySQL connection to database problem"); 160 $selection = mysql_select_db($crawltdb) or die("MySQL database selection problem"); 161 162 $sql ="SELECT addressmail FROM crawlt_config"; 163 $requete = mysql_query($sql, $connexion) or die("MySQL query error"); 164 165 $ligne = mysql_fetch_array($requete,MYSQL_ASSOC); 166 $addressmail = $ligne['addressmail']; 167 168 $email= explode(',',$addressmail); 169 echo"<hr><p><b>".$language['set_up_mail6']."</b></p>\n"; 170 echo"<div align='center'>"; 171 echo"<table width='100%'><tr><td align='right'width='40%'>"; 172 echo"</td> <td align='left'>"; 173 echo"<form action=\"index.php\" method=\"POST\" >\n"; 174 echo "<input type=\"hidden\" name ='navig' value='6'>\n"; 175 echo "<input type=\"hidden\" name ='validform' value=\"20\">"; 176 echo "<input type=\"hidden\" name ='validsite' value=\"5\">"; 177 $i=1; 178 foreach($email as $adress) 179 { 180 echo "<input type=\"checkbox\" name ='adress".$i."' value=\"$adress\"> ".$adress."<br>"; 181 $i++; 182 } 183 echo "<input type=\"hidden\" name ='numberaddress' value=\"$i\">"; 184 echo"</td></tr></table><br>"; 185 echo"<table class=\"centrer\">\n"; 186 echo"<tr>\n"; 187 echo"<td>\n"; 188 echo"<input name='ok' type='submit' value='".$language['set_up_mail7']."'>\n"; 189 echo"</td>\n"; 190 echo"</tr>\n"; 191 echo"</table>\n"; 192 echo"</form><br>\n"; 193 echo"</div>"; 194 } 195 elseif($validsite ==5) //suppress email address 196 { 197 $numberaddress = $_POST['numberaddress']; 198 for($i=1; $i<$numberaddress; $i++) 199 { 200 $address='adress'.$i; 201 if(isset($_POST["$address"])) 202 { 203 $listaddresstosuppress[]=$_POST["$address"]; 204 } 205 } 206 207 if(count($listaddresstosuppress)== ($numberaddress - 1) ) 208 { 209 //case all the address are suppress 210 //database connection 211 $connexion = mysql_connect($crawlthost,$crawltuser,$crawltpassword) or die("MySQL connection to database problem"); 212 $selection = mysql_select_db($crawltdb) or die("MySQL database selection problem"); 213 214 $sqlupdatemail ="UPDATE crawlt_config SET mail='0', addressmail=''"; 215 216 $requeteupdatemail = mysql_query($sqlupdatemail, $connexion) or die("MySQL query error"); 217 218 echo"<br><br><p>".$language['update']."</p><br><br>"; 219 220 //continue 221 222 223 echo"<form action=\"index.php\" method=\"POST\" >\n"; 224 echo "<input type=\"hidden\" name ='navig' value='6'>\n"; 225 echo"<table class=\"centrer\">\n"; 226 echo"<tr>\n"; 227 echo"<td colspan=\"2\">\n"; 228 echo"<input name='ok' type='submit' value='OK ' size='20'>\n"; 229 echo"</td>\n"; 230 echo"</tr>\n"; 231 echo"</table>\n"; 232 echo"</form><br>\n"; 233 } 234 else 235 { 236 //database connection 237 $connexion = mysql_connect($crawlthost,$crawltuser,$crawltpassword) or die("MySQL connection to database problem"); 238 $selection = mysql_select_db($crawltdb) or die("MySQL database selection problem"); 239 240 $sql ="SELECT addressmail FROM crawlt_config"; 241 $requete = mysql_query($sql, $connexion) or die("MySQL query error"); 242 243 $ligne = mysql_fetch_array($requete,MYSQL_ASSOC); 244 $addressmail = $ligne['addressmail']; 245 246 $email= explode(',',$addressmail); 247 foreach($email as $adress) 248 { 249 $listaddress[]=$adress; 250 } 251 252 $listaddresstokeep = array_diff($listaddress,$listaddresstosuppress); 253 254 $sitename=''; 255 foreach($listaddresstokeep as $adress) 256 { 257 $sitename =$adress.','.$sitename; 258 } 259 $sitename = rtrim($sitename,","); 260 //database connection 261 $connexion = mysql_connect($crawlthost,$crawltuser,$crawltpassword) or die("MySQL connection to database problem"); 262 $selection = mysql_select_db($crawltdb) or die("MySQL database selection problem"); 263 264 $sqlupdatemail ="UPDATE crawlt_config SET addressmail='".sql_quote($sitename)."'"; 265 266 $requeteupdatemail = mysql_query($sqlupdatemail, $connexion) or die("MySQL query error"); 267 268 echo"<br><br><p>".$language['update']."</p><br><br>"; 269 270 //continue 271 272 echo"<form action=\"index.php\" method=\"POST\" >\n"; 273 echo "<input type=\"hidden\" name ='navig' value='6'>\n"; 274 echo"<table class=\"centrer\">\n"; 275 echo"<tr>\n"; 276 echo"<td colspan=\"2\">\n"; 277 echo"<input name='ok' type='submit' value='OK ' size='20'>\n"; 278 echo"</td>\n"; 279 echo"</tr>\n"; 280 echo"</table>\n"; 281 echo"</form><br>\n"; 282 } 283 284 } 285 else //first page when email is already set 286 { 287 echo"<br><hr><p><b>".$language['set_up_mail2']."</b></p>\n"; 288 289 echo"<br><table width='100%'><tr><td align='right'width='50%'>"; 290 291 echo"<form action=\"index.php\" method=\"POST\" >\n"; 292 echo "<input type=\"hidden\" name ='navig' value='6'>\n"; 293 echo "<input type=\"hidden\" name ='validform' value=\"20\">"; 294 echo "<input type=\"hidden\" name ='validsite' value=\"1\">"; 295 echo"<table class=\"centrer\">\n"; 296 echo"<tr>\n"; 297 echo"<td>\n"; 298 echo"<input name='ok' type='submit' value=".$language['yes']." size='20'>\n"; 299 echo"</td>\n"; 300 echo"</tr>\n"; 301 echo"</table>\n"; 302 echo"</form><br>\n"; 303 304 echo"</td><td align='left'>"; 305 306 echo"<form action=\"index.php\" method=\"POST\" >\n"; 307 echo "<input type=\"hidden\" name ='navig' value='6'>\n"; 308 echo"<table class=\"centrer\">\n"; 309 echo"<tr>\n"; 310 echo"<td>\n"; 311 echo"<input name='ok' type='submit' value=".$language['no']." size='20'>\n"; 312 echo"</td>\n"; 313 echo"</tr>\n"; 314 echo"</table>\n"; 315 echo"</form><br>\n"; 316 317 echo"</td></tr></table>"; 318 319 echo"<hr><p><b>".$language['set_up_mail3']."</b></p>\n"; 320 echo"<div align='center'>"; 321 //database connection 322 $connexion = mysql_connect($crawlthost,$crawltuser,$crawltpassword) or die("MySQL connection to database problem"); 323 $selection = mysql_select_db($crawltdb) or die("MySQL database selection problem"); 324 325 $sql ="SELECT addressmail FROM crawlt_config"; 326 $requete = mysql_query($sql, $connexion) or die("MySQL query error"); 327 328 $ligne = mysql_fetch_array($requete,MYSQL_ASSOC); 329 $addressmail = $ligne['addressmail']; 330 331 $email= explode(',',$addressmail); 332 foreach($email as $adress) 333 { 334 echo $adress."<br>"; 335 } 336 echo"<br><table width='100%'><tr><td align='right'width='50%'>"; 337 338 echo"<form action=\"index.php\" method=\"POST\" >\n"; 339 echo "<input type=\"hidden\" name ='navig' value='6'>\n"; 340 echo "<input type=\"hidden\" name ='validform' value=\"20\">"; 341 echo "<input type=\"hidden\" name ='validsite' value=\"2\">"; 342 echo"<table class=\"centrer\">\n"; 343 echo"<tr>\n"; 344 echo"<td>\n"; 345 echo"<input name='ok' type='submit' value='".$language['set_up_mail4']."'>\n"; 346 echo"</td>\n"; 347 echo"</tr>\n"; 348 echo"</table>\n"; 349 echo"</form><br>\n"; 350 351 echo"</td><td align='left'>"; 352 353 354 echo"<form action=\"index.php\" method=\"POST\" >\n"; 355 echo "<input type=\"hidden\" name ='navig' value='6'>\n"; 356 echo "<input type=\"hidden\" name ='validform' value=\"20\">"; 357 echo "<input type=\"hidden\" name ='validsite' value=\"4\">"; 358 echo"<table class=\"centrer\">\n"; 359 echo"<tr>\n"; 360 echo"<td>\n"; 361 echo"<input name='ok' type='submit' value='".$language['set_up_mail6']."' >\n"; 362 echo"</td>\n"; 363 echo"</tr>\n"; 364 echo"</table>\n"; 365 echo"</form><br>\n"; 366 367 echo"</td></tr></table>"; 368 echo"</div>"; 369 } 370 371 } 372 else 373 { 374 375 //valid address 376 377 $adressmail=strtolower($sitename); 378 if(check_email($adressmail)) 379 { 380 $validaddress=1; 381 } 382 else 383 { 384 $validaddress=0; 385 } 386 387 388 if($validsite==1 && $validaddress==0) 389 { 390 echo"<br><br><p>".$language['address_no_ok']."</p>"; 391 392 393 $validsite=0; 394 echo"<div class=\"form\">\n"; 395 echo"<form action=\"index.php\" method=\"POST\" >\n"; 396 echo "<input type=\"hidden\" name ='validform' value='20'>\n"; 397 echo "<input type=\"hidden\" name ='navig' value='6'>\n"; 398 echo "<input type=\"hidden\" name ='sitename' value='$sitename'>\n"; 399 echo"<input name='ok' type='submit' value=' ".$language['back_to_form']." ' size='20'>\n"; 400 echo"</form>\n"; 401 echo"</div><br>\n"; 402 } 403 else 404 { 405 if($validsite !=1) 406 { 407 //form to add site in the database 408 409 echo"<br><br><p>".$language['set_up_mail']."</p>\n"; 410 echo"</div>\n"; 411 412 413 echo"<div class=\"form\">\n"; 414 echo"<form action=\"index.php\" method=\"POST\" >\n"; 415 echo "<input type=\"hidden\" name ='navig' value='6'>\n"; 416 echo "<input type=\"hidden\" name ='validform' value=\"20\">"; 417 echo "<input type=\"hidden\" name ='validsite' value=\"1\">"; 418 echo"<table class=\"centrer\">\n"; 419 echo"<tr>\n"; 420 echo"<td>".$language['email-address']."</td>\n"; 421 echo"<td><input name='sitename' value='$sitename' type='text' maxlength='45' size='50'/></td>\n"; 422 echo"</tr>\n"; 423 echo"<tr>\n"; 424 echo"<td colspan=\"2\">\n"; 425 echo"<br>\n"; 426 echo"<input name='ok' type='submit' value=' OK ' size='20'>\n"; 427 echo"</td>\n"; 428 echo"</tr>\n"; 429 echo"</table>\n"; 430 echo"</form><br>\n"; 431 } 432 else 433 { 434 //update the crawlt_config_table 435 436 //database connection 437 $connexion = mysql_connect($crawlthost,$crawltuser,$crawltpassword) or die("MySQL connection to database problem"); 438 $selection = mysql_select_db($crawltdb) or die("MySQL database selection problem"); 439 440 $sqlupdatemail ="UPDATE crawlt_config SET mail='1', addressmail='".sql_quote($sitename)."'"; 441 442 $requeteupdatemail = mysql_query($sqlupdatemail, $connexion) or die("MySQL query error"); 443 444 echo"<br><br><p>".$language['update']."</p><br><br>"; 445 446 //continue 447 448 echo"<form action=\"index.php\" method=\"POST\" >\n"; 449 echo "<input type=\"hidden\" name ='navig' value='6'>\n"; 450 echo"<table class=\"centrer\">\n"; 451 echo"<tr>\n"; 452 echo"<td colspan=\"2\">\n"; 453 echo"<input name='ok' type='submit' value='OK ' size='20'>\n"; 454 echo"</td>\n"; 455 echo"</tr>\n"; 456 echo"</table>\n"; 457 echo"</form><br>\n"; 458 459 460 } 461 462 } 463 } 464 465 ?>
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 |