[Xoops-svn] SF.net SVN: xoops-svn:[13343] *.xoops.org (Subdomain APIs & Sites)/ fonty.xoops.org/crons/zip-fonts.php

[<chr...@us...>]

Revision: 13343
          http://sourceforge.net/p/xoops/svn/13343
Author:   chronolabscoop
Date:     2018-02-23 10:45:37 +0000 (Fri, 23 Feb 2018)
Log Message:
-----------
Fonting Services Repository REST API v2.7.8!

Modified Paths:
--------------
    *.xoops.org (Subdomain APIs & Sites)/fonty.xoops.org/crons/zip-fonts.php

Modified: *.xoops.org (Subdomain APIs & Sites)/fonty.xoops.org/crons/zip-fonts.php
===================================================================
--- *.xoops.org (Subdomain APIs & Sites)/fonty.xoops.org/crons/zip-fonts.php	2018-02-23 10:41:34 UTC (rev 13342)
+++ *.xoops.org (Subdomain APIs & Sites)/fonty.xoops.org/crons/zip-fonts.php	2018-02-23 10:45:37 UTC (rev 13343)
@@ -332,7 +332,7 @@
 		{
 			$ffls++;
 			echo "Checking file $ffls missing in files index: $path/$files\n";
-			list($count) = $GLOBALS['APIDB']->fetchRow($GLOBALS['APIDB']->queryF($sql = "SELECT count(*) from `fonts_files` WHERE `font_id` = '" . $upload['font_id']. "' AND  `archive_id` = '" . $archive_id. "' AND `path` = '/' AND `filename` = '$files'"));
+			list($count) = $GLOBALS['APIDB']->fetchRow($GLOBALS['APIDB']->queryF($sql = "SELECT count(*) from `" . $GLOBALS['APIDB']->prefix('fonts_files') . "` WHERE `font_id` = '" . $upload['font_id']. "' AND  `archive_id` = '" . $archive_id. "' AND `path` = '/' AND `filename` = '$files'"));
 			if ($count==0)
 			{
 				$exts = explode('.', $files);
@@ -343,7 +343,7 @@
 						$type = $filetype;
 				if (empty($type))
 					$type = 'other';
-				if ($GLOBALS['APIDB']->queryF($sql = "INSERT INTO `fonts_files` (`font_id`, `archive_id`, `type`, `extension`, `filename`, `path`, `bytes`, `hits`, `created`) VALUES('" . $upload['font_id']. "', '" . $archive_id. "','$type','$ext','$files','/','" .filesize($currently . DIRECTORY_SEPARATOR . $files) . "',0,unix_timestamp())"))
+				if ($GLOBALS['APIDB']->queryF($sql = "INSERT INTO `" . $GLOBALS['APIDB']->prefix('fonts_files') . "` (`font_id`, `archive_id`, `type`, `extension`, `filename`, `path`, `bytes`, `hits`, `created`) VALUES('" . $upload['font_id']. "', '" . $archive_id. "','$type','$ext','$files','/','" .filesize($currently . DIRECTORY_SEPARATOR . $files) . "',0,unix_timestamp())"))
 					echo "Index for File Missing added: $path/$files for font\n";
 				else
 					die("SQL Failed: $sql;");
@@ -354,7 +354,7 @@
 			{
 				$ffls++;
 				echo "Checking file $ffls missing in files index: $path/$filz\n";
-				list($count) = $GLOBALS['APIDB']->fetchRow($GLOBALS['APIDB']->queryF($sql = "SELECT count(*) from `fonts_files` WHERE `font_id` = '" . $upload['font_id']. "' AND  `archive_id` = '" . $archive_id. "' AND `path` = '$path' AND `filename` = '$filz'"));
+				list($count) = $GLOBALS['APIDB']->fetchRow($GLOBALS['APIDB']->queryF($sql = "SELECT count(*) from `" . $GLOBALS['APIDB']->prefix('fonts_files') . "` WHERE `font_id` = '" . $upload['font_id']. "' AND  `archive_id` = '" . $archive_id. "' AND `path` = '$path' AND `filename` = '$filz'"));
 				if ($count==0)
 				{
 					$exts = explode('.', $filz);
@@ -365,7 +365,7 @@
 							$type = $filetype;
 					if (empty($type))
 						$type = 'other';
-					if ($GLOBALS['APIDB']->queryF($sql = "INSERT INTO `fonts_files` (`font_id`, `archive_id`, `type`, `extension`, `filename`, `path`, `bytes`, `hits`, `created`) VALUES('" . $upload['font_id']. "', '" . $archive_id. "','$type','$ext','$filz','$path','" .filesize($currently . DIRECTORY_SEPARATOR . $path . DIRECTORY_SEPARATOR . $filz) . "',0,unix_timestamp())"))
+					if ($GLOBALS['APIDB']->queryF($sql = "INSERT INTO `" . $GLOBALS['APIDB']->prefix('fonts_files') . "` (`font_id`, `archive_id`, `type`, `extension`, `filename`, `path`, `bytes`, `hits`, `created`) VALUES('" . $upload['font_id']. "', '" . $archive_id. "','$type','$ext','$filz','$path','" .filesize($currently . DIRECTORY_SEPARATOR . $path . DIRECTORY_SEPARATOR . $filz) . "',0,unix_timestamp())"))
 						echo "Index for File Missing added: $path/$filz for font\n";
 					else
 						die("SQL Failed: $sql;");