* My eye catched a typo and I had to fix that...

* Temporary removed webboard.php as agreed upon.  If we ever make a
  new webboard, the code is likely to be incorporated into
  discussion.php.

* Fixed the *mumble*bug*mumble*

* Just a quick test

* Fixed 2 small bugs in submit.php reported by Pepijn (kangaroot.net).

Updates:
--------

* URI/URL enhancements to make the URLs more comprehensive and shorter.
* Fixed a bug in submit.php that slipped in during the latest commit.
* Changed a few tidbits on the calendar.
* Fixed a bug in most themes:
    $tid       --> $cid
    COUNT(tid) --> COUNT(cid)
  Updated most themes except for UnConeD's.
* Fixed a handful of problems with Jeroen's theme.  However, Jeroen's
  theme is still not working yet - some features are completly missing,
  making the theme not very useful ...

Any known bugs left?  If not, I'll head on tonight and add some new
features.  I'll probably add basic admin tools to edit articles and
such.  Once done, we can start on the comment moderation.

Bugfixes:
  (1) fixed SQL bug in search.php.
  (2) fixed SQL bug in discussion.php.
  (3) fixed theme-bug in submit.php.
  (4) fixed theme-bug in discussion.php.
  (5) fixed Dries2-theme: it more or less works now though
      I still have to change the look/layout.

Important:
  (3) and (4) did fix the i-suddenly-seem-to-log-out behavior.

* Updated small tidbits ... :)

* 2 small bugfixes
* I'll try to update my 2nd theme later this weekend

-- Dries

 * 2 bugfixes to discussion.php and themes/Dries/theme.class.php.
 * Added a 'disclaimer' and 'terms and conditions' to the FAQ.

* discussion.php replaces both article.php and comments.php

* _Major_ update of the comments and moderation system: it's a lot more
  stream-lined and more compact.  There are a few parts I like to optimize
  prior to heading towards comment moderation.

  Please test, report bugs and update the footer()-part of your themes a
  bit (see my theme)!!!


-- Dries

* Added more and better error checking which should fix 'potential'
  bugs or weird behavior in case something goes wrong.  We aim for
  something that is rock-solid, right? :-)

* Update: improved error checking/handling.

* Fixed at least 5 bugs!!! :)

* Yet another bugfix (hopefully).

* Updated the FAQ: added new stuff.

* Small bugfixes and minor updates.

* Bugfixes:
   - the stories in the submission queue should not be accesible.
   - the author-field is redundant due to the public moderation.

* Fixed yet another quote problem...

* Fixed a bug in submission.inc and a minor glitch in my theme.

* Adjusted calendar to scale well in IE at 800x600!
* <chit-chat>
   UnConeD: - what about integrating it in your theme now?
            - how was your last exam, btw?
   Natrak : - did you arrived well?
   Jeroen : - how was your *cough*blind date*cough*?
  </chit-chat>

* Small bugfix from Ekeren - Dries
  (hopefully it works)

* Small, quick and dry bugfix.

* Small bugfix for `Display mode'.

* Various small bugfixes and enhancements: I think I fixed all bugs I
  knew about.
* The code generated by my theme `Dries' is now 90% of the time
  aligned correctly. :o)

* A fix related to the comment system - one of the settings is now
  truncated.

in the pipe and no drop will leak out of it.

* Commited a *temporary* version of the new comment system: I have been
  working on it for about 4 a 5 hours today and I considered it would be
  smart (backup- or crash-wise) to commit what I have made so far.  I'm
  aware of a few bugs and I'll keep workin on it:
    - removing bugs
    - clean up the code to make it very streamlined
    - improve error checking
  Once we got a stable comment system, I'll add moderation.  But right
  now I want to sort out the major problems.
* I made my theme the default theme until the other themes are updated.
* Expanded the database abstraction layer with more goodies.

* Updated SQL table listing (for those who care).

* Removed 2 redundant files from the CVS repository. :-)

* patch: search.php now uses the new SQL tables.

* Added extra PHP variables to .htaccess as discussed earlier this week.

* Integrated the database abstraction layer into the account pages.  One
  reason for doing so is because the database abstraction layer provides
  build-in error checking and a debug mode for easy development.

* Fixed a small bugs, integrated the database abstraction layer and
  shortened the code.

IMPORANT - IMPORTANT - :)
=========================

Wulp.  I did a major upgrade by (a) breaking a lot of stuff and (b) by
re-doing those things in a much better way.  I redesigned the stories
and submissions SQL tables, the way they work and the way they co-
operate together.

In addition, I changed the way parameters are passed to
$theme->abstract() and $theme->article().  Instead of passing a
sh!tload of parameters that only cluttered the code and required too
much pre-processing on the engine-side, we now pass a singly object
$story.  $story has more variables then the paramaters we used to pass,
so it allows for better theming (if you feel like it).

I'm not finished yet but I decided to upload my changes so you can
start patching and updating your themes: PLEASE update your themes
ASAP!  I don't plan making heavy changes like this again, so don't
get intimiated. ;)  You mainly have to update article() and abstract()
as well as a minor update of footer():

article(), abstract():
----------------------
 - use the $story object - see my theme!
 - the morelink can now be themed.  Currently you can use the function
   morelink_bytes() in function.inc to `render' the old morelink.  The
   idea is to make a morelink_words() or morelink_lines() sooner or
   later because "188 bytes in body" is not half as clear as "52 words
   in body".  Clearly, "52 words" is much more informative. ;-)

footer():
---------
 - in the article-part, you need to update the displayRelatedLinks():
   instead of passing it $sid, you need to pass it $story (after you
   globaled $story).

Everything should display correct on the following pages:
 - main page
 - article page (follow a `read more | xxx bytes in bdoy | x comments' link)
 - submission queue
Check if they work with your theme: they should as they work fine for
me (theme `Dries') ...  If you got stuck, just look at my theme or ask
for a hand on the list!


Hopefully you can update your themes asap.  Thanks in advance.

Wheep! Wheep! Major performance optimization for index.php: we reduced the
number of SQL on the mainpage with factor 10 and shortened the code with 4
lines.  There is only *one* optimized SQL query left, being:

$result = db_query("SELECT stories.*, COUNT(comments.sid) AS comments FROM
stories LEFT JOIN comments ON stories.sid = comments.sid WHERE
stories.status = 1 AND stories.time <= $date GROUP BY stories.sid ORDER BY
stories.sid DESC LIMIT $number");

 Note: we use a LEFT JOIN to retrieve the number of comments associated
       with each story.  By retrieving this data now, we elimate a *lot*
       of individual queries that would otherwise be required inside the
       while-loop.  If there is no matching record for the right table in
       the ON-part of the LEFT JOIN, a row with all columns set to NULL
       is used for the right table.  This is required, as not every story
       has a counterpart in the comments table (at a given time).

* Small bugfix. ;-)