NP_gallery 0.94

[nucleus-jp/nucleus-plugins.git] / NP_gallery / trunk / gallery / template.php

diff --git a/NP_gallery/trunk/gallery/template.php b/NP_gallery/trunk/gallery/template.php
new file mode 100644 (file)
index 0000000..1e2704c
--- /dev/null
+++ b/NP_gallery/trunk/gallery/template.php
@@ -0,0 +1,94 @@
+<?php\r
+\r
+class NPG_TEMPLATE {\r
+\r
+       var $id;\r
+       var $section;\r
+       var $name;\r
+       var $description;\r
+       \r
+       function NPG_TEMPLATE($templateid) {\r
+               $this->id = $templateid;\r
+               $this->section = array();\r
+               if($this->existsID($this->id)) {\r
+                       $this->readall();\r
+                       $query = 'select * from '.sql_table('plug_gallery_template_desc').' where tdid='.$this->id;\r
+                       $res = sql_query($query);\r
+                       $row = mysql_fetch_object($res);\r
+                       $this->name = stripslashes($row->tdname);\r
+                       $this->description = stripslashes($row->tddesc);\r
+               }\r
+       }\r
+       \r
+       function getID() { return $this->id; }\r
+       function getname() {return $this->name; }\r
+       function getdesc() {return $this->description; }\r
+       \r
+       function createfromname($name) {return new NPG_TEMPLATE(NPG_TEMPLATE::getIdFromName($name));}\r
+       \r
+       function getIDfromName($name) {\r
+               $query =  'SELECT tdid'\r
+               . ' FROM '.sql_table('plug_gallery_template_desc')\r
+               . ' WHERE tdname="'.addslashes($name).'"';\r
+               $res = sql_query($query);\r
+               $obj = mysql_fetch_object($res);\r
+               return $obj->tdid;\r
+       }\r
+       \r
+       function updategeneralinfo($name,$desc) {\r
+               $query =  'UPDATE '.sql_table('plug_gallery_template_desc').' SET'\r
+               . " tdname='" . addslashes($name) . "',"\r
+               . " tddesc='" . addslashes($desc) . "'"\r
+               . " WHERE tdid=" . $this->getID();\r
+               sql_query($query); \r
+       }\r
+       \r
+       function update($type,$content) {\r
+               $id = $this->getID();\r
+               sql_query('DELETE FROM '.sql_table('plug_gallery_template')." WHERE name='". addslashes($type) ."' and tdesc=" . intval($id));\r
+               \r
+               if ($content) {\r
+                       sql_query('INSERT INTO '.sql_table('plug_gallery_template')." SET content='" . addslashes($content) . "', name='" . addslashes($type) . "', tdesc=" . intval($id));\r
+               }\r
+       }\r
+       \r
+       function deleteallparts() { sql_query('DELETE FROM '.sql_table('plug_gallery_template').' WHERE tdesc='.$this->getID()); }\r
+       \r
+       function createnew($name,$desc) {\r
+               sql_query('INSERT INTO '.sql_table('plug_gallery_template_desc')." (tdname, tddesc) VALUES ('" . addslashes($name) . "','" . addslashes($desc) . "')");\r
+               $newId = mysql_insert_id();\r
+               return $newId;\r
+       }\r
+       \r
+       function exists($name) {\r
+               $r = sql_query('select * FROM '.sql_table('plug_gallery_template_desc').' WHERE tdname="'.addslashes($name).'"');\r
+               return (mysql_num_rows($r) != 0);\r
+       }\r
+       \r
+       function existsID($id) {\r
+               $r = sql_query('select * FROM '.sql_table('plug_gallery_template_desc').' WHERE tdid='.intval($id));\r
+               return (mysql_num_rows($r) != 0);\r
+       }\r
+       \r
+       function gettemplate($type) {\r
+               $result = mysql_query("select * from ".sql_table('plug_gallery_template')." where name='$type'" );\r
+               $data = mysql_fetch_assoc($result);\r
+               $template = stripslashes($data['content']);\r
+               return $template;\r
+       }\r
+       \r
+       function settemplate($type, $content) {\r
+               $this->update($type,$content);\r
+       }\r
+       \r
+       function readall() {\r
+               $query = 'select * from '.sql_table('plug_gallery_template').' where tdesc='.$this->id;\r
+               $res = sql_query($query);\r
+               while ($row = mysql_fetch_object($res)){\r
+                       $this->section[$row->name] = stripslashes($row->content);\r
+               }\r
+       }\r
+       \r
+}\r
+\r
+?>\r