From 198ab37015dbe1f999f149dbd887dcb814202585 Mon Sep 17 00:00:00 2001
From: arun <arun@nubati.net>
Date: Wed, 13 Dec 2006 18:32:33 +0000
Subject: added two new features: local time and a link to the user page

---
 db.php | 21 +++++++++++++++++++++
 1 file changed, 21 insertions(+)

(limited to 'db.php')

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));
-- 
cgit v1.2.3-18-g5258