function waiting_list_create_sms($mailing_group_id, $mailing_name, $sms_template_id, $sms_provider_id, $date) { $waiting_list_sms_api = new civicrm_api3(); $waiting_list_sms_params = array(); $waiting_list_sms_params['version'] = 3; $waiting_list_sms_params['sequential'] = 1; $waiting_list_sms_params['group_id'] = $mailing_group_id; $waiting_list_sms_params['options'] = array('sort' => 'id', 'limit' => 0); if ($waiting_list_sms_api->GroupContact->Get($waiting_list_sms_params)) { $waiting_list = $waiting_list_sms_api->lastResult->values; $count = $waiting_list_sms_api->lastResult->count; for ($i = 0; $i < $count; $i++) { try { unset($waiting_list_sms_params); $waiting_list_sms_params['version'] = 3; $waiting_list_sms_params['contact_id'] = $waiting_list[$i]->contact_id; $waiting_list_sms_params['template_id'] = $sms_template_id; $waiting_list_sms_params['provider_id'] = $sms_provider_id; if (!$waiting_list_sms_api->Sms->Send($waiting_list_sms_params)) { print "Error creating sms "; print_r($waiting_list_sms_api->errorMsg()); } } catch (API_Exception $apie) { print "Caught exception: " . $apie->getMessage() . "\n"; } } } else { throw new API_Exception("Error retrieving SMS group contacts " . print_r($waiting_list_sms_api->errorMsg(), true)); } }
<?php require_once dirname(__DIR__) . '/config.php'; require_once 'class.api.php'; // Initialize database $dbh = new PDO('mysql:dbname=' . DBNAME . ';host=' . DBHOST, DBUSER, DBPASS); // Get data from civicrm.org $api = new civicrm_api3(array('server' => CO_CIVIURL, 'api_key' => CO_USERKEY, 'key' => CO_SITEKEY)); if (!$api->ExtensionDir->Get()) { echo 'Unable to retrieve ExtensionDir: ' . $api->errorMsg() . PHP_EOL; exit; } // Save in database, replacing existing data $dbh->query('TRUNCATE TABLE extensions_dir'); $stm = $dbh->prepare("\n INSERT INTO extensions_dir (nid, title, created, fq_name, git_url)\n VALUES (:nid, :title, :created, :fq_name, :git_url)\n "); $count = 0; foreach ($api->values() as $row) { $stm->bindValue(':nid', $row->nid, PDO::PARAM_INT); $stm->bindValue(':title', $row->title, PDO::PARAM_STR); $stm->bindValue(':created', $row->created, PDO::PARAM_INT); $stm->bindValue(':fq_name', $row->fq_name, PDO::PARAM_STR); $stm->bindValue(':git_url', $row->git_url, PDO::PARAM_STR); if ($stm->execute()) { $count++; } } echo "{$count} CiviCRM-native extensions found in the Extensions Directory." . PHP_EOL;