\n\n\n\n\n
Utilisateur : $usernamePage chargée le : ".date("d-m-Y")." à : ".date("H:i:s")."
\n"; # BEGION OF FUNCTION DECLARATION # #open_page() # function open_page($site,$ancre) { # if ($ancre) { # $ancre=$ancre; # } else {$ancre="";} # $the_content="function ouvrirSite(site,ancre) {\n # var contenu=\"\";\n # contenu=\"".$site.$ancre."\";\n # contenu+=ancre;\n # var win_opt= \"toolbar=0,location=0,directories=0,status=0,menubar=0,\";\n # win_opt += \"scrollbars=1,resizable=1,copyhistory=0,\";\n # win_opt += \"width=\" + 600 + \",height=\" + 600;\n # nouvo=window.open(contenu, \"site\",win_opt);\n # }\n"; # return $the_content; # } # exit() function exit_to_welcome() { echo "
\n"; echo "
\n"; echo "\n"; echo "
"; echo "
\n"; } # context_select() function context_select() { mysql_pconnect( "localhost", "dao", "carole") or die( "Unable to connect to SQL server"); mysql_select_db("dao") or die( "Unable to select database"); $context_query = "SELECT * FROM ui_context ORDER BY id"; $context_result = mysql_query($context_query); echo ""; } # context_table() function context_table() { mysql_pconnect( "localhost", "dao", "carole") or die( "Unable to connect to SQL server"); mysql_select_db("dao") or die( "Unable to select database"); $context_query = "SELECT * FROM ui_context ORDER BY id"; $context_result = mysql_query($context_query); echo "\n"; echo "\n\n\n"; for ($c=0;$c\n"; echo "\n"; echo "\n"; echo "\n"; } echo "\n"; echo "
CHOIXCONTEXTEUTILISATEUR
".mysql_result($context_result,$c,'context')."".mysql_num_rows($context_users_result)."
ou
"; } # print_last_edited($context,$username,$edit_ui) function print_last_edited($context,$username,$edit_ui) { $addendum_query=""; if ($edit_ui>0) { $ui_check_query="SELECT * FROM ui_data WHERE context='$context' AND username='$username' AND ui_num='$edit_ui'"; $ui_check_result=mysql_query($ui_check_query); $lastDate=mysql_result($ui_check_result,0,'last_date'); $lastTime=mysql_result($ui_check_result,0,'last_time'); } else { $lastDate="0000-00-00"; $lastTime="00:00:00"; } $lastEdited = "Dernière édition le : ".dateddmmyyyy($lastDate)." à : ".$lastTime." (".day_span_count($lastDate,$lastTime).")"; return $lastEdited; } # dateddmmyyyy($lastDate) function dateddmmyyyy($lastDate) { $dateddmmyyyy_array=explode("-",$lastDate); $dateddmmyyyy=$dateddmmyyyy_array[2]."-"; $dateddmmyyyy=$dateddmmyyyy.$dateddmmyyyy_array[1]."-"; $dateddmmyyyy=$dateddmmyyyy.$dateddmmyyyy_array[0]; return $dateddmmyyyy; } # day_span_count($lastDate,$lastTime) function day_span_count($lastDate,$lastTime) { $a=""; $today=explode("-",date("Y-m-d")); $now=explode(":",date("H:i:s")); $yesterday=explode("-",$lastDate); $before=explode(":",$lastTime); if ($yesterday[0]!="0") { $years=$today[0]-$yesterday[0]; $months=$today[1]-$yesterday[1]; $days=$today[2]-$yesterday[2]; $hours=$now[0]-$before[0]; $minutes=$now[1]-$before[1]; $seconds=$now[2]-$before[2]; $unitsNow=$now[2]+($now[1]*60)+($now[0]*3600)+($today[2]*86400)+($today[1]*2592000)+($today[0]*31536000); $unitsBefore=$before[2]+($before[1]*60)+($before[0]*3600)+($yesterday[2]*86400)+($yesterday[1]*2592000)+($yesterday[0]*31536000); $units=$unitsNow-$unitsBefore; #echo "unitsNow=".$unitsNow; #echo "unitsBefore=".$unitsBefore; #echo "units=".$units; if ($units<60) {$a=$units."sec.";} else { if ($units<3600) {$a=floor($units/60)."min.";} else { if ($units<86400) {$a=floor($units/3600)."h.";} else { if ($units<2592000) {$a=floor($units/86400)." jour";} else { if ($units<31536000) {$a=floor($units/2592000)." mois";} else { $a=floor($units/31536000)." années";} } } } } $span="il y a ".$a; } else { $span="hmmm... en fait jamais"; } return $span; } # AdminGreetings function AdminGreetings($color,$text) { $textColor=""; if ($color==0) { $textColor="green";} else { $textColor="red";} echo "\n

