db = new database($set['db_host'], $set['db_user'], $set['db_pass'], $set['db_name'], $set['db_port'], $set['db_socket']); @$connect = mysql_Connect($set['db_host'], $set['db_user'], $set['db_pass']); MySQL_Select_DB($set['db_name']); $today = date('Y-m-d'); echo " $domain $today hourly 1.0 "; //Get the Catagorys $query = MySQL_Query("SELECT forum_name,forum_id,forum_lastpost FROM mb_forums WHERE forum_parent =0 "); $count = mysql_Num_Rows($query); for ($i=0; $i<$count; $i++){ $unixdate = mysql_result($query, $i, "forum_lastpost"); $date =date("Y-m-d" ,"$unixdate"); $urlname= urlencode(mysql_result($query, $i, 'forum_name')); echo " ".$domain."c".mysql_result($query, $i, 'forum_id')."-".$urlname.".html $date daily 0.9 "; } //Get the Forums $query = MySQL_Query("SELECT forum_name,forum_id,forum_lastpost FROM mb_forums WHERE forum_parent != 0 "); $count = mysql_Num_Rows($query); for ($i=0; $i<$count; $i++){ $post = mysql_result($query, $i,'forum_lastpost'); $querytime = MySQL_Query("SELECT post_time FROM mb_posts WHERE post_id = $post ORDER BY post_time DESC LIMIT 1 "); $counttime = mysql_Num_Rows($querytime); if ($counttime){ $unixdate = mysql_result($querytime, 0,'post_time'); } $date =date("Y-m-d" ,"$unixdate"); $urlname= urlencode(mysql_result($query, $i, 'forum_name')); echo " ".$domain."index.php?a=forum&f=".mysql_result($query, $i, 'forum_id')." $date daily 0.8 "; } //Get the Topics $query = MySQL_Query("SELECT topic_title,topic_id FROM mb_topics "); $count = mysql_Num_Rows($query); for ($i=0; $i<$count; $i++){ $topic =mysql_result($query, $i, 'topic_id'); $querytime = MySQL_Query("SELECT post_time FROM mb_posts WHERE post_topic = $topic ORDER BY post_time DESC LIMIT 1 "); $counttime = mysql_Num_Rows($querytime); if ($counttime){ $unixdate = mysql_result($querytime, 0,'post_time'); } $date =date("Y-m-d" ,"$unixdate"); $urlname= urlencode(mysql_result($query, $i, 'topic_title')); echo " ".$domain."index.php?a=forum&f=".mysql_result($query, $i, 'forum_id')." $date daily 0.7 "; } echo ""; ?>