Help with "latest" modification (simple php and template question)

[Scandal]

Well, I have the Mindestic GlosPro (glossary modification) on my site.
I want to make an vBa CMPS module with the latest 10 glossary terms.
I use the Random Glossary Term [vBa CMPS module] (https://vborg.vbsupport.ru/showthread.php?t=111900) and change the php file to:
<?php

if (($permissions['glossarypermissions'] & $vbulletin->bf_ugp_glossarypermissions['canviewglossary']) AND $vbulletin->options['vbglossaryactive'])
{
$glossary_module_content = '';

$glossary_content_query = $db->query_read("SELECT glossaryid, glossaryname
FROM " . TABLE_PREFIX . "glossary
WHERE glossaryvalid = 1
ORDER BY glossaryid DESC
LIMIT 10
");

$glossary_content_fetcharray = $db->fetch_array($glossary_content_query);

$glossary_module_term_id = $glossary_content_fetcharray['glossaryid'];
$glossary_module_term_name = $glossary_content_fetcharray['glossaryname'];

$db->free_result($glossary_content_query);
}

eval('$home[$mods[\'modid\']][\'content\'] .= "' . fetch_template('adv_portal_glossary_random_term') . '";');

?>
I change the lines to:
ORDER BY glossaryid DESC
LIMIT 10

...and with the template:
<tr>
<td class="alt1">
<div align="center">
<a href="$vboptions[bburl]/glossary.php?$session[sessionurl]do=viewglossary&amp;term=$glossary_module_term_id"><img src="$vboptions[bburl]/images/question-mark.gif" border="0" alt="$vbphrase[glossary]" title="$glossary_module_term_name" /></a>
<br /><a href="$vboptions[bburl]/glossary.php?$session[sessionurl]do=viewglossary&amp;term=$glossary_module_term_id"><strong>$glossary_module_term_name</strong></a>
</div>
</td>
</tr>
<tr>
<td class="alt2">
<div align="center">
<span class="smallfont"><a href="$vboptions[bburl]/glossary.php?$session[sessionurl]">[$vbphrase[glossary]]</a></span>
</div>
</td>
</tr>
I have the latest ONE glossary term.
http://img37.imageshack.us/img37/9494/screenshottg.gif
What to do, to achieve the viewing of the latest 10 glossary terms? :up:

Thanks!
-peter

[kh99]

I think I would first make a template to format one glossary term, maybe call it adv_portal_glossary_termbit, something like

<a href="$vboptions[bburl]/glossary.php?$session[sessionurl]do=viewglossary&amp;term=$glossary_module_term_id"><strong>$glossary_module_term_name</strong></a><BR />



Next change the existing template to something like:

<tr>
<td class="alt1">
<div align="center">
$termbits
</div>
</td>
</tr>
<tr>
<td class="alt2">
<div align="center">
<span class="smallfont"><a href="$vboptions[bburl]/glossary.php?$session[sessionurl]">[$vbphrase[glossary]]</a></span>
</div>
</td>
</tr>



and finally, add a loop to the php to build $termbits, like:

<?php

if (($permissions['glossarypermissions'] & $vbulletin->bf_ugp_glossarypermissions['canviewglossary']) AND $vbulletin->options['vbglossaryactive'])
{
$glossary_module_content = '';

$glossary_content_query = $db->query_read("SELECT glossaryid, glossaryname
FROM " . TABLE_PREFIX . "glossary
WHERE glossaryvalid = 1
ORDER BY glossaryid DESC
LIMIT 10
");

while ($glossary_content_fetcharray = $db->fetch_array($glossary_content_query))
{
$glossary_module_term_id = $glossary_content_fetcharray['glossaryid'];
$glossary_module_term_name = $glossary_content_fetcharray['glossaryname'];
eval('$termbits .= "' . fetch_template('adv_portal_glossary_termbit') . '";');
}
$db->free_result($glossary_content_query);
}

eval('$home[$mods[\'modid\']][\'content\'] .= "' . fetch_template('adv_portal_glossary_random_term') . '";');

?>


(I haven't tried this at all so there may be errors).

[Scandal]

Thank you very much kh99, it works fine! :D

edit: hmm, on my localhost test forum it works fine. When I try to install on my site I have the error
Error 330 (net::ERR_CONTENT_DECODING_FAILED) to chrome and
"The page you are trying to view cannot be shown because it uses an invalid or unsupported form of compression.
* Please contact the website owners to inform them of this problem." to firefox....

... and the page is not accessable!
I try with firefox, chrome and opera and I get decoding failed error... :(

Sorry for my bad english...

edit2: I turn off the GZIP HTML Output, and the problem solved! ;)

-petros