assign('STC_MODE', $_POST['stc_mode']);
$template->assign('STC_MAIL', @$_POST['stc_mail']);
}
}
}
/**
* send notifications on comment validation
* @param: array|int comment_id
* @param: string type (image|category)
*/
function stc_comment_validation($comm_ids, $type='image')
{
if (!is_array($comm_ids)) $comm_ids = array($comm_ids);
if ($type == 'image')
{
$query = '
SELECT
id,
image_id,
author,
content
FROM '.COMMENTS_TABLE.'
WHERE id IN('.implode(',', $comm_ids).')
;';
}
else if ($type == 'category')
{
$query = '
SELECT
id,
category_id,
author,
content
FROM '.COA_TABLE.'
WHERE id IN('.implode(',', $comm_ids).')
;';
}
$comms = hash_from_query($query, 'id');
foreach ($comms as $comm)
{
send_comment_to_subscribers($comm);
}
}
/**
* add field and link on picture page
*/
function stc_on_picture()
{
global $template, $picture, $page, $user, $conf;
// standalone subscription
if (isset($_POST['stc_submit']))
{
switch ($_POST['stc_mode'])
{
case 'all-images':
subscribe_to_comments(@$_POST['stc_mail'], 'all-images');
break;
case 'album-images':
if (empty($page['category']['id'])) break;
subscribe_to_comments(@$_POST['stc_mail'], 'album-images', $page['category']['id']);
break;
case 'image':
subscribe_to_comments(@$_POST['stc_mail'], 'image', $picture['current']['id']);
break;
}
}
else if (isset($_GET['stc_unsubscribe']))
{
if (un_subscribe_to_comments(null, $_GET['stc_unsubscribe']))
{
array_push($page['infos'], l10n('Successfully unsubscribed your email address from receiving notifications.'));
}
}
// if registered user with mail we check if already subscribed
if ( !is_a_guest() and !empty($user['email']) )
{
$subscribed = false;
// registered to all pictures
if (!$subscribed)
{
$query = '
SELECT id
FROM '.SUBSCRIBE_TO_TABLE.'
WHERE
email = "'.$user['email'].'"
AND type = "all-images"
AND validated = "true"
;';
$result = pwg_query($query);
if (pwg_db_num_rows($result))
{
$template->assign(array(
'SUBSCRIBED_ALL_IMAGES' => true,
'MANAGE_LINK' => make_stc_url('manage', $user['email']),
));
$subscribed = true;
}
}
// registered to pictures in this album
if ( !$subscribed and !empty($page['category']['id']) )
{
$query = '
SELECT id
FROM '.SUBSCRIBE_TO_TABLE.'
WHERE
email = "'.$user['email'].'"
AND element_id = '.$page['category']['id'].'
AND type = "album-images"
AND validated = "true"
;';
$result = pwg_query($query);
if (pwg_db_num_rows($result))
{
list($stc_id) = pwg_db_fetch_row($result);
$template->assign(array(
'SUBSCRIBED_ALBUM_IMAGES' => true,
'UNSUB_LINK' => add_url_params($picture['current']['url'], array('stc_unsubscribe'=>$stc_id)),
));
$subscribed = true;
}
}
// registered to this picture
if (!$subscribed)
{
$query = '
SELECT id
FROM '.SUBSCRIBE_TO_TABLE.'
WHERE
email = "'.$user['email'].'"
AND element_id = '.$picture['current']['id'].'
AND type = "image"
AND validated = "true"
;';
$result = pwg_query($query);
if (pwg_db_num_rows($result))
{
list($stc_id) = pwg_db_fetch_row($result);
$template->assign(array(
'SUBSCRIBED_IMAGE' => true,
'UNSUB_LINK' => add_url_params($picture['current']['url'], array('stc_unsubscribe'=>$stc_id)),
));
$subscribed = true;
}
}
}
else
{
$template->assign('STC_ASK_MAIL', true);
}
$template->assign('STC_ON_PICTURE', true);
if ( !empty($page['category']['id']) ) $template->assign('STC_ALLOW_ALBUM_IMAGES', true);
if ( $conf['Subscribe_to_Comments']['allow_global_subscriptions'] or is_admin() ) $template->assign('STC_ALLOW_GLOBAL', true);
$template->set_prefilter('picture', 'stc_main_prefilter');
}
/**
* add field and link on album page
*/
function stc_on_album()
{
global $page, $template, $pwg_loaded_plugins, $user, $conf;
if (
script_basename() != 'index' or !isset($page['section']) or
!isset($pwg_loaded_plugins['Comments_on_Albums']) or
$page['section'] != 'categories' or !isset($page['category'])
)
{
return;
}
if (isset($_POST['stc_submit']))
{
switch ($_POST['stc_mode'])
{
case 'all-albums':
subscribe_to_comments(@$_POST['stc_mail'], 'all-albums');
break;
case 'album':
subscribe_to_comments(@$_POST['stc_mail'], 'album', $page['category']['id']);
break;
}
}
else if (isset($_GET['stc_unsubscribe']))
{
if (un_subscribe_to_comments(null, $_GET['stc_unsubscribe']))
{
array_push($page['infos'], l10n('Successfully unsubscribed your email address from receiving notifications.'));
}
}
// if registered user we check if already subscribed
if ( !is_a_guest() and !empty($user['email']) )
{
$subscribed = false;
// registered to all albums
if (!$subscribed)
{
$query = '
SELECT id
FROM '.SUBSCRIBE_TO_TABLE.'
WHERE
email = "'.$user['email'].'"
AND type = "all-albums"
AND validated = "true"
;';
$result = pwg_query($query);
if (pwg_db_num_rows($result))
{
$template->assign(array(
'SUBSCRIBED_ALL_ALBUMS' => true,
'MANAGE_LINK' => make_stc_url('manage', $user['email']),
));
$subscribed = true;
}
}
// registered to this album
if (!$subscribed)
{
$query = '
SELECT id
FROM '.SUBSCRIBE_TO_TABLE.'
WHERE
email = "'.$user['email'].'"
AND element_id = '.$page['category']['id'].'
AND type = "album"
AND validated = "true"
;';
$result = pwg_query($query);
if (pwg_db_num_rows($result))
{
list($stc_id) = pwg_db_fetch_row($result);
$element_url = make_index_url(array(
'section' => 'categories',
'category' => $page['category'],
));
$template->assign(array(
'SUBSCRIBED_ALBUM' => true,
'UNSUB_LINK' => add_url_params($element_url, array('stc_unsubscribe'=>$stc_id)),
));
$subscribed = true;
}
}
}
else
{
$template->assign('STC_ASK_MAIL', true);
}
$template->assign('STC_ON_ALBUM', true);
if ( $conf['Subscribe_to_Comments']['allow_global_subscriptions'] or is_admin() ) $template->assign('STC_ALLOW_GLOBAL', true);
$template->set_prefilter('comments_on_albums', 'stc_main_prefilter');
}
/**
* main prefilter
*/
function stc_main_prefilter($content, &$smarty)
{
## subscribe at any moment ##
$search = '{if isset($comments)}';
$replace = file_get_contents(SUBSCRIBE_TO_PATH.'template/form_standalone.tpl');
$content = str_replace($search, $replace.$search, $content);
## subscribe while add a comment ##
$search = '{$comment_add.CONTENT}';
$replace = file_get_contents(SUBSCRIBE_TO_PATH.'template/form_comment.tpl');
$content = str_replace($search, $search.$replace, $content);
return $content;
}
/**
* delete subscriptions to deleted images or categories
*/
function stc_delete_elements($ids)
{
$query = '
DELETE FROM '.SUBSCRIBE_TO_TABLE.'
WHERE
element_id IN ('.implode(',', $ids).')
AND type = "image"
';
pwg_query($query);
}
function stc_delete_categories($ids)
{
$query = '
DELETE FROM '.SUBSCRIBE_TO_TABLE.'
WHERE
element_id IN ('.implode(',', $ids).')
AND (type = "album" OR type = "album-images")
';
pwg_query($query);
}
/**
* add link to management page for registered users
*/
function stc_profile_link()
{
global $template, $user;
if (!empty($user['email']))
{
$template->assign('MANAGE_LINK', make_stc_url('manage', $user['email']) );
$template->set_prefilter('profile_content', 'stc_profile_link_prefilter');
}
}
function stc_profile_link_prefilter($content, &$smarty)
{
$search = '';
$replace = '
{\'Manage my subscriptions\'|@translate}
';
return str_replace($search, $replace.$search, $content);
}
?>