1 files changed, 0 insertions, 153 deletions
diff --git a/lib/raumzeit/IssueDB.class.php b/lib/raumzeit/IssueDB.class.php
deleted file mode 100644
index d6c0ba3..0000000
--- a/lib/raumzeit/IssueDB.class.php
+++ /dev/null
@@ -1,153 +0,0 @@
-<?
-# Lifter002: TODO
-# Lifter003: TEST
-# Lifter007: TODO
-# Lifter010: TODO
-// +--------------------------------------------------------------------------+
-// This file is part of Stud.IP
-// IssueDB.class.php
-//
-// Datenbank-Abfragen für Issue.class.php
-//
-// +--------------------------------------------------------------------------+
-// This program is free software; you can redistribute it and/or
-// modify it under the terms of the GNU General Public License
-// as published by the Free Software Foundation; either version 2
-// of the License, or any later version.
-// +--------------------------------------------------------------------------+
-// This program is distributed in the hope that it will be useful,
-// but WITHOUT ANY WARRANTY; without even the implied warranty of
-// MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
-// GNU General Public License for more details.
-// You should have received a copy of the GNU General Public License
-// along with this program; if not, write to the Free Software
-// Foundation, Inc., 59 Temple Place - Suite 330, Boston, MA  02111-1307, USA.
-// +--------------------------------------------------------------------------+
-
-
-/**
- * IssueDB.class.php
- *
- *
- * @author      Till Glöggler <tgloeggl@uos.de>
- * @version     19. Oktober 2005
- * @access      protected
- * @package     raumzeit
- * @deprecated
- */
-
-class IssueDB
-{
-    public static function restoreIssue($issue_id)
-    {
-        $query = "SELECT *
-                  FROM themen
-                  WHERE issue_id = ?";
-        $statement = DBManager::get()->prepare($query);
-        $statement->execute([$issue_id]);
-        return $statement->fetch(PDO::FETCH_ASSOC);
-    }
-
-    public static function storeIssue(&$issue)
-    {
-        if ($issue->new) {
-            $query = "INSERT INTO themen
-                        (issue_id, seminar_id, author_id, title, description, mkdate, chdate, priority)
-                      VALUES (?, ?, ?, ?, ?, ?, ?, ?)";
-            $statement = DBManager::get()->prepare($query);
-            $statement->execute([
-                $issue->issue_id,
-                $issue->seminar_id,
-                $issue->author_id,
-                $issue->title,
-                $issue->description,
-                $issue->mkdate,
-                $issue->chdate,
-                $issue->priority
-            ]);
-        } else {
-            $query = "UPDATE themen
-                      SET seminar_id = ?, author_id = ?, title = ?, description = ?, mkdate = ?, priority = ?
-                      WHERE issue_id = ?";
-            $statement = DBManager::get()->prepare($query);
-            $statement->execute([
-                $issue->seminar_id,
-                $issue->author_id,
-                $issue->title,
-                $issue->description,
-                $issue->mkdate,
-                $issue->priority,
-                $issue->issue_id
-            ]);
-
-            if ($statement->rowCount()) {
-                $query = "UPDATE themen SET chdate = UNIX_TIMESTAMP() WHERE issue_id = ?";
-                $statement = DBManager::get()->prepare($query);
-                $statement->execute([$issue->issue_id]);
-
-                $query = "SELECT termin_id FROM themen_termine WHERE issue_id = ?";
-                $statement = DBManager::get()->prepare($query);
-                $statement->execute([$issue->issue_id]);
-                $termin_ids = $statement->fetchAll(PDO::FETCH_COLUMN);
-
-                if (count($termin_ids) > 0) {
-                    $query = "UPDATE termine SET chdate = UNIX_TIMESTAMP() WHERE termin_id IN (?)";
-                    $statement = DBManager::get()->prepare($query);
-                    $statement->execute([$termin_ids]);
-                }
-            }
-
-        }
-        return TRUE;
-    }
-
-    public static function deleteIssue($issue_id)
-    {
-        $query = "DELETE FROM themen WHERE issue_id = ?";
-        $statement = DBManager::get()->prepare($query);
-        $statement->execute([$issue_id]);
-
-        $query = "DELETE FROM themen_termine WHERE issue_id = ?";
-        $statement = DBManager::get()->prepare($query);
-        $statement->execute([$issue_id]);
-    }
-
-    public static function isIssue($issue_id)
-    {
-        $query = "SELECT 1 FROM themen WHERE issue_id = ?";
-        $statement = DBManager::get()->prepare($query);
-        $statement->execute([$issue_id]);
-        return (bool)$statement->fetchColumn();
-    }
-
-    public static function getDatesforIssue($issue_id)
-    {
-        $query = "SELECT termine.*
-                  FROM themen_termine
-                  INNER JOIN termine USING (termin_id)
-                  WHERE issue_id = ?
-                  ORDER BY `date` ASC";
-        $statement = DBManager::get()->prepare($query);
-        $statement->execute([$issue_id]);
-
-        $ret = [];
-        while ($row = $statement->fetch(PDO::FETCH_ASSOC)) {
-            $ret[$row['termin_id']] = $row;
-        }
-        return $ret;
-    }
-
-    public static function deleteAllIssues($course_id)
-    {
-        $query = "SELECT issue_id FROM themen WHERE seminar_id = ?";
-        $statement = DBManager::get()->prepare($query);
-        $statement->execute([$course_id]);
-        $themen = $statement->fetchAll(PDO::FETCH_COLUMN);
-
-        foreach ($themen as $issue_id) {
-            self::deleteIssue($issue_id, $course_id);
-        }
-
-        return count($themen);
-    }
-}