/**
* Tells the database system to let go of its data from the previous
* query.
*
* @access public
*
*/
function free()
{
parent::free();
if ($this->result) {
return @pg_free_result($this->result);
}
}
function DoUpdate($table, $db, $field, $vars)
{
$this->db = $db;
$this->table = $table;
$this->vars = $vars;
$this->field = $field;
$q = new Query($this->db);
$q->exec('SHOW COLUMNS FROM ' . $this->table);
$q->inic();
for ($i = 0; $i < $q->numrows; $i++) {
$row = $q->data;
$this->_col[$row['Field']] = $row['Field'];
$q->nxt();
}
$q->free();
}
/**
* Obtiene los usuarios y los <li> del
* submenu de la derecha.
*
* @return array
*/
function get_users()
{
global $db;
global $id_users;
$q = new Query($db);
$q->exec('SELECT users.id_users
, users.username
, users.name
, users.description
FROM users');
$data = array();
$submenu = '';
for ($i = 0; $i < $q->numrows; $i++) {
$data[$q->data['id_users']] = $q->data;
$selected = $id_users == $q->data['id_users'] ? ' class="selected"' : '';
$submenu .= '
<li><a href="?id_users=' . $q->data['id_users'] . '"' . $selected . '>' . $q->data['name'] . '</a></li>';
$q->nxt();
}
$q->free();
return array($data, $submenu);
}
}
} else {
if (isset($_POST['username'])) {
$success = false;
$q = new Query($db);
$q->exec('SELECT users.*
FROM users
WHERE users.username = \'' . $_POST['username'] . '\'
AND users.password = \'' . md5($_POST['password']) . '\'');
if ($q->numrows > 0) {
$success = true;
$_SESSION['login'] = $q->data;
$_SESSION['login']['password'] = '';
// Security
}
$q->free();
if ($success) {
redirect('?rand=' . rand());
}
}
$page_title = 'Login';
$content = isset($success) && !$success ? 'Not Success. Sorry.' : '';
$content .= '
<form name="frm" id="frm" action="" method="post">
<label for="username">Username</label><input type="text" name="username" id="username" value="' . $_POST['username'] . '" /><br />
<label for="password">Password</label><input type="password" name="password" id="password" /><br />
<div align="center"><a href="javascript:send();">login</a></div>
</form>';
}
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.1//EN" "http://www.w3.org/TR/xhtml11/DTD/xhtml11.dtd">
