Go Back   vb.org Archive > vBulletin 3 Discussion > vB3 Programming Discussions
FAQ Community Calendar Today's Posts Search

Reply
 
Thread Tools Display Modes
  #1  
Old 01-07-2008, 08:14 PM
Antivirus's Avatar
Antivirus Antivirus is offline
 
Join Date: Sep 2004
Location: Black Lagoon
Posts: 1,090
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default Need help breaking out of while() loop - logic problem...

I have the following result set from my db:

-------------------------------
| postid | post_statusid |
-------------------------------
| 100 | 4 |
| 101 | 7 |
-------------------------------

And I am looping through the result set as follows:
PHP Code:
$statusid 8;
while (
$post $vbulletin->db->fetch_array($sql))
{
    if (
$post['post_statusid'] == 7)
    {
        
$statusid 7;
    }
    else if (
$post['post_statusid'] == 4)
    {
        
$statusid 4;
    }
    else
    {
        
$statusid 8;
    }
    
    
// Immediately get out if one of following!
    
if ($statusid == || $statusid == 4)
    {
        break;
    }
}            
echo 
$statusid
The rules I want to impose upon the set are as follows:

If any posts have post_statusid of '7' set $statusid = 7
If any posts have post_statusid of '4' and NO posts have post_statusid of '7' set $statusid = 4
If no posts have post_statusid of '7' or of '4' set $statusid = 8

The result set can only have a value of 4,7, or 8. Following are all possible result sets, however the one highlighted in red is giving me a problem. It's returning '4' instead of the needed value of '7':

If: 8,8 $statusid = 8
If: 8,7 $statusid = 7
If: 8,4 $statusid = 4
If: 7,8 $statusid = 7
If: 7,7 $statusid = 7
If: 7,4 $statusid = 7
If: 4,8 $statusid = 4
If: 4,7 $statusid = 7
If: 4,4 $statusid = 4

Anyone have an idea on how to get this one instance of 4,7 to return '7' as I need instead of '4'?

Thanks in advance
Reply With Quote
  #2  
Old 01-07-2008, 08:22 PM
Opserty Opserty is offline
 
Join Date: Apr 2007
Posts: 4,103
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

You will be better to store the post_statusid in a temp. array. Then you can make use of in_array() and a few simple if expressions.
PHP Code:
$arr = array();
// while($post...
{
    
// You may want to store postid as key up to you...
    
$arr[] = intval($post['post_statusid']);
}
// Now we do the checking:
if(in_array(7$arr))
{
    
$statusid 7;
}
elseif(
in_array(//....
{
    
$statusid 4;
}
else
{
    
$statusid 8;

Makes the logic easier to understand.
Reply With Quote
  #3  
Old 01-07-2008, 08:41 PM
Antivirus's Avatar
Antivirus Antivirus is offline
 
Join Date: Sep 2004
Location: Black Lagoon
Posts: 1,090
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

perfect, thanks Opserty
Reply With Quote
Reply


Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


All times are GMT. The time now is 09:21 AM.


Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2024, vBulletin Solutions Inc.
X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.03628 seconds
  • Memory Usage 2,188KB
  • Queries Executed 11 (?)
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
  • (2)bbcode_php
  • (1)footer
  • (1)forumjump
  • (1)forumrules
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (1)navbar
  • (3)navbar_link
  • (120)option
  • (3)post_thanks_box
  • (3)post_thanks_button
  • (1)post_thanks_javascript
  • (1)post_thanks_navbar_search
  • (3)post_thanks_postbit_info
  • (3)postbit
  • (3)postbit_onlinestatus
  • (3)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
  • tag_fetchbit_complete
  • forumrules
  • navbits
  • navbits_complete
  • showthread_complete