0){$st=$st-($previous*$listnos);$previous=0;} if($next>0){$st=$st+($next*$listnos);$next=0;} if($st<0){$st=0;} #conditions $sql="from videolinks where 1=1 "; if(!empty($newscategory)){$sql.="and category='$newscategory' ";$pagetitle.=$categories[$newscategory];} if(!empty($newscountry)) { if(!empty($newscategory))$pagetitle.=" - "; $sql.="and country='$newscountry' "; $pagetitle.="Pravasi Video Links From ".$countries[$newscountry]; } elseif(!empty($newscategory))$pagetitle.=" - Pravasi Video Links"; #get total count $entries=mysqli_query($db,"select count(*) as cnt ".$sql); $tmp=mysqli_fetch_object($entries); $totcnt=$tmp->cnt; #actual query output $sql.="order by videoid desc "; $sql.=" limit ".$st.",".($listnos+1); $sql="select * ".$sql; $getvideos=mysqli_query($db,$sql); $cnt=mysqli_num_rows($getvideos); include_once "header.php"; ?>
$listnos){$next=1;$cnt=$listnos;} if($st>0){$previous=1;} if($cnt>0) { $navigurl=""; $navig="
"; #previous link if($previous==1) $navig.="<< ".mlconvert("XpSÀ¶pÅh").""."  :  "; #middle part - show page nos $pagelinksS=""; $pagelinksM=""; $pagelinksE=""; $pagelimit1=3; $pagelimit2=4; $pageradius=3; $pagelimit=$pagelimit1+$pagelimit2; $totpages=ceil($totcnt/$listnos); $thispage=($st/$listnos)+1; //club first extra pages if($thispage-$pageradius>1) { $pagelinksS.="1"; } if($thispage-$pageradius>2) { $tmp=round(1+($thispage-$pageradius)/2,0); $pagelinksS.="$tmp"; } if($thispage+$pageradius<($totpages-1)) { $tmp=round(($totpages+($thispage+$pageradius))/2,0); $pagelinksE.="$tmp"; } if($thispage+$pageradius<$totpages) { $pagelinksE.="$totpages"; } #consecutive page nos if($thispage-$pageradius<1)$pagestart=1;else $pagestart=$thispage-$pageradius; if($thispage+$pageradius>$totpages)$pageend=$totpages; else $pageend=$thispage+$pageradius; for($i=$pagestart;$i<=$pageend;$i++) { if($i==$thispage){$pagelinksM.="$i";} else { if($i<$thispage) {$pagelinksM.="$i";} else {$pagelinksM.="$i";} } } $pagelinks=$pagelinksS.$pagelinksM.$pagelinksE; $navig.=$pagelinks; #next link if($next==1) $navig.="  :  "."".mlconvert("XpSÀ¶pÅh")." >>"; $navig.="
"; echo $navig; $st=0;$en=$cnt; //display video link for($i=0;$i<$cnt;$i++) { $video=mysqli_fetch_object($getvideos); $videoid=stripslashes($video->videoid); $vtitle=stripslashes($video->videotitle); $vscript=stripslashes($video->videolink); $category=$video->videocategory; ?>
$vtitle"; ?> VIDEO SETTINGS"; ?>