vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vB3 General Discussions (https://vborg.vbsupport.ru/forumdisplay.php?f=111)
-   -   Help with "latest" modification (simple php and template question) (https://vborg.vbsupport.ru/showthread.php?t=265011)

Scandal 06-10-2011 09:22 PM
Help with "latest" modification (simple php and template question)
 
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:
Code:
<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 06-11-2011 12:45 AM
I think I would first make a template to format one glossary term, maybe call it adv_portal_glossary_termbit, something like

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

HTML Code:
<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 06-11-2011 07:34 AM
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


All times are GMT. The time now is 02:10 AM.

Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.

X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.01020 seconds
  • Memory Usage 1,749KB
  • Queries Executed 10 (?)
More Information
Template Usage:
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (1)bbcode_code_printable
  • (2)bbcode_html_printable
  • (2)bbcode_php_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (3)printthreadbit
  • (1)spacer_close
  • (1)spacer_open 
Phrase Groups Available:
  • global
  • postbit
  • showthread
Included Files:
  • ./printthread.php
  • ./global.php
  • ./includes/init.php
  • ./includes/class_core.php
  • ./includes/config.php
  • ./includes/functions.php
  • ./includes/class_hook.php
  • ./includes/modsystem_functions.php
  • ./includes/class_bbcode_alt.php
  • ./includes/class_bbcode.php
  • ./includes/functions_bigthree.php 
Hooks Called:
  • init_startup
  • init_startup_session_setup_start
  • init_startup_session_setup_complete
  • cache_permissions
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • printthread_start
  • bbcode_fetch_tags
  • bbcode_create
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • printthread_post
  • printthread_complete