Send default PM to all new users

[Sparkz]

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 (https://vborg.vbsupport.ru/attachment.php?s=&postid=246943) installfile instead.

[DelusionalMind]

nice :)

would be a good feature at my board :)

[DelusionalMind]

will be installing in a few...the first one also. haha

[Sparkz]

Heh - it would be cool if someone was actually able to use it :)

*looks at the time*hmm - 05.20... Time to get home, I guess. Should probably be thinking of getting up in - err - 3 hours

[Xelation]

Oh first time someone actually created a hack I requested! I'm gonna install it right now... I'll tell you how it went.

[DelusionalMind]

okie. i just installed. it would be cool if you made it show the input area under the vb options...but hey, this is nice also

I don't feel like editing the hack so i'll leave it as is. heh

I installed it at teencribs.com .... please register only if you plan on being part of the board...not just for the sake of trying out the hack!

[Sparkz]

Originally posted by DelusionalMind
okie. i just installed. it would be cool if you made it show the input area under the vb options...but hey, this is nice also


I'm not quite sure I understand what you mean here...

[Xelation]

Works perfectly! Thank you very much! :D

[Xelation]

Just though I would make a screen shot for everyone. :D oh and I just made a temporary message for now... that will change later.

[Admin]

Nice hack, just installed this here (another good way to tell people to enter their license). :)

[FWC]

Originally posted by FireFly
Nice hack, just installed this here (another good way to tell people to enter their license). :) LOL!!!!! :D

[Admin]

Ok works a treat, I did make one change though, to use the username of the user in the message:
$PM_content = str_replace('$username',$username,fread($fp, 50000));

[Lesane]

Great feature, gonna install this hack later. Thnx

[Sparkz]

Originally posted by FireFly
Ok works a treat, I did make one change though, to use the username of the user in the message:
$PM_content = str_replace('$username',$username,fread($fp, 50000));

Thx for the idea - I uploaded an updated zip with this feature for both the title and the content.

I also changed
fread($fp, 50000)
to fread($fp, filesize ($PM_file))
(where the variable $PM_file contains the filename, of course)

Just in case someone wants an incredibly long default PM

[Admin]

Why not store it in the database, as a setting?

[Sparkz]

Originally posted by FireFly
Why not store it in the database, as a setting?

Mainly because I haven't touched that part of the system before.
This was kind of a quick&dirty done in the wee hours.

But I guess by saying that you just gave me a reason to play some more with the DB :)

[aldamon]

Hey,

How do I change who the PM comes from? I have two identities, my Administrator ID and my anonymous "Moderator" ID. I'd like the welcome PM to come from moderator and it's coming from my Administrator ID.

Thanks!

[Admin]

Originally posted by Sparkz
All messages will originate from userid 1 - this can be changed by assigning $originating_user another userid in register.php

[aldamon]

LOL.

OK, here's another one. I have "pmpopup" and PM e-mail notification set to YES to during registration. However, I have created a new ID to test the system, and when I clicked the activation link there was no popup or E-mail notification of the new PM when I returned to the main menu.

What could cause that? It's almost like vB is not recognizing the automated PM as a "new" message.

This concerns me because my users are very computer illiterate and I want them to have a reason to go into the user cp. If there is no popup, then most people won't even notice the first new message. Heck, most of my users don't even know PMs exist, so the popup, or at the very least E-mail notification, on the first message would be really sweet.

Thanks!

[Sparkz]

I'd have to look in to this when I get back home from this business trip.

I'll change it so it uses the settings table as well, in stead of storing the default message in a file.
Have had a lot to do at work lately, so I haven't had time to implement this yet...

[neal]

Doesn't seem to be working on 2.2.2... anyone else have this installed or have to modify anything?

[c-pr0mpt]

