File: /var/www/html/tmpr/../tmpr/../renameDuplicates.php
<?php
include('Connections/videoondemand.php');
require("DbSql2.inc.php");
require("NewsSql2.inc.php");
$db = new NewsSQL;
//a class to handle database operations
ini_set('max_execution_time', 30000000); //300 seconds = 5 minutes
error_reporting(1);
global $link;
$sql = "SELECT * FROM profilepicture where catalogid=152 GROUP BY slug HAVING COUNT(*) > 1 order by slug limit 0,200";
$result = mysqli_query($link, $sql) or die(mysqli_error($link));
if(empty($result)){exit("no result!");}
$count = 0;
while ($row1 = mysqli_fetch_assoc($result)) {
$count++;
$id = $row1['id'];
$slug = $row1['slug'];
$alias = $row1['alias'];
$title = $row1['title'];
$title = urlencode("$title - $count");
$slug = strtolower($title);
$slug = preg_replace('/[^A-Za-z0-9-]+/', '-', $slug);
$slug =str_replace("---","-","$slug");
$slug =str_replace("--","-","$slug");
$slug = urlencode($slug);
echo $url = "https://www.thebrand.ai/TheBrandZ/mode.php?mode=renameDuplicates&slug=$slug&title=$title&specialID=$id";
$ch = curl_init();
curl_setopt($ch, CURLOPT_URL,"$url");
curl_setopt($ch, CURLOPT_POST, 1);
curl_setopt($ch, CURLOPT_POSTFIELDS,
"$json");
curl_setopt($ch, CURLOPT_RETURNTRANSFER, true);
$server_output = curl_exec($ch);
$httpcode = curl_getinfo($ch, CURLINFO_HTTP_CODE);
curl_close ($ch);
if($httpcode>=200 && $httpcode<300)
{
echo $server_output;
sleep(2);
}
else
{
echo "fail";
}
}