[Harald_T]

O.k., i've got it so far, but at the moment not as a seperate modul. This will come, i'll promise.

In your template "adv_portal" find:

$navbar

after this insert:

<if condition="$vboptions['show_latest']==1">
<table class="tborder" align="center" width=99%">
<tr>
<td colspan=$gal_num_rows>
Latest pictures in the gallery:
</td>
</tr>
<tr>
$latestgallery
</tr>
</table>
<br />
</if>


<if condition="$vboptions['show_random']==1">
<table class="tborder" align="center" width="99%">
<tr>
<td colspan=$gal_num_rows>
Random Pictures from the gallery</td>
</tr>
<tr>
$random_gallery
</tr>
</table>
<br />
</if>

Now, in your /includes/vba_cmps_include_bottom.php find:

eval('print_output("' . fetch_template('adv_portal') . '");');

before this insert:

// #################### Latest Gallery-Additions #######################
// fetch the permissions for each forum
// global $vbulletin;
$gal_num_rows = $vbulletin->options['gal_num_rows'];


$thumbs = $db->query_read("SELECT gallery, threadid, firstpostid, ". TABLE_PREFIX . "thread.title, attachmentid, ". TABLE_PREFIX . "attachment.dateline FROM ". TABLE_PREFIX . "attachment, ". TABLE_PREFIX . "thread, ". TABLE_PREFIX . "forum
WHERE gallery='1' AND ". TABLE_PREFIX . "thread.forumid=". TABLE_PREFIX . "forum.forumid AND ". TABLE_PREFIX . "thread.firstpostid = ". TABLE_PREFIX . "attachment.postid AND ". TABLE_PREFIX . "attachment.dateline < " . TIME() ." ORDER BY ". TABLE_PREFIX . "attachment.dateline DESC LIMIT $gal_num_rows");

while ($gallery = $db->fetch_array($thumbs))
{
eval('$latestgallery .= "' . fetch_template('latestgallery') . '";');
}

// #################### Random Gallery-Pictures #######################
// fetch the permissions for each forum

$random_thumbs = $db->query_read("SELECT gallery, threadid, firstpostid, ". TABLE_PREFIX . "thread.title, attachmentid, ". TABLE_PREFIX . "attachment.dateline FROM ". TABLE_PREFIX . "attachment, ". TABLE_PREFIX . "thread, ". TABLE_PREFIX . "forum
WHERE gallery='1' AND ". TABLE_PREFIX . "thread.forumid=". TABLE_PREFIX . "forum.forumid AND ". TABLE_PREFIX . "thread.firstpostid = ". TABLE_PREFIX . "attachment.postid AND ". TABLE_PREFIX . "attachment.dateline < " . TIME() ." ORDER BY RAND() LIMIT $gal_num_rows");

while ($rand_gallery = $db->fetch_array($random_thumbs))
{
eval('$random_gallery .= "' . fetch_template('random_gallery') . '";');
}

// ##################### End Gallery-Modification ########################

Now it should work.