"; echo "
Information de l'administrateur...
"; echo "$text"; echo "
"; echo "

\n"; } # beginAdminGreetings function beginAdminGreetings($color) { $bgColor=""; $msg=""; $adminGif=""; if ($color==0) { $bgColor="green";} else { $bgColor="red"; $msg="!!! ERREUR !!!
"; $adminGif="_bad";} echo "
Information de l'administrateur...
$msg"; } # endAdminGreetings function endAdminGreetings() { echo "

"; } # preConnectionText function preConnectionText() { echo "
\n \n \n \n \n \n \n \n

Inscription comme utilisateur de la grille

\n
Si vous etes déjà utilisateurs du Campus Virtuel TECFA...
\n
Il vous suffit d'entrer votre LOGIN et votre PASSWORD (étape 1 et 2 ci-dessous).
\n
Si vous n'etes ni utilisateurs du Campus Virtuel TECFA ni inscrit à la grille...
\n
Veuillez entrer votre LOGIN (choisissez en un) et un PASSWORD (choisissez en un) ainsi que sa confirmation (étape 1 à 3 ci-dessous). Cette inscription à la grille vous donne droit à l'utilisation de la grille ainsi qu'à un statut d'invité au Campus Virtuel TECFA. Le statut d'invité vous permet de visiter le Campus Virtuel TECFA avec, néanmoins, certaine restriction d'accès.
\n
1. Login
2. Password1
3. Password2 = Password1
\n \n \n \n \n \n \n \n \n \n \n
\n
\n"; echo "
\n \n \n"; echo "\n"; echo "\n \n \n

Connection à la grille

\n
Si vous n'avez pas encore de LOGIN & PASSWORD pour la grille...
\n
Il vous suffit de vous inscrire à la grille selon les directives de la section ci-dessus 'Inscription comme utilisateur de la grille'.
\n"; echo "
Si vous êtes inscrits à la grille...
\n
Il vous suffit de :
  1. choisir votre LOGIN dans le menu déroulant,
  2. entrer votre PASSWORD,
  3. choisir votre contexte de travail.
1. Login (sélectionnez votre login)
2. Password
3. Contexte (choisissez le contexte approprié)\n"; # context selection context_select(); echo " admin
\n
\n
\n"; } # data_check function data_check($userId,$context,$ui_num) { mysql_pconnect( "localhost", "dao", "carole") or die( "Unable to connect to SQL server"); mysql_select_db("dao") or die( "Unable to select database"); $data_check_query="SELECT * FROM ui_data WHERE userId='$userId' AND context='$context' AND ui_num='$ui_num'"; $data_check_result=mysql_query($data_check_query); if (mysql_result($data_check_result,0,'identification')==0) { $theString[]="identification"; } if (mysql_result($data_check_result,0,'structuration')==0) { $theString[]="structuration"; } if (mysql_result($data_check_result,0,'referenciation')==0) { $theString[]="referenciation"; } if (mysql_result($data_check_result,0,'localisation')==0) { $theString[]="localisation"; } if (mysql_result($data_check_result,0,'nature')==0) { $theString[]="nature"; } if (mysql_result($data_check_result,0,'interactivite')==0) { $theString[]="interactivite"; } if (mysql_result($data_check_result,0,'son')==0) { $theString[]="son"; } if (mysql_result($data_check_result,0,'fonction')==0) { $theString[]="fonction"; } if (mysql_result($data_check_result,0,'hyperlien')==0) { $theString[]="hyperlien"; } if (count($theString)==0) {$theReturnedString="";} else {$theReturnedString=(join($theString,", "));} return $theReturnedString; } # END OF FUNCTION DECLARATION ################################################################ ################################################################ ################################################################ # to debug put this value = 1 $debug = 0; if ($debug) { echo "

