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 05-11-2003, 05:01 PM
mADmAX` mADmAX` is offline
 
Join Date: Dec 2001
Posts: 93
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default While statement not working...

This is what I have inside index.php (of my hack)...

PHP Code:
// ###################### Start #######################

$dwipnavlinkgroups $DB_site->query("SELECT navlinkgroupid,title,displayorder FROM dwipnavlinkgroup ORDER BY displayorder");

while (
$dwipnavlinkgroup=$DB_site->fetch_array($dwipnavlinkgroups)) {

    eval(
"\$newmenunav .= \"".gettemplate("menu_navtable")."\";");

    
$dwipnavlinks $DB_site->query("SELECT navlinkid,navlinkgroupid2,title,varname,value,displayorder FROM dwipnavlink WHERE navlinkgroupid2=$dwipnavlinkgroup[navlinkgroupid] ORDER BY displayorder");

    while (
$dwipnavlink=$DB_site->fetch_array($dwipnavlinks)) {

        eval(
"\$newmenuitem .= \"".gettemplate("menu_navitem")."\";");    

    }

}

eval(
"\$menu .= \"".gettemplate("menu_main")."\";");


// ###################### End ####################### 
This is inside menu_main

PHP Code:
$newmenunav 
This is inside menu_navtable

PHP Code:
$dwipnavlinkgroup[title]
$dwipnavlinkgroup[navlinkgroupid]
<
br>
$newmenuitem 
This is inside menu_navitem

PHP Code:
$dwipnavlink[title]
$dwipnavlink[navlinkgroupid2]
<
br
This is what displays when I call index.php

Navigation 1 <---navgroup
Gallery 7 <---navgroup
Home 1
Forums 1
News 1
Biography 1
Contact Info 1
WebSite Help 1
Links 8 <---navgroup
Home 1
Forums 1
News 1
Biography 1
Contact Info 1
WebSite Help 1
Animals 7
Birds 7


I have marked which are navgroup for you to see, but you can see that its not in order like I want called... It should look like this when called right...

Navigation 1 <---navgroup
Home 1
Forums 1
News 1
Biography 1
Contact Info 1
WebSite Help 1
Gallery 7 <---navgroup
Animals 7
Birds 7
Links 8 <---navgroup
Reply With Quote
  #2  
Old 05-11-2003, 05:13 PM
filburt1 filburt1 is offline
 
Join Date: Feb 2002
Location: Maryland, US
Posts: 6,144
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

I don't see the problem immediately but never, ever query in a loop.
Reply With Quote
  #3  
Old 05-11-2003, 05:20 PM
mADmAX` mADmAX` is offline
 
Join Date: Dec 2001
Posts: 93
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

How would you do this query then as its in the loop that way the navlinks pull under there correct navgroup (which obviously is not working).
Reply With Quote
  #4  
Old 05-12-2003, 01:35 AM
mADmAX` mADmAX` is offline
 
Join Date: Dec 2001
Posts: 93
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

I changed a bit but its not quite working right...

PHP Code:
// ###################### Start #######################

$dwipnavlinkgroups $DB_site->query("SELECT navlinkgroupid,title,displayorder FROM dwipnavlinkgroup ORDER BY navlinkgroupid");

while (
$dwipnavlinkgroup=$DB_site->fetch_array($dwipnavlinkgroups)) {

$linkid $dwipnavlinkgroup["navlinkgroupid"];

    eval(
"\$newmenunav .= \"".gettemplate("menu_navtable")."\";");

    
$dwipnavlinks $DB_site->query("SELECT navlinkid,navlinkgroupid,title,varname,value,displayorder FROM dwipnavlink WHERE navlinkgroupid=\"$linkid\" ORDER BY navlinkgroupid");

    while (
$dwipnavlink=$DB_site->fetch_array($dwipnavlinks)) {

        eval(
"\$newmenuitem .= \"".gettemplate("menu_navitem")."\";");    
    }

}

eval(
"\$menu .= \"".gettemplate("menu_main")."\";");


// ###################### End ####################### 
Displays this...

Navigation 1 <----navgroup
Gallery 2 <----navgroup
Links 3 <----navgroup
Home 1
Forums 1
Biography 1
Contact Info 1
News 1
WebSite Help 1
Animals 2
Birds 2
Test Link 1 3
Test Link 2 3
Test Link 3 3

How come the nav items are not going into there correct nav group? I know it has to be something small but cant figure it out.

PS. The numbers at the end are the navgroupid which they belong to.
Reply With Quote
  #5  
Old 05-12-2003, 02:17 AM
Velocd's Avatar
Velocd Velocd is offline
 
Join Date: Mar 2002
Location: CA University
Posts: 1,696
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Funny this problem for you was brought up, as I recently found a solution for it myself.

Take a look at the following thread, and the code given inside. Basically this function, modified some, should do as you need.

https://vborg.vbsupport.ru/showthrea...threadid=52836
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 04:29 PM.


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.04475 seconds
  • Memory Usage 2,213KB
  • 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
  • (5)bbcode_php
  • (1)footer
  • (1)forumjump
  • (1)forumrules
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (1)navbar
  • (3)navbar_link
  • (120)option
  • (5)post_thanks_box
  • (5)post_thanks_button
  • (1)post_thanks_javascript
  • (1)post_thanks_navbar_search
  • (5)post_thanks_postbit_info
  • (5)postbit
  • (5)postbit_onlinestatus
  • (5)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