[Done] Calendar Mod [Ver 1.4]

[Myiasis]

I am still having a time with this database thing. I can email someone a screen shot of what this database consists of so far. I believe I have the first table created fine;yabbse_calendar. I get lost when you alter table yabbse_calendar add index idx_year_month (year, month) Then I went to me yabbse_settings and I have two entries there variable, which is tinytext, and values, which is text. Where do I need to put 'cal_minnyear',''2001' and the rest of the yabbse_settings? I am probably making this waaaaaaaaay too dificult. I used boardmod to submit the mod to my board. I haven't uploaded it to the server yet because of the MySql database questions. Should I see what I have? I am completely lost can someone please help?   Thanks

I may have made things harder than they needed to be with the comments I put in the middle of all those database changes. Some of those comments were not compatible. Try downloading the file again -- I've changed the comments in the Readme.txt file to be friendlier.

It sounds like you are still typing in the database changes by hand? Each of those lines in the readme file are valid database statements, you don't have to type anything in at all (other than fixing the <prefix> like you mentioned). All you have to do, once the <prefix> is changed in the text, is highlight all the database lines, copy them to the clipboard (like you do in any other windows program), tab over to your telnet client which is logged into the 'mysql' program, and paste those lines into the telnet client. Every one of those lines can be run in the mysql client. There's no need to understand what the lines are doing, like the alter table statement, just trust that it works and run all those lines. Not that understanding what it is doing is bad, but it isn't necessary to do the mod.

Steps:
1) Start up your telnet program, log into your website and start the 'mysql' client program. Change to the database that has the YaBBSE tables.
2) Open up Readme.txt do a search and replace on the "<prefix>", change to "yabbse_" or whatever you used for a database prefix on the tables.
3) Highlight all of the database changes. There is a comment at the start and a comment at the end of them to make it easier to spot. You can include the comments in the lines you highlight.
4) Hit Ctrl+C, or use the menu Edit|Copy.
5) Tab to your telnet client.
6) Paste those lines into the telnet client. Menu: Edit|Paste. Your telnet client will send all of those lines to the 'mysql' program which will run them all doing all the changes for you.

[D8TA]

I got the information into the database. Thanks that worked like a charm. I also put the calendar.php file into my sources directory and placed the linktocal.gif and the other .gif files into my images directory. I don't see anything changed on my board. Where do I make the changes to the index.php, modsettings.php, display.php,post.php? What and where is the mod file? Are these automatic or do I have to manual do something. Slowly but surely I'll get this calendar. Thanks

[Myiasis]

I think BoardModSE has instructions with it. There is a link to the program as a sticky message in this category.

[nferreri]

Thank you so much for creating this mod Myiasis!

You have NO idea how much more productive this has made my board.  I use YabbSE for a communications portal for an Everquest guild and this Calendar mod has just made scheduling of raids (dates where everyone gets together to kill things) SOO much easier.

Previously, we were posting events in a forum (announcement board) and this is an awesome upgrade for organizational purposes!  This has to be the best mod I've seen for YabbSE.. very clean code and VERY efficient methods... congrats on a great job.

Some things I changed:  bunch of cosmetic html stuff to pretty it up a bit and make it fit with my dark colors... also, i changed the sql string for bdays to make it so people who weren't a member of a group didn't show up... guild members didn't want to see visitor bdays on the calendar....

the security and viewing method of events is genious... i couldn't have thought of a better way to do it...

thanks so very much again.

[raus]

I like very much this mod, and i was just wondering... would it be too hard to allow viewing current day from main page? What should i edit to bring the current's day box to my main page?


Thx

[Myiasis]

You have NO idea how much more productive this has made my board.  I use YabbSE for a communications portal for an Everquest guild and this Calendar mod has just made scheduling of raids (dates where everyone gets together to kill things) SOO much easier.

The funny thing about that comment is that was the reason I made the calendar. I don't play EQ much anymore but I created the calendar for my EQ guild board for raids.

I like very much this mod, and i was just wondering... would it be too hard to allow viewing current day from main page? What should i edit to bring the current's day box to my main page?

That is on my todo list already. There will be an option to include events on the main board index. I had only planned on putting events in there, but I suppose it could include all the information for that day.

