/**
* execute the connection to source
**/
function connect()
{
$this->lang = DoceboLanguage::createInstance('sap_report');
// perform the query for data retriving
$course_man = new Man_Course();
$this->_query_result = false;
$this->_readed_end = false;
$this->row_index = 0;
// find some information
require_once $GLOBALS['where_framework'] . '/lib/lib.field.php';
$field_man = new FieldList();
$field_man->setFieldEntryTable($GLOBALS['prefix_fw'] . '_field_userentry');
$this->_cid_list = $field_man->getAllFieldEntryData($this->cid_field);
$query_course_user = "******" . $GLOBALS['prefix_lms'] . "_courseuser AS cu \r\n\t\t\tJOIN " . $GLOBALS['prefix_lms'] . "_course AS c\r\n\t\tWHERE cu.idCourse = c.idCourse \r\n\t\t\tAND cu.status = '" . _CUS_END . "' ";
$this->_query_result = sql_query($query_course_user);
if (!$this->_query_result) {
$this->last_error = mysql_error();
return FALSE;
}
return TRUE;
}
