Mod Howto

Mod Description	Makes Invisionboard 1.3 compatible with nyMSQL5
Mod Compatibility	Invision Power Board 1.3
Mod Category	Major Mod
Mod Author	Peter
Mod Author's Email	Peter@ibforen.de
Info File	sources/mods/mysql5/mod_mysql5_howto.htm
Mod Version	1.0.2
Comment	Distribution is not allowed. Download from ibforen.de All changes could be recognized by mod_token This html-howto was created with The ModInstaller 1.3.2 by Peter@ibforen.de, released on 29th January, 2007 Creation time 2009-01-23 It is not for public use. Attention This modification is no freeware. Redistribution of this howto or of one of the mod files is prohibited. Redistribution of the mod or its files only with my authorisation. Customizing of the mod, in order to fit your board's skin, is welcomed. Share your experiences with the community.But do not hurt my copyright by distributing code segment derivated from this mod. Violation of these rules will finally let me stop any production of free available modifications or programs. Please, respect the creative work of coders and take care of their copyrights.
Mod Token	mod_mysql5

1 Newest History and Change Logs
2 Changes
3 Copy
4 Code
5 Customize
6 Comment
7 Older Change History and Change Logs

Version 1.0.2

Makes DynamicLite compatible with mySQL5
Improved modification of the mySQL driver.
Changes in sources/dynamiclite/csite.php and sources/Drivers/mySQL.php

