message-toggle.php

Go to the documentation of this file.

<?php
/*
if (!isset($_POST['token'])) {
    die ('no direct access allowed.');
}
else if ($_POST['token'] != "U3E44ERG0H0M3") {
    die ('no direct access allowed!');
}
*/
include '../../../classes/db.php';
include '../../../classes/alert.php';
include '../classes/messages.php';
 
/* set database object */
if (!isset($db))
{   // create db object if not exists...
    $db = new \YAWK\db();
}
 
$msg_id     =   $_POST['msg_id'];
 
// check status before toggle
$sql = $db->query("SELECT msg_read FROM {plugin_msg} WHERE msg_id='".$msg_id."'");
$res = mysqli_fetch_row($sql);
if ($res[0] === '1')
{   // toggle to unread
    if ($db->query("UPDATE {plugin_msg} SET msg_read='0' WHERE msg_id='".$msg_id."'"))
    {
        echo "message marked as unread";
    }
    else
    {
        die ("failed to mark as unread");
    }
}
else
{   // toggle to read
    if ($db->query("UPDATE {plugin_msg} SET msg_read='1' WHERE msg_id='".$msg_id."'"))
    {
        echo "message marked as read";
    }
    else
    {
        die ("failed to mark as read");
    }
}