Archiv der Kategorie: Pastes

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

Deny in iptables based on AS-number

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

WP Title

War:

 

<title><?php bloginfo('name'); ?> - <?php is_front_page() ? bloginfo('description') : wp_title(''); ?></title>

 

Neu: