X-Git-Url: https://git.mxchange.org/?p=mailer.git;a=blobdiff_plain;f=inc%2Flibs%2Fregister_functions.php;h=1d36cd12a4ef0a28ea38fe35c27e3369fb50b7f8;hp=7a74af6a32c7fa7ce8ea36740aefe3302fbf1cb6;hb=c5e685ff1b1bd296243b9bfcd8921969fa09d53f;hpb=7f104f6fe558bb56b4205241435a2357c2feece1 diff --git a/inc/libs/register_functions.php b/inc/libs/register_functions.php index 7a74af6a32..1d36cd12a4 100644 --- a/inc/libs/register_functions.php +++ b/inc/libs/register_functions.php @@ -40,23 +40,22 @@ if (!defined('__SECURITY')) { // function REGISTER_FILL_MUST_CONSTANTS() { - $result = SQL_QUERY("SELECT field_name, field_required FROM "._MYSQL_PREFIX."_must_register ORDER BY id", __FILE__, __LINE__); - while(list($name, $required) = SQL_FETCHROW($result)) - { + $result = SQL_QUERY("SELECT field_name, field_required FROM `{!_MYSQL_PREFIX!}_must_register` ORDER BY `id`", __FILE__, __LINE__); + while (list($name, $required) = SQL_FETCHROW($result)) { $value = ""; - if ($required == "Y") $value = " (*)"; + if ($required == "Y") $value = "
 (*)
"; $eval = "define('MUST_".strtoupper($name)."', \"".$value."\");"; eval($eval); - } + } // END - while // Free memory SQL_FREERESULT($result); // Also fill other constants - define('MUST_GENDER', " (*)"); - define('MUST_ADDY' , " (*)"); - define('MUST_BIRTH' , " (*)"); - define('MUST_MARKER', " (*)"); + define('MUST_GENDER', "
 (*)
"); + define('MUST_ADDY' , "
 (*)
"); + define('MUST_BIRTH' , "
 (*)
"); + define('MUST_MARKER', "
 (*)
"); } // function REGISTER_CHECK_REQUIRED_FIELDS(&$array) @@ -64,7 +63,7 @@ function REGISTER_CHECK_REQUIRED_FIELDS(&$array) $ret = false; foreach ($array as $key => $value) { - $result = SQL_QUERY("SELECT field_required FROM "._MYSQL_PREFIX."_must_register WHERE field_name='".$key."' LIMIT 1", __FILE__, __LINE__); + $result = SQL_QUERY("SELECT field_required FROM `{!_MYSQL_PREFIX!}_must_register` WHERE field_name='".$key."' LIMIT 1", __FILE__, __LINE__); if (SQL_NUMROWS($result) == 1) { // "Must-line" found @@ -88,16 +87,14 @@ function REGISTER_CHECK_REQUIRED_FIELDS(&$array) // function REGISTER_OUTPUT_REQUIRE_CHECK(&$array) { - $result = SQL_QUERY("SELECT field_name, field_required FROM "._MYSQL_PREFIX."_must_register ORDER BY id", __FILE__, __LINE__); - while(list($name, $required) = SQL_FETCHROW($result)) + $result = SQL_QUERY("SELECT field_name, field_required FROM `{!_MYSQL_PREFIX!}_must_register` ORDER BY `id`", __FILE__, __LINE__); + while (list($name, $required) = SQL_FETCHROW($result)) { - if (($array[$name] == "!") && ($required == "Y")) - { + if (($array[$name] == "!") && ($required == "Y")) { // Empty entry found $array[$name] = ""; - $eval = "\$OUT = REGISTER_".strtoupper($name)."_REQUIRED;"; - eval($eval); - OUTPUT_HTML("".$OUT."

"); + $OUT = constant('REGISTER_'.strtoupper($name).'_REQUIRED'); + OUTPUT_HTML("
".$OUT."
"); } } @@ -105,24 +102,21 @@ function REGISTER_OUTPUT_REQUIRE_CHECK(&$array) SQL_FREERESULT($result); } // -function REGISTER_ADD_CATEGORY_TABLE ($MODE, $return=false) -{ - global $_POST, $_CONFIG; +function REGISTER_ADD_CATEGORY_TABLE ($MODE, $return=false) { $OUT = ""; // Guests are mostly not interested in how many members has // choosen an individual category - $AND = "WHERE visible='Y' "; + $AND = "WHERE `visible`='Y' "; + // Admins are allowed to see every category... if (IS_ADMIN()) $AND = ""; - $result = SQL_QUERY("SELECT id, cat, visible FROM "._MYSQL_PREFIX."_cats ".$AND." ORDER BY sort", __FILE__, __LINE__); - if (SQL_NUMROWS($result) > 0) - { + $result = SQL_QUERY("SELECT id, cat, visible FROM `{!_MYSQL_PREFIX!}_cats` ".$AND." ORDER BY `sort`", __FILE__, __LINE__); + if (SQL_NUMROWS($result) > 0) { // List alle visible modules (or all to the admin) $SW = 2; - $OUT .= "\n"; - while (list($id, $cat, $visible) = SQL_FETCHROW($result)) - { + $OUT .= "
\n"; + while (list($id, $cat, $visible) = SQL_FETCHROW($result)) { if (empty($_POST['cat'][$id])) $_POST['cat'][$id] = ""; // Prepare array for the template $content = array( @@ -133,7 +127,7 @@ function REGISTER_ADD_CATEGORY_TABLE ($MODE, $return=false) 'id' => $id, ); - if (($_POST['cat'][$id] == "Y") || (($_CONFIG['register_default'] == "Y") && (empty($_POST['cat'][$id])))) { + if (($_POST['cat'][$id] == "Y") || ((getConfig('register_default') == "Y") && (empty($_POST['cat'][$id])))) { $content['def_y'] = " checked=\"checked\""; } else { $content['def_n'] = " checked=\"checked\""; @@ -143,24 +137,19 @@ function REGISTER_ADD_CATEGORY_TABLE ($MODE, $return=false) $OUT .= LOAD_TEMPLATE("guest_cat_row", true, $content); $SW = 3 - $SW; } - $OUT .= "
\n"; + $OUT .= "\n"; // Free memory SQL_FREERESULT($result); - } - else - { + } else { // No categories setted up so far... - $OUT .= LOAD_TEMPLATE("admin_settings_saved", true, NO_CATEGORIES_VISIBLE); + $OUT .= LOAD_TEMPLATE("admin_settings_saved", true, getMessage('NO_CATEGORIES_VISIBLE')); } - if ($return) - { + if ($return) { // Return generated HTML code return $OUT; - } - else - { + } else { // Output directly (default) OUTPUT_HTML($OUT); }