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.

[Glenn379]

Great Hack! Works like a charm! (Now that I can install them myself it does hehe) Thanks! *installs*

[FleaBag]

All's well with 2.2.8. Thank you!

[Cyberhouse]

Works great

[Xer]

working on my 2.2.9..thx!

[JustAskJulie]

I'm getting the following error when I click "install"

Invalid SQL: SELECT @displayorder:=displayorder+1 FROM settinggroup ORDER BY displayorder DESC LIMIT 1
mysql error: You have an error in your SQL syntax near '@displayorder:=displayorder+1 FROM settinggroup ORDER BY displayorder DESC LIMIT' at line 1

[Sparkz]

Try using this installfile instead: https://vborg.vbsupport.ru/attachmen...&postid=246943

You probably have MySQL 3.22.xx or something. Someone else had problems with that too, so I had to change some stuff in the installer.

[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.

[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?

[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

[Bison]

Does this hack work if you manually register a user to your forum?