plugin.php

<?php
/*
+---------------------------------------------------------------+
|        e107 website system
+---------------------------------------------------------------+
*/

if (!defined('e107_INIT')) { exit; }

require_once(e_PLUGIN."ebattles/include/main.php");
include(e_PLUGIN."ebattles/include/revision.php");

// Plugin info -------------------------------------------------------------------------------------------------------
$eplug_name = EB_L1;
$eplug_version = "$majorRevision.$minorRevision.$revRevision";
$eplug_author = "Frederic Marchais (qam4)";
$eplug_logo = "";
$eplug_url = "http://www.ebattles.net";
$eplug_email = "frederic.marchais@gmail.com";
$eplug_description = EB_L2;
$eplug_compatible = "e107v0.7+";
$eplug_compliant = TRUE; // indicator if plugin is XHTML compliant, shows icon
$eplug_readme = "";        // leave blank if no readme file

$eb_SQL = new db;
$eb_SQL->db_Select("plugin", "plugin_version", "plugin_path='ebattles' AND plugin_installflag > 0");
list($eb_version_string) = $eb_SQL->db_Fetch();
$eb_version_string = preg_replace("/[a-zA-z\s]/", '', $eb_version_string);
$eb_version = explode('.', $eb_version_string, 3);

// Name of the plugin's folder -------------------------------------------------------------------------------------
$eplug_folder = "ebattles";

// Name of menu item for plugin ----------------------------------------------------------------------------------
$eplug_menu_name = TRUE;

// Name of the admin configuration file --------------------------------------------------------------------------
$eplug_conffile = "admin_config.php";

// Icon image and caption text ------------------------------------------------------------------------------------
$eplug_icon = $eplug_folder."/images/ebattles_32.ico";
$eplug_icon_small = $eplug_folder."/images/ebattles_16.ico";
//$eplug_caption =  EB_L3;

// List of preferences -----------------------------------------------------------------------------------------------
$eplug_prefs = array(
"eb_events_update_delay" => 60,
"eb_events_update_delay_enable" => 0,
"eb_mod_class" => e_UC_ADMIN,
"eb_events_create_class" => e_UC_MEMBER,
"eb_teams_create_class" => e_UC_MEMBER,
"eb_media_submit_class" => e_UC_MEMBER,
"eb_tab_theme" => 'default',
"eb_max_image_size_check" => 1,
"eb_max_image_size" => 16,
"eb_default_items_per_page" => 25,
"eb_max_avatar_size" => 32,
"eb_avatar_enable_playersstandings" => 1,
"eb_avatar_default_image" => 'anonymous.png',
"eb_avatar_enable_teamsstandings" => 1,
"eb_avatar_enable_teamslist" => 1,
"eb_avatar_default_team_image" => 'default_group_avatar.png',
"eb_links_menuheading" => EB_ADMIN_L29,
"eb_activity_menuheading" => EB_ADMIN_L31,
"eb_activity_number_of_items" => 10,
"eb_activity_max_image_size_check" => 1,
"eb_activity_max_image_size" => 16,
"eb_disclaimer" => EB_ADMIN_L37,
"eb_max_number_media" => 3,
"eb_max_map_image_size_check" => 1,
"eb_max_map_image_size" => 80,
"eb_pm_notifications_class" => e_UC_MEMBER,
"eb_email_notifications_class" => e_UC_NOBODY,
"eb_links_showcreateevent" => 1,
"eb_links_showcreateteam" => 1,
"eb_links_showmatchsplayed" => 1,
"eb_links_showmatchstoapprove" => 1,
"eb_links_showmatchspending" => 1,
"eb_links_showmatchesscheduled" => 1,
"eb_links_showchallengesrequested" => 1,
"eb_links_showchallengesunconfirmed" => 1,
"eb_gold_active" => false,
"eb_gold_userclass" => e_UC_ADMIN,
"eb_gold_playmatch" => 0
);

// List of table names -----------------------------------------------------------------------------------------------
$eplug_table_names = array(
TBL_GAMES_SHORT,
TBL_EVENTS_SHORT,
TBL_EVENTMODS_SHORT,
TBL_CLANS_SHORT,
TBL_DIVISIONS_SHORT,
TBL_MEMBERS_SHORT,
TBL_TEAMS_SHORT,
TBL_MATCHS_SHORT,
TBL_PLAYERS_SHORT,
TBL_SCORES_SHORT,
TBL_STATSCATEGORIES_SHORT,
TBL_AWARDS_SHORT,
TBL_PLAYERS_RESULTS_SHORT,
TBL_GAMES_GENRES_SHORT,
TBL_GAMES_PLATFORMS_SHORT,
TBL_MAPS_SHORT,
TBL_FACTIONS_SHORT,
TBL_MEDIA_SHORT,
TBL_CHALLENGES_SHORT,
TBL_GAMERS_SHORT,
TBL_OFFICIAL_EVENTS_SHORT
);

