chamilo / chamilo-lms

                            $centerCode = $centro->CODIGO_CENTRO;

                            $sql = "SELECT id FROM $tableCenters WHERE center_origin='".$centerOrigin."' AND center_code='".$centerCode."';";

                            $res = Database::query($sql);

                            if (Database::num_rows($res)>0) {

                                $aux_row = Database::fetch_assoc($res);

                                $centerId = $aux_row['id'];

                            } else {

                                $sql = "INSERT INTO $tableCenters (center_origin, center_code)

                                        VALUES ('" . $centerOrigin . "','" . $centerCode . "');";

                                Database::query($sql);

                                $centerId = Database::insert_id();

                            }

                            $sql = "INSERT INTO $tableSpecialtyClassroom (specialty_id, center_id)

                                    VALUES ('" . $specialtyId . "','" . $centerId . "')";

                            Database::query($sql);

                                $sql = "SELECT id FROM $tableTutors WHERE 

                                document_type='".$documentType."' AND document_number='".$documentNumber."' AND document_letter='".$documentLetter."';";

                                $res = Database::query($sql);

                                if (Database::num_rows($res)>0) {

                                    $aux_row = Database::fetch_assoc($res);

                                    $tutorId = $aux_row['id'];

                                } else {

                                    $sql = "INSERT INTO $tableTutors (document_type, document_number, document_letter)

                                        VALUES ('" . $documentType . "','" . $documentNumber . "','" . $documentLetter . "');";

                                    Database::query($sql);

                                    $tutorId = Database::insert_id();

                                }

                                if (empty($tutorId)) {

                                    return array(

                                        "RESPUESTA_OBT_ACCION" => array(

            if (!empty($tmp_folders_titles[$tmp_path])) {

                // If this path has soon been stored here we don't need a new query

                $path_displayed .= $tmp_folders_titles[$tmp_path];

            } else {

                $sql = 'SELECT title FROM '.Database::get_course_table(TABLE_DOCUMENT).'

                    WHERE c_id = ' . $course_id.' AND path LIKE BINARY "'.$tmp_path.'"';

                $rs = Database::query($sql);

                $tmp_title = '/'.Database::result($rs, 0, 0);

                $path_displayed .= $tmp_title;

                $tmp_folders_titles[$tmp_path] = $tmp_title;

            }

        }

        return $path_displayed;