>*************************
";
  echo "> debug consol = ON
";
  echo ">
";
  echo "> ...tryConnection = ";
  if ($tryConnection) {echo "1";} else {echo "0";}
  echo "
";
  echo "> ...new = ";
  if ($new) {echo "1";} else {echo "0";}
  echo "
";
  echo "> ...username = ";
  if ($username) {echo "$username";} else {echo "NO";}
  echo "
";
  echo "> ...password1 = ";
  if ($password) {echo "$password";} else {echo "NO";}
  echo "
";
  echo "> ...password2 = ";
  if ($password_2) {echo "$password_2";} else {echo "NO";}
  echo "
";
  echo "> ...exit_to_welcome = ";
  if ($exit_to_welcome) {echo "$exit_to_welcome";} else {echo "NO";}
  echo "
";
  echo "> ...access_ok = ";
  if (!strpos($access_ok,"0")) {echo "OK";} else {echo "NO";}
  echo "
";
  echo "> ...context = ";
  if ($context) {echo "$context";} else {echo "NO";}
  echo "
";
  echo ">*************************
"; } ############################ # FIRST CONNECTION ON PAGE # ############################ if ((!isset($tryConnection))&&(!isset($new))||(isset($exit_to_welcome))) { preConnectionText(); } else { # else_1 ################## # TRY CONNECTION # ################## if (isset($tryConnection)){ if (!$username) { #AdminGreetings(1,"Aucun LOGIN n'a été précisé.
Veuillez essayer de vous re-connecter en précisant un LOGIN.
\n"); preConnectionText(); } else { mysql_pconnect( "localhost", "dao", "carole") or die( "Unable to connect to SQL server"); mysql_select_db("infospace") or die( "Unable to select database"); $user_check_query="SELECT * FROM users WHERE username='$username'"; $user_check_result=mysql_query($user_check_query); if (mysql_num_rows($user_check_result)) { if (md5($password)==mysql_result($user_check_result,0,'password')) { # if password mysql_pconnect( "localhost", "dao", "carole") or die( "Unable to connect to SQL server"); mysql_select_db("dao") or die( "Unable to select database"); if ((!$context) && (!$id)) { $context=$alt_context;} # just tried next line for a test #if ($save_new_context) {$context=$alt_context;} if ($context) { $context_access_query="SELECT * FROM ui_context WHERE context='$context'"; } else { $context_access_query="SELECT * FROM ui_context WHERE id='$id'"; } #echo "context=$context\n"; #echo "id=$id\n"; #echo "$context_access_query\n"; $context_access_result=mysql_query($context_access_query); $contexts=mysql_result($context_access_result,0,'context_group'); #$contexts=explode(",",$contexts); if (strstr($contexts,"10")&&(!isset($context_admin))) { #echo "found 10 in $contexts
"; mysql_pconnect( "localhost", "dao", "carole") or die( "Unable to connect to SQL server"); mysql_select_db("infospace") or die( "Unable to select database"); $user_access_query="SELECT * FROM users_groups WHERE userId='".mysql_result($user_check_result,0,'userId')."' AND groupId=10"; $user_access_result=mysql_query($user_access_query); } else { mysql_pconnect( "localhost", "dao", "carole") or die( "Unable to connect to SQL server"); mysql_select_db("infospace") or die( "Unable to select database"); $user_access_query="SELECT * FROM users_groups WHERE userId='".mysql_result($user_check_result,0,'userId')."' AND groupId=3"; $user_access_result=mysql_query($user_access_query); } if (mysql_num_rows($user_access_result)>0) { $ouvrir_site="\n"; mysql_pconnect( "localhost", "dao", "carole") or die( "Unable to connect to SQL server"); mysql_select_db("dao") or die( "Unable to select database"); #AdminGreetings(0,"Vous etes connectés a la grille!!!!!
\n"); $userId = mysql_result($user_check_result,0,'userId'); ################# # CONTEXT_ADMIN # ################# if (isset($context_admin)) { if ($save_edited_context) { mysql_pconnect( "localhost", "dao", "carole") or die( "Unable to connect to SQL server"); mysql_select_db("dao") or die( "Unable to select database"); if ($context_group==10) {$context_group="3,10";} else {$context_group="3";} if (!isset($research)) {$research="0";} if ($max_ui=="") {$max_ui=0;} if ($url=="") {$url="";} if ($context=="") {$context="$username".date("dmyhis");} #echo "($id,'$context','$context_group',$max_ui,'$url','$creator',$research)
"; $context_insert_query = "REPLACE INTO ui_context VALUES ($id,'$context','$context_group',$max_ui,'$url','$creator',$research)"; #$context_insert_query = "REPLACE INTO ui_context VALUES ($id,'$context','$context_group',$max_ui,'$url','$creator')"; $context_insert_result = mysql_query($context_insert_query); if ($context_insert_result) { $msg="contexte mis-à-jour
";} else { echo "la mise-à-jour a échoué !
";} } if ($save_new_context) { mysql_pconnect( "localhost", "dao", "carole") or die( "Unable to connect to SQL server"); mysql_select_db("dao") or die( "Unable to select database"); if ($context_group==10) {$context_group="3,10";} else {$context_group="3";} if (!isset($research)) {$research="0";} if ($max_ui=="") {$max_ui=0;} if ($url=="") {$url="";} if ($context=="") {$context="$username".date("dmyhis");} $context_insert_query = "INSERT INTO ui_context VALUES (NULL,'$context','$context_group',$max_ui,'$url','$creator',$research)"; #$context_insert_query = "INSERT INTO ui_context VALUES (NULL,'$context','$context_group',$max_ui,'$url','$creator')"; $context_insert_result = mysql_query($context_insert_query); if ($context_insert_result) { $save_msg="contexte enregistré";} else { echo "l'enregistrement a échoué !
";} } if ($delete_context) { mysql_pconnect( "localhost", "dao", "carole") or die( "Unable to connect to SQL server"); mysql_select_db("dao") or die( "Unable to select database"); $context_delete_query = "DELETE FROM ui_context WHERE id=$id"; mysql_query($context_delete_query); #if ($context_insert_result) { $save_msg="contexte supprimé";} else { echo "la suppression a échoué !
";} } mysql_pconnect( "localhost", "dao", "carole") or die( "Unable to connect to SQL server"); mysql_select_db("dao") or die( "Unable to select database"); $alt_context_query="SELECT * FROM ui_context"; $alt_context_result=mysql_query($alt_context_query); echo "
\n"; echo "\n"; echo "\n"; echo "\n"; echo "\n"; #echo "\n"; echo "\n"; echo "\n"; echo context_table(); echo "
\n"; ########################################## # ########################################## if ((isset($context_edit) ||isset($context_new)) && !isset($id)) { #if ((isset($context_edit)) && !isset($id)) { unset($context_edit); unset($context_new); } if (isset($context_edit)) { mysql_pconnect( "localhost", "dao", "carole") or die( "Unable to connect to SQL server"); mysql_select_db("dao") or die( "Unable to select database"); $context_query="SELECT * FROM ui_context WHERE id='$id' ORDER BY id"; $context_result=mysql_query($context_query); #$context_id=mysql_result($context_result,0,'id'); $context=mysql_result($context_result,0,'context'); $context_users_query = "SELECT distinct userId FROM ui_data WHERE context='$context'"; $context_users_result = mysql_query($context_users_query); if (mysql_num_rows($context_users_result)!=0) { $context_line="$context (champ inéditable car contexte utilisé)"; } else { $context_line=""; } $context_max_ui=mysql_result($context_result,0,'max_ui'); $context_url=mysql_result($context_result,0,'url'); $context_research=mysql_result($context_result,0,'research'); if ($context_research==1) {$research_checked=" checked";} else {$research_checked="";} $context_creator=mysql_result($context_result,0,'creator'); $context_group=explode(",",mysql_result($context_result,0,'context_group')); if ($context_group[1]) {$checked=" checked";} else {$checked="";} #$submit=" "; $submit="\n"; } if (isset($context_new)) { $context_id=""; $context_line=""; #$context_id=mysql_result($context_result,0,'context_group'); $context_max_ui=""; $context_url=""; $context_research="0"; $research_checked=""; $checked=""; $submit="\n"; } if ($context_edit||$context_new) { echo "
\n"; echo "\n"; echo "
\n"; echo "\n"; echo "\n"; #echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo "
Nom du contexte :$context_line\n
Créateur :$username\n
URL du contexte :\n
Groupe 'poschiavo' :
Nombre d'UI à analyser :\n"; echo " dans un contexte de recherche : OUI"; echo "
$submit
\n"; } # exit admin exit_to_welcome(); } # CONTEXT_ADMIN END else { # else_2 echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo "\n"; ###################################################################################### # SAVE UI DATA # -alors la y'a un bug avec le son... il doit etre coche sinon ca plante!! (supprime le 2/3/99) ###################################################################################### if (isset($save_ui)) { $save_msg=""; if (count($son)==0) {$son_to_insert="";} else {$son_to_insert = join($son,",");} if ($identification==0 && $structuration==0 && $referenciation==0 && $localisation==0 && $nature==0 && $interactivite==0 && (!isset($son)) && $fonction==0 && $hyperlien==0) { $save_msg= "soumission non valide car vide"; } else { #$ui_referencante = 0; if ($child_of=="") {$child_of=0;} if ($ui_referencante=="") {$ui_referencante=0;} mysql_pconnect( "localhost", "dao", "carole") or die( "Unable to connect to SQL server"); mysql_select_db("dao") or die( "Unable to select database"); $last_date=date("Y-m-d"); $last_time=date("H:i:s"); if (isset($edited)) { mysql_pconnect( "localhost", "dao", "carole") or die( "Unable to connect to SQL server"); mysql_select_db("dao") or die( "Unable to select database"); $accessed_query="SELECT * FROM ui_data WHERE context='$context' AND username='$username' AND ui_num='$ui_num'"; $accessed_result=mysql_query($accessed_query); $accessed=mysql_result($accessed_result,0,'accessed'); $accessed++; $ui_insert_query = "REPLACE INTO ui_data VALUES ($id,$userId,'$username','$context',$ui_num,$identification,$structuration,$referenciation,$ui_referencante,$localisation,$nature,$interactivite,'$son_to_insert',$fonction,$hyperlien,'$last_date','$last_time',$accessed,$child_of)"; } else { $accessed=0; $ui_insert_query = "INSERT INTO ui_data VALUES (NULL,$userId,'$username','$context',$ui_num,$identification,$structuration,$referenciation,$ui_referencante,$localisation,$nature,$interactivite,'$son_to_insert',$fonction,$hyperlien,'$last_date','$last_time',$accessed,$child_of)"; } $ui_insert_result = mysql_query($ui_insert_query); if ($ui_insert_result) { $save_msg="valeurs enregistrées";} else { $save_msg="l'enregistrement a échoué !
";} #echo "Vous n'avez pas encore précisé les catégories suivantes :
".data_check($userId,$context,$ui_num)."
\n"; } } mysql_pconnect( "localhost", "dao", "carole") or die( "Unable to connect to SQL server"); mysql_select_db("dao") or die( "Unable to select database"); $context_query = "SELECT * FROM ui_context WHERE context='$context'"; $context_result = mysql_query($context_query); $ui_check_query="SELECT * FROM ui_data WHERE context='$context' AND userId='$userId' ORDER BY ui_num"; $ui_check_result=mysql_query($ui_check_query); #echo $ui_check_query; if ($new_ui) { $curr_ui = $new_ui; } if ($edit_ui) { $curr_ui = $edit_ui; } if ($ui_check_result) { echo ""; $ui_gif=""; ######################### # GIF generation for UI # ######################### $allcomplete=0; $the_max_ui=mysql_result($context_result,0,'max_ui'); $max_ui_display=15; $yorows=1; $yocols=1; for ($j=0;$j<$the_max_ui;$j++) { #if (($j%10)==0) {echo "\n\n";} $UI=$j+1; $ui_state_query="SELECT * FROM ui_data WHERE context='$context' AND userId='$userId' AND ui_num='$UI'"; $ui_state_result=mysql_query($ui_state_query); if ($new_ui) { $curr_ui = $new_ui;} if ($edit_ui) { $curr_ui = $edit_ui;} if (mysql_num_rows($ui_state_result)!=0) {$actif_color=1; $state="edit"; if (data_check($userId,$context,$UI)!="") {$complete=1;} else {$complete=0; $allcomplete++;}} else {$actif_color=0; $state="new"; $complete=0;} if ($UI==$curr_ui) { $actif_color=2;} $ui_gif=$ui_gif.""; if ($yocols==$max_ui_display*$yorows) { $ui_gif=$ui_gif."\n"; $yorows++; } $yocols++; } echo ""; echo ""; echo ""; echo "$ui_gif"; echo ""; echo ""; echo "

