Remove All Scores Button

[Chuckie]

This will add a button in you scores tools section of you Arcade Admincp. Tested on only 2 sites so far and works good.

Does 3 quarries at execution only.

1 php file to edit.

Open /admincp/arcadeadmin.php

add these 2 edits in the stated locations.

Back up you database!!!!!!!
No Warranties or guarantees express or implied.

{Fixed Code} (http://www.v3arcade.com/forums/showpost.php?p=7314&postcount=3)

[egyptsons]

Thanks
:)

I do it and it's works good :cool:

[Our Sponsors]

[marquisite]

For some reason I couldnt get it to work, however with some editing it does now!

I changed the UPDATE order around, as that was the cause of the invalid sql query error.

Here is my code:

// -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
// 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');
}

[Chuckie]

For some reason I couldnt get it to work, however with some editing it does now!

I changed the UPDATE order around, as that was the cause of the invalid sql query error.

Here is my code:

// -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
// 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');
}

You are right, it is an error on my part that would cause a problem if you have a table prefix. Cannot edit my post above to fix it.

[Our Sponsors]

[Detomah]

Don't suppose you could add some kind of double check reference to the code, so that it doesn't delete all the scroes with a single click? I could forsee some violent langueage by various webmasters after having little accidents.

I got it working fine, but if you read between the lines above, you may get an idea of what I did by accident when I first added it. ;)

Fortunately it was on a day where all the scores were due a reset anyway.

[theguru]

Would it be possible for some kind person to come up with the following code for me please?

I'd like a cron job that would automatically remove scores that are older than a specified period (eg 1 month)

[fly]

Where does this code go? I think that part got deleted. Anyone know if this works with 1.0.5?

[imported_lairnoc]

Where does this code go? I think that part got deleted. Anyone know if this works with 1.0.5?

yeah i wanno know that too prune all button would be great actually

[imported_legendarybennnn]

would love to know this aswell

[fly]

would love to know this aswell
It does work, as I just ran the SQL queries. Would love to know how to get this into the script though.

[Shafy]

where is the code for showing the actual button?

The templete edits where are that? Can someome please give us the complete code and edits.

Thanks

[imported_Zendiver]

Here is what I have done to remove all scores. See file attached.

[imported_Black Cobra]

Can the attachment be approved so we can use this please?

[dvg323]

the newest version of the arcade has this feature included. ;)~

[theguru]

the newest version of the arcade has this feature included. ;)~
Does it? Which version specifically and where?

[imported_kimrur]

I haven't seen it in the newest version either

[imported_Black Cobra]

he might of had it in the olde version and it kept in when he updated...

[CrazyEh]

Does Zen's version work?. I need to clear all the scores, but I'm kind of worried here.. I'm not sure why this isn't included?.

Thanks.

[Chuckie]

Zens works fine. Only difference is he added a check and a popup. Either way they are both good and safe if you want you scores database cleaned out.

[Ryder]

sorry if this is too old to be revived but works great, thanks for the mod :D!