[30631] | 1 | <?php |
---|
[30702] | 2 | /*picture*/ |
---|
[30631] | 3 | function tab_add_info_one_photo($id_img){ |
---|
| 4 | $query = ' |
---|
[30702] | 5 | SELECT aip.id_prop_pho,aip.wording,aipd.data,aip.orderprop |
---|
| 6 | FROM ' . ADD_PROP_PHOTO_TABLE . ' AS aip |
---|
| 7 | LEFT JOIN ' . ADD_PROP_PHOTO_DATA_TABLE . ' AS aipd ON aip.id_prop_pho=aipd.id_prop_pho |
---|
[30631] | 8 | WHERE aipd.id_img = \'' . $id_img . '\' |
---|
| 9 | AND aip.active = 0 |
---|
[30702] | 10 | ORDER BY aip.orderprop ASC |
---|
[30631] | 11 | ;'; |
---|
| 12 | |
---|
| 13 | return pwg_query($query); |
---|
| 14 | } |
---|
[30702] | 15 | /* |
---|
[30631] | 16 | function tab_add_info_one_photo2($id_img){ |
---|
| 17 | $query = ' |
---|
[30702] | 18 | SELECT aip.id_prop_pho,aip.wording,aipd.data,aip.orderprop |
---|
| 19 | FROM ' . ADD_PROP_PHOTO_DATA_TABLE . ' AS aipd |
---|
| 20 | RIGHT JOIN ' . ADD_PROP_PHOTO_TABLE . ' AS aip ON aip.id_prop_pho=aipd.id_prop_pho |
---|
[30631] | 21 | WHERE aipd.id_img = \'' . $id_img . '\' |
---|
| 22 | AND aip.active = 0 |
---|
[30702] | 23 | ORDER BY aip.orderprop ASC |
---|
[30631] | 24 | ;'; |
---|
| 25 | |
---|
| 26 | return pwg_query($query); |
---|
| 27 | } |
---|
[30702] | 28 | */ |
---|
| 29 | /*Admin*/ |
---|
[30631] | 30 | function tab_add_info_by_photo(){ |
---|
| 31 | $query = ' |
---|
[30702] | 32 | SELECT id_prop_pho,wording |
---|
| 33 | FROM ' . ADD_PROP_PHOTO_TABLE . ' |
---|
[30631] | 34 | WHERE active = 0 |
---|
| 35 | AND edit = 1 |
---|
[30702] | 36 | ORDER BY orderprop ASC |
---|
[30631] | 37 | ;'; |
---|
| 38 | return pwg_query($query); |
---|
| 39 | } |
---|
| 40 | |
---|
[30702] | 41 | |
---|
| 42 | /*initpicture*/ |
---|
[30631] | 43 | function tab_add_info_by_photo_show(){ |
---|
| 44 | $query = ' |
---|
[30702] | 45 | SELECT id_prop_pho,wording,orderprop |
---|
| 46 | FROM ' . ADD_PROP_PHOTO_TABLE . ' |
---|
[30631] | 47 | WHERE active = 0 |
---|
[30702] | 48 | ORDER BY orderprop ASC |
---|
[30631] | 49 | ;'; |
---|
| 50 | return pwg_query($query); |
---|
| 51 | } |
---|
| 52 | |
---|
[30702] | 53 | /*initpicture et admin*/ |
---|
| 54 | function data_info_photos($id_img=null,$id_prop_pho=NULL){ |
---|
[30631] | 55 | $query = ' |
---|
| 56 | SELECT data |
---|
[30702] | 57 | FROM ' . ADD_PROP_PHOTO_DATA_TABLE; |
---|
[30631] | 58 | $wa='WHERE'; |
---|
| 59 | if($id_img!=null){ |
---|
| 60 | $query .=' '.$wa.' id_img='.$id_img;$wa='AND'; |
---|
| 61 | } |
---|
[30702] | 62 | if($id_prop_pho!=null){ |
---|
| 63 | $query .=' '.$wa.' id_prop_pho='.$id_prop_pho;$wa='AND'; |
---|
[30631] | 64 | } |
---|
| 65 | $query .= ';'; |
---|
| 66 | return pwg_query($query); |
---|
| 67 | } |
---|
| 68 | |
---|
[30702] | 69 | /*Admin*/ |
---|
| 70 | function tab_info_photos($id_prop_pho=NULL){ |
---|
[30631] | 71 | $query = ' |
---|
[30702] | 72 | SELECT id_prop_pho,wording,orderprop,active,edit |
---|
| 73 | FROM ' . ADD_PROP_PHOTO_TABLE; |
---|
| 74 | if($id_prop_pho!=null){ |
---|
| 75 | $query .= ' WHERE id_prop_pho='.$id_prop_pho; |
---|
[30631] | 76 | } |
---|
| 77 | |
---|
[30702] | 78 | $query .= ' ORDER BY orderprop ASC |
---|
[30631] | 79 | ;'; |
---|
| 80 | return pwg_query($query); |
---|
| 81 | } |
---|
| 82 | |
---|
| 83 | ?> |
---|