Main Page: Difference between revisions

← Older edit Newer edit →

Revision as of 00:15, 13 January 2026

Welcome to Esports Amaze

The Home of Indian Esports Data

🏆 Ongoing & Upcoming Tournaments

Error: The SQL function "CURRENT_DATE()" is not allowed.

🎮 Game Hubs

Battlegrounds Mobile India (BGMI)

Click to explore Players, Teams & Events

Valorant

(Coming Soon)

📊 Database Stats

     Total Matches Recorded: 87 

     Registered Users: 3

🔍 Quick Browse

     👤 All BGMI Players
     🛡️ All BGMI Teams
     🏆 Tournament Archive

📢 Socials

   Follow us for updates:
   * Instagram
   * Twitter

@@ Line 1: / Line 1: @@
-== Ongoing Tournaments ==
+<div style="text-align: center; padding: 40px 20px; background: linear-gradient(135deg, #1a1a1a 0%, #333 100%); color: white; border-radius: 12px; margin-bottom: 30px;">
-{{#cargo_query:
+  <div style="font-size: 2.5em; font-weight: bold;">Welcome to Esports Amaze</div>
-|tables=Tournaments
+  <div style="font-size: 1.2em; opacity: 0.8; margin-top: 10px;">The Home of Indian Esports Data</div>
-|fields=_pageName=Tournament, organizer=Organizer, end_date=End Date, prizepool=Prize Pool
+</div>
-|where=start_date <= NOW() AND end_date >= NOW()
-|order by=end_date ASC
-|format=table
-|headers=Tournament, Organizer, Ends On, Prize Pool
-|default=No active tournaments right now.
-}}
-== Upcoming Tournaments ==
+<div class="mp-grid">
-{{#cargo_query:
-|tables=Tournaments
-|fields=_pageName=Tournament, organizer=Organizer, start_date=Start Date, prizepool=Prize Pool
-|where=start_date > NOW()
-|order by=start_date ASC
-|limit=10
-|format=table
-|headers=Tournament, Organizer, Start Date, Prize Pool
-|default=No upcoming tournaments announced.
-}}
-== Past Tournaments ==
+  <div class="mp-column-left">
-{{#cargo_query:
-|tables=Tournaments
+    <div class="section-header">🏆 Ongoing & Upcoming Tournaments</div>
-|fields=_pageName=Tournament, organizer=Organizer, winner=Winner, prizepool=Prize Pool
+    {{#cargo_query:
-|where=end_date < NOW()
+    |tables=Tournaments
-|order by=end_date DESC
+    |fields=_pageName=Page, name, start_date, prize_pool
-|limit=10
+    |where=end_date >= CURRENT_DATE() OR end_date IS NULL
-|format=table
+    |order by=start_date ASC
-|headers=Tournament, Organizer, Winners, Prize Pool
+    |limit=5
-|default=No past tournaments recorded.
+    |format=template
-}}
+    |template=TournamentListRow
+    |intro=<table class="wikitable flat-table" style="width:100%;"><tr><th>Date</th><th>Event</th><th>Prize</th></tr>
+    |outro=</table>
+    |default=<div style="padding:15px; background:#f0f0f0; border-radius:5px;">No active tournaments found. Check back soon!</div>
+    }}
+    <br>
+    <div class="section-header">🎮 Game Hubs</div>
+    <div class="game-card">
+        <div style="font-size:1.2em; font-weight:bold;">[[BGMI|Battlegrounds Mobile India (BGMI)]]</div>
+        <div style="font-size:0.9em; opacity:0.7;">Click to explore Players, Teams & Events</div>
+    </div>
+    <div class="game-card" style="border-left-color: #ff4655;">
+        <div style="font-size:1.2em; font-weight:bold;">[[Valorant|Valorant]]</div>
+        <div style="font-size:0.9em; opacity:0.7;">(Coming Soon)</div>
+    </div>
+  </div>
+  <div class="mp-column-right">
+    <div class="section-header">📊 Database Stats</div>
+    <div style="background: #f8f9fa; padding: 15px; border-radius: 8px; border: 1px solid #ddd;">
+      '''Total Matches Recorded:''' {{NUMBEROFARTICLES}} <br>
+      '''Registered Users:''' {{NUMBEROFUSERS}}
+    </div>
+    <br>
+    <div class="section-header">🔍 Quick Browse</div>
+    <div style="display: flex; flex-direction: column; gap: 10px;">
+      [[BGMI/Players|👤 All BGMI Players]]
+      [[BGMI/Teams|🛡️ All BGMI Teams]]
+      [[BGMI/Tournaments|🏆 Tournament Archive]]
+    </div>
+    <br>
+    <div class="section-header">📢 Socials</div>
+    Follow us for updates:
+    * [https://instagram.com/yourhandle Instagram]
+    * [https://twitter.com/yourhandle Twitter]
+  </div>
+</div>