New Users Create their own Welcome thread During Registration

[ap0c]

Since I didn't find this exact hack around, here you go.

This hack creates a new welcome thread in the users name after email conformation in the forum of your choice,
and is the new forum user's first post on your board.
Since the new forum user has 1 post, it is easier for admins to check for banned members.
Depending on the admincp settings this is either required to be filled in during the registration process,
or a default reply will be inserted.
You also have the ability to redirect the new user to their post if you want.
The new thread and post will appear on the forums after they reply to the activation email.

Things to do:
-------------------
9 mysql queries to run
1 File ( 6 edits)
1 Template edit
2 new templates to create
Set vboptions


Time to install:
-----------------
a few minutes

pics to follow

edit: updated to include allowing users to create thier own thread title, see instructions for upgrade information

[ap0c]

registration page pic

[ap0c]

new thread and post created with a default message

[ap0c]

user created message

[Kenji Wing]

very nice apoc this iwll go great with my new members section ^_^

[Dean C]

Very nice idea :)!

- miSt

[ap0c]

thanks for the comments Kenji and Mist

[Bulleh]

whats it like for bugs? safe enough to install and use?

[Bulleh]

seeems ok Very nice hack, summut i wanted :)

[Bulleh]

actually, now i got a database error :|

[ap0c]

what kind of error?

[Bulleh]

i donno, it just Says theres an Error With the Database, Please Contact Admin

So i reverted to the backup register.php for now.....mite have a mistake in the register.php somewhere tho im guessing around...
// homepage doesn't match the http://-style format in the beginning -- possible attempted exploit
$homepage = '';
}
}
$DB_site->query("INSERT INTO user (userid,username,password,email,".$newstylefield."parentemail,coppauser,homepage,icq,aim,yahoo,signa ture,adminemail,showemail,invisible,usertitle,join date,cookieuser,daysprune,lastvisit,lastactivity,u sergroupid,timezoneoffset,emailnotification,receiv epm,emailonpm,options,birthday,maxposts,startofwee k,ipaddress,pmpopup,referrerid,nosessionhash,avata rid,regthread) VALUES (NULL,'".addslashes(htmlspecialchars($username))."','".addslashes(md5($password))."','".addslashes(htmlspecialchars($email))."',".$newstyleval."'".addslashes(htmlspecialchars($parentemail))."','$coppauser','".addslashes(htmlspecialchars($homepage))."','".addslashes(htmlspecialchars($icq))."','".addslashes(htmlspecialchars($aim))."','".addslashes(htmlspecialchars($yahoo))."','".addslashes($signature)."','$adminemail','$showemail','$invisible','".addslashes($usertitle)."','".time()."','$cookieuser','".addslashes($prunedays)."','".time()."','".time()."','$newusergroupid','".addslashes($timezoneoffset)."','$emailnotification','$receivepm','$emailonpm',' $options','".addslashes($birthday)."','".addslashes($umaxposts)."','".addslashes($startofweek)."','".addslashes($ipaddress)."','$pmpopup','".addslashes($testreferrerid['userid'])."','$nosessionhash','$avatarid')");
$DB_site->query("INSERT INTO user (userid,username,password,email,".$newstylefield."parentemail,coppauser,homepage,icq,aim,yahoo,signa ture,adminemail,showemail,invisible,usertitle,join date,cookieuser,daysprune,lastvisit,lastactivity,u sergroupid,timezoneoffset,emailnotification,receiv epm,emailonpm,options,birthday,maxposts,startofwee k,ipaddress,pmpopup,referrerid,nosessionhash,avata rid,country) VALUES (NULL,'".addslashes(htmlspecialchars($username))."','".addslashes(md5($password))."','".addslashes(htmlspecialchars($email))."',".$newstyleval."'".addslashes(htmlspecialchars($parentemail))."','$coppauser','".addslashes(htmlspecialchars($homepage))."','".addslashes(htmlspecialchars($icq))."','".addslashes(htmlspecialchars($aim))."','".addslashes(htmlspecialchars($yahoo))."','".addslashes($signature)."','$adminemail','$showemail','$invisible','".addslashes($usertitle)."','".time()."','$cookieuser','".addslashes($prunedays)."','".time()."','".time()."','$newusergroupid','".addslashes($timezoneoffset)."','$emailnotification','$receivepm','$emailonpm',' $options','".addslashes($birthday)."','".addslashes($umaxposts)."','".addslashes($startofweek)."','".addslashes($ipaddress)."','$pmpopup','".addslashes($testreferrerid['userid'])."','$nosessionhash','$avatarid','".addslashes($country).",".addslashes($regthread)."')");

as i couldnt copy and paste straight over cus i got other hack code there, u see the prob?

[ap0c]

