summaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorINOPIAE <inopiae@cacert.org>2013-05-01 00:56:03 +0200
committerINOPIAE <inopiae@cacert.org>2013-05-01 00:56:03 +0200
commit27c8a1c6ffafda639754bcd9fda7b462117f7771 (patch)
treee51452aeb993bda789a73f8b7d907ccc3694045c
parenta7e362a25081b2aaf5069f52c79ffec96109e132 (diff)
downloadcacert-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.php6
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;