PM upon usergroup change And PM with forum password when changed...

[Chris M]

Right...

I've made a script that the user takes before he can access any forums...

It sorts them into a different usergroup depending on their answer

I am using Afterburner's password hack, as well as forum permissions for custom forums...

What I need is that when they are updated into that usergroup, they are sent the password to the custom forum that they can see...

Also - As an addon to this, I need the new password to be sent to the user's in that usergroup that can see that forum every time their Leader changes the password (the password changes every month)

Can someone help me do this, or give me the code to do it?

Satan

[Xenon]

well, the first one is easy, you just have to insert a new row into the privatemessage table, you should be able to do so..

the scond one should be as easy to you need a while construct:

PHP Code:

$users=$DB_site->query("SELECT userid FROM user WHERE usergroupid=XXX");
while($user=$DB_site->fetch_array($users)) {
  $DB_site->query("INSERT INTO privatemessage.......");
} 


[Chris M]

A new row?

Oh...You mean field?

There are 4 different passwords though...Can it be done?

Satan

[Xenon]

no i mean row

just use an insert into query

[Chris M]

How would that work?

The password is stored in the forum table, and there are 4 forums for 4 different usergroups which will have 4 different passwords

Satan

[Xenon]

PHP Code:

$pw=$DB_site->query("SELECT password FROM forum WHERE forumid=YY");
$users=$DB_site->query("SELECT userid FROM user WHERE usergroupid=XXX");
while($user=$DB_site->fetch_array($users)) {
  $DB_site->query("INSERT INTO privatemessage (privatemessageid,userid,touserid,fromuserid,folderid,title,message,dateline) VALUES (NULL,$user[userid],$user[userid],1,0,'New password','".addslashes($pw[password])."',".time().")");
} 


[Chris M]

Ah

Thanks Xenon

Satan

[Xenon]

welcome