#!/usr/bin/perl -w # This code is a part of Slash, and is released under the GPL. # Copyright 1997-2001 by Open Source Development Network. See README # and COPYING for more information, or see http://slashcode.com/. # $Id: hof.pl,v 1.5.2.6 2001/07/12 14:02:17 jamie Exp $ use strict; use Slash; use Slash::Display; use Slash::Utility; ################################################################## sub main { my $slashdb = getCurrentDB(); my $form = getCurrentForm(); my $section = $slashdb->getSection($form->{section}); header(getData('head'), $section->{section}); my @topcomments = ( ); # getCommentsTop() comes in two versions as of 2001/07/12. The old # version takes impossibly long to do a 3-way join on 2.5 million # rows. The new version isn't really written yet. So I'm just # commenting this out until the new version is done. See # Slash/DB/MySQL/MySQL.pm getCommentsTop(). - Jamie 2001/07/12 # my $topcomments; # $topcomments = $slashdb->getCommentsTop($form->{sid}); # for (@$topcomments) { # my $top = $topcomments[@topcomments] = {}; # # leave as "aid" for now # @{$top}{qw(section sid anickname title pid subj cdate sdate uid cid score)} = @$_; # my $user_email = $slashdb->getUser($top->{uid}, ['fakeemail', 'nickname']); # @{$top}{'fakeemail', 'nickname'} = @{$user_email}{'fakeemail', 'nickname'}; # } slashDisplay('main', { width => '98%', actives => $slashdb->countStories(), visited => $slashdb->countStoriesTopHits(), activea => $slashdb->countStoriesAuthors(), activep => $slashdb->countPollquestions(), activesub => $slashdb->countStorySubmitters(), currtime => timeCalc(scalar localtime), topcomments => \@topcomments, }); # this is commented out ... ? # Not I. -Brian # if (0) { # only do this in static mode # print "

"; # titlebar("100%", "Most Popular Slashboxes"); # my $boxes = $I{dbobject}->getDescription('sectionblocks'); # my(%b, %titles); # # while (my($bid, $title) = each %$boxes) { # $b{$bid} = 1; # $titles{$bid} = $title; # } # # # #Something tells me we could simplify this with some # # thought -Brian # foreach my $bid (keys %b) { # $b{$bid} = $I{dbobject}->countUsersIndexExboxesByBid($bid); # } # # my $x; # foreach my $bid (sort { $b{$b} <=> $b{$a} } keys %b) { # $x++; # $titles{$bid} =~ s/<(.*?)>//g; # print <$b{$bid} $titles{$bid}
# EOT # last if $x > 10; # } # } footer($form->{ssi}); } ################################################################# createEnvironment(); main(); 1;