neal> Doesnt work for me either. :(

[Sparkz]

I'll see if I have time to install 2.2.2 on my testserver today and see if there is anything special that needs to be done there.

As I still have craploads of work to do, I can't promise that I have the time today, but I'll try.

[Xelation]

Originally posted by Sparkz
I'll see if I have time to install 2.2.2 on my testserver today and see if there is anything special that needs to be done there.

As I still have craploads of work to do, I can't promise that I have the time today, but I'll try.

I just tested it on 2.2.2 and eveything seems to be working fine, it sent a pm to the new user. :D

[jvv]

Yes it works, don't forget that the user has to activate the account before he receives the PM.

[nafae]

mine doesn't work either. Note that I don't have email activation turned on, if that would have anything to do with it?

[nafae]

bump? :(

[jvv]

Yes it has to do with that. If you look closely at where you need to insert the code, you'll notice that it is when the user activates. If you want to change this you'll have to place it at where the user registers if I am making any sense (I'm actually too lazy to look it up right now... maybe tomorrow)

[nafae]

yeah that makes sense, if you can find where that is in the code I would be soo appreciative~ Thanks :]

[SaintDog]

I would love to use this hack if you were to adapt it to work with vB 2.2.2, it would help control a few things on my board as well (I believe, at least)

SaintDog

[Sparkz]

I have been really swamped in work lately, so I haven't even gotten around to upgrading my own boards to 2.2.2 yet.
At the moment, I am not sure when I will get around to look at it.
Sorry. Will do it as soon as I find the time, tho.

[SaintDog]

That's cool, I can wait (for a little ;))

[mav]

Awesome!

[Supernature]

Very nice Hack, I would love to use it, but I also have the Email verification turned off and don't know where to put the code in register.php :(
Please help

[ForKmaN]

Originally posted by Supernature
Very nice Hack, I would love to use it, but I also have the Email verification turned off and don't know where to put the code in register.php :(
Please help

*bump*

I'd like to know aswell

[neal]

same here. anyone?

[Overgrow]

I hope Sparkz doesn't mind, but I updated this hack since I wanted to use it.

-works with 2.2.1 and 2.2.2 no problem
-works whether or not you have email activation turned on
-uses templates instead of text files

https://vborg.vbsupport.ru/showthread.php?s=&threadid=35647

[camoboy]

There is a slight issue with this hack;

if a user who registers chooses not to receive stuff from admins, it still sends a PM to them upon activiation. I received a rather rude message from a user about this; is there any fix?

[aldamon]

If a user is going to write rude messages to you about a welcome PM, then they are not worth having around any way. How lame.

Anyway, I don't think the option you are referring to will limit Private Messages in any way.



*****2.2.3 Issue*****

Anyone get this to work in 2.2.3 yet? It's giving me errors on line 593 in register.php. Here is the line that's giving it fits. There could be more but I have to fix this one first (Line is IN BOLD):

// send default PM to new user
$originating_user = 1;
$PM_file = "admin/default_pm.txt";
$fp = fopen <http://www.php.net/fopen>($PM_file, 'r');
$PM_title = str_replace <http://www.php.net/str_replace> ('$username', $username, fgets <http://www.php.net/fgets>($fp, 4096));
$PM_content = str_replace <http://www.php.net/str_replace> ('$username',$username,fread <http://www.php.net/fread>($fp, filesize <http://www.php.net/filesize> ($PM_file)));

$DB_site->query("INSERT INTO privatemessage (privatemessageid,userid,touserid,fromuserid,title ,message,dateline,messageread,folderid) VALUES (NULL,$u,$u,$originating_user,'".addslashes <http://www.php.net/addslashes>(htmlspecialchars <http://www.php.net/htmlspecialchars>($PM_title))."','".addslashes <http://www.php.net/addslashes>($PM_content)."',".time <http://www.php.net/time>().",0,0)");
// send default PM to new user

[mas404]

can it modified to send the PM to the normal user depend on his post NO.?

ex.
if the user get 50 post >> he will get defult PM
" thank you for your posts after another 20 post more your titel will be chang to Tyro Hacker and you will get star "

thank you

[Sparkz]

Updated the zip with a complete rewrite of the hack.
See first post for details.

[JulianD]

This is one of the most useful hacks installed on my board! Although there were other options and similars hacks, I kept this one! And now I'm getting an updated version :D :p Great work Sparkz

[Sparkz]

Thanks.
This update was due a long time ago. For some reason I just didn't get around to it before.
I am quite convinced that this one is superior to the first version, tho. :)

[Sparkz]

BTW, why isn't this featurea already present in vB?
It is most usefull :)

You don't even have to sex0r me to use it in vB3 ;)

Disclamier to all posts I have made in the last 6 hours:
We are a wee bit drunk today, but we are doing our best :)

[Meta]

Installs softly and works nice.

Well done ... thank you, Sparkz!

[tpearl5]

