Joined: Sat Sep 15, 2012 9:11 am Posts: 7
|
Two mistyping bugs in callingcard_cid_sanitize. Resulting function doesnt work for DIDs as expected
in callingcard_cid_sanitize
Sintax errors in
$QUERY .= "SELECT cc_did.did ". " FROM cc_did ". " JOIN cc_did_destination ON cc_did_destination.id_cc_did=cc_did.id ". " JOIN cc_card ON cc_did_destination.id_cc_card=cc_card.id ". " WHERE (cc_did.activated=1 OR cc_did.activated='t') AND cc_did_destination.activated=1 AND cc_did.startingdate <= NOW() AND cc_did.expirationdate => NOW()". " AND cc_card.username='".$this -> username."' ". " AND cc_did_destination.validated=1"; $QUERY .= "ORDER BY 1";
instead of "cc_did_destination.validated=1ORDER BY 1" should be "cc_did_destination.validated=1 ORDER BY 1"
instead of cc_did.expirationdate => NOW() should be cc_did.expirationdate >= NOW()
|
|