yttcom.net
Backend / Tools / DB Viewer
yttcom.net
Domains / DB Viewer
v2.0 · 07.11.26
◇ laboratory.db
systems/30-tech/laboratory/
records.db inbox.db transfers.db knowledge.db jurisdiction.db
laboratory › templates
Tables
categories
0 commands
37 creators
0 events
0 knowledge
12 prog_counter
3 qa
37 scripts
1 shortcuts
29 sqlite_sequence
7 templates
14
templates
14 rows
14
Write and Execute PHP via Temp File
status: active
Write PHP to a temp path then execute via HTTP — correct pattern since eval() is blocked
▾ tap
id
14
code
TMPL-S006
name
Write and Execute PHP via Temp File
platform
server
language
bash
category
Server Scripts
purpose
Write PHP to a temp path then execute via HTTP — correct pattern since eval() is blocked
inputs_json
[{"key":"TMP_PATH","label":"Temp file path","placeholder":"public_html/tmp_exec_abc123.php","hint":"Unique temp filename
template_body
#!/bin/bash # Write+Execute PHP via temp file — Tech [03] # eval() is blocked — this is the correct pattern TMP_PATH
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
version
v1.0
status
active
date_created
2026-07-13
date_updated
2026-07-13
created_by
USR369
active
1
description
Write PHP to a temp path then execute via HTTP — correct pattern since eval() is blocked
⊞ Full detail →
13
Trash Lifecycle Sweep
status: active
Move files 5+ days old from trash/ to archive/, delete archive/ files after 5 more days
▾ tap
id
13
code
TMPL-S005
name
Trash Lifecycle Sweep
platform
server
language
bash
category
Server Scripts
purpose
Move files 5+ days old from trash/ to archive/, delete archive/ files after 5 more days
inputs_json
[{"key":"SYSTEM_DIR","label":"System backup directory","placeholder":"backups/30-tech","hint":"Directory containing tras
template_body
#!/bin/bash # Trash Lifecycle Sweep — Tech [03] — D102/D106 SYSTEM_DIR="{{SYSTEM_DIR}}" TRASH="$SYSTEM_DIR/trash" AR
usage_notes
Per D102/D106/D107. SYSTEM_DIR = e.g. backups/30-tech
dependencies
SSH, find
tested_on
yttcom.net LiteSpeed
version
v1.0
status
active
date_created
2026-07-13
date_updated
2026-07-13
created_by
USR369
active
1
description
Move files 5+ days old from trash/ to archive/, delete archive/ files after 5 more days
⊞ Full detail →
12
PHP Error Log Tail
status: active
Show last N lines of PHP error log filtered by keyword
▾ tap
id
12
code
TMPL-S004
name
PHP Error Log Tail
platform
server
language
bash
category
Server Scripts
purpose
Show last N lines of PHP error log filtered by keyword
inputs_json
[{"key":"LINES","label":"Lines to show","placeholder":"50","hint":"How many recent log lines"},{"key":"FILTER","label":"
template_body
#!/bin/bash # PHP Error Log Tail — Tech [03] LINES="{{LINES}}" FILTER="{{FILTER}}" LOG=~/logs/error_log if [ ! -f "$LO
usage_notes
Leave FILTER blank to see all. Common filters: Fatal, Warning, undefined
dependencies
SSH access
tested_on
yttcom.net LiteSpeed
version
v1.0
status
active
date_created
2026-07-13
date_updated
2026-07-13
created_by
USR369
active
1
description
Show last N lines of PHP error log filtered by keyword
⊞ Full detail →
11
SQLite DB Backup
status: active
Copy a SQLite .db file to a timestamped backup
▾ tap
id
11
code
TMPL-S003
name
SQLite DB Backup
platform
server
language
bash
category
Server Scripts
purpose
Copy a SQLite .db file to a timestamped backup
inputs_json
[{"key":"DB_PATH","label":"DB Path","placeholder":"public_html/backend/records/db/records.db","hint":"Full path to the S
template_body
#!/bin/bash # SQLite DB Backup — Tech [03] DB_PATH="{{DB_PATH}}" TIMESTAMP=$(date +%Y%m%d_%H%M) BACKUP="${DB_PATH%.db}
usage_notes
Run before any major DB change. Output goes to same directory with date suffix.
dependencies
SSH, sqlite3
tested_on
yttcom.net LiteSpeed
version
v1.0
status
active
date_created
2026-07-13
date_updated
2026-07-13
created_by
USR369
active
1
description
Copy a SQLite .db file to a timestamped backup
⊞ Full detail →
10
Find Large Files
status: active
List the largest files in a directory, sorted by size
▾ tap
id
10
code
TMPL-S002
name
Find Large Files
platform
server
language
bash
category
Server Scripts
purpose
List the largest files in a directory, sorted by size
inputs_json
[{"key":"SEARCH_DIR","label":"Search Directory","placeholder":"public_html","hint":"Directory to scan"},{"key":"COUNT","
template_body
#!/bin/bash # Find Large Files — Tech [03] SEARCH_DIR="{{SEARCH_DIR}}" COUNT="{{COUNT}}" echo "Top $COUNT largest file
usage_notes
Useful for finding log bloat or large uploads eating disk quota.
dependencies
SSH access
tested_on
yttcom.net LiteSpeed
version
v1.0
status
active
date_created
2026-07-13
date_updated
2026-07-13
created_by
USR369
active
1
description
List the largest files in a directory, sorted by size
⊞ Full detail →
9
Fix File Permissions
status: active
Reset permissions on a directory — 755 for dirs, 644 for files
▾ tap
id
9
code
TMPL-18
name
Fix File Permissions
platform
server
language
bash
category
Server Scripts
purpose
Reset permissions on a directory — 755 for dirs, 644 for files
inputs_json
[{"key":"TARGET_DIR","label":"Target Directory","placeholder":"public_html/systems/30-tech","hint":"Relative to home or
template_body
#!/bin/bash # Fix File Permissions — Tech [03] TARGET="{{TARGET_DIR}}" echo "Fixing permissions in: $TARGET" find "$T
usage_notes
Run from SSH. TARGET_DIR is relative to public_html or absolute path.
dependencies
SSH access
tested_on
yttcom.net LiteSpeed
version
v1.0
status
active
date_created
2026-07-13
date_updated
2026-07-13
created_by
USR369
active
1
description
Reset permissions on a directory — 755 for dirs, 644 for files
⊞ Full detail →
8
List Largest Files in Folder
status: active
Lists the largest files in a folder to identify space usage. Useful before running duplicate finder or manual cleanup.
▾ tap
id
8
code
TMPL-A003
name
List Largest Files in Folder
platform
android
language
Python3
category
Android Scripts
purpose
Lists the largest files in a folder to identify space usage. Useful before running duplicate finder or manual cleanup.
inputs_json
[{"key": "TARGET_FOLDER", "label": "Target Folder", "placeholder": "/storage/emulated/0", "hint": "Full path to scan"},
template_body
# List largest files in {{TARGET_FOLDER}} # Paste into Termux python3 - << 'PYEOF' import os TARGET = '{{TARGET_FOLDER
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
version
v1.0
status
active
date_created
2026-07-13
date_updated
2026-07-13
created_by
USR369
active
1
description
Lists the largest files in a folder to identify space usage. Useful before running duplicate finder or manual cleanup.
⊞ Full detail →
7
Create Python Script in Termux (Heredoc Method)
status: active
Template for creating any Python script file in Termux using cat heredoc. Avoids nano editor complications on Android.
▾ tap
id
7
code
TMPL-A002
name
Create Python Script in Termux (Heredoc Method)
platform
android
language
Bash
category
Android Scripts
purpose
Template for creating any Python script file in Termux using cat heredoc. Avoids nano editor complications on Android.
inputs_json
[{"key": "SCRIPT_NAME", "label": "Script Filename", "placeholder": "my_script.py", "hint": "Will be created in Termux ho
template_body
# Create a Python script in Termux # Paste into Termux — creates ~/{{SCRIPT_NAME}} cat > ~/{{SCRIPT_NAME}} << 'EOF' #
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
version
v1.0
status
active
date_created
2026-07-13
date_updated
2026-07-13
created_by
USR369
active
1
description
Template for creating any Python script file in Termux using cat heredoc. Avoids nano editor complications on Android.
⊞ Full detail →
6
Android Duplicate File Finder
status: active
Scans a folder recursively for duplicate files by MD5 hash. Reports all groups showing KEEP and DELETE. Asks YES/NO before deleting. Always keeps one copy.
▾ tap
id
6
code
TMPL-A001
name
Android Duplicate File Finder
platform
android
language
Python3
category
Android Scripts
purpose
Scans a folder recursively for duplicate files by MD5 hash. Reports all groups showing KEEP and DELETE. Asks YES/NO befo
inputs_json
[{"key": "TARGET_FOLDER", "label": "Target Folder", "placeholder": "/storage/emulated/0/AI", "hint": "Full path to scan
template_body
# Android Duplicate File Finder # Paste into Termux — scans {{TARGET_FOLDER}} for duplicates python3 - << 'PYEOF' imp
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
version
v1.0
status
active
date_created
2026-07-13
date_updated
2026-07-13
created_by
USR369
active
1
description
Scans a folder recursively for duplicate files by MD5 hash. Reports all groups showing KEEP and DELETE. Asks YES/NO before deleting. Always keeps one copy.
⊞ Full detail →
5
Disable OneDrive Completely
status: active
Quits OneDrive, removes it from startup, uninstalls it, and optionally blocks reinstall. More reliable than using Settings UI.
▾ tap
id
5
code
TMPL-005
name
Disable OneDrive Completely
platform
windows
language
PowerShell
category
Windows Scripts
purpose
Quits OneDrive, removes it from startup, uninstalls it, and optionally blocks reinstall. More reliable than using Settin
inputs_json
[]
template_body
# CAI Tech — Disable OneDrive Completely v1.0n# Run in PowerShell as Administratornn# Step 1 — Kill OneDrive process
usage_notes
Run as Administrator — OneDrive will be stopped and removed
dependencies
Windows 11 — PowerShell 5.1+
tested_on
Windows 11
version
v1.0
status
active
date_created
2026-07-13
date_updated
2026-07-13
created_by
USR369
active
1
description
Quits OneDrive, removes it from startup, uninstalls it, and optionally blocks reinstall. More reliable than using Settings UI.
⊞ Full detail →
4
Uninstall Store App via PowerShell
status: active
Removes a Windows Store app (AppX package) that does not appear in normal Add/Remove Programs. Useful for stubborn pre-installed apps.
▾ tap
id
4
code
TMPL-004
name
Uninstall Store App via PowerShell
platform
windows
language
PowerShell
category
Windows Scripts
purpose
Removes a Windows Store app (AppX package) that does not appear in normal Add/Remove Programs. Useful for stubborn pre-i
inputs_json
[{"key": "APP_KEYWORD", "label": "App Name Keyword", "placeholder": "Cortana", "hint": "Partial name \u2014 matches any
template_body
# CAI Tech — Uninstall Store App v1.0 # Run in PowerShell as Administrator $keyword = "{{APP_KEYWORD}}" # Find match
usage_notes
Run as Administrator — enter app name keyword in input — copy and run
dependencies
Windows 11 — PowerShell 5.1+
tested_on
Windows 11
version
v1.0
status
active
date_created
2026-07-13
date_updated
2026-07-13
created_by
USR369
active
1
description
Removes a Windows Store app (AppX package) that does not appear in normal Add/Remove Programs. Useful for stubborn pre-installed apps.
⊞ Full detail →
3
Startup Cleanup — Remove Duplicate/Unwanted Startup Entries
status: active
Removes duplicate Google Drive entries, OneDrive, BingWallpaperDaemon, and Edge AutoLaunch from all four registry startup locations. Adds back one clean Google …
▾ tap
id
3
code
TMPL-003
name
Startup Cleanup — Remove Duplicate/Unwanted Startup Entries
platform
windows
language
PowerShell
category
Windows Scripts
purpose
Removes duplicate Google Drive entries, OneDrive, BingWallpaperDaemon, and Edge AutoLaunch from all four registry startu
inputs_json
[{"key": "GD_PATH", "label": "Google Drive .exe Path", "placeholder": "C:\\\\Program Files\\\\Google\\\\Drive File Strea
template_body
# CAI Tech — Startup Cleanup v1.0 — 06/17/26 # Removes: Google Drive duplicates, OneDrive, Bing Wallpaper, Edge Auto
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
version
v1.0
status
active
date_created
2026-07-13
date_updated
2026-07-13
created_by
USR369
active
1
description
Removes duplicate Google Drive entries, OneDrive, BingWallpaperDaemon, and Edge AutoLaunch from all four registry startup locations. Adds back one clean Google Drive entry.
⊞ Full detail →
2
Set Any App as Windows 11 Default
status: active
Universal default app setter — bypasses Windows 11 Store-only restriction via registry. Registers app, creates file class, assigns extensions, clears UserChoi …
▾ tap
id
2
code
TMPL-002
name
Set Any App as Windows 11 Default
platform
windows
language
PowerShell
category
Windows Scripts
purpose
Universal default app setter — bypasses Windows 11 Store-only restriction via registry. Registers app, creates file cl
inputs_json
[{"key": "APP_PATH", "label": "App Path (.exe)", "placeholder": "C:\\\\Program Files\\\\Notepad++\\\\notepad++.exe", "hi
template_body
# CAI Tech — Set Any App as Windows 11 Default v2.0 — 06/17/26 # Run in PowerShell as Administrator # ---- CONFIGUR
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++
version
v1.0
status
active
date_created
2026-07-13
date_updated
2026-07-13
created_by
USR369
active
1
description
Universal default app setter — bypasses Windows 11 Store-only restriction via registry. Registers app, creates file class, assigns extensions, clears UserChoice locks.
⊞ Full detail →
1
Windows 11 System Audit
status: active
Snapshots installed apps, startup items, disk space, OneDrive status, and notable background processes
▾ tap
id
1
code
TMPL-001
name
Windows 11 System Audit
platform
windows
language
PowerShell
category
Windows Scripts
purpose
Snapshots installed apps, startup items, disk space, OneDrive status, and notable background processes
inputs_json
[]
template_body
# ============================================================n# CAI Tech — Windows 11 System Audit Script v1.0 — 06
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
version
v1.0
status
active
date_created
2026-07-13
date_updated
2026-07-13
created_by
USR369
active
1
description
Snapshots installed apps, startup items, disk space, OneDrive status, and notable background processes
⊞ 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