vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   ibProArcade Archive (https://vborg.vbsupport.ru/forumdisplay.php?f=174)
-   -   [Please participate] Most Played Games, cut off by time, for example last 30 days (https://vborg.vbsupport.ru/showthread.php?t=283871)

basketmen 06-03-2012 12:29 AM
[Please participate] Most Played Games, cut off by time, for example last 30 days
 
Hi guys, i think the current Most Played Games, is not good and very rarely updated by other games, almost static, its should be more dynamic

its should be cut off by time, for example make it Most Played Games in the last 30 days



in arcade.php i see this lines

PHP Code:
// Begin Most Popular Games
        $DB->query("SELECT g.gid, g.gtitle, g.gname, g.gcat, cat.password, g.gcount, cat.active FROM ibf_games_list AS g, ibf_games_cats AS cat WHERE g.active=1 AND cat.active=1 AND g.gcat=cat.c_id AND trim(password)='' ORDER BY g.gcount DESC LIMIT ".$this->arcade->settings['games_popular']);
                 $firstpop = true;
                 while($popgline = $DB->fetch_row()) {
                 if($firstpop) {
                    $firstpop = false;
                 } else {
                    $pop_games .= "<br />\n";
                 }
                    $pop_games .= " <a href='".$ibforums->base_url."act=Arcade&amp;do=play&amp;gameid={$popgline['gid']}'>{$popgline['gtitle']}</a> <a href='".$ibforums->base_url."act=Arcade&amp;do=play&amp;gameid={$popgline['gid']}'><img src='arcade/images/{$popgline[gname]}2.gif' border='0' alt='".$ibforums->lang[times_played].$popgline['gcount']."x' width='20' height='20' /></a>";
}
//Most End Popular Games 



the count database, currently is in games_list table >> field gcount
its stored total game played



please participate here to make it


All times are GMT. The time now is 01:04 AM.

Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.

X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.01547 seconds
  • Memory Usage 1,719KB
  • Queries Executed 10 (?)
More Information
Template Usage:
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (1)bbcode_php_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (1)printthreadbit
  • (1)spacer_close
  • (1)spacer_open 
Phrase Groups Available:
  • global
  • postbit
  • showthread
Included Files:
  • ./printthread.php
  • ./global.php
  • ./includes/init.php
  • ./includes/class_core.php
  • ./includes/config.php
  • ./includes/functions.php
  • ./includes/class_hook.php
  • ./includes/modsystem_functions.php
  • ./includes/class_bbcode_alt.php
  • ./includes/class_bbcode.php
  • ./includes/functions_bigthree.php 
Hooks Called:
  • init_startup
  • init_startup_session_setup_start
  • init_startup_session_setup_complete
  • cache_permissions
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • printthread_start
  • bbcode_fetch_tags
  • bbcode_create
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • printthread_post
  • printthread_complete