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)

Mahar 09-16-2009 04:51 AM

Very Very nice hack. Installed. :)

Stifmeister2 09-23-2009 09:15 PM

Quote:

Originally Posted by SirAdrian (Post 1875880)
If you guys want to fix the IP's:

Edit both plugins, find
PHP Code:

$threaddm->set('visible'$visible); 

Below it, add
PHP Code:

$threaddm->set('ipaddress'IPADDRESS); 

Cheers

Are you sure this works?? I did it and I'm still getting weird IPs for the welcome thread starter... :S

Adrian Schneider 09-23-2009 09:55 PM

Works, but you may want it to post from the person being welcomed rather than someone else, or the IP associations will be out of wack like you said. :)

Cloudrunner 09-24-2009 12:35 AM

Fix for the DB error after email click for activation:

Find in the plugin "Welcome thread upon registration -> register_activate_start"
Code:

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

Replace with
Code:

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

No more database errors.

Cloudrunner 09-24-2009 01:09 AM

To get it to truly randomize ...

In BOTH "welcome thread upon registration" plugins:

Find:
Code:

$rand_title = array_rand($title, 4);
Replace with:
Code:

$rand_title = array_rand($title);
Find:
Code:

$rand_text = array_rand($pagetext, 4);
Replace with:
Code:

$rand_text = array_rand($pagetext);
Find:
Code:

$threaddm->setr('pagetext', $pagetext[$rand_text[0]]);
$threaddm->setr('title', $title[$rand_title[0]]);

Replace with:
Code:

$threaddm->setr('pagetext', $pagetext[$rand_text]);
$threaddm->setr('title', $title[$rand_title]);

This fixes the problems I have found. I will post any more fixes if I find any other problems.

Stifmeister2 09-24-2009 09:36 PM

Quote:

Originally Posted by SirAdrian (Post 1889653)
Works, but you may want it to post from the person being welcomed rather than someone else, or the IP associations will be out of wack like you said. :)

Damnit. We like to have random poster... Is there any way to get the posters real IP (I guess not)? Or the same IP for every welcome topic started (like 123.123.123.123)??

Adrian Schneider 09-24-2009 10:07 PM

If you have a dedicated bot account, you could use a fake IP:
PHP Code:

$threaddm->set('ipaddress''123.123.123.123'); 


CMFINC 09-25-2009 12:49 AM

id like to thank all the people trying to help get this one going.. so far so good on this end other than the IP thing...
SirAdrin im trying your frist IP fix post.. see what will happen now. LOL..
again thank you all.

jimjam 09-29-2009 04:58 AM

Hi this is working well, but its not showing the welcoming posters signature. I really need the signature to show as there are important links in it. Is it possible to show the signature as well. Thanks

abdulbasitsaeed 10-15-2009 09:21 AM

Thank you for this awesome mod! :)

I have this weird problem, and would be grateful if someone could help me sort it out.

I have entered the ID's of the post icons I want to use for the welcome thread when it is generated. However, the mod seems to not recognize them and uses its own icons. And yes, I am sure that I am entering the ID, and not the display order of the post icons.

e.g. I first entered these IDs: 28,34,24

The ID's of the icons it uses are: 2 and 3



Then I entered only 28.

Now it uses icon with ID 2.


Does the mod recognize only the first digit of the ID's entered?

On other thing, if I may mention. I have 2 separate categories of post icons. One with the default vbulletin ones and another with my own personal selection. I don't think that it should matter, since the ID of every post icon is unique, regardless of category. Still thought I'd mention it.

Hope someone can make some sense out of this. Thanks!

abdulbasitsaeed 10-16-2009 07:10 PM

OK. Just to add a few more things.

When no post icon ID is given, it uses the paper icon as has been mentioned before.

I'm using the "make thread after email verification" option, and it seems to create multiple threads with some new registrations. And of these multiple threads, only one will have the username given. The rest simply say..."Welcome ," instead of "Welcome user,"

Any idea what's going wrong here? Is it not compatible with 3.8.4?

Mr. W 10-17-2009 01:21 AM

____This modification seems to be better, and a lot more full featured than this one: https://vborg.vbsupport.ru/showthread.php?t=165951

____However, it does do one thing that yours doesn't appear to do, or allow for. When a new user registers, can you add an option in the ACP where the thread will appear to have been written by that very user (the one who just registered)? If you added that, then that would make this modification nearly perfect for it's purpose.

____Another idea that builds on this, if it's not too hard to implement, would be to have the user automatically subscribe to this new Introduction thread. Again, this would be an option within the ACP. If you added this as well, then this modification would indeed be perfect for it's purpose.

elwachiman 11-04-2009 08:51 PM

Excelent¡¡¡¡¡

pantani 11-05-2009 06:11 AM

Thanks, nice one

abdulbasitsaeed 11-09-2009 08:28 AM

Quote:

Originally Posted by jimjam (Post 1892150)
Hi this is working well, but its not showing the welcoming posters signature. I really need the signature to show as there are important links in it. Is it possible to show the signature as well. Thanks

Yeah, I am having the same problem too.

metalguy639 11-19-2009 01:13 PM

I got a serious database issue with this mod. I was wondering if there was a fix for it. It happens when a user registers for the site. They register and then when they get the activation e-mail and try to click the link the board gives them a database error. Here is the error.

Code:


Database error in vBulletin 3.8.4:

Invalid SQL:

    SELECT userid
    FROM useractivation
    WHERE activationid = '5caae7dd108e1765562bcdeab25f2b44a020a0a2';

