From 81e8cecb7c497b8c7c7b7a4ef9015155c36a7750 Mon Sep 17 00:00:00 2001 From: "Eric Johansson (neku)" Date: Sat, 15 Aug 2015 13:55:42 +0200 Subject: Update core.php --- moe/includes/core.php | 16 ++++++++-------- 1 file changed, 8 insertions(+), 8 deletions(-) diff --git a/moe/includes/core.php b/moe/includes/core.php index b32ae58..57a035e 100644 --- a/moe/includes/core.php +++ b/moe/includes/core.php @@ -105,25 +105,25 @@ function search ($word) { $str = "%".$word."%"; $id = $_SESSION['id']; if($_SESSION['level'] === '1'){ - $do = $db->prepare("SELECT orginalname, filename FROM files WHERE orginalname LIKE (:1) OR filename LIKE (:2)"); + $do = $db->prepare("SELECT originalname, filename FROM files WHERE originalname LIKE (:1) OR filename LIKE (:2)"); $do->bindParam(':1', $str); $do->bindParam(':2', $str); $do->execute(); while ($row = $do->fetch(PDO::FETCH_ASSOC)) { - print strip_tags($row['orginalname']).' - '.''.$row['filename'].' '.' Delete
'; + print strip_tags($row['originalname']).' - '.''.$row['filename'].' '.' Delete
'; } //Yes I love not being efficient, deal with it. }else{ - $do = $db->prepare("SELECT orginalname, filename FROM files WHERE orginalname LIKE (:1) AND user = (:3) OR filename LIKE (:2) AND user = (:3)"); + $do = $db->prepare("SELECT originalname, filename FROM files WHERE originalname LIKE (:1) AND user = (:3) OR filename LIKE (:2) AND user = (:3)"); $do->bindParam(':1', $str); $do->bindParam(':2', $str); $do->bindParam(':3', $id); $do->execute(); while ($row = $do->fetch(PDO::FETCH_ASSOC)) { - print strip_tags($row['orginalname']).' - '.''.$row['filename'].' '.' Delete
'; + print strip_tags($row['originalname']).' - '.''.$row['filename'].' '.' Delete
'; } } } @@ -180,9 +180,9 @@ function delete ($filename, $deleteid, $mod) { case "fetch": if($_SESSION['level'] > '0'){ - $do = $db->prepare("SELECT * FROM files WHERE orginalname LIKE (:keyword) AND date LIKE (:date) OR filename LIKE (:keyword) AND date LIKE (:date) ORDER BY id DESC LIMIT 0,:amount"); + $do = $db->prepare("SELECT * FROM files WHERE originalname LIKE (:keyword) AND date LIKE (:date) OR filename LIKE (:keyword) AND date LIKE (:date) ORDER BY id DESC LIMIT 0,:amount"); }else{ - $do = $db->prepare("SELECT * FROM files WHERE orginalname LIKE (:keyword) AND date LIKE (:date) AND user = (:userid) OR filename LIKE (:keyword) AND date LIKE (:date) AND user = (:userid) ORDER BY id$ + $do = $db->prepare("SELECT * FROM files WHERE originalname LIKE (:keyword) AND date LIKE (:date) AND user = (:userid) OR filename LIKE (:keyword) AND date LIKE (:date) AND user = (:userid) ORDER BY id$ $do->bindValue(':userid', $_SESSION['id']);} $do->bindValue(':date', "%".$date."%"); @@ -210,8 +210,8 @@ function delete ($filename, $deleteid, $mod) { while ($row = $do->fetch(PDO::FETCH_ASSOC)) { $i++; echo ''.$row['id'].' - '.strip_tags($row['orginalname']).' - '.$row['filename'].' ('.$row['orginalname'].') + '.strip_tags($row['originalname']).' + '.$row['filename'].' ('.$row['originalname'].') '.$row['size'].' Remove'; -- cgit v1.2.3