'.generate_key(50).''; if (isset($_GET['feed']) and preg_match('/^[A-Za-z0-9]{50}$/', $_GET['feed'])) { $query = ' SELECT uf.user_id AS id, ui.status, uf.last_check, u.'.$conf['user_fields']['username'].' AS username FROM '.USER_FEED_TABLE.' AS uf INNER JOIN '.USER_INFOS_TABLE.' AS ui ON ui.user_id = uf.user_id INNER JOIN '.USERS_TABLE.' AS u ON u.'.$conf['user_fields']['id'].' = uf.user_id WHERE uf.id = \''.$_GET['feed'].'\' ;'; $user = mysql_fetch_array(pwg_query($query)); } else { echo l10n('Unknown feed identifier'); exit(); } $user['forbidden_categories'] = calculate_permissions($user['id'], $user['status']); if ('' == $user['forbidden_categories']) { $user['forbidden_categories'] = '0'; } list($dbnow) = mysql_fetch_row(pwg_query('SELECT NOW();')); include_once(PHPWG_ROOT_PATH.'include/feedcreator.class.php'); $rss = new UniversalFeedCreator(); $rss->title = $conf['gallery_title'].', notifications'; $rss->title.= ' (as '.$user['username'].')'; $rss->link = $conf['gallery_url']; // +-----------------------------------------------------------------------+ // | Feed creation | // +-----------------------------------------------------------------------+ $news = news($user['last_check'], $dbnow); if (count($news) > 0) { $item = new FeedItem(); $item->title = sprintf(l10n('New on %s'), $dbnow); $item->link = $conf['gallery_url']; // content creation $item->description = '

'; foreach ($news as $line) { $item->description.= '
• '.$line.'
'; } $item->description.= '

'; $item->descriptionHtmlSyndicated = true; $item->date = ts_to_iso8601(mysqldt_to_ts($dbnow)); $item->author = 'PhpWebGallery notifier'; $rss->addItem($item); } $query = ' UPDATE '.USER_FEED_TABLE.' SET last_check = \''.$dbnow.'\' WHERE id = \''.$_GET['feed'].'\' ;'; pwg_query($query); // send XML feed echo $rss->saveFeed('RSS2.0', '', true); ?>