// Variables

public $longname = 'PHPLeague';

public $homepage = 'https://github.com/Mikaweb/PHPLeague-for-WP';

public $edition = 'Ultimate Edition';

public static $access = '';

public static $pages = array(

'phpleague_about',

'phpleague_club',

'phpleague_overview',

'phpleague_player',

'phpleague_setting',

'phpleague_my_results'

);

/**

* Constructor

*

* @param none

* @return void

*/

public function __construct()

{

// Load the constants

$this->define_constants();

// PHPLeague Translation

load_plugin_textdomain('phpleague', FALSE, 'phpleague/i18n');

// Core files

require_once WP_PHPLEAGUE_PATH.'libs/phpleague-tools.php';

require_once WP_PHPLEAGUE_PATH.'libs/phpleague-database.php';

require_once WP_PHPLEAGUE_PATH.'libs/phpleague-widgets.php';

// Sports files

// Soccer is used for testing...

require_once WP_PHPLEAGUE_PATH.'inc/sports/sports.php';

require_once WP_PHPLEAGUE_PATH.'inc/sports/football.php';

require_once WP_PHPLEAGUE_PATH.'inc/sports/volley.php';

// Load our tables

$this->define_tables();

// PHPLeague back-end

if (is_admin())

{

// Specific WP actions...

register_activation_hook(__FILE__, array('PHPLeague', 'activate'));

register_uninstall_hook(__FILE__, array('PHPLeague', 'uninstall'));

// We need to be administrator to manage PHPLeague backend

PHPLeague::$access = 'administrator';

// Load the backend controller system

require_once WP_PHPLEAGUE_PATH.'libs/phpleague-admin.php';

add_action('init', array('PHPLeague_Admin', 'add_editor_button'));

add_action('admin_init', array(&$this, 'plugin_admin_init'));

add_action('admin_init', array(&$this, 'plugin_check_upgrade'));

add_action('admin_menu', array('PHPLeague_Admin', 'admin_menu'));

add_action('admin_print_styles', array('PHPLeague_Admin', 'print_admin_styles'));

add_action('admin_print_scripts', array('PHPLeague_Admin', 'print_admin_scripts'));

add_action('wp_dashboard_setup', array('PHPLeague_Admin', 'register_admin_widgets'));

// AJAX library

require_once WP_PHPLEAGUE_PATH.'libs/phpleague-ajax.php';

// Ajax request to delete a team in player history

add_action('wp_ajax_delete_player_history_team', array('PHPLeague_AJAX', 'delete_player_history_team'));

}

else // PHPLeague front-end

{

// Load the frontend controller system

require_once WP_PHPLEAGUE_PATH.'libs/phpleague-front.php';

add_action('wp_print_styles', array('PHPLeague_Front', 'print_front_styles'));

add_shortcode('phpleague', array(&$this, 'shortcodes_controller'));

}

}

/**

* Define constants

*

* @param none

* @return void

*/

public function define_constants()

{

define('WP_PHPLEAGUE_VERSION', '1.4.7');

define('WP_PHPLEAGUE_DB_VERSION', '1.3.2');

define('WP_PHPLEAGUE_EDITION', $this->edition);

define('WP_PHPLEAGUE_PATH', plugin_dir_path(__FILE__));

define('WP_PHPLEAGUE_UPLOADS_PATH', ABSPATH.'wp-content/uploads/phpleague/');

}

/**

* Admin initializer

*

* @param none

* @return void

*/

public function plugin_admin_init()

{

// Just after the plugin activation, we redirect user to PHPLeague...

if (get_option('phpleague_do_activation_redirect', FALSE))

{

delete_option('phpleague_do_activation_redirect');

wp_redirect(get_option('siteurl').'/wp-admin/admin.php?page=phpleague_overview&activation=1');

die();

}

// Set capabilities

$role = get_role(PHPLeague::$access);

$role->add_cap('manage_phpleague');

$role->add_cap('phpleague');

// Give everyone access to the editor button

$role = get_role('editor');

$role->add_cap('phpleague');

// On every PHPLeague page, we check the permission!

if (isset($_GET['page']) && in_array(trim($_GET['page']), PHPLeague::$pages))

{

if ( ! current_user_can('manage_phpleague') && $_GET['page'] != "phpleague_my_results")

wp_die(__('Permission insufficient to run PHPLeague!', 'phpleague'));

}

}

