public function saveConfig()
{
$date_format = JRequest::getVar('date_format', '', 'post', 'string');
$yteam_color = JRequest::getVar('yteam_color', '', 'post', 'string');
$nick_reg = JRequest::getVar('nick_reg', 0, 'post', 'int');
$nick_reg_rq = JRequest::getVar('nick_reg_rq', 0, 'post', 'int');
$country_reg = JRequest::getVar('country_reg', 0, 'post', 'int');
$country_reg_rq = JRequest::getVar('country_reg_rq', 0, 'post', 'int');
$mcomments = JRequest::getVar('mcomments', 0, 'post', 'int');
$player_reg = JRequest::getVar('player_reg', 0, 'post', 'int');
$team_reg = JRequest::getVar('team_reg', 0, 'post', 'int');
$moder_addplayer = JRequest::getVar('moder_addplayer', 0, 'post', 'int');
$pllist_order = JRequest::getVar('pllist_order', 0, 'post', 'string');
$pllist_order_se = JRequest::getVar('pllist_order_se', 0, 'post', 'string');
//SELECT
$teamlogo_height = JRequest::getVar('teamlogo_height', 0, 'post', 'int');
$teams_per_account = JRequest::getVar('teams_per_account', 0, 'post', 'int');
$players_per_account = JRequest::getVar('players_per_account', 0, 'post', 'int');
$unbl_venue = JRequest::getVar('unbl_venue', 0, 'post', 'int');
$cal_venue = JRequest::getVar('cal_venue', 0, 'post', 'int');
$played_matches = JRequest::getVar('played_matches', 0, 'post', 'int');
$player_name = JRequest::getVar('player_name', 0, 'post', 'int');
$esport_invite_player = JRequest::getVar('esport_invite_player', 0, 'post', 'int');
$esport_invite_confirm = JRequest::getVar('esport_invite_confirm', 0, 'post', 'int');
$esport_invite_unregister = JRequest::getVar('esport_invite_unregister', 0, 'post', 'int');
$esport_join_team = JRequest::getVar('esport_join_team', 0, 'post', 'int');
$jssa_editplayer = JRequest::getVar('jssa_editplayer', 0, 'post', 'int');
$jssa_editplayer_single = JRequest::getVar('jssa_editplayer_single', 0, 'post', 'int');
$jssa_deleteplayers = JRequest::getVar('jssa_deleteplayers', 0, 'post', 'int');
$jssa_deleteplayers_single = JRequest::getVar('jssa_deleteplayers_single', 0, 'post', 'int');
$esport_invite_match = JRequest::getVar('esport_invite_match', 0, 'post', 'int');
$knock_style = JRequest::getVar('knock_style', 0, 'post', 'int');
$jsb_twitter = JRequest::getVar('jsb_twitter', 0, 'post', 'int');
$jsb_gplus = JRequest::getVar('jsb_gplus', 0, 'post', 'int');
$jsb_fbshare = JRequest::getVar('jsb_fbshare', 0, 'post', 'int');
$jsb_fblike = JRequest::getVar('jsb_fblike', 0, 'post', 'int');
$jsbp_season = JRequest::getVar('jsbp_season', 0, 'post', 'int');
$jsbp_team = JRequest::getVar('jsbp_team', 0, 'post', 'int');
$jsbp_player = JRequest::getVar('jsbp_player', 0, 'post', 'int');
$jsbp_match = JRequest::getVar('jsbp_match', 0, 'post', 'int');
$jsbp_venue = JRequest::getVar('jsbp_venue', 0, 'post', 'int');
$jssa_editteam = JRequest::getVar('jssa_editteam', 0, 'post', 'int');
$jssa_delteam = JRequest::getVar('jssa_delteam', 0, 'post', 'int');
$jssa_addexteam = JRequest::getVar('jssa_addexteam', 0, 'post', 'int');
/*UPDATE*/
$jssa_addexteam_single = JRequest::getVar('jssa_addexteam_single', 0, 'post', 'int');
$player_team_reg = JRequest::getVar('player_team_reg', 0, 'post', 'int');
$autoreg_player = JRequest::getVar('autoreg_player', 0, 'post', 'int');
$reg_lastname = JRequest::getVar('reg_lastname', 0, 'post', 'int');
$reg_lastname_rq = JRequest::getVar('reg_lastname_rq', 0, 'post', 'int');
$jsbrand_on = JRequest::getVar('jsbrand_on', 0, 'post', 'int');
//$jsbrand_epanel_image = JRequest::getVar( 't_logo', '', 'post', 'string' );
$istlogo = JRequest::getVar('istlogo', 0, 'post', 'int');
$jsmr_mark_played = JRequest::getVar('jsmr_mark_played', 0, 'post', 'int');
$jsmr_editresult_yours = JRequest::getVar('jsmr_editresult_yours', 0, 'post', 'int');
$jsmr_editresult_opposite = JRequest::getVar('jsmr_editresult_opposite', 0, 'post', 'int');
$jsmr_edit_playerevent_yours = JRequest::getVar('jsmr_edit_playerevent_yours', 0, 'post', 'int');
$jsmr_edit_playerevent_opposite = JRequest::getVar('jsmr_edit_playerevent_opposite', 0, 'post', 'int');
$jsmr_edit_matchevent_yours = JRequest::getVar('jsmr_edit_matchevent_yours', 0, 'post', 'int');
$jsmr_edit_matchevent_opposite = JRequest::getVar('jsmr_edit_matchevent_opposite', 0, 'post', 'int');
$jsmr_edit_squad_yours = JRequest::getVar('jsmr_edit_squad_yours', 0, 'post', 'int');
$jsmr_edit_squad_opposite = JRequest::getVar('jsmr_edit_squad_opposite', 0, 'post', 'int');
$query = "UPDATE #__bl_config SET cfg_value='" . $jsmr_mark_played . "' WHERE cfg_name='jsmr_mark_played'";
$this->db->setquery($query);
$this->db->query();
$query = "UPDATE #__bl_config SET cfg_value='" . $jsmr_editresult_yours . "' WHERE cfg_name='jsmr_editresult_yours'";
$this->db->setquery($query);
$this->db->query();
$query = "UPDATE #__bl_config SET cfg_value='" . $jsmr_editresult_opposite . "' WHERE cfg_name='jsmr_editresult_opposite'";
$this->db->setquery($query);
$this->db->query();
$query = "UPDATE #__bl_config SET cfg_value='" . $jsmr_edit_playerevent_yours . "' WHERE cfg_name='jsmr_edit_playerevent_yours'";
$this->db->setquery($query);
$this->db->query();
$query = "UPDATE #__bl_config SET cfg_value='" . $jsmr_edit_playerevent_opposite . "' WHERE cfg_name='jsmr_edit_playerevent_opposite'";
$this->db->setquery($query);
$this->db->query();
$query = "UPDATE #__bl_config SET cfg_value='" . $jsmr_edit_matchevent_yours . "' WHERE cfg_name='jsmr_edit_matchevent_yours'";
$this->db->setquery($query);
$this->db->query();
$query = "UPDATE #__bl_config SET cfg_value='" . $jsmr_edit_matchevent_opposite . "' WHERE cfg_name='jsmr_edit_matchevent_opposite'";
$this->db->setquery($query);
$this->db->query();
$query = "UPDATE #__bl_config SET cfg_value='" . $jsmr_edit_squad_yours . "' WHERE cfg_name='jsmr_edit_squad_yours'";
$this->db->setquery($query);
$this->db->query();
$query = "UPDATE #__bl_config SET cfg_value='" . $jsmr_edit_squad_opposite . "' WHERE cfg_name='jsmr_edit_squad_opposite'";
$this->db->setquery($query);
$this->db->query();
if (!$istlogo) {
$jsbrand_epanel_image = '';
$query = "UPDATE #__bl_config SET cfg_value='" . $jsbrand_epanel_image . "' WHERE cfg_name='jsbrand_epanel_image'";
$this->db->setquery($query);
$this->db->query();
}
if (isset($_FILES['t_logo']['name']) && $_FILES['t_logo']['tmp_name'] != '' && isset($_FILES['t_logo']['tmp_name'])) {
$ext = pathinfo($_FILES['t_logo']['name']);
$bl_filename = "bl" . time() . rand(0, 3000) . '.' . $ext['extension'];
$bl_filename = str_replace(" ", "", $bl_filename);
//echo $bl_filename;
if ($this->uploadFile($_FILES['t_logo']['tmp_name'], $bl_filename)) {
$jsbrand_epanel_image = '/media/bearleague/' . $bl_filename;
$query = "UPDATE #__bl_config SET cfg_value='" . $jsbrand_epanel_image . "' WHERE cfg_name='jsbrand_epanel_image'";
$this->db->setquery($query);
$this->db->query();
}
}
$query = "UPDATE #__bl_config SET cfg_value='" . $jsbrand_on . "' WHERE cfg_name='jsbrand_on'";
$this->db->setquery($query);
$this->db->query();
$query = "UPDATE #__bl_config SET cfg_value='" . $jssa_editteam . "' WHERE cfg_name='jssa_editteam'";
$this->db->setquery($query);
$this->db->query();
$query = "UPDATE #__bl_config SET cfg_value='" . $jssa_delteam . "' WHERE cfg_name='jssa_delteam'";
$this->db->setquery($query);
$this->db->query();
$query = "UPDATE #__bl_config SET cfg_value='" . $date_format . "' WHERE cfg_name='date_format'";
$this->db->setquery($query);
$this->db->query();
$query = "UPDATE #__bl_config SET cfg_value='" . $yteam_color . "' WHERE cfg_name='yteam_color'";
$this->db->setquery($query);
$this->db->query();
$query = "UPDATE #__bl_config SET cfg_value='" . $nick_reg . "' WHERE cfg_name='nick_reg'";
$this->db->setquery($query);
$this->db->query();
$query = "UPDATE #__bl_config SET cfg_value='" . $nick_reg_rq . "' WHERE cfg_name='nick_reg_rq'";
$this->db->setquery($query);
$this->db->query();
$query = "UPDATE #__bl_config SET cfg_value='" . $country_reg . "' WHERE cfg_name='country_reg'";
$this->db->setquery($query);
$this->db->query();
$query = "UPDATE #__bl_config SET cfg_value='" . $country_reg_rq . "' WHERE cfg_name='country_reg_rq'";
$this->db->setquery($query);
$this->db->query();
$query = "UPDATE #__bl_config SET cfg_value='" . $mcomments . "' WHERE cfg_name='mcomments'";
$this->db->setquery($query);
$this->db->query();
$query = "UPDATE #__bl_config SET cfg_value='" . $player_reg . "' WHERE cfg_name='player_reg'";
$this->db->setquery($query);
$this->db->query();
$query = "UPDATE #__bl_config SET cfg_value='" . $team_reg . "' WHERE cfg_name='team_reg'";
$this->db->setquery($query);
$this->db->query();
$query = "UPDATE #__bl_config SET cfg_value='" . $moder_addplayer . "' WHERE cfg_name='moder_addplayer'";
$this->db->setquery($query);
$this->db->query();
$query = "UPDATE #__bl_config SET cfg_value='" . $pllist_order . "' WHERE cfg_name='pllist_order'";
$this->db->setquery($query);
$this->db->query();
//select
$query = "UPDATE #__bl_config SET cfg_value='" . $pllist_order_se . "' WHERE cfg_name='pllist_order_se'";
$this->db->setquery($query);
$this->db->query();
$query = "UPDATE #__bl_config SET cfg_value='" . $teamlogo_height . "' WHERE cfg_name='teamlogo_height'";
$this->db->setquery($query);
$this->db->query();
$query = "UPDATE #__bl_config SET cfg_value='" . $teams_per_account . "' WHERE cfg_name='teams_per_account'";
$this->db->setquery($query);
$this->db->query();
$query = "UPDATE #__bl_config SET cfg_value='" . $players_per_account . "' WHERE cfg_name='players_per_account'";
$this->db->setquery($query);
$this->db->query();
$query = "UPDATE #__bl_config SET cfg_value='" . $unbl_venue . "' WHERE cfg_name='unbl_venue'";
$this->db->setquery($query);
$this->db->query();
$query = "UPDATE #__bl_config SET cfg_value='" . $cal_venue . "' WHERE cfg_name='cal_venue'";
$this->db->setquery($query);
$this->db->query();
$query = "UPDATE #__bl_config SET cfg_value='" . $played_matches . "' WHERE cfg_name='played_matches'";
$this->db->setquery($query);
$this->db->query();
$query = "UPDATE #__bl_config SET cfg_value='" . $player_name . "' WHERE cfg_name='player_name'";
$this->db->setquery($query);
$this->db->query();
//esport invite
$query = "UPDATE #__bl_config SET cfg_value='" . $esport_invite_player . "' WHERE cfg_name='esport_invite_player'";
$this->db->setquery($query);
$this->db->query();
$query = "UPDATE #__bl_config SET cfg_value='" . $esport_invite_confirm . "' WHERE cfg_name='esport_invite_confirm'";
$this->db->setquery($query);
$this->db->query();
$query = "UPDATE #__bl_config SET cfg_value='" . $esport_invite_unregister . "' WHERE cfg_name='esport_invite_unregister'";
$this->db->setquery($query);
$this->db->query();
$query = "UPDATE #__bl_config SET cfg_value='" . $esport_join_team . "' WHERE cfg_name='esport_join_team'";
$this->db->setquery($query);
$this->db->query();
///admin rights
$query = "UPDATE #__bl_config SET cfg_value='" . $jssa_editplayer . "' WHERE cfg_name='jssa_editplayer'";
$this->db->setquery($query);
$this->db->query();
$query = "UPDATE #__bl_config SET cfg_value='" . $jssa_editplayer_single . "' WHERE cfg_name='jssa_editplayer_single'";
$this->db->setquery($query);
$this->db->query();
$query = "UPDATE #__bl_config SET cfg_value='" . $jssa_deleteplayers . "' WHERE cfg_name='jssa_deleteplayers'";
$this->db->setquery($query);
$this->db->query();
$query = "UPDATE #__bl_config SET cfg_value='" . $jssa_deleteplayers_single . "' WHERE cfg_name='jssa_deleteplayers_single'";
$this->db->setquery($query);
$this->db->query();
//invite to match
$query = "UPDATE #__bl_config SET cfg_value='" . $esport_invite_match . "' WHERE cfg_name='esport_invite_match'";
$this->db->setquery($query);
$this->db->query();
//knock_style
$query = "UPDATE #__bl_config SET cfg_value='" . $knock_style . "' WHERE cfg_name='knock_style'";
$this->db->setquery($query);
$this->db->query();
//social buttons
$query = "UPDATE #__bl_config SET cfg_value='" . $jsb_twitter . "' WHERE cfg_name='jsb_twitter'";
$this->db->setquery($query);
$this->db->query();
$query = "UPDATE #__bl_config SET cfg_value='" . $jsb_gplus . "' WHERE cfg_name='jsb_gplus'";
$this->db->setquery($query);
$this->db->query();
$query = "UPDATE #__bl_config SET cfg_value='" . $jsb_fbshare . "' WHERE cfg_name='jsb_fbshare'";
$this->db->setquery($query);
$this->db->query();
$query = "UPDATE #__bl_config SET cfg_value='" . $jsb_fblike . "' WHERE cfg_name='jsb_fblike'";
$this->db->setquery($query);
$this->db->query();
$query = "UPDATE #__bl_config SET cfg_value='" . $jsbp_season . "' WHERE cfg_name='jsbp_season'";
$this->db->setquery($query);
$this->db->query();
$query = "UPDATE #__bl_config SET cfg_value='" . $jsbp_team . "' WHERE cfg_name='jsbp_team'";
$this->db->setquery($query);
$this->db->query();
$query = "UPDATE #__bl_config SET cfg_value='" . $jsbp_player . "' WHERE cfg_name='jsbp_player'";
$this->db->setquery($query);
$this->db->query();
$query = "UPDATE #__bl_config SET cfg_value='" . $jsbp_match . "' WHERE cfg_name='jsbp_match'";
$this->db->setquery($query);
$this->db->query();
$query = "UPDATE #__bl_config SET cfg_value='" . $jsbp_venue . "' WHERE cfg_name='jsbp_venue'";
$this->db->setquery($query);
$this->db->query();
$query = "UPDATE #__bl_config SET cfg_value='" . $jssa_addexteam . "' WHERE cfg_name='jssa_addexteam'";
$this->db->setquery($query);
$this->db->query();
/*UPDATE*/
$query = "UPDATE #__bl_config SET cfg_value='" . $jssa_addexteam_single . "' WHERE cfg_name='jssa_addexteam_single'";
$this->db->setquery($query);
$this->db->query();
$query = "UPDATE #__bl_config SET cfg_value='" . $player_team_reg . "' WHERE cfg_name='player_team_reg'";
$this->db->setquery($query);
$this->db->query();
//autoreg
$query = "UPDATE #__bl_config SET cfg_value='" . $autoreg_player . "' WHERE cfg_name='autoreg_player'";
$this->db->setquery($query);
$this->db->query();
$query = "UPDATE #__bl_config SET cfg_value='" . $reg_lastname . "' WHERE cfg_name='reg_lastname'";
$this->db->setquery($query);
$this->db->query();
$query = "UPDATE #__bl_config SET cfg_value='" . $reg_lastname_rq . "' WHERE cfg_name='reg_lastname_rq'";
$this->db->setquery($query);
$this->db->query();
$adf_pl = JRequest::getVar('adf_pl', array(0), '', 'array');
JArrayHelper::toInteger($adf_pl, array(0));
if (count($adf_pl)) {
$counter = 0;
foreach ($adf_pl as $map) {
$query = "UPDATE #__bl_extra_filds SET reg_exist='" . (isset($_POST['adfpl_reg_' . $map]) && $_POST['adfpl_reg_' . $map] == 1 ? 1 : 0) . "',reg_require='" . (isset($_POST['adfpl_rq_' . $map]) && $_POST['adfpl_rq_' . $map] == 1 ? 1 : 0) . "' WHERE id=" . $map;
$this->db->setQuery($query);
$this->db->query();
$counter++;
}
}
$adf_pl = JRequest::getVar('adf_tm', array(0), '', 'array');
JArrayHelper::toInteger($adf_pl, array(0));
if (count($adf_pl)) {
$counter = 0;
foreach ($adf_pl as $map) {
$query = "UPDATE #__bl_extra_filds SET reg_exist='" . (isset($_POST['adf_reg_' . $map]) && $_POST['adf_reg_' . $map] == 1 ? 1 : 0) . "',reg_require='" . (isset($_POST['adf_rq_' . $map]) && $_POST['adf_rq_' . $map] == 1 ? 1 : 0) . "' WHERE id=" . $map;
$this->db->setQuery($query);
$this->db->query();
$counter++;
}
}
// Custom fields: team city, etc.
$customFields = JS_Utils::getCustomFields();
$customFields['team_city']['enabled'] = (bool) JRequest::getVar('cf_team_city_enabled', 0, 'post', 'int');
$customFields['team_city']['required'] = (bool) JRequest::getVar('cf_team_city_required', 0, 'post', 'int');
$query = "UPDATE #__bl_config\r\r\n\t SET cfg_value='" . serialize($customFields) . "'\r\r\n WHERE cfg_name='custom_fields'";
$this->db->setquery($query);
$this->db->query();
JS_Utils::invalidateFieldsCache();
}
function regTeamSave()
{
$post = JRequest::get('post');
unset($post["id"]);
$user =& JFactory::getUser();
$row = new JTableTeams($this->db);
$row->created_by = $user->id;
$canmore = false;
$query = "SELECT COUNT(*) FROM #__bl_teams WHERE created_by=" . $user->id;
$this->db->setQuery($query);
$curcap = $this->db->loadResult();
$error = $this->db->getErrorMsg();
if ($error) {
return JError::raiseError(500, $error);
}
$teams_per_account = $this->getJS_Config('teams_per_account');
$query = "SELECT COUNT(*) FROM #__bl_moders WHERE uid=" . $user->id;
$this->db->setQuery($query);
$teamcap = $this->db->loadResult();
if ($curcap < $teams_per_account) {
$canmore = true;
}
if ($teamcap < $teams_per_account) {
$canmore = true;
}
if ($user->get('guest') && !$canmore) {
JError::raiseError(403, JText::_('Access Forbidden'));
return;
}
//$post['captain_id'] = $user->id;
if (!$row->bind($post)) {
JError::raiseError(500, $row->getError());
}
// Validate and store custom field
$customFields = JS_Utils::getCustomFields();
if (!empty($customFields['team_city']['enabled'])) {
if (!empty($post['cf_team_city'])) {
$row->t_city = mysql_real_escape_string($post['cf_team_city']);
} else {
if (!empty($customFields['team_city']['required'])) {
// FIXME: Set a correct error message and redraw form with errors.
$this->set_sess(JText::_('BLBE_REQUIRED'), 'error');
return;
}
}
}
if (!$row->check()) {
JError::raiseError(500, $row->getError());
}
// if new item order last in appropriate group
if (!$row->store()) {
JError::raiseError(500, $row->getError());
}
$row->checkin();
if ($row->id) {
//-------extra fields-----------//
if (isset($_POST['extraf']) && count($_POST['extraf'])) {
foreach ($_POST['extraf'] as $p => $dummy) {
$query = "DELETE FROM #__bl_extra_values WHERE f_id = " . $_POST['extra_id'][$p] . " AND uid = " . $row->id;
$this->db->setQuery($query);
$this->db->query();
$error = $this->db->getErrorMsg();
if ($error) {
return JError::raiseError(500, $error);
}
if ($_POST['extra_ftype'][$p] == '2') {
$query = "INSERT INTO #__bl_extra_values(f_id,uid,fvalue_text) VALUES(" . $_POST['extra_id'][$p] . "," . $row->id . ",'" . addslashes($_POST['extraf'][$p]) . "')";
} else {
$query = "INSERT INTO #__bl_extra_values(f_id,uid,fvalue) VALUES(" . $_POST['extra_id'][$p] . "," . $row->id . ",'" . $_POST['extraf'][$p] . "')";
}
$this->db->setQuery($query);
$this->db->query();
$error = $this->db->getErrorMsg();
if ($error) {
return JError::raiseError(500, $error);
}
}
}
$query = "INSERT INTO #__bl_moders(uid,tid) VALUES({$user->id},{$row->id})";
$this->db->setQuery($query);
$this->db->query();
$error = $this->db->getErrorMsg();
if ($error) {
return JError::raiseError(500, $error);
}
}
}
