|
|
bugs [06-01-2010 01:05] 208.125.5.162 Birthday and LDIF |
bugs [17-11-2016 12:34] |
====== Bug Tracker ====== | |
{{bug.png?nolink}} | |
Try this code in iaddressbook/functions/module_birthday.php, line 30, to fix end-of-year bug: | |
| |
<code php> | |
$sql = "SELECT * FROM ".$db_config['dbtable_ab']. | |
$sql .= " WHERE ((MONTH(birthdate) = MONTH(NOW()) OR MONTH(birthdate) = MONTH(NOW()) + 1) AND MONTH(NOW()) != 12)"; | |
$sql .= " OR ((MONTH(birthdate) = 12 OR MONTH(birthdate) = 1) AND MONTH(NOW()) = 12)"; | |
$sql .= " ORDER BY DAYOFYEAR(birthdate) ASC LIMIT 100"; | |
</code> | |
| |
This code exports LDIF to Mozilla Thunderbird, in a format which uses names, instead of numbers. | |
| |
iaddressbook/functions/module_ldif.php line 85: | |
| |
<code php> | |
$line[] .= rtrim('dn: cn='. ldif_escape($contact->firstname).' '.ldif_escape($contact->lastname).', mail='.ldif_escape($workMail)); | |
// $line[] .= rtrim('dn: cn='. ldif_escape($contact->id).', '.$base, ", "); | |
$line[] .= 'objectClass: inetOrgPerson'; | |
$line[] .= 'objectClass: person'; | |
$line[] .= 'objectClass: top'; | |
$line[] .= 'cn: '.ldif_escape($contact->firstname).' '.ldif_escape($contact->lastname); | |
// $line[] .= 'cn: '. ldif_escape($contact->name()); | |
// $line[] .= 'cn: '. ldif_escape($contact->id); | |
</code> | |
| |
==== Version 1.00 ==== | |
* Birthday reminder seems a little buggy with the new year. Since December, it only shows people born in january (although some contacts are born in december). | |
| |
==== Version 0.99 ==== | |
* <del>if there are no birthdays in the future but at least one in the past, the birthday 'none' label was not displayed</del> | |
* <del>image handling: image is not resized when GD is used (instead of ImageMagick)</del> | |
* <del>image handling: replace proc_open by popen (again) as it may cause troubles with restrictive PHP settings</del> | |
* <del>Image has wrong Content-Type: image/$format instead of image/PNG etc.</del> | |
| |
==== Version 0.98 ==== | |
* PostgreSQL compatibility broken | |
* <del>photo import in contact edit view does always use imagemagick</del> | |
* <del>Category: Select 'ALL' in category filter, Go to range '26 - 50' (page2), Choose a category with less entries (2 for exemple), The list on the left is empty (Filter is on range '26 - 50' (page2)?)</del> | |
* <del>photo in vcard export is not compatible with Mac 10.4 Addressbook vcard import (Addressbook has a newline after PHOTO;BASE64:, while iAddressbook does not)</del> | |
| |
==== Version 0.97 ==== | |
* <del>Export Vcard add "\" in attribut "FN:". \\ | |
| |
<code> | |
BEGIN:VCARD | |
VERSION:3.0 | |
FN:prenom\, NOM | |
... | |
</code> | |
</del> (This is not a bug! See RFC 2426 for more information) | |
| |
==== Version 0.96 ==== | |
* <del>fixed a problem when PEAR.php could not be found</del> | |
| |
==== Version 0.95 ==== | |
* <del>two or more contacts that have the same display name are only shown once in the contact list. The number of total contacts displayed is correct however.</del> | |
| |
==== Version 0.94 ==== | |
* <del>removed some dependencies to PHP 5. Should now work with PHP 4 as well.</del> | |
* <del>Bug: resolved bug in actions.php that caused an unexpected T_OBJECT_OPERATOR</del> | |
* <del>Bug: vcard export: htmlspecialchars must not be used when exporting vcards</del> | |
* <del>Bug: category: can add categories with no name</del> | |
* <del>Bug: category: when adding categories, does not check for duplicate category names</del> | |
| |
==== Version 0.93 ==== | |
* <del>minor bugs in default template</del> | |
* <del>escaping does not work correct</del> | |
* <del>fix sqlite support (categories are not displayed (but handled correctly))</del> | |
* <del>fixed a serious bug that allowed cross site scripting</del> | |
* <del>auto-select first contact on category change</del> | |
| |
==== Version 0.92 ==== | |
| |
* <del>person_edit.tpl: localize CHANGE and REMOVE keywords</del> | |
* <del>Birthday field not shown in edit view if birthday is empty</del> | |
| |
==== Version 0.91a ==== | |
* <del>[MEDIUM] vcard import: cannot detect UTF-8/16/32 without BOM</del> | |
* <del>[HIGH] proper escaping for assembled objects before storing in database (;) (strip newlines!)</del> | |
* <del>[HIGH] birthdate before 1970 not displayed correctly</del> | |
* <del>[HIGH] photo removal and change not implemented in code</del> | |
* <del>[LOW] vCard import (V2.1): does not import birthday from Outlook generated vCards</del> | |
* <del>[FEATURE REQUEST] function to produce nice firstname, lastname or whatever lines, that can be used in //person.tpl// or in //contactlist.tpl//</del> | |
| |
==== Version 0.91 ==== | |
* <del>[HIGH] template looks ugly in Internet Explorer 6!</del> | |
* <del>company cards should display the company name at the top instead of fistname, lastname</del> | |
* <del>vCard import missing in template</del> | |
* <del>typo in DE text -> empty card</del> | |
| |
| |
==== Version 0.9 ==== | |
* <del>nice default template missing</del> | |
* <del>input validation!</del> | |
* <del>vcard import lacks //item// support</del> | |
* <del>vcard export lacks //item// support</del> | |