$sql = "UPDATE signup SET total_friends = total_friends-1, popularity = popularity-2 WHERE UID = " . $uid . " LIMIT 1";
$conn->execute($sql);
$sql = "UPDATE signup SET points = points-2 WHERE UID = " . $fid . " LIMIT 1";
$conn->execute($sql);
$message = $lang['ajax.reject_friend_success'];
$sql = "SELECT u.username, u.email, p.friend_request FROM signup AS u, users_prefs AS p \n WHERE u.UID = " . $fid . " AND u.UID = p.UID LIMIT 1";
$rs = $conn->execute($sql);
if ($conn->Affected_Rows() === 1 && $rs->fields['friend_request'] == '1') {
$to = $rs->fields['email'];
$receiver = $rs->fields['username'];
$sql = "SELECT username FROM signup WHERE UID = " . $uid . " LIMIT 1";
$rs = $conn->execute($sql);
if ($conn->Affected_Rows() === 1) {
$username = $rs->fields['username'];
require $config['BASE_DIR'] . '/classes/email.class.php';
$mail = new VMail();
$search = array('{$site_title}', '{$username}', '{$baseurl}', '{$site_name}', '{$receiver}');
$replace = array($config['site_title'], $username, $config['BASE_URL'], $config['site_name'], $receiver);
$mail->sendPredefined($to, 'request_rejected', $search, $replace);
}
}
} else {
$message = $lang['ajax.reject_friend_missing'];
}
} else {
$message = $lang['ajax.reject_friend_login'];
}
} else {
$message = 'Invalid request!?';
}
echo $message;
$code .= '</div>';
$code .= '<div class="clear"></div>';
$code .= '</div>';
$code .= '</div>';
$data['code'] = $code;
$data['cid'] = $cid;
$data['bid'] = $bid;
$_SESSION['b_comment_added'] = time();
$sql = "SELECT b.UID, b.title, s.email, u.blog_comment \n FROM blog AS b, users_prefs AS u, signup AS s \n WHERE b.BID = " . $bid . " \n AND b.UID = u.UID \n AND b.UID = s.UID \n LIMIT 1";
$rs = $conn->execute($sql);
if ($conn->Affected_Rows() === 1) {
$prefs_b_comment = $rs->fields['blog_comment'];
if ($prefs_b_comment == '1') {
$email = $rs->fields['email'];
$title = $rs->fields['title'];
require $config['BASE_DIR'] . '/classes/file.class.php';
require $config['BASE_DIR'] . '/classes/email.class.php';
$blog_link = '<a href="' . $config['BASE_URL'] . '/blog/' . $bid . '/' . prepare_string($title) . '">' . $config['BASE_URL'] . '/blog/' . $bid . '/' . prepare_string($title) . '</a>';
$search = array('{$username}', '{$site_title}', '{$site_name}', '{$baseurl}', '{$blog_link}');
$replace = array($_SESSION['username'], $config['site_title'], $config['site_name'], $config['BASE_URL'], $blog_link);
$mail = new VMail();
$mail->sendPredefined($email, 'blog_comment', $search, $replace);
}
}
}
} else {
$data['msg'] = $lang['ajax.comment_login'];
}
}
echo json_encode($data);
die;
function send_album_approve_email($album_id)
{
global $config, $conn;
$sql = "SELECT a.AID, a.name, s.username, s.email FROM albums AS a, signup AS s\n\t WHERE a.AID = " . intval($album_id) . " AND a.UID = s.UID\n\t\t\t\t LIMIT 1";
$rs = $conn->execute($sql);
$aid = intval($rs->fields['AID']);
$name = $rs->fields['name'];
$username = $rs->fields['username'];
$email = $rs->fields['email'];
$album_url = $config['BASE_URL'] . '/album/' . $aid . '/' . prepare_string($name);
$album_link = '<a href="' . $album_url . '">' . $album_url . '</a>';
$search = array('{$site_title}', '{$site_name}', '{$username}', '{$album_link}', '{$baseurl}');
$replace = array($config['site_title'], $config['site_name'], $username, $album_link, $config['BASE_URL']);
if (!class_exists('VMail')) {
require $config['BASE_DIR'] . '/classes/email.class.php';
}
$mail = new VMail();
$mail->sendPredefined($email, 'video_approve', $search, $replace);
}
$dst = $config['BASE_DIR'] . '/media/albums/' . $album_id . '.jpg';
$image->process($src, $dst, 'MAX_WIDTH', 400, 0);
$image->resize(true, true);
$sql = "UPDATE albums SET total_photos = " . intval($photos) . " WHERE AID = " . $album_id . " LIMIT 1";
$conn->execute($sql);
$sql = "UPDATE channel SET total_albums = total_albums+1 WHERE CHID = " . $category . " LIMIT 1";
$conn->execute($sql);
$sql = "UPDATE signup SET total_albums = total_albums+1, points = points+5 WHERE UID = " . $uid . " LIMIT 1";
$conn->execute($sql);
$album_url = $config['BASE_URL'] . '/album/' . $album_id . '/' . prepare_string($name);
$album_link = '<a href="' . $album_url . '">' . $album_url . '</a>';
$search = array('{$site_title}', '{$site_name}', '{$username}', '{$album_link}', '{$baseurl}');
$replace = array($config['site_title'], $config['site_name'], $_SESSION['username'], $album_link, $config['BASE_URL']);
$mail = new VMail();
if ($config['approve'] == '0') {
$mail->sendPredefined($_SESSION['email'], 'photo_approve', $search, $replace);
} else {
$mail->sendPredefined($_SESSION['email'], 'photo_upload', $search, $replace);
}
$album['name'] = '';
$album['category'] = 0;
$album['tags'] = '';
$album['anonymous'] = 'no';
$album['type'] = 'public';
if ($config['approve_photos'] == '1') {
$messages[] = translate('upload.album_approve', $config['site_name']);
} else {
$messages[] = translate('upload.album_success', $config['site_name'], $album_url, htmlspecialchars($name, ENT_QUOTES, 'UTF-8'));
}
}
}
$search = array('{$site_title}', '{$username}', '{$baseurl}', '{$site_name}', '{$receiver}');
$replace = array($config['site_title'], $username, $config['BASE_URL'], $config['site_name'], $receiver);
$mail = new VMail();
$mail->sendPredefined($to, 'request_approved', $search, $replace);
}
}
} else {
$sql = "INSERT INTO friends ( UID, FID, message, invite_date, status )\n \t VALUES (" . $user_id . ", " . $uid . ", '" . mysql_real_escape_string($msg) . "', '" . date('Y-m-d') . "', 'Pending')";
$conn->execute($sql);
$sql = "SELECT p.friend_request, s.email, s.username FROM users_prefs AS p, signup AS s\n \t WHERE p.UID = " . $user_id . " AND p.UID = s.UID LIMIT 1";
$rs = $conn->execute($sql);
$friend_request = $rs->fields['friend_request'];
$to = $rs->fields['email'];
$receiver = $rs->fields['username'];
if ($friend_request == '1') {
require $config['BASE_DIR'] . '/classes/email.class.php';
$search = array('{$username}', '{$site_name}', '{$baseurl}', '{$receiver}');
$replace = array($_SESSION['username'], $config['site_name'], $config['BASE_URL'], $receiver);
$mail = new VMail();
$mail->sendPredefined($to, 'friend_request', $search, $replace);
}
$response = show_msg($lang['ajax.invite_friend_sent']);
}
}
}
} else {
$response = show_err($lang['ajax.invite_friend_login']);
}
}
echo $response;
die;
if ($conn->Affected_Rows() == 1) {
$sql = "UPDATE friends SET status = 'Confirmed' WHERE UID = " . $uid . " AND FID = " . $fid . " LIMIT 1";
$conn->execute($sql);
$sql = "INSERT INTO friends ( UID, FID, invite_date, status)\n VALUES (" . $fid . ", " . $uid . ", '" . date('Y-m-d') . "', 'Confirmed')";
$conn->execute($sql);
$sql = "UPDATE signup SET total_friends = total_friends+1, popularity = popularity+3 WHERE UID = " . $uid . " LIMIT 1";
$conn->execute($sql);
$sql = "UPDATE signup SET total_friends = total_friends+1, points = points+2 WHERE UID = " . $fid . " LIMIT 1";
$conn->execute($sql);
$sql = "SELECT u.username, u.email, p.friend_request FROM signup AS u, users_prefs AS p\n WHERE u.UID = " . $fid . " AND u.UID = p.UID LIMIT 1";
$rs = $conn->execute($sql);
$message = $lang['ajax.accept_friend_success'];
if ($conn->Affected_Rows() === 1 && $rs->fields['friend_request'] == '1') {
$to = $rs->fields['email'];
$receiver = $rs->fields['username'];
$sql = "SELECT username FROM signup WHERE UID = " . $uid . " LIMIT 1";
$rs = $conn->execute($sql);
if ($conn->Affected_Rows() === 1) {
$username = $rs->fields['username'];
require $config['BASE_DIR'] . '/classes/email.class.php';
$search = array('{$site_title}', '{$username}', '{$baseurl}', '{$site_name}', '{$receiver}');
$replace = array($config['site_title'], $username, $config['BASE_URL'], $config['site_name'], $receiver);
$mail = new VMail();
$mail->sendPredefined($to, 'request_approved', $search, $replace);
}
}
}
}
}
echo $message;
die;
$sql_add[] = "'" . mysql_real_escape_string($user) . "'";
}
$sql = "SELECT email FROM signup WHERE username in (" . implode(',', $sql_add) . ")";
$rs = $conn->execute($sql);
$users_emails = $rs->getrows();
foreach ($users_emails as $user) {
$emails[] = $user['email'];
}
}
if (!$emails) {
$data['msg'] = show_err_mb($lang['ajax.share_recipient_valid']);
} else {
$sql = "SELECT title FROM game WHERE GID = " . $game_id . " LIMIT 1";
$rs = $conn->execute($sql);
if ($conn->Affected_Rows() == 1) {
$title = $rs->fields['title'];
$url = '<a href="' . $config['BASE_URL'] . '/game/' . $game_id . '/' . prepare_string($title) . '">' . $config['BASE_URL'] . '/game/' . $game_id . '/' . prepare_string($title) . '</a>';
$search = array('{$site_name}', '{$site_title}', '{$sender_name}', '{$message}', '{$baseurl}', '{$game_link}');
$replace = array($config['site_name'], $config['site_title'], $from, $message, $config['BASE_URL'], $url);
$mail = new VMail();
$mail->sendPredefined($emails, 'share_game', $search, $replace);
$data['status'] = 1;
$data['msg'] = show_msg_mb($lang['ajax.share_success']);
} else {
$data['msg'] = show_err_mb($lang['ajax.share_game_failed']);
}
}
}
}
echo json_encode($data);
die;
