--- /dev/null
+<?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