Fixes for wrong tewmplate names, new network added:

[mailer.git] / inc / modules / admin / what-edit_sponsor.php

diff --git a/inc/modules/admin/what-edit_sponsor.php b/inc/modules/admin/what-edit_sponsor.php
index 059fce33be377a3814bc9317184646c0f697166d..81d68c22284844be1c10787b320c9d846ab76505 100644 (file)
--- a/inc/modules/admin/what-edit_sponsor.php
+++ b/inc/modules/admin/what-edit_sponsor.php
@@ -40,7 +40,7 @@
 // Some security stuff...
 if ((!defined('__SECURITY')) || (!isAdmin())) {
        die();
-}
+} // END - if
 
 // Add description as navigation point
 addMenuDescription('admin', __FILE__);
@@ -48,14 +48,14 @@ addMenuDescription('admin', __FILE__);
 if ((isGetRequestParameterSet('id')) && (isGetRequestParameterSet('mode'))) {
        // Check for selected sponsor
        $result_main = SQL_QUERY_ESC("SELECT
-       `company`, `position`, `gender`, `surname`, `family`,
+       `id`, `company`, `position`, `gender`, `surname`, `family`,
        `street_nr1`, `street_nr2`, `zip`, `city`, `country`,
        `phone`, `fax`, `cell`, `email`, `url`, `tax_ident`,
        `receive_warnings`, `warning_interval`
 FROM
        `{?_MYSQL_PREFIX?}_sponsor_data`
 WHERE
-       `id`='%s'
+       `id`=%s
 LIMIT 1",
                array(bigintval(getRequestParameter('id'))), __FILE__, __LINE__);
        if (SQL_NUMROWS($result_main) == 1) {
@@ -63,9 +63,6 @@ LIMIT 1",
                $content = SQL_FETCHARRAY($result_main);
 
                // Prepare all data for the template
-               //  Sponsor's id
-               $content['id'] = bigintval(getRequestParameter('id'));
-
                // Init gender
                foreach (array('m', 'f', 'c') as $gender) {
                        $content['gender_' . $gender] = '';
@@ -92,20 +89,20 @@ LIMIT 1",
                                                $points = bigintval(convertCommaToDot(postRequestParameter('points')));
 
                                                // Add points to account
-                                               SQL_QUERY_ESC("UPDATE `{?_MYSQL_PREFIX?}_sponsor_data` SET `points_amount`=`points_amount`+%s WHERE `id`='%s' LIMIT 1",
+                                               SQL_QUERY_ESC("UPDATE `{?_MYSQL_PREFIX?}_sponsor_data` SET `points_amount`=`points_amount`+%s WHERE `id`=%s LIMIT 1",
                                                        array($points, bigintval(getRequestParameter('id'))), __FILE__, __LINE__);
 
                                                // Remember points /reason for the template
-                                               $content['points'] = translateComma($points);
+                                               $content['points'] = $points;
                                                $content['reason'] = secureString(postRequestParameter('reason'));
 
                                                // Send email
                                                $message = loadEmailTemplate('sponsor_add_points', $content);
-                                               sendEmail($content['email'], '{--ADMIN_SPONSOR_ADD_POINTS_SUBJ--}', $message);
+                                               sendEmail($content['email'], '{--ADMIN_SPONSOR_ADD_POINTS_SUBJECT--}', $message);
                                                $message = '{--ADMIN_SPONSOR_POINTS_ADDED--}';
                                        } else {
                                                // No points entered to add!
-                                               $message = '{--ADMIN_SPONSPOR_NO_POINTS_TO_ADD--}';
+                                               $message = '{--ADMIN_SPONSOR_NO_POINTS_TO_ADD--}';
                                        }
                                        break;
 
@@ -115,20 +112,20 @@ LIMIT 1",
                                                $points = bigintval(convertCommaToDot(postRequestParameter('points')));
 
                                                // Add points to account
-                                               SQL_QUERY_ESC("UPDATE `{?_MYSQL_PREFIX?}_sponsor_data` SET `points_used`=`points_used`+%s WHERE `id`='%s' LIMIT 1",
+                                               SQL_QUERY_ESC("UPDATE `{?_MYSQL_PREFIX?}_sponsor_data` SET `points_used`=`points_used`+%s WHERE `id`=%s LIMIT 1",
                                                        array($points, bigintval(getRequestParameter('id'))), __FILE__, __LINE__);
 
                                                // Remember points /reason for the template
-                                               $content['points'] = translateComma($points);
+                                               $content['points'] = $points;
                                                $content['reason'] = secureString(postRequestParameter('reason'));
 
                                                // Send email
                                                $message = loadEmailTemplate('sponsor_sub_points', $content);
-                                               sendEmail($content['email'], '{--ADMIN_SPONSOR_SUB_POINTS_SUBJ--}', $message);
+                                               sendEmail($content['email'], '{--ADMIN_SPONSOR_SUB_POINTS_SUBJECT--}', $message);
                                                $message = '{--ADMIN_SPONSOR_POINTS_SUBTRACTED--}';
                                        } else {
                                                // No points entered to add!
-                                               $message = '{--ADMIN_SPONSPOR_NO_POINTS_TO_SUBTRACT--}';
+                                               $message = '{--ADMIN_SPONSOR_NO_POINTS_TO_SUBTRACT--}';
                                        }
                                        break;
 
@@ -146,7 +143,7 @@ LIMIT 1",
                                        convertSelectionsToTimestamp(postRequestArray(), $DATA, $id, $skip);
 
                                        // Save the sponsor
-                                       handlSponsorRequest(postRequestArray());
+                                       handleSponsorRequest(postRequestArray());
 
                                        // Convert some data for the email template
                                        postRequestParameter('gender'          , translateGender(postRequestParameter('gender')));
@@ -169,12 +166,12 @@ LIMIT 1",
                                // Output message
                                loadTemplate('admin_settings_saved', false, $message);
                        } // END - if
-               } elseif (isFileReadable(sprintf("%stemplates/%s/html/admin/%s.tpl", getConfig('PATH'), getLanguage(), $TPL))) {
+               } elseif (isFileReadable(sprintf("%stemplates/%s/html/admin/%s.tpl", getPath(), getLanguage(), $TPL))) {
                        // Create mailto link
-                       $content['contact'] = '<a href="' . generateEmailLink($content['email'], 'sponsor_data') . '">' . $content['surname'] . ' ' . $content['family'] . '</a>';
+                       $content['contact'] = '<a href="' . generateSponsorEmailLink($content['email'], 'sponsor_data') . '">' . $content['surname'] . ' ' . $content['family'] . '</a>';
 
                        // Load mode template
-                       loadTemplate($TPL);
+                       loadTemplate($TPL, false, $content);
                } else {
                        // Template not found!
                        loadTemplate('admin_settings_saved', false, getMaskedMessage('ADMIN_SPONSOR_MODUS_TPL_404', getRequestParameter('mode')));