$err = "Please type a search key";
}
if ($err == "") {
if ($_REQUEST['search_type'] == "search_users") {
$sql = "select UID from signup WHERE username='******'search_id']}'";
$rs = $conn->execute($sql);
if ($rs->recordcount() > 0) {
$id = $rs->fields['UID'];
header("location:{$config['baseurl']}/uprofile.php?UID={$id}");
exit;
}
} elseif ($_REQUEST[search_type] == "search_groups") {
header("location:{$config['baseurl']}/search_group.php?search_type={$_REQUEST['search_type']}&search_id={$_REQUEST['search_id']}");
exit;
} elseif ($_REQUEST[search_type] == "related") {
$list = key_to_info($_REQUEST['search_key']);
$ch = explode(" ", $list[2]);
if (count($ch) > 1) {
for ($i = 1; $i < count($ch); $i++) {
$chnl .= "or keyword like '%{$ch[$i]}%'";
}
}
$sql = "SELECT count(*) as total from video where type='public' and (title like '%{$ch['0']}%' {$chnl}) order by VID asc";
} else {
$sql = "SELECT count(*) as total from video where type='public' and (title like '%{$_REQUEST['search_id']}%' or keyword like '%{$_REQUEST['search_id']}%' or description like '%{$_REQUEST['search_id']}%') {$sortby} limit {$config['total_per_ini']}";
}
//PAGING STARTS
if ($_REQUEST[page] == "") {
$page = 1;
} else {
$page = $_REQUEST[page];
$rs = $conn->execute($sql);
$sql1 = "select count(*) as total from inappro_req where VID=" . $rs->fields['VID'];
$rs1 = $conn->execute($sql1);
if ($rs1->fields['total'] > 0) {
$sql = "update inappro_req set req = req + 1, date='" . date("Y-m-d") . "' where VID=" . $rs->fields['VID'];
} else {
$sql = "insert inappro_req set VID='" . $rs->fields['VID'] . "', req = 1, date='" . date("Y-m-d") . "'";
}
$rs = $conn->execute($sql);
header("Location: view_video.php?viewkey={$_REQUEST['viewkey']}&msg=Your inappropriate request is sent successfully");
}
//INITIALIZATION
if (!key_to_info($_REQUEST[viewkey])) {
$err = "This video does not exists.";
} else {
$list = key_to_info($_REQUEST[viewkey]);
STemplate::assign('VID', $list[0]);
STemplate::assign('UID', $list[1]);
//END
//INCREASE VIEW COUNT
$sql = "update video set viewnumber=viewnumber+1, viewtime='" . date("Y-m-d H:i:s") . "' WHERE VID={$list['0']}";
$conn->execute($sql);
//END
//INCREASE TOTAL VIEW COUNT
$sql = "update signup set video_viewed=video_viewed+1 WHERE UID={$list['1']}";
$conn->execute($sql);
//END
//INCREASE TOTAL WATCH COUNT
if ($_SESSION[UID] != "") {
$sql = "update signup set watched_video=watched_video+1 WHERE UID={$_SESSION['UID']}";
$conn->execute($sql);
