Announcement

Collapse
No announcement yet.

Post storage

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

  • Post storage

    How is the text of vbulletin posts stored? Does vBulletin translate the vBCode and smilie codes to pure html and then the end result saved in its raw form? Or is it stored unaltered with vBCodes and smilie codes untranslated?

    If it's the first, then obviously vBulletin has to do a reverse translation when a user tries to edit a post.

    If it's the latter, then when the thread is displayed, vBulletin has to dynamically translate the vBCodes back into html.

    If someone can help me with this I'd greatly appreciate it. Thanks.
    Well, there it is.
    - Keeper of the Grove

  • #2
    latter AFAIK
    My Sites :

    Comment


    • #3
      When I submit a new post (see attachment for screenshot) it is stored in the database like this. (see second attachment for screenshot - grabbed that from post table with phpmyadmin)
      Attached Files

      Comment


      • #4
        Would it be better for performance if it's stored twice, once with the vBCodes intact and the other rendered into html? That way when displaying it's quicker.

        Obviously the database size will increase, but will it not be worth the performance gain?
        Well, there it is.
        - Keeper of the Grove

        Comment


        • #5
          I believe in the Server Settings / Optimization part of the options pane in the ACP, there's a post caching feature that will do just that.
          Bugdar: PHP bug tracking software that is beautiful, fast, and robust.

          Comment


          • #6
            ACP? Administrative Control Panel?

            How is the caching done?
            Well, there it is.
            - Keeper of the Grove

            Comment


            • #7
              Yes, ACP = Admin Control Panel.

              I'm not sure when it is done but the post is turned from BBCode into HTML which makes rendering faster. All the BBCode templates are parsed (quote, PHP, HTML), along with standard bold tags. Then when the thread goes to render, it just pulls the post and renders it.

              The attachment is a picture of the quote template parsed in:
              Attached Files
              Bugdar: PHP bug tracking software that is beautiful, fast, and robust.

              Comment


              • #8
                Hmmm so the post text IS stored twice? Once with vBCode intact and the other rendered into pure html? What table is pagetext_html stored?
                Well, there it is.
                - Keeper of the Grove

                Comment


                • #9
                  It's stored in the post_parsed table. And it's only stored twice if you enable it.
                  Bugdar: PHP bug tracking software that is beautiful, fast, and robust.

                  Comment


                  • #10
                    Originally posted by daemon
                    It's stored in the post_parsed table. And it's only stored twice if you enable it.
                    I can't locate the feature in the administrative control panel for this feature. Where is it? I tried looking all over.
                    Well, there it is.
                    - Keeper of the Grove

                    Comment


                    • #11
                      I believe you enable this by going to:

                      Admin CP --> vBulletin Options --> Server Settings and Optimization Options

                      Then set Cached Posts Lifespan to be a number of days. Generally this should be about 5 to 15 to 30 days depnding on how active your forum is. Then you should run:

                      Admin CP --> Import and Maintenance --> Update Counters --> [Rebuild Post Cache]
                      Bugdar: PHP bug tracking software that is beautiful, fast, and robust.

                      Comment

                      widgetinstance 262 (Related Topics) skipped due to lack of content & hide_module_if_empty option.
                      Working...
                      X