= 1) { if (!@mysql_connect($sql["hostname"],$sql["username"],$sql["password"])) { printHeader($installversion . " Installation"); ?>
 Error
Database Connection could not be established.

Please go back and verify your database data.
gettables(); } } // #################################### WELCOME ######################################## if (!isset($step)) { printHeader($installversion . " Installation"); ?>
 Welcome to the Virtual War Installation


 Click here to start the installation!


 We recommend to backup existing databases! 
 Check Environment

System Requirements
Property Required Available
PHP Version 4.0.4 "> " align="top" alt="">
upload_max_filesize > 0 "> " align="top" alt="">
Folder "backup" writable Yes "> " align="top" alt="">
Folder "upload" writable Yes "> " align="top" alt="">
Folder "includes/language" writable Yes "> " align="top" alt="">
Folder "images/gameicons" writable Yes "> " align="top" alt="">
Folder "images/screen" writable Yes "> " align="top" alt="">
Folder "images/member" writable Yes "> " align="top" alt="">
Folder "images/locations" writable Yes "> " align="top" alt="">
Folder "images/smilies" writable Yes "> " align="top" alt="">
File "includes/_config.inc.php" writable Yes "> " align="top" alt="">
File "vwarcard.dat" writable Yes "> " align="top" alt="">

Make sure that all requirements are fulfilled!

 Click here to start the installation!
 Error

Database Connection could not be established.

Please go back and verify your database data
'; fwrite($fp,$config,strlen($config)); fclose($fp); header("Location: " . $installfile . "?step=1"); exit(); } printHeader($installversion . " Installation"); ?>
 Configuration
Current Configuration
Database Server " class="input">
Database User " class="input">
Database Password " class="input">
Database Name " class="input">
Number of VWar-Installation
if there's already an existing installation of vwar
please enter a prefix which will signify this installation
 

 if you already configured "_config.inc.php" by hand, you can skip this step here.
num_rows($result)) header("Location: ".$installfile."?step=4"); else { printHeader($installversion . " Installation"); ?>
 Database Maintenance


The database "" is not empty!

You can install VWar on a non-clean database,
but we recommend an installation on a clean database.

If you like to accomplish a multiple installation,
please enter the appropriate number in the  previous step ("Number of Virtual War Installation").

 Click here to continue the installation!

or

 Click here to empty the database!
this option will delete ALL TABLES in your database!
query("DROP TABLE " . mysql_tablename($result, $i)); } printHeader($installversion . " Installation"); ?>
 Database Maintenance


The Database "" has been cleared successfully!

 Click here to continue the installation!
 Database Maintenance


There are already existing tables with the same name as the installation will create.
This tables will be overwritten if you continue!

 Click here to continue the installation!
