Changeset 32135 for extensions/manage_properties_photos/include

Timestamp:

Apr 28, 2020, 2:37:00 AM (4 years ago)

Author:

ddtddt

Message:

[manage_properties_photos]

Location:

extensions/manage_properties_photos/include

Files:

• function.aip.inc.php (modified) (5 diffs)
• index.php (added)

extensions/manage_properties_photos/include/function.aip.inc.php

@@ -2 +2 @@
 
 // +-----------------------------------------------------------------------+
-// | Manage Properties Photos plugin for Piwigo                            |
+// | Manage Properties Photos plugin for Piwigo by TEMMII                  |
 // +-----------------------------------------------------------------------+
-// | Copyright(C) 2014-2016 ddtddt               http://temmii.com/piwigo/ |
+// | Copyright(C) 2007-2020 ddtddt               http://temmii.com/piwigo/ |
 // +-----------------------------------------------------------------------+
 // | This program is free software; you can redistribute it and/or modify  |
@@ -24 +24 @@
 function tab_add_info_one_photo($id_img){
 $query = '
-    SELECT aip.id_prop_pho,aip.wording,aipd.data,aip.orderprop
+    SELECT aip.id_prop_pho,aip.wording,aipd.data,aip.orderprop,aip.Typ
     FROM ' . ADD_PROP_PHOTO_TABLE . ' AS aip
     LEFT JOIN ' . ADD_PROP_PHOTO_DATA_TABLE . ' AS aipd ON aip.id_prop_pho=aipd.id_prop_pho
@@ -51 +51 @@
 function tab_add_info_by_photo(){
 $query = '
-    SELECT id_prop_pho,wording
+    SELECT id_prop_pho,wording,Typ,dataprop
     FROM ' . ADD_PROP_PHOTO_TABLE . ' 
-    WHERE active = 0 
-    AND edit = 1 
+    WHERE edit = 1
+        AND typ != 3
+        AND typ != 6
     ORDER BY orderprop ASC
     ;';
@@ -64 +65 @@
 function tab_add_info_by_photo_show(){
 $query = '
-    SELECT id_prop_pho,wording,orderprop
+    SELECT id_prop_pho,wording,orderprop,Typ,dataprop
     FROM ' . ADD_PROP_PHOTO_TABLE . ' 
     WHERE active = 0 
@@ -88 +89 @@
 }
 
+function data_info_photosdate($id_img=null,$id_prop_pho=NULL){
+$query = '
+    SELECT datadate
+    FROM ' . ADD_PROP_PHOTO_DATADATE_TABLE;
+    $wa='WHERE';
+    if($id_img!=null){
+        $query .=' '.$wa.' id_img='.$id_img;$wa='AND';
+    }
+    if($id_prop_pho!=null){
+        $query .=' '.$wa.' id_prop_pho='.$id_prop_pho;$wa='AND';
+    }
+$query .= ';';
+return pwg_query($query);
+}
+
 /*Admin*/
 function tab_info_photos($id_prop_pho=NULL){
 $query = '
-    SELECT id_prop_pho,wording,orderprop,active,edit
+    SELECT id_prop_pho,wording,orderprop,active,edit,Typ,dataprop
     FROM ' . ADD_PROP_PHOTO_TABLE;
     if($id_prop_pho!=null){