$DB->query("SELECT f.*, c.id as cat_id, c.position as cat_position, c.state as cat_state, c.name as cat_name, c.description as cat_desc,

//-- mod_mysql5 begin
        if (TRUE)
            $DB->query("SELECT f.*, c.id as cat_id, c.position as cat_position, c.state as cat_state, c.name as cat_name, c.description as cat_desc,
                       c.image, c.url, m.member_name as mod_name, m.member_id as mod_id, m.is_group, m.group_id, m.group_name, m.mid
                       FROM ibf_categories c,ibf_forums f
                        LEFT JOIN ibf_moderators m ON (f.id=m.forum_id)
                       WHERE c.id=f.category
                       ORDER BY c.position, f.position");
        else
//-- mod_mysql5 end

        $DB->query("SELECT f.*, c.id as cat_id, c.position as cat_position, c.state as cat_state, c.name as cat_name, c.description as cat_desc,

if ( $ibforums->vars['vb_configured'] )
{

//-- mod_mysql5 begin
        if (TRUE)
            if ( $ibforums->vars['vb_configured'] )
                $DB->query("SELECT  t.*, f.read_perms, f.use_html, p.*, m.avatar, m.view_avs, m.avatar_size,
                                    m.id as member_id, m.name as member_name, m.mgroup, g.g_id, g.g_dohtml
                                FROM ibf_posts p
                                    LEFT JOIN ibf_topics t ON (t.tid=p.topic_id)
                                    LEFT JOIN ibf_forums f ON (f.id=p.forum_id)
                                    LEFT JOIN ibf_members m ON (p.author_id=m.id)
                                    LEFT JOIN ibf_groups g ON (g.g_id=m.mgroup)
                                WHERE   t.approved=1 AND t.moved_to IS NULL AND
                                        p.forum_id IN (-1{$ibforums->vars['csite_article_forum']}) $qe
                                GROUP BY p.topic_id
                                ORDER BY t.pinned DESC, p.post_date DESC
                                LIMIT 0,$limit");
            else
                $DB->query("SELECT  t.*, f.read_perms, f.use_html, p.*, m.avatar, m.view_avs, m.avatar_size,
                                    m.id as member_id, m.name as member_name, m.mgroup, g.g_id, g.g_dohtml
                                FROM ibf_topics t
                                    LEFT JOIN ibf_members m ON (t.starter_id=m.id)
                                    LEFT JOIN ibf_groups g ON (g.g_id=m.mgroup)
                                    LEFT JOIN ibf_posts p ON (p.topic_id=t.tid)
                                    LEFT JOIN ibf_forums f on (f.id=p.forum_id)
                                WHERE   t.forum_id IN (-1{$ibforums->vars['csite_article_forum']}) $qe
                                        AND p.new_topic=1 AND t.approved=1 AND (t.moved_to IS NULL or t.moved_to='')
                                ORDER BY t.pinned DESC, t.start_date DESC
                                LIMIT 0,$limit");
        else
//-- mod_mysql5 end

        if ( $ibforums->vars['vb_configured'] )
        {

$DB->query("SELECT t.tid, t.title, t.state, t.last_vote, p.* $sql

//-- mod_mysql5 begin
        if (TRUE) {
            if ($extra)
                $DB->query("SELECT t.tid, t.title, t.state, t.last_vote, p.*, v.member_id as member_voted
                                FROM ibf_polls AS p, ibf_topics AS t
                                LEFT JOIN ibf_voters v ON (v.tid=t.tid)
                                WHERE t.tid=$tid AND p.tid=t.tid AND v.member_id={$ibforums->member['id']}");
            else
                $DB->query("SELECT t.tid, t.title, t.state, t.last_vote, p.*
                                FROM ibf_polls AS p, ibf_topics AS t
                                WHERE t.tid=$tid AND p.tid=t.tid");
        }
        else
//-- mod_mysql5 end

        $DB->query("SELECT t.tid, t.title, t.state, t.last_vote, p.* $sql

        if ($this->obj['debug'])
        {
            global $Debug, $ibforums;

//-- mod_mysql5 begin
        if (!preg_match("`^create\s`ims", $the_query) && !preg_match("`^select\s`ims", $the_query))
            $the_query = preg_replace("`([^\\\])''`", "\\1NULL", $the_query);
//-- mod_mysql5 end

        if ($this->obj['debug'])
        {
            global $Debug, $ibforums;

Attention

The installation must be processed before the update of your database to mySQL5
Before the installation process be sure to have made a complete backup of the board database.
After the installation process and before getting online test your board very very carefully.
If your database is already running under mySQL5, but the board does not work, then you can try to call directly mod_mysql5_install.php from the mod directory.
Therefore copy that script into the root directory of your board and call it with your browser.
If my ModInstaller does not work now, you have to apply the changes to the script files manually.
If you want to process a full new intallation of your IPB under mySQL5, then you have to customize sm_install.php first.
In the mod directory you can find the file mysql5_create.txt. Use the content of that file to exchange the red marked part of sm_install.php.
Zitat

// DATA AND STUFF, ETC

function get_sql()
{

$SQL = array();

$SQL[] = "CREATE TABLE `ibf_admin_logs` (
`id` bigint(20) NOT NULL auto_increment,
`act` varchar(255) default NULL,

...

$SQL[] = "CREATE TABLE `ibf_warn_logs` (
`wlog_id` int(10) NOT NULL auto_increment,
`wlog_mid` mediumint(8) default '0',
`wlog_notes` text,
`wlog_contact` varchar(250) default 'none',
`wlog_contact_content` text,
`wlog_date` int(10) NOT NULL default '0',
`wlog_type` varchar(6) default 'pos',
`wlog_addedby` mediumint(8) default '0',
PRIMARY KEY (`wlog_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;";

$SQL[] = "INSERT INTO ibf_categories (id, position, state, name, description, image, url) VALUES (-1, NULL, NULL, '-', NULL, NULL, NULL)";
$SQL[] = "INSERT INTO ibf_categories (id, position, state, name, description, image, url) VALUES (1, 1, '1', 'A Test Category', '', '', '')";

Thereafter you can call the install script without any further errrors.
If your board has to run under PHP5, then you have to customize sm_install.php again. INsert the blue code at the very beginning of the file:
Zitat

| > Update For mySQL5 AND PHP5 by Peter@ibforen.de
|
+--------------------------------------------------------------------------
*/

error_reporting (E_ERROR | E_WARNING | E_PARSE);
set_magic_quotes_runtime(0);

$HTTP_SERVER_VARS = $_SERVER;
$HTTP_GET_VARS = $_GET;
$HTTP_POST_VARS = $_POST;
$HTTP_POST_FILES = $_FILES;
$HTTP_COOKIE_VARS = $_COOKIE;
$HTTP_ENV_VARS = $_ENV;
$HTTP_SESSION_FILES = $_SESSION;

//+---------------------------------------
// ENTER YOUR PATH TO THE DIRECTORY THIS SCRIPT
// IS IN.
After the installation of the board under PHP5 you have to modify index.php and admin.php, too.

In index.php insert the blue code as shown below:
Zitat

| > Wrapper script
| > Script written by Matt Mecham
| > Date started: 14th February 2002
|
+--------------------------------------------------------------------------
*/

//-- mod_sec_update_131 begin
error_reporting (E_ALL);
if (isset($HTTP_POST_VARS['GLOBALS']) || isset($_POST['GLOBALS']) ||
isset($HTTP_POST_FILES['GLOBALS']) || isset($_FILES['GLOBALS']) ||
isset($HTTP_GET_VARS['GLOBALS']) || isset($_GET['GLOBALS']) ||
isset($HTTP_COOKIE_VARS['GLOBALS']) || isset($_COOKIE['GLOBALS'])) {
trigger_error('Is this a GLOBAL GPC hacking attempt?', E_USER_ERROR);
}
$HTTP_SERVER_VARS = isset($_SERVER)?$_SERVER:array();
$HTTP_GET_VARS = isset($_GET)?$_GET:array();
$HTTP_POST_VARS = isset($_POST)?$_POST:array();
$HTTP_POST_FILES = isset($_FILES)?$_FILES:array();
$HTTP_COOKIE_VARS = isset($_COOKIE)?$_COOKIE:array();
$HTTP_ENV_VARS = isset($_ENV)?$_ENV:array();
$HTTP_SESSION_VARS = isset($_SESSION)?$_SESSION:array();
//-- mod_sec_update_131 end
//-----------------------------------------------
// USER CONFIGURABLE ELEMENTS
//-----------------------------------------------

In admin.php you have to insert the blue code like:
Zitat

| > Admin wrapper script
| > Script written by Matt Mecham
| > Date started: 1st March 2002
|
+--------------------------------------------------------------------------
*/

//-- mod_sec_update_131 begin
define("ADMIN_SCRIPT_NAME", preg_replace("`^(.*?\.php).*$`", "\\1", basename(htmlentities($_SERVER['SCRIPT_NAME']))));
$HTTP_SERVER_VARS = isset($_SERVER)?$_SERVER:array();
$HTTP_GET_VARS = isset($_GET)?$_GET:array();
$HTTP_POST_VARS = isset($_POST)?$_POST:array();
$HTTP_POST_FILES = isset($_FILES)?$_FILES:array();
$HTTP_COOKIE_VARS = isset($_COOKIE)?$_COOKIE:array();
$HTTP_ENV_VARS = isset($_ENV)?$_ENV:array();
$HTTP_SESSION_VARS = isset($_SESSION)?$_SESSION:array();
//-- mod_sec_update_131 end
/*-----------------------------------------------
USER CONFIGURABLE ELEMENTS
------------------------------------------------*/

Changed file	Changed function
sources/Boards.php	Boards(..)
sources/Drivers/mySQL.php	query(..)
sources/dynamiclite/csite.php	click_site(..)
sources/dynamiclite/csite.php	_show_poll(..)