// List of sql requests to create tables -----------------------------------------------------------------------------
$eplug_tables = array(
"CREATE TABLE ".TBL_GAMES."
(
GameID int NOT NULL AUTO_INCREMENT,
PRIMARY KEY(GameID),
Name varchar(63),
ShortName varchar(63),
Icon varchar(255),
Style varchar(63) NOT NULL default '',
Genre varchar(63) NOT NULL default '',
MatchTypes varchar(255) NOT NULL default '',
Description text NOT NULL default '',
Developer varchar(63) NOT NULL default '',
Publisher varchar(63) NOT NULL default '',
ReleaseDate varchar(63) NOT NULL default '',
OfficialWebsite varchar(63) NOT NULL default '',
ESRB varchar(63) NOT NULL default '',
Banner varchar(63) NOT NULL default ''
) ENGINE = MyISAM;",
"CREATE TABLE ".TBL_EVENTS."
(
EventID int NOT NULL AUTO_INCREMENT,
PRIMARY KEY(EventID),
Name varchar(63),
password varchar(32),
Game int NOT NULL,
INDEX (Game),
FOREIGN KEY (Game) REFERENCES ".TBL_GAMES." (GameID),
Type varchar(63),
Format varchar(63),
MatchType varchar(63) DEFAULT '',
StartDateTime int(11) unsigned not null,
EndDateTime int(11) unsigned not null,
nbr_games_to_rank int DEFAULT '4',
nbr_team_games_to_rank int DEFAULT '4',
ELO_default int DEFAULT '".ELO_DEFAULT."',
ELO_K int DEFAULT '".ELO_K."',
ELO_M int DEFAULT '".ELO_M."',
TS_default_mu float DEFAULT '".floatToSQL(TS_Mu0)."',
TS_default_sigma float DEFAULT '".floatToSQL(TS_sigma0)."',
TS_beta float DEFAULT '".floatToSQL(TS_beta)."',
TS_epsilon float DEFAULT '".floatToSQL(TS_epsilon)."',
TS_tau float DEFAULT '".floatToSQL(TS_tau)."',
G2_default_r float DEFAULT '".floatToSQL(G2_r0)."',
G2_default_RD float DEFAULT '".floatToSQL(G2_RD0)."',
G2_default_sigma float DEFAULT '".floatToSQL(G2_sigma0)."',
G2_tau float DEFAULT '".floatToSQL(G2_tau)."',
G2_epsilon float DEFAULT '".floatToSQL(G2_epsilon)."',
rating_period float DEFAULT '".eb_rating_period."',
next_rating_timestamp int(11) unsigned not null,
Owner int(10) unsigned NOT NULL,
INDEX (Owner),
FOREIGN KEY (Owner) REFERENCES ".TBL_USERS." (user_id),
Rules text NOT NULL,
Description text NOT NULL,
NextUpdate_timestamp int(11) unsigned not null,
IsChanged tinyint(1) DEFAULT '1',
AllowDraw tinyint(1) DEFAULT '0',
AllowForfeit tinyint(1) DEFAULT '0',
ForfeitWinLossUpdate tinyint(1) DEFAULT '0',
ForfeitWinPoints int default '".PointsPerWin_DEFAULT."',
ForfeitLossPoints int default '".PointsPerLoss_DEFAULT."',
AllowScore tinyint(1) DEFAULT '0',
PointsPerWin int default '".PointsPerWin_DEFAULT."',
PointsPerDraw int default '".PointsPerDraw_DEFAULT."',
PointsPerLoss int default '".PointsPerLoss_DEFAULT."',
match_report_userclass tinyint(3) unsigned NOT NULL DEFAULT '".eb_UC_EVENT_PLAYER."',
match_replay_report_userclass tinyint(3) unsigned NOT NULL DEFAULT '".eb_UC_EVENT_PLAYER."',
quick_loss_report tinyint(1) DEFAULT '1',
hide_ratings_column tinyint(1) DEFAULT '0',
MatchesApproval tinyint(3) unsigned NOT NULL DEFAULT '".eb_UC_NONE."',
RankingType varchar(20) DEFAULT 'Classic',
Visibility tinyint(3) unsigned NOT NULL DEFAULT '".eb_UC_NONE."',
Status varchar(20) DEFAULT 'draft',
PlayersApproval tinyint(3) unsigned NOT NULL DEFAULT '".eb_UC_NONE."',
ChallengesEnable tinyint(1) DEFAULT '0',
MaxDatesPerChallenge int DEFAULT '".eb_MAX_CHALLENGE_DATES."',
MaxMapsPerMatch int DEFAULT '".eb_MAX_MAPS_PER_MATCH."',
MaxNumberPlayers int DEFAULT '0',
ForceFaction tinyint(1) default '0',
Seeded tinyint(3) default '0',
Seeds text,
Results text,
Rounds text,
MapPool text,
MatchupsFile text,
FixturesEnable tinyint(1) DEFAULT '0',
CheckinDuration int default '0',
HideFixtures int default '0',
GoldEntryFee int default '0',
GoldWinningEvent int default '0',
SignupsEnable tinyint(1) DEFAULT '1',
AllowLateSignups tinyint(1) DEFAULT '1'
) ENGINE = MyISAM;",
"CREATE TABLE ".TBL_EVENTMODS."
(
ModeratorID int NOT NULL AUTO_INCREMENT,
PRIMARY KEY(ModeratorID),
Event int NOT NULL,
INDEX (Event),
FOREIGN KEY (Event) REFERENCES ".TBL_EVENTS." (EventID),
User int(10) unsigned NOT NULL,
INDEX (User),
FOREIGN KEY (User) REFERENCES ".TBL_USERS." (user_id),
Level int DEFAULT '0'
) ENGINE = MyISAM;",
"CREATE TABLE ".TBL_CLANS."
(
ClanID int NOT NULL AUTO_INCREMENT,
PRIMARY KEY(ClanID),
Name varchar(30),
Tag varchar(30),
Owner int(10) unsigned NOT NULL,
INDEX (Owner),
FOREIGN KEY (Owner) REFERENCES ".TBL_USERS." (user_id),
password varchar(32),
Image varchar(255) NOT NULL default '',
websiteURL varchar(100) NOT NULL default '',
email varchar(100) NOT NULL default '',
IM varchar(100) NOT NULL default '',
Description text NOT NULL
) ENGINE = MyISAM;",
"CREATE TABLE ".TBL_DIVISIONS."
(
DivisionID int NOT NULL AUTO_INCREMENT,
PRIMARY KEY(DivisionID),
Clan int NOT NULL,
INDEX (Clan),
FOREIGN KEY (Clan) REFERENCES ".TBL_CLANS." (ClanID),
Game int NOT NULL,
INDEX (Game),
FOREIGN KEY (Game) REFERENCES ".TBL_GAMES." (GameID),
Captain int(10) unsigned NOT NULL,
INDEX (Captain),
FOREIGN KEY (Captain) REFERENCES ".TBL_USERS." (user_id)
) ENGINE = MyISAM;",
"CREATE TABLE ".TBL_MEMBERS."
(
MemberID int NOT NULL AUTO_INCREMENT,
PRIMARY KEY(MemberID),
Division int NOT NULL,
INDEX (Division),
FOREIGN KEY (Division) REFERENCES ".TBL_DIVISIONS." (DivisionID),
User int(10) unsigned NOT NULL,
INDEX (User),
FOREIGN KEY (User) REFERENCES ".TBL_USERS." (user_id),
timestamp int(11) unsigned not null
) ENGINE = MyISAM;",
"CREATE TABLE ".TBL_TEAMS."
(
TeamID int NOT NULL AUTO_INCREMENT,
PRIMARY KEY(TeamID),
Event int NOT NULL,
INDEX (Event),
FOREIGN KEY (Event) REFERENCES ".TBL_EVENTS." (EventID),
Division int NOT NULL,
INDEX (Division),
FOREIGN KEY (Division) REFERENCES ".TBL_DIVISIONS." (DivisionID),
Rank int DEFAULT '0',
RankDelta int DEFAULT '0',
OverallScore float DEFAULT '0',
ELORanking int DEFAULT '".ELO_DEFAULT."',
TS_mu float DEFAULT '".floatToSQL(TS_Mu0)."',
TS_sigma float DEFAULT '".floatToSQL(TS_sigma0)."',
G2_r float DEFAULT '".floatToSQL(G2_r0)."',
G2_RD float DEFAULT '".floatToSQL(G2_RD0)."',
G2_sigma float DEFAULT '".floatToSQL(G2_sigma0)."',
GamesPlayed int DEFAULT '0',
Win int DEFAULT '0',
Draw int DEFAULT '0',
Loss int DEFAULT '0',
Streak int DEFAULT '0',
Streak_Best int DEFAULT '0',
Streak_Worst int DEFAULT '0',
Score int DEFAULT '0',
ScoreAgainst int DEFAULT '0',
Points int DEFAULT '0',
Forfeits int DEFAULT '0',
Joined  int(11) unsigned not null,
CheckedIn tinyint(1) DEFAULT '0',
Banned tinyint(1) DEFAULT '0',
Seed int NOT NULL
) ENGINE = MyISAM;",
"CREATE TABLE ".TBL_MATCHS."
(
MatchID int NOT NULL AUTO_INCREMENT,
PRIMARY KEY(MatchID),
Event int NOT NULL,
INDEX (Event),
FOREIGN KEY (Event) REFERENCES ".TBL_EVENTS." (EventID),
ReportedBy int(10) unsigned NOT NULL,
INDEX (ReportedBy),
FOREIGN KEY (ReportedBy) REFERENCES ".TBL_USERS." (user_id),
TimeReported int(11) unsigned not null,
Comments text NOT NULL,
Status varchar(20) DEFAULT 'active',
Maps varchar(255) NOT NULL default '0',
TimeScheduled int(11) unsigned not null,
GameLength int(11) unsigned not null,
GameSpeed varchar(20),
Realm varchar(20),
TimePlayed int(11) unsigned not null
) ENGINE = MyISAM;",
"CREATE TABLE ".TBL_PLAYERS."
(
PlayerID int NOT NULL AUTO_INCREMENT,
PRIMARY KEY(PlayerID),
Event int NOT NULL,
INDEX (Event),
FOREIGN KEY (Event) REFERENCES ".TBL_EVENTS." (EventID),
Gamer int(10) unsigned NOT NULL,
INDEX (Gamer),
FOREIGN KEY (Gamer) REFERENCES ".TBL_GAMERS." (GamerID),
Team int NOT NULL,
INDEX (Team),
FOREIGN KEY (Team) REFERENCES ".TBL_TEAMS." (TeamID),
Rank int DEFAULT '0',
RankDelta int DEFAULT '0',
OverallScore float DEFAULT '0',
ELORanking int DEFAULT '".ELO_DEFAULT."',
TS_mu float DEFAULT '".floatToSQL(TS_Mu0)."',
TS_sigma float DEFAULT '".floatToSQL(TS_sigma0)."',
G2_r float DEFAULT '".floatToSQL(G2_r0)."',
G2_RD float DEFAULT '".floatToSQL(G2_RD0)."',
G2_sigma float DEFAULT '".floatToSQL(G2_sigma0)."',
GamesPlayed int DEFAULT '0',
Win int DEFAULT '0',
Draw int DEFAULT '0',
Loss int DEFAULT '0',
Streak int DEFAULT '0',
Streak_Best int DEFAULT '0',
Streak_Worst int DEFAULT '0',
Score int DEFAULT '0',
ScoreAgainst int DEFAULT '0',
Points int DEFAULT '0',
Forfeits int DEFAULT '0',
Joined  int(11) unsigned not null,
CheckedIn tinyint(1) DEFAULT '0',
Banned tinyint(1) DEFAULT '0',
Seed int NOT NULL
) ENGINE = MyISAM;",
"CREATE TABLE ".TBL_SCORES."
(
ScoreID int NOT NULL AUTO_INCREMENT,
PRIMARY KEY(ScoreID),
MatchID int NOT NULL,
INDEX (MatchID),
FOREIGN KEY (MatchID) REFERENCES ".TBL_MATCHS." (MatchID),
Player int NOT NULL,
INDEX (Player),
FOREIGN KEY (Player) REFERENCES ".TBL_PLAYERS." (PlayerID),
Team int NOT NULL,
INDEX (Team),
FOREIGN KEY (Team) REFERENCES ".TBL_TEAMS." (TeamID),
Player_MatchTeam int DEFAULT '0',
Player_deltaELO int DEFAULT '0',
Player_deltaTS_mu float DEFAULT '0',
Player_deltaTS_sigma float DEFAULT '0',
Player_deltaG2_mu float DEFAULT '0',
Player_deltaG2_phi float DEFAULT '0',
Player_deltaG2_sigma float DEFAULT '0',
Player_Score int DEFAULT '0',
Player_ScoreAgainst int DEFAULT '0',
Player_Rank int DEFAULT '0',
Player_Win int DEFAULT '0',
Player_Loss int DEFAULT '0',
Player_Draw int DEFAULT '0',
Player_Points int DEFAULT '0',
Player_Forfeit tinyint(1) DEFAULT '0',
Faction int DEFAULT '0',
Color varchar(20),
sColor varchar(20),
APM int DEFAULT '0'
) ENGINE = MyISAM;",
"CREATE TABLE ".TBL_STATSCATEGORIES."
(
StatsCategoryID int NOT NULL AUTO_INCREMENT,
PRIMARY KEY(StatsCategoryID),
Event int NOT NULL,
INDEX (Event),
FOREIGN KEY (Event) REFERENCES ".TBL_EVENTS." (EventID),
CategoryName varchar(63),
CategoryMinValue int DEFAULT '1',
CategoryMaxValue int DEFAULT '0',
InfoOnly tinyint(1) DEFAULT '0'
) ENGINE = MyISAM;",
"CREATE TABLE ".TBL_AWARDS."
(
AwardID int NOT NULL AUTO_INCREMENT,
PRIMARY KEY(AwardID),
Player int NOT NULL,
INDEX (Player),
FOREIGN KEY (Player) REFERENCES ".TBL_PLAYERS." (PlayerID),
Team int DEFAULT '0',
INDEX (Team),
FOREIGN KEY (Player) REFERENCES ".TBL_TEAMS." (TeamID),
Type varchar(63),
timestamp int(11) unsigned not null
) ENGINE = MyISAM;",
"CREATE TABLE ".TBL_PLAYERS_RESULTS."
(
PlayerResultID int NOT NULL AUTO_INCREMENT,
PRIMARY KEY(PlayerResultID),
Player int NOT NULL,
INDEX (Player),
FOREIGN KEY (Player) REFERENCES ".TBL_PLAYERS." (PlayerID),
Type varchar(63),
Value float DEFAULT '0',
Display varchar(63),
timestamp int(11) unsigned not null
) ENGINE = MyISAM;",
"CREATE TABLE ".TBL_GAMES_GENRES."
(
GameGenreID int NOT NULL AUTO_INCREMENT,
PRIMARY KEY(GameGenreID),
Game int NOT NULL,
INDEX (Game),
FOREIGN KEY (Game) REFERENCES ".TBL_GAMES." (GameID),
Genre varchar(63)
) ENGINE = MyISAM;",
"CREATE TABLE ".TBL_GAMES_PLATFORMS."
(
GamePlatformID int NOT NULL AUTO_INCREMENT,
PRIMARY KEY(GamePlatformID),
Game int NOT NULL,
INDEX (Game),
FOREIGN KEY (Game) REFERENCES ".TBL_GAMES." (GameID),
Platform varchar(63)
) ENGINE = MyISAM;",
"CREATE TABLE ".TBL_MAPS."
(
MapID int NOT NULL AUTO_INCREMENT,
PRIMARY KEY(MapID),
Game int NOT NULL,
INDEX (Game),
FOREIGN KEY (Game) REFERENCES ".TBL_GAMES." (GameID),
Name varchar(63) NOT NULL default '',
Image varchar(255) NOT NULL default '',
Description varchar(63) NOT NULL default ''
) ENGINE = MyISAM;",
"CREATE TABLE ".TBL_FACTIONS."
(
FactionID int NOT NULL AUTO_INCREMENT,
PRIMARY KEY(FactionID),
Game int NOT NULL,
INDEX (Game),
FOREIGN KEY (Game) REFERENCES ".TBL_GAMES." (GameID),
Name varchar(63) NOT NULL default '',
Icon varchar(255) NOT NULL default ''
) ENGINE = MyISAM;",
"CREATE TABLE ".TBL_MEDIA."
(
MediaID int NOT NULL AUTO_INCREMENT,
PRIMARY KEY(MediaID),
MatchID int NOT NULL,
INDEX (MatchID),
FOREIGN KEY (MatchID) REFERENCES ".TBL_MATCHS." (MatchID),
Submitter int NOT NULL,
INDEX (Submitter),
FOREIGN KEY (Submitter) REFERENCES ".TBL_USERS." (user_id),
Path varchar(255) NOT NULL default '',
Type varchar(20) NOT NULL default ''
) ENGINE = MyISAM;",
"CREATE TABLE ".TBL_CHALLENGES."
(
ChallengeID int NOT NULL AUTO_INCREMENT,
PRIMARY KEY(ChallengeID),
Event int NOT NULL,
INDEX (Event),
FOREIGN KEY (Event) REFERENCES ".TBL_EVENTS." (EventID),
ChallengerPlayer int NOT NULL,
INDEX (ChallengerPlayer),
FOREIGN KEY (ChallengerPlayer) REFERENCES ".TBL_PLAYERS." (PlayerID),
ChallengerTeam int NOT NULL,
INDEX (ChallengerTeam),
FOREIGN KEY (ChallengerTeam) REFERENCES ".TBL_TEAMS." (TeamID),
ChallengedPlayer int NOT NULL,
INDEX (ChallengedPlayer),
FOREIGN KEY (ChallengedPlayer) REFERENCES ".TBL_PLAYERS." (PlayerID),
ChallengedTeam int NOT NULL,
INDEX (ChallengedTeam),
FOREIGN KEY (ChallengedTeam) REFERENCES ".TBL_TEAMS." (TeamID),
ReportedBy int(10) unsigned NOT NULL,
INDEX (ReportedBy),
FOREIGN KEY (ReportedBy) REFERENCES ".TBL_USERS." (user_id),
TimeReported int(11) unsigned not null,
Comments text NOT NULL,
Status varchar(20) DEFAULT 'requested',
MatchDates varchar(255) NOT NULL default ''
) ENGINE = MyISAM;",
"CREATE TABLE ".TBL_GAMERS."
(
GamerID int NOT NULL AUTO_INCREMENT,
PRIMARY KEY(GamerID),
User int(10) unsigned NOT NULL,
INDEX (User),
FOREIGN KEY (User) REFERENCES ".TBL_USERS." (user_id),
Game int NOT NULL,
INDEX (Game),
FOREIGN KEY (Game) REFERENCES ".TBL_GAMES." (GameID),
Name varchar(64) NOT NULL default '',
UniqueGameID varchar(64) NOT NULL default ''
) ENGINE = MyISAM;",
"CREATE TABLE ".TBL_OFFICIAL_EVENTS."
(
OfficialEventID int NOT NULL AUTO_INCREMENT,
PRIMARY KEY(OfficialEventID),
Event int NOT NULL,
INDEX (Event),
FOREIGN KEY (Event) REFERENCES ".TBL_EVENTS." (EventID),
Game int NOT NULL,
INDEX (Game),
FOREIGN KEY (Game) REFERENCES ".TBL_GAMES." (GameID),
Type varchar(63),
MatchType varchar(63) DEFAULT ''
) ENGINE = MyISAM;"
);

