File: /var/www/html/updateProfilePictureSlug.php
<?php
$page = $_SERVER['PHP_SELF'];
$sec = "4";
?>
<?php
set_time_limit(100000);
include("includes/limittext.php");
include('Connections/videoondemand.php');
require("DbSql2.inc.php");
require("NewsSql2.inc.php");
include("includes/processFunctionsX.php");
include("const.inc.php");
$db = new NewsSQL();
include("protect.php");
global $link;
$stmt2 ="SELECT * FROM `profilepicture` WHERE catalogid=152 and id >14764";
$query = mysqli_query($link,$stmt2) or die(mysqli_error());
$dbdata = array();
while ($row = mysqli_fetch_array($query, MYSQLI_ASSOC))
{
$title= $row["title"] ;
$slug = str_replace(' ', '-', $title);
$slug= preg_replace('/[^A-Za-z0-9\-]/', rand(10,30), $slug);
$id= $row["id"] ;
echo $sql = "update profilepicture set slug='$slug',alias='$slug' WHERE id=$id and catalogid=152; <br>";
//$query = mysqli_query($link,"$sql");
//echo "done $title | $slug <br>";
}
?>