<%=$I_administration%>

<%@ $Language=JScript /* PARA COLORES PHP */ %><% include("../includes/DB_Conectar.php"); /*toma la seguridad de la página imagenes_borrar.php*/ $admABMLink_manual="imagenes_borrar.php"; include("../includes/inc_auth.php"); include("../includes/funciones.php"); switch($tipo){ case 'F': $titulo = $I_associateimages; $err1 = $I_images; $col1 = $I_image; break; case 'A': $titulo = $I_associateaudio; $err1 = $I_audio; $col1 = $I_audio; break; case 'V': $titulo =$I_associatevideo; $err1 = $I_videos; $col1 = $I_video; break; case 'D': $titulo = $I_associatedocuments; $err1 = $I_documents; $col1 = $I_document; break; case 'Z': $titulo = $I_associatecompressedfiles; $err1 = $I_files; $col1 = $I_file; break; } /*Desvinculo elemento*/ if($adrOrden && $adrID && $accion=="desvincular") { //Reordeno los vinculados $sql="select max(adrOrden) as max from ADVF_Vinculante where tabID='$tabID' and fgnID='$accID'"; $rsmax=$conn->execute($sql); $max=$rsmax->field(max); do{ $sql="update ADVF_Vinculante set adrOrden=adrOrden-1 where tabID='$tabID' and fgnID='$accID' and adrOrden='$adrOrden'+1"; //echo $sql."
"; $max--; $adrOrden++; $conn->execute($sql); }while($max>0); $sql="delete from ADVF_Vinculante where adrID='$adrID'"; $delete=$conn->execute($sql); %> <% } /*Subo elemento*/ if($adrID && $adrOrden && $accion=="subir") { $sql="update ADVF_Vinculante set adrOrden=adrOrden-1 where tabID='$tabID' and fgnID='$accID' and adrOrden='$adrOrden'+1"; $update=$conn->execute($sql); $sql="update ADVF_Vinculante set adrOrden='$adrOrden'+1 where adrID='$adrID'"; $update=$conn->execute($sql); } /*Bajo elemento*/ if($adrID && $adrOrden && $accion=="bajar") { $sql="update ADVF_Vinculante set adrOrden=adrOrden+1 where tabID='$tabID' and fgnID='$accID' and adrOrden='$adrOrden'-1"; $update=$conn->execute($sql); $sql="update ADVF_Vinculante set adrOrden='$adrOrden'-1 where adrID='$adrID'"; $update=$conn->execute($sql); } %> <%=$I_administration%>

<% //aca listo los elementos asociados /*if(!$order || $order=="advFecha"){$order="advFecha desc";} if($order=="adrOrden"){$order="adrOrden desc";}*/ $sqelem = "select A.advID,A.advTitulo,OP.usradUsuario, CAT.catNombre,A.advFecha,A.advLink,B.adrID,B.adrOrden from ADVF A,segUsuariosAdmin OP,ADVF_Categorias CAT, ADVF_Vinculante B where B.tabID='$tabID' and B.fgnID='$accID' and A.advID=B.advID and A.advTipo='$tipo' and A.advAutor=OP.usradID and A.catID=CAT.catID and B.adrOrden!='0' order by adrOrden desc"; //echo "$sqelem"; $rselem = $conn->execute($sqelem); $cantidad=$rselem->numrows; if(!$rselem) { showError("Error XM32660","javascript: window.history.back()","Back",1); } if($rselem->numrows) { %> <% $color="#eeefff"; while(!$rselem->eof) { %> > <% if($color=="#eeefff"){$color="#dcdcee";} else if($color=="#dcdcee"){$color="#eeefff";} $rselem->movenext(); } %>

<%=$col1%>	<%=$I_category%>	<%=$I_author%>	<%=$I_date%>
<%=ver_Icono($rselem->field(advLink))%> <%if($tipo!='F'){%><%=$rselem->field(advTitulo)%><%}else{%><%=$rselem->field(advTitulo)%><%}%>	<%=$rselem->field(catNombre);%>	<%=$rselem->field(usradUsuario);%>	<%=verFecha($rselem->field(advFecha));%>	<%if($cantidad>1 && $rselem->field(adrOrden)<$cantidad){%> <% }else{echo " ";} if($cantidad>1 && $rselem->field(adrOrden)>1){ %> <%}else{echo " ";}%>

<%}else{%>

<%=$I_therearenotassociated%> <%=$err1%>

<%}%>