I'm getting this error when I run the install file:

Database error in vBulletin Control Panel 2.2.5:

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

mysql error number: 1064

Any idea why?

[Mathiau]

Great hack m8

When i clicked the

[Proceed to fileedit-part]

Part, i didn't think it was doing anything, SO now in my control panel, i got like

8

[Default PM]

In a row, how can i 'uninstall' 7 of them?

And perhaps add some feature so idiots can't do what i did?

[Sparkz]

Originally posted by Mathiau
Great hack m8

When i clicked the

[Proceed to fileedit-part]

Part, i didn't think it was doing anything, SO now in my control panel, i got like

8

[Default PM]


In a row, how can i 'uninstall' 7 of them?

And perhaps add some feature so idiots can't do what i did?

I am on the move now, but I will write a script for you later that fixes this.
I will also update the installfile to prevent it from happening to others. It's a known bug.

[Sparkz]

Originally posted by tpearl5
I'm getting this error when I run the install file:

Database error in vBulletin Control Panel 2.2.5:

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

mysql error number: 1064

Any idea why?

What version of MySQL are you running?

[tpearl5]

3.22.32 :( I have had problems with it before.

[Sparkz]

Without having actually checked, I'd guess that your version does not support user variables.
I am about to hit the sack now, but I'll try to make a script you can run instead tomorrow afternoon.

[tpearl5]

Is there any way to get around it?

[Sparkz]

Yeah, it is. I'll write an install script for you later today, or early tomorrow. I just completed an 8 hour trip and had to go straight to work, but as I said, I'll try to whip something up for you this afternoon.

[sub]

Thanks so much of this hack! It's awesome and WORKS GREAT with 2.2.5

Now the hostess don't have to keep PM'ing ppl.
Keep up the good work! :bunny:

[Sparkz]

Originally posted by tpearl5
Is there any way to get around it?

Try this script instead. Since I have a much more recent version of MySQL myself, I have no chance to verify that it will work with your version, but it does work with the version I am running.

[Droopy]

Very cool hack, works fine.

[tpearl5]

Thanks Sparkz! It installed this time.

However, when I signed up a test account I did not get the default PM. I'm not getting any errors anywhere and I changed the settings in the control panel. What could be wrong?

You can visit my board at http://degster.com/midi/board/ to take a look.

[Sparkz]

And you have completed the file edits too?

[tpearl5]

yep, there's only one, right?

[Sparkz]

Yeah... I have just tried with a fresh forum/DB - using the file I wrote for you, and it works nicely...

I honestly can't see what is wrong.

[Mathiau]

Hey m8

Just wanted to say thnx for the great support....

I actually am redoing the entire forum, did a few bo'bo's on hacks, and will be reinstalling your hack, but this time i won't press he button 50 million times :)

[Sparkz]

Well, with the updated installfile that is no longer an issue :)

[bandersen]

Cute hack - I installed it. Shows fine in admin panel, but no PM message is actually sent to the new user. I have yes on receive PM, PM activated etc.

for some reason I get an error when clicking on the Agree button in the signup template (line 748 - document.forms.0.avatarset.selectedIndex is NULL or not an object) Win Me, vb 2.2.5. Not sure this is a result of this hack tho.

Anyone have an idea... the latter is really more urgent than the first.

Oh, I installed it May 1st. Will the new version sort out the above?
Thanks!

[Sparkz]

I have been unable to reproduce the bug where no PM is sent, so I can't really say what to do about it. If/when I can reproduce it, I can start debugging. Sorry for not being able to help here.

[Sparkz]

I will however look into the problem asap.
For all I know it might be because of some general forum setup *wild guess*.

[bandersen]

thank you - appreciate it!!

[vbf.Falco171]

Hello, I have the same problem...
I have install your hack but i never receive default pm !
I have only an error on line +- 527 in the register.php file...
eval("\$subject = \"".gettemplate("emailsubject_activateaccount",1,0)."\";");

I have translate this hack in french (version of 05-02-2002), if you change something, can you say me what ?

[Sparkz]

I never bothered to sort out that email-thingy, so I removed it like 10 minutes after posting it. :)

I could probably check it out a bit later today, tho.
I think the only thing I really changed was the install-procedure, and the removal of the mail-thingy.

[vbf.Falco171]

It's probably a problem from the code top in the register.php file...

