/** * 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; }