Table broken on inline event display

Discuss everything related to ApPHP Calendar. All versions. Any questions related to the ApPHP Calendar developing or using should be posted to this forum.

Moderators: ne_moj, zewa

PRHS
Newbie
Newbie
Posts: 5
Joined: Jan 9th, '12, 18:18

Table broken on inline event display

Postby PRHS » Jan 9th, '12, 18:32

This was originally posted in CodeCanyon

Display of inline events in month view is distorting the Calendar table. Change was made to work with MySQL 4 as advised in CodeCanyon (return_overlib()). The onmouseover event is incomplete causing the following line of dates in the calendar to display incorrectly.

HTML Source code of calendar display page:

Code: Select all

<td class="td"><a href="javascript:__doPostBack('view','daily','2011','12','24')">24 (3 events)</a><br /><div class="events_list_inline">&#8226; <span class="event_descr" onmouseover="return overlib('test Event 2 Description',WIDTH,150)" onmouseout="return nd();" style="color:#000000;">Test Event 2</span><br />&#8226; <span class="event_descr" onmouseover="return overlib('Test Event Description',WIDTH,150)" onmouseout="return nd();" style="color:#000000;">Test Event</span><br />&#8226; <span class="event_descr" onmouseover="return overlib('Test Event Description<br /></div></td> <tr class="tr" style="height:83px;"> </tr>


Bit that is incorrect:

Code: Select all

onmouseover="return overlib('Test Event Description<br />


Fix that was applied:

Find in calendar.class.php

Code: Select all

apphp_text_encode_overlib(".EVENTS_TABLE.".description)


and replace it with

Code: Select all

REPLACE(REPLACE(REPLACE(".EVENTS_TABLE.".description, '\\\\', '&#92;&#92;'), '\'', '&#92;&#39;'), '\"', '&#92;&#34;')


Was the replacement in calendar.class.php at fault?

Screen shot attached.

Thanks
Attachments
screen_shot.jpg
screen_shot.jpg (9.29 KiB) Viewed 4313 times

PRHS
Newbie
Newbie
Posts: 5
Joined: Jan 9th, '12, 18:18

Re: Table broken on inline event display [RESOLVED]

Postby PRHS » Jan 9th, '12, 21:06

More research through this forum has found the answer to this. The code replacement shown in CodeCanyon was a single search/replace. Elsewhere in this forum it showed three search and replace items for a similar issue. Having made those changes the month calendar is now displaying correctly.

Thanks

administrator
Site Admin
Site Admin
Posts: 5928
Joined: Jan 7th, '09, 23:18
Contact:

Re: Table broken on inline event display

Postby administrator » Jan 10th, '12, 08:50

This issue will be completely fixed in the next version (planned in 1-1.5 month)

PRHS
Newbie
Newbie
Posts: 5
Joined: Jan 9th, '12, 18:18

Re: Table broken on inline event display

Postby PRHS » Feb 14th, '12, 09:03

Thanks. Look forward to the fix. Progress?? Problem has recurred. Cannot currently see the reason for the issue. The event with the date of the 11th (11 (1 event)) is displaying inside the date of the 10th. This only seems to be happening with a three day event that is at the end of one week and the beginning of the next. If the three day event is deleted the calendar displays OK.

calendar_broken.jpg
calendar_broken.jpg (16.24 KiB) Viewed 4128 times

administrator
Site Admin
Site Admin
Posts: 5928
Joined: Jan 7th, '09, 23:18
Contact:

Re: Table broken on inline event display

Postby administrator » Feb 15th, '12, 08:42

Try following solution:

open your include/connection.php file, find set_group_concat_max_length() function

Code: Select all

function set_group_concat_max_length(){
   database_void_query("SET SESSION group_concat_max_len = 6036");   
}


and increase the number from 6036 to 9000 or even more.
Does it help now?

PRHS
Newbie
Newbie
Posts: 5
Joined: Jan 9th, '12, 18:18

Re: Table broken on inline event display

Postby PRHS » Feb 16th, '12, 02:13

That fixed it! Very many thanks.

riham
Newbie
Newbie
Posts: 1
Joined: Nov 13th, '14, 05:45

Re: Table broken on inline event display

Postby riham » Nov 13th, '14, 05:49

Ok, but is all this code you written here somewere in the calendar.class.php file? Cause i do not for example find any word named 'output' in the file(?). So i guess i need to copy all this and then paste it itno the calendar.class.phph file(?) and the also replace with any javascript at 'doPostBack'?
Get free demos for 500-006 exam and wikipedia exam with 100% guaranteed success. Our best quality Duke University prepares you well before appearing in the Isaca of ISC


Return to “ApPHP Calendar”