Muhammad Rafi Rahman Habibi rafirh

🎯

Focusing

📚 Constantly embracing the journey of learning and exploring the exciting world of technology.

rafirh / install-postgis.sh

Created December 8, 2025 01:17

	#!/bin/bash
	set -e

	echo "=== AUTO INSTALL POSTGRESQL + POSTGIS ==="

	# -------- INPUT USER --------
	read -p "Masukkan nama database: " DB_NAME
	read -p "Masukkan username database: " DB_USER
	read -sp "Masukkan password database: " DB_PASS
	echo ""

rafirh / install-geonetwork.sh

Created December 8, 2025 01:15

	#!/bin/bash
	set -e

	echo "=== AUTO INSTALL GEONETWORK + NGINX REVERSE PROXY ==="

	# -------- INPUT USER --------
	read -p "Masukkan domain (tanpa https://): " DOMAIN
	read -p "Masukkan port GeoNetwork (contoh 5002): " GN_PORT

	echo ""

rafirh / install-geoserver.sh

Last active December 8, 2025 00:39

	#!/bin/bash
	set -e

	echo "=== AUTO INSTALL GEOSERVER + NGINX REVERSE PROXY ==="

	# -------- INPUT USER --------
	read -p "Masukkan domain (tanpa https://): " DOMAIN
	read -p "Masukkan port GeoServer (contoh 5001): " GS_PORT

	echo ""

rafirh / satupeta-installation.sh

Last active December 4, 2025 15:41

	#!/bin/bash
	clear
	echo "=== AUTO INSTALL SATU PETA ==="
	set -euo pipefail

	# --- INPUT DOMAIN ---
	read -p "Masukkan domain (tanpa https://): " DOMAIN

	# --- INPUT GITLAB USERNAME & TOKEN ---
	echo "=== AUTH GITLAB ==="

rafirh / asd.js

Created October 17, 2025 09:17

	let n = 0;
	let i = 0;

	// bagian tag dipecah agar sulit terdeteksi oleh bot
	const tagStart = "🔥(" + "@";
	const tagMid = "cukongin" + "crypto";
	const tagEnd = ")🔥";
	const groupTag = tagStart + tagMid + tagEnd; // -> "🔥(@cukongincrypto)🔥"

	// array pesan dasar (tanpa tag, tanpa spasi tambahan)

rafirh / main.js

Created March 11, 2025 08:36

script chat idx

	let n = 0;

	const coinName = "AAZ";
	const target = '400rb';

	const messages = [
	`jangan sampai ketinggalan, ${coinName} lagi siap-siap pump 🚀🔥`,
	`cek ${coinName}, mau terbang nih`,
	`${coinName} lagi ngumpulin penumpang, naik sekarang sebelum penuh`,
	`mending masuk ${coinName} sekarang, daripada nyesel pas ${coinName} udah mahal 🔥`,

rafirh / main.js

Created May 27, 2024 02:47

dump

	// test api, show to console https://api-portal-jatim.pisdev.my.id/api/users

	// jquery request
	$.ajax({
	url: 'https://klinikhoaks.jatimprov.go.id/api/mobile/getjmlhoaksytd',
	type: 'GET',
	success: function(response) {
	console.log(response);
	},
	error: function(xhr) {

rafirh / query.sql

Created May 20, 2024 04:42

Grant Access to a Schema

	GRANT USAGE ON SCHEMA "user" TO username;
	GRANT SELECT, INSERT, UPDATE, DELETE ON ALL TABLES IN SCHEMA "user" TO username;
	GRANT EXECUTE ON ALL FUNCTIONS IN SCHEMA "user" TO username;
	GRANT USAGE ON ALL SEQUENCES IN SCHEMA "user" TO username;

rafirh / recap_by_year.sql

Created January 16, 2024 07:23

	SELECT
	terminal.name as terminal,
	city.name as kota,
	COALESCE(count(
	CASE
	WHEN r.is_arrival = true AND r.tvehicle_type_id = 4 THEN r.id
	ELSE null
	END), 0::bigint) AS ar_vehicle_akap,
	COALESCE(sum(
	CASE

rafirh / recap_by_month_and_year.sql

Created January 16, 2024 07:21

	SELECT
	terminal.name as terminal,
	city.name as kota,
	COALESCE(count(
	CASE
	WHEN r.is_arrival = true AND r.tvehicle_type_id = 4 THEN r.id
	ELSE null
	END), 0::bigint) AS ar_vehicle_akap,
	COALESCE(sum(
	CASE