Information Architecture and feature set, part I. — OZONE Asylum, home of the Mad Scientists

This page's ID: 13151

Edit Post

Who can edit a post?	The poster and administrators may edit a post. The poster can only edit it for a short while after the initial post.

Your User Name:
Your Password:
Login Options:	Remember Me On This Computer

Your Text: Insert Slimies » Insert UBB Code » Close Last Tag \| All Tags UBB Help	I'm here for the night, the whole night, to keep some promises. About the structure, the data structure I mean, aka database: To make the search fast, make the structure easy to handle, the best, fastest, more reliable way I found (I'll explain why) is a UNIQUE tabel for controlling all the posts. With fields like: --- nodeID --- nodeParentID --- Player1ProfileID --- Player2ProfileID --- Postcontents (HTML) etc.. All the data required to let users play. This way, a simple LIKE '%PhraseToSearch%' SQL statement Retrieves all the possible matches in 1 instruction. nodeID to identify data, nodeParentID to connect a child to his father, so we have a tree. Got it? Next.. [url=http://www.wapod.com/~beta/] [img]http://www.wapod.com/~ini/newsig4.gif[/img] [/url] [This message has been edited by InI (edited 12-03-2001).] [This message has been edited by InI (edited 12-03-2001).] Loading...
Options:	Enable Slimies Enable Linkwords

Edit Post