Changeset 32180
- Timestamp:
- May 6, 2020, 9:26:22 PM (4 years ago)
- Location:
- extensions/manage_properties_photos
- Files:
-
- 7 edited
Legend:
- Unmodified
- Added
- Removed
-
extensions/manage_properties_photos/admin.php
r32151 r32180 22 22 if (!defined('PHPWG_ROOT_PATH')) 23 23 die('Hacking attempt!'); 24 global $template, $conf, $user ;24 global $template, $conf, $user, $pwg_loaded_plugins; 25 25 include_once(PHPWG_ROOT_PATH . 'admin/include/tabsheet.class.php'); 26 26 load_language('plugin.lang', ADD_PROP_PHOTO_PATH); … … 38 38 )); 39 39 40 /*download_counter*/ 41 if (isset($pwg_loaded_plugins['download_counter'])){ 42 $row = pwg_db_fetch_assoc(pwg_query('SELECT dataprop FROM '. ADD_PROP_PHOTO_TABLE .' where dataprop ="plugdownload_counter";')); 43 if(empty($row)){ 44 $row = pwg_db_fetch_assoc(pwg_query('SELECT MAX(orderprop) FROM '. ADD_PROP_PHOTO_TABLE )); 45 $or = ($row['MAX(orderprop)'] + 1); 46 pwg_query('INSERT INTO ' . $prefixeTable . 'add_properties_photos(wording,orderprop,active,edit,Typ,dataprop)VALUES ("Download Counter","' . $or . '","0",0,"1","plugdownload_counter");'); 47 } 48 }else{ 49 pwg_query('DELETE FROM ' . ADD_PROP_PHOTO_TABLE . ' where dataprop ="plugdownload_counter";'); 50 } 51 /*end*/ 52 /*added by*/ 53 if (isset($pwg_loaded_plugins['Photo_add_by'])){ 54 $row = pwg_db_fetch_assoc(pwg_query('SELECT dataprop FROM '. ADD_PROP_PHOTO_TABLE .' where dataprop ="plugPhoto_add_by";')); 55 if(empty($row)){ 56 $row = pwg_db_fetch_assoc(pwg_query('SELECT MAX(orderprop) FROM '. ADD_PROP_PHOTO_TABLE )); 57 $or = ($row['MAX(orderprop)'] + 1); 58 pwg_query('INSERT INTO ' . $prefixeTable . 'add_properties_photos(wording,orderprop,active,edit,Typ,dataprop)VALUES ("addedby","' . $or . '","0",0,"1","plugPhoto_add_by");'); 59 } 60 }else{ 61 pwg_query('DELETE FROM ' . ADD_PROP_PHOTO_TABLE . ' where dataprop ="plugPhoto_add_by";'); 62 } 63 /*end*/ 40 64 41 65 if (!isset($_GET['tab'])) … … 116 140 } 117 141 } 118 $template->append('info_photos ', $items);142 $template->append('info_photosI', $items); 119 143 } 120 144 } … … 216 240 if($info_photos['dataprop']=="DeletePhoto" and $info_photos['wording'] ="**delpho**"){ 217 241 $items['AIPWORDING'] = l10n('Delete photo'); 242 }else if($info_photos['dataprop']=="movedescription"){ 243 $items['AIPWORDING'] = l10n('Description'); 244 }else if($info_photos['dataprop']=="showid"){ 245 $items['AIPWORDING'] = l10n('Image id'); 246 }else if($info_photos['dataprop']=="plugPhoto_add_by"){ 247 $items['AIPWORDING'] = l10n('Photo added by'); 248 }else if($info_photos['dataprop']=="plugdownload_counter"){ 249 $items['AIPWORDING'] = l10n('Downloads'); 218 250 }else{ 219 251 $items['AIPWORDING'] = trigger_change('AP_render_content',$info_photos['wording']); … … 446 478 redirect(ADD_PROP_PHOTO_ADMIN . '-config'); 447 479 } 480 $mppshid = pwg_db_fetch_assoc(pwg_query('SELECT dataprop FROM ' . ADD_PROP_PHOTO_TABLE.' WHERE dataprop="showid";')); 481 if(empty($mppshid)){ 482 $vars['MPPSHID']='actionschowid'; 483 $template->append('mppconfig', $vars, true); 484 } 485 if (isset($_POST['submitmppsid'])){ 486 $row = pwg_db_fetch_assoc(pwg_query('SELECT MAX(orderprop) FROM '. ADD_PROP_PHOTO_TABLE )); 487 $or = ($row['MAX(orderprop)'] + 1); 488 $q = 'INSERT INTO ' . $prefixeTable . 'add_properties_photos(wording,orderprop,active,edit,Typ,dataprop)VALUES ("ID","' . $or . '","0",0,"1","showid");'; 489 pwg_query($q); 490 $_SESSION['page_infos'] = array(l10n('Information data registered in database')); 491 redirect(ADD_PROP_PHOTO_ADMIN . '-config'); 492 } 493 if (isset($_POST['submitmpphid'])){ 494 pwg_query('DELETE FROM ' . ADD_PROP_PHOTO_TABLE . ' where dataprop ="showid";'); 495 $_SESSION['page_infos'] = array(l10n('Information data registered in database')); 496 redirect(ADD_PROP_PHOTO_ADMIN . '-config'); 497 } 448 498 break; 449 499 } -
extensions/manage_properties_photos/admin/admin.tpl
r32162 r32180 381 381 <legend>{'Properties additionals'|@translate}</legend> 382 382 <table> 383 {foreach from=$info_photos item=infophoto}383 {foreach from=$info_photosI item=infophoto} 384 384 <tr> 385 385 <td style="width: 100px;"><span style="font-weight: bold; text-align: right;" >{$infophoto.AIPWORDING}</span></td> … … 439 439 {/if} 440 440 <br> 441 <br> 442 {if isset($mppconfig.MPPSHID)} 443 <span style="margin: 0 0 0 20px"><input class="submit" name="submitmppsid" type="submit" value="{'Show Image Id'|@translate}" /> 444 {else} 445 <span style="margin: 0 0 0 20px"><input class="submit" name="submitmpphid" type="submit" value="{'Hide Image Id'|@translate}" /> 446 {/if} 447 <br> 448 441 449 </div> 442 450 </form> -
extensions/manage_properties_photos/initadmin.php
r32162 r32180 60 60 $test = pwg_query($q); 61 61 $row = pwg_db_fetch_assoc($test); 62 if ( count($row) > 0){62 if (!empty($row)){ 63 63 $propertieslist = array(); 64 64 $propertieslist2 = tab_add_info_by_photo(); -
extensions/manage_properties_photos/initpicture.php
r32177 r32180 184 184 }); 185 185 {/footer_script} 186 {else if $addinfophotos.AIPWORDING == \'ID\'} 187 <div id="ImageId" class="imageInfo"> 188 <dt>{\'Image id\'|@translate}</dt> 189 <dd>{$addinfophotos.AIPDATA}</dd> 190 </div> 191 {else if $addinfophotos.AIPWORDING == \'addedby\'} 192 <div id="pab1" class="imageInfo"> 193 <dt>{\'Photo added by\'|@translate}</dt> 194 <dd>{$PAB}</dd> 195 </div> 196 {else if $addinfophotos.AIPWORDING == \'Download Counter\'} 197 <div id="DownloadCounter" class="imageInfo"> 198 <dt>{\'Downloads\'|@translate}</dt> 199 <dd>{$DOWNLOAD_COUNTER}</dd> 200 </div> 186 201 {else if $addinfophotos.AIPDATA} 187 202 <div id="add_info" class="imageInfo"> … … 395 410 }); 396 411 {/footer_script} 412 {else if $addinfophotos.AIPWORDING == \'ID\'} 413 <div id="ImageId" class="imageInfo"> 414 <dl class="row mb-0"> 415 <dt class="col-sm-5">{\'Image id\'|@translate}</dt> 416 <dt class="col-sm-5">{$addinfophotos.AIPDATA}</dd> 417 </dl> 418 </div> 419 {else if $addinfophotos.AIPWORDING == \'addedby\'} 420 <div id="pab1" class="imageInfo"> 421 <dl class="row mb-0"> 422 <dt class="col-sm-5">{\'Photo added by\'|@translate}</dt> 423 <dt class="col-sm-5">{$PAB}</dd> 424 </dl> 425 </div> 426 {else if $addinfophotos.AIPWORDING == \'Download Counter\'} 427 <div id="DownloadCounter" class="imageInfo"> 428 <dl class="row mb-0"> 429 <dt class="col-sm-5">{\'Downloads\'|@translate}</dt> 430 <dt class="col-sm-5">{$DOWNLOAD_COUNTER}</dd> 431 </dl> 432 </div> 397 433 {else if $addinfophotos.AIPDATA} 398 434 <div id="add_info" class="imageInfo"> … … 735 771 }); 736 772 {/footer_script} 773 {else if $addinfophotos.AIPWORDING == \'ID\'} 774 <div id="ImageId" class="imageInfo"> 775 <tr> 776 <th scope="row">{\'Image id\'|@translate}</th> 777 <td>{$addinfophotos.AIPDATA}</td> 778 </tr> 779 </div> 780 {else if $addinfophotos.AIPWORDING == \'addedby\'} 781 <div id="pab1" class="imageInfo"> 782 <tr> 783 <th scope="row">{\'Photo added by\'|@translate}</th> 784 <td>{$PAB}</td> 785 </tr> 786 </div> 787 {else if $addinfophotos.AIPWORDING == \'Download Counter\'} 788 <div id="DownloadCounter" class="imageInfo"> 789 <tr> 790 <th scope="row">{\'Downloads\'|@translate}</th> 791 <td>{$DOWNLOAD_COUNTER}</td> 792 </tr> 793 </div> 737 794 {else if $addinfophotos.AIPDATA} 738 739 740 741 742 743 795 <div id="add_info" class="imageInfo"> 796 <tr> 797 <th scope="row label">{$addinfophotos.AIPWORDING}</th> 798 <td class="value">{$addinfophotos.AIPDATA}</td> 799 </tr> 800 </div> 744 801 {/if} 745 802 {/foreach} … … 943 1000 }); 944 1001 {/footer_script} 1002 {else if $addinfophotos.AIPWORDING == \'ID\'} 1003 <li id="ImageId" class="imageInfo"> 1004 <dt>{\'Image id\'|@translate}</dt> 1005 <dd>{$addinfophotos.AIPDATA}</dd> 1006 </li> 1007 {else if $addinfophotos.AIPWORDING == \'addedby\'} 1008 <li id="pab1" class="imageInfo"> 1009 <dt>{\'Photo added by\'|@translate}</dt> 1010 <dd>{$PAB}</dd> 1011 </li> 1012 {else if $addinfophotos.AIPWORDING == \'Download Counter\'} 1013 <li id="DownloadCounter" class="imageInfo"> 1014 <dt>{\'Downloads\'|@translate}</dt> 1015 <dd>{$DOWNLOAD_COUNTER}</dd> 1016 </li> 945 1017 {else if $addinfophotos.AIPDATA} 946 1018 <li id="add_info" class="imageInfo"> -
extensions/manage_properties_photos/language/en_UK/plugin.lang.php
r32161 r32180 36 36 $lang['delete data this property'] = 'delete data this property'; 37 37 $lang['Choose a property'] = 'Choose a property'; 38 39 38 $lang['Text'] = 'Text'; 40 39 $lang['select'] = 'select'; … … 43 42 $lang['radio'] = 'radio'; 44 43 $lang['IPTC'] = 'IPTC'; 45 46 44 $lang['Option List'] = 'Option List'; 47 45 $lang['Add Field'] = 'Add Field'; … … 58 56 $lang['exif field can\'t be empty'] = 'exif field can\'t be empty'; 59 57 $lang['IPTC field can\'t be empty'] = 'IPTC field can\'t be empty'; 58 $lang['Show Image Id'] = 'Show Image Id'; 59 $lang['Hide Image Id'] = 'Hide Image Id'; -
extensions/manage_properties_photos/language/fr_FR/plugin.lang.php
r32161 r32180 34 34 $lang['delete data this property'] = 'supprimer des données de la propriété'; 35 35 $lang['Choose a property'] = 'Choisir une propriété'; 36 37 36 $lang['Text'] = 'Text'; 38 37 $lang['select'] = 'select'; … … 41 40 $lang['radio'] = 'radio'; 42 41 $lang['IPTC'] = 'IPTC'; 43 44 42 $lang['Option List'] = 'Liste des options'; 45 43 $lang['Add Field'] = 'Ajouter un champs'; … … 56 54 $lang['exif field can\'t be empty'] = 'le champ exif ne peux pas être vide'; 57 55 $lang['IPTC field can\'t be empty'] = 'le champ IPTC ne peux pas être vide'; 56 $lang['Show Image Id'] = 'Montrer l\'ID de l\'Image'; 57 $lang['Hide Image Id'] = 'Cacher l\'ID de l\'Image'; -
extensions/manage_properties_photos/maintain.class.php
r32161 r32180 29 29 4 : properties select 30 30 5 : properties radio 31 6 : properties IPTC 31 32 32 33 $conf['mpp_idexif'] ** picture id for list exif … … 118 119 119 120 function update($old_version, $new_version, &$errors=array()){ 120 global $prefixeTable;121 if (!defined('ADD_PROP_PHOTO_TABLE')) define('ADD_PROP_PHOTO_TABLE', $prefixeTable.'add_properties_photos');121 global $prefixeTable, $pwg_loaded_plugins; 122 if (!defined('ADD_PROP_PHOTO_TABLE')) define('ADD_PROP_PHOTO_TABLE', $prefixeTable.'add_properties_photos'); 122 123 /*Update to manage Typ select date*/ 123 124 $col = pwg_db_fetch_assoc(pwg_query("SHOW COLUMNS FROM " . ADD_PROP_PHOTO_TABLE . " LIKE 'Typ';")); 124 125 if ($col == NULL){ 125 $q = 'ALTER TABLE '. ADD_PROP_PHOTO_TABLE.' ADD COLUMN `Typ` SMALLINT(5) DEFAULT 1;'; 126 pwg_query($q); 127 $q = 'ALTER TABLE '. ADD_PROP_PHOTO_TABLE.' ADD COLUMN `dataprop` LONGTEXT;'; 128 pwg_query($q); 129 $q = 'UPDATE '. ADD_PROP_PHOTO_TABLE.' set Typ = 0 where edit =0;'; 130 pwg_query($q); 126 pwg_query('ALTER TABLE '. ADD_PROP_PHOTO_TABLE.' ADD COLUMN `Typ` SMALLINT(5) DEFAULT 1;'); 127 pwg_query('ALTER TABLE '. ADD_PROP_PHOTO_TABLE.' ADD COLUMN `dataprop` LONGTEXT;'); 128 pwg_query('UPDATE '. ADD_PROP_PHOTO_TABLE.' set Typ = 0 where edit =0;'); 131 129 } 132 130 … … 142 140 $result = pwg_query($query); 143 141 } 144 145 142 } 146 143
Note: See TracChangeset
for help on using the changeset viewer.