X-Git-Url: https://git.mxchange.org/?a=blobdiff_plain;f=inc%2Fmodules%2Fadmin%2Fwhat-list_sponsor.php;h=ca6488743674bc0df580081b45cf77b469055e05;hb=refs%2Fheads%2F0.2.1-FINAL;hp=58b2243640c5f597d2de71bbdd7386ec9aa9c1ec;hpb=49acdb7a7adbcf25a8e8683b5581bfcec72b23bd;p=mailer.git diff --git a/inc/modules/admin/what-list_sponsor.php b/inc/modules/admin/what-list_sponsor.php index 58b2243640..ca64887436 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 - 2015 by Mailer Developer Team * + * Copyright (c) 2009 - 2016 by Mailer Developer Team * * For more information visit: http://mxchange.org * * * * This program is free software; you can redistribute it and/or modify * @@ -46,7 +46,7 @@ addYouAreHereLink('admin', __FILE__); if (isGetRequestElementSet('id')) { // Show detailed informations to a sponsor $result = sqlQueryEscaped("SELECT - `company`, `position`, `gender`, `surname`, `family`, `street_nr1`, `street_nr2`, `zip`, `city`, `country`, + `company`, `position`, `sex`, `surname`, `family`, `street_nr1`, `street_nr2`, `zip`, `city`, `country`, `phone`, `fax`, `cell`, `email`, `url`, `tax_ident`, `status`, UNIX_TIMESTAMP(`sponsor_created`) AS `sponsor_created`, @@ -101,7 +101,7 @@ WHERE // Sponsor found so let's list all his referrals $result = sqlQueryEscaped("SELECT `id`, - `gender`, + `sex`, `surname`, `family`, `email`, @@ -135,7 +135,7 @@ ORDER BY } else { // List all sponsors $result_main = sqlQuery("SELECT - `id`, `gender`, `surname`, `family`, `email`, `status`, + `id`, `sex`, `surname`, `family`, `email`, `status`, UNIX_TIMESTAMP(`sponsor_created`) AS `sponsor_created`, UNIX_TIMESTAMP(`last_online`) AS `last_online`, `points_amount`, `points_used`,