X-Git-Url: https://git.mxchange.org/?a=blobdiff_plain;f=inc%2Fmodules%2Fadmin%2Fwhat-lock_user.php;h=46c8d6a9961a5483a6ec51e4b5241ea752c58e2d;hb=5c4d360166de238420eec3e5f4e694befb09ab5d;hp=a23e065e6d94662030d0e32cbec7f8ab1abde745;hpb=f8da178ba4b2f0ed9bfd303d6d32f62b0919a442;p=mailer.git diff --git a/inc/modules/admin/what-lock_user.php b/inc/modules/admin/what-lock_user.php index a23e065e6d..46c8d6a996 100644 --- a/inc/modules/admin/what-lock_user.php +++ b/inc/modules/admin/what-lock_user.php @@ -1,7 +1,7 @@ = '0.3.5') { + if (isExtensionInstalledAndNewer('user', '0.3.5')) { // Lock with reason - SQL_QUERY_ESC("UPDATE `{!_MYSQL_PREFIX!}_user_data` SET `status`='LOCKED',lock_reason='%s',lock_timestamp=NOW() WHERE userid=%s LIMIT 1", - array(REQUEST_POST('reason'), bigintval(REQUEST_GET('uid'))), __FILE__, __LINE__); + SQL_QUERY_ESC("UPDATE `{?_MYSQL_PREFIX?}_user_data` SET `status`='LOCKED', `lock_reason`='%s', `lock_timestamp`=NOW() WHERE `userid`=%s LIMIT 1", + array(postRequestParameter('reason'), bigintval(getRequestParameter('userid'))), __FILE__, __LINE__); } else { // Lock with no lock reason saved - SQL_QUERY_ESC("UPDATE `{!_MYSQL_PREFIX!}_user_data` SET `status`='LOCKED' WHERE userid=%s LIMIT 1", - array(bigintval(REQUEST_GET('uid'))), __FILE__, __LINE__); + SQL_QUERY_ESC("UPDATE `{?_MYSQL_PREFIX?}_user_data` SET `status`='LOCKED' WHERE `userid`=%s LIMIT 1", + array(bigintval(getRequestParameter('userid'))), __FILE__, __LINE__); } // Entry updated? - if (SQL_AFFECTEDROWS() == 1) { + if (!SQL_HASZEROAFFECTED()) { // Send an email to the user! In later version you can optionally switch this feature off - $msg = LOAD_EMAIL_TEMPLATE("lock-user", array('text' => REQUEST_POST('reason')), bigintval(REQUEST_GET('uid'))); + $message = loadEmailTemplate('lock-user', array('text' => postRequestParameter('reason')), bigintval(getRequestParameter('userid'))); // Send away... - sendEmail(bigintval(REQUEST_GET('uid')), ADMIN_LOCKED_SUBJ, $msg); + sendEmail(bigintval(getRequestParameter('userid')), '{--ADMIN_LOCKED_SUBJECT--}', $message); } // END - if // Prepare message - $message = sprintf(getMessage('USER_ACCOUNT_LOCKED'), REQUEST_GET('uid')); - $ACT = true; - } elseif ((REQUEST_ISSET_POST(('unlock'))) && ($status == "LOCKED")) { + $message = getMaskedMessage('ADMIN_USER_ACCOUNT_LOCKED', bigintval(getRequestParameter('userid'))); + $isActive = true; + } elseif ((isPostRequestParameterSet('unlock')) && (getUserData('status') == 'LOCKED')) { // Ok, unlock the account! - if (GET_EXT_VERSION('user') >= '0.3.5') { + if (isExtensionInstalledAndNewer('user', '0.3.5')) { // Reset lock reason as well - SQL_QUERY_ESC("UPDATE `{!_MYSQL_PREFIX!}_user_data` SET `status`='CONFIRMED',lock_reason='',lock_timestamp='0000-00-00 00:00' WHERE userid=%s LIMIT 1", - array(bigintval(REQUEST_GET('uid'))), __FILE__, __LINE__); + SQL_QUERY_ESC("UPDATE + `{?_MYSQL_PREFIX?}_user_data` +SET + `status`='CONFIRMED', + `lock_reason`='', + `lock_timestamp`=NULL +WHERE + `userid`=%s +LIMIT 1", + array(bigintval(getRequestParameter('userid'))), __FILE__, __LINE__); } else { // No lock reason to reset - SQL_QUERY_ESC("UPDATE `{!_MYSQL_PREFIX!}_user_data` SET `status`='CONFIRMED' WHERE userid=%s LIMIT 1", - array(bigintval(REQUEST_GET('uid'))), __FILE__, __LINE__); + SQL_QUERY_ESC("UPDATE `{?_MYSQL_PREFIX?}_user_data` SET `status`='CONFIRMED' WHERE `userid`=%s LIMIT 1", + array(bigintval(getRequestParameter('userid'))), __FILE__, __LINE__); } // Entry updated? - if (SQL_AFFECTEDROWS() == 1) { + if (!SQL_HASZEROAFFECTED()) { // Send an email to the user! In later version you can optionally switch this feature off - $msg = LOAD_EMAIL_TEMPLATE("unlock-user", array('text' => REQUEST_POST('reason')), bigintval(REQUEST_GET('uid'))); + $message = loadEmailTemplate('unlock-user', array('text' => postRequestParameter('reason')), bigintval(getRequestParameter('userid'))); // Send away... - sendEmail(bigintval(REQUEST_GET('uid')), getMessage('ADMIN_UNLOCKED_SUBJ'), $msg); - if (EXT_IS_ACTIVE('rallye')) { - RALLYE_AUTOADD_USER(REQUEST_GET('uid')); + sendEmail(bigintval(getRequestParameter('userid')), '{--ADMIN_UNLOCKED_SUBJECT--}', $message); + if (isExtensionActive('rallye')) { + addUserToReferalRallye(getRequestParameter('userid')); } // END - if } // END - if // Prepare message - $message = sprintf(getMessage('USER_ACCOUNT_UNLOCKED'), REQUEST_GET('uid')); - $ACT = true; - } elseif (REQUEST_ISSET_POST('del')) { + $message = getMaskedMessage('ADMIN_USER_ACCOUNT_UNLOCKED', bigintval(getRequestParameter('userid'))); + $isActive = true; + } elseif (isFormSent('delete')) { // Delete the account - $ACT = true; - loadIncludeOnce("inc/modules/admin/what-del_user.php"); - } elseif (REQUEST_ISSET_POST(('no'))) { + $isActive = true; + loadIncludeOnce('inc/modules/admin/what-del_user.php'); + } elseif (isPostRequestParameterSet('no')) { // Do not lock him... - $URL = ADMIN_CREATE_USERID_LINK(REQUEST_GET('uid')); + $url = adminCreateUserLink(getRequestParameter('userid')); } else { - $result = SQL_QUERY_ESC("SELECT email, surname, family FROM `{!_MYSQL_PREFIX!}_user_data` WHERE userid=%s LIMIT 1", - array(bigintval(REQUEST_GET('uid'))), __FILE__, __LINE__); - - // Entry found? - if (SQL_NUMROWS($result) == 1) { - // Load data - list ($email, $sname, $fname) = SQL_FETCHROW($result); - - // Free result - SQL_FREERESULT($result); - + // Load user data we need + if (fetchUserData(getRequestParameter('userid'))) { // Transfer data to constants for the template - // @TODO Rewrite these all constants - define('__EMAIL', generateMemberEmailLink($email, 'user_data')); - define('__SNAME', $sname); - define('__FNAME', $fname); - define('__UID' , bigintval(REQUEST_GET('uid'))); + $content['userid'] = getRequestParameter('userid'); // Realy want to lock? - switch ($status) - { + switch (getUserData('status')) { case 'CONFIRMED': // Yes, lock him down... ;-) - define('__OK_VALUE' , 'lock'); - define('__HEADER_VALUE', sprintf(getMessage('ADMIN_HEADER_LOCK_ACCOUNT'), constant('__UID'))); - define('__TEXT_VALUE' , sprintf(getMessage('ADMIN_TEXT_LOCK_ACCOUNT'), constant('__UID'))); + $content['ok'] = 'lock'; + $content['header'] = getMaskedMessage('ADMIN_HEADER_LOCK_ACCOUNT', $content['userid']); + $content['text'] = getMaskedMessage('ADMIN_TEXT_LOCK_ACCOUNT', $content['userid']); break; case 'LOCKED': // Unlock the user - define('__OK_VALUE' , 'unlock'); - define('__HEADER_VALUE', sprintf(getMessage('ADMIN_HEADER_UNLOCK_ACCOUNT'), constant('__UID'))); - define('__TEXT_VALUE' , sprintf(getMessage('ADMIN_TEXT_UNLOCK_ACCOUNT'), constant('__UID'))); + $content['ok'] = 'unlock'; + $content['header'] = getMaskedMessage('ADMIN_HEADER_UNLOCK_ACCOUNT', $content['userid']); + $content['text'] = getMaskedMessage('ADMIN_TEXT_UNLOCK_ACCOUNT', $content['userid']); break; case 'UNCONFIRMED': // Unconfirmed accounts cannot be unlocked! - define('__OK_VALUE' , 'del'); - define('__HEADER_VALUE', sprintf(getMessage('ADMIN_HEADER_DEL_ACCOUNT'), constant('__UID'))); - define('__TEXT_VALUE' , sprintf(getMessage('ADMIN_TEXT_DEL_ACCOUNT'), constant('__UID'))); + $content['ok'] = 'delete'; + $content['header'] = getMaskedMessage('ADMIN_HEADER_DELETE_ACCOUNT', $content['userid']); + $content['text'] = getMaskedMessage('ADMIN_TEXT_DELETE_ACCOUNT', $content['userid']); break; } // Output form - LOAD_TEMPLATE('admin_lock_user'); + loadTemplate('admin_lock_user', false, $content); } else { // Account does not exists! - LOAD_TEMPLATE('admin_settings_saved', false, "