Rankings page

5 files changed, 88 insertions, 4 deletions

diff --git a/RULES.md b/RULES.md
new file mode 100644
index 0000000..99c5a3e
--- /dev/null
+++ b/RULES.md
@@ -0,0 +1,42 @@
+# Rules
+
+To compete on the leaderboard, you must adhere to the following rules. Failure to do so may result in warnings or bans depending on severity. 
+
+## Game
+
+All runs must be performed on the latest release of Portal 2. Game files must not be modified in any way (things such as binary or dll files).
+Launch options that alter game behavior (e.g., `-tickrate`) are prohibited
+The use of scripts, cheats, plugins, third-party software, or anything that changes the game's behavior is strictly forbidden.
+The only allowed plugin is SourceAutoRecord and if used it must be latest version.
+
+### Texture Modifications
+
+You may modify texture files as long as it doesn't give you any advantage.
+Both `.vtf` and `.vmt` files associated with these textures can be modified.
+Models cannot be modified as they alter game behaviour 
+
+## Runs
+
+### Demos
+
+Proof of your run must be recorded using demos. To start recording, type `record <demoname>` when entering the map, or use the SAR plugin with the command `sar_record_at 0`.
+A valid demo begins when the player can move and ends when the player touches the end flags.
+For cooperative runs, both players must submit their demos.
+
+### Console Commands & Cheats
+
+The use of cheats, including specific console commands, is prohibited. Even if a command is not cheat-protected, it may still invalidate your run. For a full list of banned commands, refer to rules.portal2.sr/#command-list.
+Additionally, commands that affect game behavior (e.g., `net_*` commands) are not allowed.
+
+### Banned Exploits
+
+The following exploits are banned: freezing the game window, pause abuse, packet loss manipulation, intentional internet disconnection, and any glitches requiring setup before the run (e.g., moving portals or EHM).
+If you're unsure whether an exploit is allowed, ask in the Discord server.
+
+### Note
+
+The moderation team has the authority to remove any record they believe to be illegitimate.
+If you accidentally submit an illegitimate run, the moderation team will attempt to contact you, and you may receive a warning.
+However, ignoring their attempts to contact you, deliberately cheating, or receiving too many warnings may result in a ban.
+
+As this is an open beta, we highly encourage players to test the limits and report any exploits they discover. Your feedback is essential to improving the system and ensuring fair competition.
diff --git a/backend/handlers/map.go b/backend/handlers/map.go
index 56c3455..33910fe 100644
--- a/backend/handlers/map.go
+++ b/backend/handlers/map.go
@@ -328,7 +328,7 @@ func FetchMapLeaderboards(c *gin.Context) {
 //      @Failure                400     {object}        models.Response
 //      @Router                 /games [get]
 func FetchGames(c *gin.Context) {
-        rows, err := database.DB.Query(`SELECT id, name, is_coop, image FROM games`)
+        rows, err := database.DB.Query(`SELECT id, name, is_coop, image FROM games ORDER BY id;`)
         if err != nil {
                 c.JSON(http.StatusOK, models.ErrorResponse(err.Error()))
                 return
@@ -340,7 +340,7 @@ func FetchGames(c *gin.Context) {
                         c.JSON(http.StatusOK, models.ErrorResponse(err.Error()))
                         return
                 }
-                categoryPortalRows, err := database.DB.Query(`SELECT c.id, c.name FROM game_categories gc JOIN categories c ON gc.category_id = c.id WHERE gc.game_id = $1`, game.ID)
+                categoryPortalRows, err := database.DB.Query(`SELECT c.id, c.name FROM game_categories gc JOIN categories c ON gc.category_id = c.id WHERE gc.game_id = $1 ORDER BY c.id;`, game.ID)
                 if err != nil {
                         c.JSON(http.StatusOK, models.ErrorResponse(err.Error()))
                         return
@@ -403,7 +403,7 @@ func FetchChapters(c *gin.Context) {
                 return
         }
         var response ChaptersResponse
-        rows, err := database.DB.Query(`SELECT c.id, c.name, g.name, c.is_disabled, c.image FROM chapters c INNER JOIN games g ON c.game_id = g.id WHERE game_id = $1`, gameID)
+        rows, err := database.DB.Query(`SELECT c.id, c.name, g.name, c.is_disabled, c.image FROM chapters c INNER JOIN games g ON c.game_id = g.id WHERE game_id = $1 ORDER BY c.id;`, gameID)
         if err != nil {
                 c.JSON(http.StatusOK, models.ErrorResponse(err.Error()))
                 return
@@ -448,7 +448,7 @@ func FetchMaps(c *gin.Context) {
                 c.JSON(http.StatusOK, models.ErrorResponse(err.Error()))
                 return
         }
-        categoryPortalRows, err := database.DB.Query(`SELECT c.id, c.name FROM game_categories gc JOIN categories c ON gc.category_id = c.id WHERE gc.game_id = $1`, gameID)
+        categoryPortalRows, err := database.DB.Query(`SELECT c.id, c.name FROM game_categories gc JOIN categories c ON gc.category_id = c.id WHERE gc.game_id = $1 ORDER BY c.id;`, gameID)
         if err != nil {
                 c.JSON(http.StatusOK, models.ErrorResponse(err.Error()))
                 return
diff --git a/frontend/src/App.tsx b/frontend/src/App.tsx
index 095cbbe..3980e1b 100644
--- a/frontend/src/App.tsx
+++ b/frontend/src/App.tsx
@@ -11,6 +11,7 @@ import Maps from './pages/Maps';
 import User from './pages/User';
 import Homepage from './pages/Homepage';
 import UploadRunDialog from './components/UploadRunDialog';
+import Rules from './pages/Rules';
 import About from './pages/About';
 import { Game } from './types/Game';
 import { API } from './api/Api';
@@ -59,6 +60,7 @@ const App: React.FC = () => {
         <Route path="/games" element={<Games games={games} />} />
         <Route path='/games/:id' element={<Maplist />}></Route>
         <Route path="/maps/*" element={<Maps profile={profile} isModerator={isModerator} onUploadRun={(mapID) => {setUploadRunDialog(true);setUploadRunDialogMapID(mapID)}} />}/>
+        <Route path="/rules" element={<Rules />} />
         <Route path="/about" element={<About />} />
         <Route path='/rankings' element={<Rankings></Rankings>}></Route>
         <Route path="*" element={"404"} />
diff --git a/frontend/src/css/Rules.css b/frontend/src/css/Rules.css
new file mode 100644
index 0000000..bbc84c0
--- /dev/null
+++ b/frontend/src/css/Rules.css
@@ -0,0 +1,3 @@
+main {
+    font-size: 24px;
+}
\ No newline at end of file
diff --git a/frontend/src/pages/Rules.tsx b/frontend/src/pages/Rules.tsx
new file mode 100644
index 0000000..516b73c
--- /dev/null
+++ b/frontend/src/pages/Rules.tsx
@@ -0,0 +1,37 @@
+import React from 'react';
+import ReactMarkdown from 'react-markdown';
+
+import '../css/Rules.css';
+
+const Rules: React.FC = () => {
+
+    const [rulesText, setRulesText] = React.useState<string>("");
+
+    React.useEffect(() => {
+        const fetchRules = async () => {
+            try {
+                const response = await fetch(
+                    'https://raw.githubusercontent.com/pektezol/leastportalshub/main/README.md'
+                );
+                if (!response.ok) {
+                    throw new Error('Failed to fetch README');
+                }
+                const rulesText = await response.text();
+                setRulesText(rulesText);
+            } catch (error) {
+                console.error('Error fetching Rules:', error);
+            }
+            setRulesText(rulesText)
+        };
+        fetchRules();
+    }, []);
+
+
+    return (
+        <main>
+            <ReactMarkdown>{rulesText}</ReactMarkdown>
+        </main>
+    );
+};
+
+export default Rules;