X-Git-Url: https://git.mxchange.org/?a=blobdiff_plain;f=inc%2Fmodules%2Fadmin%2Fwhat-unlock_sponsor.php;h=25242a5380b563b39521e0fc23e42f179904cd0d;hb=e297ccd93221dfbfd99f90ed160fb20df3524df0;hp=74bd7e8ce913676eee5cbe2d93cf4d3064d98e09;hpb=db0c6702086eea2c44d0aae1702dc2e77a0afc4e;p=mailer.git diff --git a/inc/modules/admin/what-unlock_sponsor.php b/inc/modules/admin/what-unlock_sponsor.php index 74bd7e8ce9..25242a5380 100644 --- a/inc/modules/admin/what-unlock_sponsor.php +++ b/inc/modules/admin/what-unlock_sponsor.php @@ -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 @@ -70,7 +70,7 @@ WHERE LIMIT 1", array($content['id']), __FILE__, __LINE__); - /// Is there an entry? + // Is there an entry? if (SQL_NUMROWS($result_main) == 1) { // Load data $content = SQL_FETCHARRAY($result_main); @@ -124,7 +124,7 @@ ORDER BY SQL_FREERESULT($result); } else { // Not found - displayMessage(getMaskedMessage('ADMIN_SPONSOR_ACCOUNT_404_ALREADY_CONFIRMED', $content['id'])); + displayMessage('{%message,ADMIN_SPONSOR_ACCOUNT_404_ALREADY_CONFIRMED=' . $content['id'] . '%}'); return; } @@ -158,9 +158,9 @@ LIMIT 1", if (!SQL_HASZEROAFFECTED()) { // Load referal's data $result = SQL_QUERY_ESC("SELECT - `id`, `gender`, `surname`, `family`, `email`, - (`points_amount` - `points_used`) AS points, - `receive_warnings`, `ref_count` AS refs + `id`,`gender`,`surname`,`family`,`email`, + (`points_amount` - `points_used`) AS `points`, + `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`