Website Membership: auto-subscribe original posts

Hi Deborah, 

That's really great.  Ok, so obviously it's a lot of custom code and outside of what we typically support, but let's see if we can find something that will work for you.  

If you look in websiteComments.php there's a few functions that apply to subscriptions:

• wsc_thread_isSubscribed($tableOrTag, $recordNum); // check if current user is subscribed to this thread
• wsc_thread_subscribe();

wsc_thread_subscribe() is what we want, but it redirects and does some other things, but I can see that it calls _wsc_thread_subscribe() which looks like this:

// subscribe current user to current comment thread
function _wsc_thread_subscribe($tableOrTag, $recordNum) {
  global $CURRENT_USER;

  // subscribe user (if not already subscribed)
  $isSubscribed = wsc_thread_isSubscribed($tableOrTag, $recordNum);
  if (!$isSubscribed) {
    mysql_insert('_wsc_subscribers', array(
      'createdDate=' => 'NOW()',
      'userNum'      => $CURRENT_USER['num'],
      'tableOrTag'   => $tableOrTag,
      'recordNum'    => $recordNum,
    ));
  }
}

Now, we use a leading _ in function names to indicate it's a "private" function not intended to be called externally.  But you can call it, we just can't guarantee it won't change in future (but it probably won't).

But basically, if you can get these values:

• tableOrTag - usually a form value in $_REQUEST['_wsc_tableOrTag']
• recordNum - usually a form value in $_REQUEST['_wsc_recordNum']

Then you could just call the function after getting the new thread record num.

So adding that to you code might look like this (untested):

// add record
if (!@$errorsAndAlerts) {
mysql_query("INSERT INTO `{$TABLE_PREFIX}topics` SET
title            = '".mysql_real_escape_string( $_REQUEST['title'] )."',
content          = '".mysql_real_escape_string( $_REQUEST['content'] )."',
fullname         = '".mysql_real_escape_string( $_REQUEST['fullname'] )."',
usernum          = '".mysql_real_escape_string( $_REQUEST['usernum'] )."',
createdDate      = NOW(),
updatedDate      = NOW(),
createdByUserNum = '0',
updatedByUserNum = '0'")
    or die("MySQL Error Creating Record:<br>\n". htmlspecialchars(mysql_error()) . "\n");
    $recordNum = mysql_insert_id();

 // subscribe user to thread they just created
  $tableOrTag = "determine what this should be?"; 
 _wsc_thread_subscribe($tableOrTag, $recordNum);


 // display thanks msg, clear form
    $errorsAndAlerts = "Thanks, we've added that topic!";
    $_REQUEST = array();
  }
}

But you've got another table 'topics' in your setup, so you may need to create a new comment on the topic first.  Have a look at the code in wsc_comments_addRecord() for how to go about that.

Hope that helps!  Let me know any questions and if any of that information can get you any further.