The Arcive of Official vBulletin Modifications Site.

Latest Arcade Score (more than one?) · **Released**: 12-14-2008

Does anyone know what file I need to edit so that more than one result is listed for the "Latest Arcade Score" area?

The Stifmeister2 referred me here so I am thinking someone here might know how to do this.

Thank You

Nintendo-Daily · #12 12-27-2008, 06:36 PM

Thanks KatieG, I'll try and get up with that person from the site.

Nintendo-Daily · #13 01-04-2009, 08:24 AM

bump...I can't seen to find any support/ solution to this.

Does anyone know what file I need to edit so that more than one result is listed for the "Latest Arcade Score" area?

The Stifmeister2 referred me here so I am thinking someone here might know how to do this.

Thank You

Gemma · #14 01-04-2009, 10:18 AM

Quote:

Originally Posted by Nintendo-Daily

bump...I can't seen to find any support/ solution to this.

Does anyone know what file I need to edit so that more than one result is listed for the "Latest Arcade Score" area?

The Stifmeister2 referred me here so I am thinking someone here might know how to do this.

Thank You

In your arcade.php search for

Code:

//latest score and champions

There should be a database query that can be edited so you can show more than one latest score

KatieG · #15 01-04-2009, 11:04 AM

Quote:

Originally Posted by Stifmeister2

Maybe he bought the branding-free version.

ha ha there is No branding Free version

edytwinky · #16 01-04-2009, 05:58 PM

Here's what I see, I don't see anything to change from 1 latest score to more:

