Skip to content

Instantly share code, notes, and snippets.

View AlexDev404's full-sized avatar
🫤
I'm here.

Immanuel Daviel A. Garcia AlexDev404

🫤
I'm here.
View GitHub Profile
-- =============================================
-- Author: <Immanuel Garcia>
-- Create date: <March 30, 2026>
-- Description: <Proportional CTE-based request pagination for random page-access>
-- =============================================
CREATE PROCEDURE [dbo].[GetRequests]
-- Add the parameters for the stored procedure here
@pageNumber INT,
@pageSize INT,
@requestStatus NVARCHAR(10),
@AlexDev404
AlexDev404 / SigWebDevice.ts
Created March 26, 2026 21:01
SigWebDevice TypeScript Implementation
// SigWebTablet TypeScript SDK
// Based on SigWeb v1.0.4.0 by Topaz Systems Inc.
const getBlobURL =
(window.URL && URL.createObjectURL.bind(URL)) ||
((window as any).webkitURL && (window as any).webkitURL.createObjectURL.bind((window as any).webkitURL)) ||
(window as any).createObjectURL
const revokeBlobURL =
(window.URL && URL.revokeObjectURL.bind(URL)) ||
@AlexDev404
AlexDev404 / gist:ff0ea1901b6c14f29a17ed9387f3b2d3
Created March 8, 2026 19:28
Connecting containers to the internet on an IPv6-Only Hetzner Server

Dokploy on an IPv6-Only Hetzner Server

Environment

  • OS: Debian 13 (trixie)
  • Server: Hetzner VPS, IPv6-only (2a01:4f8:1c19:2b2a::1/64)
  • Dokploy version: v0.28.4 (Docker Swarm mode)

@echo off
REM ----- Choose your browser -----
REM For Google Chrome:
set browser="C:\Program Files\Google\Chrome\Application\chrome.exe"
REM ----- Tabs to open -----
set url1=https://www.grinchhourofcode.com/
set url2=https://education.minecraft.net/en-us/lessons/hour-of-ai-the-first-night
set url3=https://studio.code.org/courses/oceans/units/1/lessons/1/levels/1
@AlexDev404
AlexDev404 / schema.dbml
Created November 12, 2025 19:20
Soil Moisture Quality Monitor
// Soil Moisture Quality Monitor
Table Users {
user_id serial [pk]
username string
password string
}
Table Nodes {
device_id serial [pk]
@AlexDev404
AlexDev404 / README.md
Last active March 30, 2026 17:41
A guide on cracking Phaser 2D Editor (Windows)

Cracking Phaser 2D Editor v3

It's been over a year since Phaser 2D v3 has been dead, so I thought I'd make a small guide on how to crack the editor now that it's out of support.

Cracking the editor is very easy to do, and is very low effort. To begin, start by downloading a copy of the Phaser Editor from Archive.org or similar along with Phaser Core.

Then, download a copy or Telerik Fiddler Classic

Open fiddler, and unzip phaser core.

@AlexDev404
AlexDev404 / index.md
Created October 22, 2025 21:02
CMPS4191 - WebSocket API Lab (Client-side)

WebSocket API Lab - Client-side

Explore & Observe - Questions

Before Opening the Connection

  • Open the Console and type:

socket.readyState

@AlexDev404
AlexDev404 / cool_stuff.md
Last active November 15, 2025 03:55
Cool stuff to try out
@AlexDev404
AlexDev404 / okx-sublogin-1.0.user.js
Last active October 28, 2025 04:33
Login to your provisioned OKX subaccount
// ==UserScript==
// @name OKX - Sign in with Pool Token
// @namespace http://tampermonkey.net/
// @version 1.0
// @description Set token and isLogin cookies with custom values
// @author AlexDev404 (Immanuel Garcia)
// @match https://www.okx.com/account/users?logged_in=true
// @match https://www.okx.com/account/login*
// @match https://www.okx.com/*
// @grant none

Chapter 2: Voltage, Current, and Resistance

Concept Formula Citation
Voltage (V) $V = \frac{W}{Q}$ [1-3]
Current (I) $I = \frac{Q}{t}$ [4]
Conductance (G) $G = \frac{1}{R}$ [5]
Wire Resistance (R) $R = \rho \frac{l}{A}$ [6]

Chapter 3: Ohm’s Law, Energy, and Power