The Arcive of vBulletin Modifications Site.

AN-net · #1 07-01-2004, 02:51 PM

ok its getting all the information its susposed to but then its not displaying it

heres my code:

PHP Code:


			
            $getlatest= $DB_site->query("SELECT journal_entries.entrytitle,journal_entries.entrydate,journal_entries.entry_id,

            journal_entries.entrytext,journal_entries.journal_id,journals.journalist,journals.journalist_id 

            FROM ".TABLE_PREFIX."journal_entries 

            LEFT JOIN ".TABLE_PREFIX."journals ON (journal_entries.journal_id=journals.journal_id) 

            WHERE journal_entries.entry_active=1 AND journal_entries.private!=1 

            ORDER BY journal_entries.entrydate DESC

            ");

            $countlatest= $DB_site->num_rows($getlatest);

            if($countlatest>0)

            {

                while($latest= $DB_site->fetch_array($getlatest))

                {

                    $latestentrydate= vbdate($vboptions['dateformat'], $latest['entrydate'], 1);

                    $latestentrytime= vbdate($vboptions['timeformat'], $latest['entrydate']);

                    exec_switch_bg();

                    eval('$latestentrybits .= "' . fetch_template('journal_latestentrybits') . '";');

                }

            }

            else

            {

                $latestentrybits="There are no entries.";

            }

and

here is how it appears in the template:

HTML Code:

<table class="tborder" cellspacing="$stylevar[cellspacing]" cellpadding="$stylevar[cellpadding]" border="0" align="center" width="100%">
$latestentrybits
</table>

the table its self doesnt even show up

Zachery · #2 07-01-2004, 02:56 PM

Do you have a template journal_latestentrybits

?

AN-net · #3 07-01-2004, 03:24 PM

yes i do, here is what is in the template:

HTML Code:

<tr>
<td class="$bgclass"><div class="smallfont"><a href="journal.php?do=showentry&e=$latest[entry_id]&j=$lastest[journal_id]">$latesty[entrytitle]</a> - ($latestentrydate at $latestentrytime)<br /><span style="cursor:pointer" onclick="window.open('member.php?u=$latest[journalist_id]')">$latest[journalist]</span></div></td>
</tr>

Zachery · #4 07-01-2004, 03:30 PM

You do have a call to printout a template at the end of the file right ?

AN-net · #5 07-01-2004, 04:08 PM

yeah.

heres the entire block of code for that do:

PHP Code:


			
if($do=="showindex")

        {

            $fjournals= $DB_site->query("SELECT

             journals.journal_id,journals.journalname,journals.journaldesc,

            journals.journalist,journals.journalist_id,journals.lastentry,

            journals.lastentry_date,journals.lastentry_id,journals.journalviews,

            journals.journal_totalrating AS totalrating,journals.journal_totalvotes AS totalvotes,COUNT(journal_entries.entry_id) AS entries

             FROM ".TABLE_PREFIX."journals

            LEFT JOIN journal_entries 

            ON (journals.journal_id=journal_entries.journal_id AND entry_active=1) 

            WHERE journals.active='1'

            GROUP BY journals.journal_id

            ");

            $check= $DB_site->num_rows($fjournals);

            if($check=="0")

            {

                $journalbits= $vbphrase['journalnojournals'];

            }

            else

            {

                while($journal= $DB_site->fetch_array($fjournals))

                {

                    //$count= $DB_site->query_first("SELECT COUNT(*) AS entries FROM ".TABLE_PREFIX."journal_entries WHERE journal_id='".$journal['journal_id']."' AND entry_active='1'");

                    if(empty($journal['totalrating']) OR empty($journal['totalvotes']))

                    {

                    $rating= "0";

                    }

                    else

                    {

                        $calcrating= $journal['totalrating']/$journal['totalvotes'];

                        $rating= round($calcrating);

                    }

                    $lastedate= vbdate($vboptions['dateformat'], $journal['lastentry_date'], 1);

                    $lastetime= vbdate($vboptions['timeformat'], $journal['lastentry_date']);

                    exec_switch_bg();

                    eval('$journalbits .= "' . fetch_template('journal_journalbits') . '";');

                }

            }

            $getlatest= $DB_site->query("SELECT journal_entries.entrytitle,journal_entries.entrydate,journal_entries.entry_id,

            journal_entries.entrytext,journal_entries.journal_id,journals.journalist,journals.journalist_id 

            FROM ".TABLE_PREFIX."journal_entries 

            LEFT JOIN ".TABLE_PREFIX."journals ON (journal_entries.journal_id=journals.journal_id) 

            WHERE journal_entries.entry_active=1 AND journal_entries.private!=1 

            ORDER BY journal_entries.entrydate DESC

            ");

            $countlatest= $DB_site->num_rows($getlatest);

            if($countlatest>0)

            {

                while($latest= $DB_site->fetch_array($getlatest))

                {

                    $latestentrydate= vbdate($vboptions['dateformat'], $latest['entrydate'], 1);

                    $latestentrytime= vbdate($vboptions['timeformat'], $latest['entrydate']);

                    exec_switch_bg();

                    eval('$latestentrybits .= "' . fetch_template('journal_latestentrybits') . '";');

                }

            }

            else

            {

                $latestentrybits="There are no entries.";

            }

            eval('$navbar = "' . fetch_template('navbar') . '";');

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

        }

Zachery · #6 07-01-2004, 04:11 PM

Quote:

Originally Posted by AN-net

yeah.

heres the entire block of code for that do:

PHP Code:


			
if($do=="showindex")

        {

            $fjournals= $DB_site->query("SELECT

             journals.journal_id,journals.journalname,journals.journaldesc,

            journals.journalist,journals.journalist_id,journals.lastentry,

            journals.lastentry_date,journals.lastentry_id,journals.journalviews,

            journals.journal_totalrating AS totalrating,journals.journal_totalvotes AS totalvotes,COUNT(journal_entries.entry_id) AS entries

             FROM ".TABLE_PREFIX."journals

            LEFT JOIN journal_entries 

            ON (journals.journal_id=journal_entries.journal_id AND entry_active=1) 

            WHERE journals.active='1'

            GROUP BY journals.journal_id

            ");

            $check= $DB_site->num_rows($fjournals);

            if($check=="0")

            {

                $journalbits= $vbphrase['journalnojournals'];

            }

            else

            {

                while($journal= $DB_site->fetch_array($fjournals))

                {

                    //$count= $DB_site->query_first("SELECT COUNT(*) AS entries FROM ".TABLE_PREFIX."journal_entries WHERE journal_id='".$journal['journal_id']."' AND entry_active='1'");

                    if(empty($journal['totalrating']) OR empty($journal['totalvotes']))

                    {

                    $rating= "0";

                    }

                    else

                    {

                        $calcrating= $journal['totalrating']/$journal['totalvotes'];

                        $rating= round($calcrating);

                    }

                    $lastedate= vbdate($vboptions['dateformat'], $journal['lastentry_date'], 1);

                    $lastetime= vbdate($vboptions['timeformat'], $journal['lastentry_date']);

                    exec_switch_bg();

                    eval('$journalbits .= "' . fetch_template('journal_journalbits') . '";');

                }

            }

            $getlatest= $DB_site->query("SELECT journal_entries.entrytitle,journal_entries.entrydate,journal_entries.entry_id,

            journal_entries.entrytext,journal_entries.journal_id,journals.journalist,journals.journalist_id 

            FROM ".TABLE_PREFIX."journal_entries 

            LEFT JOIN ".TABLE_PREFIX."journals ON (journal_entries.journal_id=journals.journal_id) 

            WHERE journal_entries.entry_active=1 AND journal_entries.private!=1 

            ORDER BY journal_entries.entrydate DESC

            ");

            $countlatest= $DB_site->num_rows($getlatest);

            if($countlatest>0)

            {

                while($latest= $DB_site->fetch_array($getlatest))

                {

                    $latestentrydate= vbdate($vboptions['dateformat'], $latest['entrydate'], 1);

                    $latestentrytime= vbdate($vboptions['timeformat'], $latest['entrydate']);

                    exec_switch_bg();

                    eval('$latestentrybits .= "' . fetch_template('journal_latestentrybits') . '";');

                }

            }

            else

            {

                $latestentrybits="There are no entries.";

            }

            eval('$navbar = "' . fetch_template('navbar') . '";');

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

        }

This is for vB3?

where is $do defined?

try
if ($_REQUEST['do'] == 'showindex')

AN-net · #7 07-01-2004, 05:12 PM

yeah its for vb3 and the page shows up but the stuff for latestentrybits will not show up at all. the information is retrieved cause i used echo and it all showed, its just the template info isnt

Modin · #8 07-02-2004, 04:29 AM

is it a scope problem?

since the variable is defined within the if statement, it shouldn't be available outside it, so just prior to your if statement add the line

Code:

$latestentrybits = "";

I'm not completely sure how php handles scope, but in any other language this would be the case.

AN-net · #9 07-02-2004, 02:20 PM

nope still doesnt work, it just the table and the journal_latestentrybits template wont show. the JOURNAL template shows and the information in it does too.

heres a screenshot(attached)
the red oval is where the table inside the JOURNAL template should appear and inside that table it should have the information from journal_latestentrybits.

Modin · #10 07-02-2004, 02:29 PM

Can I see the Journal template? Thay may be where the problem arrises from, since everything else looks ok

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.06145 seconds Memory Usage 4,826KB Queries Executed 12 (?)
More Information
Template Usage: (1)SHOWTHREAD (1)ad_footer_end (1)ad_footer_start (1)ad_header_end (1)ad_header_logo (1)ad_navbar_below (1)ad_showthread_beforeqr (1)ad_showthread_firstpost (1)ad_showthread_firstpost_sig (1)ad_showthread_firstpost_start (1)bbcode_code (2)bbcode_html (3)bbcode_php (1)bbcode_quote (1)footer (1)forumjump (1)forumrules (1)gobutton (1)header (1)headinclude (1)navbar (3)navbar_link (120)option (1)pagenav (1)pagenav_curpage (1)pagenav_pagelink (10)post_thanks_box (10)post_thanks_button (1)post_thanks_javascript (1)post_thanks_navbar_search (10)post_thanks_postbit_info (10)postbit (1)postbit_attachment (10)postbit_onlinestatus (10)postbit_wrapper (1)spacer_close (1)spacer_open (1)tagbit_wrapper Phrase Groups Available: global inlinemod postbit posting reputationlevel showthread	Included Files: ./showthread.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/functions_bigthree.php ./includes/class_postbit.php ./includes/class_bbcode.php ./includes/functions_reputation.php ./includes/functions_post_thanks.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 showthread_start showthread_getinfo forumjump showthread_post_start showthread_query_postids showthread_query bbcode_fetch_tags bbcode_create showthread_postbit_create postbit_factory postbit_display_start post_thanks_function_post_thanks_off_start post_thanks_function_post_thanks_off_end post_thanks_function_fetch_thanks_start post_thanks_function_fetch_thanks_end post_thanks_function_thanked_already_start post_thanks_function_thanked_already_end fetch_musername postbit_imicons bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete postbit_display_complete post_thanks_function_can_thank_this_post_start postbit_attachment pagenav_page pagenav_complete tag_fetchbit_complete forumrules navbits navbits_complete showthread_complete
Messages: