_dodger opened this issue on Dec 04, 2002 ยท 6 posts
_dodger posted Wed, 04 December 2002 at 12:42 PM
First, I really think a rant forum is in order. I feel a need for a place to bitch about how a perfectly good work can be passed over by so many dolts when the thumbnail doesn't show any chicks or ninjas. Aside from that, I have a gallery suggestion and a Free Stuff suggestion. Really, the same suggestion. We have a 'best rated' and 'most comments' but not a 'hot' search order. The Hot 20 doesn't count nor does it work. Something that takes into account a date -- for instance, best rated for the last day, week, month, etc. Most commented restricted by the same. Maybe even a dropdown for time period and text box for number of that time period. For the Free Stuff, it would be in terms of downloads. Okay, another suggestion... a pretty simple one, actually... this one is titally Free Stuff related -- Add a column to the Free Stuff table that marks whether something is active or not. As simple as active enum('Y','N'). Or even dead char(0) (null is not dead, '' is dead). Now, once per night, run something like the folowing ina cron job:
#!/usr/bin/perl
use DBI;
use LWP::Simple(':all');
my $dbh = DBI->connect('DBI:mysql:freestuff','freestuffuser','freestuffpass');
my $get_free_stuff = $dbh->prepare(<<"eosql");
SELECT url, id
FROM free_stuff
eosql
my $setactive_fs = $dbh->prepare(<<"eosql");
UPDATE free_stuff
SET active = ?
WHERE id = ?
eosql
$get_free_stuff->execute;
while (my ($url, $id) = $get_free_stuff->fetchrow_array) {
if (Get($url)) {
$setactive_fs->execute('Y',$id);
}
else {
$setactive_fs->execute('N',$id);
}
}
This will at least clear out the Free Stuff that leads to a broken link. You can do the same with the image, too, and easily wrap it all into the same script. Just once a night will be plenty to delete all the damned things in Free Stuff that have huge numbes of 'downloads' only because people think it looks cool and check back occassionally to see if maybe, just maybe, the link is fixed.
Grimtwist posted Wed, 04 December 2002 at 6:21 PM
Rant forum? You could probably do that in Virtual Tavern. Or just feel free to have a rant where ever you want.
bluetone posted Thu, 05 December 2002 at 10:14 AM
Don't tell THAT to dodger! He already does! ;> But, I agree that a rant in a tavern(pub) is more agreeable with a pint... or 2... or 3... ::>>
caleb68 posted Sat, 07 December 2002 at 6:17 PM
I only see one problem with the 'check for file' routine. Html redirects. Some users are using there own scripts on there site to redirect and count file downloads, as well as some directing you strait to html pages. If there is a redirect on the server that your requesting from its either going to be reporting 'no its inactive' or 'yes its active' which nulls the effect when your being redirected to a error page like so many free servers do these days.
cambert posted Mon, 09 December 2002 at 9:26 AM
Rant forum is commonly known as OT.
EricofSD posted Sun, 15 December 2002 at 12:54 AM
As for the dead links (reminds me of the hot bot commercial a few years ago), osity has a script that deletes sites if they are down twice in a short period. It did clear out the dead stuff, but also took out some good stuff that was on a server getting routine maintenance and some merchants / freebie contributors threatened to leave because it was too time consuming to rebuild here. So watch what you wish for, you might get it.