Hi all, here's the beta Calendar upgrade, the old version was on this thread <br /> <br />Please note that this is a beta... the calendar is working fine for me, but I had to play around with the installation instructions a lot, and there is a chance for error. <br /> <br />Hold on to your old files, backup your database, etc etc... you may want to hold off from installing this in a production installation until some other users give us some feedback. <br /> <br />Max <br /> <br />[PS - oops, I forgot to clarify, at the end of the installation instructions, that you should also upload your new showthreaded.php ]

Thanks Max <img src="/forum/images/icons/laugh.gif" alt="" /> - is there a demo anywhere of this running?<br /><br />Ian

<blockquote><font class="small">posted by Max Fisch:</font><hr /> Hi all, here's the beta Calendar upgrade<hr /></blockquote><br /><br />This is great, Max. Thank you for sharing your work. Is this Beta Calendar hack in use at your site, in the Events forum at The Hang?<br /><br />Thanks,<br /><br />Rob<br />

Yes it is.

I want to see it in action, where is it?

muchas gracias. will be installing here soon <img src="/forum/images/icons/laugh.gif" alt="" />

Looks great! Thank you.

you got a demo link? <img src="/forum/images/icons/tongue.gif" alt="" />

To really clean up this whole installation of the calendar one could attach the new files created to save time and then we simply would have to do a few basic steps to install this thing. Templates could also be made. I have updated the instructions a bit for those who want a simpler install and attach the neccesary files that are created which take alot of the work. Great work Max looks great.<br />

Agreed Omega, but Infopop has objections to posting complete modified scripts. That's what I did when I released V2, and Allen was kind enough to change it to a "differential" version. <br /><br />Max<br />

Ah so things are different that UBB for UBBThreads??? <br /> <br />When one downloads a hack at UBBDEV.com the file contains the new files which are not normally a infopop file. I did not include modified UBBThreads files. I just included in the above post a modified install file and addevent.php and newevent.php. These are not infopop files. I figured from the rules I have read this is allowed. It is done in the UBB forum all the time. Oh well if I am mistaken my bad. Download any hack over at UBBDEV and the non infopop files are included in the distribution. I just thought this would save people time hacking as I installed your hack and it works good. It took along time creating addevent.php and newevent.php hense my post above. <br /> <br />Allen: If I am mistaken on the rules simply remove my attachment. The three files included in the attachment are an updated install and the two files created which are addevent.php and newevent.php

This calendar works great for me, thanks Max <img src="/forum/images/icons/smile.gif" alt="" />

You're welcome, enjoy <img src="/forum/images/icons/smirk.gif" alt="" /> <br />Max

