CiviCRM Community Forums (archive)

When a new event is saved, From which file query is fired to update db?
Or As If I have to add one more column in event table & need to update that column fields while event creation along with other event information , in which file I should put query of updating that particular column ?
Help please!
Thanks

also to update and keep your column data up to date,

here civi hooks also play a key role and no need to modify main files

you might wanna take a look for
1. hook_civicrm_postProcess
2. hook_civicrm_pre
3. hook_civicrm_post

here is the doc : http://wiki.civicrm.org/confluence/display/CRMDOC40/CiviCRM+hook+specification

kiran

hey you could get all these info w/o any db schema changes.

civicrm_event table store contact id of person who created event in 'created_id' column
civicrm_uf_match gives you mapping between drupal user and civicrm contact.

query might be like :

     
    SELECT  event.id as eventId,
            civicrm_drupal_mapping.uf_id drupalUserId,
            event.created_id  CiviCRMEventCreatedContactId
      FROM  civicrm_uf_match civicrm_drupal_mapping
INNER JOIN  civicrm_event as event ON ( event.created_id = civicrm_drupal_mapping.contact_id )
hope this help

kiran

Mapping between drupal ( or cms ) user id with civicrm contacts stored in table 'civicrm_uf_match' where column 'uf_id' is nothing but drupal user Id and 'contact_id' is nothing but civicrm contact Id.
In 'civcrm_event' table, field 'created_id' specify the event creator contact id of that event.

I think using civicrm api will be more useful here.
<?php
global $user;
if ( !module_exists('civicrm') || !$user->uid || !civicrm_initialize()) {
return;
}

require_once 'api/v2/UFGroup.php'; 
require_once 'api/v2/Event.php'; 

// get civicrm contact Id from drupal user id.
$civicrm_contact_id = civicrm_uf_match_id_get( $user->uid );

// Find events created by specified contact id.
$params = array( 'created_id' => $civicrm_contact_id );
$events = civicrm_event_search($params);

// Evens created by current logged in user ( array ).
print_r( $events );
?>


Hope this will help you.

Rajan

OR if you prefer (slightly less verbose)


<?php
global $user;
if ( !module_exists('civicrm') || !$user->uid || !civicrm_initialize()) {
return;
}

require_once 'api/api.php'; 

// get civicrm contact Id from drupal user id.
$contact = civicrm_api('UFMatch','Get', array('version' =>3, 'uf_id' => $user->uid, 'sequential' =>1);

// Find events created by specified contact id.
$events = civicrm_api('Event','Get', array( 'version' = > 3, 'created_id' => $contact['values'][0]['contact_id'] ));

// Events created by current logged in user ( array ).
print_r( $events );
?>