/**

* Plugin upgrade handler

*

* @param none

* @return void

*/

public function plugin_check_upgrade()

{

global $wpdb;

// Get the current versions from the database

$version = get_option('phpleague_version');

$current_version = isset($version) ? $version : 0;

$db_version = get_option('phpleague_db_version');

$current_db_version = isset($db_version) ? $db_version : 0;

// We're already using the latest version

// so we're leaving!

if ($current_version == WP_PHPLEAGUE_VERSION && $current_db_version == WP_PHPLEAGUE_DB_VERSION)

return;

// Few people encounter issues because they can't handle

// with a 'NOT DEFAULT' without any value

// TODO: upgrade script for sport in league

// TODO: upgrade script for non playing team in fixtures

// TODO: upgrade script for team WordPress user

// TODO: upgrade script for club contact info

if (version_compare($current_db_version, '1.2.0', '<'))

{

// ALTER tables

$wpdb->query("ALTER TABLE $wpdb->country MODIFY name VARCHAR(100) DEFAULT NULL;");

$wpdb->query("ALTER TABLE $wpdb->club MODIFY venue VARCHAR(100) DEFAULT NULL;");

$wpdb->query("ALTER TABLE $wpdb->club MODIFY coach VARCHAR(100) DEFAULT NULL;");

$wpdb->query("ALTER TABLE $wpdb->club MODIFY logo_big VARCHAR(255) DEFAULT NULL;");

$wpdb->query("ALTER TABLE $wpdb->club MODIFY logo_mini VARCHAR(255) DEFAULT NULL;");

}

// We add the 4 UK members...

if (version_compare($current_db_version, '1.2.1', '<'))

{

$countries = array(

238 => 'England',

239 => 'Wales',

240 => 'Northern Ireland',

241 => 'Scotland'

);

// Update the country table with all of the above

foreach ($countries as $key => $country)

{

$wpdb->query("INSERT INTO $wpdb->country VALUES($key, '".$country."');");

}

// Penalty is not unsigned anymore

$wpdb->query("ALTER TABLE $wpdb->team MODIFY penalty TINYINT(1) NOT NULL DEFAULT '0';");

}

// Drop constraints because too much pain in the ass with WP

if (version_compare($current_db_version, '1.2.2', '<'))

{

// ALTER tables

$wpdb->query("ALTER TABLE $wpdb->fixture DROP FOREIGN KEY phpleague_fixture_ibfk_1;");

$wpdb->query("ALTER TABLE $wpdb->match DROP FOREIGN KEY phpleague_match_ibfk_1;");

$wpdb->query("ALTER TABLE $wpdb->table_cache DROP FOREIGN KEY phpleague_table_cache_ibfk_1;");

$wpdb->query("ALTER TABLE $wpdb->team DROP FOREIGN KEY phpleague_team_ibfk_1;");

}

// Few modifications

if (version_compare($current_db_version, '1.3.2', '<'))

{

// No more premium edition...

delete_option('phpleague_edition');

// ALTER tables

$wpdb->query("ALTER TABLE $wpdb->club ADD creation VARCHAR(4) NOT NULL DEFAULT '0000' AFTER coach;");

$wpdb->query("ALTER TABLE $wpdb->club ADD website VARCHAR(255) DEFAULT NULL AFTER creation;");

$wpdb->query("ALTER TABLE $wpdb->league MODIFY id_favorite smallint(4) unsigned NOT NULL DEFAULT '0';");

$wpdb->query("ALTER TABLE $wpdb->league ADD team_link ENUM('no','yes') NOT NULL DEFAULT 'no' AFTER nb_leg;");

$wpdb->query("ALTER TABLE $wpdb->league ADD default_time time NOT NULL DEFAULT '17:00:00' AFTER team_link;");

$wpdb->query("ALTER TABLE $wpdb->league ADD player_mod ENUM('no','yes') NOT NULL DEFAULT 'no' AFTER nb_teams;");

$wpdb->query("ALTER TABLE $wpdb->league ADD sport_type VARCHAR(50) NOT NULL DEFAULT 'football' AFTER player_mod;");

$wpdb->query("ALTER TABLE $wpdb->league ADD nb_starter TINYINT(1) unsigned NOT NULL DEFAULT '0' AFTER sport_type;");

$wpdb->query("ALTER TABLE $wpdb->league ADD nb_bench TINYINT(1) unsigned NOT NULL DEFAULT '0' AFTER nb_starter;");

$wpdb->query("ALTER TABLE $wpdb->league ADD prediction_mod ENUM('no','yes') NOT NULL DEFAULT 'no' AFTER nb_bench;");

$wpdb->query("ALTER TABLE $wpdb->league ADD point_right TINYINT(1) unsigned NOT NULL DEFAULT '5' AFTER prediction_mod;");

$wpdb->query("ALTER TABLE $wpdb->league ADD point_wrong TINYINT(1) unsigned NOT NULL DEFAULT '0' AFTER point_right;");

$wpdb->query("ALTER TABLE $wpdb->league ADD point_part TINYINT(1) unsigned NOT NULL DEFAULT '1' AFTER point_wrong;");

$wpdb->query("ALTER TABLE $wpdb->league ADD deadline TINYINT(1) unsigned NOT NULL DEFAULT '1' AFTER point_part;");

}

// Basic actions to do everytime we upgrade PHPLeague...

if ($current_version < WP_PHPLEAGUE_VERSION)

{

update_option('phpleague_version', WP_PHPLEAGUE_VERSION);

update_option('phpleague_db_version', WP_PHPLEAGUE_DB_VERSION);

}

}

