| 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 `locations` WHERE `area_name` LIKE '%/%' LIMIT 1");
if(!mysql_num_rows($area_sql)){echo 'done';die;}
while($area_row = mysql_fetch_array($area_sql)){
$mid=$area_row['area_id'];
$area_name =explode('/',trim($area_row['area_name']));
$area_name = $area_name[0];
echo "$mid";
echo "<hr>";
echo "$area_name ";
echo "<hr>";
mysql_query("UPDATE locations SET area_name='$area_name' WHERE area_id='$mid'");
}
?>
<meta http-equiv="refresh" content="0" />