[mirrors/Kyberia-bloodline.git] / inc / eventz / delete_mail.inc

<?php
function delete_mail() {
    global $node,$db,$error;
    $user_id = $_SESSION['user_id'];
    foreach ($_POST['message'] as $chosen =>$value) {
        $set = $db->query("select mail_read,mail_to from mail where mail_id = '$chosen' and mail_from = '$user_id'");
        $set->next();
        if ($set->getString('mail_read') == 'no') {
            $db->query("delete from mail where mail_duplicate_id = '$chosen' and mail_from = '$user_id'");
            $db->update("update users set user_mail = user_mail - 1 where user_id = ". $set->getString('mail_to') ."");
        }
        $db->query("delete from mail where mail_id = '$chosen' and mail_user = '$user_id'");
    }
}
?>
Commit	Line	Data
e586807d	1	<?php
b42b2bf9 H	2	function delete_mail() {
	3	global $node,$db,$error;
	4	$user_id = $_SESSION['user_id'];
	5	foreach ($_POST['message'] as $chosen =>$value) {
	6	$set = $db->query("select mail_read,mail_to from mail where mail_id = '$chosen' and mail_from = '$user_id'");
	7	$set->next();
	8	if ($set->getString('mail_read') == 'no') {
	9	$db->query("delete from mail where mail_duplicate_id = '$chosen' and mail_from = '$user_id'");
	10	$db->update("update users set user_mail = user_mail - 1 where user_id = ". $set->getString('mail_to') ."");
	11	}
	12	$db->query("delete from mail where mail_id = '$chosen' and mail_user = '$user_id'");
	13	}
	14	}
e586807d	15	?>