/**

* Define every table

*

* @param none

* @return void

*/

public function define_tables()

{

global $wpdb;

// PHPLeague tables

$wpdb->club = $wpdb->prefix.'phpleague_club';

$wpdb->country = $wpdb->prefix.'phpleague_country';

$wpdb->fixture = $wpdb->prefix.'phpleague_fixture';

$wpdb->league = $wpdb->prefix.'phpleague_league';

$wpdb->match = $wpdb->prefix.'phpleague_match';

$wpdb->table_cache = $wpdb->prefix.'phpleague_table_cache';

$wpdb->team = $wpdb->prefix.'phpleague_team';

$wpdb->player = $wpdb->prefix.'phpleague_player';

$wpdb->player_team = $wpdb->prefix.'phpleague_player_team';

$wpdb->player_data = $wpdb->prefix.'phpleague_player_data';

$wpdb->table_chart = $wpdb->prefix.'phpleague_table_chart';

$wpdb->table_predi = $wpdb->prefix.'phpleague_table_prediction';

}

/**

* Create or update the tables

*

* @param string table name

* @param string sql

* @param integer db version

* @return object

*/

public static function run_install_or_upgrade($table_name, $sql, $db_version)

{

global $wpdb;

// Table does not exist, we create it!

// We use InnoDB and UTF-8 by default

if ($wpdb->get_var("SHOW TABLES LIKE '".$table_name."'") != $table_name)

{

$create = "CREATE TABLE ".$table_name." ( ".$sql." ) ENGINE=InnoDB DEFAULT CHARSET=utf8 ;";

// We use the dbDelta method given by WP!

require_once ABSPATH.'wp-admin/includes/upgrade.php';

dbDelta($create);

}

}

/**

* Plugin activation method

*

* @param none

* @return void

*/

public static function activate()

