vb.org Archive

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)

Erica1977 02-10-2010 10:59 PM

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

Itchy Nips 02-25-2010 01:38 PM

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

matthewhotdude 04-05-2010 12:29 PM

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

Fivestones 12-01-2010 02:22 AM

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

Digital Jedi 12-04-2010 01:12 PM

Quote:

Originally Posted by Fivestones (Post 2127765)
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 ..

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

Scyther 06-24-2011 04:22 AM

i like this mod.

marked installed.

RedDevil 08-04-2011 08:13 AM

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

Fivestones 10-31-2011 08:29 PM

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

Fivestones 01-20-2012 04:43 AM

Thanks i have added it to new site thanks

BlownFiveLiter 02-06-2012 03:26 PM

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


All times are GMT. The time now is 04:13 AM.

Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.

X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.04900 seconds
  • Memory Usage 1,735KB
  • 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
  • (4)pagenav_pagelink
  • (1)pagenav_pagelinkrel
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (10)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