I haven't yet looked at the files, but if they don't contain Infopop code, then they should be fine.<br /><br />We can share templates and language files, but no php files (with IP's code).<br /><br />Thanks for asking <img src="/forum/images/icons/smile.gif" alt="" />

Well based on your thinking then remove the attachment. Because any modified file even hacked and discombobulated contains still IP work. Weird the rules must have changed in the last 6 months or rather stricter in enforcement <img src="/forum/images/icons/wink.gif" alt="" />. Oh well my bad.

Hi Max<br />I installed the Calendar update for 6.02 and it went in like a dream. Very Easy. Thanks a Million, My users apreciate it.

You're welcome, good to hear - sorry it took me so long.<br />Max

Hey Max, just a question or two. My users have been dying without a calendar, so I really want to get it running. But knowing it is still in the working stages, how easy is it going to be to upgrade to newer versions/fixes you come out with? <br /><br />I just wonder because it is a very in-depth hack, and just wondering what it will take to make any changes, or if your updated instructions for the new releases will specifically address upgrade issues?

Hello msula,<br /><br />It shouldn't be too hard to upgrade once you install it: I don't anticipate any database changes, and if you look at it, the only file that's changing from the standard code is postlist.php (the rest of the files are new). So re-installing an upgraded version shouldn't be particularly hard.<br /><br />Regards,<br />Max<br /><br /><br />

Thanks, sounds great then!

Max:<br /><br />Can you provide a link to a demo so we can see how this works?

Hey max, or anyone? I installed the hack, everything works great, except my posts for new events don't show up in the calendar itself, only below it as a post <img src="/forum/images/icons/frown.gif" alt="" /> What could be the problem?<br /><br />Check it out<br />http://www.michiganjeepers.com/forums/postlist.php?Cat=&Board=calendar<br /><br />Also, I know the arrow images don't work, that's fine for now <img src="/forum/images/icons/smile.gif" alt="" />

I had the same problem -- not showing up in the calendar, but in the list. Before I had a chance to really pour over it and see what I missed, omegatron posted the attachment above, I used that to check what I'd missed, and there was a whole section I missed in addevent I believe. I really wish I could tell you what it was, but I don't think I have a copy of what I had before I fixed it. I'll look though, I have Beyond Compare set to automatically backup things I change. Heaven knows I don't ever remember. <img src="/forum/images/icons/grin.gif" alt="" /> <br /> <br />I have a working version here: <br />http://www.fishingfordeals.com/forums2/postlist.php?Cat=&Board=calendar <br /> <br />if anyone wants to try it. It's just an empty testboard, and you should be able to post anonymously.

I get access denied with that link, and the calendar doesn't show up in the main index.

<img src="/forum/images/icons/blush.gif" alt="" /> I'm sorry, please try again. It should work now. <img src="/forum/images/icons/wink.gif" alt="" />

I used omega's attachment and uploaded the two add*.php files and it works fine now <img src="/forum/images/icons/confused.gif" alt="" /> I followed those instructions perfectly I thought and went very slow. Hmm... but anyway, its working <img src="/forum/images/icons/wink.gif" alt="" />

<img src="/forum/images/icons/laugh.gif" alt="" /> I thought I followed them pretty closely too. There is either an error in the original instructions, or something that's confusing and caused me to put it in the wrong spot. <img src="/forum/images/icons/crazy.gif" alt="" />

I'm just wondering if any existing hacks had originally edited the files that were used to create those two new ones.. don't see anything missing yet, but I can't remember half the hacks I installed <img src="/forum/images/icons/laugh.gif" alt="" />

If you figure it out, please let me know so I can edit the instructions.<br /><br />Regards,<br />Max

looks very good on your site, and I must say, your whole site really has improved over the last few months <img src="/forum/images/icons/smile.gif" alt="" /> nice work.

Hi Max,<br />one problem I had is when I delete an event it does not delete from the main database? is there an updated editpost? or did I miss something?

<blockquote><font class="small">posted by AllenAyres:</font><hr /> looks very good on your site, and I must say, your whole site really has improved over the last few months <img src="/forum/images/icons/smile.gif" alt="" /> nice work. <hr /></blockquote><br /><br />Who's site were you commenting on? I was hoping mine, but I doubt it.. lol <br /><br />Just wondering <img src="/forum/images/icons/smile.gif" alt="" />

Yours, someone I know is outgrowing ubb, I pointed them to your site as an example of a good threads site <img src="/forum/images/icons/smile.gif" alt="" />

Oh yay! I just got tingles, I'm so happy. haha j/k<br /><br />But for real, thanks. It is growing fast, but threads is keeping up just fine. A few issues to work out with my header and everything will almost be set. Oh, and IIP 5.0 will be nice too <img src="/forum/images/icons/wink.gif" alt="" />

Just one thought - how complicated would it be to display today's date in a different colour so that it stood out?<br /><br />Ian

Max, or Dave, any thought on making this work for a pal box <img src="/forum/images/icons/wink.gif" alt="" /> Basically, just a box that contained a mini-calendar with numbers, but the days that had something planned those boxes are a different color and when clicked on take you to the associated event?

Pappy,<br />see the notes in the instructions starting on line 14.<br />When you delete a post, it does get deleted from the main w3t_Posts table as usual, but not from the new "Events" table. The idea is that unless you're deleting hundreds of events, I judged that the tradeoff between modifying an additional script and just leaving a few "dead" entries in the Events database wasn't worth it.<br /><br />Having said that, see the "Additional note" in the instructions starting on line 30 - if you really want to delete entries in the Events database, you could adapt/update from this old thread <br /><br />Regards,<br />Max<br />

That's pretty easy... in postlist.php, find <br /><br /> if (($d == $thisDay) && ($mon == $thisMon)) {<br /> echo " class=\"darktable\"><table width=\"100%\" cellpadding=\"0\" cellspacing=\"0\"><tr><td>$d.</td>";<br /><br />This prints the starting point for today's cell. It shows up in "darktable" colors, and other days show up in "lighttable" colors. You can either modify these in the stylesheet you use, or you can modify the above lines to your liking. The $d prints today's day of the month, so you could replace it with <font=red>$d.</font> or something like that.<br /><br />Regards,<br />Max<br />

That would be pretty cool<br />Maybe Dave would consider building it... He could steal the formatting from the box on http://ubbdesign.com/ <img src="/forum/images/icons/smile.gif" alt="" /><br /><br />Max<br /><br />

One suggestion though. It would be nice to post an event one time with a beginning and end date one time instead of having to post it all say 3 days. An example lets say would be a 3 day convention. If one wants to post this it would have to be posted 3 times on every day instead of one post which would then fill the corresponding days correctly on the calendar.

agreed.. since some events we have are weekend long events. Maybe have the starting day a full descript in the box, and in concurrent boxes it just says part of the event title and says "cont..." or something just to show it continues on.

Max, <br /> <br />i'm just playing with this really nice hack ... any chance to get the displayed time in postlist.php changed to 24h - format? <br /> <br />Should be anwhere at <br /> <br />$h = strtolower(strftime ("%I", $tm)); <br /> <br />(I've removed the am/pm correction successfully before)

