27 Responses for "MySQL Calendar - V1.2: Multilingual"

1. DSK August 31st, 2007 at 2:45 pm 1

   Hi, i’m using your mysqlcalendar (thanks for create it) and i have a suggestion. Could it use ajax or some kind of “loading system”?, because when you click on a day it’s too slow to load the text or notes. It would be interesting to add some loading gif, but i don’t know exactly how to do this :-/ (sorry for my english)

   Bye

2. Jamie August 31st, 2007 at 5:10 pm 2

   Hi DSK,
   Thanks for the suggestion, i totally agree.
   I’ll build that into it over the weekend or first part of next week and post it up…
   I’ll email you when its ready so you can have a look..

   Thanks for your continued support.
   Jamie.

3. gopinath September 6th, 2007 at 8:20 am 3

   nice

4. Markus September 9th, 2007 at 4:04 pm 4

   I have it working purfect locally, after uploading the site to a live server I cannot seem to log in — I havent changed the default logins either.If I try admin, admin it kinda loops back to the original page. If i try to enter say admin, whatever it tells me the pw is incorrect. It appears to be cheing properly but whats seems to be the problem with loggin in? Please have a look here:
   http://www.oswegowebdesign.com/djdonwan/calendar-iframe.html

   Try to log in with the defaults please. Thanks for anyhelp given this is a great little calendar.

   Markus

5. Jamie September 12th, 2007 at 12:50 pm 5

   Hi Markus,
   I had a look at your site, can you try running this SQL on the ‘Calendar’ database:
   —————–
   UPDATE user SET username=’admin’, password=’d033e22ae348aeb5660fc2140aec35850c4da997′ WHERE id=’1′ LIMIT 1
   —————–

   This will reset the username and password to ‘admin’.
   If you are unable to login after that i would check your database connection.

   Jamie

6. Omar September 15th, 2007 at 12:06 am 6

   Hi, This calender looks great in you demo. When I tried to Implement it on my site I get this error
   Forbidden
   You don’t have permission to access /Calendar/rpc.php on this server.

   Additionally, a 404 Not Found error was encountered while trying to use an ErrorDocument to handle the request.

   Any idea what might be causing it

