Fix mySQL/PHP Code Line ERRORS on NFOPic.com (php7.4 upgrade needs debug) [TXT/NFO/DiZ 2 PNG Converter PHP Script]

Job ID: 37226330

Budget: $30 – $250 AUD

I had the NFOPic.com ALPHA added to on Scriptlance by Dr. Tech a while ago:
a) Added Hotlinking b) Changed BitMap Font Type c) Added JS text input field to display hotlink URL
d) Displays Name of Document above PNG when converted & Adds FileName.png, Adds Random Number String to DB and saves eg. 9984783883993.png in /uploads folder!
e) adds count(1) to nfo_images mySQL TABLE so it displays the number of .png converted files on index.php -> There have been <strong><font color="red"><?php echo $total; ?></font></strong> Files Converted on NFOPic so far...

*** OUTSTANDING ERRORS NEED FIXING (mySQL/PHP) = 4 Lines of Code Shown Below + db.php (has mysql database info....

e1) <?php echo $total; ?> = NO LONGER shows/fetches the XX,000 number from 'nfo_images' since php5.5 was upgraded to php7.4 when my cPanel Backup was re-uploaded to new Server (Database Line NEEDS DE-BUGGING I think, as it is using older mysql code (instead of mysqli_ or PDO for new php7.4 version on server) =======

require_once 'include/db.php';

if ( !is_local() )
{
$sql = "SELECT count(1) AS count FROM nfo_images";
$rs = mysql_query( $sql );
$data = mysql_fetch_assoc( $rs );
$total = $data['count'];
}
else {
$total = rand(1, 9999);
}

------- NOTE: BitMap Font Bug is FIXED, the bitmap file was corrupted, after replacing with the v1.0 ALPHA file, it fixed the problem ----
Related categories: PHP MySQL HTML jQuery