DROP TABLE IF EXISTS book_auth;
CREATE TABLE book_auth (
ID smallint(5) NOT NULL auto_increment,
username varchar(60) NOT NULL default '',
password varchar(60) NOT NULL default '',
session varchar(32) NOT NULL default '',
last_visit int(11) NOT NULL default '0',
PRIMARY KEY (ID)
) TYPE=MyISAM;

INSERT INTO book_auth (ID, username, password, session, last_visit) VALUES (1, 'test', '773359240eb9a1d9', 'cd2c6d5e457641991d52da8fb6d87c08', 1013100791);

it is misleading in that the 'timestamp' field type in mysql holds a datetime value that updates itself unless you explicitly set it

<?php
/**
* ----------------------------------------------
* Advanced Guestbook 2.2 (PHP/MySQL)
* Copyright (c)2001 Chi Kien Uong
* URL: http://www.proxy2.de
* ----------------------------------------------
*/

class gb_session extends gbook_sql {

var $expire = 7200;
var $include_path;
var $table;

function gb_session($path='') {
global $GB_TBL;
$this->table =& $GB_TBL;
$this->gbook_sql();
$this->connect();
$this->include_path = $path;
}

function isValidSession($session,$user_id) {
$this->query("SELECT session, LAST_VISIT from ".$this->table['auth']." WHERE session='$session' and ID='$user_id'");
$row = $this->fetch_array($this->result);
if ($row) {
$year = substr($row["LAST_VISIT"],0,4);
$date = substr($row["LAST_VISIT"],4,10);
$date_strg = chunk_split($date,2,"-");
list($month,$day,$hour,$minute,$second) = explode("-",$date_strg);
$tstamp = mktime($hour,$minute,$second,$month,$day,$year);
return ($this->expire + $tstamp > time()) ? $row["session"] : false;
} else {
return false;
}
}

function isValidUser($user_id) {
$this->query("SELECT username FROM ".$this->table['auth']." WHERE ID='$user_id'");
$this->fetch_array($this->result);
return ($this->record) ? true : false;
}

function changePass($user_id,$new_password) {
$this->query("UPDATE ".$this->table['auth']." SET password=PASSWORD('$new_password') WHERE ID='$user_id'");
return ($this->record) ? true : false;
}

function generateNewSessionID($user_id) {
srand((double)microtime()*1000000);
$session = md5 (uniqid (rand()));
$this->query("UPDATE ".$this->table['auth']." SET session='$session' WHERE ID='$user_id'");
return $session;
}

function checkPass($username,$password) {
$this->query("SELECT ID FROM ".$this->table['auth']." WHERE username='$username' and password=PASSWORD('$password')");
$this->fetch_array($this->result);
return ($this->record) ? $this->record["ID"] : false;
}

function checkSessionID() {
global $username, $password, $session, $uid;
if (isset($session) && isset($uid)) {
return ($this->isValidSession($session,$uid)) ? array("session" => "$session", "uid" => "$uid") : false;
} elseif (isset($username) && isset($password)) {
if (get_magic_quotes_gpc()) {
$username = stripslashes($username);
$password = stripslashes($password);
}
$ID = $this->checkPass($username,$password);
if ($ID) {
$session = $this->generateNewSessionID($ID);
return array("session" => "$session", "uid" => "$ID");
} else {
return false;
}

} else {
return false;
}

}

}

?>

Jam'n wrote:Try reseting the password

You will need PHPadmin for this.

[Method 1]
Select the Guestbook database.
Select book_auth.
Now choose Browse.
You now see the admin username and password.
Select edit.
Now paste Code:

773359240eb9a1d9


in the password field and click “GO”.

This will reset your account to:

Your admin name and the password will be: 123


Or do it like this.


[Method 2]
Select the Guestbook database
Now choose on the right side of screen select SQL
Now insert in the Data Entry Field the following lines:

delete from book_auth; INSERT INTO book_auth VALUES (1, 'test', '773359240eb9a1d9', '7d8b85294e2e060b83f596a4fc5561ce', 1058460506);



And click "GO"

This will reset your account to:

User name: test
Password: 123