Welcome Topic

[Hj Ahmad Rasyid Hj Ismail]

Can this mod be enhanced to welcome new members of a membergroup and welcome topic created for more than one board?

[JamesWC]

Is it possible to set it so that new members immediately go in to the newly created welcome posting.

I'd like either this or, alternatively, if the new member could be automatically subscribed to this topic, so that they'll know when other members have replied to welcome them. That might be easier to code?

[GravuTrad]

For 2.0 make sure you use [username] for personalization

Hi vb.

Why this?

Thanks.

[vbgamer45]

The other way doesn't work. 2.0 it changed.

[GravuTrad]

Ok no {username} so. Thanks vb.

[vbgamer45]

Correct and then it should work ok.

[puw]

Hi, just installed ok on 2.0.4 - thx.

Not a complaint but I thought there would be an auto feature when a new member first activated their acct, would insert the name and send based on the template - no?

Also, how will the new member know you created this post for them? Do they get a pm?

[vbgamer45]

It should create a topic when activated/member registers.

No pm is sent. It just creates a post.

[StarterX]

I use 2.0.4 It gives me a Error i tried Many Times i cant Find a Solution

Code Select Expand

SQL logic error or missing database
near "NOT": syntax error
File: /home/u700575668/public_html/Packages/temp/WelcomeTopicsql2.php
Line: 18

Here My Function

Code Select Expand

<?php
//SMFHacks.com
//Table SQL

if (file_exists(dirname(__FILE__) . '/SSI.php') && !defined('SMF'))
  require_once(dirname(__FILE__) . '/SSI.php');
// Hmm... no SSI.php and no SMF?
elseif (!defined('SMF'))
  die('<b>Error:</b> Cannot install - please verify you put this in the same place as SMF\'s index.php.');

global $smcFunc;

// Create the Welcome Topic Table
$smcFunc['db_query']('',"CREATE TABLE IF NOT EXISTS {db_prefix}welcome
(ID smallint(5) unsigned NOT NULL auto_increment,
welcomesubject tinytext,
welcomebody text,
PRIMARY KEY (ID))");


// Insert the settings
$smcFunc['db_query']('',"INSERT IGNORE INTO {db_prefix}settings VALUES ('welcome_boardid', '0')");
$smcFunc['db_query']('',"INSERT IGNORE INTO {db_prefix}settings VALUES ('welcome_memberid', '0')");
$smcFunc['db_query']('',"INSERT IGNORE INTO {db_prefix}settings VALUES ('welcome_membername', '')");


?>

[puw]

But upon each new member registering/activating, then I have to open this up, choose the welcome message template, choose the username to send to etc. The new topic or "post" isn't done automatically?

As I say, I'm not complaining, just want to know what I've got to manually do each time to make it happen

[vbgamer45]

But upon each new member registering/activating, then I have to open this up, choose the welcome message template, choose the username to send to etc. The new topic or "post" isn't done automatically?

It is done automatically when a member registers

[vbgamer45]

I use 2.0.4 It gives me a Error i tried Many Times i cant Find a Solution

Code Select Expand

SQL logic error or missing database
near "NOT": syntax error
File: /home/u700575668/public_html/Packages/temp/WelcomeTopicsql2.php
Line: 18

Here My Function

Code Select Expand

<?php
//SMFHacks.com
//Table SQL

if (file_exists(dirname(__FILE__) . '/SSI.php') && !defined('SMF'))
  require_once(dirname(__FILE__) . '/SSI.php');
// Hmm... no SSI.php and no SMF?
elseif (!defined('SMF'))
  die('<b>Error:</b> Cannot install - please verify you put this in the same place as SMF\'s index.php.');

global $smcFunc;

// Create the Welcome Topic Table
$smcFunc['db_query']('',"CREATE TABLE IF NOT EXISTS {db_prefix}welcome
(ID smallint(5) unsigned NOT NULL auto_increment,
welcomesubject tinytext,
welcomebody text,
PRIMARY KEY (ID))");


// Insert the settings
$smcFunc['db_query']('',"INSERT IGNORE INTO {db_prefix}settings VALUES ('welcome_boardid', '0')");
$smcFunc['db_query']('',"INSERT IGNORE INTO {db_prefix}settings VALUES ('welcome_memberid', '0')");
$smcFunc['db_query']('',"INSERT IGNORE INTO {db_prefix}settings VALUES ('welcome_membername', '')");


?>

Are you using MySQL? This mod only works with MySQL

[puw]

kk, will test it out then, thx

[StarterX]

I use 2.0.4 It gives me a Error i tried Many Times i cant Find a Solution

Code Select Expand

SQL logic error or missing database
near "NOT": syntax error
File: /home/u700575668/public_html/Packages/temp/WelcomeTopicsql2.php
Line: 18

Here My Function

Code Select Expand

<?php
//SMFHacks.com
//Table SQL

if (file_exists(dirname(__FILE__) . '/SSI.php') && !defined('SMF'))
  require_once(dirname(__FILE__) . '/SSI.php');
// Hmm... no SSI.php and no SMF?
elseif (!defined('SMF'))
  die('<b>Error:</b> Cannot install - please verify you put this in the same place as SMF\'s index.php.');

global $smcFunc;

// Create the Welcome Topic Table
$smcFunc['db_query']('',"CREATE TABLE IF NOT EXISTS {db_prefix}welcome
(ID smallint(5) unsigned NOT NULL auto_increment,
welcomesubject tinytext,
welcomebody text,
PRIMARY KEY (ID))");


// Insert the settings
$smcFunc['db_query']('',"INSERT IGNORE INTO {db_prefix}settings VALUES ('welcome_boardid', '0')");
$smcFunc['db_query']('',"INSERT IGNORE INTO {db_prefix}settings VALUES ('welcome_memberid', '0')");
$smcFunc['db_query']('',"INSERT IGNORE INTO {db_prefix}settings VALUES ('welcome_membername', '')");


?>

Are you using MySQL? This mod only works with MySQL

I am using MySQL

[vbgamer45]

Hmm not sure what version of mysql?
And you are using SMF 2.0.x right?

[Arantor]

Just think, if you used $smcFunc['db_create_table'] and $smcFunc['db_insert'], you would get cross-DB compatibility.

[StarterX]

I Am using The Version 2.0.4 For SMF 

[vbgamer45]

And what mysql version?
That code above should work for MySQL

[StarterX]

How to Check the Version of MySQL?

[puw]

in the left column of ur CPanel homepage