|
-
June 4th, 2019, 11:31 AM
#1
 This code won't work. Need a second mind to look at it.
I'm having trouble with this code I wrote. I know for a fact I wrote it all correctly but for some very odd reason ( which must be something very simple I am overlooking ) it just won't update the data in the sql row. It doesn't it even show the message that it can't do it. what am I doing wrong here??
Code:
<?php
/*
===========================================================================================
+ Cerberus Content Management System.
+ ---
+ - Author : Gary Christopher Johnson
+ - E-Mail : TinkeSoftware@Protonmail.com // GCJohnsonChevalier@Protonmail.com
+ - Company: Tinke Software
+ - Notes : Please view this file in Notepad or similar for proper indentation display
+ ---
+
+
+
+
+
+
+
+
+
+
+
+ ---
+ - File Location: root->Module->Administration->Settings
+ - File Version: 0.4 - Sunday, March, 24, 2019
+ ---
+%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%
+%%%()()%%()()()%%()()()%%()()()%%()()()%%()()()%%()%%()%%%%%%()()()%%%%%%%%%%%%
+%%()%%%%%()%%%%%%()%%()%%()%%()%%()%%%%%%()%%()%%()%%()%%%%%%()%%%%%%%%%%%%%%%%
+%%()%%%%%()%%%%%%()%%()%%()%%()%%()%%%%%%()%%()%%()%%()%%%%%%()%%%%%%%%%%%%%%%%
+%%()%%%%%()%%%%%%()%%()%%()%%()%%()%%%%%%()%%()%%()%%()%%%%%%()%%%%%%%%%%%%%%%%
+%%()%%%%%()()()%%()()()%%()()()%%()()()%%()()()%%()%%()%%%%%%()%%%%%%%%%%%%%%%%
+%%()%%%%%()%%%%%%()%%()%%()%%()%%()%%%%%%()%%()%%()%%()%%%%%%()%%%%%%%%%%%%%%%%
+%%()%%%%%()%%%%%%()%%()%%()%%()%%()%%%%%%()%%()%%()%%()%%%%%%()%%%%%%%%%%%%/-\%
+%%()%%%%%()%%%%%%()%%()%%()%%()%%()%%%%%%()%%()%%()%%()%%%%%%()%%%%%%%%%%%%|4|%
+%%%()()%%()()()%%()%%()%%()()()%%()()()%%()%%()%%()()()%%()()()%%%%%%%%%%%%\-/% Build 0.6
===========================================================================================
*/
/*
===========================
+
+
+ Update System Settings
+
+
===========================
*/
/*
===========================
+
+ DB Query Select Settings Entries
+
===========================
*/
$_Module_Settings_DB_Query_SELECT_SETTINGS = $DB->query("SELECT * FROM {$_ACCESS_DATABASE_PREFIX}_settings ORDER BY id ASC LIMIT 1");
while ($_Module_Settings_DB_Query_SELECT_SETTINGS_Fetch_Array = $DB->fetch_array($_Module_Settings_DB_Query_SELECT_SETTINGS)) {
/*
===========================
+ List Settings Entries
===========================
*/
$_Module_Settings_LIST_SETTING_SAFEHTML_DIRECTORY = $_Module_Settings_DB_Query_SELECT_SETTINGS_Fetch_Array['settings_safeHTML_directory'];
$_Module_Settings_LIST_SETTING_SAFEHTML_STATUS = $_Module_Settings_DB_Query_SELECT_SETTINGS_Fetch_Array['settings_safeHTML_status'];
$_Module_Settings_LIST_SETTING_COOKIE_TIME = $_Module_Settings_DB_Query_SELECT_SETTINGS_Fetch_Array['settings_cookie_time'];
$_Module_Settings_LIST_SETTING_GZIP_STATUS = $_Module_Settings_DB_Query_SELECT_SETTINGS_Fetch_Array['settings_gzip'];
$_Module_Settings_LIST_SETTING_IMAGE_EXTENSION = $_Module_Settings_DB_Query_SELECT_SETTINGS_Fetch_Array['settings_image_extension'];
$_Module_Settings_LIST_SETTING_LANGUAGE_DIRECTORY = $_Module_Settings_DB_Query_SELECT_SETTINGS_Fetch_Array['settings_language_directory'];
$_Module_Settings_LIST_SETTING_OFFLINE_STATUS = $_Module_Settings_DB_Query_SELECT_SETTINGS_Fetch_Array['settings_offline_status'];
$_Module_Settings_LIST_SETTING_SITE_TITLE = $_Module_Settings_DB_Query_SELECT_SETTINGS_Fetch_Array['settings_site_title'];
$_Module_Settings_LIST_SETTING_SMILES_DIRECTORY = $_Module_Settings_DB_Query_SELECT_SETTINGS_Fetch_Array['settings_smiles_directory'];
$_Module_Settings_LIST_SETTING_SOUND_EXTENSION = $_Module_Settings_DB_Query_SELECT_SETTINGS_Fetch_Array['settings_sound_extension'];
$_Module_Settings_LIST_SETTING_THEME_DIRECTORY = $_Module_Settings_DB_Query_SELECT_SETTINGS_Fetch_Array['settings_theme_directory'];
$_Module_Settings_LIST_SETTING_UPLOAD_SIZE_PRIVATE = $_Module_Settings_DB_Query_SELECT_SETTINGS_Fetch_Array['settings_upload_size_private'];
$_Module_Settings_LIST_SETTING_UPLOAD_SIZE_PUBLIC = $_Module_Settings_DB_Query_SELECT_SETTINGS_Fetch_Array['settings_upload_size_public'];
/*
===========================
+
+ Settings Update Form Post Variables
+
===========================
*/
$_Module_Settings_POST_UPDATE_SAFEHTML_DIRECTORY = $_POST['Module_Settings_SafeHTML_Directory'];
$_Module_Settings_POST_UPDATE_SAFEHTML_STATUS = $_POST['Module_Settings_SafeHTML_Status'];
$_Module_Settings_POST_UPDATE_COOKIE_TIME = $_POST['Module_Settings_Session_Time'];
$_Module_Settings_POST_UPDATE_GZIP_STATUS = $_POST['Module_Settings_GZIP_Compression'];
$_Module_Settings_POST_UPDATE_IMAGE_EXTENSION = $_POST['Module_Settings_Image_Extension'];
$_Module_Settings_POST_UPDATE_LANGUAGE_DIRECTORY = $_POST['Module_Settings_Language_Directory'];
$_Module_Settings_POST_UPDATE_OFFLINE_STATUS = $_POST['Module_Settings_Offline_Status'];
$_Module_Settings_POST_UPDATE_SITE_TITLE = $_POST['Module_Settings_Site_Title'];
$_Module_Settings_POST_UPDATE_SMILEY_DIRECTORY = $_POST['Module_Settings_Smiley_Directory'];
$_Module_Settings_POST_UPDATE_SOUND_EXTENSION = $_POST['Module_Settings_Sound_Extension'];
$_Module_Settings_POST_UPDATE_THEME_DIRECTORY = $_POST['Module_Settings_Theme_Directory'];
$_Module_Settings_POST_UPDATE_UPLOAD_PRIVATE = $_POST['Module_Settings_Upload_Size_Private'];
$_Module_Settings_POST_UPDATE_UPLOAD_PUBLIC = $_POST['Module_Settings_Upload_Size_Public'];
/*
===========================
+
+ Settings Update Form
+
===========================
*/
echo ("
<CENTER><B>System Settings</B></CENTER><HR>
<FORM ACTION=\"?$_INTERNAL_ADMINISTRATOR_MODULE=cPanel&Action=Settings\" METHOD=\"post\">
Safe-HTML Application Directory:<BR>
<INPUT TYPE=\"text\" NAME=\"Module_Settings_SafeHTML_Directory\" VALUE=\"$_Module_Settings_LIST_SETTING_SAFEHTML_DIRECTORY\" MAXLENGTH=\"50\"><BR><BR>
Safe-HTML Application Status: [ Current: $_Module_Settings_LIST_SETTING_SAFEHTML_STATUS ]<BR>
<SELECT NAME=\"Module_Settings_SafeHTML_status\">
<OPTION VALUE=\"1\">1: On</OPTION>
<OPTION VALUE=\"0\">0: Off</OPTION>
</SELECT><BR><BR>
Cookie / Session Time Expiration: [ In Seconds ]<BR>
<INPUT TYPE=\"text\" NAME=\"Module_Settings_Session_Time\" VALUE=\"$_Module_Settings_LIST_SETTING_COOKIE_TIME\" MAXLENGTH=\"10\"><BR><BR>
GZIP Compression: [ Current: $_Module_Settings_LIST_SETTING_GZIP_STATUS ]<BR>
<SELECT NAME=\"Module_Settings_GZIP_Compression\">
<OPTION VALUE=\"1\">1: On</OPTION>
<OPTION VALUE=\"0\">0: Off</OPTION>
</SELECT><BR><BR>
Image Extension:<BR>
<INPUT TYPE=\"text\" NAME=\"Module_Settings_Image_Extension\" VALUE=\"$_Module_Settings_LIST_SETTING_IMAGE_EXTENSION\" MAXLENGTH=\"3\"><BR><BR>
Language Directory:<BR>
<INPUT TYPE=\"text\" NAME=\"Module_Settings_Language_Directory\" VALUE=\"$_Module_Settings_LIST_SETTING_LANGUAGE_DIRECTORY\" MAXLENGTH=\"50\"><BR><BR>
OFFLINE Mode Status: [ Current: $_Module_Settings_LIST_SETTING_OFFLINE_STATUS ]<BR>
<SELECT NAME=\"Module_Settings_Offline_Status\">
<OPTION VALUE=\"0\">0: Off</OPTION>
<OPTION VALUE=\"1\">1: On</OPTION>
</SELECT><BR><BR>
Website Title:<BR>
<INPUT TYPE=\"text\" NAME=\"Module_Settings_Site_Title\" VALUE=\"$_Module_Settings_LIST_SETTING_SITE_TITLE\" MAXLENGTH=\"250\"><BR><BR>
Smiley-Face(s) Application Directory:<BR>
<INPUT TYPE=\"text\" NAME=\"Module_Settings_Smiley_Directory\" VALUE=\"$_Module_Settings_LIST_SETTING_SMILES_DIRECTORY\" MAXLENGTH=\"50\"><BR><BR>
Sound Extension:<BR>
<INPUT TYPE=\"text\" NAME=\"Module_Settings_Sound_Extension\" VALUE=\"$_Module_Settings_LIST_SETTING_SOUND_EXTENSION\" MAXLENGTH=\"$_Module_Settings_LIST_SETTING_SOUND_EXTENSION\"><BR><BR>
Theme Directory:<BR>
<SELECT NAME=\"Module_Settings_Theme_Directory\">
");
/*
===========================
+ Update Theme Directory
===========================
*/
$_Module_Settings_SPECIFY_THEME_DIRECTORY = "./Theme/";
$_Module_Settings_OPEN_THEME_DIRECTORY = opendir($_Module_Settings_SPECIFY_THEME_DIRECTORY);
while (($_Module_Settings_READ_THEME_DIRECTORY = readdir($_Module_Settings_OPEN_THEME_DIRECTORY))) {
if ($_Module_Settings_READ_THEME_DIRECTORY == "." || $_Module_Settings_READ_THEME_DIRECTORY == ".." || $_Module_Settings_READ_THEME_DIRECTORY == "index.php") {
/**
* Do Nothing
**/
} else {
echo ("<OPTION VALUE=\"$_Module_Settings_READ_THEME_DIRECTORY\">$_Module_Settings_READ_THEME_DIRECTORY</OPTION>");
} // [ + ] IF_NOT_DIRECTORY || FILE
} // [ + ] WHILE_DIRECTORY
/*
===========================
+ Close Directory
===========================
*/
closedir($_Module_Settings_OPEN_THEME_DIRECTORY);
echo ("
</SELECT><BR><BR>
Upload Size Limit: [ Private Uploader [ Members ] In Bytes ]<BR>
<INPUT TYPE=\"text\" NAME=\"Module_Settings_Upload_Size_Private\" VALUE=\"$_Module_Settings_LIST_SETTING_UPLOAD_SIZE_PRIVATE\" MAXLENGTH=\"15\"><BR><BR>
Upload Size Limit: [ Public Uploader [ Members ] In Bytes ]<BR>
<INPUT TYPE=\"text\" NAME=\"Module_Settings_Upload_Size_Public\" VALUE=\"$_Module_Settings_LIST_SETTING_UPLOAD_SIZE_PUBLIC\" MAXLENGTH=\"15\"><BR>
<INPUT TYPE=\"submit\" VALUE=\"Update Settings\">
</FORM>
");
/*
===========================
+
+ If Update Settings SQL Query
+
===========================
*/
if ($_Module_Settings_POST_UPDATE_UPLOAD_PUBLIC) {
$_Module_Settings_DB_Query_UPDATE_SETTINGS = $DB->query("UPDATE {$_ACCESS_DATABASE_PREFIX}_settings SET
settings_safeHTML_directory='$_Module_Settings_POST_UPDATE_SAFEHTML_DIRECTORY',
settings_safeHTML_status='$_Module_Settings_POST_UPDATE_SAFEHTML_STATUS',
settings_cookie_time='$_Module_Settings_POST_UPDATE_COOKIE_TIME',
settings_gzip='$_Module_Settings_POST_UPDATE_GZIP_STATUS',
settings_image_extension='$_Module_Settings_POST_UPDATE_IMAGE_EXTENSION',
settings_language_directory='$_Module_Settings_POST_UPDATE_LANGUAGE_DIRECTORY',
settings_offline_status='$_Module_Settings_POST_UPDATE_OFFLINE_STATUS',
settings_site_title='$_Module_Settings_POST_UPDATE_SITE_TITLE',
settings_smiles_directory='$_Module_Settings_POST_UPDATE_SMILEY_DIRECTORY',
settings_sound_extension='$_Module_Settings_POST_UPDATE_SOUND_EXTENSION',
settings_theme_directory='$_Module_Settings_POST_UPDATE_THEME_DIRECTORY',
settings_upload_size_private='$_Module_Settings_POST_UPDATE_UPLOAD_PRIVATE',
settings_upload_size_public='$_Module_Settings_POST_UPDATE_UPLOAD_PUBLIC'
WHERE id='1'");
if ($_Module_Settings_DB_Query_UPDATE_SETTINGS) {
echo ("<CENTER>Cerberus: I have Updated the System Settings successfully.</CENTER>");
} else {
echo ($_MSG_ERROR_ACTION_UNIVERSAL);
} // [ + ] IF_DB_Query
/*
===========================
+ Kill SQL Query
===========================
*/
$DB->free($_Module_Settings_DB_Query_UPDATE_SETTINGS);
} // [ + ] IF_POST_UPDATE
/*
===========================
+ Kill SQL Query
===========================
*/
} // [ + ] WHILE_READ_SQL_Settings
$DB->free($_Module_Settings_DB_Query_SELECT_SETTINGS);
?>
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|
Reply With Quote