Forum:Reorganization of the whole Uncycs/de/Videos
Tried to save following on correct wiki, not working:
Some images may have failed to import, for probably various reasons. Most notable are some redirects, but I recommend checking anything that's not a video and seeing what's up/manually getting it if possible. -— Athyria ༆ 17:32, 31 March 2019 (UTC)
redirects[edit]
MariaDB [uncy_de]> select page_title from page where page_namespace = 6 and page_is_redirect = 1 and not exists (select * from image where img_name = page_title) and not exists (select * from categorylinks where cl_from = page_id and cl_to = 'Vídeos');
- file:Ebaysell.gif
- file:Lauftext_AdM.gif
- file:EbaycommOn.gif
- file:Ebayhelp.gif
- file:Ebaybuy.gif
- file:Myebay.gif
- file:Verwaltung_Zange.jpg
- file:AdW.png
- file:AdM.png
- file:Crystal_Clear_app_mp3.png
- file:P_sport-lightblue.png
- file:P_ps-lightblue.png
- file:P_religion-lightblue.png
- file:P_transport-lightblue.png
- file:P_history-lightblue.png
- file:P_countries-lightblue.png
- file:P_art-lightblue.png
- file:P_social_sciences-lightblue.png
18 rows in set (0.07 sec)
not redirects, mostly videos[edit]
MariaDB [uncy_de]> select page_title from page where page_namespace = 6 and page_is_redirect = 0 and not exists (select * from image where img_name = page_title) and not exists (select * from categorylinks where cl_from = page_id and cl_to = 'Vídeos');
- file:...Immer_schön_die_Klappe_zu,_gelle?
- file:1._Geschischte_des_Frauenfußballs_im_TV_-_Sportstudio,_29._März_1970
- file:10_hours_and_1_second_of_pure_black_screen!
- file:180px-Richard_Stallman_2005_(chrys).jpg
- file:60_000_HP_"Shockwave"_FIRST_JET_RACE_EVER_in_MI!
- file:Aktenzeichen_XY_02.11.1990_3_6
- file:Aktenzeichen_XY_ungelöst_(1.10.1982)_Teil_5_7
- file:Alexander_Marcus_-_1,_2,_3
- file:Alexander_Marcus_-_Papaya
- file:Aliens_vs._Predator_2_-_Die_Alien-WG_auf_Schwäbisch
- file:Alte_Kameraden_Marsch
- file:Americans_are_NOT_stupid_-_WITH_SUBTITLES
- file:Arnold_Gives_Advice
- file:Bluefin-bigs.JPG
- file:COMEDIAN_HARMONISTS_LES_GARS_DE_LA_MARINE
- file:Caravan_with_Renault_1.4_turbo_engine
- file:Cartoon_coronation\БумажнаÑ_коронациÑ
- file:Cat_Man_Do_-_Simon's_Cat
- file:Chopin-Trauermarsch
- file:Condi_Rice_Raps
- file:Darth_Vader
- file:David_Hasselhoff_-_Crazy_for_you
- file:David_Hasselhoff_-_DU
- file:David_Hasselhoff_-_Hooked_on_a_Feeling
- file:DerpCraft_(Minecraft_Cartoon_)_German_Version
- file:Die_ARD_Tagesschau_auf_Schwäbisch_-_dodokay_SWR
- file:Die_Ärzte_&_Michael_Schumacher_"Mein_Freund_Michael"
- file:Dixie_Klo_Crash_(2)
- file:Domian_rastet_aus!_*NEU*_-_Das_Gespräch_in_voller_Länge!!
- file:Drucker-Troubleshooting
- file:Du_Ekelhafter!
- file:Eddie_Van_Halen's_Dad
- file:Edmund_Stoiber_-_Der_Transrapid
- file:Eulish_2
- file:Evolution_of_Dance
- file:Extra3_-_Guido_Westerwelle_Hymmne
- file:Fabian_-_Gib_mir_die_Welt_plus_5_Prozent_(1_8)
- file:Fat_chick_Thanksgiving_EPIC_FAIL
- file:Favorite_Oscar?_moment_-_Steve_Martin's_Michael_Moore_joke
- file:Frau_am_steuer
- file:Funny_-_Austin_Powers_-_The_Movie_-_Dr._Evil_-_How_About_No
- file:Funny_Kyocera_Cell_Phone_Commercial
- file:Gerd_Show_-_Gerhard_Schröder_-_Der_Steuersong
- file:Gotthilf_Fischer_&_Chor_-_Ich_hab_mein_Herz_in_Heidelberg_verloren_2008
- file:Greatest_wrestling_commercial_ever
- file:Greek_Bike_Accident_1
- file:Guelcan_präsentiert_ihre_Oberweite
- file:Guido_Knopp_stellt_fest
- file:Guitar
- file:Harald_Schmidt_Show_-_Helmut_Berger_bei_Schmidt_Teil_1
- file:Harald_Schmidt_Show_-_Nazi-Werbung
- file:Harald_Schmidt_Uli_Hoeneß_schimpft
- file:He-man_der_Saarländer_-_Saarländische_Synchro
- file:Helge_Schneider_-_Ich_drück_die_Maus
- file:Helge_Schneider_als_Studienrat_und_Major_(1_of_2)
- file:Holz_Vor_Der_Hütte
- file:Hummer_eingebaute_vorfahrt
- file:Ich_liebe_Deutscheland
- file:Karate_Fail
- file:Klaus_Prömpers_und_die_800_Millionen_Tote
- file:Klinsmann-Kick
- file:Kriegsende_NDR_Extra_3_Hitler_Guido_Knopp
- file:Kurde_am_turmspringen
- file:LATINA_girl_dancing
- file:LKW_Geisterfahrer
- file:LKW_fressende_Brücke
- file:Liegen_reservieren_-_7_Tipps_für_den_Platz_an_der_Sonne
- file:Love_Story
- file:Lustiger_fire_fart_bleh_feuer_furz_kampffurz_fireball
- file:Magic_Mushroom_and_acid_trip
- file:Mann_rastet_aus
- file:Masters_of_the_Universe_Werbung_80er_Jahre
- file:MegaFURZ!!!
- file:Muay_thai_fail
- file:Möse_Schmeckt_Viel_Besser_-_Alexanderband
- file:Nickelodeon_Gak_Ad
- file:Pachelbel_Rant
- file:Parcheggio_perfetto
- file:Peter_Fox_-_Haus_am_See_(official_Video)
- file:Polizeianruf_Mannheim_Zehnbauer
- file:Popel_Affe_-_Funny_Monkey
- file:Portland_Ice_Storm
- file:Preussens_Gloria_KMS_Bismarck
- file:Python_versus_Google
- file:Quiz_Taxi_Skandal!
- file:Rainald_Grebe_-_Brandenburg_(IFA_2005_live)
- file:Rainald_Grebe_-_Guido_Knopp
- file:Real_-_BVB_Das_frühe_Tor_-_Teil_1
- file:Schalke_04_Felix_Magath_verliert_die_Nerven_und_rastet_aus
- file:Schmidt_&_Pocher
- file:Schnäppchen.JPG
- file:Smells_like_Teen_Spirit_-_The_Ukulele_Orchestra
- file:Soziale_Kompetenz_-_ein_Lehrfilm
- file:Star_Wars_uff_pälzisch_Episoden_1_bis_10
- file:Super_Perforator
- file:TV_Dinner_-_Simon's_Cat
- file:Tagesschau_Panne_Thema,_falsche_Graphik,_falscher_Film
- file:Taliban_Midget_with_AK47
- file:The_Final_Countdown_Techno_Remix
- file:The_JET_Bicycle_-_The_most_dangerous_unsafe_bike_EVER
- file:The_Next_Big_Movie_-_Trailer_-_Switch_Reloaded
- file:The_Original_Human_TETRIS_Performance_by_Guillaume_Reymond
- file:The_best_of_Silvio_Berlusconi
- file:Ton_Tauben_schießen_für_echte_Männer
- file:Unglaublich_Brettunfall_vom_feinsten
- file:Unser_Stoiber
- file:Videos_chistosos_moto_yamaha_suzuki_honda_harley_davidsonfunny
- file:Voll_assi_toni
- file:Vorabend._Eine_Reise_durchs_TV-Programm
- file:Vuvunella_the_modern_Urinella
- file:Wat´n_dat???_Tutorial-_Urinella_Pibella_-_DIY
- file:Windows_did_not_steal_ideas_from_Mac_OS_X!
- file:ärztelust.jpg
113 rows in set (0.18 sec)
Script output[edit]
List of videos found on the Wikia site as reported by grabFiles.php:
...Immer_schön_die_Klappe_zu,_gelle? 1._Geschischte_des_Frauenfußballs_im_TV_-_Sportstudio,_29._März_1970 10_hours_and_1_second_of_pure_black_screen! 60_000_HP_"Shockwave"_FIRST_JET_RACE_EVER_in_MI! Aktenzeichen_XY_02.11.1990_3_6 Aktenzeichen_XY_ungelöst_(1.10.1982)_Teil_5_7 Alexander_Marcus_-_1,_2,_3 Alexander_Marcus_-_Papaya Aliens_vs._Predator_2_-_Die_Alien-WG_auf_Schwäbisch Alte_Kameraden_Marsch Americans_are_NOT_stupid_-_WITH_SUBTITLES Arnold_Gives_Advice COMEDIAN_HARMONISTS_LES_GARS_DE_LA_MARINE Caravan_with_Renault_1.4_turbo_engine Cartoon_coronation\Бумажная_коронация Cat_Man_Do_-_Simon's_Cat Chopin-Trauermarsch Condi_Rice_Raps David_Hasselhoff_-_Crazy_for_you David_Hasselhoff_-_DU David_Hasselhoff_-_Hooked_on_a_Feeling DerpCraft_(Minecraft_Cartoon_)_German_Version Die_ARD_Tagesschau_auf_Schwäbisch_-_dodokay_SWR Die_Ärzte_&_Michael_Schumacher_"Mein_Freund_Michael" Dixie_Klo_Crash_(2) Domian_rastet_aus!_*NEU*_-_Das_Gespräch_in_voller_Länge!! Drucker-Troubleshooting Du_Ekelhafter! Eddie_Van_Halen's_Dad Edmund_Stoiber_-_Der_Transrapid Eulish_2 Evolution_of_Dance Extra3_-_Guido_Westerwelle_Hymmne Fabian_-_Gib_mir_die_Welt_plus_5_Prozent_(1_8) Fat_chick_Thanksgiving_EPIC_FAIL Favorite_Oscar?_moment_-_Steve_Martin's_Michael_Moore_joke Frau_am_steuer Funny_-_Austin_Powers_-_The_Movie_-_Dr._Evil_-_How_About_No Funny_Kyocera_Cell_Phone_Commercial Gerd_Show_-_Gerhard_Schröder_-_Der_Steuersong Gotthilf_Fischer_&_Chor_-_Ich_hab_mein_Herz_in_Heidelberg_verloren_2008 Greatest_wrestling_commercial_ever Greek_Bike_Accident_1 Guelcan_präsentiert_ihre_Oberweite Guido_Knopp_stellt_fest Guitar Harald_Schmidt_Show_-_Helmut_Berger_bei_Schmidt_Teil_1 Harald_Schmidt_Show_-_Nazi-Werbung Harald_Schmidt_Uli_Hoeneß_schimpft He-man_der_Saarländer_-_Saarländische_Synchro Helge_Schneider_-_Ich_drück_die_Maus Helge_Schneider_als_Studienrat_und_Major_(1_of_2) Holz_Vor_Der_Hütte Hummer_eingebaute_vorfahrt Ich_liebe_Deutscheland Karate_Fail Klaus_Prömpers_und_die_800_Millionen_Tote Klinsmann-Kick Kriegsende_NDR_Extra_3_Hitler_Guido_Knopp Kurde_am_turmspringen LATINA_girl_dancing LKW_Geisterfahrer LKW_fressende_Brücke Liegen_reservieren_-_7_Tipps_für_den_Platz_an_der_Sonne Love_Story Lustiger_fire_fart_bleh_feuer_furz_kampffurz_fireball Magic_Mushroom_and_acid_trip Mann_rastet_aus Masters_of_the_Universe_Werbung_80er_Jahre MegaFURZ!!! Muay_thai_fail Möse_Schmeckt_Viel_Besser_-_Alexanderband Nickelodeon_Gak_Ad Pachelbel_Rant Parcheggio_perfetto Peter_Fox_-_Haus_am_See_(official_Video) Polizeianruf_Mannheim_Zehnbauer Popel_Affe_-_Funny_Monkey Portland_Ice_Storm Preussens_Gloria_KMS_Bismarck Python_versus_Google Quiz_Taxi_Skandal! Rainald_Grebe_-_Brandenburg_(IFA_2005_live) Rainald_Grebe_-_Guido_Knopp Real_-_BVB_Das_frühe_Tor_-_Teil_1 Schalke_04_Felix_Magath_verliert_die_Nerven_und_rastet_aus Schmidt_&_Pocher Smells_like_Teen_Spirit_-_The_Ukulele_Orchestra Soziale_Kompetenz_-_ein_Lehrfilm Star_Wars_uff_pälzisch_Episoden_1_bis_10 Super_Perforator TV_Dinner_-_Simon's_Cat Tagesschau_Panne_Thema,_falsche_Graphik,_falscher_Film Taliban_Midget_with_AK47 The_Final_Countdown_Techno_Remix The_JET_Bicycle_-_The_most_dangerous_unsafe_bike_EVER The_Next_Big_Movie_-_Trailer_-_Switch_Reloaded The_Original_Human_TETRIS_Performance_by_Guillaume_Reymond The_best_of_Silvio_Berlusconi Ton_Tauben_schießen_für_echte_Männer Unglaublich_Brettunfall_vom_feinsten Unser_Stoiber Videos_chistosos_moto_yamaha_suzuki_honda_harley_davidsonfunny Voll_assi_toni Vorabend._Eine_Reise_durchs_TV-Programm Vuvunella_the_modern_Urinella Wat´n_dat???_Tutorial-_Urinella_Pibella_-_DIY Windows_did_not_steal_ideas_from_Mac_OS_X!
Some other missing file errors:
180px-Richard_Stallman_2005_(chrys).jpg AdM.png AdW.png Crystal_Clear_app_mp3.png Ebaybuy.gif EbaycommOn.gif Ebayhelp.gif Ebaysell.gif Lauftext_AdM.gif Myebay.gif P_art-lightblue.png P_countries-lightblue.png P_history-lightblue.png P_ps-lightblue.png P_religion-lightblue.png P_social_sciences-lightblue.png P_sport-lightblue.png P_transport-lightblue.png Verwaltung_Zange.jpg