--- /dev/null
+<?php\r
+\r
+include('.\..\..\..\..\config.php');\r
+global $DIR_PLUGINS;\r
+include_once ($DIR_PLUGINS.'gallery/config.php');\r
+\r
+//from 0.61a to 0.75\r
+global $NPG_CONF;\r
+\r
+$query = 'CREATE TABLE IF NOT EXISTS '.sql_table('plug_gallery_views').' ( '.\r
+ 'vpictureid int unsigned not null, '.\r
+ 'views int unsigned )';\r
+sql_query($query);\r
+ \r
+$query = 'CREATE TABLE IF NOT EXISTS '.sql_table('plug_gallery_views_log').' ( '.\r
+ 'vlpictureid int unsigned not null, '.\r
+ 'ip varchar(20), '.\r
+ 'time timestamp )';\r
+sql_query($query);\r
+\r
+//new option\r
+global $manager;\r
+if ($manager->pluginInstalled('NP_gallery')) \r
+{\r
+ $plugin =& $manager->getPlugin('NP_gallery');\r
+ if ($plugin != NULL)\r
+ if($plugin->getoption('deletetables')) $plugin->createOption('deletetables',__NPG_OPT_DONT_DELETE_TABLES,'yesno','no'); \r
+}\r
+\r
+//new config\r
+if (!$NPG_CONF['viewtime']) setNPGoption('viewtime', 30 * 60);\r
+\r
+\r
+//make new table\r
+$query = 'CREATE TABLE IF NOT EXISTS '.sql_table('plug_gallery_template_desc').' ( '.\r
+ 'tdid int unsigned not null auto_increment PRIMARY KEY, '.\r
+ 'tdname varchar(20), '.\r
+ 'tddesc varchar(200) )';\r
+sql_query($query);\r
+\r
+//if it already exists and there are no rows already, then add default\r
+$query = 'select * from '.sql_table('plug_gallery_template_desc');\r
+$res = sql_query($query);\r
+if(!mysql_num_rows($res)) {\r
+ $query = 'insert into '.sql_table('plug_gallery_template_desc').' (tdid, tdname, tddesc) values (NULL, "061default", "default templates from 0.61")';\r
+ sql_query($query);\r
+ $new_id = mysql_insert_id();\r
+ if(!$NPG_CONF['template']) setNPGOption('template', $newid);\r
+}\r
+\r
+//change previous template table and add reference to template_desc\r
+$query = 'show columns from '.sql_table('plug_gallery_template').' like "tdesc"';\r
+$res = sql_query($query);\r
+if(!mysql_num_rows($res)) {\r
+ $query = 'ALTER TABLE '.sql_table('plug_gallery_template').\r
+ ' add column tdesc int unsigned first ';\r
+ sql_query($query);\r
+ if(!$new_id) $new_id = 1;\r
+ $query = 'UPDATE '.sql_table('plug_gallery_template').' set tdesc = '.$new_id;\r
+ sql_query($query);\r
+}\r
+\r
+\r
+$query = 'show columns from '.sql_table('plug_gallery_comment').' like "cuser"';\r
+$res = sql_query($query);\r
+if(!mysql_num_rows($res)) {\r
+ $query = 'ALTER TABLE '.sql_table('plug_gallery_comment').\r
+ ' add column cuser varchar(40), '.\r
+ ' add column cmail varchar(100), '.\r
+ ' add column chost varchar(60), '.\r
+ ' add column cip varchar(15)';\r
+ sql_query($query);\r
+}\r
+\r
+\r
+$query = 'show columns from '.sql_table('plug_gallery_album').' like "commentsallowed"';\r
+$res = sql_query($query);\r
+if(!mysql_num_rows($res)) {\r
+ $query = 'ALTER TABLE '.sql_table('plug_gallery_album').\r
+ ' add column commentsallowed tinyint DEFAULT 1 ';\r
+ sql_query($query);\r
+}\r
+\r
+//new template\r
+if (!NPG_TEMPLATE::exists('default075')) {\r
+ $template = new NPG_TEMPLATE(NPG_TEMPLATE::createnew('default075','default 0.75 templates'));\r
+ if(!$NPG_CONF['template']) setNPGOption('template', $template->getID());\r
+ \r
+ $name = 'LIST_HEADER';\r
+ $content = '<%breadcrumb%><hr/><table width=100% ><thead>'\r
+ .'<tr><th><a href="<%sortbytitle%>">Title</a></th>'\r
+ .'<th><a href="<%sortbydescription%>">Description</a></th>'\r
+ .'<th><a href="<%sortbyowner%>">Owner</a></th>'\r
+ .'<th><a href="<%sortbymodified%>">Last Modified</a></th>'\r
+ .'<th><a href="<%sortbynumber%>">Images</a></th></tr></thead><tbody>';\r
+ $template->setTemplate($name, $content);\r
+ \r
+ $name = 'LIST_BODY';\r
+ $content = '<tr><td><a href="<%albumlink%>"><%title%></a></td>'\r
+ .'<td><%description%></td>'\r
+ .'<td><%ownername%></td>'\r
+ .'<td><%modified%></td>'\r
+ .'<td><%numberofimages%></td></tr>';\r
+ $template->setTemplate($name, $content);\r
+ \r
+ $name = 'LIST_FOOTER';\r
+ $content = '</tbody></table><hr/><br />'\r
+ .'<%if(canaddalbum)%>'\r
+ .'<a href="<%addalbumlink%>">Add New Album | </a>'\r
+ .'<%endif%>'\r
+ .'<%if(canaddpicture)%>'\r
+ .'<a href="<%addpictureslink%>"onclick="window.open(this.href,\'addpicture\',\'status=no,toolbar=no,scrollbars=no,resizable=yes,width=600,height=400\');return false;">'\r
+ .' Add Pictures</a>'\r
+ .'<%endif%>';\r
+ $template->setTemplate($name, $content);\r
+ \r
+ //\r
+ $name = 'ALBUM_HEADER';\r
+ $content = '<%breadcrumb%><hr/><div id="NPG_thumbnail"><ul class="thumbnail">';\r
+ $template->setTemplate($name, $content);\r
+ \r
+ $name = 'ALBUM_BODY';\r
+ $content = '<li><a href="<%picturelink%>"><img style="<%centeredtopmargin(140,-10)%>" src="<%thumbnail%>" /></a><br/><%picturetitle%><br/><%pictureviews%> views</li>';\r
+ $template->setTemplate($name, $content);\r
+ \r
+ $name = 'ALBUM_FOOTER';\r
+ $content = '</ul></div><div id="NPG_footer"><br /><hr/>'\r
+ .'<%if(caneditalbum)%>'\r
+ .'<a href="<%editalbumlink%>">Modify Album </a> | '\r
+ .'<%endif%>'\r
+ .'<%if(canaddpicture)%>'\r
+ .'<a href="<%addpicturelink%>"onclick="window.open(this.href,\'imagepopup\',\'status=no,toolbar=no,scrollbars=no,resizable=yes,width=480,height=360\');return false;">Add Picture</a>'\r
+ .'<%endif%>'\r
+ .'</div>';\r
+ $template->setTemplate($name, $content);\r
+ \r
+ //\r
+ $name = 'ITEM_HEADER';\r
+ $content = '<%breadcrumb%><br/><a href="<%previouslink%>"> Previous |</a><a href="<%nextlink%>"> Next</a><hr/><div id="NPG_picture">';\r
+ $template->setTemplate($name, $content);\r
+ \r
+ $name = 'ITEM_BODY';\r
+ $content = '<a href="<%fullsizelink%>" onclick="window.open(this.href,\'imagepopup\',\'status=no,toolbar=no,scrollbars=auto,resizable=yes,width=<%width%>,height=<%height%>\');return false;">'\r
+ .'<img src="<%intermediatepicture%>" /></a>';\r
+ $template->setTemplate($name, $content);\r
+ \r
+ $name = 'ITEM_FOOTER';\r
+ $content = '</div><div id="NPG_footer"><br /><%description%><br/><br/>Last modified by <%owner%> on <%date%> '\r
+ .'<%if(caneditpicture)%>'\r
+ .'<a href="<%editpicturelink%>">Edit</a>'\r
+ .' | <a href="<%deletepicturelink%>">Delete</a>'\r
+ .'<%endif%>'\r
+ .'<br/></div>'\r
+ .'<div class="contenttitle"><h2>Comments</h2></div><%comments%>'\r
+ .'<div class="contenttitle"><h2>Add Comment</h2></div><%commentform%>'; \r
+ $template->setTemplate($name, $content);\r
+ \r
+ $name = 'COMMENT_BODY';\r
+ $content = '<div class="itemcomment id<%memberid%>">'\r
+ .'<h3><a href="<%userlinkraw%>"'\r
+ .'title="<%ip%> | Click to visit <%user%>\'s website or send an email">'\r
+ .'<%user%></a> wrote:</h3>'\r
+ .'<div class="commentbody">'\r
+ .'<%body%></div><div class="commentinfo"><%date%> <%time%></div></div>' ;\r
+ $template->setTemplate($name, $content);\r
+}\r
+\r
+setNPGoption('currentversion',75);\r
+\r
+include('np_gallery_update075.php');\r
+?>\r
OSDN Git Service
