Hello, again, I wanted to precise a bit my explanation.
As the repeat keyword is also used in other part of the code, the repeat string should be replaced only where it is used
to contruct a SQL query ;)
for example, there were many occurence in the appointment.pinc file : see
#
# Second query ( repeating appointments w/o end )
#
$q = "SELECT c.* FROM ". $obj->dbconn->prefix ."calendar c WHERE ";
$q .= " r_ignore = 1 AND (";
$q .= " ( repeat = 1 AND r_arg in (". $wd .") )";
$q .= " OR ( repeat = 2 AND r_arg in (". $md .") )";
$q .= " OR ( repeat = 3 AND r_arg in (". $ymd .") )";
$q .= " OR ( repeat = 4 )";
$q .= " ) AND ( a_start <= ". $x2 ." )";
$q .= "";
$q .= " ORDER by a_start";
which should be replaced by :
#
# Second query ( repeating appointments w/o end )
#
$q = "SELECT c.* FROM ". $obj->dbconn->prefix ."calendar c WHERE ";
$q .= " r_ignore = 1 AND (";
$q .= " ( `repeat` = 1 AND r_arg in (". $wd .") )";
$q .= " OR ( `repeat` = 2 AND r_arg in (". $md .") )";
$q .= " OR ( `repeat` = 3 AND r_arg in (". $ymd .") )";
$q .= " OR ( `repeat` = 4 )";
$q .= " ) AND ( a_start <= ". $x2 ." )";
$q .= "";
$q .= " ORDER by a_start";
--
To UNSUBSCRIBE, email to [EMAIL PROTECTED]
with a subject of "unsubscribe". Trouble? Contact [EMAIL PROTECTED]
