rss.php

<?php
/*
* This file is part of PEM package
*
* Copyright(c) Nicolas Roudaire  https://www.nikrou.net/
* Licensed under the GPL version 2.0 license.
*
* For the full copyright and license information, please view the LICENSE
* file that was distributed with this source code.
*/

define('INTERNAL', true);
$root_path = './';
require_once($root_path.'include/common.inc.php');

$tpl->set_filename('rss', 'rss.tpl');

// $conf['page_title']
$tpl->assign(
  array(
    'xml_header' => '<?xml version="1.0" encoding="utf-8"?>',
    'title' => $conf['page_title'],
    'website_url' => $conf['website_url'],
    'description' => $conf['website_description'],
    'language' => $conf['website_language'],
    'webmaster_email' => $conf['webmaster_email'],
    )
  );

// Gets the latest X (defined in constants.inc.php) mods information
$query = '
SELECT
    version,
    description,
    id_revision,
    idx_extension
  FROM '.REV_TABLE.'
  ORDER BY id_revision DESC
  LIMIT 0, '.$conf['rss_nb_items'].'
;';
$req = $db->query($query);

$revisions = array();
$extension_ids = array();
$user_ids = array();

while ($data = $db->fetch_assoc($req))
{
  array_push($revisions, $data);
  array_push($extension_ids, $data['idx_extension']);
}

$extension_infos_of = get_extension_infos_of($extension_ids);

foreach ($extension_ids as $extension_id)
{
  array_push($user_ids, $extension_infos_of[$extension_id]['idx_user']);
}
$author_infos_of = get_user_basic_infos_of($user_ids);

$tpl_revisions = array();
foreach ($revisions as $revision)
{
  $extension = $extension_infos_of[ $revision['idx_extension'] ];
  $author = $author_infos_of[ $extension['idx_user'] ];

  array_push(
    $tpl_revisions,
    array(
      'ext_name' => $extension['name'],
      'name' => $revision['version'],
      'url' => sprintf(
        '%s/extension_view.php?eid=%u&amp;rid=%u#rev%u',
        $conf['website_url'],
        $revision['idx_extension'],
        $revision['id_revision'],
        $revision['id_revision']
        ),
      'ext_author' => $author['username'],
      'ext_description' => $extension['description'],
      'description' => $revision['description'],
      )
    );
}
$tpl->assign('revisions', $tpl_revisions);

// echo '<pre>'; print_r($tpl_revisions); echo '</pre>';

// +-----------------------------------------------------------------------+
// |                           html code display                           |
// +-----------------------------------------------------------------------+

$tpl->pparse('rss');