<?php
    $_id = isset($_GET['i']) ? intval($_GET['i']) : 0;

    $tracker_bugs = q("SELECT * FROM tracker_bugs WHERE id = " . sq($_id));
    if (!$tracker_bugs_row = mysqli_fetch_array($tracker_bugs))
    {
        header('Location: ./?s=home');
        die;
    }

    if ($tracker_bugs_row['status'] == 250)
    {
        $tracker_bugs_comments = mysqli_query_logged("SELECT * FROM tracker_bugs_comments WHERE link_id = " . sq($_id) . " ORDER BY id DESC LIMIT 1");
        if ($tracker_bugs_comments_row = mysqli_fetch_assoc($tracker_bugs_comments))
        {
            if ($tracker_bugs_comments_row['user_id'] == $GLOBALS['auth']['id'])
            {
                mysqli_query_logged("UPDATE tracker_bugs SET status = '1' WHERE id = " . sq($_id));
            }
        }
    }
    
    header('Location: ./?s=tracker_bugs&i=' . $_id);
    die;
?>