<?php
// The number of posts you want to see
$count = 5;

// url to the forum
$forum_url = 'http://forum.arabbuilder.com/';

// The dbase information
$dbserver = 'localhost'; // The server name ( hostname )
$dbuser = 'username';    // The username
$dbpass = 'password';    // The password
$dbname = 'dbname';  // The database name

$db_conn = mysql_connect( $dbserver, $dbuser, $dbpass );

$result = mysql_db_query($dbname, "SELECT thread.threadid AS id,thread.title AS title,thread.replycount AS replycount,thread.forumid AS forumid,forum.title AS forumtitle FROM thread,forum WHERE forum.forumid = thread.forumid ORDER BY thread.lastpost DESC LIMIT $count" , $db_conn);

while ($thread = mysql_fetch_array( $result )) {
    if ($thread[replycount] > 0) {
        $reply = "رد على موضوع : ";
    } else {
        $reply = "";
    }
    echo "<a href='{$forum_url}showthread.php?threadid={$thread[id]}'>{$reply}{$thread[title]}</a> [<a href='{$forum_url}forumdisplay.php?forumid={$thread[forumid]}'>{$thread[forumtitle]}</a>]<br>\n";
}

mysql_close( $db_conn );

?>

<?

	$num_active = 5;
	$num_chars  = 75;

	require("admin/config.php3");
	$db=mysql_connect($servername,$dbusername,$dbpassword);
	mysql_select_db($dbname);

	$querylatest="select * from thread where forumid='1' or forumid='2' or forumid='3' or forumid='4' or forumid='5' or forumid='6' or forumid='7' or forumid='8' or forumid='10' or forumid='11' or forumid='12' or forumid='13' or forumid='14' or forumid='15' or forumid='16' or forumid='17' or forumid='18' or forumid='19' or forumid='20' or forumid='22' or forumid='23' or forumid='25' or forumid='26' or forumid='27' or forumid='28' or forumid='32' or forumid='34' or forumid='35' or forumid='36' or forumid='37' or forumid='38' or forumid='44' or forumid='45' or forumid='46' 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("<tr><td colspan=\"2\" bgcolor=\"#000000\"><b><font color=\"#FFE116\" size=\"1\" face=\"Verdana, ArialHelveticasans-serif\">%s: %s</font></b></td></tr>",$forum_info_array["title"],$latest_array["title"]);

	// split the date up a bit 
	$datestr1 = substr($latest_array["dateline"],0,10);
	$datetime = substr($latest_array["dateline"],11,8);	
	printf ("<tr valign=\"top\"><td width=\"15%%\" bgcolor=\"#F7F7F7\"><font face=\"Verdana, ArialHelveticasans-serif\" size=\"1\"><b>%s</b><br>تحديث: %s<br>الردود: %s</font></td>", $latest_array["postusername"], $datetime, $latest_array["replycount"]);

	$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=\"#DEDFDF\"><font face=\"Verdana, ArialHelveticasans-serif\" size=\"1\"><img src=\"/vb/images/icons/icon%s.gif\">آخر رد بواسطة: %s<hr>%s...<br></font><a href=\"/vb/showthread.php3?threadid=%s\"><font face=\"Verdana, ArialHelveticasans-serif\" size=\"1\">مزيد من التفصيل</font></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>");
?>

<?php
// Set this to the max number top posters to display
$num = 20;

require("admin/config.php3");
$db=mysql_connect($servername,$dbusername,$dbpassword);
mysql_select_db($dbname);
$query = "SELECT * FROM user ORDER BY  posts DESC LIMIT $num";
$resultlatest = mysql_query($query,$db);
while ($latest_array = mysql_fetch_array($resultlatest)) {
echo "<FONT SIZE=\"1\" FACE=\"Verdana, Arial, Helvetica, sans-serif\"> °
<A HREF=\"http://www.itihadclub.com/vb/member.php3?action=getinfo&userid=$latest_array[userid]\">$latest_array[username]</A></FONT><BR>";
}
 
?>

<html>
<head>
<title>ملخص</title>
<meta http-equiv="Content-Type" content="text/html; charset=windows-1256">
<style type="text/css">
<!--
a:hover {  color: #FF0000; text-decoration: underline overline}
-->
</style>
</head>

<body bgcolor="#FFE116" link="#000000" vlink="#000000" alink="#000000" leftMargin=0 topMargin=0 marginwidth="0" marginheight="0" text="#000000">
 <div dir=RTL>
  <table width="99%" border="0" cellspacing="1" cellpadding="4" bgcolor="#000000">
    <tr bgcolor="#000000"> 
      <td width="25%" valign="top"> 
        <table border=0 cellpadding=1 cellspacing=0 width="100%">
          <tbody> 
          <tr> 
            <td bgcolor=#000000> 
                <p align="center"><font color="#FFE116">افضل عشرة
                كتاب</font>
            </td>
          </tr>
          <tr> 
            <td bgcolor=#FFE116> 
                <?php include("http://www.itihadclub.com/vb/top.php3");?>
            </td>
          </tr>
          </tbody> 
        </table>
      </td>
      <td width="49%" valign="top" bgcolor="#000000"> 
        <center>
          <table border=0 cellpadding=1 cellspacing=0 width="100%">
            <tbody> 
            <tr bgcolor="#B9B9B9"> 
              <td bgcolor="#000000"> 
                <p align="center"><font color="#FFE116">آخر خمسة
                مواضيع نشطة</font>
       </td>
            </tr>
            <tr bgcolor="#B9B9B9"> 
              <td bgcolor="#FFE116"> 
                <?php include("http://www.itihadclub.com/vb/test2.php3");?>
       </td>
            </tr>
            </tbody> 
          </table>
        </center>
      </td>
      <td width="25%" valign="top" bgcolor="#000000"> 
        <table border=0 cellpadding=1 cellspacing=0 width="100%">
          <tbody> 
          <tr> 
            <td bgcolor=#000000> 
              <table bgcolor=#ffffff border=0 cellpadding=4 cellspacing=0 
            width="100%">
                <tbody> 
                <tr> 
                  <td colspan=2 bgcolor="#000000"> 
                      <div align="center"><b><font face="Arial, Helvetica, sans-serif" size="2" color="#FFE116">خدمات</font></b></div>
                    </td>
                  </form>
                </tr>
                <tr bgcolor="#000000"> 
                  
         <td valign=top width="100%" colspan="2" bgcolor="#FFE116"> 
          <p>
           <font face="Verdana, Arial, Helvetica, sans-serif" size="1"><a href="http://ittihadmail.mail.everyone.net" target="_top">بريد الاتحاديين</a></font> <br>
           <font face="Verdana, Arial, Helvetica, sans-serif" size="1"><a href="http://www.itihadclub.com/vb" target="_top">Post 
           Cards</a></font> <a href="http://www.itihadclub.com/vb" target="_top"> <br>
          </a> 
          </p>
                    </td>
                </tr>
                </tbody> 
              </table>
            </td>
          </tr>
          </tbody> 
        </table>
        <br>
        
   </td>
    </tr>
  </table>
</div>
</body>
</html>