// Insert "data"
// Insert "Unknown Game"
$query =
"INSERT INTO ".TBL_GAMES."(Name, Icon)
VALUES ('".EB_GAME_L1."', 'unknown.gif')";
array_push($eplug_tables, $query);

// Create a link in main menu (yes=TRUE, no=FALSE) -------------------------------------------------------------
$eplug_link = TRUE;
$eplug_link_name = EB_L5;
$eplug_link_url = e_PLUGIN."ebattles/userinfo.php?user={USERID}";


// Text to display after plugin successfully installed ------------------------------------------------------------------
$eplug_done = EB_L4;

// upgrading ... //
$upgrade_add_prefs = array();
$upgrade_remove_prefs = array();
$upgrade_alter_tables = array();

$majVersion = $eb_version[0];
$minVersion = $eb_version[1];
$revision = $eb_version[2];

if (versionsCompare($eb_version_string, "0.8") < 0)
{
	// To revision 0.8
	array_push ($upgrade_alter_tables,
	"ALTER TABLE ".TBL_EVENTS." ADD Visibility tinyint(3) unsigned NOT NULL DEFAULT '".eb_UC_NONE."'",
	"ALTER TABLE ".TBL_EVENTS." ADD Status varchar(20) DEFAULT 'active'",
	"ALTER TABLE ".TBL_EVENTS." ADD PlayersApproval tinyint(3) unsigned NOT NULL DEFAULT '".eb_UC_NONE."'",
	"ALTER TABLE ".TBL_MATCHS." ADD Map int DEFAULT '0'",
	"ALTER TABLE ".TBL_SCORES." ADD Faction int DEFAULT '0'",
	"ALTER TABLE ".TBL_GAMES." ADD ShortName varchar(63) ",
	"CREATE TABLE ".TBL_MAPS."
	(
	MapID int NOT NULL AUTO_INCREMENT,
	PRIMARY KEY(MapID),
	Game int NOT NULL,
	INDEX (Game),
	FOREIGN KEY (Game) REFERENCES ".TBL_GAMES." (GameID),
	Name varchar(63) NOT NULL default '',
	Image varchar(63) NOT NULL default '',
	Description varchar(63) NOT NULL default ''
	) TYPE = MyISAM;",
	"CREATE TABLE ".TBL_FACTIONS."
	(
	FactionID int NOT NULL AUTO_INCREMENT,
	PRIMARY KEY(FactionID),
	Game int NOT NULL,
	INDEX (Game),
	FOREIGN KEY (Game) REFERENCES ".TBL_GAMES." (GameID),
	Name varchar(63) NOT NULL default '',
	Icon varchar(63) NOT NULL default ''
	) TYPE = MyISAM;",
	"CREATE TABLE ".TBL_MEDIA."
	(
	MediaID int NOT NULL AUTO_INCREMENT,
	PRIMARY KEY(MediaID),
	MatchID int NOT NULL,
	INDEX (MatchID),
	FOREIGN KEY (MatchID) REFERENCES ".TBL_MATCHS." (MatchID),
	Submitter int NOT NULL,
	INDEX (Submitter),
	FOREIGN KEY (Submitter) REFERENCES ".TBL_USERS." (user_id),
	Path varchar(63) NOT NULL default '',
	Type varchar(20) NOT NULL default ''
	) TYPE = MyISAM;"
	);

	array_push_associative ($upgrade_add_prefs, array(
	"eb_max_number_media" => 3,
	"eb_max_map_image_size_check" => 1,
	"eb_max_map_image_size" => 80,
	"eb_media_submit_class" => e_UC_MEMBER
	));
}

if (versionsCompare($eb_version_string, "0.8.4") < 0)
{
	// To revision 0.8.4
	array_push ($upgrade_alter_tables,
	"ALTER TABLE ".TBL_EVENTS." ADD ChallengesEnable tinyint(1) DEFAULT '0'",
	"ALTER TABLE ".TBL_MATCHS." ADD TimeScheduled int(11) unsigned not null",
	"CREATE TABLE ".TBL_CHALLENGES."
	(
	ChallengeID int NOT NULL AUTO_INCREMENT,
	PRIMARY KEY(ChallengeID),
	Event int NOT NULL,
	INDEX (Event),
	FOREIGN KEY (Event) REFERENCES ".TBL_EVENTS." (EventID),
	ChallengerPlayer int NOT NULL,
	INDEX (ChallengerPlayer),
	FOREIGN KEY (ChallengerPlayer) REFERENCES ".TBL_PLAYERS." (PlayerID),
	ChallengerTeam int NOT NULL,
	INDEX (ChallengerTeam),
	FOREIGN KEY (ChallengerTeam) REFERENCES ".TBL_TEAMS." (TeamID),
	ChallengedPlayer int NOT NULL,
	INDEX (ChallengedPlayer),
	FOREIGN KEY (ChallengedPlayer) REFERENCES ".TBL_PLAYERS." (PlayerID),
	ChallengedTeam int NOT NULL,
	INDEX (ChallengedTeam),
	FOREIGN KEY (ChallengedTeam) REFERENCES ".TBL_TEAMS." (TeamID),
	ReportedBy int(10) unsigned NOT NULL,
	INDEX (ReportedBy),
	FOREIGN KEY (ReportedBy) REFERENCES ".TBL_USERS." (user_id),
	TimeReported int(11) unsigned not null,
	Comments text NOT NULL,
	Status varchar(20) DEFAULT 'requested',
	MatchDates varchar(255) NOT NULL default ''
	) TYPE = MyISAM;"
	);
}

