HEX
Server: Apache
System: Linux msm5694.mjhst.com 3.10.0-1160.119.1.el7.x86_64 #1 SMP Tue Jun 4 14:43:51 UTC 2024 x86_64
User: camjab_ssh (1000)
PHP: 5.3.29
Disabled: NONE
Upload Files
File: //home/httpd/mech_ftp/baretube.com/admin/existing_content.php
<?php
require "header.php";
foreach ($_REQUEST as $k => $v) {
    $_REQUEST[$k] = mysqli_real_escape_string($dbconn, $v);
}
if ($_POST['appendKeywords']) {
    $_POST['appendKeywords'] = mysqli_real_escape_string($dbconn, $_POST['appendKeywords']);
}
if ($_POST['list']) {
    $default_video_path = $video_path;

    $spinOptions = dbQuery("SELECT `value` FROM `fields_values` LEFT JOIN `fields` ON `field_id` = `fields`.`record_num` WHERE `fields`.`code` = 'spin_text_options'", false);
    foreach ($_POST['list'] as $i) {
        if (is_numeric($i)) {
            $contentFilterBulk = "S";
            if (in_array($_POST['setfilter'], array("S", "G", "T"))) {
                $contentFilterBulk = $_POST['setfilter'];
            }
            
            if ($_POST['action'] == 'delete') {
                $row = dbRow("SELECT * FROM `content` WHERE `record_num` = '$i'");
                $data = mysqli_real_escape_string($dbconn, serialize($row));
                $time = date('Y-m-d H:i:s');
				
                dbQuery("INSERT INTO `content_deleted` SET `content` = '$i', `date` = '$time', `data` = '$data'");
                
                dbQuery("DELETE FROM `content_views` WHERE `content` = '$i'");
                dbQuery("DELETE FROM `content_niches` WHERE `content` = '$i'");
                dbQuery("DELETE FROM `content_pornstars` WHERE `content` = '$i'");
                dbQuery("DELETE FROM `content_search` WHERE `content` = '$i'");
                dbQuery("DELETE FROM `content_languages` WHERE `content` = '$i'");
                dbQuery("DELETE FROM `comments` WHERE `content` = '$i' AND `type` = 0");
                if ($row['photos'] == 1) {
                    dbQuery("DELETE FROM `images` WHERE `gallery` = '$i'");
                }
                dbQuery("DELETE FROM `content` WHERE `record_num` = '$i'");

                $first = $row['filename'][0];
                $second = $row['filename'][1];
                $third = $row['filename'][2];
                $forth = $row['filename'][3];
                $fifth = $row['filename'][4];
                $subdir = $first . '/' . $second . '/' . $third . '/' . $forth . '/' . $fifth . '/';

                if ($multiple_servers == 1) {
                    $server = getMediaServerData($i);
                    if ($server) {
                        $video_path = $server['nfs_path'];
                    } else {
                        $video_path = $default_video_path;
                    }
                }

                if($ceph_enabled) { 
					if($row['filename']) { 
						cephDeleteObject('videos/' . $subdir . $row['filename']);
					}
					if($row['mobile']) { 
						cephDeleteObject('videos/' . $subdir . $row['mobile']);
					}
					if($row['trailer_filename']) { 
						cephDeleteObject('videos/' . $subdir . $row['trailer_filename']);
					}
				} else { 
							@unlink($video_path . '/' . $subdir . $row['filename']);
							if ($row['mobile']) {
								@unlink($video_path . '/' . $subdir . $row['mobile']);
							}
							if ($row['trailer_filename']) {
								@unlink($video_path . '/' . $subdir . $row['trailer_filename']);
							}
							if ($row['photos'] == 1) {
								if(strlen($row['filename'] > 2)) { 
									delete_folder($gallery_path . '/' . $row['filename']);
								}
							}
				}
                if (!$row['embed'] && $row['photos'] == 0 && $row['orig_filename']) {
                    $dirname = str_replace('.flv', '', $row['orig_filename']);
					if($ceph_enabled) { 
						if($dirname) { 
							cephDeleteObject('thumbs/' . $subdir . $dirname. '/'. $row['orig_filename'] .'-0.jpg');
							cephDeleteObject('thumbs/' . $subdir . $dirname. '/'. $row['orig_filename'] .'-1.jpg');
							cephDeleteObject('thumbs/' . $subdir . $dirname. '/'. $row['orig_filename'] .'-2.jpg');
							cephDeleteObject('thumbs/' . $subdir . $dirname. '/'. $row['orig_filename'] .'-3.jpg');
							cephDeleteObject('thumbs/' . $subdir . $dirname. '/'. $row['orig_filename'] .'-4.jpg');
							cephDeleteObject('thumbs/' . $subdir . $dirname. '/'. $row['orig_filename'] .'-5.jpg');
							cephDeleteObject('thumbs/' . $subdir . $dirname. '/'. $row['orig_filename'] .'-6.jpg');
							cephDeleteObject('thumbs/' . $subdir . $dirname. '/'. $row['orig_filename'] .'-7.jpg');
							cephDeleteObject('thumbs/' . $subdir . $dirname. '/'. $row['orig_filename'] .'-8.jpg');
							cephDeleteObject('thumbs/' . $subdir . $dirname. '/'. $row['orig_filename'] .'-9.jpg');
							cephDeleteObject('thumbs/' . $subdir . $dirname. '/'. $row['orig_filename'] .'-10.jpg');
							cephDeleteObject('thumbs/' . $subdir . $dirname. '/'. $row['orig_filename'] .'-0b.jpg');
							cephDeleteObject('thumbs/' . $subdir . $dirname. '/'. $row['orig_filename'] .'-1b.jpg');
							cephDeleteObject('thumbs/' . $subdir . $dirname. '/'. $row['orig_filename'] .'-2b.jpg');
							cephDeleteObject('thumbs/' . $subdir . $dirname. '/'. $row['orig_filename'] .'-3b.jpg');
							cephDeleteObject('thumbs/' . $subdir . $dirname. '/'. $row['orig_filename'] .'-4b.jpg');
							cephDeleteObject('thumbs/' . $subdir . $dirname. '/'. $row['orig_filename'] .'-5b.jpg');
							cephDeleteObject('thumbs/' . $subdir . $dirname. '/'. $row['orig_filename'] .'-6b.jpg');
							cephDeleteObject('thumbs/' . $subdir . $dirname. '/'. $row['orig_filename'] .'-7b.jpg');
							cephDeleteObject('thumbs/' . $subdir . $dirname. '/'. $row['orig_filename'] .'-8b.jpg');
							cephDeleteObject('thumbs/' . $subdir . $dirname. '/'. $row['orig_filename'] .'-9b.jpg');
							cephDeleteObject('thumbs/' . $subdir . $dirname. '/'. $row['orig_filename'] .'-10b.jpg');
							$numVtt = ceil($row[length]/5)+1;
							for($v = 1; $v <= $numVtt; $v++) {
								$number = str_pad($v,3,0,STR_PAD_LEFT);
								cephDeleteObject('thumbs/' . $subdir . $dirname. '/vtt_'.$number.'.jpg');
							}
							cephDeleteObject('thumbs/' . $subdir . $dirname. '/');
						}
					} else { 
						delete_folder($thumb_path . '/' . $subdir . $dirname);
					}
                }
				if($row['embed']) { 
					unlink($thumb_path.'/embedded/'.$row['record_num'].'.jpg'); 
				}
				
            } elseif ($_POST['action'] == 'setpublic') {
                dbQuery("UPDATE content SET access_level = '0' WHERE record_num = '$i'");
            } elseif ($_POST['action'] == 'setprivate') {
                dbQuery("UPDATE content SET access_level = '1' WHERE record_num = '$i'");
            } elseif ($_POST['action'] == 'setpremium') {
                dbQuery("UPDATE content SET access_level = '2' WHERE record_num = '$i'");
            } elseif ($_POST['action'] == 'unpublish') {
                dbQuery("UPDATE content SET enabled = 0 WHERE record_num = '$i'");
            } elseif ($_POST['action'] == 'spintext') {
                $row = dbRow("SELECT * FROM content WHERE record_num = '$i'");
                if (is_array($spinOptions)) {
                    dbQuery("UPDATE content SET title = '" . mysqli_real_escape_string($dbconn, spinText($row['title'])) . "', description = '" . mysqli_real_escape_string($dbconn, spinText($row['description'])) . "' WHERE record_num = '$i'");
                }
            } elseif ($_POST['action'] == 'setkeywords') {
                dbQuery("UPDATE content SET keywords = CONCAT(keywords,', ','$_POST[appendKeywords]') WHERE record_num = '$i' AND keywords NOT LIKE '%$_POST[appendKeywords]%'");
            } elseif ($_POST['action'] == 'setpaysite') {
                dbQuery("UPDATE content SET paysite = '$_POST[setpaysite]' WHERE record_num = '$i'");
            } elseif ($_POST['action'] == 'setfilter') {
                dbQuery("UPDATE content SET filter = '$contentFilterBulk' WHERE record_num = $i");
            } elseif ($_POST['action'] == 'setuser') {
                $getUser = dbRow("SELECT record_num FROM users WHERE username = '" . mysqli_real_escape_string($dbconn, $_POST['setuser']) . "'", false);
                if (is_array($getUser)) {
                    $submitter = $getUser['record_num'];
                } else {
                    $submitter = 0;
                }
                dbQuery("UPDATE content SET submitter = '$submitter' WHERE record_num = '$i'");
            } elseif ($_POST['action'] == 'setchannel') {
                foreach ($_POST['setchannel'] as $i2) {
                    if (is_numeric($i2)) {
                        dbQuery("INSERT INTO content_niches (content, niche) VALUES ('$i','$i2')");
                    }
                }
            } elseif ($_POST['action'] == 'setpornstar') {
                foreach ($_POST['setpornstar'] as $i2) {
                    if (is_numeric($i2)) {
                        dbQuery("INSERT INTO content_pornstars (content, pornstar) VALUES ('$i','$i2')");
                    }
                }
            }
        }
    }
}
?>
<script>
    function processList(spanid) {
        if (spanid == 'setuser') {
            document.getElementById('setpaysite').style.display = 'none';
            document.getElementById('setchannel').style.display = 'none';
            document.getElementById('setpornstar').style.display = 'none';
            document.getElementById('setuser').style.display = 'inline-block';
            document.getElementById('setchannelwarning').style.display = 'none';
            document.getElementById('setkeywords').style.display = 'none';
			 document.getElementById('setfilter').style.display = 'none';
        }
        else if (spanid == 'setkeywords') {
            document.getElementById('setpaysite').style.display = 'none';
            document.getElementById('setchannel').style.display = 'none';
            document.getElementById('setpornstar').style.display = 'none';
            document.getElementById('setuser').style.display = 'none';
            document.getElementById('setchannelwarning').style.display = 'none';
            document.getElementById('setkeywords').style.display = 'inline-block';
			 document.getElementById('setfilter').style.display = 'none';
        }
        else if (spanid == 'setpaysite') {
            document.getElementById('setpaysite').style.display = 'inline-block';
            document.getElementById('setchannel').style.display = 'none';
            document.getElementById('setpornstar').style.display = 'none';
            document.getElementById('setuser').style.display = 'none';
            document.getElementById('setchannelwarning').style.display = 'none';
            document.getElementById('setkeywords').style.display = 'none';
			 document.getElementById('setfilter').style.display = 'none';
        }
        else if (spanid == 'setpornstar') {
            document.getElementById('setpaysite').style.display = 'none';
            document.getElementById('setchannel').style.display = 'none';
            document.getElementById('setpornstar').style.display = 'inline-block';
            document.getElementById('setuser').style.display = 'none';
            document.getElementById('setchannelwarning').style.display = 'none';
            document.getElementById('setkeywords').style.display = 'none';
			 document.getElementById('setfilter').style.display = 'none';
        }
        else if (spanid == 'setchannel') {
            document.getElementById('setpaysite').style.display = 'none';
            document.getElementById('setchannel').style.display = 'inline-block';
            document.getElementById('setpornstar').style.display = 'none';
            document.getElementById('setuser').style.display = 'none';
            document.getElementById('setchannelwarning').style.display = 'inline-block';
            document.getElementById('setkeywords').style.display = 'none';
			 document.getElementById('setfilter').style.display = 'none';
        }
		 else if (spanid == 'setfilter') {
            document.getElementById('setpaysite').style.display = 'none';
            document.getElementById('setchannel').style.display = 'none';
            document.getElementById('setpornstar').style.display = 'none';
            document.getElementById('setuser').style.display = 'none';
            document.getElementById('setchannelwarning').style.display = 'none';
            document.getElementById('setkeywords').style.display = 'none';
            document.getElementById('setfilter').style.display = 'inline-block';
        }
        else {
            document.getElementById('setpaysite').style.display = 'none';
            document.getElementById('setchannel').style.display = 'none';
            document.getElementById('setpornstar').style.display = 'none';
            document.getElementById('setuser').style.display = 'none';
            document.getElementById('setchannelwarning').style.display = 'none';
            document.getElementById('setkeywords').style.display = 'none';
			 document.getElementById('setfilter').style.display = 'none';
        }
    }

    $().ready(function () {
        $(document).on('submit', '#form-edit-specific-content', function (e) {
            e.preventDefault();
            if ($(this).find('.error').length > 0) {
                return false;
            }
            var id = $(this).find('input[name="id"]').val();
            $.colorbox({
                width: '97%',
                height: '95%',
                iframe: true,
                href: "<? echo $basehttp; ?>/admin/edit_content__load.php?id=" + id,
                onOpen: function () {
                    $('body').addClass('colorbox-opened');
                },
                onClosed: function () {
                    $("#record" + id).load("<? echo $basehttp ?>/admin/existing_content_row.php?id=" + id);
                    $('body').removeClass('colorbox-opened');
                }
            });
            return false;
        });
    });

