function privmess_receive() { if (isset($_POST['privmess_send'])) { privmess_send($_SESSION[PREFIX . 'user_id'], user_get_id_from_username($_POST['receiver']), $_POST['subject'], $_POST['message']); } else { if (isset($_GET['message_id'])) { if (isset($_GET['privmess_delete'])) { //Mark as deleted $sql = "UPDATE " . PREFIX . "privmess \r\n\t\t\t\tSET deleted=NOW()\r\n\t\t\t\tWHERE reciever='" . sql_safe($_SESSION[PREFIX . 'user_id']) . "'\r\n\t\t\t\tAND id=" . sql_safe($_GET['message_id']) . ";"; mysql_query($sql); } else { if (isset($_GET['privmess_mark_unread'])) { //Mark as NOT opened $sql = "UPDATE " . PREFIX . "privmess \r\n\t\t\t\tSET opened=NULL\r\n\t\t\t\tWHERE reciever='" . sql_safe($_SESSION[PREFIX . 'user_id']) . "'\r\n\t\t\t\tAND id=" . sql_safe($_GET['message_id']) . ";"; mysql_query($sql); } else { //Mark as opened $sql = "UPDATE " . PREFIX . "privmess \r\n\t\t\t\tSET opened=NOW()\r\n\t\t\t\tWHERE reciever='" . sql_safe($_SESSION[PREFIX . 'user_id']) . "'\r\n\t\t\t\tAND id=" . sql_safe($_GET['message_id']) . ";"; mysql_query($sql); } } } } }
function usermessage_send_to_user($user, $message_event) { // echo "<br />DEBUG1303: usermessage_send_to_user($user, $message_event)"; $sql = "SELECT type, subject, message, once, reward, sendby FROM " . PREFIX . "messages_to_users WHERE event='" . sql_safe($message_event) . "' ORDER BY activated DESC LIMIT 0,1"; if ($mm = mysql_query($sql)) { if ($m = mysql_fetch_array($mm)) { $adress = ""; $sendby = explode(",", $m['sendby']); if (in_array("insite_privmess", $sendby)) { //Skicka ett ingame-meddelande till användaren med meddelandet $privmess_id = privmess_send(0, $user, $m['subject'], $m['message'], FALSE); $adress .= "insite_privmess"; } if (in_array("insite_notice", $sendby)) { notice_send($user, $message_event, $m['type'], $m['subject'], $m['message']); if ($adress != "") { $adress .= ", "; } $adress .= "insite_notice"; } if (in_array("email", $sendby)) { $email = user_get_email($user); mailer_send_mail($adress, user_get_name($user), $m['subject'], $m['message']); if ($adress != "") { $adress .= ", "; } $adress .= $email; } //Ge eventuellt belöning if ($m['reward'] > 0) { money_transaction(0, $user, $m['reward'], "Reward", $m['subject']); } //lägg in att detta skickats i messages_to_users_sent $sql = "INSERT INTO " . PREFIX . "messages_to_users_sent SET\r\n\t\t\t\tuser='******', \r\n\t\t\t\tmessage_event='" . sql_safe($message_event) . "',\r\n\t\t\t\tadress='" . $adress . "'"; if (isset($privmess_id)) { $sql .= ", privmess_id=" . sql_safe($privmess_id); } $sql .= ";"; // echo "<br />DEBUG1753: $sql"; mysql_query($sql); } } }