Fix for inserted codes while registering of extensions, many rewrites/cleanups:

[mailer.git] / inc / modules / guest / what-mediadata.php

diff --git a/inc/modules/guest/what-mediadata.php b/inc/modules/guest/what-mediadata.php
index 4da05fad705987ece86f6838748d8899161af892..733327beeba47653b71eaaceb1b70f322d2a8cdc 100644 (file)
--- a/inc/modules/guest/what-mediadata.php
+++ b/inc/modules/guest/what-mediadata.php
@@ -1,7 +1,7 @@
 <?php
 /************************************************************************
- * MXChange v0.2.1                                    Start: 12/09/2003 *
- * ===============                              Last change: 02/12/2006 *
+ * Mailer v0.2.1-FINAL                                Start: 12/09/2003 *
+ * ===================                          Last change: 02/12/2006 *
  *                                                                      *
  * -------------------------------------------------------------------- *
  * File              : what-mediadata.php                               *
@@ -23,6 +23,7 @@
  * svn:keywords Date Revision" (autoprobset!) at least!!!!!!            *
  * -------------------------------------------------------------------- *
  * Copyright (c) 2003 - 2009 by Roland Haeder                           *
+ * Copyright (c) 2009, 2010 by Mailer Developer Team                    *
  * For more information visit: http://www.mxchange.org                  *
  *                                                                      *
  * This program is free software; you can redistribute it and/or modify *
@@ -55,9 +56,9 @@ if ((!isExtensionActive('mediadata')) && (!isAdmin())) {
 } // END - if
 
 // Get total confirmed user ids...
-$content['user_confirmed']   = round(countSumTotalData('CONFIRMED'  , 'user_data', 'userid', 'status', true));
-$content['user_unconfirmed'] = round(countSumTotalData('UNCONFIRMED', 'user_data', 'userid', 'status', true));
-$content['user_locked']      = round(countSumTotalData('LOCKED'     , 'user_data', 'userid', 'status', true));
+$content['user_confirmed']   = getTotalConfirmedUser();
+$content['user_unconfirmed'] = getTotalUnconfirmedUser();
+$content['user_locked']      = getTotalLockedUser();
 $content['user_count']       = ($content['user_confirmed'] + $content['user_unconfirmed'] + $content['user_locked']);
 
 // Start of this exchange
@@ -74,9 +75,9 @@ if ($content['user_count'] > 0) {
 $TEST = makeTime(0, 0, 0, $PROJECTED);
 
 if ($TEST > time()) {
-       $content['projected'] = generateDateTime($PROJECTED, 3);
+       $content['projected'] = getMaskedMessage('USER_MT_PROJECTED', generateDateTime($PROJECTED, 3));
 } else {
-       $content['projected'] = getMessage('USER_PROJECTION_UNKNOWN');
+       $content['projected'] = getMaskedMessage('USER_MT_PROJECTED', '{--USER_PROJECTION_UNKNOWN--}');
 }
 
 // User who can receive mails
@@ -135,10 +136,10 @@ if (empty($jackpot)) $jackpot = '0';
 $content['jackpot'] = translateComma($jackpot);
 
 // Total referal link clicks, total logins
-$result = SQL_QUERY("SELECT
+$result = SQL_QUERY('SELECT
        SUM(d.ref_clicks), SUM(d.total_logins)
 FROM
-       `{?_MYSQL_PREFIX?}_user_data` AS d", __FILE__, __LINE__);
+       `{?_MYSQL_PREFIX?}_user_data` AS d', __FILE__, __LINE__);
 list($ref, $logins) = SQL_FETCHROW($result);
 SQL_FREERESULT($result);
 
@@ -174,48 +175,46 @@ $content['ref_clicks'] = $clicks;
 //
 
 // Initialize Variables
-$OUT_EXTRA   = ''; $ROWS_EXTRA   = 2;
-$OUT_POINTS  = ''; $ROWS_POINTS  = 2;
-$OUT_USER    = ''; $ROWS_USER    = 6;
+$OUT_EXTRA   = '';
+$OUT_POINTS  = '';
+$OUT_USER    = '';
 $OUT_SPECIAL = ''; // We don't need row count here
 
 // @TODO Rewrite all these if-blocks to filters
 if (isExtensionActive('beg')) {
        // Clicks on beg links
        $data = array(
-               'lang'  => getMessage('MEDIA_BEG_CLICKS'),
-               'value' => countSumTotalData(1, 'user_data', 'beg_clicks', 1, false, " AND `beg_clicks` > 0")
+               'lang'  => '{--MEDIA_BEG_CLICKS--}',
+               'value' => countSumTotalData('0', 'user_data', 'beg_clicks', 'userid', false, ' AND `beg_clicks` > 0')
        );
        $OUT_EXTRA .= loadTemplate('mediadata_extra_row', true, $data);
-       $ROWS_EXTRA++;
 }
 
 if (isExtensionActive('doubler')) {
        // Add header
-       $OUT_SPECIAL .= loadTemplate('mediadata_extra_hrow', true, getMessage('MEDIA_DOUBLER_HEADER'));
+       $OUT_SPECIAL .= loadTemplate('mediadata_extra_hrow', true, '{--MEDIA_DOUBLER_HEADER--}');
 
        // Add first line (count)
        $data = array(
-               'lang'  => getMessage('MEDIA_DOUBLER_COUNT'),
-               'value' => countSumTotalData('Y','doubler','id','completed', true, " AND `points` > 0"),
-               'rows'  => 4
+               'lang'  => '{--MEDIA_DOUBLER_COUNT--}',
+               'value' => countSumTotalData('Y','doubler','id','completed', true, ' AND `points` > 0'),
        );
 
        // Add points
        $OUT_SPECIAL .= loadTemplate('mediadata_extra_row2', true, $data);
        $data = array(
-               'lang'  => getMessage('MEDIA_DOUBLER_CPOINTS'),
-               'value' => translateComma(countSumTotalData('Y','doubler','id','completed', false, " AND `points` > 0"))
+               'lang'  => '{--MEDIA_DOUBLER_CPOINTS--}',
+               'value' => countSumTotalData('Y','doubler','id','completed', false, ' AND `points` > 0')
        );
        $OUT_SPECIAL .= loadTemplate('mediadata_extra_row', true, $data);
        $data = array(
-               'lang'  => getMessage('MEDIA_DOUBLER_WAITING'),
-               'value' => translateComma(countSumTotalData('N','doubler','id','completed', true, " AND `points` > 0"))
+               'lang'  => '{--MEDIA_DOUBLER_WAITING--}',
+               'value' => countSumTotalData('N','doubler','id','completed', true, ' AND `points` > 0')
        );
        $OUT_SPECIAL .= loadTemplate('mediadata_extra_row', true, $data);
        $data = array(
-               'lang'  => getMessage('MEDIA_DOUBLER_WPOINTS'),
-               'value' => translateComma(countSumTotalData('N','doubler','id','completed', false, " AND `points` > 0"))
+               'lang'  => '{--MEDIA_DOUBLER_WPOINTS--}',
+               'value' => countSumTotalData('N','doubler','id','completed', false, ' AND `points` > 0')
        );
        $OUT_SPECIAL .= loadTemplate('mediadata_extra_row', true, $data);
 }
@@ -237,11 +236,10 @@ WHERE
        SQL_FREERESULT($result);
        if (empty($holiday)) $holiday = '0';
        $data = array(
-               'lang'  => getMessage('MEDIA_HOLIDAY_COUNT'),
+               'lang'  => '{--MEDIA_HOLIDAY_COUNT--}',
                'value' => $holiday
        );
        $OUT_USER .= loadTemplate('mediadata_extra_row', true, $data);
-       $ROWS_USER++;
 }
 
 if (isExtensionActive('transfer')) {
@@ -260,10 +258,14 @@ ON
        if (empty($count_in))  $count_in  = '0';
        if (empty($points_in)) $points_in = '0';
 
-       $result = SQL_QUERY("SELECT COUNT(t.id), SUM(t.points)
-FROM `{?_MYSQL_PREFIX?}_user_transfers_out` AS t
-LEFT JOIN `{?_MYSQL_PREFIX?}_user_data` AS d
-ON t.userid=d.userid",
+       $result = SQL_QUERY("SELECT
+       COUNT(t.id), SUM(t.points)
+FROM
+       `{?_MYSQL_PREFIX?}_user_transfers_out` AS t
+LEFT JOIN
+       `{?_MYSQL_PREFIX?}_user_data` AS d
+ON
+       t.userid=d.userid",
        __FILE__, __LINE__);
        list($count_out, $points_out) = SQL_FETCHROW($result);
        SQL_FREERESULT($result);
@@ -271,37 +273,33 @@ ON t.userid=d.userid",
        if (empty($points_out)) $points_out = '0';
 
        // Add header
-       $OUT_SPECIAL .= loadTemplate('mediadata_extra_hrow', true, getMessage('MEDIA_TRANSFER_HEADER'));
+       $OUT_SPECIAL .= loadTemplate('mediadata_extra_hrow', true, '{--MEDIA_TRANSFER_HEADER--}');
        $data = array(
-               'lang'  => getMessage('MEDIA_TRANSFER_IN_COUNT'),
+               'lang'  => '{--MEDIA_TRANSFER_IN_COUNT--}',
                'value' => $count_in,
-               'rows'  => 4
        );
        $OUT_SPECIAL .= loadTemplate('mediadata_extra_row2', true, $data);
        $data = array(
-               'lang'  => getMessage('MEDIA_TRANSFER_IN_POINTS'),
-               'value' => translateComma($points_in)
+               'lang'  => '{--MEDIA_TRANSFER_IN_POINTS--}',
+               'value' => $points_in
        );
        $OUT_SPECIAL .= loadTemplate('mediadata_extra_row', true, $data);
        $data = array(
-               'lang'  => getMessage('MEDIA_TRANSFER_OUT_COUNT'),
+               'lang'  => '{--MEDIA_TRANSFER_OUT_COUNT--}',
                'value' => $count_out
        );
        $OUT_SPECIAL .= loadTemplate('mediadata_extra_row', true, $data);
        $data = array(
-               'lang'  => getMessage('MEDIA_TRANSFER_OUT_POINTS'),
-               'value' => translateComma($points_out)
+               'lang'  => '{--MEDIA_TRANSFER_OUT_POINTS--}',
+               'value' => $points_out
        );
        $OUT_SPECIAL .= loadTemplate('mediadata_extra_row', true, $data);
 } // END - if
 
-$content['out_extra']      = $OUT_EXTRA;
-$content['out_points']     = $OUT_POINTS;
-$content['out_user']       = $OUT_USER;
-$content['out_special']    = $OUT_SPECIAL;
-$content['rowspan_extra']  = $ROWS_EXTRA;
-$content['rowspan_points'] = $ROWS_POINTS;
-$content['rowspan_user']   = $ROWS_USER;
+$content['out_extra']   = $OUT_EXTRA;
+$content['out_points']  = $OUT_POINTS;
+$content['out_user']    = $OUT_USER;
+$content['out_special'] = $OUT_SPECIAL;
 
 // Patch timespamp
 $content['patch_ctime'] = generateDateTime(getConfig('patch_ctime'), 2);