Difference between revisions of "UCWCE"
(Utter Chaos Web Comic Engine started) |
(Schema added) |
||
Line 25: | Line 25: | ||
==Schema== | ==Schema== | ||
− | + | Schema for the MySQL DB backend | |
+ | |||
+ | ===Comic Table=== | ||
+ | {| border=1 | ||
+ | ! cid !! date !! title !! comic_path !! Text description | ||
+ | |- | ||
+ | | 1 || 2/6/2006 || Enter the Dragon || comic20060206.png || You killed my fish! | ||
+ | |- | ||
+ | | 2 || 2/8/2006 || Exit Tiger || comic20060208.png || Why does that pickle you? | ||
+ | |} | ||
+ | |||
+ | ===News Table=== | ||
+ | {| border=1 | ||
+ | ! cid !! nid !! date !! title !! poster !! entry | ||
+ | |- | ||
+ | | 1 || 1 || 2/6/2006 15:30 EST || Enter the Dragon || Artist || Hey everyone, I posted a comic! | ||
+ | |- | ||
+ | | 1 || 2 || 2/7/2006 12:43 EST || You Suck || Writer || Pthhhpbt | ||
+ | |- | ||
+ | | 2 || 3 || 2/8/2006 00:00 EST || Exit Tiger || Artist || Waka waka | ||
+ | |- | ||
+ | | 2 || 4 || 2/9/2006 12:17 EST || Lameness || Admin || I am lame | ||
+ | |} | ||
+ | |||
+ | ===Search Table=== | ||
+ | {| border=1 | ||
+ | ! word !! weight !! type !! id | ||
+ | |- | ||
+ | | dragon || 4 || comic || 1 | ||
+ | |- | ||
+ | | dragon || 4 || news || 1 | ||
+ | |- | ||
+ | | pthhpbt || 1 || news || 2 | ||
+ | |- | ||
+ | | posted || 1 || news || 1 | ||
+ | |} |
Revision as of 22:47, 22 February 2006
Utter Chaos Web Comic Engine
Contents
Modules
Page Loader
This module creates an XHTML page from the comic template, inserts the image reference to the specified comic, fills in the archive popup menu, and current news entries. As much of this work should be done before hand as possible to make this script run quickly for each page refresh.
Database Interface
This module acts as the abstraction between our internal objects and the database backend. This will probably interface with MySQL.
Comic Uploader
This module uploads comics into the engine and updates the database with the appropriate information.
News Poster
This module is used to add news posts to the database which will be used by the page loader.
Cron Updater
This module is run on a daily basis to post comic updates at a specified time in the future.
Search
This module will run a search for keywords, new posts, and comic dialog.
File Structure
The file structure will be specified here.
Schema
Schema for the MySQL DB backend
Comic Table
cid | date | title | comic_path | Text description |
---|---|---|---|---|
1 | 2/6/2006 | Enter the Dragon | comic20060206.png | You killed my fish! |
2 | 2/8/2006 | Exit Tiger | comic20060208.png | Why does that pickle you? |
News Table
cid | nid | date | title | poster | entry |
---|---|---|---|---|---|
1 | 1 | 2/6/2006 15:30 EST | Enter the Dragon | Artist | Hey everyone, I posted a comic! |
1 | 2 | 2/7/2006 12:43 EST | You Suck | Writer | Pthhhpbt |
2 | 3 | 2/8/2006 00:00 EST | Exit Tiger | Artist | Waka waka |
2 | 4 | 2/9/2006 12:17 EST | Lameness | Admin | I am lame |
Search Table
word | weight | type | id |
---|---|---|---|
dragon | 4 | comic | 1 |
dragon | 4 | news | 1 |
pthhpbt | 1 | news | 2 |
posted | 1 | news | 1 |