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] and change the php file to:

PHP Code:

<?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.

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 Code:

<?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!

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