Vwar

lima-city → Forum → Programmiersprachen → PHP, MySQL & .htaccess

Autor dieses Themas
samger

samger hat kostenlosen Webspace.

15:21, 18.5.2004
hi,
ich wollte fragen ob sich hier einer mit Vwar auskennt oder vielleicht sogar was besseres kennt
Diskutiere mit und stelle Fragen: Jetzt kostenlos anmelden!

lima-city: Gratis werbefreier Webspace für deine eigene Homepage
robin

robin hat kostenlosen Webspace.

19:05, 18.5.2004
wenn du ma l f?r all die, die es nicht kennen erkl?rst was das ist - vielleicht kennt dann jemand was besseres
freak89

freak89 hat kostenlosen Webspace.

13:06, 19.5.2004
VWar ist ein PHP-Script und geh?rt doch eigendlich
in die daf?r vorhergesehene Kategorie...
~~m*******9~~

15:08, 21.5.2004
Nimm Vwar was besseres kenn ich ned, aber ich werde was besseres schreiben ^^
scaone

scaone hat kostenlosen Webspace.

17:34, 19.8.2004
hallo k?nnte mir jemand mal helfen komme nicht weiter schauht mal selber

http://scaone.xardas.lima-city.de/vwar/admin/install.php was habe ich

falsch gemacht

-----------------------------------------------
VWar Installation
-----------------------------------------------

1. Edit _config.inc.php (enter your database data)
2. Run install.php in the admin/ directory
3. Delete install.php (or rename)
4. Go to Admin Control Panel and edit the Administrators Details (change to our Name, your Password, your Mail ...)
5. Edit Settings in Admin Control Panel
5. Set Directory images/screen to chmod 777
6. Set Directory images/member to chmod 777
7. Set Directory images/locations to chmod 777

die chmod rechte habe ichs chon gegeben nur die install.php f?hrt er auch aus aber weiter nicht
fbi

fbi hat kostenlosen Webspace.

17:46, 19.8.2004
schau mal auf die einstellungen.
oder in der install.php unter step1

hast du alle CHMOD s richtig gesetzt ?

also ich habe es ohne probs installiert.
scaone

scaone hat kostenlosen Webspace.

17:48, 19.8.2004
ja die chmods habe ich richtig gemacht sind ja nur 3 ordner die die bekommen

und ich verstehe nicht was du unter step 1 meinst ich habe mal meine install.php kopiert hier

<?php
@error_reporting(7);
/* #####################################################################################
*
* $Id: _install.php,v 1.19 2003/03/17 19:41:19 mabu Exp $
*
* This notice must remain untouched at all times.
*
* Modifications to the script, except the official addons or hacks,
* without the owners permission are prohibited.
* All rights reserved to their proper authors.
*
* Get the latest version at http://www.vwar.de - Copyright (C) 2001-2003
*
* #####################################################################################
*/

$installversion="1.4.0";
$installfile="install.php";
$header="
<html>
<head>
<title>Vwar Installation</title>
<style type=\"text/css\">
body {
margin: 0px;
}
.infobox {
font-family: Verdana,Arial, Helvetica, sans-serif;
font-size: 13px;
color: #000000;
line-height: 125%;
background-color: #FFFFFF;
border: 1px solid #000000;
}
a:link, a:visited, a:active {
color: #1010f7;
font-size: 9pt;
text-decoration: none;
}
a:hover {
color: #000000;
font-size: 9pt;
text-decoration: underline;
}
.title {
font-family: Verdana,Arial, Helvetica, sans-serif;
font-size: 17px;
}
</style>
</head>
<body bgcolor=\"#D6D7D6\" text=\"#000000\" bgproperties=fixed>

<table width=\"90%\" align=\"center\" cellpadding=\"3\" cellspacing=\"0\" border=\"0\">
<tr>
<td width=\"100%\" align=\"center\">
» VWar $installversion Installation
</td>
</tr>
</table>
";

require("../_config.inc.php");
require("../_class_db.php");

$step=$HTTP_GET_VARS["step"];

function inarray($search, $array) {
for($i=0;$i<count($array);$i++) {
if($search==$array[$i]) {
return true;
break;
}
}
}

$tables = array(
"vwar".$n."",
"vwar".$n."_accessgroup",
"vwar".$n."_calendarevents",
"vwar".$n."_cash",
"vwar".$n."_challenge",
"vwar".$n."_comments",
"vwar".$n."_games",
"vwar".$n."_gametype",
"vwar".$n."_join",
"vwar".$n."_locations",
"vwar".$n."_matchtype",
"vwar".$n."_member",
"vwar".$n."_membergames",
"vwar".$n."_memberlocation",
"vwar".$n."_memberprofilefield",
"vwar".$n."_memberstatus",
"vwar".$n."_opponents",
"vwar".$n."_participants",
"vwar".$n."_profilefield",
"vwar".$n."_replacement",
"vwar".$n."_scores",
"vwar".$n."_settings",
"vwar".$n."_screen",
"vwar".$n."_server",
"vwar".$n."_smilie",
"vwar".$n."_team",
"vwar".$n."_teammember",
"vwar".$n."_template"
);
$db = new db($sql["hostname"],$sql["username"],$sql["password"],$sql["database"]);

# - steps -
if(!isset($step) || $step=="") {
echo $header;
?>

<table border="0" align="center" width="90%" cellpadding="3" cellspacing="1">
<tr>
<td class="infobox">
» Start Installation
» <a href="<?= $installfile; ?>?step=1">Click here to start the installation!</a>
</td>
</tr>
</table>

<?
}

if($step==1) {
$result = mysql_list_tables($sql["database"]);
if(!$db->num_rows($result)) header("Location: ".$installfile."?step=4");
else {
echo $header;
?>

<table border="0" align="center" width="90%" cellpadding="3" cellspacing="1">
<tr>
<td class="infobox">

» Database <? echo "$sql[database]"; ?> is not empty!


» <a href="<?= $installfile; ?>?step=3">Click here to continue the installation!</a>


» <a href="<?= $installfile; ?>?step=2">Click here to empty the database!</a> (this option deletes ALL TABLES in your database!)

</td>
</tr>
</table>

<?
}
}

if($step==2) {
$result = mysql_list_tables ($sql["database"]);
for($i = 0; $i < mysql_num_rows ($result); $i++) $db->query("DROP TABLE ".mysql_tablename($result, $i));
echo $header;
?>

<table border="0" align="center" width="90%" cellpadding="3" cellspacing="1">
<tr>
<td class="infobox">

» Database <? echo "$sql[database]"; ?> was cleared successfully!


» <a href="<?= $installfile; ?>?step=4">Click here to continue the installation!</a>

</td>
</tr>
</table>

<?
}

if($step==3) {
$result = mysql_list_tables ($sql["database"]);
for($i = 0; $i < mysql_num_rows ($result); $i++) {
if(inarray(mysql_tablename($result, $i),$tables)) {
$check = 1;
break;
}
}
if(!$check) header("Location: ".$installfile."?step=4");
else {
echo $header;
?>

<table border="0" align="center" width="90%" cellpadding="3" cellspacing="1">
<tr>
<td class="infobox">

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


» <a href="<?= $installfile; ?>?step=4">Click here to continue the installation!</a>

</td>
</tr>
</table>

<?
}
}

if($step==4) {
$result = mysql_list_tables ($sql["database"]);
for($i = 0; $i < mysql_num_rows ($result); $i++) if(inarray(mysql_tablename($result, $i),$tables)) $db->query("DROP TABLE ".mysql_tablename($result, $i));
echo $header;
?>

<table border="0" align="center" width="90%" cellpadding="3" cellspacing="1">
<tr>
<td class="infobox">
<?
echo "\n";

$db->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',
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',
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),
UNIQUE KEY warid (warid),
KEY warid_2 (warid)
)");
echo "» vwar".$n." table created ";

