Leitgedanken/msd/inc/sqllib.php
2023-02-11 15:24:36 +01:00

70 lines
2.0 KiB
PHP

<?php
/* ----------------------------------------------------------------------
MyOOS [Dumper]
http://www.oos-shop.de/
Copyright (c) 2013 - 2022 by the MyOOS Development Team.
----------------------------------------------------------------------
Based on:
MySqlDumper
http://www.mysqldumper.de
Copyright (C)2004-2011 Daniel Schlichtholz (admin@mysqldumper.de)
----------------------------------------------------------------------
Released under the GNU General Public License
---------------------------------------------------------------------- */
if (!defined('MOD_VERSION')) {
exit('No direct access.');
}
//SQL-Library
include './language/'.$config['language'].'/lang_sql.php';
/*
Template
if $sqllib[$i]['sql'] =trenn, Then it is a Heading
$sqllib[$i]['name'] = '';
$sqllib[$i]['sql'] = '';
$i++;
*/
$i = 0;
$sqllib = [];
$sqllib[$i]['name'] = $lang['L_SQLLIB_GENERALFUNCTIONS'];
$sqllib[$i]['sql'] = 'trenn';
++$i;
$sqllib[$i]['name'] = $lang['L_SQLLIB_RESETAUTO'];
$sqllib[$i]['sql'] = 'ALTER TABLE `table` AUTO_INCREMENT=1;';
++$i;
/********* phpBB-Boards *********************************/
$sqllib[$i]['name'] = 'phpBB-'.$lang['L_SQLLIB_BOARDS'];
$sqllib[$i]['sql'] = 'trenn';
++$i;
// Bord de-/aktivieren
$sqllib[$i]['name'] = $lang['L_SQLLIB_DEACTIVATEBOARD'].' [phpBB]';
$sqllib[$i]['sql'] = "UPDATE `phpbb_config` set config_value=1 where config_name='board_disable'";
++$i;
$sqllib[$i]['name'] = $lang['L_SQLLIB_ACTIVATEBOARD'].' [phpBB]';
$sqllib[$i]['sql'] = "UPDATE `phpbb_config` set config_value=0 where config_name='board_disable'";
++$i;
// Bord de-/aktivieren
$sqllib[$i]['name'] = 'vBulletin-'.$lang['L_SQLLIB_BOARDS'];
$sqllib[$i]['sql'] = 'trenn';
++$i;
// Bord de-/aktivieren
$sqllib[$i]['name'] = $lang['L_SQLLIB_DEACTIVATEBOARD'].' [vBulletin]';
$sqllib[$i]['sql'] = 'UPDATE forum SET options = options - 1 WHERE options & 1';
++$i;
$sqllib[$i]['name'] = $lang['L_SQLLIB_ACTIVATEBOARD'].' [vBulletin]';
$sqllib[$i]['sql'] = 'UPDATE forum SET options = options + 1 WHERE NOT (options & 1)';
++$i;