X-Git-Url: https://git.mxchange.org/?a=blobdiff_plain;f=inc%2Fmodules%2Fadmin%2Fwhat-unlock_sponsor.php;h=15c1fb40b59d15866d9fb6ed9e359fe7c4b4cd6b;hb=20741b93fd58620af677a7f1039ffd16ea6ec689;hp=d83df3bcb19567b4560241d156fc5debf99f58df;hpb=330dbb3e2b34450cd1665497506455e195a0a166;p=mailer.git diff --git a/inc/modules/admin/what-unlock_sponsor.php b/inc/modules/admin/what-unlock_sponsor.php index d83df3bcb1..15c1fb40b5 100644 --- a/inc/modules/admin/what-unlock_sponsor.php +++ b/inc/modules/admin/what-unlock_sponsor.php @@ -17,7 +17,7 @@ * -------------------------------------------------------------------- * * Copyright (c) 2003 - 2009 by Roland Haeder * * Copyright (c) 2009 - 2011 by Mailer Developer Team * - * For more information visit: http://www.mxchange.org * + * For more information visit: http://mxchange.org * * * * This program is free software; you can redistribute it and/or modify * * it under the terms of the GNU General Public License as published by * @@ -48,7 +48,7 @@ if (isFormSent()) { // Does he have selected at least one sponsor? if (ifPostContainsSelections('id')) { // At least one entry selected - foreach (postRequestParameter('id') as $id => $selected) { + foreach (postRequestElement('id') as $id => $selected) { // Secure id number and init $content $content = array( 'id' => bigintval($id), @@ -57,9 +57,9 @@ if (isFormSent()) { // Load his personal data $result_main = SQL_QUERY_ESC("SELECT - `id`, `gender`, `surname`, `family`, `email`, `remote_addr`, + `id`,`gender`,`surname`,`family`,`email`,`remote_addr`, UNIX_TIMESTAMP(`sponsor_created`) AS `sponsor_created`, - `points_amount`, `points_used`, + `points_amount`,`points_used`, (`points_amount` + `points_used`) AS `points`, `refid` FROM @@ -158,9 +158,9 @@ LIMIT 1", if (!SQL_HASZEROAFFECTED()) { // Load referal's data $result = SQL_QUERY_ESC("SELECT - `id`, `gender`, `surname`, `family`, `email`, + `id`,`gender`,`surname`,`family`,`email`, (`points_amount` - `points_used`) AS `points`, - `receive_warnings`, `ref_count` AS refs + `receive_warnings`,`ref_count` AS refs FROM `{?_MYSQL_PREFIX?}_sponsor_data` WHERE @@ -193,7 +193,7 @@ LIMIT 1", // Begin listing of all pending sponsor accounts $result = SQL_QUERY("SELECT - `id`, `gender`, `surname`, `family`, `email`, `remote_addr`, + `id`,`gender`,`surname`,`family`,`email`,`remote_addr`, UNIX_TIMESTAMP(`sponsor_created`) AS `sponsor_created` FROM `{?_MYSQL_PREFIX?}_sponsor_data`