[Clipart] next historical question

[Jon Phillips]

I don't know about it, but I do remember the episode.

They have copyright violations. Also, Wolfgang, just by adding these images
to the site and db, really you need to make sure there is a human checking
the images to see if they are in violation.

Jon


On Tue, Mar 12, 2013 at 10:34 AM, Jakub Jankiewicz <jcubic at onet.pl> wrote:

> There was some issue with ArtFavor clipart and one of the authors
> requested to remove them all, so I remove them from database but they
> remain on disk. I don't know about the rest, but you need to know that
> delete clipart by use didn't remove the file from the disk once.
>
> Maybe rejon, pianoBrad and boobaloo will know about that since they are
> on your list, they all have librarian accounts.
>
> On Tue, 12 Mar 2013 05:23:31 -0400
> Wolfgang Spraul <wolfgang at fabricatorz.com> wrote:
>
> > OK I have continued some cleanup, roughly summing up:
> >
> > *) deleted about 500 .svg files that had pd_issue set in the
> > database, but were still present in the filesystem (and publicly
> > accessible). Also deleted about 4200 derivative .pngs of those
> > pd_issue graphics
> >
> > *) imported about 500 old cch graphics into the database, and
> > deleted about 1000 duplicates of those graphics (see earlier
> > mail)
> >
> > *) renamed about 200 files with .SVG (capitalized) extension
> > that didn't show up in the database. The database had a few
> > (13) .SVG graphics which I also renamed to .svg. Going forward,
> > I will try to disable .SVG (capitalized) or auto-lowercase for
> > new uploads.
> >
> > Now I am looking at 6308 .svg files that show up in the filesystem,
> > but not in the database. They belong to the following users:
> >
> >     962 ArtFavor
> >     785 Anonymous
> >     176 inky2010
> >      88 rejon
> >      84 gustavorezende
> >      80 pianoBrad
> >      73 Gerald_G
> >      69 brandynne
> >      68 slanteigne
> >      66 Merlin2525
> >      62 jiangyi_99
> >      57 cibo00
> >      54 gsagri04
> >      52 boobaloo
> >      51 10binary
> > plus another 856 users with less than 50 graphics, for a total of
> > 6308.
> >
> > Any idea what that might be? I think I will roughly do this:
> >
> > 1. make sure that all those users exist in the database, if not
> > create them.
> > 2. check some graphics manually to understand whether they are old
> > 'problem' uploads, spam, non-pd, duplicates, etc.
> > 3. import all those 6308 into the database same as I did for the 'cch'
> > user this morning.
> >
> > The problem with #3 is that unlike the cch import, this one will be
> > harder to reverse once I did it. In the cch case, it's all listed
> > under that specific user. But for these 6308 graphics, they are spread
> > out among hundreds of users. So once I import them, they will be
> > everywhere and if there are problems with those graphics, they would
> > need to be flagged pd_issue etc. and then deleted again.
> >
> > Feedback?
> > _______________________________________________
> > clipart mailing list
> > clipart at lists.freedesktop.org
> > http://lists.freedesktop.org/mailman/listinfo/clipart
>
> --
> Jakub Jankiewicz, Web Developer
> http://jcubic.pl
>
> _______________________________________________
> clipart mailing list
> clipart at lists.freedesktop.org
> http://lists.freedesktop.org/mailman/listinfo/clipart
>
>


-- 
Jon Phillips 王✳ http://fabricatorz.com ✳ skype: kidproto ✳ irc: rejon
+1.415.830.3884 (global) ✳ +86-187-1003-9974 (beijing)
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.freedesktop.org/archives/clipart/attachments/20130312/91989a07/attachment.html>