| Server IP : 51.89.169.208 / Your IP : 3.148.107.92 Web Server : Apache System : Linux ns3209505.ip-198-244-202.eu 4.18.0-553.27.1.el8_10.x86_64 #1 SMP Tue Nov 5 04:50:16 EST 2024 x86_64 User : yellowleaf ( 1019) PHP Version : 7.4.33 Disable Function : exec,passthru,shell_exec,system MySQL : OFF | cURL : ON | WGET : ON | Perl : ON | Python : ON | Sudo : ON | Pkexec : ON Directory : /home/yellowleaf/public_html/junk/ |
Upload File : |
<?
include_once('connect.php');
$area_sql = mysql_query("SELECT * FROM ads WHERE boz = '' ORDER BY adid ASC LIMIT 1");
if(!mysql_num_rows($area_sql)){echo 'done';die;}
while($area_row = mysql_fetch_array($area_sql)){
$mid=$area_row['adid'];
$town_name =ucwords($area_row['town_name']);
$county_name =ucwords($area_row['county_name']);
echo "$mid";
echo "<hr>";
echo "$town_name";
echo "<hr>";
echo "<hr>";
echo "$county_name ";
echo "<hr>";
//active = '0' AND active = '0' AND
}
$area_sql2 = mysql_query("SELECT * FROM towns_new WHERE stripped_name = '{$town_name}' AND r_county_name = '{$county_name}' LIMIT 1");
if(!mysql_num_rows($area_sql2)){ $found=1; } else {$found=2;}
echo "UPDATE ads SET boz='{$found}' WHERE $adid='{$mid}'";
mysql_query("UPDATE ads SET boz='{$found}' WHERE adid='{$mid}'");
?>
<meta http-equiv="refresh" content="0" />