vb.org Archive - Problem calling $count[threads] variable

vb.org Archive (https://vborg.vbsupport.ru/index.php)

- Member Archives (https://vborg.vbsupport.ru/forumdisplay.php?f=202)

- - Problem calling $count[threads] variable (https://vborg.vbsupport.ru/showthread.php?t=52633)

Grunt

05-06-2003 01:57 AM

Problem calling $count[threads] variable

im working on a little hack, however im having a problem calling a variable in a template. here is the call:

$count[threads] new thread$pluralthread

If a new thread(s) have been made, the # will show no problem - the plural variable is working fine also. However, if no threads have been made, instead of showing 'No' like i think i specified below, nothing is showing up. Heres the code where they are defined:

Code:

  $newthreads = '';

  if ( $activenewthread )

  {

    if ( $dothreads = $DB_site->query_first("

      SELECT COUNT(*) AS total

      FROM thread

                        WHERE $iforumperms AND dateline>$bbuserinfo[lastvisit]

    ") and !empty( $dothreads['total'] ) )

    {

      $count['threads'] = number_format( $dothreads['total'] );

      $count['threads'] = iif ( $count['threads']!=0 , $count['threads'] , 'No' );

      $pluralthread = iif ( $count['threads']!=1 , 's' , '' );

    }

  }

Xenon

05-06-2003 04:02 PM

i think you would get type mismatches here try this code:

PHP Code:


		
			
$newthreads = '';

  if ( $activenewthread )

  {

    if ( $dothreads = $DB_site->query_first("

      SELECT COUNT(*) AS total

      FROM thread

            WHERE $iforumperms AND dateline>$bbuserinfo[lastvisit]

    ") and !empty( $dothreads['total'] ) )

    {

      $count['threads'] = intval( $dothreads['total'] );

      $count['threads'] = iif ( $count['threads'] > 0 , numer_format($count['threads']) , 'No' );

      $pluralthread = iif ( $count['threads']!=1 , 's' , '' );

    }

  }

Grunt

05-06-2003 08:19 PM

nope..still not showing the 'No'

this is where im calling it:

Code:

<img src="/bullet.gif">$count[threads] new thread$pluralthread<br />

the $pluralthread is still being called hovever..hmmm

Xenon

05-06-2003 09:35 PM

try this code then:

PHP Code:


		
			
$newthreads = '';

  if ( $activenewthread )

  {

    $dothreads = $DB_site->query_first("

      SELECT COUNT(*) AS total

      FROM thread

            WHERE $iforumperms AND dateline>$bbuserinfo[lastvisit]

    ");

      $count['threads'] = intval( $dothreads['total'] );

      $count['threads'] = iif ( $count['threads'] > 0 , number_format($count['threads']) , 'No' );

      $pluralthread = iif ( $count['threads']!=1 , 's' , '' );

  }

after a closer look i think the if tag is senseless and could produce your problem

Grunt

05-07-2003 07:08 AM

that was it! thanks much..i really appreciate the help :)

Xenon

05-07-2003 08:30 AM

:)

no problem, you're welcome :)

All times are GMT. The time now is 09:00 PM.

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.01210 seconds Memory Usage 1,735KB 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 (2)bbcode_code_printable (2)bbcode_php_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)post_thanks_navbar_search (1)printthread (6)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
Messages: