- $INC = substr(dirname(__FILE__), 0, strpos(dirname(__FILE__), "/inc") + 4) . "/security.php";
+ $INC = substr(dirname(__FILE__), 0, strpos(dirname(__FILE__), '/inc') + 4) . '/security.php';
-} elseif ((!EXT_IS_ACTIVE("mediadata")) && (!IS_ADMIN())) {
- addFatalMessage(__FILE__, __LINE__, getMessage('EXTENSION_PROBLEM_EXT_INACTIVE'), "mediadata");
+} elseif ((!EXT_IS_ACTIVE('mediadata')) && (!IS_ADMIN())) {
+ addFatalMessage(__FILE__, __LINE__, generateExtensionInactiveNotInstalledMessage('mediadata'));
-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);
-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($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;
// Load jackpot
$result = SQL_QUERY("SELECT points FROM `{!_MYSQL_PREFIX!}_jackpot` WHERE ok='ok' LIMIT 1", __FILE__, __LINE__);
list($jackpot) = SQL_FETCHROW($result);
SQL_FREERESULT($result);
if (empty($jackpot)) $jackpot = 0;
// Load jackpot
$result = SQL_QUERY("SELECT points FROM `{!_MYSQL_PREFIX!}_jackpot` WHERE ok='ok' LIMIT 1", __FILE__, __LINE__);
list($jackpot) = SQL_FETCHROW($result);
SQL_FREERESULT($result);
if (empty($jackpot)) $jackpot = 0;
// 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)
if (empty($points)) $points = 0;
if (empty($ref)) $ref = 0;
if (empty($logins)) $logins = 0;
if (empty($points)) $points = 0;
if (empty($ref)) $ref = 0;
if (empty($logins)) $logins = 0;
define('__TOTAL_REFCLICKS', $ref);
define('__TOTAL_LOGINS' , $logins);
define('__TOTAL_REFCLICKS', $ref);
define('__TOTAL_LOGINS' , $logins);
-$OUT_EXTRA = ""; $ROWS_EXTRA = 2;
-$OUT_POINTS = ""; $ROWS_POINTS = 2;
-$OUT_USER = ""; $ROWS_USER = 6;
-$OUT_SPECIAL = ""; // We don't need row count here
+$OUT_EXTRA = ''; $ROWS_EXTRA = 2;
+$OUT_POINTS = ''; $ROWS_POINTS = 2;
+$OUT_USER = ''; $ROWS_USER = 6;
+$OUT_SPECIAL = ''; // We don't need row count here
// Clicks on beg links
$result = SQL_QUERY("SELECT SUM(beg_clicks) FROM `{!_MYSQL_PREFIX!}_user_data` WHERE beg_clicks>0", __FILE__, __LINE__);
list($extra) = SQL_FETCHROW($result);
// Clicks on beg links
$result = SQL_QUERY("SELECT SUM(beg_clicks) FROM `{!_MYSQL_PREFIX!}_user_data` WHERE beg_clicks>0", __FILE__, __LINE__);
list($extra) = SQL_FETCHROW($result);
// Total payed points
$result = SQL_QUERY("SELECT COUNT(id), SUM(points) FROM `{!_MYSQL_PREFIX!}_doubler` WHERE completed='Y' AND points > 0", __FILE__, __LINE__);
list($count1, $points1) = SQL_FETCHROW($result);
// Total payed points
$result = SQL_QUERY("SELECT COUNT(id), SUM(points) FROM `{!_MYSQL_PREFIX!}_doubler` WHERE completed='Y' AND points > 0", __FILE__, __LINE__);
list($count1, $points1) = SQL_FETCHROW($result);
// 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,
- 'value' => TRANSLATE_COMMA($points1)
- );
- $OUT_SPECIAL .= LOAD_TEMPLATE("mediadata_extra_row", true, $content);
- $content = array(
+ 'value' => translateComma($points1)
+ );
+ $OUT_SPECIAL .= LOAD_TEMPLATE('mediadata_extra_row', true, $content);
+ $content = array(
- 'value' => TRANSLATE_COMMA($count2)
- );
- $OUT_SPECIAL .= LOAD_TEMPLATE("mediadata_extra_row", true, $content);
- $content = array(
+ 'value' => translateComma($count2)
+ );
+ $OUT_SPECIAL .= LOAD_TEMPLATE('mediadata_extra_row', true, $content);
+ $content = array(
- 'value' => TRANSLATE_COMMA($points2)
- );
- $OUT_SPECIAL .= LOAD_TEMPLATE("mediadata_extra_row", true, $content);
+ 'value' => translateComma($points2)
+ );
+ $OUT_SPECIAL .= LOAD_TEMPLATE('mediadata_extra_row', true, $content);
// Total holiday requests
$result = SQL_QUERY("SELECT DISTINCT COUNT(h.userid)
FROM `{!_MYSQL_PREFIX!}_user_holidays` AS h
LEFT JOIN `{!_MYSQL_PREFIX!}_user_data` AS d
ON h.userid=d.userid
// Total holiday requests
$result = SQL_QUERY("SELECT DISTINCT COUNT(h.userid)
FROM `{!_MYSQL_PREFIX!}_user_holidays` AS h
LEFT JOIN `{!_MYSQL_PREFIX!}_user_data` AS d
ON h.userid=d.userid
list($holiday) = SQL_FETCHROW($result);
if (empty($holiday)) $holiday = 0;
$content = array(
'lang' => getMessage('MEDIA_HOLIDAY_COUNT'),
'value' => $holiday
);
list($holiday) = SQL_FETCHROW($result);
if (empty($holiday)) $holiday = 0;
$content = array(
'lang' => getMessage('MEDIA_HOLIDAY_COUNT'),
'value' => $holiday
);
// Statistics for points transfers
$result = SQL_QUERY("SELECT DISTINCT COUNT(t.id), SUM(t.points)
FROM `{!_MYSQL_PREFIX!}_user_transfers_in` AS t
LEFT JOIN `{!_MYSQL_PREFIX!}_user_data` AS d
ON t.userid=d.userid",
// Statistics for points transfers
$result = SQL_QUERY("SELECT DISTINCT COUNT(t.id), SUM(t.points)
FROM `{!_MYSQL_PREFIX!}_user_transfers_in` AS t
LEFT JOIN `{!_MYSQL_PREFIX!}_user_data` AS d
ON t.userid=d.userid",
list($count_in, $points_in) = SQL_FETCHROW($result);
if (empty($count_in)) $count_in = 0;
if (empty($points_in)) $points_in = 0;
list($count_in, $points_in) = SQL_FETCHROW($result);
if (empty($count_in)) $count_in = 0;
if (empty($points_in)) $points_in = 0;
list($count_out, $points_out) = SQL_FETCHROW($result);
if (empty($count_out)) $count_out = 0;
if (empty($points_out)) $points_out = 0;
// Add header
list($count_out, $points_out) = SQL_FETCHROW($result);
if (empty($count_out)) $count_out = 0;
if (empty($points_out)) $points_out = 0;
// Add header
- 'value' => TRANSLATE_COMMA($points_in)
- );
- $OUT_SPECIAL .= LOAD_TEMPLATE("mediadata_extra_row", true, $content);
- $content = array(
+ 'value' => translateComma($points_in)
+ );
+ $OUT_SPECIAL .= LOAD_TEMPLATE('mediadata_extra_row', true, $content);
+ $content = array(
- 'value' => TRANSLATE_COMMA($points_out)
- );
- $OUT_SPECIAL .= LOAD_TEMPLATE("mediadata_extra_row", true, $content);
+ 'value' => translateComma($points_out)
+ );
+ $OUT_SPECIAL .= LOAD_TEMPLATE('mediadata_extra_row', true, $content);
// Patch level and it's timespamp
define('__PATCH_LEVEL', getConfig('patch_level'));
// Patch level and it's timespamp
define('__PATCH_LEVEL', getConfig('patch_level'));