User Tools

Site Tools


Sidebar

Author

Published by Samuel Penn.

Also, see my profile for things that interest me.

Glendale Website - My main web site.

Yags - Main site for yet another game system, a generic GPL'd tabletop RPG.

Yagsbook - Documentation on the Yagsbook RPG documentation format, a Sourceforge project.

Mapcraft - Documentation on world mapping tools, another Sourceforge project.

Midnight Saga - An Ars Magica campaign.

Active Topics

The current topics are currently under active development (relatively speaking).

Yags is Another Game System - Game design notes for Yags, a Free roleplaying game system I use as the core system for most of my campaigns.

Yagsbook - Notes on an XML based documentation system I use for documenting Yags and related campaigns.

Full Thrust - Notes on Full Thrust

Stargrunt - Notes on Stargrunt.

mapcraft:database

Database Schemas

CREATE TABLE mapcraft (name CHAR(64), width INT, height INT, scale INT, shape CHAR(16), template 
CHAR(64), author CHAR(64), description CHAR(128), created TIMESTAMP);
 
CREATE TABLE X_area (id INT, name VARCHAR(128), TYPE VARCHAR(128));
 
CREATE TABLE X_terrain(id INT, name VARCHAR(32), description VARCHAR(128),
                       image VARCHAR(128), colour INT);
 
CREATE TABLE X_things(id INT, name VARCHAR(128), description text, 
                      x INT, y INT, terrain_id INT);
 
CREATE TABLE X_tiles(x INT, y INT, terrain_id INT, feature_id INT, altitude INT);
 
CREATE TABLE X_tile_area(x INT, y INT, area_id INT);
mapcraft/database.txt · Last modified: 2015/02/04 22:40 (external edit)