Show Events on non-vb page

[Dave#]

I will pay anyone who can modify the following hack

http://vbulletin.com/forum/showthrea...threadid=21232

to do the following

• Run as a standalone script for inclusion in a non VB page
• Be able to pull the next 5 events from the callendar (not just todays events) from todays date (including todays events)

Payment is open to negotiation but this is an urgent requirement.

Payment will be via one of the following options depending on how you want paid

• paypal
• cheque
• bank transfer

Please PM me asap to get this work.

Please state:

a) The cost
b) the timescales

Thanks

Dave Campbell www.cpfc.org

[sysmom]

I'll bet Dave has a bigger budget than I do, but I'm pretty interested in this, as well.

Not neccesarily just the next 5 events, but the listings over the next X number of days would be good, too.

-deb

[boatdesign]

Me too!

Would love a mod which would show the next x events or events for the next x days on my homepage...

[Freddie Bingham]

PHP Code:

<?php

include('./global.php');
  
$events = $DB_site->query("SELECT event, eventdate, eventid, subject
                           FROM calendar_events
                           WHERE public = 1 AND eventdate >= '".vbdate('Y-m-d',time())."'
                           ORDER BY eventdate LIMIT 5");
if ($DB_site->num_rows($events)) {
  echo "Next Five Events:<br>";
  while ($event = $DB_site->fetch_array($events)) {
    echo "<a href='calendar.php?s=$session[sessionhash]&action=getinfo&eventid=".$event['eventid']."'>".$event['subject']."</a><br>";
  }
} else {
  echo "No Events";
}
?>

It should even be Kier approved in terms of quoted array indices but it may be subject to correction.

[Dave#]

Originally posted by freddie

PHP Code:

<?php

include('./global.php');
  
$events = $DB_site->query("SELECT event, eventdate, eventid, subject
                           FROM calendar_events
                           WHERE public = 1 AND eventdate >= NOW()
                           ORDER BY eventdate LIMIT 5");
if ($DB_site->num_rows($events)) {
  echo "Next Five Events:<br>";
  while ($event = $DB_site->fetch_array($events)) {
    echo "<a href='calendar.php?s=".$session['sessionhash']."&action=getinfo&eventid=".$event['eventid']."'>".$event['subject']."</a><br>";
  }
} else {
  echo "No Events";
}
?>

It should even be Kier approved in terms of quoted array indices but it may be subject to correction.

You really can't imagine how happy this makes me

People can spout off about other products 'community' and 'support' but VB is in a different class.

I'll leave it there b4 I start gushing

[Freddie Bingham]

It just shows you how do it, you will have to format it how you wish. If you are not going to use the event text than you can remove it from the SELECT portion of the query.

[Dave#]

Originally posted by freddie
It just shows you how do it, you will have to format it how you wish. If you are not going to use the event text than you can remove it from the SELECT portion of the query.

The formatting was a breeze as log as I escape "

It;s exactly as I needed 100% perfect and will save me lots of time every week

In action www.cpfc.org (latest fixtures)

[Mike Sullivan]

[QUOTE]Originally posted by Dave#
In action www.cpfc.org (latest fixtures)

[Dave#]

Originally posted by Ed Sullivan
It's linking to the wrong place though

http://www.cpfc.org/calendar.php?act...nfo&eventid=82 gives a 404.

Should be: http://www.cpfc.org/forums/calendar....nfo&eventid=82

And make sure that's not a hardcoded sessionhash -- I don't know if you're including vB elements, which would generate a new sessionhash or what.

Fixed that

Ed Can you explain the session hash thing please? Should the href be different than calendar.php?s=$session[sessionhash] ?

[sysmom]

Wow, this can go on a non-vBulletin page, too?

-deb