New Posting Features - Welcome Thread Upon Registration

Welcome Thread Upon Registration

This mod creates a welcome thread when a new member registers.

Features controlled via the ACP (See screenshot)

- Thread Title
- Thread Message
- Forum Location
- Post Icon
- Which User Creates Thread
- Thread Placed In Moderation
- Create Thread Before/After Email Activation
- Have a Random Title
- Have Random Thread Content
- Post From a Random Member
- Post a Random Icon

When is the thread created?

You now have the choice via the ACP! A thread can be created as soon as a member registers, or if you use email activation on your board, you can have the thread created once they have activated their email.

Boards that require an admin to approve new users

This mod has an option to place new threads into moderation. Once the new user has been approved via an admin, you can then release the new thread.

New Features in Version 1.2

Does your welcome forum look a little bit "samey" like this?


Same old thread title, same old post icon, same old user posting the thread and when you go inside it has the same old content?

Well maybe I could interest you in the latest version of this mod!



You decide on four titles and the content of four threads! You can also select the UserID's of who you want the threads to be created by. You can also select to have random post icons! - All controlled via the ACP.

Its all random. Thread title one doesnt belong to thread content one and thread title two doesnt belong to thread content two. With this mod when a member registers, thread title one may be posted with the contents of thread content four and thread title three might be posted with thread content two etc. The same goes with the UserID's and the post icon.

Download
v1.1 = product-welcomethread280509updated
v1.2 = product-welcomethread300509
v1.2.1 = product-welcomethread030609
v1.2.2 = Fixed the issue of "Welcome Unregistered" showing if you have email activation on.

Installation
Import product via ACP
Edit settings via vbulletin options >> Welcome Thread Upon Registration

Upgrade
Import product via ACP, Click "yes" to allow overwrite.
Edit settings via vbulletin options >> Welcome Thread Upon Registration

Screenshots
The screenshots show the ACP in version 1.2. I was unable to fit it all into one image, so had to split the image in half.

Although I have marked this as supported im a very new coder and this is my first release. I have tested it by signing up over 100 users on my test board and as yet there have been no glitches.
If there are any errors, I will try my best to resolve them, however as being new im still learning the ropes.

Version History
v1.0 - First release 28/05/09 (98 d/l)
v1.1 - Thread creation after email activation added / Post Icon added 28/05/09
v1.2 - Random titles/UserID/Thread content/Post icons 30/05/2009 (49 d/l)
v1.2.1 - Allows you to have the members name created as a link to their profile (88 d/l)
v1.2.2 - Fixed the "unregistered" bug

[cybergas]

this is a great idea, I salute the original poster idea and thank for his efforts to try to make it work, as well as the others who had fixed the bugs.

However, is there a way the bugs fixed and all that can come in product upgrade, let's say version 1.3 or so? I run 3.8.4 and tagged install right before installing but then I took my time to read the whole thread and now I am not installing this until find something similar fully debugged. Is there any other developer that already came up with it under other name? or just BBR-APBT is in charge of this for now and for the vB4.0 (which we are not upgrading since still in beta).

[BBR-APBT]

Originally Posted by cybergas

this is a great idea, I salute the original poster idea and thank for his efforts to try to make it work, as well as the others who had fixed the bugs.

However, is there a way the bugs fixed and all that can come in product upgrade, let's say version 1.3 or so? I run 3.8.4 and tagged install right before installing but then I took my time to read the whole thread and now I am not installing this until find something similar fully debugged. Is there any other developer that already came up with it under other name? or just BBR-APBT is in charge of this for now and for the vB4.0 (which we are not upgrading since still in beta).

Do you have a test site?

Try to install the version for 4.0 on the 3.8 test site. It just may work!!!

[cybergas]

No test site yet... all the test I run them on the demo vesion but as you know no products/mods can be installed
I will give try on the low activity hours on the forum, thanks a lot for the info, I thought the 4.0 was a completely rewrite so the product will not work there.

Let you know! :up:

[BBR-APBT]

Originally Posted by cybergas

No test site yet... all the test I run them on the demo vesion but as you know no products/mods can be installed
I will give try on the low activity hours on the forum, thanks a lot for the info, I thought the 4.0 was a completely rewrite so the product will not work there.

Let you know! :up:

This really doesn't use much on the vbulletin side of things that have changed. Which is why I said it may work. I don't have a test site for 3.8 only for 4.0 or I would have tested it.

[^SuiCyde^]

testing for 3.8 now, been waiting for the bugs to be worked out of this one

good job BBR!

[^SuiCyde^]

seems to be no issues thus far on 3.8 test board for the record

[laztrix]

I've installed product-welcomethread140609.xml this one. It sends the messages with random users but random messages won't work on my 3.8.4 board. In addition to that it send only 4 of the users while I have more than 4 users written to post a welcome thread.

[BrightStar]

Any progress on vbulletin 4 version?

[ozmazdaclub]

getting a database error:

Database error in vBulletin 3.8.4:

Invalid SQL:

SELECT userid
FROM useractivation
WHERE activationid = 'd62941f74c66347c70fd99dd255c4849000fe92d';

MySQL Error : Table 'ozmazdac_forum.useractivation' doesn't exist
Error Number : 1146
Request Date : Monday, February 1st 2010 @ 05:41:38 PM
Error Date : Monday, February 1st 2010 @ 05:41:38 PM
Script : http://www.ozmazdaclub.com/forums/re...hp?do=activate
Referrer : http://www.ozmazdaclub.com/forums/register.php?a=ver
IP Address : 58.165.1.223
Username : wildrose85
Classname : vB_Database
MySQL Version :

[Digital Jedi]

Originally Posted by ozmazdaclub

getting a database error:

Database error in vBulletin 3.8.4:

Invalid SQL:

SELECT userid
FROM useractivation
WHERE activationid = 'd62941f74c66347c70fd99dd255c4849000fe92d';

MySQL Error : Table 'ozmazdac_forum.useractivation' doesn't exist
Error Number : 1146
Request Date : Monday, February 1st 2010 @ 05:41:38 PM
Error Date : Monday, February 1st 2010 @ 05:41:38 PM
Script : http://www.ozmazdaclub.com/forums/re...hp?do=activate
Referrer : http://www.ozmazdaclub.com/forums/register.php?a=ver
IP Address : 58.165.1.223
Username : wildrose85
Classname : vB_Database
MySQL Version :

I got this same error today. I'm no expert at SQL, but I know enough to know that it appears one of the plugins is trying to SELECT the id from a table name, without accounting for your table's prefix first. I was able to fix it this way.

Like I said, I'm no expert, so use at your own risk. But it makes sense to me. Maybe someone more versed in MySQL can verify.

In Plugins & Products >> Plugin Manager >> Product : Welcome Thread, edit the plugin that uses the register_activate_start hook. Add the code in red:

$useridnumber = $db->query_first(" 
    SELECT userid 
    FROM " . TABLE_PREFIX . "useractivation 
    WHERE activationid = '" . $vbulletin->db->escape_string($vbulletin->GPC['i']) . "'

Be careful with the syntax. The syntax is important. Don't just assume that quote mark or period or what have you is unimportant. It needs to be there.