Dave had written a PAL box for this in his first release of IIP for ubbt 5.5. It displays any upcoming events for the next week. I still use this pal box on my 6.0.2 board. <br /> <br />Since the table structure for the events table has not changed, the old pal code works just fine. <br /> <br />It dosent display a "mini calendar" but it does list all current upcoming events.

Hiya Max.<br /><br />Just FYI. <br />That code that JustDave wrote to delete the data from w3t_Events works fine with v6.<br /><br />Also. I noticed in the w3t_Events table there are fields for recurring events, and Duration. Any plans to make use of these features in the future?<br /><br />Thanks!

Sorry Stefan, over my head, maybe someone else can help.<br />Max

Nice one <img src="/forum/images/icons/smile.gif" alt="" /> Testing here right now.. I redid the instructions to fix the xhtml in the code:<br /><br />http://www.threadsdev.com/mods/6/52455-instructions.txt<br /><br />It runs fine, if I find some more xhtml bugs, I'll update the file and post here <img src="/forum/images/icons/smile.gif" alt="" />

File updated with lots of little fixes <img src="/forum/images/icons/smile.gif" alt="" /> The only thing not 100% xhtml is bordercolor and I am too sleepy to fix it right now <img src="/forum/images/icons/wink.gif" alt="" /> I think I transferred all the changes from our files here to the instructions, if you see something different, please let me know and I'll update it <img src="/forum/images/icons/smile.gif" alt="" />

<blockquote><font class="small">posted by AllenAyres:</font><hr /> File updated with lots of little fixes <img src="/forum/images/icons/smile.gif" alt="" /> <hr /></blockquote><br /><br />Allan, all of your changes had to do with the xhtml compliency correct?

Yes, I didn't change anything else <img src="/forum/images/icons/smile.gif" alt="" />

Suggestion:<br /><br />In UBB.classic's calendar it automatically adds an event for a registered users birthday.<br /><br />It would be great if we could get this calendar to do the same.<br />You could add an optional field inside the w3t_users table.

That might be good to co-ordinate with anything Rick might be working on regarding coppa, and the ubb.classic import script, as birthdays are already required there.

OK, it should be a bit easier to install now. I believe it is 100% xhtml compliant as well. <br /><br />http://www.threadsdev.com/mods/6/calendar.zip<br /><br />I included the template files pre-done and updated the instructions so that you are requiring the templates into the posting pages instead of adding the contents to the .php files. We are using these same files here.<br /><br />Next up will be pulling the text out to make a language file... I'll work on it this weekend or so unless someone else wants to jump in there <img src="/forum/images/icons/wink.gif" alt="" /><br /><br />Max feel free to do with this how you want, thank you for your work in getting it to v6 status <img src="/forum/images/icons/smile.gif" alt="" />

MAX,<br /><br />This is AWESOME <img src="/forum/images/icons/wink.gif" alt="" /><br /><br />I have one problem...?<br />I attempted your step nine(after I made sure everything else was working ok) and I CANNOT get the date and location to show up in the Subject line?<br /><br />Nothing is breaking, it's just not showing up?<br /><br />Any ideas, I have double checked the edits.<br /><br />Cheers, Bill<br />

Thanks Max,<br /><br />Was a piece of cake to install some 15 calendars on my forums, for the various clubs that I have. Now they can all have their own calendar, and not all have to share one.<br /><br />Thanks again.<br /><br />Ian

I would change the UPDATE to be using the "Keyword" instead of the "Title".<br /><br />I ran into problems with this because of multiple forums in different categories which have the same title!<br /><br />I know this is just in your instructions and I simply used the Keyword to avoid any problems...but just an FYI nonetheless.<br /><br />REALLY enjoying your work <img src="/forum/images/icons/grin.gif" alt="" /> <br /><br />Cheers, Bill

Just got this IIP integration working with IIP4.3 and .threads 6.0.2... <img src="/forum/images/icons/smile.gif" alt="" /> Wasn't hard at all, so if anyone needs the code, let me know and I can post it (with instructions) here.

