Esempi in PHP per CTableGrUser::get_id_by_email

Esempio n. 1

File: redirection.php Progetto: rakotobe/Rakotobe

$mail = isset($_REQUEST['m'])?$_REQUEST['m']:'';	// Adresse mail
$url = isset($_REQUEST['u'])?$_REQUEST['u']:'';	// Lien dans le mail automatique

if($id > 0) {

	$zQuery = "SELECT id_groupe, type_envoi FROM email WHERE id = " . $id;
	$tzData = mysql_fetch_assoc (mysql_query ($zQuery));
	if ( ($tzData['type_envoi'] == TYPE_ENVOI_GROUPE) || ($tzData['type_envoi'] == TYPE_ENVOI_USER) ) {
		$zColIdUser = '******';
		$zTableUser = '******';
		$user_id = CTableUser::get_id_by_email($mail);
	}
	else {
		$zColIdUser = '******';
		$zTableUser = '******';
		$user_id = CTableGrUser::get_id_by_email($mail);
	}
	
	// Par précaution sur l'existence de l'utilisateur dans la base
	if ( $user_id != '' ){	
	  $zSql2 = "SELECT COUNT(*) AS num FROM retour_email WHERE retour_email_id_email ='".$id."' AND " . $zColIdUser . " ='".$user_id."'";
	  $iNbRowMatch = CBdd::select_one($zSql2,'num');
	
	  if ((int)($iNbRowMatch) > 0) {
	    $zSql3 = "UPDATE retour_email SET retour_email_statut='2', retour_email_lien='1' WHERE retour_email_id_email ='".$id."' AND " . $zColIdUser . " = ". $user_id;
	    $resUpdate = CBdd::update($zSql3);
	  }
	  else {
	    $zSql3 = "INSERT INTO retour_email (retour_email_id_email, " . $zColIdUser . ", retour_email_statut, retour_email_lien) VALUES ('".$id."', '".$user_id."', '2', '1')";
	    $resInsert = CBdd::insert($zSql3);
	  }