UpComing Events SideBlock/Bar With/Without Image

[ProFifaLeagues]

Upcoming Events in Forum Block/Sidebar



Add the "Upcoming Events" in the forum side block
(Added as a few people seem to have issues with other mods the same)

Start by logging into your Admin cp

Goto Forums and moderators - Forum Blocks Manager and add a new Block.
Call the Block Upcoming Events(Or what ever suits your liking)
Set the block to Active
And use PhP Format.

Now add the content below :
ob_start();


// %d
$show_count = 5;

$query = sprintf("SELECT * FROM ".TABLE_PREFIX."event WHERE visible = 1 AND (dateline_from > '%d' || ( dateline_from < '%d' AND dateline_to > '%d' )) ORDER BY dateline_from ASC LIMIT %d",TIMENOW,TIMENOW,TIMENOW,$show_count);

$event_get = vB::$db->query_read($query);

$output_bits = '';
while($event = vB::$db->fetch_array($event_get)) {

if($event['dateline_to'] == 0 )
{
$format = sprintf("On %s",date('jS M Y',$event['dateline_from']));
} else {
$format = sprintf("From %s to %s",date('jS M Y',$event['dateline_from']),date('jS M Y',$event['dateline_to']));
}

$output_bits .= sprintf('
<div class = "cms_widget_post_bit"><h4 class="cms_widget_post_header"><a href="calendar.php?do=getinfo&e=%d">%s</a></h4>
<p class="cms_widget_post_content">%s</p>
</div>
',$event['eventid'],$event['title'],$format);

}
$output = $output_bits;


ob_end_clean();
return $output; Then just make sure the template to use is set to Block_HTML

This will then show the latest upcoming event from your calendar with multi-day events shown until the last day of the event.



Update Thanks to dcuellar (https://vborg.vbsupport.ru/member.php?u=228106)
What this does is add a picture centered above the upcoming event. The picture is uploaded to 'images/' as event.jpg. You can change that to whatever you want. It also corrects the issue I had with the date. It's now projecting the proper date.


NOTE:
I changed the number of events to display to 1.
I do not need the range on my forum so I did not test that part.
Here you go for those interested (change what's in Red):
ob_start();


// %d
$show_count = 1;

$query = sprintf("SELECT * FROM ".TABLE_PREFIX."event WHERE visible = 1 AND (dateline_from > '%d' || ( dateline_from > '%d' AND dateline_to > '%d' )) ORDER BY dateline_from ASC LIMIT %d",TIMENOW,TIMENOW,TIMENOW,$show_count);

$event_get = vB::$db->query_read($query);

$output_bits = '';
while($event = vB::$db->fetch_array($event_get)) {

if($event['dateline_to'] == 0 )
{
$format = sprintf("On %s%s %s %s",date("j",$event['dateline_from'])+1, date("S",$event['dateline_from']), date("M",$event['dateline_from']), date("Y",$event['dateline_from']));
} else {
$format = sprintf("From %s to %s",date('jS M Y',$event['dateline_from']),date('jS M Y',$event['dateline_to']));
}

$output_bits .= sprintf('
<div class = "cms_widget_post_bit"><center><a href="calendar.php?do=getinfo&e=%d"><img src="http://www.YourForum.com/forum/images/event.jpg" width="200px" alt="Upcoming Event"/><h4 class="cms_widget_post_header">%s</a></h4>
<p class="cms_widget_post_content">%s</p></center>
</div>
',$event['eventid'],$event['title'],$format);

}
$output = $output_bits;


ob_end_clean();
return $output;



Thanks go to cybaGirl for this fix:
Anyone who has the date showing as the day before can use this code in there forum block.

ob_start();


// %d
$show_count = 5;

$query = sprintf("SELECT * FROM ".TABLE_PREFIX."event WHERE visible = 1 AND (dateline_from > '%d' || ( dateline_from < '%d' AND dateline_to > '%d' )) ORDER BY dateline_from ASC LIMIT %d",TIMENOW,TIMENOW,TIMENOW,$show_count);

$event_get = vB::$db->query_read($query);

$output_bits = '';
while($event = vB::$db->fetch_array($event_get)) {

if($event['dateline_to'] == 0 )
{
$format = sprintf("On %s",date('jS M Y',$event['dateline_from']));
} else {
$format = sprintf("From %s to %s",date('jS M Y',$event['dateline_from']),date('jS M Y',$event['dateline_to']));
}

$output_bits .= sprintf('
<div class = "cms_widget_post_bit"><center><a href="calendar.php?do=getinfo&e=%d"><img src="http://www.YourForum.com/forum/images/event.jpg" width="200px" alt="Upcoming Event"/><h4 class="cms_widget_post_header">%s</a></h4>
<p class="cms_widget_post_content">%s</p></center>
</div>
',$event['eventid'],$event['title'],$format);

}
$output = $output_bits;


ob_end_clean();
return $output;

[ProFifaLeagues]

Works well in Vbull 4.0.6 and no screenshots needed as each users forum will be showing different upcoming events anyway!

We use this to show upcoming events on the calendar for our Football comps and the like!

[Zweeper]

what about birthdays? are they shown?

[ProFifaLeagues]

No mate it wont pull the birthdays but is something i will look into adding next!

[Zweeper]

cheers, its installed when it shows birhtdays since i am looking for that a long time!

[ProFifaLeagues]

Well this may be of help then fella and it works well as i have used it
https://vborg.vbsupport.ru/showthread.php?t=236131&highlight=birthday

[oldfan]

demo?

[ProFifaLeagues]

We run a closed Site but will add some screen shots later when i get home!

[ProFifaLeagues]

Heres a basic view with one event arranged for today(Info pulled from the calendar)

[Bram H]

We have multiple calendar events per day, and for today it only shows 1 event out of 4

[ProFifaLeagues]

We have multiple calendar events per day, and for today it only shows 1 event out of 4

Not sure then there whats happening as we have it set to pull all events on the preset day from the main calendar but n saying that we do only run one event at a set date!
Sorry i cant be more helpful but after a quick look around seems there is a few problems with the date discrepancy on vbull for this type of mod...Only other thing you could try would be copy the original upcoming event code and test that.

[Zweeper]

Well this may be of help then fella and it works well as i have used it
https://vborg.vbsupport.ru/showthread.php?t=236131&highlight=birthday


quite nice, thats true. but i would rather the birthdays in the calender widget as well.

[dcuellar]

This one works well. Anyway to have an image above the event in the forum block. Would be nice for it to automatically pull an image posted in the calendar event.

[dcuellar]

Also, I just noticed that the date shown on the forum block is one day before it is set in the calendar.

[dcuellar]

Got both of my above comments to work.

Here you go for those interested (change what's in Red):
ob_start();


// %d
$show_count = 1;

$query = sprintf("SELECT * FROM ".TABLE_PREFIX."event WHERE visible = 1 AND (dateline_from > '%d' || ( dateline_from > '%d' AND dateline_to > '%d' )) ORDER BY dateline_from ASC LIMIT %d",TIMENOW,TIMENOW,TIMENOW,$show_count);

$event_get = vB::$db->query_read($query);

$output_bits = '';
while($event = vB::$db->fetch_array($event_get)) {

if($event['dateline_to'] == 0 )
{
$format = sprintf("On %s%s %s %s",date("j",$event['dateline_from'])+1, date("S",$event['dateline_from']), date("M",$event['dateline_from']), date("Y",$event['dateline_from']));
} else {
$format = sprintf("From %s to %s",date('jS M Y',$event['dateline_from']),date('jS M Y',$event['dateline_to']));
}

$output_bits .= sprintf('
<div class = "cms_widget_post_bit"><center><a href="calendar.php?do=getinfo&e=%d"><img src="http://www.YourForum.com/forum/images/event.jpg" width="200px" alt="Upcoming Event"/><h4 class="cms_widget_post_header">%s</a></h4>
<p class="cms_widget_post_content">%s</p></center>
</div>
',$event['eventid'],$event['title'],$format);

}
$output = $output_bits;


ob_end_clean();
return $output;

What this does is add a picture centered above the upcoming event. The picture is uploaded to 'images/' as event.jpg. You can change that to whatever you want. It also corrects the issue I had with the date. It's now projecting the proper date.

What I'd really like to do is replace the code related to the image with a piece of code that uses an image that was either attached or placed between img tags in the event.

NOTE:
I changed the number of events to display to 1.
I do not need the range on my forum so I did not test that part.

[ProFifaLeagues]

Cheers dcuellar (https://vborg.vbsupport.ru/member.php?u=228106) I have added that info in the 1st post and given you credit as it will help many!

[dcuellar]

Cheers dcuellar (https://vborg.vbsupport.ru/member.php?u=228106) I have added that info in the 1st post and given you credit as it will help many!

Cool. Hope it helps others. I'm talking to some friends of mine to see if the image can be auto generated if an image is included in a calendar event. That way we don't have to change the picture everytime a new event is up. That will also allow us to do more than one event on the block at a time.

Wish me luck.

[COL NIL SATIS]

Nice one mate..sounds cool that does!!

[ProFifaLeagues]

Cool. Hope it helps others. I'm talking to some friends of mine to see if the image can be auto generated if an image is included in a calendar event. That way we don't have to change the picture everytime a new event is up. That will also allow us to do more than one event on the block at a time.

Wish me luck.


Be great to have that option mate keep us informed!!!:up:

[dcuellar]

Update: I'm trying to get this thing to work but I need help from someone who knows how to deal with plugins.
Update 2: Sorry guys, I gave in. I hired a coder to complete this for me. Unfortunately, I cannot post the code here. :( He may do the custom work for you if you are really interested. Look for the member called Gio~logist.

[ProFifaLeagues]

Cheers for the info dcuellar!!!

[starman?]

I'm still watching this one.

[CybaGirl]

Thanks works well apart from not displaying more than one event on the same day.

I don't suppose anyone has worked out how to do this yet?

Installed on version 4.0.3 BTW.

Sorry never mind it does display more than one event from the same day!

:).

[ProFifaLeagues]

Thanks works well apart from not displaying more than one event on the same day.

I don't suppose anyone has worked out how to do this yet?

Installed on version 4.0.3 BTW.

Sorry never mind it does display more than one event from the same day!

:).

Should show all the days events on 4.0.3 :up:

[CybaGirl]

Hello seem to have found a small issues since moving our forum to a VPS but still staying with the same host.

The issue I have come across is that it is reporting the date a day later in the forum sideblock.

For example if an event in the calendar is scheduled for the 25th of December. The sideblock is saying that the event is happening on the 26th of December.

But when you click on the event in the sideblock and you are taken to your calendar it is taking you to the actual date of the event which in this case is the 25th of December.

So for some reason it is showing the event date in the sideblock as a day later.

Does anyone know how I might be able to correct this please?

Thank you.

[ProFifaLeagues]

CybaGirl i will be more then happy to come take a look if needed just pm me the details

[CybaGirl]

Ok I finally figured out what the problem was.

Has something to do with the calling of the date in the code.

Here is the first part of dcuellar's original code that I changed that uses an image.

Although this change seems to make no difference. But I still changed it anyway.


$query = sprintf("SELECT * FROM ".TABLE_PREFIX."event WHERE visible = 1 AND (dateline_from > '%d' || ( dateline_from > '%d' AND dateline_to > '%d' )) ORDER BY dateline_from ASC LIMIT %d",TIMENOW,TIMENOW,TIMENOW,$show_count);


Here is the new code and the section I changed is highlighted in red.


$query = sprintf("SELECT * FROM ".TABLE_PREFIX."event WHERE visible = 1 AND (dateline_from > '%d' || ( dateline_from < '%d' AND dateline_to > '%d' )) ORDER BY dateline_from ASC LIMIT %d",TIMENOW,TIMENOW,TIMENOW,$show_count);


This next change in the code is what made the difference.

Here is the area of the second part of dcuellar's original code that I changed.


$format = sprintf("On %s%s %s %s",date("j",$event['dateline_from'])+1, date("S",$event['dateline_from']), date("M",$event['dateline_from']), date("Y",$event['dateline_from']));


This is how it now looks.


$format = sprintf("On %s",date('jS M Y',$event['dateline_from']));


Once I made the above change the date being posted in the side block is now being posted as the same date as whats in the calendar.

I hope this helps others that may come across this same issue.

Here is the complete code so you can just copy and paste it into your Sideblock Manager.


ob_start();


// %d
$show_count = 5;

$query = sprintf("SELECT * FROM ".TABLE_PREFIX."event WHERE visible = 1 AND (dateline_from > '%d' || ( dateline_from < '%d' AND dateline_to > '%d' )) ORDER BY dateline_from ASC LIMIT %d",TIMENOW,TIMENOW,TIMENOW,$show_count);

$event_get = vB::$db->query_read($query);

$output_bits = '';
while($event = vB::$db->fetch_array($event_get)) {

if($event['dateline_to'] == 0 )
{
$format = sprintf("On %s",date('jS M Y',$event['dateline_from']));
} else {
$format = sprintf("From %s to %s",date('jS M Y',$event['dateline_from']),date('jS M Y',$event['dateline_to']));
}

$output_bits .= sprintf('
<div class = "cms_widget_post_bit"><center><a href="calendar.php?do=getinfo&e=%d"><img src="http://www.YourForum.com/forum/images/event.jpg" width="200px" alt="Upcoming Event"/><h4 class="cms_widget_post_header">%s</a></h4>
<p class="cms_widget_post_content">%s</p></center>
</div>
',$event['eventid'],$event['title'],$format);

}
$output = $output_bits;


ob_end_clean();
return $output;



:)

[ProFifaLeagues]

Superb CybaGirl Much thanks!!!

[Thr33]

is there a way to show the times of the event? i have multiple events on the same day but at different hours, would be nice to show the hours also.

[wampforum]

instalkled this but have a coupe of questions - my dates are 1 day too early - even if I try the alternate code its still showing wrong (I prefer the layout on the first code anyway) is there a way to adjust this?

Second thing is there a way to make it pull dates from a single calendar? At the moment it also pulls from a private calendar

[Mr_Running]

instalkled this but have a coupe of questions - my dates are 1 day too early - even if I try the alternate code its still showing wrong (I prefer the layout on the first code anyway) is there a way to adjust this?

Second thing is there a way to make it pull dates from a single calendar? At the moment it also pulls from a private calendar

In regards dates are 1 day too early - if any changes are made to the events or calendar: Once the changes are complete: See if saving the widget block again - this may fix it.

I changed $format = sprintf("From %s to %s",date('jS M

Layout : I perfer not to have the word From to
$format = sprintf(" %s to %s",date('jS M

Sorry! I have not played/seen with the layout on the first code.

cheers:)

[cyberchief]

I can't get this to work. If I load the code with the images... the dates are correct. when loading the code without images (which is what I want)... it is a day to early. This is worthless if the dates aren't correct.

Anybody have this working without images where the dates are correct? If so... can you please post your code?

[Micha66]

hi, i installed this and it works fine.

how can i change the date in german format.

that means not On 30th Dec 2010, but Am 30. Dezember 2010

[ProFifaLeagues]

Glad to hear it's working well for you!
To be honest i have no idea how that would be done but if i can find out i will pm you and give the info asap.

[Micha66]

thanks for fast answering and thanks in advance for help ;)

[Gleedo]

Second thing is there a way to make it pull dates from a single calendar? At the moment it also pulls from a private calendar

Yes, I would also like to be able to pull events from a single calendar if possible. I have looked at the code but can't identify anything that looks like a calendar id :confused:

Nice mod though - good work :)

[Zweeper]

really like this one. but can i get the text a bit further away from the left side of the box? (not centered, just a bit further away)?

[ProFifaLeagues]

Just delete the Center tags and work from there for your positioning mate

[wickedstangs]

I can't get this to work my block is behind a day...:( how can I fix this..

Thanks

[ProFifaLeagues]

Did you load it with the images???
As otherwise it seems to show a day behind

[wickedstangs]

Did you load it with the images???
As otherwise it seems to show a day behind

Loaded it with the images and had to use this code.. and it works now...
$format = sprintf("On %s%s %s %s",date("j",$event['dateline_from'])+1, date("S",$event['dateline_from']), date("M",$event['dateline_from']), date("Y",$event['dateline_from']));

[ProFifaLeagues]

Cheers for the code it may well help out another user

[Raul7]

Loaded it with the images and had to use this code.. and it works now...
$format = sprintf("On %s%s %s %s",date("j",$event['dateline_from'])+1, date("S",$event['dateline_from']), date("M",$event['dateline_from']), date("Y",$event['dateline_from']));

thanks man, it helped me.

[Raul7]

guys is there anyway to show this on "NON" VB pages?

[ProFifaLeagues]

guys is there anyway to show this on "NON" VB pages?


Something i have'nt looked at mate but your welcome to have a go and do some testing to get it working on a non vbull page.

[Raul7]

Something i have'nt looked at mate but your welcome to have a go and do some testing to get it working on a non vbull page.

here is a the query for anyone intrested, as you see its very basic , you need to add the styling code on top of it, the reason i am not adding mine is everyone page is differing ! btw i am using Event forum, if u r not, take out any reference to lv_vb_eventforums_threadid !

<?php
require("db.php"); /*this is your DB connection file */
$ctime = time();
$query = "SELECT title , lv_vb_eventforums_threadid, dateline_from FROM event where dateline_from > '$ctime' ORDER BY dateline_from ASC LIMIT 2;";
$result = mysql_query($query) or die('Query failed: ' . mysql_error());

echo "<table width='290'>";

while ($row = mysql_fetch_assoc($result)) {
echo "<tr><td>";

echo "<a href='http://YOURFORUMLINK/showthread.php?".$row['lv_vb_eventforums_threadid']."' target=_blank>".$row['title']."</a>";

echo "<br /><b>On ";
$unixtime = $row['dateline_from'];


$realtime = date("F d", $unixtime + 86400);
echo $realtime."</b>";

echo "<hr></td></tr>";

}

echo "</table>";
mysql_free_result($result);
?>

i aint any advance PHP coder, so excuse my code if its very basic :D

[Mark4865]

Hello All,

Great mod and good work by all who contributed.

I have a few questions (you are talking to a technical idiot please bear that in mind when answering)

Will this work as a widget in CMS
Is there a way to have images to the left and event data on the right (any chance someone can show me full code to do this PLEASE)
If someone has worked out how to get it to work for single calendars please advise I run two calendars and would like to have a widget for each of them.

Many thanks in advance to anyone who takes the time to answer me

[bitbender]

I have a similar need, Mark4 - good of ya to ask - I was just searching for that function.

and btw - it works just fine in CMS - Just remember to return a variable of $results as instructed. The scripts above in the root post refer to $output..

1_ Admin CP - CMS - Widget Manager - Create Widget - Direct PHP execution type - Give it a title.
2) Select configure from the list after the addd of the widget and the code above of your choice. I will assume you know how to copy the code block and paste it.

3) In your pasted block, scroll all the way to the end - If the one you copied ends like this return $output;

Then change it to this: return $result;

Save it, and then add the block to a page layout you are using. Worked just like that for me in 4.1.1

now, to customize it by event :)

Cheers

[Raul7]

2 questions :

1- ) can someone explain what is // %d ? I am just trying to learn

2-) another issue i have right now is when an even is on Feb 9th, as soon as clock turn to FEB 9th, the even is gone, is it possible to keep it until end of the current date?

Thanks,

[Mark4865]

Hello BitBender

thanks for info, cutting and pasting just about covers my technical knowlege so I can manage that thanks.

I want a widget with images but the image on the left and text on the right, but the text should be limited to the title only that will take you to the event if click on it. Any chance you can help me with the code required to acheive that result?

Sorry I know I am asking a lot here

[Mark4865]

2-) another issue i have right now is when an even is on Feb 9th, as soon as clock turn to FEB 9th, the even is gone, is it possible to keep it until end of the current date?

Second that important point for me as well

[bitbender]

Hi Mark --

Getting that image like you want it is going to be some template work as they are calling a function to make that line up. To do what is wanted we'd have to track back, clone the function and makes changes, then change the widget to call your new function. I'd have to dig into that and I'm a bit crunched for time for the next 10 days or so.

Btw - Never change the base VBulletin templates - always make a new style and then modify the template to be changed in YOUR style - Save you it will, at upgrade time - bcause the default VB style will always work. I learned many years ago not to try to fool mother nature :)

Now, you may ask, how in tarnation would I do that? Simple - Export the default style to your 'puter as an xml file and then reimport it - following the guideline below;

Create a new style with no parent style and give it a NEW name - Like "MarksTest".

Leave it as non-selectable by users.
================================================
Now - You have your own little test style that you can do what you want with and no one but yor hairdresser will know for sure :) Once you get stuff like you want, you can publish your style to your community by making it selectable. Or cast it into the unknown depths of the bit-bucket and start over.

2nd post - Check your recurring dates/times - make sure the end time is beyond what you are looking at. On the site I am building, there is an event (http://www.jamgoodbluegrass.com/forums/content.php?45-documentation) that takes place this evening, but my calendar shows it and so does this mod as a widget in the CMS.

--> I also added location selection logic to seperate by location (based upon a rexexp i am looking for in the title field) so that I can list music events by location on location specific CMS pages, or lump them all together in a sidebar by using the basic widget above.

[Mark4865]

thanks for all the effort and info will have to think seriously about this as I dont want to mess with templates

[Mark4865]

Am I to understand this will work fine if I dont want the images on the side but leave them as is in their current position??

I just want the event title, date of event and a thumbnail picture, is that possible?? If so please advise exact code I need. Thanks in advance sorry for all the questions.

Mark

[way2xtreme]

hi, is there a way to show just the starting date for an event the carries over 2 days. I'd like to make this look tidy and neat.. thanks

[otterag]

a problem i am having with this is that i have not found a mod that will show a recurring event in an upcoming event widget on a daily basis instead of the range of its repeats.
I have the same type of event occuring every Friday at 3:00pm and instead of making 1 event for each Friday for the entire year i have made 1 that recurs every Friday for the rest of the year and my upcoming events widget shows instead Friday March 1st - 700pm it shows From March 1st to March 31st

is there any way to change the display output on this

from current
Event Name
From 1st March 2011 to 31st March 2011

to
Event Name
March 1st - 7:00pm

this is something that is really bothering me and i cant figure out how to make the changes after reading these boards for a few days and looking at the code. help would be greatly appreciated.

[southeastminis]

I've installed this and it works great, however I am trying to change the color of the background (where the events are actually posted.)

Anyone know what Stylevar this would be under?

[Mark4865]

Hello everyone need help please.

I have used this in the CMS with a few changes (images on right text on left) works great BUT cant get images to show. They show up fine in the actual event but not in the widget here is an example of my image address for one image www.mywebsite.co.za/temp%20logos/2-LongBeach_2010.jpg

this is the code I have used, how do I get the image to show

ob_start();


// %d
$show_count = 10;


$query = sprintf("SELECT * FROM ".TABLE_PREFIX."event WHERE visible = 1 AND (dateline_from > '%d' || ( dateline_from > '%d' AND dateline_to > '%d' )) ORDER BY dateline_from ASC LIMIT %d",TIMENOW,TIMENOW,TIMENOW,$show_count);

$event_get = vB::$db->query_read($query);

$output_bits = '';
while($event = vB::$db->fetch_array($event_get)) {

if($event['dateline_to'] == 0 )
{
$format = sprintf("On %s%s %s %s",date("j",$event['dateline_from'])+1, date("S",$event['dateline_from']), date("M",$event['dateline_from']), date("Y",$event['dateline_from']));

} else {
$format = sprintf("From %s to %s",date('jS M Y',$event['dateline_from']),date('jS M Y',$event['dateline_to']));
}

$output_bits .= sprintf('
<div class = "cms_widget_post_bit"><a href="calendar.php?do=getinfo&e=%d"><img src="http://www.YourForum.com/forum/images/event.jpg" width="75" height="60" alt="Upcoming Event" HSPACE="7" VSPACE="3" align="left"/><h4 class="cms_widget_post_header"><b>%s</b></a></h4>
<p class="cms_widget_post_content"><b>%s</b></p>

</div> <BR/><BR/>
',$event['eventid'],$event['title'],$format);

}
$output = $output_bits;


ob_end_clean();
return $output;

[Voeltz]

This.. is.. AMAZING!! :D thanks, works wonderfully:
http://goo.gl/p2SqP

[tomsch]

<a href="https://vborg.vbsupport.ru/showthread.php?t=231365" target="_blank">https://vborg.vbsupport.ru/showthread.php?t=231365</a>

this post has a corrected query that take into account time zone and dst.

[Mark4865]

Has anyone got this to work with images PLEASE.

Cant get the images to show???

HELP!!!!!!!!!

[Mark4865]

Help!!!!!!!!!! any one got this to work in the CMS with images

[Mark4865]

Anyone Help Please I have tried everything and I just cant get the images to show, has anyone got this working in cms????????

[ProFifaLeagues]

Sorry Mark i havent used this in the Cms setup at all!

Maybe best to post up Here (https://vborg.vbsupport.ru/forumdisplay.php?f=251)
for some Advice on the best way to ad the code for the Cms

[Mark4865]

Thanks I will try that earlier posters seemed to think it would work in the CMS, does it make a huge differnce that I have different images for different events, do all images have to be the same??

[ProFifaLeagues]

No as long as you have them with there correct addresses they should be fine...
Maybe post an exmaple of what your adding in the code to show these and we may spot something wrong

[Mark4865]

thanks for taking a look code show below

I have used this in the CMS with a few changes (images on right text on left) works great BUT cant get images to show. They show up fine in the actual event but not in the widget here is an example of my image address for one image http://www.mywebsite.co.za/temp%20lo...Beach_2010.jpg

this is the code I have used, how do I get the image to show

ob_start();


// %d
$show_count = 10;


$query = sprintf("SELECT * FROM ".TABLE_PREFIX."event WHERE visible = 1 AND (dateline_from > '%d' || ( dateline_from > '%d' AND dateline_to > '%d' )) ORDER BY dateline_from ASC LIMIT %d",TIMENOW,TIMENOW,TIMENOW,$show_count);

$event_get = vB::$db->query_read($query);

$output_bits = '';
while($event = vB::$db->fetch_array($event_get)) {

if($event['dateline_to'] == 0 )
{
$format = sprintf("On %s%s %s %s",date("j",$event['dateline_from'])+1, date("S",$event['dateline_from']), date("M",$event['dateline_from']), date("Y",$event['dateline_from']));

} else {
$format = sprintf("From %s to %s",date('jS M Y',$event['dateline_from']),date('jS M Y',$event['dateline_to']));
}

$output_bits .= sprintf('
<div class = "cms_widget_post_bit"><a href="calendar.php?do=getinfo&e=%d"><img src="http://www.YourForum.com/forum/images/event.jpg" width="75" height="60" alt="Upcoming Event" HSPACE="7" VSPACE="3" align="left"/><h4 class="cms_widget_post_header"><b>%s</b></a></h4>
<p class="cms_widget_post_content"><b>%s</b></p>

</div> <BR/><BR/>
',$event['eventid'],$event['title'],$format);

}
$output = $output_bits;

[Mark4865]

Anyone out there who can help me to get this to work with images in the CMS PLEASE

[ProFifaLeagues]

Mark this code is not the one you have entered is it???

<img src="http://www.YourForum.com/forum/images

You would need to link that to your forum address rather then Yourforum.com

[Mark4865]

No I tried to use my website address and the file locations but it didnt work

[Mark4865]

Okay Update:

I discovered the code I was using for the image is for a single image event and it will only show the same image for every event in the widget, although I still havent got it to show in the widget.

My question is does anyone know how to write the code so a different image for every event will show in the widget. I have the image showing up perfectly in the actual event does someone know what code to use to get the same image to show in the widget.

Desperate please

[TransAmDan]

Is there any way to display repeated events correctly?
We have an event every 2 weeks on a Tuesday, it displays fine in the calendar. However on the events list it displays

Club Night
From 7th Jun 2011 to 30th Dec 2012

It displays the start and end of the reoccurring event, but not the date it is on.

[RedTrinity]

Is there any way to display repeated events correctly?
We have an event every 2 weeks on a Tuesday, it displays fine in the calendar. However on the events list it displays

Club Night
From 7th Jun 2011 to 30th Dec 2012

It displays the start and end of the reoccurring event, but not the date it is on.

Having the same issue. Today is June 5th, and all I have displaying in our events box is the following recurring events from as early as March 1st....

N & D's wedding anniversary
From 1st Mar 2010 to 1st Mar 2013

E's birthday
From 3rd Mar 2010 to 3rd Mar 2020

J's Birthday
From 16th Mar 2010 to 16th Mar 2020

T & L's Wedding Anniversary
From 19th Apr 2010 to 19th Apr 2013

C's birthday
From 9th Jun 2010 to 9th Jun 2020


Kind of defeats the purpose of the mod when the events don't update :confused: Which is a shame, because its a great mod concept....

[Mark4865]

Hello,

Just noticed my dates are showing incorrectly as it shows 1 day late so I put in say 12/06 in the event but in the widget is shows 13/06. Code shown below how do I fix this please

ob_start();

// %d
$show_count = 10;

$query = sprintf("SELECT * FROM ".TABLE_PREFIX."event WHERE visible = 1 AND (dateline_from > '%d' || ( dateline_from > '%d' AND dateline_to > '%d' )) ORDER BY dateline_from ASC LIMIT %d",TIMENOW,TIMENOW,TIMENOW,$show_count);

$event_get = vB::$db->query_read($query);

$output_bits = '';
while($event = vB::$db->fetch_array($event_get)) {

if($event['dateline_to'] == 0 )
{
$format = sprintf("On %s%s %s %s",date("j",$event['dateline_from'])+1, date("S",$event['dateline_from']), date("M",$event['dateline_from']), date("Y",$event['dateline_from']));

} else {
$format = sprintf("From %s to %s",date('jS M Y',$event['dateline_from']),date('jS M Y',$event['dateline_to']));
}

$output_bits .= sprintf('
<div class = "cms_widget_post_bit"><a href="calendar.php?do=getinfo&e=%d"><img src="http://www.porscheplanet.co.za/images/misc/motorsport.gif" width="75" height="60" alt="Upcoming Event" HSPACE="7" VSPACE="3" align="left"/><h4 class="cms_widget_post_header"><b>%s</b></a></h4>
<p class="cms_widget_post_content"><b>%s</b></p>

</div> <BR/><BR/>
',$event['eventid'],$event['title'],$format);

}
$output = $output_bits;

ob_end_clean();
return $output;

[tomsch]

Hello,

Just noticed my dates are showing incorrectly as it shows 1 day late so I put in say 12/06 in the event but in the widget is shows 13/06. Code shown below how do I fix this please


as have said before the query used does not work properly in some cases.

there is a small "bug" in the way events sre stored for single day events as well as the query used to get the events does not adjust for time zone. the "bug" has been reported and is now confirmed. if you use the query for the other upcoming events widget i have posted you should have better luck with the dates.

[Mark4865]

as have said before the query used does not work properly in some cases.

there is a small "bug" in the way events sre stored for single day events as well as the query used to get the events does not adjust for time zone. the "bug" has been reported and is now confirmed. if you use the query for the other upcoming events widget i have posted you should have better luck with the dates.

Thanks for info tomsch appreciate it, any chance you can tell me what sections to change on my code as I have everything set up the way I need it just the date issue. Sorry hope I am not taking advantage here

[oldfan]

Ive tried and tried and I cannot get the block to show up :(

[ProFifaLeagues]

Ive tried and tried and I cannot get the block to show up :(


Oldfan I see your having the same issues with other mods for the forum block too,if you wish to send me some login info for your admin cp i will come across and add this for you later today.

[oldfan]

Thanks for getting mine to work and adding the custom welcome block rammieone !!

[netzwart]

This MOD is working fine in vB 4.0.8 ! Thank you !!!:)

However, there are two questions left:

1. The dates are shown in english, not in the selected language german, e. g. January instead of Januar. How can I change this ?

2. Is it possible to place the date in front of the event title ? I tried to change the order of the following lines, but it did not work:

<h4 class="cms_widget_post_header"><a href="calendar.php?do=getinfo&e=%d">%s</a></h4>
<p class="cms_widget_post_content">%s</p>

Thank you in advance!

Netzwart

[netzwart]

Second thing is there a way to make it pull dates from a single calendar? At the moment it also pulls from a private calendar

Change the code like this:

$query = sprintf("SELECT * FROM ".TABLE_PREFIX."event WHERE visible = 1 AND calendarid = X AND (dateline_from > '%d' || ( dateline_from > '%d' AND dateline_to > '%d' )) ORDER BY dateline_from ASC LIMIT %d",TIMENOW,TIMENOW,TIMENOW,$show_count);

X should be the ID of the calendar you want the events to be taken from.

I am not a professional programmer, i. e. an expert should have a look at it.

Netzwart

[bposner]

I've updated this widget with the code that was suppose to fix the date issue (displays one day behind) but this code did not fix the date issue.
Suggestions?
Thanks!

[fookaa]

Hi...

Is there a ay to get it to show the time also ??

[rhody401]

I tried all above variations, and the dates were still sometimes off one day.

My solution: I took out dates entirely, and I took out the images as well. Now it is just one line per event, with a descriptive link to the calendar. It's nice and compact.

Even though it required some tweaking, this code is fantastic and exactly what I was looking for.

THANK YOU!

Mike

[rhody401]

I wouldn't mind shrinking the print a bit, and adding a space between each entry. I couldn't figure that out, however.

It appears to be using block_html template. I can call this up, but don't want to change something that may hurt other areas of the system.

Any advice appreciated.

[ProFifaLeagues]

I wouldn't mind shrinking the print a bit, and adding a space between each entry. I couldn't figure that out, however.

It appears to be using block_html template. I can call this up, but don't want to change something that may hurt other areas of the system.

Any advice appreciated.
You could Just use simple Html markups to change the text sizes and add line breaks:up:

[rhody401]

The solution was simple. Thank you!

This "lite" version is what I applied, with slight modifications to reduce the text size, eliminate the images/missing image errors, and eliminate the misbehaving single date field.

I have only had my VB forum license for a week, but have learned so much from these forums that has helped me customize and configure it.

Thanks to all

ob_start();

// %d
$show_count = 4;

$query = sprintf("SELECT * FROM ".TABLE_PREFIX."event WHERE visible = 1 AND (dateline_from > '%d' || ( dateline_from < '%d' AND dateline_to > '%d' )) ORDER BY dateline_from ASC LIMIT %d",TIMENOW,TIMENOW,TIMENOW,$show_count);

$event_get = vB::$db->query_read($query);

$output_bits = '';
while($event = vB::$db->fetch_array($event_get)) {

if($event['dateline_to'] == 0 )
{
$format = sprintf(" ");
// $format = sprintf("On %s",date('jS M Y',$event['dateline_from'])); <-- broken/disabled
} else {
$format = sprintf("From %s to %s",date('jS M Y',$event['dateline_from']),date('jS M Y',$event['dateline_to']));
}

$output_bits .= sprintf('
<div class = "cms_widget_post_bit"><center><a href="calendar.php?do=getinfo&e=%d"><h4 class="cms_widget_post_header"><font size="2">%s</font></a></h4>
<p class="cms_widget_post_content"><font size="1">%s </font></p><p><font size="1">&nbsp;</font></p></center>
</div>
',$event['eventid'],$event['title'],$format);

}
$output = $output_bits;

ob_end_clean();
return $output;

[mgurain]

Could this be supported to make it work in 4.1.12 ?

Regards,,

[rhody401]

I'm using it with 4.1.12 PL1

[ProFifaLeagues]

Could this be supported to make it work in 4.1.12 ?

Regards,,

Confirmed working in 4.1.12

[mgurain]

It did not show anything to me !

[edytwinky]

has this been updated to show birthdays?

[ProFifaLeagues]

has this been updated to show birthdays?


No mate but its something you can quickly add in the code if needed.

[dlewisr]

Nice mod. Installed (4.2.0 (Patch 1) and rated

Thank you.

[Alibass]

Works great on 4.2.0 PL2 :):up:

Thanks...

[yoximusprime]

Does this update automatically? I've gotten it looking fine but if I add or remove events it doesn't seem to correct itself.

[ProFifaLeagues]

yes mate auto updates with any events you have

[Alibass]

I have an event scheduled for 2nd Nov 2012 but the display shows 2st Nov 2012 because of the time stamp being on the first.

Is there away to fix this so it displays correctly?

Thanks in advance.

WD

[Alibass]

I have an event scheduled for 2nd Nov 2012 but the display shows 2st Nov 2012 because of the time stamp being on the first.

Is there away to fix this so it displays correctly?

Thanks in advance.

WD
@ProFifaLeagues

I know you do not support this mod but you must have run across this issue somewhere along the line.

[ProFifaLeagues]

Try using this Code

ob_start();

// %d
$show_count = 4;

$query = sprintf("SELECT * FROM ".TABLE_PREFIX."event WHERE visible = 1 AND (dateline_from > '%d' || ( dateline_from < '%d' AND dateline_to > '%d' )) ORDER BY dateline_from ASC LIMIT %d",TIMENOW,TIMENOW,TIMENOW,$show_count);

$event_get = vB::$db->query_read($query);

$output_bits = '';
while($event = vB::$db->fetch_array($event_get)) {

if($event['dateline_to'] == 0 )
{
$format = sprintf(" ");
// $format = sprintf("On %s",date('jS M Y',$event['dateline_from'])); <-- broken/disabled
} else {
$format = sprintf("From %s to %s",date('jS M Y',$event['dateline_from']),date('jS M Y',$event['dateline_to']));
}

$output_bits .= sprintf('
<div class = "cms_widget_post_bit"><center><a href="calendar.php?do=getinfo&e=%d"><h4 class="cms_widget_post_header"><font size="2">%s</font></a></h4>
<p class="cms_widget_post_content"><font size="1">%s </font></p><p><font size="1">&nbsp;</font></p></center>
</div>
',$event['eventid'],$event['title'],$format);

}
$output = $output_bits;

ob_end_clean();
return $output;

[Alibass]

That removed the dates which I really did not want to do. :(

[bif95]

I have an issue with hours. Event is e.g. at 10:00 but the sideblock display 11:00

Any idea?

[ProFifaLeagues]

You can try to set your Time Zone to GMT Does this then work Fine??

[CSS59]

How do I get it to show Date first and then Event name please?

[edytwinky]

What code do you add to show birthdays?

[CSS59]

How do I get it to show Date first and then Event name please?

anyone please?

[Thommy]

Nice Mod! Works fine and easy for 4.2.0 PL2!!!

Is there a way to change Date Format in German?
Now is: 1st Dec.
Perfect for me is: 1. Dezember (or 1. Dez)

[ProFifaLeagues]

Nice Mod! Works fine and easy for 4.2.0 PL2!!!

Is there a way to change Date Format in German?
Now is: 1st Dec.
Perfect for me is: 1. Dezember (or 1. Dez)



Sorry Thommy I have never Used the German format so know little about it at all sir.
If i can find any info I will be sure to post back for you

[Thommy]

THX for your answer!

I found followings works:

search in your code this: %s",date('jS M Y'
and change it to: %s",date('j. F Y'

Before change: 1st. Dec 2012
After Change: 1. December 2012

At last change Phrases from December to Dezember (for German)

[PoorGuysGarage]

i'm thinking it has something to do with the following :

Specify the content you want to display. If this is PHP code, use a return statement to send your output to the block. For example:

$my_output = 'Hello, world.';
return $my_output;

I'm guessing i need to imput this somewhere in the code?

[zapiy]

Can i use this on VBadvanced as a module is some way please?

[CptBogo]

i have modified this a little bit for my forum and i thought i would share.

instead of
if($event['dateline_to'] == 0 )
{
$format = sprintf("On %s",date('jS M Y',$event['dateline_from']));
} else {
$format = sprintf("From %s to %s",date('jS M Y',$event['dateline_from']),date('jS M Y',$event['dateline_to']));
}

i used
$format = sprintf("On %s at %s", vbdate('jS M, Y',$event['dateline_from']), vbdate('g:i A', $event['dateline_from']));

this does a couple things different.

first i changed the format to look like 'On 5th Feb, 2013 at 8:00 PM'. the end date wasnt as important to us as the time the event started so i added the time and removed the end date.

second it uses the vbulletin 'vbdate' function instead of the PHP 'date' function. this will automatically change the date to the users timezone instead of using the servers timezone. remember to set 'Cache Time' to 0 in the forum block settings or else it will cache someone elses timezone and be incorrect for every other user.

hope this helps someone else trying to do something similar.

and a screenshot of how it looks on my forum.
https://vborg.vbsupport.ru/external/2013/02/43.png

[Filip]

Is there a simple way to have the date being displayed in a other language than english?

[rhody401]

I like the changes you made a couple posts before this one(VBDATE), but it still seems to show one day earlier than the scheduled date. (for all events on my calendar)

I have the cache set to 0, etc.

Any ideas why? Are you having the same issue?

[CptBogo]

Is there a simple way to have the date being displayed in a other language than english?

if the user logged into vbulletin has another language set in their profile the vbdate function should adjust it for their language. you might want to change the format the date is displayed in though vbdate("format here", time())
if you are familiar with PHP you might want to have a look at these functions:
http://www.php.net/manual/en/function.setlocale.php
http://www.php.net/manual/en/function.strftime.php
they work together, you use the first function to set the language you want to use and the second function creates the date string based on the language you defined in the first function. note that the vbdate function includes those 2 functions in it.


I like the changes you made a couple posts before this one(VBDATE), but it still seems to show one day earlier than the scheduled date. (for all events on my calendar)

I have the cache set to 0, etc.

Any ideas why? Are you having the same issue?

i did not have this issue. however it looks like others have been experiencing it. there are a couple solutions in this thread. but the easiest is probably:
$format = sprintf("On %s at %s", vbdate('jS M, Y',$event['dateline_from']+86400), vbdate('g:i A', $event['dateline_from']));
this simply adds 1 day(in seconds) to the events timestamp so when it gets the formatted date string its +1 day


also for those interested i have updated my own code to show 'Today', 'Tomorrow', etc instead of the day, month and year. if the date is more then a week in the future it will display the full day, month, year format(February 6th, 2013).

if(vbdate("dmY", $event['dateline_from']) == vbdate("dmY")) //it is today.
{
$format = sprintf("Today at %s", vbdate('g:i A', $event['dateline_from']));
}
elseif(vbdate("dmY", $event['dateline_from']) == vbdate("dmY", time() + 86400)) //it is tomorrow
{
$format = sprintf("Tomorrow at %s", vbdate('g:i A', $event['dateline_from']));
}
elseif($event['dateline_from'] < (time() + 604800)) //1 week = 604800 //it is this week
{
$format = sprintf("%s at %s", vbdate('l',$event['dateline_from']), vbdate('g:i A', $event['dateline_from']));
}
else
{
$format = sprintf("%s at %s", vbdate('l, F jS',$event['dateline_from']), vbdate('g:i A', $event['dateline_from']));
}

https://vborg.vbsupport.ru/external/2013/02/38.png



Edit: I have discovered an issue where full day events that do not have a start time specified dont display correctly. for example the last event in my screenshot, "Starcraft II Risk", should start at 12AM on Saturday and not on Friday. i do not currently have a way to fix this but when i do i will post an update.

[ITMerc]

Hi folks! How/where would you modify the code to insert a page break so you'd have an empty line between the date of the first event and the description/title of the NEXT event... I want to visually separate them.

[Hawkinz]

My block doesn't show up when PHP is selected. Any ideas? cheers

[rhody401]

I have modified this a bit to make it in a format for USA Month Day Year, and some other small changes. (my modified code below)

It would be REALLY nice if I could find a way to have it exclude some calendar items that have a specific string of text in the title. I just don't know where to put the hook to make this happen. Any suggestions appreciated! :) THANK YOU

example: If a calendar event has "BOARD MEETING" anywhere in the TITLE, it gets overlooked/ignored by this code. It displays everything else, but these events.

Here is my (current/modified from above) code:
ob_start();

// %d
$show_count = 9;

$query = sprintf("SELECT * FROM ".TABLE_PREFIX."event WHERE visible = 1 AND (dateline_from > '%d' || ( dateline_from < '%d' AND dateline_to > '%d' )) ORDER BY dateline_from ASC LIMIT %d",TIMENOW,TIMENOW,TIMENOW,$show_count);

$event_get = vB::$db->query_read($query);

$output_bits = '';
while($event = vB::$db->fetch_array($event_get)) {

if($event['dateline_to'] == 0 )
{
$format = sprintf(" ");

//changed code 2/6/13 adds a day to fix issue, and reformat for USA m/d/y
$format = sprintf("On %s", vbdate('M jS, Y',$event['dateline_from']+86400), vbdate('g:i A', $event['dateline_from']));

} else {
$format = sprintf("From %s to %s",vbdate('M jS',$event['dateline_from']),vbdate('M jS Y',$event['dateline_to']));
}

$output_bits .= sprintf('
<div class = "cms_widget_post_bit"><center><a href="calendar.php?do=getinfo&e=%d"><h4 class="cms_widget_post_header"><font size="2">%s</font></a></h4>
<p class="cms_widget_post_content"><font size="1">%s </font></p><p><font size="1">&nbsp;</font></p></center>
</div>
',$event['eventid'],$event['title'],$format);

}
$output = $output_bits;

ob_end_clean();
return $output;

Thanks in advance if anyone has the time to look at this and give some advice.

Much appreciated! :up:
Rhody

[CptBogo]

I have modified this a bit to make it in a format for USA Month Day Year, and some other small changes. (my modified code below)

It would be REALLY nice if I could find a way to have it exclude some calendar items that have a specific string of text in the title. I just don't know where to put the hook to make this happen. Any suggestions appreciated! :) THANK YOU

example: If a calendar event has "BOARD MEETING" anywhere in the TITLE, it gets overlooked/ignored by this code. It displays everything else, but these events.

Here is my (current/modified from above) code:


Thanks in advance if anyone has the time to look at this and give some advice.

Much appreciated! :up:
Rhody

ob_start();

// %d
$show_count = 9;

$query = sprintf("SELECT * FROM ".TABLE_PREFIX."event WHERE visible = 1 AND (dateline_from > '%d' || ( dateline_from < '%d' AND dateline_to > '%d' )) ORDER BY dateline_from ASC LIMIT %d",TIMENOW,TIMENOW,TIMENOW,$show_count);

$event_get = vB::$db->query_read($query);

$output_bits = '';
while($event = vB::$db->fetch_array($event_get))
{

if(!strpos($event['title'], "BOARD MEETING")) // do not show event
{

if($event['dateline_to'] == 0 )
{
$format = sprintf(" ");

//changed code 2/6/13 adds a day to fix issue, and reformat for USA m/d/y
$format = sprintf("On %s", vbdate('M jS, Y',$event['dateline_from']+86400), vbdate('g:i A', $event['dateline_from']));

}
else
{
$format = sprintf("From %s to %s",vbdate('M jS',$event['dateline_from']),vbdate('M jS Y',$event['dateline_to']));
}

$output_bits .= sprintf('
<div class = "cms_widget_post_bit"><center><a href="calendar.php?do=getinfo&e=%d"><h4 class="cms_widget_post_header"><font size="2">%s</font></a></h4>
<p class="cms_widget_post_content"><font size="1">%s </font></p><p><font size="1">&nbsp;</font></p></center>
</div>
',$event['eventid'],$event['title'],$format);

}

}

$output = $output_bits;

ob_end_clean();
return $output;

i have added a simple check if(!strpos($event['title'], "BOARD MEETING")) which says if the title does not contain BOARD MEETING. if it does have BOARD MEETING it skips the event and moves to the next one.

i havnt tested it but it should work.

[rhody401]

Thank you thank you thank you! :)

I had to take out the first few characters on top, and it is case sensitive, but very workable for what i'm trying to fix. I will fix the calendar entries to be the correct case, so they get ignored.

It does work!

Rhody

[CptBogo]

I had to take out the first few characters on top

im not sure what that means


and it is case sensitive

use stripos instead. that is a case insensitive search instead of the case sensitive strpos

[rhody401]

>I removed the first characters
im not sure what that means


use stripos instead. that is a case insensitive search instead of the case sensitive strpos

Oh what I meant is that it gave an error until i removed this from the start of the snippet: "<?"

It works fine without that at the very top of the code.

I also changed it to stripos, at your suggestion, and tested to confirm that it now works with mixed case.

Thank you so much for taking the time to help me with this. This is one that we use heavily on our forum, to show upcoming meetings and events.

:up:

[CptBogo]

>I removed the first characters


Oh what I meant is that it gave an error until i removed this from the start of the snippet: "<?"

It works fine without that at the very top of the code.

I also changed it to stripos, at your suggestion, and tested to confirm that it now works with mixed case.

Thank you so much for taking the time to help me with this. This is one that we use heavily on our forum, to show upcoming meetings and events.

:up:

oops sorry. i forgot to take out the <?. i edited my post to remove it for anyone in the future. and no problem, glad i could help.

[gajinoz]

Just installed this. Seems to work perfectly, thanks, good job.

[RichieBoy67]

I cannot get this working properly. it either shows the wrong date or does not display correctly after trying the fixes.

Can someone share their code they are using with 4.2.2?

i have it working now..I took some of the above fixes and made some changes and it is working now.

[audzilla]

Thanks, this is excellent!

Since DST started, though, I've noticed that sometimes events display as an hour later than they should, and sometimes they're fine. By default there's an 'ignore DTS' checkbox that is checked when creating a calendar event, but that doesn't really seem to affect what's displaying on the sidebar widget.

I'm not remotely a coder, but basically I can't figure out the interaction between the calendar's automatic DST stuff and the user profiles and this widget. Any suggestions?