if (versionsCompare($eb_version_string, "0.8.5") < 0)
{
	// To revision 0.8.5
	array_push ($upgrade_alter_tables,
	"ALTER TABLE ".TBL_MATCHS." CHANGE Map Maps varchar(255) NOT NULL default '0'",
	"ALTER TABLE ".TBL_EVENTS." ADD MaxDatesPerChallenge int DEFAULT '".eb_MAX_CHALLENGE_DATES."'",
	"ALTER TABLE ".TBL_EVENTS." ADD MaxMapsPerMatch int DEFAULT '".eb_MAX_MAPS_PER_MATCH."'",
	"ALTER TABLE ".TBL_CLANS." ADD websiteURL varchar(100) NOT NULL default ''",
	"ALTER TABLE ".TBL_CLANS." ADD email varchar(100) NOT NULL default ''",
	"ALTER TABLE ".TBL_CLANS." ADD IM varchar(100) NOT NULL default ''",
	"ALTER TABLE ".TBL_CLANS." ADD Description text NOT NULL"
	);
}

if (versionsCompare($eb_version_string, "0.8.9") < 0)
{
	// To revision 0.8.9
	array_push_associative ($upgrade_add_prefs, array(
	"eb_pm_notifications_class" => e_UC_MEMBER,
	"eb_email_notifications_class" => e_UC_MEMBER
	));
}

