Reddit ModLog Wiki Publisher

This skill helps you work with a Python-based Reddit moderation log publisher that automatically scrapes moderation actions from a subreddit and publishes them to a wiki page.

What This Skill Does

Assists with development, configuration, and maintenance of a Reddit bot that:

Core Architecture

Step-by-Step Instructions

1. Python Environment Setup

**CRITICAL**: Always use `/opt/.venv/redditbot/bin/python` for all Python commands in this project.

When running Python commands:

2. Configuration Management

The application supports three configuration methods with priority order:

1. Command line arguments (highest priority)

2. Environment variables (override config file)

3. JSON config file (base configuration)

**First-time setup:**

```bash

cp config_template.json config.json

```

**Environment variables available:**

3. Running the Application

**Test configuration and connectivity:**

```bash

/opt/.venv/redditbot/bin/python modlog_wiki_publisher.py --test

```

**Single run:**

```bash

/opt/.venv/redditbot/bin/python modlog_wiki_publisher.py --source-subreddit SUBREDDIT_NAME

```

**Continuous daemon mode:**

```bash

/opt/.venv/redditbot/bin/python modlog_wiki_publisher.py --source-subreddit SUBREDDIT_NAME --continuous

```

**Force wiki update using existing database data:**

```bash

/opt/.venv/redditbot/bin/python modlog_wiki_publisher.py --source-subreddit SUBREDDIT_NAME --force-wiki

```

**Debug authentication issues:**

```bash

/opt/.venv/redditbot/bin/python scripts/debug_auth.py

```

4. Database Operations

**View recent processed actions:**

```bash

sqlite3 modlog.db "SELECT action_id, action_type, moderator, removal_reason, subreddit, created_at FROM processed_actions ORDER BY created_at DESC LIMIT 10;"

```

**View actions by specific subreddit:**

```bash

sqlite3 modlog.db "SELECT action_type, moderator, target_author, removal_reason FROM processed_actions WHERE subreddit = 'SUBREDDIT_NAME' ORDER BY created_at DESC LIMIT 5;"

```

**Track content lifecycle by target ID:**

```bash

sqlite3 modlog.db "SELECT target_id, action_type, moderator, removal_reason, datetime(created_at, 'unixepoch') FROM processed_actions WHERE target_id LIKE '%CONTENT_ID%' ORDER BY created_at;"

```

**Manual cleanup of old entries:**

```bash

sqlite3 modlog.db "DELETE FROM processed_actions WHERE created_at < date('now', '-30 days');"

```

5. Development and Code Changes

**Git workflow:**

**Code standards:**

6. Common Command Line Options

7. Authentication Requirements

The bot account needs:

8. Security and Privacy Guidelines

**CRITICAL SECURITY REQUIREMENT:**

**Content linking:**

9. Action Types and Display

**Default tracked actions:**

**Display behavior:**

10. File Structure

11. Troubleshooting Common Issues

**401 errors:**

**Wiki permission denied:**

**Rate limiting:**

**Module not found:**

Examples

**Run single update with debug logging:**

```bash

/opt/.venv/redditbot/bin/python modlog_wiki_publisher.py --source-subreddit mysubreddit --debug

```

**Run in daemon mode with custom interval:**

```bash

/opt/.venv/redditbot/bin/python modlog_wiki_publisher.py --source-subreddit mysubreddit --continuous --interval 600

```

**Check recent removals in database:**

```bash

sqlite3 modlog.db "SELECT action_type, target_author, removal_reason FROM processed_actions WHERE action_type LIKE '%remove%' ORDER BY created_at DESC LIMIT 5;"

```

Important Notes