WCDDL Live Total Downloads Stats (v2)

gtaclub · **WCDDL Live Total Downloads Stats (v2) -** 03-08-2011, 07:43 PM

Create a new php file named wcddl_stats.php in /modules/

Paste this following code in it and then save it.

PHP Code:


			
<?php

if(!defined("WCDDL_GUTS"))

   exit;

$statshtml .= '<li><a href="index.php">Home</a></li>';

$statshtml .= '<li><strong><a href="submit.php">Submit</a></strong></li>'; 

foreach($core->allowed_types as $ty) {

$county = mysql_query("SELECT COUNT(id) as countid from wcddl_downloads WHERE type = '".$ty."'");

while($row = mysql_fetch_assoc($county)) { $total += $row['countid'];

$statshtml .= '<li><a href="/index.php?type='.$ty.'">'.ucfirst($ty).'</a>: '.$row['countid'].'</li>';

}

}

$contqueue = mysql_query("SELECT COUNT(id)from wcddl_queue");

$cqueue = mysql_result($contqueue, 0);

$statshtml .= '<hr><strong>Total:</strong> '.$total.'';

$statshtml .= '<br /><strong>Queue:</strong> '.$cqueue.'';

$core->setTemplateVar("stats",$statshtml);

?>

Replace you navigation code to:

PHP Code:


			
<?=$core->templateVar("stats")?>

For each new type downloads you add on wcfg.php and it will be automatically added on the list.

Note: If you have any question about this mod, please send a P.M to me.

jomasaco · 03-09-2011, 02:26 AM

This is one of heavy mods, very nice and usefull, but execute that query's for each page turns the site an little slow.

you can add there some output to an file and read from file untill X time like an cache.

if(fileatime($file) >= ($time() - 3600))
{
EXECUTE THE CODE
OUTPUT TO AN FILE
OUTPUT TO BROWSER
EXIT
}
else
{
readfile($file)
}

something near this

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode