Stuffs Posts

Scan WhatsApp Web’s QR Code while Having a Bad Rear Camera

This thing just happen to me like 5minutes ago, suddenly my WhatsApp web is logged off and i need to do a device link by using a QR code generated by WhatsApp web on my mobile phone.

But heres the problem, my phone have a very bad rear camera. It’s unable to stay focus on the QR code thus making me unable to login.

Workaround is quite simple, i just need to zoomout on my browser (press ctrl and “-” sign) and put my mobile phone camera close to the monitor until finally my WhatsApp mobile able to read the QR code perfectly.

Weird, but somehow it works lol.

Download A Compressed Attachment (Zip, Rar or 7Z) on GMail

I want to download a compressed file that i’ve sent several years ago, but somehow google disabled it, and gives an “anti virus warning”. And it happen for all my email with compressed attachments files, such as .zip, .rar and also .7z.

compressed download

Well, the workaround is quite simple, im opening my email using my Android GMail client , and then save my attachment to Google Drive.


From Google Drive, i can easily download my attachment freely.
google drive

Hopefully it can help other people. 😀

How to Extract SRT (Subtitle File) From MKV Movie File on Windows

Ive just download a very good, and a highly recommended anime, Digimon Adventure Tri. It can play well on my laptop, but when i put it on my TV, somehow the subtitle is gone. I notice that it happen because the srt got burn inside the video file.

After browsing for a while, i found out that i can extract my srt using MKVToolNix tools. I downloaded it, and using one of its tools, mkvextract.exe, i can extract the subtitles i wanted from my mkv files.

But first, make sure you use mkvinfo.exe to check your mkv information.

C:\Program Files\MKVToolNix>mkvinfo.exe 
        "C:\Users\edw\Downloads\[HorribleSubs] Digimon Adventure tri - 01 [1080p].mkv"

And find track id for subtitles.

| + A track
|  + Track number: 3 (track ID for mkvmerge & mkvextract: 2)
|  + Track UID: 3
|  + Track type: subtitles
|  + Lacing flag: 0
|  + Codec ID: S_TEXT/ASS
|  + CodecPrivate, length 1934

In this scenario, my subtitle track id is 2 and subtitle format is .ass

Okay, whit that information, i can start to extracting my subtitle file.

C:\MKVToolNix>mkvextract tracks 
        "C:\Users\edw\Downloads\[HorribleSubs] Digimon Adventure tri - 01 [1080p].mkv" 

It will extract subtitle from “Digimon Adventure tri – 04 [1080p].mkv” and put the subtitle on E:\ with named mysubtitle.ass. You can convert .ass file into .srt file easily using online converter tools.

Download A Free Screen Recorder Software (CamStudio), and get A Lot of Crapware

Today i decided to download free Camstudio application from, and perhaps it’s my fault for not reading Terms and Condition, just simple next and next, accept and accept, but what i got is so many crapware.

This is for example,

And i dont even know, what else crapware that i got.
TL;DR, dont use CamStudio, because i uninstalled like 5 minutes after i download this application.


remove highstair application from control panel, it will help remove the unwanted ads on your browsers.

Daftar Kode Provinsi, Kecamatan, Kabupaten dan Desa di Indonesia Menurut Kode BPS

Kali ini gw kembali menulis tentang GIS, berawal dari masalah yang gw temui di project terbaru gw terkait geospasial Indonesia. Disana gw kesulitan untuk mendapatkan kode dan nama wilayah di Indonesia secara sistematis, akhirnya gw bikin versi sql-nya. Semoga data gw bisa bermanfaat bagi seluruh penggiat spasial Indonesia (Y)

SQL File-nya bisa diunduh —> disini

database kabupaten sql

database kabupaten sql