Skip to content

Instantly share code, notes, and snippets.

View Hotfirenet's full-sized avatar

Johan .V Hotfirenet

5 followers · 41 following
View GitHub Profile
@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 / 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 / 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 / genstring.sql
Created April 19, 2017 08:09
Fonction MySQL qui permet de generer une chaine de caractère aléatoirement
/* Find on http://ready2gosoft.com/php/mysql-generate-random-string.html
USE SELECT genstring(ROUND((RAND() * (128-1))+1));
USE SELECT CONCAT(genstring(ROUND((RAND() * (30-5))+5)), '@', genstring(ROUND((RAND() * (30-5))+5)), '.', genstring(ROUND((RAND() * (5-2))+2)));
*/
DROP function if exists genstring;
delimiter $$
CREATE FUNCTION genstring(in_strlen int) RETURNS VARCHAR(500) DETERMINISTIC
BEGIN
@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 / extend_prestashop_smarty.php
Last active April 19, 2017 14:20
<?php
/*
* Sources:
* http://blog.dev-net.fr/ajoutez-vos-propres-fonctions-a-smarty-depuis-un-module-prestashop/
* http://www.smarty.net/forums/viewtopic.php?p=23628#23628
*/
if (!defined('_PS_VERSION_'))
exit;
class extend_prestashop_smarty extends Module
@Hotfirenet
Hotfirenet / docker-rm.sh
Created April 26, 2017 11:30
supprime toutes les images et containers Docker
#!/usr/bin/env bash
docker rm $(docker ps -a -q)
docker rmi $(docker images -q)
@Hotfirenet
Hotfirenet / shortcode_wordpress_list_user_domain.php
Created May 3, 2017 13:08
Shortcode wordpress qui permet de lister les utilisateurs et d'afficher uniquement ceux qui ont un email avec le domaine voulu.
// Use [collaborateurs][/collaborateurs]
add_shortcode( 'collaborateurs', function () {
$search = "/@hotfirenet\.com$/i";
$html = '<div id="collaborateurs" class="items">';
//$users = get_users();
$args = array(
@Hotfirenet
Hotfirenet / prestashop_cookie.php
Created August 14, 2017 14:33
@Hotfirenet
Hotfirenet / renamePhotos.sh
Created September 17, 2017 17:11
Script bash qui permet de renommer une photo au format anneemoisjour_heureminuteseconde via la date de prise de vue
#!/usr/bin/env bash
for f in *.jpg
do
mv -n "$f" "$(exiftool -d "%Y%m%d_%H%M%S" -CreateDate "$f" | awk '{print $4".jpg"}')"
done