The Arcive of Official vBulletin Modifications Site.

V3arcade - Show Last Score News · **Released**: 02-28-2006

This Modification show the last scores and the games played in V3arcade main page.
I do not know if the next version of v3arcade taught also the latest scores, but this modification is a way for it.

Fully phrased modification.
Tested in Vbulletin 3.5.3 and V3arcade 1.0.2

Products to import: (1) - product-v3arcade_score_news_english.xml or product-v3arcade_score_news_spanish.xml
Templates to edit: (1) - arcade_main
Templates Added: (2) - arcade_scor_bit & arcade_scor_bit_first
Phrases Added: (4)
DB changes: Add new fields in arcade_news_scor

Instructions...

Download the attached product and install it in Admin CP -> Plugin System -> Manage Products -> [Add/Import Product]

Edit the template "arcade_main"

Search

HTML Code:

<tbody id="collapseobj_newsandevents" style="$vbcollapse[collapseobj_newsandevents]">
    <tr align="center">
      <td class="alt1" valign="top" style="padding: 0px">
          <table cellpadding="0" cellspacing="0" border="0" width="100%" align="center">
          $newsbits
          </table>
      </td>
    </tr>
</tbody>

Bellow add

HTML Code:

<thead>
    <tr align="center">
      <td class="thead"><a style="float:$stylevar[right]" href="#top" onclick="return toggle_collapse('newscorevents')"><img id="collapseimg_newscorevents" src="$stylevar[imgdir_button]/collapse_thead$vbcollapse[collapseimg_newscorevents].gif" alt="" border="0" /></a>$vbphrase[newscorevents]</td>
    </tr>
</thead>
<tbody id="collapseobj_newscorevents" style="$vbcollapse[collapseobj_newscorevents]">
    <tr align="center">
      <td class="alt1" valign="top" style="padding: 0px">
          <table cellpadding="0" cellspacing="0" border="0" width="100%" align="center">
          $scorbits
          </table>
      </td>
    </tr>
</tbody>

Edit arcade.php file in /forumroot/

Search

PHP Code:


			
'arcade_news_bit',

Bellow add

PHP Code:


			
'arcade_scor_bit_first',
 'arcade_scor_bit',

Search

PHP Code:


			
        eval('$newsbits .= "' . fetch_template('arcade_news_bit') . '";');
    }

Bellow add

PHP Code:


			
  // MioTraGuSa Modification Last Scores
    // Fetch the latest scores.
    $scorbits = '';
    $scorquery = $db->query_read("SELECT * FROM " . TABLE_PREFIX . "arcade_news_scor AS arcade_news_scor ORDER BY datescor DESC LIMIT " . $vbulletin->options['quicksearchresults']);
    while ($scor = $db->fetch_array($scorquery))
    {
        exec_switch_bg();

    // Format the score news date/time.

    $scor['date'] = vbdate($vbulletin->options['logdateformat'], $scor['datescor']);
    $scor['newstext'] = unhtmlspecialchars($parser->do_parse($scor['scortext'], false, true, true, false, true, false));
    if ($scor['scorid'] == "1")
        {
        eval('$scorbits .= "' . fetch_template('arcade_scor_bit_first') . '";');
        } else {
            eval('$scorbits .= "' . fetch_template('arcade_scor_bit') . '";');
            }
    }

Search

PHP Code:


			
    // Save the session.
    $db->query_write("UPDATE " . TABLE_PREFIX . "arcade_sessions SET ping='$difference', valid=$validate WHERE sessionid=" . $vbulletin->GPC['id'] . " AND userid=" . $vbulletin->userinfo['userid']);

Bellow add

PHP Code:


			
  // MioTraGuSa Modification Last Scores    
    $gamescornews['score'] = sprintf((float)$game['score']);
    if ($gamescornews['score'] <= 1) {
    $db->query_write("INSERT INTO " . TABLE_PREFIX . "arcade_news_scor (scortext, scortype, scorgame, scoruserid, datescor) VALUES ('" . addslashes(construct_phrase($vbphrase['x_points_in_the_y_gamezero'], $vbulletin->userinfo['username'], $gamescornews['score'], $game['title'])) . "', 'auto', '$game[gameid]', " .$vbulletin->userinfo['userid']. ", " . TIMENOW . ")");
    } else {
        $db->query_write("INSERT INTO " . TABLE_PREFIX . "arcade_news_scor (scortext, scortype, scorgame, scoruserid, datescor) VALUES ('" . addslashes(construct_phrase($vbphrase['x_points_in_the_y_game'], $vbulletin->userinfo['username'], $gamescornews['score'], $game['title'])) . "', 'auto', '$game[gameid]', " .$vbulletin->userinfo['userid']. ", " . TIMENOW . ")");
        }
  // MioTraGuSa END Modification Last Scores

Upload modified file

Enjoy!!

If your like this modification, please click Install

Sorry for my very bad english ...:nervous:

Omranic · #2 03-01-2006, 11:59 PM

hey thanks

there is two issues
the first code error here

your code must be

