quick question,
1. lets say after I open admin cp and run each query individually, how can I test to see if it worked? I mean will I see side effects if it doesn't?

2. I forget should I run it manually or automatic in the admin cp

3. I created the board, but it says I don't have permissions to exicute an SQL query. I know when I transfered my PHP board, it transfered my admin account, then created another admin account. I deleted that without thinking. So how do I make myself a super admin again???


Thanks for all of your help :)

Yup... and then delete the user in the Admin CP when you are done.

To see if it worked, go into the Admin CP --> vBulletion Options --> User Registration Options

And there should be three new options: Registration PM From, Text, and Title.

You do them manually by pasting them into the query box.

http://www.vbulletin.com/docs/html/m...ntenance_query

i would like to install this hack. however, i know absolutely NOTHING about mysql.

i would be able to run the queries just fine, but i need to know now to uninstall the hack for future upgrades and whatnot. if anyone could provide an exact undo of every change to the database (putting it back just like it was before the hack was installed), that would be fantabulous. i could then install the hack without worrying about foreign things in my vbulletin database that i have no idea how to get rid of. :)

if this is alot of work, then nevermind. :)

The following two queries will undo any database changes:

thanks :)

Thanks a lot for this hack!

Thanks for this hack !
click install ;)

Ran all queries, clicked "save" in ACP User registration options and did the file edit. When I registered a test user I got an error message that there was a problem with the database. This is the error msg that was emailed to me.

Looks like exactly what I was after. Just so I'm clear on this... do PM's need to be enabled for users awaiting email confirmation or will the welcome PM just wait until the account is activated?

It appears that you don't have a user set for the registration PM to be from. Go into the Admin CP and make sure that 'User Who Sends Automatic PM Upon Registration' has the proper value.

The PM will be sent upon the user hitting the final button in the registration system... since there is no "PM Que" in vB, the user will get the welcome PM notice right after they register (even if they haven't activated yet). And the hack simply puts the PM in the user's inbox without any regards for permissions.