Location: PHPKode > scripts > Ja2BU > install/install2.php
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
  <meta http-equiv="content-type" content="text/html; charset=us-ascii" />
  <link href="css/styles.css" rel="stylesheet" type="text/css" />
</head>
<body>
<center>
  <table width="70%" align="center" border="0">
    <tr>
      <td align="center" width="120" height="100px"></td>
    </tr>
  </table>
<div id="incral">
    <table width="80%" align="center" border="0">
      <tr>
        <td align="center">
          <h3><img src="css/icon.png" />&nbsp;&nbsp;&nbsp;Install - Step 3</h3>MySQL Database
          Server<br />
         
        </td>
      </tr>
    </table>
	<?php
require_once('../admin/config.php');
include ('../classes/adodb/adodb.inc.php');
$dbdriver = "mysql";
$conn = &ADONewConnection($dbdriver);
$conn->Connect($server,$user,$password,$database);

$sql = "CREATE TABLE IF NOT EXISTS `abcoption` (
  `optionid` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `nameopt` varchar(255) NOT NULL DEFAULT '',
  `valueopt` text,
  `module` tinyint(1) NOT NULL,
  `active` tinyint(1) NOT NULL,
  PRIMARY KEY (`optionid`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=1";

$sql2 = "INSERT INTO `abcoption` (`optionid`, `nameopt`, `valueopt`, `module`, `active`) VALUES
(1, 'sitetitle', 'phpForm.net', '0', '0'),
(2, 'metadesc', 'Discussion Board', '0', '0'),
(3, 'keywords', 'discussion, technology, latest news, tech news', '0', '0'),
(4, 'sitepath', 'http://localhost/111', '0', '0'),
(5, 'language', 'english', '0', '0'),
(6, 'caching', '0', '0', '0'),
(7, 'themes', 'default', '0', '0'),
(8, 'sitemail', 'hide@address.com', '0', '0'),
(9, 'sitedisabled', '2', '0', '0'),
(10, 'rewritemod', '2', '0', '0'),
(11, 'frontpage', '1', '0', '0'),
(12, 'frontext', 'ltr', '0', '0'),
(13, 'customheader', '0', '0', '0'),
(14, 'signuprole', '3', '0', '0'),
(15, 'signupapp', '2', '0', '0'),
(16, 'newson', '1', '0', '0'),
(17, 'newstext', 'Welcome to the Discussion Group.', '0', '0'),
(18, 'siteabout', 'About', '0', '0'),
(19, 'siteprivacy', 'Privacy Text', '0', '0'),
(20, 'siteterms', 'Terms Text', '0', '0'),
(21, 'messaging', '1', '0', '0'),
(22, 'maxposting', '25800', '0', '0'),
(23, 'editortrue', '2', '0', '0'),
(24, 'smilestrue', '1', '0', '0'),
(25, 'smilespath', 'themes/images/smilies', '0', '0'),
(26, 'maxtopic', '15', '0', '0'),
(27, 'hottopic', '1', '0', '0'),
(28, 'adsoffon', '1', '0', '0'),
(29, 'senseup', '-', '0', '0'),
(30, 'sensedown', '-', '0', '0'),
(31, 'stopspam', '1', '0', '0'),
(32, 'incitem', '0', '0', '0'),
(33, 'keypublic', '0', '0', '0'),
(34, 'keycaptcha', '0', '0', '0'),
(35, 'slider', '1', '0', '0'),
(36, 'efslide', 'scroller', '0', '0'),
(37, 'payoffon', '0', '0', '0'),
(38, 'payvalue', '10.00', '0', '0'),
(39, 'payday',  '180',  '0',  '0'),
(40, 'bookonoff',  '1',  '0',  '0'),
(41, 'bookmarklet', 'Save on', '0', '0'),
(42, 'headerin', '0', 0, 0),
(43, 'footerin', '0', 0, 0),
(44, 'aconfig', '0', 0, 0),
(45, 'bconfig', '0', 0, 0),
(46, 'dconfig', '0', 0, 0),
(47, 'notificate', '1', 0, 0),
(48, 'sfspam', '1', 0, 0),
(49, 'tagson', '1', 0, 0);";

$sql3 = "CREATE TABLE IF NOT EXISTS `article` (
  `blogid` int(11) NOT NULL AUTO_INCREMENT,
  `main` tinyint(1) NOT NULL DEFAULT '0',
  `univer` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `idblog` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `editor` tinyint(4) NOT NULL DEFAULT '2',
  `buserid` text COLLATE utf8_unicode_ci,
  `buser` text COLLATE utf8_unicode_ci,
  `btexty` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `bhelper` text COLLATE utf8_unicode_ci,
  `bimgs` text COLLATE utf8_unicode_ci,
  `bdate` datetime NOT NULL,
  `bamess` text COLLATE utf8_unicode_ci,
  `tags` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `commno` int(11) NOT NULL DEFAULT '0',
  `views` int(11) NOT NULL DEFAULT '0',
  `favorites` int(10) unsigned NOT NULL,
  `total_rating` int(10) NOT NULL,
  `total_ratings` int(10) NOT NULL,
  PRIMARY KEY (`blogid`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1";


$sql4 = "CREATE TABLE IF NOT EXISTS `catags` (
  `hashid` int(11) NOT NULL AUTO_INCREMENT,
  `hashmain` tinyint(1) NOT NULL,
  `hashtags` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `nofhash` int(11) NOT NULL,
  `wikihash` text COLLATE utf8_unicode_ci,
  `imagehash` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `editedhash` text COLLATE utf8_unicode_ci,
  PRIMARY KEY (`hashid`),
  UNIQUE KEY `hashtags` (`hashtags`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1";

$sql5 = "CREATE TABLE IF NOT EXISTS `cpadmin` (
  `ausid` int(11) NOT NULL AUTO_INCREMENT,
  `ausername` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `apassword` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `aemail` varchar(55) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  PRIMARY KEY (`ausid`),
  UNIQUE KEY `Username` (`ausername`),
  UNIQUE KEY `Email` (`aemail`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1";


$sql6 = "CREATE TABLE IF NOT EXISTS `messages` (
  `messid` int(11) NOT NULL AUTO_INCREMENT,
  `fromid` int(11) NOT NULL DEFAULT '0',
  `fromname` varchar(11) COLLATE utf8_unicode_ci NOT NULL DEFAULT '0',
  `fromimg` text COLLATE utf8_unicode_ci,
  `mdate` datetime NOT NULL,
  `toid` int(11) NOT NULL DEFAULT '0',
  `toname` varchar(11) COLLATE utf8_unicode_ci NOT NULL DEFAULT '0',
  `toimage` text COLLATE utf8_unicode_ci,
  `raeder` tinyint(1) NOT NULL DEFAULT '1',
  `messege` text COLLATE utf8_unicode_ci,
  `flager` tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`messid`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1";

$sql7 = "CREATE TABLE IF NOT EXISTS `modules` (
  `modid` int(2) NOT NULL AUTO_INCREMENT,
  `idmod` int(11) NOT NULL,
  `modname` text COLLATE utf8_unicode_ci,
  `modimag` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `modap` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `mactive` tinyint(1) NOT NULL DEFAULT '0',
  `mabstrt` text COLLATE utf8_unicode_ci,
  PRIMARY KEY (`modid`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1";




$sql8 = "CREATE TABLE IF NOT EXISTS `onewse` (
  `oids` int(11) NOT NULL AUTO_INCREMENT,
  `omain` tinyint(1) NOT NULL,
  `oniver` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `omages` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '0',
  `otexty` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `ohelper` text COLLATE utf8_unicode_ci,
  `oamess` text COLLATE utf8_unicode_ci,
  `odate` datetime NOT NULL,
  PRIMARY KEY (`oids`),
  FULLTEXT KEY `otexty` (`otexty`,`oamess`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1";

$sql9 = "CREATE TABLE IF NOT EXISTS `reviews` (
  `revid` int(5) NOT NULL AUTO_INCREMENT,
  `comrev` varchar(15) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `idrev` varchar(15) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `cmain` tinyint(1) NOT NULL,
  `comenter` text COLLATE utf8_unicode_ci,
  `comimage` text COLLATE utf8_unicode_ci,
  `chomes` text COLLATE utf8_unicode_ci,
  `cdate` datetime NOT NULL,
  `chelper` text COLLATE utf8_unicode_ci,
  `ctexte` text COLLATE utf8_unicode_ci,
  `revrating` int(10) NOT NULL,
  `revratings` int(10) NOT NULL,
  PRIMARY KEY (`revid`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1";

$sql10 = "CREATE TABLE IF NOT EXISTS `users` (
  `usid` int(11) NOT NULL AUTO_INCREMENT,
  `privilege` tinyint(1) NOT NULL DEFAULT '2',
  `fullname` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `username` varchar(100) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `password` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `tempass` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `salt` char(30) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `email` char(100) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `homep` text COLLATE utf8_unicode_ci,
  `biosi` text COLLATE utf8_unicode_ci,
  `ipos` varchar(50) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `thumbs` varchar(50) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `date` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `active` tinyint(1) NOT NULL DEFAULT '0',
  `keysi` varchar(32) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `adsnumero` int(10) NOT NULL DEFAULT '0',
  `picnumero` int(10) NOT NULL DEFAULT '0',
  `subscriber` tinyint(1) NOT NULL DEFAULT '0',
  `havealbum` tinyint(1) NOT NULL DEFAULT '0',
  `myalbum` text COLLATE utf8_unicode_ci,
  `lastime` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `google` char(100) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `skype` char(35) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `msn` char(100) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `yahoo` char(35) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `birthday` varchar(80) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `gender` varchar(80) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `location` varchar(80) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  PRIMARY KEY (`usid`),
  UNIQUE KEY `Username` (`username`),
  UNIQUE KEY `Email` (`email`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1";



$result = $conn->Execute($sql);

if ($result == false) {
	print 'error'  . $conn->ErrorMsg() . '<br>';
}
else {
	echo '';
}
$result2 = $conn->Execute($sql2);

if ($result2 == false) {
	print 'error'  . $conn->ErrorMsg() . '<br>';
}
else {
	echo '';
}
$result3 = $conn->Execute($sql3);

if ($result3 == false) {
	print 'error'  . $conn->ErrorMsg() . '<br>';
}
else {
	echo '';
}

$result4 = $conn->Execute($sql4);

if ($result4 == false) {
	print 'error'  . $conn->ErrorMsg() . '<br>';
}
else {
	echo '';
}
$result5 = $conn->Execute($sql5);

if ($result5 == false) {
	print 'error'  . $conn->ErrorMsg() . '<br>';
}
else {
	echo '';
}

$result6 = $conn->Execute($sql6);

if ($result6 == false) {
	print 'error'  . $conn->ErrorMsg() . '<br>';
}
else {
	echo '';
}

$result7 = $conn->Execute($sql7);

if ($result7 == false) {
	print 'error'  . $conn->ErrorMsg() . '<br>';
}
else {
	echo '';
}
$result18 = $conn->Execute($sql8);

if ($result18 == false) {
	print 'error'  . $conn->ErrorMsg() . '<br>';
}
else {
	echo '';
}
$result19 = $conn->Execute($sql9);

if ($result19 == false) {
	print 'error'  . $conn->ErrorMsg() . '<br>';
}
else {
	echo '';
}
$result110 = $conn->Execute($sql10);

if ($result110 == false) {
	print 'error'  . $conn->ErrorMsg() . '<br>';
}
else {
	echo '';
}

?>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Database tables successfully created. <a href="install3.php"><b>Step 4</b></a>
</div>

  <table width="100%" height="422px"  align="center" border="0">
    <tr>
      <td align="center" valign="bottom"></td>
    </tr>
  </table>
</body>
</html>
Return current item: Ja2BU