Path: news.nzbot.com!not-for-mail
NNTP-Posting-Date: Sat, 25 Nov 2017 21:47:47 -0600
Newsgroups: alt.binaries.multimedia.erotica.lesbians
Subject: Re: Anyone worked out new naming convention on a.b.e.? - File Names.zip - Book1.zip
X-Newsreader: NewsLeecher v7.0 Final (http://www.newsleecher.com)
References: <cdej1d160dfjs97b8gkfhtimb7conlpnfv@4ax.com>
Message-ID: <QJednRxeqZ7-pIfHnZ2dnUU7-KudnZ2d@giganews.com>
Date: Sat, 25 Nov 2017 21:47:47 -0600
Lines: 90
X-Usenet-Provider: http://www.giganews.com
X-Trace: sv3-MNYgSGezlfnvmFBhHo2jkGJzuB1QuMY0kG1xjJ7TF54L+u2+SAJhtDoTfOS3OU3zy8sNIVbBHhRMarF!uFMdix8szQf5Cg2QvmF2VOwmeWfIlmBQvY68lH6nEOzVhDszUqrAVsULdbr8ug/gZaClrWn7VjxB
X-Complaints-To: abuse@giganews.com
X-DMCA-Notifications: http://www.giganews.com/info/dmca.html
X-Abuse-and-DMCA-Info: Please be sure to forward a copy of ALL headers
X-Abuse-and-DMCA-Info: Otherwise we will be unable to process your complaint properly
X-Postfilter: 1.3.40
X-Original-Bytes: 4744
X-Received-Bytes: 4866
X-Received-Body-CRC: 3867620019
Xref: news.nzbot.com alt.binaries.multimedia.erotica.lesbians:14699
In reply to "Ed H" who wrote the following:
>
>
> > > Ed
> >
> > Nice VBA coding. You've achieved what I've recently been able to do, but in
> > less
> > steps! I currently use a batch file to do the same with output to a csv
> > file.
> >
> > Can I ask you... is the 'date downloaded' the date that the sfv file was
> > downloaded? How does your code 'decide' which line of the sfv file to
> > extract as
> > the 'real file name'? (it seems that it's mainly the first line,
> > occassionally
> > second, other times random).
> >
> > In order to have a truly useful database for future resource, the minimum
> > required columns (variables) would be:
> > 1. original date posted to a.b.e.
> > 2. original rarset name (ie the randomly generated name)
> > 3. actual embedded filename (without extension and CRC32 value)
> > 4. full rarset size (in kB)
> > 5. number of files in rarset (perhaps)
> >
> > We currently can get 2 and 3 from the sfv file, but 4 and 5 require data
> > from
> > the par2 file (which is a much more complex data file), and 1 requires
> > access to
> > the original file posting data (via newsreader or perhaps nzbindex).
> >
> > Interested to hear what you think.
> >
> > Nhoj
> >
> >
> >
> Thanks, but I can't claim credit for all the coding... much of it I
> just found lying around the internet, if you catch my drift :)
>
> The database works by importing the contents of all text file copies
> of the sfv files into a table (which is cleared before the import
> starts), attaching the file name (renamed back to .sfv) to each line.
>
> The contents of this table are then appended to the final table, and
> today's date is added to each record at this point. (Thus likely to
> be, but not necessarily, the download date.) The sfv file name field
> of the final table is set to disallow duplicates, so only one line
> from each sfv is kept - presumably the first line, but that might just
> be pot luck!
>
> Lastly a query is run to display those downloaded 'today', on the
> basis that previous days' downloads will already have been viewed.
>
> It would be easy to remove the extension and CRC32 value, which would
> be neater, but I'm not sure I CBA!
>
> Acquiring the other information suggested above looks very difficult
> to me - at the very least you would have to download the par files as
> well as the sfvs. Whilst it would be useful to know, it is quite easy
> to find out for the files you're interested in. Let's face it, file
> size is the least interesting of the dimensions associated with this
> kind of material ;)
>
> But anyone is welcome to modify the database in any way they wish!
>
> Ed
Nice. Thanks. Yes, why reinvent the wheel when you can retask code already
available. Same for my batch file.
I agreee that the info from an sfv file (ie. 2 and 3 from list above) is all
that one needs to make a decision, but the decision would be a more informed one
with more info (ie. 4 and maybe 5 from list above; eg. size diff between 1080p
and 4k versions). And as for original posting date and time (ie. 1 from list),
its value is to give chronological order to the list (like it is displayed in
newsreaders) as it grows, esp for future reference.
Downloading the par2 files along with the sfv files is not a signif drag on
bandwidth, but getting a batch file (or other method) to extract info from it is
proving next level. I wonder if anyone in the abmel community has the par2
structure insight and coding nouse?
Many thanks for your contribution.
Nhoj
|
|