phpBB.de

Code: Alles auswählen

Warning: mysql_query(): Access denied for user: '******@localhost' (Using password: NO) in /var/www/html/phpBB2/sitemap.php on line 51

Warning: mysql_query(): A link to the server could not be established in /var/www/html/phpBB2/sitemap.php on line 51

Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /var/www/html/phpBB2/sitemap.php on line 52

Code: Alles auswählen

<?php 
/*************************************************************************** 
* Save this file as:   sitemap.php  
* Version:      beta, still in development 
* Email:      webmaster@retriever-hilfe.de 
* Purpose of hack:   Basically generates a list of topics and 
*      displays them with link to the topic. 
* 
* Tested on:   phpBB 2.0.8 
* 
***************************************************************************/ 

/*************************************************************************** 
* 
* 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. 
* 
***************************************************************************/ 

define('IN_PHPBB', true); 
$phpbb_root_path = './'; 
include($phpbb_root_path . 'extension.inc'); 
include($phpbb_root_path . 'common.'.$phpEx); 

// 
// Start session management 
// 
$userdata = session_pagestart($user_ip, PAGE_INDEX); 
init_userprefs($userdata); 
// 
// End session management 
// 

$t=$HTTP_GET_VARS['t']; 
$f=$HTTP_GET_VARS['f']; 

// 
// Start output of page 
// 
define('SHOW_ONLINE', true); 
$page_title = 'Sitemap'; 
include($phpbb_root_path . 'includes/page_header.'.$phpEx); 


echo "<h2>Sitemap</h2>"; 

echo "<center><a href='" . $PHP_SELF . "' class='nav'>Alles einklappen</a>&nbsp;&nbsp;<a href='" . $PHP_SELF . "?f=all&t=all' class='nav'>Alles ausklappen</a></center>"; 

$resultc = mysql_query("SELECT * FROM " . CATEGORIES_TABLE . " ORDER BY cat_title"); 
while($rowc=  mysql_fetch_assoc($resultc)) 
{ 
   $actionc = (($f == $rowc["cat_id"]) || ($f == 'all')) ? "<a href='" . $PHP_SELF . "' class='nav'>&nbsp;-</a>" : "<a href='" . $PHP_SELF . "?f=" . $rowc["cat_id"] . "' class='nav'>+</a>"; 

    echo $actionc . "&nbsp;<a href='index.php?c=" . $rowc["cat_id"] . "' class='nav'>" . $rowc["cat_title"] . "</a><br>"; 

   if ( ($f == 'all') || ($f == $rowc["cat_id"]) ) 
   {    
      $resultf = mysql_query("SELECT * FROM " . FORUMS_TABLE . " WHERE cat_id =" . $rowc["cat_id"] . " ORDER BY forum_name"); 
      while($rowf=  mysql_fetch_assoc($resultf)) 
      { 

         $is_auth_ary = array(); 
         $is_auth_ary = auth(AUTH_ALL, AUTH_LIST_ALL, $userdata, $rowf[]); 
         if ((!$is_auth_ary[$rowf['forum_id']]['auth_read']) or (!$is_auth_ary[$rowf['forum_id']]['auth_view'])) 
         { 
            // nothing to do 
         } 
         else 
         { 
            $actionf = (($t == $rowf["forum_id"]) || ($t == 'all')) ? "<a href='" . $PHP_SELF . "?f=" .$rowc["cat_id"] . "' class='nav'>&nbsp;-</a>" : "<a href='" . $PHP_SELF . "?f=" . $rowc["cat_id"] . "&t=" . $rowf["forum_id"] . "' class='nav'>+</a>"; 

                echo "&nbsp;&nbsp;&nbsp;" . $actionf . "&nbsp;<a href='viewforum.php?f=" . $rowf["forum_id"] . "' class='nav'>" . $rowf["forum_name"] . "</a><span class='gensmall'>" . " - " . $rowf["forum_desc"] . "</span><br>"; 

            if ( ($t == 'all') || ($t == $rowf["forum_id"]) ) 
            { 
               $resultt = mysql_query("SELECT * FROM " . TOPICS_TABLE . " WHERE forum_id=" . $rowf["forum_id"] . " ORDER BY topic_title"); 
               while($rowt=  mysql_fetch_assoc($resultt)) 
               { 
                     echo "&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<a href='viewtopic.php?t=" . $rowt["topic_id"] . "' class='nav'>" . $rowt["topic_title"] . "</a><br>"; 
               } 
            }    
         }          
      } 
   }    
} 

include($phpbb_root_path . 'includes/page_tail.'.$phpEx); 

?>