More missing config entries added
[mailer.git] / mailid.php
index d61a17441aab468a3b59b12cc0741db2d21876d5..34de98562876460a958ae3dd910dc3101bda1557 100644 (file)
  * MA  02110-1301  USA                                                  *
  ************************************************************************/
 
-// Load security stuff here (Oh, I hope this is not unsecure? Am I paranoia??? ;-) )
+// 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'] = -1;
+$errorCode = '';
 
 // Load the required file(s)
-require('inc/config.php');
-
-if (isInstalled()) {
-       // Is the extension active?
-       REDIRECT_ON_UNINSTALLED_EXTENSION('mailid');
-
-       // Init
-       $url_uid = 0; $url_bid = 0; $url_mid = 0;
-
-       // Secure all data
-       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'));
-
-       // 01        1        12            3    32           21    1                   22     10
-       if (($url_uid) > 0 && (($url_mid > 0) || ($url_bid > 0)) && (getTotalFatalErrors() == 0)) {
-               // Maybe he wants to confirm an email?
-               if ($url_mid > 0) {
-                       // Normal-Mails
-                       $result = SQL_QUERY_ESC("SELECT 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) {
-                       // Bonus-Mail
-                       $result = SQL_QUERY_ESC("SELECT 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;
-               } else {
-                       // Problem: No ID entered
-                       redirectToUrl('index.php');
-               }
+require('inc/config-global.php');
 
-               if (SQL_NUMROWS($result) == 1) {
-                       // Load the entry
-                       list($ltype) = SQL_FETCHROW($result);
+if (!isInstalled()) {
+       // You have to install first!
+       redirectToUrl('install.php');
+} // END - if
+
+// Is the extension active?
+redirectOnUninstalledExtension('mailid');
+
+// Init
+$url_uid = 0;
+$url_bid = 0;
+$url_mid = 0;
+
+// Secure all data
+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'));
+
+// 01        1        12            3    32           21    1                   22     10
+if (($url_uid) > 0 && (($url_mid > 0) || ($url_bid > 0)) && (getTotalFatalErrors() == 0)) {
+       // Maybe he wants to confirm an email?
+       if ($url_mid > 0) {
+               // Normal-Mails
+               $result = SQL_QUERY_ESC("SELECT `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) {
+               // Bonus-Mail
+               $result = SQL_QUERY_ESC("SELECT `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;
+       } else {
+               // Problem: No ID entered
+               redirectToUrl('index.php');
+       }
 
-                       // Clean result
-                       SQL_FREERESULT($result);
+       if (SQL_NUMROWS($result) == 1) {
+               // Load the entry
+               list($ltype) = SQL_FETCHROW($result);
 
-                       switch ($ltype)
-                       {
+               // Clean result
+               SQL_FREERESULT($result);
+
+               // @TODO Rewrite this to a filter
+               switch ($ltype)
+               {
                        case 'NORMAL':
                                // Is the stats ID valid?
                                $result = SQL_QUERY_ESC("SELECT pool_id, url, subject FROM `{!_MYSQL_PREFIX!}_user_stats` WHERE `id`=%s LIMIT 1",
-                                       array($url_mid), __FILE__, __LINE__);
+                               array($url_mid), __FILE__, __LINE__);
                                break;
 
                        case 'BONUS':
                                // Is the bonus extension active?
-                               REDIRECT_ON_UNINSTALLED_EXTENSION('bonus');
+                               redirectOnUninstalledExtension('bonus');
 
                                // Bonus-Mails
                                $result = SQL_QUERY_ESC("SELECT id, url, subject FROM `{!_MYSQL_PREFIX!}_bonus` WHERE `id`=%s LIMIT 1",
-                                       array($url_bid), __FILE__, __LINE__);
+                               array($url_bid), __FILE__, __LINE__);
                                break;
-                       }
 
-                       if (SQL_NUMROWS($result) == 1) {
-                               // Load data
-                               list($pool, $URL, $EXTRA_TITLE) = SQL_FETCHROW($result);
+                       default: // Invalid mail type
+                               debug_report_bug('Invalid mail type ' . $ltype . ' detected.');
+                               break;
+               }
 
-                               // Free result
-                               SQL_FREERESULT($result);
+               if (SQL_NUMROWS($result) == 1) {
+                       // Load data
+                       list($pool, $URL, $title) = SQL_FETCHROW($result);
+
+                       // Free result
+                       SQL_FREERESULT($result);
+
+                       // Compile extra title
+                       $title = COMPILE_CODE($title);
+
+                       // Set it
+                       setExtraTitle($title);
 
-                               // Compile extra title
-                               $EXTRA_TITLE = COMPILE_CODE($EXTRA_TITLE);
-
-                               // Is the user's ID unlocked?
-                               $result = SQL_QUERY_ESC("SELECT status, gender, surname, family FROM `{!_MYSQL_PREFIX!}_user_data` WHERE userid=%s LIMIT 1",
-                                       array($url_uid), __FILE__, __LINE__);
-                               if (SQL_NUMROWS($result) == 1) {
-                                       list($status, $gender, $sname, $fname) = SQL_FETCHROW($result);
-                                       SQL_FREERESULT($result);
-                                       if ($status == 'CONFIRMED') {
-                                               // User has confirmed his account so we can procede...
-                                               switch ($ltype)
-                                               {
+                       // Is the user's ID unlocked?
+                       $result = SQL_QUERY_ESC("SELECT `status`, `gender`, `surname`,` family` FROM `{!_MYSQL_PREFIX!}_user_data` WHERE `userid`=%s LIMIT 1",
+                               array($url_uid), __FILE__, __LINE__);
+                       if (SQL_NUMROWS($result) == 1) {
+                               list($status, $gender, $sname, $fname) = SQL_FETCHROW($result);
+                               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__);
@@ -141,7 +156,7 @@ if (isInstalled()) {
 
                                                case 'BONUS':
                                                        $result = SQL_QUERY_ESC("SELECT points, time FROM `{!_MYSQL_PREFIX!}_bonus` WHERE `id`=%s LIMIT 1",
-                                                               array($url_bid), __FILE__, __LINE__);
+                                                       array($url_bid), __FILE__, __LINE__);
                                                        if (SQL_NUMROWS($result) == 1) {
                                                                list($points, $time) = SQL_FETCHROW($result);
                                                                $payment = '0.00000';
@@ -151,78 +166,77 @@ if (isInstalled()) {
                                                        // Free memory
                                                        SQL_FREERESULT($result);
                                                        break;
-                                               }
 
-                                               // Add header
-                                               loadIncludeOnce('inc/header.php');
-
-                                               // Was that mail a valid one?
-                                               if ($isValid === true) {
-                                                       // If time is zero seconds we have a sponsor mail. 1 Second shall be set to avoid problems
-                                                       if (($time == '0') && ($payment > 0)) { $URL = constant('URL'); $time = '1'; }
-                                                       if (($time > 0) && (($payment > 0) || ($points > 0))) {
-                                                               // He can confirm this mail!
-                                                               // Export data into constants for the template
-                                                               define('_UID_VALUE' , $url_uid);
-                                                               define('_TYPE_VALUE', $type);
-                                                               define('_DATA_VALUE', $urlId);
-                                                               define('_URL_VALUE' , DEREFERER($URL));
-
-                                                               // Load template
-                                                               LOAD_TEMPLATE('mailid_frames');
-                                                       } else {
-                                                               $msg = getCode('DATA_INVALID');
-                                                       }
+                                               default: // Invalid mail type
+                                                       debug_report_bug('Invalid mail type ' . $ltype . ' detected.');
+                                                       break;
+                                       }
+
+                                       // Add header
+                                       loadIncludeOnce('inc/header.php');
+
+                                       // Was that mail a valid one?
+                                       if ($isValid === true) {
+                                               // If time is zero seconds we have a sponsor mail. 1 Second shall be set to avoid problems
+                                               if (($time == '0') && ($payment > 0)) { $URL = constant('URL'); $time = '1'; }
+                                               if (($time > 0) && (($payment > 0) || ($points > 0))) {
+                                                       // He can confirm this mail!
+                                                       // Export data into constants for the template
+                                                       // @TODO Rewrite these constants
+                                                       define('_UID_VALUE' , $url_uid);
+                                                       define('_TYPE_VALUE', $type);
+                                                       define('_DATA_VALUE', $urlId);
+                                                       define('_URL_VALUE' , DEREFERER($URL));
+
+                                                       // Load template
+                                                       LOAD_TEMPLATE('mailid_frames');
                                                } else {
-                                                       $msg = getCode('POSSIBLE_INVALID');
+                                                       $errorCode = getCode('DATA_INVALID');
                                                }
                                        } else {
-                                               $msg = getCode('ACCOUNT_LOCKED');
+                                               $errorCode = getCode('POSSIBLE_INVALID');
                                        }
                                } else {
-                                       SQL_FREERESULT($result);
-                                       $msg = getCode('USER_404');
+                                       $errorCode = getCode('ACCOUNT_LOCKED');
                                }
                        } else {
                                SQL_FREERESULT($result);
-                               $msg = getCode('STATS_404');
+                               $errorCode = getCode('USER_404');
                        }
                } else {
                        SQL_FREERESULT($result);
-                       $msg = getCode('ALREADY_CONFIRMED');
+                       $errorCode = getCode('STATS_404');
                }
        } else {
-               // Nothing entered
-               $msg = getCode('ERROR_MAILID');
+               SQL_FREERESULT($result);
+               $errorCode = getCode('ALREADY_CONFIRMED');
        }
+} else {
+       // Nothing entered
+       $errorCode = getCode('ERROR_MAILID');
+}
 
-       // Error code is set?
-       if (!empty($msg)) {
-               switch (getConfig('mailid_error_redirect')) {
-                       case 'INDEX': // Redirect to index page
-                               redirectToUrl('modules.php?module=index&msg='.$msg.'&ext=mailid');
-                               break;
-
-                       case 'REJECT': // Redirect to rejection page
-                               LOAD_CONFIGURED_URL('reject_url');
-                               break;
-
-                       default:
-                               DEBUG_LOG(__FILE__, __LINE__, sprintf("Unknown status %s detected in mailid_error_redirect.", getConfig('mailid_error_redirect')));
-                               redirectToUrl('modules.php?module=index&msg=' . getCode('UNKNOWN_STATUS') . '&ext=mailid');
-                               break;
-               }
-       } else {
-               // Include footer
-               loadIncludeOnce('inc/footer.php');
+// Error code is set?
+if (!empty($errorCode)) {
+       // @TODO Rewrite this to a filter
+       switch (getConfig('mailid_error_redirect')) {
+               case 'INDEX': // Redirect to index page
+                       redirectToUrl('modules.php?module=index&msg=' . $errorCode . '&ext=mailid');
+                       break;
+
+               case 'REJECT': // Redirect to rejection page
+                       redirectToConfiguredUrl('reject_url');
+                       break;
+
+               default:
+                       DEBUG_LOG(__FILE__, __LINE__, sprintf("Unknown status %s detected in mailid_error_redirect.", getConfig('mailid_error_redirect')));
+                       redirectToUrl('modules.php?module=index&msg=' . getCode('UNKNOWN_STATUS') . '&ext=mailid');
+                       break;
        }
 } else {
-       // You have to install first!
-       redirectToUrl('install.php');
+       // Include footer
+       loadIncludeOnce('inc/footer.php');
 }
 
-// Shutdown
-shutdown();
-
-//
+// [EOF]
 ?>