Skip to content

Instantly share code, notes, and snippets.

View Skoatpalace's full-sized avatar

Richard Fages Skoatpalace

7 followers · 20 following
View GitHub Profile
@Skoatpalace
Skoatpalace / csrf.txt
Created March 4, 2020 08:43
Quête Attaques CSRF
https://google-gruyere.appspot.com/446189207851996622915780513020583367416/deletesnippet?index=0
@Skoatpalace
Skoatpalace / convert_Col_Letter.gs
Created December 9, 2019 14:26
Apps script convert column to letter & letter to column
function letterToColumn(letter){
letter = letter.toUpperCase();
var column = 0, length = letter.length;
for (var i = 0; i < length; i++)
{
column += (letter.charCodeAt(i) - 64) * Math.pow(26, length - i - 1);
}
return column;
}
@Skoatpalace
Skoatpalace / snowslide.gs
Created June 14, 2019 07:50
Snow on Google Slides
function onOpen() {
var ui = SlidesApp.getUi();
// Or DocumentApp or FormApp.
ui.createMenu('Make it Snow')
.addItem('Add Flakes', 'drawFlakes')
.addItem('Clear Flakes', 'clearFlakes')
.addToUi();
}
function drawFlakes(){
@Skoatpalace
Skoatpalace / mon_historique.log
Created March 27, 2019 20:46
mon_historique.log
1 ls
2 cat instructions
3 cat hint1
4 cd mystery/
5 ls
6 head -n 20 people
7 grep "CLUE" crimescene
8 grep "Annabel" people
9 head -n 173 streets/Mattapan_Street | tail -n 1
10 head -n 40 streets/Hart_place | tail -n 1
@Skoatpalace
Skoatpalace / best-film.js
Created February 18, 2019 08:14
odyssey quest js
const titleFilm = 'Le cinquième élément';
const yearFilm = '1997';
const authorFilm = 'Luc Besson';
const message = titleFilm + ', réalisé par ' + authorFilm + ', est sorti en ' + yearFilm;
// Display a popup
alert(message);
@Skoatpalace
Skoatpalace / base.json
Created January 17, 2019 16:36
{
"_ANCHORS": [
{
"boot_command": [
"<esc><esc><enter><wait>",
"install initrd=/install/initrd.gz ",
"auto=true ",
"url=http://{{.HTTPIP}}:{{.HTTPPort}}/{{user `preseed_file`}} ",
"language={{user `language`}} ",
"country={{user `country`}} ",
@Skoatpalace
Skoatpalace / lycee.html
Created January 14, 2019 13:41
<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="utf-8" />
<link rel="apple-touch-icon" sizes="76x76" href="/img/logo-cr-cvl.png">
<link rel="icon" type="image/png" href="/img/logo-cr-cvl.png">
<meta http-equiv="X-UA-Compatible" content="IE=edge,chrome=1" />
<title>Equipe Régionale d'Exploitation Energétique des Lycées</title>
@Skoatpalace
Skoatpalace / richard_f_wcs_toulouse.sql
Created December 11, 2018 14:14
quête sql 3
-- MySQL dump 10.13 Distrib 5.7.24, for Linux (x86_64)
--
-- Host: localhost Database: richard_f_wcs_toulouse
-- ------------------------------------------------------
-- Server version 5.7.24-0ubuntu0.18.04.1
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;
@Skoatpalace
Skoatpalace / supprimer_info.sql
Created November 27, 2018 08:27
SQL 4 - Supprimer des informations
DELETE FROM movie WHERE id = '5';
DELETE FROM movie WHERE id > '10';
@Skoatpalace
Skoatpalace / Inserer_des_informations.sql
Last active November 5, 2018 15:11
requete_sql.sql
INSERT INTO movie VALUES (null, 'blablacar et tinder', 'http://ekfhdjd.fdgfs', 'dsfsdgbshfdg fdjsf fsdqf');
INSERT INTO movie (name, poster, comment) VALUES ('blop en route', 'http://sfdfsdgsgsgf.sqd', 'dsgsf qseZkkl fdgff');
INSERT INTO movie (name, poster, comment) VALUES ('blop en voyage', 'http://sfdfsdgsgsgf.sqd', 'dsgsf qseZkkl fdgff'), ('blop au cimetiere', 'http://sfdfsdgsgsgf.sqd', 'dsgsf qseZkkl fdgff'), ('blop au supermarché', 'http://sfdfsdgsgsgf.sqd', 'dsgsf qseZkkl fdgff');
INSERT INTO movie (name) VALUES ('Salut les blops'); ( En parametrant une valeur par defaut aux autres colonnes à null)