// TODO!!!!!!!!!!!111111111 // Read Text fields if (isset($_POST['User_PrependTitle'])) { $USERCFG['PrependTitle'] = $_POST['User_PrependTitle']; } if (isset($_POST['User_SearchCustomButtonCaption'])) { $USERCFG['SearchCustomButtonCaption'] = $_POST['User_SearchCustomButtonCaption']; } if (isset($_POST['User_SearchCustomButtonSearch'])) { $USERCFG['SearchCustomButtonSearch'] = $_POST['User_SearchCustomButtonSearch']; } // Save configuration variables now SaveUserGeneralSettingsIntoDB(); } // Do a redirect RedirectResult($content['LN_GEN_SUCCESSFULLYSAVED'], "index.php"); } } // PreInit newer values if necessary if (!isset($content['SuppressDuplicatedMessages'])) { $content['SuppressDuplicatedMessages'] = 0; } if (!isset($content['TreatNotFoundFiltersAsTrue'])) { $content['TreatNotFoundFiltersAsTrue'] = 0; } if (!isset($content['InlineOnlineSearchIcons'])) { $content['InlineOnlineSearchIcons'] = 1; } if (!isset($content['AdminChangeWaitTime'])) { $content['AdminChangeWaitTime'] = 2; }
// Everything was alright, go and check if the entry exists! $result = DB_Query("SELECT FieldID FROM " . DB_FIELDS . " WHERE FieldID = '" . $content['FieldID'] . "'"); $myrow = DB_GetSingleRow($result, true); if (!isset($myrow['FieldID'])) { // Add custom Field now! $sqlquery = "INSERT INTO " . DB_FIELDS . " (FieldID, FieldCaption, FieldDefine, SearchField, FieldAlign, DefaultWidth, FieldType, SearchOnline) \n\t\t\tVALUES (\n\t\t\t\t\t'" . $content['FieldID'] . "', \n\t\t\t\t\t'" . $content['FieldCaption'] . "',\n\t\t\t\t\t'" . $content['FieldDefine'] . "',\n\t\t\t\t\t'" . $content['SearchField'] . "',\n\t\t\t\t\t'" . $content['FieldAlign'] . "', \n\t\t\t\t\t" . $content['DefaultWidth'] . ", \n\t\t\t\t\t" . $content['FieldType'] . ", \n\t\t\t\t\t" . $content['SearchOnline'] . " \n\t\t\t\t\t)"; $result = DB_Query($sqlquery); DB_FreeQuery($result); // Do the final redirect RedirectResult(GetAndReplaceLangStr($content['LN_FIELDS_HASBEENADDED'], DB_StripSlahes($content['FieldCaption'])), "fields.php"); } else { // Edit the Search Entry now! $result = DB_Query("UPDATE " . DB_FIELDS . " SET \n\t\t\t\tFieldCaption = '" . $content['FieldCaption'] . "', \n\t\t\t\tFieldDefine = '" . $content['FieldDefine'] . "', \n\t\t\t\tSearchField = '" . $content['SearchField'] . "', \n\t\t\t\tFieldAlign = '" . $content['FieldAlign'] . "', \n\t\t\t\tDefaultWidth = " . $content['DefaultWidth'] . ", \n\t\t\t\tFieldType = " . $content['FieldType'] . ", \n\t\t\t\tSearchOnline = " . $content['SearchOnline'] . "\n\t\t\t\tWHERE FieldID = '" . $content['FieldID'] . "'"); DB_FreeQuery($result); // Done redirect! RedirectResult(GetAndReplaceLangStr($content['LN_FIELDS_HASBEENEDIT'], DB_StripSlahes($content['FieldCaption'])), "fields.php"); } } } if (!isset($_POST['op']) && !isset($_GET['op'])) { // Default Mode = List Searches $content['LISTFIELDS'] = "true"; // Copy Search array for further modifications $content['FIELDS'] = $fields; $i = 0; // Help counter! foreach ($content['FIELDS'] as &$myField) { // Allow Delete Operation if ($myField['IsInternalField'] && $myField['FieldFromDB']) { $myField['AllowDelete'] = true; $myField['DELETEIMG'] = $content['MENU_DELETE_FROMDB'];
DB_FreeQuery($result); // Do the final redirect RedirectResult(GetAndReplaceLangStr($content['LN_SEARCH_HASBEENADDED'], DB_StripSlahes($content['DisplayName'])), "searches.php"); } else { if ($_POST['op'] == "editsearch") { $result = DB_Query("SELECT ID FROM " . DB_SEARCHES . " WHERE ID = " . $content['SEARCHID']); $myrow = DB_GetSingleRow($result, true); if (!isset($myrow['ID'])) { $content['ISERROR'] = true; $content['ERROR_MSG'] = GetAndReplaceLangStr($content['LN_SEARCH_ERROR_IDNOTFOUND'], $content['SEARCHID']); } else { // Edit the Search Entry now! $result = DB_Query("UPDATE " . DB_SEARCHES . " SET \n\t\t\t\t\tDisplayName = '" . $content['DisplayName'] . "', \n\t\t\t\t\tSearchQuery = '" . $content['SearchQuery'] . "', \n\t\t\t\t\tuserid = " . $content['userid'] . ", \n\t\t\t\t\tgroupid = " . $content['groupid'] . "\n\t\t\t\t\tWHERE ID = " . $content['SEARCHID']); DB_FreeQuery($result); // Done redirect! RedirectResult(GetAndReplaceLangStr($content['LN_SEARCH_HASBEENEDIT'], DB_StripSlahes($content['DisplayName'])), "searches.php"); } } } } } if (!isset($_POST['op']) && !isset($_GET['op'])) { // Default Mode = List Searches $content['LISTSEARCHES'] = "true"; // Copy Search array for further modifications $content['SEARCHES'] = $content['Search']; $i = 0; // Help counter! foreach ($content['SEARCHES'] as &$mySearch) { $mySearch['SearchQuery_Display'] = strlen($mySearch['SearchQuery']) > 25 ? substr($mySearch['SearchQuery'], 0, 25) . " ..." : $mySearch['SearchQuery']; // Allow EDIT
} else { if (strpos($_POST['op'], "editsavedreport") !== false) { $result = DB_Query("SELECT ID FROM " . DB_SAVEDREPORTS . " WHERE ID = " . $content['SavedReportID']); $myrow = DB_GetSingleRow($result, true); if (!isset($myrow['ID'])) { $content['ISERROR'] = true; $content['ERROR_MSG'] = GetAndReplaceLangStr($content['LN_REPORTS_ERROR_SAVEDREPORTIDNOTFOUND'], $content['SavedReportID']); } else { $sqlquery = "UPDATE " . DB_SAVEDREPORTS . " SET \n\t\t\t\t\t\t\t\t\tsourceid = " . $content['SourceID'] . ", \n\t\t\t\t\t\t\t\t\tcustomTitle = '" . $content['customTitle'] . "', \n\t\t\t\t\t\t\t\t\tcustomComment = '" . $content['customComment'] . "', \n\t\t\t\t\t\t\t\t\tfilterString = '" . $content['filterString'] . "', \n\t\t\t\t\t\t\t\t\tcustomFilters = '" . $content['customFilters'] . "', \n\t\t\t\t\t\t\t\t\toutputFormat = '" . $content['outputFormat'] . "', \n\t\t\t\t\t\t\t\t\toutputTarget = '" . $content['outputTarget'] . "', \n\t\t\t\t\t\t\t\t\toutputTargetDetails = '" . $content['outputTargetDetails'] . "', \n\t\t\t\t\t\t\t\t\tscheduleSettings = '" . $content['scheduleSettings'] . "' \n\t\t\t\t\t\t\t\t\tWHERE ID = " . $content['SavedReportID']; $result = DB_Query($sqlquery); DB_FreeQuery($result); // Done redirect! if (strpos($_POST['op'], "_return") !== false) { RedirectResult(GetAndReplaceLangStr($content['LN_REPORTS_HASBEENEDIT'], DB_StripSlahes($content['customTitle'])), "reports.php"); } else { RedirectResult(GetAndReplaceLangStr($content['LN_REPORTS_HASBEENEDIT'], DB_StripSlahes($content['customTitle'])), "reports.php" . $content['FormUrlAddOP']); } } } } } } else { $content['ISERROR'] = true; $content['ERROR_MSG'] = GetAndReplaceLangStr($content['LN_REPORTS_ERROR_IDNOTFOUND'], $content['ReportID']); } } // Default mode! if (!isset($_POST['op']) && !isset($_GET['op'])) { if (isset($content['REPORTS'])) { // Default Mode = List Searches $content['LISTREPORTS'] = "true";
if (isset($_POST['userid'])) { // Copy UserID $content['USERID'] = intval(DB_RemoveBadChars($_POST['userid'])); $result = DB_Query("SELECT username FROM " . DB_USERS . " WHERE id = " . $content['USERID']); $myrow = DB_GetSingleRow($result, true); if (isset($myrow['username'])) { // remove user from group $result = DB_Query("DELETE FROM " . DB_GROUPMEMBERS . " WHERE userid = " . $content['USERID'] . " AND groupid = " . $content['GROUPID']); if ($result == FALSE) { $content['ISERROR'] = true; $content['ERROR_MSG'] = GetAndReplaceLangStr($content['LN_GROUP_ERROR_REMUSERFROMGROUP'], $myrow['username'], $content['groupname']); } else { DB_FreeQuery($result); } // Do the final redirect RedirectResult(GetAndReplaceLangStr($content['LN_GROUP_USERHASBEENREMOVED'], $myrow['username'], $content['groupname']), "groups.php"); } else { $content['ISERROR'] = true; $content['ERROR_MSG'] = GetAndReplaceLangStr($content['LN_USER_ERROR_IDNOTFOUND'], $content['USERID']); } } else { $content['ISERROR'] = true; $content['ERROR_MSG'] = $content['LN_GROUP_ERROR_USERIDMISSING']; } } } } } } } if (!isset($_POST['op']) && !isset($_GET['op'])) {
// Helper counter $addedFields = 0; // Loop through all custom fields! foreach ($myParser['CustomFieldsList'] as $myField) { // check if field is in define list! if (!array_key_exists($myField['FieldID'], $fields)) { // Add field into DB! $sqlquery = "INSERT INTO " . DB_FIELDS . " (FieldID, FieldCaption, FieldDefine, SearchField, FieldAlign, DefaultWidth, FieldType, SearchOnline) \n\t\t\t\t\t\t\tVALUES (\n\t\t\t\t\t\t\t\t\t'" . $myField['FieldID'] . "', \n\t\t\t\t\t\t\t\t\t'" . $myField['FieldCaption'] . "',\n\t\t\t\t\t\t\t\t\t'" . $myField['FieldDefine'] . "',\n\t\t\t\t\t\t\t\t\t'" . $myField['SearchField'] . "',\n\t\t\t\t\t\t\t\t\t'" . $myField['FieldAlign'] . "', \n\t\t\t\t\t\t\t\t\t" . $myField['DefaultWidth'] . ", \n\t\t\t\t\t\t\t\t\t" . $myField['FieldType'] . ", \n\t\t\t\t\t\t\t\t\t" . $myField['SearchOnline'] . " \n\t\t\t\t\t\t\t\t\t)"; $result = DB_Query($sqlquery); DB_FreeQuery($result); // increment counter $addedFields++; } } // Do the final redirect RedirectResult(GetAndReplaceLangStr($content['LN_PARSERS_ERROR_HASBEENADDED'], $myParser['DisplayName'], $addedFields), "parsers.php"); } else { $content['ISERROR'] = true; $content['ERROR_MSG'] = GetAndReplaceLangStr($content['LN_PARSERS_ERROR_NOFIELDS'], $content['ParserID']); } } else { $content['ISERROR'] = true; $content['ERROR_MSG'] = GetAndReplaceLangStr($content['LN_PARSERS_ERROR_IDNOTFOUND'], $content['ParserID']); } } else { $content['ISERROR'] = true; $content['ERROR_MSG'] = $content['LN_PARSERS_ERROR_INVALIDID']; } } } }
$content['ERROR_MSG'] = $content['LN_USER_ERROR_PASSSHORT']; } if (!isset($content['ISERROR'])) { // Create passwordhash now :)! $content['PASSWORDHASH'] = md5($content['PASSWORD1']); // Edit the User now! $result = DB_Query("UPDATE " . DB_USERS . " SET \n\t\t\t\t\t\t\tusername = '******'USERNAME'] . "', \n\t\t\t\t\t\t\tpassword = '******'PASSWORDHASH'] . "', \n\t\t\t\t\t\t\tis_admin = " . $content['ISADMIN'] . ", \n\t\t\t\t\t\t\tis_readonly = " . $content['ISREADONLY'] . "\n\t\t\t\t\t\t\tWHERE ID = " . $content['USERID']); DB_FreeQuery($result); } } else { // Edit the User now! $result = DB_Query("UPDATE " . DB_USERS . " SET \n\t\t\t\t\t\tusername = '******'USERNAME'] . "', \n\t\t\t\t\t\tis_admin = " . $content['ISADMIN'] . ", \n\t\t\t\t\t\tis_readonly = " . $content['ISREADONLY'] . "\n\t\t\t\t\t\tWHERE ID = " . $content['USERID']); DB_FreeQuery($result); } // Done redirect! RedirectResult(GetAndReplaceLangStr($content['LN_USER_ERROR_HASBEENEDIT'], DB_StripSlahes($content['USERNAME'])), "users.php"); } } } } } if (!isset($_POST['op']) && !isset($_GET['op'])) { // Default Mode = List Users $content['LISTUSERS'] = "true"; // Set AddUsers TAB! if ($content['UserDBAuthMode'] == USERDB_AUTH_LDAP) { $content["ALLOWADDUSERS"] = "false"; } else { $content["ALLOWADDUSERS"] = "true"; } // Read all Serverentries
} else { // Report error! $content['ISEDITORNEWDBMP'] = false; $content['ISERROR'] = true; $content['ERROR_MSG'] = GetAndReplaceLangStr($content['LN_DBMP_ERROR_MISSINGFIELDNAME'], $myColKey); // Abort loop break; } } // Only perform if no error occured if (!isset($content['ISERROR'])) { // Edit the Search Entry now! $result = DB_Query("UPDATE " . DB_MAPPINGS . " SET \n\t\t\t\t\t\t\t\tDisplayName = '" . $content['DisplayName'] . "', \n\t\t\t\t\t\t\t\tMappings = '" . $content['SUBMAPPINGS'] . "' \n\t\t\t\t\t\t\t\tWHERE ID = " . $content['DBMPID']); DB_FreeQuery($result); // Done redirect! RedirectResult(GetAndReplaceLangStr($content['LN_DBMP_HASBEENEDIT'], DB_StripSlahes($content['DisplayName'])), "dbmappings.php"); } } else { $content['ISERROR'] = true; $content['ERROR_MSG'] = $content['LN_DBMP_ERROR_NOCOLUMNS']; } } } } } } } } } } }
DB_FreeQuery($result); // Do the final redirect RedirectResult(GetAndReplaceLangStr($content['LN_CHARTS_HASBEENADDED'], DB_StripSlahes($content['Name'])), "charts.php"); } else { if ($_POST['op'] == "editchart") { $result = DB_Query("SELECT ID FROM " . DB_CHARTS . " WHERE ID = " . $content['CHARTID']); $myrow = DB_GetSingleRow($result, true); if (!isset($myrow['ID'])) { $content['ISERROR'] = true; $content['ERROR_MSG'] = GetAndReplaceLangStr($content['LN_CHARTS_ERROR_IDNOTFOUND'], $content['CHARTID']); } else { $sqlquery = "UPDATE " . DB_CHARTS . " SET \n\t\t\t\t\t\t\t\tDisplayName = '" . $content['Name'] . "', \n\t\t\t\t\t\t\t\tchart_enabled = " . $content['chart_enabled'] . ", \n\t\t\t\t\t\t\t\tchart_type = " . $content['chart_type'] . ", \n\t\t\t\t\t\t\t\tchart_width = " . $content['chart_width'] . ", \n\t\t\t\t\t\t\t\tchart_field = '" . $content['chart_field'] . "',\n\t\t\t\t\t\t\t\tchart_defaultfilter = '" . $content['chart_defaultfilter'] . "',\n\t\t\t\t\t\t\t\tmaxrecords = " . $content['maxrecords'] . ", \n\t\t\t\t\t\t\t\tshowpercent = " . $content['showpercent'] . ", \n\t\t\t\t\t\t\t\tuserid = " . $content['userid'] . ", \n\t\t\t\t\t\t\t\tgroupid = " . $content['groupid'] . "\n\t\t\t\t\t\t\t\tWHERE ID = " . $content['CHARTID']; $result = DB_Query($sqlquery); DB_FreeQuery($result); // Done redirect! RedirectResult(GetAndReplaceLangStr($content['LN_CHARTS_HASBEENEDIT'], DB_StripSlahes($content['Name'])), "charts.php"); } } } } } if (!isset($_POST['op']) && !isset($_GET['op'])) { // Default Mode = List Searches $content['LISTCHARTS'] = "true"; // Copy Sources array for further modifications $content['CHARTS'] = $content['Charts']; // --- Process Sources $i = 0; // Help counter! foreach ($content['CHARTS'] as &$myChart) { // --- Set Image for Type
// Create Columnlist comma seperated! if (isset($_POST['Columns']) && is_array($_POST['Columns'])) { // Copy columns ID's unset($content['COLUMNS']); foreach ($_POST['Columns'] as $myColKey) { if (isset($content['COLUMNS'])) { $content['COLUMNS'] .= ", " . DB_RemoveBadChars($myColKey); } else { $content['COLUMNS'] = DB_RemoveBadChars($myColKey); } } // Edit the Search Entry now! $result = DB_Query("UPDATE " . DB_VIEWS . " SET \n\t\t\t\t\t\t\tDisplayName = '" . $content['DisplayName'] . "', \n\t\t\t\t\t\t\tColumns = '" . $content['COLUMNS'] . "', \n\t\t\t\t\t\t\tuserid = " . $content['userid'] . ", \n\t\t\t\t\t\t\tgroupid = " . $content['groupid'] . "\n\t\t\t\t\t\t\tWHERE ID = " . $content['VIEWID']); DB_FreeQuery($result); // Done redirect! RedirectResult(GetAndReplaceLangStr($content['LN_VIEWS_HASBEENEDIT'], DB_StripSlahes($content['DisplayName'])), "views.php"); } else { $content['ISERROR'] = true; $content['ERROR_MSG'] = $content['LN_VIEWS_ERROR_NOCOLUMNS']; } } } } } } } } } } if (!isset($_POST['op']) && !isset($_GET['op'])) { // Default Mode = List Searches
if (!isset($myrow['ID'])) { $content['ISERROR'] = true; $content['ERROR_MSG'] = GetAndReplaceLangStr($content['LN_SOURCES_ERROR_IDNOTFOUND'], $content['SOURCEID']); } else { // Edit the Search Entry now! if ($content['SourceType'] == SOURCE_DISK) { $sqlquery = "UPDATE " . DB_SOURCES . " SET \n\t\t\t\t\t\t\t\t\tName = '" . $content['Name'] . "', \n\t\t\t\t\t\t\t\t\tDescription = '" . $content['Description'] . "', \n\t\t\t\t\t\t\t\t\tSourceType = " . $content['SourceType'] . ", \n\t\t\t\t\t\t\t\t\tMsgParserList = '" . $content['MsgParserList'] . "', \n\t\t\t\t\t\t\t\t\tMsgNormalize = " . $content['MsgNormalize'] . ", \n\t\t\t\t\t\t\t\t\tMsgSkipUnparseable = " . $content['MsgSkipUnparseable'] . ", \n\t\t\t\t\t\t\t\t\tdefaultfilter = '" . $content['defaultfilter'] . "', \n\t\t\t\t\t\t\t\t\tViewID = '" . $content['SourceViewID'] . "', \n\t\t\t\t\t\t\t\t\tLogLineType = '" . $content['SourceLogLineType'] . "', \n\t\t\t\t\t\t\t\t\tDiskFile = '" . $content['SourceDiskFile'] . "', \n\t\t\t\t\t\t\t\t\tuserid = " . $content['userid'] . ", \n\t\t\t\t\t\t\t\t\tgroupid = " . $content['groupid'] . "\n\t\t\t\t\t\t\t\t\tWHERE ID = " . $content['SOURCEID']; } else { if ($content['SourceType'] == SOURCE_DB || $content['SourceType'] == SOURCE_PDO || $content['SourceType'] == SOURCE_MONGODB) { $sqlquery = "UPDATE " . DB_SOURCES . " SET \n\t\t\t\t\t\t\t\t\tName = '" . $content['Name'] . "', \n\t\t\t\t\t\t\t\t\tDescription = '" . $content['Description'] . "', \n\t\t\t\t\t\t\t\t\tSourceType = " . $content['SourceType'] . ", \n\t\t\t\t\t\t\t\t\tMsgParserList = '" . $content['MsgParserList'] . "', \n\t\t\t\t\t\t\t\t\tMsgNormalize = " . $content['MsgNormalize'] . ", \n\t\t\t\t\t\t\t\t\tMsgSkipUnparseable = " . $content['MsgSkipUnparseable'] . ", \n\t\t\t\t\t\t\t\t\tdefaultfilter = '" . $content['defaultfilter'] . "', \n\t\t\t\t\t\t\t\t\tViewID = '" . $content['SourceViewID'] . "', \n\t\t\t\t\t\t\t\t\tDBTableType = '" . $content['SourceDBTableType'] . "', \n\t\t\t\t\t\t\t\t\tDBType = " . $content['SourceDBType'] . ", \n\t\t\t\t\t\t\t\t\tDBServer = '" . $content['SourceDBServer'] . "', \n\t\t\t\t\t\t\t\t\tDBName = '" . $content['SourceDBName'] . "', \n\t\t\t\t\t\t\t\t\tDBUser = '******'SourceDBUser'] . "', \n\t\t\t\t\t\t\t\t\tDBPassword = '******'SourceDBPassword'] . "', \n\t\t\t\t\t\t\t\t\tDBTableName = '" . $content['SourceDBTableName'] . "', \n\t\t\t\t\t\t\t\t\tDBEnableRowCounting = " . $content['SourceDBEnableRowCounting'] . ", \n\t\t\t\t\t\t\t\t\tDBRecordsPerQuery = " . $content['SourceDBRecordsPerQuery'] . ", \n\t\t\t\t\t\t\t\t\tuserid = " . $content['userid'] . ", \n\t\t\t\t\t\t\t\t\tgroupid = " . $content['groupid'] . "\n\t\t\t\t\t\t\t\t\tWHERE ID = " . $content['SOURCEID']; } } $result = DB_Query($sqlquery); DB_FreeQuery($result); // Done redirect! RedirectResult(GetAndReplaceLangStr($content['LN_SOURCES_HASBEENEDIT'], DB_StripSlahes($content['Name'])), "sources.php"); } } } } } if (!isset($_POST['op']) && !isset($_GET['op'])) { // Default Mode = List Searches $content['LISTSOURCES'] = "true"; // Copy Sources array for further modifications $content['SOURCES'] = $content['Sources']; // --- Process Sources $i = 0; // Help counter! foreach ($content['SOURCES'] as &$mySource) { // --- Set Image for Type