vb.org Archive - Does this code for member.php showing attended events look correct ?

The following aims at showing

the next future event a memebr is attending to but is
not hosting the event (have not themselves entered the event in the calendar)

at the memper.php profile page

The major critical data is pulled from roll field which is created as a part of the event attendace mod. The data entries looks like

a:2:{i:34;s:7:"test018";i:1;s:5:"MikaK";}
a:1:{i:1;s:5:"MikaK";}
a:1:{i:60;s:5:"kfied";}

The code I'm thinking of using look like this

PHP Code:


		
			
$eventattend = $DB_site->query = ("SELECT eventid , userid ,  title ,  customfields , dateline_from , roll 
FROM " . TABLE_PREFIX . "event 
WHERE roll LIKE '%i:" . $userinfo['userid'] . ";s:" . strlen($userinfo['userid']) . ":%' 
AND dateline_from > UNIX_TIMESTAMP() 
AND userid != '$userinfo[userid]' 
ORDER BY dateline_from ASC 
LIMIT 1");

        while($eventsatt = $DB_site->fetch_array($eventattend))
        {
        exec_switch_bg();
        $eventsatt['date'] = vbdate($vboptions['dateformat'],$eventsatt['dateline_from']);
        eval('$attendevents .= "' . fetch_template('memberinfo_attendedevents') . '";');
        }

the bits template is memberinfo_attendedevents and the $attendevents variable iserting the bits goes into memberinfo template.

What do you think is wrong with the code? It doesn?t give any sql errors, but the bits teplate doesn?t appear uncached (i haven?t added it to the templates cache on purpose just yet) and the bits area at the member info page stay blanco despite I have entered test attendances...

I just don't get why:(

Thanks for any thoughts!

-Mika

X vBulletin 3.8.12 by vBS Debug Information
Template Usage: (1)ad_footer_end (1)ad_footer_start (1)ad_header_end (1)ad_header_logo (1)ad_navbar_below (1)bbcode_php_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)post_thanks_navbar_search (1)printthread (2)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:

X vBulletin 3.8.12 by vBS Debug Information

Page Generation 0.01009 seconds
Memory Usage 1,719KB
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
(1)bbcode_php_printable
(1)footer
(1)gobutton
(1)header
(1)headinclude
(6)option
(1)post_thanks_navbar_search
(1)printthread
(2)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:

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