Send default PM to all new users

Small hack to automatically send PM to new users
after they have activated account.

Requested by Xelation
Tested on 2.2.5

UPDATED - v2.1 - 2002-05-02

Version 2.1 only fixes some problems with installation. Now it checks to see if the settings are already present in the DB, it has an option to remove the settings if you wish to uninstall and it has an option to remove any surplus settings you may have as a result of running the old install file.

If you have version 2.0 up and running problem-free, there is absolutely no need to upgrade.

You should uninstall version 1.0 before installing this one.
This version facilitates vB's built in setting system, and no longer requires a writable file on the server.

It also supports popup on PM.

Follow the instructions in install.txt

-- If you are running MySQL 3.22.xx, you might need to use this installfile instead.

[Sparkz]

Originally posted by JustAskJulie
Thanks that did the trick. Now one more question, how do I find out the numerical userID that matches a username? I can't find that on the profile info that comes up in the CP.

Just hover your mouse cursor over a username in the member list, and watch the link in your status bar. At the end of the link there is a userid=xxxx parameter, where xxxx is the number you are looking for.

[Sparkz]

Originally posted by JustAskJulie
One more thing, I'm now getting a java error on my register.php page when it opens. Any ideas what might have caused this?

No idea. I don't mess with any javascript or anything in this hack...

[Sparkz]

Originally posted by JustAskJulie
One more still. Getting this error when attempting to register a new user:

Invalid SQL: SELECT setting.varname, setting.value FROM setting INNER JOIN settinggroup ON setting.settinggroupid = settinggroup.settinggroupid WHERE settinggroup.title = 'Default PM'
mysql error: You have an error in your SQL syntax near 'ON setting.settinggroupid = settinggroup.settinggroupid WHERE settinggroup.title' at line 1

I'd have to look in to this at a later date. I am out of town atm, so I don't have access to my test board from here.

[Sparkz]

Originally posted by Rolodex
Does this hack work if you manually register a user to your forum?

I haven't checked, but I believe manual registration from the ACP uses other scripts than register.php.

It should be a quick fix to add that feature, though.

[Bison]

Thanks, i'll be looking for that fix when you have the time to do it.

Otherwise, the hack works great ... thanks! :banana:

[JustAskJulie]

Thanks Sparkz,

I'm going to try reinstalling it again and see what happens.

[JustAskJulie]

Still no luck
FYI, I am using MySQL 3.23

[JustAskJulie]

Tried to uninstall it and got this error:

Invalid SQL: SELECT @settinggroupid:=settinggroupid FROM settinggroup WHERE title = 'Default PM'
mysql error: You have an error in your SQL syntax near '@settinggroupid:=settinggroupid FROM settinggroup WHERE title = 'Default PM'' at line 1

[Sparkz]

Strange, that scripts runs w/o problems on my server.

[JustAskJulie]

Any idea how I can uninstall it then? I have a few more hacks I want install but I don't want any remnants of hacks that aren't working hanging around causing more problems.