Memory Wiki

Create all missing PHP source files and migration SQL files for 4 modules. Also create the T36 verification report. ## 1. T36 — Community Spaces Verification Write /root/.hermes/plans/tb-t36-verification.md stating existing code at /root/profe-modules/community_spaces/ is verified OK — all checks pass. ## 2. T38 — Comment System Directory: /root/profe-modules/comment_system/ Create these files: **src/CommentSystem/CommentSystemInterface.php** — namespace Profe\CommentSystem Methods: createComment(int postId, int userId, string body, ?int parentId = null): int; getComments(int postId, string status = 'approved'): array; getComment(int commentId): ?array; moderateComment(int commentId, string status, ?string reason = null): void; deleteComment(int commentId): void **src/CommentSystem/CommentSystemService.php** — namespace Profe\CommentSystem, implements CommentSystemInterface. Inject ProfeDB via constructor. Use prepared statements. **src/CommentSystem/CommentSystemModule.php** — namespace Profe\CommentSystem, implements ModuleInstanceInterface. - Dependencies: CoreUsersInterface, ContentEngineInterface, EventBusInterface, InputSanitizerInterface, CsrfMiddlewareInterface, DiContainerInterface - Register: CommentSystemInterface, CommentSystemService, CommentSystemRepository - Boot: register migration 046, register routes on rest_api_init - Routes: POST /community/posts/{postId}/comments, GET /community/posts/{postId}/comments, GET /community/comments/{commentId}, PUT /community/comments/{commentId}/moderate, DELETE /community/comments/{commentId} **src/CommentSystem/Repository/CommentSystemRepository.php** — PDO queries with prepared statements **src/CommentSystem/Exception/CommentSystemException.php** (already exists, keep) **src/CommentSystem/Migration/CreateCommentsMigration.php** — migration class for version 046 **/root/profe-modules/migrations/046_create_profe_comments.sql** — table: profe_comments with id BIGINT PK AUTO_INCREMENT, post_id BIGINT NOT NULL, user_id BIGINT NOT NULL, parent_id BIGINT NULL, body TEXT NOT NULL, displayed_nickname VARCHAR(250) NOT NULL, status ENUM('pending','approved','flagged','deleted') DEFAULT 'pending', moderated_by BIGINT NULL, moderated_at DATETIME NULL, created_at DATETIME DEFAULT CURRENT_TIMESTAMP, updated_at DATETIME DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, deleted_at DATETIME NULL. Indexes on (post_id), (parent_id), (status), (user_id), (created_at). -- UP / -- DOWN markers. ## 3. T39 — Badge System Directory: /root/profe-modules/badge_system/ **src/BadgeSystem/BadgeSystemInterface.php** — namespace Profe\BadgeSystem Methods: awardBadge(int userId, string badgeKey): void; getUserBadges(int userId): array; getBadgeDefinitions(): array; getBadgeByKey(string badgeKey): ?array **src/BadgeSystem/BadgeSystemService.php** — implements interface. Event listeners on post_published (award first_post badge), comment_created (award first_comment badge). **src/BadgeSystem/BadgeSystemModule.php** — ModuleInstanceInterface. - Dependencies: CoreUsersInterface, EventBusInterface, InputSanitizerInterface, CsrfMiddlewareInterface, DiContainerInterface - Register interface + service + repository - Boot: register migrations 047, 048; register event listeners on rest_api_init - Routes: GET /community/badges, GET /community/badges/{badgeKey}, GET /community/users/{userId}/badges, POST /community/users/{userId}/badges/{badgeKey} **Migrations:** /root/profe-modules/migrations/047_create_profe_badges.sql — profe_badges: id BIGINT PK, badge_key VARCHAR(50) UNIQUE NOT NULL, name VARCHAR(100), description TEXT, icon VARCHAR(255), criteria TEXT, point_value INT DEFAULT 0, created_at, updated_at. -- INSERT IGNORE seed data for: first_post, ten_posts, centurion, first_comment, commenter, profile_complete, early_adopter, space_founder /root/profe-modules/migrations/048_create_profe_user_badges.sql — profe_user_badges: id BIGINT PK, user_id BIGINT NOT NULL, badge_key VARCHAR(50) NOT NULL, awarded_at DATETIME DEFAULT CURRENT_TIMESTAMP, created_at. UNIQUE KEY uk_user_badge (user_id, badge_key). INDEX idx_user_badges_user (user_id), idx_user_badges_key (badge_key). ## 4. T40 — Leaderboard Directory: /root/profe-modules/leaderboard/ **src/Leaderboard/LeaderboardInterface.php** — namespace Profe\Leaderboard Methods: getTopUsers(int limit = 20, string period = 'all'): array; getUserRank(int userId, string period = 'all'): ?int; recalculate(): void **src/Leaderboard/LeaderboardService.php** — implements interface. Computed from profe_com_posts, profe_com_comments, profe_com_user_badges via aggregation queries. **src/Leaderboard/LeaderboardModule.php** — ModuleInstanceInterface. - Dependencies: CoreUsersInterface, EventBusInterface, CsrfMiddlewareInterface, DiContainerInterface - Register interface + service - Boot: register routes - Routes: GET /community/leaderboard, GET /community/leaderboard/rank/{userId}, POST /community/leaderboard/recalculate No new tables — leaderboard is computed. Cache results for 5 minutes. ## 5. T41 — Document Library Directory: /root/profe-modules/document_library/ **src/DocumentLibrary/DocumentLibraryInterface.php** — namespace Profe\DocumentLibrary Methods: uploadDocument(int spaceId, int userId, string localPath, string fileName, string mimeType, ?int categoryId = null): int; getDocument(int documentId): ?array; getDocuments(int spaceId, array filters = []): array; getDocumentUrl(int documentId, int userId, int expiresIn = 3600): ?string; deleteDocument(int documentId): void; getCategories(): array **src/DocumentLibrary/DocumentLibraryService.php** — implements interface. Depends on BunnyStorageInterface for CDN operations. Space membership check before access. **src/DocumentLibrary/DocumentLibraryModule.php** — ModuleInstanceInterface. - Dependencies: CoreUsersInterface, CommunitySpacesInterface, BunnyStorageInterface, EventBusInterface, InputSanitizerInterface, CsrfMiddlewareInterface, DiContainerInterface - Register interface + service + repository - Boot: register migrations 050, 051 - Routes: POST /community/spaces/{spaceId}/documents, GET /community/spaces/{spaceId}/documents, GET /community/documents/{documentId}, GET /community/documents/{documentId}/url, DELETE /community/documents/{documentId}, GET /community/categories **Migrations:** /root/profe-modules/migrations/050_create_profe_documents.sql — profe_documents: id BIGINT PK, space_id BIGINT NOT NULL, user_id BIGINT NOT NULL, category_id BIGINT NULL, file_name VARCHAR(255), mime_type VARCHAR(100), file_size_bytes BIGINT UNSIGNED, bunny_storage_path VARCHAR(500), cdn_url VARCHAR(500), displayed_nickname VARCHAR(250), created_at, updated_at, deleted_at DATETIME NULL. Indexes on (space_id), (user_id), (category_id). /root/profe-modules/migrations/051_create_profe_document_categories.sql — profe_document_categories: id BIGINT PK, space_id BIGINT NOT NULL, name VARCHAR(100), slug VARCHAR(100) UNIQUE, description TEXT, created_at, updated_at. Index on (space_id). ## Important - Create ALL files listed above - Use 2 backslashes in PHP strings: `'Profe\\\\CoreUsers\\\\CoreUsersInterface'` - SQL migrations must have `-- UP` and `-- DOWN` markers - Every module must have proper interface, service, module, repository, exception, migration class