Register to post in forums, or Log in to your existing account
 

Play RetroMUD
Post new topic  Reply to topic     Home » Forums » CMUD General Discussion
skyy
Newbie


Joined: 17 Mar 2016
Posts: 2

PostPosted: Thu Mar 17, 2016 5:02 am   

What is the format of the CMUD mapper file?
 
Is there a spec that describes the format of the CMUD mapper file? I would like to export it and import into a different database type so I can use with a web interface.
Reply with quote
Daern
Sorcerer


Joined: 15 Apr 2011
Posts: 809

PostPosted: Thu Mar 17, 2016 11:57 pm   
 
It's a standard SQLite 3 format. If you mean documentation on the structure of the actual tables, that doesn't exist as far as I know, but if you poke around it's all pretty self-explanatory from what I remember.
Reply with quote
skyy
Newbie


Joined: 17 Mar 2016
Posts: 2

PostPosted: Fri Mar 18, 2016 5:38 am   
 
I found the table specs in case anyone else is looking for them:

CREATE TABLE IconTbl ([IconId] INTEGER PRIMARY KEY,[Bitmap] BLOB,[Filename] VARCHAR(255),[UID1] INTEGER DEFAULT 0,[UID2] INTEGER DEFAULT 0,[UserID] INTEGER DEFAULT 0,[Modified] TIMESTAMP)
CREATE TABLE ZoneTbl ([ZoneId] INTEGER PRIMARY KEY,[Name] VARCHAR(80),[ZoneFile] VARCHAR(80),[UserID] INTEGER DEFAULT 0,[Modified] TIMESTAMP,[Script] TEXT,[Desc] TEXT,[X] INTEGER DEFAULT 0,[Y] INTEGER DEFAULT 0,[Z] INTEGER DEFAULT 0,[Dx] INTEGER DEFAULT 0,[Dy] INTEGER DEFAULT 0,[MinX] INTEGER DEFAULT 0,[MinY] INTEGER DEFAULT 0,[MinZ] INTEGER DEFAULT 0,[MaxX] INTEGER DEFAULT 0,[MaxY] INTEGER DEFAULT 0,[MaxZ] INTEGER DEFAULT 0,[Background] VARCHAR(80),[XScale] INTEGER DEFAULT 0,[YScale] INTEGER DEFAULT 0,[XOffset] INTEGER DEFAULT 0,[YOffset] INTEGER DEFAULT 0,[Divisor] INTEGER DEFAULT 1,[Multiplier] INTEGER DEFAULT 1,[DefSize] INTEGER DEFAULT 0,[DefSizeY] INTEGER DEFAULT 0,[Res] INTEGER DEFAULT 0,[Color] INTEGER DEFAULT 536870911,[GridXInc] INTEGER DEFAULT 120,[GridYInc] INTEGER DEFAULT 120,[GridXOff] INTEGER DEFAULT 0,[GridYOff] INTEGER DEFAULT 0,[GridCol] INTEGER DEFAULT 0,[Flags] INTEGER DEFAULT 0,[Parent] INTEGER DEFAULT -1)
CREATE TABLE MetaTbl ([MetaId] INTEGER PRIMARY KEY,[X] INTEGER DEFAULT 0,[Y] INTEGER DEFAULT 0,[Z] INTEGER DEFAULT 0,[Dx] INTEGER DEFAULT 0,[Dy] INTEGER DEFAULT 0,[Label] VARCHAR(255),[DrawData] BLOB,[HasData] BOOLEAN DEFAULT False,[Ref] INTEGER DEFAULT 0,[UID1] INTEGER DEFAULT 0,[UID2] INTEGER DEFAULT 0,[IconID] INTEGER DEFAULT -1,[ZoneID] INTEGER DEFAULT -1,[Color] INTEGER DEFAULT 536870911,[Flags] INTEGER DEFAULT 0,[ParentID] INTEGER DEFAULT -1,[UserID] INTEGER DEFAULT 0,[Modified] TIMESTAMP)
CREATE TABLE KindTbl ([KindId] INTEGER PRIMARY KEY,[Name] VARCHAR(80),[Desc] VARCHAR(255),[IconID] INTEGER DEFAULT -1,[Color] INTEGER DEFAULT 536870911,[MetaID] INTEGER DEFAULT -1,[Dx] INTEGER DEFAULT 0,[Dy] INTEGER DEFAULT 0,[Ref] INTEGER DEFAULT 0,[Flags] INTEGER DEFAULT 0,[Script] TEXT,[UserID] INTEGER DEFAULT 0,[StyleID] INTEGER DEFAULT 0,[ParentID] INTEGER DEFAULT -1,[DrawDef] BOOLEAN DEFAULT True,[Pen] INTEGER DEFAULT 0,[Modified] TIMESTAMP)
CREATE TABLE ObjectTbl ([ObjId] INTEGER PRIMARY KEY,[Name] VARCHAR(255),[IDName] VARCHAR(255),[Hint] VARCHAR(255),[Desc] TEXT,[KindID] INTEGER DEFAULT 0,[IconID] INTEGER DEFAULT -1,[RefNum] INTEGER DEFAULT 0,[fKey] INTEGER DEFAULT 0,[X] INTEGER DEFAULT 0,[Y] INTEGER DEFAULT 0,[Z] INTEGER DEFAULT 0,[Dx] INTEGER DEFAULT 0,[Dy] INTEGER DEFAULT 0,[ExitX] INTEGER DEFAULT 0,[ExitY] INTEGER DEFAULT 0,[ExitZ] INTEGER DEFAULT 0,[Cost] INTEGER DEFAULT 0,[Color] INTEGER DEFAULT 536870911,[MetaID] INTEGER DEFAULT -1,[StyleID] INTEGER DEFAULT 0,[LabelDir] INTEGER DEFAULT 11,[Enabled] BOOLEAN DEFAULT True,[Script] TEXT,[Param] VARCHAR(80),[UserStr] VARCHAR(255),[UserInt] INTEGER DEFAULT 0,[Content] TEXT,[Flags] INTEGER DEFAULT 0,[Deleted] BOOLEAN DEFAULT False,[UserID] INTEGER DEFAULT 0,[Modified] TIMESTAMP,[DateAdded] TIMESTAMP,[ServerID] INTEGER DEFAULT -1,[ZoneID] INTEGER DEFAULT 1)
CREATE TABLE ExitKindTbl ([ExitKindId] INTEGER PRIMARY KEY,[Name] VARCHAR(80),[Desc] VARCHAR(255),[Script] TEXT,[Style] INTEGER DEFAULT 0,[Color] INTEGER DEFAULT 536870911,[InnerWidth] INTEGER DEFAULT 0,[InnerColor] INTEGER DEFAULT 536870911,[FillColor] INTEGER DEFAULT 536870911,[DoorColor] INTEGER DEFAULT 536870911,[Flags] INTEGER DEFAULT 0,[Dx] INTEGER DEFAULT 0,[MetaID] INTEGER DEFAULT -1,[IconID] INTEGER DEFAULT -1,[UserID] INTEGER DEFAULT 0,[ParentID] INTEGER DEFAULT -1,[DrawDef] BOOLEAN DEFAULT True,[Modified] TIMESTAMP)
CREATE TABLE NoteTbl ([NoteId] INTEGER PRIMARY KEY,[ObjID] INTEGER DEFAULT -1,[Note] TEXT,[Category] INTEGER DEFAULT 0,[Flags] INTEGER DEFAULT 0,[UserID] INTEGER DEFAULT 0,[Deleted] BOOLEAN DEFAULT False,[Modified] TIMESTAMP)
CREATE TABLE StyleTbl ([StyleId] INTEGER PRIMARY KEY,[Name] VARCHAR(80),[ParentID] INTEGER DEFAULT -1,[FontName] VARCHAR(80),[FontSize] INTEGER DEFAULT 10,[FontStyle] INTEGER DEFAULT 0,[Color] INTEGER DEFAULT 536870911,[Color2] INTEGER DEFAULT 536870911,[Flags] INTEGER DEFAULT 0,[UserID] INTEGER DEFAULT 0,[Modified] TIMESTAMP)
CREATE TABLE ExitTbl ([ExitId] INTEGER PRIMARY KEY,[ExitIdTo] INTEGER DEFAULT -1,[FromID] INTEGER DEFAULT -1,[ToID] INTEGER DEFAULT -1,[ExitKindID] INTEGER DEFAULT 0,[Name] VARCHAR(80),[Param] VARCHAR(80),[Label] VARCHAR(80),[X0] INTEGER DEFAULT 0,[Y0] INTEGER DEFAULT 0,[Z0] INTEGER DEFAULT 0,[X1] INTEGER DEFAULT 0,[Y1] INTEGER DEFAULT 0,[Z1] INTEGER DEFAULT 0,[Distance] INTEGER DEFAULT 0,[Script] TEXT,[Color] INTEGER DEFAULT 536870911,[MetaID] INTEGER DEFAULT -1,[DrawRev] BOOLEAN DEFAULT False,[DirType] INTEGER DEFAULT 0,[DirToType] INTEGER DEFAULT 0,[Tested] BOOLEAN DEFAULT True,[Flags] INTEGER DEFAULT 0,[UserID] INTEGER DEFAULT 0,[Modified] TIMESTAMP)
CREATE TABLE FavTbl ([FavId] INTEGER PRIMARY KEY,[Name] VARCHAR(80),[KindID] INTEGER DEFAULT -1,[ParentID] INTEGER DEFAULT -1,[ObjID] INTEGER DEFAULT -1)
CREATE TABLE DrawTbl ([DrawId] INTEGER PRIMARY KEY,[X] INTEGER DEFAULT 0,[Y] INTEGER DEFAULT 0,[Z] INTEGER DEFAULT 0,[Dx] INTEGER DEFAULT 0,[Dy] INTEGER DEFAULT 0,[Name] VARCHAR(255),[Hint] VARCHAR(255),[MetaID] INTEGER DEFAULT -1,[StyleID] INTEGER DEFAULT 0,[ZoneID] INTEGER DEFAULT -1,[Flags] INTEGER DEFAULT 0,[UserID] INTEGER DEFAULT 0,[Modified] TIMESTAMP)
CREATE TABLE VersTbl ([VersId] INTEGER PRIMARY KEY,[VersNum] INTEGER DEFAULT 0,[IconID] INTEGER DEFAULT 1,[MetaID] INTEGER DEFAULT 1,[DrawID] INTEGER DEFAULT 1,[KindID] INTEGER DEFAULT 1,[FavID] INTEGER DEFAULT 1,[ZoneID] INTEGER DEFAULT 1,[ObjID] INTEGER DEFAULT 1,[ExitKindID] INTEGER DEFAULT 1,[NoteID] INTEGER DEFAULT 1,[StyleID] INTEGER DEFAULT 1,[ExitID] INTEGER DEFAULT 1,[PortalID] INTEGER DEFAULT 1,[DirID] INTEGER DEFAULT 1)
CREATE TABLE DirTbl ([DirId] INTEGER PRIMARY KEY,[DirName] VARCHAR(80),[DirRef] INTEGER DEFAULT 0,[RevId] INTEGER DEFAULT 0,[Dx] INTEGER DEFAULT 0,[Dy] INTEGER DEFAULT 0,[Dz] INTEGER DEFAULT 0)
CREATE TABLE PortalTbl ([PortalId] INTEGER PRIMARY KEY,[ToID] INTEGER DEFAULT 0,[Cost] INTEGER DEFAULT 0,[ZoneID] INTEGER DEFAULT -1,[Name] VARCHAR(255),[Flags] INTEGER DEFAULT 0,[Enable] BOOLEAN DEFAULT True,[Modified] TIMESTAMP)
Reply with quote
Display posts from previous:   
Post new topic   Reply to topic     Home » Forums » CMUD General Discussion All times are GMT
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum

© 2009 Zugg Software. Hosted by Wolfpaw.net