X-Git-Url: https://git.mxchange.org/?a=blobdiff_plain;f=inc%2Fmodules%2Fadmin%2Fwhat-list_sponsor.php;h=713c1219fdf915dd56ef8dbeb4f250995db00f75;hb=2e394cb5b8a6225a39a6942b1fcc17c37a17a175;hp=89db1c6400e981f4625d30f1147e5e2fb66f6763;hpb=c8d76610eb94093d4eed4fcd8a6cb72e74c8f6d8;p=mailer.git diff --git a/inc/modules/admin/what-list_sponsor.php b/inc/modules/admin/what-list_sponsor.php index 89db1c6400..713c1219fd 100644 --- a/inc/modules/admin/what-list_sponsor.php +++ b/inc/modules/admin/what-list_sponsor.php @@ -16,7 +16,7 @@ * $Author:: $ * * -------------------------------------------------------------------- * * Copyright (c) 2003 - 2009 by Roland Haeder * - * Copyright (c) 2009, 2010 by Mailer Developer Team * + * Copyright (c) 2009 - 2011 by Mailer Developer Team * * For more information visit: http://www.mxchange.org * * * * This program is free software; you can redistribute it and/or modify * @@ -41,7 +41,7 @@ if ((!defined('__SECURITY')) || (!isAdmin())) { } // END - if // Add description as navigation point -addMenuDescription('admin', __FILE__); +addYouAreHereLink('admin', __FILE__); if (isGetRequestParameterSet('id')) { // Show detailed informations to a sponsor @@ -74,7 +74,7 @@ WHERE $content['id'] = getRequestParameter('id'); // Contact data $content['email_link'] = generateEmailLink($content['email'], 'sponsor_data'); - // Timestamps + // Epoche times $content['sponsor_created'] = generateDateTime($content['sponsor_created'], 2); $content['last_online'] = generateDateTime($content['last_online'], 2); $content['last_change'] = generateDateTime($content['last_change'], 2); @@ -85,7 +85,7 @@ WHERE loadTemplate('admin_list_sponsor_details', false, $content); } else { // Sponsor not found - loadTemplate('admin_settings_saved', false, getMaskedMessage('ADMIN_SPONSOR_404', bigintval(getRequestParameter('id')))); + displayMessage(getMaskedMessage('ADMIN_SPONSOR_404', bigintval(getRequestParameter('id')))); } // Free result @@ -119,11 +119,11 @@ ORDER BY SQL_FREERESULT($result); } else { // No refs made so far - loadTemplate('admin_settings_saved', false, getMaskedMessage('ADMIN_SPONSOR_REFS_404', '' . bigintval(getRequestParameter('refid')) . '')); + displayMessage(getMaskedMessage('ADMIN_SPONSOR_REFS_404', '' . bigintval(getRequestParameter('refid')) . '')); } } else { // Sponsor not found - loadTemplate('admin_settings_saved', false, getMaskedMessage('ADMIN_SPONSOR_404', bigintval(getRequestParameter('refid')))); + displayMessage(getMaskedMessage('ADMIN_SPONSOR_404', bigintval(getRequestParameter('refid')))); } } else { // List all sponsors @@ -131,21 +131,22 @@ ORDER BY `id`, `gender`, `surname`, `family`, `email`, `status`, UNIX_TIMESTAMP(`sponsor_created`) AS `sponsor_created`, UNIX_TIMESTAMP(`last_online`) AS `last_online`, - `points_amount`, `points_used`, `remote_addr` + `points_amount`, `points_used`, + (`points_amount` + `points_used`) AS `points`, + `remote_addr` FROM `{?_MYSQL_PREFIX?}_sponsor_data` ORDER BY `id` ASC", __FILE__, __LINE__); if (!SQL_HASZERONUMS($result_main)) { - // At least one sponsor found! + // At least one sponsor found $OUT = ''; while ($content = SQL_FETCHARRAY($result_main)) { // Transfer data to array $content['email'] = generateEmailLink($content['email'], 'sponsor_data'); $content['sponsor_created'] = generateDateTime($content['sponsor_created'], 2); $content['last_online'] = generateDateTime($content['last_online'], 2); - $content['points'] = ($content['points_amount'] - $content['points_used']); // Load row template $OUT .= loadTemplate('admin_list_sponsor_row', true, $content); @@ -158,7 +159,7 @@ ORDER BY loadTemplate('admin_list_sponsor', false, $OUT); } else { // No sponsors registered so far - loadTemplate('admin_settings_saved', false, '{--ADMIN_SPONSOR_NONE_REGISTERED--}'); + displayMessage('{--ADMIN_SPONSOR_NONE_REGISTERED--}'); } }