FYI: this is how the voting is done (I checked this long ago, and I might have missed something but this is what I remeber of it):

The db doesn't keep track of what you have voted, each "voteable" node has a field where user_id's who voted are stacked, comma-seperated or something like that. So when you try to vote, it checks against that field to see if you've voted, so there isn't a table for you holding what you've voted on, there's a field for the node holding who voted on it, it's simpler that way.

So, once again, you cannot "piggyback on the votes database table" cause there ain't any. I'm not assuming "it needs a radical change". I know it does, and you can ask other pmdevers.


He who asks will be a fool for five minutes, but he who doesn't ask will remain a fool for life.

Chady | http://chady.net/

In reply to Re: Re: Re: Visited nodes by Chady
in thread Visited nodes by bart

Title:
Use:  <p> text here (a paragraph) </p>
and:  <code> code here </code>
to format your post, it's "PerlMonks-approved HTML":



  • Posts are HTML formatted. Put <p> </p> tags around your paragraphs. Put <code> </code> tags around your code and data!
  • Titles consisting of a single word are discouraged, and in most cases are disallowed outright.
  • Read Where should I post X? if you're not absolutely sure you're posting in the right place.
  • Please read these before you post! —
  • Posts may use any of the Perl Monks Approved HTML tags:
    a, abbr, b, big, blockquote, br, caption, center, col, colgroup, dd, del, details, div, dl, dt, em, font, h1, h2, h3, h4, h5, h6, hr, i, ins, li, ol, p, pre, readmore, small, span, spoiler, strike, strong, sub, summary, sup, table, tbody, td, tfoot, th, thead, tr, tt, u, ul, wbr
  • You may need to use entities for some characters, as follows. (Exception: Within code tags, you can put the characters literally.)
            For:     Use:
    & &amp;
    < &lt;
    > &gt;
    [ &#91;
    ] &#93;
  • Link using PerlMonks shortcuts! What shortcuts can I use for linking?
  • See Writeup Formatting Tips and other pages linked from there for more info.