function ArcadeCountGames()
{
global $smcFunc, $arcSettings;
$result = $smcFunc['db_query']('', '
SELECT count(*) AS games
FROM {db_prefix}arcade_games WHERE enabled = 1', array());
list($total_games) = $smcFunc['db_fetch_row']($result);
$smcFunc['db_free_result']($result);
$updates = array('arcade_total_games' => $total_games);
saveArcadeSettings($updates);
}
function GamesQuickEdit()
{
global $scripturl, $txt, $smcFunc, $context, $arcSettings;
checkSession('post');
switch ($_REQUEST['qaction']) {
case 'change':
$games = implode(',', $_POST['games']);
$category = (int) $_POST['qcategory'];
if ($_REQUEST['qset'] == 0) {
$games = implode(',', $_POST['games']);
$category = (int) $_POST['qcategory'];
$smcFunc['db_query']('', '
UPDATE {db_prefix}arcade_games
SET
id_category = {int:idc}
WHERE id_game IN(' . $games . ')', array('idc' => $category));
} else {
$smcFunc['db_query']('', '
UPDATE {db_prefix}arcade_games
SET
id_category = {int:idc}', array('idc' => $category));
}
break;
case 'gotd':
if ($_REQUEST['qset'] == 0) {
foreach ($_POST['games'] as $key => $value) {
$value = (int) $value;
$updates = array('arcadegotd' => $value);
}
saveArcadeSettings($updates);
GamesCacheClear();
}
break;
case 'clear_scores':
if ($_REQUEST['qset'] == 0) {
foreach ($_POST['games'] as $key => $game) {
ScoresDelete($game, 0);
ArcadeFixPositions($game);
}
} else {
$result = $smcFunc['db_query']('', '
SELECT id_game
FROM {db_prefix}arcade_games', array());
while ($game = $smcFunc['db_fetch_assoc']($result)) {
ScoresDelete($game['id_game'], 0);
update_champ_cups($game['id_game']);
}
}
break;
case 'clear_scores2':
if ($_REQUEST['qset'] == 0) {
foreach ($_POST['games'] as $key => $game) {
ScoresDelete($game, 1);
ArcadeFixPositions($game);
}
} else {
$result = $smcFunc['db_query']('', '
SELECT id_game
FROM {db_prefix}arcade_games', array());
while ($game = $smcFunc['db_fetch_assoc']($result)) {
ScoresDelete($game['id_game'], 1);
update_champ_cups($game['id_game']);
}
}
break;
case 'del_games':
if ($_REQUEST['qset'] == 0) {
foreach ($_REQUEST['games'] as $key => $game) {
GamesDelete($game);
ArcadeCountGames();
}
} else {
$result = $smcFunc['db_query']('', '
SELECT id_game
FROM {db_prefix}arcade_games', array());
while ($game = $smcFunc['db_fetch_row']($result)) {
GamesDelete($game[0]);
ArcadeCountGames();
}
}
break;
case 'fix_scores':
if ($_REQUEST['qset'] == 0) {
foreach ($_REQUEST['games'] as $key => $game) {
$result = $smcFunc['db_query']('', '
SELECT id_game, score_type
FROM {db_prefix}arcade_games
WHERE id_game = {int:idg}', array('idg' => $game));
while ($game = $smcFunc['db_fetch_assoc']($result)) {
ArcadeFixPositions($game['id_game'], $game['score_type']);
}
}
} else {
$result = $smcFunc['db_query']('', '
SELECT id_game, score_type
FROM {db_prefix}arcade_games', array());
while ($game = $smcFunc['db_fetch_assoc']($result)) {
ArcadeFixPositions($game['id_game'], $game['score_type']);
}
}
break;
default:
redirectexit('action=admin;area=managearcade;sa=listgames');
break;
}
redirectexit('action=admin;area=managearcade;sa=listgames');
}
