if ($_POST) { $loginPassword = k_encrypt($memberPassword); // Encrypt password $loginResult = mysqli_query($db, "\r\n\t\t\tSELECT *\r\n\t\t\tFROM {$dbinfo[pre]}members\r\n\t\t\tWHERE email = '{$memberEmail}' \r\n\t\t\tAND password = '******'\r\n\t\t\tLIMIT 1\r\n\t\t"); // Pull basic login info from the db $loginRows = mysqli_num_rows($loginResult); // Rows from query if ($loginRows) { try { $loginMember = mysqli_fetch_array($loginResult); if ($loginMember['status'] == 1) { $loggedOutUMEMID = $_SESSION['member']['umem_id']; // Before overwriting this grab the umem_id from the session before the member logged in unset($_SESSION['member']); $memberSess = new memberTools($loginMember['mem_id']); save_activity($loginMember['mem_id'], $mgrlang['pubLogin'], 0, "<strong>{$mgrlang[pubLoggedIn]} ({$_SERVER['REMOTE_ADDR']})</strong>"); // Make entry in the activity log db $_SESSION['member'] = $memberSess->getMemberInfoFromDB($loginMember['umem_id']); if ($_SESSION['member']['umem_id']) { if ($loginMember['membership'] == 1 or $nowGMT < $_SESSION['member']['ms_end_date'] or $_SESSION['member']['ms_end_date'] == '0000-00-00 00:00:00') { $_SESSION['member']['membershipDetails'] = $memberSess->getMembershipInfoFromDB($loginMember['membership']); // Get the membership info and add it to the member session array } else { $_SESSION['member']['membership'] = 1; $_SESSION['member']['membershipDetails'] = $memberSess->getMembershipInfoFromDB(1); // Membership is expired put them on basic free membership } //print_k($_SESSION['member']['membershipDetails']); //exit; $_SESSION['loggedIn'] = 1; // Set the logged in session but make sure first
// Check word filter $tagSplit = explode(' ', $newTag); foreach ($tagSplit as $testTag) { if (in_array($testTag, $blockedWords)) { echo '{"errorCode": "newTagPending","errorMessage": "' . $lang['tagNotAccepted'] . '","tagID": "0"}'; // // Word blocked exit; } } // Check if tag already exists $checkTagResult = mysqli_query($db, "SELECT SQL_CALC_FOUND_ROWS * FROM {$dbinfo[pre]}keywords WHERE media_id = '{$mediaID}' AND keyword = '{$newTag}'"); if (!getRows()) { if ($_SESSION['loggedIn']) { $user = $_SESSION['member']['f_name'] . ' ' . $_SESSION['member']['l_name']; // User name from member name save_activity($_SESSION['member']['mem_id'], $mgrlang['pubNewTag'], 0, "<strong>({$mediaID})</strong>"); // Make entry in the activity log db - only if member is logged in $autoApprove = $_SESSION['member']['membershipDetails']['tagging_approval'] ? 1 : 0; // Check if this should auto approve - check membership } else { $user = $mgrlang['gen_visitor']; // User is guest $autoApprove = $config['settings']['tagging_system_aa'] ? 1 : 0; // Check if this should auto approve - check guest settings } $memberID = $_SESSION['member']['mem_id']; // member id $language = strtoupper($_SESSION['member']['language']); // current member language // Insert comment to db mysqli_query($db, "\r\n\t\t\t\t\t\t\tINSERT INTO {$dbinfo[pre]}keywords \r\n\t\t\t\t\t\t\t(\r\n\t\t\t\t\t\t\t\tmedia_id,\r\n\t\t\t\t\t\t\t\tkeyword,\r\n\t\t\t\t\t\t\t\tposted,\r\n\t\t\t\t\t\t\t\tlanguage,\r\n\t\t\t\t\t\t\t\tstatus,\r\n\t\t\t\t\t\t\t\tmember_id,\r\n\t\t\t\t\t\t\t\tmemtag \r\n\t\t\t\t\t\t\t)\r\n\t\t\t\t\t\t\tVALUES\r\n\t\t\t\t\t\t\t(\r\n\t\t\t\t\t\t\t\t'{$mediaID}',\r\n\t\t\t\t\t\t\t\t'{$newTag}',\r\n\t\t\t\t\t\t\t\t'{$nowGMT}',\r\n\t\t\t\t\t\t\t\t'{$language}',\r\n\t\t\t\t\t\t\t\t'{$autoApprove}',\r\n\t\t\t\t\t\t\t\t'{$memberID}',\r\n\t\t\t\t\t\t\t\t1\r\n\t\t\t\t\t\t\t)\r\n\t\t\t\t\t\t\t");