| 12 | | |
| 13 | | function addUserWithPassword($email, $name, $password) { |
| 14 | | global $database, $service, $user, $blog; |
| 15 | | if (empty($email)) |
| 16 | | return 1; |
| 17 | | if (!preg_match('/^[^@]+@([-a-zA-Z0-9]+\.)+[-a-zA-Z0-9]+$/', $email)) |
| 18 | | return 2; |
| 19 | | |
| 20 | | if (strcmp($email, UTF8::lessenAsEncoding($email, 64)) != 0) return 11; |
| 21 | | |
| 22 | | $loginid = DBQuery::escapeString(UTF8::lessenAsEncoding($email, 64)); |
| 23 | | $name = DBQuery::escapeString(UTF8::lessenAsEncoding($name, 32)); |
| 24 | | |
| 25 | | $result = DBQuery::queryRow("SELECT * FROM `{$database['prefix']}Users` WHERE loginid = '$loginid'"); |
| 26 | | if (!empty($result)) { |
| 27 | | return 9; // User already exists. |
| 28 | | } |
| 29 | | |
| 30 | | $result = DBQuery::query("INSERT INTO `{$database['prefix']}Users` (userid, loginid, password, name, created, lastLogin, host) VALUES (NULL, '$loginid', '" . md5($password) . "', '$name', UNIX_TIMESTAMP(), 0, 1)"); |
| 31 | | if (empty($result)) { |
| 32 | | return 11; |
| 33 | | } |
| 34 | | return true; |
| 35 | | } |
| 36 | | |