if (isAdminRegistered()) {
// Redirect
// @TODO Why does this lead into an endless loop but we still need it???
- // @TODO Commented out LOAD_URL("admin.php");
+ // @TODO Commented out LOAD_URL('admin.php');
} // END - if
}
$ret = getMessage('_CATEGORY_404');
// Is the category id set?
- if ($cid == "0") {
+ if ($cid == '0') {
// No category
$ret = getMessage('_CATEGORY_NONE');
} elseif ($cid > 0) {
} else {
// Return title and price
list($t, $p) = SQL_FETCHROW($result);
- $ret = $t." / ".TRANSLATE_COMMA($p)." {!POINTS!}";
+ $ret = $t.' / '.TRANSLATE_COMMA($p).' {!POINTS!}';
}
}
}
// Get (basicly) the price of given payment id
-function GET_PAY_POINTS ($pid, $lookFor = "price") {
- $ret = "-1";
+function GET_PAY_POINTS ($pid, $lookFor = 'price') {
+ $ret = '-1';
$result = SQL_QUERY_ESC("SELECT %s FROM `{!_MYSQL_PREFIX!}_payments` WHERE id=%s LIMIT 1",
array($lookFor, $pid), __FUNCTION__, __LINE__);
if (SQL_NUMROWS($result) == 1) {
}
// 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) {
+function REMOVE_RECEIVER (&$receivers, $key, $uid, $pool_id, $stats_id='', $bonus=false) {
// Default is not removed
- $ret = "failed";
+ $ret = 'failed';
// Is the userid valid?
if ($uid > 0) {
// Is there already a line for this user available?
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'; }
+ $type = 'NORMAL'; $rowName = 'stats_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",
// 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__);
- $ret = "done";
+ $ret = 'done';
} else {
// Already found
- $ret = "already";
+ $ret = 'already';
}
// Free memory
}
// Calculate sum (default) or count records of given criteria
-function GET_TOTAL_DATA ($search, $tableName, $lookFor = "id", $whereStatement = 'userid', $countRows = false, $add = "") {
+function GET_TOTAL_DATA ($search, $tableName, $lookFor = 'id', $whereStatement = 'userid', $countRows = false, $add = '') {
$ret = 0;
- //* DEBUG: */ echo $search."/".$tableName."/".$lookFor."/".$whereStatement."/".$add."<br />\n";
- if ((empty($search)) && ($search != "0")) {
+ //* DEBUG: */ echo $search.'/'.$tableName.'/'.$lookFor.'/'.$whereStatement.'/'.$add.'<br />\n';
+ if ((empty($search)) && ($search != '0')) {
// Count or sum whole table?
if ($countRows === true) {
// Count whole table
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."" == "") {
+ $ret = '0.00000';
+ } elseif (''.$ret.'' == '') {
// Fix empty result
- $ret = "0";
+ $ret = '0';
}
// Return value
return $ret;
}
-// "Getter fro ref level percents
+// Getter fro ref level percents
function GET_REF_LEVEL_PERCENTS ($level) {
// Default is zero
$per = 0;
* add_mode = Add points only to $uid or also refs? (WARNING! Changing "ref" to "direct"
* for default value will cause no referal will get points ever!!!)
*/
-function ADD_POINTS_REFSYSTEM ($subject, $uid, $points, $send_notify=false, $rid="0", $locked=false, $add_mode="ref") {
+function ADD_POINTS_REFSYSTEM ($subject, $uid, $points, $send_notify=false, $rid='0', $locked=false, $add_mode='ref') {
//* DEBUG: */ print "----------------------- <font color=\"#00aa00\">".__FUNCTION__." - ENTRY</font> ------------------------<ul><li>\n";
global $DATA;
$add_mode = strtolower($add_mode);
// When $uid = 0 add points to jackpot
- if ($uid == "0") {
+ if ($uid == '0') {
// Add points to jackpot
ADD_JACKPOT($points);
return;
}
// Default is 'normal' points
- $data = "points";
+ $data = 'points';
// Which points, locked or normal?
- if ($locked) $data = "locked_points";
+ if ($locked) $data = 'locked_points';
// Check user account
$result_user = SQL_QUERY_ESC("SELECT refid, email FROM `{!_MYSQL_PREFIX!}_user_data` WHERE userid=%s AND `status`='CONFIRMED' LIMIT 1",
);
// Load email template
- $msg = LOAD_EMAIL_TEMPLATE("confirm-referal", $content, bigintval($uid));
+ $msg = LOAD_EMAIL_TEMPLATE('confirm-referal', $content, bigintval($uid));
SEND_EMAIL($email, THANX_REFERRAL_ONE, $msg);
} elseif (($send_notify) && ($ref == 0) && (!$locked) && ($add_mode == "direct") && (!defined('__POINTS_VALUE'))) {
);
// Load message
- $msg = LOAD_EMAIL_TEMPLATE("add-points", $content, $uid);
+ $msg = LOAD_EMAIL_TEMPLATE('add-points', $content, $uid);
// And sent it away
SEND_EMAIL($email, getMessage('SUBJECT_DIRECT_PAYMENT'), $msg);
}
// Maybe there's another ref?
- if (($ref > 0) && ($points > 0) && ($ref != $uid) && ($add_mode == "ref")) {
+ if (($ref > 0) && ($points > 0) && ($ref != $uid) && ($add_mode == 'ref')) {
// Then let's credit him here...
//* DEBUG: */ print __FUNCTION__."(<font color=\"#0000aa\">".__LINE__."</font>):uid={$uid},ref={$ref},points={$points} - ADVANCE!<br />\n";
ADD_POINTS_REFSYSTEM(sprintf("%s_ref:%s", $subject, $GLOBALS['ref_level']), $ref, $points, $send_notify, $ref, $locked);
} elseif ((($ref == $uid) || ($ref == 0)) && (GET_EXT_VERSION('cache') >= '0.1.2')) {
// Remove cache here
//* DEBUG: */ print __FUNCTION__."(<font color=\"#0000aa\">".__LINE__."</font>):ref={$ref} - CACHE!<br />\n";
- rebuildCacheFiles("refsystem", "refsystem");
+ rebuildCacheFiles('refsystem', 'refsystem');
}
// "Walk" back here
// Get ID number from administrator's login name
function GET_ADMIN_ID ($login) {
// By default no admin is found
- $ret = "-1";
+ $ret = '-1';
// Check cache
if (isset($GLOBALS['cache_array']['admins']['aid'][$login])) {
// Get password hash from administrator's login name
function GET_ADMIN_HASH ($aid) {
// By default an invalid hash is returned
- $ret = "-1";
+ $ret = '-1';
if (isset($GLOBALS['cache_array']['admins']['password'][$aid])) {
// Check cache
// Set cache
$GLOBALS['cache_array']['admins']['password'][$aid] = $ret;
- }
+ } // END - if
// Free result
SQL_FREERESULT($result);
//
function GET_ADMIN_LOGIN ($aid) {
// By default a non-existent login is returned (other functions react on this!)
- $ret = "***";
+ $ret = '***';
if (isset($GLOBALS['cache_array']['admins']['login'][$aid])) {
// Get cache
// Get email address of admin id
function GET_ADMIN_EMAIL ($aid) {
// By default an invalid emails is returned
- $ret = "***";
+ $ret = '***';
if (isset($GLOBALS['cache_array']['admins']['email'][$aid])) {
// Get cache
// Get default ACL of admin id
function GET_ADMIN_DEFAULT_ACL ($aid) {
// By default an invalid ACL value is returned
- $ret = "***";
+ $ret = '***';
// 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";
+ $ret = 'allow';
} elseif (isset($GLOBALS['cache_array']['admins']['def_acl'][$aid])) {
// Use cache
$ret = $GLOBALS['cache_array']['admins']['def_acl'][$aid];
return $ret;
}
//
-function ADD_OPTION_LINES ($table, $id, $name, $default="", $special="", $where="") {
+function ADD_OPTION_LINES ($table, $id, $name, $default='', $special='', $where='') {
$ret = '';
- if ($table == "/ARRAY/") {
+ if ($table == '/ARRAY/') {
// Selection from array
if (is_array($id) && is_array($name) && count($id) == count($name)) {
// Both are arrays
foreach ($id as $idx => $value) {
- $ret .= "<option value=\"".$value."\"";
+ $ret .= '<option value="' . $value . '"';
if ($default == $value) $ret .= ' selected="selected"';
- $ret .= ">".$name[$idx]."</option>\n";
+ $ret .= '>' . $name[$idx] . '</option>';
} // END - foreach
} // END - if
} else {
// Data from database
- $SPEC = ", ".$id;
- if (!empty($special)) $SPEC = ", ".$special;
+ $SPEC = ', '.$id;
+ if (!empty($special)) $SPEC = ', '.$special;
$ORDER = $name.$SPEC;
if ($table == 'country') $ORDER = $special;
$result = SQL_QUERY_ESC("SELECT %s, %s".$SPEC." FROM `{!_MYSQL_PREFIX!}_%s` ".$where." ORDER BY %s",
// @TODO Try to rewrite this to $content = SQL_FETCHARRAY()
while (list($value, $title, $add) = SQL_FETCHROW($result)) {
if (empty($special)) $add = '';
- $ret .= "<option value=\"".$value."\"";
+ $ret .= '<option value="' . $value . '"';
if ($default == $value) $ret .= ' selected="selected"';
- if (!empty($add)) $add = " (".$add.")";
- $ret .= ">".$title.$add."</option>\n";
+ if (!empty($add)) $add = ' ('.$add.')';
+ $ret .= '>' . $title . $add . '</option>';
} // END - while
// Free memory
SQL_FREERESULT($result);
} else {
// No data found
- $ret = "<option value=\"x\">{--SELECT_NONE--}</option>\n";
+ $ret = '<option value="x">{--SELECT_NONE--}</option>';
}
}
} // END - if
// Check total amount of users
- $totalUsers = GET_TOTAL_DATA("CONFIRMED", "user_data", 'userid', "status", true, " AND max_mails > 0");
+ $totalUsers = GET_TOTAL_DATA('CONFIRMED', 'user_data', 'userid', 'status', true, ' AND max_mails > 0');
if ($totalUsers >= getConfig('activate_xchange')) {
// Activate System
SET_SQLS(array(
"UPDATE `{!_MYSQL_PREFIX!}_mod_reg` SET `locked`='N', `hidden`='N', `mem_only`='Y' WHERE `module`='order' LIMIT 1",
- "UPDATE `{!_MYSQL_PREFIX!}_member_menu` SET `visible`='Y', `locked`='N' WHERE `what`='order' OR `what`='unconfirmed' LIMIT 2",
+ "UPDATE `{!_MYSQL_PREFIX!}_member_menu` SET `visible`='Y', `locked`='N' WHERE `what='order' OR `what`='unconfirmed' LIMIT 2",
"UPDATE `{!_MYSQL_PREFIX!}_config` SET activate_xchange='0' WHERE config=0 LIMIT 1"
));
runFilterChain('run_sqls');
// Rebuild caches
- rebuildCacheFiles("config", "config");
- rebuildCacheFiles("modreg", "modreg");
+ // @TODO Rewrite this to a filter
+ rebuildCacheFiles('config', 'config');
+ rebuildCacheFiles('modreg', 'modreg');
} // END - if
}
+
//
-function DELETE_USER_ACCOUNT($uid, $reason)
-{
+function DELETE_USER_ACCOUNT ($uid, $reason) {
$points = 0;
$result = SQL_QUERY_ESC("SELECT (SUM(p.points) - d.used_points) AS points
FROM `{!_MYSQL_PREFIX!}_user_points` AS p
//
function META_DESCRIPTION ($mod, $wht) {
// Exclude admin and member's area
- if (($mod != 'admin') && ($mod != "login")) {
+ if (($mod != 'admin') && ($mod != 'login')) {
// Construct dynamic description
- $DESCR = "{!MAIN_TITLE!} ".trim(getConfig('title_middle'))." ".ADD_DESCR('guest', "what-".$wht, true);
+ $DESCR = '{!MAIN_TITLE!} '.trim(getConfig('title_middle')).' '.ADD_DESCR('guest', 'what-'.$wht, true);
// Output it directly
- OUTPUT_HTML("<meta name=\"description\" content=\"".$DESCR."\" />");
+ OUTPUT_HTML('<meta name="description" content="' . $DESCR . '" />');
} // END - if
// Remove depth
//
function SUB_JACKPOT($points) {
// First failed
- $ret = "-1";
+ $ret = '-1';
// Get current points
$result = SQL_QUERY("SELECT points FROM `{!_MYSQL_PREFIX!}_jackpot` WHERE ok='ok' LIMIT 1", __FUNCTION__, __LINE__);
// Free memory
SQL_FREERESULT($result);
}
-//
+
+// Checks wether the extension demo is actuve and the admin login is demo (password needs to be demo, too!)
function IS_DEMO () {
return ((EXT_IS_ACTIVE('demo')) && (get_session('admin_login') == 'demo'));
}
switch ($modCheck)
{
case 'admin':
- $wht = "overview";
+ $wht = 'overview';
break;
- case "login":
+ case 'login':
case 'index':
- $wht = "welcome";
- if (($modCheck == 'index') && (getConfig('index_home') != "")) $wht = getConfig('index_home');
+ $wht = 'welcome';
+ if (($modCheck == 'index') && (getConfig('index_home') != '')) $wht = getConfig('index_home');
break;
default:
}
// Update config entries
-function UPDATE_CONFIG ($entries, $values, $updateMode="") {
+function UPDATE_CONFIG ($entries, $values, $updateMode='') {
// Do not update config in CSS mode
- if (($GLOBALS['output_mode'] == "1") || ($GLOBALS['output_mode'] == -1)) {
+ if (($GLOBALS['output_mode'] == '1') || ($GLOBALS['output_mode'] == -1)) {
return;
} // END - if
if (($values[$idx] + 0) === $values[$idx]) {
// Number detected
$all .= sprintf("%s=%s,", $entry, (float)$values[$idx]);
- } elseif ($values[$idx] == "UNIX_TIMESTAMP()") {
+ } elseif ($values[$idx] == 'UNIX_TIMESTAMP()') {
// Function UNIX_TIMESTAMP() detected
$all .= sprintf("%s=%s,", $entry, $values[$idx]);
} else {
//* DEBUG: */ print __FUNCTION__."(<font color=\"#0000aa\">".__LINE__."</font>):entries={$entries},affectedRows={$affectedRows}<br />\n";
// Rebuild cache
- rebuildCacheFiles("config", "config");
+ rebuildCacheFiles('config', 'config');
}
// Prepares an SQL statement part for HTML mail and/or holiday depency
$MORE = '';
// HTML mail?
- if ($mode == 'html') $MORE = " AND html='Y'";
+ if ($mode == 'html') $MORE = " AND `html`='Y'";
if (GET_EXT_VERSION('holiday') >= '0.1.3') {
// Add something for the holiday extension
- $MORE .= " AND holiday_active='N'";
+ $MORE .= " AND `holiday_active`='N'";
} // END - if
// Return result
$OUT = '';
foreach ($CATS['id'] as $key => $value) {
if (strlen($CATS['name'][$key]) > 20) $CATS['name'][$key] = substr($CATS['name'][$key], 0, 17)."...";
- $OUT .= " <option value=\"".$value."\">".$CATS['name'][$key]." (".$CATS['uids'][$key]." {--USER_IN_CAT--})</option>\n";
+ $OUT .= ' <option value="' . $value . '">' . $CATS['name'][$key] . ' (' . $CATS['uids'][$key] . ' {--USER_IN_CAT--})</option>';
} // END - foreach
} else {
// No cateogries are defined yet
- $OUT = "<option class=\"member_failed\">{!MEMBER_NO_CATS!}</option>\n";
+ $OUT = '<option class="member_failed">{!MEMBER_NO_CATS!}</option>';
}
// Return HTML code
// HTML extension active?
if (EXT_IS_ACTIVE('html_mail')) {
// No HTML by default
- $HTML = "N";
+ $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`
// Exclude users in holiday?
if (GET_EXT_VERSION('holiday') >= '0.1.3') {
// Add something for the holiday extension
- $CAT_WHERE .= " AND d.holiday_active='N'";
+ $CAT_WHERE .= " AND d.`holiday_active`='N'";
} // END - if
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",
+ $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__);
} else {
// Include all
// Do we have nickname extension installed?
if (EXT_IS_ACTIVE('nickname')) {
- $add = ", ud.nickname";
+ $add = ', ud.nickname';
} // END - if
// Get refs from database
// Fetch all entries
while ($row = SQL_FETCHARRAY($result)) {
// Get total points of this user
- $row['points'] = GET_TOTAL_DATA($row['refid'], "user_points", "points") - GET_TOTAL_DATA($row['refid'], "user_data", "used_points");
+ $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;