andreacoi

# This hosts file is brought to you by Dan Pollock and can be found at
# http://someonewhocares.org/hosts/
# You are free to copy and distribute this file for non-commercial uses,
# as long the original URL and attribution is included.

#<localhost>
127.0.0.1	localhost
127.0.0.1	localhost.localdomain
255.255.255.255	broadcasthost
::1		localhost

andreacoi

# ~/.zshrc file for zsh interactive shells.
# see /usr/share/doc/zsh/examples/zshrc for examples

setopt autocd              # change directory just by typing its name
#setopt correct            # auto correct mistakes
setopt interactivecomments # allow comments in interactive mode
setopt magicequalsubst     # enable filename expansion for arguments of the form ‘anything=expression’
setopt nonomatch           # hide error message if there is no match for the pattern
setopt notify              # report the status of background jobs immediately
setopt numericglobsort     # sort filenames numerically when it makes sense

andreacoi

SELECT
customer.id_customer AS `ID Cliente`,
CONCAT(LEFT(customer.`firstname`, 1), '. ', customer.`lastname`) AS `Cliente`,
address.city AS `Città`,
address.postcode AS `CAP`,
country_lang.name as `Paese`,
pso.`date_add` AS `Data ordine`,
pso.`reference` AS `ID Ordine`,
#cname.name AS `Categoria`,
product_name AS `Prodotto Acquistato`,

andreacoi

SELECT SQL_CALC_FOUND_ROWS 
    CONCAT(LEFT(c.`firstname`, 1), '. ', c.`lastname`) AS `Cliente`, 
    `reference` AS `ID Ordine`,
    `total_paid_tax_incl` AS `Totale Pagato`,
    address.city AS `Città`,
    address.postcode AS `CAP`,
    country_lang.name as `Paese`,
    a.`date_add` AS `Data ordine`,
    osl.`name` AS `Status`
FROM `ps_orders` a 			

andreacoi

<?php
  /******************************************************************************************************************
   * Source: http://www.emvee-solutions.com/blog/create-tar-files-archive-files-server-using-php-script/
   * 
   * Please note that the script wil by default tar all files and (sub)folders from the directory you uploaded the script to
   * into a file named archive.tar. You can overwrite the directory and archive name by calling the script with your own 
   * parameters, like this (replace the italic text for your own needs):
   *
   * http://domain.com/archive.php?targetname=achivename.tar&dir=relative/folder/to/put/in/archive/
   ******************************************************************************************************************/