query_first("SELECT vwarversion FROM vwar".$n."_settings");
// ############################## UPDATE PRECHECK #################################
// check if the version to install is the same as the installed
if ($result["vwarversion"] >= $newversion)
{
printHeader("Update from ".$oldversion." to ".$newversion, 2);
?>
 Error |
You have already running Version of Virtual War!
Installation Aborted!
|
| Error |
This Update only runs with Version of Virtual War installed!
Installation Aborted!
|
| 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="">
|
';
fwrite($fp,$config,strlen($config));
fclose($fp);
header("Location: update.php?step=1");
exit();
}
printHeader("Update from ".$oldversion." to ".$newversion, 2);
?>
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++; //echo "» vwar".$n."_acpmenugroups table created
";
$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++; //echo "» vwar".$n."_acpmenuitems table created
";
$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++; //echo "» vwar".$n."_bbcode table created
";
$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++; //echo "» vwar".$n."_customlanguage table created
";
$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++; //echo "» vwar".$n."_emailgroup table created
";
$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++; //echo "» vwar".$n."_emailgroupmember table created
";
$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++; //echo "» vwar".$n."_pfield_cat table created
";
$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++; //echo "» vwar".$n."_search table created
";
$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++; //echo "» vwar".$n."_quickjump table created
";
$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++; //echo "» vwar".$n."_cashcat table created
";
//news
$result = mysql_list_tables($sql["database"]);
for ($i = 0; $i < $vwardb->num_rows($result); $i++)
{
if (mysql_tablename($result,$i) == "vwar".$n."_news")
{
$tab_news = true;
}
else if (mysql_tablename($result,$i) == "vwar".$n."_newscat")
{
$tab_newscat = true;
}
else if (mysql_tablename($result,$i) == "vwar".$n."_newslink")
{
$tab_newslink = true;
}
else if (mysql_tablename($result,$i) == "vwar".$n."_newscomment")
{
$tab_newscomment = true;
}
}
if ($tab_news)
{
$vwardb->query("ALTER TABLE vwar".$n."_news ADD convertsmilies SMALLINT(1) NOT NULL DEFAULT '1' AFTER content");
$vwardb->query("ALTER TABLE vwar".$n."_news ADD converturls SMALLINT(1) NOT NULL DEFAULT '1' AFTER convertsmilies");
$vwardb->query("ALTER TABLE vwar".$n."_news ADD allowcomments SMALLINT(1) NOT NULL DEFAULT '1' AFTER converturls");
$vwardb->query("ALTER TABLE vwar".$n."_news ADD submitname VARCHAR(255) NOT NULL DEFAULT '' AFTER allowcomments");
$vwardb->query("ALTER TABLE vwar".$n."_news ADD submitinfo VARCHAR(255) NOT NULL DEFAULT '' AFTER submitname");
}
else
{
$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)
)");
$tblcount++;
}
if ($tab_newscat)
{
$vwardb->query("ALTER TABLE vwar".$n."_newscat ADD intern SMALLINT(1) NOT NULL DEFAULT '0' AFTER caticon");
}
else
{
$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)
)");
$tblcount++;
}
if ($tab_newslink)
{
$vwardb->query("ALTER TABLE vwar".$n."_newslink ADD target VARCHAR(10) NOT NULL DEFAULT '_blank' AFTER url");
}
else
{
$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)
)");
$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 '',
standardcatintern SMALLINT(5) NOT NULL DEFAULT '',
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'
)");
$tblcount++;
?>
| Database Maintenance |
All tables () have been created successfully!
|
query("ALTER TABLE vwar".$n." ADD mailgroupid SMALLINT( 5 ) DEFAULT '0' NOT NULL AFTER gameid");
$vwardb->query("ALTER TABLE vwar".$n." ADD repeat_mod VARCHAR( 6 ) DEFAULT '' NOT NULL AFTER dateline");
$vwardb->query("ALTER TABLE vwar".$n." ADD repeat_number VARCHAR( 10 ) DEFAULT '' NOT NULL AFTER repeat_mod");
$vwardb->query("ALTER TABLE vwar".$n." ADD repeat_saveas SMALLINT( 1 ) DEFAULT '0' NOT NULL AFTER repeat_number");
$vwardb->query("ALTER TABLE vwar".$n."_accessgroup ADD canfinishwar SMALLINT( 1 ) DEFAULT '0' NOT NULL AFTER caneditwar");
$vwardb->query("ALTER TABLE vwar".$n."_accessgroup ADD canaddmailgroup SMALLINT( 1 ) DEFAULT '0' NOT NULL AFTER candeleteprofilefield");
$vwardb->query("ALTER TABLE vwar".$n."_accessgroup ADD caneditmailgroup SMALLINT( 1 ) DEFAULT '0' NOT NULL AFTER canaddmailgroup");
$vwardb->query("ALTER TABLE vwar".$n."_accessgroup ADD candeletemailgroup SMALLINT( 1 ) DEFAULT '0' NOT NULL AFTER caneditmailgroup");
$vwardb->query("ALTER TABLE vwar".$n."_accessgroup ADD cansendmembermail SMALLINT( 1 ) DEFAULT '0' NOT NULL AFTER candeletemailgroup");
$vwardb->query("ALTER TABLE vwar".$n."_accessgroup ADD canmanagecomments SMALLINT( 1 ) DEFAULT '0' NOT NULL AFTER candeletelocation");
//news access
$row = $vwardb->query_first("SELECT * FROM vwar".$n."_accessgroup");
while (list($key,) = each($row))
{
$accessfields[] = $key;
}
if(!inarray("canaddnews",$accessfields))
{
$vwardb->query("ALTER TABLE vwar".$n."_accessgroup ADD canaddnews SMALLINT( 1 ) DEFAULT '0' NOT NULL AFTER canmanagecomments");
}
if(!inarray("caneditnews",$accessfields))
{
$vwardb->query("ALTER TABLE vwar".$n."_accessgroup ADD caneditnews SMALLINT( 1 ) DEFAULT '0' NOT NULL AFTER canaddnews");
}
if(!inarray("candeletenews",$accessfields))
{
$vwardb->query("ALTER TABLE vwar".$n."_accessgroup ADD candeletenews SMALLINT( 1 ) DEFAULT '0' NOT NULL AFTER caneditnews");
}
if(!inarray("canaddcategory",$accessfields))
{
$vwardb->query("ALTER TABLE vwar".$n."_accessgroup ADD canaddcategory SMALLINT( 1 ) DEFAULT '0' NOT NULL AFTER candeletenews");
}
if(!inarray("caneditcategory",$accessfields))
{
$vwardb->query("ALTER TABLE vwar".$n."_accessgroup ADD caneditcategory SMALLINT( 1 ) DEFAULT '0' NOT NULL AFTER canaddcategory");
}
if(!inarray("candeletecategory",$accessfields))
{
$vwardb->query("ALTER TABLE vwar".$n."_accessgroup ADD candeletecategory SMALLINT( 1 ) DEFAULT '0' NOT NULL AFTER caneditcategory");
}
$vwardb->query("ALTER TABLE vwar".$n."_accessgroup ADD canaddpermission SMALLINT ( 1 ) DEFAULT '0' NOT NULL AFTER candeletecategory");
$vwardb->query("ALTER TABLE vwar".$n."_accessgroup ADD caneditpermission SMALLINT ( 1 ) DEFAULT '0' NOT NULL AFTER canaddpermission");
$vwardb->query("ALTER TABLE vwar".$n."_accessgroup ADD candeletepermission SMALLINT ( 1 ) DEFAULT '0' NOT NULL AFTER caneditpermission");
$vwardb->query("ALTER TABLE vwar".$n."_accessgroup ADD caneditmemberpermission SMALLINT ( 1 ) DEFAULT '0' NOT NULL AFTER candeletepermission");
$vwardb->query("ALTER TABLE vwar".$n."_accessgroup ADD canaccessbackup SMALLINT ( 1 ) DEFAULT '0' NOT NULL AFTER caneditmemberpermission");
$vwardb->query("ALTER TABLE vwar".$n."_accessgroup ADD canaddcashcategory SMALLINT ( 1 ) DEFAULT '0' NOT NULL AFTER candeletecash");
$vwardb->query("ALTER TABLE vwar".$n."_accessgroup ADD caneditcashcategory SMALLINT ( 1 ) DEFAULT '0' NOT NULL AFTER canaddcashcategory");
$vwardb->query("ALTER TABLE vwar".$n."_accessgroup ADD candeletecashcategory SMALLINT ( 1 ) DEFAULT '0' NOT NULL AFTER caneditcashcategory");
$vwardb->query("ALTER TABLE vwar".$n."_calendarevents ADD enddate INT( 11 ) DEFAULT '' NOT NULL AFTER eventdate");
//convert events
$result = $vwardb->query("SELECT eventdate,eventid FROM vwar".$n."_calendarevents");
$count = 0;
while ($row = $vwardb->fetch_array($result))
{
$dates[$count] = $row;
$count++;
}
$vwardb->free_result($result);
$vwardb->query("ALTER TABLE vwar".$n."_calendarevents CHANGE eventdate eventdate INT( 11 ) NOT NULL");
for ($i = 0; $i < count($dates); $i++)
{
$oldtime = explode("-",$dates[$i]["eventdate"]);
$newtime = mktime(12,00,00,$oldtime[1],$oldtime[2],$oldtime[0]);
$vwardb->query("UPDATE vwar".$n."_calendarevents set eventdate = '$newtime' WHERE eventid = '".$dates[$i]["eventid"]."'");
//$vwardb->query("INSERT INTO vwar".$n."_calendarevents ('eventdate') VALUES ('$newtime') WHERE eventid = '".$dates[$i]["eventid"]."'");
}
$vwardb->query("ALTER TABLE vwar".$n."_comments CHANGE guestip ip VARCHAR( 20 ) NOT NULL");
$vwardb->query("ALTER TABLE vwar".$n."_comments CHANGE warid sourceid SMALLINT( 5 ) DEFAULT '0' NOT NULL");
$vwardb->query("ALTER TABLE vwar".$n."_comments ADD frompage VARCHAR ( 10 ) DEFAULT 'war' NOT NULL AFTER commentid");
$vwardb->query("ALTER TABLE vwar".$n."_comments ADD iconid SMALLINT( 5 ) DEFAULT '' NOT NULL AFTER memberid");
$vwardb->query("ALTER TABLE vwar".$n."_comments ADD guestyim VARCHAR( 30 ) DEFAULT '' NOT NULL AFTER guesticq");
$vwardb->query("ALTER TABLE vwar".$n."_comments ADD guestmsn VARCHAR( 30 ) DEFAULT '' NOT NULL AFTER guestyim");
$vwardb->query("ALTER TABLE vwar".$n."_comments ADD guestaim VARCHAR( 30 ) DEFAULT '' NOT NULL AFTER guestmsn");
$vwardb->query("ALTER TABLE vwar".$n."_comments ADD title VARCHAR( 255 ) DEFAULT '' NOT NULL AFTER ip");
$vwardb->query("ALTER TABLE vwar".$n."_comments ADD editdateline INT( 11 ) DEFAULT '' NOT NULL AFTER comment");
$vwardb->query("ALTER TABLE vwar".$n."_comments ADD editmemberid SMALLINT( 5 ) DEFAULT '' NOT NULL AFTER editdateline");
$vwardb->query("ALTER TABLE vwar".$n."_comments DROP allowsmilies");
$vwardb->query("ALTER TABLE vwar".$n."_comments DROP allowhtml");
$vwardb->query("ALTER TABLE vwar".$n."_comments DROP deleted");
// alter the icq fields to varchar fields
$vwardb->query("ALTER TABLE vwar".$n."_challenge CHANGE contacticq contacticq varchar(30) NOT NULL default ''");
$vwardb->query("ALTER TABLE vwar".$n."_comments CHANGE guesticq guesticq varchar(30) NOT NULL default ''");
$vwardb->query("ALTER TABLE vwar".$n."_join CHANGE contacticq contacticq varchar(30) NOT NULL default ''");
$vwardb->query("ALTER TABLE vwar".$n."_member CHANGE icq icq varchar(30) NOT NULL default ''");
$vwardb->query("ALTER TABLE vwar".$n."_opponents CHANGE oppcontacticq oppcontacticq varchar(30) NOT NULL default ''");
//news comments
if ($GPC['c'] == "checked")
{
$result = $vwardb->query("SELECT * FROM vwar".$n."_newscomment");
while ($row = $vwardb->fetch_array($result))
{
$vwardb->query("
INSERT INTO vwar".$n."_comments
VALUES (
NULL ,
'news' ,
'".$row["newsid"]."' ,
'".$row["memberid"]."' ,
'' ,
'".$row["posternick"]."' ,
'".$row["posteremail"]."' ,
'".$row["posterhomepage"]."' ,
'".$row["postericq"]."' ,
'".$row["posteryim"]."' ,
'".$row["postermsn"]."' ,
'".$row["posteraim"]."' ,
'".$row["posterip"]."' ,
'' ,
'".$row["posttext"]."' ,
'' ,
'' ,
'".$row["dateline"]."')
");
}
$vwardb->query("DROP TABLE IF EXISTS vwar".$n."_newscomment");
$vwardb->free_result($result);
}
// update comments
unset($row);
unset($result);
$result = $vwardb->query("SELECT name,memberid FROM vwar".$n."_member");
while($row = $vwardb->fetch_array($result))
{
$vwardb->query("
UPDATE vwar".$n."_comments
SET
memberid = '".$row["memberid"]."', guestname = '', guestemail = '', guesticq = 0,
guesthomepage = '', guestyim = '', guestmsn = '', guestaim = ''
WHERE guestname = '".$row["name"]."' OR memberid = '".$row["memberid"]."'");
}
$vwardb->free_result($result);
$vwardb->query("ALTER TABLE vwar".$n."_locations ADD locationpic VARCHAR( 100 ) DEFAULT '' NOT NULL AFTER locationname");
$vwardb->query("ALTER TABLE vwar".$n."_matchtype ADD matchtypeurl VARCHAR( 255 ) NOT NULL AFTER matchtypename");
$vwardb->query("ALTER TABLE vwar".$n."_matchtype ADD public SMALLINT( 5 ) DEFAULT '1' NOT NULL AFTER matchtypeurl");
$vwardb->query("ALTER TABLE vwar".$n."_member ADD signature TEXT NOT NULL DEFAULT '' AFTER deleted");
$vwardb->query("ALTER TABLE vwar".$n."_member ADD lastactivity INT ( 10 ) DEFAULT '' NOT NULL AFTER signature");
$vwardb->query("ALTER TABLE vwar".$n."_member DROP deleted");
$vwardb->query("ALTER TABLE vwar".$n."_settings
ADD timezoneoffsetuser VARCHAR( 4 ) DEFAULT '0' NOT NULL AFTER timezoneoffset,
ADD showreport SMALLINT( 1 ) DEFAULT '1' NOT NULL AFTER showgameicons,
ADD ownmail VARCHAR( 100 ) DEFAULT 'admin@yourdomain.com' NOT NULL AFTER ownhomepage,
ADD urltovwar VARCHAR( 250 ) DEFAULT 'http://www.yourdomain.com/vwar/' NOT NULL AFTER ownmail,
ADD cookiedomain VARCHAR( 100 ) NOT NULL AFTER urltovwar,
ADD cookiepath VARCHAR( 100 ) NOT NULL AFTER cookiedomain,
ADD bbcode SMALLINT( 1 ) DEFAULT '1' NOT NULL AFTER htmlcode,
ADD whoisonline SMALLINT( 1 ) DEFAULT '1' NOT NULL AFTER bbcode,
ADD formmailer SMALLINT( 1 ) DEFAULT '1' NOT NULL AFTER whoisonline,
ADD allowmails SMALLINT( 1 ) DEFAULT '1' NOT NULL AFTER formmailer,
ADD nomemberpic VARCHAR( 100 ) DEFAULT '' NOT NULL AFTER favperline,
ADD censor SMALLINT( 1 ) DEFAULT '1' NOT NULL AFTER guestcomments,
ADD censorwords TEXT NOT NULL AFTER censor,
ADD censorsign VARCHAR( 10 ) NOT NULL DEFAULT '*' AFTER censorwords,
ADD censorformembers SMALLINT( 1 ) DEFAULT '0' NOT NULL AFTER censorsign,
ADD sendwarmail SMALLINT( 1 ) DEFAULT '1' NOT NULL AFTER censorformembers,
ADD warmailhtml SMALLINT( 5 ) DEFAULT '0' NOT NULL AFTER sendwarmail,
ADD warmailsubjectnew VARCHAR( 100 ) DEFAULT 'New War added!' NOT NULL AFTER warmailhtml,
ADD warmailsubjectchanged VARCHAR( 100 ) DEFAULT 'War changed!' NOT NULL AFTER warmailsubjectnew,
ADD warmailpriority SMALLINT( 5 ) DEFAULT '3' NOT NULL AFTER warmailsubjectchanged,
ADD deletedwars SMALLINT( 5 ) DEFAULT '0' NOT NULL AFTER moneysymbol,
ADD challengeenabled SMALLINT( 1 ) DEFAULT '1' NOT NULL AFTER deletedwars,
ADD joinenabled SMALLINT( 1 ) DEFAULT '1' NOT NULL AFTER challengeenabled,
ADD thumbnailwidth SMALLINT( 4 ) NOT NULL DEFAULT '150' AFTER screenshotheight,
ADD thumbnailheight SMALLINT( 4 ) NOT NULL DEFAULT '150' AFTER thumbnailwidth,
ADD ab_enabled SMALLINT( 4 ) NOT NULL DEFAULT '0' AFTER vwarlanguage,
ADD ab_user MEDIUMTEXT NOT NULL AFTER ab_enabled,
ADD ab_days VARCHAR( 7 ) NOT NULL DEFAULT '' AFTER ab_user,
ADD ab_fallback INT( 11 ) NOT NULL DEFAULT '48' AFTER ab_days,
ADD ab_tables CHAR( 1 ) NOT NULL DEFAULT 'v' AFTER ab_fallback,
ADD ab_deloldfiles SMALLINT( 1 ) NOT NULL DEFAULT '0' AFTER ab_tables,
ADD gzip SMALLINT( 1 ) NOT NULL DEFAULT '0' AFTER ab_deloldfiles,
ADD showsignature SMALLINT( 1 ) NOT NULL DEFAULT '0' AFTER gzip");
$vwardb->query("ALTER TABLE vwar".$n."_smilie ADD smilie SMALLINT( 1 ) DEFAULT '1' NOT NULL AFTER filename");
$vwardb->query("ALTER TABLE vwar".$n."_smilie ADD icon SMALLINT( 1 ) DEFAULT '0' NOT NULL AFTER smilie");
$vwardb->query("ALTER TABLE vwar".$n."_team ADD invisible SMALLINT( 1 ) DEFAULT '0' NOT NULL AFTER displayorder");
$vwardb->query("ALTER TABLE vwar".$n."_cash ADD catid SMALLINT( 5 ) DEFAULT '0' NOT NULL AFTER purpose");
$vwardb->query("ALTER TABLE vwar".$n."_template ADD isspecial SMALLINT( 1 ) DEFAULT '0' NOT NULL AFTER template");
$vwardb->query("ALTER TABLE vwar".$n."_profilefield ADD adminonly SMALLINT( 6 ) DEFAULT '0' NOT NULL AFTER displayorder");
$vwardb->query("ALTER TABLE vwar".$n."_profilefield ADD smiliecode SMALLINT( 6 ) DEFAULT '0' NOT NULL AFTER adminonly");
$vwardb->query("ALTER TABLE vwar".$n."_profilefield ADD htmlcode SMALLINT( 6 ) DEFAULT '0' NOT NULL AFTER smiliecode");
$vwardb->query("ALTER TABLE vwar".$n."_profilefield ADD bbcode SMALLINT( 6 ) DEFAULT '0' NOT NULL AFTER htmlcode");
$vwardb->query("ALTER TABLE vwar".$n."_profilefield ADD allowimages SMALLINT( 6 ) DEFAULT '0' NOT NULL AFTER bbcode");
$vwardb->query("ALTER TABLE vwar".$n."_profilefield ADD fieldlength SMALLINT( 6 ) DEFAULT '100' NOT NULL AFTER allowimages");
$vwardb->query("ALTER TABLE vwar".$n."_profilefield ADD cat_id SMALLINT( 6 ) DEFAULT '0' NOT NULL AFTER fieldlength");
$vwardb->query("ALTER TABLE vwar".$n."_memberprofilefield CHANGE fieldvalue fieldvalue TEXT NOT NULL");
$vwardb->query("ALTER TABLE vwar".$n."_memberprofilefield CHANGE memberprofilefieldid memberprofilefieldid INT( 5 ) UNSIGNED NOT NULL AUTO_INCREMENT");
$vwardb->query("ALTER TABLE vwar".$n."_memberlocation CHANGE memberlocationid `memberlocationid` INT NOT NULL AUTO_INCREMENT");
$vwardb->query("ALTER TABLE vwar".$n."_membergames CHANGE membergamesid membergamesid INT( 5 ) UNSIGNED NOT NULL AUTO_INCREMENT");
$vwardb->query("
UPDATE vwar".$n."_accessgroup
SET
canfinishwar = '1',
canaddmailgroup = '1',
caneditmailgroup = '1',
candeletemailgroup = '1',
cansendmembermail = '1',
canmanagecomments = '1',
canaddnews = '1',
caneditnews = '1',
candeletenews = '1',
canaddcategory = '1',
caneditcategory = '1',
candeletecategory = '1',
canaddpermission = '1',
candeletepermission = '1',
caneditpermission = '1',
caneditmemberpermission = '1',
canaccessbackup = '1',
canaddcashcategory = '1',
caneditcashcategory = '1',
candeletecashcategory = '1'
WHERE isadmin = '1'
");
$vwardb->query("UPDATE vwar".$n."_accessgroup SET canfinishwar = '1' WHERE caneditwar = '1'");
$vwardb->query("UPDATE vwar".$n."_replacement SET findword = '' WHERE findword = ''");
$vwardb->query("UPDATE vwar".$n."_replacement SET findword = '' WHERE findword = ''");
$vwardb->query("INSERT INTO vwar".$n."_replacement (replacementid, findword, replaceword) VALUES (NULL, '', '')");
$vwardb->query("INSERT INTO vwar".$n."_replacement (replacementid, findword, replaceword) VALUES (NULL, '', '')");
$vwardb->query("INSERT INTO vwar".$n."_replacement (replacementid, findword, replaceword) VALUES (NULL, '', '')");
$vwardb->query("INSERT INTO vwar".$n."_replacement (replacementid, findword, replaceword) VALUES (NULL, '', '')");
$vwardb->query("INSERT INTO vwar".$n."_replacement (replacementid, findword, replaceword) VALUES (NULL, '{codeboxcolor}', '#FFFFFF')");
$vwardb->query("UPDATE vwar".$n."_smilie SET icon = '1' WHERE code = ':)'");
$vwardb->query("UPDATE vwar".$n."_smilie SET icon = '1' WHERE code = ';)'");
$vwardb->query("UPDATE vwar".$n."_smilie SET icon = '1' WHERE code = ':D'");
$vwardb->query("UPDATE vwar".$n."_smilie SET icon = '1' WHERE code = ':o'");
$vwardb->query("UPDATE vwar".$n."_smilie SET icon = '1' WHERE code = ':cool:'");
$vwardb->query("UPDATE vwar".$n."_smilie SET icon = '1' WHERE code = ':('");
$vwardb->query("UPDATE vwar".$n."_smilie SET icon = '1' WHERE code = ':mad:'");
$vwardb->query("UPDATE vwar".$n."_smilie SET icon = '1' WHERE code = ':rolleyes:'");
$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."_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."_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', '', '', 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', '![](\"{VWAR_BBCODE_FUNCTION_#1}\")
', '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', '', '', 0, 3, '[marquee=blue,right]Around the World...[/marquee]', 0, 1),
(29, 'marquee', '', '', 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', '![](\"\\\\1\")
', '', 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', '', '', 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."_newssettings VALUES (1, '-more-', '', '', 10, 1, 1, 1, '[b]News is offline![/b]', 1)");
$vwardb->query("INSERT INTO vwar".$n."_smilie (title,code,filename,smilie,icon,deleted) VALUES ('Question',':?:','question.gif',1,1,0)");
$vwardb->query("INSERT INTO vwar".$n."_smilie (title,code,filename,smilie,icon,deleted) VALUES ('Warning',':!:','warning.gif',1,1,0)");
$vwardb->query("INSERT INTO vwar".$n."_smilie (title,code,filename,smilie,icon,deleted) VALUES ('Thumb up',':thumbup:','thumbup.gif',1,1,0)");
$vwardb->query("INSERT INTO vwar".$n."_smilie (title,code,filename,smilie,icon,deleted) VALUES ('Thumb down',':thumbdown:','thumbdown.gif',1,1,0)");
$vwardb->query("INSERT INTO vwar".$n."_smilie (title,code,filename,smilie,icon,deleted) VALUES ('Crying',':\'(','crying.gif',1,0,0)");
// delete old templates
$vwardb->query("DELETE FROM vwar".$n."_template WHERE templatename = 'message_joinus'");
$vwardb->query("DELETE FROM vwar".$n."_template WHERE templatename = 'message_error_forgotpw'");
$vwardb->query("DELETE FROM vwar".$n."_template WHERE templatename = 'admin_message_error_permission'");
$vwardb->query("DELETE FROM vwar".$n."_template WHERE templatename = 'message_challenge'");
$vwardb->query("DELETE FROM vwar".$n."_template WHERE templatename = 'message_confirmation_formmailer'");
$vwardb->query("DELETE FROM vwar".$n."_template WHERE templatename = 'message_confirmation_search'");
$vwardb->query("DELETE FROM vwar".$n."_template WHERE templatename = 'message_confirmation_formmailer'");
$vwardb->query("DELETE FROM vwar".$n."_template WHERE templatename = 'admin_memberlocationfav'");
$vwardb->query("DELETE FROM vwar".$n."_template WHERE templatename = 'message_error_commentadd_registered'");
$vwardb->query("DELETE FROM vwar".$n."_template WHERE templatename = 'admin_memberlocationfavmaxreached'");
$vwardb->query("DELETE FROM vwar".$n."_template WHERE templatename = 'admin_memberlocationfavnolocations'");
$vwardb->query("DELETE FROM vwar".$n."_template WHERE templatename = 'nextaction_nav_line'");
$vwardb->query("DELETE FROM vwar".$n."_template WHERE templatename = 'nextaction_nav_membergames'");
$vwardb->query("DELETE FROM vwar".$n."_template WHERE templatename = 'war_addcommentmember'");
$vwardb->query("DELETE FROM vwar".$n."_template WHERE templatename = 'war_addcommentguest'");
$vwardb->query("DELETE FROM vwar".$n."_template WHERE templatename = 'war_editcommentguest'");
$vwardb->query("DELETE FROM vwar".$n."_template WHERE templatename = 'war_editcommentmember'");
$vwardb->query("DELETE FROM vwar".$n."_template WHERE templatename = 'war_comment'");
$vwardb->query("DELETE FROM vwar".$n."_template WHERE templatename = 'war_commentbit'");
$vwardb->query("DELETE FROM vwar".$n."_template WHERE templatename = 'warlist'");
$vwardb->query("DELETE FROM vwar".$n."_template WHERE templatename = 'member_profile_phonebit'");
$vwardb->query("DELETE FROM vwar".$n."_template WHERE templatename = 'member_profile_gametypestatbit'");
$vwardb->query("DELETE FROM vwar".$n."_template WHERE templatename = 'news_newslistbit_linkbit'");
$vwardb->query("DELETE FROM vwar".$n."_template WHERE templatename = 'news_newslistbit_nolinks'");
$vwardb->query("DELETE FROM vwar".$n."_template WHERE templatename = 'news_nownews'");
$vwardb->query("DELETE FROM vwar".$n."_template WHERE templatename = 'admin_countryselectbit'");
$vwardb->query("DELETE FROM vwar".$n."_template WHERE templatename = 'admin_countryselectbit2'");
$vwardb->query("DELETE FROM vwar".$n."_template WHERE templatename = 'member_profile_nonpublicfields'");
$vwardb->query("DELETE FROM vwar".$n."_template WHERE templatename = 'member_profile_storybit'");
$vwardb->query("DELETE FROM vwar".$n."_template WHERE templatename = 'calendar_list_options'");
$vwardb->query("DELETE FROM vwar".$n."_template WHERE templatename = 'statistics_gamestatbit'");
$vwardb->query("ALTER TABLE vwar".$n."_screen DROP converted");
//"participants-bug in 1.4.0" -> we have to count the participants with invalid warid.
$numdeletedwars = 0;
$result = $vwardb->query("SELECT DISTINCT(warid) FROM vwar".$n."_participants");
while ($row = $vwardb->fetch_array($result))
{
$result2 = $vwardb->query_first("SELECT COUNT(warid) AS numwars FROM vwar".$n." WHERE warid = '".$row["warid"]."'");
$warexists = $result2['numwars'];
if ($warexists != 1)
{
$numdeletedwars++;
}
}
$vwardb->free_result($result);
$vwardb->query("UPDATE vwar".$n."_settings SET deletedwars = deletedwars+$numdeletedwars");
//new field in vwar_locations: locationpic
//we have to fill it with the locationpics that exist so far
$result = $vwardb->query("SELECT locationid, locationname FROM vwar".$n."_locations");
while ($row = $vwardb->fetch_array($result))
{
if(file_exists("" . $vwar_root . "images/locations/" . strtolower($row["locationname"]) . ".jpg"))
{
//file exists, we update the field in table:
$vwardb->query("UPDATE vwar".$n."_locations SET locationpic = '".strtolower($row["locationname"]).".jpg'
WHERE locationid = '".$row["locationid"]."'");
}
}
$vwardb->free_result($result);
## --- Converting Screenshot Format --- ###
$result = $vwardb->query("SELECT * FROM vwar".$n."_screen WHERE filename <> ''");
while ($row = $vwardb->fetch_array($result)) {
$screen_path = $vwar_root . "images/screen/";
$new_filename = $row['warid'] . "-" . $row['locationid'] . "_" . $row['scoreid'] . "." . $row['fileextension'];
$old_filename = $row['filename'] . "." . $row['fileextension'];
$new_thumbname = "th_" . $row['warid'] . "-" . $row['locationid'] . "_" . $row['scoreid'] . "." .$row['fileextension'];
$old_thumbname = $row['filename'] . "_th." . $row['fileextension'];
// rename old screenshot
if (@is_file($screen_path . $old_filename) && @file_exists($screen_path . $old_filename))
{
// rename old thumbnail
@rename($screen_path . $old_filename, $screen_path . $new_filename);
if (@is_file($screen_path . $old_thumbname) && @file_exists($screen_path . $old_thumbname))
{
@rename($screen_path . $old_thumbname, $screen_path . $new_thumbname);
}
$vwardb->query("UPDATE vwar".$n."_screen SET filename = '$new_filename' WHERE screenid = '".$row['screenid']."'");
}
}
$vwardb->query("DELETE FROM vwar".$n."_template WHERE templatename = 'admin_screenbit'");
$vwardb->query("ALTER TABLE vwar".$n."_screen DROP fileextension");
$vwardb->free_result($result);
## --- Converting Profilefields --- ###
$vwardb->query("INSERT INTO vwar".$n."_pfield_cat VALUES ( 'NULL', 'PC Equipment', 'members pc equipment (e.g. cpu type and speed)', '0')");
$catid['equipment'] = $vwardb->insert_id();
$vwardb->query("INSERT INTO vwar".$n."_profilefield VALUES ( 'NULL', 'Ram', 'e.g. 512 Mb', '1', '0', '0', '0', '0', '0', '0', '250', '".$catid['equipment']."')");
$id['pcram'] = $vwardb->insert_id();
$vwardb->query("INSERT INTO vwar".$n."_profilefield VALUES ( 'NULL', 'CPU', 'e.g. 2.7 MHz', '1', '0', '0', '0', '0', '0', '0', '250', '".$catid['equipment']."')");
$id['pccpu'] = $vwardb->insert_id();
$vwardb->query("INSERT INTO vwar".$n."_profilefield VALUES ( 'NULL', 'Monitor', 'e.g. TFT', '1', '0', '0', '0', '0', '0', '0', '250', '".$catid['equipment']."')");
$id['pcmonitor'] = $vwardb->insert_id();
$vwardb->query("INSERT INTO vwar".$n."_profilefield VALUES ( 'NULL', 'Connection', 'e.g. cable', '1', '0', '0', '0', '0', '0', '0', '250', '".$catid['equipment']."')");
$id['pcconnection'] = $vwardb->insert_id();
$vwardb->query("INSERT INTO vwar".$n."_profilefield VALUES ( 'NULL', 'Graphic Card', 'e.g. geforce 4 mx', '1', '0', '0', '0', '0', '0', '0', '250', '".$catid['equipment']."')");
$id['pcgraphiccard'] = $vwardb->insert_id();
$vwardb->query("INSERT INTO vwar".$n."_profilefield VALUES ( 'NULL', 'Mouse', 'e.g. logitech optical', '1', '0', '0', '0', '0', '0', '0', '250', '".$catid['equipment']."')");
$id['pcmouse'] = $vwardb->insert_id();
$vwardb->query("INSERT INTO vwar".$n."_profilefield VALUES ( 'NULL', 'Keyboard', 'e.g. standard 102 key', '1', '0', '0', '0', '0', '0', '0', '250', '".$catid['equipment']."')");
$id['pckeyboard'] = $vwardb->insert_id();
$result = $vwardb->query("SELECT memberid, pcram, pccpu, pcmonitor, pcconnection, pcgraphiccard, pcmouse, pckeyboard FROM vwar".$n."_member ORDER BY memberid ASC");
while ($row = $vwardb->fetch_array($result))
{
if ($row['pcram'] != "")
{
$vwardb->query("INSERT INTO vwar".$n."_memberprofilefield VALUES ( '', '".$row['memberid']."', '".$id['pcram']."', '".$row['pcram']."')");
}
if ($row['pccpu'] != "")
{
$vwardb->query("INSERT INTO vwar".$n."_memberprofilefield VALUES ( '', '".$row['memberid']."', '".$id['pccpu']."', '".$row['pccpu']."')");
}
if ($row['pcmonitor'] != "")
{
$vwardb->query("INSERT INTO vwar".$n."_memberprofilefield VALUES ( '', '".$row['memberid']."', '".$id['pcmonitor']."', '".$row['pcmonitor']."')");
}
if ($row['pcconnection'] != "")
{
$vwardb->query("INSERT INTO vwar".$n."_memberprofilefield VALUES ( '', '".$row['memberid']."', '".$id['pcconnection']."', '".$row['pcconnection']."')");
}
if ($row['pcgraphiccard'] != "")
{
$vwardb->query("INSERT INTO vwar".$n."_memberprofilefield VALUES ( '', '".$row['memberid']."', '".$id['pcgraphiccard']."', '".$row['pcgraphiccard']."')");
}
if ($row['pcmouse'] != "")
{
$vwardb->query("INSERT INTO vwar".$n."_memberprofilefield VALUES ( '', '".$row['memberid']."', '".$id['pcmouse']."', '".$row['pcmouse']."')");
}
if ($row['pckeyboard'] != "")
{
$vwardb->query("INSERT INTO vwar".$n."_memberprofilefield VALUES ( '', '".$row['memberid']."', '".$id['pckeyboard']."', '".$row['pckeyboard']."')");
}
}
$vwardb->query("INSERT INTO vwar".$n."_pfield_cat VALUES ( 'NULL', 'Personal Details', 'personal details (e.g. story about your life)', '0')");
$catid['personal'] = $vwardb->insert_id();
// first set the old existing fields to standard cat
$vwardb->query("UPDATE vwar".$n."_profilefield SET cat_id = '".$catid['personal']."' WHERE cat_id = '0'");
$vwardb->query("INSERT INTO vwar".$n."_profilefield VALUES ( 'NULL', 'Story', 'member story (e.g. i play the game for 2 years now)', '1', '0', '0', '1', '0', '1', '0', '1000', '".$catid['personal']."')");
$id['story'] = $vwardb->insert_id();
$result = $vwardb->query("
SELECT
memberid,
story
FROM vwar".$n."_member
");
while ($row = $vwardb->fetch_array($result))
{
if ($row['story'] != "")
{
$vwardb->query("INSERT INTO vwar".$n."_memberprofilefield VALUES ( '', '".$row['memberid']."', '".$id['story']."', '".$row['story']."')");
}
}
// delete the old fields from the member table ...
$vwardb->query("
ALTER TABLE vwar".$n."_member
DROP pcram ,
DROP pccpu ,
DROP pcmonitor ,
DROP pcconnection ,
DROP pcgraphiccard ,
DROP pcmouse ,
DROP pckeyboard ,
DROP story
");
?>
| Import Data & Cleaning Database |
All data has been successfully inserted into the tables and the database has been successfully updated!
|
query_first("SELECT templateid FROM vwar".$n."_template WHERE templatename = '".$vwartpls[$i*2]."'");
$num = $result["templateid"]; $tplcount++;
if ($num != 0)
{
$vwardb->query("
UPDATE vwar".$n."_template SET template = '".$vwartpls[$i*2+1]."'
WHERE templatename = '".$vwartpls[$i*2]."'");
}
else
{
$vwardb->query("
INSERT INTO vwar".$n."_template
(templatename,template,isspecial,isinactive)
VALUES (
'".$vwartpls[$i*2]."',
'".$vwartpls[$i*2+1]."',
'0',
'0')
");
}
}
$message = "All templates ($tplcount) in "$uploadfile" have been imported successfully.";
$showstep = true;
$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'");
$vwardb->query("UPDATE vwar".$n."_template SET isspecial = '1' WHERE templatename = 'message_mail_newmember'");
$vwardb->query("UPDATE vwar".$n."_template SET isspecial = '1' WHERE templatename = 'message_mail_footer'");
$vwardb->query("UPDATE vwar".$n."_template SET isspecial = '1' WHERE templatename = 'message_mail_submitnews'");
$vwardb->query("UPDATE vwar".$n."_template SET isspecial = '1' WHERE templatename = 'news_sendnews_mailtext'");
}
else
{
$message = ""$uploadfile" file is missing!
Upload file into update directory and click here!";
$showstep = false;
}
?>
| Import Data |
|
createAccessFile($path . ".htpasswd");
printHeader("Update from ".$oldversion." to ".$newversion, 2);
// update the settings
$vwardb->query("UPDATE vwar".$n."_settings SET vwarversion = '$newversion'");
?>
| Finish Update |
The update has been completed succesfully!
Please follow these steps immediately:
- Delete the update folder ( vwar/update1.5.0/ )!
- Change the new settings of "General Settings" in your Admin Control Panel.
- Change your backup password in your profile.
- Change the contact details in "Contact".
The Versionnumber has been updated to .
|