I'm planning to spend some time this weekend to try and finish up the items on my todo list: 1) Week Numbers as option, 2) Allow events to span multiple days, 3) Add calendar info to board index as option, 4) Make events work with the Move Thread option.

[Hypocrite]

You have NO idea how much more productive this has made my board.  I use YabbSE for a communications portal for an Everquest guild and this Calendar mod has just made scheduling of raids (dates where everyone gets together to kill things) SOO much easier.

The funny thing about that comment is that was the reason I made the calendar. I don't play EQ much anymore but I created the calendar for my EQ guild board for raids.

I like very much this mod, and i was just wondering... would it be too hard to allow viewing current day from main page? What should i edit to bring the current's day box to my main page?

That is on my todo list already. There will be an option to include events on the main board index. I had only planned on putting events in there, but I suppose it could include all the information for that day.

I'm planning to spend some time this weekend to try and finish up the items on my todo list: 1) Week Numbers as option, 2) Allow events to span multiple days, 3) Add calendar info to board index as option, 4) Make events work with the Move Thread option.

That would be awesome.

[D8TA]

I was attempting to modify my board with boardmod 2.5se adding this calendar mod and in step 3 of 19 I get an error.
No Matching string found
Search string start
   else if ( $fastfind =='c') { if( $action == 'changemod') {setmod;}
search string end.  
Any suggestions?

[Myiasis]

I was attempting to modify my board with boardmod 2.5se adding this calendar mod and in step 3 of 19 I get an error.
No Matching string found
Search string start
   else if ( $fastfind =='c') { if( $action == 'changemod') {setmod;}
search string end.  
Any suggestions?

Have you installed any other mods? That's a line from index.php... If BoardMod can't find the lines it's probably from something else changing the line it is looking for. What you have to do in a case like that is look at the Calendar.MOD file and find that line. There is only the one change to index.php in the .MOD file. You'll have to apply the change by hand. Look at your index.php and compare that section of code to what the .MOD file wants in there.

If you aren't comfortable trying to figure that out either email me or post here what the block of code looks like where you see the if( $fastfind == 'c' ) -- Include all of the text starting with the == 'c' through the #END FASTFIND C* line.

[D8TA]

I was attempting to modify my board with boardmod 2.5se adding this calendar mod and in step 3 of 19 I get an error.
No Matching string found
Search string start
   else if ( $fastfind =='c') { if( $action == 'changemod') {setmod;}
search string end.  
Any suggestions?

I manually looked at the files and all the added strings seem to be included. Not sure why boardmod gave me that message. Now all I should have to do is upload these files back to the server and it should work correct?  Thanks

[Myiasis]

I manually looked at the files and all the added strings seem to be included. Not sure why boardmod gave me that message. Now all I should have to do is upload these files back to the server and it should work correct?  Thanks

Yes, just upload all the changed files. Make sure you have backups of your original files in case something doesn't go well.

[D8TA]

Thanks Myiasis for all your help and support. Especially for this mod!! The calendar does work. Hooray!!   This is a GREAT enhancement to my board. One last questions, how or where do I change the month font color? Thanks again! God Bless.

[opus]

There is one more enhancement I would love to see    To allow certain members to be able to post to the calendar without being part of a particular group and now opening it up to everyone.  

[Myiasis]

Thanks Myiasis for all your help and support. Especially for this mod!! The calendar does work. Hooray!!   This is a GREAT enhancement to my board. One last questions, how or where do I change the month font color? Thanks again! God Bless.

Hrm, just noticed I hard coded the color in for the table caption. I used the style sheet for everything else so that it would match your board colors, but the text color there was too dark. For now, just find the <caption> HTML tag in Calendar.php and you'll see the HTML color in the <font> tag. Can change that to whatever you like. Maybe I'll make that color a setting.

[Myiasis]

There is one more enhancement I would love to see    To allow certain members to be able to post to the calendar without being part of a particular group and now opening it up to everyone.  

That would be really easy to do. I'll put that in while I'm making these other changes. It will be additive with the other post permissions: Everybody can post OR they belong to a group you have given permission to OR it's a specific user name.