྅༻ Ǭɀħ ༄༆ཉ ozh

🐳 Docker Crash Course (Linux)

🧠 Concepts de base

Docker repose sur 4 briques :

Images → templates (nginx, php, etc.)
Containers → instances exécutées

npp - Notepad++ wrapper for Git Bash

Open files in Notepad++ from Git Bash, handling both Unix and Windows paths.

Usage

npp                        # Launch Notepad++
npp /e/path/to/file.php    # Open file (Unix path)
npp anything\weird # Suspicious path → reads clipboard instead

=== YOURLS SQL Queries Benchmark ===
Date: 2026-02-19 22:25:26
Cache plugin: DISABLED
Iterations per query: 10
========================================

--- OPTIONS TABLE QUERIES ---
SELECT all options (WHERE 1=1)                               | Avg:   1.06ms | Min:   0.94ms | Max:   1.71ms
SELECT single option (LIMIT 1)                               | Avg:   0.97ms | Min:   0.86ms | Max:   1.15ms

./admin/index.php:304:$url_results = yourls_get_db('read-admin_index')->fetchObjects( "SELECT * FROM `$table_url` WHERE 1=1 {$where['sql']} ORDER BY `$sort_by` $sort_order LIMIT $offset, $perpage;", $where['binds'] );
./includes/Database/Options.php:46:$sql = "SELECT option_name, option_value FROM $table WHERE 1=1";
./includes/Database/Options.php:105:$sql = "SELECT option_value FROM $table WHERE option_name = :option_name LIMIT 1";
./includes/Database/Options.php:164:$sql  = "UPDATE $table SET option_value = :value WHERE option_name = :name";
./includes/Database/Options.php:209:$sql  = "INSERT INTO $table (option_name, option_value) VALUES (:name, :value)";
./includes/Database/Options.php:240:$sql = "DELETE FROM $table WHERE option_name = :name";
./includes/functions-shorturls.php:259:$delete = $ydb->fetchAffected("DELETE FROM `$table` WHERE `keyword` = :keyword", array('keyword' => $keyword));
./includes/functions-shorturls.php:289:$insert = $ydb->fetchAffected("INSERT INTO `$table` (`keyword`, `url`

userChrome vs. userContent :

userContent : modify web pages and internal pages like about:newtab and about:home
userChrome : modify Firefox user interface

In about:config turn toolkit.legacyUserProfileCustomizations.stylesheets to true
Open folder %APPDATA%\Mozilla\Firefox\Profiles\, find one or more folders and go to the folder that has a lot of other folders.

$maintenance_start;
$ydb;
$yourls_actions;
$yourls_allowedentitynames;
$yourls_allowedprotocols;
$yourls_filters;
$yourls_l10n;
$yourls_locale;
$yourls_locale_formats;

Master/Slave DB Setup

POC plugin: shows how a YOURLS instance using a Master/Slave DB setup would work.

Requirements:

a Master (write) / Slave (read) DB setup, obviously.
YOURLS 1.10.3 and above

Installation

Factory reset : plug the device, not the RJ45, push pin into reset hole for 5 secs. LED goes flashing green - once solid red, device is ready to configure. Unplug/plug back.
With phone : connect to Wifi broadcasted by the device (TP_Link_Extender_something)
Open http://tplinkrepeater.net/ (be sure to deactivate your custom DNS on phone)
Connect : admin/admin
Create new admin user
Change mode : "mode" icon in the top right - chose AP, apply. The LED goes flashing. Plug RJ45.
Open http://<ip of device>, connect -- NOT HTTPS !
Network : disable DHCP
Wifi, Wifi Param : copy SSID & password of your wifi network
Wifi, WPS : deactivate

Export all databases except #mysql50#mysql-8.4, information_schema, mysql, performance_schema and phpmyadmin :

 for DB in $(mysql -u root -e "SHOW DATABASES;" | grep -Ev "mysql|phpmy|schema|Database"); do echo "DB : $DB"; mysqldump -u root --skip-lock-tables --databases $DB > db_${DB}.sql; done

	<?php

	$dir = __DIR__; // change this to your target directory

	$items = scandir($dir);

	$dirs = [];
	$files = [];

	foreach ($items as $item) {