';
exit();
}
//test for dont repeat
$sql="SELECT * FROM add_url ORDER BY id DESC";
$result=mysql_query($sql,$connection) or die(mysql_error());
while ($row=mysql_fetch_array($result)){
if ($row[url_address] == $_POST[url_address] ){
$message='
در حال پردازش...
';
}
echo $message;
exit();
}
//delete url
if ($id == 'delurl' && $number != "" && $pass=="2039"){
include "../forum/config.php";
$connection=mysql_connect($dbhost,$dbuser,$dbpasswd);
$db=mysql_select_db($dbname,$connection);
$sql="DELETE FROM add_url WHERE id=$number;";
$result=mysql_query($sql,$connection) or die(mysql_error());
if ($result){
$message ='deleted successfully';
}
else
{
$message ='not deleted';
}
echo $message;
exit();
}
// if id = empty
include "./forum/config.php";
$connection=mysql_connect($dbhost,$dbuser,$dbpasswd);
$db=mysql_select_db($dbname,$connection);
$sql="SELECT * FROM add_url WHERE url_far='1' ORDER BY id DESC";
$result=mysql_query($sql,$connection) or die(mysql_error());
while ($row=mysql_fetch_array($result)){
$id =$row[id];
$url_address =$row[url_address];
$url_name =$row[url_name];
$url_type =$row[url_type];
$url_date =$row[url_date];
$i[0]++;
$url_names_far .= '
'.$url_name.' |'.$url_type.'| ثبت شده در تاریخ '.$url_date.'- به شماره ی ('.$id.') ';
}
$sql="SELECT * FROM add_url WHERE url_soc='1' ORDER BY id DESC";
$result=mysql_query($sql,$connection) or die(mysql_error());
while ($row=mysql_fetch_array($result)){
$id =$row[id];
$url_address =$row[url_address];
$url_name =$row[url_name];
$url_type =$row[url_type];
$url_date =$row[url_date];
$i[1]++;
$url_names_soc .= '
'.$url_name.' |'.$url_type.'| ثبت شده در تاریخ '.$url_date.'- به شماره ی ('.$id.') ';
}
$sql="SELECT * FROM add_url WHERE url_pol='1' ORDER BY id DESC";
$result=mysql_query($sql,$connection) or die(mysql_error());
while ($row=mysql_fetch_array($result)){
$id =$row[id];
$url_address =$row[url_address];
$url_name =$row[url_name];
$url_type =$row[url_type];
$url_date =$row[url_date];
$i[2]++;
$url_names_pol .= '
'.$url_name.' |'.$url_type.'| ثبت شده در تاریخ '.$url_date.'- به شماره ی ('.$id.') ';
}
$sql="SELECT * FROM add_url WHERE url_sci='1' ORDER BY id DESC";
$result=mysql_query($sql,$connection) or die(mysql_error());
while ($row=mysql_fetch_array($result)){
$id =$row[id];
$url_address =$row[url_address];
$url_name =$row[url_name];
$url_type =$row[url_type];
$url_date =$row[url_date];
$i[3]++;
$url_names_sci .= '
'.$url_name.' |'.$url_type.'| ثبت شده در تاریخ '.$url_date.'- به شماره ی ('.$id.') ';
}
$sql="SELECT * FROM add_url WHERE url_oth='1' ORDER BY id DESC";
$result=mysql_query($sql,$connection) or die(mysql_error());
while ($row=mysql_fetch_array($result)){
$id =$row[id];
$url_address =$row[url_address];
$url_name =$row[url_name];
$url_type =$row[url_type];
$url_date =$row[url_date];
$i[4]++;
$url_names_oth .= '
'.$url_name.' |'.$url_type.'| ثبت شده در تاریخ '.$url_date.'- به شماره ی ('.$id.') ';
}
?>