Results 1 to 2 of 2

Thread: vBulletin Power Tips Using MySQL

Hybrid View

  1. #1

    vBulletin Power Tips Using MySQL

    Here are some power tips for doing things to your vBulletin database directly from the MySQL command line.

    Always backup your database before editing it manually, or you'll be sorry...

    Delete Guest Posts

    delete from post where userid = 0;

    Delete Soft Deleted Posts

    delete from post where visible = 2;

    Delete Soft Deleted Threads

    delete from thread where visible = 2;

    Delete Thread Redirects

    delete from thread where open="10";
    Submit Your Webmaster Related Sites to the NB Directory
    I swear, by my life and my love of it, that I will never live for the sake of another man, nor ask another man to live for mine.

  2. And when too password attempts lock you out of vBulletin...

    Clear vBulletin Admin Lockout

    DELETE FROM strikes;
    Submit Your Webmaster Related Sites to the NB Directory
    I swear, by my life and my love of it, that I will never live for the sake of another man, nor ask another man to live for mine.

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •