CiviCRM Community Forums (archive)

Hi, I would like to know if it is possible to create Contribution Pages having a custom set of fields available in the moment of creation, not like inserting Profiles (those are to be filled in by contributors), but more like administrative attributes of each new Contribution Page, in order to handle them more freely.

I'm talking about fields that could be filled in by people creating new contribution pages: for example,

1-Organization related to that contribution (that would be a dynamic select-list of organizations available),
2-Type of contribution (for example a static select-list... Disaster relief, HIV, Human Rights, etc.)
3-etc.

I don't know if I expressed myself OK, sorry for my english. Anyway,  Thanks in advance
Alex

I don't think there is an API that pulls Personal Campaign Pages information, and I don't use CiviCRM with Joomla, but I guess you can make an SQL query, the information for PCPs is in table `civicrm_pcp`, and the fields are `id`, `contact_id`, `status_id`, `title`, `intro_text`, `page_text`, `donate_link_text`, `contribution_page_id`, `is_thermometer`, `is_honor_roll`, `goal_amount`, `referer`, `is_active`.

I guess you could use something like the following if you wanted to retrieve, let's say, the goal amount for a PCP called 'My PCP' (haven't checked the syntax):

SELECT goal_amount FROM civicrmdatabasename.civicrm_pcp WHERE title = 'My PCP'
In Drupal there's an API for database access, db_query, but in Joomla I think it is JFactory... I think this will help you out:

Joomla! 1.0.x (and Joomla! 1.5 in Legacy mode):
<?php
global $database;
$database->setQuery( "SELECT * FROM #__your_table" );
$result = $database->loadObjectList();
?>
Joomla! 1.5
<?php
$db = & JFactory::getDBO();
$db->setQuery( "SELECT * FROM #__your_table" );
$result = $db->loadObjectList();
?>
However, the total amount contributed through a given PCP is something that (in my opinion) is not retrievable since they are tracked as per Contribution Page (and not per PCP). Anyway, if you need to know the contributed totals for a Contribution Page, it's perfectly possible of course.

Anybody correct me if I'm wrong   

That is so great to know, thanks!!