Skip to content

Instantly share code, notes, and snippets.

View Hotfirenet's full-sized avatar

Johan .V Hotfirenet

5 followers · 43 following
View GitHub Profile
@Hotfirenet
Hotfirenet / anonymisePrestashop.sql
Last active April 19, 2017 08:10
permet d'anonymiser prestashop pour faire un labo
/* NEED https://gist.github.com/Hotfirenet/6059aa528800c1bb944fa5b7d8fcbf42 */
TRUNCATE TABLE ps_connections;
TRUNCATE TABLE ps_connections_page;
TRUNCATE TABLE ps_connections_source;
TRUNCATE TABLE ps_customer_ip;
TRUNCATE TABLE ps_customer_message;
TRUNCATE TABLE ps_customer_thread;
TRUNCATE TABLE ps_mail;
TRUNCATE TABLE ps_message;
@Hotfirenet
Hotfirenet / listReferenceWithAvailableNowMessage.sql
Last active April 12, 2017 12:10
Liste les références actives d'un catalogue prestashop qui ont un message disponible maintenance
SELECT reference FROM ps_product P
INNER JOIN ps_product_lang PL ON PL.id_product = P.id_product
WHERE P.active = 1 AND (PL.available_now IS NOT NULL AND PL.available_now <> '')
GROUP BY reference
@Hotfirenet
Hotfirenet / rename_file_macOS.applescript
Last active April 7, 2017 07:24
Permet de renommer tous les fichiers d'un repertoire
tell application "Finder"
set chemin to choose folder with prompt "Sélectionnez le dossier contenant les fichiers à renommer"
my inspecter(chemin) --appel routine avec transmission des variables
end tell
on inspecter(un_dossier)
-- récupération du nom du dossier
set ledossier to un_dossier as string
set ledossier to text 1 thru -2 of ledossier
set AppleScript's text item delimiters to {":"}
@Hotfirenet
Hotfirenet / remove_yoast_metabox_cpt.php
Created March 28, 2017 12:42
suppression de la metabox yoast seao sur un custom post type sur wordpress, remove yoast metabox for one custom post type on wordpress
#suppression de la metabox yoast seao sur un custom post type
add_action( 'add_meta_boxes', function() {
remove_meta_box('wpseo_meta', 'mycustomposttype', 'normal');
},11 );
@Hotfirenet
Hotfirenet / suppDS_Store.sh
Created March 21, 2017 09:01
Commande qui permet de supprimer tous les fichiers DS_Store
find /home/foo \( -name '.DS_Store' -or -name '._.DS_Store' -or -name '._*' -or -name '.TemporaryItems' -or -name '.apdisk' \) -exec rm -rf {} \;
@Hotfirenet
Hotfirenet / find_illegalCharInFilesName.sh
Created March 21, 2017 08:41
Manipulation de fichier en shell
#trouver les fichiers linux, mac qui n'ont pas les caractères autorisé par Windows
find . -name '*[<>:/\\|?*]*' -o -name '*[ \.]'
#fonction de renommage en masse des fichiers linux, mac qui n'ont pas les caractères autorisé par Windows
#rename.sh
#!/usr/bin/env bash
find "$1" -depth -print0 | while IFS= read -r -d '' file; do
d="$( dirname "$file" )"
f="$( basename "$file" )"
@Hotfirenet
Hotfirenet / erasedFirewall.sh
Created March 11, 2017 14:00
Suppression des règles de firewall
#!/usr/bin/env bash
iptables -F
iptables -X
iptables -t nat -F
iptables -t nat -X
iptables -t mangle -F
iptables -t mangle -X
iptables -P INPUT ACCEPT
iptables -P FORWARD ACCEPT
@Hotfirenet
Hotfirenet / hotlink_protect_nginx.conf
Created March 2, 2017 07:43
@Hotfirenet
Hotfirenet / recap_article_wordpress_shortcode.php
Last active February 23, 2017 07:50
Shortcode pour wordpress qui permet de lister les articles et / ou les custom post type publiés entre 2 dates.
<?php
//By: Hotfirenet
//Description Shortcode: List post, cpt, published between 2 dates
//Use: [recap_article type="post,guide" datedebut="2016-01-31" datefin="2016-02-28" limit=5]
//For: domadoo blog
add_shortcode( 'recap_article', function( $atts ) {
extract( shortcode_atts( array(
'type' => 'post',
@Hotfirenet
Hotfirenet / ufw-firewall.sh
Created February 20, 2017 14:30
#!/usr/bin/env bash
#Automation script By Hotfirenet to install ufw (firewall)
#NEED ROOT
#Use curl -sSL https://gist.githubusercontent.com/Hotfirenet/acd59a8c31de631220afe42cb4025a19/raw/05698e1a230783a9894b2df330296f91e9240d67/ufw-firewall.sh | bash
#installation
apt-get update
apt-get -y install ufw