7. Tim September 22nd, 2007 at 3:14 am 7

   Nice job on the Calendar. I have a few questions for you I hope you can answer.

   How do I get this Calendar to display in another page? (I do not want it by itself I would like it on the main index home page in the lower left corner.

   Also how do I remove the login on the Calendar? I would like to be the only on logging in and or no that it can be done so I would like a separate login page (admin area) if possible.

   Also If in the event I put an email in how do I make it work as an email us link so it opens the users default mail program?

   Feel free to email me anything for this.

   Thanks Much

   Tim

8. The House Network » Blog Archive » Coding a simple Ajax Calendar with a MySQL backend October 2nd, 2007 at 8:00 pm 8

   [...] Jamie’s MYSQL Calendar code [...]

9. MG October 18th, 2007 at 12:07 am 9

   Hi,

   I’ve embedded the calendar in a page I’m working on and I still get what Markus above said even though I reset the SQL Uid and pw. It stays on login without going to control panel.
   The site is:

   http://jeromewashingtonexpress.com/jwe_website/JWE_Calendar/index.php

   Any suggestions?

   Thanks
   MG

10. David October 28th, 2007 at 8:45 pm 10

    Is there any way to do so that the users doesn’t need to enter a password when they want to add something in the calendar?

11. .iznogud October 31st, 2007 at 4:43 pm 11

    Hi, I am trying to include calendar instead of i-framing it into the page, and I have:

    1. moved everything into “kalendar” folder,

    2. made a copy of the file “index.php” named “kalendar.php”, and called include_once(”kalendar/kalendar.php”); in my page where I wanted calendar included,

    3. edited kalendar.php so that left php code intact, removed section and moved from there 3 tags to the head of my page,

    3. moved startCalendar(0,0); all the way to the bottom of my page,

    but it is not yet functioning for me. I have left an original index.php intact in the folder /kalendar/index.php and it works fine.

    I would appreciate any quick pointers for this problem. If you got it to work already before me as an included file instead of standalone page, please let me know at iznogud@gmail.com

12. .iznogud October 31st, 2007 at 5:30 pm 12

    ok, i found my error.

    please discard my previous post, i will re-write the process for the others who were stuck where i was

    this is how i managed to embed the calendar into my page, but leave it possible for admin only to add/remove events…

    1. I placed all calendar files into “kalendar” folder,

    2. made a copy of the file “index.php” named “kalendar.php”, and called include_once(”kalendar/kalendar.php”); in my page where I wanted calendar included,

    3. edited kalendar.php like this:
    3a. I left php code intact,
    3b. I removed section HEAD from the original page, but kept parts of it -
    3c. moved from original HEAD 3 SCRIPT tags to the HEAD of my page, now here be careful to inspect and correct all the paths, if files are in the other folder (like kalendar folder in my case, step 1).
    3d. also moved CSS styles into my own style sheet, already included into the page.

    4. moved SCRIPT tag with startCalendar(0,0); line all the way to the bottom of my page. before closing BODY tag.

    now, what is left, is to edit out my kalendar.php file so it will not show LOGIN link. this way, it is embedded into the page and login is invisible for user, however, admin can go to the http://www.example.com/kalendar and there is intact index.php from the calendar that allows you all the original functions (add edit change dates and events)

    if i forgot something i am sure you will work it out, it is not hard at all. i will also need to squeeze it a bit, i need it in 155 pixels

    even with this code tweaking, this calendar saved hours from my hands, so THANK YOU VERY MUCH Mr. Jamie McConnell for free calendar code! i surely will leave credits to the creator, for such a good work!

13. Rens Lauwers November 8th, 2007 at 6:40 pm 13

    Hello,

    I have installed your calender succesfull! It works really good but I have one question: If I have a event today, the showed color is the eventcolor. Is it possible to show the todaycolor? If yes, how can I change this?
    Thanks!
    Rens

14. Jim November 24th, 2007 at 7:29 pm 14

    Excellent script!!!

    I do have two questions though…
    First, how can I change the date display format in the calendar view from the European style to the US style (dd/mm/yyyy)?

    Second, also in the calendar view, is it possible to place a or something similar to add a little more spacing between entries?

    Sorry, but I am just the coder, my wife is the designer and wanting the changes….

    Thanks for making such a great script free….

    Jim

15. Jim November 24th, 2007 at 7:32 pm 15

    Sorry, but I had a brain fade there, the date format that I need is mm/dd/yyyy….

    Looking at this monitor for too long today…..

    Jim

16. c3r3br0 December 7th, 2007 at 9:50 pm 16

    Jim,

    In index.php you will find this function:

    function displayEvents(day, month, year) {
    new Ajax.Updater(’eventList’, ‘rpc.php’, {method: ‘post’, postBody: ‘action=listEvents&&d=’+day+’&m=’+month+’&y=’+year+”});
    if(Element.visible(’eventList’)) {
    // do nothing, its already visble.
    } else {
    setTimeout(”Element.show(’eventList’)”, 300);
    }
    }

    Change it to:

    function displayEvents(day, month, year) {
    new Ajax.Updater(’eventList’, ‘rpc.php’, {method: ‘post’, postBody: ‘action=listEvents&&m=’+month+’&d=’+day+’&y=’+year+”});
    if(Element.visible(’eventList’)) {
    // do nothing, its already visble.
    } else {
    setTimeout(”Element.show(’eventList’)”, 300);
    }
    }

17. c3r3br0 December 7th, 2007 at 9:55 pm 17

    .iznogud,

    The easiest way I found to remove the Login link was to make a copy of index.php and rpc.php called admin.php and admin_rpc.php; then remove the login link out of the original files. This way the admin is accessible only by going to admin.php.

18. plattecoducks December 18th, 2007 at 10:02 pm 18

    I need to make this “American-ized” so that Sunday is the beginning of the calendar week. Where do I “touch” the code to implement this?

    Great calendar; we’re going to use it.

19. plattecoducks December 19th, 2007 at 3:59 pm 19

    I answered my own question: in the file rpc.php at the point where the number of prior month’s days is calculated, the following code is substituted
    …
    /* Skip some cells to take into account for the weekdays. */
    if($i == 0)
    {
    $firstDay = date(”w”, $fdf);
    // European style; calendar week starts on Monday: $skip = ($firstDay - 1);
    // American style; calendar week starts on Sunday:
    $skip = $firstDay;
    // Euro: if($skip < 0)
    // American:
    if ( $skip == 0 )
    {
    $skip = 6;
    }
    for($s=0; $s<$skip; $s++)
    {
    echo ‘ ’;
    }
    }
    …
    In addition, the order of the headers for the day names needs to be rearranged.

    Great calendar; my only modification will be to add holiday checks.

20. Jessie February 24th, 2008 at 7:08 pm 20

    Jessie…

    There are varying schools of thought on your subject. I happen to agree with you - most of the time. Keep it up….

21. jake March 25th, 2008 at 6:33 pm 21

    I’m trying to install your calendar and I’m getting this error when importing the SQL:

    You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near ‘ENGINE=MyISAM AUTO_INCREMENT=14′ at line 8

    anyideas

22. Frederic May 24th, 2008 at 10:40 pm 22

    I am french, so if you speak french

    Very nice calendar and very easy to use and install, Thank you

    I would like to know if it is possible to add rows ” to change the visualized month :month-1, month+1(we can keep the selection list possible) ?

23. LBK June 6th, 2008 at 1:46 pm 23

    Great job… i’ve translated your calendar in italian and it works good.
    Thank you.

    LBK

24. Sandeep Gaykhe June 20th, 2008 at 2:52 pm 24

    Hello Jamie
    the calendar is not working on this url, i have not chnaged anything accept the database setting, do i need any kind of specific php version, my current php version is Php 4.4.4 please let me know. or is it any rights issue?

    regards

25. Sandeep Gaykhe June 21st, 2008 at 10:45 am 25

    Hello Jamie

    the calendar is not working on this url, http://tilind.com/cc/ i have not changed anything accept the database setting, do i need any kind of specific php version, my current php version is Php 4.4.4 please let me know. or is it any rights issue?

    regards

26. SPIC3 September 10th, 2008 at 3:27 pm 26

    Hi,
    i’m trying to use mysqlCalendar on a page where there is a jquery slideshow, but the scripts (jquery & scriptaculous) seem unable to cohabitate.

    example page :
    http://www.raphael-lacour.com/www2008/calendrier-mysqlCalendar-scriptaculous.php

    Do you have a tip or something ?

27. sasha September 15th, 2008 at 8:55 pm 27

    Hello!
    I would like to ask the permission for use your calendar to remake it for my own needs.
    How much it will cost?
    Thank you for Your site.
    Alexander.