lucnap

Professional SP2 VOL	CCMWP-99T99-KCY96-FGKBW-F9WJT

lucnap

How to get a Facebook Page Access Token that doesn't expire Never!

- Go to http://developers.facebook.com/tools/explorer/
- Get a User Access Token with a permission "manage_pages"
- Convert this short-lived access token into a long-lived one by making this Graph API call: 
  https://graph.facebook.com/v2.6/oauth/access_token?client_id=<your FB App ID >&client_secret=<your FB App secret>&grant_type=fb_exchange_token&fb_exchange_token=<your short-lived access token>
- Make a call Graph API:
  https://graph.facebook.com/v2.6/<your personal account FB user id>/accounts?access_token=<your long-lived access token>
- The returned access_token has no expiration unless you change your password or not more admin of the target page or deauthorize FB page

lucnap

def generatefieldmap(cursor):
    """ Given a DB API 2.0 cursor object that has been executed, returns
    a dictionary that maps each field name to a column index; 0 and up. """
    results = {}
    column = 0
    for d in cursor.description:
        results[d[0]] = column
        column = column + 1

lucnap

Install PyInstaller

if using Virtual Env (very likely) compile spcifying the folder of the modules
Example:
pyinstaller main.py --paths venv\Lib\site-packages --onefile

otherwise you will get an error of module not found when moving the executable to another machine
This is very useful when using libraries like MySQLdb for example

lucnap

const fs = require('fs');
const path = require('path');


const walkSync = (dir, filelist = []) => {
	fs.readdirSync(dir).forEach(file => {
  
	  filelist = fs.statSync(path.join(dir, file)).isDirectory()
		? walkSync(path.join(dir, file), filelist)
		: filelist.concat(path.join(dir, file));

lucnap

<?php


	if (!defined('_PS_VERSION_')) {
		exit;
	}
	
	
	
class LunaEnergiaNaz extends Module {

lucnap

SetEnvIF CF-Connecting-IP "10.20.30.40" MySecretIP
<Files index.php>
order allow,deny
allow from env=MySecretIP
</Files>

lucnap

Resizing and Padding image to keep a constant aspect ratio with ImageMagick

This command center any given image in an area of 768x1024 and resize to fit the aspect ratio 768x1024

magick mogrify -resize 768x1024 -background "#fff" -gravity center -extent 768x1024 *Copia.jpg



Example Batch file, ResizeAndPadImage.bat

lucnap

# impostare la password in modo sicuro con il seguente
mysql_config_editor set --login-path=mypath1 --host=localhost --user=username --password


# questo al fine di poter utilizzare mysqldump in modo sicuro con
mysqldump --login-path=mypath1 nomeDelDataBase > /path/dove/metto/i/backup/nomeDelDatabase.sql

lucnap

strNazione = Doc.CustomField(584)
prefisso = ""

Select Case strNazione
    Case "HU", "HUN"
        prefisso = "36"
    Case "UA", "UKR"
        prefisso = "380"
    Case "CH", "CHE"
        prefisso = "41"