var $sql_report = '';

var $cache_num_queries = 0;

/**

* return on error or display error message

* Build sql statement from array for insert/update/select statements

*

* Idea for this from Ikonboard

*/

function sql_build_array($query, $assoc_ary = false)

{

$fields = array();

$values = array();

{

foreach ($assoc_ary as $key => $var)

{

{

$values[] = 'NULL';

}

{

$values[] = "'" . $this->sql_escape($var) . "'";

}

else

{

$values[] = (is_bool($var)) ? intval($var) : $var;

}

}

}

else if ($query == 'MULTI_INSERT')

{

case 'mysql4':

case 'mysqli':

case 'mssql':

case 'sqlite':

$sql .= (($sql != '') ? ' UNION ALL ' : '') . ' SELECT ' . $user->data['user_id'] . ", $forum_id, $current_time";

break;

$db->sql_query($sql);

unset($topic_id_ary);

}

}

break;

case 'mysql4':

case 'mysqli':

case 'mssql':

case 'sqlite':

$sql = 'INSERT INTO ' . MODERATOR_TABLE . ' (forum_id, user_id, username, group_id, groupname)

' . implode(' UNION ALL ', preg_replace('#^(.*)$#', 'SELECT \1', $m_sql));

case 'mysql4':

case 'mysqli':

case 'mssql':

case 'sqlite':

$sql = implode(' UNION ALL ', preg_replace('#^(.*?)$#', 'SELECT \1', $sql_subary));

break;

case 'mysql4':

case 'mysqli':

case 'mssql':

case 'sqlite':

$sql .= (($sql != '') ? ' UNION ALL ' : '') . " SELECT '$option', " . $type_sql[$type];

break;

global $auth, $db, $user;

global $config, $phpbb_root_path, $phpEx;

// Sanitise for future path use, it's escaped as appropriate for queries

$this->p_class = str_replace(array('.', '/', '\\'), '', basename($p_class));

if (file_exists($phpbb_root_path . 'cache/' . $this->p_class . '_modules.' . $phpEx))

{

include($phpbb_root_path . 'cache/' . $this->p_class . '_modules.' . $phpEx);

}

$right = $depth = $i = 0;

$depth_ary = array();

{

// Authorisation is required ... not authed, skip

if ($row['module_auth'])

$right = $row['right_id'];

$i++;

}

}

function set_active($id = false, $mode = false)

$this->p_parent = $itep_ary['parent'];

$this->p_name = $itep_ary['name'];

$this->p_mode = $itep_ary['mode'];

break;

}

{

$category = $itep_ary['id'];

}

}

}

/**

}

}

function assign_tpl_vars($module_url)

{

$current_padding = $current_depth = 0;

$linear_offset = 'l_block1';

}

// Only output a categories items if it's currently selected

{

$use_tabular_offset = (!$depth) ? 't_block1' : $tabular_offset;

'L_TITLE' => $itep_ary['lang'],

'U_TITLE' => $module_url . '&i=' . (($itep_ary['cat']) ? $itep_ary['id'] : $itep_ary['name'] . '&mode=' . $itep_ary['mode'])

}

'L_TITLE' => $itep_ary['lang'],

'U_TITLE' => $module_url . '&i=' . (($itep_ary['cat']) ? $itep_ary['id'] : $itep_ary['name'] . '&mode=' . $itep_ary['mode'])

$current_depth = $depth;

}

case 'mysql4':

case 'mysqli':

case 'mssql':

case 'sqlite':

$sql .= (($sql != '') ? ' UNION ALL ' : '') . " SELECT $ban_entry, $current_time, $ban_end, $ban_exclude, '" . $db->sql_escape($ban_reason) . "'";

break;

case 'mysql4':

case 'mysqli':

case 'mssql':

case 'sqlite':

$sql = 'INSERT INTO ' . USER_GROUP_TABLE . " (user_id, group_id, group_leader, user_pending)

VALUES " . implode(', ', preg_replace('#^([0-9]+)$#', "(\\1, $group_id, $leader, $pending)", $add_id_ary));

case 'mysql4':

case 'mysqli':

case 'mssql':

case 'sqlite':

$sql = 'INSERT INTO ' . SEARCH_WORD_TABLE . ' (word_text) ' . implode(' UNION ALL ', preg_replace('#^(.*)$#', "SELECT '\$1'", $new_words));

$db->sql_query($sql);

return true;

}

// Sets the template filenames for handles. $filename_array

// should be a hash of handle => filename pairs.

function set_filenames($filename_array)

case 'mysql4':

case 'mysqli':

case 'mssql':

case 'sqlite':

$sql = 'INSERT INTO ' . ZEBRA_TABLE . " (user_id, zebra_id, $sql_mode)

VALUES " . implode(' UNION ALL ', preg_replace('#^([0-9]+)$#', '(' . $user->data['user_id'] . ", \\1, 1)", $user_id_ary));

'NO_ADMIN' => 'You are not authorised to administer this board.',

'NO_FRAMES' => 'Sorry, your browser does not support frames.',

'ADMIN' => 'Administration',

'RETURN_TO' => 'Return to ...',

'FORUM_INDEX' => 'Forum Index',

'ADMIN_INDEX' => 'Admin Index',

'ACP_INDEX' => 'Admin index',

'ACP_CAT_GENERAL' => 'General',

'ACP_CAT_USERGROUP' => 'Users & Groups',

'ACP_USERS_MANAGE' => 'Edit user data',

'DB_CAT' => 'Database',

'DB_BACKUP' => 'Backup Database',

'LOGIN_FORUM' => 'To view or post in this forum you must enter a password.',

'LOGIN_INFO' => 'In order to login you must be registered. Registering takes only a few seconds but gives you increased capabilies. The board administrator may also grant additional permissions to registered users. Before you login please ensure you are familiar with our terms of use and related policies. Please ensure you read any forum rules as you navigate around the board.',

'LOGIN_VIEWFORUM' => 'The board administrator requires you to be registered and logged in to view this forum.',

'LOGOUT_USER' => 'Logout [ %s ]',

'LOG_ADMIN_AUTH_FAIL' => '<b>Failed administration login attempt</b>',

'LOG_ADMIN_AUTH_SUCCESS'=> '<b>Sucessful administration login</b>',

page_footer();

?> \ No newline at end of file