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