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

<?php 
/*picture*/
function tab_add_info_one_photo($id_img){
$query = '
    SELECT aip.id_prop_pho,aip.wording,aipd.data,aip.orderprop
    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
    WHERE aipd.id_img = \'' . $id_img . '\' 
    AND aip.active = 0 
    ORDER BY aip.orderprop ASC
    ;';

return pwg_query($query);
}
/*
function tab_add_info_one_photo2($id_img){
$query = '
    SELECT aip.id_prop_pho,aip.wording,aipd.data,aip.orderprop
    FROM ' . ADD_PROP_PHOTO_DATA_TABLE . ' AS aipd
    RIGHT JOIN ' . ADD_PROP_PHOTO_TABLE . ' AS aip ON aip.id_prop_pho=aipd.id_prop_pho
    WHERE aipd.id_img = \'' . $id_img . '\' 
    AND aip.active = 0 
    ORDER BY aip.orderprop ASC
    ;';

return pwg_query($query);
}
*/
/*Admin*/
function tab_add_info_by_photo(){
$query = '
    SELECT id_prop_pho,wording
    FROM ' . ADD_PROP_PHOTO_TABLE . ' 
    WHERE active = 0 
    AND edit = 1 
    ORDER BY orderprop ASC
    ;';
return pwg_query($query);
}


/*initpicture*/
function tab_add_info_by_photo_show(){
$query = '
    SELECT id_prop_pho,wording,orderprop
    FROM ' . ADD_PROP_PHOTO_TABLE . ' 
    WHERE active = 0 
    ORDER BY orderprop ASC
    ;';
return pwg_query($query);
}

/*initpicture et admin*/
function data_info_photos($id_img=null,$id_prop_pho=NULL){
$query = '
    SELECT data
    FROM ' . ADD_PROP_PHOTO_DATA_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
    FROM ' . ADD_PROP_PHOTO_TABLE;
    if($id_prop_pho!=null){
        $query .= ' WHERE id_prop_pho='.$id_prop_pho;
    }

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

?>