//Articles Hack

$row_max = 20; /* Number of rows to display */

$rows = dbcount("(article_id)", "articles", "article_subject='".$data['user_id']."'");

if (!isset($rowstart) || !isNum($rowstart)) $rowstart = 0;



opensidex("Articles Submitted by: ".$data['user_name'],"off");



echo "<table align='center' cellpadding='0' cellspacing='1' width='70%' class='tbl-border'>

<tr>

<td class='tbl1'>";



$userarticle = dbquery("SELECT * FROM ".$db_prefix."articles WHERE article_name='".$data['user_id']."' ORDER BY article_datestamp DESC LIMIT $rowstart,$row_max");



//tablebreak();

$articlesd = "";

while ($articles=dbarray($userarticle)) {

if ($articlesd != "") $articlesd .= "<br>";

$articlesd .= "<img src='".THEME."images/bullet.gif'> <a href='".BASEDIR."readarticle.php?article_id=".$articles['article_id']."'>".$articles['article_subject']."</a>";

}

if ($data['user_id'] != $userdata['user_id']) { $whatuser = "This user has"; } else { $whatuser = "You have"; }

if ($articlesd != "") { echo $articlesd; } else { echo "<center>".$whatuser." not posted any articles.</center>"; }

echo "</td></tr></table>";

if ($rows > $row_max) echo "<div align='center' style='margin-top:5px;'>\n".makePageNav($rowstart,$row_max,$rows,3,FUSION_SELF."?lookup=".$data['user_id']."&")."\n</div>\n";

closeside();