From 89e0eed10a593f082640b60f1bcf6c97033919ea Mon Sep 17 00:00:00 2001
From: Cosmin Stroe <cstroe@users.sf.net>
Date: Mon, 21 Mar 2016 03:24:24 -0500
Subject: Dates start from 1970 onward.

---
 install/piwigo_structure-mysql.sql | 16 ++++++++--------
 1 file changed, 8 insertions(+), 8 deletions(-)

diff --git a/install/piwigo_structure-mysql.sql b/install/piwigo_structure-mysql.sql
index 0c50701c0..1c7853edc 100644
--- a/install/piwigo_structure-mysql.sql
+++ b/install/piwigo_structure-mysql.sql
@@ -51,7 +51,7 @@ DROP TABLE IF EXISTS `piwigo_comments`;
 CREATE TABLE `piwigo_comments` (
   `id` int(11) unsigned NOT NULL auto_increment,
   `image_id` mediumint(8) unsigned NOT NULL default '0',
-  `date` datetime NOT NULL default '0000-00-00 00:00:00',
+  `date` datetime NOT NULL default '1970-01-01 00:00:00',
   `author` varchar(255) default NULL,
   `email` varchar(255) default NULL,
   `author_id` mediumint(8) unsigned DEFAULT NULL,
@@ -121,7 +121,7 @@ CREATE TABLE `piwigo_groups` (
 DROP TABLE IF EXISTS `piwigo_history`;
 CREATE TABLE `piwigo_history` (
   `id` int(10) unsigned NOT NULL auto_increment,
-  `date` date NOT NULL default '0000-00-00',
+  `date` date NOT NULL default '1970-01-01',
   `time` time NOT NULL default '00:00:00',
   `user_id` mediumint(8) unsigned NOT NULL default '0',
   `IP` varchar(15) NOT NULL default '',
@@ -196,7 +196,7 @@ DROP TABLE IF EXISTS `piwigo_images`;
 CREATE TABLE `piwigo_images` (
   `id` mediumint(8) unsigned NOT NULL auto_increment,
   `file` varchar(255) binary NOT NULL default '',
-  `date_available` datetime NOT NULL default '0000-00-00 00:00:00',
+  `date_available` datetime NOT NULL default '1970-01-01 00:00:00',
   `date_creation` datetime default NULL,
   `name` varchar(255) default NULL,
   `comment` text,
@@ -248,7 +248,7 @@ DROP TABLE IF EXISTS `piwigo_old_permalinks`;
 CREATE TABLE `piwigo_old_permalinks` (
   `cat_id` smallint(5) unsigned NOT NULL default '0',
   `permalink` varchar(64) binary NOT NULL default '',
-  `date_deleted` datetime NOT NULL default '0000-00-00 00:00:00',
+  `date_deleted` datetime NOT NULL default '1970-01-01 00:00:00',
   `last_hit` datetime default NULL,
   `hit` int(10) unsigned NOT NULL default '0',
   PRIMARY KEY  (`permalink`)
@@ -276,7 +276,7 @@ CREATE TABLE `piwigo_rate` (
   `element_id` mediumint(8) unsigned NOT NULL default '0',
   `anonymous_id` varchar(45) NOT NULL default '',
   `rate` tinyint(2) unsigned NOT NULL default '0',
-  `date` date NOT NULL default '0000-00-00',
+  `date` date NOT NULL default '1970-01-01',
   PRIMARY KEY  (`element_id`,`user_id`,`anonymous_id`)
 ) ENGINE=MyISAM;
 
@@ -300,7 +300,7 @@ DROP TABLE IF EXISTS `piwigo_sessions`;
 CREATE TABLE `piwigo_sessions` (
   `id` varchar(255) binary NOT NULL default '',
   `data` mediumtext NOT NULL,
-  `expiration` datetime NOT NULL default '0000-00-00 00:00:00',
+  `expiration` datetime NOT NULL default '1970-01-01 00:00:00',
   PRIMARY KEY  (`id`)
 ) ENGINE=MyISAM;
 
@@ -350,7 +350,7 @@ CREATE TABLE `piwigo_themes` (
 DROP TABLE IF EXISTS `piwigo_upgrade`;
 CREATE TABLE `piwigo_upgrade` (
   `id` varchar(20) NOT NULL default '',
-  `applied` datetime NOT NULL default '0000-00-00 00:00:00',
+  `applied` datetime NOT NULL default '1970-01-01 00:00:00',
   `description` varchar(255) default NULL,
   PRIMARY KEY  (`id`)
 ) ENGINE=MyISAM;
@@ -455,7 +455,7 @@ CREATE TABLE `piwigo_user_infos` (
   `show_nb_hits` enum('true','false') NOT NULL default 'false',
   `recent_period` tinyint(3) unsigned NOT NULL default '7',
   `theme` varchar(255) NOT NULL default 'elegant',
-  `registration_date` datetime NOT NULL default '0000-00-00 00:00:00',
+  `registration_date` datetime NOT NULL default '1970-01-01 00:00:00',
   `enabled_high` enum('true','false') NOT NULL default 'true',
   `level` tinyint unsigned NOT NULL default '0',
   `activation_key` varchar(255) default NULL,
-- 
cgit v1.2.3


From b544ee394890501290a84d48ee62df72f94d5009 Mon Sep 17 00:00:00 2001
From: plegall <plg@piwigo.org>
Date: Tue, 3 May 2016 15:02:29 +0200
Subject: fixes #440, update search page on SmartPocket theme

... to include new features of Piwigo 2.7 and 2.8
---
 themes/smartpocket/template/search.tpl | 123 +++++++++++++++++++++++----------
 1 file changed, 85 insertions(+), 38 deletions(-)

diff --git a/themes/smartpocket/template/search.tpl b/themes/smartpocket/template/search.tpl
index 7c648ab1a..33c3eabb0 100644
--- a/themes/smartpocket/template/search.tpl
+++ b/themes/smartpocket/template/search.tpl
@@ -1,3 +1,28 @@
+{combine_script id='jquery.selectize' load='footer' path='themes/default/js/plugins/selectize.min.js'}
+{combine_css id='jquery.selectize' path="themes/default/js/plugins/selectize.{$themeconf.colorscheme}.css"}
+
+{footer_script}
+jQuery(document).ready(function() {
+  jQuery("#authors, #tags, #categories").each(function() {
+    jQuery(this).selectize({
+      plugins: ['remove_button'],
+      maxOptions:jQuery(this).find("option").length
+    });
+  })
+});
+{/footer_script}
+
+{html_style}
+.ui-checkbox, .ui-radio, .ui-btn-text {
+  z-index:0;
+}
+
+.form-actions {
+  margin-top:3em;
+  margin-bottom:3em;
+}
+{/html_style}
+
 {include file='infos_errors.tpl'}
 <div data-role="content">
   <ul data-role="listview" data-inset="true">
@@ -6,56 +31,78 @@
 
 
 <form class="filter" method="post" name="search" action="{$F_SEARCH_ACTION}">
-<fieldset data-role="controlgroup">
-  <legend>{'Filter'|@translate}</legend>
-  <div data-role="fieldcontain">
-    <label for="search_allwords">{'Search for words'|@translate}</label>
-    <input type="text" id="search_allwords" style="width: 300px" name="search_allwords" size="30">
-  </div>
-  
-  <input type="radio" name="mode" id="mode_and" value="AND" checked="checked">
-  <label for="mode_and">{'Search for all terms'|@translate}</label>
-  <input type="radio" name="mode" id="mode_or" value="OR">
-  <label for="mode_or">{'Search for any term'|@translate}</label>
-  <div data-role="fieldcontain">
-    <label for="search_author">{'Search for Author'|@translate}</label>
-    <input type="text" style="width: 300px" name="search_author" id="search_author" size="30">
-  </div>
-</fieldset>
+  <fieldset data-role="controlgroup">
+    <legend>{'Search for words'|@translate}</legend>
 
-{if isset($TAG_SELECTION)}
-<fieldset data-role="controlgroup">
-  <legend>{'Search tags'|@translate}</legend>
-  {$TAG_SELECTION}
+    <input type="text" name="search_allwords">
+
+    <input type="radio" name="mode" id="mode_and" value="AND" checked="checked">
+    <label for="mode_and">{'Search for all terms'|@translate}</label>
+
+    <input type="radio" name="mode" id="mode_or" value="OR">
+    <label for="mode_or">{'Search for any term'|@translate}</label>
+  </fieldset>
+
+  <fieldset data-role="controlgroup">
+  <legend>{'Apply on properties'|translate}</legend>
+
+    <input type="checkbox" name="fields[]" value="name" checked="checked" id="field-name">
+    <label for="field-name">{'Photo title'|translate}</label>
+
+    <input type="checkbox" name="fields[]" value="comment" checked="checked" id="field-comment">
+    <label for="field-comment">{'Photo description'|translate}</label>
+
+    <input type="checkbox" name="fields[]" value="file" checked="checked" id="field-file">
+    <label for="field-file">{'File name'|translate}</label>
+
+{if isset($TAGS)}
+    <input type="checkbox" name="search_in_tags" value="tags" id="field-tags">
+    <label for="field-tags">{'Tags'|translate}</label>
+{/if}
+  </fieldset>
+
+{if count($AUTHORS)>=1}
+<fieldset  data-role="controlgroup">
+  <legend>{'Search for Author'|@translate}</legend>
+  <select id="authors" placeholder="{'Type in a search term'|translate}" name="authors[]" multiple>
+{foreach from=$AUTHORS item=author}
+    <option value="{$author.author|strip_tags:false|escape:html}">{$author.author|strip_tags:false} ({$author.counter|translate_dec:'%d photo':'%d photos'})</option>
+{/foreach}
+  </select>
 </fieldset>
+{/if}
 
+{if isset($TAGS)}
 <fieldset data-role="controlgroup">
+  <legend>{'Search tags'|@translate}</legend>
+  <select id="tags" placeholder="{'Type in a search term'|translate}" name="tags[]" multiple>
+{foreach from=$TAGS item=tag}
+    <option value="{$tag.id}">{$tag.name} ({$tag.counter|translate_dec:'%d photo':'%d photos'})</option>
+{/foreach}
+  </select>
   <input type="radio" name="tag_mode" id="tag_mode_and" value="AND" checked="checked">
   <label for="tag_mode_and">{'All tags'|@translate}</label>
+
   <input type="radio" name="tag_mode" id="tag_mode_or" value="OR">
   <label for="tag_mode_or">{'Any tag'|@translate}</label>
 </fieldset>
 {/if}
 
-<div data-role="fieldcontain">
+<fieldset data-role="controlgroup">
   <legend>{'Search in albums'|@translate}</legend>
-  <label for="categoryList">{'Albums'|@translate}
-    <select class="categoryList" id="categoryList" name="cat[]" multiple="multiple" data-native-menu="false">
-      {html_options options=$category_options selected=$category_options_selected}
-    </select>
-  </label>
-  <fieldset data-role="controlgroup">
-  <legend>{'Search in sub-albums'|@translate}</legend>
-    <input type="radio" name="subcats-included" value="1" id="subcats-included-yes" checked="checked">
-    <label for="subcats-included-yes">{'Yes'|@translate}</label>
-    <input type="radio" name="subcats-included" id="subcats-included-no" value="0">
-    <label for="subcats-included-no">{'No'|@translate}</label>
-  </fieldset>
-</div>
-<p>
-  <input class="submit" type="submit" name="submit" value="{'Submit'|@translate}">
-  <input class="submit" type="reset" value="{'Reset'|@translate}">
-</p>
+  <select id="categories" placeholder="{'Type in a search term'|translate}" name="cat[]" multiple>
+    {html_options options=$category_options selected=$category_options_selected}
+  </select>
+
+  <input type="checkbox" name="subcats-included" value="1" checked="checked" id="subcats-included">
+  <label for="subcats-included">{'Search in sub-albums'|@translate}</label>
+</fieldset>
+
+
+  <div class="form-actions">
+    <input class="submit" type="submit" name="submit" value="{'Submit'|@translate}">
+  </div>
+
 </form>
 
 <script type="text/javascript"><!--
-- 
cgit v1.2.3