Create an account

or log in:



I forgot my password


Path

8. fair call

7. still using different code

6. avoid perl

5. yep

4. editor level tier

3. Quality Control?

2. Stopped Visiting This Site Due

1. The Forum

fair call

avatar on 2014-03-06 02:33:48

816 hits, 1 views, 0 upvotes.

Return to Parent Episode
Jump to child episodes
Jump to comments

Yup, makes sense.

My recommendation is focus on the login script last, create a story handler first.

For handling stories, I don tknow what structure you want, but the approach I was going to take was simply to have each episode store it's details as expected (authorID as opposed to a name/email, so you could relate this to the users table), as well as it's parent ID.

That way, all you need to do to find children is simply to do a search on the "parent ID" table using the current episode ID as the parent ID to relate, and then sort by the date (store date as Unix_time and apply time conversions later, it'll make sorting A LOT easier for you!)

Handle anything fancier like styles and logins last, build your foundation before you build your walls and roof :)

A demonstration of the data handling method I wanted to use (not exactly mine, but is SQL compatible and the diagram demonstrates what I'm on about) is here:

http://stackoverflow.com/questions/13585460/sql-tree-traversal-down-to-the-root-and-back-up-one




Please consider donating to keep the site running:

Donate using Cash

Donate Bitcoin