If I find a solution, i'll send it to you or give it here...

[Sparkz]

Have any of you done other hacks in your register.php which might affect this hack?

I have reinstalled my hack at least 10 times on completely fresh copies of vB 2.2.5, and it works like a charm every single time.

For the life of me, I can't figure out what is wrong.

[bandersen]

I have no other hacks in the register.php.
I even tried a clean install of the original file just in case... included the code again... but still nothing. I made sure everything was checked "yes" if to receive PMs or not....

[vbf.Falco171]

Yes, same for me...

[Sparkz]

If at least I was able to reproduce the problem, I could try to solve it. Sorry for not being able to help you guys :/

[vbf.Falco171]

I've a first correction for this hack...

In php file of the hack, replace on line 17 and 18, $username by \$username, because with $username you can't see this text in admin panel...

[Sparkz]

I actually knew about that one. Just forgot to update the file :)

[bonnmac]

Thank You very much for this hack. I've installed it and it works great. Will make for a nice friendly atmosphere of a board to be welcomed.

[vbf.Falco171]

Ouhhh I've the solution, from Nicolas2000 a moderator of vBulletin-France Team...

The new code to insert into register.php :
// Sparkz - Send Default PM to new users
if ($defpmactive && ($defpmadminmail || $adminemail)) {
$DB_site->query ("INSERT INTO privatemessage
(privatemessageid,userid,touserid,fromuserid,title ,message,dateline,messageread,folderid)
VALUES (NULL,$userid,$userid," . $defpmuserid . ",'" . addslashes (htmlspecialchars (str_replace ('$username', $username, $defpmsubject))) . "','".addslashes (htmlspecialchars (str_replace ('$username', $username, $defpmbody))) . "',".time().",0,0)");
if ($pmpopup) {
if ($noshutdownfunc) {
$DB_site->query("UPDATE user SET pmpopup=2 WHERE userid='$userid'");
} else {
$shutdownqueries[]="UPDATE user SET pmpopup=2 WHERE userid='$userid'";
}
}
}
// Sparkz - Send Default PM to new users

Modifications in php file :
$optionstemplate=generateoptions();
$DB_site->query("UPDATE template SET template='$optionstemplate' WHERE title='options'");
Put that on line 34 after } and on line 71 after } .

I test it and it run ! But the installation and un-installation don't work

[bandersen]

Vive la France!!!!

Can you pls. tell what's on line 34 and 71... just in case we do not have the same? then I'll try it out. thanks.

[vbf.Falco171]

Ouais vive la Belgique, vive la France, vive les pays Francophones :)

And for answer you :
On line 34 after } elseif ($result['total'] > 1) {
echo '<tr class="'.getrowbg().'" valign="top"><td><p><font size="1">Les param&egravetres existent d&eacuteja ' . $result['total'] . ' fois</font></p></td></tr>';
echo '<tr class="'.getrowbg().'" valign="top"><td><p><font size="1">Essayez de modifier vos param&egravetres.</font></p></td></tr>';
}

and on line 71 after }
} else {
echo '<tr class="'.getrowbg().'" valign="top"><td><p><font size="1">Impossible de trouver des param?tres ? supprimer.</font></p></td></tr>';
}

[Sparkz]

I will look at it and update the files tomorrow... I've already had a few beers, so I'm not gonna mess with any code now :)

[bandersen]

It's working here too.

Merci merci from Norway!!

[Sparkz]

J?ss, norsk du ogs?? :)

[bandersen]

YES, you bet! :laugh:

[trainer]

got this installed and it is working great but...

is there a way to send 2 different PM's to new users? i would like to send the normal greeting PM and also one with our site sponsors. really need to push to help support our site.

any way that can be done?

[Sinecure]

First off I must say, great hack, installed perfectly!
I ran into a problem though, after installation. I went to the Admin CP to change the PM body and PM Message title, etc..

I wanted to incorporate the Username of the user in the PM, but when reading your description it didn't say how to get the username in there. Well after reading it closely I discovered that you need to place the $username variable before "anywhere". $username is the variable that will be parsed.

So, here are the quick changes u need to make.

Under PM Subject change it to:
Whatever you enter here will appear in the subject line of the PM. Enter $username anywhere to have it replaced by the username of the recipient.

and

