| [ 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: adminmodifsite.php 14 //---------------------------------------------------------------------- 15 if (!defined('IN_CRAWLT_ADMIN')) 16 { 17 echo"<h1>Hacking attempt !!!!</h1>"; 18 exit(); 19 } 20 21 $sitenamedisplay=htmlentities($sitename); 22 $siteurldisplay=htmlentities($siteurl); 23 24 if($validsite==1) 25 { 26 //form to enter the new datas 27 echo"<br><br><h1>".$language['modif_site']."</h1>\n"; 28 echo"</div>\n"; 29 30 echo"<div class=\"form\">\n"; 31 echo"<form action=\"index.php\" method=\"POST\" >\n"; 32 echo "<input type=\"hidden\" name ='navig' value='6'>\n"; 33 echo "<input type=\"hidden\" name ='validform' value=\"23\">\n"; 34 echo "<input type=\"hidden\" name ='validsite' value=\"2\">\n"; 35 echo "<input type=\"hidden\" name ='site' value='$site'>\n"; 36 echo"<table class=\"centrer\">\n"; 37 echo"<tr>\n"; 38 echo"<td>".$language['site_name']."</td>\n"; 39 echo"<td><input name='sitename' value='$sitenamedisplay' type='text' maxlength='45' size='50'/></td>\n"; 40 echo"</tr>\n"; 41 echo"<tr>\n"; 42 echo"<td>".$language['site_url']."</td>\n"; 43 echo"<td><input name='siteurl' value='$siteurldisplay' type='text' maxlength='250' size='50'/></td>\n"; 44 echo"</tr>\n"; 45 echo"<tr>\n"; 46 echo"<td colspan=\"2\">\n"; 47 echo"<br>\n"; 48 echo"<input name='ok' type='submit' value=' OK ' size='20'>\n"; 49 echo"</td>\n"; 50 echo"</tr>\n"; 51 echo"</table>\n"; 52 echo"</form>\n"; 53 } 54 elseif($validsite==2) 55 { 56 //check if datas are empti 57 if($sitename=='' OR $siteurl=='') 58 { 59 //go back to form 60 echo"<br><br><p>".$language['site_no_ok']."</p>"; 61 echo"<div class=\"form\">\n"; 62 echo"<form action=\"index.php\" method=\"POST\" >\n"; 63 echo "<input type=\"hidden\" name ='validform' value='23'>\n"; 64 echo "<input type=\"hidden\" name ='validsite' value=\"1\">\n"; 65 echo "<input type=\"hidden\" name ='navig' value='6'>\n"; 66 echo "<input type=\"hidden\" name ='sitename' value='$sitenamedisplay'>\n"; 67 echo "<input type=\"hidden\" name ='siteurl' value='$siteurldisplay'>\n"; 68 echo"<input name='ok' type='submit' value=' ".$language['back_to_form']." ' size='20'>\n"; 69 echo"</form>\n"; 70 echo"</div>\n"; 71 } 72 else 73 { 74 //update database 75 76 //database connection 77 $connexion = mysql_connect($crawlthost,$crawltuser,$crawltpassword) or die("MySQL connection to database problem"); 78 $selection = mysql_select_db($crawltdb) or die("MySQL database selection problem"); 79 80 81 $sql ="UPDATE crawlt_site SET name='".sql_quote($sitename)."',url='".sql_quote($siteurl)."' 82 WHERE id_site= '".sql_quote($site)."'"; 83 84 $requete = mysql_query($sql, $connexion) or die("MySQL query error"); 85 86 echo"<br><br><h1>".$language['modif_site']."</h1>\n"; 87 echo"<br><br><p>".$language['update']."</p><br><br>"; 88 89 //continue 90 91 echo"<form action=\"index.php\" method=\"POST\" >\n"; 92 echo "<input type=\"hidden\" name ='navig' value='6'>\n"; 93 echo"<table class=\"centrer\">\n"; 94 echo"<tr>\n"; 95 echo"<td colspan=\"2\">\n"; 96 echo"<input name='ok' type='submit' value='OK ' size='20'>\n"; 97 echo"</td>\n"; 98 echo"</tr>\n"; 99 echo"</table>\n"; 100 echo"</form><br>\n"; 101 } 102 } 103 else 104 { 105 //first arrival on the page 106 107 //database connection 108 $connexion = mysql_connect($crawlthost,$crawltuser,$crawltpassword) or die("MySQL connection to database problem"); 109 $selection = mysql_select_db($crawltdb) or die("MySQL database selection problem"); 110 111 //request to get the sites datas 112 $sql = "SELECT id_site, name, url FROM crawlt_site"; 113 $requete = mysql_query($sql, $connexion) or die("MySQL query error"); 114 115 $nbrresult=mysql_num_rows($requete); 116 117 if($nbrresult>=1) 118 { 119 while ($ligne = mysql_fetch_row($requete)) 120 { 121 $listsite[]=$ligne[0]; 122 $namesite[$ligne[0]]=$ligne[1]; 123 $urlsite[$ligne[0]]=$ligne[2]; 124 } 125 } 126 echo"<br><br><h1>".$language['modif_site']."</h1>\n"; 127 echo"</div>\n"; 128 129 echo"<div align=\"center\"><table cellpadding='0px' cellspacing='0'>\n"; 130 echo"<tr><th class='tableau1'>\n"; 131 echo" ".$language['site_name2']." \n"; 132 echo"</th>\n"; 133 echo"<th class='tableau1'>\n"; 134 echo" ".$language['site_url2']." \n"; 135 echo"</th>\n"; 136 echo"<th class='tableau2'>\n"; 137 echo" \n"; 138 echo"</th></tr>\n"; 139 foreach($listsite as $siteid) 140 { 141 //counter for alternate color lane 142 $comptligne=2; 143 if ($comptligne%2 ==0) 144 { 145 echo"<tr><td class='tableau3'> ".$namesite[$siteid]." </td>\n"; 146 echo"<td class='tableau3'> ".$urlsite[$siteid]." </td>\n"; 147 echo"<td class='tableau5'> <a href='index.php?navig=6&validform=23&sitename=".urlencode($namesite[$siteid])."&siteurl=".urlencode($urlsite[$siteid])."&site=".$siteid."&validsite=1'>".$language['modif_site2']."</a> </td></tr>\n"; 148 } 149 else 150 { 151 echo"<tr><td class='tableau30'> ".$namesite[$siteid]." </td>\n"; 152 echo"<td class='tableau30'> ".$urlsite[$siteid]." </td>\n"; 153 echo"<td class='tableau50'> <a href='index.php?navig=6&validform=23&sitename=".urlencode($namesite[$siteid])."&siteurl=".urlencode($urlsite[$siteid])."&site=".$siteid."&validsite=1'>".$language['modif_site2']."</a> </td></tr>\n"; 154 } 155 } 156 echo"</table><br>\n"; 157 158 } 159 160 161 ?>
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 |