lucnap

Fix for CURL & SQLite3 under Windows on PHP 7.4

If you have just downloaded and configured PHP 7.4 and you want to use CURL and SQLite3 you could run into a serious PHP-generated error for the reason that both CURL and SQlite3 make use of an external library located in the PHP directory. First SQLite3 was integrated into PHP but from version 7.4 no longer. The errors are these:

PHP Warning: PHP Startup: Unable to load dynamic library 'pdo_sqlite'

PHP Warning: PHP Startup: Unable to load dynamic library 'sqlite3'

PHP Warning: PHP Startup: Unable to load dynamic library 'php_curl'

lucnap

This was a response to a Hacker News comment asking me what I've been up to since 2010. I'm posting it here since HN rejects it with "that comment is too long." I suppose that's fair, since this ended up being something of an autobiography.

--

What happened after 2010?

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"