Skip to content

Database Query Layer

Brendan Walker edited this page Jul 1, 2014 · 1 revision

Overview

AccountQueries

  • CreateAccount
  • CreateAccountNoEmailVerify
  • VerifyUsernameAvailable
  • VerifiedEmailAddress
  • VerifyCredentials
  • GetAccountOpsLevel
  • SetAccountOpsLevel
  • CreateNonDeterministicRandomString
  • CreateRandomSalt
  • SaltAndHashPassword
  • ClientPasswordHash

CharacterQueries

  • CreateCharacter
  • DeleteCharacter
  • GetGameCharacterList
  • GetFullCharacterState
  • GetAccountCharacterList
  • GetCharacterIDList
  • GetPlayers
  • GetPlayer
  • UpdatePlayer
  • GetCharacterName
  • GetCharacterNewEventFlag
  • GetCharacterGameId
  • GetCharacterLastPingTime
  • GetCharacterEmail
  • GetCharacterPosition
  • GetCharacterEnergy
  • UpdateCharacterPosition
  • UpdateCharacterEnergy
  • UpdateCharacterLastPingTime
  • ClearCharacterNewEventFlag
  • GetCharacterLastEventId
  • UpdateCharacterLastEventId

ConfigQueries

  • InitializeConfig
  • GetDatabaseVersion
  • UpgradeDatabase
  • SetDatabaseVersion

EnergyTankQueries

  • GetEnergyTanks
  • GetEnergyTank
  • UpdateEnergyTank
  • UpdateEnergyTankEnergy
  • UpdateEnergyTankOwnership

GameEventQueries

  • AddEvent
  • GetGameEventsAfterId
  • GetLastGameEvent
  • DeleteAllEventsForGame

GameQueries

  • CreateGame
  • DeleteGame
  • GetGameList
  • GetCharacterNamesInGame
  • GetGameName
  • GetGameIRCDetails
  • BindCharacterToGame
  • UnBindCharacterFromGame
  • VerifyGameExists
  • VerifyAccountOwnsGame

MobQueries

  • LoadMobTypes
  • LoadMobSpawnTables
  • GetMobSpawners
  • UpdateMobSpawner
  • InsertMobs
  • UpdateMob
  • GetMobs
  • GetMob

WorldQueries

  • GetWorldGenerationParameters
  • DoesRoomExist
  • GetRoomPortals
  • GetRoomRandomSeed
  • GetPortal
  • GetRoomStaticData
  • InsertWorld
  • LoadRoomTemplates

High Level

Folder Organization

Game Design

Game Objective

Player Classes

Enemy Types

Loot

Web Server Documentation

Server Project Organization - How the files in the server project are arranged

Mob Types - Format for the mob type definitions

Room Templates - How the room templates are validated and stored in the DB

Navigation - How AI navigation is computed on the server

AI Decision Making - How AIs make decisions in response to players moves

Request Processors - How incoming JSON requests are processed

Database Query Layer - How database queries are structured and cached

Standalone And Embedded Web Server - How the stand alone and client embedded web server are structured

ASPX Web Service - How the IIS hosted web server is structured

Unity Client Documentation

Client Project Organization - How the files in the client project are arranged

UI System - Wrapper around Unity immediate mode UI and UI event handling

Asynchronous Request System - How JSON requests are sent to the web server

Game Event System - How the game state changes as a result of player actions

AI Path Finding and Steering - How the AI compute a path and drive toward path waypoints

IRC and Push Notifications - How chat and server push notifications are routed through IRC

Tools Documentation

OGMO Tile Editor

Verification Scripts

Build Scripts

Clone this wiki locally