No announcement yet.

Delete Password History

  • Filter
  • Time
  • Show
Clear All
new posts

  • Delete Password History

    Would there be any adverse side effects if I truncated the passwordhistory table?

    Basically, my forum authenticates with Active Directory, then I pass a random password into vB. The passwords stored in vB are meaningless to me and the passwordhistory table is getting rather large. It's making backups go slow. I was kicking around adding a weekly cleanup that truncates that table.

  • #2
    u got the answer for this?


    • #3
      Ha, forgot all about asking this. I went ahead and created a plugin with the following code:
      $vbulletin->db->query_write("DELETE FROM " . TABLE_PREFIX . "passwordhistory");
      The plugin is attached to the cron_script_cleanup_daily hook.

      I haven't had any problems since implementing this.


      • #4
        can u give the procedure detailed


        • #5
          it wotn affect anything in database deleting this table?


          • #6
            You're not actually deleting the table, just the entries in the table. It didn't matter for me because I don't use passwords in vBulletin because my site authenticates through Active Directory. My understanding of the table is that it keeps a history of your passwords so you can't reuse the same password. If your site does use vBulletin passwords, then you may want to reconsider.

            As for the procedure, go to the AdminCP, then the Plugin Manager. Create a new plugin, paste in the above code and select the specified hook. When the daily cron script runs, the plugin will be executed, and the db table will be emptied.


            • #7
              whats the use of this password history?


              • #8
                As stated above, it keeps a history of your passwords so you can't reuse the same password should you prevent passwords being reused in AdminCP.
                Vote for:

                - *Admin Settable Paid Subscription Reminder Timeframe*
                *PM - Add ability to reply to originator only*
                - Add Admin ability to auto-subscribe users to specific channel(s)
                - "Quick Route" Interface...


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