Skip to content

Instantly share code, notes, and snippets.

View renshuki's full-sized avatar
💭
🇫🇷 🇯🇵 🇺🇸

Francois-Clement Brossard renshuki

💭
🇫🇷 🇯🇵 🇺🇸
View GitHub Profile
@renshuki
renshuki / ubuntu_agnoster_install.md
Last active April 23, 2024 13:04
Ubuntu 16.04 + Terminator + Oh My ZSH with Agnoster Theme

Install Terminator (shell)

sudo add-apt-repository ppa:gnome-terminator
sudo apt-get update
sudo apt-get install terminator

Terminator should be setup as default now. Restart your terminal (shortcut: "Ctrl+Alt+T").

Install ZSH

@renshuki
renshuki / decipher_base64.md
Last active June 19, 2016 10:31
Decipher a base64 like message

Introduction

Below a ciphered message (source):

QlpoOTFBWSZTWW8hhvwAAD7aAG0wAAsABQAKIAB1CVT8UEeRBJpRDRoaJoYJ2hHaMottLYUShiAD7GMfiBkCDGKMIrRvW41TxV5lWawgMpr4yNM4jiTfAZrPiH4u5IpwoSDeQw34

Deciphering

Step 1

No special characters so Ascii85 can be excluded.

@renshuki
renshuki / vhost.py
Created August 31, 2016 02:02 — forked from fideloper/vhost.py
Create vHost Ubuntu Lamp-Server (bash and python)
#! /usr/bin/python
from sys import argv
from os.path import exists
from os import makedirs
from os import symlink
from os import system
import getopt
#
@renshuki
renshuki / zsh.md
Created October 7, 2016 16:36 — forked from tsabat/zsh.md
Getting oh-my-zsh to work in Ubuntu

Keybase proof

I hereby claim:

  • I am renshuki on github.
  • I am renshuki (https://keybase.io/renshuki) on keybase.
  • I have a public key whose fingerprint is 5E9D 54A3 38BC 3392 2036 1CB1 F85D 8FDC 28FC C710

To claim this, I am signing this object:

@renshuki
renshuki / wordpress_tag_search.md
Last active November 1, 2021 18:42
Wordpress SQL query to find posts having both tags

Please replace TAG ID 1 and TAG ID 2 by the tags you are looking for.

SELECT p.id
FROM wp_posts AS p
JOIN wp_term_relationships AS tr ON p.id = tr.object_id
JOIN wp_term_taxonomy AS tt ON tr.term_taxonomy_id = tt.term_taxonomy_id
JOIN wp_terms AS t ON tt.term_id = t.term_id
WHERE t.term_id=_TAG ID 1_ OR t.term_id=_TAG ID 2_ AND p.post_type LIKE 'post'
GROUP BY p.id
@renshuki
renshuki / middlewares.py
Created June 13, 2017 04:59 — forked from seagatesoft/middlewares.py
An example of RotateUserAgentMiddleware
from random import choice
from scrapy import signals
from scrapy.exceptions import NotConfigured
class RotateUserAgentMiddleware(object):
"""Rotate user-agent for each request."""
def __init__(self, user_agents):
self.enabled = False
self.user_agents = user_agents
@renshuki
renshuki / wordpress_gitignore.md
Last active June 20, 2017 15:22
Default Wordpress .gitignore file for git repositories
# Keep these files out of the repo
/wp-content/themes/twenty*
/wp-content/upgrade
/wp-content/uploads
/sitemap.*
/wp-config.php
*.sql

# Hidden files
@renshuki
renshuki / alt-checker.js
Created June 20, 2017 16:09
This bookmarklet reveal all the alt attributes of the <img /> tags (current page only)
javascript: (function() {
function getTag(tag) {
return document.getElementsByTagName(tag);
}
function a(o, a) {
return o.getAttribute(a);
}
var images = getTag('img');
@renshuki
renshuki / mysql_database_create_time.sql
Last active March 18, 2019 13:21
Find the time of creation of a MySQL database
SELECT create_time
FROM INFORMATION_SCHEMA.TABLES WHERE table_schema = 'db_name';