Flag suspicious registrations sharing risky account IPs #974

Merged
jimmyb merged 1 commit from codex/issue-49-suspicious-registration-alerts into master 2026-10-15 09:28:39 -05:00
Member

Flag registrations whose IP matches a banned/deleted account or at least two existing accounts created within seven days, while keeping ordinary IP reuse quiet.

Persist structured security audit snapshots and send optional queued Discord embeds with account edit links, Central-time dates, bounded retries, and resumable pagination. Configure DISCORD_WEBHOOK_URL and an asynchronous queue worker to enable delivery; the migration adds a registration-IP lookup index.

Verification: 48 focused tests passed, including registration regressions, risk flags, burst boundaries, IPv6, transaction rollback, delivery failures, embed limits, index rollback, and audit retention. The opt-in live delivery test was skipped in the final automated run; separate live mock deliveries were accepted by Discord. Pint and PHPStan passed.

Fixes #49

Flag registrations whose IP matches a banned/deleted account or at least two existing accounts created within seven days, while keeping ordinary IP reuse quiet. Persist structured security audit snapshots and send optional queued Discord embeds with account edit links, Central-time dates, bounded retries, and resumable pagination. Configure `DISCORD_WEBHOOK_URL` and an asynchronous queue worker to enable delivery; the migration adds a registration-IP lookup index. Verification: 48 focused tests passed, including registration regressions, risk flags, burst boundaries, IPv6, transaction rollback, delivery failures, embed limits, index rollback, and audit retention. The opt-in live delivery test was skipped in the final automated run; separate live mock deliveries were accepted by Discord. Pint and PHPStan passed. Fixes #49
jimmyb force-pushed codex/issue-49-suspicious-registration-alerts from ca1b6fbf17
Some checks are pending
tests / ci (pull_request) Has started running
linter / quality (pull_request) Has started running
to 0ba47adb73
All checks were successful
linter / quality (pull_request) Successful in 7m39s
tests / ci (pull_request) Successful in 19m13s
2026-10-15 09:01:09 -05:00
Compare
jimmyb merged commit 378a03443d into master 2026-10-15 09:28:39 -05:00
jimmyb deleted branch codex/issue-49-suspicious-registration-alerts 2026-10-15 09:28:39 -05:00
Sign in to join this conversation.
No reviewers
No milestone
No project
No assignees
2 participants
Notifications
Due date
The due date is invalid or out of range. Please use the format "yyyy-mm-dd".

No due date set.

Dependencies

No dependencies set

Reference
MyVideoGameList/myvideogamelist.com!974
No description provided.