UCWCE - Revision history

Nybble: /* Database Interface */ Added needed methods

2006-03-05T04:27:37Z

Database Interface: Added needed methods

@@ Line 8: / Line 8: @@
 ===Database Interface===
 This module acts as the abstraction between our internal objects and the database backend. This will probably interface with MySQL.
 ===Comic Uploader===

Nybble: /* File Structure */ Added base file structure

2006-03-05T04:02:05Z

File Structure: Added base file structure

← Older revision		Revision as of 04:02, 5 March 2006
Line 22:		Line 22:

	==File Structure==		==File Structure==
	~~The file structure will be specified here~~.
			; Comic image files : /comics/comic${cid}.foo
			; Icons files : /icons/*
			; Skins : /skins/${skin_name}/
			; Templates : /skins/${skin_name}/templates/*
			; PHP Script include files : /include/*

	==Schema==		==Schema==

Nybble: /* Schema */ More revisions

2006-02-26T05:14:07Z

Schema: More revisions

@@ Line 35: / Line 35: @@
 | 2 || 2 || 2/8/2006 || Exit Tiger || comic20060208.png || 1 || Why does that pickle you? || working
 |}
-Indexed by cid, Full Text on title, Full Text on description, or Chapter.
+This table contains all the information for a specific comic on a row.
-Sorted by Date or Page
+* The cid is a unique serial number for each comic that will never change no matter how much reordering of pages occurs.
 ===News Table===
 {| border=1
-! cid !! nid !! date !! title !! poster !! entry !! status
+! nid !! date !! title !! poster !! entry !! status
 |-
-| 1 || 1 || 2/6/2006 15:30 EST || Enter the Dragon || Artist || Hey everyone, I posted a comic! || live
+| 1 || 1
 |-
-| 1 || 2 || 2/7/2006 12:43 EST || You Suck || Writer || Pthhhpbt || live
+| 1 || 2
 |-
-| 2 || 3 || 2/8/2006 00:00 EST || Exit Tiger || Artist || Waka waka || working
+| 2 || 3
 |-
-| 2 || 4 || 2/9/2006 12:17 EST || Lameness || Admin || I am lame || working
+| 2 || 4
 |}
 ===Chapter Table===

Nybble: Minor modifications to schema

2006-02-25T06:54:23Z

Minor modifications to schema

← Older revision		Revision as of 06:54, 25 February 2006
Line 29:		Line 29:
	===Comic Table===		===Comic Table===
	{\| border=1		{\| border=1
	! cid !! date !! title !! comic_path !! Text description		! cid !! page !! date !! title !! comic_path !! Chapter !! Text description !! Status
	\|-		\|-
	\| 1 \|\| 2/6/2006 \|\| Enter the Dragon \|\| comic20060206.png \|\| You killed my fish!		\| 1 \|\| 1 \|\| 2/6/2006 \|\| Enter the Dragon \|\| comic20060206.png \|\| 1 \|\| You killed my fish! \|\| live
	\|-		\|-
	\| 2 \|\| 2/8/2006 \|\| Exit Tiger \|\| comic20060208.png \|\| Why does that pickle you?		\| 2 \|\| 2 \|\| 2/8/2006 \|\| Exit Tiger \|\| comic20060208.png \|\| 1 \|\| Why does that pickle you? \|\| working
	\|}		\|}
			Indexed by cid, Full Text on title, Full Text on description, or Chapter.
			Sorted by Date or Page

	===News Table===		===News Table===
	{\| border=1		{\| border=1
	! cid !! nid !! date !! title !! poster !! entry		! cid !! nid !! date !! title !! poster !! entry !! status
	\|-		\|-
	\| 1 \|\| 1 \|\| 2/6/2006 15:30 EST \|\| Enter the Dragon \|\| Artist \|\| Hey everyone, I posted a comic!		\| 1 \|\| 1 \|\| 2/6/2006 15:30 EST \|\| Enter the Dragon \|\| Artist \|\| Hey everyone, I posted a comic! \|\| live
	\|-		\|-
	\| 1 \|\| 2 \|\| 2/7/2006 12:43 EST \|\| You Suck \|\| Writer \|\| Pthhhpbt		\| 1 \|\| 2 \|\| 2/7/2006 12:43 EST \|\| You Suck \|\| Writer \|\| Pthhhpbt \|\| live
	\|-		\|-
	\| 2 \|\| 3 \|\| 2/8/2006 00:00 EST \|\| Exit Tiger \|\| Artist \|\| Waka waka		\| 2 \|\| 3 \|\| 2/8/2006 00:00 EST \|\| Exit Tiger \|\| Artist \|\| Waka waka \|\| working
	\|-		\|-
	\| 2 \|\| 4 \|\| 2/9/2006 12:17 EST \|\| Lameness \|\| Admin \|\| I am lame		\| 2 \|\| 4 \|\| 2/9/2006 12:17 EST \|\| Lameness \|\| Admin \|\| I am lame \|\| working
	\|}

	~~===Search Table===~~
	{\| ~~border=1~~
	~~! word !! weight !! type !! id~~
	\|-
	~~\| dragon \|\| 4 \|\| comic \|\| 1~~
	\|-
	~~\| dragon \|\| 4 \|\| news \|\| 1~~
	\|-
	~~\| pthhpbt \|\| 1 \|\| news \|\| 2~~
	\|-
	~~\| posted \|\| 1 \|\| news \|\| 1~~
	\|}		\|}

	===Chapter Table===		===Chapter Table===
	{\| border=1		{\| border=1
	! chapter !! title !! ~~start~~ !! ~~end~~		! chapter !! title !! book !! status
	\|-		\|-
	\| 1 \|\| Crash \|\| 1 \|\| 25		\| 1 \|\| Crash \|\| 1 \|\| live
	\|-		\|-
	\| 2 \|\| Crashier \|\| 26 \|\| 42		\| 2 \|\| Crashier \|\| 1 \|\| working
	\|}		\|}

	===Book Table===		===Book Table===
	{\| border=1		{\| border=1
	! book !! title !! ~~start !! end~~		! book !! title !! status
	\|-		\|-
	\| 1 \|\| Start! \|\| ~~1 \|\| 5~~		\| 1 \|\| Start! \|\| live
	\|-		\|-
	\| 2 \|\| Downward \|\| ~~6 \|\| 7~~		\| 2 \|\| Downward \|\| working
	\|}		\|}

Nybble: More schema

2006-02-23T03:06:21Z

More schema

@@ Line 60: / Line 60: @@
 |-
 | posted || 1 || news || 1
 |}

Nybble: Schema added

2006-02-23T02:47:06Z

Schema added

← Older revision		Revision as of 02:47, 23 February 2006
Line 25:		Line 25:

	==Schema==		==Schema==
	~~The database schema will be specified here~~.		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
			\|}

Nybble: Utter Chaos Web Comic Engine started

2006-02-21T04:53:02Z

Utter Chaos Web Comic Engine started

New page

Utter Chaos Web Comic Engine

==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==
The database schema will be specified here.