Requiem Screen Shots |
global $user;
if ($user->uid) {
print t('Welcome @name! You can upload your requiem screen shots here to show everyone. You can add comments here!', array('@name' => $user->name));
?>
$offset=0;
if(isset($_REQUEST['offset'])){
$offset=$_REQUEST['offset'];
}
$limit=12;
mysql_connect("localhost", "requiemdb", "kanola44") or die(mysql_error());
mysql_select_db("rockiem") or die(mysql_error());
#paging is done here
$countquery="SELECT count(*) as cnt FROM rb_ss WHERE showss=1";
$result = mysql_query($countquery) or die(mysql_error());
$row = mysql_fetch_array($result);
$allss=$row['cnt'];
$pages=ceil($allss/$limit);
$previous=$offset-$limit;
if($previous>=0){
$paging.=" First ";
$paging.=" Previous ";
}else{
# $paging.=" First ";
# $paging.=" Previous ";
}
for($i=1;$i<=$pages;$i++){
$pageoffset=($i-1)*$limit;
if($offset==$pageoffset){
$paging.=" ".$i." ";
}else{
$paging.=" ".$i." ";
}
}
$next=$offset+$limit;
$last=($pages-1)*$limit;
if($next<=$allss){
$paging.=" Next ";
$paging.=" Last ";
}else{
# $paging.=" Next ";
# $paging.=" Last ";
}
#end of paging
$query="SELECT username,filename,notes,thumbnail,original,showss,dateadded FROM rb_ss WHERE showss=1 ORDER BY ssid DESC LIMIT $limit OFFSET $offset";
$result = mysql_query($query) or die(mysql_error());
$sstable="