MySQL Error  : Table 'admin_forum.useractivation' doesn't exist
Error Number  : 1146
Request Date  : Wednesday, November 18th 2009 @ 05:07:37 PM
Error Date    : Wednesday, November 18th 2009 @ 05:07:37 PM
Script        : XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX
Referrer      : XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX
IP Address    :XX.XX.XX.XX
Username      : Unregistered
Classname    : vB_Database
MySQL Version :

Any help would be great, thanks.

gbechtel 11-20-2009 01:32 AM

Quote:

Originally Posted by metalguy639 (Post 1917208)
I got a serious database issue with this mod. I was wondering if there was a fix for it. It happens when a user registers for the site. They register and then when they get the activation e-mail and try to click the link the board gives them a database error. Here is the error.

Code:


Database error in vBulletin 3.8.4:
 
Invalid SQL:
 
    SELECT userid
    FROM useractivation
    WHERE activationid = '5caae7dd108e1765562bcdeab25f2b44a020a0a2';
 
MySQL Error  : Table 'admin_forum.useractivation' doesn't exist
Error Number  : 1146
Request Date  : Wednesday, November 18th 2009 @ 05:07:37 PM
Error Date    : Wednesday, November 18th 2009 @ 05:07:37 PM
Script        : XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX
Referrer      : XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX
IP Address    :XX.XX.XX.XX
Username      : Unregistered
Classname    : vB_Database
MySQL Version :

Any help would be great, thanks.

This should take care of it, there are also some other plugin fixes on the previous pages...

https://vborg.vbsupport.ru/showpost....&postcount=164

metalguy639 11-20-2009 05:46 PM

Quote:

Originally Posted by Cloudrunner (Post 1889708)
Fix for the DB error after email click for activation:

Find in the plugin "Welcome thread upon registration -> register_activate_start"
Code:

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

Replace with
Code:

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

No more database errors.

Thanks

metalguy639 11-20-2009 05:47 PM

Quote:

Originally Posted by gbechtel (Post 1917498)
This should take care of it, there are also some other plugin fixes on the previous pages...

https://vborg.vbsupport.ru/showpost....&postcount=164

Thanks :D

metalguy639 11-23-2009 09:45 PM

Quote:

Originally Posted by abdulbasitsaeed (Post 1901073)
OK. Just to add a few more things.

When no post icon ID is given, it uses the paper icon as has been mentioned before.

I'm using the "make thread after email verification" option, and it seems to create multiple threads with some new registrations. And of these multiple threads, only one will have the username given. The rest simply say..."Welcome ," instead of "Welcome user,"

Any idea what's going wrong here? Is it not compatible with 3.8.4?

same issue here also running the latest 3.8.4 P1.

abdulbasitsaeed 11-23-2009 11:34 PM

Quote:

Originally Posted by metalguy639 (Post 1919788)
same issue here also running the latest 3.8.4 P1.

I think I found out when that happens, though haven't found a way around it.

The plugin creates a thread without the username of the newly registered account when the user clicks on the "Activation link" sent to them, and for some reason (slow dialup connection etc.), the Activation page does not load. Every time the user clicks the link (to load the activation page), a nameless thread is created. Only when the page fully loads does the thread created contain a name, e.g. Welcome XYX!

"powerful_rogue", any idea whether you would be updating this plugin for version 4 or not?

voglermc 11-30-2009 07:43 PM

It's just not working for me!

powerful_rogue 12-02-2009 08:24 PM

Hi,

I no longer use vbulletin as I have moved over to IPB, so there wont be any updates.

Anyone that feels they wish to carry this mod on, please do so.

voglermc 12-02-2009 10:25 PM

My recomendation is to delete this and the user altogether

powerful_rogue 12-03-2009 12:27 PM

Quote:

Originally Posted by voglermc (Post 1924364)
My recomendation is to delete this and the user altogether

:rolleyes:

Looks like a village is missing its idiot

BBR-APBT 12-03-2009 03:18 PM

Quote:

Originally Posted by powerful_rogue (Post 1924291)
Hi,

I no longer user vbulletin as I have moved over to IPB, so there wont be any updates.

Anyone that feels they wish to carry this mod on, please do so.

I have started to port this over to vb4.0

After seeing the bugs posted here it will take me some time to port it over and work out all the bugs and include the ideas posted here.

I imagine with in the next day or two I will have a working beta version posted.

Veer 12-03-2009 03:48 PM

Quote:

Originally Posted by BBR-APBT (Post 1924777)
I have started to port this over to vb4.0

After seeing the bugs posted here it will take me some time to port it over and work out all the bugs and include the ideas posted here.

I imagine with in the next day or two I will have a working beta version posted.

That's really great, BBR-APBT :)

Good luck.

abdulbasitsaeed 12-03-2009 04:10 PM

Thank you, BBR-APBT.

That's really great news. :)

BBR-APBT 12-03-2009 11:26 PM

I have it almost done all but one error I do believe.

Here is the error I can't figure out is any one cares to take a peek.
https://vborg.vbsupport.ru/showthread.php?t=229458

As soon as I fix that error I am releasing the beta release. I do believe I fixed all the errors in this thread.

BBR-APBT 12-04-2009 01:35 AM

Beta Version for vb 4.0 - https://vborg.vbsupport.ru/showthread.php?t=229473

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 02:53 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.02001 seconds
  • Memory Usage 1,856KB
  • 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
  • (13)bbcode_code_printable
  • (3)bbcode_php_printable
  • (14)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (3)pagenav_pagelink
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (40)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