Re: [MRBS-general] Quick list of rooms and status

[Mike F. <mik...@gm...>]

Hey,

Thanks for your reply.

Sorry should have explained the start and end time info more. What I was a
bit confused about, was when I converted the UNIX timestamp for a few of the
database entries, the start time was something like 12:07 and the end time
was 12:08 - how does this link to the session times?

So, we have
Session 1, Session 2, Session 3 etc which are times throughout the day. So
say we add a book for
20th November 2008 - Session 1 (which is 9am - 10am) how can I find this in
the database by using the start and end time? Should the start unix
timestamp = 20th November 2008 9:00am and the same accordingly for the end
time?

Thanks for your help

Kind Regards
Mike


On Wed, Nov 19, 2008 at 6:44 PM, Campbell Morrison <
ma...@ca...> wrote:

> Not quite sure what you need to know about the start and end times:
> they are Unix timestamps as in
> http://www.php.net/manual/en/function.time.php
>
> Depending on what you're trying to achieve, one easy way of getting a
> list of currently booked and free rooms is to have a link or a button
> or a page which just goes to the day view for the current day and
> setting timetohighlight in the query string to the current day (having
> made sure that it matches one of the slots).    For example
>
>
> http://www.yoursystem.com/day.php?year=2008&month=11&day=19&area=1&timetohighlight=1030
>
> This will then give you the day view with the current time slot
> highlighted.    Of course, this just gives you a visual
> representation.   If you want a list of rooms to feed into another
> application then you'll have to do something else.
>
> Campbell
>
>
>
> On 18/11/2008, Mike Fairbrother <mik...@gm...> wrote:
> > I've been trying to create a MOD which is a simple page, no functions on
> it
> > - apart from it'll pull in a list of the rooms and next to each room tell
> > you if it's available at that present time.
> >
> > For example
> >
> > Room 1 is currently available
> > Room 2 is currently unavailable
> >
> > This will be based on whether or not it's booked in the database.
> >
> > I can't get the mod to work properly because I can't understand the start
> > and end time. It's not the session times which confuses me.
> >
> > Can anyone advise how this could work or how the start_time and end_time
> > works so I can code around that accordingly.
> >
> > Cheers
> > Mike
> >
>
> -------------------------------------------------------------------------
> This SF.Net email is sponsored by the Moblin Your Move Developer's
> challenge
> Build the coolest Linux based applications with Moblin SDK & win great
> prizes
> Grand prize is a trip for two to an Open Source event anywhere in the world
> http://moblin-contest.org/redirect.php?banner_id=100&url=/
> _______________________________________________
> mrbs-general mailing list
> mrb...@li...
> https://lists.sourceforge.net/lists/listinfo/mrbs-general
>