Real-time games & apps synchronization across all global visitors
Connected (public.games)
Project REST Endpoint
Connected to table: public.games
Anon Public API Key
Authenticated Client Active
Supabase Database & Live Visitor Counter SQL Setup
Run this complete 1-click script in your Supabase SQL Editor to enable games publishing and activate the global real-time visitor counter table:
-- 1. Grant public read & write access to games table
ALTER TABLE public.games ENABLE ROW LEVEL SECURITY;
DROP POLICY IF EXISTS "Public Full Access" ON public.games;
CREATE POLICY "Public Full Access" ON public.games FOR ALL USING (true) WITH CHECK (true);
-- 2. Create Live Visitor Counter Table (site_stats) & allow realtime sync
CREATE TABLE IF NOT EXISTS public.site_stats (
id text PRIMARY KEY,
count bigint DEFAULT 1,
updated_at timestamptz DEFAULT timezone('utc'::text, now())
);
ALTER TABLE public.site_stats ENABLE ROW LEVEL SECURITY;
DROP POLICY IF EXISTS "Public Full Access Stats" ON public.site_stats;
CREATE POLICY "Public Full Access Stats" ON public.site_stats FOR ALL USING (true) WITH CHECK (true);
INSERT INTO public.site_stats (id, count) VALUES ('visits', 1) ON CONFLICT (id) DO NOTHING;
-- 3. Create Community Reviews & Ratings Table (reviews)
CREATE TABLE IF NOT EXISTS public.reviews (
id bigint GENERATED BY DEFAULT AS IDENTITY PRIMARY KEY,
created_at timestamptz DEFAULT timezone('utc'::text, now()),
game_id bigint NOT NULL,
user_name text NOT NULL,
rating integer DEFAULT 5,
feedback_type text DEFAULT 'review',
comment text NOT NULL
);
ALTER TABLE public.reviews ENABLE ROW LEVEL SECURITY;
DROP POLICY IF EXISTS "Public Full Access Reviews" ON public.reviews;
CREATE POLICY "Public Full Access Reviews" ON public.reviews FOR ALL USING (true) WITH CHECK (true);
-- 4. Create Community Apps Submissions Table (community_apps)
CREATE TABLE IF NOT EXISTS public.community_apps (
id bigint GENERATED BY DEFAULT AS IDENTITY PRIMARY KEY,
created_at timestamptz DEFAULT timezone('utc'::text, now()),
title text NOT NULL,
category text DEFAULT 'Game',
url text NOT NULL,
icon text,
description text,
requirements text,
developer_name text,
developer_email text,
user_id text,
status text DEFAULT 'pending',
admin_notes text
);
ALTER TABLE public.community_apps ENABLE ROW LEVEL SECURITY;
DROP POLICY IF EXISTS "Public Read Approved Community Apps" ON public.community_apps;
CREATE POLICY "Public Read Approved Community Apps" ON public.community_apps FOR SELECT USING (true);
DROP POLICY IF EXISTS "Users Submit Community Apps" ON public.community_apps;
CREATE POLICY "Users Submit Community Apps" ON public.community_apps FOR INSERT WITH CHECK (true);
DROP POLICY IF EXISTS "Admin Full Access Community Apps" ON public.community_apps;
CREATE POLICY "Admin Full Access Community Apps" ON public.community_apps FOR ALL USING (true) WITH CHECK (true);
-- 5. Create Profiles Table & Enable Row Level Security (RLS)
CREATE TABLE IF NOT EXISTS public.profiles (
id uuid PRIMARY KEY DEFAULT gen_random_uuid(),
username text UNIQUE NOT NULL,
created_at timestamptz DEFAULT timezone('utc'::text, now())
);
ALTER TABLE public.profiles ENABLE ROW LEVEL SECURITY;
DROP POLICY IF EXISTS "Public Read Profiles" ON public.profiles;
CREATE POLICY "Public Read Profiles" ON public.profiles FOR SELECT USING (true);
DROP POLICY IF EXISTS "Authenticated Users Insert Own Profile" ON public.profiles;
CREATE POLICY "Authenticated Users Insert Own Profile" ON public.profiles FOR INSERT WITH CHECK (auth.role() = 'authenticated');
DROP POLICY IF EXISTS "Users Update Own Profile" ON public.profiles;
CREATE POLICY "Users Update Own Profile" ON public.profiles FOR UPDATE USING (auth.uid() = id);
Live Visitor & Online Presence CounterPRESENCE ACTIVE
Supabase Realtime Presence tracks active online tabs/users directly in memory without database tables.
Online Now:1
Total Visits:0
Admin PIN Gate Security
Default PIN is 2026. Update to your private 4-digit code.
Discord Community Webhook
Stream visitor reviews, bug reports, and ratings directly to your Discord channel.
Adsterra & Monetag Ads DisplayToggle all monetization banners and in-page push
Store Hub Backup & Restore
Export or restore your complete catalog, reviews, admin replies, notifications, and settings as a JSON file.
Danger Zone
ADMIN SECURITY GATE
Enter authorized 4-digit PIN to enter management mode.
Invalid PIN. Redirecting...
Game Sandbox
LIVE
embedded sandbox
Launching Game Environment...
|
Creator Links Hub
Connect across official channels & personal accounts
Official Verified Accounts
Install Progressive Web App
Add to Home Screen for Fullscreen Offline Play
Community Reviews
Player feedback, ratings & bug reports
Recent Player Reviews
Community Leaderboard
Top Scores & Player Rankings
Add / Edit Social Link
Confirm Action
Are you sure you want to proceed?
Developer Sign In
Enter your username to access your dashboard, upload games & track approvals.
@developer
Verified Profile
Synced with Supabase profiles
Don't have an account?
Recent account on this device:
Developer Name
Verified Developer
developer@example.com
Total Submitted0
Pending Review0
Published0
Rejected0
Reject Submission & Send Feedback
Provide feedback so the developer can fix and resubmit their app
Submit Your App / Game / أضف لعبتك
Share your PWA or Web Game with thousands of active players
Creator Links Hub
Connect across official channels & personal accounts