function LoadViewsFromDatabase()
{
// Needed to make global
global $CFG, $content;
// --- Create SQL Query
// Create Where for USERID
if (isset($content['SESSION_LOGGEDIN']) && $content['SESSION_LOGGEDIN']) {
$szWhereUser = "******" . DB_VIEWS . "`.userid = " . $content['SESSION_USERID'] . " ";
} else {
$szWhereUser = "";
}
if (isset($content['SESSION_GROUPIDS'])) {
$szGroupWhere = " OR `" . DB_VIEWS . "`.groupid IN (" . $content['SESSION_GROUPIDS'] . ")";
} else {
$szGroupWhere = "";
}
$sqlquery = " SELECT " . DB_VIEWS . ".ID, " . DB_VIEWS . ".DisplayName, " . DB_VIEWS . ".Columns, " . DB_VIEWS . ".userid, " . DB_VIEWS . ".groupid, " . DB_USERS . ".username, " . DB_GROUPS . ".groupname " . " FROM `" . DB_VIEWS . "`" . " LEFT OUTER JOIN (`" . DB_USERS . "`) ON (`" . DB_VIEWS . "`.userid=`" . DB_USERS . "`.ID ) " . " LEFT OUTER JOIN (`" . DB_GROUPS . "`) ON (`" . DB_VIEWS . "`.groupid=`" . DB_GROUPS . "`.ID ) " . " WHERE (`" . DB_VIEWS . "`.userid IS NULL AND `" . DB_VIEWS . "`.groupid IS NULL) " . $szWhereUser . $szGroupWhere . " ORDER BY `" . DB_VIEWS . "`.userid, `" . DB_VIEWS . "`.groupid, `" . DB_VIEWS . "`.DisplayName";
// ---
// Get Views from DB now!
$result = DB_Query($sqlquery);
$myrows = DB_GetAllRows($result, true);
if (isset($myrows) && count($myrows) > 0) {
// Overwrite existing Views array
unset($CFG['Views']);
// ReINIT Views Array
InitViewConfigs();
// Unpack the Columns and append to Views Array
foreach ($myrows as &$myView) {
// Split into array
$myView['Columns'] = explode(",", $myView['Columns']);
// remove spaces
foreach ($myView['Columns'] as &$myCol) {
$myCol = trim($myCol);
}
// Append to Views Array
$CFG['Views'][$myView['ID']] = $myView;
}
// Merge into existing Views Array!
// $CFG['Views'] = array_merge ( $CFG['Views'], $myrows );
$content['Views'] = $CFG['Views'];
}
}
function InitBasicPhpLogCon()
{
// Needed to make global
global $gl_root_path, $content;
// Check RunMode first!
CheckAndSetRunMode();
// Set the default line sep
SetLineBreakVar();
// Start the PHP Session
StartPHPSession();
// Init View Configs prior loading config.php!
InitViewConfigs();
}
