Website Installation
";
if($submit AND $clanname1 != "") {
echo "
Attempting to create database tables...
";
mysql_connect("$dbhost1","$dbuser1","$dbpass1");
mysql_select_db("$dbname1");
// CREATE challenges table
$query = "
CREATE TABLE `".$dbprefix1."challenges` (
`id` smallint(255) NOT NULL auto_increment,
`challenger` varchar(255) NOT NULL default '',
`challenged` varchar(255) NOT NULL default '',
`challengedate` varchar(255) NOT NULL default '',
`details` text NOT NULL,
`outcome` text NOT NULL,
PRIMARY KEY (`id`)
) AUTO_INCREMENT=1 ;
";
$result = mysql_query($query)
or die(mysql_error());
// CREATE comments table
$query = "
CREATE TABLE `".$dbprefix1."comments` (
`id` smallint(255) NOT NULL auto_increment,
`poster` varchar(255) NOT NULL default '',
`message` text NOT NULL,
`newsid` smallint(255) NOT NULL default '0',
`dateposted` varchar(255) NOT NULL default '',
PRIMARY KEY (`id`)
) AUTO_INCREMENT=1 ;
";
$result = mysql_query($query)
or die(mysql_error());
// CREATE console table
$query = "
CREATE TABLE `".$dbprefix1."console` (
`id` smallint(255) NOT NULL auto_increment,
`url` varchar(255) NOT NULL default '',
`name` varchar(255) NOT NULL default '',
`displayname` varchar(255) NOT NULL default '',
`minrank` smallint(255) NOT NULL default '0',
`hide` int(11) NOT NULL default '0',
PRIMARY KEY (`id`),
UNIQUE KEY `name` (`name`),
UNIQUE KEY `url` (`url`)
) AUTO_INCREMENT=66 ;
";
$result = mysql_query($query)
or die(mysql_error());
// Console Inserts
$query = "INSERT INTO `".$dbprefix1."console` VALUES (1, 'include/console/editprofile.php', 'Edit Profile', 'Edit Profile', 0, 0);";
$result = mysql_query($query)
or die(mysql_error());
$query = "INSERT INTO `".$dbprefix1."console` VALUES (2, 'include/console/addcalendarevent.php', 'Add a Calendar Event', 'Add a Calendar Event', 10, 0);";
$result = mysql_query($query)
or die(mysql_error());
$query = "INSERT INTO `".$dbprefix1."console` VALUES (3, 'include/console/addclanlegend.php', 'Add a Clan Legend', 'Add a Clan Legend', 25, 0);";
$result = mysql_query($query)
or die(mysql_error());
$query = "INSERT INTO `".$dbprefix1."console` VALUES (4, 'include/console/adddownload.php', 'Add Download', 'Add Download', 13, 0);";
$result = mysql_query($query)
or die(mysql_error());
$query = "INSERT INTO `".$dbprefix1."console` VALUES (5, 'include/console/addhalloffamer.php', 'Add to Hall of Fame', 'Add to Hall of Fame', 21, 0);";
$result = mysql_query($query)
or die(mysql_error());
$query = "INSERT INTO `".$dbprefix1."console` VALUES (6, 'include/console/addhallofshamer.php', 'Add to Hall of Shame', 'Add to Hall of Shame', 21, 0);";
$result = mysql_query($query)
or die(mysql_error());
$query = "INSERT INTO `".$dbprefix1."console` VALUES (7, 'include/console/addhero.php', 'Add a Hero', 'Add a Hero', 25, 0);";
$result = mysql_query($query)
or die(mysql_error());
$query = "INSERT INTO `".$dbprefix1."console` VALUES (8, 'include/console/addmember.php', 'Add a Member', 'Add a Member', 10, 0);";
$result = mysql_query($query)
or die(mysql_error());
$query = "INSERT INTO `".$dbprefix1."console` VALUES (9, 'include/console/addpastwar.php', 'Add a Past War', 'Add a Past War', 25, 0);";
$result = mysql_query($query)
or die(mysql_error());
$query = "INSERT INTO `".$dbprefix1."console` VALUES (10, 'include/console/addtourneystaff.php', 'Add Tournament Staff', 'Add Tournament Staff', 25, 0);";
$result = mysql_query($query)
or die(mysql_error());
$query = "INSERT INTO `".$dbprefix1."console` VALUES (11, 'include/console/awardmedal.php', 'Award Medal', 'Award Medal', 21, 0);";
$result = mysql_query($query)
or die(mysql_error());
$query = "INSERT INTO `".$dbprefix1."console` VALUES (12, 'include/console/challenge.php', 'Challenge', 'Challenge', 0, 0);";
$result = mysql_query($query)
or die(mysql_error());
$query = "INSERT INTO `".$dbprefix1."console` VALUES (13, 'include/console/changename.php', 'Change Name', 'Change Name', 0, 0);";
$result = mysql_query($query)
or die(mysql_error());
$query = "INSERT INTO `".$dbprefix1."console` VALUES (14, 'include/console/changepassword.php', 'Change Password', 'Change Password', 0, 0);";
$result = mysql_query($query)
or die(mysql_error());
$query = "INSERT INTO `".$dbprefix1."console` VALUES (15, 'include/console/chatboard.php', 'Post on Chat Board', 'Post on Chat Board', 0, 0);";
$result = mysql_query($query)
or die(mysql_error());
$query = "INSERT INTO `".$dbprefix1."console` VALUES (17, 'include/console/clearlogs.php', 'Clear Logs', 'Clear Logs', 26, 0);";
$result = mysql_query($query)
or die(mysql_error());
$query = "INSERT INTO `".$dbprefix1."console` VALUES (18, 'include/console/deleteclanlegend.php', 'Delete a Clan Legend', 'Delete a Clan Legend', 25, 0);";
$result = mysql_query($query)
or die(mysql_error());
$query = "INSERT INTO `".$dbprefix1."console` VALUES (19, 'include/console/deletedownload.php', 'Delete Download', 'Delete Download', 13, 0);";
$result = mysql_query($query)
or die(mysql_error());
$query = "INSERT INTO `".$dbprefix1."console` VALUES (20, 'include/console/deletehalloffamer.php', 'Delete Hall of Famer', 'Delete Hall of Famer', 21, 0);";
$result = mysql_query($query)
or die(mysql_error());
$query = "INSERT INTO `".$dbprefix1."console` VALUES (21, 'include/console/deletehallofshamer.php', 'Delete Hall of Shamer', 'Delete Hall of Shamer', 21, 0);";
$result = mysql_query($query)
or die(mysql_error());
$query = "INSERT INTO `".$dbprefix1."console` VALUES (22, 'include/console/deletehero.php', 'Delete a Hero', 'Delete a Hero', 25, 0);";
$result = mysql_query($query)
or die(mysql_error());
$query = "INSERT INTO `".$dbprefix1."console` VALUES (23, 'include/console/deletemember.php', 'Delete a Member', 'Delete a Member', 26, 0);";
$result = mysql_query($query)
or die(mysql_error());
$query = "INSERT INTO `".$dbprefix1."console` VALUES (24, 'include/console/deletesquad.php', 'Delete a Squad', 'Delete a Squad', 26, 0);";
$result = mysql_query($query)
or die(mysql_error());
$query = "INSERT INTO `".$dbprefix1."console` VALUES (25, 'include/console/deletetourneystaff.php', 'Delete Tournament Staff', 'Delete Tournament Staff', 25, 0);";
$result = mysql_query($query)
or die(mysql_error());
$query = "INSERT INTO `".$dbprefix1."console` VALUES (26, 'include/console/demotemember.php', 'Demote Member', 'Demote Member', 15, 0);";
$result = mysql_query($query)
or die(mysql_error());
$query = "INSERT INTO `".$dbprefix1."console` VALUES (27, 'include/console/diplomacyoptions.php', 'Diplomacy Options', 'Diplomacy Options', 21, 0);";
$result = mysql_query($query)
or die(mysql_error());
$query = "INSERT INTO `".$dbprefix1."console` VALUES (28, 'include/console/disablemember.php', 'Disable Member', 'Disable Member', 15, 0);";
$result = mysql_query($query)
or die(mysql_error());
$query = "INSERT INTO `".$dbprefix1."console` VALUES (29, 'include/console/editchallenges.php', 'Manage Challenges', 'Manage Challenges', 0, 0);";
$result = mysql_query($query)
or die(mysql_error());
$query = "INSERT INTO `".$dbprefix1."console` VALUES (30, 'include/console/edithistory.php', 'Edit History', 'Edit History', 25, 0);";
$result = mysql_query($query)
or die(mysql_error());
$query = "INSERT INTO `".$dbprefix1."console` VALUES (31, 'include/console/editmotm.php', 'Edit Member of the Month', 'Edit Member of the Month', 25, 0);";
$result = mysql_query($query)
or die(mysql_error());
$query = "INSERT INTO `".$dbprefix1."console` VALUES (32, 'include/console/editnewsticker.php', 'Edit News Ticker', 'Edit News Ticker', 26, 0);";
$result = mysql_query($query)
or die(mysql_error());
$query = "INSERT INTO `".$dbprefix1."console` VALUES (33, 'include/console/editrules.php', 'Edit Rules', 'Edit Rules', 25, 0);";
$result = mysql_query($query)
or die(mysql_error());
$query = "INSERT INTO `".$dbprefix1."console` VALUES (34, 'include/console/editsecurity.php', 'Change Security Level', 'Change Security Level', 25, 0);";
$result = mysql_query($query)
or die(mysql_error());
$query = "INSERT INTO `".$dbprefix1."console` VALUES (35, 'include/console/entertournament.php', 'Enter a Tournament', 'Enter a Tournament', 0, 0);";
$result = mysql_query($query)
or die(mysql_error());
$query = "INSERT INTO `".$dbprefix1."console` VALUES (37, 'include/console/iarequest.php', 'IA Request', 'IA Request', 0, 0);";
$result = mysql_query($query)
or die(mysql_error());
$query = "INSERT INTO `".$dbprefix1."console` VALUES (38, 'include/console/iarequestoptions.php', 'IA Request Options', 'IA Request Options', 21, 0);";
$result = mysql_query($query)
or die(mysql_error());
$query = "INSERT INTO `".$dbprefix1."console` VALUES (39, 'include/console/ipban.php', 'IP Banning', 'IP Banning', 25, 0);";
$result = mysql_query($query)
or die(mysql_error());
$query = "INSERT INTO `".$dbprefix1."console` VALUES (40, 'include/console/massmemberadder.php', 'Mass Member Adder', 'Mass Member Adder', 25, 0);";
$result = mysql_query($query)
or die(mysql_error());
$query = "INSERT INTO `".$dbprefix1."console` VALUES (41, 'include/console/postnews.php', 'Post News', 'Post News', 10, 0);";
$result = mysql_query($query)
or die(mysql_error());
$query = "INSERT INTO `".$dbprefix1."console` VALUES (42, 'include/console/promotemember.php', 'Promote Member', 'Promote Member', 15, 0);";
$result = mysql_query($query)
or die(mysql_error());
$query = "INSERT INTO `".$dbprefix1."console` VALUES (43, 'include/console/recruiting.php', 'Open/Close Recruiting', 'Open/Close Recruiting', 25, 0);";
$result = mysql_query($query)
or die(mysql_error());
$query = "INSERT INTO `".$dbprefix1."console` VALUES (44, 'include/console/retrievepassword.php', 'Retrieve Password', 'Retrieve Password', 25, 0);";
$result = mysql_query($query)
or die(mysql_error());
$query = "INSERT INTO `".$dbprefix1."console` VALUES (45, 'include/console/revokemedal.php', 'Revoke Medal', 'Revoke Medal', 21, 0);";
$result = mysql_query($query)
or die(mysql_error());
$query = "INSERT INTO `".$dbprefix1."console` VALUES (46, 'include/console/sendpm.php', 'Send PM', 'Send a PM', 0, 0);";
$result = mysql_query($query)
or die(mysql_error());
$query = "INSERT INTO `".$dbprefix1."console` VALUES (47, 'include/console/setrank.php', 'Set Rank', 'Set Rank', 25, 0);";
$result = mysql_query($query)
or die(mysql_error());
$query = "INSERT INTO `".$dbprefix1."console` VALUES (48, 'include/console/startsquad.php', 'Start Squad', 'Start a Squad', 10, 0);";
$result = mysql_query($query)
or die(mysql_error());
$query = "INSERT INTO `".$dbprefix1."console` VALUES (49, 'include/console/tournamentoptions.php', 'Tournament Options', 'Tournament Options', 10, 0);";
$result = mysql_query($query)
or die(mysql_error());
$query = "INSERT INTO `".$dbprefix1."console` VALUES (50, 'include/console/undisablemember.php', 'Undisable Member', 'Undisable Member', 15, 0);";
$result = mysql_query($query)
or die(mysql_error());
$query = "INSERT INTO `".$dbprefix1."console` VALUES (51, 'include/console/viewlogs.php', 'View Logs', 'View Logs', 0, 0);";
$result = mysql_query($query)
or die(mysql_error());
$query = "INSERT INTO `".$dbprefix1."console` VALUES (52, 'include/console/viewnews.php', 'View Internal News', 'View Internal News', 0, 0);";
$result = mysql_query($query)
or die(mysql_error());
$query = "INSERT INTO `".$dbprefix1."console` VALUES (53, 'include/console/viewpm.php', 'PM Inbox', 'PM Inbox', 0, 0);";
$result = mysql_query($query)
or die(mysql_error());
$query = "INSERT INTO `".$dbprefix1."console` VALUES (54, 'include/console/viewprofile.php', 'View Profile', 'View Profile', 0, 0);";
$result = mysql_query($query)
or die(mysql_error());
$query = "INSERT INTO `".$dbprefix1."console` VALUES (55, 'include/console/votemotm.php', 'Vote for Member of the Month', 'Vote for Member of the Month', 0, 0);";
$result = mysql_query($query)
or die(mysql_error());
$query = "INSERT INTO `".$dbprefix1."console` VALUES (56, 'include/console/editstats.php', 'Edit Stats', 'Edit Stats', 0, 0);";
$result = mysql_query($query)
or die(mysql_error());
$query = "INSERT INTO `".$dbprefix1."console` VALUES (57, 'include/console/addsong.php', 'Add a Song', 'Add a Song', 25, 0);";
$result = mysql_query($query)
or die(mysql_error());
$query = "INSERT INTO `".$dbprefix1."console` VALUES (58, 'include/console/deletesong.php', 'Delete a Song', 'Delete a Song', 25, 0);";
$result = mysql_query($query)
or die(mysql_error());
$query = "INSERT INTO `".$dbprefix1."console` VALUES (59, 'include/console/postcomment.php', 'Post Comment', 'Post Comment', 0, 1);";
$result = mysql_query($query)
or die(mysql_error());
$query = "INSERT INTO `".$dbprefix1."console` VALUES (60, 'include/console/editnews.php', 'Edit News', 'Edit News', 21, 1);";
$result = mysql_query($query)
or die(mysql_error());
$query = "INSERT INTO `".$dbprefix1."console` VALUES (61, 'include/console/deletenews.php', 'Delete News', 'Delete News', 21, 1);";
$result = mysql_query($query)
or die(mysql_error());
$query = "INSERT INTO `".$dbprefix1."console` VALUES (62, 'include/console/managesquad.php', 'Manage Squads', 'Manage Squads', 10, 0);";
$result = mysql_query($query)
or die(mysql_error());
$query = "INSERT INTO `".$dbprefix1."console` VALUES (63, 'include/console/joinsquad.php', 'Join Squad', 'Join a Squad', 0, 0);";
$result = mysql_query($query)
or die(mysql_error());
$query = "INSERT INTO `".$dbprefix1."console` VALUES (65, 'include/console/deletepastwar.php', 'Delete Past War', 'Delete Past War', 25, 0);";
$result = mysql_query($query)
or die(mysql_error());
// CREATE custompage table
$query = "
CREATE TABLE `".$dbprefix1."custompage` (
`id` smallint(255) NOT NULL auto_increment,
`title` varchar(255) NOT NULL default '',
`info` text NOT NULL,
PRIMARY KEY (`id`)
) AUTO_INCREMENT=1 ;
";
$result = mysql_query($query)
or die(mysql_error());
// CREATE diplomacy table
$query = "
CREATE TABLE `".$dbprefix1."diplomacy` (
`id` smallint(255) NOT NULL auto_increment,
`clanname` varchar(255) NOT NULL default '',
`sponser` varchar(255) NOT NULL default '',
`dateadded` varchar(255) NOT NULL default '',
`website` varchar(255) NOT NULL default '',
`status` varchar(255) NOT NULL default '',
`game` varchar(255) NOT NULL default '',
`skill` varchar(255) NOT NULL default '',
`tag` varchar(255) NOT NULL default '',
`description` text NOT NULL,
`clansize` varchar(255) NOT NULL default '',
`leaders` varchar(255) NOT NULL default '',
PRIMARY KEY (`id`)
) AUTO_INCREMENT=1 ;
";
$result = mysql_query($query)
or die(mysql_error());
// CREATE downloadcategory table
$query = "
CREATE TABLE `".$dbprefix1."downloadcategory` (
`id` smallint(255) NOT NULL auto_increment,
`name` varchar(255) NOT NULL default '',
`extension` varchar(255) NOT NULL default '',
PRIMARY KEY (`id`),
UNIQUE KEY `name` (`name`)
) AUTO_INCREMENT=1 ;
";
$result = mysql_query($query)
or die(mysql_error());
// CREATE download table
$query = "
CREATE TABLE `".$dbprefix1."downloads` (
`id` smallint(255) NOT NULL auto_increment,
`name` varchar(255) NOT NULL default '',
`type` int(225) NOT NULL default '0',
`description` text NOT NULL,
`poster` int(11) NOT NULL default '0',
`filename` varchar(255) NOT NULL default '',
`dateadded` int(255) NOT NULL default '0',
`adderip` varchar(255) NOT NULL default '',
`outsidelink` int(11) NOT NULL default '0',
PRIMARY KEY (`id`)
) AUTO_INCREMENT=1 ;
";
$result = mysql_query($query)
or die(mysql_error());
// CREATE gamesplayed table
$query = "
CREATE TABLE `".$dbprefix1."gamesplayed` (
`id` smallint(255) NOT NULL auto_increment,
`gamename` varchar(255) NOT NULL default '',
`gamepic` varchar(255) NOT NULL default '',
`statnames` text NOT NULL,
`outsidelink` int(25) NOT NULL default '0',
PRIMARY KEY (`id`)
) AUTO_INCREMENT=4 ;
";
$result = mysql_query($query)
or die(mysql_error());
$query = "INSERT INTO `".$dbprefix1."gamesplayed` VALUES (1, 'Starcraft', '/gamesplayed/sc.gif', 'Wins*\r\nLosses\r\nDisc', 0);";
$result = mysql_query($query)
or die(mysql_error());
$query = "INSERT INTO `".$dbprefix1."gamesplayed` VALUES (2, 'Brood War', '/gamesplayed/bw.gif', 'Wins*\r\nLosses\r\nDisc', 0);";
$result = mysql_query($query)
or die(mysql_error());
$query = "INSERT INTO `".$dbprefix1."gamesplayed` VALUES (3, 'Frozen Throne', '/gamesplayed/w3x.gif', 'Wins*\r\nLosses\r\nDisc', 0);";
$result = mysql_query($query)
or die(mysql_error());
$query = "INSERT INTO `".$dbprefix1."gamesplayed` VALUES (4, 'Warcraft 3', '/gamesplayed/w3.gif', 'Wins*\r\nLosses\r\nDisc', 0);";
$result = mysql_query($query)
or die(mysql_error());
// CREATE hall table
$query = "
CREATE TABLE `".$dbprefix1."hall` (
`id` smallint(255) NOT NULL auto_increment,
`name` varchar(255) NOT NULL default '',
`reason` varchar(255) NOT NULL default '',
`type` varchar(255) NOT NULL default '',
`adderip` varchar(255) NOT NULL default '',
PRIMARY KEY (`id`)
) AUTO_INCREMENT=1 ;
";
$result = mysql_query($query)
or die(mysql_error());
// CREATE iarequests table
$query = "
CREATE TABLE `".$dbprefix1."iarequests` (
`id` smallint(255) NOT NULL auto_increment,
`requester` varchar(255) NOT NULL default '',
`approver` varchar(255) NOT NULL default '',
`subject` varchar(255) NOT NULL default '',
`reason` text NOT NULL,
`status` int(11) NOT NULL default '0',
`daterequested` int(255) NOT NULL default '0',
`dateapproved` varchar(255) NOT NULL default '',
`comments` text NOT NULL,
PRIMARY KEY (`id`)
) AUTO_INCREMENT=1 ;
";
$result = mysql_query($query)
or die(mysql_error());
// CREATE ipban table
$query = "
CREATE TABLE `".$dbprefix1."ipban` (
`id` smallint(255) NOT NULL auto_increment,
`ipaddress` varchar(255) NOT NULL default '',
`reason` varchar(255) NOT NULL default '',
`banend` int(255) NOT NULL default '0',
PRIMARY KEY (`id`)
) AUTO_INCREMENT=1 ;
";
$result = mysql_query($query)
or die(mysql_error());
// CREATE ips table
$query = "
CREATE TABLE `".$dbprefix1."ips` (
`id` smallint(255) NOT NULL auto_increment,
`ipaddress` varchar(255) NOT NULL default '',
`loginattempts` int(11) NOT NULL default '0',
`lastsong` int(255) NOT NULL default '0',
`repeatsong` int(255) NOT NULL default '0',
PRIMARY KEY (`id`),
UNIQUE KEY `ipaddress` (`ipaddress`)
) AUTO_INCREMENT=1 ;
";
$result = mysql_query($query)
or die(mysql_error());
// CREATE logs table
$query = "
CREATE TABLE `".$dbprefix1."logs` (
`id` smallint(25) NOT NULL auto_increment,
`action` text NOT NULL,
`ipaddress` varchar(255) NOT NULL default '',
`datelogged` int(255) NOT NULL default '0',
PRIMARY KEY (`id`)
) AUTO_INCREMENT=1 ;
";
$result = mysql_query($query)
or die(mysql_error());
// CREATE medals table
$query = "
CREATE TABLE `".$dbprefix1."medals` (
`id` smallint(255) NOT NULL auto_increment,
`name` varchar(255) NOT NULL default '',
`picture` varchar(255) NOT NULL default '',
`description` text NOT NULL,
`autodays` int(255) NOT NULL default '0',
`autorecruits` int(255) NOT NULL default '0',
`outsidelink` int(1) NOT NULL default '0',
PRIMARY KEY (`id`)
) AUTO_INCREMENT=35 ;
";
$result = mysql_query($query)
or die(mysql_error());
$query = "INSERT INTO `".$dbprefix1."medals` VALUES (32, 'Army Achievement Medal', '/medals/aa.jpg', '', 150, 0, 0);";
$result = mysql_query($query)
or die(mysql_error());
$query = "INSERT INTO `".$dbprefix1."medals` VALUES (2, 'American Campaign Medal', '/medals/ac.jpg', '', 730, 0, 0);";
$result = mysql_query($query)
or die(mysql_error());
$query = "INSERT INTO `".$dbprefix1."medals` VALUES (3, 'Army Distinguished Cross', '/medals/adc.jpg', '', 20, 0, 0);";
$result = mysql_query($query)
or die(mysql_error());
$query = "INSERT INTO `".$dbprefix1."medals` VALUES (4, 'Armed Forces Services', '/medals/afs.jpg', '', 10, 0, 0);";
$result = mysql_query($query)
or die(mysql_error());
$query = "INSERT INTO `".$dbprefix1."medals` VALUES (5, 'Army Good Conduct Medal', '/medals/agc.jpg', '', 90, 0, 0);";
$result = mysql_query($query)
or die(mysql_error());
$query = "INSERT INTO `".$dbprefix1."medals` VALUES (6, 'Asiatic Pacific Campaign Medal', '/medals/apc.jpg', 'This medal is given to a member who wins an interclan tournament. ', 0, 0, 0);";
$result = mysql_query($query)
or die(mysql_error());
$query = "INSERT INTO `".$dbprefix1."medals` VALUES (7, 'Airman''s Medal', '/medals/am.jpg', '', 1000, 0, 0);";
$result = mysql_query($query)
or die(mysql_error());
$query = "INSERT INTO `".$dbprefix1."medals` VALUES (8, 'Army Reserve Achievment Medal', '/medals/ara.jpg', '', 210, 0, 0);";
$result = mysql_query($query)
or die(mysql_error());
$query = "INSERT INTO `".$dbprefix1."medals` VALUES (9, 'Bronze Star', '/medals/bs.jpg', '', 30, 0, 0);";
$result = mysql_query($query)
or die(mysql_error());
$query = "INSERT INTO `".$dbprefix1."medals` VALUES (10, 'Defense Distinguished Service Medal', '/medals/ddsm.jpg', 'Awaded for strong activeness on the message board and Battle.net. ', 0, 0, 0);";
$result = mysql_query($query)
or die(mysql_error());
$query = "INSERT INTO `".$dbprefix1."medals` VALUES (11, 'Distinguished Flying Cross', '/medals/dfc.jpg', 'Awarded to anyone who has 0 DSL for a week straight. Ask a general for this medal. ', 0, 0, 0);";
$result = mysql_query($query)
or die(mysql_error());
$query = "INSERT INTO `".$dbprefix1."medals` VALUES (12, 'Distinguished Knowledge Achievement', '/medals/dka.jpg', 'This Medal is awarded to anyone that has a basic knowledge of bots. Must be able to load at least ONE. ', 0, 0, 0);";
$result = mysql_query($query)
or die(mysql_error());
$query = "INSERT INTO `".$dbprefix1."medals` VALUES (13, 'Distinguished Knowledge Commendation', '/medals/dkc.jpg', 'This Medal is awarded to anyone that has an excellent knowledge of bots. Must be able to load at least FOUR. ', 0, 0, 0);";
$result = mysql_query($query)
or die(mysql_error());
$query = "INSERT INTO `".$dbprefix1."medals` VALUES (14, 'Defense Meritorious Service Medal', '/medals/dms.jpg', 'Awarded for Extreme Activeness on Battle.net, AIM and the message board. ', 0, 0, 0);";
$result = mysql_query($query)
or die(mysql_error());
$query = "INSERT INTO `".$dbprefix1."medals` VALUES (15, 'Distinguished Service Cross', '/medals/dsc.jpg', '', 300, 0, 0);";
$result = mysql_query($query)
or die(mysql_error());
$query = "INSERT INTO `".$dbprefix1."medals` VALUES (16, 'Distinguished Service Medal', '/medals/dsm.jpg', '', 180, 0, 0);";
$result = mysql_query($query)
or die(mysql_error());
$query = "INSERT INTO `".$dbprefix1."medals` VALUES (17, 'Defense Superior Service Medal', '/medals/dss.jpg', 'Awarded for High activeness on Battle.net and on message board. Recipient must be on everyday and constantly show support. ', 0, 0, 0);";
$result = mysql_query($query)
or die(mysql_error());
$query = "INSERT INTO `".$dbprefix1."medals` VALUES (18, 'Medal for Humane Action', '/medals/ha.jpg', '', 550, 0, 0);";
$result = mysql_query($query)
or die(mysql_error());
$query = "INSERT INTO `".$dbprefix1."medals` VALUES (19, 'Humanitarian Service Medal', '/medals/hs.jpg', '', 365, 0, 0);";
$result = mysql_query($query)
or die(mysql_error());
$query = "INSERT INTO `".$dbprefix1."medals` VALUES (20, 'Joint Service Commendation Medal', '/medals/jsc.jpg', '', 450, 0, 0);";
$result = mysql_query($query)
or die(mysql_error());
$query = "INSERT INTO `".$dbprefix1."medals` VALUES (21, 'Legion of Merit', '/medals/lom.jpg', 'This medal is given only to members who are competent, loyal, reliable at all times. ', 0, 0, 0);";
$result = mysql_query($query)
or die(mysql_error());
$query = "INSERT INTO `".$dbprefix1."medals` VALUES (22, 'Meritorious Knowledge', '/medals/mka.jpg', 'Achievement\r\nThis Medal is awarded to anyone that has an exceptional knowledge of bots. Must be able to load at least NINE. ', 0, 0, 0);";
$result = mysql_query($query)
or die(mysql_error());
$query = "INSERT INTO `".$dbprefix1."medals` VALUES (23, 'Medal of Honor', '/medals/moh.jpg', 'The Highest ranking medal you can recieve. This medal shows supreme dedication, supreme loyalty, supreme activeness, and supreme helpful to the clan. Can ONLY be awarded by Commanders. ', 0, 0, 0);";
$result = mysql_query($query)
or die(mysql_error());
$query = "INSERT INTO `".$dbprefix1."medals` VALUES (24, 'Meritorious Service Medal', '/medals/ms.jpg', 'This the second Highest medal can be awared. This medal is given only to members who are EXTREMELY loyal, trustworthy, and reliable at all times. Can only be awarded by commanders. ', 0, 0, 0);";
$result = mysql_query($query)
or die(mysql_error());
$query = "INSERT INTO `".$dbprefix1."medals` VALUES (25, 'Navy Achievement', '/medals/na.jpg', 'This medal is awarded to the above average member who has shown his loyalty. ', 0, 0, 0);";
$result = mysql_query($query)
or die(mysql_error());
$query = "INSERT INTO `".$dbprefix1."medals` VALUES (26, 'Navy Cross', '/medals/nc.jpg', 'This medal is given to members who have proven themselves loyal and trustworthy. ', 0, 0, 0);";
$result = mysql_query($query)
or die(mysql_error());
$query = "INSERT INTO `".$dbprefix1."medals` VALUES (27, 'Purple Heart', '/medals/ph.jpg', 'Awarded to member who helps the clan through Web Design/Graphics, etc... ', 0, 0, 0);";
$result = mysql_query($query)
or die(mysql_error());
$query = "INSERT INTO `".$dbprefix1."medals` VALUES (28, 'Prisoner of War', '/medals/pow.jpg', 'Given to a member who helps gain information on another clan during war. Must be approved by general first before spying. ', 0, 0, 0);";
$result = mysql_query($query)
or die(mysql_error());
$query = "INSERT INTO `".$dbprefix1."medals` VALUES (29, 'Silver Star', '/medals/ss.jpg', 'Blah', 120, 0, 0);";
$result = mysql_query($query)
or die(mysql_error());
$query = "INSERT INTO `".$dbprefix1."medals` VALUES (30, 'United Nations Medal', '/medals/un.jpg', 'Awarded for helping set up an alliance. The clan must be active, at least 2 months old, mature leader, at 25 members, and decent website. ', 0, 0, 0);";
$result = mysql_query($query)
or die(mysql_error());
$query = "INSERT INTO `".$dbprefix1."medals` VALUES (31, 'US Service Medal', '/medals/uss.jpg', '', 60, 0, 0);";
$result = mysql_query($query)
or die(mysql_error());
// CREATE members table
$query = "
CREATE TABLE `".$dbprefix1."members` (
`id` smallint(255) NOT NULL auto_increment,
`username` varchar(20) NOT NULL default '',
`password` varchar(20) NOT NULL default '',
`recruitedby` varchar(255) NOT NULL default 'Admin Account',
`recruits` int(255) NOT NULL default '0',
`aim` varchar(25) NOT NULL default 'None',
`loggedin` int(11) NOT NULL default '0',
`remember` int(1) NOT NULL default '0',
`medals` text NOT NULL,
`gamesplayed` text NOT NULL,
`rank` int(11) NOT NULL default '0',
`email` varchar(255) NOT NULL default 'None',
`lastlogin` int(255) NOT NULL default '0',
`datejoined` int(255) NOT NULL default '0',
`lastpromotion` int(255) NOT NULL default '0',
`lastdemotion` int(255) NOT NULL default '0',
`ipnum` varchar(255) NOT NULL default '',
`maingame` varchar(255) NOT NULL default '',
`realname` varchar(255) NOT NULL default '',
`country` varchar(255) NOT NULL default '',
`bday` int(255) NOT NULL default '0',
`age` smallint(2) NOT NULL default '0',
`pic` varchar(255) NOT NULL default 'http://',
`disable` smallint(1) NOT NULL default '0',
`inactive` int(1) NOT NULL default '0',
`inactivedate` int(255) NOT NULL default '0',
`inactivedays` int(255) NOT NULL default '0',
`gender` varchar(255) NOT NULL default 'Male',
`timesloggedin` int(255) NOT NULL default '0',
`yahoo` varchar(255) NOT NULL default 'None',
`msn` varchar(255) NOT NULL default 'None',
`quote` text NOT NULL,
`smurfnames` text NOT NULL,
`motmvotes` int(225) NOT NULL default '0',
`motmvoted` varchar(255) NOT NULL default '0',
`tourneystaff` int(1) NOT NULL default '0',
`gp_Wins_1` int(255) NOT NULL default '0',
`gp_Losses_1` varchar(255) NOT NULL default '',
`gp_Disc_1` varchar(255) NOT NULL default '',
`gp_Wins_2` int(255) NOT NULL default '0',
`gp_Losses_2` varchar(255) NOT NULL default '',
`gp_Disc_2` varchar(255) NOT NULL default '',
`gp_Wins_3` int(255) NOT NULL default '0',
`gp_Losses_3` varchar(255) NOT NULL default '',
`gp_Disc_3` varchar(255) NOT NULL default '',
`gp_Wins_4` int(255) NOT NULL default '0',
`gp_Losses_4` varchar(255) NOT NULL default '',
`gp_Disc_4` varchar(255) NOT NULL default '',
PRIMARY KEY (`id`),
UNIQUE KEY `username` (`username`)
) AUTO_INCREMENT=1 ;
";
$result = mysql_query($query)
or die(mysql_error());
$time = time();
$query = "INSERT INTO {$dbprefix1}members (username, password, recruitedby, rank, lastlogin, datejoined) VALUES ('Webmaster', '12345', '1', '26', '$time', '$time')";
$result = mysql_query($query)
or die(mysql_error());
// CREATE news table
$query = "
CREATE TABLE `".$dbprefix1."news` (
`id` smallint(255) NOT NULL auto_increment,
`dateposted` varchar(255) NOT NULL default '',
`subject` varchar(255) NOT NULL default '',
`poster` varchar(255) NOT NULL default '',
`posterip` varchar(255) NOT NULL default '',
`content` text NOT NULL,
`type` varchar(255) NOT NULL default '',
`newscat` varchar(255) NOT NULL default '',
`month` varchar(255) NOT NULL default '',
`day` varchar(255) NOT NULL default '',
`year` varchar(255) NOT NULL default '',
`lasteditor` varchar(255) NOT NULL default '',
`lasteditdate` varchar(255) NOT NULL default '',
PRIMARY KEY (`id`)
) AUTO_INCREMENT=1 ;
";
$result = mysql_query($query)
or die(mysql_error());
// CREATE pastwars table
$query = "
CREATE TABLE `".$dbprefix1."pastwars` (
`id` smallint(255) NOT NULL auto_increment,
`enemyclan` varchar(255) NOT NULL default '',
`leaders` varchar(255) NOT NULL default '',
`dateended` varchar(255) NOT NULL default '',
`outcome` varchar(255) NOT NULL default '',
`adderip` varchar(255) NOT NULL default '',
PRIMARY KEY (`id`)
) AUTO_INCREMENT=1 ;
";
$result = mysql_query($query)
or die(mysql_error());
// CREATE pm table
$query = "
CREATE TABLE `".$dbprefix1."pm` (
`id` smallint(255) NOT NULL auto_increment,
`sender` int(255) NOT NULL default '0',
`reciever` int(255) NOT NULL default '0',
`subject` varchar(255) NOT NULL default '',
`message` text NOT NULL,
`datesent` int(255) NOT NULL default '0',
`alert` int(1) NOT NULL default '0',
PRIMARY KEY (`id`)
) AUTO_INCREMENT=1 ;
";
$result = mysql_query($query)
or die(mysql_error());
// CREATE randomimages table
$query = "
CREATE TABLE `".$dbprefix1."randomimages` (
`id` smallint(255) NOT NULL auto_increment,
`imageurl` varchar(255) NOT NULL default '',
PRIMARY KEY (`id`)
) AUTO_INCREMENT=1 ;
";
$result = mysql_query($query)
or die(mysql_error());
// CREATE rankcategory table
$query = "
CREATE TABLE `".$dbprefix1."rankcategory` (
`id` smallint(255) NOT NULL auto_increment,
`name` varchar(255) NOT NULL default '',
`description` text NOT NULL,
`orderby` int(11) NOT NULL default '0',
`minrank` int(11) NOT NULL default '0',
`maxrank` int(11) NOT NULL default '0',
`color` varchar(255) NOT NULL default '',
PRIMARY KEY (`id`),
UNIQUE KEY `orderby` (`orderby`)
) AUTO_INCREMENT=10 ;
";
$result = mysql_query($query)
or die(mysql_error());
$query = "INSERT INTO `".$dbprefix1."rankcategory` VALUES (7, 'Commanders', 'Commanders duties go here.', 2, 25, 26, 'red');";
$result = mysql_query($query)
or die(mysql_error());
$query = "INSERT INTO `".$dbprefix1."rankcategory` VALUES (2, 'Generals', 'General duties go here.', 3, 21, 24, 'gold');";
$result = mysql_query($query)
or die(mysql_error());
$query = "INSERT INTO `".$dbprefix1."rankcategory` VALUES (3, 'Officers', 'Officers duties go here.', 4, 15, 20, 'steelblue');";
$result = mysql_query($query)
or die(mysql_error());
$query = "INSERT INTO `".$dbprefix1."rankcategory` VALUES (4, 'Warrant Officers', 'Warrant Officers duites go here.', 5, 10, 14, 'teal');";
$result = mysql_query($query)
or die(mysql_error());
$query = "INSERT INTO `".$dbprefix1."rankcategory` VALUES (5, 'Enlisted', 'Enlisted Duties go here.', 6, 0, 9, 'lime');";
$result = mysql_query($query)
or die(mysql_error());
// CREATE ranks tables
$query = "
CREATE TABLE `".$dbprefix1."ranks` (
`id` smallint(255) NOT NULL auto_increment,
`name` varchar(255) NOT NULL default '',
`description` text NOT NULL,
`picture` varchar(255) NOT NULL default '',
`ranknum` int(11) NOT NULL default '0',
`autodays` int(11) NOT NULL default '0',
`outsidelink` smallint(2) NOT NULL default '0',
`power` int(11) NOT NULL default '0',
PRIMARY KEY (`id`),
UNIQUE KEY `ranknum` (`ranknum`),
UNIQUE KEY `name` (`name`)
) AUTO_INCREMENT=30 ;
";
$result = mysql_query($query)
or die(mysql_error());
$query = "INSERT INTO `".$dbprefix1."ranks` VALUES (1, 'Commander', 'This is a very important rank. They have to be very active and a good leader.', '/ranks/26.gif', 26, 0, 0, 26);";
$result = mysql_query($query)
or die(mysql_error());
$query = "INSERT INTO `".$dbprefix1."ranks` VALUES (2, 'Co-Commander', 'The Co-Commander helps the Commanders. Promoted by the Commander. ', '/ranks/25.gif', 25, 0, 0, 25);";
$result = mysql_query($query)
or die(mysql_error());
$query = "INSERT INTO `".$dbprefix1."ranks` VALUES (3, 'General', 'Promoted by the Commander. ', '/ranks/24.gif', 24, 0, 0, 23);";
$result = mysql_query($query)
or die(mysql_error());
$query = "INSERT INTO `".$dbprefix1."ranks` VALUES (4, 'Lieutenant General', 'Promoted by General or Higher.', '/ranks/23.gif', 23, 0, 0, 21);";
$result = mysql_query($query)
or die(mysql_error());
$query = "INSERT INTO `".$dbprefix1."ranks` VALUES (5, 'Major General', 'Promoted by General or Higher. ', '/ranks/22.gif', 22, 0, 0, 21);";
$result = mysql_query($query)
or die(mysql_error());
$query = "INSERT INTO `".$dbprefix1."ranks` VALUES (6, 'Brigadier General', 'Promoted by Major General or Higher. ', '/ranks/21.gif', 21, 0, 0, 20);";
$result = mysql_query($query)
or die(mysql_error());
$query = "INSERT INTO `".$dbprefix1."ranks` VALUES (7, 'Colonel', 'Promoted by Brigadier General or Higher. ', '/ranks/20.gif', 20, 0, 0, 19);";
$result = mysql_query($query)
or die(mysql_error());
$query = "INSERT INTO `".$dbprefix1."ranks` VALUES (8, 'Lieutenant Colonel', 'Promoted by Colonel or Higher. ', '/ranks/19.gif', 19, 0, 0, 18);";
$result = mysql_query($query)
or die(mysql_error());
$query = "INSERT INTO `".$dbprefix1."ranks` VALUES (9, 'Major', 'Promoted by LT. Colonel or Higher. ', '/ranks/18.gif', 18, 0, 0, 17);";
$result = mysql_query($query)
or die(mysql_error());
$query = "INSERT INTO `".$dbprefix1."ranks` VALUES (10, 'Captain', 'Promoted by Major or Higher. ', '/ranks/17.gif', 17, 0, 0, 16);";
$result = mysql_query($query)
or die(mysql_error());
$query = "INSERT INTO `".$dbprefix1."ranks` VALUES (11, '1st Lieutenant', 'Promoted by Captain or Higher.', '/ranks/16.gif', 16, 0, 0, 15);";
$result = mysql_query($query)
or die(mysql_error());
$query = "INSERT INTO `".$dbprefix1."ranks` VALUES (12, '2nd Lieutenant', 'Promoted by 1st Lieutenant or Higher. ', '/ranks/15.gif', 15, 0, 0, 12);";
$result = mysql_query($query)
or die(mysql_error());
$query = "INSERT INTO `".$dbprefix1."ranks` VALUES (13, 'Cheif Warrant Officer W5', 'Promoted by 1st Lieutenant or Higher. ', '/ranks/14.gif', 14, 0, 0, 0);";
$result = mysql_query($query)
or die(mysql_error());
$query = "INSERT INTO `".$dbprefix1."ranks` VALUES (14, 'Cheif Warrant Officer W4', 'Promoted by 1st Lieutanent or Higher.', '/ranks/13.gif', 13, 0, 0, 0);";
$result = mysql_query($query)
or die(mysql_error());
$query = "INSERT INTO `".$dbprefix1."ranks` VALUES (15, 'Warrant Officer W3', 'Promoted by 2nd Lieutanent or Higher.', '/ranks/12.gif', 12, 0, 0, 0);";
$result = mysql_query($query)
or die(mysql_error());
$query = "INSERT INTO `".$dbprefix1."ranks` VALUES (16, 'Warrant Officer W2', 'Promoted by 2nd Lieutanent or Higher.', '/ranks/11.gif', 11, 0, 0, 0);";
$result = mysql_query($query)
or die(mysql_error());
$query = "INSERT INTO `".$dbprefix1."ranks` VALUES (17, 'Warrant Officer W1', 'Promoted by 2nd Lieutanent or Higher.', '/ranks/10.gif', 10, 0, 0, 0);";
$result = mysql_query($query)
or die(mysql_error());
$query = "INSERT INTO `".$dbprefix1."ranks` VALUES (18, 'Sergeant Major', '', '/ranks/9.gif', 9, 56, 0, 0);";
$result = mysql_query($query)
or die(mysql_error());
$query = "INSERT INTO `".$dbprefix1."ranks` VALUES (19, '1st Sergeant', '', '/ranks/8.gif', 8, 49, 0, 0);";
$result = mysql_query($query)
or die(mysql_error());
$query = "INSERT INTO `".$dbprefix1."ranks` VALUES (20, 'Master Sergeant', '', '/ranks/7.gif', 7, 42, 0, 0);";
$result = mysql_query($query)
or die(mysql_error());
$query = "INSERT INTO `".$dbprefix1."ranks` VALUES (21, 'Gunnery Sergeant', '', '/ranks/6.gif', 6, 35, 0, 0);";
$result = mysql_query($query)
or die(mysql_error());
$query = "INSERT INTO `".$dbprefix1."ranks` VALUES (22, 'Staff Sergeant', '', '/ranks/5.gif', 5, 28, 0, 0);";
$result = mysql_query($query)
or die(mysql_error());
$query = "INSERT INTO `".$dbprefix1."ranks` VALUES (23, 'Sergeant', '', '/ranks/4.gif', 4, 21, 0, 0);";
$result = mysql_query($query)
or die(mysql_error());
$query = "INSERT INTO `".$dbprefix1."ranks` VALUES (24, 'Corporal', '', '/ranks/3.gif', 3, 14, 0, 0);";
$result = mysql_query($query)
or die(mysql_error());
$query = "INSERT INTO `".$dbprefix1."ranks` VALUES (25, 'Private First Class', '', '/ranks/2.gif', 2, 7, 0, 0);";
$result = mysql_query($query)
or die(mysql_error());
$query = "INSERT INTO `".$dbprefix1."ranks` VALUES (26, 'Private', '', '/ranks/1.gif', 1, 3, 0, 0);";
$result = mysql_query($query)
or die(mysql_error());
$query = "INSERT INTO `".$dbprefix1."ranks` VALUES (27, 'Recruit', 'Starting Rank', '/ranks/0.gif', 0, -1, 0, 0);";
$result = mysql_query($query)
or die(mysql_error());
// CREATE reqdiplomacy table
$query = "
CREATE TABLE `".$dbprefix1."reqdiplomacy` (
`id` smallint(255) NOT NULL auto_increment,
`clanname` varchar(255) NOT NULL default '',
`email` varchar(255) NOT NULL default '',
`game` varchar(255) NOT NULL default '',
`message` text NOT NULL,
`daterequested` varchar(255) NOT NULL default '',
`ipaddress` varchar(255) NOT NULL default '',
PRIMARY KEY (`id`)
) AUTO_INCREMENT=1 ;
";
$result = mysql_query($query)
or die(mysql_error());
// CREATE songs table
$query = "
CREATE TABLE `".$dbprefix1."songs` (
`id` smallint(255) NOT NULL auto_increment,
`url` varchar(255) NOT NULL default '',
`name` varchar(255) NOT NULL default '',
`outsidelink` int(255) NOT NULL default '0',
`seconds` int(255) NOT NULL default '0',
`adderip` varchar(255) NOT NULL default '',
PRIMARY KEY (`id`)
) AUTO_INCREMENT=1 ;
";
$result = mysql_query($query)
or die(mysql_error());
// CREATE squadinfo table
$query = "
CREATE TABLE `".$dbprefix1."squadinfo` (
`id` smallint(255) NOT NULL auto_increment,
`creator` int(11) NOT NULL default '0',
`datecreated` int(255) NOT NULL default '0',
`squadname` varchar(255) NOT NULL default '',
`description` text NOT NULL,
`rankings` text NOT NULL,
`status` int(11) NOT NULL default '0',
`website` varchar(255) NOT NULL default 'http://',
`logo` text NOT NULL,
PRIMARY KEY (`id`)
) AUTO_INCREMENT=1 ;
";
$result = mysql_query($query)
or die(mysql_error());
// CREATE squadmembers table
$query = "
CREATE TABLE `".$dbprefix1."squadmembers` (
`id` smallint(255) NOT NULL auto_increment,
`memberid` int(255) NOT NULL default '0',
`squad` int(255) NOT NULL default '0',
`rank` varchar(255) NOT NULL default '',
`datejoined` int(11) NOT NULL default '0',
`status` int(2) NOT NULL default '0',
`manager` int(2) NOT NULL default '0',
PRIMARY KEY (`id`)
) AUTO_INCREMENT=1 ;
";
$result = mysql_query($query)
or die(mysql_error());
// CREATE tournaments table
$query = "
CREATE TABLE `".$dbprefix1."tournaments` (
`id` smallint(255) NOT NULL auto_increment,
`prize` varchar(255) NOT NULL default '',
`winner` varchar(255) NOT NULL default '',
`host` int(255) NOT NULL default '0',
`name` varchar(255) NOT NULL default '',
`date` varchar(255) NOT NULL default '',
`time` varchar(255) NOT NULL default '',
`game` varchar(255) NOT NULL default '',
`access` varchar(255) NOT NULL default '',
`totalplayers` int(255) NOT NULL default '0',
`status` int(255) NOT NULL default '0',
`rules` text NOT NULL,
`info` text NOT NULL,
`round1` text NOT NULL,
`round2` text NOT NULL,
`round3` text NOT NULL,
`round4` text NOT NULL,
`round5` text NOT NULL,
PRIMARY KEY (`id`)
) AUTO_INCREMENT=1 ;
";
$result = mysql_query($query)
or die(mysql_error());
// CREATE wsinfo table
$query = "
CREATE TABLE `".$dbprefix1."wsinfo` (
`id` smallint(255) NOT NULL auto_increment,
`adminuser` varchar(255) NOT NULL default '',
`adminpass` varchar(255) NOT NULL default '',
`websiteurl` varchar(255) NOT NULL default '',
`clanname` varchar(255) NOT NULL default '',
`tag` varchar(255) NOT NULL default '',
`backgroundcolor` varchar(255) NOT NULL default 'black',
`bordercolor` varchar(255) NOT NULL default '#000033',
`mostdsl` varchar(255) NOT NULL default '8',
`lowdslcolor` varchar(255) NOT NULL default 'lime',
`mediumdslcolor` varchar(255) NOT NULL default 'yellow',
`highdslcolor` varchar(255) NOT NULL default 'red',
`inactivecolor` varchar(255) NOT NULL default 'gray',
`nodslcolor` varchar(255) NOT NULL default 'white',
`logourl` varchar(255) NOT NULL default 'themes/extendeddarkblue/images/logo.jpg',
`newsticker` varchar(255) NOT NULL default 'Welcome to the Website!',
`newstickercolor` varchar(255) NOT NULL default 'lightblue',
`theme` varchar(255) NOT NULL default 'extendeddarkblue',
`rules` text NOT NULL,
`history` text NOT NULL,
`hits` int(255) NOT NULL default '0',
`mostmembersdate` varchar(255) NOT NULL default '0',
`mostmembers` int(255) NOT NULL default '0',
`securitylevel` int(2) NOT NULL default '0',
`recruiting` int(2) NOT NULL default '0',
`failedlogins` int(11) NOT NULL default '0',
`motm` varchar(255) NOT NULL default '',
`todaydate` varchar(255) NOT NULL default '',
`reqdiplomacycount` int(255) NOT NULL default '3',
`maxdiplomacyreq` int(255) NOT NULL default '10',
`forumurl` text NOT NULL,
`musicplayer` varchar(255) NOT NULL default 'new',
`installed` int(11) NOT NULL default '0',
PRIMARY KEY (`id`)
) AUTO_INCREMENT=3 ;
";
$result = mysql_query($query)
or die(mysql_error());
$query = "INSERT INTO `".$dbprefix1."wsinfo` VALUES (1, '', '', '', '".$clanname1."', '".$clantag1."', 'black', '#000033', '8', 'lime', 'yellow', 'red', 'gray', 'white', 'themes/extendeddarkblue/images/logo.jpg', 'Welcome to the Website!', 'lightblue', 'extendeddarkblue', '', '', 0, '0', 0, 0, 0, 0, '', '', 3, 10, '', 'new', 0);";
$result = mysql_query($query)
or die(mysql_error());
echo "
Database Tables Created
Installation Completed Successfully!
Admin Section Information:
Username: $user1
Password: $pass1
Make sure to remember this information as you will not be able to change it unless you change it manually through the database. It is also suggested that you rename the admin folder for more security.
Clan Site Information:
Username: Webmaster
Password: 12345
Make sure that you delete this file to prevent your website from being hacked. You may also delete the install folder.
Go to your Clan Site
";
}
elseif($submit AND ($dbhost1 == "" OR $dbname1 == "" OR $dbuser1 == "" OR $clanname1 == "")) {
echo "
There was an error in your submission. You either forgot to give a required field
Go Back
";
}
elseif(!$submit) {
echo "
Please fill out the form below to install your website. All fields are required except for database table prefix and clan tag. Make sure that you created a database before continuing with the installation. The installation will create the database tables for you. Make sure to correctly fill out the config file before installing.
";
}
echo "
|
