Changeset 9 for trunk/include/functions_user.inc.php
- Timestamp:
- May 13, 2003, 12:02:06 PM (21 years ago)
- File:
-
- 1 edited
Legend:
- Unmodified
- Added
- Removed
-
trunk/include/functions_user.inc.php
r2 r9 15 15 * * 16 16 ***************************************************************************/ 17 18 // validate_mail_address verifies whether the given mail address has the 19 // right format. ie someone@domain.com "someone" can contain ".", "-" or 20 // even "_". Exactly as "domain". The extension doesn't have to be 21 // "com". The mail address can also be empty. 22 // If the mail address doesn't correspond, an error message is returned. 17 23 function validate_mail_address( $mail_address ) 18 24 { 19 25 global $lang; 20 26 21 $output = ''; 22 // le mail doit être conforme à qqch du type : nom@serveur.com 23 if ( $mail_address != '' 24 and !ereg( "([_a-z0-9-]+(\.[_a-z0-9-]+)*@[a-z0-9-]+(\.[a-z0-9-]+)+)", 25 $mail_address ) ) 26 { 27 $output = $lang['reg_err_mail_address']; 28 } 29 30 return $output; 31 } 32 33 function register_user( $login, $password, $password_conf, 34 $mail_address, $status = 'visiteur' ) 35 { 36 global $prefixeTable; 27 if ( $mail_address == '' ) 28 { 29 return ''; 30 } 31 $regex = '/^[\w-]+(\.[\w-]+)*@[\w-]+(\.[\w-]+)*\.[a-z]+$/'; 32 if ( !preg_match( $regex, $mail_address ) ) 33 { 34 return $lang['reg_err_mail_address']; 35 } 36 } 37 38 function register_user( 39 $login, $password, $password_conf, $mail_address, $status = 'guest' ) 40 { 41 global $prefixeTable, $lang; 37 42 38 43 $error = array(); 39 44 $i = 0; 40 // l e login ne doit pas41 // 1. être vide42 // 2. commencer ou se terminer par un espace43 // 3. comporter les caractères ' ou "44 // 4. être déjà utilisé45 // login must not 46 // 1. be empty 47 // 2. start ou end with space character 48 // 3. include ' or " characters 49 // 4. be already used 45 50 if ( $login == '' ) 46 51 { … … 63 68 $query = 'select id'; 64 69 $query.= ' from '.$prefixeTable.'users'; 65 $query.= " where pseudo= '".$login."';";70 $query.= " where username = '".$login."';"; 66 71 $result = mysql_query( $query ); 67 72 if ( mysql_num_rows( $result ) > 0 ) … … 70 75 } 71 76 } 72 // on vérifie que le password rentré correspond bien 73 // à la confirmation faite par l'utilisateur 77 // given password must be the same as the confirmation 74 78 if ( $password != $password_conf ) 75 79 { … … 82 86 $error[$i++] = $error_mail_address; 83 87 } 84 85 // on enregistre le nouvel utilisateur si aucune 86 //erreur détectée dans les paramètres 88 89 // if no error until here, registration of the user 87 90 if ( sizeof( $error ) == 0 ) 88 91 { 89 // 1. récupération des valeurs par défaut de l'application92 // 1. retrieving default values, the ones of the user "guest" 90 93 $infos = array( 'nb_image_line', 'nb_line_page', 'theme', 'language', 91 94 'maxwidth', 'maxheight', 'expand', 'show_nb_comments', … … 105 108 } 106 109 $query.= ' from '.$prefixeTable.'users'; 107 $query.= " where pseudo = 'visiteur';";110 $query.= " where username = 'guest';"; 108 111 $row = mysql_fetch_array( mysql_query( $query ) ); 109 // 2. ajout du nouvel utilisateur112 // 2. adding new user 110 113 $query = 'insert into '.$prefixeTable.'users'; 111 114 $query.= ' ('; 112 $query.= ' pseudo,password,mail_address,status';115 $query.= ' username,password,mail_address,status'; 113 116 for ( $i = 0; $i < sizeof( $infos ); $i++ ) 114 117 { 115 118 $query.= ','.$infos[$i]; 116 119 } 117 $query.= ' values (';120 $query.= ') values ('; 118 121 $query.= " '".$login."'"; 119 122 $query.= ",'".md5( $password )."'"; … … 129 132 for ( $i = 0; $i < sizeof( $infos ); $i++ ) 130 133 { 131 $query.= ','.$row[$infos[$i]]; 134 $query.= ','; 135 if ( $row[$infos[$i]] == '' ) 136 { 137 $query.= 'NULL'; 138 } 139 else 140 { 141 $query.= "'".$row[$infos[$i]]."'"; 142 } 132 143 } 133 144 $query.= ');'; 134 145 mysql_query( $query ); 135 // 3. r écupérer l'identifiant de l'utilisateur nouvellement créé146 // 3. retrieving the id of the newly created user 136 147 $query = 'select id'; 137 148 $query.= ' from '.$prefixeTable.'users'; 138 $query.= " where pseudo= '".$login."';";149 $query.= " where username = '".$login."';"; 139 150 $row = mysql_fetch_array( mysql_query( $query ) ); 140 151 $user_id = $row['id']; 141 // 4.ajouter les restrictions au nouvel utilisateur, 142 // les mêmes que celles de l'utilisateur par défaut 152 // 4. adding restrictions to the new user, the same as the user "guest" 143 153 $query = 'select cat_id'; 144 154 $query.= ' from '.$prefixeTable.'restrictions as r'; 145 155 $query.= ','.$prefixeTable.'users as u '; 146 156 $query.= ' where u.id = r.user_id'; 147 $query.= " and u. pseudo = 'visiteur';";157 $query.= " and u.username = 'guest';"; 148 158 $result = mysql_query( $query ); 149 159 while( $row = mysql_fetch_array( $result ) ) … … 191 201 $query.= ' where id = '.$user_id; 192 202 $query.= ';'; 203 echo $query; 193 204 mysql_query( $query ); 194 205 }
Note: See TracChangeset
for help on using the changeset viewer.