Index: backend/challenges/initialChallenges.json =================================================================== --- backend/challenges/initialChallenges.json (revision c2cdb62ff65e867fb8280183284b8401d96cc789) +++ backend/challenges/initialChallenges.json (revision 33abc79bae4c0bc470881cd85c91e677b10d4266) @@ -636,4 +636,62 @@ "input": "1113122113121113222123211211131211121311123112111331121113122112132113121113222112311311221112132113211321321123123211311222112111312211311123113321112132113211332112111312211311123113321112132113211332211213211322311211131221131112311311222113111231133211321123113112221133112132123123112111311222112132113211321322112311311222113311213212322211231131122211311123113321112132113211312311211131221", "output": "3113112221131112311332111213122112311311123112111331121113122112132113121113222112311311221112132113211321321123123211311222112111312211311123113321112132113211332112111312211311123113321112132113211332211213211322311211131221131112311311222113111231133211321123113112221133112132123123112111311222112132113211321322112311311222113311213212322211231131122211311123113321112132113211312311211131221" + } + ], + "difficulty": "Medium", + "output_type": "string" + }, + { + "title": "rotate-2-dimensional-array-90-degrees", + "description": "Given a square/rectangle matrix representing an image and a direction of rotation (`clockwise` or `anticlockwise`), rotate the image by 90 degrees.", + "examples": [ + { + "input": "clockwise\n1 2 3\n4 5 6\n7 8 9", + "output": "7 4 1\n8 5 2\n9 6 3" + }, + { + "input": "anticlockwise\n1 2 3\n4 5 6\n7 8 9", + "output": "3 6 9\n2 5 8\n1 4 7" + } + ], + "testcases": [ + { + "input": "clockwise\n1 2 3 4 5 6\n7 8 9 10 11 12\n13 14 15 16 17 18\n19 20 21 22 23 24\n25 26 27 28 29 30", + "output": "25 19 13 7 1\n26 20 14 8 2\n27 21 15 9 3\n28 22 16 10 4\n29 23 17 11 5\n30 24 18 12 6" + }, + { + "input": "anticlockwise\n1 2 3 4 5 6\n7 8 9 10 11 12\n13 14 15 16 17 18\n19 20 21 22 23 24\n25 26 27 28 29 30", + "output": "6 12 18 24 30\n5 11 17 23 29\n4 10 16 22 28\n3 9 15 21 27\n2 8 14 20 26\n1 7 13 19 25" + }, + { + "input": "clockwise\n1 2 3 4 5\n6 7 8 9 10\n11 12 13 14 15\n16 17 18 19 20\n21 22 23 24 25\n26 27 28 29 30", + "output": "26 21 16 11 6 1\n27 22 17 12 7 2\n28 23 18 13 8 3\n29 24 19 14 9 4\n30 25 20 15 10 5" + }, + { + "input": "anticlockwise\n1 2 3 4 5\n6 7 8 9 10\n11 12 13 14 15\n16 17 18 19 20\n21 22 23 24 25\n26 27 28 29 30", + "output": "5 10 15 20 25 30\n4 9 14 19 24 29\n3 8 13 18 23 28\n2 7 12 17 22 27\n1 6 11 16 21 26" + }, + { + "input": "clockwise\n1 2 3 4 5 6 7\n8 9 10 11 12 13 14\n15 16 17 18 19 20 21\n22 23 24 25 26 27 28\n29 30 31 32 33 34 35", + "output": "29 22 15 8 1\n30 23 16 9 2\n31 24 17 10 3\n32 25 18 11 4\n33 26 19 12 5\n34 27 20 13 6\n35 28 21 14 7" + }, + { + "input": "anticlockwise\n1 2 3 4 5 6 7\n8 9 10 11 12 13 14\n15 16 17 18 19 20 21\n22 23 24 25 26 27 28\n29 30 31 32 33 34 35", + "output": "7 14 21 28 35\n6 13 20 27 34\n5 12 19 26 33\n4 11 18 25 32\n3 10 17 24 31\n2 9 16 23 30\n1 8 15 22 29" + }, + { + "input": "clockwise\n1 2 3 4 5\n6 7 8 9 10\n11 12 13 14 15\n16 17 18 19 20\n21 22 23 24 25\n26 27 28 29 30\n31 32 33 34 35", + "output": "31 26 21 16 11 6 1\n32 27 22 17 12 7 2\n33 28 23 18 13 8 3\n34 29 24 19 14 9 4\n35 30 25 20 15 10 5" + }, + { + "input": "anticlockwise\n1 2 3 4 5\n6 7 8 9 10\n11 12 13 14 15\n16 17 18 19 20\n21 22 23 24 25\n26 27 28 29 30\n31 32 33 34 35", + "output": "5 10 15 20 25 30 35\n4 9 14 19 24 29 34\n3 8 13 18 23 28 33\n2 7 12 17 22 27 32\n1 6 11 16 21 26 31" + }, + { + "input": "clockwise\n1 2 3 4 5 6\n7 8 9 10 11 12\n13 14 15 16 17 18\n19 20 21 22 23 24\n25 26 27 28 29 30\n31 32 33 34 35 36", + "output": "31 25 19 13 7 1\n32 26 20 14 8 2\n33 27 21 15 9 3\n34 28 22 16 10 4\n35 29 23 17 11 5\n36 30 24 18 12 6" + }, + { + "input": "anticlockwise\n1 2 3 4 5 6\n7 8 9 10 11 12\n13 14 15 16 17 18\n19 20 21 22 23 24\n25 26 27 28 29 30\n31 32 33 34 35 36", + "output": "6 12 18 24 30 36\n5 11 17 23 29 35\n4 10 16 22 28 34\n3 9 15 21 27 33\n2 8 14 20 26 32\n1 7 13 19 25 31" } ], Index: backend/controllers/reviewController.js =================================================================== --- backend/controllers/reviewController.js (revision c2cdb62ff65e867fb8280183284b8401d96cc789) +++ backend/controllers/reviewController.js (revision 33abc79bae4c0bc470881cd85c91e677b10d4266) @@ -1,3 +1,4 @@ const prisma = require("../lib/prisma"); +const ToBeReviewedPost = require("../models/ToBeReviewedPost"); const ForumPost = require("../models/ForumPost"); const ForumController = require("./forumController"); @@ -7,18 +8,15 @@ const createReviewPost = async (req, res) => { const { title, content, authorId, authorName } = req.body; - console.log(title); + try { - const post = new ForumPost({ + const post = new ToBeReviewedPost({ title, content, + authorId, authorName, + dateCreated: new Date(), }); const savedPost = await prisma.to_be_reviewed.create({ - data: { - title: post.title, - content: post.content, - author_id: authorId, - author_name: post.author_name, - }, + data: post, }); } catch (err) { Index: backend/controllers/taskController.js =================================================================== --- backend/controllers/taskController.js (revision c2cdb62ff65e867fb8280183284b8401d96cc789) +++ backend/controllers/taskController.js (revision 33abc79bae4c0bc470881cd85c91e677b10d4266) @@ -213,5 +213,4 @@ function getTimeBonus() { const minutes = getMinutesSinceSevenAM(); - console.log("Minutes since 7 AM:", minutes); return Math.max(0, 60 - Math.floor(minutes * 0.0833)); } Index: backend/models/ToBeReviewedPost.js =================================================================== --- backend/models/ToBeReviewedPost.js (revision 33abc79bae4c0bc470881cd85c91e677b10d4266) +++ backend/models/ToBeReviewedPost.js (revision 33abc79bae4c0bc470881cd85c91e677b10d4266) @@ -0,0 +1,21 @@ +class ToBeReviewedPost { + constructor({ + title, + content, + authorId, + authorName, + id, + commentCount, + dateCreated, + }) { + this.id = id; + this.title = title; + this.content = content; + this.created_at = dateCreated.toISOString() || new Date().toISOString(); + this.comment_count = commentCount; + this.author_id = authorId; + this.author_name = authorName; + } +} + +module.exports = ToBeReviewedPost; Index: backend/scripts/addChallenge.js =================================================================== --- backend/scripts/addChallenge.js (revision 33abc79bae4c0bc470881cd85c91e677b10d4266) +++ backend/scripts/addChallenge.js (revision 33abc79bae4c0bc470881cd85c91e677b10d4266) @@ -0,0 +1,50 @@ +const supabase = require("../supabaseClient"); +const prisma = require("../lib/prisma"); +const fs = require("fs").promises; +const path = require("path"); +const Challenge = require("../models/Challenge"); + +async function addChallenge() { + const jsonPath = path.join(__dirname, "../challenges/initialChallenges.json"); + const data = await fs.readFile(jsonPath, "utf8"); + const challengesData = JSON.parse(data); + + const challenge = challengesData[challengesData.length - 1]; + + let currentDate = new Date(); + currentDate.setDate(currentDate.getDate() + 1); + const newChallenge = new Challenge({ + title: challenge.title, + content: challenge.description, + solving_date: currentDate, + attempted_by: 0, + solved_by: 0, + expired: false, + examples: challenge.examples, + test_cases: challenge.testcases.map((testCase) => ({ + input: testCase.input, + output: testCase.output, + })), + output_type: challenge.output_type, + difficulty: challenge.difficulty, + }); + const createdChallenge = await prisma.challenges.create({ + data: { + title: newChallenge.title, + content: newChallenge.content, + solving_date: newChallenge.solving_date, + attempted_by: newChallenge.attempted_by, + solved_by: newChallenge.solved_by, + expired: newChallenge.expired, + examples: newChallenge.examples, + output_type: newChallenge.output_type, + difficulty: newChallenge.difficulty, + + test_cases: { + create: newChallenge.test_cases, + }, + }, + }); +} + +addChallenge(); Index: ckend/scripts/deleteAllUsers.js =================================================================== --- backend/scripts/deleteAllUsers.js (revision c2cdb62ff65e867fb8280183284b8401d96cc789) +++ (revision ) @@ -1,41 +1,0 @@ -const supabase = require("../supabaseClient"); - -async function deleteAllUsers() { - const { data: users, error: fetchError } = await supabase - .from("users") - .select("id"); - if (fetchError) { - console.error("Error fetching users:", fetchError); - return; - } - - if (!users || users.length === 0) { - console.log("No users found."); - return; - } - - for (const user of users) { - const { error: authError } = await supabase.auth.admin.deleteUser(user.id); - if (authError) { - if (authError.status === 404 && authError.code === "user_not_found") { - console.warn(`Auth user ${user.id} not found (already deleted).`); - } else { - console.error(`Error deleting auth user ${user.id}:`, authError); - } - } else { - console.log(`Deleted auth user ${user.id}`); - } - } - - const { error: tableError } = await supabase - .from("users") - .delete() - .not("id", "is", null); - if (tableError) { - console.error("Error deleting users from table:", tableError); - } else { - console.log("Deleted all users from users table."); - } -} - -deleteAllUsers(); Index: backend/supabase/functions/leaderboard/index.ts =================================================================== --- backend/supabase/functions/leaderboard/index.ts (revision c2cdb62ff65e867fb8280183284b8401d96cc789) +++ backend/supabase/functions/leaderboard/index.ts (revision 33abc79bae4c0bc470881cd85c91e677b10d4266) @@ -4,6 +4,4 @@ const CACHE_DURATION = 5 * 60 * 1000; const PAGE_SIZE = 20; - -console.log("Starting leaderboard function..."); serve(async (req: Request): Promise => { @@ -52,5 +50,4 @@ if (cacheData && now - cacheData.timestamp < CACHE_DURATION) { - console.log("Cache hit"); return new Response(JSON.stringify({ ...cacheData.data, cached: true }), { status: 200, @@ -63,5 +60,4 @@ } - console.log("Cache miss — fetching leaderboard"); const offset = (page - 1) * limit; const { data, error, count } = await supabase Index: client/src/LandingPage/components/LeaderBoardEx.jsx =================================================================== --- client/src/LandingPage/components/LeaderBoardEx.jsx (revision c2cdb62ff65e867fb8280183284b8401d96cc789) +++ client/src/LandingPage/components/LeaderBoardEx.jsx (revision 33abc79bae4c0bc470881cd85c91e677b10d4266) @@ -71,10 +71,9 @@ } }; - // Load initial data + useEffect(() => { fetchLeaderboard(1, false); }, []); - // Handle load more button click const handleLoadMore = () => { if (pagination && pagination.hasNextPage) { @@ -83,8 +82,5 @@ }; - // Calculate position based on current page and index - FIXED const getPosition = (index) => { - // For load more functionality, we need to track total loaded items - // since we're appending data, the index represents the actual position return index + 1; }; @@ -135,10 +131,14 @@
Total Users
-
{pagination.totalUsers}
+
+ {pagination.totalUsers} +
Showing
-
{leaderboard.length}
+
+ {leaderboard.length} +