This is simply frustrating me now thank you to all that have helped
i can get the template to show now but no results from either forum ??
Any help or guidelines would be great thanks
PHP Code:
<?php
include("./global.php");
/////////////// CONFIG ///////////////
//
$maxposters = "10"; // change this to the number of posters you want to show.
$bc1 = "#777777"; // change to first alternating color.
$bc2 = "#555555"; // change to second alternating color.
///////////// END CONFIG /////////////
require("admin/config.php");
$db=mysql_connect($servername,$dbusername,$dbpassword) or die("Unable to connect to database");
mysql_select_db($dbname) or die("Unable to select database $dbname");
$postsresult = mysql_query("SELECT COUNT(*) AS count,postuserid,postusername FROM thread WHERE forumid IN (10,11) GROUP BY postuserid ORDER BY count DESC LIMIT $maxposters;") or die("Unable to complete query");
while ($topposters = mysql_fetch_array($postsresult))
{
if (($counter++ % 2) != 0)
{
$bc=$bc1;
}
else
{
$bc=$bc2;
}
}
eval("dooutput(\"".gettemplate("topp")."\");");
?>
Template Named: topp
PHP Code:
{htmldoctype}
<html>
<head>
<title>test</title>
$headinclude
</head>
<body>
$header
<table cellpadding="10" cellspacing="0" border="0" bgcolor="{pagebgcolor}" width="100%"><tr><td>
<table cellpadding="4" cellspacing="1" border="0" bgcolor="{tablebordercolor}" width="100%">
<tr>
<td colspan="2" bgcolor="{categorybackcolor}">
<p align="center"><normalfont color="{categoryfontcolor}"><b>Gambling
Addicts:</b></normalfont></td>
</tr>
<tr>
<td bgcolor="{tableheadbgcolor}" width="100%">
<p align="center"><smallfont color="{tableheadtextcolor}">User</smallfont></td>
<td bgcolor="{tableheadbgcolor}">
<p align="center"><smallfont color="{tableheadtextcolor}">Threads</smallfont></td>
</tr>
<tr>
<td bgcolor="{tableheadbgcolor}" width="100%"><center><a href="$bburl/xxx/xxx/member.php?&action=getinfo&userid=$topposters[postuserid]">
<smallfont>$topposters[postusername]</a></smallfont></td>
<td bgcolor="{tableheadbgcolor}"><center>$topposters[count]</td>
</tr>
</tr>
</table>
</td></tr></table>
</body>
</html>
09-18-2003, 06:43 PM
Hybrid Mode