For European users, i tried this in postlist.php:<br /><br /> // get what weekday the first is on<br /> $tempDate = getdate(mktime(0,0,0,$mon,1,$year));<br /> $firstwday= $tempDate["wday"]-1; //HACK: Monday starts week instead of Sunday: '-1' added<br /> if ($firstwday==-1) {$firstwday=6;} //HACK: Monday starts week instead of Sunday: first day should not be -1<br /><br /><br />And here: (update the header namings...)<br /> <tr class=\"tdheader\"><th>Montag</th><th>Dienstag</th><th>Mittwoch</th><th>Donnerstag</th><th>Freitag</th><th>Samstag</th><th>Sonntag</th></tr><br />

If you want to translate the calendar, <br />some code needs to be added after this: <br /> <br /> if ($action = "findDate") { <br /> $theDate = getdate(mktime(0,0,0,$mon,1,$year)); <br /> $month = $theDate["month"]; <br /> } <br /> <br />Add this: <br /> <br />//Hack im hack translation <br /> <br /> <br />switch($month) { <br /> case "January": <br /> $month2 = "Januar"; <br /> break; <br /> case "February": <br /> $month2 = "Februar"; <br /> break; <br /> case "March": <br /> $month2 = "M&auml;rz"; <br /> break; <br /> case "May": <br /> $month2 = "Mai"; <br /> break; <br /> case "June": <br /> $month2 = "Juni"; <br /> break; <br /> case "July": <br /> $month2 = "Juli"; <br /> break; <br /> case "October": <br /> $month2 = "Oktober"; <br /> break; <br /> case "December": <br /> $month2 = "Dezember"; <br /> break; <br /> default: <br /> $month2 = $month; <br />} <br />$month = $month2; <br />//Hack im hack ende <br /> <br />This is an example for German, you can change that after your needs for your language. Note that only Month names are changed in this example that are different in English than German. <br /> <br />

> $h = strtolower(strftime ("%I", $tm)); <br /> <br />maybe: <br /> <br />$h = strtolower(strftime ("%H", $tm)); <br /> <br />But I am still working to catch all those time-things myself, for example in addevent.php, this format change needs to be done, i think: <br /> <br />$date_string = date("j. n. Y, G:i",mktime ($hour_convert,$min,0,$mon,$day,$year)); //HACK AMPM <br /> <br />

What does that >>> and »»» mean?<br />I did not find out when what symbols are displayed.<br /><br /> if ($i > 0) {<br /> $events .= "<hr width=95% align=center><font color=red><b>&#8250;&#8250;&#8250;</b></font> $Evnt<br>";<br /> } <br /> else {<br /> $events .= "<font color=red><b>&raquo;&raquo;&raquo;</b></font> $Evnt<br>";<br /> } <br /><br /><br />By the way: those >>> needs to be changed to that &#8250;&#8250;&#8250; code, or the MAC displays messy gremlins.

Since I converted the Calendar somehow into German (not finished yet), I really start liking the idea of having one. <br /> <br />Thanks Max for your great work. <br /> <br />One thought: Do you think it is useful of having all the calendar entries also listed underneath? <br />The more entries the calendar has the more double information the page will have. I think I would prefer not showing the entries underneath but to have only the calendar displayed. - Other oppinions? <br />

<blockquote><font class="small">posted by caymuc:</font><hr /> One thought: Do you think it is useful of having all the calendar entries also listed underneath?<br />The more entries the calendar has the more double information the page will have. I think I would prefer not showing the entries underneath but to have only the calendar displayed. - Other oppinions?<br /> <hr /></blockquote><br /><br />That is kind of my concern. After getting some use on my site I find people seeing a new post and they reply to it thinking today is the day of the event and such. I think it would be better t force users to just click the boxes and then be taken to the post info and replies.

Hey Caymuc, if you can share your German files, it would make it easier for me to finish the language file for the calendar <img src="/forum/images/icons/smile.gif" alt="" /><br /><br />Pretty please... <img src="/forum/images/icons/smile.gif" alt="" />

Hi, send me your email address to info @ chrom.de<br />I would mail you the code, as it is right now.<br /><br />I prefer not to post my stuff online, it is translated but far from beeing finished. Also I changed this and that. So normal users would be rather confused than inspired by the hacks, but you will know what ro pick from it. <img src="/forum/images/icons/smile.gif" alt="" /><br /><br />Greetings

<blockquote><font class="small">posted by paulf:</font><hr /> It dosent display a "mini calendar" but it does list all current upcoming events. <hr /></blockquote><br /><br />The next one does. <img src="/forum/images/icons/wink.gif" alt="" />

