summaryrefslogtreecommitdiffstats
diff options
context:
space:
mode:
authorRafael Bodill <rafi@sortex.co.il>2014-09-19 17:36:51 +0200
committerRafael Bodill <rafi@sortex.co.il>2014-09-19 17:36:51 +0200
commit8082cc98e7ebc9a27dcf8a8a4e6ee24dc71af1f3 (patch)
tree52b92bc5eea38d9eb17674e6fb2b4244d9501cc0
parent1a007fc8e7bf71fc5e292929af00a15bcac6b2c2 (diff)
where_in for in array queries a proper count usage
-rw-r--r--application/controllers/file.php2
-rw-r--r--application/controllers/user.php6
2 files changed, 4 insertions, 4 deletions
diff --git a/application/controllers/file.php b/application/controllers/file.php
index 96c3fb9c6..ddb7a38cf 100644
--- a/application/controllers/file.php
+++ b/application/controllers/file.php
@@ -541,7 +541,7 @@ class File extends MY_Controller {
->select('id, filename, mimetype, date, hash, filesize')
->from('files')
->where('user', $user)
- ->where('mimetype', array('image/jpeg', 'image/png', 'image/gif'))
+ ->where_in('mimetype', array('image/jpeg', 'image/png', 'image/gif'))
->order_by('date', 'desc')
->get()->result_array();
diff --git a/application/controllers/user.php b/application/controllers/user.php
index a9e50d742..57c6498b1 100644
--- a/application/controllers/user.php
+++ b/application/controllers/user.php
@@ -175,13 +175,13 @@ class User extends MY_Controller {
$userid = $this->muser->get_userid();
- $query = $this->db->select('user')
- ->from('action')
+ $invitations = $this->db->select('user')
+ ->from('actions')
->where('user', $userid)
->where('action', 'invitation')
->count_all_results();
- if ($query["count"] + 1 > 3) {
+ if ($invitations + 1 > 3) {
show_error("You can't create more invitation keys at this time.");
}