X-Git-Url: https://git.mxchange.org/?a=blobdiff_plain;f=inc%2Fmodules%2Fadmin%2Fwhat-list_sponsor.php;h=2eaa90720541809462e6f32a76eff72deeabe0cd;hb=c6a411b7d235e1d3a36321fcb7ac806a0e6509f7;hp=d518b7f4058f404787daab4031c19fe44223b164;hpb=db1f357f01e1ebb16a31fdcd3e432a1d19b54ae3;p=mailer.git diff --git a/inc/modules/admin/what-list_sponsor.php b/inc/modules/admin/what-list_sponsor.php index d518b7f405..2eaa907205 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 * @@ -46,14 +46,14 @@ addYouAreHereLink('admin', __FILE__); if (isGetRequestParameterSet('id')) { // Show detailed informations to a sponsor $result = SQL_QUERY_ESC("SELECT - `company`, `position`, `gender`, `surname`, `family`, `street_nr1`, `street_nr2`, `zip`, `city`, `country`, - `phone`, `fax`, `cell`, `email`, `url`, `tax_ident`, + `company`,`position`,`gender`,`surname`,`family`,`street_nr1`,`street_nr2`,`zip`,`city`,`country`, + `phone`,`fax`,`cell`,`email`,`url`,`tax_ident`, `status`, UNIX_TIMESTAMP(`sponsor_created`) AS `sponsor_created`, UNIX_TIMESTAMP(`last_online`) AS `last_online`, UNIX_TIMESTAMP(`last_change`) AS `last_change`, `receive_warnings`, - `points_amount`, `points_used`, `remote_addr`, `warning_interval`, `refid`, `ref_count` + `points_amount`,`points_used`,`remote_addr`,`warning_interval`,`refid`,`ref_count` FROM `{?_MYSQL_PREFIX?}_sponsor_data` WHERE @@ -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('{%message,ADMIN_SPONSOR_404=' . bigintval(getRequestParameter('id')) . '%}'); } // Free result @@ -100,11 +100,11 @@ WHERE // Sponsor found so let's list all his referals $result = SQL_QUERY_ESC("SELECT - `id`, `gender`, `surname`, `family`, `email`, `status`, + `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`, `ref_count` + `points_amount`,`points_used`, + `remote_addr`,`ref_count` FROM `{?_MYSQL_PREFIX?}_sponsor_data` WHERE @@ -119,19 +119,19 @@ 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('{%message,ADMIN_SPONSOR_404=' . bigintval(getRequestParameter('refid')) . '%}'); } } else { // List all sponsors $result_main = SQL_QUERY("SELECT - `id`, `gender`, `surname`, `family`, `email`, `status`, + `id`,`gender`,`surname`,`family`,`email`,`status`, UNIX_TIMESTAMP(`sponsor_created`) AS `sponsor_created`, UNIX_TIMESTAMP(`last_online`) AS `last_online`, - `points_amount`, `points_used`, + `points_amount`,`points_used`, (`points_amount` + `points_used`) AS `points`, `remote_addr` FROM @@ -140,7 +140,7 @@ 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 @@ -159,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--}'); } }