Advertisement
jotichand

member form

Aug 31st, 2014
259
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PHP 24.30 KB | None | 0 0
  1. <?php
  2.  
  3. # member
  4.  
  5.  
  6. # variables
  7. $page['L_message']="";
  8. $page['form_action']=convert_url("index.php?r=".$lang['general']['idurl_member']."&v1=form_member");
  9. $nb_error="0";
  10. $page['error']=array();
  11. $page['member']=array();
  12. $details_member="0";
  13.  
  14. # form values
  15. $page['value_id']="";
  16. $page['value_name']="";
  17. $page['value_firstname']="";
  18. $page['value_email']="";
  19. $page['value_date_birth']="";
  20. $page['value_place_birth']="";
  21. $page['value_size']="";
  22. $page['value_weight']="";
  23. $page['value_comment']="";
  24. $page['value_sex']="";
  25. $page['value_country']="";
  26. $page['value_level']="";
  27. $page['value_login']="";
  28. $page['value_description']="";
  29. $page['value_photo']="";
  30. $page['value_avatar']="";
  31. $page['value_status']="";
  32. $page['value_valid']="0";
  33.  
  34.  
  35. if(isset($_GET['id']) AND $_GET['id']!="") { $page['value_id']=$_GET['id']; }
  36. elseif(isset($_POST['id']) AND $_POST['id']!="") { $page['value_id']=$_POST['id']; }
  37.  
  38. # case of add or edit
  39. if(isset($_POST) AND !empty($_POST))
  40. {
  41.  
  42.  if(isset($_POST['name'])) $_POST['name']=format_txt($_POST['name']);
  43.  if(isset($_POST['firstname'])) $_POST['firstname']=format_txt($_POST['firstname']);
  44.  if(isset($_POST['email'])) $_POST['email']=trim($_POST['email']);
  45.  if(isset($_POST['comment'])) $_POST['comment']=format_txt($_POST['comment']);
  46.  if(isset($_POST['description'])) $_POST['description']=format_txt($_POST['description']);
  47.  if(isset($_POST['place_birth'])) $_POST['place_birth']=format_txt($_POST['place_birth']);
  48.  if(isset($_POST['login_member'])) $_POST['login']=$_POST['login_member'];
  49.  if(isset($_POST['size'])) $_POST['size']=$_POST['size'];
  50.  
  51.  
  52.  if(!isset($_POST['name']) OR $_POST['name']=="") { $page['error'][$nb_error]['message']=$lang['member']['E_empty_name']; $nb_error++; }
  53.  if(!isset($_POST['firstname']) OR $_POST['firstname']=="") { $page['error'][$nb_error]['message']=$lang['member']['E_empty_firstname']; $nb_error++; }
  54.  
  55.  if($nb_error==0)
  56.  {
  57.   # we check if it does not already exist
  58.   $sgbd = sql_connect();
  59.    $sql_verif = sql_replace($sql['member']['verif_presence_member'],$_POST);
  60.    $res_verif = sql_query($sql_verif);
  61.    $nb_res = sql_num_rows($res_verif);
  62.    sql_free_result($res_verif);
  63.    sql_close($sgbd);
  64.    if($nb_res!="0") { $page['error'][$nb_error]['message']=$lang['member']['E_exist_member']; $nb_error++; }
  65.  }
  66.  
  67.  # size weight
  68.  if(isset($_POST['size']) AND !empty($_POST['size']) AND !check_integer($_POST['size'])) { $page['error'][$nb_error]['message']=$lang['member']['E_invalid_size']; $nb_error++; }
  69.  
  70.  # email
  71. if(isset($_POST['email']) AND !empty($_POST['email']) AND !check_email($_POST['email'])) { $page['error'][$nb_error]['message']=$lang['member']['E_invalid_email']; $nb_error++; }
  72.  elseif(isset($_POST['email']) AND !empty($_POST['email']))
  73.  {
  74.    $sgbd = sql_connect();
  75.    $sql_verif_email = sql_replace($sql['member']['verif_member_email'],$_POST);
  76.    $res = sql_query($sql_verif_email);
  77.    $nb_res = sql_num_rows($res);
  78.    sql_free_result($res);
  79.    sql_close($sgbd);
  80.    if($nb_res!="0") { $page['error'][$nb_error]['message']=$lang['member']['E_choisi_email']; $nb_error++; }
  81.  }
  82.  
  83.  if(isset($_POST['date_birth']) AND !empty($_POST['date_birth']) AND !check_date($_POST['date_birth'])) { $page['error'][$nb_error]['message']=$lang['member']['E_invalid_date_birth']; $nb_error++; }
  84.  
  85.  
  86.  if(isset($_POST['id']) AND $_POST['id']==1 AND ((!isset($_POST['status']) OR $_POST['status']!="2") OR (!isset($_POST['valid']) OR $_POST['valid']!="1"))) { $page['error'][$nb_error]['message']=$lang['member']['E_modification_member_administrateur']; $nb_error++;
  87.  $_POST['status']=2;
  88.  $_POST['valid']=1; }
  89.  
  90.  if(isset($_POST['id']) AND $_POST['id']==1 AND $_POST['id']!=$_SESSION['session_member_id']) {
  91.   $page['error'][$nb_error]['message']=$lang['member']['E_modification_compte_administrateur']; $nb_error++;
  92.   $details_member="1";
  93.  }
  94.  
  95.  # login
  96. if(isset($_POST['valid']) AND $_POST['valid']!=0 AND (!isset($_POST['login_member']) OR empty($_POST['login_member']))) { $page['error'][$nb_error]['message']=$lang['member']['E_empty_login']; $nb_error++; }
  97.  elseif(isset($_POST['valid']) AND $_POST['valid']!=0 AND !check_login($_POST['login_member'])) { $page['error'][$nb_error]['message']=$lang['member']['E_invalid_login']; $nb_error++; }
  98.  elseif(isset($_POST['login']) AND !empty($_POST['login']))
  99.  {
  100.    $sgbd = sql_connect();
  101.    $sql_verif_login = sql_replace($sql['member']['verif_member_login'],$_POST);
  102.    $res = sql_query($sql_verif_login);
  103.    $nb_res = sql_num_rows($res);
  104.    sql_free_result($res);
  105.    sql_close($sgbd);
  106.    if($nb_res!="0") { $page['error'][$nb_error]['message']=$lang['member']['E_choisi_login']; $nb_error++; }
  107.  }
  108.  
  109.  
  110.  if(isset($_POST['pass_member']) AND !empty($_POST['pass_member'])) {
  111.   if(!isset($_POST['confirm_pass']) OR empty($_POST['confirm_pass'])) { $page['error'][$nb_error]['message']=$lang['member']['E_empty_confirm_pass']; $nb_error++; }
  112.   elseif(!check_login($_POST['pass_member'])) { $form_invalid=1; $page['error'][$nb_error]['message']=$lang['member']['E_invalid_pass']; $nb_error++; }
  113.   elseif($_POST['pass_member']!=$_POST['confirm_pass']) { $form_invalid=1; $page['error'][$nb_error]['message']=$lang['member']['E_pass_different']; $nb_error++; }  
  114.  }
  115.  else
  116.  {
  117.  
  118.  }
  119.  
  120.  
  121.  
  122.  if($nb_error==0)
  123.  {
  124.   $_POST['date_birth']=convert_date_sql($_POST['date_birth']);
  125.   if(!isset($_POST['sex'])) $_POST['sex']="";
  126.   if(!isset($_POST['size']) OR empty($_POST['size'])) $_POST['size']="NULL";
  127.   if(!isset($_POST['weight']) OR empty($_POST['weight'])) $_POST['weight']="NULL";
  128.    
  129.   # case : new item
  130.  if(!isset($_POST['id']) OR empty($_POST['id']))
  131.   {
  132.    $sql_add=sql_replace($sql['member']['insert_member'],$_POST);
  133.    
  134.    $sgbd = sql_connect();
  135.    $execution=sql_query($sql_add);
  136.    if($execution != false) { $page['L_message']=$lang['member']['form_member_add_1']; }
  137.    else { $page['L_message']=$lang['member']['form_member_add_0']; }
  138.    $page['value_id']=sql_insert_id($sgbd);
  139.    sql_close($sgbd);
  140.    
  141.    # member_club
  142.   $values=array();
  143.    if($execution AND isset($_POST['club']) AND !empty($_POST['club']))
  144.    {  
  145.     $tab_club=array_keys($_POST['club']);
  146.     foreach($tab_club as $key => $value)
  147.     {
  148.      $values[]="('".$page['value_id']."','".$_POST['club'][$value]."','".$_POST['season_club'][$value]."')";
  149.     }  
  150.     $var['values']=implode(", ",$values);
  151.     $sql_add=sql_replace($sql['member']['insert_member_club'],$var);
  152.    
  153.     $sgbd = sql_connect();
  154.     sql_query($sql_add);
  155.     sql_close($sgbd);  
  156.    }
  157.    
  158.    
  159.    # member_job
  160.   $values=array();
  161.    if($execution AND isset($_POST['job']) AND !empty($_POST['job']))
  162.    {  
  163.     $tab_job=array_keys($_POST['job']);
  164.     foreach($tab_job as $key => $value)
  165.     {
  166.      $values[]="('".$page['value_id']."','".$_POST['job'][$value]."','".$_POST['season_job'][$value]."')";
  167.     }  
  168.     $var['values']=implode(", ",$values);
  169.     $sql_add=sql_replace($sql['member']['insert_member_job'],$var);
  170.     $sgbd = sql_connect();
  171.     sql_query($sql_add);
  172.     sql_close($sgbd);  
  173.    }  
  174.   }
  175.   # case : item to modify
  176.  else
  177.   {
  178.    $sql_modification=sql_replace($sql['member']['edit_member_admin'],$_POST);  
  179.    $sgbd = sql_connect();
  180.    $execution=sql_query($sql_modification);
  181.    
  182.    if($execution != false) { $page['L_message']=$lang['member']['form_member_edit_1']; }
  183.    else { $page['L_message']=$lang['member']['form_member_edit_0']; }
  184.    sql_close($sgbd);
  185.    
  186.    
  187.    if(isset($_POST['pass_member']) AND !empty($_POST['pass_member'])) {
  188.     $_POST['pass_md5']=md5($_POST['pass_member']);
  189.     $sql_pass=sql_replace($sql['member']['edit_member_pass'],$_POST);
  190.     $sgbd = sql_connect();
  191.     sql_query($sql_pass);  
  192.     sql_close($sgbd);
  193.    }
  194.    
  195.    # member_club et member_job
  196.   if($execution)
  197.    {
  198.    
  199.      $var['member']=$page['value_id'];
  200.      $sql_sup=sql_replace($sql['member']['sup_member_club'],$var);   
  201.      $sgbd = sql_connect();
  202.      sql_query($sql_sup);
  203.      sql_close($sgbd);
  204.      
  205.     $values=array();
  206.    
  207.     if(isset($_POST['club']) AND !empty($_POST['club']) AND is_array($_POST['club']))
  208.     {
  209.      $tab_club=array_keys($_POST['club']);
  210.      foreach($tab_club as $key => $value)
  211.      {
  212.       $values[]="('".$page['value_id']."','".$_POST['club'][$value]."','".$_POST['season_club'][$value]."')";
  213.      }
  214.      $var['values']=implode(", ",$values);
  215.      $sql_add=sql_replace($sql['member']['insert_member_club'],$var);
  216.    
  217.      $sgbd = sql_connect();
  218.      sql_query($sql_add);
  219.      sql_close($sgbd); 
  220.     }
  221.    
  222.    
  223.      $var['member']=$page['value_id'];
  224.      $sql_sup=sql_replace($sql['member']['sup_member_job'],$var);    
  225.      $sgbd = sql_connect();
  226.      sql_query($sql_sup);
  227.      sql_close($sgbd);
  228.      
  229.     $values=array();
  230.    
  231.     if(isset($_POST['job']) AND !empty($_POST['job']))
  232.     {
  233.      $tab_job=array_keys($_POST['job']);
  234.      foreach($tab_job as $key => $value)
  235.      {
  236.      $values[]="('".$page['value_id']."','".$_POST['job'][$value]."','".$_POST['season_job'][$value]."')";
  237.      }   
  238.      $var['values']=implode(", ",$values);
  239.      $sql_add=sql_replace($sql['member']['insert_member_job'],$var);
  240.    
  241.      $sgbd = sql_connect();
  242.      sql_query($sql_add);
  243.      sql_close($sgbd); 
  244.     }  
  245.    }  
  246.   }
  247.  }
  248.  else
  249.  {
  250.  
  251.   if(isset($_POST['id'])) $page['value_id']=$_POST['id'];
  252.   if(isset($_POST['name'])) $page['value_name']=$_POST['name'];
  253.   if(isset($_POST['firstname'])) $page['value_firstname']=$_POST['firstname'];
  254.   if(isset($_POST['email'])) $page['value_email']=$_POST['email'];
  255.   if(isset($_POST['date_birth'])) $page['value_date_birth']=$_POST['date_birth'];
  256.   if(isset($_POST['place_birth'])) $page['value_place_birth']=$_POST['place_birth'];
  257.   if(isset($_POST['size'])) $page['value_size']=$_POST['size'];
  258.   if(isset($_POST['weight'])) $page['value_weight']=$_POST['weight'];
  259.   if(isset($_POST['comment'])) $page['value_comment']=$_POST['comment'];
  260.   if(isset($_POST['sex'])) $page['value_sex']=$_POST['sex'];
  261.   if(isset($_POST['country'])) $page['value_country']=$_POST['country'];
  262.   if(isset($_POST['level'])) $page['value_level']=$_POST['level'];
  263.  
  264.   if(isset($_POST['club'])) $page['club']=$_POST['club'];
  265.   if(isset($_POST['club_text'])) $page['club_text']=$_POST['club_text'];
  266.   if(isset($_POST['date_arrivee'])) $page['date_arrivee']=$_POST['date_arrivee'];
  267.   if(isset($_POST['date_depart'])) $page['date_depart']=$_POST['date_depart'];
  268.  
  269.   if(isset($_POST['job'])) $page['job']=$_POST['job'];
  270.   if(isset($_POST['job_text'])) $page['job_text']=$_POST['job_text'];
  271.   if(isset($_POST['date_start'])) $page['date_start']=$_POST['date_start'];
  272.   if(isset($_POST['date_end'])) $page['date_end']=$_POST['date_end'];
  273.  
  274.   if(isset($_POST['login_member'])) $page['value_login']=$_POST['login_member'];
  275.   if(isset($_POST['description'])) $page['value_description']=$_POST['description'];
  276.   if(isset($_POST['photo'])) $page['value_photo']=$_POST['photo'];
  277.   if(isset($_POST['avatar'])) $page['value_avatar']=$_POST['avatar'];  
  278.   if(isset($_POST['status'])) $page['value_status']=$_POST['status'];
  279.   if(isset($_POST['valid'])) $page['value_valid']=$_POST['valid'];
  280.  }
  281. }
  282.  
  283.  
  284. if(isset($page['value_id']) AND $page['value_id']!="" AND ($nb_error==0 OR $details_member==1))
  285. {
  286.  
  287.  $var['id']=$page['value_id'];
  288.  $sql_details=sql_replace($sql['member']['select_member_details'],$var);
  289.  
  290.  $sgbd = sql_connect();
  291.  $res = sql_query($sql_details);
  292.  $ligne = sql_fetch_array($res);
  293.  sql_free_result($res);
  294.  sql_close($sgbd);
  295.  
  296.  $page['value_id']=$ligne['member_id'];
  297.  $page['value_name']=$ligne['member_lastname'];
  298.  $page['value_firstname']=$ligne['member_firstname'];
  299.  $page['value_email']=$ligne['member_email'];
  300.  $page['value_date_birth']=convert_date($ligne['member_date_birth'],$lang['member']['format_date_form']);
  301.  $page['value_place_birth']=$ligne['member_place_birth'];
  302.  $page['value_size']=$ligne['member_size'];
  303.  $page['value_weight']=$ligne['member_weight'];
  304.  $page['value_comment']=$ligne['member_comment'];
  305.  $page['value_sex']=$ligne['sex_id'];
  306.  $page['value_country']=$ligne['country_id'];
  307.  $page['value_level']=$ligne['level_id'];
  308.  $page['value_login']=$ligne['member_login'];
  309.  $page['value_description']=$ligne['member_description'];
  310.  $page['value_photo']=$ligne['member_photo'];
  311.  $page['value_avatar']=$ligne['member_avatar'];
  312.  $page['value_status']=$ligne['member_status'];
  313.  $page['value_valid']=$ligne['member_valid'];
  314. }
  315.  
  316.  
  317. $page['sex']=array();
  318. $sql_sex=$sql['member']['select_sex'];
  319. $sgbd = sql_connect();
  320. $res_sex = sql_query($sql_sex);
  321. $nb_ligne=sql_num_rows($res_sex);
  322. if($nb_ligne!="0")
  323. {
  324.  $i="0";
  325.  while($ligne = sql_fetch_array($res_sex))
  326.  {
  327.   $page['sex'][$i]['id']=$ligne['sex_id'];
  328.   $page['sex'][$i]['name']=$ligne['sex_name'];
  329.   if(isset($page['value_sex']) AND $page['value_sex']==$ligne['sex_id']) { $page['sex'][$i]['checked']="checked"; } else { $page['sex'][$i]['checked']=""; }
  330.   $i++;
  331.  }
  332. }
  333. sql_free_result($res_sex);
  334. sql_close($sgbd);
  335.  
  336. # country list
  337. $page['country']=array();
  338. $sql_country=$sql['member']['select_country'];
  339. $sgbd = sql_connect();
  340. $res_country = sql_query($sql_country);
  341. $nb_ligne=sql_num_rows($res_country);
  342. if($nb_ligne!="0")
  343. {
  344.  $i="0";
  345.  while($ligne = sql_fetch_array($res_country))
  346.  {
  347.   $page['country'][$i]['id']=$ligne['country_id'];
  348.   $page['country'][$i]['name']=$ligne['country_name'];
  349.   if(isset($page['value_country']) AND $page['value_country']==$ligne['country_id']) { $page['country'][$i]['selected']="selected"; } else { $page['country'][$i]['selected']=""; }
  350.   $i++;
  351.  }
  352. }
  353. sql_free_result($res_country);
  354. sql_close($sgbd);
  355. $page['link_form_country']=convert_url("index.php?r=".$lang['general']['idurl_member']."&v1=country_list&fen=pop",0);
  356. $page['L_add_country']=$lang['member']['add_country'];
  357.  
  358.  
  359. # level list
  360. $page['level']=array();
  361. $sql_level=$sql['member']['select_level'];
  362. $sgbd = sql_connect();
  363. $res_level = sql_query($sql_level);
  364. $nb_ligne=sql_num_rows($res_level);
  365. if($nb_ligne!="0")
  366. {
  367.  $i="0";
  368.  while($ligne = sql_fetch_array($res_level))
  369.  {
  370.   $page['level'][$i]['id']=$ligne['level_id'];
  371.   $page['level'][$i]['name']=$ligne['level_name'];
  372.   if(isset($page['value_level']) AND $page['value_level']==$ligne['level_id']) { $page['level'][$i]['selected']="selected"; } else { $page['level'][$i]['selected']=""; }
  373.   $i++;
  374.  }
  375. }
  376. sql_free_result($res_level);
  377. sql_close($sgbd);
  378.  
  379. # member_club
  380. $page['L_member_club']=$lang['member']['member_club'];
  381. $page['L_club']=$lang['member']['club'];
  382. $page['L_choose_club']=$lang['member']['choose_club'];
  383. $page['L_season']=$lang['member']['season'];
  384. $page['L_choose_season']=$lang['member']['choose_season'];
  385. $page['L_add']=$lang['member']['add'];
  386. $page['L_delete']=$lang['member']['delete'];
  387. $page['L_erreur_club']=$lang['member']['E_empty_member_club'];
  388.  
  389. $page['club_nb']=0;
  390.  
  391. $page['club']=array();
  392. $page['member_club']=array();
  393.  
  394.  
  395.  
  396. $page['club']=array();
  397. $sql_club=$sql['club']['select_club'];
  398. $sgbd = sql_connect();
  399. $res_club = sql_query($sql_club);
  400. $nb_ligne=sql_num_rows($res_club);
  401. if($nb_ligne!="0")
  402. {
  403.  $i="0";
  404.  while($ligne = sql_fetch_array($res_club))
  405.  {
  406.   $page['club'][$i]['id']=$ligne['club_id'];
  407.   $page['club'][$i]['name']=$ligne['club_name'];
  408.   if(isset($_POST['club']) AND $_POST['club']==$ligne['club_id']) { $page['club'][$i]['selected']="selected"; } else { $page['club'][$i]['selected']=""; }
  409.   $i++;
  410.  }
  411. }
  412. sql_free_result($res_club);
  413. sql_close($sgbd);
  414.  
  415.  
  416. $season_club=array();
  417. if($nb_error==0) {
  418. $var['condition']=" WHERE mc.member_id='".$page['value_id']."' ";
  419. $var['order']=" ORDER BY s.season_date_start DESC";
  420. $var['limit']="";
  421. $sql_member_club=sql_replace($sql['member']['select_member_club'],$var);
  422. $sgbd = sql_connect();
  423. $res_member_club = sql_query($sql_member_club);
  424. $nb_ligne=sql_num_rows($res_member_club);
  425. $page['club_nb']=$nb_ligne;
  426. if($nb_ligne!="0")
  427. {
  428.  $i="0";
  429.  while($ligne = sql_fetch_array($res_member_club))
  430.  {
  431.   $page['member_club'][$i]['i']=$i;
  432.   $page['member_club'][$i]['club']=$ligne['club_id'];
  433.   $page['member_club'][$i]['club_text']=$ligne['club_name'];
  434.   $page['member_club'][$i]['season']=$ligne['season_id'];
  435.   $page['member_club'][$i]['season_text']=$ligne['season_name'];
  436.   $page['member_club'][$i]['L_delete']=$lang['member']['delete'];    
  437.   $season_club[$i]=$ligne['season_id'];
  438.   $i++;
  439.  }
  440. }
  441. sql_free_result($res_member_club);
  442. sql_close($sgbd);
  443. }
  444.  
  445.  
  446. if(isset($_POST['club']) AND !empty($_POST['club']) AND is_array($_POST['club']))
  447. {
  448.  $tab=array_keys($_POST['club']);
  449.  $i=0;
  450.  foreach($tab as $key => $value)
  451.  {
  452.   $page['member_club'][$i]['i']=$i;
  453.   $page['member_club'][$i]['club']=$_POST['club'][$value];
  454.   $page['member_club'][$i]['club_text']=$_POST['club_text'][$value];
  455.   $page['member_club'][$i]['season']=$_POST['season_club'][$value];
  456.   $page['member_club'][$i]['season_text']=$_POST['season_club_text'][$value];
  457.   $page['member_club'][$i]['L_delete']=$lang['member']['delete'];    
  458.   $season_club[$i]=$_POST['season_club'][$value];
  459.   $i++;
  460.  }
  461.  $page['club_nb']=$i;
  462. }
  463.  
  464. # member_job
  465. $page['L_member_job']=$lang['member']['member_job'];
  466. $page['L_job']=$lang['member']['job'];
  467. $page['L_choose_job']=$lang['member']['choose_job'];
  468. $page['L_add']=$lang['member']['add'];
  469. $page['L_delete']=$lang['member']['delete'];
  470. $page['L_erreur_job']=$lang['member']['E_empty_member_job'];
  471.  
  472. $page['job_nb']=0;
  473.  
  474. $page['job']=array();
  475. $page['member_job']=array();
  476.  
  477.  
  478.  
  479. $page['job']=array();
  480.  
  481. $sql_job=$sql['member']['select_job'];
  482. $sgbd = sql_connect();
  483. $res_job = sql_query($sql_job);
  484. $nb_ligne=sql_num_rows($res_job);
  485. if($nb_ligne!="0")
  486. {
  487.  $i="0";
  488.  while($ligne = sql_fetch_array($res_job))
  489.  {
  490.   $page['job'][$i]['id']=$ligne['job_id'];
  491.   $page['job'][$i]['name']=$ligne['job_name'];
  492.   if(isset($_POST['job']) AND $_POST['job']==$ligne['job_id']) { $page['job'][$i]['selected']="selected"; } else { $page['job'][$i]['selected']=""; }
  493.   $i++;
  494.  }
  495. }
  496. sql_free_result($res_job);
  497. sql_close($sgbd);
  498.  
  499.  
  500.  
  501. $season_job=array();
  502. if($nb_error==0) {
  503. $var['condition']=" WHERE mf.member_id='".$page['value_id']."' ";
  504. $var['order']=" ORDER BY s.season_date_start DESC";
  505. $var['limit']="";
  506. $sql_member_job=sql_replace($sql['member']['select_member_job'],$var);
  507. $sgbd = sql_connect();
  508. $res_member_job = sql_query($sql_member_job);
  509. $nb_ligne=sql_num_rows($res_member_job);
  510. if($nb_ligne!="0")
  511. {
  512.  $i="0";
  513.  while($ligne = sql_fetch_array($res_member_job))
  514.  {
  515.   $page['member_job'][$i]['i']=$i;
  516.   $page['member_job'][$i]['job']=$ligne['job_id'];
  517.   $page['member_job'][$i]['job_text']=$ligne['job_name'];
  518.   $page['member_job'][$i]['season']=$ligne['season_id'];
  519.   $page['member_job'][$i]['season_text']=$ligne['season_name'];
  520.   $page['member_job'][$i]['L_delete']=$lang['member']['delete'];    
  521.   $season_job[$i]=$ligne['season_id'];
  522.   $i++;
  523.  }
  524. }
  525. sql_free_result($res_member_job);
  526. sql_close($sgbd);
  527. }
  528.  
  529.  
  530. if(isset($_POST['job']) AND !empty($_POST['job']))
  531. {
  532.  $tab=array_keys($_POST['job']);
  533.  $i=0;
  534.  foreach($tab as $key => $value)
  535.  {
  536.   $page['member_job'][$i]['i']=$i;
  537.   $page['member_job'][$i]['job']=$_POST['job'][$value];
  538.   $page['member_job'][$i]['job_text']=$_POST['job_text'][$value];
  539.   $page['member_job'][$i]['season']=$_POST['season_job'][$value];
  540.   $page['member_job'][$i]['season_text']=$_POST['season_job_text'][$value];
  541.   $page['member_job'][$i]['L_delete']=$lang['member']['delete'];    
  542.   $season_job[$i]=$_POST['season_job'][$value];
  543.   $i++;
  544.  }
  545.  $page['job_nb']=$i;
  546. }
  547.  
  548.  
  549. $page['season_club']=array();
  550. $page['season_job']=array();
  551. include_once(create_path("competition/sql_competition.php"));
  552. include_once(create_path("competition/lg_competition_".LANG.".php"));
  553. include_once(create_path("competition/tpl_competition.php"));
  554. $sql_liste=$sql['competition']['select_season'];
  555. $sgbd = sql_connect();
  556. $res_liste = sql_query($sql_liste);
  557. $nb_ligne = sql_num_rows($res_liste);
  558. $i="0";
  559. $j="0";
  560. while($ligne = sql_fetch_array($res_liste))
  561. {
  562.  if(!in_array($ligne['season_id'],$season_club)) {
  563.   $page['season_club'][$i]['i']=$i;
  564.   $page['season_club'][$i]['id']=$ligne['season_id'];
  565.   $page['season_club'][$i]['name']=$ligne['season_name'];
  566.   $page['season_club'][$i]['abbreviation']=$ligne['season_abbreviation'];
  567.   $i++;
  568.  }
  569.  if(!in_array($ligne['season_id'],$season_job)) {
  570.   $page['season_job'][$j]['i']=$j;
  571.   $page['season_job'][$j]['id']=$ligne['season_id'];
  572.   $page['season_job'][$j]['name']=$ligne['season_name'];
  573.   $page['season_job'][$j]['abbreviation']=$ligne['season_abbreviation'];
  574.   $j++;
  575.  }
  576. }
  577.  
  578. # status
  579. $page['status']=array();
  580. $page['status']['0']['id']="0";
  581. $page['status']['0']['name']=$lang['member']['status_0'];
  582. $page['status']['0']['info']=$lang['member']['status_member_info'];
  583. $page['status']['0']['checked']="";
  584. $page['status']['1']['id']="1";
  585. $page['status']['1']['name']=$lang['member']['status_1'];
  586. $page['status']['1']['info']=$lang['member']['status_admin_info'];
  587. $page['status']['1']['checked']="";
  588. $page['status']['2']['id']="2";
  589. $page['status']['2']['name']=$lang['member']['status_2'];
  590. $page['status']['2']['info']=$lang['member']['status_super_admin_info'];
  591. $page['status']['2']['checked']="";
  592. $page['status']['3']['id']="-1";
  593. $page['status']['3']['name']=$lang['member']['status_-1'];
  594. $page['status']['3']['info']=$lang['member']['status_blocked_info'];
  595. $page['status']['3']['checked']="";
  596.  
  597. switch($page['value_status']) {
  598.  case "0" : $page['status']['0']['checked']="checked"; break;
  599.  case "1" : $page['status']['1']['checked']="checked"; break;
  600.  case "2" : $page['status']['2']['checked']="checked"; break;
  601.  case "-1" : $page['status']['3']['checked']="checked"; break;
  602.  default : $page['status']['0']['checked']="checked";
  603. }
  604.  
  605. # valid
  606. $page['valid']=array();
  607. $valid=array('0','1','-1','-2');
  608.  
  609. $nb_valid=sizeof($valid);
  610. for($i=0; $i < $nb_valid; $i++) {
  611.     $id=$valid[$i];
  612.     $page['valid'][$i]['id']=$id;
  613.     $page['valid'][$i]['name']=$lang['member']['valid_'.$id.''];
  614.     $page['valid'][$i]['checked']="";
  615.     if($page['value_valid']==$id) {
  616.         $page['valid'][$i]['checked']='checked="checked"';
  617.     }
  618. }
  619.  
  620.  
  621.  
  622. # links
  623. if(ADMIN==1 AND !empty($page['value_id']))
  624. {
  625. $page['link_delete']=convert_url("index.php?r=".$lang['general']['idurl_member']."&v1=member_list&mode=delete&id=".$page['value_id']);
  626.  
  627. }
  628. else
  629. {
  630.  $page['link_delete']="";
  631. }
  632. $page['link_list']=convert_url("index.php?r=".$lang['general']['idurl_member']."&v1=member_list");
  633. $page['link_choose_image']=convert_url("index.php?r=".$lang['general']['idurl_file']."&v1=image_manager&parent_form=form_member&field_name=photo&file_type=image&fen=pop",1);
  634. $page['link_choose_avatar']=convert_url("index.php?r=".$lang['general']['idurl_file']."&v1=image_manager&parent_form=form_member&field_name=avatar&file_type=image&fen=pop",1);
  635.  
  636.  
  637. # text
  638. if(empty($page['value_id'])) { $page['L_title']=$lang['member']['form_member_add']; }
  639. else { $page['L_title']=$lang['member']['form_member_edit']; }
  640.  
  641. $page['L_valider']=$lang['member']['submit'];
  642. $page['L_delete']=$lang['member']['delete'];
  643. $page['L_back_list']=$lang['member']['back_list'];
  644. $page['L_erreur']=$lang['general']['E_erreur'];
  645. $page['L_field_required']=$lang['general']['field_required'];
  646.  
  647. $page['L_identity']=$lang['member']['identity'];
  648. $page['L_name']=$lang['member']['name'];
  649. $page['L_firstname']=$lang['member']['firstname'];
  650. $page['L_date_birth']=$lang['member']['date_birth'];
  651. $page['L_place_birth']=$lang['member']['place_birth'];
  652. $page['L_email']=$lang['member']['email'];
  653. $page['L_size']=$lang['member']['size'];
  654. $page['L_size_unit']=$lang['member']['size_unit'];
  655. $page['L_weight']=$lang['member']['weight'];
  656. $page['L_weight_unite']=$lang['member']['weight_unite'];
  657. $page['L_sex']=$lang['member']['sex'];
  658. $page['L_country']=$lang['member']['nationality'];
  659. $page['L_choose_country']=$lang['member']['choose_nationality'];
  660. $page['L_referee']=$lang['member']['referee'];
  661. $page['L_level']=$lang['member']['level'];
  662. $page['L_choose_level']=$lang['member']['choose_level'];
  663.  
  664. $page['L_info_internaute']=$lang['member']['info_internaute'];
  665. $page['L_login']=$lang['member']['login'];
  666. $page['L_description']=$lang['member']['description'];
  667. $page['L_photo']=$lang['member']['photo'];
  668. $page['L_avatar']=$lang['member']['avatar'];
  669. $page['L_choose_image']=$lang['member']['choose_image'];
  670. $page['L_pass']=$lang['member']['pass'];
  671. $page['L_explication_pass']=$lang['member']['explication_pass'];
  672. $page['L_confirm_pass']=$lang['member']['confirm_pass'];
  673. $page['L_status']=$lang['member']['status'];
  674. $page['L_choose_status']=$lang['member']['choose_status'];
  675. $page['L_valid']=$lang['member']['valid'];
  676.  
  677. $page['L_comment']=$lang['member']['comment'];
  678. $page['L_format_date']=$lang['member']['format_date'];
  679.  
  680. $page['meta_title']=$page['L_title'];
  681. $page['template']=$tpl['member']['form_member'];
  682. ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement