A lot texts rewritten and exclamation signs removed
[mailer.git] / mailid_top.php
index 5273f72e9ca9e5c5f98e2c8c125401ef0842b6ee..baa25eb6041b8456172ab3f0852c3fca368ed579 100644 (file)
@@ -17,7 +17,7 @@
  * Needs to be in all Files and every File needs "svn propset           *
  * svn:keywords Date Revision" (autoprobset!) at least!!!!!!            *
  * -------------------------------------------------------------------- *
- * Copyright (c) 2003 - 2008 by Roland Haeder                           *
+ * Copyright (c) 2003 - 2009 by Roland Haeder                           *
  * For more information visit: http://www.mxchange.org                  *
  *                                                                      *
  * This program is free software; you can redistribute it and/or modify *
 // Load security stuff here
 require('inc/libs/security_functions.php');
 
-// Init "action" and "what"
-$GLOBALS['what'] = '';
-$GLOBALS['action'] = '';
+// Init start time
+$GLOBALS['startTime'] = microtime(true);
 
 // Tell everyone we are in this module
 $GLOBALS['module'] = 'mailid';
-$GLOBALS['output_mode'] = 0;
+$GLOBALS['output_mode'] = -1;
 
 // Load the required file(s)
 require('inc/config-global.php');
 
-if (isInstalled()) {
-       // Is the extension active
-       redirectOnUninstalledExtension('mailid');
-
-       // Secure all data
-       $url_uid = 0; $url_bid = 0; $url_mid = 0; $code = 0; $mode = '';
-       if (REQUEST_ISSET_GET('uid'))     $url_uid = bigintval(REQUEST_GET('uid'));
-       if (REQUEST_ISSET_GET('mailid'))  $url_mid = bigintval(REQUEST_GET('mailid'));
-       if (REQUEST_ISSET_GET('bonusid')) $url_bid = bigintval(REQUEST_GET('bonusid'));
-       if (REQUEST_ISSET_GET('code'))    $code    = bigintval(REQUEST_GET('code'));
-       if (REQUEST_ISSET_GET('mode'))    $mode    = REQUEST_GET('mode');
-
-       // 01        1        12            2    2            21    1                   22     10
-       if (($url_uid) > 0 && (($url_mid > 0) || ($url_bid > 0)) && (getTotalFatalErrors() == 0)) {
-               // No image? Then output header
-               if ($mode != 'img') loadIncludeOnce('inc/header.php');
-
-               // Maybe he wants to confirm an email?
-               if ($url_mid > 0) {
-                       $result = SQL_QUERY_ESC("SELECT id, link_type FROM `{!_MYSQL_PREFIX!}_user_links` WHERE stats_id=%s AND `userid`=%s LIMIT 1",
-                       array($url_mid, $url_uid), __FILE__, __LINE__);
-                       $type = 'mailid'; $urlId = $url_mid;
-               } elseif ($url_bid > 0) {
-                       $result = SQL_QUERY_ESC("SELECT id, link_type FROM `{!_MYSQL_PREFIX!}_user_links` WHERE bonus_id=%s AND `userid`=%s LIMIT 1",
-                       array($url_bid, $url_uid), __FILE__, __LINE__);
-                       $type = 'bonusid'; $urlId = $url_bid;
-               }
+// Set content type
+setContentType('text/html');
+
+// Is the extension mailid active?
+redirectOnUninstalledExtension('mailid');
+
+// Is the extension other active?
+redirectOnUninstalledExtension('other');
+
+// Init variables
+$url_userid = 0;
+$url_bid = 0;
+$url_mid = 0;
+$code = 0;
+$mode = '';
+
+// Secure all data
+if (isGetRequestElementSet('userid'))  $url_userid = bigintval(getRequestElement('userid'));
+if (isGetRequestElementSet('mailid'))  $url_mid    = bigintval(getRequestElement('mailid'));
+if (isGetRequestElementSet('bonusid')) $url_bid    = bigintval(getRequestElement('bonusid'));
+if (isGetRequestElementSet('code'))    $code       = bigintval(getRequestElement('code'));
+if (isGetRequestElementSet('mode'))    $mode       = getRequestElement('mode');
+
+// 01           1        12            2    2            21    1                   22     10
+if (($url_userid) > 0 && (($url_mid > 0) || ($url_bid > 0)) && (getTotalFatalErrors() == 0)) {
+       // No image? Then output header
+       if ($mode != 'img') loadIncludeOnce('inc/header.php');
+
+       // Maybe he wants to confirm an email?
+       if ($url_mid > 0) {
+               $result = SQL_QUERY_ESC("SELECT `id`, `link_type` FROM `{?_MYSQL_PREFIX?}_user_links` WHERE `stats_id`=%s AND `userid`=%s LIMIT 1",
+                       array($url_mid, $url_userid), __FILE__, __LINE__);
+               $type = 'mailid'; $urlId = $url_mid;
+       } elseif ($url_bid > 0) {
+               $result = SQL_QUERY_ESC("SELECT `id`, `link_type` FROM `{?_MYSQL_PREFIX?}_user_links` WHERE `bonus_id`=%s AND `userid`=%s LIMIT 1",
+                       array($url_bid, $url_userid), __FILE__, __LINE__);
+               $type = 'bonusid'; $urlId = $url_bid;
+       }
 
-               if (SQL_NUMROWS($result) == 1) {
-                       // Is the stats ID valid?
-                       list($lid, $ltype) = SQL_FETCHROW($result);
-                       SQL_FREERESULT($result);
-                       switch ($ltype)
-                       {
-                               case 'NORMAL':
-                                       $result_mailid = SQL_QUERY_ESC("SELECT pool_id, userid, id FROM `{!_MYSQL_PREFIX!}_user_stats` WHERE `id`=%s LIMIT 1",
+       if (SQL_NUMROWS($result) == 1) {
+               // Is the stats id valid?
+               list($lid, $ltype) = SQL_FETCHROW($result);
+               SQL_FREERESULT($result);
+
+               // Init result here with invalid to avoid possible missing variable
+               $result_mailid = false;
+
+               // @TODO Rewrite this to a filter
+               switch ($ltype) {
+                       case 'NORMAL':
+                               $result_mailid = SQL_QUERY_ESC("SELECT `pool_id`, `userid`, `id` FROM `{?_MYSQL_PREFIX?}_user_stats` WHERE `id`=%s LIMIT 1",
                                        array($url_mid), __FILE__, __LINE__);
-                                       break;
+                               break;
 
-                               case 'BONUS':
-                                       $result_mailid = SQL_QUERY_ESC("SELECT id, id, is_notify FROM `{!_MYSQL_PREFIX!}_bonus` WHERE `id`=%s LIMIT 1",
+                       case 'BONUS':
+                               $result_mailid = SQL_QUERY_ESC("SELECT `id`, `id`, `is_notify` FROM `{?_MYSQL_PREFIX?}_bonus` WHERE `id`=%s LIMIT 1",
                                        array($url_bid), __FILE__, __LINE__);
-                                       break;
-                       }
+                               break;
 
-                       // Entry found?
-                       if (SQL_NUMROWS($result_mailid) == 1) {
-                               // Load data
-                               list($pool, $sender, $notify) = SQL_FETCHROW($result_mailid);
+                       default: // Unknown type
+                               debug_report_bug('Unknown mail type ' . $ltype . ' detected.');
+                               break;
+               }
+
+               // Entry found?
+               if (SQL_NUMROWS($result_mailid) == 1) {
+                       // Load data
+                       list($pool, $sender, $notify) = SQL_FETCHROW($result_mailid);
 
-                               // Correct notification switch in non-bonus mails
-                               if (($notify != 'Y') && ($notify != 'N')) $notify = 'N';
+                       // Correct notification switch in non-bonus mails
+                       if (($notify != 'Y') && ($notify != 'N')) $notify = 'N';
+
+                       // Free some memory
+                       SQL_FREERESULT($result_mailid);
+
+                       // Set sender to 0 when we have a bonus mail
+                       if ($ltype == 'BONUS') $sender = 0;
+
+                       // Is the user's id unlocked?
+                       $result = SQL_QUERY_ESC("SELECT `status`, `gender`, `surname`, `family`, `ref_payout` FROM `{?_MYSQL_PREFIX?}_user_data` WHERE `userid`=%s LIMIT 1",
+                               array($url_userid), __FILE__, __LINE__);
+                       if (SQL_NUMROWS($result) == 1) {
+                               // Load data
+                               list($status, $gender, $surname, $family, $ref_pay) = SQL_FETCHROW($result);
 
                                // Free some memory
-                               SQL_FREERESULT($result_mailid);
-
-                               // Set sender to 0 when we have a bonus mail
-                               if ($ltype == 'BONUS') $sender = 0;
-
-                               // Is the user's ID unlocked?
-                               $result = SQL_QUERY_ESC("SELECT status, gender, surname, family, ref_payout FROM `{!_MYSQL_PREFIX!}_user_data` WHERE userid=%s LIMIT 1",
-                               array($url_uid), __FILE__, __LINE__);
-                               if (SQL_NUMROWS($result) == 1) {
-                                       // Load data
-                                       list($status, $gender, $sname, $fname, $ref_pay) = SQL_FETCHROW($result);
-
-                                       // Free some memory
-                                       SQL_FREERESULT($result);
-
-                                       if ($status == 'CONFIRMED') {
-                                               // Update last activity
-                                               SQL_QUERY_ESC("UPDATE `{!_MYSQL_PREFIX!}_user_data` SET last_online=UNIX_TIMESTAMP(), `last_module`='mailid_top' WHERE userid=%s LIMIT 1",
-                                               array($url_uid), __FILE__, __LINE__);
-
-                                               // User has confirmed his account so we can procede...
-                                               switch ($ltype)
-                                               {
-                                                       case 'NORMAL':
-                                                               $result = SQL_QUERY_ESC("SELECT payment_id FROM `{!_MYSQL_PREFIX!}_user_stats` WHERE pool_id=%s LIMIT 1",
+                               SQL_FREERESULT($result);
+
+                               if ($status == 'CONFIRMED') {
+                                       // User has confirmed his account so we can procede...
+                                       // @TODO Rewrite this to a filter
+                                       switch ($ltype) {
+                                               case 'NORMAL':
+                                                       $result = SQL_QUERY_ESC("SELECT `payment_id` FROM `{?_MYSQL_PREFIX?}_user_stats` WHERE `pool_id`=%s LIMIT 1",
                                                                array(bigintval($pool)), __FILE__, __LINE__);
 
-                                                               // Entry found?
-                                                               if (SQL_NUMROWS($result) == 1) {
-                                                                       list($pay) = SQL_FETCHROW($result);
-                                                                       $time      = getPaymentPoints($pay, 'time');
-                                                                       $payment   = getPaymentPoints($pay, 'payment');
-                                                                       $isValid   = true;
-                                                               } // END - if
+                                                       // Entry found?
+                                                       if (SQL_NUMROWS($result) == 1) {
+                                                               list($pay) = SQL_FETCHROW($result);
+                                                               $time      = getPaymentPoints($pay, 'time');
+                                                               $payment   = getPaymentPoints($pay, 'payment');
+                                                               $isValid   = true;
+                                                       } // END - if
 
-                                                               // Free memory...
-                                                               SQL_FREERESULT($result);
-                                                               break;
+                                                       // Free memory...
+                                                       SQL_FREERESULT($result);
+                                                       break;
 
-                                                       case 'BONUS':
-                                                               $result = SQL_QUERY_ESC("SELECT time, points FROM `{!_MYSQL_PREFIX!}_bonus` WHERE `id`=%s LIMIT 1",
+                                               case 'BONUS':
+                                                       $result = SQL_QUERY_ESC("SELECT `time`, `points` FROM `{?_MYSQL_PREFIX?}_bonus` WHERE `id`=%s LIMIT 1",
                                                                array(bigintval($pool)), __FILE__, __LINE__);
 
-                                                               // Entry found?
-                                                               if (SQL_NUMROWS($result) == 1) {
-                                                                       list($time, $payment) = SQL_FETCHROW($result);
-                                                                       $isValid = true;
-                                                               }
+                                                       // Entry found?
+                                                       if (SQL_NUMROWS($result) == 1) {
+                                                               list($time, $payment) = SQL_FETCHROW($result);
+                                                               $isValid = true;
+                                                       } // END - if
 
-                                                               // Free memory...
-                                                               SQL_FREERESULT($result);
-                                                               break;
-                                               }
+                                                       // Free memory...
+                                                       SQL_FREERESULT($result);
+                                                       break;
+
+                                               default: // Unknown type
+                                                       debug_report_bug('Unknown mail type ' . $ltype . ' detected.');
+                                                       break;
+                                       }
 
-                                               // Is this entry valid?
-                                               if ($isValid) {
-                                                       if (($time == '0') && ($payment > 0)) $time = '1';
-                                                       if (($time > 0) && ($payment > 0)) {
-                                                               if (!empty($code)) {
-                                                                       // Generate code
-                                                                       $img_code = generateRandomCodde(getConfig('code_length'), $code, $url_uid, $urlId);
-                                                               } // END - if
-
-                                                               switch ($mode) {
-                                                                       case 'add':
-                                                                               // Init stats data
-                                                                               $stats_data = 0;
-
-                                                                               // Count clicks
-                                                                               switch ($ltype)
-                                                                               {
-                                                                                       case 'NORMAL':
-                                                                                               SQL_QUERY_ESC("UPDATE `{!_MYSQL_PREFIX!}_user_stats` SET clicks=clicks + 1 WHERE `id`=%s LIMIT 1",
+                                       // Is this entry valid?
+                                       if ($isValid === true) {
+                                               if (($time == 0) && ($payment > 0)) $time = 1;
+                                               if (($time > 0) && ($payment > 0)) {
+                                                       $img_code = 0;
+                                                       if (!empty($code)) {
+                                                               // Generate code
+                                                               $img_code = generateRandomCode(getConfig('code_length'), $code, $url_userid, $urlId);
+                                                       } // END - if
+
+                                                       // @TODO Rewrite this to a filter
+                                                       switch ($mode) {
+                                                               case 'add':
+                                                                       // Init stats data
+                                                                       $stats_data = 0;
+
+                                                                       // Count clicks
+                                                                       // @TODO Rewrite this to a filter
+                                                                       switch ($ltype) {
+                                                                               case 'NORMAL':
+                                                                                       SQL_QUERY_ESC("UPDATE `{?_MYSQL_PREFIX?}_user_stats` SET `clicks`=`clicks`+1 WHERE `id`=%s LIMIT 1",
                                                                                                array($url_mid), __FILE__, __LINE__);
 
-                                                                                               // Update mediadata as well
-                                                                                               if (GET_EXT_VERSION('mediadata') >= '0.0.4') {
-                                                                                                       // Update database
-                                                                                                       MEDIA_UPDATE_ENTRY(array('total_clicks', 'normal_clicks'), 'add', 1);
-                                                                                               }
-                                                                                               $stats_data = $url_mid;
-                                                                                               break;
+                                                                                       // Update mediadata as well
+                                                                                       if (getExtensionVersion('mediadata') >= '0.0.4') {
+                                                                                               // Update database
+                                                                                               updateMediadataEntry(array('total_clicks', 'normal_clicks'), 'add', 1);
+                                                                                       } // END - if
+                                                                                       $stats_data = $url_mid;
+                                                                                       break;
 
-                                                                                       case 'BONUS':
-                                                                                               SQL_QUERY_ESC("UPDATE `{!_MYSQL_PREFIX!}_bonus` SET clicks=clicks + 1 WHERE `id`=%s LIMIT 1",
+                                                                               case 'BONUS':
+                                                                                       SQL_QUERY_ESC("UPDATE `{?_MYSQL_PREFIX?}_bonus` SET `clicks`=`clicks`+1 WHERE `id`=%s LIMIT 1",
                                                                                                array($url_bid), __FILE__, __LINE__);
 
-                                                                                               // Update mediadata as well
-                                                                                               if (GET_EXT_VERSION('mediadata') >= '0.0.4') {
-                                                                                                       // Update database
-                                                                                                       MEDIA_UPDATE_ENTRY(array('total_clicks', 'bonus_clicks'), 'add', 1);
-                                                                                               }
-                                                                                               $stats_data = $url_bid;
-                                                                                               break;
-                                                                               }
+                                                                                       // Update mediadata as well
+                                                                                       if (getExtensionVersion('mediadata') >= '0.0.4') {
+                                                                                               // Update database
+                                                                                               updateMediadataEntry(array('total_clicks', 'bonus_clicks'), 'add', 1);
+                                                                                       } // END - if
+                                                                                       $stats_data = $url_bid;
+                                                                                       break;
+
+                                                                               default: // Unknown type
+                                                                                       debug_report_bug('Unknown mail type ' . $ltype . ' detected.');
+                                                                                       break;
+                                                                       } // END - switch
+
+                                                                       // Export data into constants for the template
+                                                                       $content['points'] = translateComma($payment);
+                                                                       $content['banner'] = loadTemplate('mailid_banner', true);
+
+                                                                       // Only when user extension = v0.1.2: Update mails-confirmed counter
+                                                                       // @TODO Rewrite these blocks to filter
+                                                                       if (getExtensionVersion('user') >= '0.1.2') {
+                                                                               // Update counter
+                                                                               SQL_QUERY_ESC("UPDATE `{?_MYSQL_PREFIX?}_user_data` SET mails_confirmed=mails_confirmed + 1 WHERE `userid`=%s LIMIT 1",
+                                                                               array($url_userid), __FILE__, __LINE__);
+
+                                                                               // Update random confirmed as well?
+                                                                               if (getExtensionVersion('user') >= '0.3.4') {
+                                                                                       // Update second counter
+                                                                                       SQL_QUERY_ESC("UPDATE `{?_MYSQL_PREFIX?}_user_data` SET rand_confirmed=rand_confirmed + 1 WHERE `userid`=%s LIMIT 1",
+                                                                                       array($url_userid), __FILE__, __LINE__);
+                                                                               } // END - if
+                                                                       } // END - if
+
+                                                                       // Insert stats record
+                                                                       insertUserStatsRecord($url_userid, $type, $stats_data);
+
+                                                                       // Right code entered?
+                                                                       if (bigintval(postRequestElement('gfx_check')) == $img_code) {
+                                                                               // Add points over referal system is the default
+                                                                               $locked = false;
+                                                                               $template = 'mailid_points_done';
+
+                                                                               // Right code entered add points and remove entry
+                                                                               if (($ref_pay > 0) && (getConfig('allow_direct_pay') != 'Y')) {
+                                                                                       // Don't add points over the referal system
+                                                                                       $locked = true;
+                                                                                       $template = 'mailid_points_locked';
+                                                                               } // END - if
 
-                                                                               // Export data into constants for the template
-                                                                               define('_POINTS_VALUE'   , translateComma($payment));
-                                                                               define('_TEMPLATE_BANNER', LOAD_TEMPLATE('mailid_banner', true));
-
-                                                                               // Only when user extension = v0.1.2: Update mails-confirmed counter
-                                                                               // @TODO Rewrite these blocks to filter
-                                                                               if (GET_EXT_VERSION('user') >= '0.1.2') {
-                                                                                       // Update counter
-                                                                                       SQL_QUERY_ESC("UPDATE `{!_MYSQL_PREFIX!}_user_data` SET mails_confirmed=mails_confirmed + 1 WHERE userid=%s LIMIT 1",
-                                                                                       array($url_uid), __FILE__, __LINE__);
-
-                                                                                       // Update random confirmed as well?
-                                                                                       if (GET_EXT_VERSION('user') >= '0.3.4') {
-                                                                                               // Update second counter
-                                                                                               SQL_QUERY_ESC("UPDATE `{!_MYSQL_PREFIX!}_user_data` SET rand_confirmed=rand_confirmed + 1 WHERE userid=%s LIMIT 1",
-                                                                                               array($url_uid), __FILE__, __LINE__);
+                                                                               // Count down ref_payout value
+                                                                               SQL_QUERY_ESC("UPDATE `{?_MYSQL_PREFIX?}_user_data` SET `ref_payout`=`ref_payout`-1 WHERE `userid`=%s AND `ref_payout` > 0 LIMIT 1",
+                                                                                       array($url_userid), __FILE__, __LINE__);
+
+                                                                               // Add points
+                                                                               // @TODO Try to rewrite the following unset()
+                                                                               unset($GLOBALS['ref_level']);
+                                                                               addPointsThroughReferalSystem('mailid_okay', $url_userid, $payment, false, 0, $locked);
+
+                                                                               // Shall I add bonus points for "turbo clickers" ?
+                                                                               if (getExtensionVersion('bonus') >= '0.2.2') {
+                                                                                       // Is an active-rallye running and this is not a notification mail?
+                                                                                       if ((getConfig('bonus_active') == 'Y') && ($notify != 'Y')) {
+                                                                                               // Shall I exclude the webmaster's own userid from the active-rallye?
+                                                                                               if ((((getConfig('bonus_userid') == $url_userid) && (getConfig('bonus_include_own') == 'Y')) || (getConfig('bonus_userid') != $url_userid)) && (getConfig('def_refid') != $url_userid)) {
+                                                                                                       // Add points and remember ranking are done in this function....
+                                                                                                       addTurboBonus($urlId, $url_userid, $type);
+
+                                                                                                       // Set template to mailid_points_done2 which contains a link to the ranking list
+                                                                                                       $template = 'mailid_points_done2';
+                                                                                                       if ($locked) $template = 'mailid_points_locked2';
+                                                                                                       $content['userid']  = $url_userid;
+                                                                                                       $content['type']    = $type;
+                                                                                                       $content['data']    = $urlId;
+                                                                                               } // END - if
                                                                                        } // END - if
                                                                                } // END - if
 
-                                                                               // Insert stats record
-                                                                               insertUserStatsRecord($url_uid, $type, $stats_data);
+                                                                               // Load total points
+                                                                               $content['total'] = translateComma(
+                                                                                       countSumTotalData($url_userid, 'user_points', 'points') -
+                                                                                       countSumTotalData($url_userid, 'user_data', 'used_points')
+                                                                               );
 
-                                                                               // Right code entered?
-                                                                               if (bigintval(REQUEST_POST('gfx_check')) == $img_code) {
-                                                                                       // Add points over referal system is the default
-                                                                                       $locked = false;
-                                                                                       $template = 'mailid_points_done';
+                                                                               // Load template
+                                                                               loadTemplate($template, false, $content);
+                                                                       } else {
+                                                                               // Wrong image code! So add points to sender's account
+                                                                               addPointsDirectly('mailid_payback', $sender, $payment);
 
-                                                                                       // Right code entered add points and remove entry
-                                                                                       if (($ref_pay > 0) && (getConfig('allow_direct_pay') != 'Y')) {
-                                                                                               // Don't add points over the referal system
-                                                                                               $locked = true;
-                                                                                               $template = 'mailid_points_locked';
-                                                                                       } // END - if
+                                                                               // Load template
+                                                                               loadTemplate('mailid_points_failed', false, $content);
+                                                                       }
 
-                                                                                       // Count down ref_payout value
-                                                                                       SQL_QUERY_ESC("UPDATE `{!_MYSQL_PREFIX!}_user_data` SET ref_payout=ref_payout-1 WHERE userid=%s AND ref_payout > 0 LIMIT 1",
-                                                                                       array($url_uid), __FILE__, __LINE__);
-
-                                                                                       // Add points
-                                                                                       unset($GLOBALS['ref_level']);
-                                                                                       ADD_POINTS_REFSYSTEM('mailid_okay', $url_uid, $payment, false, '0', $locked);
-
-                                                                                       // Shall I add bonus points for "turbo clickers" ?
-                                                                                       if (GET_EXT_VERSION('bonus') >= '0.2.2') {
-                                                                                               // Is an active-rallye running and this is not a notification mail?
-                                                                                               if ((getConfig('bonus_active') == 'Y') && ($notify == 'N')) {
-                                                                                                       // Shall I exclude the webmaster's own userid from the active-rallye?
-                                                                                                       if ((((getConfig('bonus_uid') == $url_uid) && (getConfig('bonus_include_own') == 'Y')) || (getConfig('bonus_uid') != $url_uid)) && (getConfig('def_refid') != $url_uid)) {
-                                                                                                               // Add points and remember ranking are done in this function....
-                                                                                                               BONUS_ADD_TURBO_POINTS($urlId, $url_uid, $type);
-
-                                                                                                               // Set template to mailid_points_done2 which contains a link to the ranking list
-                                                                                                               $template = 'mailid_points_done2';
-                                                                                                               if ($locked) $template = 'mailid_points_locked2';
-                                                                                                               define('_UID_VALUE' , $url_uid);
-                                                                                                               define('_TYPE_VALUE', $type);
-                                                                                                               define('_DATA_VALUE', translateComma($urlId));
-                                                                                                       } // END - if
-                                                                                               } // END - if
-                                                                                       } // END - if
+                                                                       // Remove link from table
+                                                                       SQL_QUERY_ESC("DELETE LOW_PRIORITY FROM `{?_MYSQL_PREFIX?}_user_links` WHERE `id`=%s LIMIT 1",
+                                                                               array(bigintval($lid)), __FILE__, __LINE__);
+                                                                       break;
 
-                                                                                       // Load total points
-                                                                                       define('__TOTAL_POINTS', translateComma(
-                                                                                       GET_TOTAL_DATA($url_uid, 'user_points', 'points') -
-                                                                                       GET_TOTAL_DATA($url_uid, 'user_data', 'used_points'))
-                                                                                       );
+                                                               case 'img':
+                                                                       generateImageOrCode($img_code);
+                                                                       break;
 
-                                                                                       // Load template
-                                                                                       LOAD_TEMPLATE($template);
+                                                               case 'confirm':
+                                                                       if ($code > 0) {
+                                                                               // Export data into constants for the template
+                                                                               $content['code']   = $code;
+                                                                               $content['userid'] = $url_userid;
+                                                                               $content['type']   = $type;
+                                                                               $content['data']   = $urlId;
+                                                                               $content['banner'] = loadTemplate('mailid_banner', true);
+                                                                               if (getConfig('code_length') > 0) {
+                                                                                       // Generate Code
+                                                                                       $content['image'] = generateCaptchaCode($code, $type, $urlId, $url_userid);
+                                                                                       $templ = 'mailid_enter_code';
                                                                                } else {
-                                                                                       // Wrong image code! So add points to sender's account
-                                                                                       unset($GLOBALS['ref_level']);
-                                                                                       ADD_POINTS_REFSYSTEM_DIRECT('mailid_payback', $sender, $payment);
-
-                                                                                       // Load template
-                                                                                       LOAD_TEMPLATE('mailid_points_failed');
+                                                                                       // Disabled code
+                                                                                       $content['gfx'] = $img_code;
+                                                                                       $templ = 'mailid_confirm_buttom';
                                                                                }
 
-                                                                               // Remove link from table
-                                                                               SQL_QUERY_ESC("DELETE LOW_PRIORITY FROM `{!_MYSQL_PREFIX!}_user_links` WHERE `id`=%s LIMIT 1",
-                                                                               array(bigintval($lid)), __FILE__, __LINE__);
-                                                                               break;
-
-                                                                                       case 'img':
-                                                                                               GENERATE_IMAGE($img_code);
-                                                                                               break;
-
-                                                                                       case 'confirm':
-                                                                                               if ($code > 0) {
-                                                                                                       // Export data into constants for the template
-                                                                                                       define('_CODE_VALUE', $code);
-                                                                                                       define('_UID_VALUE' , $url_uid );
-                                                                                                       define('_TYPE_VALUE', $type);
-                                                                                                       define('_DATA_VALUE', $urlId);
-                                                                                                       define('_TEMPLATE_BANNER', LOAD_TEMPLATE('mailid_banner', true));
-                                                                                                       if (getConfig('code_length') > 0) {
-                                                                                                               // Generate Code
-                                                                                                               define('_IMAGE_CODE', generateCaptchaCode($code, $type, $urlId, $url_uid));
-                                                                                                               $templ = 'mailid_enter_code';
-                                                                                                       } else {
-                                                                                                               // Disabled code
-                                                                                                               define('__GFX_CODE', $img_code);
-                                                                                                               $templ = 'mailid_confirm_buttom';
-                                                                                                       }
-
-                                                                                                       // Load template
-                                                                                                       LOAD_TEMPLATE($templ);
-                                                                                               }
-                                                                                               break;
-
-                                                                                       case '':
-                                                                                               // Ok, all data is valid and loaded. Finally let's output the timer... :-)
-                                                                                               // Export data into constants for the template
-                                                                                               define('_TIME_VALUE', $time);
-                                                                                               define('_TIM2_VALUE', strlen($time));
-                                                                                               define('_UID_VALUE' , $url_uid );
-                                                                                               define('_TYPE_VALUE', $type);
-                                                                                               define('_DATA_VALUE', $urlId);
-                                                                                               define('_RAND_VALUE', mt_rand(0, 99999));
-                                                                                               define('_TEMPLATE_BANNER', LOAD_TEMPLATE('mailid_banner', true));
-
-                                                                                               // Load template
-                                                                                               LOAD_TEMPLATE('mailid_timer');
-                                                                                               break;
-                                                               } // END - switch
-                                                       } else {
-                                                               LOAD_TEMPLATE('admin_settings_saved', false, "<div class=\"member_failed\">{--MAIL_ALREADY_CONFIRMED--} (6)</div>");
-                                                       }
+                                                                               // Load template
+                                                                               loadTemplate($templ, false, $content);
+                                                                       }
+                                                                       break;
+
+                                                               case '':
+                                                                       // Ok, all data is valid and loaded. Finally let's output the timer... :-)
+                                                                       // Export data into constants for the template
+                                                                       $content['time']   = $time;
+                                                                       $content['tim2']   = strlen($time);
+                                                                       $content['userid'] = $url_userid;
+                                                                       $content['type']   = $type;
+                                                                       $content['data']   = $urlId;
+                                                                       $content['rand']   = mt_rand(0, 99999);
+                                                                       $content['banner'] = loadTemplate('mailid_banner', true);
+
+                                                                       // Load template
+                                                                       loadTemplate('mailid_timer', false, $content);
+                                                                       break;
+
+                                                               default: // Unknown mode
+                                                                       debug_report_bug('Unknown mode ' . $mode . ' detected.');
+                                                                       break;
+                                                       } // END - switch
                                                } else {
-                                                       LOAD_TEMPLATE('admin_settings_saved', false, "<div class=\"member_failed\">{--MAIL_ALREADY_CONFIRMED--} (5)</div>");
+                                                       loadTemplate('admin_settings_saved', false, "<div class=\"member_failed\">{--MAIL_ALREADY_CONFIRMED--} (6)</div>");
+                                                       $mode = 'failed';
                                                }
                                        } else {
-                                               LOAD_TEMPLATE('admin_settings_saved', false, "<div class=\"member_failed\">{--MAIL_ALREADY_CONFIRMED--} (4)</div>");
+                                               loadTemplate('admin_settings_saved', false, "<div class=\"member_failed\">{--MAIL_ALREADY_CONFIRMED--} (5)</div>");
+                                               $mode = 'failed';
                                        }
                                } else {
-                                       SQL_FREERESULT($result);
-                                       LOAD_TEMPLATE('admin_settings_saved', false, "<div class=\"member_failed\">{--MAIL_ALREADY_CONFIRMED--} (3)</div>");
+                                       loadTemplate('admin_settings_saved', false, "<div class=\"member_failed\">{--MAIL_ALREADY_CONFIRMED--} (4)</div>");
+                                       $mode = 'failed';
                                }
                        } else {
                                SQL_FREERESULT($result);
-                               LOAD_TEMPLATE('admin_settings_saved', false, "<div class=\"member_failed\">{--MAIL_ALREADY_CONFIRMED--} (2)</div>");
+                               loadTemplate('admin_settings_saved', false, "<div class=\"member_failed\">{--MAIL_ALREADY_CONFIRMED--} (3)</div>");
+                               $mode = 'failed';
                        }
                } else {
                        SQL_FREERESULT($result);
-                       LOAD_TEMPLATE('admin_settings_saved', false, "<div class=\"member_failed\">{--MAIL_ALREADY_CONFIRMED--} (1)</div>");
+                       loadTemplate('admin_settings_saved', false, "<div class=\"member_failed\">{--MAIL_ALREADY_CONFIRMED--} (2)</div>");
+                       $mode = 'failed';
                }
-
-               // Insert footer if no image
-               if ($mode != 'img') {
-                       // Write footer
-                       loadIncludeOnce('inc/footer.php');
-               } // END - if
+       } else {
+               SQL_FREERESULT($result);
+               loadTemplate('admin_settings_saved', false, "<div class=\"member_failed\">{--MAIL_ALREADY_CONFIRMED--} (1)</div>");
+               $mode = 'failed';
        }
-} elseif ($mode != 'img') {
-       // You have to install first!
-       redirectToUrl('install.php');
+
+       // Insert footer if no image
+       if ($mode != 'img') {
+               // Write footer
+               loadIncludeOnce('inc/footer.php');
+       } // END - if
 }
 
 // Really all done here... ;-)
 shutdown();
 
-//
+// [EOF]
 ?>