Category talk:Animated GIF files

Bereinigung abgebrochen

Nachden ich von 7500 auf etwa 6800 Dateien im Verzeichnis gekommen war, ist die Anzahl über nacht wieder auf über 21.000 angewachsen. Da gebe ich auf. ArishG (talk) 13:26, 21 October 2016 (UTC)

Versuch einer Bereinigung der Kategorie "Animated GIF files"

Vorgehensweise. Anhand der Einzelbildkategorien werden die benutzten Kategorien geprüft und im Falle, dass sie ausschließlich GIF enthalten, wird diese Kategorie dann in "Animated GIF files" eingetragen. Die als Einzeldateien in Animated GIF files eingetragenen Dateien werden per VisualBot hier ausgetragen. ArishG (talk) 10:22, 19 October 2016 (UTC)

Animations of physics (Mit allen Unterkategorien) ArishG (talk) 21:13, 20 October 2016 (UTC)

Animations in very large GIF files. ArishG (talk) 11:47, 20 October 2016 (UTC)

Animations of crosses ArishG (talk) 09:08, 20 October 2016 (UTC)

Animated human action ArishG (talk) 21:27, 19 October 2016 (UTC)

Animated maps of the Solar Eclipse‎ArishG (talk) 18:12, 19 October 2016 (UTC)

Category:Animations of standing waves

Category:Animations of water waves

Category:Early digital photographs by Rick Doble‎ ArishG (talk) 11:17, 19 October 2016 (UTC)

Category:Animations from Anatomography‎ Als Unterkategorie eingetragen und Einzelbilder aus Animated GIF ausgetragen per Bot. ArishG (talk) 10:22, 19 October 2016 (UTC)

Category maintenance SQL

-- 2> /dev/null; date; echo '
/* Missing and wrongly categorized Animated GIF files
 * Based on [[User:Dispenser/GIF check]]
 *
 * License: CC-0
 * Runtime: 5 minutes
 */
SELECT IF(cl_to IS NULL, "Add", "Remove") AS "Cat",
  CONCAT("[[File:", REPLACE(img_name,"_"," "), "]]") AS File
FROM image
JOIN page ON page_namespace=6 AND page_title=img_name
LEFT JOIN categorylinks ON cl_from=page_id AND cl_to IN (
  "Animated_GIF_files"
)
WHERE img_major_mime="image" AND img_minor_mime="gif" AND img_media_type="BITMAP"
AND img_metadata LIKE "%\"frameCount\";i:%"
AND (img_metadata LIKE "%\"frameCount\";i:1;%"
 XOR cl_from IS NULL)
GROUP BY img_name
;-- ' | sql commonswiki_p

Dispenser (talk) 04:57, 22 February 2016 (UTC)

Amended query since img_metadata field is sometimes missing, see Bug T155741. —Dispenser (talk) 16:24, 22 January 2017 (UTC)

Categorizing by file type

@Estopedist1: You removed this category from a set of animated GIF files. I suppose your reason is that it is already in an Animations of ... category. I am the first to agree, that Commons does not need to be told which images have which file extension — because it already knows that. But then the content of this category should be moved to Animations. Ill-advised categories like this one (or SVG files) should be deleted, not ignored. Watchduck (quack) 13:31, 2 November 2019 (UTC)

yep, it is wide topic. For example, no idea why there is category:Animated SVG maps?--Estopedist1 (talk) 16:57, 2 November 2019 (UTC)

What would make sense is to categorize by behaviour, rather than file extension. This and this animated SVG behave just like GIFs. You can passively look at them, and that's it. By contrast, this and this one are interactive. Adding them to interactive animations would actually add information to Commons. Watchduck (quack) 23:36, 2 November 2019 (UTC)