Skip to content

Instantly share code, notes, and snippets.

View maulvi's full-sized avatar
🏠
Working from home

maulvi

🏠
Working from home
View GitHub Profile
@maulvi
maulvi / soal no 1
Last active September 25, 2017 02:05
database minggu 3
select employees.emp_no, first_name, last_name, count(dept_no) jml_dpt
from employees join dept_emp on employees.emp_no = dept_emp.emp_no
group by employees.emp_no, first_name, last_name
having count(dept_no) = 2;
Through the Rod Smith’s guidance and a few dirty tricks, I was successfully able to convert my GPT partition – without data loss or deleting any partitions – and then boot Windows 7 in legacy/MBR mode. In order to do this you’ll need your Windows installation media at hand as well as a copy of the Fedora 16 Live media. If you don’t have a copy of Fedora 16 Live handy, you can download the Live media ISO (64-bit) from a local mirror here
Keep in mind that at this point I only had 3 partitions and a bunch of unpartitioned space on the disk, so conversion was a rather straightforward process (all GPT partitions mapped directly to primary partitions). Although it is theoretically possible to convert GPT partitions with >4 partitions by defining which ones are to be logical partitions after conversion, I have not tested this.
Boot your Fedora 16 Live media and wait for your session to start. If you’re having troubles booting, press Tab at the boot loader screen and try booting with the nomodeset parameter ad
@maulvi
maulvi / client.py
Last active June 20, 2018 08:12
Socket chat room Caesar cipher
import socket
import select
import sys
import string
key = 'abcdefghijklmnopqrstuvwxyz'
def encrypt(n, plaintext):
"""Encrypt the string and return the ciphertext"""
result = ''
@maulvi
maulvi / debloat.txt
Created June 20, 2018 08:15
debloat
rm -rf system/app/AntHalService
rm -rf system/app/Apollo
rm -rf system/app/BasicDreams
rm -rf system/app/BookmarkProvider
rm -rf system/app/Browser
rm -rf system/app/CellBroadcastReceiver
rm -rf system/app/CMFileManager
rm -rf system/app/CMHome
rm -rf system/app/CMWallpapers
rm -rf system/app/DashClock
@maulvi
maulvi / gist:070bb48ab462499db126d9ad96876559
Created July 6, 2018 13:59
fix brightness waking up from sleep/suspend
For waking up from suspension, I create the following script /etc/pm/sleep.d/brightness:
```shell
#!/bin/sh
case "$1" in
resume|thaw)
echo 170 > /sys/class/backlight/intel_backlight/brightness
;;
esac
```
@maulvi
maulvi / kota.txt
Created May 25, 2019 07:17
nama kota Indonesia
teupahselatan
simeuluetimur
teupahbarat
teupahtengah
simeuluetengah
telukdalam
simeuluecut
salang
simeuluebarat
alafan
Memuat data ke dalam Apache pig dari sistem file (HDFS / Lokal) menggunakan operator LOAD.
a = LOAD 'test_set_tweets.txt' AS (id:chararray, ts:chararray, tweet:chararray);
Fungsi FLATTEN(TOKENIZE ini digunakan untuk split string dan LOWER mengubah semua karakter dalam string menjadi huruf kecil.
b = foreach a generate tweet, FLATTEN(TOKENIZE(LOWER(tweet))) as tokens;
Fungsi yang digunakan memfilter string yang diawali dengan hashtag
c = filter b by tokens MATCHES '#\\s*(\\w+)';
Operator GROUP digunakan untuk mengelompokkan data dalam satu atau beberapa string.
deb http://mirror.0x.sg/ubuntu/ xenial main restricted universe
deb-src http://mirror.0x.sg/ubuntu/ xenial main universe
###### Ubuntu Update Repos
deb http://mirror.0x.sg/ubuntu/ xenial-security main restricted universe
deb http://mirror.0x.sg/ubuntu/ xenial-updates main restricted universe
@maulvi
maulvi / SetupSSHForwardingOnQNAP.md
Created November 5, 2019 07:11 — forked from smuda/SetupSSHForwardingOnQNAP.md
Setup SSH forwarding on QNAP NAS

On receiving NAS:

setcfg LOGIN "SSH AllowTcpForwarding" TRUE
reboot

On client to forward local port 8443 to the QNAP admin interface:

ssh user@host -L 8443:localhost:443
@maulvi
maulvi / softether.sh
Last active November 13, 2019 10:56
Softether entware startup, place this file at /usr/local/etc/rc.d
#!/bin/sh
case $1 in
start)
/opt/etc/init.d/S05vpnserver start
;;
stop)
;;
esac