diff options
| author | INOPIAE <inopiae@cacert.org> | 2013-05-01 00:56:03 +0200 |
|---|---|---|
| committer | INOPIAE <inopiae@cacert.org> | 2013-05-01 00:56:03 +0200 |
| commit | 27c8a1c6ffafda639754bcd9fda7b462117f7771 (patch) | |
| tree | e51452aeb993bda789a73f8b7d907ccc3694045c | |
| parent | a7e362a25081b2aaf5069f52c79ffec96109e132 (diff) | |
| download | cacert-devel-27c8a1c6ffafda639754bcd9fda7b462117f7771.tar.gz cacert-devel-27c8a1c6ffafda639754bcd9fda7b462117f7771.tar.xz cacert-devel-27c8a1c6ffafda639754bcd9fda7b462117f7771.zip | |
bug 893: replaced some * by 1 in select statments
| -rw-r--r-- | includes/temp_functions.php | 6 |
1 files changed, 3 insertions, 3 deletions
diff --git a/includes/temp_functions.php b/includes/temp_functions.php index 23a9acd..86b55c2 100644 --- a/includes/temp_functions.php +++ b/includes/temp_functions.php @@ -160,7 +160,7 @@ function check_email_exists($email){ // called from includes/account.php if($process != "" && $oldid == 1) // called from includes/account.php if($oldid == 50 && $process != "") $email = mysql_real_escape_string($email); - $query = "select * from `email` where `email`='$email' and `deleted`=0"; + $query = "select 1 from `email` where `email`='$email' and `deleted`=0"; $res = mysql_query($query); return mysql_num_rows($res) > 0; } @@ -170,9 +170,9 @@ function check_gpg_cert_running($uid,$cca=0){ // called from includes/account.php if($oldid == 50 && $process != "") $uid = intval($uid); if (0==$cca) { - $query = "select * from `gpg` where `memid`='$uid' and `expire`>NOW()"; + $query = "select 1 from `gpg` where `memid`='$uid' and `expire`>NOW()"; }else{ - $query = "select * from `gpg` where `memid`='$uid' and `expire`>(NOW()-90*86400)"; + $query = "select 1 from `gpg` where `memid`='$uid' and `expire`>(NOW()-90*86400)"; } $res = mysql_query($query); return mysql_num_rows($res) > 0; |