Subversion Repositories ALCASAR

Compare Revisions

Ignore whitespace Rev 583 → Rev 584

/web/acc/manager/htdocs/import_user.php
152,61 → 152,64
{
$tligne = split(" ",$ligne);
$login = str_replace("%0D","",str_replace("%0A","",urlencode ($tligne[0])));
$password = GenPassword();
$passwd = da_encrypt($password);
$passwd = da_sql_escape_string($passwd);
if ($login != '')
{
$password = GenPassword();
$passwd = da_encrypt($password);
$passwd = da_sql_escape_string($passwd);
/* insertion (login + password) dans la table "radcheck" (si l'usager existe --> changement de mot de passe) */
$res = @da_sql_query($link,$config,"INSERT INTO $config[sql_check_table] (attribute,value,username $text) VALUES ('$config[sql_password_attribute]','$passwd','$login' $passwd_op);");
if (!$res || !@da_sql_affected_rows($link,$res,$config))
{
echo "<b>Unable to add user $login: " . da_sql_error($link,$config) . "</b><br>\n";
$da_abort=1;
}
else
{
creatlog ($login,$password,$service,$RS_out);
/*echo $login." : ".$password." , ";*/
}
/* insertion de l'usager dans la table "userinfo" */
if ($config[sql_use_user_info_table] == 'true' && !$da_abort)
{
$res = @da_sql_query($link,$config, "SELECT username FROM $config[sql_user_info_table] WHERE username = '$login';");
if ($res)
{
if (!@da_sql_num_rows($res,$config))
$res = @da_sql_query($link,$config,"INSERT INTO $config[sql_check_table] (attribute,value,username $text) VALUES ('$config[sql_password_attribute]','$passwd','$login' $passwd_op);");
if (!$res || !@da_sql_affected_rows($link,$res,$config))
{
$res = @da_sql_query($link,$config,"INSERT INTO $config[sql_user_info_table] (username,department) VALUES ('$login','$service');");
if (!$res || !@da_sql_affected_rows($link,$res,$config))
echo "<b>Could not add user information in user info table: " . da_sql_error($link,$config) . "</b><br>\n";
echo "<b>Unable to add user $login: " . da_sql_error($link,$config) . "</b><br>\n";
$da_abort=1;
}
else
echo "<b>User already exists in user info table.</b><br>\n";
}
else
echo "<b>Could not add user information in user info table: " . da_sql_error($link,$config) . "</b><br>\n";
if ($group != '')
{
$group = da_sql_escape_string($group);
$res = @da_sql_query($link,$config,"SELECT username FROM $config[sql_usergroup_table] WHERE username = '$login' AND groupname = '$group';");
if ($res)
creatlog ($login,$password,$service,$RS_out);
/*echo $login." : ".$password." , ";*/
}
/* insertion de l'usager dans la table "userinfo" */
if ($config[sql_use_user_info_table] == 'true' && !$da_abort)
{
$res = @da_sql_query($link,$config, "SELECT username FROM $config[sql_user_info_table] WHERE username = '$login';");
if ($res)
{
if (!@da_sql_num_rows($res,$config))
{
if (!@da_sql_num_rows($res,$config))
$res = @da_sql_query($link,$config,"INSERT INTO $config[sql_user_info_table] (username,department) VALUES ('$login','$service');");
if (!$res || !@da_sql_affected_rows($link,$res,$config))
echo "<b>Could not add user information in user info table: " . da_sql_error($link,$config) . "</b><br>\n";
}
else
echo "<b>User already exists in user info table.</b><br>\n";
}
else
echo "<b>Could not add user information in user info table: " . da_sql_error($link,$config) . "</b><br>\n";
if ($group != '')
{
$group = da_sql_escape_string($group);
$res = @da_sql_query($link,$config,"SELECT username FROM $config[sql_usergroup_table] WHERE username = '$login' AND groupname = '$group';");
if ($res)
{
$res = @da_sql_query($link,$config,"INSERT INTO $config[sql_usergroup_table] (username,groupname) VALUES ('$login','$group');");
if (!$res || !@da_sql_affected_rows($link,$res,$config))
echo "<b>Could not add user to group $group. SQL Error</b><br>\n";
} # end if
if (!@da_sql_num_rows($res,$config))
{
$res = @da_sql_query($link,$config,"INSERT INTO $config[sql_usergroup_table] (username,groupname) VALUES ('$login','$group');");
if (!$res || !@da_sql_affected_rows($link,$res,$config))
echo "<b>Could not add user to group $group. SQL Error</b><br>\n";
} # end if
else
echo "<b>User already is a member of group $group</b><br>\n";
} # end if
else
echo "<b>User already is a member of group $group</b><br>\n";
} # end if
else
echo "<b>Could not add user to group $group: " . da_sql_error($link,$config) . "</b><br>\n";
} # end if ($group)
} # end if ($config)
} # end foreach
echo "<b>Could not add user to group $group: " . da_sql_error($link,$config) . "</b><br>\n";
} # end if ($group)
} # end if ($config)
} # end if ($login !='')
} # end foreach
fclose($RS_out);
}
} # end if (is_file ...
} # end if (is file)
} # end if (link)
}
}
else if ($choix == "bdd")
/web/acc/manager/htdocs/ticket_user.php
2,19 → 2,19
// ticket d'impression (thank's to Geoffroy MUSITELLI)
//--recupération des variables provenant du formulaire
// Etiquettes
$l_login_imp=$_POST["l_login_imp"];
$l_password_imp=$_POST["l_password_imp"];
$l_session_timeout_imp=$_POST["l_session_timeout_imp"];
$l_max_daily_session_imp=$_POST["l_max_daily_session_imp"];
$l_max_monthly_session_imp=$_POST["l_max_monthly_session_imp"];
$l_expiration_imp=$_POST["l_expiration_imp"];
$l_login_imp=utf8_decode($_POST["l_login_imp"]);
$l_password_imp=utf8_decode($_POST["l_password_imp"]);
$l_session_timeout_imp=utf8_decode($_POST["l_session_timeout_imp"]);
$l_max_daily_session_imp=utf8_decode($_POST["l_max_daily_session_imp"]);
$l_max_monthly_session_imp=utf8_decode($_POST["l_max_monthly_session_imp"]);
$l_expiration_imp=utf8_decode($_POST["l_expiration_imp"]);
// Valeurs
$log_imp=$_POST["log_imp"];
$passwd_imp=$_POST["passwd_imp"];
$exp_imp = $_POST["exp_imp"];
$sto_imp = $_POST["sto_imp"];
$mds_imp = $_POST["mds_imp"];
$mms_imp = $_POST["mms_imp"];
$log_imp=utf8_decode($_POST["log_imp"]);
$passwd_imp=utf8_decode($_POST["passwd_imp"]);
$exp_imp=utf8_decode($_POST["exp_imp"]);
$sto_imp=utf8_decode($_POST["sto_imp"]);
$mds_imp=utf8_decode($_POST["mds_imp"]);
$mms_imp=utf8_decode($_POST["mms_imp"]);
 