$db->query("CREATE TABLE vwar".$n."_accessgroup (
accessgroupid smallint(5) NOT NULL auto_increment,
accessgroupname varchar(100) NOT NULL default '',
canaddwar smallint(6) NOT NULL default '0',
caneditwar smallint(6) NOT NULL default '0',
candeletewar smallint(6) NOT NULL default '0',
canaddmember smallint(6) NOT NULL default '0',
caneditmember smallint(6) NOT NULL default '0',
candeletemember smallint(6) NOT NULL default '0',
canaddstatus smallint(6) NOT NULL default '0',
caneditstatus smallint(6) NOT NULL default '0',
candeletestatus smallint(6) NOT NULL default '0',
canaddprofilefield smallint(6) NOT NULL default '0',
caneditprofilefield smallint(6) NOT NULL default '0',
candeleteprofilefield smallint(6) NOT NULL default '0',
canaddteam smallint(6) NOT NULL default '0',
caneditteam smallint(6) NOT NULL default '0',
candeleteteam smallint(6) NOT NULL default '0',
canaddcash smallint(6) NOT NULL default '0',
caneditcash smallint(6) NOT NULL default '0',
candeletecash smallint(6) NOT NULL default '0',
canaddevent smallint(6) NOT NULL default '0',
caneditevent smallint(6) NOT NULL default '0',
candeleteevent smallint(6) NOT NULL default '0',
canaddserver smallint(6) NOT NULL default '0',
caneditserver smallint(6) NOT NULL default '0',
candeleteserver smallint(6) NOT NULL default '0',
canaddgametype smallint(6) NOT NULL default '0',
caneditgametype smallint(6) NOT NULL default '0',
candeletegametype smallint(6) NOT NULL default '0',
canaddmatchtype smallint(6) NOT NULL default '0',
caneditmatchtype smallint(6) NOT NULL default '0',
candeletematchtype smallint(6) NOT NULL default '0',
canaddgame smallint(6) NOT NULL default '0',
caneditgame smallint(6) NOT NULL default '0',
candeletegame smallint(6) NOT NULL default '0',
canaddlocation smallint(6) NOT NULL default '0',
caneditlocation smallint(6) NOT NULL default '0',
candeletelocation smallint(6) NOT NULL default '0',
isadmin smallint(6) NOT NULL default '0',
PRIMARY KEY (accessgroupid)
)");
echo "» vwar".$n."_accessgroup table created ";

$db->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 date NOT NULL default '0000-00-00',
eventadded int(11) NOT NULL default '0',
deleted tinyint(4) NOT NULL default '0',
PRIMARY KEY (eventid)
)");
echo "» vwar".$n."_calendarevents table created ";

$db->query("CREATE TABLE vwar".$n."_cash (
cashid smallint(5) unsigned NOT NULL auto_increment,
purpose varchar(100) NOT NULL default '',
amount double NOT NULL default '0',
bookingdate date NOT NULL default '0000-00-00',
deleted smallint(1) NOT NULL default '0',
PRIMARY KEY (cashid)
)");
echo "» vwar".$n."_cash table created ";

$db->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 int(11) NOT NULL default '0',
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)
)");
echo "» vwar".$n."_challenge table created ";

$db->query("CREATE TABLE vwar".$n."_comments (
commentid smallint(5) unsigned NOT NULL auto_increment,
warid smallint(5) NOT NULL default '0',
memberid 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 tinyint(11) NOT NULL default '0',
guestip varchar(20) NOT NULL default '',
comment text NOT NULL,
allowsmilies smallint(1) NOT NULL default '0',
allowhtml smallint(1) NOT NULL default '0',
dateline int(11) NOT NULL default '0',
deleted smallint(1) NOT NULL default '0',
PRIMARY KEY (commentid)
)");
echo "» vwar".$n."_comments table created ";

$db->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)
)");
echo "» vwar".$n."_games table created ";

$db->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)
)");
echo "» vwar".$n."_gametype table created ";

$db->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 int(11) NOT NULL default '0',
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)
)");
echo "» vwar".$n."_join table created ";

$db->query("CREATE TABLE vwar".$n."_locations (
locationid smallint(5) unsigned NOT NULL auto_increment,
locationname varchar(100) NOT NULL default '',
gameid smallint(5) NOT NULL default '0',
deleted smallint(1) NOT NULL default '0',
PRIMARY KEY (locationid)
)");
echo "» vwar".$n."_locations table created ";

$db->query("CREATE TABLE vwar".$n."_matchtype (
matchtypeid smallint(5) unsigned NOT NULL auto_increment,
matchtypename varchar(100) NOT NULL default '',
deleted smallint(1) NOT NULL default '0',
PRIMARY KEY (matchtypeid)
)");
echo "» vwar".$n."_matchtype table created ";

$db->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 int(12) 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 '',
pcram varchar(20) NOT NULL default '',
pccpu varchar(100) NOT NULL default '',
pcmonitor varchar(100) NOT NULL default '',
pcconnection VARCHAR(100) NOT NULL default '',
pcgraphiccard VARCHAR(100) NOT NULL default '',
pcmouse VARCHAR(100) NOT NULL default '',
pckeyboard VARCHAR(100) NOT NULL default '',
story TEXT NOT NULL,
picture VARCHAR(255) NOT NULL default '',
ismember SMALLINT(1) NOT NULL default '1',
hidemember SMALLINT(1) NOT NULL default '0',
deleted tinyint(4) NOT NULL default '0',
PRIMARY KEY (memberid),
UNIQUE KEY memberid_2 (memberid),
KEY id (memberid)
)");
echo "» vwar".$n."_member table created ";

$db->query("CREATE TABLE vwar".$n."_memberlocation (
memberlocationid smallint(5) 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)
)");
echo "» vwar".$n."_memberlocation table created ";

$db->query("CREATE TABLE vwar".$n."_memberprofilefield (
memberprofilefieldid smallint(5) NOT NULL auto_increment,
memberid smallint(5) NOT NULL default '0',
profilefieldid smallint(5) NOT NULL default '0',
fieldvalue varchar(250) NOT NULL default '',
PRIMARY KEY (memberprofilefieldid)
)");
echo "» vwar".$n."_memberprofilefield table created ";

$db->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)
)");
echo "» vwar".$n."_memberstatus Tabelle created ";

$db->query("CREATE TABLE vwar".$n."_membergames (
membergamesid smallint(5) unsigned NOT NULL auto_increment,
memberid smallint(5) NOT NULL default '0',
gameid smallint(5) NOT NULL default '0',
PRIMARY KEY (membergamesid)
)");
echo "» vwar".$n."_membergames table created ";

$db->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 int(12) default NULL,
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)
)");
echo "» vwar".$n."_opponents table created ";

$db->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)
)");
echo "» vwar".$n."_participants table created ";

$db->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',
PRIMARY KEY (profilefieldid)
)");
echo "» vwar".$n."_profilefield table created ";

$db->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)
)");
echo "» vwar".$n."_replacement table created ";

$db->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)
)");
echo "» vwar".$n."_scores table created ";

$db->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 '',
fileextension varchar(10) NOT NULL default '',
converted smallint(1) NOT NULL default '0',
PRIMARY KEY (screenid)
)");
echo "» vwar".$n."_screen table created ";

$db->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)
)");
echo "» vwar".$n."_server table created ";

