X-Git-Url: https://git.mxchange.org/?a=blobdiff_plain;ds=sidebyside;f=inc%2Fmysql-manager.php;h=15a1126c27fbe6fb653f4e6098cf3f0895b892e2;hb=0ee18ff2f17d096211666727d9e47f1528a4d885;hp=531aa79a79f594a34c9ceecd655ed43ce5576bf6;hpb=c25e794a61b597f90bff599307ae4d766a2d3479;p=mailer.git diff --git a/inc/mysql-manager.php b/inc/mysql-manager.php index 531aa79a79..15a1126c27 100644 --- a/inc/mysql-manager.php +++ b/inc/mysql-manager.php @@ -108,8 +108,8 @@ function addYouAreHereLink ($accessLevel, $FQFN, $return = false) { $dummy = substr($search, 0, -4); $ADD .= sprintf(" AND `action`='%s'", getActionFromModuleWhat($accessLevel, $dummy)); - } elseif (($accessLevel == 'sponsor') || ($accessLevel == 'engine')) { - // Sponsor / engine menu + } elseif ($accessLevel == 'sponsor') { + // Sponsor menu $type = 'what'; $search = $file; $modCheck = getModule(); @@ -839,7 +839,7 @@ function getPaymentTitlePrice ($pid, $full=false) { // Get (basicly) the price of given payment id function getPaymentPoints ($pid, $lookFor = 'price') { // Default value... - $data[$lookFor] = '-1'; + $data[$lookFor] = -1; // Search for it in database $result = SQL_QUERY_ESC("SELECT `%s` FROM `{?_MYSQL_PREFIX?}_payments` WHERE `id`=%s LIMIT 1", @@ -1230,7 +1230,7 @@ function sendAdminEmails ($subj, $message) { // Get id number from administrator's login name function getAdminId ($adminLogin) { // By default no admin is found - $data['id'] = '-1'; + $data['id'] = -1; // Check cache if (isset($GLOBALS['cache_array']['admin']['admin_id'][$adminLogin])) { @@ -1285,7 +1285,7 @@ function setCurrentAdminId ($currentAdminId) { // Get password hash from administrator's login name function getAdminHash ($adminId) { // By default an invalid hash is returned - $data['password'] = '-1'; + $data['password'] = -1; if (isAdminHashSet($adminId)) { // Check cache @@ -1449,7 +1449,9 @@ function generateOptionList ($table, $id, $name, $default = '', $special = '', $ } else { // Data from database $SPEC = ', `' . $id . '`'; - if (!empty($special)) $SPEC = ', `' . $special . '`'; + if (!empty($special)) { + $SPEC = ', `' . $special . '`'; + } // END - if // Query the database $result = SQL_QUERY_ESC("SELECT `%s`, `%s`".$SPEC." FROM `{?_MYSQL_PREFIX?}_%s` ".$where." ORDER BY `%s` ASC", @@ -1476,7 +1478,9 @@ function generateOptionList ($table, $id, $name, $default = '', $special = '', $ } // Add it, if set - if (!empty($add)) $add = ' ('.$add.')'; + if (!empty($add)) { + $add = ' ('.$add.')'; + } // END - if // Is the call-back function set? if (!empty($callback)) { @@ -1529,6 +1533,7 @@ function deleteUserAccount ($userid, $reason) { // Init points $data['points'] = '0'; + // Search for the points and user data $result = SQL_QUERY_ESC("SELECT (SUM(p.`points`) - d.`used_points`) AS `points` FROM