-- phpMyAdmin SQL Dump -- version 3.2.4 -- http://www.phpmyadmin.net -- -- Host: localhost -- Generation Time: Feb 20, 2010 at 02:39 PM -- Server version: 5.1.40 -- PHP Version: 5.2.6 SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO"; /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */; /*!40101 SET NAMES utf8 */; -- -- Database: `bmcforu_transfer` -- -- -------------------------------------------------------- -- -- Table structure for table `productcode` -- CREATE TABLE IF NOT EXISTS `productcode` ( `productcodeid` int(10) unsigned NOT NULL AUTO_INCREMENT, `productid` varchar(25) NOT NULL DEFAULT '', `version` varchar(25) NOT NULL DEFAULT '', `installcode` mediumtext, `uninstallcode` mediumtext, PRIMARY KEY (`productcodeid`), KEY `productid` (`productid`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=368 ; -- -- Dumping data for table `productcode` -- INSERT INTO `productcode` (`productcodeid`, `productid`, `version`, `installcode`, `uninstallcode`) VALUES (285, 'paulm_20051029', '*', '\r\n// Start v1.19 //\r\n$db->hide_errors(); \r\n$info[''cvs''] = trim(substr(substr($arr[''cvs''],10),0,-1));\r\nif ($vbulletin->options[''pemdata''])\r\n{\r\n $data = unserialize($vbulletin->options[''pemdata'']);\r\n $prev = $data[$info[''productid'']];\r\n $data[$info[''productid'']] = $info;\r\n $productdata = $db->escape_string(serialize($data));\r\n $db->query_write("\r\n UPDATE ".TABLE_PREFIX."setting SET value = ''$productdata'' where varname = ''pemdata''\r\n ");\r\n}\r\nelse\r\n{\r\n $data[$info[''productid'']] = $info;\r\n $productdata = $db->escape_string(serialize($data));\r\n $db->query_write("\r\n REPLACE INTO ".TABLE_PREFIX."phrase \r\n (varname, fieldname, product, text)\r\n VALUES (''setting_pemdata_desc'',''vbsettings'',''pem-dummy-product'',''Leave this setting alone.''),\r\n (''setting_pemdata_title'',''vbsettings'',''pem-dummy-product'',''Modification Version Data'')\r\n ");\r\n $db->query_write("\r\n REPLACE INTO ".TABLE_PREFIX."setting \r\n (varname, value, optioncode, displayorder, grouptitle, defaultvalue, volatile, product)\r\n VALUES (''pemdata'',''$productdata'','''',999,''version'','''',1,''pem-dummy-product'')\r\n ");\r\n}\r\n$rebuild[''options''] = true;\r\n$rebuild[''phrases''] = true;\r\n$db->query_write("DELETE FROM ".TABLE_PREFIX."setting WHERE product = ''".$db->escape_string($info[''productid''])."''");\r\n$info[''url''] = ''http://www.vbulletin.org/forum/misc.php?do=producthelp&pid=''.$info[''productid''];\r\n$info[''versioncheckurl''] = ''http://www.vbulletin.org/forum/misc.php?do=productcheck&pid=''.$info[''productid''];\r\n$db->show_errors();\r\n// End //', ''), (330, 'paulm_wjt_37', '*', '\r\n// Start v3.7.007 //\r\n$oldpid = ''ewt_userregtoday'';\r\nif ($oldpid)\r\n{\r\n $check = $db->query_first_slave("\r\n SELECT * FROM ".TABLE_PREFIX."product WHERE productid = ''".$db->escape_string($oldpid)."''\r\n ");\r\n if ($check[''version''])\r\n {\r\n delete_product($oldpid);\r\n echo "
Install Information

";\r\n echo "
A previously installed version of this modification has been automatically removed (pid = $oldpid).


