I don’t think so: http://modxcms.com/forums/index.php/topic,21007.msg186950.html#msg186950
... will it screw things up?
$sql = "
SELECT DISTINCT
$cFields
s_tvcv.value AS startDate,
e_tvcv.value AS endDate,
h_tvcv.value AS hide
FROM
($t_sc AS sc,
$t_t AS t,
$t_tv AS s_tv,
$t_tv AS e_tv,
$t_tv AS h_tv)
# Start Date
JOIN
$t_cv AS s_tvcv ON s_tvcv.contentid = sc.id AND s_tv.id = s_tvcv.tmplvarid
# End Date
LEFT JOIN
$t_cv AS e_tvcv ON e_tvcv.contentid = sc.id AND e_tvcv.tmplvarid = e_tv.id
# Hide time
LEFT JOIN
$t_cv AS h_tvcv ON h_tvcv.contentid = sc.id AND h_tvcv.tmplvarid = h_tv.id
LEFT JOIN
$t_dg AS dg ON dg.document = sc.id
WHERE
(sc.privateweb = 0 OR dg.document_group IN ($docGroup))
AND
sc.parent IN ($parents)
AND
sc.published = 1
AND
t.templatename IN ($allowedTemplates)
# Start date
AND
s_tv.name = '$tmplVarStart'
AND
CONCAT(SUBSTRING(s_tvcv.value,7,4),'-',SUBSTRING(s_tvcv.value,4,2),'-',SUBSTRING(s_tvcv.value,1,2)) <= '$endDate'
# End date
AND
e_tv.name = '$tmplVarEnd'
AND
(
CONCAT(SUBSTRING(e_tvcv.value,7,4),'-',SUBSTRING(e_tvcv.value,4,2),'-',SUBSTRING(e_tvcv.value,1,2)) >= '$startDate'
OR
(
e_tvcv.value IS NULL
AND
CONCAT(SUBSTRING(s_tvcv.value,7,4),'-',SUBSTRING(s_tvcv.value,4,2),'-',SUBSTRING(s_tvcv.value,1,2)) >= '$startDate'
)
)
# Hide
AND
h_tv.name = '$tmplVarHideTime'
ORDER BY
CONCAT(SUBSTRING(s_tvcv.value,7,4),'-',SUBSTRING(s_tvcv.value,4,2),'-',SUBSTRING(s_tvcv.value,1,2),' ',RIGHT(s_tvcv.value,8))
$limit ";
$prevMonth = (1 == (int)$month ) ? '12' : str_pad(((int)$month-1),2,0,STR_PAD_LEFT);
$prevMonth = (1 == (int)$month ) ? '12' : str_pad(((int)$month-1),2,'0',STR_PAD_LEFT);
I just installed Easyevents on MODx 0.9.6.3 (I’m new to both). I managed to get the calendar working but I’m unable to go to the next or previous month. I do have some events scheduled for next month and they do show up as ’coming events’ but when I click on the little arrows nothing happens. Any ideas what might be wrong?
xhr0: window.XMLHttpRequest ? new XMLHttpRequest() : new ActiveXObject("MSXML2.XMLHTTP.3.0"), var xhro = window.XMLHttpRequest ? new XMLHttpRequest() : new ActiveXObject("MSXML2.XMLHTTP.3.0"),
try fix the easyEventsAjax.js, line 7:
xhr0: window.XMLHttpRequest ? new XMLHttpRequest() : new ActiveXObject("MSXML2.XMLHTTP.3.0"),
to be:
var xhro = window.XMLHttpRequest ? new XMLHttpRequest() : new ActiveXObject("MSXML2.XMLHTTP.3.0"),
How do I add my TVs to EasyEvents listing display?