Under PM Body change it to:
This is the message-body. Enter the text that will be the actual PM to new users. If you enter $username anywhere in this text, it will be replaced by the username of the recipient.

--------------------------
That will simply help make it more clear as to how to get the recepients username in the subject or the body. I think you meant to put $username in there, but just forgot.

As I said, great hack!

[vbf.Falco171]

I say that in one of my last posts...

For correct the problem, you must put / before $username in the text...

[Sparkz]

Sorry about that, Sinecure... Corrected it in the zip.

[rascal]

It works perfectly but there is no popup.

*update - It's ok now.*

[rcooper7]

excellent idea! i'm installing it now! Thansk

[inetd]

Who can make this:
User receive default PM only after user moderation.

[novel44]

Running 2.2.6.

Ran the install.php file. it says successful and creates the table entries in sql, but does not create the admin CP information.

Please assist.

[Keith]

This is a very good hack, and it's working on 2.2.5.

novell44, The Send Default PM is now placed/found in the VBulletins Options Menu, last item listed. I think the screen shot earlier in thread shows it placed in the left frame. Could be why you don't see it in your CP.

Great hack. I wish I had the talent and knowledge to do this sort of stuff, you hack guys simply amaze me. :D

[dreamhost]

Ok this may sound stupid. I installed script as directed, but I cannot find in my admin cp where to send a new pm. All buttons looks same.
thanks in advance

[dreamhost]

disreguard, last post, found it, man I must be really tired :)

[mashby]

This was one of the easiest hacks I've ever installed!

After seeing the results of this hack on VBulletinTemplates.com (http://www.vbulletintemplates.com), I decided that it was way cool and I had to have it on one of my new boards.

Excellent work!

[tpearl5]

Originally posted by vbf.Falco171
Ouhhh I've the solution, from Nicolas2000 a moderator of vBulletin-France Team...


It must be our versions of mySQL. Your code worked for me and sprakz didn't at all. :D

[Schorsch]

thanks for this hack, works fine on my v2.2.6 and installation was very easy :)

regards,
Schorsch

[Floris]

1000th download by me !! :) weeee.

I will use the weekend to install it, nice hack dude. Great job.

[Floris]

installed.. i couldn't wait :P

It works great, nice job!

[PsYc]

hi the popup didn't work


i have this addon installed


https://vborg.vbsupport.ru/showthread.php?s=&threadid=34356


called Improved PM Popup JavaScript


i think there is a little conflict in it

can anybody help

would be nice ;)

[Kiraly]

i have 2.2.6
i have installed the hack
put text before
// sort out emails and usergroups
:(

[Floris]

Why are you sad that you installed vBulletin 2.2.6 and the hack and that you put text somewhere :) I have done that many times, you don't see me commit suicide :D

Explain what is wrong, then users might be able to help out.

[PsYc]

fixed my problem it was just a typo :)

[Sparkz]

This has been downloaded 1017 time(s).
Yay! Can't say I ever expected it to be downloaded more than twice (first time would be me testing to see if it was working after upload - second time would be me testing a week later since the number never increased ;))
Really glad you guys like it :)

[A.T.F]

Originally posted by novel44
Running 2.2.6.

Ran the install.php file. it says successful and creates the table entries in sql, but does not create the admin CP information.

Please assist.


Try clicking "vbulletin options" in your admin cp and it should greate a new tag underneath the "who's online" options, right at the very bottom.

[omegauk]

I bought this forum and they have this hack installed, now users get a message with the ex-owners name but I want to have my name there instead, how to fix this?

[Nightfire]

I'm getting an error on register.php this is on the latest version that's out.

line 814:
char 5
error 'document.forms.0.avatarset.selectedIndex' is not an object
URL http://chatterspics.com/forums/register.php

The only thing I added to register.php was the default pm code in the zip file

The PM does work though, but doesn't tell the user he/she has a pm

[Arekusan]

Awesome hack!

Amazing autoinstall!

U rool!

[8ball]

very good work ;)

[K_2]

Thank you very much, this works in version 2.2.8

K2 clicks 'Install'

[Graphics]

Excellent work Sparkz. Easy to install, and very usefull.

* Works on new PM

[erdem]

allright great hack ..
i installed it ..

but when a new user registered it automatically logged out after registering ..
but users can get pms when they logged in ..

uhmm also pm's has a missing footer .. i mean uhmm dunno how to explain LOL