if (versionsCompare($eb_version_string, "0.8.10") < 0)
{
	// To revision 0.8.10
	array_push_associative ($upgrade_add_prefs, array(
	"eb_links_showcreateevent" => 1,
	"eb_links_showcreateteam" => 1,
	"eb_links_showmatchsplayed" => 1,
	"eb_links_showmatchstoapprove" => 1,
	"eb_links_showmatchspending" => 1,
	"eb_links_showmatchesscheduled" => 1,
	"eb_links_showchallengesrequested" => 1,
	"eb_links_showchallengesunconfirmed" => 1
	));
}

if (versionsCompare($eb_version_string, "0.8.11") < 0)
{
	// To revision 0.8.11
	array_push ($upgrade_alter_tables,
	"ALTER TABLE ".TBL_AWARDS." ADD Team int NOT NULL",
	"ALTER TABLE ".TBL_AWARDS." ADD INDEX (Team)",
	"ALTER TABLE ".TBL_AWARDS." ADD FOREIGN KEY (Team) REFERENCES ".TBL_TEAMS." (TeamID)"
	);
}

if (versionsCompare($eb_version_string, "0.8.12") < 0)
{
	// To revision 0.8.12
	array_push ($upgrade_alter_tables,
	"ALTER TABLE ".TBL_EVENTS." ADD MaxPlayers int DEFAULT '0'"
	);
}

if (versionsCompare($eb_version_string, "0.8.13") < 0)
{
	// To revision 0.8.13
	array_push ($upgrade_alter_tables,
	"ALTER TABLE ".TBL_GAMES." ADD MatchTypes varchar(255) NOT NULL default ''",
	"ALTER TABLE ".TBL_EVENTS." ADD MatchType varchar(63) DEFAULT ''",
	"ALTER TABLE ".TBL_EVENTS." ADD AllowForfeit tinyint(1) DEFAULT '0'",
	"ALTER TABLE ".TBL_EVENTS." ADD ForfeitWinLossUpdate tinyint(1) DEFAULT '0'",
	"ALTER TABLE ".TBL_EVENTS." ADD ForfeitWinPoints int default '".PointsPerWin_DEFAULT."'",
	"ALTER TABLE ".TBL_EVENTS." ADD ForfeitLossPoints int default '".PointsPerLoss_DEFAULT."'",
	"ALTER TABLE ".TBL_SCORES." ADD Player_Forfeit tinyint(1) DEFAULT '0'"
	);
}

