0 ) { list($sec,$min,$hour,$mday,$mon,$year,$wday,$yday,$isdst) = localtime(); $mon = $mon + 1; $lasttimeon = mktime($hour,$min,$sec,$mon,$mday,$year); $laston = "REPLACE INTO laston VALUES($cat,$userid,$lasttimeon)"; $resultb = ppmysql_query($laston, $link); } childsub($cat); $childnav = "Home $childnav"; $searchcat = $cat; } else { if ( $username != "" && $username != "Unregistered" ) $childnav = "Welcome, $username!"; else $childnav = "Welcome to the ".$Globals{'galleryname'}."!"; $searchcat = 998; } if ( !empty($cat) ) { $query = "SELECT id,catname FROM categories WHERE id='$cat'"; $ctitleq = ppmysql_query($query, $link); if ( $ctitleq ) { list( $catid, $cattitle ) = mysql_fetch_row($ctitleq); ppmysql_free_result( $ctitleq ); $tablehead = "$cattitle"; } else $tablehead = ""; } else { $tablehead = "Main Index"; } $header = str_replace( "titlereplace", "$tablehead", $header ); $output = "$header

$menu2 $menu
"; if ( $Globals{'mostrecent'} == "yes" && $Globals{'recentdefault'} == "no" ) { display_gallery("latest"); } $output .= "

"; $count = 0; $catdepth = 0; $catrows = ""; $cptotal = 0; $posttotal = 0; $totalviews = 0; $diskspace = 0; if ( !(IsSet($cat)) ) { catrow(0); } else { catrow($cat); } $output .= $catrows; $usertotal = get_totalusers(); $query = "SELECT SUM(views), SUM(filesize), COUNT(*) AS fsize FROM photos"; $totalv = ppmysql_query($query,$link); list( $totalviews, $diskuse, $totalphotos ) = mysql_fetch_row($totalv); ppmysql_free_result($totalv); $query = "SELECT id FROM comments"; $lastc = ppmysql_query($query, $link); $catposts = mysql_num_rows($lastc); ppmysql_free_result($lastc); $totalviews = number_format( $totalviews ); $totalphotos = number_format( $totalphotos ); $usertotal = number_format( $usertotal ); $posttotal = number_format( $catposts ); $diskspace = $diskuse/1048576; $diskspace = number_format( $diskspace, 1 ); $diskspace = "$diskspace MB"; // Lets get the Top 5 Posters $query = "SELECT user,userid,COUNT(*) AS pcount FROM photos GROUP BY user ORDER BY pcount DESC"; $queryz = ppmysql_query($query,$link); $rowcnt = mysql_num_rows($queryz); $numfound = 0; while ( list($theuser, $theuserid, $uphotos) = mysql_fetch_row($queryz)) { $numfound++; $topposters[$numfound] = $theuser; $topid[$numfound] = $theuserid; $topposts[$numfound] = $uphotos; if ( $numfound == 5 ) break; } $toplist = "
Top Posters:"; for ( $x=1; $x < ($numfound+1); $x++ ) { $toplist .= " $topposters[$x] ($topposts[$x])"; } if ($Globals{'stats'} == "yes") { if ( !IsSet($cat) ) { $output .= ""; } } $output .= "

$childnav

Recent Posts: last day last 7 days last 14 days all images

Category

Photos

Comments

Last Comment

Last Photo Upload

$usertotal registered users, $totalphotos posted photos and $posttotal comments
$totalviews photo views using $diskspace disk space.$toplist

"; if ( $Globals{'mostrecent'} == "yes" && $Globals{'recentdefault'} == "yes") { display_gallery("latest"); } if ( $Globals{'dispopular'} == "yes" ) { display_gallery("most_views"); } if ( $Globals{'disrandom'} == "yes" ) { display_gallery("random"); } print $output."