CiviCRM Community Forums (archive)

Compare the complete link (URL) you're getting in your block (the one that doesn't work) to the View Contact link you get when browsing contacts (i.e. links in Find Contacts).

Hi
sorry for replying on an old post, but where do i actually have to put this code in when i want it to appear on dashboard?
greets

hey,

so i am using civicrm on another project now and wanted to use the birthday block again but it does not work anymore.

this was the code i used years ago:

<?php
// Check if CiviCRM is installed here.
if (!module_exists('civicrm')) return false;

// Initialization call is required to use CiviCRM APIs.
civicrm_initialize(true);
require_once('api/v2/Contact.php');

$query = "SELECT id, display_name, birth_date, CONCAT(((RIGHT(birth_date,5)
< RIGHT(CURRENT_DATE,5)) + YEAR(CURRENT_DATE)), RIGHT(birth_date,6)) AS bday,
concat(concat(month(birth_date), '/'), day(birth_date)) as displaydate, 
(TO_DAYS(CONCAT(((RIGHT(birth_date,5) < RIGHT(CURRENT_DATE,5)) + YEAR(CURRENT_DATE)),
RIGHT(birth_date,6))) - TO_DAYS(CURRENT_DATE)) AS toBday FROM civicrm_contact WHERE
(TO_DAYS(CONCAT(((RIGHT(birth_date,5) < RIGHT(CURRENT_DATE,5)) + YEAR(CURRENT_DATE)),
RIGHT(birth_date,6))) - TO_DAYS(CURRENT_DATE) < 7) ORDER BY bday, RIGHT(birth_date,5);";

$params = array( );

$dao =& CRM_Core_DAO::executeQuery( $query, $params );

echo "<div class=\"item-list\"><ul>\n";
while ( $dao->fetch( ) ) {

echo "<li><a href=\"/civicrm/contact/view?reset=1&cid=" . $dao->id . "\">" . $dao->display_name .
"</a>, " . $dao->displaydate;

echo "</li>\n";

}
echo "</div></ul>\n";

?>
can anyone tell me what to change to get this working again?

thanks
conte

API v3 is now in use.  API v2 has been removed, so that would be the place to start.

See http://wiki.civicrm.org/confluence/display/CRMDOC/Using+the+API  and http://wiki.civicrm.org/confluence/display/CRMDOC/API+Reference

yea. looks right.

however I didnt do any coding or reading on civicrm for a while, so I think I wont be able to handle this atm.

Hoping, that someone is willing to invest some minutes

thanks
conte