Fri, Jan 24, 5:03 PM CST

Renderosity Forums / Community Center



Welcome to the Community Center Forum

Forum Moderators: wheatpenny Forum Coordinators: Anim8dtoon

Community Center F.A.Q (Last Updated: 2025 Jan 22 10:24 am)

Forum news, updates, events, etc. Please sitemail any notices or questions for the staff to the Forum Moderators.



Subject: A few suggestions


_dodger ( ) posted Wed, 04 December 2002 at 12:42 PM · edited Tue, 21 January 2025 at 5:33 AM

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.


Privacy Notice

This site uses cookies to deliver the best experience. Our own cookies make user accounts and other features possible. Third-party cookies are used to display relevant ads and to analyze how Renderosity is used. By using our site, you acknowledge that you have read and understood our Terms of Service, including our Cookie Policy and our Privacy Policy.