try this
$DB_site->query("INSERT INTO user (userid,username,password,email,".$newstylefield." parentemail,coppauser,homepage,icq,aim,yahoo,signa ture,adminemail,showemail,invisible,usertitle,join date,cookieuser,daysprune,lastvisit,lastactivity,u sergroupid,timezoneoffset,emailnotification,receiv epm,emailonpm,options,birthday,maxposts,startofwee k,ipaddress,pmpopup,referrerid,nosessionhash,avata rid,country,regthread) VALUES (NULL,'".addslashes(htmlspecialchars($username))."','".addslashes(md5($password))."','".addslashes(htmlspecialchars($email))."',".$newstyleval."'".addslashes(htmlspecialchars($parentemail))."','$coppauser','".addslashes(htmlspecialchars($homepage))."','".addslashes(htmlspecialchars($icq))."','".addslashes(htmlspecialchars($aim))."','".addslashes(htmlspecialchars($yahoo))."','".addslashes($signature)."','$adminemail','$showemail','$invisible','".addslashes($usertitle)."','".time()."','$cookieuser','".addslashes($prunedays)."','".time()."','".time()."','$newusergroupid','".addslashes($timezoneoffset)."','$emailnotification','$receivepm','$emailonpm',' $options','".addslashes($birthday)."','".addslashes($umaxposts)."','".addslashes($startofweek)."','".addslashes($ipaddress)."','$pmpopup','".addslashes($testreferrerid['userid'])."','$nosessionhash','$avatarid','".addslashes($country).",".addslashes($regthread)."')");

[Bulleh]

i still get some Database error, can i send you my register.php some how and u Do it for me please? :) wud be appreciated ta

[Hoffi]

A very nice Idea.

But I don't Hack my Board even more till 3 is released.

[KISS]

Anyway it could be made to force user to fill in the welcome thread during registration instead of using a default one?

[Ian Cunningham]

Are the users automatically taken to that thread once they have registered?

[ap0c]

@KISS - yes, maybe I'll have time tomorrow night to write it. It's not hard, move the welcome thread box to the top of the page under email and change the code to, if nothing is inserted give a standard required field error


@Ian - no not presently, but by changing the redirection link they could be:)

[Dean C]

ap0c - at KISS's question i suggest a nice admin cp option :) And the same with Ian's :)

- miSt

[ap0c]

Today at 07:47 AM Mist said this in Post #19 (https://vborg.vbsupport.ru/showthread.php?postid=418678#post418678)
ap0c - at KISS's question i suggest a nice admin cp option :) And the same with Ian's :)

- miSt

see post below, done

[KISS]

07-17-03 at 04:54 PM ap0c said this in Post #18 (https://vborg.vbsupport.ru/showthread.php?postid=418571#post418571)
@KISS - yes, maybe I'll have time tomorrow night to write it. It's not hard, move the welcome thread box to the top of the page under email and change the code to, if nothing is inserted give a standard required field error


@Ian - no not presently, but by changing the redirection link they could be:)



Any update on this. I really like this option and would love to have it.

[ap0c]

For requiring this during registration,done update soon.

[ap0c]

07-18-03 at 07:47 AM Mist said this in Post #19 (https://vborg.vbsupport.ru/showthread.php?postid=418678#post418678)
ap0c - at KISS's question i suggest a nice admin cp option :) And the same with Ian's :)

- miSt


Is there anything else anyone can think of that needs to be added to the admincp? (see pic)

[KISS]

Nope, that looks great. Can't wait to try it out.. Awesome work!

[Oblivion Knight]

It's looking good ap0c, especially now with admin panel integration :)

Keep up the good work!

[ap0c]

Update to this hack

updated the first post to include the new instructions.
Every thing should work :cool: Make sure you update the admincp options!!!


New options added in the admincp for:
-requiring this to be filled during registration
-admin decides to redirect to the new thread created or not
-default title can be changed through the admincp
-default post can be changed through the admincp

let me know if you find any bugs.
apoc

[KISS]

I have email verification turned on during regisrtation, when I test this out with it. I get a database error during the email verification part. And I get 5 Welcome posts that are Identical from that which I think is one per time I clicked the verification link.

With it turned off I get no welcome message at all.

Any clues?

[ap0c]

what are the lines around the db error line?
Did you install the first beta version?

[KISS]

Invalid SQL: UPDATE user SET usergroupid=, usertitle='' WHERE userid='684'
mysql error: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near ' usertitle='' WHERE userid='684'' at line 1

mysql error number: 1064

And yes I used the first database version.. If I uninstall this version the old one still works.

But thats the exact error I get. When Installed.

[ap0c]

KISS, check your pm

around line 375 find and remove:

//registration hack
if ($regthread=="") {
$regthread="Hi, Im your newest member. I look forward to being part of this community";
$regthread=censortext($regthread);
}

see if removing this helps

[KISS]

Thanks for you help ap0c, got it all worked out with what you suggested.

Maybe a few more suggestions if you plan on updating it again as after you fixing my problem I discovered or more like realised some other things that could be added to this hack.

