Skip to content

Instantly share code, notes, and snippets.

View juananpe's full-sized avatar
🎯
Focusing

Juanan Pereira juananpe

🎯
Focusing
View GitHub Profile
@juananpe
juananpe / wb_admin_export_options.py
Created May 3, 2020 16:03
Patched wb_admin_export_options.py to avoid the "Unknown table 'COLUMN_STATISTICS' in information_schema (1109)" dreaded error
# Copyright (c) 2007, 2018, Oracle and/or its affiliates. All rights reserved.
#
# This program is free software; you can redistribute it and/or modify
# it under the terms of the GNU General Public License, version 2.0,
# as published by the Free Software Foundation.
#
# This program is also distributed with certain software (including
# but not limited to OpenSSL) that is licensed under separate terms, as
# designated in a particular file or component or in included license
# documentation. The authors of MySQL hereby grant you an additional
@juananpe
juananpe / readFile.java
Created March 8, 2023 10:24
read text file from resources folder
public String readFile(String filename) {
String content = "";
try {
// read filename from resources folder
URL fileURL = getClass().getResource(filename);
content = new String ( Files.readAllBytes( Paths.get( fileURL.getFile() ) ) );
}
catch (IOException e) {
e.printStackTrace();
}
@juananpe
juananpe / HackTheBox University CTF 2022
Last active December 7, 2022 21:41
HackTheBox University CTF 2022 WriteUps
Writeup online! HTB University CTF 2022 - Fake News http://exto.lo.gs/htb-university-ctf-2022-fake-news-a213495533
@K1nd4SUS_ctf
https://twitter.com/_eexto/status/1599481956638461952
Walkthrough: HTB University CTF 2022 “The Magic Informer” Challenge http://dlvr.it/SdrL9h #ctf #cybersecurity #ssrf
https://twitter.com/iSecurity/status/1599584233752006656
W0rty / HTP-Univ-Spell-Orsterra
github.com/W0rty/HTB-Univ-Spell-Orsterra
@juananpe
juananpe / easyhacks.txt
Created June 22, 2020 20:50
alternative issue names for easyhacks
beginner
beginner friendly
beginners-only
contribution-starter
difficulty/low
difficulty/newcomer
Easy
easyfix
easyhack
easy hack
@juananpe
juananpe / DBKudeatzaile.java
Last active December 4, 2019 13:54
DBKudeatzaile (SQLite)
package ehu.isad.controller.db;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.io.File;
import java.sql.Connection;
import java.sql.Statement;
@juananpe
juananpe / lastcommitdatebybranch.js
Created October 31, 2019 11:54
show last commit date of each branch
{
search(query: "org:bardsoftware", type: REPOSITORY, last: 100) {
nodes {
... on Repository {
nameWithOwner
refs(first: 100, refPrefix: "refs/heads/") {
nodes {
name
target {
... on Commit {
@juananpe
juananpe / uninstall_vmware.sh
Last active June 21, 2019 10:19
Completely uninstall VMWare on macOS
#!/usr/bin/env bash
# Usage: bash uninstall_vmware.bash
remove() {
entry="$1"
echo -ne "Removing $entry ["
sudo rm -rf "$entry"
if [[ ! -e "$entry" ]]; then
echo -ne "OK"
@juananpe
juananpe / HelloWSS.java
Created October 24, 2017 19:07
Get wss://ws-feed.gdax.com stream
import com.google.gson.JsonArray;
import com.google.gson.JsonObject;
import com.neovisionaries.ws.client.WebSocket;
import com.neovisionaries.ws.client.WebSocketAdapter;
import com.neovisionaries.ws.client.WebSocketFactory;
/**
* Mendekotasunak: (maven bidez instalatu)
* gson-2.8.2
* nv-websocket-client-2.3
@juananpe
juananpe / fifa.csv
Created March 25, 2019 11:03 — forked from yrochat/fifa.csv
We can make this file beautiful and searchable if this error is corrected: Any value after quoted field isn't allowed in line 1.
"journal";"note";"auteur";"url";"annee";"texte"
"gamekult";"70";"puyo";"http://www.gamekult.com/jeux/test-fifa-17-SU3050706473t.html#ps4";"2017";"Si vous avez un tant soit peu suivi l'actualité de FIFA 17 depuis son annonce, vous savez déjà qu'il ne s'agit pas d'un FIFA +1 comme il en paraît chaque année. Pour ce millésime 2016, la simu d'EA Sports fait peau neuve en se dotant d'un nouveau moteur, le Frostbite cher à Battlefield, histoire de se mettre à niveau tout en bénéficiant des améliorations régulières apportées par les ingénieurs maison. Forcément, qui dit nouveau moteur sous-entend une liste considérable de changements et de petits ajustements, pour ne pas dire de concessions ; Konami avait d'ailleurs essuyé les plâtres il y a quelques années en osant le pari du Fox Engine, qui a longtemps tâtonné avant de parvenir à un compromis satisfaisant en 2016. FIFA 17 saura-t-il trouver la bonne formule dès le coup d'envoi ? \n Si l'on se place du point de vue dév, FIFA 17 tient du petit exploit. Même si le pr
@juananpe
juananpe / fifa.R
Created March 25, 2019 11:02 — forked from yrochat/fifa.R
The code for article #20 on my blog (about FIFA)
rm(list=ls())
library(readr) # importation
library(RTextTools) # classification de textes
library(textreuse) # plagiat
library(tm) # text mining
library(ggplot2) # visualisations
library(lsa) # latent semantic analysis
library(stringr) # manipulation de chaines de caractères