<?php
    set_time_limit(0);
    
    mysqli_query_logged("TRUNCATE TABLE messages_index");

    $messages = mysqli_query_logged("SELECT * FROM messages ORDER BY id");
    while ($messages_row = mysqli_fetch_assoc($messages))
    {
        $messages_index = mysqli_query_logged("SELECT * FROM messages_index WHERE sender_id = '" . $messages_row['sender_id'] . "' AND receiver_id = '" . $messages_row['recipiant_id'] . "'");
        if ($messages_index_row = mysqli_fetch_assoc($messages_index))
        {
            if ($messages_index_row['last_received'] <= $messages_row['posted_on'])
            {
                mysqli_query_logged("UPDATE messages_index SET last_received = '" . $messages_row['posted_on'] . "', message_id_received = '" . $messages_row['id'] . "' WHERE sender_id = '" . $messages_row['sender_id'] . "' AND receiver_id = '" . $messages_row['recipiant_id'] . "'");
            }
        }
        else
        {
            mysqli_query_logged("INSERT INTO messages_index SET sender_id = '" . $messages_row['sender_id'] . "', receiver_id = '" . $messages_row['recipiant_id'] . "', last_received = '" . $messages_row['posted_on'] . "', message_id_received = '" . $messages_row['id'] . "'");
        }
        
        $messages_index = mysqli_query_logged("SELECT * FROM messages_index WHERE receiver_id = '" . $messages_row['sender_id'] . "' AND sender_id = '" . $messages_row['recipiant_id'] . "'");
        if ($messages_index_row = mysqli_fetch_assoc($messages_index))
        {
            if ($messages_index_row['last_sent'] <= $messages_row['posted_on'])
            {
                mysqli_query_logged("UPDATE messages_index SET last_sent = '" . $messages_row['posted_on'] . "', message_id_sent = '" . $messages_row['id'] . "' WHERE receiver_id = '" . $messages_row['sender_id'] . "' AND sender_id = '" . $messages_row['recipiant_id'] . "'");
            }
        }
        else
        {
            mysqli_query_logged("INSERT INTO messages_index SET receiver_id = '" . $messages_row['sender_id'] . "', sender_id = '" . $messages_row['recipiant_id'] . "', last_sent = '" . $messages_row['posted_on'] . "', message_id_sent = '" . $messages_row['id'] . "'");
        }
    }
?>