{

global $wpdb;

$db_version = WP_PHPLEAGUE_DB_VERSION;

// Club table

$sql = "id smallint(5) unsigned NOT NULL AUTO_INCREMENT,

name VARCHAR(255) NOT NULL DEFAULT '',

id_country smallint(4) unsigned NOT NULL,

venue VARCHAR(100) DEFAULT NULL,

coach VARCHAR(100) DEFAULT NULL,

logo_big VARCHAR(255) DEFAULT NULL,

logo_mini VARCHAR(255) DEFAULT NULL,

creation VARCHAR(4) NOT NULL DEFAULT '0000',

website VARCHAR(255) DEFAULT NULL,

wp_user_id bigint(20) DEFAULT NULL,

address VARCHAR(255) DEFAULT NULL,

phone VARCHAR(50) DEFAULT NULL,

training_time VARCHAR(255) DEFAULT NULL,

PRIMARY KEY (id),

UNIQUE KEY name (name)";

PHPLeague::run_install_or_upgrade($wpdb->club, $sql, $db_version);

// Country table

$sql = "id tinyint(1) unsigned NOT NULL AUTO_INCREMENT,

name VARCHAR(100) DEFAULT NULL,

PRIMARY KEY (id),

UNIQUE KEY name (name)";

PHPLeague::run_install_or_upgrade($wpdb->country, $sql, $db_version);

// Fixture table

$sql = "number tinyint(3) unsigned NOT NULL DEFAULT '0',

scheduled date NOT NULL DEFAULT '0000-00-00',

id smallint(5) unsigned NOT NULL AUTO_INCREMENT,

id_league smallint(5) unsigned NOT NULL DEFAULT '0',

non_playing_team_id smallint(5) unsigned DEFAULT NULL,

PRIMARY KEY (id),

KEY id_league (id_league)";

PHPLeague::run_install_or_upgrade($wpdb->fixture, $sql, $db_version);

// League table

$sql = "id smallint(5) unsigned NOT NULL AUTO_INCREMENT,

name VARCHAR(100) NOT NULL DEFAULT '',

year year(4) NOT NULL,

sport VARCHAR(100) NOT NULL DEFAULT '',

pt_victory tinyint(3) unsigned NOT NULL DEFAULT '3',

pt_draw tinyint(3) unsigned NOT NULL DEFAULT '1',

pt_defeat tinyint(3) unsigned NOT NULL DEFAULT '0',

promotion tinyint(3) unsigned NOT NULL DEFAULT '4',

qualifying tinyint(3) unsigned NOT NULL DEFAULT '2',

relegation tinyint(3) unsigned NOT NULL DEFAULT '3',

id_favorite smallint(4) unsigned NOT NULL DEFAULT '0',

nb_leg tinyint(1) NOT NULL DEFAULT '2',

team_link ENUM('no','yes') NOT NULL DEFAULT 'no',

default_time time NOT NULL DEFAULT '17:00:00',

nb_teams tinyint(1) NOT NULL DEFAULT '0',

player_mod ENUM('no','yes') NOT NULL DEFAULT 'no',

sport_type VARCHAR(50) NOT NULL DEFAULT 'football',

nb_starter TINYINT(1) unsigned NOT NULL DEFAULT '0',

nb_bench TINYINT(1) unsigned NOT NULL DEFAULT '0',

prediction_mod ENUM('no','yes') NOT NULL DEFAULT 'no',

point_right TINYINT(1) unsigned NOT NULL DEFAULT '5',

point_wrong TINYINT(1) unsigned NOT NULL DEFAULT '0',

point_part TINYINT(1) unsigned NOT NULL DEFAULT '1',

deadline TINYINT(1) unsigned NOT NULL DEFAULT '1',

PRIMARY KEY (id)";

PHPLeague::run_install_or_upgrade($wpdb->league, $sql, $db_version);

// Match table

$sql = "id mediumint(6) unsigned NOT NULL AUTO_INCREMENT,

id_team_home smallint(5) unsigned DEFAULT NULL,

id_team_away smallint(5) unsigned DEFAULT NULL,

played datetime DEFAULT NULL,

id_fixture smallint(5) unsigned DEFAULT NULL,

goal_home int(11) DEFAULT NULL,

goal_away int(11) DEFAULT NULL,

PRIMARY KEY (id),

KEY id_fixture (id_fixture),

KEY id_team_away (id_team_away),

KEY id_team_home (id_team_home)";

PHPLeague::run_install_or_upgrade($wpdb->match, $sql, $db_version);

// Table Cache table

$sql = "club_name VARCHAR(255) DEFAULT NULL,

points smallint(4) unsigned DEFAULT NULL,

played tinyint(3) unsigned DEFAULT NULL,

victory tinyint(3) unsigned DEFAULT NULL,

draw tinyint(3) unsigned DEFAULT NULL,

defeat tinyint(3) unsigned DEFAULT NULL,

goal_for smallint(4) unsigned DEFAULT NULL,

goal_against smallint(4) unsigned DEFAULT NULL,

diff smallint(4) DEFAULT NULL,

pen tinyint(2) DEFAULT NULL,

home_points smallint(4) unsigned DEFAULT NULL,

home_played tinyint(3) unsigned DEFAULT NULL,

home_v tinyint(3) unsigned DEFAULT NULL,

home_d tinyint(3) unsigned DEFAULT NULL,

home_l tinyint(3) unsigned DEFAULT NULL,

home_g_for smallint(4) unsigned DEFAULT NULL,

home_g_against smallint(4) unsigned DEFAULT NULL,

home_diff smallint(4) DEFAULT NULL,

away_points smallint(4) unsigned DEFAULT NULL,

away_played tinyint(3) unsigned DEFAULT NULL,

away_v tinyint(3) unsigned DEFAULT NULL,

away_d tinyint(3) unsigned DEFAULT NULL,

away_l tinyint(3) unsigned DEFAULT NULL,

away_g_for smallint(4) unsigned DEFAULT NULL,

away_g_against smallint(4) unsigned DEFAULT NULL,

away_diff tinyint(4) DEFAULT NULL,

id_team smallint(5) unsigned NOT NULL DEFAULT '0',

id_league smallint(5) unsigned NOT NULL DEFAULT '0',

KEY id_league (id_league)";

PHPLeague::run_install_or_upgrade($wpdb->table_cache, $sql, $db_version);

// Team table

$sql = "id smallint(5) unsigned NOT NULL AUTO_INCREMENT,

id_league smallint(5) unsigned NOT NULL DEFAULT '0',

id_club smallint(5) unsigned NOT NULL DEFAULT '0',

penalty tinyint(1) NOT NULL DEFAULT '0',

PRIMARY KEY (id),

KEY id_club (id_club),

KEY id_league (id_league)";

PHPLeague::run_install_or_upgrade($wpdb->team, $sql, $db_version);

// Player table

$sql = "id smallint(6) unsigned NOT NULL AUTO_INCREMENT,

firstname varchar(100) NOT NULL DEFAULT '',

lastname varchar(100) NOT NULL DEFAULT '',

description text,

birthdate date NOT NULL DEFAULT '0000-00-00',

weight tinyint(1) unsigned NOT NULL DEFAULT '0',

height tinyint(1) unsigned NOT NULL DEFAULT '0',

picture varchar(255) NOT NULL DEFAULT '',

id_country tinyint(1) unsigned NOT NULL DEFAULT '0',

id_term smallint(6) unsigned NOT NULL DEFAULT '0',

PRIMARY KEY (id)";

PHPLeague::run_install_or_upgrade($wpdb->player, $sql, $db_version);

// Player data table

$sql = "id_event tinyint(1) unsigned NOT NULL DEFAULT '0',

id_player_team smallint(4) unsigned NOT NULL DEFAULT '0',

id_match smallint(4) unsigned NOT NULL DEFAULT '0',

value tinyint(1) unsigned NOT NULL DEFAULT '0',

KEY id_match (id_match),

KEY id_event (id_event),

KEY id_player_team (id_player_team)";

PHPLeague::run_install_or_upgrade($wpdb->player_data, $sql, $db_version);

// Player team table

$sql = "id smallint(4) unsigned NOT NULL AUTO_INCREMENT,

id_player smallint(4) unsigned NOT NULL DEFAULT '0',

id_team smallint(4) unsigned NOT NULL DEFAULT '0',

number tinyint(1) unsigned NOT NULL DEFAULT '0',

position tinyint(1) unsigned NOT NULL DEFAULT '0',

PRIMARY KEY (id),

KEY id_player (id_player),

KEY id_team (id_team)";

PHPLeague::run_install_or_upgrade($wpdb->player_team, $sql, $db_version);

// Charts table

$sql = "id_team mediumint(5) unsigned NOT NULL DEFAULT '0',

fixture tinyint(1) unsigned NOT NULL DEFAULT '0',

ranking tinyint(1) unsigned NOT NULL DEFAULT '0',

KEY id_team (id_team)";

PHPLeague::run_install_or_upgrade($wpdb->table_chart, $sql, $db_version);

// Prediction table

$sql = "id_league smallint(3) unsigned NOT NULL DEFAULT '0',

id_member smallint(3) unsigned NOT NULL DEFAULT '0',

points smallint(3) unsigned NOT NULL DEFAULT '0',

participation smallint(3) unsigned NOT NULL DEFAULT '0',

KEY id_league (id_league),

KEY id_member (id_member)";

// TODO - Add 'type of ranking (monthly, weekly, yearly, ...)' field later

// TODO - Give possibility to predict the score too...

PHPLeague::run_install_or_upgrade($wpdb->table_predi, $sql, $db_version);

// Countries listing

$countries = array(

1 => 'Afghanistan',

2 => 'Zaire',

3 => 'Albania',

4 => 'Algeria',

5 => 'American&nbsp;Samoa',

6 => 'Andorra',

7 => 'Angola',

8 => 'Anguilla',

9 => 'Antarctica',

10 => 'Antigua&nbsp;and&nbsp;Barbuda',

11 => 'Argentina',

12 => 'Armenia',

13 => 'Aruba',

14 => 'Australia',

15 => 'Austria',

16 => 'Azerbaijan',

17 => 'Bahamas',

18 => 'Bahrain',

19 => 'Bangladesh',

20 => 'Barbados',

21 => 'Belarus',

22 => 'Belgium',

23 => 'Belize',

24 => 'Benin',

25 => 'Bermuda',

26 => 'Bhutan',

27 => 'Bolivia',

28 => 'Bosnia&nbsp;and&nbsp;Herzegovina',

29 => 'Botswana',

30 => 'Bouvet&nbsp;Island',

31 => 'Brazil',

32 => 'British&nbsp;Indian&nbsp;Ocean&nbsp;territory',

33 => 'Brunei&nbsp;Darussalam',

34 => 'Bulgaria',

35 => 'Burkina&nbsp;Faso',

36 => 'Burundi',

37 => 'Cambodia',

38 => 'Cameroon',

39 => 'Canada',

40 => 'Cape&nbsp;Verde',

41 => 'Cayman&nbsp;Islands',

42 => 'Central&nbsp;African&nbsp;Republic',

43 => 'Chad',

44 => 'Chile',

45 => 'China',

46 => 'Christmas&nbsp;Island',

47 => 'Cocos&nbsp;Keeling)&nbsp;Islands',

48 => 'Colombia',

49 => 'Comoros',

50 => 'Congo',

51 => 'Zambia',

52 => 'Zimbabwe',

53 => 'Cook&nbsp;Islands',

54 => 'Costa&nbsp;Rica',

55 => 'Ivory Coast',

56 => 'Croatia',

57 => 'Cuba',

58 => 'Cyprus',

59 => 'Czech&nbsp;Republic',

60 => 'Denmark',

61 => 'Djibouti',

62 => 'Dominica',

63 => 'Dominican&nbsp;Republic',

64 => 'East&nbsp;Timor',

65 => 'Ecuador',

66 => 'Egypt',

67 => 'El&nbsp;Salvador',

68 => 'Equatorial&nbsp;Guinea',

69 => 'Eritrea',

70 => 'Estonia',

71 => 'Ethiopia',

72 => 'Falkland&nbsp;Islands',

73 => 'Faroe&nbsp;Islands',

74 => 'Fiji',

75 => 'Finland',

76 => 'France',

77 => 'French&nbsp;Guiana',

78 => 'French&nbsp;Polynesia',

79 => 'French&nbsp;Southern&nbsp;Territories',

80 => 'Gabon',

81 => 'Gambia',

82 => 'Georgia',

83 => 'Germany',

84 => 'Ghana',

85 => 'Gibraltar',

86 => 'Greece',

87 => 'Greenland',

88 => 'Grenada',

89 => 'Guadeloupe',

90 => 'Guam',

91 => 'Guatemala',

92 => 'Guinea',

93 => 'Guinea-Bissau',

94 => 'Guyana',

95 => 'Haiti',

96 => 'Heard&nbsp;and&nbsp;McDonald&nbsp;Islands',

97 => 'Honduras',

98 => 'Hong&nbsp;Kong',

99 => 'Hungary',

100 => 'Iceland',

101 => 'India',

102 => 'Indonesia',

103 => 'Iran',

104 => 'Iraq',

105 => 'Ireland',

106 => 'Israel',

107 => 'Italy',

108 => 'Jamaica',

109 => 'Japan',

110 => 'Jordan',

111 => 'Kazakhstan',

112 => 'Kenya',

113 => 'Kiribati',

114 => 'North Korea',

115 => 'South Korea',

116 => 'Kuwait',

117 => 'Kyrgyzstan',

118 => 'Laos',

119 => 'Latvia',

120 => 'Lebanon',

121 => 'Lesotho',

122 => 'Liberia',

123 => 'Libyan&nbsp;Arab&nbsp;Jamahiriya',

124 => 'Liechtenstein',

125 => 'Lithuania',

126 => 'Luxembourg',

127 => 'Macao',

128 => 'Macedonia',

129 => 'Madagascar',

130 => 'Malawi',

131 => 'Malaysia',

132 => 'Maldives',

133 => 'Mali',

134 => 'Malta',

135 => 'Marshall&nbsp;Islands',

136 => 'Martinique',

137 => 'Mauritania',

138 => 'Mauritius',

139 => 'Mayotte',

140 => 'Mexico',

141 => 'Micronesia',

142 => 'Moldova',

143 => 'Monaco',

144 => 'Mongolia',

145 => 'Montserrat',

146 => 'Morocco',

147 => 'Mozambique',

148 => 'Myanmar',

149 => 'Namibia',

150 => 'Nauru',

151 => 'Nepal',

152 => 'Netherlands',

153 => 'Netherlands&nbsp;Antilles',

154 => 'New&nbsp;Caledonia',

155 => 'New&nbsp;Zealand',

156 => 'Nicaragua',

157 => 'Niger',

158 => 'Nigeria',

159 => 'Niue',

160 => 'Norfolk&nbsp;Island',

161 => 'Northern&nbsp;Mariana&nbsp;Islands',

162 => 'Norway',

163 => 'Oman',

164 => 'Pakistan',

165 => 'Palau',

166 => 'Palestinian&nbsp;Territories',

167 => 'Panama',

168 => 'Papua&nbsp;New&nbsp;Guinea',

169 => 'Paraguay',

170 => 'Peru',

171 => 'Philippines',

172 => 'Pitcairn',

173 => 'Poland',

174 => 'Portugal',

175 => 'Puerto&nbsp;Rico',

176 => 'Qatar',

177 => 'R&eacute;union',

178 => 'Romania',

179 => 'Russia',

180 => 'Rwanda',

181 => 'Saint&nbsp;Helena',

182 => 'Saint&nbsp;Kitts&nbsp;and&nbsp;Nevis',

183 => 'Saint&nbsp;Lucia',

184 => 'Saint&nbsp;Pierre&nbsp;and&nbsp;Miquelon',

185 => 'Saint&nbsp;Vincent&nbsp;and&nbsp;the&nbsp;Grenadines',

186 => 'Samoa',

187 => 'San&nbsp;Marino',

188 => 'Sao&nbsp;Tome&nbsp;and&nbsp;Principe',

189 => 'Saudi&nbsp;Arabia',

190 => 'Senegal',

191 => 'Serbia&nbsp;and&nbsp;Montenegro',

192 => 'Seychelles',

193 => 'Sierra&nbsp;Leone',

194 => 'Singapore',

195 => 'Slovakia',

196 => 'Slovenia',

197 => 'Solomon&nbsp;Islands',

198 => 'Somalia',

199 => 'South&nbsp;Africa',

200 => 'Yemen',

201 => 'Spain',

202 => 'Sri&nbsp;Lanka',

203 => 'Sudan',

204 => 'Suriname',

205 => 'Svalbard&nbsp;and&nbsp;Jan&nbsp;Mayen&nbsp;Islands',

206 => 'Swaziland',

207 => 'Sweden',

208 => 'Switzerland',

209 => 'Syria',

210 => 'Taiwan',

211 => 'Tajikistan',

212 => 'Tanzania',

213 => 'Thailand',

214 => 'Togo',

215 => 'Tokelau',

216 => 'Tonga',

217 => 'Trinidad&nbsp;and&nbsp;Tobago',

218 => 'Tunisia',

219 => 'Turkey',

220 => 'Turkmenistan',

221 => 'Turks&nbsp;and&nbsp;Caicos&nbsp;Islands',

222 => 'Tuvalu',

223 => 'Uganda',

224 => 'Ukraine',

225 => 'United&nbsp;Arab&nbsp;Emirates',

226 => 'United&nbsp;Kingdom',

227 => 'United&nbsp;States&nbsp;of&nbsp;America',

228 => 'Uruguay',

229 => 'Uzbekistan',

230 => 'Vanuatu',

231 => 'Vatican&nbsp;City',

232 => 'Venezuela',

233 => 'Vietnam',

234 => 'Virgin&nbsp;Islands&nbsp;British',

235 => 'Virgin&nbsp;Islands&nbsp;US',

236 => 'Wallis&nbsp;and&nbsp;Futuna&nbsp;Islands',

237 => 'Western&nbsp;Sahara',

238 => 'England',

239 => 'Wales',

240 => 'Northern Ireland',

241 => 'Scotland'

);

// Add every country in the database

foreach ($countries as $key => $country)

{

$wpdb->query("INSERT INTO $wpdb->country VALUES($key, '".$country."');");

}

// Create the PHPLeague directory and sub-directories

PHPLeague_Tools::manage_directory(WP_PHPLEAGUE_UPLOADS_PATH, 'create');

PHPLeague_Tools::manage_directory(WP_PHPLEAGUE_UPLOADS_PATH.'logo_big/', 'create');

PHPLeague_Tools::manage_directory(WP_PHPLEAGUE_UPLOADS_PATH.'logo_mini/', 'create');

PHPLeague_Tools::manage_directory(WP_PHPLEAGUE_UPLOADS_PATH.'players/', 'create');

// Save versions

add_option('phpleague_version', WP_PHPLEAGUE_VERSION);

add_option('phpleague_db_version', $db_version);

add_option('phpleague_do_activation_redirect', TRUE);

}

