public function emailcode()
{
$ht = '<a href="http://www.our.com">点击验证</a>';
sendRegMail('*****@*****.**', $ht, 'our');
}
/**
* Inserts the given (username, password) pair
* into the database. Returns true on success,
* false otherwise.
*/
function addNewUser($username, $password, $email)
{
global $db;
$md5pass = md5($password);
// Note that 'pending' defaults to true on INSERT
$sql = 'INSERT INTO user ( username, passwdmd5, email, creation_time )' . " VALUES ('{$username}', '{$md5pass}', '{$email}', now() )";
$affected =& $db->exec($sql);
if (PEAR::isError($affected)) {
die($res->getMessage());
}
if ($affected) {
$sql = "SELECT *\r\n\t\t\t\tFROM user\r\n\t\t\t\tWHERE username = '******'";
$res =& $db->query($sql);
if (PEAR::isError($res)) {
die($res->getMessage());
}
$row = $res->fetchRow();
$new_uid = $row['id'];
// Create a default set for the user
$name = $row['username'] . "\\'s First Set";
$description = "This set was created for you automatically when you registered. Click the edit link to change this description.";
$policy = "private";
$owner_id = $row['id'];
$sql = 'INSERT INTO sets ( name, description, policy, owner_id, creation_time )' . " VALUES ('{$name}', '{$description}', '{$policy}', '{$owner_id}', now() )";
$affected =& $db->exec($sql);
if (PEAR::isError($affected)) {
die($res->getMessage());
}
// Send confirmation email
sendRegMail($new_uid, $username, $email);
return $new_uid;
}
return;
}
