diff options
| author | Florian Pritz <bluewind@xinu.at> | 2015-09-20 16:03:22 +0200 |
|---|---|---|
| committer | Florian Pritz <bluewind@xinu.at> | 2015-09-20 16:03:22 +0200 |
| commit | 7da9de48d2b3bbb0309d6311e4dc7d275d3bf26d (patch) | |
| tree | bc90956bccaad107255e350ed29cad242eede5cc /application/models | |
| parent | f149a0d1abb4a79b1d5de9ddb5963b2eab4b126d (diff) | |
| parent | e79c1c45dcd23dde1f4b072993829cc008f4858b (diff) | |
Merge branch 'postgres' into dev
Diffstat (limited to 'application/models')
| -rw-r--r-- | application/models/mmultipaste.php | 12 |
1 files changed, 6 insertions, 6 deletions
diff --git a/application/models/mmultipaste.php b/application/models/mmultipaste.php index f80105ec9..0185e8c7f 100644 --- a/application/models/mmultipaste.php +++ b/application/models/mmultipaste.php @@ -65,7 +65,7 @@ class Mmultipaste extends CI_Model { $sql = ' SELECT url_id - FROM `'.$this->db->dbprefix.'multipaste` + FROM '.$this->db->dbprefix.'multipaste WHERE url_id = ? LIMIT 1'; $query = $this->db->query($sql, array($id)); @@ -124,7 +124,7 @@ class Mmultipaste extends CI_Model { { return $this->db->query(" SELECT user_id - FROM `".$this->db->dbprefix."multipaste` + FROM ".$this->db->dbprefix."multipaste WHERE url_id = ? ", array($id))->row_array()["user_id"]; } @@ -133,7 +133,7 @@ class Mmultipaste extends CI_Model { { return $this->db->query(" SELECT url_id, user_id, date - FROM `".$this->db->dbprefix."multipaste` + FROM ".$this->db->dbprefix."multipaste WHERE url_id = ? ", array($id))->row_array(); } @@ -144,8 +144,8 @@ class Mmultipaste extends CI_Model { $query = $this->db->query(" SELECT mfm.file_url_id - FROM `".$this->db->dbprefix."multipaste_file_map` mfm - JOIN `".$this->db->dbprefix."multipaste` m ON m.multipaste_id = mfm.multipaste_id + FROM ".$this->db->dbprefix."multipaste_file_map mfm + JOIN ".$this->db->dbprefix."multipaste m ON m.multipaste_id = mfm.multipaste_id WHERE m.url_id = ? ORDER BY mfm.sort_order ", array($url_id))->result_array(); @@ -162,7 +162,7 @@ class Mmultipaste extends CI_Model { { $query = $this->db->query(" SELECT multipaste_id - FROM `".$this->db->dbprefix."multipaste` + FROM ".$this->db->dbprefix."multipaste WHERE url_id = ? ", array($url_id)); |