Stories
Slash Boxes
Comments

Slash Open Source Project

This discussion has been archived. No new comments can be posted.
The Fine Print: The following comments are owned by whoever posted them. We are not responsible for them in any way.
 Full
 Abbreviated
 Hidden
More | Login
Loading... please wait.
  • by jamiemccarthy (414) on Monday September 23 2002, @11:50PM (#5330) Homepage
    id = moderation's id. the metamodlog.mmid column points to moderatorlog.id

    uid = moderator's uid

    val = -1 for downmod, +1 for upmod

    ts = timestamp of the moderation

    cid = comment id the mod applies to

    sid = discussion ID of the comment the mod applies to (redundant information, breaks normalization, oh well)

    cuid = uid of the comment poster, look, we break normalization again! we suck!

    reason = reason for the moderation (see the modreasons table)

    active = 1 if the moderation is active, 0 if not. most mods are active. a mod may be inactive because it was an attempt to up/downmod a comment already at max/minimum, or because the moderator later posted to the same discussion, turning all earlier mods inactive retroactively

    m2count = number of metamods on this mod

    m2status = 0 if the mod is still being metamodded, 1 if the mod is all done being metamodded but hasn't been reconciled yet, or 2 if the mod is all done being metammodded and has been reconciled ("reconciling" is the process where all the metamods are tallied up and the consequences dealt out to everyone)