[Shmee]

For anyone that may need this. I have about 1/2 a million users on my forum.
When I tried installing this hack, it would hang and timeout, even crash my mysql.

To fix this issue open /admincp/donation_install/donation_install_tables.php (line 128)

Find:

PHP Code:

        $test = $vbulletin->db->query_first("SELECT * FROM ".TABLE_PREFIX."user"); 


Change to:

PHP Code:

        $test = $vbulletin->db->query_first("SELECT * FROM ".TABLE_PREFIX."user LIMIT 1"); 


open /admincp/donation_install/donation_uninstall.php (line 98)

Find:

PHP Code:

            $test = $vbulletin->db->query_first("SELECT * FROM ".TABLE_PREFIX."user"); 


Change to:

PHP Code:

            $test = $vbulletin->db->query_first("SELECT * FROM ".TABLE_PREFIX."user LIMIT 1"); 


What that line would do is load all the user rows into memory. If you have an insane ammount of users, it would hang (crash) mysql. So I basically modified it to only load one row, since that's all it needs to check if certain tables exist.