function loadCurrentImage($pCurrentImageId)
{
if ($this->isValid() && @$this->verifyId($pCurrentImageId)) {
// this code sucks but works - XOXO spiderr
$query = "SELECT fgim.*, fi.`image_id`, lf.`file_name`, lf.`user_id`, lf.`mime_type`, la.`attachment_id`\n\t\t\t\t\tFROM `" . BIT_DB_PREFIX . "fisheye_gallery_image_map` fgim\n\t\t\t\t\t\tINNER JOIN `" . BIT_DB_PREFIX . "fisheye_image` fi ON ( fi.`content_id`=fgim.`item_content_id` )\n\t\t\t\t\t\tINNER JOIN `" . BIT_DB_PREFIX . "liberty_attachments` la ON ( fi.`content_id`=la.`content_id` )\n\t\t\t\t\t\tINNER JOIN `" . BIT_DB_PREFIX . "liberty_files` lf ON ( lf.`file_id`=la.`foreign_id` )\n\t\t\t\t\tWHERE fgim.`gallery_content_id` = ?\n\t\t\t\t\tORDER BY fgim.`item_position`, fi.`content_id` ";
if ($rs = $this->mDb->query($query, array($this->mContentId))) {
$tempImage = new FisheyeImage();
$rows = $rs->getRows();
for ($i = 0; $i < count($rows); $i++) {
if ($rows[$i]['image_id'] == $pCurrentImageId) {
if ($i > 0) {
$this->mInfo['previous_image_id'] = $rows[$i - 1]['image_id'];
$this->mInfo['previous_image_avatar'] = liberty_fetch_thumbnail_url(array('file_name' => $rows[$i - 1]['file_name'], 'source_file' => $tempImage->getSourceFile($rows[$i - 1]), 'mime_image' => TRUE, 'size' => 'avatar'));
}
if ($i + 1 < count($rows)) {
$this->mInfo['next_image_id'] = $rows[$i + 1]['image_id'];
$this->mInfo['next_image_avatar'] = liberty_fetch_thumbnail_url(array('file_name' => $rows[$i + 1]['file_name'], 'source_file' => $tempImage->getSourceFile($rows[$i + 1]), 'mime_image' => TRUE, 'size' => 'avatar'));
}
}
}
}
}
}
