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(); }