PHP Code:


			
//latest score and champions

       //Added g.decpoints after g.title

                $DB->query("SELECT s.*, g.gtitle, g.decpoints, c.password FROM ibf_games_scores AS s, ibf_games_list AS g, ibf_games_cats AS c WHERE s.gid=g.gid AND g.gcat=c.c_id AND g.active=1 AND trim(password)='' ORDER BY datescored DESC LIMIT 0,5");

                $newest_score = $DB->fetch_row();



        //$newest_score['score'] = $this->arcade->t3h_format($newest_score['score']);

                // Replaced

                $newest_score['score'] = $this->arcade->do_arcade_format($newest_score['score'],$newest_score['decpoints']);



                if ($this->arcade->settings['use_announce'])

        {

            $announce = $this->arcade->settings['announcement_parsed'];

                    $tourneyinfo['announcement'] = $this->html->generalbox($ibforums->lang['arcade_announcements'], $announce);

        }

                else

                $tourneyinfo['announcement'] = "";





        $latestinfo = $ibforums->lang['newest_score'];

        $latestinfo = preg_replace("/<% NAME %>/i" , $newest_score['name'] , $latestinfo);

        $latestinfo = preg_replace("/<% SCORE %>/i" , $newest_score['score'] , $latestinfo);

        $latestinfo = preg_replace("/<% GAME %>/i" , $newest_score['gtitle'] , $latestinfo);





        $newtext = "";

        $DB->query("SELECT c.*, g.gcat, cat.password FROM ibf_games_champs AS c, ibf_games_list AS g, ibf_games_cats AS cat WHERE c.champ_gid=g.gid AND g.gcat=cat.c_id AND g.active=1 AND trim(password)='' ORDER BY champ_date DESC LIMIT 0,5");

        while( $row = $DB->fetch_row() )

        {

                        $row['champ_date'] = $std->get_date($row['champ_date'],'ARCADE');

                if( $row['champ_date'] == date("{$ibforums->lang['timeformat4']}") )

                {

                                $row['champ_date'] = $ibforums->lang['today'];

                        }

                else

                {

                if ($ibforums->lang[timeformat1] == "de")

                {

                                $yesterday = date("{$ibforums->lang['timeformat4']}", mktime(0, 0, 0, date("d")-1  , date("m"), date("Y")));

                }

                else

                {

                                $yesterday = date("{$ibforums->lang['timeformat4']}", mktime(0, 0, 0, date("m")-1  , date("d"), date("Y")));

                }



                                if( $row['champ_date'] == $yesterday )

                    {

                                        $row['champ_date'] = $ibforums->lang['yesterday'];

                                }

                        }

Nintendo-Daily · #17 01-04-2009, 09:14 PM

Yeah, that's the part of the code I was playing around with as well and couldn't figure out how to manipulate it. I really think this is the right part to modify though.

Any ideas?

Think adding another one of these:

Code:

$latestinfo = $ibforums->lang['newest_score']; 
        $latestinfo = preg_replace("/<% NAME %>/i" , $newest_score['name'] , $latestinfo); 
        $latestinfo = preg_replace("/<% SCORE %>/i" , $newest_score['score'] , $latestinfo); 
        $latestinfo = preg_replace("/<% GAME %>/i" , $newest_score['gtitle'] , $latestinfo);

under the original will do the trick?

Stifmeister2 · #18 01-05-2009, 01:17 PM

Quote:

Originally Posted by Nintendo-Daily

Yeah, that's the part of the code I was playing around with as well and couldn't figure out how to manipulate it. I really think this is the right part to modify though.

Any ideas?

Think adding another one of these:

Code:

$latestinfo = $ibforums->lang['newest_score']; 
        $latestinfo = preg_replace("/<% NAME %>/i" , $newest_score['name'] , $latestinfo); 
        $latestinfo = preg_replace("/<% SCORE %>/i" , $newest_score['score'] , $latestinfo); 
        $latestinfo = preg_replace("/<% GAME %>/i" , $newest_score['gtitle'] , $latestinfo);

under the original will do the trick?

You can try, but I'm afraid it will just display the same score twice.

Dunno though, so it's worth a test.

GreasySpoon · #19 01-05-2009, 01:37 PM

arcade.php

Find:

PHP Code:


			
//latest score and champions
       //Added g.decpoints after g.title
                $DB->query("SELECT s.*, g.gtitle, g.decpoints, c.password FROM ibf_games_scores AS s, ibf_games_list AS g, ibf_games_cats AS c WHERE s.gid=g.gid AND g.gcat=c.c_id AND g.active=1 AND trim(password)='' ORDER BY datescored DESC LIMIT 0,5");
                $newest_score = $DB->fetch_row();

        //$newest_score['score'] = $this->arcade->t3h_format($newest_score['score']);
                // Replaced
                $newest_score['score'] = $this->arcade->do_arcade_format($newest_score['score'],$newest_score['decpoints']);

                if ($this->arcade->settings['use_announce'])
        {
            $announce = $this->arcade->settings['announcement_parsed'];
                    $tourneyinfo['announcement'] = $this->html->generalbox($ibforums->lang['arcade_announcements'], $announce);
        }
                else
                $tourneyinfo['announcement'] = "";


        $latestinfo = $ibforums->lang['newest_score'];
        $latestinfo = preg_replace("/<% NAME %>/i" , $newest_score['name'] , $latestinfo);
        $latestinfo = preg_replace("/<% SCORE %>/i" , $newest_score['score'] , $latestinfo);
        $latestinfo = preg_replace("/<% GAME %>/i" , $newest_score['gtitle'] , $latestinfo);

Replace with:

PHP Code:


			
//latest score and champions
       //Added g.decpoints after g.title 
$newest_score_query = $DB->query("SELECT s.*, g.gtitle, g.decpoints, c.password FROM ibf_games_scores AS s, ibf_games_list AS g, ibf_games_cats AS c WHERE s.gid=g.gid AND g.gcat=c.c_id AND g.active=1 AND trim(password)='' ORDER BY datescored DESC LIMIT 0,5");
        while ($newest_score = $DB->fetch_row($newest_score_query))
        {
            $newest_score['score'] = $this->arcade->do_arcade_format($newest_score['score'],$newest_score['decpoints']);

            if ($this->arcade->settings['use_announce'])
            {
                $announce = $this->arcade->settings['announcement_parsed'];
                $tourneyinfo['announcement'] = $this->html->generalbox($ibforums->lang['arcade_announcements'], $announce);
            }
            else
            $tourneyinfo['announcement'] = "";

            $tmplatestinfo = $ibforums->lang['newest_score'];
            $tmplatestinfo = preg_replace("/<% NAME %>/i" , $newest_score['name'] , $tmplatestinfo);
            $tmplatestinfo = preg_replace("/<% SCORE %>/i" , $newest_score['score'] , $tmplatestinfo);
            $tmplatestinfo = preg_replace("/<% GAME %>/i" , $newest_score['gtitle'] , $tmplatestinfo);
            
            $latestinfo[] = $tmplatestinfo;
            
            $this->arcade->make_links($newest_score['gid'] , $newest_score['gtitle']);
            $click_links[] = $this->arcade->links['click'];
        }
        
        $viewerav = "";
        $this->arcade->links['click'] = $click_links;

Find:

PHP Code:


			
//header
        $this->arcade->make_links($newest_score['gid'] , $newest_score['gtitle']);
        $viewerav = "";

Replace with:

PHP Code:


			
//header
        //$this->arcade->make_links($newest_score['gid'] , $newest_score['gtitle']);
        //$viewerav = "";

skin_Arcade.php im am using the blockstyle (check in our arcade) so this modification will only work if you are using also the blockstyle.

Edit: skin_v3Arcade.php is the same. Do the same steps.

Find (in the function start()):

PHP Code:


			
$totalstext = $totalstext . $ibforums->lang['infobox_title7'];

Add below:

PHP Code:


			
for ($i = 0, $count = count($latestinfo); $i < $count; $i++)
{
    $latestscores .= "<tr>
        <td align=\"left\">
            " . $latestinfo[$i] . "<br />
        </td>
        <td align=\"right\">
            " . $clicktoplay['click'][$i] . "
        </td>
    </tr>";
}

Find (in the "return <<<EOF" part):

PHP Code:


			
<tr>
                                                                            <td align="left">
                                                {$latestinfo}<br />
                                                                                </td>
                                            <td align="right">
                                                {$clicktoplay['click']}
                                            </td>
                                        </tr>

Replace with:

PHP Code:


			
{$latestscores}

Greetz

Stifmeister2 · #20 01-05-2009, 07:53 PM

Quote:

Originally Posted by GreasySpoon

arcade.php

Find:

PHP Code:


			
//latest score and champions
       //Added g.decpoints after g.title
                $DB->query("SELECT s.*, g.gtitle, g.decpoints, c.password FROM ibf_games_scores AS s, ibf_games_list AS g, ibf_games_cats AS c WHERE s.gid=g.gid AND g.gcat=c.c_id AND g.active=1 AND trim(password)='' ORDER BY datescored DESC LIMIT 0,5");
                $newest_score = $DB->fetch_row();

        //$newest_score['score'] = $this->arcade->t3h_format($newest_score['score']);
                // Replaced
                $newest_score['score'] = $this->arcade->do_arcade_format($newest_score['score'],$newest_score['decpoints']);

                if ($this->arcade->settings['use_announce'])
        {
            $announce = $this->arcade->settings['announcement_parsed'];
                    $tourneyinfo['announcement'] = $this->html->generalbox($ibforums->lang['arcade_announcements'], $announce);
        }
                else
                $tourneyinfo['announcement'] = "";


        $latestinfo = $ibforums->lang['newest_score'];
        $latestinfo = preg_replace("/<% NAME %>/i" , $newest_score['name'] , $latestinfo);
        $latestinfo = preg_replace("/<% SCORE %>/i" , $newest_score['score'] , $latestinfo);
        $latestinfo = preg_replace("/<% GAME %>/i" , $newest_score['gtitle'] , $latestinfo);

Replace with:

PHP Code:


			
//latest score and champions
       //Added g.decpoints after g.title 
$newest_score_query = $DB->query("SELECT s.*, g.gtitle, g.decpoints, c.password FROM ibf_games_scores AS s, ibf_games_list AS g, ibf_games_cats AS c WHERE s.gid=g.gid AND g.gcat=c.c_id AND g.active=1 AND trim(password)='' ORDER BY datescored DESC LIMIT 0,5");
        while ($newest_score = $DB->fetch_row($newest_score_query))
        {
            $newest_score['score'] = $this->arcade->do_arcade_format($newest_score['score'],$newest_score['decpoints']);

            if ($this->arcade->settings['use_announce'])
            {
                $announce = $this->arcade->settings['announcement_parsed'];
                $tourneyinfo['announcement'] = $this->html->generalbox($ibforums->lang['arcade_announcements'], $announce);
            }
            else
            $tourneyinfo['announcement'] = "";

            $tmplatestinfo = $ibforums->lang['newest_score'];
            $tmplatestinfo = preg_replace("/<% NAME %>/i" , $newest_score['name'] , $tmplatestinfo);
            $tmplatestinfo = preg_replace("/<% SCORE %>/i" , $newest_score['score'] , $tmplatestinfo);
            $tmplatestinfo = preg_replace("/<% GAME %>/i" , $newest_score['gtitle'] , $tmplatestinfo);
            
            $latestinfo[] = $tmplatestinfo;
            
            $this->arcade->make_links($newest_score['gid'] , $newest_score['gtitle']);
            $click_links[] = $this->arcade->links['click'];
        }
        
        $viewerav = "";
        $this->arcade->links['click'] = $click_links;

Find:

PHP Code:


			
//header
        $this->arcade->make_links($newest_score['gid'] , $newest_score['gtitle']);
        $viewerav = "";

Replace with:

PHP Code:


			
//header
        //$this->arcade->make_links($newest_score['gid'] , $newest_score['gtitle']);
        //$viewerav = "";

skin_Arcade.php im am using the blockstyle (check in our arcade) so this modification will only work if you are using also the blockstyle. Should be similar to other styles.

Find (in the function start()):

PHP Code:


			
$totalstext = $totalstext . $ibforums->lang['infobox_title7'];

Add below:

PHP Code:


			
for ($i = 0, $count = count($latestinfo); $i < $count; $i++)
{
    $latestscores .= "<tr>
        <td align=\"left\">
            " . $latestinfo[$i] . "<br />
        </td>
        <td align=\"right\">
            " . $clicktoplay['click'][$i] . "
        </td>
    </tr>";
}

Find (in the "return <<<EOF" part):

PHP Code:


			
<tr>
                                                                            <td align="left">
                                                {$latestinfo}<br />
                                                                                </td>
                                            <td align="right">
                                                {$clicktoplay['click']}
                                            </td>
                                        </tr>

Replace with:

PHP Code:


			
{$latestscores}

Greetz

Wow, that's very nice.

Thank you.

GreasySpoon · #21 01-05-2009, 08:12 PM

No problem

Searched weeks ago for the same feature and did find nothing. So i decided to do it self

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.04663 seconds Memory Usage 2,474KB Queries Executed 25 (?)
More Information
Template Usage: (1)SHOWTHREAD (1)ad_footer_end (1)ad_footer_start (1)ad_header_end (1)ad_header_logo (1)ad_navbar_below (1)ad_showthread_beforeqr (3)bbcode_code (17)bbcode_php (4)bbcode_quote (1)footer (1)forumjump (1)forumrules (1)gobutton (1)header (1)headinclude (1)modsystem_post (1)navbar (6)navbar_link (120)option (1)pagenav (1)pagenav_curpage (3)pagenav_pagelink (11)post_thanks_box (11)post_thanks_button (1)post_thanks_javascript (1)post_thanks_navbar_search (11)post_thanks_postbit_info (10)postbit (11)postbit_onlinestatus (11)postbit_wrapper (1)spacer_close (1)spacer_open (1)tagbit_wrapper Phrase Groups Available: global inlinemod postbit posting reputationlevel showthread	Included Files: ./showthread.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/functions_bigthree.php ./includes/class_postbit.php ./includes/class_bbcode.php ./includes/functions_reputation.php ./includes/functions_post_thanks.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 showthread_start showthread_getinfo forumjump showthread_post_start showthread_query_postids showthread_query bbcode_fetch_tags bbcode_create showthread_postbit_create postbit_factory postbit_display_start post_thanks_function_post_thanks_off_start post_thanks_function_post_thanks_off_end post_thanks_function_fetch_thanks_start post_thanks_function_fetch_thanks_end post_thanks_function_thanked_already_start post_thanks_function_thanked_already_end fetch_musername postbit_imicons bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete postbit_display_complete post_thanks_function_can_thank_this_post_start pagenav_page pagenav_complete tag_fetchbit_complete forumrules navbits navbits_complete showthread_complete
Messages:

The Arcive of Official vBulletin Modifications Site.

It is not a VB3 engine, just a parsed copy!