public function addEntry($sender, $param)
{
if ($this->IsValid) {
$name = strtr(trim($this->Name->Text), array("'" => "''"));
$email = strtr(trim($this->Email->Text), array("'" => "''"));
$phone = strtr(trim($this->Phone->Text), array("'" => "''"));
$address = strtr(trim($this->Address->Text), array("'" => "''"));
$memo = strtr($this->Memo->Text, array("'" => "''"));
$db = new TAdodb();
$db->DataSourceName = $this->Application->getUserParameter('DSN');
$db->Execute("INSERT INTO tblEntry (name,email,phone,address,memo) VALUES ('{$name}','{$email}','{$phone}','{$address}','{$memo}')");
$this->Application->transfer('HomePage', array(HomePage::FILTER => $name[0]));
}
}
public function login($name, $password = '')
{
$authenticated = false;
$adodb = new TAdodb();
//$adodb->setDataSourceName($this->Application->getUserParameter('DSN'));
require "config.php";
$adodb->setDataSourceName($dsn);
$adodb->SetFetchMode("Associative");
//Check if there are any admin users
$result = $adodb->Execute("SELECT * FROM users WHERE admin=255");
//Check with config.php password if there are no admin users
if ($result->RecordCount() == 0) {
if ($name == $admin_name && $password == $admin_temp_password) {
$this->setEmail("*****@*****.**");
$this->setId(0);
$this->setAdmin(true);
$this->setGroup(false);
$this->setRepository(false);
$this->setAuthenticated(true);
$this->setConfigAdmin(true);
$result->Close();
return true;
}
}
$result->Close();
//Check for database user
$md5_pw = md5($password);
$s_name = makeSqlString($name);
$result = $adodb->Execute("SELECT * FROM users WHERE name={$s_name} AND password='******'");
//$result=$adodb->Execute("SELECT * FROM users WHERE name='$name' AND password = MD5('$password')");
if ($result->RecordCount() > 0) {
$authenticated = true;
$fields = $result->fields;
$userid = $fields['id'];
$s_userid = makeSqlString($userid);
$email = $fields['email'];
$this->setEmail($email);
$this->setId($userid);
if ($fields['admin'] == 255) {
//Level 255 is superadmin
$this->setAdmin(true);
} else {
$this->setAdmin(false);
}
$groups = $adodb->Execute("SELECT * FROM groups WHERE adminid={$s_userid}");
if ($groups->RecordCount() > 0) {
$this->setGroup(true);
} else {
$this->setGroup(false);
}
$repos = $adodb->Execute("SELECT * FROM repositories WHERE ownerid={$s_userid}");
if ($repos->RecordCount() > 0) {
$this->setRepository(true);
} else {
$repos = $adodb->Execute("SELECT repositorygrants FROM users WHERE id={$s_userid}");
if ($repos->fields['repositorygrants'] > 0) {
$this->setRepository(true);
} else {
$this->setRepository(false);
}
}
}
$result->Close();
$this->setAuthenticated($authenticated);
return $authenticated;
}
