<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" /> 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 '';
}
?>
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>