<blockquote><font class="small">posted by JustDave:</font><hr /> <blockquote><font class="small">posted by paulf:</font><hr /> It dosent display a "mini calendar" but it does list all current upcoming events. <hr /></blockquote><br /><br />The next one does. <img src="/forum/images/icons/wink.gif" alt="" /> <hr /></blockquote><br /><br />tease! <img src="/forum/images/icons/tongue.gif" alt="" /> how close are you nowadays? <img src="/forum/images/icons/cool.gif" alt="" />

hehehe I should have my test site open to public preview before this month is over with. I'm working on putting in a few extra rabbits to pull out of the hat for everyone's amusement... lol<br /><br />This next version will be easier to set up but there will be alot of setting up to do... lol

Hi Caymuc,<br />It's relatively easy to hide the entries... that's how I had it at first, but my readers complained about not being able to easily identify new replies. This was the compromise I came up with, but other ideas are welcome.<br />Regards,<br />Max<br />

I can't wait, JustDave.<br /><br />the users on my board were very tickled with your world class IIP add-on that we're running with UBBT v5.5.1 at www.retailflorist.com.<br /><br />I want to install the calendar add on etc but I'm thinking of waiting til the end of the month once you have it as a pal box.<br /><br />would it be better to install it now and tiptoe up to your next release when it comes out or is it better to wait do it all in one big shot?<br /><br />thanks,

I would venture to say that you will be glad you waited. <img src="/forum/images/icons/wink.gif" alt="" />

<blockquote><font class="small">posted by JustDave:</font><hr /> I would venture to say that you will be glad you waited. <img src="/forum/images/icons/wink.gif" alt="" /> <hr /></blockquote><br /><br />okay, so you're saying I should wait and do it all in one big shot then?<br /><br />what will you be releasing?<br /><br />I haven't been keeping that up to date on features.<br /><br />thanks,

