From 8a4629984964a8be28d4d07ce2496fd77e57e9a4 Mon Sep 17 00:00:00 2001
From: x2000habouzit <x2000habouzit>
Date: Mon, 9 Feb 2004 16:35:49 +0000
Subject: [PATCH] scripts roots

---
 etat_migration                |  4 ++--
 scripts/FormatePrenomNOM.php  | 35 +++++++++++++++++++++++++++++++++++
 scripts/FormatePrenomNOM2.php | 39 +++++++++++++++++++++++++++++++++++++++
 3 files changed, 76 insertions(+), 2 deletions(-)
 create mode 100644 scripts/FormatePrenomNOM.php
 create mode 100644 scripts/FormatePrenomNOM2.php

diff --git a/etat_migration b/etat_migration
index eb54c57..19f7fc2 100644
--- a/etat_migration
+++ b/etat_migration
@@ -16,8 +16,6 @@
 ------+-------------------------------------------+----------------
 Etat  | Ancien nom								  | Nouveau nom
 ------+-[ admin ]---------------------------------+----------------
-	  | admin/FormatePrenomNOM.php				  | scripts/
-	  | admin/FormatePrenomNOM2.php				  | scripts/
 	  | admin/admin_faqs.php					  | 
 	  | admin/admin_trombino.php				  | 
 	  | admin/comptesPOP.php					  | 
@@ -145,6 +143,8 @@ xx	  | acces_smtp.php							  | -
 xx	  | acces_wap.php							  | -
 xx	  | admin/ax-xorg.php						  | -
 xx	  | admin/deces_promo.php					  | -
+xx	  | admin/FormatePrenomNOM2.php				  | scripts/
+xx	  | admin/FormatePrenomNOM.php				  | scripts/
 xx	  | admin/graph_promo.php					  | stats/graph_promo.php
 xx	  | admin/index.php							  | -
 xx	  | admin/postfix_blacklist.php				  | -
diff --git a/scripts/FormatePrenomNOM.php b/scripts/FormatePrenomNOM.php
new file mode 100644
index 0000000..7f88b31
--- /dev/null
+++ b/scripts/FormatePrenomNOM.php
@@ -0,0 +1,35 @@
+<?php echo "L'usage de cette page est réservé à un root"; exit; ?>
+<?php
+require("xorg.common.inc.php");
+
+$result=mysql_query("SELECT user_id,prenom,nom FROM auth_user_md5");
+
+while($myrow = mysql_fetch_array($result)) {
+
+	$prenom = $myrow["prenom"];
+	$old_prenom = $prenom;
+	$nom = $myrow["nom"];
+	$old_nom = $nom;
+	$uid = $myrow["user_id"];
+
+	$pre1=strtok($prenom,"-");
+	$pre2=strtok(" ");
+	$pre1=ucwords(strtolower($pre1));
+	$pre2=ucwords(strtolower($pre2));
+	if ($pre2) {
+		$prenom = $pre1."-".$pre2;
+	} else {
+		$prenom = $pre1;
+	}
+	$nom = strtoupper(strtr($nom,"éèëêàäâïîôöùûüç","eeeeaaaiioouuuc"));
+
+	if ($old_prenom!=$prenom || $old_nom!=$nom) {
+		echo "$old_prenom $old_nom >>>>> $prenom $nom<br>"; 
+		$prenom = addslashes($prenom);
+		$nom = addslashes($nom);
+		//mysql_query("UPDATE auth_user_md5 SET prenom='$prenom',nom='$nom' WHERE user_id=$uid");
+	}
+
+}
+
+?>
diff --git a/scripts/FormatePrenomNOM2.php b/scripts/FormatePrenomNOM2.php
new file mode 100644
index 0000000..5047061
--- /dev/null
+++ b/scripts/FormatePrenomNOM2.php
@@ -0,0 +1,39 @@
+<?php echo "L'usage de cette page est réservé à un root"; exit; ?>
+<?php
+require("xorg.common.inc.php");
+
+$result=mysql_query("SELECT matricule,prenom,nom FROM identification");
+
+while($myrow = mysql_fetch_array($result)) {
+
+	$prenom = rtrim($myrow["prenom"]);
+	$old_prenom = $prenom;
+	$nom = rtrim($myrow["nom"]);
+	$old_nom = $nom;
+	$uid = $myrow["matricule"];
+
+	$pre1=strtok($prenom,"-");
+	$pre2=strtok(" -");
+	$pre3=strtok(" -");
+	$pre1=ucwords(strtolower($pre1));
+	$pre2=ucwords(strtolower($pre2));
+	$pre3=ucwords(strtolower($pre3));
+	if ($pre3) {
+		$prenom = $pre1."-".$pre2."-".$pre3;
+	} else if ($pre2) {
+		$prenom = $pre1."-".$pre2;
+	} else {
+		$prenom = $pre1;
+	}
+	$nom = strtoupper(strtr($nom,"éèëêàäâïîôöùûüç","eeeeaaaiioouuuc"));
+
+	if ($old_prenom != $prenom || $old_nom != $nom) {
+		echo "$old_prenom $old_nom >>>>> $prenom $nom<br>"; 
+		$prenom = addslashes($prenom);
+		$nom = addslashes($nom);
+		//mysql_query("UPDATE identification SET prenom='$prenom',nom='$nom' WHERE matricule='$uid'");
+	}
+
+}
+
+?>
-- 
2.1.4