Forum:Reorganization of the whole Uncycs/de/Videos

From Uncyclomedia, the UnMeta-wiki
Jump to: navigation, search

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');

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');

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