He's been working on the new IIP 5 for quite some time, what has it been, 6 months? lol j/k <img src="/forum/images/icons/laugh.gif" alt="" /><br /><br />But yeah, he's made some tremendous changes (or so I've heard) and like he said, it will be worth the little while to wait to do that. <img src="/forum/images/icons/smile.gif" alt="" />

great thanks,<br /><br />but this suspense is killing me.<br /><br />what are some of the new features it will have?

Here are updated instructions for 6.1

You forgot in the directions how to create a forum to be a calendar. How do I do this??

Hmm, it's not mentioned in the original directions. If memory serves, I think you just make a normal forum. I called mine 'calendar' in the keyword, and used that in the script where you put in your forum's keyword.

In the table w3t_boards (or prefix_Boards) set Bo_Calendar to Y in the calendar forum (s). I think?

Aglavalin and Pappy are both right <img src="/forum/images/icons/wink.gif" alt="" /><br /><br />First you set a special forum up named Calendar. Now when you first did this hack you did an SQL command. This inserted Bo_Calendar under W3T_Boards. Simply make sure any forum you want a calendar in mark Y. In my case I have one forum named Calendar like above. I have ALL forums marked N and only one forum marked Y. This will create the desired effect of one special place for a calendar like here at Threadsdev etc.

Just checking..<br /><br />The only difference between the calendar week from western > european is that Monday starts off the european week?<br /><br />

Yes...<br /><br />Doesn't it in most countries?<br /><br />

LoL I don't know...<br /><br /><br />When I was stationed in Germany I never noticed... (was there for 2 years) LoL <img src="/forum/images/icons/blush.gif" alt="" /><br /><br /><br /><br />In the US Sunday is the first day of the week, not Monday.

yes, and hours count 0:00-23:59 instead of 0.00 AM - 23.59 PM, thats all the difference I think.<br /><br />Greetings Carl<br /><br />

Thanks <img src="/forum/images/icons/smile.gif" alt="" /><br /><br />I hadn't thought about allowing for the 24 hour format (military time) but I'll get it in. <img src="/forum/images/icons/smile.gif" alt="" /><br /><br />Switching from European to Western calendar weeks is configurable. I wan't to place an extra setting in users prefs so they can chose what type they see but if they haven't chosen a calendar week type it falls back on what ever the default is set to. <img src="/forum/images/icons/smile.gif" alt="" />

Sounds pretty cool! I am very curious now.<br /><br />In case you need help with German language files, let me know.

IIP 6.0's text has been completely moved to seperate language files and is stored in the same manor as .threads' is. <img src="/forum/images/icons/smile.gif" alt="" /><br /><br />This last version was just something I threw together from the pieces parts I had laying around. LoL I just wanted to give everyone something to kill time with. <img src="/forum/images/icons/wink.gif" alt="" /><br />

<blockquote><font class="small">posted by caymuc:</font><hr /> yes, and hours count 0:00-23:59 instead of 0.00 AM - 23.59 PM, thats all the difference I think.<br /> <hr /></blockquote><br /><br />No - we prefer to use 0:00am to 11:59pm - oh and don't forget to allow for the fact that we drive on the left, still use our own currency and rule the world <img src="/forum/images/icons/wink.gif" alt="" /> Okay the last one might not be true these days <img src="/forum/images/icons/smile.gif" alt="" />

Ohh I figured that out... The problem or thing that needs adding is... When you "Create" a forum. You should add a Radio Button on "Is this forum a Calendar?" If yes it does the Y and no it does the N... Just my 2 cents...<br /><br />Also a bug... I put in an event. Then I went to delete it and it gave me some weird error (cant remember it) and the stats for the forum still show the message being there but it isn't... Any suggestions...

It does not remove the event name and date from the w3t_events table, you need to manually remove it. phpmyadmin works great for this.

Well shouldn't we make it so it does??

Yeah, that would be a good idea. Also having it show the event date and title in the post body would be good so ya know when the event is from the post info.

Yeah that would be nice also <img src="/forum/images/icons/smile.gif" alt="" /> Especially for the Calendar's that are Moderated...

when I run-<br /><br /> CREATE TABLE w3t_Events (<br /> E_ID int(9) DEFAULT '0' NOT NULL auto_increment,<br /> E_CalendarID int(9) unsigned DEFAULT '0' NOT NULL,<br /> E_Number int(9) DEFAULT '0' NOT NULL,<br /> E_Date int(11) unsigned DEFAULT '0' NOT NULL,<br /> E_Time int(11),<br /> E_Duration int(11) DEFAULT '0' NOT NULL,<br /> E_Recurring char(1) DEFAULT 'N' NOT NULL,<br /> E_Recurtype varchar(10),<br /> E_End int(11),<br /> E_Frequency int(11),<br /> E_Days varchar(7),<br /> E_Location text,<br /> PRIMARY KEY (E_ID),<br /> KEY E_CalendarID (E_CalendarID)<br />);<br /> <br /><br /><br />I get-<br /><br />Results from your SQL command <br /> <br />Here are the results of your command: "CREATE TABLE w3t_Events ( E_ID int(9) DEFAULT '0' NOT NULL auto_increment, E_CalendarID int(9) unsigned DEFAULT '0' NOT NULL, E_Number int(9) DEFAULT '0' NOT NULL, E_Date int(11) unsigned DEFAULT '0' NOT NULL, E_Time int(11), E_Duration int(11) DEFAULT '0' NOT NULL, E_Recurring char(1) DEFAULT 'N' NOT NULL, E_Recurtype varchar(10), E_End int(11), E_Frequency int(11), E_Days varchar(7), E_Location text, PRIMARY KEY (E_ID), KEY E_CalendarID (E_CalendarID) ); ".<br />SQL ERROR: Unable to do_query: CREATE TABLE w3t_Events ( E_ID int(9) DEFAULT '0' NOT NULL auto_increment, E_CalendarID int(9) unsigned DEFAULT '0' NOT NULL, E_Number int(9) DEFAULT '0' NOT NULL, E_Date int(11) unsigned DEFAULT '0' NOT NULL, E_Time int(11), E_Duration int(11) DEFAULT '0' NOT NULL, E_Recurring char(1) DEFAULT 'N' NOT NULL, E_Recurtype varchar(10), E_End int(11), E_Frequency int(11), E_Days varchar(7), E_Location text, PRIMARY KEY (E_ID), KEY E_CalendarID (E_CalendarID) ); <br />You have an error in your SQL syntax near '; ' at line 16 row(s) affected by your query. <br /> <br /> <br />

Hmm, I didn't change that create table command when I updated the directions to 6.1, so they should still work. It looks like you have a space after the ; from your quote of '; ' so perhaps it got added on from a copy and paste?

anyone know if this hack works with 6.1.1?<br /><br />Thanks!

It works just fine with 6.1.1 Pappy. I am glad that I installed it.<br /><br />One question though from me: Until we wait for Rick to do some magic with the birthdays etc., I noticed that on the events table there are some fields like E_Duration, E_Recurring, E_Recurtype, E_End and E_Frequency<br /><br />Can we set those fields and if yes to what, so that if I enter someone's birthday (say 12/12/1980) it will appear every year on the 12/12th?<br /><br />That will save loads of input for the admins.<br /><br />Thanks in advance<br /><br />Warm regards<br /><br />Nikos

The events table is part of the calendar 3.0 addon, and I think those fields were never implemented by Max.<br /><br />Birthdays should go in the user table along with the other user information.

does this version of calendar work with 6.1 ?

Charles,<br /><br />Dimipoulous indicated (in a few posts above yours) that it seemed to work in 6.1.1 so I presume it would work in 6.1 - YMMV, since I haven't had the opportunity to try it myself.<br /><br />Cheers,<br /><br />Rob

Yes it works in 6.1, I posted updated instructions above somewheres...

An optional note:<br /><br />When you specify a board to be a calendar, it shows at the top of the screen and below it you can see the list of all the entries you made - as events.<br /><br />If you do not wish this to be shown - only the calendar to be visible you need to do the following:<br /><br />Open postlist.php<br />Go to the end of the file and find:<br /><pre><font class="small">code:</font><hr><br /> if (!$debug) {<br /> include ("$thispath/templates/$tempstyle/postlist.tmpl");<br /> }<br /></pre><hr><br />and change it to<br /><pre><font class="small">code:</font><hr><br />if($Calendar != "Y")<br />{<br /> if (!$debug) {<br /> include ("$thispath/templates/$tempstyle/postlist.tmpl");<br /> }<br />}<br /></pre><hr><br /><br />Warm regards<br /><br />Nikos

Make Note... You forgot the making of the templates

Here are 2 suggestions for the calendar incase you guys haven't thought of it. If you have please ignore it:<br /><br />1. Edit Event so that we can change the information about the event.<br />2. Put the Event information into the original subject line of the original post.

Another one....<br /><br />Add a date that it goes under for the actual thread listings. If you put new posts at the top and someone inputs something for a date a few months ahead, there is no decent way to figure it out.

2 more suggestions.<br />1. Add an option for All Day Events. <br />2. Set it so that if you change the time offset in the display settings it also changes on the calendar as well.

Here is a proposed change for the calendar to fix timeoffset issues.<br /><br />In postlist.php:<br />Look for<br />$h = strtolower(strftime ("%I", $tm));<br /><br />Add Above it:<br />$tm = strtotime($html -> convert_time($tm, $user['U_TimeOffset']));<br /><br />There should only be 2 entries.<br /><br />------------------------<br />In AddEvent.php<br /><br />Look For <br />$user = $userob -> authenticate("U_Username, U_Password,U_Signature,U_Picture,U_Groups,U_Display,U_Language,U_Totalposts,U_Title,U_Color,U_TempRead,U_TextCols,U_TextRows,U_EReplies,U_Preview,U_Number");<br /><br />Change it to<br />$user = $userob -> authenticate("U_Username, U_Password,U_Signature,U_Picture,U_Groups,U_Display,U_Language,U_Totalposts,U_Title,U_Color,U_TempRead,U_TextCols,U_TextRows,U_EReplies,U_Preview,U_Number, U_TimeOffset");<br /><br />Look for:<br />$ETime = mktime ($hour_convert, $min, 0, 0, 0, $year);<br /><br />Change it to:<br />$ETime = mktime ($hour_convert - $user['U_TimeOffset'], $min, 0, 0, 0, $year);<br /><br />And that's it. Then Timeoffset will work properly.

Is this mod compatible with 6.2?

I don't believe it will be. Since this works off of the information stored in the w3t_Posts table which has been changed for 6.2 it will probably break this mod. I haven't seen the code for 3.0 and can't remember if Max went with a table join between the events table and the posts table to grab the information. If so this will also be a problem since .threads 6.2 uses a table join between the Users table and the Posts table and adding an additional table will most likely impact speed. (without a lot of work in streamlining things)

About adding an extra table join to the Users table:<br /><br />This only seems to apply to postlist.php (and I'm not even sure if the username is needed there). So wouldn't the additional overhead only occur when viewing the calendar? Is so, I wouldn't think that would be a big deal.

I've modified the version of this hack in this post to work with 6.2dev4.<br /><br />I can upload it after 6.2 public beta is available, if there's interest. I'm not sure who's currently maintaining this hack, and I'm not really interested in maintaining it.<br /><br />Questions:<br /><br />1) What version # should this be called?<br /><br />2) I know that Max Fisch and Allen Ayers have worked on the hack. Is there anyone else, so that I can list the authors?

I haven't looked at 3.0's code so I couldn't say for sure but I know you know your stuff Dave so I'm sure it's all good. <img src="/forum/images/graemlins/smile.gif" alt="" /><br /><br />Yeah the extra overhead should only occur during calendar viewing. The last time I seen it running here I recall a good 30-40 queries being needed when there was a few events listed. Is there a way to cut them down? Just a thought. <img src="/forum/images/graemlins/smile.gif" alt="" />

GameJag ? I believe started things rolling. Max picked it up from him and moved it forward. Then Allen got the templates/xhtml into working order and some fixes too, I believe. I would say those are the 3 main authors prior to your update. Anyone else have some input on this?

30-40 queries<br /><br />This is probably what you were seeing:<br /><br /><pre><font class="small">code:</font><hr>// loop through all the days of the month<br />while ( $d <= $lastday) {<br /> ...<br /> select E_ID,E_Date,E_Time,E_Location,B_Subject, B_Number, B_Replies<br /> FROM w3t_Events, w3t_Posts<br /> WHERE E_Date >= '$lowdate'<br /> AND E_Date < '$highdate'<br /> AND B_Number = E_Number<br /> AND B_Board = '$Board_q'<br /> ...<br />}</pre><hr><br /><br /><br />(This query originally was also selecting U_Username, but the username wasn't used anywhere, so I simply took it out, and there was no need to add a join to the users table.)<br /><br />Maybe that's what dimopoulos was talking about in his Fetching data in an array post.<br /><br />I suppose the query could be done before the loop, extracting the data for the whole month, and storing it in an associative array. Do you think it would make sense to do that?

Yeah I think it would be much better done that way. I'm not much for calendars but those that use them alot will have a lot less load on their servers. <img src="/forum/images/graemlins/smile.gif" alt="" />

I am really not too sure about the Load issues but I used a version 3.1 and redid some of the tags so that it would display properly on all the stylesheets. (IE month and other text areas that used the default black text. Also I added some stuff to change the border color on the current day for stylesheets that had light table and dark table using the same or similar backgroud colors. My server is at www.greatlakesalliance.com and our Calendars are used fairly often and have events for most days. I am really a newbie when it comes to actually writing any code that works. Lots of trial and error here and I am not sure if any of the stuff I have done is "optimized" I would be very interested in any new stuff done with this. Also Dave, I really apreciate all the effort you and the other Users here have done over the past couple years here and at wwwthreads when it was still live. <br /><br />Justdave, you used to have a Calendar pal in one of the older IIP versions (3.x I believe?) is there any way I can get a copy of that one from you so I can modify it to work with the current version of threads/IIP?<br /><br />Thanks a million everyone!!<br /><br />Pappy

The calendar pal is laying around here somewhere. I'll dig it out this coming week and put in to the next minor upate for IIP. I have IIP working with the upcoming release of .threads and will post the updated IIP when .threads 6.2 is pubicly available. <br /><br />As far a server load with the calendar addon I don't think smaller sites will have much of an issue with it. I was considering the "what if" when a site has 10 or 20 users browsing the calendar and possibly creating 300 - 800 queries in that area alone.<br /><br />I think Dave_L will have this problem resolved though. <img src="/forum/images/graemlins/smile.gif" alt="" />

Ok, I've moved the query out of the loop. The events are now stored in an array. Here's the header comment for the function that stores the data:<br /><br />// Get all the events for the specified month.<br />//<br />// The events are extracted from the database Events table, and stored in the<br />// array $events_for_month, which is indexed by the day of the month.<br />//<br />// Events are stored in ascending order of date (E_Date).<br />//<br />// Examples:<br />// $events_for_month[5] is an array containing the events for the fifth day of the month.<br />// $events_for_month[5][2] is an array containing the third event for the fifth day of the month.<br />// $events_for_month[5][2]['E_Location'] is a scalar containing the E_Location column for the third event<br />// for the fifth day of the month.<br /><br />function get_events_for_month($month, $year) {<br /><br />Does this look reasonable? It seems to work correctly.

I don't see any problems with that at all. <img src="/forum/images/graemlins/smile.gif" alt="" /> I bet that dropped the query count considerably too. <img src="/forum/images/graemlins/smile.gif" alt="" />

I didn't notice the query count before, but it's about 11 now. The number of queries has been reduced by one less than the number of days in the month.<br /><br />I was wondering if that three-dimensional array might take up a lot of memory, if there were a large number of events for the month.

As far as using the array for storage untill it's sent to the browser I don't think it will be a problem since .threads does the same thing for it's displays before being sent to the templates.

Thanks Dave,<br /><br />That was exactly what I wanted to do = reduce the number of queries.<br /><br />Warm regards<br /><br />Nikos