\n\n";
echo "| ".$locale['global_048']."
| \n";
echo "".$locale['global_044']."
| \n";
echo "".$locale['global_049']."
| \n";
echo "
\n";
while ($data = dbarray($result)) {
if ($i % 2 == 0) { $row_color = "tbl1"; } else { $row_color = "tbl2"; }
echo "\n";
echo "| ".trimlink($data['forum_name'], 30)."
| \n";
echo "".trimlink($data['thread_subject'], 40)."
| \n";
echo "".showdate("forumdate", $data['post_datestamp'])." | \n";
echo "
\n";
$i++;
}
echo "
\n";
closetable();
if ($rows > 20) { echo "
\n".makePageNav($rowstart,20,$rows,3,"?lookup=$lookup&")."
\n
\n";
} else {
opentable($locale['global_042']);
echo "
\n".$locale['global_054']."
\n
\n";
closetable();
}
} else {
$result = dbquery(
"
SELECT tp.*, tf.* FROM ".$db_prefix."posts tp
INNER JOIN ".$db_prefix."forums tf USING(forum_id)
WHERE ".groupaccess('forum_access')." AND post_author='".$userdata['user_id']."' LIMIT 100
"
);
$rows = dbrows($result);
if ($rows != 0) {
if (!isset($rowstart) || !isNum($rowstart)) $rowstart = 0;
$result = dbquery(
"
SELECT tp.*, tf.* FROM ".$db_prefix."posts tp
INNER JOIN ".$db_prefix."forums tf USING(forum_id)
WHERE ".groupaccess('forum_access')." AND post_author='".$userdata['user_id']."'
ORDER BY post_datestamp DESC LIMIT $rowstart,20
"
);
$i=0;
opentable($locale['global_042']);
echo "
\n\n";
echo "
| ".$locale['030']." |
".$locale['035']." |
".$locale['036']." |
\n";
while ($data = dbarray($result)) {
if ($i % 2 == 0) { $row_color = "
tbl1"; } else { $row_color = "
tbl2"; }
echo "
| ".trimlink($data['forum_name'], 30)." |
".trimlink($data['post_subject'], 40)." |
".showdate("forumdate", $data['post_datestamp'])." |
\n";
$i++;
}
echo "
\n";
closetable();
if ($rows > 20) echo "
\n".makePageNav($rowstart,20,$rows,3)."
\n
\n";
} else {
opentable($locale['global_042']);
echo "
\n".$locale['global_054']."
\n\n";
closetable();
}
}
require_once THEMES."
templates/footer.php";
?>