X-Git-Url: https://git.mxchange.org/?a=blobdiff_plain;f=inc%2Fmysql-manager.php;h=39da8f2203a27fa9d7c66a114fdc03f01bb1ecad;hb=820a65d753f3103901bec03a93588044670684fa;hp=cedb715f33342b14c6ebe456728de9474d34ae98;hpb=43f8fab36af6c030d8835e1118cab430f8585e67;p=mailer.git
diff --git a/inc/mysql-manager.php b/inc/mysql-manager.php
index cedb715f33..39da8f2203 100644
--- a/inc/mysql-manager.php
+++ b/inc/mysql-manager.php
@@ -65,7 +65,7 @@ function ADD_MODULE_TITLE($mod) {
// Still no luck or empty title?
if (empty($name)) {
// No name found
- $name = LANG_UNKNOWN_MODULE." (".$mod.")";
+ $name = sprintf("%s (%s)", LANG_UNKNOWN_MODULE, $mod);
if (SQL_NUMROWS($result) == 0) {
// Add module to database
$dummy = CHECK_MODULE($mod);
@@ -77,7 +77,7 @@ function ADD_MODULE_TITLE($mod) {
}
// Check validity of a given module name (no file extension)
-function CHECK_MODULE($mod) {
+function CHECK_MODULE ($mod) {
// We need them now here...
global $cacheArray, $_CONFIG, $cacheInstance;
@@ -794,7 +794,7 @@ function SEND_MODE_MAILS($mod, $modes)
// Load hash
$result_main = SQL_QUERY_ESC("SELECT password FROM "._MYSQL_PREFIX."_user_data WHERE userid=%s AND status='CONFIRMED' LIMIT 1",
- array($GLOBALS['userid']), __FILE__, __LINE__);
+ array($GLOBALS['userid']), __FILE__, __LINE__);
if (SQL_NUMROWS($result_main) == 1) {
// Load hash from database
list($hashDB) = SQL_FETCHROW($result_main);
@@ -807,7 +807,7 @@ function SEND_MODE_MAILS($mod, $modes)
if (($hash == get_session('u_hash')) || ($_POST['pass1'] == $_POST['pass2'])) {
// Load user's data
$result = SQL_QUERY_ESC("SELECT gender, surname, family, street_nr, country, zip, city, email FROM "._MYSQL_PREFIX."_user_data WHERE userid=%s AND password='%s' LIMIT 1",
- array($GLOBALS['userid'], $hashDB), __FILE__, __LINE__);
+ array($GLOBALS['userid'], $hashDB), __FILE__, __LINE__);
if (SQL_NUMROWS($result) == 1) {
// Load the data
$DATA = SQL_FETCHROW($result);
@@ -842,13 +842,13 @@ function SEND_MODE_MAILS($mod, $modes)
DEBUG_LOG(__FUNCTION__, __LINE__, sprintf("Unknown mode %s detected.", $mode));
$content = MEMBER_UNKNOWN_MODE.": ".$mode."\n\n";
break;
- }
+ } // END - switch
} // END - if
if (EXT_IS_ACTIVE("country")) {
// Replace code with description
$DATA[4] = COUNTRY_GENERATE_INFO($_POST['country_code']);
- }
+ } // END - if
// Load template
$msg = LOAD_EMAIL_TEMPLATE("member_mydata_notify", $content, $GLOBALS['userid']);
@@ -867,32 +867,32 @@ function SEND_MODE_MAILS($mod, $modes)
$sub_mem = MEMBER_CHANGED_DATA;
// Output success message
- $content = "".MYDATA_MAIL_SENT."";
+ $content = "".MYDATA_MAIL_SENT."";
break;
default:
DEBUG_LOG(__FUNCTION__, __LINE__, sprintf("Unsupported module %s detected.", $mod));
- $content = "".UNKNOWN_MODULE."";
+ $content = "".UNKNOWN_MODULE."";
break;
- }
+ } // END - switch
} else {
// Could not load profile data
- $content = "".MEMBER_CANNOT_LOAD_PROFILE."";
+ $content = "".MEMBER_CANNOT_LOAD_PROFILE."";
}
} else {
// Passwords mismatch
- $content = "".MEMBER_PASSWORD_ERROR."";
+ $content = "".MEMBER_PASSWORD_ERROR."";
}
} else {
// Could not load profile
- $content = "".MEMBER_CANNOT_LOAD_PROFILE."";
+ $content = "".MEMBER_CANNOT_LOAD_PROFILE."";
}
// Send email to user if required
if ((!empty($sub_mem)) && (!empty($msg))) {
// Send member mail
SEND_EMAIL($DATA[7], $sub_mem, $msg);
- }
+ } // END - if
// Send only if no other error has occured
if (empty($content)) {
@@ -904,22 +904,20 @@ function SEND_MODE_MAILS($mod, $modes)
$content = CANNOT_SEND_ADMIN_MAILS;
} else {
// No mail to admin
- $content = "".MYDATA_MAIL_SENT."";
+ $content = "".MYDATA_MAIL_SENT."";
}
- }
+ } // END - if
// Load template
LOAD_TEMPLATE("admin_settings_saved", false, $content);
}
// Update module counter
-function COUNT_MODULE($mod)
-{
- if ($mod != "css")
- {
+function COUNT_MODULE($mod) {
+ if ($mod != "css") {
// Do count all other modules but not accesses on CSS file css.php!
$result = SQL_QUERY_ESC("UPDATE "._MYSQL_PREFIX."_mod_reg SET clicks=clicks+1 WHERE module='%s' LIMIT 1",
- array($mod), __FILE__, __LINE__);
- }
+ array($mod), __FILE__, __LINE__);
+ } // END - if
}
// Get action value from mode (admin/guest/member) and what-value
function GET_ACTION ($MODE, &$wht)
@@ -974,7 +972,8 @@ function GET_ACTION ($MODE, &$wht)
// Return action value
return $ret;
}
-//
+
+// Get category name back
function GET_CATEGORY ($cid) {
// Default is not found
$ret = _CATEGORY_404;
@@ -999,7 +998,8 @@ function GET_CATEGORY ($cid) {
// Return result
return $ret;
}
-//
+
+// Get a string of "mail title" and price back
function GET_PAYMENT ($pid, $full=false) {
// Default is not found
$ret = _PAYMENT_404;
@@ -1025,7 +1025,8 @@ function GET_PAYMENT ($pid, $full=false) {
// Return result
return $ret;
}
-//
+
+// Get (basicly) the price of given payment id
function GET_PAY_POINTS($pid, $lookFor="price")
{
$ret = "-1";
@@ -1039,8 +1040,9 @@ function GET_PAY_POINTS($pid, $lookFor="price")
}
return $ret;
}
+
// Remove a receiver's ID from $ARRAY and add a link for him to confirm
-function REMOVE_RECEIVER(&$ARRAY, $key, $uid, $pool_id, $stats_id="", $bonus=false)
+function REMOVE_RECEIVER (&$ARRAY, $key, $uid, $pool_id, $stats_id="", $bonus=false)
{
$ret = "failed";
if ($uid > 0)
@@ -1407,7 +1409,7 @@ WHERE sid='%s' LIMIT 1",
$result = SQL_QUERY_ESC("DELETE LOW_PRIORITY FROM "._MYSQL_PREFIX."_online WHERE timestamp <= (UNIX_TIMESTAMP() - %s)",
array($_CONFIG['online_timeout']), __FILE__, __LINE__);
}
-// OBSULETE: Sends out mail to all administrators
+// OBSOLETE: Sends out mail to all administrators
function SEND_ADMIN_EMAILS ($subj, $msg) {
// Load all admin email addresses
$result = SQL_QUERY("SELECT email FROM "._MYSQL_PREFIX."_admins ORDER BY id ASC", __FILE__, __LINE__);
@@ -1730,7 +1732,7 @@ function IS_DEMO() {
return ((EXT_IS_ACTIVE("demo")) && (get_session('admin_login') == "demo"));
}
//
-function LOAD_CONFIG($no="0") {
+function LOAD_CONFIG ($no="0") {
global $cacheArray;
$CFG_DUMMY = array();
@@ -1854,6 +1856,13 @@ function SUB_POINTS ($subject, $uid, $points) {
// Update config entries
function UPDATE_CONFIG ($entries, $values, $updateMode="") {
+ global $CSS;
+
+ // Do not update config in CSS mode
+ if (($CSS == "1") || ($CSS == -1)) {
+ return;
+ } // END - if
+
// Do we have multiple entries?
if (is_array($entries)) {
// Walk through all
@@ -1889,7 +1898,7 @@ function UPDATE_CONFIG ($entries, $values, $updateMode="") {
}
// Run database update
- //DEBUG_LOG(__FUNCTION__, __LINE__, "entries={$entries}");
+ //* DEBUG: */ DEBUG_LOG(__FUNCTION__, __LINE__, "entries={$entries}");
SQL_QUERY("UPDATE "._MYSQL_PREFIX."_config SET ".$entries." WHERE config=0 LIMIT 1", __FILE__, __LINE__);
// Get affected rows
@@ -1900,58 +1909,6 @@ function UPDATE_CONFIG ($entries, $values, $updateMode="") {
REBUILD_CACHE("config", "config");
}
-// Creates a new task for updated extension
-function CREATE_EXTENSION_UPDATE_TASK ($admin_id, $subject, $notes) {
- // Check if task is not there
- $result = SQL_QUERY_ESC("SELECT id FROM "._MYSQL_PREFIX."_task_system WHERE subject='%s' LIMIT 1",
- array($subject), __FILE__, __LINE__);
- if (SQL_NUMROWS($result) == 0) {
- // Task not created so it's a brand-new extension which we need to register and create a task for!
- $result = SQL_QUERY_ESC("INSERT INTO "._MYSQL_PREFIX."_task_system (assigned_admin, userid, status, task_type, subject, text, task_created) VALUES ('%s','0','NEW','EXTENSION_UPDATE','%s','%s', UNIX_TIMESTAMP())",
- array($admin_id, $subject, $notes), __FILE__, __LINE__);
- } // END - if
-
- // Free memory
- SQL_FREERESULT($result);
-}
-
-// Creates a new task for newly installed extension
-function CREATE_NEW_EXTENSION_TASK ($admin_id, $subject, $ext) {
- // Not installed and do we have created a task for the admin?
- $result = SQL_QUERY_ESC("SELECT `id` FROM `"._MYSQL_PREFIX."_task_system` WHERE `subject` LIKE '%s%%' LIMIT 1",
- array($subject), __FILE__, __LINE__);
- if ((SQL_NUMROWS($result) == 0) && (GET_EXT_VERSION($ext) == "")) {
- // Template file
- $tpl = sprintf("%stemplates/%s/html/ext/ext_%s.tpl",
- PATH,
- GET_LANGUAGE(),
- $ext
- );
-
- // Load text for task
- if (FILE_READABLE($tpl)) {
- // Load extension's own text template (HTML!)
- $msg = LOAD_TEMPLATE("ext_".$ext, true);
- } else {
- // Load default message
- $msg = LOAD_TEMPLATE("admin_new_ext", "", 0);
- }
-
- // Task not created so it's a brand-new extension which we need to register and create a task for!
- $result_insert = SQL_QUERY_ESC("INSERT INTO "._MYSQL_PREFIX."_task_system (assigned_admin, userid, status, task_type, subject, text, task_created)
-VALUES (%s,0,'NEW','EXTENSION','%s','%s',UNIX_TIMESTAMP())",
- array(
- $admin_id,
- $subject,
- SQL_ESCAPE($msg),
- ), __FILE__, __LINE__, true, false
- );
- } // END - if
-
- // Free memory
- SQL_FREERESULT($result);
-}
-
// Prepares an SQL statement part for HTML mail and/or holiday depency
function PREPARE_SQL_HTML_HOLIDAY ($mode) {
// Exclude no users by default