Veri tabanından veri çekerek sitemap hazırlama

$isimx=mysql_query("SELECT * FROM rehbersi_data WHERE onay='e' ORDER BY haber_id DESC");;

Aşağıdaki ile değiştir.

$isimx=mysql_query("SELECT * FROM rehbersi_data WHERE onay='e' ORDER BY haber_id DESC");

Yukarıda verdiğin gibi değiştirdim..

Şu hatayı aldım..
Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/rehbersi/public_html/_sitemap.php on line 6

<?
include "yol.php";
                                       
$xml_ciktisi="<?xml version=\"1.0\" encoding=\"windows-1254\"?><urlset xmlns=\"http://www.google.com/schemas/sitemap/0.84\" xmlns:xsi=\"http://www.w3.org/2001/XMLSchema-instance\" xsi:schemaLocation=\"http://www.google.com/schemas/sitemap/0.84 http://www.google.com/schemas/sitemap/0.84/sitemap.xsd\">\n";
$isimx=mysql_query("SELECT * FROM rehbersi_data WHERE onay='e' ORDER BY haber_id DESC");
while($link = mysql_fetch_array($isimx))
{
$haber_id = $veri["haber_id"];
  $date = date("F d, 20y");
$xml_ciktisi .= "<url>
                          <loc>http://www.rehbersite.net/index.php?mode=haberdetay&haber_id</loc>
						       //index.php?mode=index   // veya link boyle olucak...
                          <lastmod>$date</lastmod>
                              <changefreq>daily</changefreq>
                              <priority>0.5</priority>
                              </url>\n";
};
$xml_ciktisi .= "</urlset>\n";
echo $xml_ciktisi;
?>

Kotalı Adsl Kullananlar Dikkat Etsin Kotayı Doldurabilir

Phpbb3 için yapabilen oldumu?

elinize sağlık....

Bu yöntem phpbb3 de çalışıyor mu? Yapabilen var mı?

yalnız bu yöntemle sitemap oluşturduğumuz zaman linklerimiz html olsa bile seosuz yani .php gibi linklerden oluşan bir sitemap elde ediyoruz değilmi ?

iki kere sordum kimse yazmadı ben buldum bari ekleyeyim.

<?php
/** 
*
* @author Tobi Schäfer Allgemein Informationen :: SEO phpBB
*
* @package phpBB3
* @version $Id: google-sitemap.php V0.1.1 2007-08-30 23:54:18 tas2580 $
* @copyright (c) 2005 phpBB Group; 2006 phpBB.de
* @license Open Source Initiative OSI - The GPL:Licensing | Open Source Initiative GNU Public License
*
*/
/**
* @ignore
*/
$domain_root = 'http://localhost/phpbb3/'; // Edit here
 
define('IN_PHPBB', true);
$phpbb_root_path = './';
$phpEx = substr(strrchr(__FILE__, '.'), 1);
include($phpbb_root_path . 'common.'.$phpEx);
$user->session_begin();
$auth->acl($user->data);
if (is_numeric($_GET['fid'])) {
   $fid = $_GET['fid'];
}
echo header('Content-Type: text/xml; charset=utf-8');

if (isset($fid)) {
   echo '<?xml version="1.0" encoding="UTF-8"?>'."\n";
   echo '<urlset xmlns="http://www.google.com/schemas/sitemap/0.84">'."\n";
  $sql = 'SELECT  forum_topics, forum_id, forum_name FROM ' . FORUMS_TABLE . ' WHERE forum_id = "'. (int) $fid.'"';
  $result = $db->sql_query($sql);
  $forum_data = $db->sql_fetchrow($result);
 
  // Forums
  echo '<url>'. "\n";
  echo '   <loc>' . $domain_root .  'viewforum.' . $phpEx . '?f=' . $forum_data['forum_id'] . '</loc>'. "\n";
  echo '   <changefreq>hourly</changefreq>'. "\n";
  echo '</url>'. "\n";
   
   // Forums with more that 1 Page
   if ( $forum_data['forum_topics'] > $config['topics_per_page'] )
   {
      $pages = $forum_data['forum_topics'] / $config['topics_per_page'];
      for ($i = 1; $i < $pages; $i++)
      {
         $s = $s + $config['topics_per_page'];
        echo '<url>'. "\n";
        echo '   <loc>' . $domain_root .  'viewforum.' . $phpEx . '?f=' . $forum_data['forum_id'] . '&amp;start=' . $s . '</loc>'. "\n";
        echo '   <changefreq>hourly</changefreq>'. "\n";
        echo '</url>'. "\n";
      }
   }
  if ($forum_data['forum_id'] == $fid) {
   $sql = 'SELECT t.topic_title, t.topic_replies, t.topic_last_post_id, t.forum_id, t.topic_type, t.topic_id, p.post_time, p.post_id
   FROM ' . TOPICS_TABLE . ' t, ' . POSTS_TABLE . ' p
   WHERE t.forum_id = '.$fid.'
   AND p.post_id = t.topic_last_post_id
   ORDER BY t.topic_type DESC, t.topic_last_post_id DESC';
   $result = $db->sql_query($sql);
    while ($data = $db->sql_fetchrow($result))
    {
       // Topics
      echo '<url>'. "\n";
      echo '   <loc>'. $domain_root . $forum_url . 'viewtopic.' . $phpEx . '?f=' . $forum_data['forum_id'] . '&amp;t=' . $data['topic_id'] . '</loc>'. "\n";
      echo '   <lastmod>'.date('Y-m-d', $data['post_time']),'</lastmod>'. "\n";
       echo '</url>'. "\n";
         // Topics with more that 1 Page
        if ( $data['topic_replies'] > $config['posts_per_page'] )
         {
            $s = 0;
            $pages = $data['topic_replies'] / $config['posts_per_page'];
            for ($i = 1; $i < $pages; $i++)
            {
               $s = $s + $config['posts_per_page'];
              echo '<url>'. "\n";
              echo '   <loc>'. $domain_root . $forum_url . 'viewtopic.' . $phpEx . '?f=' . $forum_data['forum_id'] . '&amp;t=' . $data['topic_id'] . '&amp;start=' . $s . '</loc>'. "\n";
              echo '   <lastmod>'.date('Y-m-d', $data['post_time']),'</lastmod>'. "\n";
              echo '</url>'. "\n";
            }
         }
    }
  }
  echo '</urlset>';
}
else
{
  echo '<?xml version="1.0" encoding="UTF-8"?>'."\n";
  echo '  <sitemapindex xmlns="http://www.google.com/schemas/sitemap/0.84">'."\n";
   $sql = 'SELECT forum_id FROM ' . FORUMS_TABLE;
  $result = $db->sql_query($sql);
  while($data = $db->sql_fetchrow($result))
  {
     if ($auth->acl_get('f_list', $data['forum_id']))
      {
        echo '    <sitemap>' . "\n";
      echo '       <loc>'. $domain_root .'google-sitemap.php?fid='.$data['forum_id'].'</loc>'. "\n";
      echo '       <changefreq>daily</changefreq>'. "\n";
         echo '    </sitemap>'. "\n";
    }
  }
  echo "\n".'  </sitemapindex>';
}
?>

peki baska bir siteden gün gün veri ceken bir sayfanın her gun belli bir ssatteki durumunu sayfa sayfa nasıl kaydeder veya sitempa olustururuz? mesela gün gün maç sonucları gosteren bir sayfam var desek?