SELECT videoid, posterpath, previewpath
FROM tblVideoFiles WHERE videoid = <ID>;

# Verify ImageMagick
which convert
convert --version

# Reprocess thumbnails only
php ct/admin/cron/videoprocessor.php --video-id=<ID> --thumbnails-only

SELECT  FROM tblStorageServers WHERE enabled = 1;
   SELECT  FROM tblStorageServerGroups;

SELECT  FROM tblStorageFileLocations WHERE videoid = <ID>;

https://cdn.example.com/videos/4000/4321/webmp4/web.mp4

SELECT serverid, title, statusid, currentjobs, maxconcurrentjobs,
          lastheartbeat, loadaverage
   FROM tblConversionServers WHERE statusid = 1;

SELECT  FROM tblConversionServerLogs
   WHERE loglevel IN ('WARNING', 'ERROR')
   ORDER BY createdat DESC LIMIT 20;

SELECT  FROM tblSettings WHERE settinggroup = 'videoprocessing';

-- CORRECT
   SELECT id, username, accountstatus FROM tblCMSUsers WHERE id = 123;

   -- WRONG (column doesn't exist)
   SELECT userid FROM tblCMSUsers;

-- CORRECT
   WHERE accountstatus = 'active'

   -- WRONG
   WHERE status = 'active'

POST /ct/api/v1/auth/login

$jwtsecret = md5($domain . $licensekey);

// Browser console
   const api = new ApiClient();
   console.log(api.baseUrl);

console.log(localStorage.getItem('authtoken'));

SELECT COUNT() FROM tblVideos WHERE status = 'active';
   SELECT COUNT() FROM tblCamsPerformers WHERE status = 1 AND enabled = 1;

header('Access-Control-Allow-Origin: https://yourdomain.com');
header('Access-Control-Allow-Methods: GET, POST, PUT, DELETE, OPTIONS');
header('Access-Control-Allow-Headers: Content-Type, Authorization');

Header set Access-Control-Allow-Origin "https://yourdomain.com"

curl https://yourdomain.com/ct/api/v1/features

// Clear APCu cache
   apcuclearcache();

php -r "jsondecode(filegetcontents('lang/en.json')); echo jsonlasterrormsg();"

# Search for a specific key
   grep -o '"videos"' lang/en.json

// Force cache bust
<link rel="stylesheet" href="assets/css/style.css?v=<?= time() ?>">

console.log(localStorage.getItem('comusdarkmode'));

document.body.classList.contains('dark-mode');
   document.documentElement.classList.contains('dark-mode');

GET /securemedia.php?token=...&type=video&id=...

// PHP
$url = sprintf('click.php?url=%s&type=video&id=%d',
    urlencode($externalurl), $videoid);

// JavaScript
const url = click.php?url=${encodeURIComponent(externalUrl)}&type=${type}&id=${id};

SELECT  FROM tblClickTracking ORDER BY clickid DESC LIMIT 10;

// 1. Load config and API helper FIRST
requireonce DIR . '/ct/dat/config.inc.php';
requireonce DIR . '/includes/InternalApiHelper.php';

// 2. Fetch data for SEO
$api = InternalApiHelper::getInstance();
$videoData = $api->getVideoForSeo($videoId);

// 3. NOW include header (generates meta tags from loaded data)
requireonce DIR . '/includes/header.php';

php ct/admin/cronupdatecams.php

SELECT recordnum, name, enabled FROM tblCamsSites WHERE enabled = 1;

tail -50 ct/logs/cron-update.log

GET /ct/api/v1/cams/online?perpage=1&fast=1

php ct/admin/cronupdatecams.php

curl --location 'https://performersext-api.pcvdaa.com/performers-ext/?token=<TOKEN>&gender=f&live=true&size=1&page=1' \
   --header 'x-api-key: <APIKEY>' \
   --header 'User-Agent: ComusThumbz/1.0'

SELECT COUNT() FROM tblCamsPerformers WHERE status = 1;

-- Check stored API credentials
SELECT recordnum, name, apiData, parameters FROM tblCamsSites WHERE enabled = 1;

-- Check token values
SELECT recordnum, name, parameters, brand FROM tblCamsSites WHERE enabled = 1;

https://yourdomain.com/tools/camperformersdebug.php?key=comus2025

php -m | grep apcu

/2     php /path/to/ct/admin/cron/updatecamperformerstats.php

$clickurl = sprintf('click.php?url=%s&type=camperformer&id=%d',
    urlencode($performer['chatroomurl']), $performer['performerid']);

# Check container status
docker ps -a | grep livekit

# Check logs
docker logs livekit

# Verify Docker is running
systemctl status docker

# Check port availability
ss -tlnp | grep 7880

# Restart container
docker restart livekit

# Or recreate
docker rm -f livekit
docker run -d --name livekit --network host \
  -v $(pwd)/livekit-config.yaml:/livekit.yaml:ro \
  livekit/livekit-server:latest --config /livekit.yaml

define('LIVEKITHOST', 'wss://yourdomain.com/livekit/');
   define('LIVEKITAPIKEY', 'yourkey');
   define('LIVEKITAPISECRET', 'yoursecret');

sudo ufw status | grep -E "7880|7881|40000"

top -bn1 | head -5

SELECT  FROM tblLiveStreamChat ORDER BY id DESC LIMIT 10;

-- Check recent token transactions
SELECT  FROM tblTokenTransactions ORDER BY createdat DESC LIMIT 10;

-- Check creator tips
SELECT  FROM tblCreatorTips ORDER BY createdat DESC LIMIT 10;

-- Check user token balance
SELECT id, username, tokenbalance FROM tblCMSUsers WHERE id = <USERID>;

     php /path/to/ct/admin/cron/aggregatecreatorearnings.php

-- Check daily earnings records
SELECT  FROM tblCreatorEarningsDaily
WHERE creatorid = <ID>
ORDER BY earningdate DESC LIMIT 10;

-- Check if raw transactions exist
SELECT SUM(amount) as total
FROM tblTokenTransactions
WHERE recipientid = <ID> AND createdat >= CURDATE();

SELECT  FROM tblCreatorPosts WHERE creatorid = <ID> ORDER BY createdat DESC LIMIT 10;

SELECT  FROM tblCreatorPostMedia WHERE postid = <POSTID>;

-- Check active subscriptions
SELECT  FROM tblCreatorSubscriptions
WHERE subscriberid = <USERID> AND status = 'active';

-- Check subscription packages
SELECT  FROM tblCreatorSubscriptionPackages WHERE creatorid = <CREATORID>;

POST /ct/api/v1/auth/login
   {"username": "test", "password": "test"}

SELECT id, username, accountstatus, emailverified
   FROM tblCMSUsers WHERE username = 'testuser';

DELETE FROM tblCMSRateLimits WHERE action LIKE '%login%';

<?php echo passwordhash('yournewpassword', PASSWORDDEFAULT); ?>

UPDATE tblSettings SET adminpassword = 'PASTEHASHHERE' WHERE id = 1;

document.cookie  // Check for PHP session cookie

vardump(sessionstatus());  // Should be PHPSESSIONACTIVE
   vardump($SESSION);         // Should contain user data

date
   timedatectl status