/**
** @description : function will create cache file with all SQL queries ;
** @return :
*/
function genSiteStatCache()
{
$sqlQuery = "SELECT `Name` as `name`,\n `Title` as `capt`,\n `UserQuery` as `query`,\n `UserLink` as `link`,\n `IconName` as `icon`,\n `AdminQuery` as `adm_query`,\n `AdminLink` as `adm_link`\n FROM `sys_stat_site`\n ORDER BY `StatOrder` ASC, `ID` ASC";
$rData = db_res($sqlQuery);
$sLine = "return array( \n";
while ($aVal = mysql_fetch_assoc($rData)) {
$sLine .= genSiteStatFile($aVal);
}
$sLine = rtrim($sLine, ",\n") . "\n);";
$aResult = eval($sLine);
$oCache = $GLOBALS['MySQL']->getDbCacheObject();
return $oCache->setData($GLOBALS['MySQL']->genDbCacheKey('sys_stat_site'), $aResult);
}
function getSiteStatAdmin()
{
global $site;
global $dir;
$aAdmin = '';
$sProfVideo = '';
$sAdd = '_a';
$sProfVideo = getApplicationContent('video', 'stat', array(), true);
$sqlQuery = "SELECT `Name` as `name`,\r\n\t\t\t\t\t\t`Title` as `capt`,\r\n\t\t\t\t\t\t`UserQuery` as `query`,\r\n\t\t\t\t\t\t`UserLink` as `link`,\r\n\t\t\t\t\t\t`IconName` as `icon`,\r\n\t\t\t\t\t\t`AdminQuery` as `adm_query`,\r\n\t\t\t \t\t\t`AdminLink` as `adm_link`\r\n\t\t\t\t\t\tFROM `SiteStat`";
$rData = db_res($sqlQuery);
$sCode = $sProfVideo . '<div>';
$fStat = @fopen(BX_DIRECTORY_PATH_INC . 'db_cached/SiteStat.inc', 'w');
if (!$fStat) {
return false;
}
fwrite($fStat, "return array( \n");
$sLine = '';
while ($aVal = mysql_fetch_assoc($rData)) {
$sCode .= getSiteStatBody($aVal, 'admin');
$sLine .= genSiteStatFile($aVal);
}
$sLine = rtrim($sLine, ",\n") . "\n);";
fwrite($fStat, $sLine);
fclose($fStat);
$sCode .= '</div><div class="clear_both"></div>';
return $sCode;
}
