View Single Post
  #1  
Old 07-23-2004, 02:18 AM
AN-net's Avatar
AN-net AN-net is offline
 
Join Date: Dec 2003
Location: AnimationTalk.com
Posts: 2,367
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default need a little help

i dont get why php is considering 2 of these entries private because they are not private and the database has them listed as not private so i have no clue y.

here is my code:
PHP Code:
                $fentries $DB_site->query(
                    SELECT journal_entries.entry_id, journal_entries.entrytitle, 
                    journal_entries.entrytext, journal_entries.entrydate, 
                   journal_entries.entry_totalvotes, journal_entries.entry_totalrating, 
                    journal_entries.private, journal_entries.whocanview, 
                    COUNT(journal_comments.comment_text) AS comments 
                    FROM "
.TABLE_PREFIX."journal_entries 
                    LEFT JOIN journal_comments 
                    ON (journal_entries.entry_id=journal_comments.entry_id) 
                    WHERE journal_entries.journal_id='"
.$j."' 
                    AND entry_active='1'      
                    GROUP BY journal_entries.entry_id
                ORDER BY entrydate ASC 
                "
); 
                
$check$DB_site->num_rows($fentries);
                if(
$check=="0")
                {
                    
$entrybits$vbphrase['journalnoentries'];
                }
                else
                {
                    while(
$entry$DB_site->fetch_array($fentries))
                    {
                        
$enum++;
                        
$entry['date']= vbdate($vboptions['dateformat'], $entry['entrydate'], 1);
                        
$entry['time']= vbdate($vboptions['timeformat'], $entry['entrydate']);
                        if(empty(
$entry['entry_totalrating']) OR empty($entry['entry_totalvotes']))
                        {
                            
$rating"0";
                        }
                        else
                        {
                            
$calcrating$entry['entry_totalrating']/$entry['entry_totalvotes'];
                            
$ratinground($calcrating);
                        }
                        if (
is_array($replacewords))
                        {
                            require_once(
'./includes/functions_showthread.php');
                            
$entry['entrytext'] = preg_replace('#(^|>)([^<]+)(?=<|$)#sUe'"process_highlight_postbit('\\2', \$replacewords, '\\1')"$entry['entrytext']);
                            
$entry['entrytext'] = preg_replace('#<vb_highlight>(.*)</vb_highlight>#siU''<span class="highlight">$1</span>'$entry['entrytext']);
                        }
                            require_once(
'./includes/functions_bbcodeparse.php');
                            
$entry['entrytext']= parse_bbcode2($entry['entrytext'], 0$setting['allow_imgcode'], $setting['allow_smilies'], $setting['allow_bbcode']);
                        
$wcv_entryexplode(','$entry['whocanview']);
                        if(
$entry['private'])
                        {
                            if((
$bbuserinfo['usergroupid']=="6") OR ($bbuserinfo['userid'] == $journalinfo['journalist_id']) OR (in_array($bbuserinfo['userid'], $wcv_entry)))
                            {
                                eval(
'$entrybits .= "' fetch_template('journal_entrybits') . '";');
                            }
                            else
                            {
                                
$entrybits='';
                            }
                        }
                        else
                        {
                            eval(
'$entrybits .= "' fetch_template('journal_entrybits') . '";');
                        }
                    } 
it is taking the first 2 and counting them as private and the 3rd is private and the rest are not private but they show up, so y are the first whens being looked at as private even though they arent?

thanks in advance
Reply With Quote
 
X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.01589 seconds
  • Memory Usage 1,820KB
  • Queries Executed 11 (?)
More Information
Template Usage:
  • (1)SHOWTHREAD_SHOWPOST
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (1)bbcode_php
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)post_thanks_box
  • (1)post_thanks_button
  • (1)post_thanks_javascript
  • (1)post_thanks_navbar_search
  • (1)post_thanks_postbit_info
  • (1)postbit
  • (1)postbit_onlinestatus
  • (1)postbit_wrapper
  • (1)spacer_close
  • (1)spacer_open 

Phrase Groups Available:
  • global
  • postbit
  • reputationlevel
  • showthread
Included Files:
  • ./showpost.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_postinfo_query
  • fetch_postinfo
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • showpost_start
  • bbcode_fetch_tags
  • bbcode_create
  • postbit_factory
  • showpost_post
  • 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
  • showpost_complete