vb.org Archive - vBulletin CMS Widgets

Quote:

Originally Posted by tomsch (Post 2215122)

i am working on correcting this item.

My version of the event widget (widget Turnierticker).
http://www.united-battlezone.de

(not based on your work, based on the idea here:
https://vborg.vbsupport.ru/showthrea...pcoming+events )
But heavily heavily modified. Maybe 5 lines of code are left. :D

Anyway - since our users rely on weekly recurring events i rewrote the code to account for that and set them in the right order. I thought it might help you with your work.

vB saves the recurring events in two seperate columns:
recurring and recuroption

I know for most of them what they mean (brute force testing :p). But the only one i have implemented so far is weekly.

Code:

elseif($event['recurring'] == 3) {

            $teile = explode("|", $event['recuroption']);

            

            //Datum neu setzen fuer die weeklies -- (offset damit der heutige noch erscheint!)

            while($event['dateline_from'] + $wez_offset < $time_offset)

            {

                $event['dateline_from'] += $teile[0] * 7 * 86400; 

            }

What it does.
The recurroption for weekly events is saved like that:
1|5
-> event takes place every week on tuesdays and sundays.

3|32
-> event takes place every 3 weeks on fridays.

So we need that first part of the string, which i write into $teile[0] - then i'm using a loop to change the startdate to the actual week we are in (+ some offset to show events which are today).

I do that for all events which i take out of the database (usually 5ish more than i will show in the end - to account for database missorting based on the wrong dates).

Then i resort the array via

Code:

//getting database results

    foreach($DatabaseStatement as $event)

    {

//calculate new dates (see code above)



//add them into a big array

$events[] = $event;

}



//sort the $events array via array_multisort and startdate

    foreach($events as $c => $key)

    {

        $sort_date[] = $key['dateline_from'];

    }

    

    array_multisort($sort_date, SORT_ASC, $events);



//generate output

I hope that helps. :)

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 (2)bbcode_code_printable (3)bbcode_quote_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)pagenav (1)pagenav_curpage (1)pagenav_pagelink (1)post_thanks_navbar_search (1)printthread (9)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 pagenav_page pagenav_complete 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.01950 seconds
Memory Usage 1,738KB
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
(3)bbcode_quote_printable
(1)footer
(1)gobutton
(1)header
(1)headinclude
(6)option
(1)pagenav
(1)pagenav_curpage
(1)pagenav_pagelink
(1)post_thanks_navbar_search
(1)printthread
(9)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
pagenav_page
pagenav_complete
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.01950 seconds Memory Usage 1,738KB 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 (3)bbcode_quote_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)pagenav (1)pagenav_curpage (1)pagenav_pagelink (1)post_thanks_navbar_search (1)printthread (9)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 pagenav_page pagenav_complete bbcode_fetch_tags bbcode_create bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete printthread_post printthread_complete
Messages: