[syntax="php"]<?php
$sql = array (
0 => 'INSERT INTO phpbb_config (config_name, config_value) VALUES (\'smilie_columns\', \'4\')',
1 => 'INSERT INTO phpbb_config (config_name, config_value) VALUES (\'smilie_rows\', \'5\')',
2 => 'INSERT INTO phpbb_config (config_name, config_value) VALUES (\'smilie_window_columns\', \'8\')',
);
@set_time_limit(0);
if(!@file_exists('config.php')) die('config.php not found. make sure you have uploaded file to your forum directory.');
include('config.php');
$db = mysql_connect($dbhost, $dbuser, $dbpasswd);
if(!$db) die('Cannot connect: ' . mysql_error());
$res = mysql_select_db($dbname);
if(!$res) die('Cannot select database "' . $dbname . '": ' . mysql_error());
for($i=0; $i<count($sql); $i++)
{
if($table_prefix !== 'phpbb_') $sql[$i] = preg_replace('/phpbb_/', $table_prefix, $sql[$i]);
$res = mysql_query($sql[$i]);
if(!$res) { echo 'error in query ', ($i + 1), ': ', mysql_error(), '<br />'; }
}
echo 'done (', count($sql), ' queries).';
?>[/syntax]