summaryrefslogtreecommitdiffstats
path: root/application/models/mmultipaste.php
diff options
context:
space:
mode:
authorFlorian Pritz <bluewind@xinu.at>2015-02-06 12:40:28 +0100
committerFlorian Pritz <bluewind@xinu.at>2015-02-06 12:40:37 +0100
commit67ed287e97daa9965521c9d133714bde72145711 (patch)
tree183e75e54c830eab651ce386c3854eb60c667452 /application/models/mmultipaste.php
parent03e9a7abbf2851f3f8ac4c9a1d0bc072f4a9e103 (diff)
fixup! Support database table prefixes
Signed-off-by: Florian Pritz <bluewind@xinu.at>
Diffstat (limited to 'application/models/mmultipaste.php')
-rw-r--r--application/models/mmultipaste.php16
1 files changed, 8 insertions, 8 deletions
diff --git a/application/models/mmultipaste.php b/application/models/mmultipaste.php
index 9be4dc416..ed3b8e3a7 100644
--- a/application/models/mmultipaste.php
+++ b/application/models/mmultipaste.php
@@ -64,9 +64,9 @@ class Mmultipaste extends CI_Model {
}
$sql = '
- SELECT multipaste.url_id
- FROM '.$this->db->dbprefix.'multipaste
- WHERE multipaste.url_id = ?
+ SELECT url_id
+ FROM `'.$this->db->dbprefix.'multipaste`
+ WHERE url_id = ?
LIMIT 1';
$query = $this->db->query($sql, array($id));
@@ -113,7 +113,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"];
}
@@ -122,7 +122,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();
}
@@ -133,8 +133,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();
@@ -151,7 +151,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));