"; $ui_gif=$ui_gif."\n"; $ui_gif=$ui_gif."\n"; $ui_gif=$ui_gif."\n"; $ui_gif=$ui_gif."\n"; $ui_gif=$ui_gif."\n"; $ui_gif=$ui_gif."\n"; $ui_gif=$ui_gif."\n"; $ui_gif=$ui_gif.$ouvrir_site; $ui_gif=$ui_gif.""; $ui_gif=$ui_gif."		 
 UI à analyser dans le contexte : $context
N:B. le site s'affiche lorsque vous choisissez une UI pour l'évaluation
( cliquez sur une UI pour l'éditer )
  
"; if ($allcomplete==$the_max_ui) { echo "Toutes les UI sont évaluées (cliquez ICI pour en avertir l'administrateur)"; } else { echo "Vous n'avez pas encore évalué complètement toutes les UI"; } echo "
\n"; $ui_num=mysql_num_rows($ui_check_result)+1; echo "
\n"; echo "$ouvrir_site"; echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo "\n"; } else { echo "\n"; echo "$ouvrir_site"; echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo "Nombre d'Unités d'Informations évaluées : 0 (aucune UI évaluée dans ce contexte pour l'instant)
\n"; $ui_num=1; } if ($new_ui) { # last edited echo ""; #mettre a zero les selected $identification_0 = "selected"; $identification_1 = ""; $identification_2 = ""; $identification_3 = ""; $identification_99 = ""; $structuration_0 = "selected"; $structuration_1 = ""; $structuration_2 = ""; $structuration_3 = ""; $structuration_4 = ""; $structuration_5 = ""; $structuration_99 = ""; $referenciation_0 = "selected"; $referenciation_1 = ""; $referenciation_2 = ""; $referenciation_3 = ""; $referenciation_4 = ""; $referenciation_20 = ""; $referenciation_99 = ""; $localisation_0 = "selected"; $localisation_1 = ""; $localisation_2 = ""; $localisation_20 = ""; $localisation_99 = ""; $nature_0 = "selected"; $nature_1 = ""; $nature_2 = ""; $nature_3 = ""; $nature_4 = ""; $nature_5 = ""; $nature_6 = ""; $nature_7 = ""; $nature_8 = ""; $nature_9 = ""; $nature_99 = ""; $interactivite_0 = "selected"; $interactivite_1 = ""; $interactivite_2 = ""; $interactivite_3 = ""; $interactivite_4 = ""; $interactivite_99 = ""; $son_1 = ""; $son_2 = ""; $son_3 = ""; $son_4 = ""; $fonction_0 = "selected"; $fonction_1 = ""; $fonction_2 = ""; $fonction_3 = ""; $fonction_4 = ""; $fonction_5 = ""; $fonction_6 = ""; $fonction_7 = ""; $fonction_8 = ""; $fonction_9 = ""; $fonction_10 = ""; $fonction_11 = ""; $fonction_12 = ""; $fonction_13= ""; $fonction_99 = ""; $hyperlien_0 = "selected"; $hyperlien_1 = ""; $hyperlien_2 = ""; $hyperlien_3 = ""; $hyperlien_4 = ""; $hyperlien_99 = ""; } if ($edit_ui) { #affecter les bonnes valeurs aux variables $ui_check_query="SELECT * FROM ui_data WHERE context='$context' AND userId='$userId' AND ui_num='$curr_ui'"; $ui_check_result=mysql_query($ui_check_query); # last edited echo "
"; echo print_last_edited($context,$username,0); echo "
"; #echo ""; if (mysql_result($ui_check_result,0,'identification')!=0) { #identification $a = "identification_".mysql_result($ui_check_result,0,'identification'); $$a = "selected"; } if (mysql_result($ui_check_result,0,'structuration')!=0) { #structuration $a = "structuration_".mysql_result($ui_check_result,0,'structuration'); $$a = "selected"; } $yo_child_of=mysql_result($ui_check_result,0,'child_of'); $yo_ui_referencante=mysql_result($ui_check_result,0,'ui_referencante'); if (mysql_result($ui_check_result,0,'referenciation')!=0) { #referenciation $a = "referenciation_".mysql_result($ui_check_result,0,'referenciation'); $$a = "selected"; } if (mysql_result($ui_check_result,0,'localisation')!=0) { #localisation $a = "localisation_".mysql_result($ui_check_result,0,'localisation'); $$a = "selected"; } if (mysql_result($ui_check_result,0,'nature')!=0) { #nature $a = "nature_".mysql_result($ui_check_result,0,'nature'); $$a = "selected"; } if (mysql_result($ui_check_result,0,'interactivite')!=0) { #interactivite $a = "interactivite_".mysql_result($ui_check_result,0,'interactivite'); $$a = "selected"; } if (mysql_result($ui_check_result,0,'son')) { #son $son=mysql_result($ui_check_result,0,'son'); #echo "son=$son"; $theSon=explode(",",$son); for ($i=0;$i

"; echo print_last_edited($context,$username,$edit_ui); echo "
. . . $save_msg
\n";} if ($new_ui || $edit_ui) { #ici vient la grille if (isset($new_ui)) { $ui_num=$new_ui;} if (isset($edit_ui)) { $ui_num=$edit_ui; mysql_pconnect( "localhost", "dao", "carole") or die( "Unable to connect to SQL server"); mysql_select_db("dao") or die( "Unable to select database"); $id_query = "SELECT id FROM ui_data WHERE username='$username' AND context='$context' AND ui_num='$ui_num'"; $id_result = mysql_query($id_query); echo "\n"; } echo "\n"; #echo "\n echo "\n \n"; if (mysql_result($context_result,0,'research')>0) { echo "\n"; } else { echo "\n";} echo "\n"; if (mysql_result($context_result,0,'research')>0) { echo "\n"; } else { echo "\n";} echo "\n \n \n \n \n \n"; echo "
1. Identification [définition]\n\n
2. Structuration [définition]\n\n
2b UI incluse dans l'UI\n
3. Référenciation [définition]\n\n
3b UI référençante\n
4. Localisation [définition]\n\n
5. Nature [définition]\n\n
6. Interactivité & Animation [définition]\n\n
7. Son [définition]\n\n parole et/ou musique et/ou bruitage  sinon...  pas de son
8. Fonction [définition]\n\n
9. Hyperlien [définition]\n\n


\n"; } echo "
\n"; exit_to_welcome(); } # else_2 } else { AdminGreetings(1,"Vous n'avez pas accès à ce contexte \n"); preConnectionText(); } } # end if password else { # if password nogood AdminGreetings(1,"Le password pour l'utilisateur '$username' n'est pas correct. Veuillez essayer de vous re-connecter. Une erreur fréquente est de ne pas avoir respecté les majuscules/minuscules de votre password. Une autre erreur possible est de ne pas préciser le password. Si l'erreur persiste, veuillez contacter l'administrateur de cette page si vous n'arrivez (David Ott). \n"); preConnectionText(); } } else { AdminGreetings(1,"L'utilisateur '$username' n'existe pas!
Veuillez contacter l'administrateur de cette page (David Ott).\n"); preConnectionText(); } } } ############# # NEW USERS # ############# if (isset($new)) { mysql_pconnect( "localhost", "dao", "carole") or die( "Unable to connect to SQL server"); mysql_select_db("infospace") or die( "Unable to select database"); #load table users $userquery= "SELECT * FROM users WHERE username='$username'"; $user = mysql_query($userquery); # check if this user already exists in infospace/users... if (mysql_num_rows($user)) { $id_for_this_user = mysql_result($user,0,'userId'); if (mysql_result($user,0,'password')==md5($password)) { $users_groups_query ="SELECT * FROM users_groups WHERE userId='$id_for_this_user' AND groupId='10'"; $users_groups_result=mysql_query($users_groups_query); if (mysql_num_rows($users_groups_result)) { AdminGreetings(0,"Vous avez déjà l'autorisation d'accès à la grille.
Vous pouvez vous connecter à la grille sans autre.\n"); } else { # insert id into users_groups $groups10_insert_query = "INSERT INTO users_groups VALUES ($id_for_this_user,'10')"; $groups10_insert_result = mysql_query($groups10_insert_query); if($groups10_insert_result) { AdminGreetings(0,"A partir de maintenant vous pouvez vous connecter à la grille.\n"); } else { AdminGreetings(1,"Il y a eu un problème pendant l'enregistrement de l'autorisation d'accès à la grille.
Vous pour l'instant vous n'avez pas encore accès à la grille.
Veuillez contacter l'administrateur de la grille (David Ott).\n"); } } } else { AdminGreetings(1,"Le login '$username' est déjà utilisé par un autre utilisateur. Veuillez modifier votre login et essayer à nouveau.\n"); } } # ...else insert new user... else { if ($username=="") { AdminGreetings(1,"Vous n'avez pas précisé de LOGIN. Veuillez entrer un LOGIN et un PASSWORD.\n"); } else { # test if password == password_2 if (($password==$password_2)&&($password!="")) { # insert new user into infospace/users mysql_pconnect( "localhost", "dao", "carole") or die( "Unable to connect to SQL server"); mysql_select_db("infospace") or die( "Unable to select database"); $user_insert_query = "INSERT INTO users VALUES (NULL,'$username','" . md5($password) . "','$email','$language','$homepage',$zoneLocation,$buildingLocation,$roomLocation,'$last_date','$last_time','$sex','','','',0,0)"; #echo $user_insert_query; $user_insert_result = mysql_query($user_insert_query); $id_for_this_user=mysql_insert_id(); # find id for this user # #$find_user_query = "SELECT userId FROM users WHERE username='$username'"; #$find_user_result = mysql_query($find_user_query); #$id_for_this_user = mysql_result($find_user_result,0,'userId'); # # insert id into users_groups $groups10_insert_query = "INSERT INTO users_groups VALUES ($id_for_this_user,'10')"; $groups10_insert_result = mysql_query($groups10_insert_query); $groups09_insert_query = "INSERT INTO users_groups VALUES ($id_for_this_user,'9')"; $groups09_insert_result = mysql_query($groups09_insert_query); if(($user_insert_result)&&($groups10_insert_result)&&($groups09_insert_result)) { AdminGreetings(0,"L'enregistrement de votre login('$username') & password pour la grille s'est bien passé. A partir de maintenant vous pouvez vous connecter à la grille, maintenant vous trouvez votre login dans le menu déroulant de la fenêtre 'Connection à la grille'). Par ailleurs, vous avez gagné le droit d'accéder au Campus Virtuel TECFA en tant qu'utilisateur 'invité' (utilisez votre pour cela le login et le password d'accès à la grille.\n"); } else { AdminGreetings(1,"Il y a eu un problème pendant l'enregistrement de votre login. Veuillez contacter l'administrateur de cette page (David Ott).\n"); } } # ...if password1 <> password2 y'a un blem! else { AdminGreetings(1,"Le password2 ne correspond pas au password1. Veuillez entrer exactement le même password dans les deux cas.\n"); } } } #endAdminGreetings(); preConnectionText(); } } # else_1 echo "\n"; ?>