10 function NPG_TEMPLATE($templateid) {
\r
11 $this->id = $templateid;
\r
12 $this->section = array();
\r
13 if($this->existsID($this->id)) {
\r
15 $query = 'select * from '.sql_table('plug_gallery_template_desc').' where tdid='.intval($this->id);
\r
16 $res = sql_query($query);
\r
17 $row = mysql_fetch_object($res);
\r
18 $this->name = stripslashes($row->tdname);
\r
19 $this->description = stripslashes($row->tddesc);
\r
23 function getID() { return $this->id; }
\r
24 function getname() {return $this->name; }
\r
25 function getdesc() {return $this->description; }
\r
27 function createfromname($name) {return new NPG_TEMPLATE(NPG_TEMPLATE::getIdFromName($name));}
\r
29 function getIDfromName($name) {
\r
30 $query = 'SELECT tdid'
\r
31 . ' FROM '.sql_table('plug_gallery_template_desc')
\r
32 . ' WHERE tdname="'.addslashes($name).'"';
\r
33 $res = sql_query($query);
\r
34 $obj = mysql_fetch_object($res);
\r
38 function updategeneralinfo($name,$desc) {
\r
39 $query = 'UPDATE '.sql_table('plug_gallery_template_desc').' SET'
\r
40 . " tdname='" . addslashes($name) . "',"
\r
41 . " tddesc='" . addslashes($desc) . "'"
\r
42 . " WHERE tdid=" . intval($this->getID());
\r
46 function update($type,$content) {
\r
47 $id = $this->getID();
\r
48 sql_query('DELETE FROM '.sql_table('plug_gallery_template')." WHERE name='". addslashes($type) ."' and tdesc=" . intval($id));
\r
51 sql_query('INSERT INTO '.sql_table('plug_gallery_template')." SET content='" . addslashes($content) . "', name='" . addslashes($type) . "', tdesc=" . intval($id));
\r
55 function deleteallparts() { sql_query('DELETE FROM '.sql_table('plug_gallery_template').' WHERE tdesc='.intval($this->getID())); }
\r
57 function createnew($name,$desc) {
\r
58 sql_query('INSERT INTO '.sql_table('plug_gallery_template_desc')." (tdname, tddesc) VALUES ('" . addslashes($name) . "','" . addslashes($desc) . "')");
\r
59 $newId = mysql_insert_id();
\r
63 function exists($name) {
\r
64 $r = sql_query('select * FROM '.sql_table('plug_gallery_template_desc').' WHERE tdname="'.addslashes($name).'"');
\r
65 return (mysql_num_rows($r) != 0);
\r
68 function existsID($id) {
\r
69 $r = sql_query('select * FROM '.sql_table('plug_gallery_template_desc').' WHERE tdid='.intval($id));
\r
70 return (mysql_num_rows($r) != 0);
\r
73 function gettemplate($type) {
\r
74 $type=addslashes($type);
\r
75 $result = mysql_query("select * from ".sql_table('plug_gallery_template')." where name='$type'" );
\r
76 $data = mysql_fetch_assoc($result);
\r
77 $template = stripslashes($data['content']);
\r
81 function settemplate($type, $content) {
\r
82 $this->update($type,$content);
\r
85 function readall() {
\r
86 $query = 'select * from '.sql_table('plug_gallery_template').' where tdesc='.intval($this->id);
\r
87 $res = sql_query($query);
\r
88 while ($row = mysql_fetch_object($res)){
\r
89 $this->section[$row->name] = stripslashes($row->content);
\r