Johan .V Hotfirenet

## list_order_by_carriers.sql
SELECT A.reference, B.lastname, A.total_paid_tax_incl, A.date_add, C.name,D.*
FROM ps_orders A
	INNER  JOIN ps_customer B ON B.id_customer = A.id_customer
	INNER  JOIN ps_carrier C ON C.id_carrier = A.id_carrier
	LEFT OUTER JOIN ps_socolissimo_delivery_info D ON D.id_cart = A.id_cart
WHERE A.date_add BETWEEN '2017-06-01' AND '2017-09-31'
#	AND C.name IN ('Colissimo Suivi International','Colissimo Suivi Europe')
#	AND A.total_paid_tax_incl <= 50
#	AND C.name <> 'Colissimo Suivi International'
#	AND D.cecountry NOT IN ('AT', 'BE')

## .htaccess_hotlink

RewriteEngine on

#Regle a rajouter pas loin de RewriteEngine on
RewriteCond "%{HTTP_REFERER}" "site_a_bloquer.com" [NC]
RewriteRule \.(gif|GIF|jpg|JPG|bmp|BMP|jpeg|JPEG|png|PNG)$ http://hotfirenfw.cluster014.ovh.net/Je-suis-un-gros-encule.gif [L,R]

## default_hotlink.conf
# /etc/nginx/conf.d/default.conf
# NEED https://gist.github.com/Hotfirenet/0d5fc63204ecf8f0022294c0825ab408

server {
        listen 80 default_server;
        listen [::]:80 default_server ipv6only=on;

        ...

        if ($bad_referer) {

## blacklist.conf
map $http_referer $bad_referer {
    hostnames;

    default                           0;

    # Put regexes for undesired referers here
    "~site_a_bloquer.com"             1;
}

## prestashop_order_day_by_day.sql
SELECT COUNT(id_order) AS nbOrder
	 , SUM(total_paid_tax_incl) AS 'CA_TTC'
	 , DATE(date_add) AS 'Date'
	 , payment
FROM ps_orders
WHERE YEAR(date_add) = 2017
GROUP BY DATE(date_add), payment

## renamePhotos.sh
#!/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

## prestashop_cookie.php
<?php

//Pour créer ou modifier une nouvelle variable dans le cookie:
$this->context->cookie->__set('nom_variable' , 'valeur');

//Pour supprimer une variable du cookie Prestashop :
$this->context->cookie->__unset('nom_variable');

//Pour accéder à une valeur du cookie :
$this->context->cookie->nom_variable;

## shortcode_wordpress_list_user_domain.php
// Use [collaborateurs][/collaborateurs]
add_shortcode( 'collaborateurs', function () {

	$search = "/@hotfirenet\.com$/i";

	$html = '<div id="collaborateurs" class="items">';

	//$users = get_users();

	$args = array(

## docker-rm.sh
#!/usr/bin/env bash

docker rm $(docker ps -a -q)
docker rmi $(docker images -q)

## extend_prestashop_smarty.php
<?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
	SELECT A.reference, B.lastname, A.total_paid_tax_incl, A.date_add, C.name,D.*
	FROM ps_orders A
	INNER JOIN ps_customer B ON B.id_customer = A.id_customer
	INNER JOIN ps_carrier C ON C.id_carrier = A.id_carrier
	LEFT OUTER JOIN ps_socolissimo_delivery_info D ON D.id_cart = A.id_cart
	WHERE A.date_add BETWEEN '2017-06-01' AND '2017-09-31'
	# AND C.name IN ('Colissimo Suivi International','Colissimo Suivi Europe')
	# AND A.total_paid_tax_incl <= 50
	# AND C.name <> 'Colissimo Suivi International'
	# AND D.cecountry NOT IN ('AT', 'BE')

	RewriteEngine on

	#Regle a rajouter pas loin de RewriteEngine on
	RewriteCond "%{HTTP_REFERER}" "site_a_bloquer.com" [NC]
	RewriteRule \.(gif\|GIF\|jpg\|JPG\|bmp\|BMP\|jpeg\|JPEG\|png\|PNG)$ http://hotfirenfw.cluster014.ovh.net/Je-suis-un-gros-encule.gif [L,R]
	# /etc/nginx/conf.d/default.conf
	# NEED https://gist.github.com/Hotfirenet/0d5fc63204ecf8f0022294c0825ab408

	server {
	listen 80 default_server;
	listen [::]:80 default_server ipv6only=on;

	...

	if ($bad_referer) {
	map $http_referer $bad_referer {
	hostnames;

	default 0;

	# Put regexes for undesired referers here
	"~site_a_bloquer.com" 1;
	}
	SELECT COUNT(id_order) AS nbOrder
	, SUM(total_paid_tax_incl) AS 'CA_TTC'
	, DATE(date_add) AS 'Date'
	, payment
	FROM ps_orders
	WHERE YEAR(date_add) = 2017
	GROUP BY DATE(date_add), payment
	#!/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
	<?php

	//Pour créer ou modifier une nouvelle variable dans le cookie:
	$this->context->cookie->__set('nom_variable' , 'valeur');

	//Pour supprimer une variable du cookie Prestashop :
	$this->context->cookie->__unset('nom_variable');

	//Pour accéder à une valeur du cookie :
	$this->context->cookie->nom_variable;
	// Use [collaborateurs][/collaborateurs]
	add_shortcode( 'collaborateurs', function () {

	$search = "/@hotfirenet\.com$/i";

	$html = '<div id="collaborateurs" class="items">';

	//$users = get_users();

	$args = array(
	#!/usr/bin/env bash

	docker rm $(docker ps -a -q)
	docker rmi $(docker images -q)
	<?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