Ariadne
ATutor
AWF
Bit 5 Blog
Bricolage
Drupal
eGroupWare
eZ publish
Greymatter
JS Calendar
linPHA
Mambo
Magellan
MMBase
News-Maniac
OpenACS
OpenDocMan
Owl
Philex
Phorum
phPay
phpBB
phpGedView
PHP Layers
phpMyAdmin
PHP Nuke
phpOpenTracker
Postnuke
Serendipity
Sitebar
Slashcode
Tikiwiki
TWiki
Typo3
Xaraya
XOOPS
Zina
Home page: slashcode.com
Version: 2.2.6
License: GPL
Implementation: Perl (mod_perl), MySQL
Status: Downloaded.
Description: Website toolkit, used to post stories and comments on them. Stories may be grouped into sections. Sections may have polls. Comments are moderated (rated, voted on). Provides user logins and user preferences.
Reference Sites: Slashdot
abusers: [abuser_id, host_name, pagename, ts, reason, querystring]: log of users who try to beat post limit.
accesslog: [id, host_addr, op, dat, uid, ts, query_string]: page access log info (delayed).
blocks: [bid, block, seclev, type, description, section, ordernum, title, portal, url, rdf, retrieve]: holder for content, usually pulled from remote sites via portald (if portal == true).
code_param: [param_id, type, code, name]: codes abstraction.
commentmodes: [mode, name, description]: how comments appear: flat, nested, threaded, no comments.
comments/newcomments: [sid, cid, pid, date, host_name, subject, comment, uid, points, lastmod, reason]: comments to stories (sid).
dateformats: [id, format, description]: choice of date/time formats, per cftime(3).
content_filters: [filter_id, regex, modifier, field, ratio, minimum_match, minimum_length, err_message]: filters for error checking forms, e.g. comments.
discussions: [sid, title, url]:
formkeys: [formkey, formname, id, uid, host_name, value, cid, ts, submit_ts, content_length]: used to issue unique formkeys to make it difficult to resubmit form values.
menus: [id, menu, label, value, seclev, menuorder]: menu items.
metamodlog: [id, mmid, val, ts, flag]: logs meta-moderations.
moderatorlog: [id, uid, val, sid, ts, cid, reason, active]: when, why, who moderated something.
pollanswers: [qid, aid, answer, votes]: poll question id, answer, votes.
pollquestions: [qid, question, voters, date]: poll questions.
pollvoters: [qid, id, time]:
postmodes: [code, name]: plaintext, html, exttrans.
sections: [section, artcount, title, qid, isolate, issue, issue, extras]: primary sections.
sessions: [session, uid, logintime, lasttime, lasttitle]: users logged in.
site_info: [param_id, name, value, description]: set of values set at install time.
sortcodes: [code, name]: sort codes: oldest first, newest first, highest scores first, oldest first (ignore threads), newest first (ignore threads).
statuscodes: [code, name]: refreshing, normal, archive: controls frequency slashd rewrites static pages.
stories/newstories: [sid, tid, uid, commentcount, title, dept, time, introtext, bodytext, writestatus, hits, section, displaystatus, commentstatus, hitparade, relatedtext, extratext]: stories. newstories is a cache of current stories, determined by archive_delay.
storiestuff: [sid, hits]: hit count per story.
submissions: [subid, email, name, time, subj, story, tid, note, section, comment, uid, del]: submitted, but unapproved, stories.
templates: [tpid, name, page, section]: templates for site look and feel.
topics: [tid, image, alttext, tagwidth]: topics, each with icon and image info.
tzcodes: [tz, offset, description]: timezone info.
users: [uid, nickname, realemail, fakeemail, homepage, passwd, sig, seclev, matchname, newpasswd]: user identify/password.
users_info: [uid, realname, bio, totalmods, tokens, lastgranted, karma, maillist, totalcomments, lastmm, lastaccess, lastmmid, m2fair, m2unfair, m2fairvotes, m2unfairvotes, upmods, downmods, session_login]: user information, including moderations/comments stats.
users_comments: [uid, points, posttype, defaultpoints, highlightthresh, maxcommentsize, hardthresh, clbig, clsmall, reparent, nosigs, commentspill, commentsort, commentlimit, noscores, mode, threshold]: user info relating to display of comments.
users_index: [uid, extid, exaid, exsect, exboxes, maxstories, noboxes]: user info relating to index/article page display.
users_param: [param_id, uid, name, value]: key/value pairs relating to users.
users_prefs: [uid, willing, dfid, tzcode, noicons, light, mylinks, lang]: user info used site-wide, infrequently changed: willing to moderate, date format, time zone, icons, light mode, personal links, language.
vars: [name, value, description]: sitewide variables.
Can be customized, but not sure how this works. Template table associates template names with pages, but template contents appear to be external. Blocks are mostly limited to RDF/RSS readers.
User customization (under preferences) can set for language, date/time formats, timezone.