spiffy

WP- DB – Extraction

all-scribbly coding design - layout general accid
| | all-scribbly, coding, design - layout, general, accid

get counts — 1. Master overview: all post types + statuses SELECT post_type, post_status, COUNT(*) AS count FROM wp_posts GROUP BY post_type, post_status ORDER BY post_type, post_status; — 2. Just posts/pages by status SELECT post_type, post_status, COUNT(*) AS count FROM wp_posts WHERE post_type IN ('post', 'page') GROUP BY post_type, post_status ORDER BY post_type, post_status; —

WP- DB – Extraction Read More »

8 Types Of Progressive Lenses

all-scribbly general
| | all-scribbly, general |

8 Types of Progressive Lenses Progressive lenses have become a cornerstone of vision correction for presbyopia. Patients can smoothly transition between tasks, such as reading and then viewing a building in the distance, without needing to switch glasses. This convenience adds comfort and ease to most wearers’ days. Eye care professionals have a variety of

8 Types Of Progressive Lenses Read More »

PHP Cheat Sheet

all-scribbly coding
| | all-scribbly, coding

PHP Cheat Sheet The only paths that matter (Homebrew PHP 8.5 + Apache) PHP binary /opt/homebrew/bin/php PHP 8.5 config folder /opt/homebrew/etc/php/8.5/ Extra scanned INI files /opt/homebrew/etc/php/8.5/conf.d/ PHP-FPM main config /opt/homebrew/etc/php/8.5/php-fpm.conf PHP-FPM pool configs /opt/homebrew/etc/php/8.5/php-fpm.d/ yours: /opt/homebrew/etc/php/8.5/php-fpm.d/sandbox.conf Apache vhost file (your php sandbox site) /private/etc/apache2/extra/php-sandbox.local.conf Apache main config /etc/apache2/httpd.conf Apache logs (your sandbox vhost) /private/var/log/apache2/php-sandbox-error_log /private/var/log/apache2/php-sandbox-access_log

PHP Cheat Sheet Read More »

Gitlab – Backup / Update Steps

all-scribbly coding,
| | all-scribbly, coding | ,

To update your GitLab instance to version 17.6, follow these steps: Review the Release Notes: Familiarize yourself with the new features, bug fixes, and any deprecations in version 17.6. GitLab check rhel [spiffy-root@spiffydesign ~]$ rpm -E %rhel 9 Cool — RHEL/Alma 9 means you want the .el9 builds. Install targets (in order) 1. gitlab-ee-18.5.5-ee.0.el9 2.

Gitlab – Backup / Update Steps Read More »

Signals Vault – Auth

coding accid
| | coding, accid

Auth system complete. Two auth paths, both project-scoped: Path A — AccidAuth (primary) routers/auth.py POST /auth/verify-token — accepts X-Accid-Key + X-Accid-Hash + X-ACCID-App headers Auto-registers on first call (no separate registration step) Project scoping: pass {"project_id": "dragon-lady"} in body — keys accumulate project access on each successful auth GET /auth/key-info — returns registered projects, app,

Signals Vault – Auth Read More »