vb.org Archive
Page 1 of 2 1 2
Show 40 post(s) from this thread on one page

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vB3 Programming Discussions (https://vborg.vbsupport.ru/forumdisplay.php?f=15)
-   -   something is wrong (https://vborg.vbsupport.ru/showthread.php?t=66755)

AN-net 07-01-2004 03:51 PM
something is wrong
 
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 07-01-2004 03:56 PM
Do you have a template journal_latestentrybits

?

AN-net 07-01-2004 04: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 07-01-2004 04:30 PM
You do have a call to printout a template at the end of the file right ?

AN-net 07-01-2004 05: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 07-01-2004 05: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 07-01-2004 06: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 07-02-2004 05: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 07-02-2004 03:20 PM
1 Attachment(s)
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 07-02-2004 03:29 PM
Can I see the Journal template? Thay may be where the problem arrises from, since everything else looks ok


All times are GMT. The time now is 10:35 PM.
Page 1 of 2 1 2
Show 40 post(s) from this thread on one page

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.01209 seconds
  • Memory Usage 1,817KB
  • 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
  • (3)bbcode_php_printable
  • (1)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (1)pagenav_pagelink
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (10)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
  • pagenav_page
  • pagenav_complete
  • bbcode_fetch_tags
  • bbcode_create
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • printthread_post
  • printthread_complete