attention moderators ......problem with new forum topics in fifa2002.com site

[rahulmvora]

i wanted to bring it to notice to the moderators that when i open the site fifa 2002 , fo past few days the new forum topics coloumn is not changing at all . the 5 topics namely :- would u make a ronald face , tell me, danny murphy neogf , world cup simulation , and ..how wolud u convert faces fromfifa wc 2002 to fifa 2002.

these topics are not changed in the new forum topics coloumn . soccergaming site is working perfectly . those who have have this same kind of problem, post in this thread . i would be pleased if this is rectified . thank u very much.

rahul.

 

[Lior]

fixed

 

[Gareth]

Originally posted by Lior
fixed

Hey lior I am using vBulletin for my Xbox website and want to display the latest topicson the main page like Soccergaming. How do you do it?

 

[Lior]

<?

require("config.php");
// number of active topics to show
$num_active = 5;
// number of pagetext characters to show
$num_chars = 70;

$db=mysql_connect($servername,$dbusername,$dbpassword);
mysql_select_db($dbname);

// Remove the forums you don't want listed

$querylatest="select * from thread where forumid='58' order by lastpost desc limit $num_active";

$resultlatest = mysql_query($querylatest,$db);

print("<p align=\"right\"><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);


// split the date up a bit
$datestr1 = substr($latest_array["dateline"],0,10);
$datetime = substr($latest_array["dateline"],11,8);
printf("<tr><td align=\"right\"><b><font color=\"#FFFFCC\" size=\"1\" face=\"Arial\"><a href=\"http://www.soccergaming.tv/showthread.php?threadid=%s\" class=\"c\" target=\"_blank\">%s</a></font></b></td></tr>",$latest_array["threadid"],$latest_array["title"]);

$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 align=\"right\" width=\"100%%\"><font color=\"#FFCC66\" face=\"Verdana, Arial, Helvetica, sans-serif\" size=\"1\"><img src=\"http://www.soccergaming.tv/images/icons/icon%s.gif\"> Started By: %s <br>Last Post By: %s<hr color=\"#FEF8EB\" align=\"center\"></a></td></tr>",$result_thread_array["iconid"],$latest_array["postusername"],$latest_array["lastposter"]);
printf ("<tr><td width=\"100%%\"> </td></tr>");
}

printf ("</table>");
?>

include that with your config.php file
and include this file into your page where u want it displayed via a php include tag

make sure to edit the number of topics and the forum id within what i pasted
save it as whatever.php

 

[rahulmvora]

thx lior !!

 

[Gareth]

$querylatest="select * from thread where forumid='58' order by lastpost desc limit $num_active";

Lior, that string there, how do I get it to show ALL forums? Like at SoccerGaming.com ?

Thanks in advance.

 

[Lior]

$querylatest="select * from thread order by lastpost desc limit $num_active";

 

[Gareth]

Thankyou!