From 7a6c422d36beb00e0b6719fec7d3675b37d69af2 Mon Sep 17 00:00:00 2001 From: Arun Persaud Date: Mon, 25 Feb 2013 21:25:57 -0800 Subject: replaced two DB queries with one that is indexed. --- include/user.php | 12 ++++++++---- 1 file changed, 8 insertions(+), 4 deletions(-) (limited to 'include/user.php') diff --git a/include/user.php b/include/user.php index 6169495..546ea8d 100644 --- a/include/user.php +++ b/include/user.php @@ -25,11 +25,15 @@ if(!isset($HOST)) exit; /* test id and password, should really be done in one step */ -if(isset($_SESSION['name'])) +if(isset($_SESSION['id'])) { - $name = $_SESSION['name']; - $email = DB_get_email('name',$name); - $password = DB_get_passwd_by_name($name); + $myid = $_SESSION['id']; + $r = DB_query_array("SELECT email,password FROM User WHERE id=".DB_quote_smart($myid).""); + if($r) + { + $email = $r[0]; + $password = $r[1]; + }; }; global $ADMIN_NAME; -- cgit v1.2.3-18-g5258