/**

* Uninstall plugin method

*

* @param none

* @return void

*/

public static function uninstall()

{

global $wpdb;

// PHPLeague tables

$tables = array(

$wpdb->fixture,

$wpdb->league,

$wpdb->club,

$wpdb->country,

$wpdb->match,

$wpdb->table_cache,

$wpdb->team,

$wpdb->player,

$wpdb->player_team,

$wpdb->player_data,

$wpdb->table_chart,

$wpdb->table_predi

);

// Delete each table one by one

foreach ($tables as $table)

{

$wpdb->query('DROP TABLE IF EXISTS '.$table.';');

}

// Delete the versions in the options table

delete_option('phpleague_version');

delete_option('phpleague_db_version');

// Delete the PHPLeague directory and sub-directories

PHPLeague_Tools::manage_directory(WP_PHPLEAGUE_UPLOADS_PATH, 'delete');

PHPLeague_Tools::manage_directory(WP_PHPLEAGUE_UPLOADS_PATH.'logo_big/', 'delete');

PHPLeague_Tools::manage_directory(WP_PHPLEAGUE_UPLOADS_PATH.'logo_mini/', 'delete');

PHPLeague_Tools::manage_directory(WP_PHPLEAGUE_UPLOADS_PATH.'players/', 'delete');

}

