Mothership Game Developer Portal
Connect your standalone games to the Snappy Idioms ecosystem
Unified Economy
One pearl balance across all games
Offline-First
Retry queue handles network issues
Anti-Farming
Database-level duplicate prevention
Step 1: Database Setup
Run this SQL in your Supabase SQL Editor (Settings → SQL Editor)
-- Mothership SQL Setup for Supabase -- Run this in Supabase SQL Editor (Settings → SQL Editor) -- 1. Add unique constraint to prevent reward farming ALTER TABLE "TransactionHistory" ADD CONSTRAINT unique_level_completion UNIQUE (user_email, game_id, level_id); -- 2. Add index for nonce lookups (replay attack prevention) CREATE INDEX IF NOT EXISTS idx_transaction_nonce ON "TransactionHistory" (request_signature); -- 3. Verify the constraint is active SELECT conname AS constraint_name, contype AS constraint_type, conrelid::regclass AS table_name FROM pg_constraint WHERE conname = 'unique_level_completion';
What this does: Adds a UNIQUE constraint on (user_email, game_id, level_id) to prevent users from claiming rewards multiple times for the same level.
Step 2: Generate Your Secret Key
This key signs your API requests. Keep it secure!
⚠️ Never commit this to GitHub! Store it in environment variables.
Step 3: Register Your Game
Add your game to the GameDeveloper entity in Base44
Game ID:
word_up_01
Game Name:
Word Up!
Base Pearl Rate:
5 pearls/win
Status:
Active