<?php // $Id: backend.php 2672 2009-01-11 07:49:15Z phppp $ // ------------------------------------------------------------------------ // // XOOPS - PHP Content Management System // // Copyright (c) 2000 XOOPS.org // // <https://xoops.org/> // // ------------------------------------------------------------------------ // // This program is free software; you can redistribute it and/or modify // // it under the terms of the GNU General Public License as published by // // the Free Software Foundation; either version 2 of the License, or // // (at your option) any later version. // // // // You may not change or alter any portion of this comment or credits // // of supporting developers from this source code or any supporting // // source code which is considered copyrighted (c) material of the // // original comment or credit authors. // // // // This program is distributed in the hope that it will be useful, // // but WITHOUT ANY WARRANTY; without even the implied warranty of // // MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the // // GNU General Public License for more details. // // // // You should have received a copy of the GNU General Public License // // along with this program; if not, write to the Free Software // // Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA 02111-1307 USA // // ------------------------------------------------------------------------ // include 'mainfile.php'; global $xoopsDB; $priority[0]['max'] = 9; $priority[0]['min'] = 7; $priority[1]['max'] = 9; $priority[1]['min'] = 6; $priority[2]['max'] = 9; $priority[2]['min'] = 4; $priority[3]['max'] = 9; $priority[3]['min'] = 1; $priority[4]['max'] = 9; $priority[4]['min'] = 4; $priority[5]['max'] = 9; $priority[5]['min'] = 3; $priority[6]['max'] = 8; $priority[6]['min'] = 4; $priority[7]['max'] = 9; $priority[7]['min'] = 9; function priority($priority, $num, $of) { $range = $priority['max'] - $priority['min']; return '0.'.($priority['max']-floor($range * ($num/$of))); } $query[0] = "SELECT a.id,a.filename from ".$xoopsDB->prefix('bin')." a WHERE `resource` = 'download' ORDER BY a.hits DESC"; $query[1] = "SELECT a.categoryid,a.itemid,a.title,a.datesub,b.name from ".$xoopsDB->prefix('smartsection_items')." a inner join ".$xoopsDB->prefix('smartsection_categories')." b on a.categoryid = b.categoryid ORDER BY a.`weight`, a.`datesub` DESC"; $query[2] = "SELECT a.lid,a.cid,a.title,a.date,b.title from ".$xoopsDB->prefix('wflinks_links')." a inner join ".$xoopsDB->prefix('wflinks_cat')." b on a.cid = b.cid"; $query[3] = "SELECT a.storyid,a.topicid,a.title,a.published,b.topic_title from ".$xoopsDB->prefix('nw_stories')." a inner join ".$xoopsDB->prefix('nw_topics')." b on a.topicid = b.topic_id ORDER BY a.created DESC"; $baseurl[0] = 'binaries'; $baseurl[1] = 'articles'; $baseurl[2] = 'weblinks'; $baseurl[3] = 'news'; $endurl[0] = '.html'; $endurl[1] = ',-1.html'; $endurl[2] = ''; $endurl[3] = '.html'; error_reporting(E_ALL); header('Content-type: text/xml'); ?> <?php echo "<?xml version="1.0" encoding="UTF-8"?>n"; ?> <urlset xmlns="http://www.google.com/schemas/sitemap/0.84"> <url> <loc><?php echo XOOPS_URL; ?>/</loc> <lastmod><?php echo date('Y-m-d',time()); ?></lastmod> <changefreq>daily</changefreq> <priority>1</priority> </url> <?php foreach($query as $id => $sql) if (!empty($sql)) { switch($id) { case "0": $rsCover = $xoopsDB->query($sql); $totalRows[$id] = mysql_num_rows($rsCover); while (list($lid, $filename) = mysql_fetch_row($rsCover)){ ?>  <url> <loc><?php echo XOOPS_URL; ?>/<?php echo $baseurl[$id]; ?>/<?php echo urlencode(str_replace(' ', '-',$filename)); ?>,<?php echo $lid.$endurl[$id]; ?></loc> <lastmod><?php echo date('Y-m-d',time());?></lastmod> <changefreq>monthly</changefreq> <priority><?php $num[$id]++; echo priority($priority[$id], $num[$id], $totalRows[$id]); ?></priority> </url> <?php } break; default: $rsCover = $xoopsDB->query($sql); $totalRows[$id] = mysql_num_rows($rsCover); while (list($lid, $cid, $ititle, $idate, $ctitle) = mysql_fetch_row($rsCover)){ ?>  <url> <loc><?php echo XOOPS_URL; ?>/<?php echo $baseurl[$id]; ?>/<?php echo urlencode(str_replace(' ', '-',$ctitle)); ?>/<?php echo urlencode(str_replace(' ', '-',$ititle)); ?>/<?php echo $lid.','.$cid . $endurl[$id]; ?></loc> <lastmod><?php echo date('Y-m-d',$idate);?></lastmod> <changefreq>monthly</changefreq> <priority><?php $num[$id]++; echo priority($priority[$id], $num[$id], $totalRows[$id]); ?></priority> </url> <?php } break; } } ?> </urlset>