Skip to content

Instantly share code, notes, and snippets.

@rchrd2
rchrd2 / test-php-basic-auth.php
Last active February 1, 2024 21:18 — forked from westonruter/test-php-basic-auth.php
PHP basic auth example
<?php
function require_auth() {
$AUTH_USER = 'admin';
$AUTH_PASS = 'admin';
header('Cache-Control: no-cache, must-revalidate, max-age=0');
$has_supplied_credentials = !(empty($_SERVER['PHP_AUTH_USER']) && empty($_SERVER['PHP_AUTH_PW']));
$is_not_authenticated = (
!$has_supplied_credentials ||
$_SERVER['PHP_AUTH_USER'] != $AUTH_USER ||
$_SERVER['PHP_AUTH_PW'] != $AUTH_PASS
@Ndrou
Ndrou / clean-db.sql
Created March 8, 2017 10:03
Clean prestashop 1.6 database
DELETE FROM ps_accessory WHERE id_product_1 NOT IN (select p.id_product from ps_product p);
DELETE FROM ps_accessory WHERE id_product_2 NOT IN (select p.id_product from ps_product p);
DELETE FROM ps_address WHERE id_customer NOT IN (select c.id_customer from ps_customer c);
DELETE FROM ps_product_comment WHERE id_product NOT IN (select p.id_product from ps_product p);
DELETE FROM ps_product_comment_grade WHERE id_product_comment NOT IN (select pc.id_product_comment from ps_product_comment pc);
DELETE FROM ps_product_comment_usefulness WHERE id_product_comment NOT IN (select pc.id_product_comment from ps_product_comment pc);
DELETE FROM ps_product_lang WHERE id_product NOT IN (select p.id_product from ps_product p);
@amit-chahar
amit-chahar / download-script.sh
Last active February 20, 2023 12:57
Scirpt to download files from Google drive using curl (Detailed explanation can be read here: https://stackoverflow.com/a/49444877/4043524)
#!/bin/bash
fileid="FILEIDENTIFIER"
filename="FILENAME"
curl -c ./cookie -s -L "https://drive.google.com/uc?export=download&id=${fileid}" > /dev/null
curl -Lb ./cookie "https://drive.google.com/uc?export=download&confirm=`awk '/download/ {print $NF}' ./cookie`&id=${fileid}" -o ${filename}
@xPaw
xPaw / localhost_cert.sh
Last active January 1, 2022 20:23
Localhost certificate
#!/bin/bash
openssl ecparam -name prime256v1 -genkey -out localhost.key
openssl req -new -x509 -days 7300 -out localhost.crt -key localhost.key \
-subj '/CN=localhost' -extensions EXT -config <( \
printf "[dn]\nCN=localhost\n[req]\ndistinguished_name = dn\n[EXT]\nsubjectAltName=DNS:localhost, DNS:*.localhost, IP:127.0.0.1, IP:::1\nkeyUsage=digitalSignature\nextendedKeyUsage=serverAuth")
openssl dhparam -out dhparam.pem 4096