Web Wiz - Green Windows Web Hosting

  New Posts New Posts RSS Feed - Calendar - Adding Events for over 2 or more dates?
  FAQ FAQ  Forum Search   Events   Register Register  Login Login

Calendar - Adding Events for over 2 or more dates?

 Post Reply Post Reply Page  <123>
Author
dfrancis View Drop Down
Senior Member
Senior Member


Joined: 16 March 2005
Location: United States
Status: Offline
Points: 442
Post Options Post Options   Thanks (0) Thanks(0)   Quote dfrancis Quote  Post ReplyReply Direct Link To This Post Posted: 08 September 2006 at 5:07pm
I would like to collaborate on the momma project too.
 
My biggest concern on that and other PHP/MySQL examples has been exposing the entire database results in the Ajax scripts. For example, see the auto-complete example he has. I worked for days on that and could find no way at all to prevent all data from being available to someone who really wanted my data. (Trying to prevent sharing a list of local businesses.)
 
Anyway... I'm keenly interested in your continued development... thanks and welcome home. Smile
Back to Top
bootcom View Drop Down
Senior Member
Senior Member
Avatar

Joined: 26 February 2005
Location: United Kingdom
Status: Offline
Points: 259
Post Options Post Options   Thanks (0) Thanks(0)   Quote bootcom Quote  Post ReplyReply Direct Link To This Post Posted: 08 September 2006 at 8:22pm
Cheers Clap
 
It's good to get back to the forums and back into my projects. The portal project I've been working on has taken a year and is still being developed. Doing this has definately given me more respect for what Bruce has done with the site. It's extremely satisfying to get the kind of positive feedback that he's had.
 
On the subject of week planner, I'm no longer using AJAX, as that uses XML open to database manipulation and security violations. Instead, I'm using remote scripting with the ASP scripts checking for authentication.
 
PHP is so different than ASP and is more like .net technology (which I really need to get into).
 
I'm putting all of this up over at www.bootcom.co.uk my website so if you want to see how it's going will put some links up on there.
Back to Top
bootcom View Drop Down
Senior Member
Senior Member
Avatar

Joined: 26 February 2005
Location: United Kingdom
Status: Offline
Points: 259
Post Options Post Options   Thanks (0) Thanks(0)   Quote bootcom Quote  Post ReplyReply Direct Link To This Post Posted: 09 September 2006 at 1:43pm
Ok here's the first screen shot of this mod that I've almost completed. Basically, here's what I've done.
 
  • Changed the event date field in tblTopic to event_date_start
  • Added event_date_end field to the same table.
  • Changed the SQL queries in forum_topics.asp / forum_posts.asp / functions/calendar.asp to allow for the new field names.
  • Done a couple of modifications on calendar.asp to instead of checking for the event date to check for dates equal to or greater than event_date_start but less than or equal to event_date_end.
  • Updated the add new topic page to include a popup calendar like the one mentioned by dfrancis. Unfortunately the one I've added doesn't include firefox support so I'll probabaly use the one from DHTMLgoodies.com.
  • Updated the new_post.asp page as the SQL queries went seriously haywire when going through the first time.
  • I'm going to put a copy of this on my website shortly. I'm going to get my brother to go through and comment the code that I've changed.

Not too bad though started this mod less than 2 hours ago and in that time I've had lunch too LOL

 
Back to Top
dfrancis View Drop Down
Senior Member
Senior Member


Joined: 16 March 2005
Location: United States
Status: Offline
Points: 442
Post Options Post Options   Thanks (0) Thanks(0)   Quote dfrancis Quote  Post ReplyReply Direct Link To This Post Posted: 09 September 2006 at 7:27pm
"Not too bad though started this mod less than 2 hours ago and in that time I've had lunch too"
 
Depends on what you had for lunch. LOL... just kidding.
 
Not bad at all!!!!!!!
Back to Top
dfrancis View Drop Down
Senior Member
Senior Member


Joined: 16 March 2005
Location: United States
Status: Offline
Points: 442
Post Options Post Options   Thanks (0) Thanks(0)   Quote dfrancis Quote  Post ReplyReply Direct Link To This Post Posted: 10 September 2006 at 11:22am
Originally posted by bootcom bootcom wrote:

