File: /var/www/html/tmpr/..//tmpr/../adminthemeslist.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);
$page = $_GET['page'];
if(empty($page)) { $page = 1;}
$page = $page-1 ;
$startRow_Latest = $page * 5837;
global $link;
$sql = "SELECT * FROM profilepicture where catalogid=152 and visibility=1 and public=1 and isdisplay=13 and status=1 and is_deleted=0 order by id desc limit $startRow_Latest,5837";
$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'];
$title = $row1['title'];
// echo $url = "$id - $title<br>";
echo $url = "https://www.thebrand.ai/editorUnlimitedX/automate.php?themeid=$id<br>";
// echo $url = "https://www.thebrand.ai/i/$slug<br>";
// echo $url = "------------------------------------------------------------<br><br>";
}