get_results("SELECT t.*, tt.* FROM $wpdb->nggallery AS t INNER JOIN $wpdb->nggpictures AS tt ON t.gid = tt.galleryid WHERE tt.exclude != 1 ORDER BY tt.{$ngg_options['galSort']} {$ngg_options['galSortDir']} "); } else { $thepictures = $wpdb->get_results("SELECT t.*, tt.* FROM $wpdb->nggallery AS t INNER JOIN $wpdb->nggpictures AS tt ON t.gid = tt.galleryid WHERE t.gid = '$galleryID' AND tt.exclude != 1 ORDER BY tt.{$ngg_options['galSort']} {$ngg_options['galSortDir']} "); } // Create XML output header("content-type:text/xml;charset=utf-8"); echo "\n"; echo " \n"; echo " \n"; if (is_array ($thepictures)){ foreach ($thepictures as $picture) { echo " \n"; if (!empty($picture->description)) echo " \n"; else if (!empty($picture->alttext)) echo " \n"; else echo " \n"; echo " ".$siteurl."/".$picture->path."/".$picture->filename."\n"; echo " \n"; } } echo " \n"; echo "\n"; ?>