<?php
    if (!is_array($rrow) && is_numeric($_GET['id'])) {
        include_once('db.php');
        $record_num = (int) $_GET['id'];
        $rrow = dbRow("SELECT `content`.*, (SELECT `content_views`.`views` FROM `content_views` WHERE `content_views`.`content` = `content`.`record_num`) AS `views`, (SELECT `users`.`username` FROM `users` WHERE `users`.`record_num` = `content`.`submitter`) AS `username`, (SELECT `paysites`.`name` FROM `paysites` WHERE `paysites`.`record_num` = `content`.`paysite`) AS `paysitename`, (SELECT `images`.`filename` FROM `images` WHERE `images`.`record_num` = `content`.`thumbnail`) AS `thumbfile` FROM `content` WHERE `record_num` = '$record_num'");
    }
?>
<td class="thumb large thumb-cell">
    <?php if ($rrow['photos'] == 1) { ?>
        <a href="edit_photo_content.php?id=<?php echo $rrow['record_num']; ?>" class="popEdit" data="<?php echo $rrow['record_num']; ?>">
            <img src="<?php echo $gallery_url; ?>/<?php echo $rrow['filename']; ?>/thumbs/<?php echo $rrow['thumbfile']; ?>?<? echo time(); ?>" alt="<?php echo $rrow['title']; ?>" id="<?php echo $rrow['orig_filename']; ?>" />
        </a>
    <?php } else { ?>
        <?php if ($rrow['embed']) { ?>
            <a href="edit_content.php?id=<?php echo $rrow['record_num']; ?>" class="popEdit" data="<?php echo $rrow['record_num']; ?>">
                <img src="<?php echo $thumb_url; ?>/embedded/<?php echo $rrow['record_num']; ?>.jpg?<? echo time(); ?>" alt="<?php echo $rrow['title']; ?>" id="<?php echo $rrow['orig_filename']; ?>" />
            </a>
        <?php } else { ?>
            <?php $dirname = $rrow['filename'][0] . '/' . $rrow['filename'][1] . '/' . $rrow['filename'][2] . '/' . $rrow['filename'][3] . '/' . $rrow['filename'][4] . '/' . str_replace('.flv', '', $rrow['orig_filename']); ?>
            <a href="edit_content.php?id=<?php echo $rrow['record_num']; ?>" class="popEdit" data="<?php echo $rrow['record_num']; ?>">
                <img src="<?php echo $thumb_url; ?>/<?php echo $dirname; ?>/<?php echo $rrow['orig_filename']; ?>-<?php echo $rrow['main_thumb']; ?>.jpg?<? echo time(); ?>" alt="<?php echo $rrow['title']; ?>" id="thumb<?php echo $rrow['record_num']; ?>" />
            </a>
        <?php } ?>
    <?php } ?>
	<strong><?php echo $rrow['title']; ?></strong>
</td>
<td>
    <? if($rrow['description']) { ?>
	<strong>Description:</strong>
    <?php if (strlen($rrow['description']) > 150) { ?>
        <?php echo substr($rrow['description'], 0, 147) . '...'; ?>
    <?php } else { ?>
        <?php echo $rrow['description']; ?>
    <?php } ?><br />
	<? } ?>
    <strong>Categories:</strong> <?php echo generateChannelsAdmin($rrow['record_num']); ?><br />
    <? if($rrow['keywords']) { ?><strong>Keywords:</strong> <?php echo str_replace(',', ', ', $rrow['keywords']); ?><br /><? } ?>
    <strong>Models:</strong> <?php echo buildPornstarsAdmin($rrow['record_num']); ?><br />
    <?php if ($rrow['paysite']) { ?>
        <strong>Paysite:</strong> <a href="edit_paysite.php?id=<?php echo $rrow['paysite']; ?>"><?php echo $rrow['paysitename']; ?></a><br />
    <?php } ?>
    <strong>Uploader:</strong> <a href="edit_user.php?id=<?php echo $rrow['submitter']; ?>"><?php echo $rrow['username']; ?></a><br />
    <?php if ($rrow['photos'] == 0) { ?>
        <strong>Length:</strong> <?php echo sec2time($rrow['length']); ?>
    <?php } else { ?>
        <strong>Photos:</strong> <?php echo count(dbQuery("SELECT record_num FROM images WHERE gallery = '$rrow[record_num]'",false)); ?>
    <?php } ?><br />
    <strong>Views:</strong> <?php echo $rrow['views']; ?><br />
    <strong>Date Added:</strong> <?php echo $rrow['encoded_date']; ?><br />
    <?php
        $contentFilter = array(
            "S" => "Straight",
            "G" => "Gay",
            "T" => "Shemale"
        );
    ?>
    <strong>Content Filter:</strong> <?php echo $contentFilter[$rrow['filter']]; ?><br />
    <strong><a href="<?php echo $basehttp; ?>/admin/comments.php?content=<?php echo $rrow['title']; ?>">Comments</a></strong>
    
    <?php
        if($multiple_servers == 1) {
            $server = getMediaServerData($rrow['record_num']);
            if($server) {
    ?>
    <br /><br />
    <strong>Server:</strong> <?php echo "{$server['name']} ({$server['nfs_path']})"; ?>
    <?php
            }
        }
    ?>
</td>
<td class="options">
    <a href="<? echo generateUrl(($rrow['photos'] == 1) ? 'galleries' : 'video', $rrow['title'], $rrow['record_num']); ?>" class="btn btn-xs btn-seablue" target="_blank" title="Preview"><i class="ion ion-eye"></i></a>
    <a href="edit_<?php echo ($rrow['photos'] == 1) ? 'photo_' : ''; ?>content.php?id=<?php echo $rrow['record_num']; ?>" data="<?php echo $rrow['record_num']; ?>" class="btn btn-xs btn-orange popEdit" title="Edit"><i class="ion ion-edit icon-edit"></i></a>
    <a onClick="javascript:deleteRow('<?php echo $rrow['record_num']; ?>');return false;" href="#" class="btn btn-xs btn-red" title="Delete"><i class="ion ion-trash-a icon-trash"></i></a>
</td>
<td>
    <label class="checkbox">
        <input type="checkbox" name="list[]" value="<?php echo $rrow['record_num']; ?>" id="ids-<?php echo $rrow['record_num']; ?>"><i></i>
    </label>
</td>