From 9a3ad8883403949a59e8935497a548ec536f1d40 Mon Sep 17 00:00:00 2001
From: Igor Scheller <igor.scheller@igorshp.de>
Date: Sat, 21 Jan 2017 13:58:53 +0100
Subject: Changed from mysqli to PDO, some refactorings, faster sql queries

---
 includes/model/LogEntries_model.php | 43 ++++++++++++++++++++-----------------
 1 file changed, 23 insertions(+), 20 deletions(-)

(limited to 'includes/model/LogEntries_model.php')

diff --git a/includes/model/LogEntries_model.php b/includes/model/LogEntries_model.php
index 920b1945..0e11bf8e 100644
--- a/includes/model/LogEntries_model.php
+++ b/includes/model/LogEntries_model.php
@@ -1,59 +1,62 @@
 <?php
 
+use Engelsystem\Database\DB;
+
 /**
  * Creates a log entry.
  *
  * @param string $nick    Username
  * @param string $message Log  Message
- * @return mysqli_result|false
+ * @return bool
  */
 function LogEntry_create($nick, $message)
 {
-    return sql_query("
-        INSERT INTO `LogEntries`
-        SET
-            `timestamp`='" . sql_escape(time()) . "',
-            `nick`='" . sql_escape($nick) . "',
-            `message`='" . sql_escape($message) . "'
-    ");
+    return DB::insert('
+        INSERT INTO `LogEntries` (`timestamp`, `nick`, `message`)
+        VALUES(?, ?, ?)
+    ', [time(), $nick, $message]);
 }
 
 /**
  * Returns log entries with maximum count of 10000.
  *
- * @return array|false
+ * @return array
  */
 function LogEntries()
 {
-    return sql_select('SELECT * FROM `LogEntries` ORDER BY `timestamp` DESC LIMIT 10000');
+    return DB::select('SELECT * FROM `LogEntries` ORDER BY `timestamp` DESC LIMIT 10000');
 }
 
 /**
  * Returns log entries filtered by a keyword
  *
  * @param string $keyword
- * @return array|false
+ * @return array
  */
 function LogEntries_filter($keyword)
 {
     if ($keyword == '') {
         return LogEntries();
     }
-    return sql_select("
-        SELECT *
-        FROM `LogEntries`
-        WHERE `nick` LIKE '%" . sql_escape($keyword) . "%'
-        OR `message` LIKE '%" . sql_escape($keyword) . "%'
-        ORDER BY `timestamp` DESC
-    ");
+
+    $keyword = '%' . $keyword . '%';
+    return DB::select('
+            SELECT *
+            FROM `LogEntries`
+            WHERE `nick` LIKE ?
+            OR `message` LIKE ?
+            ORDER BY `timestamp` DESC
+        ',
+        [$keyword, $keyword]
+    );
 }
 
 /**
  * Delete all log entries.
  *
- * @return mysqli_result|false
+ * @return bool
  */
 function LogEntries_clear_all()
 {
-    return sql_query('TRUNCATE `LogEntries`');
+    return DB::statement('TRUNCATE `LogEntries`');
 }
-- 
cgit v1.2.3-70-g09d2