New bug+suggestion-->haven't had time to check for cure

"foosink1 <[email protected]>" <[email protected]> Mon, 13 Jan 2003 03:08:13 -0000
Newsgroups gmane.network.ubh
Message-ID <[email protected]>
2003/01/12 20:42:42 ubh.save_file INFO> Done saving file.
DBD::mysql::db do failed: Duplicate entry '7623' for key 1 at 
lib/Ubh/Metadata.pm line 23.
DBD::mysql::db do failed: Duplicate entry '7623' for key 1 at 
lib/Ubh/Metadata.pm line 23.
/data/news/ubh/runubh.sh: line 8: [: 255: unary operator expected

if I have some time, I will dig into this, probably caused by bad 
header (duplicate file), cure could be a check before or a catch 
during.

--->Suggestion

Maybe a filter program to run the headers through to look for certain 
characteristics:
--member of a series (regex here?  mysql loves 'em)
--favorite posters
--etc.

& apply a weight based on rules applied

UBH then does the select with an ORDER BY based on these weights, 
download in that order.  Across news groups.

That would be not only the coolest in the realm, but would allow us 
to suck down what we want, toss the rest.

(Maybe I even build some kind of interactive interface (TK?) to allow 
selection of those that fall out of the rules for later download.)

Maybe an idea is to add a "weight" column to the headers table, 
update the select in UBH with an:

        $stmt .= "GROUP by h.header_id ORDER BY h.weight,h.subject";

The potential for this is awesome. Good work.





------------------------ Yahoo! Groups Sponsor ---------------------~-->
Turn flat surfaces into speakers with the Soundbug.
http://us.click.yahoo.com/QWAVSC/onCFAA/xGHJAA/IHFolB/TM
---------------------------------------------------------------------~->

To unsubscribe from this group, send an email to:
[email protected]

 

Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/