Skip to content

Instantly share code, notes, and snippets.

View iakat's full-sized avatar
📸

Katia Esposito iakat

📸
  • Réseaux IP Européens Network Coordination Centre
  • 20:35 (UTC +02:00)
View GitHub Profile
@heathcliff
heathcliff / getHashParam.js
Last active September 16, 2023 14:54
getHashParam(), updateHashParam(), getParam()
function getHashParam(name) {
var regex = new RegExp("(#)("+name+")(\=)([^#]*)"),
matches = [];
matches = regex.exec(window.location.hash);
if (matches !== null && matches.length > 4 && matches[4] !== null) {
return matches[4];
} else {
return false;
}
}
@paracycle
paracycle / convert.sql
Created July 29, 2013 19:50
Convert and merge WhatsApp databases from iPhone format to Android
-- Clear tables
DROP TABLE chat_list;
DROP TABLE messages;
-- Create new tables
CREATE TABLE chat_list (_id INTEGER PRIMARY KEY AUTOINCREMENT, key_remote_jid TEXT UNIQUE, message_table_id INTEGER);
CREATE TABLE messages (_id INTEGER PRIMARY KEY AUTOINCREMENT, key_remote_jid TEXT NOT NULL, key_from_me INTEGER, key_id TEXT NOT NULL, status INTEGER, needs_push INTEGER, data TEXT, timestamp INTEGER, media_url TEXT, media_mime_type TEXT, media_wa_type TEXT, media_size INTEGER, media_name TEXT, latitude REAL, longitude REAL, thumb_image TEXT, remote_resource TEXT, received_timestamp INTEGER, send_timestamp INTEGER, receipt_server_timestamp INTEGER, receipt_device_timestamp INTEGER, raw_data BLOB, media_hash TEXT, recipient_count INTEGER, media_duration INTEGER, origin INTEGER);
-- Attach Android and iPhone databases
ATTACH 'msgstore.db' AS android;
@pyKun
pyKun / centos.ustack
Last active February 10, 2022 18:53
Worked kickstart file for a standard centos
# centos_minimal_livecd.ks
# Created by AndrewSerk
part / --size 8192 --fstype ext4
lang en_US.UTF-8
keyboard us
timezone US/Eastern
auth --useshadow --enablemd5
selinux --disabled
firewall --disabled