yttcom.net
Backend / Tools / DB Viewer
yttcom.net
Domains / DB Viewer
v2.0 · 07.11.26
◇ 30-app.db
systems/30-tech/data/
records.db inbox.db transfers.db knowledge.db jurisdiction.db
30-app scripts
Tables
commands
67
qa_log
38
scripts
14
shortcuts
52
sqlite_sequence
4
scripts
14 rows
23
Write and Execute PHP via Temp File
tap
id
23
code
SCRIPT-S006
library
server
name
Write and Execute PHP via Temp File
language
bash
platform
LiteSpeed / cPanel Linux
purpose
Write PHP to a temp path then execute via HTTP — correct pattern since eval() is blocked
usage_notes
Bootstrap pattern for DB ops. Per knowledge-03.md: eval() is blocked server-side. Always zero+delete the temp file.
dependencies
curl, SSH
tested_on
yttcom.net LiteSpeed
inputs_json
[{"key":"TMP_PATH","label":"Temp file path","placeholder":"public_html/tmp_exec_abc123.php","hint":"Unique temp filename
template
#!/bin/bash # Write+Execute PHP via temp file — Tech [03] # eval() is blocked — this is the correct pattern TMP_PATH
date_added
—
active
1
raw_code
display_order
0
⊞ Full detail →
22
Trash Lifecycle Sweep
tap
id
22
code
SCRIPT-S005
library
server
name
Trash Lifecycle Sweep
language
bash
platform
LiteSpeed / cPanel Linux
purpose
Move files 5+ days old from trash/ to archive/, delete archive/ files after 5 more days
usage_notes
Per D102/D106/D107. SYSTEM_DIR = e.g. backups/30-tech
dependencies
SSH, find
tested_on
yttcom.net LiteSpeed
inputs_json
[{"key":"SYSTEM_DIR","label":"System backup directory","placeholder":"backups/30-tech","hint":"Directory containing tras
template
#!/bin/bash # Trash Lifecycle Sweep — Tech [03] — D102/D106 SYSTEM_DIR="{{SYSTEM_DIR}}" TRASH="$SYSTEM_DIR/trash" AR
date_added
—
active
1
raw_code
display_order
0
⊞ Full detail →
21
PHP Error Log Tail
tap
id
21
code
SCRIPT-S004
library
server
name
PHP Error Log Tail
language
bash
platform
LiteSpeed / cPanel Linux
purpose
Show last N lines of PHP error log filtered by keyword
usage_notes
Leave FILTER blank to see all. Common filters: Fatal, Warning, undefined
dependencies
SSH access
tested_on
yttcom.net LiteSpeed
inputs_json
[{"key":"LINES","label":"Lines to show","placeholder":"50","hint":"How many recent log lines"},{"key":"FILTER","label":"
template
#!/bin/bash # PHP Error Log Tail — Tech [03] LINES="{{LINES}}" FILTER="{{FILTER}}" LOG=~/logs/error_log if [ ! -f "$LO
date_added
—
active
1
raw_code
display_order
0
⊞ Full detail →
20
SQLite DB Backup
tap
id
20
code
SCRIPT-S003
library
server
name
SQLite DB Backup
language
bash
platform
LiteSpeed / cPanel Linux
purpose
Copy a SQLite .db file to a timestamped backup
usage_notes
Run before any major DB change. Output goes to same directory with date suffix.
dependencies
SSH, sqlite3
tested_on
yttcom.net LiteSpeed
inputs_json
[{"key":"DB_PATH","label":"DB Path","placeholder":"public_html/backend/records/db/records.db","hint":"Full path to the S
template
#!/bin/bash # SQLite DB Backup — Tech [03] DB_PATH="{{DB_PATH}}" TIMESTAMP=$(date +%Y%m%d_%H%M) BACKUP="${DB_PATH%.db}
date_added
—
active
1
raw_code
display_order
0
⊞ Full detail →
19
Find Large Files
tap
id
19
code
SCRIPT-S002
library
server
name
Find Large Files
language
bash
platform
LiteSpeed / cPanel Linux
purpose
List the largest files in a directory, sorted by size
usage_notes
Useful for finding log bloat or large uploads eating disk quota.
dependencies
SSH access
tested_on
yttcom.net LiteSpeed
inputs_json
[{"key":"SEARCH_DIR","label":"Search Directory","placeholder":"public_html","hint":"Directory to scan"},{"key":"COUNT","
template
#!/bin/bash # Find Large Files — Tech [03] SEARCH_DIR="{{SEARCH_DIR}}" COUNT="{{COUNT}}" echo "Top $COUNT largest file
date_added
—
active
1
raw_code
display_order
0
⊞ Full detail →
18
Fix File Permissions
tap
id
18
code
library
server
name
Fix File Permissions
language
bash
platform
LiteSpeed / cPanel Linux
purpose
Reset permissions on a directory — 755 for dirs, 644 for files
usage_notes
Run from SSH. TARGET_DIR is relative to public_html or absolute path.
dependencies
SSH access
tested_on
yttcom.net LiteSpeed
inputs_json
[{"key":"TARGET_DIR","label":"Target Directory","placeholder":"public_html/systems/30-tech","hint":"Relative to home or
template
#!/bin/bash # Fix File Permissions — Tech [03] TARGET="{{TARGET_DIR}}" echo "Fixing permissions in: $TARGET" find "$T
date_added
07/13/26
active
1
raw_code
display_order
0
⊞ Full detail →
17
List Largest Files in Folder
tap
id
17
code
SCRIPT-A003
library
android
name
List Largest Files in Folder
language
Python3
platform
Android - Termux
purpose
Lists the largest files in a folder to identify space usage. Useful before running duplicate finder or manual cleanup.
usage_notes
Set TARGET_FOLDER and COUNT in inputs. Create with SCRIPT-A002 heredoc method then run: python3 ~/large_files.py
dependencies
Python3 (pkg install python) - Termux storage access granted
tested_on
Android - Termux
inputs_json
[{"key": "TARGET_FOLDER", "label": "Target Folder", "placeholder": "/storage/emulated/0", "hint": "Full path to scan"},
template
# List largest files in {{TARGET_FOLDER}} # Paste into Termux python3 - << 'PYEOF' import os TARGET = '{{TARGET_FOLDER
date_added
06/17/26
active
1
raw_code
display_order
8
⊞ Full detail →
16
Create Python Script in Termux (Heredoc Method)
tap
id
16
code
SCRIPT-A002
library
android
name
Create Python Script in Termux (Heredoc Method)
language
Bash
platform
Android - Termux
purpose
Template for creating any Python script file in Termux using cat heredoc. Avoids nano editor complications on Android.
usage_notes
Set filename in input. Replace the placeholder code between PYEOF markers with your actual script. Paste entire block in
dependencies
Termux - no extra packages needed for heredoc itself
tested_on
David's Android phone - 06/17/26
inputs_json
[{"key": "SCRIPT_NAME", "label": "Script Filename", "placeholder": "my_script.py", "hint": "Will be created in Termux ho
template
# Create a Python script in Termux # Paste into Termux — creates ~/{{SCRIPT_NAME}} cat > ~/{{SCRIPT_NAME}} << 'EOF' #
date_added
06/17/26
active
1
raw_code
display_order
7
⊞ Full detail →
15
Android Duplicate File Finder
tap
id
15
code
SCRIPT-A001
library
android
name
Android Duplicate File Finder
language
Python3
platform
Android - Termux
purpose
Scans a folder recursively for duplicate files by MD5 hash. Reports all groups showing KEEP and DELETE. Asks YES/NO befo
usage_notes
1. pkg install python 2. termux-setup-storage 3. Create with heredoc (SCRIPT-A002) 4. python3 ~/find_duplicates.py
dependencies
Python3 (pkg install python) - Termux storage access granted
tested_on
David's Android phone - 06/17/26 - 783 files - 197 duplicate groups
inputs_json
[{"key": "TARGET_FOLDER", "label": "Target Folder", "placeholder": "/storage/emulated/0/AI", "hint": "Full path to scan
template
# Android Duplicate File Finder # Paste into Termux — scans {{TARGET_FOLDER}} for duplicates python3 - << 'PYEOF' imp
date_added
06/17/26
active
1
raw_code
display_order
6
⊞ Full detail →
14
Disable OneDrive Completely
tap
id
14
code
SCRIPT-005
library
windows
name
Disable OneDrive Completely
language
PowerShell
platform
Windows 11
purpose
Quits OneDrive, removes it from startup, uninstalls it, and optionally blocks reinstall. More reliable than using Settin
usage_notes
Run as Administrator — OneDrive will be stopped and removed
dependencies
Windows 11 — PowerShell 5.1+
tested_on
Windows 11
inputs_json
[]
template
# CAI Tech — Disable OneDrive Completely v1.0n# Run in PowerShell as Administratornn# Step 1 — Kill OneDrive process
date_added
06/17/26
active
1
raw_code
# CAI Tech — Disable OneDrive Completely v1.0n# Run in PowerShell as Administratornn# Step 1 — Kill OneDrive process
display_order
5
⊞ Full detail →
13
Uninstall Store App via PowerShell
tap
id
13
code
SCRIPT-004
library
windows
name
Uninstall Store App via PowerShell
language
PowerShell
platform
Windows 11
purpose
Removes a Windows Store app (AppX package) that does not appear in normal Add/Remove Programs. Useful for stubborn pre-i
usage_notes
Run as Administrator — enter app name keyword in input — copy and run
dependencies
Windows 11 — PowerShell 5.1+
tested_on
Windows 11
inputs_json
[{"key": "APP_KEYWORD", "label": "App Name Keyword", "placeholder": "Cortana", "hint": "Partial name \u2014 matches any
template
# CAI Tech — Uninstall Store App v1.0 # Run in PowerShell as Administrator $keyword = "{{APP_KEYWORD}}" # Find match
date_added
06/17/26
active
1
raw_code
display_order
4
⊞ Full detail →
12
Startup Cleanup — Remove Duplicate/Unwanted Startup Entries
tap
id
12
code
SCRIPT-003
library
windows
name
Startup Cleanup — Remove Duplicate/Unwanted Startup Entries
language
PowerShell
platform
Windows 11
purpose
Removes duplicate Google Drive entries, OneDrive, BingWallpaperDaemon, and Edge AutoLaunch from all four registry startu
usage_notes
Run as Administrator — restart after to verify — confirm with System Audit
dependencies
Windows 11 — PowerShell 5.1+
tested_on
David's Windows 11 laptop — 06/17/26 — 3 entries removed
inputs_json
[{"key": "GD_PATH", "label": "Google Drive .exe Path", "placeholder": "C:\\\\Program Files\\\\Google\\\\Drive File Strea
template
# CAI Tech — Startup Cleanup v1.0 — 06/17/26 # Removes: Google Drive duplicates, OneDrive, Bing Wallpaper, Edge Auto
date_added
06/17/26
active
1
raw_code
display_order
3
⊞ Full detail →
11
Set Any App as Windows 11 Default
tap
id
11
code
SCRIPT-002
library
windows
name
Set Any App as Windows 11 Default
language
PowerShell
platform
Windows 11
purpose
Universal default app setter — bypasses Windows 11 Store-only restriction via registry. Registers app, creates file cl
usage_notes
Run as Administrator — fill in inputs above — copy — run in PowerShell
dependencies
Windows 11 — target app must be installed — PowerShell 5.1+
tested_on
Windows 11 — 06/17/26 — 23 extensions set for Notepad++
inputs_json
[{"key": "APP_PATH", "label": "App Path (.exe)", "placeholder": "C:\\Program Files\\Notepad++\\notepad++.exe", "hint": "
template
# CAI Tech — Set Any App as Windows 11 Default v2.0 — 06/17/26 # Run in PowerShell as Administrator # ---- CONFIGUR
date_added
06/17/26
active
1
raw_code
display_order
2
⊞ Full detail →
10
Windows 11 System Audit
tap
id
10
code
SCRIPT-001
library
windows
name
Windows 11 System Audit
language
PowerShell
platform
Windows 11
purpose
Snapshots installed apps, startup items, disk space, OneDrive status, and notable background processes
usage_notes
Run in PowerShell as Administrator — copy full output and paste back to Tech_Cla for review
dependencies
Windows 11 — PowerShell 5.1+ (built in)
tested_on
Windows 11
inputs_json
[]
template
# ============================================================n# CAI Tech — Windows 11 System Audit Script v1.0 — 06
date_added
06/17/26
active
1
raw_code
# ============================================================n# CAI Tech — Windows 11 System Audit Script v1.0 — 06
display_order
1
⊞ Full detail →
Backend Domains Panel DB Viewer Transfers
Backend Tools DB Viewer DB Admin Server Map File Editor Backend Tools DB Viewer DB Admin Server Map File Editor