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)

cybergas 12-06-2009 02:17 AM

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 12-06-2009 04:27 AM

Quote:

Originally Posted by cybergas (Post 1926071)
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 12-06-2009 03:36 PM

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 12-06-2009 08:45 PM

Quote:

Originally Posted by cybergas (Post 1926347)
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^ 01-08-2010 02:03 AM

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

good job BBR!

^SuiCyde^ 01-08-2010 02:34 AM

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

laztrix 01-24-2010 12:22 PM

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 01-24-2010 01:10 PM

Any progress on vbulletin 4 version?

ozmazdaclub 02-01-2010 05:30 AM

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 02-10-2010 10:53 PM

Quote:

Originally Posted by ozmazdaclub (Post 1971893)
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:
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.


All times are GMT. The time now is 03:34 PM.

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.01258 seconds
  • Memory Usage 1,747KB
  • 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
  • (3)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