PHP Code:


			
 // MioTraGuSa Modification Last Scores

    // Fetch the latest scores.

    $scorbits = '';

    $scorquery = $db->query_read("SELECT * FROM " . TABLE_PREFIX . "arcade_news_scor AS arcade_news_scor ORDER BY datescor DESC LIMIT " . $vbulletin->options['quicksearchresults']);

    while ($scor = $db->fetch_array($scorquery))

    {

        exec_switch_bg();



    // Format the score news date/time.



    $scor['date'] = vbdate($vbulletin->options['logdateformat'], $scor['datescor']);

    $scor['newstext'] = unhtmlspecialchars($parser->do_parse($scor['scortext'], false, true, true, false, true, false));

    if ($scor['scorid'] == "1")

        {

        eval('$scorbits .= "' . fetch_template('arcade_scor_bit_first') . '";');

        } else {

            if ($scor['scorgame'] <= "1")

            {

            eval('$scorbits .= "' . fetch_template('arcade_scor_bit') . '";');

            }

        }

    }

  // MioTraGuSa END Modification Last Scores

notice the additional
}
at the end

if not it will give error

the second thing Is that the Last Scores menu doesn't show any thing exept "Instalation of Show last Scores - Done!!" phrase knowing that i have played some games & get in some hight scores & in some not hight score
this is my arcade

Hornstar · #3 03-02-2006, 01:57 AM

Ok great work, been waiting on some new mods for the arcade, cant wait til the actual arcade gets its next update this month.

MioTraGusa · #4 03-02-2006, 05:27 AM

yes the code is bad .. sorry.

The code is

PHP Code:


			
  // MioTraGuSa Modification Last Scores
    // Fetch the latest scores.
    $scorbits = '';
    $scorquery = $db->query_read("SELECT * FROM " . TABLE_PREFIX . "arcade_news_scor AS arcade_news_scor ORDER BY datescor DESC LIMIT " . $vbulletin->options['quicksearchresults']);
    while ($scor = $db->fetch_array($scorquery))
    {
        exec_switch_bg();

    // Format the score news date/time.

    $scor['date'] = vbdate($vbulletin->options['logdateformat'], $scor['datescor']);
    $scor['newstext'] = unhtmlspecialchars($parser->do_parse($scor['scortext'], false, true, true, false, true, false));
    if ($scor['scorid'] == "1")
        {
        eval('$scorbits .= "' . fetch_template('arcade_scor_bit_first') . '";');
        } else {
            eval('$scorbits .= "' . fetch_template('arcade_scor_bit') . '";');
            }
    }
  // MioTraGuSa END Modification Last Scores

and

PHP Code:


			
  // MioTraGuSa Modification Last Scores    
    $gamescornews['score'] = sprintf((float)$game['score']);
    if ($gamescornews['score'] <= 1) {
    $db->query_write("INSERT INTO " . TABLE_PREFIX . "arcade_news_scor (scortext, scortype, scorgame, scoruserid, datescor) VALUES ('" . addslashes(construct_phrase($vbphrase['x_points_in_the_y_gamezero'], $vbulletin->userinfo['username'], $gamescornews['score'], $game['title'])) . "', 'auto', '$game[gameid]', " .$vbulletin->userinfo['userid']. ", " . TIMENOW . ")");
    } else {
        $db->query_write("INSERT INTO " . TABLE_PREFIX . "arcade_news_scor (scortext, scortype, scorgame, scoruserid, datescor) VALUES ('" . addslashes(construct_phrase($vbphrase['x_points_in_the_y_game'], $vbulletin->userinfo['username'], $gamescornews['score'], $game['title'])) . "', 'auto', '$game[gameid]', " .$vbulletin->userinfo['userid']. ", " . TIMENOW . ")");
        }
  // MioTraGuSa END Modification Last Scores

Updated .. sorry

test it ..

soulface · #5 03-30-2006, 08:31 AM

its not working on 1.0.5 anymore :S

MioTraGusa · #6 03-30-2006, 12:23 PM

Quote:

Originally Posted by soulface

its not working on 1.0.5 anymore :S

Exactly, that is what does not work? At present I have installed the version 1.05 of v3arcade and work for me.

soulface · #7 04-06-2006, 01:03 PM

ummm its working on 1.0.6 now lol... don know whats the reason that was not working in 1.0.5 :/

MioTraGusa · #8 04-06-2006, 05:04 PM

I don't have neither idea, because it work for my well with the version 1.0.5 .The version 1.0.6 isn't most different.

Intex · #9 10-14-2006, 07:02 PM

How do you amend how many last scores show? At the moment, there's 10 by default and I only want to display 5.

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.04722 seconds Memory Usage 2,352KB Queries Executed 23 (?)
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 (2)bbcode_html (9)bbcode_php (1)bbcode_quote (1)footer (1)forumjump (1)forumrules (1)gobutton (1)header (1)headinclude (1)modsystem_post (1)navbar (6)navbar_link (120)option (9)post_thanks_box (9)post_thanks_button (1)post_thanks_javascript (1)post_thanks_navbar_search (9)post_thanks_postbit_info (8)postbit (9)postbit_onlinestatus (9)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 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!