When customizing your forum, you may occasionally need to add or alter things in your database. Many hacks, for instance, have SQL sections in their instructions, and these sections contain a number of SQL queries that should be run on the database. There are four ways you can run these queries on your database.
The first three ways - using author supplied scripts and two uses of phpMyAdmin - are discussed in JohnMck's tutorial, Installing phpBB Hacks
. In this tutorial, we will focus on the fourth method and some common problems encountered when using this method. The fourth method is to create your own script to run the SQL queries for you.
This type of script can be created using our DB Update Generator
form. In most cases, you can simply copy and paste the SQL queries into this form, and it will create a downloadable db_update.php file for you. You can then upload this file to your forums, log in as the forum administrator, and visit the db_update.php file. It automatically processes the queries for you. Once you are finished, delete the db_update.php from the server. Viola - you've completed the SQL instructions you needed.