Cheers Clap
 
On the subject of week planner, I'm no longer using AJAX, as that uses XML open to database manipulation and security violations. Instead, I'm using remote scripting with the ASP scripts checking for authentication.
 
 
I'm glad to read that someone else shares my concerns. I thought I was being overly protective or that my Air Force "InfoSec" training was bleeding through.
 
I like some of the DHTML stuff that is being developed as a result of Ajax and there are some great things that can be done with the utilities of Ajax but just as Bruce has written before, many of those things were already being done long before the phrase "Ajax" was coined.
 
Anyway, I'm looking forward to see what you come up with on the calendar and other mods you plan to work on. Good to have you here.
 
(Early morning ponderings by an old man in Bowling Green, Kentucky USA)


Edited by dfrancis - 10 September 2006 at 11:22am
Back to Top
bootcom View Drop Down
Senior Member
Senior Member
Avatar

Joined: 26 February 2005
Location: United Kingdom
Status: Offline
Points: 259
Post Options Post Options   Thanks (0) Thanks(0)   Quote bootcom Quote  Post ReplyReply Direct Link To This Post Posted: 10 September 2006 at 1:13pm
Right, I've integrated the popup calendar from DHTML goodies. This basically means that an extra stylesheet link needed to be added to the new_topic_form.asp page. If you don't add that stylesheet link, it looks an absolute mess !!! The below screenshot shows what it looks like with the stylesheet, nicely formatted (but so far all this is untested in FF)
 
 
Once you have posted this new topic, here's how it looks on the calendar.asp page Big%20smile
 
 
You can now see the multiple entries for this calendar, for 2 events. There doesn't seem to be any issues with the overlap or anything like that. The weekly calendar page still needs modifying to include multiple day event support. I will also go in and add some js validation so that when the event start date is changed, the event end date is automatically the same. Whoever takes this MOD on, I'd add some server side validation to do a check to make sure the start date is less or equal to the end date.
 
Just to add to your point on the last post, AJAX wasn't really developed for the "old" ASP language anyway, it's more of a .net thing from what I can see. For me though remote scripting is the best way forward. Maybe I'll get round to learning .net one of these days, or maybe I'll wait a good 10 years until they phase ASP out. Seems to me that whatever ASP.net can do ASP can do just as well, ASP just isn't as simplistic and straightforward.
Back to Top
Mikey View Drop Down
Senior Member
Senior Member

1979

Joined: 06 October 2003
Location: United Kingdom
Status: Offline
Points: 839
Post Options Post Options   Thanks (0) Thanks(0)   Quote Mikey Quote  Post ReplyReply Direct Link To This Post Posted: 10 September 2006 at 1:51pm
Looks good so far mate..

P.S. i like the title of the forum lol
Handyman man?
Back to Top
bootcom View Drop Down
Senior Member
Senior Member
Avatar

Joined: 26 February 2005
Location: United Kingdom
Status: Offline
Points: 259
Post Options Post Options   Thanks (0) Thanks(0)   Quote bootcom Quote  Post ReplyReply Direct Link To This Post Posted: 10 September 2006 at 3:41pm
Originally posted by Mikey Mikey wrote:

Looks good so far mate..

P.S. i like the title of the forum lol
 
LOL hehe .... the things that happen when your scripts fold on you a couple of dozen times
Back to Top
 Post Reply Post Reply Page  <123>

Forum Jump Forum Permissions View Drop Down

Forum Software by Web Wiz Forums® version 12.08
Copyright ©2001-2026 Web Wiz Ltd.


Become a Fan on Facebook Follow us on X Connect with us on LinkedIn Web Wiz Blogs
About Web Wiz | Contact Web Wiz | Terms & Conditions | Cookies | Privacy Notice

Web Wiz is the trading name of Web Wiz Ltd. Company registration No. 05977755. Registered in England and Wales.
Registered office: Web Wiz Ltd, Unit 18, The Glenmore Centre, Fancy Road, Poole, Dorset, BH12 4FB, UK.

Prices exclude VAT at 20% unless otherwise stated. VAT No. GB988999105 - $, € prices shown as a guideline only.

Copyright ©2001-2026 Web Wiz Ltd. All rights reserved.