Files
Testing/bwadmin/introvids.php
sean 0e8a8b3028
Some checks are pending
deploy-testing / deploy (push) Waiting to run
Initial testing snapshot
2026-11-17 16:15:01 -05:00

231 lines
7.3 KiB
PHP

<?php
/* $Id: admin_viewvideos.php 13 2009-01-11 06:04:29Z john $ */
$page = "admin_general1";
include "admin_header.php";
function general()
{ global $url, $database;
if($_GET["delete"]=="delete")
{
$owner=new SEUser(Array($_GET["id"]));
//var_dump($owner);
$owner->adminuser_intro_delete();
//$database->database_query("DELETE FROM contest WHERE id='".$database->database_real_escape_string($_GET["id"])."'");
$_GET["id"]=0;
}
if($_GET["approve"]==1)
{
$database->database_query("UPDATE se_users SET introapproved=1 WHERE user_id='".$database->database_real_escape_string($_GET["id"])."'");
$_GET["id"]=0;
}
if($_GET["approve"]=="0")
{
$database->database_query("UPDATE se_users SET introapproved=0 WHERE user_id='".$database->database_real_escape_string($_GET["id"])."'");
$_GET["id"]=0;
}
if($_GET["id"]>0)
{
$query=$database->database_query("SELECT * FROM se_users WHERE user_id='".$database->database_real_escape_string($_GET["id"])."'");
$row=$database->database_fetch_array($query);
?>
By: <a href="/profile.php?user=<?=$row["user_username"]?>"><?=$row["user_username"]?></a><br />
<? if($row["introapproved"]==1){?><a href="introvids.php?id=<?=$row["user_id"]?>&amp;approve=0">Unapprove</a><? }else{?><a href="introvids.php?id=<?=$row["user_id"]?>&amp;approve=1">Approve</a><? }?>
<br />
<br />
<script type="text/javascript" src="/include/flow_player/flashembed-1.0.1.pack.js"></script>
<script type='text/javascript'>
<!--
flashembed("sevideo_player",
{
src:"/include/flow_player/flowplayer-3.1.5.swf",
width: 660,
height: 480,
wmode: 'transparent'
},
{
config: {
clip: {
url: '../<?=$url->url_userdir($row["user_id"])?><?=$row["introvid"]?>',
autoPlay: false,
autoBuffering: true
},
plugins: {
controls: {
background: '#000000',
bufferColor: '#333333',
progressColor: '#444444',
buttonColor: '#444444',
buttonOverColor: '#666666'
}
},
canvas: {
backgroundColor:'#000000'
}
}
});
//-->
</script>
<div id='sevideo_player'></div>
<?
}
else{
?>
<form action='introvids.php' method='get' name='items'>Username: <input type="text" name="username"><input type="submit" value="Search" /></form>
<table cellpadding='0' cellspacing='0' class='list'>
<tr>
<td class='header' width='10' style='padding-left: 0px;'><a class='header' href='admin_viewvideos.php?s=i&p=45&f_title=&f_owner='>ID</a></td>
<td class='header'><a class='header' href='admin_viewvideos.php?s=u&p=45&f_title=&f_owner='>Owner</a></td>
<td class='header'>Email</td>
<td class='header' width='230'>Options</td>
</tr><?
$x=1;
if($_GET["username"]!=""){
$query=$database->database_query("SELECT * FROM se_users WHERE user_username LIKE'%".$database->database_real_escape_string($_GET["username"])."%' ORDER BY introapproved ASC, introtime ASC");
}else{
$query=$database->database_query("SELECT * FROM se_users WHERE introvid!='' ORDER BY introapproved ASC, introtime ASC");
}
while($row=$database->database_fetch_array($query))
{
?>
<tr class='<? if($x%2==0){?>background2<? }else{?>background1<? }?>'>
<td class='item' style='padding-left: 0px;'><?=$x?></td>
<td class='item'><a href='http://bateworld.com/profile.php?user=<?=$row["user_username"]?>' target='_blank'><?=$row["user_username"]?></a></td>
<td class='item'><a href='http://bateworld.com/profile.php?user=<?=$row["user_username"]?>' target='_blank'><?=$row["user_email"]?></a></td>
<td class='item'>
[ <a href='introvids.php?id=<?=$row["user_id"]?>'>view</a> ]
[ <a href="introvids.php?id=<?=$row["user_id"]?>&delete=delete" onClick="return confirm('Are you sure?')">delete</a> ]
<? if($row["introapproved"]==1){?>[ <a href="introvids.php?approve=0&id=<?=$row["user_id"]?>">Un-Approve</a> ]<? }
else{?>
[ <a href="introvids.php?approve=1&id=<?=$row["user_id"]?>">Approve</a> ]
<? }
?>
</td>
</tr>
<?
$x++;}?>
</table>
<?
}}
if(isset($_POST['s'])) { $s = $_POST['s']; } elseif(isset($_GET['s'])) { $s = $_GET['s']; } else { $s = "id"; }
if(isset($_POST['p'])) { $p = $_POST['p']; } elseif(isset($_GET['p'])) { $p = $_GET['p']; } else { $p = 1; }
if(isset($_POST['f_title'])) { $f_title = $_POST['f_title']; } elseif(isset($_GET['f_title'])) { $f_title = $_GET['f_title']; } else { $f_title = ""; }
if(isset($_POST['f_owner'])) { $f_owner = $_POST['f_owner']; } elseif(isset($_GET['f_owner'])) { $f_owner = $_GET['f_owner']; } else { $f_owner = ""; }
if(isset($_POST['task'])) { $task = $_POST['task']; } elseif(isset($_GET['task'])) { $task = $_GET['task']; } else { $task = "main"; }
if(isset($_POST['video_id'])) { $video_id = $_POST['video_id']; } elseif(isset($_GET['video_id'])) { $video_id = $_GET['video_id']; } else { $video_id = 0; }
// CREATE VIDEO OBJECT
$videos_per_page = 100;
$video = new se_video();
// DELETE VIDEO
if($task == "deletevideo") {
if($database->database_num_rows($database->database_query("SELECT video_id FROM se_videos WHERE video_id='$video_id'")) == 1) {
$video->video_delete($video_id);
}
}
// SET VIDEO SORT-BY VARIABLES FOR HEADING LINKS
$i = "id"; // VIDEO_ID
$t = "t"; // VIDEO_TITLE
$u = "u"; // OWNER OF VIDEO
// SET SORT VARIABLE FOR DATABASE QUERY
if($s == "i") {
$sort = "se_videos.video_id";
$i = "id";
} elseif($s == "id") {
$sort = "se_videos.video_id DESC";
$i = "i";
} elseif($s == "t") {
$sort = "se_videos.video_title";
$t = "td";
} elseif($s == "td") {
$sort = "se_videos.video_title DESC";
$t = "t";
} elseif($s == "u") {
$sort = "user_username";
$u = "ud";
} elseif($s == "ud") {
$sort = "user_username DESC";
$u = "u";
} else {
$sort = "se_videos.video_id DESC";
$i = "i";
}
// ADD CRITERIA FOR FILTER
$where_clause = Array();
if($f_owner != "") { $where_clause[] = "(se_users.user_username LIKE '%$f_owner%' OR CONCAT(se_users.user_fname, ' ', se_users.user_lname) LIKE '%$f_owner%')"; }
if($f_title != "") { $where_clause[] = " se_videos.video_title LIKE '%$f_title%'"; }
if(count($where_clause) != 0) { $where = "(".implode(" AND ", $where_clause).")"; }
// DELETE NECESSARY VIDEOS
$start = ($p - 1) * $videos_per_page;
if($task == "delete") { $video->video_delete_selected($start, $videos_per_page, $sort, $where); }
// GET TOTAL VIDEOS
$total_videos = $video->video_total($where);
// MAKE VIDEO PAGES
$page_vars = make_page($total_videos, $videos_per_page, $p);
$page_array = Array();
for($x=0;$x<=$page_vars[2]-1;$x++) {
if($x+1 == $page_vars[1]) { $link = "1"; } else { $link = "0"; }
$page_array[$x] = Array('page' => $x+1,
'link' => $link);
}
// GET VIDEO ARRAY
$videos = $video->video_list($page_vars[0], $videos_per_page, $sort, $where);
// ASSIGN VARIABLES AND SHOW VIEW VIDEOS PAGE
$smarty->assign('total_videos', $total_videos);
$smarty->assign('pages', $page_array);
$smarty->assign('videos', $videos);
$smarty->assign('f_title', $f_title);
$smarty->assign('f_owner', $f_owner);
$smarty->assign('i', $i);
$smarty->assign('t', $t);
$smarty->assign('u', $u);
$smarty->assign('f', $f);
$smarty->assign('su', $su);
$smarty->assign('p', $page_vars[1]);
$smarty->assign('s', $s);
include "admin_footer.php";
?>