Das ist mein Code aus der portal.php :
Code: Alles auswählen
//
// BEGIN Locura's QuickStats MOD
//
include ("config.php");
@ $link = mysql_connect( $dbhost, $dbuser, $dbpasswd );
if ( ! $link )
die( "Couldn't connect to MySQL" );
mysql_select_db( $dbname, $link )
or die ( "Couldn't open $db: ".mysql_error() );
$query = "SELECT * FROM phpbb_quickstats";
$datenow=date("jS F Y");
$result=mysql_query( $query, $link );
$query = "SELECT * FROM phpbb_quickstats ORDER BY quickID desc";
$result=mysql_query( $query, $link );
while ($row = @ mysql_fetch_array ($result))
{
break;
}
if ($row[quickDATE]==$datenow)
{
$count=$row[quickCOUNT];
$count++;
$query = "UPDATE phpbb_quickstats SET quickCOUNT='$count' WHERE quickID=$row[quickID]";
$result=mysql_query( $query, $link );
}
else
{
$query = "INSERT INTO phpbb_quickstats (quickDATE, quickCOUNT )
values('$datenow','1')";
mysql_query( $query, $link );
}
$round=0;
$query = "SELECT * FROM phpbb_quickstats ORDER BY quickID desc";
$result=mysql_query( $query, $link );
while ($row = $db->sql_fetchrow($result))
{
if ($round==7) break;
else $round++;
$quickstatsdate[]=$row[quickDATE];
$quickstatscount[]=$row[quickCOUNT];
if (!isset($bignum)) $bignum=$row[quickCOUNT];
else if ($row[quickCOUNT]>$bignum) $bignum=$row[quickCOUNT];
}
$quickstatsday[4][6];
for ($i=7;$i>=0;$i--)
{
$quickstatsgraph[$i]=(INT)(($quickstatscount[$i]*150)/$bignum);
if ($quickstatsgraph[$i]<1 && $quickstatsgraph[$i]>0) $quickstatsgraph[$i]=1;
$quickstatsday[$i]=substr($quickstatsdate[$i],0,4);
$template->assign_block_vars('quickstsscow', array(
'QUICKSTATS' => $quickstatsgraph[$i],
)
);
}
//
// END Locura's QuickStats MOD
//