Código PHP:
Ver original
<?php $sql_select_folders_public = "SELECT f_NAME FROM FOLDERS WHERE IUID = '".$_SESSION['iuid']."'"; if($_GET['index'] == "images" && $_GET['folder'] == "public" && $_GET['set'] == $images_folder_public['F_NAME']) { //MOSTRAR IMAGENES DENTRO DE CARPETAS PUBLICAS $winderjester = "SELECT * FROM IMAGES I INNER JOIN THUMBNAILS T ON I.ID = T.ID INNER JOIN FOLDERS F ON I.ID_FOLDER = F.ID_FOLDER WHERE F.F_NAME = '".$images_folder_public['F_NAME']."' AND F.PARENT = 'PUBLIC' AND I.IUID = '".$_SESSION['iuid']."'"; echo '<div class="more-upload">'."\n"; echo '<div class="options-thumbnails">'."\n"; echo '<a href="http://web.com/preview.php?id='.$hjtm['ID'].'" target="_blank"><div class="options-preview"></div></a>'."\n"; echo '<a href="#"><div class="options-share"></div></a>'."\n"; echo '<a href="http://web.com/web/functions/private.php?id='.$hjtm['ID'].'"><div class="options-private"></div></a>'."\n"; echo '<a href="http://web.com/web/functions/delete.php?id='.$hjtm['ID'].'&pin='.$hjtm['PIN'].'"><div class="options-delete"></div></a>'."\n"; echo '</div>'."\n"; echo '<div class="thumbnail"><img src="'.$hjtm['SQUARE_75'].'" height="75" width="75"></div>'."\n"; echo '</div>'."\n\n"; } } elseif($_GET['index'] == "images" && $_GET['folder'] == "private" && $_GET['set'] == $images_folder_public['F_NAME']) { //MOSTRAR IMAGENES DENTRO DE CARPETAS PRIVADAS $winderjester2 = "SELECT * FROM IMAGES I INNER JOIN THUMBNAILS T ON I.ID = T.ID INNER JOIN FOLDERS F ON I.ID_FOLDER = F.ID_FOLDER WHERE F.F_NAME = '".$images_folder_public['F_NAME']."' AND F.PARENT = 'PRIVATE' AND I.IUID = '".$_SESSION['iuid']."'"; echo '<div class="more-upload">'."\n"; echo '<div class="options-thumbnails">'."\n"; echo '<a href="http://web.com/preview.php?id='.$hjtm2['ID'].'" target="_blank"><div class="options-preview"></div></a>'."\n"; echo '<a href="#"><div class="options-share"></div></a>'."\n"; echo '<a href="http://web.com/web/functions/private.php?id='.$hjtm2['ID'].'"><div class="options-private"></div></a>'."\n"; echo '<a href="http://web.com/web/functions/delete.php?id='.$hjtm2['ID'].'&pin='.$hjtm2['PIN'].'"><div class="options-delete"></div></a>'."\n"; echo '</div>'."\n"; echo '<div class="thumbnail"><img src="'.$hjtm2['SQUARE_75'].'" height="75" width="75"></div>'."\n"; echo '</div>'."\n\n"; } } elseif($_GET['index'] == "images" && $_GET['folder'] == "private") { //MOSTRAR CARPETAS PRIVADAS $sql_folders_private = "SELECT * FROM FOLDERS WHERE IUID = '".$_SESSION['iuid']."' AND PARENT = 'PRIVATE'"; } else { $name_folder_private = $folder_private['F_NAME']; } echo '<div class="more-upload" style="padding-top: 0; padding-bottom: 0; height: 103px;padding: 0;width: 103px;text-align: center;">'."\n"; echo '<a href="?index=images&folder='.$folder_private['F_NAME'].'" title="'.$folder_private['F_NAME'].'">'."\n"; echo '<img src="images/folder.png" height="75" width="75">'."\n"; echo '<div style="text-align: center; line-height: 0;font-size: 12px;">'.$name_folder_private.'</div>'."\n"; echo '</a>'."\n"; echo '</div>'."\n\n"; } //MOSTRAR IMAGENES PRIVADAS $sql_private = "SELECT * FROM IMAGES I INNER JOIN THUMBNAILS T ON I.ID = T.ID WHERE IUID = '".$_SESSION['iuid']."' AND I.ID IN(SELECT * FROM PRIVATE) ORDER BY DATE DESC"; echo "<div class=\"more-upload\"><a href=\"http://web.com/preview.php?id=".$private['ID']."\"><img src=\"".$private['SQUARE_75']."\" height=\"75\" width=\"75\"></a></div>\n"; } } elseif($_GET['index'] == "images") { $sql_more = "SELECT * FROM IMAGES I INNER JOIN THUMBNAILS T ON I.ID = T.ID WHERE IUID = '".$_SESSION['iuid']."' AND ID_FOLDER = '' AND I.ID NOT IN(SELECT * FROM PRIVATE) ORDER BY ".$row_pref['SORT_BY']." + 0 ".$row_pref['ORDER_BY'].""; //MOSTRAR ENLACE CARPETA PRIVADA echo '<div class="more-upload" style="padding-top: 0; padding-bottom: 0; height: 103px;padding: 0;width: 103px;text-align: center;">'."\n"; echo '<a href="?index=images&folder=private" title="Private">'."\n"; echo '<img src="images/private-folder.png" height="75" width="75">'."\n"; echo '<div style="text-align: center; line-height: 0;font-size: 12px;">Private</div>'."\n"; echo '</a>'."\n"; echo '</div>'."\n\n"; //MOSTRAR CARPETAS PUBLICAS $sql_folders_public = "SELECT * FROM FOLDERS WHERE IUID = '".$_SESSION['iuid']."' AND PARENT = 'PUBLIC'"; } else { $name_folder_public = $folder_public['F_NAME']; } echo '<div class="more-upload" style="padding-top: 0; padding-bottom: 0; height: 103px;padding: 0;width: 103px;text-align: center;">'."\n"; echo '<a href="?index=images&folder=public&set='.$folder_public['F_NAME'].'" title="'.$folder_public['F_NAME'].'">'."\n"; echo '<img src="images/folder.png" height="75" width="75">'."\n"; echo '<div style="text-align: center; line-height: 0;font-size: 12px;">'.$name_folder_public.'</div>'."\n"; echo '</a>'."\n"; echo '</div>'."\n\n"; } //MOSTRAR IMAGENES PUBLICAS echo '<div class="more-upload">'."\n"; echo '<div class="options-thumbnails">'."\n"; echo '<a href="http://web.com/preview.php?id='.$more['ID'].'" target="_blank"><div class="options-preview"></div></a>'."\n"; echo '<a href="#"><div class="options-share"></div></a>'."\n"; echo '<a href="http://web.com/web/functions/private.php?id='.$more['ID'].'"><div class="options-private"></div></a>'."\n"; echo '<a href="http://web.com/web/functions/delete.php?id='.$more['ID'].'&pin='.$more['PIN'].'"><div class="options-delete"></div></a>'."\n"; echo '</div>'."\n"; echo '<div class="thumbnail"><img src="'.$more['SQUARE_75'].'" height="75" width="75"></div>'."\n"; echo '</div>'."\n\n"; } } ?>
El código funciona a la mitad porque muestra todas las imágenes y las carpetas publicas y también las carpetas e imágenes privadas, y si se accede a la primera carpeta publica creada muestra las imágenes de esa carpeta, pero si se quiere ver las demás carpetas publicas muestra todas las imágenes y carpetas publicas creadas.
Alguien que me puede ayudar a resolver este problema?
Saludos y gracias de antemano