$db->query("CREATE TABLE vwar".$n."_settings (
ownname varchar(250) NOT NULL default '',
ownnameshort varchar(50) NOT NULL default '',
ownhomepage varchar(250) 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',
smiliecode smallint(1) NOT NULL default '1',
htmlcode smallint(1) NOT NULL default '1',
guestcomments smallint(1) NOT NULL default '0',
maintablewidth varchar(5) NOT NULL default '',
screenshotwidth smallint(4) NOT NULL default '0',
screenshotheight smallint(4) NOT NULL default '0',
favpermember smallint(3) NOT NULL default '3',
favperline smallint(3) NOT NULL default '3',
colorwon varchar(7) NOT NULL default '',
colorlost varchar(7) NOT NULL default '',
colordraw varchar(7) NOT NULL default '',
textwon varchar(100) NOT NULL default '',
textlost varchar(100) NOT NULL default '',
textdraw varchar(100) NOT NULL default '',
waroverlap SMALLINT( 10 ) DEFAULT '0' NOT NULL,
timezoneoffset VARCHAR( 4 ) NOT NULL DEFAULT '0',
timeformat SMALLINT( 1 ) NOT NULL DEFAULT '1',
shortdateformat varchar(30) NOT NULL default '',
longdateformat varchar(30) NOT NULL default '',
startofweek SMALLINT( 1 ) NOT NULL DEFAULT '0',
perpage smallint(5) NOT NULL default '0',
moneysymbol varchar(5) NOT NULL default '',
vwarlanguage varchar(25) NOT NULL default '',
vwarversion varchar(10) NOT NULL default ''
)");
echo "» vwar".$n."_settings table created ";

$db->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 '',
deleted tinyint(4) NOT NULL default '0',
PRIMARY KEY (smilieid),
KEY code (code)
)");
echo "» vwar".$n."_smilie table created ";

$db->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',
deleted smallint(1) NOT NULL default '0',
PRIMARY KEY (teamid)
)");
echo "» vwar".$n."_team table created ";

$db->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)
)");
echo "» vwar".$n."_teammember table created ";

$db->query("CREATE TABLE vwar".$n."_template (
templateid smallint(5) unsigned NOT NULL auto_increment,
templatename varchar(100) NOT NULL default '',
template mediumtext NOT NULL,
isinactive smallint(5) NOT NULL default '0',
PRIMARY KEY (templateid),
UNIQUE KEY id (templateid),
KEY id_2 (templateid)
)");
echo "» vwar".$n."_template table created ";

?>


» Tables were created successfully!

» <a href="<?= $installfile; ?>?step=5">Click here to continue the installation!</a>
</td>
</tr>
</table>

<?
}

if($step==5) {
echo $header;
?>

<table border="0" align="center" width="90%" cellpadding="3" cellspacing="1">
<tr>
<td class="infobox">

» Filling tables!

<?

$db->query("INSERT INTO vwar".$n."_accessgroup VALUES (1, 'Waradmin', 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)");
$db->query("INSERT INTO vwar".$n."_accessgroup VALUES (2, 'Treasurer', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 1, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0)");
$db->query("INSERT INTO vwar".$n."_accessgroup VALUES (3, 'Wararranger', 1, 1, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 0)");
$db->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, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0)");

$db->query("INSERT INTO vwar".$n."_games VALUES (1, 'Unreal Tournament', 'UT', 'ut.gif', 0)");
$db->query("INSERT INTO vwar".$n."_games VALUES (2, 'Counterstrike', 'CS', 'cs.gif', 0)");
$db->query("INSERT INTO vwar".$n."_games VALUES (3, 'Quake 3 Arena', 'Q3', 'q3.gif', 0)");
$db->query("INSERT INTO vwar".$n."_games VALUES (4, 'Return to Castle Wolfenstein', 'RtCW', 'rtcw.gif', 0)");
$db->query("INSERT INTO vwar".$n."_games VALUES (5, 'Halflife', 'HL', 'hl.gif', 0)");
$db->query("INSERT INTO vwar".$n."_games VALUES (6, 'Startrek Voyager: Elite Force', 'EF', 'ef.gif', 0)");
$db->query("INSERT INTO vwar".$n."_games VALUES (7, 'Tribes2', 'T2', 't2.gif', 0)");
$db->query("INSERT INTO vwar".$n."_games VALUES (8, 'Starcraft', 'SC', 'sc.gif', 0)");
$db->query("INSERT INTO vwar".$n."_games VALUES (9, 'Quake 2', 'Q2', 'q2.gif', 0)");
$db->query("INSERT INTO vwar".$n."_games VALUES (10, 'Diablo 2', 'D2', 'd2.gif', 0)");
$db->query("INSERT INTO vwar".$n."_games VALUES (11, 'Ages of Empire 2: Ages of Kings', 'AOE2', 'aoe2.gif', 0)");
$db->query("INSERT INTO vwar".$n."_games VALUES (12, 'Black and White', 'BW', 'bw.gif', 0)");
$db->query("INSERT INTO vwar".$n."_games VALUES (13, 'Medal of Honour : Allied Assault', 'MoHAA', 'mohaa.gif', 0)");
$db->query("INSERT INTO vwar".$n."_games VALUES (14, 'Unreal Tournament: Tactical Ops', 'TO', 'to.gif', 0)");
$db->query("INSERT INTO vwar".$n."_games VALUES (15, 'FIFA', 'FIFA', 'fifa.gif', 0)");
$db->query("INSERT INTO vwar".$n."_games VALUES (16, 'Dark Age of Camelot', 'DAoC', 'daoc.gif', 0)");
$db->query("INSERT INTO vwar".$n."_games VALUES (17, 'Alien versus Predator 2', 'AvP2', 'avp2.gif', 0)");
$db->query("INSERT INTO vwar".$n."_games VALUES (18, 'Sudden Strike', 'SS', 'ss.gif', 0)");
$db->query("INSERT INTO vwar".$n."_games VALUES (19, 'Unreal Tournament 2003', 'UT2K3', 'ut2k3.gif', 0)");

$db->query("INSERT INTO vwar".$n."_gametype VALUES (1, 'Capture the Flag', 0)");
$db->query("INSERT INTO vwar".$n."_gametype VALUES (2, 'Team Deathmatch', 0)");
$db->query("INSERT INTO vwar".$n."_gametype VALUES (3, 'Domination', 0)");
$db->query("INSERT INTO vwar".$n."_gametype VALUES (4, 'Rocket Arena', 0)");
$db->query("INSERT INTO vwar".$n."_gametype VALUES (5, 'Tactical Ops', 0)");
$db->query("INSERT INTO vwar".$n."_gametype VALUES (6, 'Strike Force', 0)");
$db->query("INSERT INTO vwar".$n."_gametype VALUES (7, 'Team Fortress', 0)");
$db->query("INSERT INTO vwar".$n."_gametype VALUES (8, 'Urban Terror', 0)");

