Welcome Message in Any Forum

Ok. I have edited PPN's new member in a forum hack to welcome someone into any forum on your board.
Basically if you want to welcome a member and have your current members welcome them this is the hack for you.
Check out the text file it has all you need to do it.
Thanks to PPN for the majority of this hack! 99% of the credit goes to him.
You can see it in action here:
http://www.lotronline.com/forums/for...p?s=&forumid=3
Comments and questions are appreciated!

[Karri]

bump...

[diettalk]

I cannot run a sql query.. can someone please make me an Install script for the query.. thanks.

Also is there a FAQ about how to read about queries? I'm interested. Thanks.

[hypedave]

in stead of it haveing the post created from autoposter
how do I get it to have my name as the thread creator ?

[sub]

This is my first contribute to help ppl so here is some of you all answers to your questions and something more. :laugh:

PHP Code:

(NULL,'".addslashes(htmlspecialchars("$username"))."','".time()."',
'$newregthreadforumid','1','0','".addslashes("YOURUSERNAME")."','USERID#','"
.addslashes("Auto Poster")."','".time()."XXX','0','1','0')"); 


Edit the these feilds to your desire:
YOURUSERNAME: This is where you put your username at
USERID#: Your user ID # goes there too like mine is 1
XXX: SIGGIE Option Variable: 0 for OFF and 1 for ON
(I renamed the feilds to above for easy reading but you get the idea)

as for the welcome text in the subject:

PHP Code:

$DB_site->query("INSERT INTO thread (threadid,title,lastpost,forumid,open,replycount,postusername,postuserid,lastposter,dateline,iconid,visible,attach) VALUES (NULL,'".addslashes(htmlspecialchars("Welcome $username"))."','".time()."','$newregthreadforumid','1','0','".addslashes("YOURUSERNAME")."','USERID#','".addslashes("YOURUSERNAME")."','".time()."','0','1','0')"); 


Look above and see "Welcome $username" thats where you edit the subject feild. Take care and have fun!

I hope I helped you all and no pun to the creator of this hack, just helping out.

Oh and BTW. GREAT HACK! Congrats!

[Dark Shogun]

Can anyone tell me how to make it so that my account is the account that introduces the new people because I tried these instructions and it doesn't work for me.

Dark Shogun

[MGSteve]

Excellent stuff, cheers!

[Bison]

I'd like to know how to get this to work if you manually add(+) a user! I added this to my admin/user.php file but the thread came up blank!

Update:

I did get it to post the username into the thread title but the "welcome_newuser" template contents wouldn't print inside the thread ....

Any suggestions?

[eyeman]

I was looking for some help and some select have helped while I was searching for my membership info...I have it now and just wanted to say thank you for the help...

[eyeman]

I am learning php, mysql is limited, do I need to mess with the database to install this welcome script?

[dontpanic]

If you want to update the post count of the user you have configured the welcome to come from, just add this code:

PHP Code:

$DB_site->query("UPDATE user SET posts=posts+1+WHERE+userid=XX"); 


Change the XX to match the userid of the user you have configured. This code gets added just above the tail end of the hack:

PHP Code:

  }

//END Hack to Post userinfo to a forum 


Great hack! I have been personally welcoming new users manually...not it will be done automatically for me, invisibly to them. Sweet!