starkayc

🔧 Deleting a Session Record in PostgreSQL (Docker)

This guide walks you through executing the following SQL command inside a PostgreSQL Docker container:

DELETE FROM session WHERE session_id = 'id_visitor';
DELETE FROM website_event WHERE session_id = 'id_visitor';

starkayc

🛠️ How to Change Medal Clip File Path

If you've moved your Medal clip storage to a different drive or folder, follow these steps to update the file path and get everything working again.

Step 1: Quit Medal Application

Make sure Medal is fully closed before starting.

---

starkayc

Export apps and import them using winget

Export Process

1. Open CMD as admin
2. Run winget export -o %userprofile%\Desktop\applist --accept-source-agreements
3. Copy the file applist to your new pc.

Import Process

1. Open CMD as admin

starkayc

from pynput import keyboard
import os

# === CONFIGURABLE SECTION ===
file_path = "score.txt"       # Change to your preferred path
left_key = 'a'                # Key to increase the first number
right_key = 'd'               # Key to increase the second number
reset_key = 'r'               # Optional: reset to 0-0
exit_key = 'esc'              # Optional: exit the script
# ============================

starkayc

import os

file_path = "counter.txt"  # You can also use an absolute path if needed

# Make sure the file exists and read the current count
if not os.path.exists(file_path):
    count = 0
else:
    with open(file_path, "r") as f:
        content = f.read().strip()

starkayc

Enable SSH on Cloud Gateway Ultra

1. Head to Settings > Control Plane > Console.
2. Then under Advanded enable SSH and input a password.

Login to Cloud Gateway Ultra

1. The username is root and the password is the one you set.
2. Find the PID by using pidof udhcpc.
3. Once you found the PID excute the command /bin/kill -SIGUSR2 PID which will kill the process.
4. Verify that the interface no longer has an ip address using ip addr.
5. Now reboot the router using reboot now.

starkayc

Sideloading on Apple TV using Appdb

Requirements

• Apple TV
• .p12 & .mobileprovision files.

Installation Guide

starkayc

Pelican Prune Webhook Configurations DB

Prune Database

Enter the SQL terminal and login.

mysql -u pelican

Delete the data in webhook configurations.

DELETE FROM panel.webhook_configurations;

starkayc

Fix Rustlog TABLE_ALREADY_EXISTS Error

Fix for username_history rustlog db error.

docker compose exec clickhouse clickhouse-client -q "DROP TABLE rustlog.username_history"

Fix for message_structured rustlog db error.

docker compose exec clickhouse clickhouse-client -q "DROP TABLE rustlog.message_structured"

starkayc

// ==UserScript==
// @name         Mute/Unmute Kick.com Video with Middle Mouse Button
// @namespace    StarKayC
// @version      1.2
// @description  Only mute/unmute Kick video when middle-clicking directly on the video player
// @author       StarKayC
// @match        https://kick.com/*
// @match        https://www.kick.com/*
// @grant        none
// ==/UserScript==