Discover gists

Migrate Whatsapp chats history from Android to iOS.

Caveats

Media files and shared locations are not imported (got placeholders instead)

Messages from contacts that changed ids (phone numbers) are not linked

	# 1. Put this file to /etc/pf.conf
	# 2. Install init boot scripts using IceFloor then - http://www.hanynet.com/icefloor/
	# I tried to use IceFloor to configure everything but it didn't work very well.
	# 3. Once done, you can confirm the rules were loaded with 'sudo pfctl -sr'
	# 4. At System Preferences -> Security -> Firewall -> Firewall Options,
	# check 'Block all incoming connections' to prevent annoying per-app dialogs.

	set skip on lo0
	set block-policy drop

	<form action="https://login.remita.net/remita/ecomm/finalize.reg" name="SubmitRemitaForm" method="POST">
	<input name="merchantId" value="20842440353" type="hidden">
	<input name="hash" value="83f604ae17ebe70faa1e77a7ac900d36e79a5a8415c0b19fbc8635cdd35f5a124f49748d1c9825718632a90d37eb7ae6e71d3159500fed2a1319151cfcfdccee" type="hidden">
	<input name="rrr" value="280238454675" type="hidden">
	<input name="responseurl" value="https://firsmaritimevat.com/app/response.php" type="hidden">
	<input type="submit" name="submit_btn" value="Pay Via Remita">
	</form>

	export const useFetch = (url, options) => {
	const [response, setResponse] = React.useState(null);
	useEffect(async () => {
	const res = await fetch(url, options);
	const json = await res.json();
	setResponse(json);
	});
	return response;
	}

	// In a Firestore standard example, we quickly create a 'xmas tree' of nested stuff
	// We use Promises directly: get().then(callback) and use snapshot.forEach() to iterate
	let campaignsRef = db.collection('campaigns');
	let activeCampaigns = campaignsRef.where('active', '==', true).select().get()
	.then(snapshot => {
	snapshot.forEach(campaign => {
	console.log(campaign.id);
	let allTasks = campaignsRef.doc(campaign.id).collection('tasks').get().then(
	snapshot => {
	snapshot.forEach(task => {

	LEFT(FROM_UNIXTIME(created/1000),19)

	select SUBSTRING(date from 1 for 7) as `month`, count(credit) as counts, round(sum(credit), 2) as total from __bank where type = 'bank_others' group by SUBSTRING(date from 1 for 7) WITH ROLLUP

	<?php
	echo round(microtime(true) * 1000);