Skip to content

Instantly share code, notes, and snippets.

@pvillamil
pvillamil / Visual Studio 2015
Created July 31, 2024 22:11 — forked from NehemiahLimo/Visual Studio 2015
Product keys for Visual Studio 2015
Visual Studio Professional 2015
Key : HMGNV-WCYXV-X7G9W-YCX63-B98R2
Visual Studio Enterprise 2015
Key :HM6NR-QXX7C-DFW2Y-8B82K-WTYJV
Visual Studio Enterprise 2015
@pvillamil
pvillamil / postgres_queries_and_commands.sql
Created July 22, 2024 23:19 — forked from rgreenjr/postgres_queries_and_commands.sql
Useful PostgreSQL Queries and Commands
-- show running queries (pre 9.2)
SELECT procpid, age(clock_timestamp(), query_start), usename, current_query
FROM pg_stat_activity
WHERE current_query != '<IDLE>' AND current_query NOT ILIKE '%pg_stat_activity%'
ORDER BY query_start desc;
-- show running queries (9.2)
SELECT pid, age(clock_timestamp(), query_start), usename, query
FROM pg_stat_activity
WHERE query != '<IDLE>' AND query NOT ILIKE '%pg_stat_activity%'
@pvillamil
pvillamil / encoded-20201212150102.txt
Created June 28, 2024 19:48 — forked from thegreatestminer/encoded-20201212150102.txt
MobaXTerm Professional x64 License Key [READ COMMENTS]
UEsDBBQAAAAIABNQjFGCf/GfLgAAACwAAAAHAAAAUHJvLmtleTMqdncpCXQOKDAp9woMzEo1MTVOrHAzTjTLME7VNs1LK8owTjQpcU8tcuLlAgBQSwECFAAUAAAACAATUIxRgn/xny4AAAAsAAAABwAAAAAAAAAAAAAAAAAAAAAAUHJvLmtleVBLBQYAAAAAAQABADUAAABTAAAAAAA=
@pvillamil
pvillamil / encoded-20201212150102.txt
Created June 28, 2024 19:48 — forked from thegreatestminer/encoded-20201212150102.txt
MobaXTerm Professional x64 License Key [READ COMMENTS]
UEsDBBQAAAAIABNQjFGCf/GfLgAAACwAAAAHAAAAUHJvLmtleTMqdncpCXQOKDAp9woMzEo1MTVOrHAzTjTLME7VNs1LK8owTjQpcU8tcuLlAgBQSwECFAAUAAAACAATUIxRgn/xny4AAAAsAAAABwAAAAAAAAAAAAAAAAAAAAAAUHJvLmtleVBLBQYAAAAAAQABADUAAABTAAAAAAA=
@pvillamil
pvillamil / grepcloud.sh
Created April 19, 2024 15:47 — forked from dafthack/grepcloud.sh
Quick script to check a list of IP addresses against Azure, AWS, and GCP netblock ranges.
#! /bin/bash
## You need to install grepcidr and jq first
## sudo apt-get install grepcidr jq
##
## AWS and GCP ranges will be created automatically
##
## Because of the way Microsoft hosts the ranges go manually download the public range
## from here: https://www.microsoft.com/en-us/download/details.aspx?id=56519
##
@pvillamil
pvillamil / gapless_sequence.sql
Created August 23, 2023 03:09 — forked from fabriziomello/gapless_sequence.sql
Gapless sequence example in PostgreSQL
CREATE TABLE public.gapless_sequence (
sequence_schema TEXT,
sequence_name TEXT,
last_value BIGINT DEFAULT 0,
step INTEGER DEFAULT 1
);
ALTER TABLE public.gapless_sequence
ADD CONSTRAINT gapless_sequence_pk PRIMARY KEY (sequence_schema, sequence_name);
@pvillamil
pvillamil / nginx.conf
Created August 8, 2023 06:13 — forked from plentz/nginx.conf
Best nginx configuration for improved security(and performance)
# to generate your dhparam.pem file, run in the terminal
openssl dhparam -out /etc/nginx/ssl/dhparam.pem 2048
@pvillamil
pvillamil / WpBroken.py
Created April 6, 2023 01:01 — forked from ilovefreesw/WpBroken.py
A script to check links in all the WordPress posts to find out broken ones. Saves the report in CSV file. Based on WordPress API and only needs domain as input.
import requests
import csv
import concurrent.futures
import sys, time
import bs4
domain = sys.argv[1]
csv_file = sys.argv[2]
headers = {
/*
* Credits go to https://stackoverflow.com/a/20371801/8504344, https://stackoverflow.com/users/179024/mw
*/
$(document).ready(function () {
// Add refresh button after field (this can be done in the template as well)
$('img.captcha').after(
$('<a href="#void" class="captcha-refresh"><i class="fa fa-refresh"></i></a>')
);
// Click-handler for the refresh-link