$db->query("INSERT INTO vwar".$n."_locations VALUES (1, 'DM-Deck16][', 1, 0)");
$db->query("INSERT INTO vwar".$n."_locations VALUES (2, 'DM-Liandri', 1, 0)");
$db->query("INSERT INTO vwar".$n."_locations VALUES (3, 'DM-Malevolence', 1, 0)");
$db->query("INSERT INTO vwar".$n."_locations VALUES (4, 'DM-Curse][', 1, 0)");
$db->query("INSERT INTO vwar".$n."_locations VALUES (5, 'DM-Codex', 1, 0)");
$db->query("INSERT INTO vwar".$n."_locations VALUES (6, 'DM-Morbias][', 1, 0)");
$db->query("INSERT INTO vwar".$n."_locations VALUES (7, 'DM-Barricade', 1, 0)");
$db->query("INSERT INTO vwar".$n."_locations VALUES (8, 'DM-Peak', 1, 0)");
$db->query("INSERT INTO vwar".$n."_locations VALUES (9, 'CTF-Command', 1, 0)");
$db->query("INSERT INTO vwar".$n."_locations VALUES (10, 'CTF-Coret', 1, 0)");
$db->query("INSERT INTO vwar".$n."_locations VALUES (11, 'CTF-Dreary', 1, 0)");
$db->query("INSERT INTO vwar".$n."_locations VALUES (12, 'CTF-EternalCave', 1, 0)");
$db->query("INSERT INTO vwar".$n."_locations VALUES (13, 'CTF-Face', 1, 0)");
$db->query("INSERT INTO vwar".$n."_locations VALUES (14, 'CTF-Gauntlet', 1, 0)");
$db->query("INSERT INTO vwar".$n."_locations VALUES (15, 'CTF-LavaGiant', 1, 0)");
$db->query("INSERT INTO vwar".$n."_locations VALUES (16, 'CTF-Niven', 1, 0)");
$db->query("INSERT INTO vwar".$n."_locations VALUES (17, 'CTF-November', 1, 0)");
$db->query("INSERT INTO vwar".$n."_locations VALUES (18, 'DM-Agony', 1, 0)");
$db->query("INSERT INTO vwar".$n."_locations VALUES (19, 'DM-ArcaneTemple', 1, 0)");
$db->query("INSERT INTO vwar".$n."_locations VALUES (20, 'DM-Bishop', 1, 0)");
$db->query("INSERT INTO vwar".$n."_locations VALUES (21, 'DM-Conveyor', 1, 0)");
$db->query("INSERT INTO vwar".$n."_locations VALUES (22, 'DM-Cybrosis][', 1, 0)");
$db->query("INSERT INTO vwar".$n."_locations VALUES (23, 'DM-Fetid', 1, 0)");
$db->query("INSERT INTO vwar".$n."_locations VALUES (24, 'DM-Fractal', 1, 0)");
$db->query("INSERT INTO vwar".$n."_locations VALUES (25, 'DM-Gothic', 1, 0)");
$db->query("INSERT INTO vwar".$n."_locations VALUES (26, 'DM-StalwartXL', 1, 0)");
$db->query("INSERT INTO vwar".$n."_locations VALUES (27, 'DM-Tempest', 1, 0)");
$db->query("INSERT INTO vwar".$n."_locations VALUES (28, 'DM-Morpheus', 1, 0)");
$db->query("INSERT INTO vwar".$n."_locations VALUES (29, 'DM-Phobos', 1, 0)");
$db->query("INSERT INTO vwar".$n."_locations VALUES (30, 'DM-Grinder', 1, 0)");
$db->query("INSERT INTO vwar".$n."_locations VALUES (31, 'CTF-Diamond Sword', 1, 0)");
$db->query("INSERT INTO vwar".$n."_locations VALUES (32, 'cs_arabstreets', 2, 0)");
$db->query("INSERT INTO vwar".$n."_locations VALUES (33, 'cs_747', 2, 0)");
$db->query("INSERT INTO vwar".$n."_locations VALUES (34, 'cs_estate', 2, 0)");
$db->query("INSERT INTO vwar".$n."_locations VALUES (35, 'de_cbble', 2, 0)");
$db->query("INSERT INTO vwar".$n."_locations VALUES (36, 'cs_assault', 2, 0)");
$db->query("INSERT INTO vwar".$n."_locations VALUES (37, 'cs_backalley', 2, 0)");
$db->query("INSERT INTO vwar".$n."_locations VALUES (38, 'cs_italy', 2, 0)");
$db->query("INSERT INTO vwar".$n."_locations VALUES (39, 'cs_militia', 2, 0)");
$db->query("INSERT INTO vwar".$n."_locations VALUES (40, 'cs_office', 2, 0)");
$db->query("INSERT INTO vwar".$n."_locations VALUES (41, 'cs_siege', 2, 0)");
$db->query("INSERT INTO vwar".$n."_locations VALUES (42, 'cs_thunder', 2, 0)");
$db->query("INSERT INTO vwar".$n."_locations VALUES (43, 'de_aztec', 2, 0)");
$db->query("INSERT INTO vwar".$n."_locations VALUES (44, 'de_dust', 2, 0)");
$db->query("INSERT INTO vwar".$n."_locations VALUES (45, 'de_dust2', 2, 0)");
$db->query("INSERT INTO vwar".$n."_locations VALUES (46, 'de_inferno', 2, 0)");
$db->query("INSERT INTO vwar".$n."_locations VALUES (47, 'de_nuke', 2, 0)");
$db->query("INSERT INTO vwar".$n."_locations VALUES (48, 'de_prodigy', 2, 0)");
$db->query("INSERT INTO vwar".$n."_locations VALUES (49, 'de_rotterdam', 2, 0)");
$db->query("INSERT INTO vwar".$n."_locations VALUES (50, 'de_storm', 2, 0)");
$db->query("INSERT INTO vwar".$n."_locations VALUES (51, 'de_survivor', 2, 0)");
$db->query("INSERT INTO vwar".$n."_locations VALUES (52, 'de_torn', 2, 0)");
$db->query("INSERT INTO vwar".$n."_locations VALUES (53, 'de_train', 2, 0)");
$db->query("INSERT INTO vwar".$n."_locations VALUES (54, 'de_vegas', 2, 0)");
$db->query("INSERT INTO vwar".$n."_locations VALUES (55, 'de_vertigo', 2, 0)");
$db->query("INSERT INTO vwar".$n."_locations VALUES (56, 'boot_camp', 5, 0)");
$db->query("INSERT INTO vwar".$n."_locations VALUES (57, 'bounce', 5, 0)");
$db->query("INSERT INTO vwar".$n."_locations VALUES (58, 'crossfire', 5, 0)");
$db->query("INSERT INTO vwar".$n."_locations VALUES (59, 'datacore', 5, 0)");
$db->query("INSERT INTO vwar".$n."_locations VALUES (60, 'datacore', 5, 0)");
$db->query("INSERT INTO vwar".$n."_locations VALUES (61, 'frenzy', 5, 0)");
$db->query("INSERT INTO vwar".$n."_locations VALUES (62, 'rapidcore', 5, 0)");
$db->query("INSERT INTO vwar".$n."_locations VALUES (63, 'snark_pit', 5, 0)");
$db->query("INSERT INTO vwar".$n."_locations VALUES (64, 'stalkyard', 5, 0)");
$db->query("INSERT INTO vwar".$n."_locations VALUES (65, 'subtransit', 5, 0)");
$db->query("INSERT INTO vwar".$n."_locations VALUES (66, 'undertow', 5, 0)");
$db->query("INSERT INTO vwar".$n."_locations VALUES (67, 'mp_destruction', 4, 0)");
$db->query("INSERT INTO vwar".$n."_locations VALUES (68, 'mp_assault', 4, 0)");
$db->query("INSERT INTO vwar".$n."_locations VALUES (69, 'mp_base', 4, 0)");
$db->query("INSERT INTO vwar".$n."_locations VALUES (70, 'mp_beach', 4, 0)");
$db->query("INSERT INTO vwar".$n."_locations VALUES (71, 'mp_castle', 4, 0)");
$db->query("INSERT INTO vwar".$n."_locations VALUES (72, 'mp_depot', 4, 0)");
$db->query("INSERT INTO vwar".$n."_locations VALUES (73, 'mp_destruction', 4, 0)");
$db->query("INSERT INTO vwar".$n."_locations VALUES (74, 'mp_sub', 4, 0)");
$db->query("INSERT INTO vwar".$n."_locations VALUES (75, 'mp_trenchtoast', 4, 0)");
$db->query("INSERT INTO vwar".$n."_locations VALUES (76, 'mp_village', 4, 0)");
$db->query("INSERT INTO vwar".$n."_locations VALUES (77, 'TO-Blister', 14, 0)");
$db->query("INSERT INTO vwar".$n."_locations VALUES (78, 'TO-Forge', 14, 0)");
$db->query("INSERT INTO vwar".$n."_locations VALUES (79, 'TO-Getaway', 14, 0)");
$db->query("INSERT INTO vwar".$n."_locations VALUES (80, 'TO-IcyBreeze', 14, 0)");
$db->query("INSERT INTO vwar".$n."_locations VALUES (81, 'TO-Monastery', 14, 0)");
$db->query("INSERT INTO vwar".$n."_locations VALUES (82, 'TO-Oilrig2', 14, 0)");
$db->query("INSERT INTO vwar".$n."_locations VALUES (83, 'TO-Province', 14, 0)");
$db->query("INSERT INTO vwar".$n."_locations VALUES (84, 'TO-Ransom2', 14, 0)");
$db->query("INSERT INTO vwar".$n."_locations VALUES (85, 'TO-RapidWaters2', 14, 0)");
$db->query("INSERT INTO vwar".$n."_locations VALUES (86, 'TO-Resurrection', 14, 0)");
$db->query("INSERT INTO vwar".$n."_locations VALUES (87, 'TO-RMSTitanic', 14, 0)");
$db->query("INSERT INTO vwar".$n."_locations VALUES (88, 'TO-Scope', 14, 0)");
$db->query("INSERT INTO vwar".$n."_locations VALUES (89, 'TO-Spynet2', 14, 0)");
$db->query("INSERT INTO vwar".$n."_locations VALUES (90, 'TO-Trainstation', 14, 0)");
$db->query("INSERT INTO vwar".$n."_locations VALUES (91, 'TO-Verdon', 14, 0)");
$db->query("INSERT INTO vwar".$n."_locations VALUES (92, 'AS-Bridge', 1, 0)");
$db->query("INSERT INTO vwar".$n."_locations VALUES (93, 'AS-Darkstar', 1, 0)");
$db->query("INSERT INTO vwar".$n."_locations VALUES (94, 'AS-Frigate', 1, 0)");
$db->query("INSERT INTO vwar".$n."_locations VALUES (95, 'AS-Guardia', 1, 0)");
$db->query("INSERT INTO vwar".$n."_locations VALUES (96, 'AS-Highspeed', 1, 0)");
$db->query("INSERT INTO vwar".$n."_locations VALUES (97, 'AS-Mazon', 1, 0)");
$db->query("INSERT INTO vwar".$n."_locations VALUES (98, 'AS-OceanFloor', 1, 0)");
$db->query("INSERT INTO vwar".$n."_locations VALUES (99, 'AS-Overlord', 1, 0)");
$db->query("INSERT INTO vwar".$n."_locations VALUES (100, 'AS-Resurrection', 1, 0)");
$db->query("INSERT INTO vwar".$n."_locations VALUES (101, 'AS-Rook', 1, 0)");
$db->query("INSERT INTO vwar".$n."_locations VALUES (102, 'AS-Siege', 1, 0)");
$db->query("INSERT INTO vwar".$n."_locations VALUES (103, 'AWtourney1', 3, 0)");
$db->query("INSERT INTO vwar".$n."_locations VALUES (104, 'AWtourney2', 3, 0)");
$db->query("INSERT INTO vwar".$n."_locations VALUES (105, 'AWtourney3', 3, 0)");
$db->query("INSERT INTO vwar".$n."_locations VALUES (106, 'AWtourney4', 3, 0)");
$db->query("INSERT INTO vwar".$n."_locations VALUES (107, 'AWtourney5', 3, 0)");
$db->query("INSERT INTO vwar".$n."_locations VALUES (108, 'AWtourney6', 3, 0)");
$db->query("INSERT INTO vwar".$n."_locations VALUES (109, 'AWtourney7', 3, 0)");
$db->query("INSERT INTO vwar".$n."_locations VALUES (110, 'cpm14', 3, 0)");
$db->query("INSERT INTO vwar".$n."_locations VALUES (111, 'cpm4', 3, 0)");
$db->query("INSERT INTO vwar".$n."_locations VALUES (112, 'cpm9', 3, 0)");
$db->query("INSERT INTO vwar".$n."_locations VALUES (113, 'hub3tourney1', 3, 0)");
$db->query("INSERT INTO vwar".$n."_locations VALUES (114, 'pro-q3dm6', 3, 0)");
$db->query("INSERT INTO vwar".$n."_locations VALUES (115, 'pro-q3tourney2', 3, 0)");
$db->query("INSERT INTO vwar".$n."_locations VALUES (116, 'pro-q3tourney4', 3, 0)");
$db->query("INSERT INTO vwar".$n."_locations VALUES (117, 'q3dm13', 3, 0)");
$db->query("INSERT INTO vwar".$n."_locations VALUES (118, 'Q3DM7', 3, 0)");
$db->query("INSERT INTO vwar".$n."_locations VALUES (119, 'q3tourney2', 3, 0)");
$db->query("INSERT INTO vwar".$n."_locations VALUES (120, 'q3tourney4', 3, 0)");
$db->query("INSERT INTO vwar".$n."_locations VALUES (121, 'ra3map1 - arena 4: theater of pain', 3, 0)");
$db->query("INSERT INTO vwar".$n."_locations VALUES (122, 'ra3map10 - arena 4: jupiter rising', 3, 0)");
$db->query("INSERT INTO vwar".$n."_locations VALUES (123, 'ra3map11 - arena 4: overkill', 3, 0)");
$db->query("INSERT INTO vwar".$n."_locations VALUES (124, 'ra3map12 - arena 4: hen house', 3, 0)");
$db->query("INSERT INTO vwar".$n."_locations VALUES (125, 'Archipelago', 7, 0)");
$db->query("INSERT INTO vwar".$n."_locations VALUES (126, 'Beggars Run', 7, 0)");
$db->query("INSERT INTO vwar".$n."_locations VALUES (127, 'Damnation', 7, 0)");
$db->query("INSERT INTO vwar".$n."_locations VALUES (128, 'Death Birds Fly', 7, 0)");
$db->query("INSERT INTO vwar".$n."_locations VALUES (129, 'Desiccator', 7, 0)");
$db->query("INSERT INTO vwar".$n."_locations VALUES (130, 'Katabatic', 7, 0)");
$db->query("INSERT INTO vwar".$n."_locations VALUES (131, 'Minotaur', 7, 0)");
$db->query("INSERT INTO vwar".$n."_locations VALUES (132, 'Reversion', 7, 0)");
$db->query("INSERT INTO vwar".$n."_locations VALUES (133, 'Riverdance', 7, 0)");
$db->query("INSERT INTO vwar".$n."_locations VALUES (134, 'Sanctuary', 7, 0)");
$db->query("INSERT INTO vwar".$n."_locations VALUES (135, 'Slapdash', 7, 0)");
$db->query("INSERT INTO vwar".$n."_locations VALUES (136, 'Thin Ice', 7, 0)");
$db->query("INSERT INTO vwar".$n."_locations VALUES (137, 'Tombstone', 7, 0)");
$db->query("INSERT INTO vwar".$n."_locations VALUES (138, 'Quagmire', 7, 0)");
$db->query("INSERT INTO vwar".$n."_locations VALUES (139, 'Arabien', 11, 0)");
$db->query("INSERT INTO vwar".$n."_locations VALUES (140, 'Archipel', 11, 0)");
$db->query("INSERT INTO vwar".$n."_locations VALUES (141, 'Dunkler Wald', 11, 0)");
$db->query("INSERT INTO vwar".$n."_locations VALUES (142, 'Festung', 11, 0)");
$db->query("INSERT INTO vwar".$n."_locations VALUES (143, 'Fl?sse', 11, 0)");
$db->query("INSERT INTO vwar".$n."_locations VALUES (144, 'Goldrausch', 11, 0)");
$db->query("INSERT INTO vwar".$n."_locations VALUES (145, 'Hochland', 11, 0)");
$db->query("INSERT INTO vwar".$n."_locations VALUES (146, 'Inseln', 11, 0)");
$db->query("INSERT INTO vwar".$n."_locations VALUES (147, 'Kontinent', 11, 0)");
$db->query("INSERT INTO vwar".$n."_locations VALUES (148, 'Kratersee', 11, 0)");
$db->query("INSERT INTO vwar".$n."_locations VALUES (149, 'K?ste', 11, 0)");
$db->query("INSERT INTO vwar".$n."_locations VALUES (150, 'Mittelmeer', 11, 0)");
$db->query("INSERT INTO vwar".$n."_locations VALUES (151, 'Ostsee', 11, 0)");
$db->query("INSERT INTO vwar".$n."_locations VALUES (152, 'V?lkerwanderung', 11, 0)");
$db->query("INSERT INTO vwar".$n."_locations VALUES (155, 'BR-Anubis', 19, 0)");
$db->query("INSERT INTO vwar".$n."_locations VALUES (156, 'BR-Bifrost', 19, 0)");
$db->query("INSERT INTO vwar".$n."_locations VALUES (157, 'BR-Disclosure', 19, 0)");
$db->query("INSERT INTO vwar".$n."_locations VALUES (158, 'BR-IceFields ', 19, 0)");
$db->query("INSERT INTO vwar".$n."_locations VALUES (159, 'BR-Skyline', 19, 0)");
$db->query("INSERT INTO vwar".$n."_locations VALUES (160, 'BR-Slaughterhouse', 19, 0)");
$db->query("INSERT INTO vwar".$n."_locations VALUES (161, 'BR-TwinTombs', 19, 0)");
$db->query("INSERT INTO vwar".$n."_locations VALUES (162, 'CTF-Chrome', 19, 0)");
$db->query("INSERT INTO vwar".$n."_locations VALUES (163, 'CTF-Citadel', 19, 0)");
$db->query("INSERT INTO vwar".$n."_locations VALUES (164, 'CTF-December', 19, 0)");
$db->query("INSERT INTO vwar".$n."_locations VALUES (165, 'CTF-Face3', 19, 0)");
$db->query("INSERT INTO vwar".$n."_locations VALUES (166, 'CTF-Geothermal', 19, 0)");
$db->query("INSERT INTO vwar".$n."_locations VALUES (167, 'CTF-Lostfaith', 19, 0)");
$db->query("INSERT INTO vwar".$n."_locations VALUES (168, 'CTF-Magma', 19, 0)");
$db->query("INSERT INTO vwar".$n."_locations VALUES (169, 'CTF-Maul', 19, 0)");
$db->query("INSERT INTO vwar".$n."_locations VALUES (170, 'CTF-Orbital2', 19, 0)");
$db->query("INSERT INTO vwar".$n."_locations VALUES (171, 'DM-Antalus', 19, 0)");
$db->query("INSERT INTO vwar".$n."_locations VALUES (172, 'DM-Asbestos', 19, 0)");
$db->query("INSERT INTO vwar".$n."_locations VALUES (173, 'DM-Compressed', 19, 0)");
$db->query("INSERT INTO vwar".$n."_locations VALUES (174, 'DM-Curse3', 19, 0)");
$db->query("INSERT INTO vwar".$n."_locations VALUES (175, 'DM-Flux2', 19, 0)");
$db->query("INSERT INTO vwar".$n."_locations VALUES (176, 'DM-Gael', 19, 0)");
$db->query("INSERT INTO vwar".$n."_locations VALUES (177, 'DM-Inferno', 19, 0)");
$db->query("INSERT INTO vwar".$n."_locations VALUES (178, 'DM-Insidious', 19, 0)");
$db->query("INSERT INTO vwar".$n."_locations VALUES (179, 'DM-Leviathan', 19, 0)");
$db->query("INSERT INTO vwar".$n."_locations VALUES (180, 'DM-Oceanic', 19, 0)");
$db->query("INSERT INTO vwar".$n."_locations VALUES (181, 'DM-Phobos2', 19, 0)");
$db->query("INSERT INTO vwar".$n."_locations VALUES (182, 'DM-Plunge', 19, 0)");
$db->query("INSERT INTO vwar".$n."_locations VALUES (183, 'DM-Serpentine', 19, 0)");
$db->query("INSERT INTO vwar".$n."_locations VALUES (184, 'DM-TokaraForest', 19, 0)");
$db->query("INSERT INTO vwar".$n."_locations VALUES (185, 'DM-TrainingDay', 19, 0)");
$db->query("INSERT INTO vwar".$n."_locations VALUES (186, 'DOM-Core', 19, 0)");
$db->query("INSERT INTO vwar".$n."_locations VALUES (187, 'DOM-OutRigger', 19, 0)");
$db->query("INSERT INTO vwar".$n."_locations VALUES (188, 'DOM-Ruination', 19, 0)");
$db->query("INSERT INTO vwar".$n."_locations VALUES (189, 'DOM-ScorchedEarth', 19, 0)");
$db->query("INSERT INTO vwar".$n."_locations VALUES (190, 'DOM-SepukkuGorge', 19, 0)");
$db->query("INSERT INTO vwar".$n."_locations VALUES (191, 'DOM-Suntemple', 19, 0)");
$db->query("INSERT INTO vwar".$n."_locations VALUES (192, 'TO-Avalanche', 14, 0)");
$db->query("INSERT INTO vwar".$n."_locations VALUES (193, 'TO-Blaze-of-Glory', 14, 0)");
$db->query("INSERT INTO vwar".$n."_locations VALUES (194, 'TO-CIA', 14, 0)");
$db->query("INSERT INTO vwar".$n."_locations VALUES (195, 'TO-Conundrum', 14, 0)");
$db->query("INSERT INTO vwar".$n."_locations VALUES (196, 'TO-Crossfire', 14, 0)");
$db->query("INSERT INTO vwar".$n."_locations VALUES (197, 'TO-Dragon', 14, 0)");
$db->query("INSERT INTO vwar".$n."_locations VALUES (198, 'TO-Drought', 14, 0)");
$db->query("INSERT INTO vwar".$n."_locations VALUES (199, 'TO-Eskero', 14, 0)");
$db->query("INSERT INTO vwar".$n."_locations VALUES (200, 'TO-FrozenScar', 14, 0)");
$db->query("INSERT INTO vwar".$n."_locations VALUES (201, 'TO-GlasgowKiss', 14, 0)");
$db->query("INSERT INTO vwar".$n."_locations VALUES (202, 'TO-KnightsEdge-B1', 14, 0)");
$db->query("INSERT INTO vwar".$n."_locations VALUES (203, 'TO-Metalstorm', 14, 0)");
$db->query("INSERT INTO vwar".$n."_locations VALUES (204, 'TO-November-Rain', 14, 0)");
$db->query("INSERT INTO vwar".$n."_locations VALUES (205, 'TO-Omega', 14, 0)");
$db->query("INSERT INTO vwar".$n."_locations VALUES (206, 'TO-Rebirth', 14, 0)");
$db->query("INSERT INTO vwar".$n."_locations VALUES (207, 'TO-TerrorMansion', 14, 0)");
$db->query("INSERT INTO vwar".$n."_locations VALUES (208, 'TO-Trooper', 14, 0)");
$db->query("INSERT INTO vwar".$n."_locations VALUES (209, 'TO-Unbreakable', 14, 0)");