</script>

<div class="content-page">
    
    <div class="header-area">
        <div class="breadcrumbs">
            <a href="index.php">Admin Home</a>
            <span><a href="existing_content.php">Existing Content</a></span>
        </div>
    </div>
    
    <div class="content-outer">
        
        <h2>Existing<strong>Content</strong></h2>
        
        
            
        <div class="content-inner">
            
            <? echo getMessages(); ?>
            
            <form action="#" class="form" id="form-edit-specific-content" novalidate autocomplete="off">
                <table class="pagetable">
                    <thead>
                        <tr>
                            <th colspan="2">Edit Specific Content</th>
                        </tr>
                    </thead>
                    <tr>
                        <td>Content ID</td>
                        <td>
                            <button type="submit" class="btn action-search pull-right no-process">Edit</button>
                            <div class="inline-input">
                                <input name="id" type="text" id="contentId" required />
                            </div>
                        </td>                        
                    </tr>
                </table>
            </form>

            <form method="GET" action="" class="form" novalidate autocomplete="off">
                <table class="pagetable">
                    <thead>
                        <tr>
                            <th colspan="2">Search Existing Content</th>
                        </tr>
                    </thead>
                    <tr>
                        <td>Select Channel</td>
                        <td>
                            <select name="channel">
                                <option value="">--All Channels--</option>
                                <? $result1 = dbQuery("SELECT * FROM niches ORDER BY name ASC",false); ?>
                                <? foreach($result1 as $row1) { ?>
                                    <option<? echo ($_REQUEST['channel'] == $row1['record_num']) ? ' selected' : ''; ?> value="<? echo $row1['record_num']; ?>"><? echo $row1['name']; ?></option>
                                <? } ?>
                            </select>
                        </td>
                    </tr>
                    <tr>
                        <td>Select Model</td>
                        <td><select name="pornstar">
                                <option value=''>--All Models--</option>
                                <? $result1 = dbQuery("SELECT * FROM pornstars ORDER BY name ASC",false); ?>
                                <? foreach($result1 as $row1) { ?>
                                    <option<? echo ($_REQUEST['pornstar'] == $row1['record_num']) ? ' selected' : ''; ?> value="<? echo $row1['record_num']; ?>"><? echo $row1['name']; ?></option>
                                <? } ?>
                            </select>
                        </td>
                    </tr>
                    <tr>
                        <td>Select Paysite</td>
                        <td>
                            <select name="paysite">
                                <option value="">--All Paysites--</option>
                                <option value="none"<? echo ($_REQUEST['paysite'] == 'none') ? ' selected' : ''; ?>>No Paysite</option>
                                <? $result1 = dbQuery("SELECT * FROM paysites ORDER BY name ASC",false); ?>
                                <? foreach($result1 as $row1) { ?>
                                    <option<? echo ($_REQUEST['paysite'] == $row1['record_num']) ? ' selected' : ''; ?> value="<? echo $row1['record_num']; ?>"><? echo $row1['name']; ?></option>
                                <? } ?>
                            </select>
                        </td>
                    </tr>
                    <tr>
                        <td>Type</td>
                        <td>
                            <select name="type">
                                <option value="">--All Types--</option>
                                <option value="photos"<? echo ($_REQUEST['type'] == 'photos') ? ' selected' : ''; ?>>Photos</option>
                                <option value="videos"<? echo ($_REQUEST['type'] == 'videos') ? ' selected' : ''; ?>>Videos</option>
                                <option value="plugs"<? echo ($_REQUEST['type'] == 'plugs') ? ' selected' : ''; ?>>Plugs</option>
                            </select>
                        </td>
                    </tr>
					 <tr>
                        <td>Access Level</td>
                        <td>
                            <select name="access_level">
                                <option value="">--All Levels--</option>
                                <option value="public"<? echo ($_REQUEST['access_level'] == 'public') ? ' selected' : ''; ?>>Public</option>
                                <option value="private"<? echo ($_REQUEST['access_level'] == 'private') ? ' selected' : ''; ?>>Private</option>
                                <option value="premium"<? echo ($_REQUEST['access_level'] == 'premium') ? ' selected' : ''; ?>>Premium</option>
                            </select>
                        </td>
                    </tr>
                    <tr>
                        <td>Filter Content</td>
                        <td>
                            <select name="filter">
                                <option value="">--All Content--</option>
                                <option value="S" <?php echo ($_GET['filter'] == 'S') ? 'selected' : ''; ?>>Straight</option>
                                <option value="G" <?php echo ($_GET['filter'] == 'G') ? 'selected' : ''; ?>>Gay</option>
                                <option value="T" <?php echo ($_GET['filter'] == 'T') ? 'selected' : ''; ?>>Shemale</option>
                            </select>
                        </td>
                    </tr>
                    <tr>
                        <td>Search</td>
                        <td><input name="keywords" type="text" value="<? echo $_REQUEST['keywords']; ?>" /></td>
                    </tr>
                    <tr>
                        <td>User Number</td>
                        <td><input name="user" type="text" value="<? echo $_REQUEST['user']; ?>" /></td>
                    </tr>
                    <tr>
                        <td>Sort By</td>
                        <td>
                            <select name="sortby">
                                <option<? echo ($_GET['sortby'] == 'encoded_date' || !$_GET['sortby']) ? ' selected' : ''; ?> value="encoded_date">Publish Date</option>
                                <option<? echo ($_GET['sortby'] == 'title') ? ' selected' : ''; ?> value="title">Title</option>
                                <option<? echo ($_GET['sortby'] == 'views') ? ' selected' : ''; ?> value="views">Views</option>
                                <option<? echo ($_GET['sortby'] == 'length') ? ' selected' : ''; ?> value="length">Length</option>
                                <option<? echo ($_GET['sortby'] == 'rating') ? ' selected' : ''; ?> value="rating">Rating</option>
                            </select>
                            <select name="sorttype">
                                <option<? echo ($_GET['sorttype'] == 'ASC') ? ' selected' : ''; ?> value="ASC">Ascending</option>
                                <option<? echo ($_GET['sorttype'] == 'DESC' || !$_GET['sorttype']) ? ' selected' : ''; ?> value="DESC">Descending</option>
                            </select>
                        </td>
                    </tr>
                    <tr>
                        <td>Results Per Page</td>
                        <td>
                            <select name="setmax">
                                <option<? echo ($_GET['setmax'] == '100' || !$_GET['setmax']) ? ' selected' : ''; ?> value="100">100</option>
                                <option<? echo ($_GET['setmax'] == '250') ? ' selected' : ''; ?> value="250">250</option>
                                <option<? echo ($_GET['setmax'] == '500') ? ' selected' : ''; ?> value="500">500</option>
                                <option<? echo ($_GET['setmax'] == '1000') ? ' selected' : ''; ?> value="1000">1000</option>
                                <option<? echo ($_GET['setmax'] == '2500') ? ' selected' : ''; ?> value="2500">2500</option>
                            </select>
                        </td>
                    </tr>
                    <tr class="item submit">
                        <td colspan="2">
                            <input type="hidden" name="searchSubmit" value="1" />
                            <button type="submit" class="btn action-search">Search</button>
                        </td>
                    </tr>
                    </tbody>
                </table>
            </form>

            <? //if (isset($_REQUEST['searchSubmit'])) { ?>
			<? if (1) { ?>
                <form method="POST" action="" class="form" novalidate autocomplete="off">
                    <?php
                    $page = (isset($_GET['page']) && is_numeric($_GET['page'])) ? (int) $_GET['page'] : 1;
                    $max_results = (isset($_GET['setmax']) && $_GET['setmax'] > 0) ? (int) $_GET['setmax'] : 100;
                    $from = ($page * $max_results) - $max_results;

                    $tables = '';
                    $where = " AND `content`.`enabled` = 1";

                    $sortBy = in_array($_REQUEST['sortby'], array('encoded_date', 'title', 'views', 'length', 'rating')) ? $_REQUEST['sortby'] : '`content`.`encoded_date`';
                    $sortType = in_array(strtolower($_REQUEST['sorttype']), array('asc', 'desc')) ? $_REQUEST['sorttype'] : 'DESC';

                    if (is_numeric($_REQUEST['channel'])) {
                        $where .= " AND `content_niches`.`niche` = '" . (int) $_REQUEST['channel'] . "' AND `content_niches`.`content` = `content`.`record_num`";
                        $tables .= ', `content_niches` ';
                    }
                    if (is_numeric($_REQUEST['pornstar'])) {
                        $where .= " AND `content_pornstars`.`pornstar` = '" . (int) $_REQUEST['pornstar'] . "' AND `content_pornstars`.`content` = `content`.`record_num`";
                        $tables .= ', `content_pornstars` ';
                    }
                    if (isset($_REQUEST['keywords']) && $_REQUEST['keywords'] != "") {
                        $_REQUEST['keywords'] = mysqli_real_escape_string($dbconn, $_REQUEST['keywords']);
                        $where .= " AND (`content`.`keywords` LIKE '%$_REQUEST[keywords]%' OR `title` LIKE '%$_REQUEST[keywords]%' OR `description` LIKE '%$_REQUEST[keywords]%' OR `embed` LIKE '%$_REQUEST[keywords]%' OR `record_num` = '$_REQUEST[keywords]') ";
                    }
                    if (is_numeric($_REQUEST['paysite']) || $_REQUEST['paysite'] == 'none') {
                        if ($_REQUEST['paysite'] == 'none') {
                            $where .= " AND `content`.`paysite` = '0'";
                        } else {
                            $where .= " AND `content`.`paysite` = '" . (int) $_REQUEST['paysite'] . "'";
                        }
                    }
                    if (!empty($_GET['type'])) {
                        if ($_GET['type'] == 'photos') {
                            $where .= " AND `content`.`photos` = '1'";
                        } elseif ($_GET['type'] == 'videos') {
                            $where .= " AND `content`.`photos` = '0'";
                        } elseif ($_GET['type'] == 'plugs') {
                            $where .= " AND `content`.`plug_url` != ''";
                        }
                    }
                    if (in_array($_GET['filter'], array("S", "G", "T"))) {
                        $where .= " AND content.filter = '{$_GET['filter']}'";
                    }
                    if (is_numeric($_REQUEST['user'])) {
                        $where .= " AND `submitter` = '" . (int) $_REQUEST['user'] . "'";
                    }
					
					if($_GET['access_level']) { 
						$accessLevels = array("public" => 0, "private" => 1, "premium" => 2);
						$where .= " AND `access_level` = '".$accessLevels[$_GET['access_level']]."'";
					}
                    $rresult = dbQuery("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` $tables WHERE 1=1 $where GROUP BY `content`.`record_num` ORDER BY $sortBy $sortType LIMIT $from,$max_results",false);
                    $result_count = dbQuery("SELECT `record_num`, COUNT(*) AS `count` FROM `content` $tables WHERE 1=1 $where",false);
                    $total_results = $result_count[0]['count'];
                    $total_pages = ceil($total_results / $max_results);
                    ?>

                    <div class="notification info"><? echo $total_results; ?> result<? echo $total_results != 1 ? 's' : ''; ?> found</div>

                    <table class="pagetable">
                        <thead>
                            <tr>
                                <th class="thumb large">Thumb</th>
                                <th>Information</th>
                                <th class="options"></th>
                                <th style="width:50px">
                                    <label for="check-select-all-1" class="checkbox">
                                        <input type="checkbox" name="select_all" value="1" data-items="list[]" id="check-select-all-1">
                                        <i></i>
                                    </label>
                                </th>
                            </tr>
                        </thead>
                        <tbody>
                            <? if ($total_results === 0) { ?>
                                <tr><td colspan="4"><div class="notification alert">No entries found</div></td></tr>
                            <? } else { ?>
                                <? foreach($rresult as $rrow) { ?>
                                    <tr id="record<? echo $rrow['record_num']; ?>">
                                        <? include('existing_content_row.php'); ?>
                                    </tr>
                                <? } ?>
                                <tr>
                                    <td colspan="4">
                                        <span>
                                            <select name="action" id="action" onChange='processList(this.value);'>
                                                <option value="delete">Delete</option>
                                                <option value="setpaysite">Assign To Paysite</option>
                                                <option value="setpornstar">Assign To Pornstar(s)</option>
                                                <option value="setchannel">Assign To Channel</option>
                                                <option value="setuser">Assign To User</option>
                                                <option value="setkeywords">Append Keywords</option>
												<option value="setfilter">Set Content Filter</option>
												<option value="setpublic">Set Public Access Level</option>
												<option value="setprivate">Set Private Access Level</option>
												<option value="setpremium">Set Premium Access Level</option>
												<option value="spintext">Spin Text</option>
                                                <option value="unpublish">Unpublish</option>
                                            </select>
                                        </span>
                                        <span id='setpaysite' style='display: none;'>
                                            <select name="setpaysite">
                                                <?
                                                $result1 = dbQuery("SELECT * FROM paysites ORDER BY name ASC",false);
                                                foreach($result1 as $row1) {

                                                    echo "<option value='$row1[record_num]'>$row1[name]</option>";
                                                }
                                                ?>
                                            </select>
                                        </span>
                                        <span id='setpornstar' style='display: none;'>
                                            <select name='setpornstar[]' size="10" multiple="multiple" onchange="chooseImageMult(this)">
                                                <?
                                                $result1 = dbQuery("SELECT * FROM pornstars ORDER BY name ASC",false);
                                               foreach($result1 as $row1) {
                                                    if ($_REQUEST[pornstars] == $row1[record_num]) {
                                                        $selected = 'selected';
                                                    } else {
                                                        $selected = '';
                                                    }
                                                    echo "<option $selected value='$row1[record_num]'>$row1[name]</option>";
                                                }
                                                ?>
                                            </select>
                                        </span>
                                        <span id='setchannel' style='display: none;'>
                                            <select name='setchannel[]' size="10" multiple="multiple">
                                                <?
                                                $result1 = dbQuery("SELECT * FROM niches ORDER BY name ASC",false);
                                                foreach($result1 as $row1) {
                                                    if ($_REQUEST[channel] == $row1[record_num]) {
                                                        $selected = 'selected';
                                                    } else {
                                                        $selected = '';
                                                    }
                                                    echo "<option $selected value='$row1[record_num]'>$row1[name]</option>";
                                                }
                                                ?>
                                            </select>
                                        </span>
                                        <span id='setkeywords' style='display: none;'>
                                            <input type='text' name='appendKeywords' placeholder="Comma Separated" />
                                        </span>
                                        <span id='setuser' style='display: none;'>
                                            <input type="text" name="setuser" id="contentAutocomplete" value=""/>
                                            <script type="text/javascript">
                                                $(document).ready(function () {
                                                    $("#contentAutocomplete").autocomplete({
                                                        source: "search_content.php?type=2",
                                                        minLength: 2
                                                    });
                                                });
                                            </script>
                                        </span>
										<span id="setfilter" style="display: none;">
                                        <select name="setfilter">
                                            <option value="S">Straight</option>
                                            <option value="G">Gay</option>
                                            <option value="T">Shemale</option>
                                        </select>
										</span>
                                        <button type="submit" class="btn action-delete">Process Selected</button>
                                        <br />
                                        <span id='setchannelwarning' style='display: none;'> </span>
                                    </td>
                                </tr>
                            <? } ?>
                        </tbody>
                    </table>
                    <div id="adminPagination"><? echo showAdminPagination($total_pages); ?></div>
                </form>
            <? } ?>
        </div>
    </div>
</div>

<? require "footer.php"; ?>