Total Game Plays

[am-fs]

Got a mod for total game plays instead of page hits?

I know it should be something like

Code: [Select]

$totalplays = $db->num_rows($db->query(sprintf('SELECT sum(views) AS totalpays FROM dd_games WHERE active="1"')));
Display

Code: [Select]

Total Games Played: <? echo $totalplays; ?>
But No Luck

[Adam LaCombe]

You got a typo..
SELECT sum(views) AS totalpays

maybe that will fix it?

[am-fs]

still incorrect number and it dont count

[Adam LaCombe]

hmmm...

Code: [Select]

<?php
$query = "SELECT sum(views) FROM dd_games WHERE active='1'"; 
$result = mysql_query($query) or die(mysql_error());
$row = mysql_fetch_array($result);
echo $row['SUM(views)'];
?>


[am-fs]

Still Nothing, ill keep digging 

[Adam LaCombe]

okay lol sorry I would try to debug it but I don't have a working FAS site on my server yet. Had to wipe the server clean and start over again.. just haven't had lots of time to put FAS back up.

check out http://www.tizag.com/mysqlTutorial/mysqlsum.php
and the people over at PHPFreaks are wonderful at helping. http://phpfreaks.com/

[Frank]

Try this.

Code: [Select]

<?php
// Total Games Played

$query = "SELECT views, SUM(views) FROM dd_games WHERE active=1"; 
$result = mysql_query($query) or die(mysql_error());

// Get result
while($row = mysql_fetch_array($result)){$row['SUM(views)'];
$totalgameplays = $row["SUM(views)"];
}
?>


// Print it out

HTML:
<?php echo $totalgameplays; ?>

PHP:
'.$totalgameplays.'

Put the script in php, Use the anchor as appropriate and decorate them with some mark-up.

[am-fs]

Right On .............. mort 

Thanks

[Adam LaCombe]

That works, but you really don't wanna do that..
That will make your server work over time. If you really wanna do it that way then I would recommend caching the results for a one day time period.
but even if you do caching results...
If you have thousands of games just imagine how long it will take to run through that while. It could even take so long that it won't display. Default slow queries stop at 30 seconds, after 30 seconds it stops loading the data and displays a error message.

[Frank]

If it ever gets to be a problem with the charge on the Db, one could possibly do a Cron Job on it once a week.

Because if one has so many games that have been played - Then hourly or daily updates would be insignificant.

As for "time-out" One could expect that from places like GoDaddy and a few others - And sometimes that's most of the problem.

[Adam LaCombe]

I suppose.. still would try to think of a better way of doing it.

No, everyone that runs a mysql database will get those errors. Unless you higher the limit from 30 seconds to something like 2 mins.. but I highly do not recommend doing so.
That limit is there to make sure you don't kill your server lol

I myself am struggling with slow queries. I got 16+ million rows of data that needs to be searched through to find results and it takes about 18 seconds for a query to execute. Wayyyy too long.
I'm trying to build a flat file database system to fix that slowness.

But.. I think doing something like a mix of caching the total game plays and a counting plays execution file would work.
soo basically create a php file and loop through 100 games at a time then have the script wait about 25-30 seconds and loop through another 100 games starting from id 101 and so on.
Just put that into a for loop and stop the loop at the amount of active games.
then cache the results. You could run that every day if you wanted, but if you got thousands of games I would say every 2-5 days.
and yup I would say do a cron job on it, if you're lazy and forgetful like myself