source: extensions/manage_properties_photos/include/function.aip.inc.php @ 30701

<?php 
function tab_add_info_one_photo($id_img){
$query = '
    SELECT aip.id_info_pho,aip.designation,aipd.data,aip.orderinfo
    FROM ' . ADD_INFO_PHOTO_TABLE . ' AS aip
    LEFT JOIN ' . ADD_INFO_PHOTO_DATA_TABLE . ' AS aipd ON aip.id_info_pho=aipd.id_info_pho
    WHERE aipd.id_img = \'' . $id_img . '\' 
    AND aip.active = 0 
    ORDER BY aip.orderinfo ASC
    ;';

return pwg_query($query);
}

function tab_add_info_one_photo2($id_img){
$query = '
    SELECT aip.id_info_pho,aip.designation,aipd.data,aip.orderinfo
    FROM ' . ADD_INFO_PHOTO_DATA_TABLE . ' AS aipd
    RIGHT JOIN ' . ADD_INFO_PHOTO_TABLE . ' AS aip ON aip.id_info_pho=aipd.id_info_pho
    WHERE aipd.id_img = \'' . $id_img . '\' 
    AND aip.active = 0 
    ORDER BY aip.orderinfo ASC
    ;';

return pwg_query($query);
}

function tab_add_info_by_photo(){
$query = '
    SELECT id_info_pho,designation
    FROM ' . ADD_INFO_PHOTO_TABLE . ' 
    WHERE active = 0 
    AND edit = 1 
    ORDER BY orderinfo ASC
    ;';
return pwg_query($query);
}

function tab_add_info_by_photo_show(){
$query = '
    SELECT id_info_pho,designation,orderinfo
    FROM ' . ADD_INFO_PHOTO_TABLE . ' 
    WHERE active = 0 
    ORDER BY orderinfo ASC
    ;';
return pwg_query($query);
}

function data_info_photos($id_img=null,$id_info_pho=NULL){
$query = '
    SELECT data
    FROM ' . ADD_INFO_PHOTO_DATA_TABLE;
    $wa='WHERE';
    if($id_img!=null){
        $query .=' '.$wa.' id_img='.$id_img;$wa='AND';
    }
    if($id_info_pho!=null){
        $query .=' '.$wa.' id_info_pho='.$id_info_pho;$wa='AND';
    }
$query .= ';';
return pwg_query($query);
}


function tab_info_photos($id_info_pho=NULL){
$query = '
    SELECT id_info_pho,designation,orderinfo,active,edit
    FROM ' . ADD_INFO_PHOTO_TABLE;
    if($id_info_pho!=null){
        $query .= ' WHERE id_info_pho='.$id_info_pho;
    }

$query .= ' ORDER BY orderinfo ASC
    ;';
return pwg_query($query);
}

?>