vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vB3 Programming Discussions (https://vborg.vbsupport.ru/forumdisplay.php?f=15)
-   -   Show Calendar entries on homepage (https://vborg.vbsupport.ru/showthread.php?t=168142)

magamaga1 01-19-2008 02:43 AM

Show Calendar entries on homepage
 
Is anyone still looking for this hack or did someone already post a way to extract events from a calendar based on how close that date is to today?

I have a solution but would like to see if there is any interest by the forum members.

thanks!

Serenity 01-19-2008 12:50 PM

i would be interested!

magamaga1 01-20-2008 09:45 PM

Well for everyone's benefit heres my hack to extract the next events from the calendar if they fall 10 days before today and 10 days after today.

The way you work with this script is that you put it in your crontab and if you can't put it in your crontab then you can include it in your homepage.

Putting it in your crontab is more effective because really you only want to run this script to run only once a day.

In your crontab ( crontab -e ) type 0 6 * * * php -q /location/of/your/script > /the/path/to/your/website/calendaritems.php

This will create a .php on your website and you can then edit your index.php to call the php by adding <? require("calendaritems.php"); ?>

If you can't put the script in crontab then you could alternatively just put in a file called "calendaritemsscript.php" and then doing a <? require("calendaritemsscript.php"); ?>

The downside of that is that your website will be hammering the database and pulling the info everytime a visitor comes to open your website. I highly recommend against doing it this way.

Here is the script:

<?
$connecttodb=mysql_connect("localhost","username", "password" ) or die ("Unable to connect to MySQL");

$calendarentries = "select eventid,title,DATE(FROM_UNIXTIME(dateline_from)),D ATE(FROM_UNIXTIME(dateline_to) ) from event where date_sub(now(),INTERVAL 10 DAY) <= FROM_UNIXTIME(dateline_from) and date_add(now(), INTERVAL 10 DAY) >= FROM_UNIXTIME(dateline_to)";

$db = mysql_db_query("forumdatabase", $calendarentries);
$numrows = mysql_num_rows($db);
echo "
<table width='260'>
<tr>
<td bgcolor=\"#15589B\" align='center'><b><font size='2' color='white'>Calendar of Events
</font></b></td>
</tr>
<tr>
<td>";

If ($db)
{
While ($pp = mysql_fetch_array($db))
{
$id = $pp["eventid"];
$title = $pp["title"];
$from = $pp["DATE(FROM_UNIXTIME(dateline_from))"];
$to = $pp["DATE(FROM_UNIXTIME(dateline_to))"];

echo "
<font size=1>
<a href=\"http://www.yourforumwebsite.com/calendar.php?do=getinfo&day=$from&e=$id&c=1id\" target=_blank> $title
</a>
</font>
<br>";
}
}
echo "</td>
</tr>
</table>
";
?>

Any questions, ask away.

Serenity 02-02-2008 10:51 AM

TY! i will be trying this out shortly


All times are GMT. The time now is 12:05 PM.

Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.

X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.01034 seconds
  • Memory Usage 1,713KB
  • 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)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (4)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