function simplenews_user_is_subscribed in Simplenews 6.2

Same name and namespace in other branches

1. 5 simplenews.module \simplenews_user_is_subscribed()
2. 6 simplenews.module \simplenews_user_is_subscribed()
3. 7.2 simplenews.module \simplenews_user_is_subscribed()
4. 7 simplenews.module \simplenews_user_is_subscribed()

3 calls to simplenews_user_is_subscribed()

simplenews_block_form in includes/simplenews.subscription.inc

FAPI BLOCK subscription form.

simplenews_mail in ./simplenews.module

Implementation of hook_mail().

template_preprocess_simplenews_block in ./simplenews.module

Process variables to format the simplenews block.

File

./simplenews.module, line 1577

Simplenews node handling, sent email, newsletter block and general hooks

Code

function simplenews_user_is_subscribed($mail, $tid, $reset = FALSE) {
  static $subscribed = array();
  if ($reset) {
    $subscribed = array();
  }
  if (!isset($subscribed[$mail][$tid])) {
    $subscribed[$mail][$tid] = db_result(db_query("\n      SELECT COUNT(*)\n      FROM {simplenews_subscriptions} s\n      INNER JOIN {simplenews_snid_tid} t\n        ON s.snid = t.snid\n      WHERE s.mail = '%s'\n        AND t.tid = %d\n        AND t.status = %d", $mail, $tid, SIMPLENEWS_SUBSCRIPTION_STATUS_SUBSCRIBED)) ? TRUE : FALSE;
  }
  return $subscribed[$mail][$tid];
}