I think I would handle it with a couple of tables. One for the users information and another table with a column for a Storable serialized object. I would create a datastructure with the rankings of the users and then store it to the database. The next time through I would retrieve that data structure, reorder however necessary and then store it back. You can use that datastructure to order (rank) your users and it only requires one update and one select for the ordering. I'm not sure how many user id's you could store in a single field, it would depend I guess on what you stored in your data structure. This would remove the flat file and would probably increase your performance. I haven't used this for anything myself as of yet, but it seems like it might be a good way to do what your looking for.

HTH,
Steve

In reply to Re: Implementation of a Ladder System by steveAZ98
in thread Implementation of a Ladder System by Anonymous Monk

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.