$db->query("INSERT INTO vwar".$n."_matchtype VALUES (1, 'League Match', 0)");
$db->query("INSERT INTO vwar".$n."_matchtype VALUES (2, 'Train Match', 0)");
$db->query("INSERT INTO vwar".$n."_matchtype VALUES (3, 'Fun Match', 0)");

$db->query("INSERT INTO vwar".$n."_member VALUES (1, 1, 'Admin', '', '0000-00-00', '', '', 'you@yourdomain.com', '', '', '', '', '', '".md5(admin)."', '', 'Administrator', 1, 'english', '', '', '', '', '', '', '', '', '', 1, 0, 0)");

$db->query("INSERT INTO vwar".$n."_memberstatus VALUES (1, 'Leader', '0', 0)");
$db->query("INSERT INTO vwar".$n."_memberstatus VALUES (2, 'Fullmember', '0', 0)");
$db->query("INSERT INTO vwar".$n."_memberstatus VALUES (3, 'Trainee', '0', 0)");
$db->query("INSERT INTO vwar".$n."_memberstatus VALUES (4, 'Inactive Member', '0', 0)");
$db->query("INSERT INTO vwar".$n."_memberstatus VALUES (5, 'Honorary Member ', '0', 0)");
$db->query("INSERT INTO vwar".$n."_memberstatus VALUES (6, 'Ex-Member', '0', 0)");

