Memory Wiki

Implement ALL 7 tasks for Module 7 (Community). Create new PHP files with correct implementations. Do NOT use rm/rmdir/del commands — only create files with write_file or echo/cat. ## T36 — Community Spaces (KEEP as-is) Directory: /root/profe-modules/community_spaces/ Already implemented. Create a verification report at /root/.hermes/plans/tb-t36-verification.md listing: - Module.php structure OK - CSRF enforcement confirmed - Backslash pattern correct - All migrations have -- UP markers - All tests pass ## T37 — Content Engine (PIVOT) Directory: /root/profe-modules/content_engine/ Create these files: **Interface** at src/ContentEngine/ContentEngineInterface.php: ```php namespace Profe\ContentEngine; interface ContentEngineInterface { public function createPost(int $spaceId, string $title, string $body, int $authorId, string $status = 'draft'): int; public function updatePost(int $postId, array $data): void; public function publishPost(int $postId): void; public function getPosts(int $spaceId, array $filters = []): array; public function getPost(int $postId): ?array; public function getVersionHistory(int $postId): array; public function restoreVersion(int $postId, int $versionId): void; } ``` **Module** at src/ContentEngine/ContentEngineModule.php — implement ModuleInstanceInterface, register dependencies (CoreUsersInterface, CommunitySpacesInterface, EventBusInterface, InputSanitizerInterface, CsrfMiddlewareInterface, DiContainerInterface), boot() registers migration 045, registers routes on rest_api_init. **Migration SQL** at /root/profe-modules/migrations/045_create_profe_content_items.sql: - profe_content_items: id, space_id FK, title, slug, body LONGTEXT, status ENUM(draft/published/archived/scheduled), author_id, displayed_nickname VARCHAR(250), publish_at DATETIME, unpublish_at DATETIME, timestamps - -- DOWN: DROP TABLE **Migration class** at Migration/CreateContentItemsMigration.php **Routes**: POST /community/spaces/{spaceId}/posts, GET /community/spaces/{spaceId}/posts, GET /community/posts/{postId}, PUT /community/posts/{postId}, POST /community/posts/{postId}/publish Keep existing migration 020 for content_versions. ## T38 — Comment System (REBUILD) Directory: /root/profe-modules/comment_system/ **Interface** at src/CommentSystem/CommentSystemInterface.php: ```php namespace Profe\CommentSystem; interface CommentSystemInterface { public function createComment(int $postId, int $userId, string $body, ?int $parentId = null): int; public function getComments(int $postId, string $status = 'approved'): array; public function getComment(int $commentId): ?array; public function moderateComment(int $commentId, string $status, ?string $reason = null): void; public function deleteComment(int $commentId): void; } ``` **Migration** 046_create_profe_comments.sql: id, post_id FK, user_id FK, parent_id NULLABLE FK, body TEXT, displayed_nickname VARCHAR(250), status ENUM(pending/approved/flagged/deleted), moderated_by, moderated_at, timestamps. Indexes on post_id, parent_id, status, user_id. **Module, Service, Repository, Routes**: Standard implementation. CSRF on POST/PUT/DELETE. ## T39 — Badge System (REBUILD) Directory: /root/profe-modules/badge_system/ **Interface** at src/BadgeSystem/BadgeSystemInterface.php: ```php namespace Profe\BadgeSystem; interface BadgeSystemInterface { public function awardBadge(int $userId, string $badgeKey): void; public function getUserBadges(int $userId): array; public function getBadgeDefinitions(): array; public function getBadgeByKey(string $badgeKey): ?array; } ``` **Migrations**: 047_create_profe_badges.sql (id, badge_key UNIQUE, name, description, icon, criteria TEXT, point_value INT, timestamps). 048_create_profe_user_badges.sql (id, user_id FK, badge_key FK, awarded_at, timestamps, UNIQUE(user_id, badge_key)). **Seed migration** with predefined badges: first_post, ten_posts, centurion, first_comment, commenter, profile_complete, early_adopter, space_founder. ## T40 — Leaderboard (REBUILD) Directory: /root/profe-modules/leaderboard/ **Interface** at src/Leaderboard/LeaderboardInterface.php: ```php namespace Profe\Leaderboard; interface LeaderboardInterface { public function getTopUsers(int $limit = 20, string $period = 'all'): array; public function getUserRank(int $userId, string $period = 'all'): ?int; public function recalculate(): void; } ``` **Migration** 049_create_profe_leaderboard_entries.sql: id, user_id FK, period ENUM(weekly/monthly/all), rank INT, total_posts INT, total_comments INT, total_badges INT, total_points INT, calculated_at DATETIME, timestamps. UNIQUE(user_id, period). No table needed — computed from aggregation queries. Cache with 5 min TTL. ## T41 — Document Library (REBUILD) Directory: /root/profe-modules/document_library/ **Interface** at src/DocumentLibrary/DocumentLibraryInterface.php: ```php namespace Profe\DocumentLibrary; interface DocumentLibraryInterface { public function uploadDocument(int $spaceId, int $userId, string $localPath, string $fileName, string $mimeType, ?int $categoryId = null): int; public function getDocument(int $documentId): ?array; public function getDocuments(int $spaceId, array $filters = []): array; public function getDocumentUrl(int $documentId, int $userId, int $expiresIn = 3600): ?string; public function deleteDocument(int $documentId): void; public function getCategories(): array; } ``` **Migrations**: 050_create_profe_documents.sql (id, space_id FK, user_id FK, category_id FK NULLABLE, file_name, mime_type, file_size_bytes, bunny_storage_path, cdn_url, displayed_nickname, timestamps, soft-delete). 051_create_profe_document_categories.sql (id, space_id FK, name, slug, description, timestamps). **Depends on**: BunnyStorageInterface from Module 6. ## T42 — Moderation Handler (REBUILD) Directory: /root/profe-modules/moderation_handler/ Namespace: Profe\ModerationHandler **Interface** at src/ModerationHandler/ModerationHandlerInterface.php: ```php namespace Profe\ModerationHandler; interface ModerationHandlerInterface { public function flagContent(string $contentType, int $contentId, int $flaggedBy, string $reason): int; public function getFlags(?string $status = 'pending'): array; public function resolveFlag(int $flagId, int $resolvedBy): void; public function dismissFlag(int $flagId, int $dismissedBy, ?string $reason = null): void; public function getStats(): array; } ``` **Migrations**: 052_create_profe_moderation_flags.sql (id, content_type VARCHAR(50), content_id BIGINT, flagged_by FK, reason TEXT, status ENUM(pending/resolved/dismissed), resolved_by FK, resolved_at, timestamps). 053_create_profe_moderation_actions.sql for action log. ## Important - Create EVERY file needed — don't skip any - Each Module.php must have getName(), getDependencies(), register(), boot(), shutdown() - Each migration SQL file needs -- UP and -- DOWN markers - Use 2 backslashes for namespace strings in PHP: `'Profe\\\\CoreUsers\\\\CoreUsersInterface'` - Migration registration pattern: global $profeContainer; if (isset(...)) { $migrator->register(new Migration\\...()); } - SQL migration files go in /root/profe-modules/migrations/ - Migration PHP classes go in src/{Module}/Migration/