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");