anyideas on login thing?

[erdem]

bumpy bump ?
;)

[FleaBag]

;) Nice addition to my 2.2.7. Thanks. :)

[erdem]

Originally posted by GamerForums
;) Nice addition to my 2.2.7. Thanks. :)

dont u have "logout" problem ?
:ermm:

[mv540]

I installed the hack flawlessly, until i came to a bump in the road. When i went to go test it, i clicked on register and all i got was a blank white screan....

any suggestions? thx in advance....

I~

[mv540]

hows about an answer people!...thx....

I~

[erdem]

no one interested in bugs/errors ?
any idea?

[mv540]

boy this room really died quickly..incase anyone is wondering ive found the answer to my own question...

thx mv540 for all your hard work and detication...cheers to you mv540..next rounds on me bro... ;)

M

[concept]

i installed everything right but nothign happend in my admin cp? i don;t have the button there

[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/attachment.php?s=&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?

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

[flup]

Nice

[flup]

darn doesn't work @ 2.2.9

[Smoothie]

Works fine for me on 2.2.9

[imageconstrux]

Great hack! Works on 2.2.9

Glad you put the failsafe in there so we don't build the template more than once - the install.txt says click install, click submit.

No 'submit' showed up for me, so I did like others did - clicked 'install' again.

Might save some confusion by just editing the install.txt.

Instead of saying: Select install and press submit.

It'd say:Select Install, when the window changes to show the options to be installed, select Install again, then close the window. I think that's how it went, anyway.

But other than that teeny tiny thing, the install was smooth as silk, did what it was supposed to on the first try, and now all new registrants to my site will get a nice PM from me when they sign up!

Thanks!

Jeff

[Bison]

Originally posted by Sparkz


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.

haven't got around to doing this?

[ernestdefoe]

Okay I had this running in vB 2.3.0 yesterday, but then decided not to use vB and deleted everything including the database. Now I changed my mind, and have decided to use vB again, and now when I try to run the installer file I get this error.

Fatal error: Call to undefined function: cpheader() in /home/twc/public_html/forums/defpm_dbinstall.php on line 4

What could be wrong?

[Verted]

I tried it on v 2.3.0 and the install file didnt work, but it sounds like such a cool hack, perhaps you can get it to work on 2.3.0 because I'd love to have it:)

[Alien]

Anyone have this confirmed working on vB 2.3.0? (Without upgrading from previous versions of course) ;)

-Jason

[Alien]

Never mind, decided to give it a whirl (like I guess I normally do lol) and it worked flawlessly in vB 2.3.0!

Thanks so much for this!

-Jason

[Floris]

Confirmed to work with version 2.3.0
I installed it yesterday on a site of a client.

[gmarik]

Nice to hear it works on 2.3.0
Will install it today.

[paratek]

Works here on 2.30 no problems....Clicks the install!

[Anjie]

INstalled on 2.3.0, and it worked awesome, or so I thought. Everything looked good, everything seemed good. Come to find that registering members never got their confirmation email, and got a database error. After uninstalling everything worked fine again. So I advise all to check and see if a new registration can get the confirmation email. If not this would be why. I wish this did work, the whole thing was too darn cool! :(

[lostsoul2k]

will this hack work for 3.0

[subu1]

sorry but why dont work this easy install Hack not on my vb2.3.0 *cry*

[Catch-22|BL]

*Clicks install

Nice hack!

Working fine in vb2.30

[erikajune]

I get this error when I try to run defpm_dbinstall.php.

Fatal error: Call to undefined function: cpheader() in /home/erika/public_html/community/defpm_dbinstall.php on line 4

Line 4 is: cpheader('<title>>Default PM to new users v2.0</title>');

[ManagerJosh]

I get this error when I try to run defpm_dbinstall.php.

Fatal error: Call to undefined function: cpheader() in /home/erika/public_html/community/defpm_dbinstall.php on line 4

Line 4 is:
anyone make a port for vB3 yet? :)

[beansbaxter]

will this work in 3.0.7?

[Marco van Herwaarden]

Since this is a vB2 hack, it will not work on any vB3 version.

[MarkyLeonard]

It upgraded itself on my 2.3.4 to 3.5 upgrade, works a treat.

Idea : Any chance of a "Test this PM" button? When clicked it sends it to you, so you can check formatting etc. Or failing that, a preview button?