Database API

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • EdBoy002
    FFR Player
    • Nov 2005
    • 13

    #1

    Database API

    Is there a possibility for an API that lets other developers make stuff that uses FFR? I'm making a bot for an IRC channel that I'd like to get stuff off of FFR (i.e. get ranking, AAAs, FCs, etc.), but that's not possible without an easy way to get the information. Is this possible with the way FFR is set up?
  • Tasselfoot
    Retired BOSS
    FFR Simfile Author
    • Jul 2003
    • 25185

    #2
    Re: Database API

    i doubt we'll release anything like this. we're tight on security to prevent potential cheaters.

    although i'm not the coder, so i don't know exactly what it would entail.
    RIP

    Comment

    • lightdarkness
      Summer!!
      • Jul 2003
      • 11308

      #3
      Re: Database API

      It might be something we would look into in the distant future.

      Comment

      • JasonKey
        FFR Underseer
        • Jul 2003
        • 2643

        #4
        Re: Database API

        Actually I don't want to say distant future. There could be some solutions regarding personal info and RSS.

        Essentially converting some of the FFR reports into a pure XML feed would not be much of a stretch.

        Originally posted by Synthlight
        I will be fix this. No worries. It happened during a version upgrade.
        Cheers,
        Synthlight

        Comment

        • EdBoy002
          FFR Player
          • Nov 2005
          • 13

          #5
          Re: Database API

          Yeah, that's what I was going for. And maybe another form that you could just put api.php?action=rank|EdBoy002 and it would just give out my rank. Something like that.

          You could make it so that only authorized people could access it.

          (I'd code it myself but I don't know how the database works and you wouldn't trust me anyway )

          EDIT: To Tasselfoot, this isn't to modify information, it's simply to get it. Just wanted to clarify that.
          Last edited by EdBoy002; 08-18-2007, 10:31 AM. Reason: Quick note

          Comment

          • Tasselfoot
            Retired BOSS
            FFR Simfile Author
            • Jul 2003
            • 25185

            #6
            Re: Database API

            as i said, i don't do any of that backend work... so i didn't know what sort of information would need to be given out to do this. apparently none, which is the goal. so, that's pretty cool.

            i'm sure something like this would go over real well.
            RIP

            Comment

            • Synthlight
              Administrator
              FFR Simfile Author
              FFR Administrator
              • Nov 2002
              • 3057

              #7
              Re: Database API

              I support this idea 100%. We need to organize this thread to include a list of everything you could want to pull from the API.

              Cheers,

              Synthlight

              Comment

              • EdBoy002
                FFR Player
                • Nov 2005
                • 13

                #8
                Re: Database API

                Well, basically, what it should be able to take is everything that you can see on a person's profile, save for comments and other irrelevant things. It would give you their overall and average rank, gameplays, AAAs, FCs, grand total, skill and normal tokens (by number), and maybe regional rank. I guess you could also add generic statistics, like the top ten overall players and such.

                You could also use this for other stuff on the site, to make it easier.

                Comment

                • JasonKey
                  FFR Underseer
                  • Jul 2003
                  • 2643

                  #9
                  Re: Database API

                  its been discussed in the past. Likely should come up again really.

                  Open a new thread call it something like "FFR Remote Data / RSS / XML Requirements" or something like that. We can look and see what we can and need to do one item at a time.

                  Originally posted by Synthlight
                  I will be fix this. No worries. It happened during a version upgrade.
                  Cheers,
                  Synthlight

                  Comment

                  • EdBoy002
                    FFR Player
                    • Nov 2005
                    • 13

                    #10
                    Re: Database API

                    Ah.

                    Anywho, I made a quick one to show what I'm going for (this one crawls the DOM of their profile, making it horrifically slow). Just go to doubleaw.com/ffr.php?action=[act]|[user] where [user] is their username, and [act] is any of the following: all (displays all their information), rank (overall rank), arank (average rank), mp (multiplayer level), games (games played), last (last activity), posts (forum posts), gender (obvious), and location (also obvious).

                    It's slow, but at least it works with my bot.

                    Comment

                    Working...