query("DROP TABLE ".mysql_tablename($result, $i)); } } printHeader($installversion . " Installation"); $vwardb->query("CREATE TABLE vwar".$n." ( warid smallint(5) unsigned NOT NULL auto_increment, gametypeid smallint(5) NOT NULL default '0', matchtypeid smallint(5) NOT NULL default '0', gameid smallint(5) NOT NULL default '0', mailgroupid smallint(5) NOT NULL default '0', report text NOT NULL, publicreport smallint(5) NOT NULL default '1', ownplayers text NOT NULL, opplayers text NOT NULL, oppid smallint(5) NOT NULL default '0', serverid smallint(5) NOT NULL default '0', playerperteam tinyint(2) default NULL, serverpassword varchar(100) NOT NULL default '', info text NOT NULL, publicinfo smallint(5) NOT NULL default '1', resultbylocations smallint(1) NOT NULL default '0', status smallint(1) NOT NULL default '0', dateline int(11) NOT NULL default '0', repeat_mod varchar(6) NOT NULL default '', repeat_number varchar(10) NOT NULL default '', repeat_saveas smallint(1) NOT NULL default '0', addedby smallint(5) NOT NULL default '0', addedtime int(11) NOT NULL default '0', changedby smallint(5) NOT NULL default '0', changedtime int(11) NOT NULL default '0', PRIMARY KEY (warid) ) TYPE=MyISAM;"); $tblcount++; $vwardb->query("CREATE TABLE vwar".$n."_accessgroup ( accessgroupid smallint(5) NOT NULL auto_increment, accessgroupname varchar(100) NOT NULL default '', canaddwar smallint(1) NOT NULL default '0', caneditwar smallint(1) NOT NULL default '0', canfinishwar smallint(1) NOT NULL default '0', candeletewar smallint(1) NOT NULL default '0', canaddmember smallint(1) NOT NULL default '0', caneditmember smallint(1) NOT NULL default '0', candeletemember smallint(1) NOT NULL default '0', canaddstatus smallint(1) NOT NULL default '0', caneditstatus smallint(1) NOT NULL default '0', candeletestatus smallint(1) NOT NULL default '0', canaddprofilefield smallint(1) NOT NULL default '0', caneditprofilefield smallint(1) NOT NULL default '0', candeleteprofilefield smallint(1) NOT NULL default '0', canaddmailgroup smallint(1) NOT NULL default '0', caneditmailgroup smallint(1) NOT NULL default '0', candeletemailgroup smallint(1) NOT NULL default '0', cansendmembermail smallint(1) NOT NULL default '0', canaddteam smallint(1) NOT NULL default '0', caneditteam smallint(1) NOT NULL default '0', candeleteteam smallint(1) NOT NULL default '0', canaddcash smallint(1) NOT NULL default '0', caneditcash smallint(1) NOT NULL default '0', candeletecash smallint(1) NOT NULL default '0', canaddcashcategory smallint(1) NOT NULL default '0', caneditcashcategory smallint(1) NOT NULL default '0', candeletecashcategory smallint(1) NOT NULL default '0', canaddevent smallint(1) NOT NULL default '0', caneditevent smallint(1) NOT NULL default '0', candeleteevent smallint(1) NOT NULL default '0', canaddserver smallint(1) NOT NULL default '0', caneditserver smallint(1) NOT NULL default '0', candeleteserver smallint(1) NOT NULL default '0', canaddgametype smallint(1) NOT NULL default '0', caneditgametype smallint(1) NOT NULL default '0', candeletegametype smallint(1) NOT NULL default '0', canaddmatchtype smallint(1) NOT NULL default '0', caneditmatchtype smallint(1) NOT NULL default '0', candeletematchtype smallint(1) NOT NULL default '0', canaddgame smallint(1) NOT NULL default '0', caneditgame smallint(1) NOT NULL default '0', candeletegame smallint(1) NOT NULL default '0', canaddlocation smallint(1) NOT NULL default '0', caneditlocation smallint(1) NOT NULL default '0', candeletelocation smallint(1) NOT NULL default '0', canmanagecomments smallint(1) NOT NULL default '0', canaddnews smallint(1) NOT NULL default '0', caneditnews smallint(1) NOT NULL default '0', candeletenews smallint(1) NOT NULL default '0', canaddcategory smallint(1) NOT NULL default '0', caneditcategory smallint(1) NOT NULL default '0', candeletecategory smallint(1) NOT NULL default '0', canaddpermission smallint(1) NOT NULL default '0', caneditpermission smallint(1) NOT NULL default '0', candeletepermission smallint(1) NOT NULL default '0', caneditmemberpermission smallint(1) NOT NULL default '0', canaccessbackup smallint(1) NOT NULL default '0', isadmin smallint(1) NOT NULL default '0', PRIMARY KEY (accessgroupid) ) TYPE=MyISAM;"); $tblcount++; $vwardb->query("CREATE TABLE vwar".$n."_acpmenugroups ( `groupid` int(10) unsigned NOT NULL auto_increment, `groupname` varchar(20) NOT NULL default '', `grouptitle` varchar(50) NOT NULL default '', `condition` text NOT NULL, `conditiontype` enum('OR','AND') NOT NULL default 'OR', `displayorder` smallint(5) NOT NULL default '0', PRIMARY KEY (groupid) ) TYPE=MyISAM;"); $tblcount++; $vwardb->query("CREATE TABLE vwar".$n."_acpmenuitems ( `itemid` int(10) unsigned NOT NULL auto_increment, `groupid` int(11) NOT NULL default '0', `itemtype` enum('LINE','BREAK') NOT NULL default 'LINE', `itemtitle` varchar(50) NOT NULL default '', `destination` varchar(255) NOT NULL default '', `condition` text NOT NULL, `conditiontype` enum('OR','AND') NOT NULL default 'OR', `displayorder` smallint(5) NOT NULL default '0', PRIMARY KEY (itemid) ) TYPE=MyISAM;"); $tblcount++; $vwardb->query("CREATE TABLE vwar".$n."_bbcode ( bbcodeid INT( 11 ) NOT NULL auto_increment, code VARCHAR( 250 ) NOT NULL, replacement TEXT NOT NULL, usefunction VARCHAR( 255 ) NOT NULL, simplecode SMALLINT( 1 ) NOT NULL, params SMALLINT( 1 ) NOT NULL, help VARCHAR( 250 ) NOT NULL, displayorder SMALLINT( 5 ) NOT NULL DEFAULT '0', deleted SMALLINT ( 2 ) NOT NULL DEFAULT '0', PRIMARY KEY (bbcodeid) ) TYPE=MyISAM;"); $tblcount++; $vwardb->query("CREATE TABLE vwar".$n."_calendarevents ( eventid int(11) NOT NULL auto_increment, memberid smallint(5) NOT NULL default '0', event varchar(100) NOT NULL default '', eventdetails text NOT NULL, eventdate int(11) NOT NULL default '0', enddate int(11) NOT NULL default '0', eventadded int(11) NOT NULL default '0', deleted tinyint(4) NOT NULL default '0', PRIMARY KEY (eventid) ) TYPE=MyISAM;"); $tblcount++; $vwardb->query("CREATE TABLE vwar".$n."_cash ( cashid smallint(5) unsigned NOT NULL auto_increment, purpose varchar(100) NOT NULL default '', catid smallint(5) NOT NULL default '0', amount double NOT NULL default '0', bookingdate date NOT NULL default '0000-00-00', deleted smallint(1) NOT NULL default '0', PRIMARY KEY (cashid) ) TYPE=MyISAM;"); $tblcount++; $vwardb->query("CREATE TABLE vwar".$n."_cashcat ( catid smallint(5) unsigned NOT NULL auto_increment, catname varchar(100) NOT NULL default '', PRIMARY KEY (catid) ) TYPE=MyISAM;"); $tblcount++; $vwardb->query("CREATE TABLE vwar".$n."_challenge ( challengeid int(11) NOT NULL auto_increment, gameid smallint(5) NOT NULL default '0', gametypeid smallint(5) NOT NULL default '0', matchtypeid smallint(5) NOT NULL default '0', teamname varchar(150) NOT NULL default '', teamnameshort varchar(20) NOT NULL default '', contactname varchar(100) NOT NULL default '', contactemail varchar(255) NOT NULL default '', contacticq varchar(30) NOT NULL default '', contactaim varchar(30) NOT NULL default '', contactyim varchar(30) NOT NULL default '', contactmsn varchar(30) NOT NULL default '', contacthomepage varchar(255) NOT NULL default '', contactircnetwork varchar(50) NOT NULL default '', contactircchannel varchar(50) NOT NULL default '', playerperteam tinyint(2) default NULL, locations varchar(50) NOT NULL default '', challengeinfo text NOT NULL, dateline int(11) NOT NULL default '0', deleted tinyint(4) NOT NULL default '0', PRIMARY KEY (challengeid) ) TYPE=MyISAM;"); $tblcount++; $vwardb->query("CREATE TABLE vwar".$n."_comments ( commentid smallint(5) unsigned NOT NULL auto_increment, frompage varchar(10) NOT NULL default 'war', sourceid smallint(5) NOT NULL default '0', memberid smallint(5) NOT NULL default '0', iconid smallint(5) NOT NULL default '0', guestname varchar(50) NOT NULL default '', guestemail varchar(100) NOT NULL default '', guesthomepage varchar(100) NOT NULL default '', guesticq varchar(30) NOT NULL default '', guestyim varchar(30) NOT NULL default '', guestmsn varchar(30) NOT NULL default '', guestaim varchar(30) NOT NULL default '', ip varchar(20) NOT NULL default '', title varchar(255) NOT NULL default '', comment text NOT NULL, editdateline int(11) NOT NULL default '0', editmemberid smallint(5) NOT NULL default '0', dateline int(11) NOT NULL default '0', PRIMARY KEY (commentid) ) TYPE=MyISAM;"); $tblcount++; $vwardb->query("CREATE TABLE vwar".$n."_customlanguage ( languageid int(10) unsigned NOT NULL auto_increment, languagename varchar(30) NOT NULL default '', languagetitle varchar(50) NOT NULL default '', PRIMARY KEY (languageid) ) TYPE=MyISAM;"); $tblcount++; $vwardb->query("CREATE TABLE vwar".$n."_emailgroup ( groupid int(10) unsigned NOT NULL auto_increment, groupname varchar(100) NOT NULL default '', PRIMARY KEY (groupid) ) TYPE=MyISAM;"); $tblcount++; $vwardb->query("CREATE TABLE vwar".$n."_emailgroupmember ( groupmemberid smallint(5) unsigned NOT NULL auto_increment, groupid smallint(5) NOT NULL DEFAULT '0', teamid smallint(5) NOT NULL DEFAULT '0', PRIMARY KEY (groupmemberid) ) TYPE=MyISAM;"); $tblcount++; $vwardb->query("CREATE TABLE vwar".$n."_games ( gameid smallint(5) unsigned NOT NULL auto_increment, gamename varchar(100) NOT NULL default '', gamenameshort varchar(10) NOT NULL default '', gameicon varchar(100) NOT NULL default '', deleted smallint(1) NOT NULL default '0', PRIMARY KEY (gameid) ) TYPE=MyISAM;"); $tblcount++; $vwardb->query("CREATE TABLE vwar".$n."_gametype ( gametypeid smallint(5) unsigned NOT NULL auto_increment, gametypename varchar(100) NOT NULL default '', deleted smallint(1) NOT NULL default '0', PRIMARY KEY (gametypeid) ) TYPE=MyISAM;"); $tblcount++; $vwardb->query("CREATE TABLE vwar".$n."_join ( joinid int(11) NOT NULL auto_increment, gameid smallint(5) NOT NULL default '0', gametypeid smallint(5) NOT NULL default '0', contactname varchar(100) NOT NULL default '', contactemail varchar(255) NOT NULL default '', contacticq varchar(30) NOT NULL default '', contactaim varchar(30) NOT NULL default '', contactyim varchar(30) NOT NULL default '', contactmsn varchar(30) NOT NULL default '', contactircnetwork varchar(50) NOT NULL default '', contactircchannel varchar(50) NOT NULL default '', contactlocation varchar(100) NOT NULL default '', contactcountry varchar(3) NOT NULL default '', contactbirthday date NOT NULL default '0000-00-00', joininfo text NOT NULL, dateline int(11) NOT NULL default '0', deleted tinyint(4) NOT NULL default '0', PRIMARY KEY (joinid) ) TYPE=MyISAM;"); $tblcount++; $vwardb->query("CREATE TABLE vwar".$n."_locations ( locationid smallint(5) unsigned NOT NULL auto_increment, locationname varchar(100) NOT NULL default '', locationpic varchar(100) NOT NULL default '', gameid smallint(5) NOT NULL default '0', deleted smallint(1) NOT NULL default '0', PRIMARY KEY (locationid) ) TYPE=MyISAM;"); $tblcount++; $vwardb->query("CREATE TABLE vwar".$n."_matchtype ( matchtypeid smallint(5) unsigned NOT NULL auto_increment, matchtypename varchar(100) NOT NULL default '', matchtypeurl varchar(255) NOT NULL default '', public smallint(5) NOT NULL default '1', deleted smallint(1) NOT NULL default '0', PRIMARY KEY (matchtypeid) ) TYPE=MyISAM;"); $tblcount++; $vwardb->query("CREATE TABLE vwar".$n."_member ( memberid int(11) NOT NULL auto_increment, accessgroupid smallint(5) unsigned NOT NULL default '0', name varchar(100) NOT NULL default '', realname varchar(255) NOT NULL default '', birthday date NOT NULL default '0000-00-00', location varchar(100) NOT NULL default '', country char(3) NOT NULL default '', email varchar(255) NOT NULL default '', homepage VARCHAR(150) NOT NULL default '', icq varchar(30) NOT NULL default '', aim varchar(30) NOT NULL default '', yim varchar(30) NOT NULL default '', msn varchar(30) NOT NULL default '', password varchar(32) NOT NULL default '', forgotpw int(11) NOT NULL, customstatus varchar(150) NOT NULL default '', status smallint(2) NOT NULL default '0', language varchar(25) NOT NULL default '', picture VARCHAR(255) NOT NULL default '', ismember SMALLINT(1) NOT NULL default '1', hidemember SMALLINT(1) NOT NULL default '0', signature text NOT NULL default '', lastactivity INT(10) NOT NULL default '0', PRIMARY KEY (memberid) ) TYPE=MyISAM;"); $tblcount++; $vwardb->query("CREATE TABLE vwar".$n."_memberlocation ( memberlocationid int(5) unsigned NOT NULL auto_increment, memberid int(11) NOT NULL default '0', membergameid smallint(5) NOT NULL default '0', locationid smallint(5) NOT NULL default '0', comment varchar(100) NOT NULL default '', PRIMARY KEY (memberlocationid) ) TYPE=MyISAM;"); $tblcount++; $vwardb->query("CREATE TABLE vwar".$n."_memberprofilefield ( memberprofilefieldid int(5) unsigned NOT NULL auto_increment, memberid smallint(5) NOT NULL default '0', profilefieldid smallint(5) NOT NULL default '0', fieldvalue text NOT NULL, PRIMARY KEY (memberprofilefieldid) ) TYPE=MyISAM;"); $tblcount++; $vwardb->query("CREATE TABLE vwar".$n."_memberstatus ( statusid smallint(5) unsigned NOT NULL auto_increment, statusname varchar(100) NOT NULL default '', displayorder smallint(5) NOT NULL default '0', deleted smallint(1) NOT NULL default '0', PRIMARY KEY (statusid) ) TYPE=MyISAM;"); $tblcount++; $vwardb->query("CREATE TABLE vwar".$n."_membergames ( membergamesid int(5) unsigned NOT NULL auto_increment, memberid smallint(5) NOT NULL default '0', gameid smallint(5) NOT NULL default '0', PRIMARY KEY (membergamesid) ) TYPE=MyISAM;"); $tblcount++; $vwardb->query("CREATE TABLE vwar".$n."_news ( newsid smallint(5) unsigned NOT NULL auto_increment, catid smallint(5) NOT NULL default '0', title varchar(255) NOT NULL default '0', memberid smallint(5) NOT NULL default '0', content text NOT NULL, convertsmilies smallint(1) NOT NULL default '1', converturls smallint(1) NOT NULL default '1', allowcomments smallint(1) NOT NULL default '1', submitname varchar(255) NOT NULL default '', submitinfo varchar(255) NOT NULL default '', dateline int(11) NOT NULL default '0', activated smallint(5) NOT NULL default '1', PRIMARY KEY (newsid), UNIQUE KEY id_2 (newsid), KEY id (newsid) ) TYPE=MyISAM;"); $tblcount++; $vwardb->query("CREATE TABLE vwar".$n."_newscat ( catid smallint(5) unsigned NOT NULL auto_increment, catname varchar(100) NOT NULL default '', caticon varchar(100) NOT NULL default '', intern smallint(1) NOT NULL default '0', deleted smallint(5) NOT NULL default '0', PRIMARY KEY (catid) ) TYPE=MyISAM;"); $tblcount++; $vwardb->query("CREATE TABLE vwar".$n."_newslink ( linkid smallint(5) unsigned NOT NULL auto_increment, newsid smallint(5) NOT NULL default '0', title varchar(255) NOT NULL default '', url varchar(255) NOT NULL default '', target varchar(10) NOT NULL default'_blank', deleted smallint(5) NOT NULL default '0', PRIMARY KEY (linkid) ) TYPE=MyISAM;"); $tblcount++; $vwardb->query("CREATE TABLE vwar".$n."_newssettings ( usemore smallint(1) NOT NULL default '1', moresign varchar(20) NOT NULL default '-more-', standardcatpublic smallint(5) NOT NULL default '0', standardcatintern smallint(5) NOT NULL default '0', newsperpage smallint(3) NOT NULL default '10', allowsendafriend smallint(1) NOT NULL default '1', allowsubmit smallint(1) NOT NULL default '1', newsstatus smallint(1) NOT NULL default '1', newsstatusmessage text NOT NULL, showticker smallint(1) NOT NULL default '1' ) TYPE=MyISAM;"); $tblcount++; $vwardb->query("CREATE TABLE vwar".$n."_opponents ( oppid smallint(5) unsigned NOT NULL auto_increment, oppnameshort varchar(20) NOT NULL default '', oppname varchar(255) NOT NULL default '', oppcontactname varchar(100) NOT NULL default '', oppcontactmail varchar(100) NOT NULL default '', oppcontacticq varchar(30) NOT NULL default '', oppcontactaim varchar(30) NOT NULL default '', oppcontactyim varchar(30) NOT NULL default '', oppcontactmsn varchar(30) NOT NULL default '', oppircchannel varchar(50) NOT NULL default '', oppircnetwork varchar(50) NOT NULL default '', opphomepage varchar(255) NOT NULL default '', oppcountry char(3) NOT NULL default '', deleted smallint(1) NOT NULL default '0', PRIMARY KEY (oppid) ) TYPE=MyISAM;"); $tblcount++; $vwardb->query("CREATE TABLE vwar".$n."_participants ( partid smallint(5) unsigned NOT NULL auto_increment, memberid smallint(5) NOT NULL default '0', warid smallint(5) NOT NULL default '0', comment mediumtext NOT NULL, available smallint(1) NOT NULL default '0', dateline int(11) NOT NULL default '0', PRIMARY KEY (partid) ) TYPE=MyISAM;"); $tblcount++; $vwardb->query("CREATE TABLE vwar".$n."_pfield_cat ( pcat_id smallint(5) unsigned NOT NULL auto_increment, catname char(50) NOT NULL default '', description char(250) NOT NULL default '', displayorder smallint(6) NOT NULL default '0', PRIMARY KEY (pcat_id) ) TYPE=MyISAM;"); $tblcount++; $vwardb->query("CREATE TABLE vwar".$n."_profilefield ( profilefieldid smallint(5) unsigned NOT NULL auto_increment, fieldname char(50) NOT NULL default '', description char(250) NOT NULL default '', public smallint(6) NOT NULL default '0', displayorder smallint(6) NOT NULL default '0', adminonly smallint(6) NOT NULL default '0', smiliecode smallint(6) NOT NULL default '0', htmlcode smallint(6) NOT NULL default '0', bbcode smallint(6) NOT NULL default '0', allowimages smallint(6) NOT NULL default '0', fieldlength smallint(6) NOT NULL default '100', cat_id smallint(6) NOT NULL default '0', PRIMARY KEY (profilefieldid) ) TYPE=MyISAM;"); $tblcount++; $vwardb->query("CREATE TABLE vwar".$n."_replacement ( replacementid smallint(5) unsigned NOT NULL auto_increment, findword text NOT NULL, replaceword text NOT NULL, PRIMARY KEY (replacementid) ) TYPE=MyISAM;"); $tblcount++; $vwardb->query("CREATE TABLE vwar".$n."_scores ( scoreid smallint(5) unsigned NOT NULL auto_increment, warid smallint(5) NOT NULL default '0', screenid smallint(5) NOT NULL default '0', locationid smallint(5) NOT NULL default '0', ownscore bigint(5) NOT NULL default '0', oppscore bigint(5) NOT NULL default '0', deleted smallint(1) NOT NULL default '0', PRIMARY KEY (scoreid) ) TYPE=MyISAM;"); $tblcount++; $vwardb->query("CREATE TABLE vwar".$n."_screen ( screenid smallint(5) unsigned NOT NULL auto_increment, scoreid smallint(5) NOT NULL default '0', locationid smallint(5) NOT NULL default '0', warid smallint(5) NOT NULL default '0', filename varchar(100) NOT NULL default '', PRIMARY KEY (screenid) ) TYPE=MyISAM;"); $tblcount++; $vwardb->query("CREATE TABLE vwar".$n."_search ( searchid smallint(5) UNSIGNED NOT NULL auto_increment, keyword varchar(255) NOT NULL default '', username varchar(255) NOT NULL default '', highlite varchar(255) NOT NULL default '', searchwhere varchar(150) NOT NULL default '', searchin varchar(150) NOT NULL default '', sort varchar(100) NOT NULL default '', daterestriction varchar(30) NOT NULL default '', searchclause text NOT NULL, lastactivity int(11), PRIMARY KEY (searchid) ) TYPE=MyISAM;"); $tblcount++; $vwardb->query("CREATE TABLE vwar".$n."_server ( serverid smallint(5) unsigned NOT NULL auto_increment, servername varchar(255) NOT NULL default '', serverip varchar(25) NOT NULL default '', deleted smallint(1) NOT NULL default '0', PRIMARY KEY (serverid) ) TYPE=MyISAM;"); $tblcount++; $vwardb->query("CREATE TABLE vwar".$n."_settings ( ownname varchar(250) NOT NULL default 'My Team', ownnameshort varchar(50) NOT NULL default '-{MT}-', ownhomepage varchar(250) NOT NULL default 'http://www.yourdomain.com', ownmail varchar(100) NOT NULL default 'yourmail@yourdomain.com', urltovwar varchar(250) NOT NULL default 'http://www.yourdomain.com/vwar/', cookiedomain varchar(100) NOT NULL default '', cookiepath varchar(100) NOT NULL default '', showlegend smallint(1) NOT NULL default '1', showquickjump tinyint(1) NOT NULL default '1', showwarnav tinyint(1) NOT NULL default '1', showrealresults smallint(1) NOT NULL default '1', showcoloredresults smallint(1) NOT NULL default '0', showcountry smallint(1) NOT NULL default '0', deleteparticipants smallint(1) NOT NULL default '0', showgameicons smallint(1) NOT NULL default '0', showreport smallint(1) NOT NULL default '1', smiliecode smallint(1) NOT NULL default '1', htmlcode smallint(1) NOT NULL default '1', bbcode smallint(1) NOT NULL default '1', whoisonline smallint(1) NOT NULL default '1', formmailer smallint(1) NOT NULL default '1', allowmails smallint(1) NOT NULL default '1', guestcomments smallint(1) NOT NULL default '0', censor smallint(1) NOT NULL default '1', censorwords text NOT NULL, censorsign varchar(10) NOT NULL default '*', censorformembers smallint(1) NOT NULL default '0', sendwarmail smallint(1) NOT NULL default '1', warmailhtml smallint(5) NOT NULL default '0', warmailsubjectnew varchar(100) NOT NULL default 'New War added!', warmailsubjectchanged varchar(100) NOT NULL default 'War changed!', warmailpriority smallint(5) NOT NULL default '3', maintablewidth varchar(5) NOT NULL default '95%', screenshotwidth smallint(4) NOT NULL default '1024', screenshotheight smallint(4) NOT NULL default '768', thumbnailwidth smallint(4) NOT NULL default '150', thumbnailheight smallint(4) NOT NULL default '150', favpermember smallint(3) NOT NULL default '3', favperline smallint(3) NOT NULL default '3', nomemberpic varchar(100) NOT NULL default '', colorwon varchar(7) NOT NULL default '#00E000', colorlost varchar(7) NOT NULL default '#F00000', colordraw varchar(7) NOT NULL default '#A0A0A0', textwon varchar(100) NOT NULL default 'Won', textlost varchar(100) NOT NULL default 'Lost', textdraw varchar(100) NOT NULL default 'Draw', waroverlap smallint(10) NOT NULL default '0', timezoneoffset varchar(4) NOT NULL default '0', timezoneoffsetuser VARCHAR( 4 ) DEFAULT '0' NOT NULL, timeformat smallint(1) NOT NULL default '1', shortdateformat varchar(30) NOT NULL default 'd.m.Y', longdateformat varchar(30) NOT NULL default 'd.m.Y H:i', startofweek smallint(1) NOT NULL default '1', perpage smallint(5) NOT NULL default '15', moneysymbol varchar(5) NOT NULL default 'EUR', deletedwars smallint(5) NOT NULL default '0', challengeenabled smallint(5) NOT NULL default '1', joinenabled smallint(5) NOT NULL default '1', vwarlanguage varchar(25) NOT NULL default 'english', ab_enabled tinyint(4) NOT NULL default '0', ab_user mediumtext NOT NULL, ab_days varchar(7) NOT NULL default '', ab_fallback int(11) NOT NULL default '48', ab_tables char(1) NOT NULL default 'v', ab_deloldfiles tinyint(4) NOT NULL default '0', gzip smallint(1) NOT NULL default '0', showsignature smallint(1) NOT NULL default '0', vwarversion varchar(10) NOT NULL default '$installversion' ) TYPE=MyISAM;"); $tblcount++; $vwardb->query("CREATE TABLE vwar".$n."_smilie ( smilieid smallint(5) unsigned NOT NULL auto_increment, title char(100) NOT NULL default '', code char(25) NOT NULL default '', filename char(100) NOT NULL default '', smilie smallint(1) NOT NULL default '1', icon smallint(1) NOT NULL default '0', deleted tinyint(4) NOT NULL default '0', PRIMARY KEY (smilieid) ) TYPE=MyISAM;"); $tblcount++; $vwardb->query("CREATE TABLE vwar".$n."_team ( teamid smallint(5) unsigned NOT NULL auto_increment, teamname varchar(100) NOT NULL default '', displayorder smallint(5) NOT NULL default '0', invisible smallint(1) NOT NULL default '0', deleted smallint(1) NOT NULL default '0', PRIMARY KEY (teamid) ) TYPE=MyISAM;"); $tblcount++; $vwardb->query("CREATE TABLE vwar".$n."_teammember ( teammemberid smallint(5) unsigned NOT NULL auto_increment, memberid smallint(5) NOT NULL default '0', teamid smallint(5) NOT NULL default '0', deleted smallint(1) NOT NULL default '0', PRIMARY KEY (teammemberid) ) TYPE=MyISAM;"); $tblcount++; $vwardb->query("CREATE TABLE vwar".$n."_template ( templateid smallint(5) unsigned NOT NULL auto_increment, templatename varchar(100) NOT NULL default '', template mediumtext NOT NULL, isspecial smallint(1) NOT NULL default '0', isinactive smallint(5) NOT NULL default '0', PRIMARY KEY (templateid) ) TYPE=MyISAM;"); $tblcount++; $vwardb->query("CREATE TABLE vwar".$n."_quickjump ( quickjumpid int(10) unsigned NOT NULL auto_increment, title varchar(70) NOT NULL default '', redirectto varchar(150) NOT NULL default '', displayorder int(11) NOT NULL default '0', activated smallint(1) NOT NULL default '1', PRIMARY KEY (quickjumpid) ) TYPE=MyISAM;"); $tblcount++; ?>
 Database Maintenance


