DB MAINTENANCE MOD 1.3.1
(c) 2003-2005 by Philipp Kordowich
Visit http://phpbb.kordowich.net/ for updates

About this Mod
--------------
This mod checks and fixes inconsistencies and errors in the database.


System requirements
-------------------
- phpBB 2.0.4 to 2.0.11 (All other versions are unsupported. You may read using_with_203.txt for a workaround)
- A MySQL-Database. This mod was developed for MySQL 3.23.17 or newer. It should work on MySQL 3.22 quite fine but will not make use of all the additional features MySQL offers.
- A little bit of space on your Web-Server.


Warning
-------
This mod will make changes directly in your database. Even though each function was tested before releasing this mod, I can and will take no responsibility for any damage done to your database.
It is YOUR responsibility to make a backup of your database before using this mod.
DB Maintenance was build on the database structure of an standard phpBB. There are however (little) modifications who do change this structure. In this case it may happen that DB Maintenance interprets special data of these Mods as faulty and corrects them. Therefore no guaranty can be given for the correct operation of DB Maintenance special when using other modifikations.


Installing instructions
-----------------------
Installing instructions can be found in db_maintenance.txt. If you have problems with the format of the instructions please visit phpbb.com for further assistance.
It is strongly recommended that you backup all your files and your database before doing any changes!


Updating
--------
When updating from an earlier version, you have to replace all files included with the mod. When upgrading from a version earlier than 1.2.1, you also have to execute the SQL-statements mentioned in db_maintenance.txt or execute the update_db_for_dbmtnc.php.


Emergency Recovery Console
--------------------------
This mod includes an Emergency Recovery Console (ERC), which can be used to access the board even when the normal methods of phpBB fail. You can clear the session table, reset path, cookie, language or template data, clear the ban list, remove administrator accounts, garant an user admin privileges or recreate the config.php. Thus, the ERC can be helpful when you have problems with the session handling, removed a template in error or your board was hacked. To access the ERC, open the URL http://www.yourdomain.net/folder/admin/erc.php - of course you have to replace www.yourdomain.net/folder with the domain and the folder (if appropriate) of your board.
SECURITY NOTE: You can gain access to the complete board by using the ERC. Although you need at least the password of the database to do so, it is reccommended to install this file only when necessary or to secure the admin directory whith a password at least. You can use the whole power of this mod without installing the erc.php (well, except for the ERC itself of course).


Additional information
----------------------
Since this mod was developed originally for a German board, a German translation is also included. You do not need to add the German parts as long as you don't want to use them.
This version only works with the subSilver-theme provided with the original Files of phpBB. You need to adapt any other theme for using it with this mod.
Usage instructions for this Mod can be found in the documentation included. (Documentation may carry an older version number as long as no update within the documentation was needed)


Translation information
-----------------------
The mod's language is English. A German translation is also included in the package.
Information about other languages can be found at http://phpbb.kordowich.net/


Files included
--------------
DB Maintenance Benutzerhandbuch.pdf - Documentation (German)
DB Maintenance User Manual.pdf      - Documentation (English)
db_maintenance.txt                  - Mod information file
README.txt                          - Well, you are reading it :-)
using_with_203.txt                  - Workaround for usage with phpBB 2.0.3 and before
files/admin_db_maintenance.php      - Main module of the mod
files/dbmtnc_config_body.tpl        - Template for configuration
files/dbmtnc_confirm_body.tpl       - Template for confirmation message
files/dbmtnc_list_body.tpl          - Template for the list of available functions
files/dbmtnc_statistic_body.tpl     - Template fot the statistic
files/erc.php                       - Emergency recovery console
files/functions_dbmtnc.php          - Functions for the Mod
files/lang_dbmtnc.php               - Language file for the mod (English)
files/lang_dbmtnc_ger.php           - Language file for the mod (German)
files/update_db_for_dbmtnc.php      - Update script for Database


Version history
---------------
1.0.0  (2003-07-30): First release
1.0.0a (2003-08-10): Just the same as version 1.0.0 but with a remark for compatibility with phpBB 2.0.6
1.1.0  (2003-09-18): Compatibility for MySQL <= 3.23.17, statistical data about board and database, function to hide items not available in the menu, some other new functions
1.1.0a (2004-02-21): Fixed a small bug in lang_dbmtnc.php (no functional impact)
1.2.0  (2004-04-09): Added function to rebuild the search index, some additions to ERC, user manual included
1.2.1  (2004-05-10): Configuration can now be done from the main windows, fixed a bug that removed data of new posts when restarting reindexing
1.2.2  (2004-06-12): Added aibility to restore anonymous user
1.2.2a (2004-06-26): Bug-fix which removed single user group for Anonymous
1.2.2b (2004-07-13): Just the same as version 1.2.2a but with a remark for compatibility with phpBB 2.0.9
1.2.2c (2004-07-29): Fixed a bug causing a warning under some conditions. Added remark for compatibility with phpBB 2.0.10
1.3.0  (2004-12-26): Added function to check for missing entries in config table. Some modifications to prevent some warnings and to add compatibility for MySQL 4.1. Some minor changes.
1.3.0a (2004-12-30): Fixed a missing entry for the config tabele.
1.3.1  (2005-02-05): Some bugfixes

Support
-------
Please do NOT contact me directly by e-mail or private message for any support request. Please use the forums provided on http://www.phpbb.com/, http://www.phpbb.de/ or http://www.phpbbhacks.com/ for any support request. If you do not get an answer in an appropriate time, please feel free to contact me with a private message (Username in all forums: PhilippK). Especially on the english boards I often do not have the time to check all posts.
Direct e-mail-contact only will be supported for security vulnerability or other bugs. See db_maintenance.txt for contact details.
