<?php
    $GLOBALS['highlight'] = 'graphix';

    require_once('include/functions/pages.php');
    
    $_page = isset($_GET['p']) ? intval($_GET['p']) : 1;

    include('include/parts/header.php');

    $image_count = mysqli_fetch_array(mysqli_query_logged("SELECT COUNT(*) AS num FROM images"));
    $page_count = ceil($image_count['num'] / IMAGES_PER_PAGE);
    $pages = '<span class="pages">Page: ' . pages('?s=graphix', $_page, $page_count) . '</span>';
?>

<div class="header">
<table width="100%" border="0" cellpadding="0" cellspacing="0"><tr><td valign="top">
Graphix<?php echo ($image_count['num']) ? '<br />' . $pages : '' ?>
<?php
    if ($GLOBALS['auth']['id'])
    {
        echo '</td><td align="right" valign="top" style="color: #cccccc; font-weight: normal;">[ <a href="?s=upload_image">Upload Graphix</a> ]';
    }
?>
</td></tr></table>
</div>

<div class="content" style="padding: 0px 5px 5px 5px;">
<?php
    $images = mysqli_query_logged("SELECT id FROM images ORDER BY posted_on DESC LIMIT " . (($_page - 1) * IMAGES_PER_PAGE) . ", " . IMAGES_PER_PAGE);
    if (mysqli_num_rows($images))
    {
        echo '<table width="100%" cellpadding="0" cellspacing="0" border="0"><tr><td>';
        while ($image = mysqli_fetch_array($images))
        {
            $comment_count = mysqli_fetch_array(mysqli_query_logged("SELECT COUNT(*) AS num FROM images_comments WHERE link_id = '" . $image['id'] . "'"));
            echo box_image_top();
            echo '<table width="' . THUMB_WIDTH . '" height="' . THUMB_HEIGHT . '" border="0" cellpadding="0" cellspacing="0"><tr><td align="center" valign="top">';
            echo '<a href="?s=image&i=' . $image['id'] . '"><img src="?g=thumb&i=' . $image['id'] . '" width="' . THUMB_WIDTH . '" height="' . THUMB_HEIGHT . '" alt="" style="border: 0px;"></a><br />';
            echo '<div style="padding: 4px 0px 0px 0px;"></div>';
            echo '<b>' . $comment_count['num'] . '</b> Comments<br />';
            echo '</td></tr></table>';
            echo box_image_bottom();
        }
        echo '</td></tr></table>';
    }
    else
    {
        echo '<div style="padding: 5px 0px 0px 0px;">There are no images in the database.';
    }
?>
</div>
<?php
    if ($image_count['num'])
    {
        echo '<div class="header">' . $pages . '</div>';
    }

    include('include/parts/footer.php');
?>