Example #1
0
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);
                }
            }
        }
    }
}
Example #2
0
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);
        }
    }
}