Esempio n. 1
0
 // we format data
 if ($field_list[$j] == 'weather_id' and $id_search = array_search($_POST['data'][$i][$j], $new_weather)) {
     $value_list[$j] = $id_search;
 } elseif ($field_list[$j] == 'field_state_id' and $id_search = array_search($_POST['data'][$i][$j], $new_field_state)) {
     $value_list[$j] = $id_search;
 } elseif ($field_list[$j] == 'field_id' and $id_search = array_search($_POST['data'][$i][$j], $new_field)) {
     $value_list[$j] = $id_search;
 } elseif ($field_list[$j] == 'competition_id' and $id_search = array_search($_POST['data'][$i][$j], $new_competition)) {
     $value_list[$j] = $id_search;
 } elseif ($field_list[$j] == 'club_home_id' and $id_search = array_search($_POST['data'][$i][$j], $new_club)) {
     $value_list[$j] = $id_search;
 } elseif ($field_list[$j] == 'club_visitor_id' and $id_search = array_search($_POST['data'][$i][$j], $new_club)) {
     $value_list[$j] = $id_search;
 }
 if ($field_list[$j] == 'match_date') {
     $value_list[$j] = convert_date_sql($_POST['data'][$i][$j]);
 }
 if ($field_list[$j] == 'club_home_id') {
     $tmp_club_home = explode('_', $_POST['data'][$i][$j]);
     $value_list[$j] = $tmp_club_home[0];
     if (isset($tmp_club_home[1]) and $tmp_club_home[1] != '') {
         $field_list[$nb_column + 1] = 'team_home_id';
         $value_list[$nb_column + 1] = $tmp_club_home[1];
         $field_value_list[$nb_column + 1] = $field_list[$nb_column + 1] . "='" . $value_list[$nb_column + 1] . "'";
     }
 }
 if ($field_list[$j] == 'club_visitor_id') {
     $tmp_club_visitor = explode('_', $_POST['data'][$i][$j]);
     $value_list[$j] = $tmp_club_visitor[0];
     if (isset($tmp_club_visitor[1]) and $tmp_club_visitor[1] != '') {
         $field_list[$nb_column + 2] = 'team_home_id';
Esempio n. 2
0
 # avatar
 if (isset($_POST['avatar']) and !empty($_POST['avatar']) and !check_url($_POST['avatar'])) {
     $page['erreur'][$nb_erreur]['message'] = $lang['member']['E_invalid_avatar'];
     $nb_erreur++;
 }
 # there is no error in submited datas
 if ($nb_erreur == 0) {
     $_POST['status'] = 0;
     // simple member
     $_POST['valid'] = -1;
     // we ask for an activation
     if (isset($_POST['pass_member'])) {
         $_POST['pass_md5'] = md5($_POST['pass_member']);
     }
     if (isset($_POST['date_birth']) and !empty($_POST['date_birth'])) {
         $_POST['date_birth'] = convert_date_sql($_POST['date_birth']);
     }
     if (!isset($_POST['sex'])) {
         $_POST['sex'] = "";
     }
     # we save data
     $sql_add = sql_replace($sql['member']['insert_member_registration'], $_POST);
     $sgbd = sql_connect();
     $execution = sql_query($sql_add);
     if ($execution) {
         $page['L_message'] = $lang['member']['form_registration_add_1'];
         $page['value_id'] = sql_insert_id($sgbd);
         # we send an email
         if (MAIL == 1 and REGISTRATION_MAIL == 1) {
             $var['firstname'] = $_POST['login'];
             $var['site_title'] = SITE_TITLE;
Esempio n. 3
0
     $page['erreur'][$nb_erreur]['message'] = $lang['news']['E_empty_release'];
     $nb_erreur++;
 } elseif (!check_date($_POST['release'])) {
     $page['erreur'][$nb_erreur]['message'] = $lang['news']['E_invalid_release'];
     $nb_erreur++;
 }
 if (isset($_POST['release_time']) and !empty($_POST['release_time']) and !check_hour($_POST['release_time'])) {
     $page['erreur'][$nb_erreur]['message'] = $lang['news']['E_invalid_release_time'];
     $nb_erreur++;
 }
 $_POST['member'] = $_SESSION['session_member_id'];
 if ($nb_erreur == 0) {
     if (empty($_POST['release_time'])) {
         $_POST['release_time'] = '00:00';
     }
     $_POST['release'] = convert_date_sql($_POST['release']);
     $_POST['release'] .= " " . $_POST['release_time'];
     /* cas d'un premier add */
     if (empty($_POST['id']) and $right_user['add_news']) {
         $sgbd = sql_connect();
         $sql_add = sql_replace($sql['news']['insert_news'], $_POST);
         if (sql_query($sql_add) != false) {
             $page['L_message'] = $lang['news']['form_news_add_1'];
         } else {
             $page['L_message'] = $lang['news']['form_news_add_0'];
         }
         $page['value_id'] = sql_insert_id($sgbd);
         sql_close($sgbd);
     } elseif ($right_user['edit_news']) {
         $sql_edit = sql_replace($sql['news']['edit_news'], $_POST);
         $sgbd = sql_connect();
Esempio n. 4
0
    $page['value_day'] = $ligne['match_day'];
    $page['value_field_state'] = $ligne['field_state_id'];
    $page['value_field'] = $ligne['field_id'];
    $page['value_weather'] = $ligne['weather_id'];
    $page['value_date'] = convert_date($ligne['match_date'], $lang['match']['format_date_form']);
    $page['value_hour'] = convert_date($ligne['match_date'], $lang['match']['format_hour_form']);
    if ($page['value_hour'] == "00:00") {
        $page['value_hour'] = "";
    }
    $page['value_score_visitor'] = $ligne['match_score_visitor'];
    $page['value_score_home'] = $ligne['match_score_home'];
    $page['value_spectators'] = $ligne['match_spectators'];
    $page['value_comment'] = $ligne['match_comment'];
}
# On determine la season dans laquelle se joue le match
$var['date'] = convert_date_sql($page['value_date']);
include_once create_path("competition/sql_competition.php");
$sql_season = sql_replace($sql['competition']['select_season_date'], $var);
$sgbd = sql_connect();
$res_season = sql_query($sql_season);
$ligne_season = sql_fetch_array($res_season);
sql_free_result($res_season);
sql_close($sgbd);
$page['value_season'] = $ligne_season['season_id'];
# liste des clubs
include_once create_path("club/sql_club.php");
include_once create_path("club/lg_club_" . LANG . ".php");
include_once create_path("club/tpl_club.php");
$var['condition'] = "";
$var['order'] = "";
$var['limit'] = "";
Esempio n. 5
0
         }
     }
 }
 if (isset($var['value_team']) and !empty($var['value_team'])) {
     $join .= " INNER JOIN " . T_team_player . " AS ej ON ej.member_id=m.member_id ";
     array_push($condition, " ej.team_id = '" . $var['value_team'] . "' ");
 }
 if (isset($var['value_season']) and !empty($var['value_season'])) {
     array_push($condition, " mc.season_id='" . $var['value_season'] . "' ");
 }
 if (isset($var['value_date_start']) and check_date($var['value_date_start'])) {
     $join .= " INNER JOIN " . T_season . " AS s ON s.season_id=mc.season_id ";
     if (isset($var['value_team']) and !empty($var['value_team'])) {
         $join .= " AND s.season_id=ej.season_id ";
     }
     $var['value_date_start'] = convert_date_sql($var['value_date_start']);
     array_push($condition, " (s.season_date_start <='" . $var['value_date_start'] . "' AND s.season_date_end >= '" . $var['value_date_start'] . "') ");
 }
 if (isset($var['value_referee']) and $var['value_referee'] == 1) {
     array_push($condition, " m.level_id!='0' ");
 }
 if (isset($var['value_member']) and !empty($var['value_member'])) {
     array_push($condition, " m.member_id NOT IN (" . $var['value_member'] . ") ");
 }
 if (isset($var['value_member_in']) and !empty($var['value_member_in'])) {
     array_push($condition, " m.member_id IN (" . $var['value_member_in'] . ") ");
 }
 if (isset($var['value_group']) and !empty($var['value_group'])) {
     array_push($condition, " m.member_status='" . $var['value_group'] . "' ");
 }
 if (isset($var['value_name']) and !empty($var['value_name'])) {
Esempio n. 6
0
 }
 if (!isset($_POST['date_end']) or empty($_POST['date_end'])) {
     $page['erreur'][$nb_erreur]['message'] = $lang['competition']['E_empty_date_end'];
     $nb_erreur++;
 } elseif (!check_date($_POST['date_end'])) {
     $page['erreur'][$nb_erreur]['message'] = $lang['competition']['E_invalid_date_end'];
     $nb_erreur++;
 }
 if (isset($_POST['date_start']) and isset($_POST['date_end']) and !empty($_POST['date_start']) and !empty($_POST['date_end']) and convert_date_sql($_POST['date_start']) > convert_date_sql($_POST['date_end'])) {
     $page['erreur'][$nb_erreur]['message'] = $lang['competition']['E_invalid_dates'];
     $nb_erreur++;
 }
 # there is no error in submited datas
 if ($nb_erreur == 0) {
     $_POST['date_start'] = convert_date_sql($_POST['date_start']);
     $_POST['date_end'] = convert_date_sql($_POST['date_end']);
     # case : new item to add
     if (!isset($_POST['id']) or empty($_POST['id'])) {
         $sql_add = sql_replace($sql['competition']['insert_season'], $_POST);
         $sgbd = sql_connect();
         if (sql_query($sql_add) != false) {
             $page['L_message'] = $lang['competition']['form_season_add_1'];
         } else {
             $page['L_message'] = $lang['competition']['form_season_add_0'];
         }
         sql_close($sgbd);
     } else {
         $sql_modification = sql_replace($sql['competition']['edit_season'], $_POST);
         $sgbd = sql_connect();
         if (sql_query($sql_modification) != false) {
             $page['L_message'] = $lang['competition']['form_season_edit_1'];