if (versionsCompare($eb_version_string, "0.9.0") < 0)
{
	// To revision 0.9.0
	array_push ($upgrade_alter_tables,
	"ALTER TABLE ".TBL_EVENTS." ADD Format varchar(63) DEFAULT ''",
	"ALTER TABLE ".TBL_EVENTS." CHANGE Start_timestamp StartDateTime int(11) unsigned not null",
	"ALTER TABLE ".TBL_EVENTS." CHANGE End_timestamp EndDateTime int(11) unsigned not null",
	"ALTER TABLE ".TBL_EVENTS." ADD match_replay_report_userclass tinyint(3) unsigned NOT NULL DEFAULT '".eb_UC_EVENT_PLAYER."'",
	"ALTER TABLE ".TBL_EVENTS." MODIFY RankingType varchar(20) DEFAULT 'Classic'",
	"ALTER TABLE ".TBL_EVENTS." MODIFY Status varchar(20) DEFAULT 'draft'",
	"ALTER TABLE ".TBL_EVENTS." CHANGE MaxPlayers MaxNumberPlayers int DEFAULT '0'",
	"ALTER TABLE ".TBL_EVENTS." ADD ForceFaction tinyint(1) default '0'",
	"ALTER TABLE ".TBL_EVENTS." ADD Seeded tinyint(3) default '0'",
	"ALTER TABLE ".TBL_EVENTS." ADD Seeds text",
	"ALTER TABLE ".TBL_EVENTS." ADD Results text",
	"ALTER TABLE ".TBL_EVENTS." ADD Rounds text",
	"ALTER TABLE ".TBL_EVENTS." ADD MapPool text",
	"ALTER TABLE ".TBL_TEAMS." ADD Joined  int(11) unsigned not null",
	"ALTER TABLE ".TBL_TEAMS." ADD CheckedIn tinyint(1) DEFAULT '0'",
	"ALTER TABLE ".TBL_MATCHS." ADD GameLength int(11) unsigned not null",
	"ALTER TABLE ".TBL_MATCHS." ADD GameSpeed varchar(20)",
	"ALTER TABLE ".TBL_MATCHS." ADD Realm varchar(20)",
	"ALTER TABLE ".TBL_MATCHS." ADD TimePlayed int(11) unsigned not null",
	"ALTER TABLE ".TBL_PLAYERS." ADD Joined  int(11) unsigned not null",
	"ALTER TABLE ".TBL_PLAYERS." ADD CheckedIn tinyint(1) DEFAULT '0'",
	"ALTER TABLE ".TBL_PLAYERS." DROP COLUMN User",
	"ALTER TABLE ".TBL_SCORES." ADD Color varchar(20)",
	"ALTER TABLE ".TBL_SCORES." ADD sColor varchar(20)",
	"ALTER TABLE ".TBL_SCORES." ADD APM int DEFAULT '0'",
	"ALTER TABLE ".TBL_STATSCATEGORIES." MODIFY CategoryMaxValue int DEFAULT '0'",
	"ALTER TABLE ".TBL_MEDIA." MODIFY Path varchar(255) NOT NULL default ''",
	"CREATE TABLE ".TBL_OFFICIAL_EVENTS."
	(
	OfficialEventID int NOT NULL AUTO_INCREMENT,
	PRIMARY KEY(OfficialEventID),
	Event int NOT NULL,
	INDEX (Event),
	FOREIGN KEY (Event) REFERENCES ".TBL_EVENTS." (EventID),
	Game int NOT NULL,
	INDEX (Game),
	FOREIGN KEY (Game) REFERENCES ".TBL_GAMES." (GameID),
	Type varchar(63),
	MatchType varchar(63) DEFAULT ''
	) ENGINE = MyISAM;"


	);
}

if (versionsCompare($eb_version_string, "0.9.2") < 0)
{
	// To revision 0.9.2
	array_push ($upgrade_alter_tables,
	"ALTER TABLE ".TBL_PLAYERS." ADD Seed int NOT NULL",
	"ALTER TABLE ".TBL_TEAMS." ADD Seed int NOT NULL",
	"ALTER TABLE ".TBL_GAMES." MODIFY Icon varchar(255) NOT NULL default ''",
	"ALTER TABLE ".TBL_CLANS." MODIFY Image varchar(255) NOT NULL default ''",
	"ALTER TABLE ".TBL_MAPS." MODIFY Image varchar(255) NOT NULL default ''",
	"ALTER TABLE ".TBL_FACTIONS." MODIFY Icon varchar(255) NOT NULL default ''"
	);
}

if (versionsCompare($eb_version_string, "0.9.4") < 0)
{
	// To revision 0.9.4
	array_push ($upgrade_alter_tables,
	"ALTER TABLE ".TBL_EVENTS." ADD MatchupsFile text"
	);
}

if (versionsCompare($eb_version_string, "0.9.6") < 0)
{
	// To revision 0.9.6
	array_push ($upgrade_alter_tables,
	"ALTER TABLE ".TBL_EVENTS." ADD FixturesEnable tinyint(1) DEFAULT '0'",
	"ALTER TABLE ".TBL_EVENTS." ADD CheckinDuration int default '0'"
	);
}

if (versionsCompare($eb_version_string, "0.9.7") < 0)
{
	// To revision 0.9.7
	array_push ($upgrade_alter_tables,
	"ALTER TABLE ".TBL_EVENTS." ADD HideFixtures int default '0'"
	);
}

if (versionsCompare($eb_version_string, "0.9.8") < 0)
{
	// To revision 0.9.8
	array_push ($upgrade_alter_tables,
	"ALTER TABLE ".TBL_EVENTS." ADD GoldEntryFee int default '0'",
	"ALTER TABLE ".TBL_EVENTS." ADD GoldWinningEvent int default '0'"
	);
	array_push_associative ($upgrade_add_prefs, array(
	"eb_gold_active" => false,
	"eb_gold_userclass" => e_UC_ADMIN,
	"eb_gold_playmatch" => 0
	));
}

if (versionsCompare($eb_version_string, "0.9.9") < 0)
{
	// To revision 0.9.9
	array_push ($upgrade_alter_tables,
	"ALTER TABLE ".TBL_EVENTS." ADD SignupsEnable tinyint(1) DEFAULT '1'",
	"ALTER TABLE ".TBL_EVENTS." ADD AllowLateSignups tinyint(1) DEFAULT '1'"
	);
}

