vb.org Archive - New Posting Features - Welcome Thread Upon Registration

vb.org Archive (https://vborg.vbsupport.ru/index.php)

- vBulletin 3.8 Add-ons (https://vborg.vbsupport.ru/forumdisplay.php?f=235)

- - New Posting Features - Welcome Thread Upon Registration (https://vborg.vbsupport.ru/showthread.php?t=214702)

Quote:

Originally Posted by Digital Jedi (Post 1979572)

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:

Code:

$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.

You can download the one from 4.0.1 it works for 3.8.4 i've installed it and no problems at all and has all the fixes to can get it here.

https://vborg.vbsupport.ru/showthread.php?t=229473

I just noticed that its not picking one of the 4 titles and thread content at random. its always displaying the first one.

I have a strange problem, it's posting threads when people register, but also it's posting random threads when people havent registerd. So the thread will just be "welcome" with no username

Does this add the Admin of the sites name to the Welcome message ?????

And if there is a place to add it to show the owners name in the post where does it go ..Thanks ....Sorry but i am new to this ..

Quote:

Originally Posted by Fivestones (Post 2127765)

This posts using whatever user account(s) you select.

i like this mod.

marked installed.

Any plans to port to VB4 would be nice to have on that

i started new hack and come back to add it to new site Thanks

Thanks i have added it to new site thanks

Installed, but presently disabled. I'm getting welcome threads with no usernames. Still investigating cause.

I am not getting any welcome threads at all?!? Any ideas anyone?

Anyone supporting this at all? Or anyone who might be able to help?

Is there something like this for vB4?

adding to site that went down thanks

Seems to be working fine for 4.0.0 PL8 at the moment.

somehow $username does not work in vb 4.2.0

@powerful_rogue

v1.2.2 remains the "unregistered" bug in vbb 4.2

Please help me to fix

https://vborg.vbsupport.ru/attachmen...1&d=1355755459

thanks i am adding it to new site

ooops worked on 4.2.0 too :(

installed and working but created thread goes for moderation even the thread is created by userid = 1

Phrase Groups Available:

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.01229 seconds Memory Usage 1,755KB Queries Executed 10 (?)
More Information
Template Usage: (1)ad_footer_end (1)ad_footer_start (1)ad_header_end (1)ad_header_logo (1)ad_navbar_below (1)bbcode_code_printable (2)bbcode_quote_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)pagenav (1)pagenav_curpage (2)pagenav_pagelink (1)post_thanks_navbar_search (1)printthread (22)printthreadbit (1)spacer_close (1)spacer_open Phrase Groups Available: global postbit showthread	Included Files: ./printthread.php ./global.php ./includes/init.php ./includes/class_core.php ./includes/config.php ./includes/functions.php ./includes/class_hook.php ./includes/modsystem_functions.php ./includes/class_bbcode_alt.php ./includes/class_bbcode.php ./includes/functions_bigthree.php Hooks Called: init_startup init_startup_session_setup_start init_startup_session_setup_complete cache_permissions fetch_threadinfo_query fetch_threadinfo fetch_foruminfo style_fetch cache_templates global_start parse_templates global_setup_complete printthread_start pagenav_page pagenav_complete bbcode_fetch_tags bbcode_create bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete printthread_post printthread_complete
Messages: