Announcement

Collapse
No announcement yet.

1,000,000, posts

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • 1,000,000, posts

    finally reached the magic number

    Does anyone know how I can see who posted the 1,000,000 posts? We want to give him/her a free payed membership
    Last edited by dutchbb; Tue 28th Feb '06, 2:39am.

  • #2
    Code:
    http://www.site.com/forum/showpost.php?p=1000000&postcount=1

    Comment


    • #3
      Originally posted by Andrew111888
      Code:
      http://www.site.com/forum/showpost.php?p=1000000&postcount=1
      thanks

      however the database show more posts and the statistics on forumhome less? How is this possible?

      Comment


      • #4
        You probably deleted some post there and there... so using the postid as a reference wouldnt work. You would need to run a query to find out exactly.

        This for example (where vb3_post is your post table...):

        Code:
        SELECT * 
        FROM vb3_post 
        WHERE visible = 1
        ORDER BY postid
        LIMIT 999999, 1
        It will return the 1 000 000th post...
        Last edited by Arsenik; Tue 28th Feb '06, 7:30am.

        Comment


        • #5
          Great, thanks

          Comment


          • #6
            IT's a dream to me

            Comment


            • #7
              Welcome to the million posts club!
              War is only fun when you are winning.

              Comment


              • #8
                Congratulations!!!

                Comment


                • #9
                  Congrats! Nice milestone to hit.

                  Comment


                  • #10
                    Congrats - very nice!
                    Crazy $16,000 Contest - Biggest Forum Contest of the Century!

                    Comment


                    • #11
                      Originally posted by TripleT
                      finally reached the magic number
                      You might want to check this thread too... http://www.vbulletin.com/forum/showthread.php?t=47430

                      Comment


                      • #12
                        hola

                        Comment


                        • #13
                          Originally posted by Arsenik
                          You probably deleted some post there and there... so using the postid as a reference wouldnt work. You would need to run a query to find out exactly.

                          This for example (where vb3_post is your post table...):

                          Code:
                          SELECT * 
                          FROM vb3_post 
                          WHERE visible = 1
                          ORDER BY postid
                          LIMIT 999999, 1
                          It will return the 1 000 000th post...
                          Order it by dateline, not post ID. All an ID is, at least in vBulletin's database, is a unique identifier for a row. It has no other special meaning. They simply ascend because that's what auto_increment does by default.
                          --filburt1, vBulletin.org/vBulletinTemplates.com moderator
                          Web Design Forums.net: vB Board of the Month
                          vBulletin Mail System (vBMS): webmail for your forum users

                          Comment


                          • #14
                            To my knowledge never in the history of forum software has a post ever been made after a post with a higher ID number than it.

                            Comment


                            • #15
                              If you drop and reapply auto_increment, it could start to fill in blank IDs. If you delete post ID 2, then reapply auto_increment, suddenly it could be filled with a new post.

                              If the dateline had millisecond precision, it could be used as the primary key instead (provided no two posts share the same post time to the millisecond). The point of an ID is to uniquely identify data, not to necessarily describe it.

                              (I'm taking a database design class, but I knew this going into it anyway)
                              --filburt1, vBulletin.org/vBulletinTemplates.com moderator
                              Web Design Forums.net: vB Board of the Month
                              vBulletin Mail System (vBMS): webmail for your forum users

                              Comment

                              Related Topics

                              Collapse

                              Working...
                              X