How can I use this on another server without using an iframe?
Here's the code for the script:
Code:
<?
require("/export/home/wsb/www/admin/config.php");
$num_active = 10;
$num_chars = 95;
$db=mysql_connect($servername,$dbusername,$dbpassword);
mysql_select_db($dbname);
$querylatest="select * from thread where forumid='29' or forumid='32' or forumid='35' or forumid='36' or forumid='37' or forumid='38' or forumid='39' or forumid='40' or forumid='41' order by lastpost desc limit $num_active";
$resultlatest = mysql_query($querylatest,$db);
print("<center><table width=\"100%%\" cellspacing=\"0\" cellpadding=\"2\">");
while ($latest_array = mysql_fetch_array($resultlatest)) {
// Get Forum Infomation
$query_forum = "select * from forum where forumid='$latest_array[forumid]'";
$result_forum = mysql_query($query_forum,$db);
$forum_info_array = mysql_fetch_array($result_forum);
printf("<font size=\"1\" face=\"verdana, arial, helvetica, san-serif\">[<font size=\"1\" face=\"verdana, arial, helvetica, san-serif\" color=\"#009900\"><b>%s</b></font>] <a href=\"http://www.worldsoccerboard.com/showthread.php?threadid=%s\" target=\"_blank\"><font size=\"1\" face=\"verdana, arial, helvetica, san-serif\" color=\"#000000\">%s</font></a> by %s<br>",$forum_info_array["title"],$latest_array["threadid"],$latest_array["title"],$latest_array["lastposter"]);
// split the date up a bit
$datestr1 = substr($latest_array["dateline"],0,10);
$datetime = substr($latest_array["dateline"],11,8);
$querythread="select * from post where threadid='$latest_array[threadid]' order by dateline asc limit 1";
$result_thread_text= mysql_query($querythread,$db);
$result_thread_array = mysql_fetch_array($result_thread_text);
// printf ("<td width=\"85%%\" bgcolor=\"#cccccc\"><font face=\"Verdana, Arial, Helvetica, sans-serif\" size=\"1\"><img src=\"/forums/images/icons/icon%s.gif\"> Last Post By: %s<hr>%s...<br><a href=\"/forums/showthread.php?threadid=%s\">Click here for more</font><a href=\"/member.php?$newsposterid\">test</a></td></tr>",$result_thread_array["iconid"],$latest_array["lastposter"],substr(strip_tags($result_thread_array["pagetext"]),0,$num_chars),$latest_array["threadid"]);
// printf ("<tr><td colspan=\"2\" width=\"100%%\"> </td></tr>");
}
printf ("</table></center>");
?>
Thanks in advance
Show Your Support
This modification may not be copied, reproduced or published elsewhere without author's permission.