$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);