wtrmln/modules/models/model_pages.php

   1 <?php
   2 /********************************************************************
   3
   4   Watermelon CMS
   5
   6 Copyright 2008-2009 Radosław Pietruszewski
   7
   8 This program is free software; you can redistribute it and/or
   9 modify it under the terms of the GNU General Public License
  10 version 2 as published by the Free Software Foundation.
  11
  12 This program is distributed in the hope that it will be useful,
  13 but WITHOUT ANY WARRANTY; without even the implied warranty of
  14 MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
  15 GNU General Public License for more details.
  16
  17 You should have received a copy of the GNU General Public License
  18 along with this program; if not, write to the Free Software
  19 Foundation, Inc., 59 Temple Place - Suite 330, Boston, MA  02111-1307, USA.
  20
  21 ********************************************************************/
  22
  23 class Model_Pages extends Model
  24 {
  25    /*
  26     * public DBresult GetPages()
  27     *
  28     * pobiera strony
  29     */
  30
  31    public function GetPages()
  32    {
  33       return $this->db->query("SELECT * FROM `__pages` ORDER BY `id` DESC");
  34    }
  35
  36    /*
  37     * public DBresult GetData(string $pagename)
  38     *
  39     * zwraca dane page'a o nazwie $pagename
  40     */
  41
  42    public function GetData($pagename)
  43    {
  44       $pagename = mysql_real_escape_string($pagename);
  45
  46       return $this->db->query("SELECT `content`, `title` FROM `__pages` WHERE `name` = '%1'", $pagename);
  47    }
  48
  49    /*
  50     * public DBresult GetData(int $pageID)
  51     *
  52     * zwraca dane page'a o ID $pageID
  53     */
  54
  55    public function GetDataByID($pageID)
  56    {
  57       $pageID = intval($pageID);
  58
  59       return $this->db->query("SELECT * FROM `__pages` WHERE `id` = '%1'", $pageID);
  60    }
  61
  62    /*
  63     * public void Post(string $title, string $name, string $text)
  64     *
  65     * tworzy stronę o tytule $title, z treścią $text i nazwą $name
  66     */
  67
  68    public function Post($title, $name, $text)
  69    {
  70       $title = mysql_real_escape_string($title);
  71       $name  = mysql_real_escape_string($name);
  72       $text  = mysql_real_escape_string($text);
  73
  74       $this->db->query("INSERT INTO `__pages` (`name`, `content`, `title`) VALUES ('%1', '%2', '%3')", $name, $text, $title);
  75    }
  76
  77    /*
  78     * public void Edit(uint $id, string $title, string $name, string $text)
  79     *
  80     * ustala stronie o ID = $id tytuł $title, nazwę $name oraz treść $text
  81     */
  82
  83    public function Edit($id, $title, $name, $text)
  84    {
  85       $title = mysql_real_escape_string($title);
  86       $text  = mysql_real_escape_string($text);
  87       $name  = mysql_real_escape_string($name);
  88       $id    = intval($id);
  89
  90       $this->db->query("UPDATE `__pages` SET `title` = '%1', `content` = '%2', `name` = '%3' WHERE `id` = '%4'", $title, $text, $name, $id);
  91    }
  92
  93    /*
  94     * public void Delete(uint $id)
  95     *
  96     * Usuwa stronę o ID = $id
  97     */
  98
  99    public function Delete($id)
 100    {
 101       $id = intval($id);
 102       $this->db->query("DELETE FROM `__pages` WHERE `id` = '%1'", $id);
 103    }
 104 }
 105 ?>