cflip.net forum^beta

- diff --git a/includes/.htaccess b/includes/.htaccess new file mode 100644 index 0000000..e69de29 diff --git a/includes/db_inc.php b/includes/db_inc.php index 2d157af..7d743fc 100644 --- a/includes/db_inc.php +++ b/includes/db_inc.php @@ -2,7 +2,7 @@ $db_server = 'localhost'; $db_user = 'root'; -$db_pass = ''; +$db_pass = 'admin'; $db_database = 'forum2'; $dbc = mysqli_connect($db_server, $db_user, $db_pass, $db_database); diff --git a/includes/functions_display.php b/includes/functions_display.php index 479648f..bf9ed64 100644 --- a/includes/functions_display.php +++ b/includes/functions_display.php @@ -86,14 +86,9 @@ function add_quote($dbc, $thread_id, $matches) { } } -function display_posts($dbc, $sql_result) { - echo ''; - $post_index = 1; - $thread_id = $_GET['id']; - +function display_posts($dbc, $thread_id, $sql_result) { while ($row = mysqli_fetch_assoc($sql_result)) { - echo ''; - echo ''; + echo '#' . $row['post_id'] . ' Posted by ' . $row['user_name'] . ' on ' . date('m/d/Y g:ia', strtotime($row['post_date'])) . '
'; $post_content = $row['post_content']; @@ -110,9 +105,6 @@ function display_posts($dbc, $sql_result) { // Replace other URLs with links. $post_content = preg_replace('@\b(http(s)?://)([^\s]*?(?:\.[a-z\d?=/_-]+)+)(?![^<]*?(?:|/?>))@i', '$0', $post_content); - echo ''; - - $post_index++; + echo $post_content; } - echo '

	' . $post_index . '
Posted by ' . $row['user_name'] . ' ' . date('m/d/Y g:ia', strtotime($row['post_date'])) . '	' . $post_content . '

'; } \ No newline at end of file diff --git a/index.php b/index.php index ec81d0a..900918b 100644 --- a/index.php +++ b/index.php @@ -1,5 +1,11 @@ - -

+ + + + + cflip.net forum + + +

Welcome to the cflip.net forum!

This is the beta test of the forum website, so there are lots of features missing. Since there are no moderation features built into the website, @@ -8,44 +14,55 @@

If you notice a problem or have an idea for a feature that is missing, reply to this thread!

- +

Latest Threads View All	Latest Post
+ ' . $row['cat_name'] . ' + + ' . $row['cat_description'] . ' +	' . $row['cat_thread_count'] . '	' . $row['cat_post_count'] . '	my supercool thread by cflip, 3 days ago

More from the forum

+ + + + + + + + + + + +

Recent Posts	Recent Threads	Popular Threads
test test test test	test test test test	test test test test

+ + \ No newline at end of file diff --git a/model/Category.php b/model/Category.php new file mode 100644 index 0000000..d98b08b --- /dev/null +++ b/model/Category.php @@ -0,0 +1,36 @@ +id = $id; + $this->name = $row['cat_name']; + $this->description = $row['cat_description']; + $this->thread_count = $row['cat_thread_count']; + $this->post_count = $row['cat_post_count']; + } + } + + mysqli_free_result($result); + } + + function get_threads() { + + } +} \ No newline at end of file diff --git a/model/Thread.php b/model/Thread.php new file mode 100644 index 0000000..78d2614 --- /dev/null +++ b/model/Thread.php @@ -0,0 +1,35 @@ +id = $id; + $this->subject = $row['thread_subject']; + $this->date_created = $row['thread_date_created']; + $this->date_lastpost = $row['thread_date_lastpost']; + + $this->category = new Category(); + $this->category->get_from_database($row['thread_category'], $dbc); + } + } + } +} \ No newline at end of file diff --git a/register.php b/register.php index efa4486..c17c1dd 100644 --- a/register.php +++ b/register.php @@ -1,17 +1,20 @@ - - -

Register an account

- -
+ + + + Register an account - cflip.net forum + + +

Register an account

+ +
- -

- - + + \ No newline at end of file diff --git a/signin.php b/signin.php index 4355afe..ba8f147 100644 --- a/signin.php +++ b/signin.php @@ -1,6 +1,10 @@ - - -

+ + + + + Sign in - cflip.net forum + +

Sign in

- - \ No newline at end of file + + \ No newline at end of file diff --git a/templates/header.php b/templates/header.php new file mode 100644 index 0000000..526f63b --- /dev/null +++ b/templates/header.php @@ -0,0 +1,14 @@ +

cflip.net forum^beta

+[Home] +[All Threads] +[All Posts] +[Create a thread] + + ' . $_SESSION['user_name'] . '\'s Profile] [Log out]'; + } else { + echo 'Sign in or Register an account'; + } + ?> + \ No newline at end of file diff --git a/thread.php b/thread.php index 97ab6b9..9c43217 100644 --- a/thread.php +++ b/thread.php @@ -1,68 +1,43 @@ - - Unknown category.'; -} else { - $sql = "SELECT thread_id, thread_subject, thread_date, user_id, user_name FROM threads LEFT JOIN users ON thread_author = user_id WHERE thread_id = " . mysqli_real_escape_string($dbc, $_GET['id']); - $result = mysqli_query($dbc, $sql); - - if (!$result) { - die('Error trying to display thread page: ' . mysqli_error($dbc)); - } - - if (mysqli_num_rows($result) == 0) { - echo 'This thread does not exist'; - } else { - while ($row = mysqli_fetch_assoc($result)) { - echo '

