1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44
| // return values are as follows
// 0 - registration passed
// 1 - registration failed (user taken)
// 2 - registration failed (email taken)
// anything else - registration failed (unknown reason)
function pRegister($_POST) {
global $db_raid, $pConfig;
// verify they aren't logged in
pLogout();
// check if username exists
$sql['SELECT'] = '*';
$sql['FROM'] = 'profile';
$sql['WHERE'] = 'username = '.$db_raid->quote_smart($_POST['username']);
$db_raid->set_query('select', $sql, __FILE__, __LINE__);
if($db_raid->sql_numrows($result) > 0) {
return 1;
}
// check if email exists
$sql['SELECT'] = '*';
$sql['FROM'] = 'profile';
$sql['WHERE'] = 'user_email = '.$db_raid->quote_smart($_POST['email']);
$db_raid->set_query('select', $sql, __FILE__, __LINE__);
if($db_raid->sql_numrows($result) > 0) {
return 2;
}
$sql['INSERT'] = 'profile';
$sql['VALUES'] = array(
'username'=>$_POST['username'],
'password'=>md5($_POST['password']),
'user_email'=>$_POST['email'],
'group_id'=>$pConfig['default_group'],
'join_date'=>time()
);
$db_raid->set_query('insert', $sql, __FILE__, __LINE__);
return 0;
} |
Partager