Changeset 30704

Timestamp:

Dec 6, 2014, 9:58:22 PM (10 years ago)

Author:

ddtddt

Message:

[extensions] - Add info - update export to manage_properties_photos

Location:

extensions/AddInfo/admin

Files:

• admin.php (modified) (3 diffs)
• admin.tpl (modified) (1 diff)

extensions/AddInfo/admin/admin.php

@@ -40 +40 @@
           ));
           
-        $exp = pwg_db_fetch_assoc(pwg_query("SELECT state FROM " . PLUGINS_TABLE . " WHERE id = 'manage_info_photos';"));
+        $exp = pwg_db_fetch_assoc(pwg_query("SELECT state FROM " . PLUGINS_TABLE . " WHERE id = 'manage_properties_photos';"));
         if($exp['state']=='active'){
                 $template->assign(
@@ -50 +50 @@
         if (isset($_POST['submitexpot'])){
 
-        $idinfo=pwg_db_fetch_assoc(pwg_query('SELECT id_info_pho FROM ' . ADD_INFO_PHOTO_TABLE . ' ORDER BY id_info_pho DESC LIMIT 1;'));       
-        $idinfo=$idinfo['id_info_pho'];
+        $idinfo=pwg_db_fetch_assoc(pwg_query('SELECT id_prop_pho FROM ' . ADD_PROP_PHOTO_TABLE . ' ORDER BY id_prop_pho DESC LIMIT 1;'));       
+        $idinfo=$idinfo['id_prop_pho'];
         $idinfo1=$idinfo+1;$idinfo2=$idinfo+2;$idinfo3=$idinfo+3;
-        $q = 'INSERT INTO ' . $prefixeTable . 'Add_Info_photos(id_info_pho,designation,orderinfo,active,edit)VALUES ('.$idinfo1.',"infos1",'.$idinfo1.',0,1);';
+        $q = 'INSERT INTO ' . $prefixeTable . 'Add_properties_photos(id_prop_pho,wording,orderprop,active,edit)VALUES ('.$idinfo1.',"infos1",'.$idinfo1.',0,1);';
     pwg_query($q);
-        $q = 'INSERT INTO ' . $prefixeTable . 'Add_Info_photos(id_info_pho,designation,orderinfo,active,edit)VALUES ('.$idinfo2.',"infos2",'.$idinfo2.',0,1);';
+        $q = 'INSERT INTO ' . $prefixeTable . 'Add_properties_photos(id_prop_pho,wording,orderprop,active,edit)VALUES ('.$idinfo2.',"infos2",'.$idinfo2.',0,1);';
     pwg_query($q);
-        $q = 'INSERT INTO ' . $prefixeTable . 'Add_Info_photos(id_info_pho,designation,orderinfo,active,edit)VALUES ('.$idinfo3.',"infos3",'.$idinfo3.',0,1);';
+        $q = 'INSERT INTO ' . $prefixeTable . 'Add_properties_photos(id_prop_pho,wording,orderprop,active,edit)VALUES ('.$idinfo3.',"infos3",'.$idinfo3.',0,1);';
     pwg_query($q);
         $query = 'SELECT * FROM ' . ADDINFO_TABLE . ';';
@@ -63 +63 @@
         if (pwg_db_num_rows($result)) {
                 while ($info = pwg_db_fetch_assoc($result)){
-                        $q = 'INSERT INTO ' . $prefixeTable . 'add_Info_photos_data(id_img,id_info_pho,data)VALUES ('.$info['id'].','.$idinfo1.',"'.$info['info1'].'");';
+                        $q = 'INSERT INTO ' . $prefixeTable . 'add_properties_photos_data(id_img,id_prop_pho,data)VALUES ('.$info['id'].','.$idinfo1.',"'.$info['info1'].'");';
                         pwg_query($q);
-                        $q = 'INSERT INTO ' . $prefixeTable . 'add_Info_photos_data(id_img,id_info_pho,data)VALUES ('.$info['id'].','.$idinfo2.',"'.$info['info2'].'");';
+                        $q = 'INSERT INTO ' . $prefixeTable . 'add_properties_photos_data(id_img,id_prop_pho,data)VALUES ('.$info['id'].','.$idinfo2.',"'.$info['info2'].'");';
                         pwg_query($q);
-                        $q = 'INSERT INTO ' . $prefixeTable . 'add_Info_photos_data(id_img,id_info_pho,data)VALUES ('.$info['id'].','.$idinfo3.',"'.$info['info3'].'");';
+                        $q = 'INSERT INTO ' . $prefixeTable . 'add_properties_photos_data(id_img,id_prop_pho,data)VALUES ('.$info['id'].','.$idinfo3.',"'.$info['info3'].'");';
                         pwg_query($q);
 

extensions/AddInfo/admin/admin.tpl

@@ -16 +16 @@
         <form method="post" >
                 <fieldset>
-                        <legend>{'Export infos to manage info photo'|@translate}</legend>
+                        <legend>{'Export infos to manage properties photos'|@translate}</legend>
                         <input class="submit" name="submitexpot" type="submit" value="{'Export'|@translate}">
                 </fieldset>