$db->query("INSERT INTO vwar".$n."_profilefield (fieldname,description,public) VALUES ('Phone','member\'s phonenumber','0')");
$db->query("INSERT INTO vwar".$n."_profilefield (fieldname,description,public) VALUES ('Cellularphone','member\'s cellularphone number','0')");
$db->query("INSERT INTO vwar".$n."_profilefield (fieldname,description,public) VALUES ('Interests','interests of the member','1')");
$db->query("INSERT INTO vwar".$n."_profilefield (fieldname,description,public) VALUES ('Motto','motto of the member','1')");

$db->query("INSERT INTO vwar".$n."_settings VALUES ('My Team', '-(My Team)-', 'http://www.yourdomain.com', 1, 1, 1, 1, 1, 1, 1, 0, 1, 0, 1, '95%', 1024, 768, 3, 3, '#20FF00', '#FF2000', '#0080FF', 'Won', 'Lost', 'Draw', '0', '0', '1', 'd.m.Y', 'd.m.Y, H:i', '1', '15', '?', 'english', '$installversion')");

$db->query("INSERT INTO vwar".$n."_smilie VALUES (1, 'smile', ':)', 'smile.gif', 0)");
$db->query("INSERT INTO vwar".$n."_smilie VALUES (2, 'frown', ':(', 'frown.gif', 0)");
$db->query("INSERT INTO vwar".$n."_smilie VALUES (3, 'embarrasment', ':o', 'redface.gif', 0)");
$db->query("INSERT INTO vwar".$n."_smilie VALUES (4, 'big grin', ':D', 'biggrin.gif', 0)");
$db->query("INSERT INTO vwar".$n."_smilie VALUES (5, 'wink', ';)', 'wink.gif', 0)");
$db->query("INSERT INTO vwar".$n."_smilie VALUES (6, 'stick out tongue', ':P', 'tongue.gif', 0)");
$db->query("INSERT INTO vwar".$n."_smilie VALUES (7, 'cool', '', 'cool.gif', 0)");
$db->query("INSERT INTO vwar".$n."_smilie VALUES (8, 'roll eyes (sarcastic)', '', 'rolleyes.gif', 0)");
$db->query("INSERT INTO vwar".$n."_smilie VALUES (9, 'mad', '', 'mad.gif', 0)");
$db->query("INSERT INTO vwar".$n."_smilie VALUES (10, 'eek!', '', 'eek.gif', 0)");
$db->query("INSERT INTO vwar".$n."_smilie VALUES (11, 'confused', '', 'confused.gif', 0)");
$db->query("INSERT INTO vwar".$n."_smilie VALUES (12, 'impactwhore', ':impact:', 'impactwhore.gif', 0)");
$db->query("INSERT INTO vwar".$n."_smilie VALUES (13, 'headshot', ':headshot:', 'headshot.gif', 0)");
$db->query("INSERT INTO vwar".$n."_smilie VALUES (14, 'globwhore', ':glob:', 'globwhore.gif', 0)");
$db->query("INSERT INTO vwar".$n."_smilie VALUES (15, 'flackwhore', ':flack:', 'flackwhore.gif', 0)");
$db->query("INSERT INTO vwar".$n."_smilie VALUES (16, 'chainsaw', ':chainsaw:', 'chainsaw.gif', 0)");
$db->query("INSERT INTO vwar".$n."_smilie VALUES (17, 'camper', ':camper:', 'camper.gif', 0)");
$db->query("INSERT INTO vwar".$n."_smilie VALUES (18, 'bluecap', ':bluecap:', 'bluecap.gif', 0)");
$db->query("INSERT INTO vwar".$n."_smilie VALUES (19, 'anger', ':angry:', 'anger.gif', 0)");
$db->query("INSERT INTO vwar".$n."_smilie VALUES (20, 'angel', '', 'angel.gif', 0)");
$db->query("INSERT INTO vwar".$n."_smilie VALUES (21, 'enforcer', ':enforcer:', 'enforcer.gif', 0)");
$db->query("INSERT INTO vwar".$n."_smilie VALUES (22, 'instagib', ':instagib:', 'instagib.gif', 0)");
$db->query("INSERT INTO vwar".$n."_smilie VALUES (23, 'king', '', 'king.gif', 0)");
$db->query("INSERT INTO vwar".$n."_smilie VALUES (24, 'knife', ':knife:', 'messer.gif', 0)");
$db->query("INSERT INTO vwar".$n."_smilie VALUES (25, 'mgwhore', ':mgwhore:', 'mgwhore.gif', 0)");
$db->query("INSERT INTO vwar".$n."_smilie VALUES (26, 'plasmawhore', ':Plasma:', 'plasmawhore.gif', 0)");
$db->query("INSERT INTO vwar".$n."_smilie VALUES (27, 'redcap', ':redcap:', 'redcap.gif', 0)");
$db->query("INSERT INTO vwar".$n."_smilie VALUES (28, 'ripper', ':ripper:', 'ripper.gif', 0)");
$db->query("INSERT INTO vwar".$n."_smilie VALUES (29, 'rocket', ':rocket:', 'rocket2.gif', 0)");
$db->query("INSERT INTO vwar".$n."_smilie VALUES (30, 'rocketwhore', ':rocket2:', 'rocketwhore.gif', 0)");
$db->query("INSERT INTO vwar".$n."_smilie VALUES (31, 'sex', '', 'sex.gif', 0)");
$db->query("INSERT INTO vwar".$n."_smilie VALUES (32, 'shockwhore', ':shock:', 'shockwhore.gif', 0)");
$db->query("INSERT INTO vwar".$n."_smilie VALUES (33, 'smokin', '', 'smokin.gif', 0)");
$db->query("INSERT INTO vwar".$n."_smilie VALUES (34, 'finger', ':finger:', 'thefinger.gif', 0)");
$db->query("INSERT INTO vwar".$n."_smilie VALUES (35, 'transloc', ':transloc:', 'transloc.gif', 0)");
$db->query("INSERT INTO vwar".$n."_smilie VALUES (36, 'sleep', '', 'sleep.gif', 0)");
$db->query("INSERT INTO vwar".$n."_smilie VALUES (37, 'bash', ':bash:', 'bash.gif', 0)");
$db->query("INSERT INTO vwar".$n."_smilie VALUES (38, 'frustration', '', 'frust.gif', 0)");
$db->query("INSERT INTO vwar".$n."_smilie VALUES (39, 'holy', '', 'holy.gif', 0)");
$db->query("INSERT INTO vwar".$n."_smilie VALUES (41, 'kiss', '', 'kiss.gif', 0)");
$db->query("INSERT INTO vwar".$n."_smilie VALUES (42, 'megarofl', '', 'megarofl.gif', 0)");
$db->query("INSERT INTO vwar".$n."_smilie VALUES (43, 'scared', '', 'scared.gif', 0)");
$db->query("INSERT INTO vwar".$n."_smilie VALUES (44, 'thumb', '', 'thumb.gif', 0)");
$db->query("INSERT INTO vwar".$n."_smilie VALUES (45, 'shy', '', 'shy.gif', 0)");
$db->query("INSERT INTO vwar".$n."_smilie VALUES (46, 'rail', ':rail:', 'rail.gif', 0)");
$db->query("INSERT INTO vwar".$n."_smilie VALUES (47, 'grenade', ':grenade:', 'grenade.gif', 0)");
$db->query("INSERT INTO vwar".$n."_smilie VALUES (48, 'bluescreen', ':bluescreen:', 'bluescreen.gif', 0)");
$db->query("INSERT INTO vwar".$n."_smilie VALUES (49, 'gauntlet', ':gauntlet:', 'gauntlet.gif', 0)");
$db->query("INSERT INTO vwar".$n."_smilie VALUES (50, 'grenade2', ':grenade2:', 'grenade2.gif', 0)");
$db->query("INSERT INTO vwar".$n."_smilie VALUES (51, 'love', '', 'love.gif', 0)");
$db->query("INSERT INTO vwar".$n."_smilie VALUES (52, 'plasma', ':qplasma:', 'plasma.gif', 0)");
$db->query("INSERT INTO vwar".$n."_smilie VALUES (53, 'puke', '', 'puke.gif', 0)");
$db->query("INSERT INTO vwar".$n."_smilie VALUES (54, 'qrocket', ':qrocket:', 'qrocket.gif', 0)");
$db->query("INSERT INTO vwar".$n."_smilie VALUES (55, 'shaft', '', 'shaft.gif', 0)");
$db->query("INSERT INTO vwar".$n."_smilie VALUES (56, 'sound', '', 'sound.gif', 0)");
$db->query("INSERT INTO vwar".$n."_smilie VALUES (57, 'wave', '', 'wave.gif', 0)");
$db->query("INSERT INTO vwar".$n."_smilie VALUES (58, 'AR15 Gunfire', ':ar15:', 'ar15.gif', 0)");
$db->query("INSERT INTO vwar".$n."_smilie VALUES (59, 'Blah', '', 'blah.gif', 0)");
$db->query("INSERT INTO vwar".$n."_smilie VALUES (60, 'Deal', ':deal:', 'deal.gif', 0)");
$db->query("INSERT INTO vwar".$n."_smilie VALUES (61, 'Fart', '', 'fart.gif', 0)");
$db->query("INSERT INTO vwar".$n."_smilie VALUES (62, 'Fart2', ':fart2:', 'fart2.gif', 0)");
$db->query("INSERT INTO vwar".$n."_smilie VALUES (63, 'Quake 1', ':q1:', 'q1.gif', 0)");
$db->query("INSERT INTO vwar".$n."_smilie VALUES (64, 'Quake 2', ':q2:', 'q2.gif', 0)");
$db->query("INSERT INTO vwar".$n."_smilie VALUES (65, 'Quake 3', ':q3:', 'q3.gif', 0)");
$db->query("INSERT INTO vwar".$n."_smilie VALUES (66, 'Rocking', ':rock:', 'rock.gif', 0)");
$db->query("INSERT INTO vwar".$n."_smilie VALUES (67, 'Stupid', '', 'stupid.gif', 0)");
$db->query("INSERT INTO vwar".$n."_smilie VALUES (68, 'What\'s up ?', '', 'wazzup.gif', 0)");
$db->query("INSERT INTO vwar".$n."_smilie VALUES (69, 'Wow', '', 'wow.gif', 0)");