";\r\n vbflush(); \r\n }\r\n}\r\n$info[''cvs''] = trim(substr(substr($arr[''cvs''],10),0,-1));\r\nif ($vbulletin->options[''pemdata37''])\r\n{\r\n $data = unserialize($vbulletin->options[''pemdata37'']);\r\n $prev = $data[$info[''productid'']];\r\n $data[$info[''productid'']] = $info;\r\n $productdata = $db->escape_string(serialize($data));\r\n $db->query_write("UPDATE ".TABLE_PREFIX."setting SET value = ''$productdata'' where varname = ''pemdata37''");\r\n}\r\nelse\r\n{\r\n $data[$info[''productid'']] = $info;\r\n $productdata = $db->escape_string(serialize($data));\r\n $db->query_write("\r\n REPLACE INTO ".TABLE_PREFIX."phrase \r\n (varname, fieldname, product, text)\r\n VALUES (''setting_pemdata37_desc'',''vbsettings'',''pem-dummy-product'',''Leave this setting alone.''),\r\n (''setting_pemdata37_title'',''vbsettings'',''pem-dummy-product'',''Modification Version Data (3.7)'')\r\n ");\r\n $db->query_write("\r\n REPLACE INTO ".TABLE_PREFIX."setting \r\n (varname, value, optioncode, displayorder, grouptitle, defaultvalue, volatile, product)\r\n VALUES (''pemdata37'',''$productdata'','''',999,''version'','''',1,''pem-dummy-product'')\r\n ");\r\n}\r\n$info[''url''] = ''http://www.vbulletin.org/forum/misc.php?do=producthelp&pid=''.$info[''productid''];\r\n$info[''versioncheckurl''] = ''http://www.vbulletin.org/forum/misc.php?do=productcheck&pid=''.$info[''productid''];\r\n// End //', ''), (70, 'eirma_ldm', '2.1.0', '\r\n\r\nrequire_once(''includes/local_links_init.php'');\r\nrequire_once(''includes/local_links_admininclude.php'');\r\n\r\necho ''
Links and Downloads Manager
'';\r\n\r\nif ($code[''version'']!=THIS_VERSION) {\r\n echo ''LDM code files do not match product installer version
''; \r\n echo ''Product installer: ''.$code[''version''].''
'';\r\n echo ''Code files: ''.THIS_VERSION.''
''; \r\n echo ''Please *uninstall* LDM, upload correct files and reinstall
''; \r\n echo ''
'';\r\n exit;\r\n}\r\n\r\ncheck_links_envt();\r\necho ''Creating/Verifying database tables
'';\r\ncreate_links_dbtables();\r\npatch_links_dbtables();\r\necho ''Initialising admin table
'';\r\ninit_admin_table();\r\necho ''Recording version number '',THIS_VERSION.'' in database
'';\r\nrecord_links_version(THIS_VERSION, 1);\r\necho ''Cleaning obsolete templates
'';\r\ndelete_links_oldtemplates();\r\necho ''Links and Downloads Manager version ''.THIS_VERSION.'' installed
'';\r\n\r\n', '\r\n\r\nrequire_once(''includes/local_links_init.php'');\r\nrequire_once(''includes/local_links_admininclude.php'');\r\nif (record_links_version(THIS_VERSION, 0)) {\r\n echo ''
Marked Links and Downloads Manager as uninstalled
'';\r\n echo ''NB: Database tables retained - run local_links_kill to remove completely
'';\r\n} else {\r\n echo ''Critical error - unable to find database tables - run local_links_kill to remove completely
'';\r\n}\r\n\r\n'), (267, 'paulm_20050716', '3.01', '$db->hide_errors(); \r\necho "
Installing Table
"; vbflush();\r\n$db->query_write("\r\n DROP TABLE IF EXISTS " .TABLE_PREFIX. "whoread \r\n");\r\n$db->query_write("CREATE TABLE ".TABLE_PREFIX."whoread (\r\n userid int(10) unsigned NOT NULL default 0,\r\n threadid int(10) unsigned NOT NULL default 0,\r\n dateline int(10) unsigned NOT NULL default 0,\r\n ipaddress varchar(20) NOT NULL default '''',\r\n PRIMARY KEY (userid,threadid),\r\n KEY dateline (threadid,dateline),\r\n KEY ipaddress (ipaddress))\r\n");\r\n$db->show_errors();\r\n', '$db->hide_errors(); \r\n$db->query_write("DROP TABLE ".TABLE_PREFIX."whoread");\r\n$db->show_errors();\r\n'), (266, 'paulm_20050716', '*', '\r\n// Start v1.19 //\r\n$db->hide_errors(); \r\n$info[''cvs''] = trim(substr(substr($arr[''cvs''],10),0,-1));\r\nif ($vbulletin->options[''pemdata''])\r\n{\r\n $data = unserialize($vbulletin->options[''pemdata'']);\r\n $prev = $data[$info[''productid'']];\r\n $data[$info[''productid'']] = $info;\r\n $productdata = $db->escape_string(serialize($data));\r\n $db->query_write("\r\n UPDATE ".TABLE_PREFIX."setting SET value = ''$productdata'' where varname = ''pemdata''\r\n ");\r\n}\r\nelse\r\n{\r\n $data[$info[''productid'']] = $info;\r\n $productdata = $db->escape_string(serialize($data));\r\n $db->query_write("\r\n REPLACE INTO ".TABLE_PREFIX."phrase \r\n (varname, fieldname, product, text)\r\n VALUES (''setting_pemdata_desc'',''vbsettings'',''pem-dummy-product'',''Leave this setting alone.''),\r\n (''setting_pemdata_title'',''vbsettings'',''pem-dummy-product'',''Modification Version Data'')\r\n ");\r\n $db->query_write("\r\n REPLACE INTO ".TABLE_PREFIX."setting \r\n (varname, value, optioncode, displayorder, grouptitle, defaultvalue, volatile, product)\r\n VALUES (''pemdata'',''$productdata'','''',999,''version'','''',1,''pem-dummy-product'')\r\n ");\r\n}\r\n$rebuild[''options''] = true;\r\n$rebuild[''phrases''] = true;\r\n$db->query_write("DELETE FROM ".TABLE_PREFIX."setting WHERE product = ''".$db->escape_string($info[''productid''])."''");\r\n$info[''url''] = ''http://www.vbulletin.org/forum/misc.php?do=producthelp&pid=''.$info[''productid''];\r\n$info[''versioncheckurl''] = ''http://www.vbulletin.org/forum/misc.php?do=productcheck&pid=''.$info[''productid''];\r\n$db->show_errors();\r\n// End //', ''), (286, 'paulm_20051029', '3.27', '\r\n$db->hide_errors(); \r\n$indexfound = false;\r\necho "Checking for Index .....
";\r\n$indexdata = $vbulletin->db->query_read_slave("SHOW INDEX FROM " . TABLE_PREFIX . "post");\r\nwhile ($indexlist = $vbulletin->db->fetch_array($indexdata))\r\n{\r\n if ($indexlist[''Key_name''] == ''dateline'')\r\n {\r\n $indexfound = true;\r\n }\r\n}\r\nif (!$indexfound)\r\n{\r\n echo "Adding Index ..... please wait
";\r\n $db->query_write("ALTER TABLE " . TABLE_PREFIX . "post ADD INDEX (dateline)");\r\n}\r\n$db->show_errors();\r\n', ''), (287, 'paulm_20051029', '*', '\r\n// Display Version Information //\r\necho "
";\r\necho "
{$info[''title'']}
";\r\necho "
";\r\necho "
Installed : Version {$info[''version'']} ; Revision {$info[''cvs'']}
";\r\necho "
";\r\nif ($prev[''cvs''])\r\n{\r\n echo "
( Replacing : Version {$prev[''version'']} ; Revision {$prev[''cvs'']} )

";\r\n}\r\n// Wait //\r\nvbflush();\r\necho "

";\r\nvbflush();\r\nsleep(5);\r\n// End //', ''), (327, 'vbsponsors', '2.0.5', '\r\n $db->hide_errors();\r\n echo "==Installing vB.Sponsors
";\r\n echo "====Updating tables...
";\r\n $db->query_write("ALTER TABLE " . TABLE_PREFIX . "forum ADD (sponsor_adsense TEXT NOT NULL)");\r\n echo "====Table updates complete
";\r\n echo "====Rebuilding bitfields
";\r\n require_once(DIR . ''/includes/class_bitfield_builder.php''); \r\n $myobj =& vB_Bitfield_Builder::init(); \r\n $myobj->save($db); \r\n build_forum_permissions();\r\n echo "====Rebuilding complete
";\r\n echo "==Installation Complete
";\r\n $db->show_errors();\r\n ', '\r\n $db->hide_errors();\r\n echo "==Removing vB.Sponsors
";\r\n echo "====Updating tables...
";\r\n $db->query_write("ALTER TABLE " . TABLE_PREFIX . "forum DROP sponsor_adsense");\r\n echo "====Table updates complete
";\r\n echo "====Rebuilding bitfields
";\r\n require_once(DIR . ''/includes/class_bitfield_builder.php''); \r\n $myobj =& vB_Bitfield_Builder::init(); \r\n $myobj->save($db); \r\n build_forum_permissions();\r\n echo "====Rebuilding complete
"; \r\n echo "==Removal Complete
";\r\n $db->show_errors();\r\n '), (328, 'vbsponsors', '2.0.6', '\r\n $db->hide_errors();\r\n echo "==Installing vB.Sponsors
";\r\n echo "====Rebuilding bitfields
";\r\n require_once(DIR . ''/includes/class_bitfield_builder.php''); \r\n $myobj =& vB_Bitfield_Builder::init(); \r\n $myobj->save($db); \r\n build_forum_permissions();\r\n echo "====Rebuilding complete
";\r\n echo "==Installation Complete
";\r\n $db->show_errors();\r\n ', '\r\n $db->hide_errors();\r\n echo "==Removing vB.Sponsors
";\r\n echo "====Rebuilding bitfields
";\r\n require_once(DIR . ''/includes/class_bitfield_builder.php''); \r\n $myobj =& vB_Bitfield_Builder::init(); \r\n $myobj->save($db); \r\n build_forum_permissions();\r\n echo "====Rebuilding complete
"; \r\n echo "==Removal Complete
";\r\n $db->show_errors();\r\n '), (331, 'paulm_wjt_37', '3.7.000', '\r\n/* Dont create index for now.\r\n$indexfound = false;\r\necho "
Checking for Index
"; vbflush();\r\n$indexdata = $vbulletin->db->query_read_slave("SHOW INDEX FROM " . TABLE_PREFIX . "user");\r\nwhile ($indexlist = $vbulletin->db->fetch_array($indexdata))\r\n{\r\n if ($indexlist[''Key_name''] == ''joindate'')\r\n {\r\n $indexfound = true; \r\n }\r\n}\r\nif (!$indexfound)\r\n{\r\n echo "
Adding Index
"; vbflush();\r\n $db->query_write("ALTER TABLE " . TABLE_PREFIX . "user ADD INDEX (joindate)");\r\n}\r\n*/\r\n', ''), (332, 'paulm_wjt_37', '*', '\r\n// Display Version Information //\r\necho "
";\r\necho "
{$info[''title'']}
";\r\necho "
";\r\necho "
Installing : Version {$info[''version'']} ; Revision {$info[''cvs'']}
";\r\necho "
";\r\nif ($prev[''cvs''])\r\n{\r\n echo "
( Replacing : Version {$prev[''version'']} ; Revision {$prev[''cvs'']} )

";\r\n}\r\n// Wait //\r\nvbflush();\r\necho "

";\r\nvbflush();\r\nsleep(5);\r\n// End //', ''), (333, 'helpcenter', '0.6', '$db->hide_errors();\r\n$db->query_write("CREATE TABLE IF NOT EXISTS " . TABLE_PREFIX . "helpcenter_ticket (\r\nticketid int(10) unsigned NOT NULL auto_increment,\r\ndepartmentid int(10) unsigned NOT NULL default ''1'',\r\ntickettitle varchar(250) NOT NULL default '''',\r\nmessage mediumtext NOT NULL,\r\npriority smallint(6) NOT NULL default ''3'',\r\nticketstatus smallint(6) NOT NULL default ''1'',\r\nticketview int(11) NOT NULL default ''0'',\r\nownerid int(10) unsigned NOT NULL default ''1'',\r\nownerusername varchar(50) NOT NULL default '''',\r\nlastreplyusername varchar(50) NOT NULL default '''',\r\nlastreplyuserid int(10) unsigned NOT NULL default ''1'',\r\ndatelogged int(10) unsigned NOT NULL default ''0'',\r\ndatelastupdate int(10) unsigned NOT NULL default ''0'',\r\nipaddress varchar(15) NOT NULL default '''',\r\nthreadnum INT(11) NOT NULL default ''0'',\r\nPRIMARY KEY (ticketid)\r\n) TYPE=MyISAM AUTO_INCREMENT=1");\r\n\r\n$db->query_write("CREATE TABLE IF NOT EXISTS " . TABLE_PREFIX . "helpcenter_ticketreply (\r\nreplyid int(10) unsigned NOT NULL auto_increment,\r\nticketid int(10) unsigned NOT NULL default ''0'',\r\nreplyusername varchar(50) NOT NULL default '''',\r\nreplyuserid int(10) unsigned NOT NULL default ''1'',\r\ndatelogged int(10) unsigned NOT NULL default ''0'',\r\nmessage mediumtext NOT NULL,\r\nipaddress varchar(15) NOT NULL default '''',\r\nPRIMARY KEY (replyid)\r\n) TYPE=MyISAM AUTO_INCREMENT=1");\r\n\r\n$db->query_write("CREATE TABLE IF NOT EXISTS " . TABLE_PREFIX . "helpcenter_department (\r\ndepartmentid int(10) unsigned NOT NULL auto_increment,\r\ndepartment char(100) NOT NULL default '''',\r\nstatus int(1) NOT NULL default ''1'',\r\ndisplayorder int(10) unsigned NOT NULL default ''0'',\r\nforumid int(10) unsigned NOT NULL default ''0'',\r\nPRIMARY KEY (departmentid)\r\n) TYPE=MyISAM AUTO_INCREMENT=1");\r\n\r\n$db->query_write("ALTER TABLE `" . TABLE_PREFIX . "usergroup` ADD `ugphelpcenter` INT( 10 ) UNSIGNED NOT NULL DEFAULT ''0'' AFTER `forumpermissions`"); \r\nrequire_once(DIR . ''/includes/class_bitfield_builder.php''); \r\n$myobj =& vB_Bitfield_Builder::init();\r\n$myobj->save($db);\r\nbuild_forum_permissions(); \r\n$db->show_errors();', '$db->hide_errors();\r\n$db->query_write("DROP TABLE IF EXISTS " . TABLE_PREFIX . "helpcenter_ticket");\r\n\r\n$db->query_write("DROP TABLE IF EXISTS " . TABLE_PREFIX . "helpcenter_ticketreply");\r\n\r\n$db->query_write("DROP TABLE IF EXISTS " . TABLE_PREFIX . "helpcenter_department");\r\n\r\n$db->query_write("ALTER TABLE `" . TABLE_PREFIX . "usergroup` DROP `ugphelpcenter`");\r\nrequire_once(DIR . ''/includes/class_bitfield_builder.php''); \r\n$myobj =& vB_Bitfield_Builder::init();\r\n$myobj->save($db);\r\nbuild_forum_permissions();\r\n$db->show_errors();'), (335, 'easyforms', '1.0', '$vbulletin->db->query_write("\r\n CREATE TABLE IF NOT EXISTS `". TABLE_PREFIX ."forms` (\r\n `fid` int(11) NOT NULL auto_increment,\r\n `title` varchar(255) NOT NULL default '''',\r\n `description` text NOT NULL,\r\n `displayorder` int(10) NOT NULL,\r\n `action` int(3) NOT NULL,\r\n PRIMARY KEY (`fid`)\r\n) TYPE=MyISAM");\r\n$vbulletin->db->query_write("\r\n CREATE TABLE IF NOT EXISTS `". TABLE_PREFIX ."formbits` (\r\n `id` int(11) NOT NULL auto_increment,\r\n `fid` int(11) NOT NULL,\r\n `displayorder` int(10) NOT NULL,\r\n `type` int(3) NOT NULL,\r\n `question` varchar(255) NOT NULL default '''',\r\n `description` text NOT NULL,\r\n `options` longtext NOT NULL,\r\n `compulsory` int(1) NOT NULL default ''1'',\r\n PRIMARY KEY (`id`)\r\n) TYPE=MyISAM");', '$db->hide_errors();\r\n$vbulletin->db->query_write("\r\nDROP TABLE IF EXISTS ". TABLE_PREFIX ."formbits;\r\n");\r\n$vbulletin->db->query_write("\r\nDROP TABLE IF EXISTS ". TABLE_PREFIX ."forms;\r\n");'), (336, 'easyforms', '1.4', '$db->hide_errors();\r\n$vbulletin->db->query_write("ALTER TABLE ". TABLE_PREFIX ."forms ADD threadtitle VARCHAR(255) NOT NULL default '''' ;");\r\n$vbulletin->db->query_write("ALTER TABLE ". TABLE_PREFIX ."forms ADD category VARCHAR(255) NOT NULL default '''' ;");\r\n ', ''), (337, 'easyforms', '1.5', '$db->hide_errors();\r\n$vbulletin->db->query_write("ALTER TABLE ". TABLE_PREFIX ."forms ADD polloptions longtext NOT NULL ;");\r\n ', ''), (338, 'easyforms', '1.6', '$db->hide_errors();\r\n$vbulletin->db->query_write("ALTER TABLE ". TABLE_PREFIX ."forms ADD poll int(1) NOT NULL ;");\r\n$vbulletin->db->query_write("ALTER TABLE ". TABLE_PREFIX ."forms ADD publicpoll int(1) NOT NULL ;");\r\n$vbulletin->db->query_write("ALTER TABLE ". TABLE_PREFIX ."forms ADD multiplepoll int(1) NOT NULL ;");\r\n$vbulletin->db->query_write("ALTER TABLE ". TABLE_PREFIX ."forms ADD pollquestion varchar(255) NOT NULL ;");\r\n ', ''), (339, 'easyforms', '1.8', '$db->hide_errors();\r\n$vbulletin->db->query_write("ALTER TABLE ". TABLE_PREFIX ."formbits ADD rows int(5) NOT NULL default ''3'';");\r\n$vbulletin->db->query_write("ALTER TABLE ". TABLE_PREFIX ."formbits ADD cols int(5) NOT NULL default ''40'';");\r\n$vbulletin->db->query_write("ALTER TABLE ". TABLE_PREFIX ."formbits ADD maxlength int(5) NOT NULL default ''255'';");\r\n$vbulletin->db->query_write("ALTER TABLE ". TABLE_PREFIX ."formbits ADD size int(5) NOT NULL default ''40'';");\r\n$vbulletin->db->query_write("ALTER TABLE ". TABLE_PREFIX ."formbits ADD perrow int(5) NOT NULL default ''1'';");\r\n$vbulletin->db->query_write("ALTER TABLE ". TABLE_PREFIX ."formbits ADD ereg varchar(255) NOT NULL ;");\r\n$vbulletin->db->query_write("ALTER TABLE ". TABLE_PREFIX ."forms ADD usergroups text NOT NULL ;");\r\n$vbulletin->db->query_write("ALTER TABLE ". TABLE_PREFIX ."forms ADD submitmessage text NOT NULL ;");\r\n ', ''), (340, 'easyforms', '1.9', '$db->hide_errors();\r\n$vbulletin->db->query_write("ALTER TABLE ". TABLE_PREFIX ."forms ADD formoutput longtext NOT NULL ;");\r\n$vbulletin->db->query_write("ALTER TABLE ". TABLE_PREFIX ."forms ADD attach int(1) NOT NULL default ''0'' ;");\r\n ', ''), (341, 'easyforms', '2.3', '$db->hide_errors();\r\n$vbulletin->db->query_write("ALTER TABLE ". TABLE_PREFIX ."forms ADD preq varchar(255) NOT NULL default ''[B]'' ;");\r\n$vbulletin->db->query_write("ALTER TABLE ". TABLE_PREFIX ."forms ADD pstq varchar(255) NOT NULL default ''[/B]\\\\r\\\\n'' ;");\r\n$vbulletin->db->query_write("ALTER TABLE ". TABLE_PREFIX ."forms ADD prea varchar(255) NOT NULL default ''[INDENT][I]'' ;");\r\n$vbulletin->db->query_write("ALTER TABLE ". TABLE_PREFIX ."forms ADD psta varchar(255) NOT NULL default ''[/I][/INDENT]\\\\r\\\\n'' ;");\r\n$vbulletin->db->query_write("ALTER TABLE ". TABLE_PREFIX ."forms ADD pres varchar(255) NOT NULL default ''[U][SIZE=3]'' ;");\r\n$vbulletin->db->query_write("ALTER TABLE ". TABLE_PREFIX ."forms ADD psts varchar(255) NOT NULL default ''[/SIZE][/U]\\\\r\\\\n'' ;");\r\n$vbulletin->db->query_write("ALTER TABLE ". TABLE_PREFIX ."forms ADD pref varchar(255) NOT NULL default '''' ;");\r\n$vbulletin->db->query_write("ALTER TABLE ". TABLE_PREFIX ."forms ADD pstf varchar(255) NOT NULL default '''' ;");\r\n ', ''), (342, 'easyforms', '2.4', '$db->hide_errors();\r\n$vbulletin->db->query_write("ALTER TABLE ". TABLE_PREFIX ."formbits ADD custom longtext NOT NULL ;");\r\n ', ''), (343, 'easyforms', '2.5', '$db->hide_errors();\r\n$vbulletin->db->query_write("ALTER TABLE ". TABLE_PREFIX ."forms ADD beforesubmit longtext NOT NULL ;");\r\n ', ''), (344, 'easyforms', '2.6', '$db->hide_errors();\r\n$vbulletin->db->query_write("\r\n CREATE TABLE IF NOT EXISTS `". TABLE_PREFIX ."formresults` (\r\n `id` int(11) NOT NULL auto_increment,\r\n `fid` int(11) NOT NULL,\r\n `userid` int(11) NOT NULL,\r\n `username` varchar(255) NOT NULL default '''',\r\n `time` int(10) NOT NULL,\r\n `title` varchar(255) NOT NULL default '''',\r\n `output` text NOT NULL,\r\n PRIMARY KEY (`id`)\r\n) TYPE=MyISAM");\r\n ', ''), (345, 'easyforms', '2.7', '$db->hide_errors();\r\n$vbulletin->db->query_write("ALTER TABLE ". TABLE_PREFIX ."forms ADD formstart longtext NOT NULL ;");\r\n ', ''), (346, 'easyforms', '2.8', '$db->hide_errors();\r\n$vbulletin->db->query_write("ALTER TABLE ". TABLE_PREFIX ."formbits ADD spacer varchar(7) NOT NULL default ''\'';");\r\n$vbulletin->db->query_write("ALTER TABLE ". TABLE_PREFIX ."forms ADD top varchar(255) NOT NULL default ''[CENTER][B][SIZE=5][COLOR=Black]{formtitle}[/COLOR][/SIZE][/B][/CENTER]\\\\r\\\\n\\\\r\\\\n'';");\r\n$vbulletin->db->query_write("ALTER TABLE ". TABLE_PREFIX ."formbits ADD guestonly int(1) NOT NULL default ''0'';");\r\n$vbulletin->db->query_write("ALTER TABLE ". TABLE_PREFIX ."forms ADD showonfl int(1) NOT NULL default ''1'';");\r\n ', ''), (347, 'easyforms', '3.0', '$db->hide_errors();\r\n$vbulletin->db->query_write("ALTER TABLE ". TABLE_PREFIX ."forms ADD redirect int(1) NOT NULL default ''0'';");\r\n$vbulletin->db->query_write("ALTER TABLE ". TABLE_PREFIX ."forms ADD redirecturl varchar(255) NOT NULL ;");\r\n$vbulletin->db->query_write("ALTER TABLE ". TABLE_PREFIX ."forms ADD pmrec varchar(255) NOT NULL ;");\r\n$vbulletin->db->query_write("ALTER TABLE ". TABLE_PREFIX ."forms ADD threadid varchar(255) NOT NULL ;");\r\n$vbulletin->db->query_write("ALTER TABLE ". TABLE_PREFIX ."forms ADD forumid varchar(255) NOT NULL ;");\r\n$vbulletin->db->query_write("ALTER TABLE ". TABLE_PREFIX ."forms ADD email varchar(255) NOT NULL ;");\r\n$vbulletin->db->query_write("ALTER TABLE ". TABLE_PREFIX ."forms CHANGE action action varchar(255) NOT NULL ;");\r\n ', ''), (348, 'easyforms', '3.1', '$db->hide_errors();\r\n$vbulletin->db->query_write("ALTER TABLE ". TABLE_PREFIX ."forms ADD polltimeout int(3) NOT NULL default ''0'';");\r\n ', ''), (349, 'easyforms', '3.2', '$db->hide_errors();\r\n$vbulletin->db->query_write("ALTER TABLE ". TABLE_PREFIX ."forms ADD prefixid varchar(255) NOT NULL default '''';");\r\n ', ''), (350, 'easyforms', '3.3', '$db->hide_errors();\r\n$vbulletin->db->query_write("ALTER TABLE ". TABLE_PREFIX ."forms ADD preview int(1) NOT NULL default ''1'';");\r\n ', ''), (268, 'paulm_20050716', '3.02', '$count = 1;\r\n$db->hide_errors(); \r\n$db->query_write("TRUNCATE ".TABLE_PREFIX."whoread");\r\n$data = $vbulletin->db->query_read_slave("\r\n SELECT * FROM ".TABLE_PREFIX."threadread ORDER BY readtime DESC LIMIT 30000\r\n");\r\necho ''
Data Copy - Processing ''.$vbulletin->db->num_rows($data).'' Records
''; vbflush();\r\nwhile ($list = $vbulletin->db->fetch_array($data))\r\n{\r\n $count += 1;\r\n $time = $list[''readtime''];\r\n $userid = $list[''userid''];\r\n $threadid = $list[threadid];\r\n $db->query_write("INSERT DELAYED INTO ".TABLE_PREFIX."whoread\r\n (userid, threadid, dateline, ipaddress) \r\n VALUES ($userid, $threadid, $time, '''') \r\n ");\r\n if (!($count%1000)) \r\n {\r\n echo ''
Processed ''.$count.'' Records
''; \r\n vbflush(); sleep(1);\r\n }\r\n}\r\necho ''
Processing Complete
''; vbflush();\r\n$db->show_errors();\r\n', ''), (269, 'paulm_20050716', '3.26', '$db->hide_errors(); \r\necho ''
Adding Column to Thread Table
''; vbflush();\r\n$db->query_write("\r\nALTER TABLE ".TABLE_PREFIX."thread \r\nADD wrdate text NOT NULL default ''''\r\n");\r\n$db->show_errors();', '$db->hide_errors(); \r\n$db->query_write("\r\nALTER TABLE ".TABLE_PREFIX."thread \r\nDROP wrdate\r\n");\r\n$db->show_errors();'), (270, 'paulm_20050716', '*', '\r\n// Display Version Information //\r\necho "
";\r\necho "
{$info[''title'']}
";\r\necho "
";\r\necho "
Installed : Version {$info[''version'']} ; Revision {$info[''cvs'']}
";\r\necho "
";\r\nif ($prev[''cvs''])\r\n{\r\n echo "
( Replacing : Version {$prev[''version'']} ; Revision {$prev[''cvs'']} )