//--initialisation des classes FPDF
require('../../lib/fpdf16/fpdf.php');
25,7 → 25,7
//Entête
function Header()
{
$l_title_imp=$_POST["l_title_imp"];
$l_title_imp=utf8_decode($_POST["l_title_imp"]);
//Logo coordonnées x , y, largeur de l'image ---Attention fpdf ne supporte pas le png avec fond transparent----
// $this->Image('../../../images/organisme.jpg',25,5,25);
//Police Arial gras 15
/web/acc/manager/htdocs/voucher_new.php
121,8 → 121,11
$mms_imp=sec_imp($mms_imp);
}
/*Formatage de la date afin d'être lisible dans toute les langues 'jj mm yyyy'*/
$Expiration=date("d - m - Y",strtotime($Expiration));
if ($Expiration!=''){
$Expiration=date("d - m - Y",strtotime($Expiration));
} else {
$Expiration=$v_illimit;
}
//Appel du ticket d'impression , passage en paramètres des étiquettes et des valeurs à afficher
echo' <form name="impression" method="post" action="ticket_user.php" target=_blank>
<input type="hidden" name="l_title_imp" value="'.$l_title_imp.'">
/web/acc/manager/htdocs/user_new.php
122,8 → 122,11
$mms_imp=sec_imp($mms_imp);
}
/*Formatage de la date afin d'être lisible dans toute les langues 'jj mm yyyy'*/
$Expiration=date("d - m - Y",strtotime($Expiration));
if ($Expiration!=''){
$Expiration=date("d - m - Y",strtotime($Expiration));
} else {
$Expiration=$v_illimit;
}
//Appel du ticket d'impression , passage en paramètres des étiquettes et des valeurs à afficher
echo' <form name="impression" method="post" action="ticket_user.php" target=_blank>
<input type="hidden" name="l_title_imp" value="'.$l_title_imp.'">