?>

» Tables filled successfully!


» <a href="<?= $installfile; ?>?step=6">Click here to continue the installation!</a>

</td>
</tr>
</table>

<?
}

if($step==6) {
echo $header;
$uploadfile="vwar.style";
if(@file_exists($uploadfile)) {
?>

<table border="0" align="center" width="90%" cellpadding="3" cellspacing="1">
<tr>
<td class="infobox">

» Importing Styles!

<?
$style = implode("",file($uploadfile));
$style = explode("~~~~~~", $style);

$replace = explode("~~~",$style[0]);
for($i=0;$i<count($replace)/3;$i++) $db->query("INSERT INTO vwar".$n."_replacement (replacementid,findword,replaceword) VALUES ('".addslashes($replace[$i*3])."','".addslashes($replace[$i*3+1])."','".addslashes($replace[$i*3+2])."')");

$templates = explode("~~~",$style[1]);
for($i=0;$i<count($templates)/2;$i++) $db->query("INSERT INTO vwar".$n."_template (templatename,template,isinactive) VALUES ('".addslashes($templates[$i*2])."','".addslashes($templates[$i*2+1])."','0')");
?>

» Styles imported successfully!


» <a href="<?= $installfile; ?>?step=7">Click here to continue the installation!</a>

<?
}
else
{
?>

» <?= $uploadfile; ?> file is missing!


» <a href="<?= $installfile; ?>?step=6">Upload file into admin directory and click here!</a>

<?
}
?>
</td>
</tr>
</table>

<?
}

