MU Soapbox

    • Register
    • Login
    • Search
    • Categories
    • Recent
    • Tags
    • Popular
    • Users
    • Groups
    • Muxify
    • Mustard

    Code request: Jobs archived to SQL, now what?

    MU Code
    code requests
    2
    2
    1716
    Loading More Posts
    • Oldest to Newest
    • Newest to Oldest
    • Most Votes
    Reply
    • Reply as topic
    Log in to reply
    This topic has been deleted. Only users with topic management privileges can see it.
    • M
      Melpomene last edited by

      So, we've got the lovely job archival thing @Thenomain posted installed. Thanks, @Thenomain! Now what, though? How do we read the archived jobs? I mean... I could whip up a quick forum-style thing and stick it on the site, but that'd be kinda ugly (I'm not a visual person) and would be a minor pain in the ass. OR... I could use whatever the big kids are using. What are the big kids using, though?

      I assume this is some kind of PHP/website-based thing, or (I guess) a softcoded bit to read the database entries as board posts, which I suppose would work, but would be weird. After all, what's the point of putting it in the database if you aren't willing to make it available on the web?

      So, anyone done this? Save me some time and later pain? Thanks in advance!

      1 Reply Last reply Reply Quote 0
      • Chime
        Chime last edited by

        @Thenomain. Really. You need docs!

        Yes; an interface will need to be made available for accessing the archives. (how it was tested without one I'm not sure, but?)

        This can be web-based (please not php) or-- well, you could just do it inside the mush. This would be another set of commands to run queries to retrieve archived job info-- and likely do various types of searches.

        I very strongly recommend using the @query interface for async db queries-- that way you can run them without hanging the game, which is handy for very large/complex queries. It also has the nice result of returning a row at a time with a @trigger-like interface.

        It is by will alone I set my mind in motion. It is by the juice of Coffea arabica that thoughts acquire speed, the table acquires stains, the stains become a warning. It is by will alone I set my mind in motion.

        1 Reply Last reply Reply Quote 0
        • 1 / 1
        • First post
          Last post