From 198ab37015dbe1f999f149dbd887dcb814202585 Mon Sep 17 00:00:00 2001 From: arun Date: Wed, 13 Dec 2006 18:32:33 +0000 Subject: [PATCH] added two new features: local time and a link to the user page --- css/standard.css | 6 ++++++ db.php | 21 +++++++++++++++++++++ functions.php | 2 +- index.php | 41 ++++++++++++++++++++++++++++++++++++----- 4 files changed, 64 insertions(+), 6 deletions(-) diff --git a/css/standard.css b/css/standard.css index 4e6650a..0289303 100644 --- a/css/standard.css +++ b/css/standard.css @@ -198,6 +198,12 @@ ul.oldtrick li div div.card3 span span{ border-top:0; } +.time,.over { + float:right; + border:2px solid black; + clear:right; + } + .bug { float:left; width:10em; diff --git a/db.php b/db.php index f893748..4b18d9c 100644 --- a/db.php +++ b/db.php @@ -100,6 +100,16 @@ function DB_get_userid_by_email($email) else return 0; } +function DB_get_userid_by_email_and_password($email,$password) +{ + $result = mysql_query("SELECT id FROM User WHERE email=".DB_quote_smart($email)." AND password=".DB_quote_smart($password)); + $r = mysql_fetch_array($result,MYSQL_NUM); + + if($r) + return $r[0]; + else + return 0; +} function DB_get_handid_by_hash($hash) { @@ -145,6 +155,17 @@ function DB_get_name_by_hash($hash) return ""; } +function DB_get_name_by_userid($id) +{ + $result = mysql_query("SELECT fullname FROM User WHERE id=".DB_quote_smart($id)); + $r = mysql_fetch_array($result,MYSQL_NUM); + + if($r) + return $r[0]; + else + return ""; +} + function DB_get_status_by_hash($hash) { $result = mysql_query("SELECT status FROM Hand WHERE hash=".DB_quote_smart($hash)); diff --git a/functions.php b/functions.php index 390f6c9..6bd50af 100644 --- a/functions.php +++ b/functions.php @@ -404,7 +404,7 @@ function display_news() global $wiki; echo "
". "Please hit shift+reload.
". - "Fixed a few bugs, comments might be working again
". + "added local time display, let me know what you think
". "If you find more bugs, please list them in the wiki.
\n"; return; diff --git a/index.php b/index.php index a3b0891..40920de 100644 --- a/index.php +++ b/index.php @@ -5,7 +5,7 @@ e-Doko - +