if($step==7) {
echo $header;
?>

<table border="0" align="center" width="90%" cellpadding="3" cellspacing="1">
<tr>
<td class="infobox">

» Installation was completed succesfully!


» Delete <?= $installfile; ?>!!!!


» <a href="index.php">Click here to enter the Admin Control Panel!</a>


» Password is: admin

</td>
</tr>
</table>

<?
}
?>

</body>
</html>
scaone

scaone hat kostenlosen Webspace.

18:06, 19.8.2004
kann das vieleicht daran liegen das ich das seperat auf ner 2 daten bank machen muss?? also ne neue ersteigern und die daten von der neien in der config eingeben muss?
jacr

jacr hat kostenlosen Webspace.

19:01, 19.8.2004

freak89 schrieb:
VWar ist ein PHP-Script und geh?rt doch eigendlich
in die daf?r vorhergesehene Kategorie...

Du sagst es.
Darum habe ich es verschoben.

Jens
scaone

scaone hat kostenlosen Webspace.

20:14, 19.8.2004
kann mir den bitte keiner helfen hat den echt keiner ahnung von vwar????

kann geschlossen werden versuche es nochmal mit 1.5
Diskutiere mit und stelle Fragen: Jetzt kostenlos anmelden!

lima-city: Gratis werbefreier Webspace für deine eigene Homepage

Dir gefällt dieses Thema?

Über lima-city

lima-city bietet dir kostenlosen und werbefreien Speicherplatz für Deine Homepage. Sofort anmelden und direkt loslegen mit Webspace, PHP, Datenbanken, günstigen Domains und einer tollen Community!

kostenloser Webspace werbefrei: lima-city

Vwar

lima-city → Forum → Programmiersprachen → PHP, MySQL & .htaccess

Dir gefällt dieses Thema?

Über lima-city

Login zum Webhosting ohne Werbung!