CiviCRM Community Forums (archive)

I have been trying to find a solution to this for some time, I feel like it's super simple I'm just missing something. A large part of our organizations fundraising is done through PCPs and I have been doing  some customizing. I was able to get the name of the owner of the PCP to show up on the PCP page, but only the first page, once you click make a donation it no longer shows up. I wrote a database call that utilizes the PCP ID to get the owners name inside the PCP>Page>PCPInfo.php file. This may not have been the best place for it, but it is where I was succesful. (I can not get the same function to run in my custom hooks file.

$ownerResult = mysql_query("
SELECT *
FROM   civicrm_pcp, civicrm_contact
WHERE  civicrm_pcp.contact_id = civicrm_contact.id
  AND  civicrm_pcp.id = {$this->_id}
");
$ownerFullName=mysql_result($ownerResult,0,"display_name");
$ownerFirstName=mysql_result($ownerResult,0,"first_name");
//$ownerName='test';
$this->assign('ownerFullName', $ownerFullName);
$this->assign('ownerFirstName', $ownerFirstName);
I'm wondering if there is a better, more consistent way to get the pcp Id, so that I may use it on all three of the contribution pages (main, confirm and thank you)? Im hoping whatever the solution maybe be I can also utilize the pcp Id in the contribution receipt!

I was able to get the name to show up on all the pages by adding the same function and a line with

$page->assign('ownerFirstName', $ownerFirstName); //#rw

to both the main.php and the confirm.php files

Which was super helpful as I added the variable to my the email receipts!!