- $INC = substr(dirname(__FILE__), 0, strpos(dirname(__FILE__), "/inc") + 4) . "/security.php";
+ $INC = substr(dirname(__FILE__), 0, strpos(dirname(__FILE__), '/inc') + 4) . '/security.php';
- addFatalMessage(__FILE__, __LINE__, getMessage('EXTENSION_PROBLEM_EXT_INACTIVE'), 'mediadata');
+ addFatalMessage(__FILE__, __LINE__, generateExtensionInactiveNotInstalledMessage('mediadata'));
ADD_DESCR('guest', __FILE__);
// @TODO Rewrite all constants
ADD_DESCR('guest', __FILE__);
// @TODO Rewrite all constants
-define('user_confirmed' , round(GET_TOTAL_DATA("CONFIRMED" , "user_data", 'userid', "status", true)));
-define('user_unconfirmed', round(GET_TOTAL_DATA("UNCONFIRMED", "user_data", 'userid', "status", true)));
-define('user_locked' , round(GET_TOTAL_DATA("LOCKED" , "user_data", 'userid', "status", true)));
+define('user_confirmed' , round(GET_TOTAL_DATA('CONFIRMED' , 'user_data', 'userid', 'status', true)));
+define('user_unconfirmed', round(GET_TOTAL_DATA('UNCONFIRMED', 'user_data', 'userid', 'status', true)));
+define('user_locked' , round(GET_TOTAL_DATA('LOCKED' , 'user_data', 'userid', 'status', true)));
define('user_count' , (constant('user_confirmed') + constant('user_unconfirmed') + constant('user_locked')));
// Start of this exchange
define('user_count' , (constant('user_confirmed') + constant('user_unconfirmed') + constant('user_locked')));
// Start of this exchange
// Projected number of members
define('__MT_STAGE', getConfig('mt_stage'));
// Projected number of members
define('__MT_STAGE', getConfig('mt_stage'));
-$TEST = MAKE_TIME(0, 0, 0, $PROJECTED);
+$TEST = makeTime(0, 0, 0, $PROJECTED);
} else {
define('__MT_PROJECTED', getMessage('USER_PROJECTION_UNKNOWN'));
}
// User who can receive mails
} else {
define('__MT_PROJECTED', getMessage('USER_PROJECTION_UNKNOWN'));
}
// User who can receive mails
-$result_max = SQL_QUERY("SELECT COUNT(max_mails) FROM `{!_MYSQL_PREFIX!}_user_data` WHERE `status`='CONFIRMED' AND max_mails > 0", __FILE__, __LINE__);
-list($dummy) = SQL_FETCHROW($result_max);
-SQL_FREERESULT($result_max);
-define('user_max_mails', $dummy);
+define('user_max_mails', GET_TOTAL_DATA('CONFIRMED', 'user_data' 'max_mails', 'status', true, " AND `max_mails` > 0"));
-$result_rec = SQL_QUERY("SELECT COUNT(receive_mails) FROM `{!_MYSQL_PREFIX!}_user_data` WHERE `status`='CONFIRMED' AND receive_mails > 0", __FILE__, __LINE__);
-list($dummy) = SQL_FETCHROW($result_rec);
-SQL_FREERESULT($result_rec);
-define('user_max_rec', $dummy);
+define('user_max_rec', GET_TOTAL_DATA('CONFIRMED', 'user_data', 'receive_mails', 'status', true, " AND `receive_mails` > 0"));
-define('max', GET_TOTAL_DATA("CONFIRMED", "user_data", "max_mails", "status", false, " AND `max_mails` > 0"));
+define('max', GET_TOTAL_DATA('CONFIRMED', 'user_data', 'max_mails', 'status', false, " AND `max_mails` > 0"));
-define('rec', GET_TOTAL_DATA("CONFIRMED", "user_data", "receive_mails", "status", false, " AND `receive_mails` > 0"));
+define('rec', GET_TOTAL_DATA('CONFIRMED', 'user_data', 'receive_mails', 'status', false, " AND `receive_mails` > 0"));
// Initial lots of variables
$bmails = 0; $sent = 0; $max = 0; $rec = 0; $clicks = 0;
// Mail orders (only current)
// Initial lots of variables
$bmails = 0; $sent = 0; $max = 0; $rec = 0; $clicks = 0;
// Mail orders (only current)
if (empty($sent)) $sent = 0;
if (empty($clicks)) $clicks = 0;
// Bonus mails
if (EXT_IS_ACTIVE('bonus')) {
if (empty($sent)) $sent = 0;
if (empty($clicks)) $clicks = 0;
// Bonus mails
if (EXT_IS_ACTIVE('bonus')) {
if (empty($dmy)) $dmy = 0;
if (empty($dmy2)) $dmy2 = 0;
$sent += $dmy2; $clicks += $dmy;
if (empty($dmy)) $dmy = 0;
if (empty($dmy2)) $dmy2 = 0;
$sent += $dmy2; $clicks += $dmy;
-$result = SQL_QUERY("SELECT points FROM `{!_MYSQL_PREFIX!}_jackpot` WHERE ok='ok' LIMIT 1", __FILE__, __LINE__);
+$result = SQL_QUERY("SELECT `points` FROM `{!_MYSQL_PREFIX!}_jackpot` WHERE `ok`='ok' LIMIT 1", __FILE__, __LINE__);
// Total referal link clicks, total logins
$result = SQL_QUERY("SELECT DISTINCT SUM(d.ref_clicks), SUM(d.total_logins)
// Total referal link clicks, total logins
$result = SQL_QUERY("SELECT DISTINCT SUM(d.ref_clicks), SUM(d.total_logins)
define('__TOTAL_REFCLICKS', $ref);
define('__TOTAL_LOGINS' , $logins);
// Referal banner
define('__TOTAL_REFCLICKS', $ref);
define('__TOTAL_LOGINS' , $logins);
// Referal banner
-$result = SQL_QUERY("SELECT COUNT(id) FROM `{!_MYSQL_PREFIX!}_refbanner` WHERE `visible`='Y'", __FILE__, __LINE__);
-list($total) = SQL_FETCHROW($result);
-SQL_FREERESULT($result);
-$result = SQL_QUERY("SELECT SUM(counter), SUM(clicks) FROM `{!_MYSQL_PREFIX!}_refbanner` WHERE `visible`='Y'", __FILE__, __LINE__);
+$total = GET_TOTAL_DATA('Y', 'refbanner', 'id', 'visible', true);
+
+// Total views and clicks
+$result = SQL_QUERY("SELECT SUM(`counter`) AS cnt, SUM(`clicks`) AS clx FROM `{!_MYSQL_PREFIX!}_refbanner` WHERE `visible`='Y'", __FILE__, __LINE__);
// Add first line (count)
$content = array(
'lang' => getMessage('MEDIA_DOUBLER_COUNT'),
'value' => $count1,
// Add first line (count)
$content = array(
'lang' => getMessage('MEDIA_DOUBLER_COUNT'),
'value' => $count1,
if (empty($holiday)) $holiday = 0;
$content = array(
'lang' => getMessage('MEDIA_HOLIDAY_COUNT'),
'value' => $holiday
);
if (empty($holiday)) $holiday = 0;
$content = array(
'lang' => getMessage('MEDIA_HOLIDAY_COUNT'),
'value' => $holiday
);
define('__EXTRA_MEDIADATA' , $OUT_EXTRA);
define('__POINTS_MEDIADATA' , $OUT_POINTS);
define('__EXTRA_MEDIADATA' , $OUT_EXTRA);
define('__POINTS_MEDIADATA' , $OUT_POINTS);
// Patch level and it's timespamp
define('__PATCH_LEVEL', getConfig('patch_level'));
// Patch level and it's timespamp
define('__PATCH_LEVEL', getConfig('patch_level'));