+ if ((!EXT_IS_ACTIVE($content['action'])) || ($content['action'] == 'online')) OUTPUT_HTML("
");
}
//* DEBUG: */ echo __LINE__."/".$main_cnt."/".$content['action']."/".$content['sub_what'].":".$GLOBALS['what']."* \n";
@@ -485,7 +485,7 @@ function ADD_MENU ($MODE, $act, $wht) {
// This patched function will reduce many SELECT queries for the specified or current admin login
function IS_ADMIN ($admin="") {
// Init variables
- $ret = false; $passCookie = ""; $valPass = "";
+ $ret = false; $passCookie = ''; $valPass = '';
//* DEBUG: */ echo __LINE__."ADMIN:".$admin." ";
// If admin login is not given take current from cookies...
@@ -509,13 +509,13 @@ function IS_ADMIN ($admin="") {
// Count cache hits
incrementConfigEntry('cache_hits');
- } elseif ((!empty($admin)) && ((!EXT_IS_ACTIVE("cache"))) || (!isset($GLOBALS['cache_array']['admins']['password'][$admin]))) {
+ } elseif ((!empty($admin)) && ((!EXT_IS_ACTIVE('cache'))) || (!isset($GLOBALS['cache_array']['admins']['password'][$admin]))) {
// Search for admin
$result = SQL_QUERY_ESC("SELECT HIGH_PRIORITY password FROM `{!_MYSQL_PREFIX!}_admins` WHERE login='%s' LIMIT 1",
array($admin), __FUNCTION__, __LINE__);
// Is he admin?
- $passDB = "";
+ $passDB = '';
if (SQL_NUMROWS($result) == 1) {
// Admin login was found so let's load password from DB
list($passDB) = SQL_FETCHROW($result);
@@ -534,7 +534,7 @@ function IS_ADMIN ($admin="") {
if (!empty($valPass)) {
// Check if password is valid
//* DEBUG: */ print __FUNCTION__."*".$valPass."/".$passCookie."* \n";
- $ret = (($valPass == $passCookie) || ((strlen($valPass) == 32) && ($valPass == md5($passCookie))) || (($valPass == "*FAILED*") && (!EXT_IS_ACTIVE("cache"))));
+ $ret = (($valPass == $passCookie) || ((strlen($valPass) == 32) && ($valPass == md5($passCookie))) || (($valPass == "*FAILED*") && (!EXT_IS_ACTIVE('cache'))));
}
// Return result of comparision
@@ -544,17 +544,17 @@ function IS_ADMIN ($admin="") {
// Generates a list of "max receiveable emails per day"
function ADD_MAX_RECEIVE_LIST ($MODE, $default = "", $return = false) {
- $OUT = "";
+ $OUT = '';
$result = false;
switch ($MODE) {
- case "guest":
+ case 'guest':
// Guests (in the registration form) are not allowed to select 0 mails per day.
$result = SQL_QUERY("SELECT value, comment FROM `{!_MYSQL_PREFIX!}_max_receive` WHERE value > 0 ORDER BY value",
__FUNCTION__, __LINE__);
break;
- case "member":
+ case 'member':
// Members are allowed to set to zero mails per day (we will change this soon!)
$result = SQL_QUERY("SELECT value, comment FROM `{!_MYSQL_PREFIX!}_max_receive` ORDER BY value",
__FUNCTION__, __LINE__);
@@ -567,7 +567,7 @@ function ADD_MAX_RECEIVE_LIST ($MODE, $default = "", $return = false) {
// Some entries are found?
if (SQL_NUMROWS($result) > 0) {
- $OUT = "";
+ $OUT = '';
while ($content = SQL_FETCHARRAY($result)) {
$OUT .= " \n";
- if (($MODE != "admin") && ($UPDATE === true)) {
+ if (($MODE != 'admin') && ($UPDATE === true)) {
// Update guest or member menu
- $sql = SQL_QUERY_ESC("UPDATE `{!_MYSQL_PREFIX!}_%s_menu` SET counter=counter+1 WHERE `action`='%s' AND `what`='%s'".$ADD." LIMIT 1",
+ $sql = SQL_QUERY_ESC("UPDATE `{!_MYSQL_PREFIX!}_%s_menu` SET counter=counter+1 WHERE `action`='%s' AND `what`='%s'".$add." LIMIT 1",
array($MODE, $act, $wht), __FUNCTION__, __LINE__, false);
} elseif (($wht != "overview") && (!empty($wht))) {
// Other actions
- $sql = SQL_QUERY_ESC("SELECT id, what FROM `{!_MYSQL_PREFIX!}_%s_menu` WHERE `action`='%s' AND `what`='%s'".$ADD." ORDER BY action DESC LIMIT 1",
+ $sql = SQL_QUERY_ESC("SELECT id, what FROM `{!_MYSQL_PREFIX!}_%s_menu` WHERE `action`='%s' AND `what`='%s'".$add." ORDER BY action DESC LIMIT 1",
array($MODE, $act, $wht), __FUNCTION__, __LINE__, false);
} else {
// Admin login overview
- $sql = SQL_QUERY_ESC("SELECT id, what FROM `{!_MYSQL_PREFIX!}_%s_menu` WHERE `action`='%s' AND (what='' OR `what` IS NULL)".$ADD." ORDER BY action DESC LIMIT 1",
+ $sql = SQL_QUERY_ESC("SELECT id, what FROM `{!_MYSQL_PREFIX!}_%s_menu` WHERE `action`='%s' AND (`what`='' OR `what` IS NULL)".$add." ORDER BY action DESC LIMIT 1",
array($MODE, $act), __FUNCTION__, __LINE__, false);
}
@@ -786,22 +787,22 @@ function SEND_MODE_MAILS($mod, $modes) {
$DATA[0] = TRANSLATE_GENDER($DATA[0]);
// Clear/init the content variable
- $content = "";
- $DATA['info'] = "";
+ $content = '';
+ $DATA['info'] = '';
switch ($mod)
{
- case "mydata":
+ case 'mydata':
foreach ($modes as $mode) {
switch ($mode)
{
- case "normal": break; // Do not add any special lines
+ case 'normal': break; // Do not add any special lines
- case "email": // Email was changed!
+ case 'email': // Email was changed!
$content = MEMBER_CHANGED_EMAIL.": ".REQUEST_POST('old_addy')."\n";
break;
- case "pass": // Password was changed
+ case 'pass': // Password was changed
$content = MEMBER_CHANGED_PASS."\n";
break;
@@ -812,7 +813,7 @@ function SEND_MODE_MAILS($mod, $modes) {
} // END - switch
} // END - if
- if (EXT_IS_ACTIVE("country")) {
+ if (EXT_IS_ACTIVE('country')) {
// Replace code with description
$DATA[4] = COUNTRY_GENERATE_INFO(REQUEST_POST('country_code'));
} // END - if
@@ -820,14 +821,14 @@ function SEND_MODE_MAILS($mod, $modes) {
// Load template
$msg = LOAD_EMAIL_TEMPLATE("member_mydata_notify", $content, getUserId());
- if (getConfig('admin_notify') == "Y") {
+ if (getConfig('admin_notify') == 'Y') {
// The admin needs to be notified about a profile change
$msg_admin = "admin_mydata_notify";
$sub_adm = ADMIN_CHANGED_DATA;
} else {
// No mail to admin
- $msg_admin = "";
- $sub_adm = "";
+ $msg_admin = '';
+ $sub_adm = '';
}
// Set subject lines
@@ -866,7 +867,7 @@ function SEND_MODE_MAILS($mod, $modes) {
if ((!empty($sub_adm)) && (!empty($msg_admin))) {
// Send admin mail
SEND_ADMIN_NOTIFICATION($sub_adm, $msg_admin, $content, getUserId());
- } elseif (getConfig('admin_notify') == "Y") {
+ } elseif (getConfig('admin_notify') == 'Y') {
// Cannot send mails to admin!
$content = getMessage('CANNOT_SEND_ADMIN_MAILS');
} else {
@@ -876,14 +877,14 @@ function SEND_MODE_MAILS($mod, $modes) {
} // END - if
// Load template
- LOAD_TEMPLATE("admin_settings_saved", false, $content);
+ LOAD_TEMPLATE('admin_settings_saved', false, $content);
}
// Update module counter
function countModuleHit($mod) {
if ($mod != "css") {
// Do count all other modules but not accesses on CSS file css.php!
- SQL_QUERY_ESC("UPDATE `{!_MYSQL_PREFIX!}_mod_reg` SET clicks=clicks+1 WHERE module='%s' LIMIT 1",
+ SQL_QUERY_ESC("UPDATE `{!_MYSQL_PREFIX!}_mod_reg` SET clicks=clicks+1 WHERE `module`='%s' LIMIT 1",
array($mod), __FUNCTION__, __LINE__);
} // END - if
}
@@ -891,15 +892,15 @@ function countModuleHit($mod) {
// Get action value from mode (admin/guest/member) and what-value
function GET_ACTION ($MODE, &$wht) {
// Init status
- $ret = "";
+ $ret = '';
//* DEBUG: */ echo __LINE__."=".$MODE."/".$wht."/".$GLOBALS['action']."= ";
- if ((empty($wht)) && ($MODE != "admin")) {
+ if ((empty($wht)) && ($MODE != 'admin')) {
$wht = "welcome";
if (getConfig('index_home') != "") $wht = getConfig('index_home');
} // END - if
- if ($MODE == "admin") {
+ if ($MODE == 'admin') {
// Action value for admin area
if (REQUEST_ISSET_GET('action')) {
// Use from request!
@@ -921,8 +922,8 @@ function GET_ACTION ($MODE, &$wht) {
if (MODULE_HAS_MENU($MODE)) {
// Rewriting modules to menu
switch ($MODE) {
- case "index": $MODE = "guest"; break;
- case "login": $MODE = "member"; break;
+ case 'index': $MODE = 'guest'; break;
+ case "login": $MODE = 'member'; break;
} // END - switch
// Guest and member menu is "main" as the default
@@ -938,12 +939,12 @@ function GET_ACTION ($MODE, &$wht) {
// Free memory
SQL_FREERESULT($result);
- } elseif ((GET_EXT_VERSION("sql_patches") == "") && ($MODE != "admin")) {
+ } elseif ((GET_EXT_VERSION('sql_patches') == "") && ($MODE != 'admin')) {
// No sql_patches installed, but maybe we need to register an admin?
if (isAdminRegistered()) {
// Redirect
// @TODO Why does this lead into an endless loop but we still need it???
- // Commented out LOAD_URL("admin.php");
+ // @TODO Commented out LOAD_URL("admin.php");
} // END - if
}
@@ -1017,31 +1018,33 @@ 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) {
+// Remove a receiver's ID from $receivers and add a link for him to confirm
+function REMOVE_RECEIVER (&$receivers, $key, $uid, $pool_id, $stats_id="", $bonus=false) {
+ // Default is not removed
$ret = "failed";
- if ($uid > 0)
- {
+
+ // Is the userid valid?
+ if ($uid > 0) {
// Remove entry from array
- unset($ARRAY[$key]);
+ unset($receivers[$key]);
// Is there already a line for this user available?
- if ($stats_id > 0)
- {
+ if ($stats_id > 0) {
// Only when we got a real stats ID continue searching for the entry
$type = "NORMAL"; $rowName = "stats_id";
- if ($bonus) { $type = "BONUS"; $rowName = "bonus_id"; }
+ if ($bonus) { $type = "BONUS"; $rowName = 'bonus_id'; }
+
+ // Try to look the entry up
$result = SQL_QUERY_ESC("SELECT id FROM `{!_MYSQL_PREFIX!}_user_links` WHERE %s='%s' AND userid=%s AND link_type='%s' LIMIT 1",
- array($rowName, $stats_id, bigintval($uid), $type), __FUNCTION__, __LINE__);
- if (SQL_NUMROWS($result) == 0)
- {
- // No, so we add one!
+ array($rowName, $stats_id, bigintval($uid), $type), __FUNCTION__, __LINE__);
+
+ // Was it *not* found?
+ if (SQL_NUMROWS($result) == 0) {
+ // So we add one!
SQL_QUERY_ESC("INSERT INTO `{!_MYSQL_PREFIX!}_user_links` (%s, userid, link_type) VALUES ('%s','%s','%s')",
- array($rowName, $stats_id, bigintval($uid), $type), __FUNCTION__, __LINE__);
+ array($rowName, $stats_id, bigintval($uid), $type), __FUNCTION__, __LINE__);
$ret = "done";
- }
- else
- {
+ } else {
// Already found
$ret = "already";
}
@@ -1050,15 +1053,27 @@ function REMOVE_RECEIVER (&$ARRAY, $key, $uid, $pool_id, $stats_id="", $bonus=fa
SQL_FREERESULT($result);
}
}
+
// Return status for sending routine
return $ret;
}
// Calculate sum (default) or count records of given criteria
-function GET_TOTAL_DATA ($search, $tableName, $lookFor, $whereStatement="userid", $onlyRows=false, $add="") {
+function GET_TOTAL_DATA ($search, $tableName, $lookFor = "id", $whereStatement = 'userid', $countRows = false, $add = "") {
$ret = 0;
//* DEBUG: */ echo $search."/".$tableName."/".$lookFor."/".$whereStatement."/".$add." \n";
- if (($onlyRows) || ($lookFor == "userid")) {
+ if ((empty($search)) && ($search != "0")) {
+ // Count or sum whole table?
+ if ($countRows === true) {
+ // Count whole table
+ $result = SQL_QUERY_ESC("SELECT COUNT(`%s`) FROM `{!_MYSQL_PREFIX!}_%s`".$add,
+ array($lookFor, $tableName), __FUNCTION__, __LINE__);
+ } else {
+ // Sum whole table
+ $result = SQL_QUERY_ESC("SELECT SUM(`%s`) FROM `{!_MYSQL_PREFIX!}_%s`".$add,
+ array($lookFor, $tableName), __FUNCTION__, __LINE__);
+ }
+ } elseif (($countRows === true) || ($lookFor == 'userid')) {
// Count rows
//* DEBUG: */ echo "COUNT! \n";
$result = SQL_QUERY_ESC("SELECT COUNT(`%s`) FROM `{!_MYSQL_PREFIX!}_%s` WHERE `%s`='%s'".$add,
@@ -1077,7 +1092,7 @@ function GET_TOTAL_DATA ($search, $tableName, $lookFor, $whereStatement="userid"
SQL_FREERESULT($result);
// Fix empty values
- if ((empty($ret)) && ($lookFor != "counter") && ($lookFor != "id") && ($lookFor != "userid")) {
+ if ((empty($ret)) && ($lookFor != "counter") && ($lookFor != "id") && ($lookFor != 'userid')) {
// Float number
$ret = "0.00000";
} elseif ("".$ret."" == "") {
@@ -1094,7 +1109,7 @@ function GET_REF_LEVEL_PERCENTS ($level) {
$per = 0;
// Do we have cache?
- if ((isset($GLOBALS['cache_array']['ref_depths']['level'])) && (EXT_IS_ACTIVE("cache"))) {
+ if ((isset($GLOBALS['cache_array']['ref_depths']['level'])) && (EXT_IS_ACTIVE('cache'))) {
// First look for level
$key = array_search($level, $GLOBALS['cache_array']['ref_depths']['level']);
if ($key !== false) {
@@ -1104,7 +1119,7 @@ function GET_REF_LEVEL_PERCENTS ($level) {
// Count cache hit
incrementConfigEntry('cache_hits');
}
- } elseif (!EXT_IS_ACTIVE("cache")) {
+ } elseif (!EXT_IS_ACTIVE('cache')) {
// Get referal data
$result_lvl = SQL_QUERY_ESC("SELECT percents FROM `{!_MYSQL_PREFIX!}_refdepths` WHERE level='%s' LIMIT 1",
array(bigintval($level)), __FUNCTION__, __LINE__);
@@ -1150,9 +1165,9 @@ function ADD_POINTS_REFSYSTEM ($subject, $uid, $points, $send_notify=false, $rid
} // END - if
// Add booking record if extension is installed
- if (EXT_IS_ACTIVE("booking")) {
+ if (EXT_IS_ACTIVE('booking')) {
// Add record
- ADD_BOOKING_RECORD($subject, $uid, $points, "add");
+ ADD_BOOKING_RECORD($subject, $uid, $points, 'add');
} // END - if
// Count up referal depth
@@ -1166,7 +1181,7 @@ function ADD_POINTS_REFSYSTEM ($subject, $uid, $points, $send_notify=false, $rid
//* DEBUG: */ print __FUNCTION__."(".__LINE__."): Referal level increased. DEPTH={$GLOBALS['ref_level']} \n";
}
- // Default is "normal" points
+ // Default is 'normal' points
$data = "points";
// Which points, locked or normal?
@@ -1193,7 +1208,7 @@ function ADD_POINTS_REFSYSTEM ($subject, $uid, $points, $send_notify=false, $rid
$ref_points = $points * $per / 100;
// Pay refback here if level > 0 and in ref-mode
- if ((EXT_IS_ACTIVE("refback")) && ($GLOBALS['ref_level'] > 0) && ($per < 100) && ($add_mode == "ref") && (isset($GLOBALS['cache_array']['add_uid'][$uid]))) {
+ if ((EXT_IS_ACTIVE('refback')) && ($GLOBALS['ref_level'] > 0) && ($per < 100) && ($add_mode == "ref") && (isset($GLOBALS['cache_array']['add_uid'][$uid]))) {
//* DEBUG: */ print __FUNCTION__."(".__LINE__."):uid={$uid},data={$GLOBALS['cache_array']['add_uid'][$uid]},ref_points={$ref_points},depth={$GLOBALS['ref_level']} - BEFORE! \n";
$ref_points = ADD_REFBACK_POINTS($GLOBALS['cache_array']['add_uid'][$uid], $uid, $points, $ref_points);
//* DEBUG: */ print __FUNCTION__."(".__LINE__."):uid={$uid},data={$GLOBALS['cache_array']['add_uid'][$uid]},ref_points={$ref_points},depth={$GLOBALS['ref_level']} - AFTER! \n";
@@ -1213,9 +1228,9 @@ function ADD_POINTS_REFSYSTEM ($subject, $uid, $points, $send_notify=false, $rid
} // END - if
// Update mediadata as well
- if (GET_EXT_VERSION("mediadata") >= "0.0.4") {
+ if (GET_EXT_VERSION('mediadata') >= '0.0.4') {
// Update database
- MEDIA_UPDATE_ENTRY(array("total_points"), "add", $ref_points);
+ MEDIA_UPDATE_ENTRY(array('total_points'), 'add', $ref_points);
} // END - if
// Points updated, maybe I shall send him an email?
@@ -1247,7 +1262,7 @@ function ADD_POINTS_REFSYSTEM ($subject, $uid, $points, $send_notify=false, $rid
// And sent it away
SEND_EMAIL($email, getMessage('SUBJECT_DIRECT_PAYMENT'), $msg);
- if (!REQUEST_ISSET_GET(('mid'))) LOAD_TEMPLATE("admin_settings_saved", false, getMessage('ADMIN_POINTS_ADDED'));
+ if (!REQUEST_ISSET_GET(('mid'))) LOAD_TEMPLATE('admin_settings_saved', false, getMessage('ADMIN_POINTS_ADDED'));
}
// Maybe there's another ref?
@@ -1298,7 +1313,7 @@ function UPDATE_REF_COUNTER ($uid) {
// Move to next referal level and count his counter one up!
//* DEBUG: */ print __FUNCTION__."(".__LINE__."):ref={$ref} - ADVANCE! \n";
$GLOBALS['cache_array']['ref_level'][$uid]++; UPDATE_REF_COUNTER($ref);
- } elseif ((($ref == $uid) || ($ref == 0)) && (GET_EXT_VERSION("cache") >= "0.1.2")) {
+ } elseif ((($ref == $uid) || ($ref == 0)) && (GET_EXT_VERSION('cache') >= '0.1.2')) {
// Remove cache here
//* DEBUG: */ print __FUNCTION__."(".__LINE__."):ref={$ref} - CACHE! \n";
rebuildCacheFiles("refsystem", "refsystem");
@@ -1308,7 +1323,7 @@ function UPDATE_REF_COUNTER ($uid) {
$GLOBALS['cache_array']['ref_level'][$uid]--;
// Handle refback here if extension is installed
- if (EXT_IS_ACTIVE("refback")) {
+ if (EXT_IS_ACTIVE('refback')) {
UPDATE_REFBACK_table($uid);
} // END - if
}
@@ -1341,7 +1356,7 @@ function GET_ADMIN_ID ($login) {
// Update cache hits
incrementConfigEntry('cache_hits');
- } elseif (!EXT_IS_ACTIVE("cache")) {
+ } elseif (!EXT_IS_ACTIVE('cache')) {
// Load from database
$result = SQL_QUERY_ESC("SELECT id FROM `{!_MYSQL_PREFIX!}_admins` WHERE login='%s' LIMIT 1",
array($login), __FUNCTION__, __LINE__);
@@ -1378,7 +1393,7 @@ function GET_ADMIN_HASH ($aid) {
// Update cache hits
incrementConfigEntry('cache_hits');
- } elseif (!EXT_IS_ACTIVE("cache")) {
+ } elseif (!EXT_IS_ACTIVE('cache')) {
// Load from database
$result = SQL_QUERY_ESC("SELECT password FROM `{!_MYSQL_PREFIX!}_admins` WHERE id=%s LIMIT 1",
array($aid), __FUNCTION__, __LINE__);
@@ -1406,7 +1421,7 @@ function GET_ADMIN_LOGIN ($aid) {
// Update cache hits
incrementConfigEntry('cache_hits');
- } elseif (!EXT_IS_ACTIVE("cache")) {
+ } elseif (!EXT_IS_ACTIVE('cache')) {
// Load from database
$result = SQL_QUERY_ESC("SELECT login FROM `{!_MYSQL_PREFIX!}_admins` WHERE id=%s LIMIT 1",
array(bigintval($aid)), __FUNCTION__, __LINE__);
@@ -1434,7 +1449,7 @@ function GET_ADMIN_EMAIL ($aid) {
// Update cache hits
incrementConfigEntry('cache_hits');
- } elseif (!EXT_IS_ACTIVE("cache")) {
+ } elseif (!EXT_IS_ACTIVE('cache')) {
// Load from database
$result_aid = SQL_QUERY_ESC("SELECT email FROM `{!_MYSQL_PREFIX!}_admins` WHERE id=%s LIMIT 1",
array(bigintval($aid)), __FUNCTION__, __LINE__);
@@ -1458,13 +1473,17 @@ function GET_ADMIN_DEFAULT_ACL ($aid) {
// By default an invalid ACL value is returned
$ret = "***";
- if (isset($GLOBALS['cache_array']['admins']['def_acl'][$aid])) {
+ // Is sql_patches there and was it found in cache?
+ if (!EXT_IS_ACTIVE('sql_patches')) {
+ // Not found, which is bad, so we need to allow all
+ $ret = "allow";
+ } elseif (isset($GLOBALS['cache_array']['admins']['def_acl'][$aid])) {
// Use cache
$ret = $GLOBALS['cache_array']['admins']['def_acl'][$aid];
// Update cache hits
incrementConfigEntry('cache_hits');
- } elseif (!EXT_IS_ACTIVE("cache")) {
+ } elseif (!EXT_IS_ACTIVE('cache')) {
// Load from database
$result_aid = SQL_QUERY_ESC("SELECT default_acl FROM `{!_MYSQL_PREFIX!}_admins` WHERE id=%s LIMIT 1",
array(bigintval($aid)), __FUNCTION__, __LINE__);
@@ -1485,7 +1504,7 @@ function GET_ADMIN_DEFAULT_ACL ($aid) {
}
//
function ADD_OPTION_LINES ($table, $id, $name, $default="", $special="", $where="") {
- $ret = "";
+ $ret = '';
if ($table == "/ARRAY/") {
// Selection from array
if (is_array($id) && is_array($name) && count($id) == count($name)) {
@@ -1501,14 +1520,14 @@ function ADD_OPTION_LINES ($table, $id, $name, $default="", $special="", $where=
$SPEC = ", ".$id;
if (!empty($special)) $SPEC = ", ".$special;
$ORDER = $name.$SPEC;
- if ($table == "country") $ORDER = $special;
+ if ($table == 'country') $ORDER = $special;
$result = SQL_QUERY_ESC("SELECT %s, %s".$SPEC." FROM `{!_MYSQL_PREFIX!}_%s` ".$where." ORDER BY %s",
array($id, $ORDER, $table, $name), __FUNCTION__, __LINE__);
if (SQL_NUMROWS($result) > 0) {
// Found data so add them as OPTION lines: $id is the value and $name is the "name" of the option
// @TODO Try to rewrite this to $content = SQL_FETCHARRAY()
while (list($value, $title, $add) = SQL_FETCHROW($result)) {
- if (empty($special)) $add = "";
+ if (empty($special)) $add = '';
$ret .= "\n";
@@ -1862,18 +1887,18 @@ WHERE userid=%s AND `status`='CONFIRMED' AND receive_mails > 0".PREPARE_SQL_HTML
}
// Add bonus mail to queue
-function ADD_BONUS_MAIL_TO_QUEUE ($subject, $text, $receiverList, $points, $seconds, $url, $cat, $mode="normal", $receiver=0) {
+function ADD_BONUS_MAIL_TO_QUEUE ($subject, $text, $receiverList, $points, $seconds, $url, $cat, $mode='normal', $receiver=0) {
// Is admin or bonus extension there?
if (!IS_ADMIN()) {
// Abort here
return false;
- } elseif (!EXT_IS_ACTIVE("bonus")) {
+ } elseif (!EXT_IS_ACTIVE('bonus')) {
// Abort here
return false;
}
// Calculcate target sent
- $target = SELECTION_COUNT(explode(";", $receiverList));
+ $target = SELECTION_COUNT(explode(';', $receiverList));
// Receiver is zero?
if ($receiver == 0) {
@@ -1882,12 +1907,12 @@ function ADD_BONUS_MAIL_TO_QUEUE ($subject, $text, $receiverList, $points, $seco
} // END - if
// HTML extension active?
- if (EXT_IS_ACTIVE("html")) {
+ if (EXT_IS_ACTIVE('html_mail')) {
// No HTML by default
$HTML = "N";
// HTML mode?
- if ($mode == "html") $HTML = "Y";
+ if ($mode == 'html') $HTML = "Y";
// Add HTML mail
SQL_QUERY_ESC("INSERT INTO `{!_MYSQL_PREFIX!}_bonus`
@@ -1928,8 +1953,8 @@ VALUES ('%s','%s','%s','%s','%s','NEW', UNIX_TIMESTAMP(),'%s','%s','%s','%s')",
function GENERATE_RECEIVER_LIST ($cat, $receiver, $mode="") {
// Init variables
$CAT_TABS = "%s";
- $CAT_WHERE = "";
- $receiverList = "";
+ $CAT_WHERE = '';
+ $receiverList = '';
$result = false;
// Secure data
@@ -1950,12 +1975,12 @@ function GENERATE_RECEIVER_LIST ($cat, $receiver, $mode="") {
} // END - if
// Exclude users in holiday?
- if (GET_EXT_VERSION("holiday") >= "0.1.3") {
+ if (GET_EXT_VERSION('holiday') >= '0.1.3') {
// Add something for the holiday extension
$CAT_WHERE .= " AND d.holiday_active='N'";
} // END - if
- if ((EXT_IS_ACTIVE("html_mail")) && ($mode == "html")) {
+ if ((EXT_IS_ACTIVE('html_mail')) && ($mode == 'html')) {
// Only include HTML receivers
$result = SQL_QUERY_ESC("SELECT d.userid FROM `{!_MYSQL_PREFIX!}_user_data` AS d ".$CAT_TABS." WHERE d.`status`='CONFIRMED' AND d.html='Y'".$CAT_WHERE." ORDER BY d.%s %s LIMIT %s",
array($cat, getConfig('order_select'), getConfig('order_mode'), $receiver), __FUNCTION__, __LINE__);
@@ -1970,7 +1995,7 @@ function GENERATE_RECEIVER_LIST ($cat, $receiver, $mode="") {
// Load all entries
while ($content = SQL_FETCHARRAY($result)) {
// Add receiver when not empty
- if (!empty($content['userid'])) $receiverList .= $content['userid'].";";
+ if (!empty($content['userid'])) $receiverList .= $content['userid'] . ';';
} // END - while
// Free memory
@@ -1995,7 +2020,7 @@ function USER_STATS_GET_TIMESTAMP ($type, $data, $uid = 0) {
} // END - if
// Is the extension installed and updated?
- if ((!EXT_IS_ACTIVE("sql_patches")) || (EXT_VERSION_IS_OLDER("sql_patches", "0.5.6"))) {
+ if ((!EXT_IS_ACTIVE('sql_patches')) || (EXT_VERSION_IS_OLDER('sql_patches', '0.5.6'))) {
// Return zero here
return $stamp;
} // END - if
@@ -2023,7 +2048,7 @@ LIMIT 1",
// Inserts user stats
function USER_STATS_INSERT_RECORD ($uid, $type, $data) {
// Is the extension installed and updated?
- if ((!EXT_IS_ACTIVE("sql_patches")) || (EXT_VERSION_IS_OLDER("sql_patches", "0.5.6"))) {
+ if ((!EXT_IS_ACTIVE('sql_patches')) || (EXT_VERSION_IS_OLDER('sql_patches', '0.5.6'))) {
// Return zero here
return false;
} // END - if
@@ -2043,16 +2068,16 @@ function USER_STATS_INSERT_RECORD ($uid, $type, $data) {
function GET_USER_REF_POINTS ($uid, $level) {
//* DEBUG: */ print "----------------------- ".__FUNCTION__." - ENTRY ------------------------
\n";
// Default is no refs and no nickname
- $ADD = "";
+ $add = '';
$refs = array();
// Do we have nickname extension installed?
- if (EXT_IS_ACTIVE("nickname")) {
- $ADD = ", ud.nickname";
+ if (EXT_IS_ACTIVE('nickname')) {
+ $add = ", ud.nickname";
} // END - if
// Get refs from database
- $result = SQL_QUERY_ESC("SELECT ur.id, ur.refid, ud.status, ud.last_online, ud.mails_confirmed, ud.emails_received".$ADD."
+ $result = SQL_QUERY_ESC("SELECT ur.id, ur.refid, ud.status, ud.last_online, ud.mails_confirmed, ud.emails_received".$add."
FROM `{!_MYSQL_PREFIX!}_user_refs` AS ur
LEFT JOIN `{!_MYSQL_PREFIX!}_user_points` AS up
ON ur.refid=up.userid AND ur.level=0
@@ -2070,7 +2095,7 @@ ORDER BY ur.refid ASC",
$row['points'] = GET_TOTAL_DATA($row['refid'], "user_points", "points") - GET_TOTAL_DATA($row['refid'], "user_data", "used_points");
// Get unconfirmed mails
- $row['unconfirmed'] = GET_TOTAL_DATA($row['refid'], "user_links", "id", "userid", true);
+ $row['unconfirmed'] = GET_TOTAL_DATA($row['refid'], "user_links", "id", 'userid', true);
// Init clickrate with zero
$row['clickrate'] = 0;
@@ -2081,11 +2106,11 @@ ORDER BY ur.refid ASC",
$row['clickrate'] = ($row['mails_confirmed'] / $row['emails_received'] * 100);
} // END - if
- // Activity is "active" by default because if autopurge is not installed
+ // Activity is 'active' by default because if autopurge is not installed
$row['activity'] = MEMBER_ACTIVITY_ACTIVE;
// Is autopurge installed and the user inactive?
- if ((EXT_IS_ACTIVE("autopurge")) && ((time() - getConfig('ap_inactive_since')) >= $row['last_online'])) {
+ if ((EXT_IS_ACTIVE('autopurge')) && ((time() - getConfig('ap_inactive_since')) >= $row['last_online'])) {
// Inactive user!
$row['activity'] = MEMBER_ACTIVITY_INACTIVE;
} // END - if