MyBB Community Forums

This code can not connect to mysql and I don't know why

<?php

define("IN_MYBB", 1);
require_once "./global.php";

add_breadcrumb("Sitemap", "sitemap.php");




$query = "SELECT * FROM `mybb_threads`";
$result = mysql_query ($query);

while ($row = mysql_fetch_array ($result)) {
    $tid = $row['tid'];
    $name = $row['subject'];
  $x = $x+1;
    $url = "{page}";
}
$perpage = 50; // Will make 5 pages
$pages = $x / $perpage;
$pages = ceil($pages);
$page = intval($mybb->input['page']);

// Check limits
if($page > $pages || $page <= 0)
{
    $page = 1;
}
if($page)
{
    $start = ($page-1) * $perpage;
}
else
{
    $start = 0;
    $page = 1;
}

$pagi = multipage($x, $perpage, $page, $url);
	

  $query = "SELECT * FROM `mybb_threads` LIMIT $start, $perpage";
$result = mysql_query ($query);

while ($row = mysql_fetch_array ($result)) {
    $tid = $row['tid'];
    $name = $row['subject'];
  $x = $x+1;
$post = get_thread_link($tid, $page=0, $action='');
 $data = ('<a href="http://www.weblasters.com/'.$post.'">'.$name.'</a>');
$end = ('<table width="50%" border="1"><tr><td><center>'.$data.'</center></td></tr></table>');
   $sitemap = $sitemap.$end;

}
$sitemap = $sitemap.$pagi;
eval("\$sitemap= \"".$templates->get("sitemap")."\";");
output_page($sitemap);
?>

look here for debug

http://prntscr.com/24j7fg

it is something like mybb HTML sitemap

see this guidance --> http://docs.mybb.com/Database_Methods.html

Can anyone tell me what should I edit in code above? Code is correct and working good at this site

http://www.maturskiradovi.net/forum/sitemap/1

ok found it - this is correct code

<?php

define("IN_MYBB", 1);
define("KILL_GLOBALS", 1);
require_once "./global.php";

add_breadcrumb("Sitemap", "sitemap.php");




$query=$db->query("SELECT * FROM `mybb_threads`");

while ($row = $db->fetch_array($query)) {
    $tid = $row['tid'];
    $name = $row['subject'];
  $x = $x+1;
    $url = "{page}";
}
$perpage = 50; // Will make 5 pages
$pages = $x / $perpage;
$pages = ceil($pages);
$page = intval($mybb->input['page']);

// Check limits
if($page > $pages || $page <= 0)
{
    $page = 1;
}
if($page)
{
    $start = ($page-1) * $perpage;
}
else
{
    $start = 0;
    $page = 1;
}

$pagi = multipage($x, $perpage, $page, $url);
	

$query=$db->query("SELECT * FROM `mybb_threads` LIMIT $start, $perpage");

while ($row = $db->fetch_array($query)) {
    $tid = $row['tid'];
    $name = $row['subject'];
  $x = $x+1;
$post = get_thread_link($tid, $page=0, $action='');

 $data = ('<a href="http://www.weblasters.com/'.$post.'">'.$name.'</A>');
$end = ('<table width="50%" border="1"><tr><td class="trow2"><center>'.$data.'</center></td></tr></table>');
   $sitemap = $sitemap.$end;

}
$sitemap = $sitemap.$pagi;
eval("\$sitemap= \"".$templates->get("sitemap")."\";");
output_page($sitemap);
?>

I just want to know how to query backwards... I want new topics to be showed first

$query=$db->query("SELECT * FROM `mybb_threads` LIMIT $start, $perpage");

this should be changed

$query=$db->query("SELECT * FROM `mybb_threads`  ORDER BY `tid` DESC LIMIT $start, $perpage");

thank you guys