$query="SELECT topic_id,topic_title FROM phpbbatl_topics ORDER BY topic_time DESC LIMIT 0,10";
$connection = mysql_connect($db_address, $db_user, $db_pass) or die("Unable to connect!$db_host");
mysql_select_db($db_name);
$result = mysql_query($query, $connection) or die ("Error in query: $query. " . mysql_error());
while($info = mysql_fetch_array($result)){
echo "- ".urldecode(stripslashes($info["topic_title"]))."
\n";
}
mysql_close($connection);
?>
$query="SELECT entry_title,entry_created_on,entry_basename FROM mt_entry WHERE entry_status=2 AND entry_blog_id=2 ORDER BY emailed DESC LIMIT 0,10";
$connection = mysql_connect($db_address, $db_user, $db_pass) or die("Unable to connect!$db_host");
mysql_select_db($db_name);
$result = mysql_query($query, $connection) or die ("Error in query: $query. " . mysql_error());
while($info = mysql_fetch_array($result)){
$year=substr($info["entry_created_on"],0,4);
$month=substr($info["entry_created_on"],5,2);
echo "- ".urldecode(stripslashes($info["entry_title"]))."
\n";
}
mysql_close($connection);
?>
include($_SERVER['DOCUMENT_ROOT']."/config.php"); ?>
$query="SELECT db_page.page_title,db_searchindex.si_text FROM db_searchindex,db_page WHERE db_page.page_id = db_searchindex.si_page ORDER BY RAND() LIMIT 1,1";
$connection = mysql_connect($db_address, $db_user, $db_pass) or die("Unable to connect!$db_host");
mysql_select_db("wikidb");
$result = mysql_query($query, $connection) or die ("Error in query: $query. " . mysql_error());
while($info = mysql_fetch_array($result)){
$wiki_title = ucfirst($info["page_title"]);
//$link = str_replace(" ","_", $wiki_title);
$words = explode(" ",$info["si_text"]);
for($i=0;$i<50;$i++){
$thetext .= $words[$i]." ";
}
if(count($words)>100){ $thetext .="..."; }
}
mysql_close($connection); ?>