vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   Modification Graveyard (https://vborg.vbsupport.ru/forumdisplay.php?f=224)
-   -   v3Arcade - Add Clear All Scores Button (https://vborg.vbsupport.ru/showthread.php?t=104180)

tcs 12-31-2005 10:00 PM
v3Arcade - Add Clear All Scores Button
 
This will add a "Clear All Scores" Button in your Arcade admincp under "Scores Tools"

Clicking this button will clear all scores out of your database.

1 php file to edit and only 2 entries to make. (About a minite of your time)

Open the /admincp/arcadeadmin.php file.

then
Back up you database!!!!!!!
No Warrenties or guaentees express or implied.

PHP Code:
Find:
    print_cp_footer();
}

// -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
// REMOVE ZERO SCORES
// -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-

Add this Above:

    print_form_header('arcadeadmin', 'removescores');
    print_table_header('Remove ALL Scores');
    print_description_row('Will Remove All Scores from your Database. Cannot be undone');
    print_submit_row($vbphrase['start'], '');



Find: 
// -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
// REMOVE USER SCORES
// -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-

And Add this Above:

// -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-  
// REMOVE ALL SCORES  
// -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-  
if ($_REQUEST['do'] == 'removescores')  
{ 

    print_cp_header($vbphrase['arcade_scores']);  
    $db->query_write("DELETE FROM " . TABLE_PREFIX ."arcade_sessions  
    ");  
    $db->query_write("DELETE FROM " . TABLE_PREFIX ."arcade_news  
    ");  

    $db->query_write("UPDATE " . TABLE_PREFIX ."arcade_games SET highscore='0.000'");  
        $db->query_write("UPDATE " . TABLE_PREFIX ."arcade_games SET highscorerid='0'");  

    // Getting Arcade functions to rebuild the counts.  
    require_once(DIR . '/includes/functions_arcade.php');  
    build_games();  

    print_cp_redirect('arcadeadmin.php?do=scores');   
} 

docvader 01-01-2006 06:17 PM
YAY, first post.

I shall install this.

Nothing like pissing off some of my Arcade gods.

docvader 01-01-2006 06:47 PM
Sorry. First, and hopefully only, issue.

There are five or six instances of "print_cp_footer();"

Not sure which one you mean.

Gizmo5h1t3 01-01-2006 06:48 PM
rofl...i came on here to look for this, entered"arcade" in search, and found this...lmao

nice 1!!!

tcs 01-01-2006 07:01 PM
Quote:
Originally Posted by docvader
Sorry. First, and hopefully only, issue.

There are five or six instances of "print_cp_footer();"

Not sure which one you mean.

Thanks, Found and fixed it in the code above.
PHP Code:
find:
    print_cp_footer();
}

// -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
// REMOVE ZERO SCORES
// -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=- 

Gizmo5h1t3 01-01-2006 07:02 PM
changed and works a treat...nice addition m8!!

docvader 01-01-2006 07:14 PM
You have to put the first step of his install, above the print_cp_footer, that resides in the
Quote:
// -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
// SCORES
// Games contain scores.
// -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
section of arcadeadmin.php file.

docvader 01-01-2006 07:18 PM
OOPS. You responded pretty quickly there tcs.

Works great. Thanks! I have members that will no doubt be very unhappy tonight.... LOL

Oblivion Knight 01-01-2006 08:13 PM
Wouldn't it be a good idea to clear the news when clearing the scores also? :)

Otherwise you'll have a lot of "new champion" events that are no longer relevant.

tcs 01-01-2006 09:38 PM
Quote:
Originally Posted by Oblivion Knight
Wouldn't it be a good idea to clear the news when clearing the scores also? :)

Otherwise you'll have a lot of "new champion" events that are no longer relevant.

Yep. Didn't think of that. Will add and do an update. You help save my face a week from now.

tcs 01-01-2006 09:49 PM
Code fix, It is already added to the install above. Ignore this if you just installed the above code.

If you just want to add the change it is below.

PHP Code:
Find:

    $db->query_write("DELETE FROM " . TABLE_PREFIX ."arcade_sessions 
    "); 


Add this below:
 
    $db->query_write("DELETE FROM " . TABLE_PREFIX ."arcade_news 
    "); 

Snake 01-02-2006 06:30 AM
<font color="#15a018">* Aftermath installs on his forums</font>


All times are GMT. The time now is 09:43 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.01744 seconds
  • Memory Usage 1,751KB
  • 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
  • (3)bbcode_php_printable
  • (3)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (12)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