<?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` FROM `content` WHERE `record_num` = '$record_num'");
}
?>
<td>
<? if($rrow['source_thumb_url']) { ?>
	<a href="approve_<?php echo ($rrow['photos'] == 1) ? 'photo_' : ''; ?>content.php?id=<?php echo $rrow['record_num']; ?>" title=""><img src='<? echo $rrow['source_thumb_url']; ?>' width='100%'></a>
<? } ?>
<strong><?php echo htmlentities($rrow['title'], ENT_QUOTES, 'UTF-8'); ?></strong>

</td>
<td>
    <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 />
    <strong>Keywords:</strong> <?php echo str_replace(',', ', ', $rrow['keywords']); ?><br />
    <strong>Models:</strong> <?php echo buildPornstars($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'] == 1) { ?>
        <strong>Photos:</strong> <?php echo count(dbQuery("SELECT record_num FROM images WHERE gallery = '$rrow[record_num]'", false)); ?>
    <?php } ?><br />
    <strong>Date Added:</strong> <?php echo $rrow['date_added']; ?><br />
    <?php if ($rrow['photos'] == 0) { ?>
        <strong>Filesize: </strong> <?php echo ceil(filesize($content_path . '/' . $rrow['orig_filename']) / 1024); ?>kB
    <?php } ?>
</td>
<?php if ($multiple_servers == 1) { ?>
    <?php if ($rrow['photos'] == 0 && empty($rrow['embed'])) { ?>
        <td>
            <select name="server[<?php echo $rrow['record_num']; ?>]" class="server-row">
                <option value="0">Default Media Server</option>
                <?php
                $getServers = dbQuery("SELECT name, record_num FROM servers ORDER BY name ASC");
                if (!empty($getServers)) {
                    foreach ($getServers as $server) {
                        ?>
                        <option value="<?php echo $server['record_num']; ?>"><?php echo $server['name']; ?></option>
                        <?php
                    }
                }
                ?>
            </select>
        </td>
    <?php } else if ($multiple_servers && $rrow['photos'] == 1) { ?>
        <td></td>
    <?php } ?>
<?php } ?>
<td class="options">
    <?php if ($rrow['photos'] == 0) { ?>
        <a href="#" onClick="setVideo('<?php echo addslashes($rrow['orig_filename']); ?>')" class="btn btn-xs btn-seablue preview" title="Preview content"><i class="ion ion-play icon-play"></i></a>
    <?php } ?>
    <a href="approve_<?php echo ($rrow['photos'] == 1) ? 'photo_' : ''; ?>content.php?id=<?php echo $rrow['record_num']; ?>" class="btn btn-xs btn-green" title="Approve content"><i class="ion ion-checkmark-circled icon-accept"></i></a>
    <a onclick="javascript:deleteRow('<?php echo $rrow[record_num]; ?>');
            return false;" href="#" class="btn btn-xs btn-red" title="Delete content"><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>