' . $row['thread_subject'] . '

'; - echo 'Created by ' . $row['user_name'] . ' on ' . date('M d, Y', strtotime($row['thread_date'])) . '

'; - $thread_id = $row['thread_id']; - } - } - - echo ''; +include_once 'model/Thread.php'; - mysqli_free_result($result); +session_start(); - $sql = "SELECT post_id, post_content, post_date, post_author, user_id, user_name FROM posts LEFT JOIN users ON post_author = user_id WHERE post_thread = " . mysqli_real_escape_string($dbc, $_GET['id']); - $result = mysqli_query($dbc, $sql); +$current = new Thread(); - if (!$result) { - die('Error trying to display posts: ' . mysqli_error($dbc)); - } - - if (mysqli_num_rows($result) == 0) { - echo '

This thread has no posts

'; - } else { - display_posts($dbc, $result); - } - - mysqli_free_result($result); - - if (isset($_SESSION['signed_in'])) { - echo ' -

- -

Reply to this thread

- Quote a post with ># and the number above the post (example: >#7) - -
- - -

- '; - } else { - echo ' -

- Sign in to reply to this thread -

- '; - } +if (!isset($_GET['id']) || !filter_var($_GET['id'], FILTER_VALIDATE_INT)) { +} else { + $current->get_from_database($_GET['id'], $dbc); } - -include_once 'footer.php'; ?> + + + + <?php echo $current->subject; ?> - cflip.net forum + + + +

subject; ?>

+ created by user->name'; ?> + in category->name; ?> + 3 days ago +

+ This thread has no posts'; + } else { + display_posts($dbc, $_GET['id'], $result); + } + ?> + + \ No newline at end of file diff --git a/user.php b/user.php index 62b9144..a5e1d16 100644 --- a/user.php +++ b/user.php @@ -1,56 +1,38 @@ -Go home.'; -} - -if (!isset($_GET['id'])) { - nobody_is_here(); -} else { - // If this is the user's own page, show the 'options' bar - echo '

'; +session_start(); - $sql = 'SELECT user_id, user_name, user_date FROM users WHERE user_id=?'; - $stmt = mysqli_stmt_init($dbc); +$user_name = "Unknown"; +$user_date = 0; - if (!mysqli_stmt_prepare($stmt, $sql)) { - die('Could not create thread due to internal error: ' . mysqli_error($dbc)); - } - mysqli_stmt_bind_param($stmt, 'i', $_GET['id']); - mysqli_stmt_execute($stmt); - $res = mysqli_stmt_get_result($stmt); - $user = mysqli_fetch_assoc($res); - - if (!$user) { - nobody_is_here(); - } else { - echo '

'. $user['user_name'] .'

'; - echo 'Member since '. date('M d, Y', strtotime($user['user_date'])); - } - - if (isset($_SESSION['user_id']) && $_SESSION['user_id'] == $_GET['id']) { - echo '

Change Password

'; - } - - echo '

'; - - $sql = "SELECT thread_id, thread_subject, thread_date, user_id, user_name, cat_id, cat_name FROM threads JOIN users ON thread_author = user_id JOIN categories ON thread_cat = cat_id WHERE thread_author = " . $user['user_id'] . " ORDER BY thread_id DESC"; +if (!isset($_GET['name'])) { +} else { + $sql = "SELECT user_date FROM users WHERE user_name = '" . $_GET['name'] . "'"; $result = mysqli_query($dbc, $sql); if (!$result) { - die('Error trying to display threads: ' . mysqli_error($dbc)); + die('Error trying to display user page: ' . mysqli_error($dbc)); } - echo ''; - display_threads($dbc, $result, true); - mysqli_free_result($result); - echo '

' . $user['user_name'] . '\'s Threads	Latest Post

'; + if (mysqli_num_rows($result) == 0) { + $user_name = "Unknown"; + } else { + while ($row = mysqli_fetch_assoc($result)) { + $user_name = $_GET['name']; + $user_date = $row['user_date']; + } + } } ?> - - + + + + <?php echo $user_name; ?>'s Profile - cflip.net forum + + + +

+ member since + + \ No newline at end of file -- cgit v1.2.3

All Posts

name; ?>

Threads

Create a new thread

Create a new thread

cflip.net forum^beta

Welcome to the cflip.net forum!

Categories

More from the forum

Register an account

Register an account

Sign in

cflip.net forum^beta

' . $row['thread_subject'] . '

Reply to this thread

subject; ?>

'. $user['user_name'] .'

All Posts

name; ?>

Threads

Create a new thread

Create a new thread

cflip.net forumbeta

Welcome to the cflip.net forum!

Categories

More from the forum

Register an account

Register an account

Sign in

cflip.net forumbeta

' . $row['thread_subject'] . '

Reply to this thread

subject; ?>

'. $user['user_name'] .'

cflip.net forum^beta

cflip.net forum^beta