All tables () have been created successfully!

 Click here to continue the installation!
query("INSERT INTO vwar".$n."_accessgroup VALUES ('1', 'Admin', '1', '1', '1', '1', '1', '1', '1', '1', '1', '1', '1', '1', '1', '1', '1', '1', '1', '1', '1', '1', '1', '1', '1', '1', '1', '1', '1', '1', '1', '1', '1', '1', '1', '1', '1', '1', '1', '1', '1', '1', '1', '1', '1', '1', '1', '1', '1', '1', '1', '1', '1', '1', '1', '1', '1', '1', '1')"); $vwardb->query("INSERT INTO vwar".$n."_accessgroup VALUES ('2', 'Treasurer', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '1', '1', '1', '0', '0', '0', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0')"); $vwardb->query("INSERT INTO vwar".$n."_accessgroup VALUES ('3', 'Match Arranger', '1', '1', '1', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '1', '0', '0', '1', '1', '1', '1', '1', '1', '1', '1', '1', '1', '1', '1', '1', '1', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0')"); $vwardb->query("INSERT INTO vwar".$n."_accessgroup VALUES ('4', 'Member', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0')"); $vwardb->query("INSERT INTO vwar".$n."_acpmenugroups VALUES (1, 'war', 'War Admin', 'canaddwar;caneditwar;candeletewar;canfinishwar;canaddserver;caneditserver;candeleteserver;canaddlocation;caneditlocation;candeletelocation;canaddmatchtype;caneditmatchtype;candeletematchtype;canaddgametype;caneditgametype;candeletegametype;canaddgame;caneditgame;candeletegame', 'OR', 0)"); $vwardb->query("INSERT INTO vwar".$n."_acpmenugroups VALUES (2, 'member', 'Member Admin', 'canaddmember;caneditmember;candeletemember;canaddstatus;caneditstatus;candeletestatus;canaddprofilefield;caneditprofilefield;candeleteprofilefield;canaddpermission;caneditpermission;candeletepermission;canaddteam;caneditteam;candeleteteam;canaddmailgroup;caneditmailgroup;candeletemailgroup;cansendmembermail', 'OR', 1)"); $vwardb->query("INSERT INTO vwar".$n."_acpmenugroups VALUES (3, 'calendar', 'Calendar Admin', 'canaddevent;caneditevent;candeleteevent', 'OR', 2)"); $vwardb->query("INSERT INTO vwar".$n."_acpmenugroups VALUES (4, 'cash', 'Cash Admin', '', 'OR', 3)"); $vwardb->query("INSERT INTO vwar".$n."_acpmenugroups VALUES (5, 'news', 'News Admin', 'canaddnews;caneditnews;candeletenews;canaddcategory;caneditcategory;candeletecategory;isadmin', 'OR', 4)"); $vwardb->query("INSERT INTO vwar".$n."_acpmenugroups VALUES (6, 'admin', 'Settings / Admin', 'isadmin', 'OR', 5)"); $vwardb->query("INSERT INTO vwar".$n."_acpmenuitems VALUES (1, 1, 'LINE', 'Add War', 'admin.php?action=addwar', 'canaddwar', 'OR', 0), (2, 1, 'LINE', 'Modify War', 'admin.php?action=warlist', 'caneditwar;candeletewar;canfinishwar', 'OR', 1), (3, 1, 'LINE', 'View Challenges', 'admin.php?action=viewchallenges', 'canaddwar', 'OR', 2), (4, 1, 'BREAK', '', '', '', 'OR', 3), (5, 1, 'LINE', 'Add Opponent', 'admin.php?action=addopponent', 'canaddwar', 'OR', 4), (6, 1, 'LINE', 'Modify Opponent', 'admin.php?action=viewopponents', 'caneditwar;candeletewar;canfinishwar', 'OR', 5), (7, 1, 'BREAK', '', '', '', 'OR', 6), (8, 1, 'LINE', 'Add Server', 'server.php?action=addserver', 'canaddserver', 'OR', 7), (9, 1, 'LINE', 'Modify Server', 'server.php?action=serverlist', 'caneditserver;candeleteserver', 'OR', 8), (10, 1, 'BREAK', '', '', '', 'OR', 9), (11, 1, 'LINE', 'Add Gametype', 'admin.php?action=addgametype', 'canaddgametype', 'OR', 10), (12, 1, 'LINE', 'Modify Gametype', 'admin.php?action=viewgametypes', 'caneditgametype;candeletegametype', 'OR', 11), (13, 1, 'BREAK', '', '', '', 'OR', 12), (14, 1, 'LINE', 'Add Matchtype', 'admin.php?action=addmatchtype', 'canaddmatchtype', 'OR', 13), (15, 1, 'LINE', 'Modify Matchtype', 'admin.php?action=viewmatchtypes', 'caneditmatchtype;candeletematchtype', 'OR', 14), (16, 1, 'BREAK', '', '', '', 'OR', 15), (17, 1, 'LINE', 'Add Game', 'admin.php?action=addgame', 'canaddgame', 'OR', 16), (18, 1, 'LINE', 'Modify Game', 'admin.php?action=viewgames', 'caneditgame;candeletegame', 'OR', 17), (19, 1, 'BREAK', '', '', '', 'OR', 18), (20, 1, 'LINE', 'Add Location', 'admin.php?action=addlocation', 'canaddlocation', 'OR', 19), (21, 1, 'LINE', 'Modify Location', 'admin.php?action=viewlocations', 'caneditlocation;candeletelocation', 'OR', 20), (22, 2, 'LINE', 'Add Member', 'member.php?action=addmember', 'canaddmember', 'OR', 0), (23, 2, 'LINE', 'Modify Member', 'member.php?action=viewmember', 'caneditmember;candeletemember;caneditmemberpermission', 'OR', 1), (24, 2, 'LINE', 'View Joinrequests', 'member.php?action=viewjoin', 'canaddmember', 'OR', 2), (25, 2, 'BREAK', '', '', '', 'OR', 3), (26, 2, 'LINE', 'Add Memberstatus', 'member.php?action=addmemberstatus', 'canaddstatus', 'OR', 4), (27, 2, 'LINE', 'Modify Memberstatus', 'member.php?action=viewstatuslist', 'candeletestatus;caneditstatus', 'OR', 5), (28, 2, 'BREAK', '', '', '', 'OR', 6), (29, 2, 'LINE', 'Add Profilefield', 'profilefields.php?action=addprofilefield', 'canaddprofilefield', 'OR', 7), (30, 2, 'LINE', 'Add Category', 'profilefields.php?action=addprofilefieldcat', 'canaddprofilefield', 'OR', 8), (31, 2, 'LINE', 'Modify Profilefield', 'profilefields.php?action=viewprofilefields', 'caneditprofilefield;candeleteprofilefield', 'OR', 9), (32, 2, 'BREAK', '', '', '', 'OR', 10), (33, 2, 'LINE', 'Add Accessgroup', 'access.php?action=addgroup', 'canaddpermission', 'OR', 11), (34, 2, 'LINE', 'Modify Accessgroup', 'access.php', 'caneditpermission;candeletepermission', 'OR', 12), (35, 2, 'BREAK', '', '', '', 'OR', 13), (36, 2, 'LINE', 'Add Team', 'team.php?action=addteam', 'canaddteam', 'OR', 14), (37, 2, 'LINE', 'Modify Team', 'team.php?action=viewteams', 'caneditteam;candeleteteam', 'OR', 15), (38, 2, 'BREAK', '', '', '', 'OR', 16), (39, 2, 'LINE', 'Add Emailgroup', 'email.php?action=addgroup', 'canaddmailgroup', 'OR', 17), (40, 2, 'LINE', 'Modify Emailgroup', 'email.php?action=viewgroups', 'caneditmailgroup;candeletegroup', 'OR', 18), (41, 2, 'BREAK', '', '', '', 'OR', 19), (42, 2, 'LINE', 'Send Mail', 'email.php?action=mail', 'cansendmembermail', 'OR', 20), (43, 3, 'LINE', 'Add Event', 'calendar.php?action=addevent', 'canaddevent', 'OR', 0), (44, 3, 'LINE', 'Modify Event', 'calendar.php?action=modifycalendar', 'caneditevent;candeleteevent', 'OR', 1), (45, 4, 'LINE', 'Add Cashentry', 'cash.php?action=addcash', 'canaddcash', 'OR', 0), (46, 4, 'LINE', 'Modify Cashentry', 'cash.php?action=cashlist', '', 'OR', 1), (47, 4, 'BREAK', '', '', '', 'OR', 2), (48, 4, 'LINE', 'Add Category', 'cash.php?action=addcategory', 'canaddcashcategory', 'OR', 3), (49, 4, 'LINE', 'Modify Category', 'cash.php?action=viewcategories', 'caneditcashcategory;candeletecashcategory', 'OR', 4), (50, 5, 'LINE', 'Add News', 'news.php?action=add', 'canaddnews', 'OR', 0), (51, 5, 'LINE', 'Modify News', 'news.php', 'caneditnews;candeletenews', 'OR', 1), (52, 5, 'LINE', 'View Submits', 'news.php?action=viewsubmits', 'canaddnews', 'OR', 2), (53, 5, 'BREAK', '', '', '', 'OR', 3), (54, 5, 'LINE', 'Add Category', 'news.php?action=addcategory', 'canaddcategory', 'OR', 4), (55, 5, 'LINE', 'Modify Category', 'news.php?action=viewcategories', 'caneditcategory;candeletecategory', 'OR', 5), (56, 5, 'BREAK', '', '', '', 'OR', 6), (57, 5, 'LINE', 'News Settings', 'news.php?action=settings', 'isadmin', 'OR', 7), (58, 6, 'LINE', 'General Settings', 'settings.php', 'isadmin', 'OR', 0), (59, 6, 'LINE', 'Fonts & Colors', 'style.php?action=edit', 'isadmin', 'OR', 1), (60, 6, 'LINE', 'Contact', 'admin.php?action=contact', 'isadmin', 'OR', 2), (61, 6, 'BREAK', '', '', '', 'OR', 3), (62, 6, 'LINE', 'Add Smilie / Icon', 'admin.php?action=addsmilie', 'isadmin', 'OR', 4), (63, 6, 'LINE', 'Modify Smilies / Icon', 'admin.php?action=viewsmilies', 'isadmin', 'OR', 5), (64, 6, 'BREAK', '', '', '', 'OR', 6), (65, 6, 'LINE', 'Add BB Code', 'bbcode.php?action=addbbcode', 'isadmin', 'OR', 7), (66, 6, 'LINE', 'Modify BB Code', 'bbcode.php?action=viewbbcode', 'isadmin', 'OR', 8), (67, 6, 'LINE', 'Censor', 'bbcode.php?action=censor', 'isadmin', 'OR', 9), (68, 6, 'BREAK', '', '', '', 'OR', 10), (69, 6, 'LINE', 'Add QuickJump', 'customize.php?action=addjump', 'isadmin', 'OR', 11), (70, 6, 'LINE', 'Modify QuickJump', 'customize.php?action=viewjumps', 'isadmin', 'OR', 12), (71, 6, 'BREAK', '', '', '', 'OR', 13), (72, 6, 'LINE', 'Add Template', 'template.php?action=add', 'isadmin', 'OR', 14), (73, 6, 'LINE', 'Modify Template', 'template.php', 'isadmin', 'OR', 15), (74, 6, 'LINE', 'Import Stylefile', 'style.php?action=import', 'isadmin', 'OR', 16), (75, 6, 'LINE', 'Export Stylefile', 'style.php?action=export', 'isadmin', 'OR', 17), (76, 6, 'BREAK', '', '', '', 'OR', 18), (77, 6, 'LINE', 'Optimize Database', 'database.php?action=optimize', 'isadmin', 'OR', 19), (78, 6, 'LINE', 'Import Data', 'database.php?action=import', '', 'OR', 20), (79, 6, 'LINE', 'Export Data', 'database.php?action=export', 'isadmin', 'OR', 21), (80, 6, 'BREAK', '', '', '', 'OR', 22), (81, 6, 'LINE', 'Add Language', 'customize.php?action=addlanguage', 'isadmin', 'OR', 23), (82, 6, 'LINE', 'Modify Language', 'customize.php?action=viewlanguage', 'isadmin', 'OR', 24), (83, 6, 'BREAK', '', '', '', 'OR', 25), (84, 6, 'LINE', 'Add Menu Group', 'customize.php?action=addmenu', 'isadmin', 'OR', 26), (85, 6, 'LINE', 'Add Menu Item', 'customize.php?action=addmenuitem', 'isadmin', 'OR', 27), (86, 6, 'LINE', 'Modify Menu', 'customize.php?action=viewmenu', 'isadmin', 'OR', 28)"); $vwardb->query("INSERT INTO vwar".$n."_bbcode VALUES (1, 'b', '\\\\1', '', 0, 1, '[b]Bold[/b]', 0, 0), (2, 'i', '\\\\1', '', 0, 1, '[i]Italic[/i]', 0, 0), (3, 'u', '\\\\1', '', 0, 1, '[u]Underline[/u]', 0, 0), (4, 'email', '\\\\1', '', 0, 1, '[email]Mail![/email]', 0, 0), (5, 'email', '\\\\3', '', 0, 2, '[email=you@yourdomain.com]VWar Mail[/email]', 0, 0), (6, 'mail', '\\\\1', '', 0, 1, '[mail]Mail![/mail]', 0, 0), (7, 'mail', '\\\\3', '', 0, 2, '[mail=you@yourdomain.com]VWar Mail[/mail]', 0, 0), (8, 'quote', '
Quote:
\\\\1
', '', 0, 1, '[quote]\"Alea iacta est!\"[/quote]', 0, 0), (9, 'code', '
CODE:
{VWAR_BBCODE_FUNCTION_#1}
', 'handle_bbcode_code', 0, 1, '[code]echo \"Hello World!\";[/code]', 0, 0), (10, 'php', '
PHP:
{VWAR_BBCODE_FUNCTION_#1}
', 'handle_bbcode_php', 0, 1, '[php][/php]', 0, 0), (11, 'sql', '
SQL:
{VWAR_BBCODE_FUNCTION_#1}
', 'handle_bbcode_sql', 0, 1, '[sql]LEFT JOIN table ON (row1 = row2)[/sql]', 0, 0), (12, 'html', '
HTML:
{VWAR_BBCODE_FUNCTION_#1}
', 'handle_bbcode_html', 0, 1, '[html]Just a try![/html]', 0, 0), (13, 'list', '{VWAR_BBCODE_FUNCTION_#1}', 'handle_bbcode_list', 0, 1, '[list][*]Point 1[/list]', 0, 0), (14, 'list', '{VWAR_BBCODE_FUNCTION_#1}', 'handle_bbcode_list', 0, 2, '[list=I][*]Point 1[/list]', 0, 0), (15, 'img', '', 'handle_bbcode_img', 0, 1, '[img]http://web8.bmbnet.com/images/vwar_button_blue.gif[/img]', 0, 0), (16, 'c', '©', '', 1, 0, '[c] Copyright!', 0, 0), (17, 'tm', '™', '', 1, 0, '[tm] Trademark!', 0, 0), (18, 'r', '®', '', 1, 0, '[r] Registered!', 0, 0), (19, 'hr', '
', '', 1, 0, '[hr]', 0, 0), (20, 'hr', '
', '', 1, 1, '[hr=red]', 0, 1), (21, 'size', '\\\\3', '', 0, 2, '[size=1]VWar[/size]', 0, 0), (22, 'color', '\\\\3', '', 0, 2, '[color=red]VWar[/color]', 0, 0), (23, 'font', '\\\\3', '', 0, 2, '[font=courier new]VWar[/font]', 0, 0), (24, 'align', '
\\\\3
', '', 0, 2, '[align=justify]This text is justified[/align]', 0, 0), (25, 'center', '
\\\\1
', '', 0, 1, '[center]Center[/center]', 0, 0), (26, 'ftp', '\\\\1', '', 0, 1, '[ftp]ftp://vwar.de[/ftp]', 0, 0), (27, 'mark', '\\\\3', '', 0, 2, '[mark=red]Mark![/mark]', 0, 1), (28, 'marquee', '\\\\4', '', 0, 3, '[marquee=blue,right]Around the World...[/marquee]', 0, 1), (29, 'marquee', '\\\\1', '', 0, 1, '[marquee]...in 80 days[/marquee]', 0, 1), (30, 'tt', '\\\\1', '', 0, 1, '[tt]VWar[/tt]', 0, 0), (31, 'cursor', '\\\\3', '', 0, 2, '[cursor=crosshair]VWar[/cursor]', 0, 1), (32, 'nimg', '', '', 0, 1, '[nimg]../images/vwar_logo.gif[/nimg]', 0, 1), (33, 's', '\\\\1', '', 0, 1, '[s]VWar[/s]', 0, 1), (34, 'glow', '\\\\3', '', 0, 2, '[glow=green]VWar[/glow]', 0, 1), (35, 'bt', '\\\\1', '', 0, 1, '[bt]VWar[/bt]', 0, 1), (36, 'd', '\\\\1', '', 0, 1, '[d]No![/d]', 0, 0), (37, 'sub', '\\\\1', '', 0, 1, '[sub]VWar[/sub]', 0, 0), (38, 'sup', '\\\\1', '', 0, 1, '[sup]VWar[/sup]', 0, 0), (39, 'blink', '\\\\1', '', 0, 1, '[blink]VWar[/blink]', 0, 1), (40, 'url', '\\\\1', '', 0, 1, '[url]http://www.vwar.de[/url]', 0, 0), (41, 'url', '\\\\3', '', 0, 2, '[url=http://www.vwar.de]VWar - Virtual War[/url]', 0, 0)"); $vwardb->query("INSERT INTO vwar".$n."_quickjump VALUES (1, 'Wars', 'war.php', 0, 1)"); $vwardb->query("INSERT INTO vwar".$n."_quickjump VALUES (2, 'Next Actions', 'war.php?action=nextaction', 1, 1)"); $vwardb->query("INSERT INTO vwar".$n."_quickjump VALUES (3, '\$str[STATISTICS]', 'stats.php', 2, 1)"); $vwardb->query("INSERT INTO vwar".$n."_quickjump VALUES (4, 'Members', 'member.php', 3, 1)"); $vwardb->query("INSERT INTO vwar".$n."_quickjump VALUES (5, '\$str[CALENDAR]', 'calendar.php', 4, 1)"); $vwardb->query("INSERT INTO vwar".$n."_quickjump VALUES (6, 'News', 'news.php', 5, 1)"); $vwardb->query("INSERT INTO vwar".$n."_newssettings VALUES (1, '-more-', '', '', 10, 1, 1, 1, '[b]News is offline![/b]', 1)"); $vwardb->query("INSERT INTO vwar".$n."_smilie VALUES (1, 'smile', ':)', 'smile.gif', 1, 1, 0), (2, 'frown', ':(', 'frown.gif', 1, 1, 0), (3, 'embarrasment', ':o', 'redface.gif', 1, 1, 0), (4, 'big grin', ':D', 'biggrin.gif', 1, 1, 0), (5, 'wink', ';)', 'wink.gif', 1, 1, 0), (6, 'stick out tongue', ':P', 'tongue.gif', 1, 0, 0), (7, 'cool', ':cool:', 'cool.gif', 1, 1, 0), (8, 'roll eyes (sarcastic)', ':rolleyes:','rolleyes.gif', 1, 1, 0), (9, 'mad', ':mad:', 'mad.gif', 1, 1, 0), (10, 'eek!', ':eek:', 'eek.gif', 1, 0, 0), (11, 'confused', ':confused:', 'confused.gif', 1, 0, 0), (12, 'impactwhore', ':impact:', 'impactwhore.gif', 1, 0, 0), (13, 'headshot', ':headshot:', 'headshot.gif', 1, 0, 0), (14, 'globwhore', ':glob:', 'globwhore.gif', 1, 0, 0), (15, 'flackwhore', ':flack:', 'flackwhore.gif', 1, 0, 0), (16, 'chainsaw', ':chainsaw:', 'chainsaw.gif', 1, 0, 0), (17, 'camper', ':camper:', 'camper.gif', 1, 0, 0), (18, 'bluecap', ':bluecap:', 'bluecap.gif', 1, 0, 0), (19, 'anger', ':angry:', 'anger.gif', 1, 0, 0), (20, 'angel', ':angel:', 'angel.gif', 1, 0, 0), (21, 'enforcer', ':enforcer:', 'enforcer.gif', 1, 0, 0), (22, 'instagib', ':instagib:', 'instagib.gif', 1, 0, 0), (23, 'king', ':king:', 'king.gif', 1, 0, 0), (24, 'knife', ':knife:', 'messer.gif', 1, 0, 0), (25, 'mgwhore', ':mgwhore:', 'mgwhore.gif', 1, 0, 0), (26, 'plasmawhore', ':Plasma:', 'plasmawhore.gif', 1, 0, 0), (27, 'redcap', ':redcap:', 'redcap.gif', 1, 0, 0), (28, 'ripper', ':ripper:', 'ripper.gif', 1, 0, 0), (29, 'rocket', ':rocket:', 'rocket2.gif', 1, 0, 0), (30, 'rocketwhore', ':rocket2:', 'rocketwhore.gif', 1, 0, 0), (31, 'sex', ':sex:', 'sex.gif', 1, 0, 0), (32, 'shockwhore', ':shock:', 'shockwhore.gif', 1, 0, 0), (33, 'smokin', ':smokin:', 'smokin.gif', 1, 0, 0), (34, 'finger', ':finger:', 'thefinger.gif', 1, 0, 0), (35, 'transloc', ':transloc:', 'transloc.gif', 1, 0, 0), (36, 'sleep', ':sleep:', 'sleep.gif', 1, 0, 0), (37, 'bash', ':bash:', 'bash.gif', 1, 0, 0), (38, 'frustration', ':frust:', 'frust.gif', 1, 0, 0), (39, 'holy', ':holy:', 'holy.gif', 1, 0, 0), (41, 'kiss', ':kiss:', 'kiss.gif', 1, 0, 0), (42, 'megarofl', ':megarofl:', 'megarofl.gif', 1, 0, 0), (43, 'scared', ':scared:', 'scared.gif', 1, 0, 0), (44, 'thumb', ':thumb:', 'thumb.gif', 1, 0, 0), (45, 'shy', ':shy:', 'shy.gif', 1, 0, 0), (46, 'rail', ':rail:', 'rail.gif', 1, 0, 0), (47, 'grenade', ':grenade:', 'grenade.gif', 1, 0, 0), (48, 'bluescreen', ':bluescreen:', 'bluescreen.gif', 1, 0, 0), (49, 'gauntlet', ':gauntlet:', 'gauntlet.gif', 1, 0, 0), (50, 'grenade2', ':grenade2:', 'grenade2.gif', 1, 0, 0), (51, 'love', ':love:', 'love.gif', 1, 0, 0), (52, 'plasma', ':qplasma:', 'plasma.gif', 1, 0, 0), (53, 'puke', ':puke:', 'puke.gif', 1, 0, 0), (54, 'qrocket', ':qrocket:', 'qrocket.gif', 1, 0, 0), (55, 'shaft', ':shaft:', 'shaft.gif', 1, 0, 0), (56, 'sound', ':sound:', 'sound.gif', 1, 0, 0), (57, 'wave', ':wave:', 'wave.gif', 1, 0, 0), (58, 'AR15 Gunfire', ':ar15:', 'ar15.gif', 1, 0, 0), (59, 'Blah', ':blah:', 'blah.gif', 1, 0, 0), (60, 'Deal', ':deal:', 'deal.gif', 1, 0, 0), (61, 'Fart', ':fart:', 'fart.gif', 1, 0, 0), (62, 'Fart2', ':fart2:', 'fart2.gif', 1, 0, 0), (63, 'Quake 1', ':q1:', 'q1.gif', 1, 0, 0), (64, 'Quake 2', ':q2:', 'q2.gif', 1, 0, 0), (65, 'Quake 3', ':q3:', 'q3.gif', 1, 0, 0), (66, 'Rocking', ':rock:', 'rock.gif', 1, 0, 0), (67, 'Stupid', ':stupid:', 'stupid.gif', 1, 0, 0), (68, 'What\'s up ?', ':wazzup:', 'wazzup.gif', 1, 0, 0), (69, 'Wow', ':wow:', 'wow.gif', 1, 0, 0), (70, 'Question', ':?:', 'question.gif', 1, 1, 0), (71, 'Warning', ':!:', 'warning.gif', 1, 1, 0), (72, 'Thumb Up', ':thumbup:', 'thumbup.gif', 1, 1, 0), (73, 'Thumb Down', ':thumbdown:', 'thumbdown.gif', 1, 1, 0), (74, 'Crying', ':\'(', 'cry.gif', 1, 0, 0)"); // first settings entry with default values $vwardb->query("INSERT INTO vwar".$n."_settings( vwarversion ) VALUES ('" . $installversion . "')"); // ###################### // create example entries // ###################### $vwardb->query("INSERT INTO vwar".$n."_gametype VALUES (1, 'Team Deathmatch (example gametype)', 0)"); $vwardb->query("INSERT INTO vwar".$n."_matchtype VALUES (1, 'League Match', '', 1, 0)"); $vwardb->query("INSERT INTO vwar".$n."_matchtype VALUES (2, 'Training', '', 1, 0)"); $vwardb->query("INSERT INTO vwar".$n."_matchtype VALUES (3, 'Fun Match', '', 1, 0)"); $vwardb->query("INSERT INTO vwar".$n."_memberstatus VALUES (1, 'Leader', '0', 0)"); $vwardb->query("INSERT INTO vwar".$n."_memberstatus VALUES (2, 'Fullmember', '0', 0)"); $vwardb->query("INSERT INTO vwar".$n."_memberstatus VALUES (3, 'Trainee', '0', 0)"); $vwardb->query("INSERT INTO vwar".$n."_memberstatus VALUES (4, 'Inactive Member', '0', 0)"); $vwardb->query("INSERT INTO vwar".$n."_memberstatus VALUES (5, 'Honorary Member ', '0', 0)"); $vwardb->query("INSERT INTO vwar".$n."_memberstatus VALUES (6, 'Ex-Member', '0', 0)"); $vwardb->query("INSERT INTO vwar".$n."_pfield_cat VALUES (1, 'PC Equipment', 'example category', 1)"); $vwardb->query("INSERT INTO vwar".$n."_profilefield VALUES (1, 'CPU (example field)', 'cpu type of your pc', 0, 1, 0, 0, 0, 0, 0, 50, 1)"); $vwardb->query("INSERT INTO vwar".$n."_team VALUES (1, 'Team A (example team)', 1, 0, 0)"); ?>
 Import Data


All data has been successfully inserted into the tables!

 Click here to continue the installation!
query(" INSERT INTO vwar".$n."_replacement (replacementid,findword,replaceword) VALUES ( '".$replace[$i*3]."', '".$replace[$i*3+1]."', '".$replace[$i*3+2]."') "); } $vwartpls = explode("~~~",$style[1]); for ($i = 0; $i < count($vwartpls) / 2;$i++) { $vwardb->query(" INSERT INTO vwar".$n."_template (templatename,template,isinactive) VALUES ( '".$vwartpls[$i*2]."', '".$vwartpls[$i*2+1]."', '0') "); $tplcount++; } $vwardb->query("UPDATE vwar".$n."_template SET isspecial = '1' WHERE templatename = 'header'"); $vwardb->query("UPDATE vwar".$n."_template SET isspecial = '1' WHERE templatename = 'message_mail_challenge'"); $vwardb->query("UPDATE vwar".$n."_template SET isspecial = '1' WHERE templatename = 'message_mail_changedwar'"); $vwardb->query("UPDATE vwar".$n."_template SET isspecial = '1' WHERE templatename = 'message_mail_forgotpw_link'"); $vwardb->query("UPDATE vwar".$n."_template SET isspecial = '1' WHERE templatename = 'message_mail_forgotpw_pw'"); $vwardb->query("UPDATE vwar".$n."_template SET isspecial = '1' WHERE templatename = 'message_mail_joinus'"); $vwardb->query("UPDATE vwar".$n."_template SET isspecial = '1' WHERE templatename = 'message_mail_newwar'"); $message = "All templates ($tplcount) in "$uploadfile" were imported successfully."; $showstep = true; } else { $message = ""$uploadfile" file is missing!

"; $message .= "Upload file into admin directory and click here!"; $showstep = false; } ?>
 Import Data






 Click here to continue the installation!
query(" INSERT INTO vwar".$n."_member (memberid,accessgroupid,name,email,password,customstatus,status,language,ismember,hidemember) VALUES (1, 1, '$username', '$useremail', '$userpassword', 'Administrator', 1, 'english', 1, 0) "); // create access files @unlink($vwar_root."backup/.htaccess"); @unlink($vwar_root."backup/.htpasswd"); $root = $HTTP_SERVER_VARS["DOCUMENT_ROOT"]; $self = dirname($HTTP_SERVER_VARS["PHP_SELF"]); $path = (substr($root,(strlen($root)-1),1) != "/") ? $root."/" : $root; $path .= (substr($self,0,1) == "/") ? substr($self,1) : $self; $path = (substr($path,(strlen($root)-1),1) != "/") ? $path."/" : $path; $path .= "backup/"; require($vwar_root."includes/classes/class_htaccess.php"); $htaccess = new htaccess($vwar_root."backup/.htaccess"); $htaccess->createAccessFile($path.".htpasswd"); $htaccess->file_name = $vwar_root."backup/.htpasswd"; $htaccess->addUser("1",$GPC['userpassword']); $htaccess->commitUserChanges(); header("Location: $installfile?step=8"); die(); } printHeader($installversion . " Installation"); ?>
 Create Admin Account
Please create your first account:
Fields marked with * are required!
Your password is also used for the backup directory. For more information read docu.
User Name *
User Password *
User eMail *
 
 Installation complete


The installation has been completed successfully!

Delete the installation folder ( vwar/install/ )!

Use the login data provided in the previous step to enter the Admin Control Panel!

Please change the contact details under "Contact".

 Click here to enter the Admin Control Panel!