View Single Post
  #1  
Old 12-21-2009, 10:14 AM
Ghostsuit's Avatar
Ghostsuit Ghostsuit is offline
 
Join Date: Nov 2001
Location: Glasgow, Scotland
Posts: 199
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default Nested Loop with templates

Wonder if anyone can help. What I'm trying to do is show a gig listings but add multiple ticket buying options.

I'm stuck though at the nested part and getting it to display in the template. I'm pretty sure the bit that's wrong is the 1st and 3rd line as if I do it with just the second line I get one link displayed but with this code I get none.

I know it's something simple but I'm new to the way vB4 does stuff.

So any ideas?

Code:
        $templater = vB_Template::create('event_giglistrowticket');
        $templater->register('ticketlink', $linkrow[ticketlink]);
        $event_giglistrowticket .= $templater->render();
Here's the full loop with nesting

Code:
$results = $vbulletin->db->query_read("SELECT date_format(gig.date, '%a %D %b %y') AS gig_date, gig.gigid, venue.venuename AS gig_venuename, gig.title, gig.status, gig.age
FROM gig 
LEFT JOIN venue ON gig.venueid=venue.venueid
WHERE Status='confirmed' AND title != '' AND date  >= ( CURDATE()  ) ORDER BY date ASC");

// Loop through all results
while ($row = $vbulletin->db->fetch_array($results))
{   
    // Generate row html from template
    $templater = vB_Template::create('event_giglistrow');
    $templater->register('gigid', $row[gigid]);
    $templater->register('title', $row[title]);
    $templater->register('venuename', $row[gig_venuename]);
    $templater->register('date', $row[gig_date]);
    $templater->register('age', $row[age]);
    
    $linkresults = $vbulletin->db->query_read("SELECT ticketlink
    FROM ticketlink 
    LEFT JOIN gig ON ticketlink.gigid=gig.gigid
    WHERE ticketlink.gigid=gig.gigid AND ticketlink.gigid = '$row[gigid]'");

    while ($linkrow = $vbulletin->db->fetch_array($linkresults))
    {      
        $templater = vB_Template::create('event_giglistrowticket');
        $templater->register('ticketlink', $linkrow[ticketlink]);
        $event_giglistrowticket .= $templater->render();
    }
    $event_giglistrow .= $templater->render();
}
Reply With Quote
 
X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.01265 seconds
  • Memory Usage 1,768KB
  • 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
  • (2)bbcode_code
  • (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