Skip to main content

Moderation

Use moderation for fake, abusive, duplicate, incorrect, or inappropriate records reported by users or the support bot.

Inappropriate Reports​

Check active inappropriate reports in production:

bunx wrangler d1 execute venezuela-te-busca-database --remote --json --command "SELECT reason, COUNT(*) AS reports, COUNT(DISTINCT person_id) AS people FROM reports WHERE deleted_at IS NULL AND hidden_at IS NULL GROUP BY reason ORDER BY reports DESC;"

Review inappropriate reports with the script when OPENROUTER_API_KEY is available:

OPENROUTER_API_KEY=... bun scripts/review-reported-persons.ts --reason inappropriate --limit 20

The script defaults to a dry run. Add --apply only after reviewing the output:

OPENROUTER_API_KEY=... bun scripts/review-reported-persons.ts --reason inappropriate --apply

Delete Policy​

Soft-delete a person record only when the record is clearly:

  • fake or a joke.
  • spam or promotional.
  • sexually explicit or abusive.
  • malicious doxxing.
  • clearly not a real missing/found person record.

Keep the person record when evidence is insufficient. Hide the report after review so it leaves the active queue.

Manual Review​

When reviewing manually:

  1. Read the report reason and details.
  2. Inspect the person fields and photo.
  3. Check sources and tips for context.
  4. Soft-delete clear abuse.
  5. Hide reviewed reports.

Do not delete legitimate-looking missing-person posters just because a report uses angry or unclear language.