/**

* The shortcodes controller

*

* @param mixed $attributes

* @return void

*/

public function shortcodes_controller($attributes)

{

// Extract data

extract(shortcode_atts(

array(

'id' => 1,

'type' => 'table',

'style' => 'general',

'id_team' => '',

'latest' => 'false'

),

$attributes

));

// TODO - In the future, make a specific Front_Controller for every sport.

// Make sure the ID is an integer

$id = (int) $id;

// Get front-end methods

$front = new PHPLeague_Front;

// Display ranking table

if ($type == 'table')

{

if ($style == 'home')

return $front->get_league_table($id, 'home', $latest);

elseif ($style == 'away')

return $front->get_league_table($id, 'away', $latest);

else

return $front->get_league_table($id, 'general', $latest);

}

elseif ($type == 'fixture') // Display fixture table

{

return $front->get_league_fixture($id);

}

elseif ($type == 'fixtures') // Display fixtures table

{

if ( ! empty($id_team))

return $front->get_league_fixtures($id, $id_team);

else

return $front->get_league_fixtures($id);

}

elseif ($type == 'club') // Display club information

{

return $front->get_club_information($id);

}

elseif ($type == 'clubs') // Display all clubs

{

return $front->get_clubs_information();

}

else // Display ranking table by default

{

return $front->get_league_table($id);

}

}