if (versionsCompare($eb_version_string, "0.9.13") < 0)
{
	// To revision 0.9.13
	array_push ($upgrade_alter_tables,
	"ALTER TABLE ".TBL_EVENTS." ADD TS_tau float DEFAULT '".floatToSQL(TS_tau)."'",
	"ALTER TABLE ".TBL_EVENTS." ADD G2_default_r float DEFAULT '".floatToSQL(G2_r0)."'",
	"ALTER TABLE ".TBL_EVENTS." ADD G2_default_RD float DEFAULT '".floatToSQL(G2_RD0)."'",
	"ALTER TABLE ".TBL_EVENTS." ADD G2_default_sigma float DEFAULT '".floatToSQL(G2_sigma0)."'",
	"ALTER TABLE ".TBL_EVENTS." ADD G2_tau float DEFAULT '".floatToSQL(G2_tau)."'",
	"ALTER TABLE ".TBL_EVENTS." ADD G2_epsilon float DEFAULT '".floatToSQL(G2_epsilon)."'",
	"ALTER TABLE ".TBL_EVENTS." ADD rating_period float DEFAULT '".floatToSQL(eb_rating_period)."'",
	"ALTER TABLE ".TBL_EVENTS." ADD next_rating_timestamp int(11) unsigned not null",
	"ALTER TABLE ".TBL_PLAYERS." ADD G2_r float DEFAULT '".floatToSQL(G2_r0)."'",
	"ALTER TABLE ".TBL_PLAYERS." ADD G2_RD float DEFAULT '".floatToSQL(G2_RD0)."'",
	"ALTER TABLE ".TBL_PLAYERS." ADD G2_sigma float DEFAULT '".floatToSQL(G2_sigma0)."'",
	"ALTER TABLE ".TBL_TEAMS." ADD G2_r float DEFAULT '".floatToSQL(G2_r0)."'",
	"ALTER TABLE ".TBL_TEAMS." ADD G2_RD float DEFAULT '".floatToSQL(G2_RD0)."'",
	"ALTER TABLE ".TBL_TEAMS." ADD G2_sigma float DEFAULT '".floatToSQL(G2_sigma0)."'",
	"ALTER TABLE ".TBL_SCORES." ADD Player_deltaG2_mu float DEFAULT '0'",
	"ALTER TABLE ".TBL_SCORES." ADD Player_deltaG2_phi float DEFAULT '0'",
	"ALTER TABLE ".TBL_SCORES." ADD Player_deltaG2_sigma float DEFAULT '0'"
	);
}

if (versionsCompare($eb_version_string, "0.9.14") < 0)
{
	// To revision 0.9.14
	array_push ($upgrade_alter_tables,
	"ALTER TABLE ".TBL_PLAYERS." ADD Forfeits int DEFAULT '0'",
	"ALTER TABLE ".TBL_TEAMS." ADD Forfeits int DEFAULT '0'"
	);
}

/*
echo "<br>Prefs upgrade:";
print_r($upgrade_add_prefs);
echo "<br>Tables upgrade:";
print_r($upgrade_alter_tables);
echo "<br>";
*/

$eplug_upgrade_done = $eplug_name.' successfully upgraded, now using version: '.$eplug_version;

if (!function_exists('ebattles_upgrade')) {
	function ebattles_upgrade() {
		global $sql;

		if (versionsCompare($eb_version_string, "0.9.0") < 0)
		{
			require_once(e_PLUGIN."ebattles/include/gamer.php");
			
			// To revision 0.9.0
			$q = "UPDATE ".TBL_EVENTS." SET Type = 'Clan Ladder' WHERE (Type = 'ClanWar')";
			$result = $sql->db_Query($q);

			$q = "ALTER TABLE ".TBL_PLAYERS." ADD Gamer int(10) unsigned NOT NULL";
			$result = $sql->db_Query($q);
			$q = "ALTER TABLE ".TBL_PLAYERS." ADD INDEX (Gamer)";
			$result = $sql->db_Query($q);
			$q = "ALTER TABLE ".TBL_PLAYERS." ADD FOREIGN KEY (Gamer) REFERENCES ".TBL_GAMERS." (GamerID)";
			$result = $sql->db_Query($q);

			$q = "CREATE TABLE ".TBL_GAMERS."
			(
			GamerID int NOT NULL AUTO_INCREMENT,
			PRIMARY KEY(GamerID),
			User int(10) unsigned NOT NULL,
			INDEX (User),
			FOREIGN KEY (User) REFERENCES ".TBL_USERS." (user_id),
			Game int NOT NULL,
			INDEX (Game),
			FOREIGN KEY (Game) REFERENCES ".TBL_GAMES." (GameID),
			Name varchar(64) NOT NULL default '',
			UniqueGameID varchar(64) NOT NULL default ''
			) ENGINE = MyISAM;";
			$result = $sql->db_Query($q);

			$q = "SELECT DISTINCT ".TBL_PLAYERS.".*, "
			.TBL_EVENTS.".*, "
			.TBL_USERS.".*"
			." FROM ".TBL_PLAYERS.", "
			.TBL_EVENTS.", "
			.TBL_USERS
			." WHERE (".TBL_PLAYERS.".Event =  ".TBL_EVENTS.".EventID)"
			."   AND (".TBL_USERS.".user_id = ".TBL_PLAYERS.".User)";
			$result = $sql->db_Query($q);
			$nbrplayers = mysql_numrows($result);
			for($i = 0; $i < $nbrplayers; $i++)
			{
				$pid = mysql_result($result, $i, TBL_PLAYERS.".PlayerID");
				$puid = mysql_result($result, $i, TBL_PLAYERS.".User");
				$puname = mysql_result($result, $i, TBL_USERS.".user_name");
				$pgame = mysql_result($result, $i, TBL_EVENTS.".Game");
				
				$gamerID = updateGamer($puid, $pgame, $puname, "");

				$q2 = "UPDATE ".TBL_PLAYERS." SET Gamer='$gamerID' WHERE (PlayerId = '$pid')";
				$result2 = $sql->db_Query($q2);
			}
		}
	}
}

if(!function_exists('ebattles_uninstall'))
{
	function ebattles_uninstall()
	{
		global $sql;
		$sql->db_Delete("menus", "menu_name = 'ebattles_menu'");
		$sql->db_Delete("menus", "menu_name = 'eb_activity_menu'");

		//Remove comments and ratings during uninstall
		purgeComments("ebmatches");
		purgeRatings("ebscores");
	}
}

?>