GFY post order problem...my solution for you Lens =)

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • Varius
    Confirmed User
    • Jun 2004
    • 6890

    #1

    GFY post order problem...my solution for you Lens =)

    I have noticed that posts are being shown in bad orders and believe I know your problem.

    If you have multiple servers, their times are probably not synchronized.

    The solution is to use the database's native function, for example if it's a unix timestamp in MySQL have your coder modify the places it inserts the time to do this instead:

    BEFORE
    timestamp_field='$time'

    AFTER
    timestamp_field=UNIX_TIMESTAMP()

    This will ensure that no matter what server the post comes from, it gets the current timestamp of the DB inserted....and no more post order mixup

    If that's not your problem, then nevermind this post
    Skype variuscr - Email varius AT gmail
  • Juicy D. Links
    So Fucking Banned
    • Apr 2001
    • 122992

    #2
    Keith your posts give me WOOD

    Comment

    • Varius
      Confirmed User
      • Jun 2004
      • 6890

      #3
      Originally posted by Juicy D. Links
      Keith your posts give me WOOD
      Just trying to do my part so you can hit 100K without going insane from posts moving up and down
      Skype variuscr - Email varius AT gmail

      Comment

      • Spunky
        I need a beer
        • Jun 2002
        • 133978

        #4
        Originally posted by Juicy D. Links
        Keith your posts give me WOOD

        Comment

        • tungsten
          Too lazy to set a custom title
          • Mar 2004
          • 10579

          #5
          didn't notice that yet..
          • VOYEUR /HOMEMADE, HENTAI / CARTOON, Reality, Amateur, Shemale, Hardcore, Cuckold, Celebrity, Retro/Vintage, ect...ALL OUR SITES >>
          • Unbelievable Ratio | High % of Rebills | Bi-Monthly Payments (also to E-Passporte)
          • Ton's of EXCLUSIVE Free content & FHG's |=> GREAT REVENUE $$$ GUARANTEED!

          Comment

          • skelly
            I fix things
            • Jun 2004
            • 47

            #6
            Originally posted by Varius
            If you have multiple servers, their times are probably not synchronized.
            One of the servers was off by about 30 seconds earlier. They are all sync'ed on an external NTP server now.
            hi

            Comment

            • TheMob
              Confirmed User
              • Jan 2003
              • 8584

              #7
              juicy, wow you got your name changed..

              Comment

              • xlogger
                Confirmed User
                • Jul 2004
                • 9507

                #8
                Originally posted by spunky
                hotlink!



                ----------
                XLOGGER [REFLECTED] [OH]

                Comment

                Working...