I am working on a function that automatically send a new registering user a welcome PM, but I've gotten stuck somehwere in the middle I created a file called inc_func_pm , and right now it contains the following function:

<deleted>

(Does this belong in the DEV forum?)<

Best of luck with this MOD, Jorrit. There is a Welcome PM MOD available here but it hasn't been updated for four years. Would be a great feature! <

I'm having trouble getting the MEMBER_ID to send the Welcome PM to from the database. Right now the code I have is this:
Is this the right way to select the MEMBER_ID and to pass it on to PMNID (the value that determines to whom the PM is sent) <

I took out that widdle pm mod out from my site so I don't know for sure if anything if this will be right but it outta be close. Two things with this sql statement which presents a problem....what happens if there is never a value of 0?!? You will get an error page that the statement is true so you need an if else statement. And the second it doesn't appear as if it is saving anything. Try something like this:

'### Forum SQL - Get the Member ID to send the Welcome PM to
strSql = "SELECT MEMBER_ID FROM " & strTablePrefix & "MEMBERS "
strSql = strSql & " WHERE M_WPMSENT = 0 "

set rsMember = my_conn.Execute(strSql)
do while not rsMember.EOF
myMember = rsMember ("MEMBER_ID")

'the action you want to perform goes here

rsMember.MoveNext
loop
rsMember.close
set RsMember = nothing

Essientially this will run through the database and perform an action if a member has a value = to 0. Also be sure within the loop to update the value to 1 otherwise the loop will run forever. Again this is just an educated guess based on past sql statements I have had to write but since I don't have the mod installed anymore I can't test the theory out for you. Good luck!<

And the second it doesn't appear as if it is saving anything.

The code above is not the whole code... I'm not that dense
I think I'm about done... I'll do some final bug-checking and then I'll post the MOD here. So far the MOD sends the new user a welcome PM and it notifies Admins of the new member's registration.<

This MOD is just what I needed, so was wondering if you managed to complete it?
Thanks,
Oli<

*bump* ?<

Sorry to bump again, but does anyone know if this was ever continued please?
Thanks<

Sounds like you might be better off emailing Jorrit. Would be a very nice MOD to have available, that one.<

Several people have emailed me about this; I am not working on this any more.<

Hmm. Maybe you could post what you have? A lot of people would be interested in this and it's a shame that it was left in limbo after:

I think I'm about done...

<

I lost the preliminary package I had made in a hard disk crash a while ago, and it's been too long since I have even looked at it, so I doubt that I would be able to re-assemble it.
From what I remember it was not all that difficult of a venture, so why don't you (or someome else) give it a shot yourself? I'll see if I can help in case you get stuck.<

I lost the preliminary package I had made in a hard disk crash a while ago

Ooh, that's bad luck. Sorry to hear that.<

I lost the preliminary package I had made in a hard disk crash a while ago

Ooh, that's bad luck. Sorry to hear that. Not if Mr. Me had been smart enough to make some backups <

Hi :-)
Any news about this great mod?<

I have a copy of the
Unofficial MOD for MWP1.2 made by DarkLord

but I don't know if I can share it.. I cannot reach the author. If our admins think I can share, I'll do it.<

There is a working mod for this out there somewhere, I have it installed.. I think it was called "Auto PM New Users". <

>>>>out there somewhere
Nice!! ^_____^
But...where?<

Why not try SnitzBitz: http://www.snitzbitz.com/mods/details.asp?Version=All&mid=143

The top one works, just do not replace your admin_home.asp or register.asp files, just look for WELCOME LETTER MOD in each of these files and you should work out how to get them to work.
As per usual, back up you files and DB before adding MODs to your systems. <

Tks! :-)
But...it's not same thing.. Sending a PM you'll can talk with newbie (if he send you a reply, of course..)<

Ain't that what's done in the mod I was talking about? <

But you try to find that MOD. Nearest I got (using Google) was this mentioning that the MOD is now a part of MaxWebPortal.<

Have you tried searching on shnforum.com? Maybe I got the mod from there, it should work on a clean snitz if that's the case. <