Forum Subscription (Page 1 of 2)

<!--SUBSCRIBE FORUM MOD-->
<?php

if (!$cookie['is_guest'] && $pun_config['o_subscriptions'] == '1')
{
    if ($is_subscribed)
        // I apologize for the variable naming here. It's a mix of subscription and action I guess :-)
        $subscraction = $lang_forum['Is subscribed'].' - <a href="misc.php?unsubscribe_forum='.$id.'">'.$lang_forum['Unsubscribe'].'</a>';
    else
        $subscraction = '<a href="misc.php?subscribe_forum='.$id.'">'.$lang_forum['Subscribe'].'</a>';
}
else
    $subscraction = ' ';


?>
<!-- END SUBSCRIBE FORUM MOD-->

<table class="punspacer" cellspacing="1" cellpadding="4">
    <tr>
        <td style="width: 46%"><?php echo $lang_common['Pages'].': '.paginate($num_pages, $p, 'viewforum.php?id='.$id) ?></td>
<!--SUBSCRIBE FORUM MOD-->
        <td class="punright" style="width: 35%"><?php echo $subscraction ?></td>
<!--END SUBSCRIBE FORUM MOD-->
        <td class="punright" style="width: 19%"><b><?php echo $post_link ?></b></td>
    </tr>
</table>

// SUBSCRIBE FORUM MOD

else if (isset($_GET['subscribe_forum']))
{
    $forum_id = intval($_GET['subscribe_forum']);
    if (empty($forum_id))
        message($lang_common['Bad request']);

    if ($cookie['is_guest'])
        message($lang_common['No permission']);

    $result = $db->query('SELECT 1 FROM '.$db->prefix.'subscriptions_forums WHERE user_id='.$cur_user['id'].' AND forum_id='.$forum_id) or error('Unable to fetch subscription info', __FILE__, __LINE__, $db->error());
    if ($db->num_rows($result))
        message($lang_misc['Already subscribed_f']);
    
    $db->query('INSERT INTO '.$db->prefix.'subscriptions_forums (user_id, forum_id) VALUES('.$cur_user['id'].' ,'.$forum_id.')') or error('Unable to add subscription', __FILE__, __LINE__, $db->error());

    redirect('viewforum.php?id='.$forum_id, $lang_misc['Subscribe redirect']);
}


else if (isset($_GET['unsubscribe_forum']))
{
    $forum_id = intval($_GET['unsubscribe_forum']);
    if (empty($forum_id))
        message($lang_common['Bad request']);

    if ($cookie['is_guest'])
        message($lang_common['No permission']);

    $result = $db->query('SELECT 1 FROM '.$db->prefix.'subscriptions_forums WHERE user_id='.$cur_user['id'].' AND forum_id='.$forum_id) or error('Unable to fetch subscription info', __FILE__, __LINE__, $db->error());
    if (!$db->num_rows($result))
        message($lang_misc['Not subscribed_f']);

    $db->query('DELETE FROM '.$db->prefix.'subscriptions_forums WHERE user_id='.$cur_user['id'].' AND forum_id='.$forum_id) or error('Unable to remove subscription', __FILE__, __LINE__, $db->error());

    redirect('viewforum.php?id='.$forum_id, $lang_misc['Unsubscribe redirect']);
}

// end SUBSCRIBE FORUM MOD

$result = $db->query('SELECT u.id, u.email, u.notify_with_post FROM '.$db->prefix.'users AS u INNER JOIN '.$db->prefix.'subscriptions AS s ON u.id=s.user_id LEFT JOIN '.$db->prefix.'bans AS b ON u.username=b.username WHERE b.username IS NULL AND s.forum_id='.$fid.' AND u.last_action>'.$previous_post_time.' AND u.id!='.intval($cur_user['id'])) or error('Unable to fetch subscription info', __FILE__, __LINE__, $db->error());

$result = $db->query('SELECT u.id, u.email, u.notify_with_post FROM '.$db->prefix.'users AS u INNER JOIN '.$db->prefix.'subscriptions_forums AS s ON u.id=s.user_id LEFT JOIN '.$db->prefix.'bans AS b ON u.username=b.username WHERE b.username IS NULL AND s.topic_id='.$tid.' AND u.last_action>'.$previous_post_time.' AND u.id!='.intval($cur_user['id'])) or error('Unable to fetch subscription info', __FILE__, __LINE__, $db->error());

$result = $db->query('SELECT u.id, u.email, u.notify_with_post FROM '.$db->prefix.'users AS u INNER JOIN '.$db->prefix.'subscriptions_forums AS s ON u.id=s.user_id LEFT JOIN '.$db->prefix.'bans AS b ON u.username=b.username WHERE b.username IS NULL AND s.forum_id='.$fid.' AND u.id!='.intval($cur_user['id'])) or error('Unable to fetch subscription info', __FILE__, __LINE__, $db->error());

Subject: New topic: <topic_subject> in a subscribed forum.

<replier> has created a topic <topic_subject> in a forum to which you are subscribed.

The post is located at <post_url>

You can unsubscribe by going to <unsubscribe_url>

-- 
<board_mailer>
(Do not reply to this message)