1) The Thread Title, maybe add another line to the registration above the welcome thread area with thread title so they can give it there own title.

2) Minimum Characters requirement, I see you have a maximum characters to it, but whats to stop someone from just typing any one letter to by pass it?

3) Just a thought, maybe add the smilie box there to? Or is that just overdoing it? Yea maybe so.

Forgive me just talking to myself.

Thanks again ap0c

[ap0c]

@KISS glad we found the extra} from the previous version:D
I look forward to seeing your forum when it goes live.



can a mod move this thread to full releases as I'm confident no bugs remain, thanks

[NuclioN]

Clicked 'Install' :) Working great. It's stimulating new members to participate smooth in your forum. If you have the quick registration hack with fields above the threads in every subforum it needs the code in that template(s) as well or registration from that point will not work.

[NuclioN]

Is it possible to use the Dos bot hack https://vborg.vbsupport.ru/showthread.php?t=58124 so when someone has registered and the welcome thread appears, it contains already a command as for example !help and a list of shortcuts to forumfunctions will emerge?

[Gio Takahashi]

Is it possible to use the Dos bot hack https://vborg.vbsupport.ru/showthread.php?t=58124 so when someone has registered and the welcome thread appears, it contains already a command as for example !help and a list of shortcuts to forumfunctions will emerge?
The dos bot only runs on "replies" It doesn't run on threads for some reason =/

[NuclioN]

?? When a new member is registering it is required to make at least 1 word for an openingstopic otherwise it is impossible to proceed. If it is possible to push the command !help as a sort of prefix in this topic then the bot will reply immediatly after the welcometopic with a whole list of botcommands to help the new member finding the way in the huge amount of functions and hacks for your forum. :)

[ap0c]

Is it possible to use the Dos bot hack https://vborg.vbsupport.ru/showthread.php?t=58124 so when someone has registered and the welcome thread appears, it contains already a command as for example !help and a list of shortcuts to forumfunctions will emerge?
off hand I would say yes if the proper check coding was added to the post creation part of the hack. Ie, $regthread I think it's called. Having never seen the vbdos bot hack in action, it's a guess but it should work.

[Rampag33]

This is a great hacc, plain on installing it tonight

***installed***

[VAN]

I can't get this to work with 2.3.3. I'm not getting any DB errors--the thread just isnt being created. I've installed and re-installed it about 5 times now, but I'm not having any luck.

Any ideas?

[ap0c]

did you set the admin cp options in settings?

[VAN]

did you set the admin cp options in settings?

Yeah. I'm not *that* dense. :D

::goes to doublecheck::

Yeah. Everything seems fine, but no thread is being posted.

[ap0c]

Do you require moderation of new members?
I havent upgraded to 2.3.3 yet, planning to this weekend. But if nothing was changed in the way registration works, and your recieving no errors, hmmm

[ap0c]

if the link in the www button is correct, you forgot to edit the template

[VAN]

if the link in the www button is correct, you forgot to edit the template

No. I'm installing the hack on my testboard. The template edit was made, and I'm not moderating new members.

[jdennis]

I'm on 2.3.2, and just installed this... followed all the instructions, and am also not getting a welcome thread. I don't verify email on registration, and new users are not moderated. New users can register and post, but I'm just not getting the welcome thread! I have it set to redirect users to their welcome thread, too, and that doesn't happen - they just go to the forum index.

[ap0c]

you need verify email for this to work.

[jdennis]

is there any way to change it so that it works without verifying emails?

[ap0c]

is there any way to change it so that it works without verifying emails?
I'm not sure if this works or not, I havent tried it, but try this

[MaDCaT75]

say is there any way to generate random welcome thread titles? Not just have "welcome to our newest member" for every thread that is created? :confused:

[subu1]

hi verry fine Hack *klick install*

but how you are all this Hack to work. Is the Option on for your new Member write a new Topic?????

[Anjie]

It installed fine, however, you can't change your email or you get kicked back to user awaiting confirmation. Any ideas?

[jp2]

installed. Nice hack.

It would be good if it would work without the email verify thing, and also if you could change the title of your thread on signup.

[YLP1]

Will this mod work with 3.0.03?

[jpt62089]

thats what i wanna know :p

[ap0c]

no it wont work in vb3. I have the admincp side done for vb3 but havent finished the rest yet.

[jpt62089]

:'( ok well take your time :p

[m0h2]

Any news about VB3? :)

[kaotic]

No, but wouldn't it be great if there was? :)

[mholtum]

A very nice Idea.

But I don't Hack my Board even more till 3 is released.3.0.3 is already released. Unless I misunderstand you.

[ap0c]

update to the 2.x.x hack this weekend, users can select thier own thead title, as well as a beta for vb3

[Lionel]

would love to see this for vb3

[YLP1]

Will this work for ver 3.0.7?