Information de l'administrateur... $msg";
}
# endAdminGreetings
function endAdminGreetings() {
echo "
";
}
# preConnectionText
function preConnectionText() {
echo "\n";
echo "\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 "
";
}
############################
# 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";
##########################################
#
##########################################
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";}
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";
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";
?>