iptables -N AS_DENY; iptables -I INPUT -j AS_DENY; whois -T route -i origin AS57169 | grep '^route:' | awk '{print $2}' | aggregate -q | xargs -n1 -I% iptables -A AS_DENY -s % -j DROP
Archiv der Kategorie: Pastes
wpCasa Button auf Listings hinzufügen
if (function_exists("wpptopdfenh_display_icon")) echo wpptopdfenh_display_icon();
//echo '<div class="title-actions-print"><a href="http://meinlink.com/" class="btn btn-mini"><i class="icon-print"></i> Exposé</a></div>';
Jeden Ordner im aktuellen Verzeichnis so stark wie möglich komprimieren
for D in *; do [ -d "${D}" ] && tar -cf - $D | xz -9 -c - > $D.tar.xz; done
Find doubles in SQL
SELECT Liste.Firma FROM Liste
INNER JOIN (SELECT Firma FROM Liste
GROUP BY Firma HAVING count(id) > 1) dup ON Liste.Firma = dup.Firma
Generate multiple dhparam-files at once
for i in {1..30}; do mkdir $i; openssl dhparam -out $i/dhparam.pem 4096; done
Skalare Unterabfrage
SELECT Name, Vorname, WohnOrt
FROM Kunden
GROUP BY WohnOrt
HAVING Anzahl < (SELECT COUNT(* ) AS AnzahlKunden FROM Kunden GROUP BY WohnOrt ORDER BY AnzahlKunden DESC LIMIT 0,1) ORDER BY Anzahl DESC