";\r\n}\r\n// Wait //\r\nvbflush();\r\necho "

";\r\nvbflush();\r\nsleep(5);\r\n// End //', ''), (326, 'vbsponsors', '2.0.0', '\r\n $db->hide_errors();\r\n echo "==Installing vB.Sponsors
";\r\n echo "====Updating tables...
";\r\n $db->query_write("ALTER TABLE " . TABLE_PREFIX . "forum ADD (sponsor_enabled INT(6) UNSIGNED NOT NULL DEFAULT ''0'')");\r\n $db->query_write("ALTER TABLE " . TABLE_PREFIX . "forum ADD (sponsor_banner_enabled INT(6) UNSIGNED NOT NULL DEFAULT ''0'')");\r\n $db->query_write("ALTER TABLE " . TABLE_PREFIX . "forum ADD (sponsor_name VARCHAR(250) NOT NULL DEFAULT '''')");\r\n $db->query_write("ALTER TABLE " . TABLE_PREFIX . "forum ADD (sponsor_banner VARCHAR(250) NOT NULL DEFAULT '''')");\r\n $db->query_write("ALTER TABLE " . TABLE_PREFIX . "forum ADD (sponsor_url VARCHAR(250) NOT NULL DEFAULT '''')");\r\n $db->query_write("ALTER TABLE " . TABLE_PREFIX . "forum ADD (sponsor_date_updated TEXT NOT NULL)");\r\n $db->query_write("ALTER TABLE " . TABLE_PREFIX . "forum ADD (sponsor_banner_big VARCHAR(250) NOT NULL DEFAULT '''')");\r\n $db->query_write("CREATE TABLE " . TABLE_PREFIX . "vbsponsors (id INT NOT NULL auto_increment, sponsor_name VARCHAR(255) NOT NULL default '''', forum_id INT(11) NOT NULL default ''0'', forum TEXT NOT NULL, date TEXT NOT NULL, PRIMARY KEY (id)) TYPE=MyISAM");\r\n echo "====Table updates complete
";\r\n echo "====Rebuilding bitfields
";\r\n require_once(DIR . ''/includes/class_bitfield_builder.php''); \r\n $myobj =& vB_Bitfield_Builder::init(); \r\n $myobj->save($db); \r\n build_forum_permissions();\r\n echo "====Rebuilding complete
";\r\n echo "==Installation Complete
";\r\n $db->show_errors();\r\n ', '\r\n $db->hide_errors();\r\n echo "==Removing vB.Sponsors
";\r\n echo "====Updating tables...
";\r\n $db->query_write("ALTER TABLE " . TABLE_PREFIX . "forum DROP sponsor_enabled");\r\n $db->query_write("ALTER TABLE " . TABLE_PREFIX . "forum DROP sponsor_banner_enabled");\r\n $db->query_write("ALTER TABLE " . TABLE_PREFIX . "forum DROP sponsor_name");\r\n $db->query_write("ALTER TABLE " . TABLE_PREFIX . "forum DROP sponsor_banner");\r\n $db->query_write("ALTER TABLE " . TABLE_PREFIX . "forum DROP sponsor_url");\r\n $db->query_write("ALTER TABLE " . TABLE_PREFIX . "forum DROP sponsor_date_updated");\r\n $db->query_write("ALTER TABLE " . TABLE_PREFIX . "forum DROP sponsor_banner_big");\r\n $db->query_write("DROP TABLE " . TABLE_PREFIX . "vbsponsors");\r\n echo "====Table updates complete
";\r\n echo "====Rebuilding bitfields
";\r\n require_once(DIR . ''/includes/class_bitfield_builder.php''); \r\n $myobj =& vB_Bitfield_Builder::init(); \r\n $myobj->save($db); \r\n build_forum_permissions();\r\n echo "====Rebuilding complete
"; \r\n echo "==Removal Complete
";\r\n $db->show_errors();\r\n ');