/* English */
INSERT INTO `language_text` VALUES ('en', '_module', 'gameme', 'GameMe',NOW(),'');
INSERT INTO `language_text` VALUES ('en', '_module', 'gameme-master', 'GameMe',NOW(),'');
INSERT INTO `language_text` VALUES ('en', '_module', 'gm_gameme', 'GameMe',NOW(),'');
INSERT INTO `language_text` VALUES ('en', '_module', 'gm_gameme_text', 'Review your progress.',NOW(),'');
INSERT INTO `language_text` VALUES ('en', '_module','gm_leaders_top','Leaders (Top %s)',NOW(),'');
INSERT INTO `language_text` VALUES ('en', '_module','gm_id','ID',NOW(),'');
INSERT INTO `language_text` VALUES ('en', '_module','gm_points','Points',NOW(),'');
INSERT INTO `language_text` VALUES ('en', '_module','gm_level','Level',NOW(),'');
INSERT INTO `language_text` VALUES ('en', '_module','gm_levels','Levels',NOW(),'');
INSERT INTO `language_text` VALUES ('en', '_module','gm_levels_awarded','Levels Awarded',NOW(),'');
INSERT INTO `language_text` VALUES ('en', '_module','gm_description','Description',NOW(),'');
INSERT INTO `language_text` VALUES ('en', '_module','gm_in_position','You are in position: %s',NOW(),'');
INSERT INTO `language_text` VALUES ('en', '_module','gm_login_for_points','Login to collect points',NOW(),'');
INSERT INTO `language_text` VALUES ('en', '_module','gm_your_levels_reached','Your Levels Reached',NOW(),'');
INSERT INTO `language_text` VALUES ('en', '_module','gm_title','Title',NOW(),'');
INSERT INTO `language_text` VALUES ('en', '_module','gm_progress_to_next','Progess to next level: %s/100',NOW(),'');
INSERT INTO `language_text` VALUES ('en', '_module','gm_progress_to_next2','Progess to next level',NOW(),'');
INSERT INTO `language_text` VALUES ('en', '_module','gm_manage_badges','Manage Badges',NOW(),'');
INSERT INTO `language_text` VALUES ('en', '_module','gm_badge_id','Badge ID',NOW(),'');
INSERT INTO `language_text` VALUES ('en', '_module','gm_counter','Counter',NOW(),'');
INSERT INTO `language_text` VALUES ('en', '_module','gm_alias','Alias',NOW(),'');
INSERT INTO `language_text` VALUES ('en', '_module','gm_badges','Badges',NOW(),'');
INSERT INTO `language_text` VALUES ('en', '_module','gm_badge','Badge',NOW(),'');
INSERT INTO `language_text` VALUES ('en', '_module','gm_your_badges','Your Badges',NOW(),'');
INSERT INTO `language_text` VALUES ('en', '_module','gm_events','Events',NOW(),'');
INSERT INTO `language_text` VALUES ('en', '_module','gm_event','Event',NOW(),'');
INSERT INTO `language_text` VALUES ('en', '_module','gm_your_alert','Your Alerts',NOW(),'');
INSERT INTO `language_text` VALUES ('en', '_module','gm_no_alerts','No level or badge alerts to show',NOW(),'');
INSERT INTO `language_text` VALUES ('en', '_module','gm_your_activity_log','Your Activity Log',NOW(),'');
INSERT INTO `language_text` VALUES ('en', '_module','gm_event_date','Event Date',NOW(),'');
INSERT INTO `language_text` VALUES ('en', '_module','gm_log','Log',NOW(),'');
INSERT INTO `language_text` VALUES ('en', '_module','gm_alerts','Alerts',NOW(),'');
INSERT INTO `language_text` VALUES ('en', '_module','gm_count','Count',NOW(),'');
INSERT INTO `language_text` VALUES ('en', '_module','gm_progress','Progress',NOW(),'');
INSERT INTO `language_text` VALUES ('en', '_module','gm_options','Options',NOW(),'');
INSERT INTO `language_text` VALUES ('en', '_module','gm_course_events','Course Events',NOW(),'');
INSERT INTO `language_text` VALUES ('en', '_module','gm_repetition','Repetition',NOW(),'');
INSERT INTO `language_text` VALUES ('en', '_module','gm_reach_reps','Reach Reps',NOW(),'');
INSERT INTO `language_text` VALUES ('en', '_module','gm_max_points','Max Points',NOW(),'');
INSERT INTO `language_text` VALUES ('en', '_module','gm_each_badge','Each Badge',NOW(),'');
INSERT INTO `language_text` VALUES ('en', '_module','gm_reach_badge','Reach Badge',NOW(),'');
INSERT INTO `language_text` VALUES ('en', '_module','gm_each_points','Each Point',NOW(),'');
INSERT INTO `language_text` VALUES ('en', '_module','gm_reach_points','Reach Points',NOW(),'');
INSERT INTO `language_text` VALUES ('en', '_module','gm_each_callback','Each Callback',NOW(),'');
INSERT INTO `language_text` VALUES ('en', '_module','gm_reach_callback','Reach Callback',NOW(),'');
INSERT INTO `language_text` VALUES ('en', '_module','gm_default_events','Default Events',NOW(),'');
INSERT INTO `language_text` VALUES ('en', '_module','gm_remove','Remove',NOW(),'');
INSERT INTO `language_text` VALUES ('en', '_module','gm_edit','Edit',NOW(),'');
INSERT INTO `language_text` VALUES ('en', '_module','gm_copy','Copy',NOW(),'');
INSERT INTO `language_text` VALUES ('en', '_module','gm_course_badges','Course Badges',NOW(),'');
INSERT INTO `language_text` VALUES ('en', '_module','gm_default_badges','Default Badges',NOW(),'');
INSERT INTO `language_text` VALUES ('en', '_module','gm_course_levels','Course Levels',NOW(),'');
INSERT INTO `language_text` VALUES ('en', '_module','gm_icon','Icon',NOW(),'');
INSERT INTO `language_text` VALUES ('en', '_module','gm_level_name','Level Name',NOW(),'');
INSERT INTO `language_text` VALUES ('en', '_module','gm_points_threshold','Points Threshold',NOW(),'');
INSERT INTO `language_text` VALUES ('en', '_module','gm_default_levels','Default Levels',NOW(),'');
INSERT INTO `language_text` VALUES ('en', '_module','gm_position','Position relative to others',NOW(),'');
INSERT INTO `language_text` VALUES ('en', '_module','gm_show_instructor','Show instructor in leader board',NOW(),'');
INSERT INTO `language_text` VALUES ('en', '_module','gm_leader_board','Leader Board',NOW(),'');
INSERT INTO `language_text` VALUES ('en', '_module','gm_leader_length','Leader board length',NOW(),'');
INSERT INTO `language_text` VALUES ('en', '_module','gm_level_number','Number of levels (max 11)',NOW(),'');
INSERT INTO `language_text` VALUES ('en', '_module','gm_progress_for','Progress for ',NOW(),'');
INSERT INTO `language_text` VALUES ('en', '_module','gm_view','view',NOW(),'');
INSERT INTO `language_text` VALUES ('en', '_module','gm_addplus','Add +',NOW(),'');
INSERT INTO `language_text` VALUES ('en', '_module','gm_enable_edit','Enable inline edit',NOW(),'');
INSERT INTO `language_text` VALUES ('en', '_module','gm_delete','delete',NOW(),'');
INSERT INTO `language_text` VALUES ('en', '_module','gm_delete_event','Delete Event',NOW(),'');
INSERT INTO `language_text` VALUES ('en', '_module','gm_delete_badge','Delete Badge',NOW(),'');
INSERT INTO `language_text` VALUES ('en', '_module','gm_delete_level','Delete Level',NOW(),'');
INSERT INTO `language_text` VALUES ('en', '_module','gm_disallow_instructors','Disallow instructor customizing',NOW(),'');
INSERT INTO `language_text` VALUES ('en', '_module','gm_update_options','Update Options',NOW(),'');
INSERT INTO `language_text` VALUES ('en', '_module','gm_edit_level','Add/Edit Level',NOW(),'');
INSERT INTO `language_text` VALUES ('en', '_module','gm_level_title','Level Title',NOW(),'');
INSERT INTO `language_text` VALUES ('en', '_module','gm_short_description','Short Description',NOW(),'');
INSERT INTO `language_text` VALUES ('en', '_module','gm_points_reached','Points Reached (Points scored to reach level)',NOW(),'');
INSERT INTO `language_text` VALUES ('en', '_module','gm_update_level','Update Level',NOW(),'');
INSERT INTO `language_text` VALUES ('en', '_module','gm_cancel','Cancel',NOW(),'');
INSERT INTO `language_text` VALUES ('en', '_module','gm_edit_badge','Add/Edit Badge',NOW(),'');
INSERT INTO `language_text` VALUES ('en', '_module','gm_save_badge','Save Badge',NOW(),'');
INSERT INTO `language_text` VALUES ('en', '_module','gm_edit_event','Add/Edit Event',NOW(),'');
INSERT INTO `language_text` VALUES ('en', '_module','gm_badges_so_far','Your badges earned so far',NOW(),'');
INSERT INTO `language_text` VALUES ('en', '_module','gm_allow_repetition','Allow Repetition (Yes this event can repeat, or No is it a one time occurence)',NOW(),'');
INSERT INTO `language_text` VALUES ('en', '_module','gm_reach_repetition','Reach required repetitions (Repetitions required to trigger reach event)',NOW(),'');
INSERT INTO `language_text` VALUES ('en', '_module','gm_max_points_allowed','Maximum points allowed  (Maximum points that can be scored for this event)',NOW(),'');
INSERT INTO `language_text` VALUES ('en', '_module','gm_reach_badge_id','Badge ID reach event (When event repetitions is reach, issue this badge)',NOW(),'');
INSERT INTO `language_text` VALUES ('en', '_module','gm_each_badge_id','Badge ID each event (When event occurs, issue this badge)',NOW(),'');
INSERT INTO `language_text` VALUES ('en', '_module','gm_eachevent_points','Points for each event (Points awarded for each occurence of this event)',NOW(),'');
INSERT INTO `language_text` VALUES ('en', '_module','gm_reachevent_points','Points awared for the reach event (Bonus points added when the reach event occurs)',NOW(),'');
INSERT INTO `language_text` VALUES ('en', '_module','gm_eachevent_callback','Each callback function (When event occurs, run this function)',NOW(),'');
INSERT INTO `language_text` VALUES ('en', '_module','gm_reachevent_callback','Reach callback function (When event repetitions is reached, run this function)',NOW(),'');
INSERT INTO `language_text` VALUES ('en', '_module','gm_reach_message','Reach Message',NOW(),'');
INSERT INTO `language_text` VALUES ('en', '_module','gm_reachevent_message','Reach Message (The message sent to users when a reach event occurs)',NOW(),'');
INSERT INTO `language_text` VALUES ('en', '_module','gm_save_event','Save Event',NOW(),'');
INSERT INTO `language_text` VALUES ('en', '_module','gm_yes','Yes',NOW(),'');
INSERT INTO `language_text` VALUES ('en', '_module','gm_no','No',NOW(),'');
INSERT INTO `language_text` VALUES ('en', '_module','gm_gameme_notification','ATutor GameMe Notification',NOW(),'');
INSERT INTO `language_text` VALUES ('en', '_module','gm_no_course_badges_yet','No course badges yet. Click "copy" next to a default badge, to move it here for customizing.',NOW(),'');
INSERT INTO `language_text` VALUES ('en', '_module','gm_no_badges_earned','You have not earned any badges yet. ',NOW(),'');
INSERT INTO `language_text` VALUES ('en', '_module','gm_no_course_events_yet','No course events yet. Click "copy" next to a default event, to move it here for customizing.',NOW(),'');
INSERT INTO `language_text` VALUES ('en', '_module','gm_no_course_levels_yet','No course levels yet. Click "copy" next to a default level, to move it here for customizing.',NOW(),'');

INSERT INTO `language_text` VALUES ('en', '_msg','AT_WARNING_GM_SET_GAMEME_OPTIONS','GameMe options must be set in this course. Under the Manage tab, open GameMe and select the Options tab. Enable GameMe elements in Manage>Course Tools.',NOW(),'');
INSERT INTO `language_text` VALUES ('en', '_msg','AT_INFOS_GM_COPY_EVENT','Copy Default Events to modify them.',NOW(),'');
INSERT INTO `language_text` VALUES ('en', '_msg','AT_INFOS_GM_EDITING_DISABLED','Editing has been disabled. Contact your administrator to have editing turned on',NOW(),'');
INSERT INTO `language_text` VALUES ('en', '_msg','AT_INFOS_GM_COPY_BADGE','Copy Default Badges to modify them',NOW(),'');
INSERT INTO `language_text` VALUES ('en', '_msg','AT_INFOS_GM_COPY_DEFAULT_LEVELS','Copy Default Levels to modify them. Set the number of levels under the Options tab.',NOW(),'');
INSERT INTO `language_text` VALUES ('en', '_msg','AT_INFOS_GM_DISPLAY_ELEMENTS','Set game elements to display to students.',NOW(),'');
INSERT INTO `language_text` VALUES ('en', '_msg','AT_INFOS_GM_SEE_PROGRESS','Select a user from the menu below to view that person\'s progress. ',NOW(),'');
INSERT INTO `language_text` VALUES ('en', '_msg','AT_INFOS_GM_ENABLE_EDIT_TEXT','Click on a table cells to edit values, click out to save. See the Handbook for more about creating and modifying the system\'s Default Events.',NOW(),'');
INSERT INTO `language_text` VALUES ('en', '_msg','AT_INFOS_GM_EDIT_BADGE_TEXT','Drag badges into the Badge dropzone in the first column, or click on a table cells to edit its value, click out to save. See the Handbook for more about creating and modifying the system\'s Default Badges.',NOW(),'');
INSERT INTO `language_text` VALUES ('en', '_msg','AT_INFOS_GM_LEVELS_TEXT','Drag level icons into the Icon dropzone in the first colum, or click on a table cells to edit its value, click out to save. See the Handbook for more about creating and modifying the system\'s Default Levels. ',NOW(),'');
INSERT INTO `language_text` VALUES ('en', '_msg','AT_INFOS_GM_OPTIONS_TEXT','Most options are managed by instructors at the course level, enabled by default. You may choose to prevent Instructors from modifying game elements by checking the checkbox below, allowing only the default settings to be used.',NOW(),'');
INSERT INTO `language_text` VALUES ('en', '_msg','AT_FEEDBACK_GM_BADGE_COPIED','Badge was successfully copied. Drag badges into the drop done in the first column to change a badge image. Click on cells to edit them, click out to save.',NOW(),'');
INSERT INTO `language_text` VALUES ('en', '_msg','AT_ERROR_GM_BADGE_COPY_FAILED','Copy badge failed. Contact your administrator if it persists.',NOW(),'');
INSERT INTO `language_text` VALUES ('en', '_msg','AT_FEEDBACK_GM_EVENT_COPIED','Event was successfully copied. Click on cells to edit them, click out to save. ',NOW(),'');
INSERT INTO `language_text` VALUES ('en', '_msg','AT_ERROR_GM_EVENT_COPY_FAILED','Copy event failed. Contact your administrator if it persists.',NOW(),'');
INSERT INTO `language_text` VALUES ('en', '_msg','AT_FEEDBACK_GM_LEVEL_COPIED','Level was successfully copied. Click on cells to edit them, click out to save. ',NOW(),'');
INSERT INTO `language_text` VALUES ('en', '_msg','AT_ERROR_GM_LEVEL_COPIED_FAILED','Copy level failed. Contact your administrator if it persists.',NOW(),'');
INSERT INTO `language_text` VALUES ('en', '_msg','AT_CONFIRM_GM_DELETE_BADGE','Are you sure you want to delete this badge?',NOW(),'');
INSERT INTO `language_text` VALUES ('en', '_msg','AT_FEEDBACK_GM_BADGE_REMOVED','Badge was successfully removed.',NOW(),'');
INSERT INTO `language_text` VALUES ('en', '_msg','AT_CONFIRM_GM_DELETE_EVENT_ADMIN','Are you sure you want to delete this event? Deleting default events can cause problems. Be sure you know what you are doing.',NOW(),'');
INSERT INTO `language_text` VALUES ('en', '_msg','AT_CONFIRM_GM_DELETE_EVENT','Are you sure you want to delete this event?',NOW(),'');
INSERT INTO `language_text` VALUES ('en', '_msg','AT_FEEDBACK_GM_EVENT_REMOVED','Event was successfully removed.',NOW(),'');
INSERT INTO `language_text` VALUES ('en', '_msg','AT_CONFIRM_GM_DELETE_LEVEL','Are you sure you want to delete this level?',NOW(),'');
INSERT INTO `language_text` VALUES ('en', '_msg','AT_FEEDBACK_GM_LEVEL_REMOVED','Level was successfully removed.',NOW(),'');
INSERT INTO `language_text` VALUES ('en', '_msg','AT_ERROR_GM_LEVEL_REQUIREMENTS','The level title and a numeric points reached value must be defined.',NOW(),'');
INSERT INTO `language_text` VALUES ('en', '_msg','AT_FEEDBACK_GM_BADGED_ADDED','Successfully added badge. Drag a badge image into the dropzone in the first column to add/edit the badge.',NOW(),'');
INSERT INTO `language_text` VALUES ('en', '_msg','AT_ERROR_GM_BADGE_REQUIREMENTS','An alias, with no spaces, and a title must be provided for the badge.',NOW(),'');
INSERT INTO `language_text` VALUES ('en', '_msg','AT_INFOS_GM_BADGE_PROPERTIES','Set badge properties here. Drag a badge image into the Badge dropzone for the new badge after saving.',NOW(),'');
INSERT INTO `language_text` VALUES ('en', '_msg','AT_INFOS_GM_CREATE_EVENT_TEXT','Creating new events also requires adding matching script to the module\'s events.php file. See the Handbook page for details.',NOW(),'');
INSERT INTO `language_text` VALUES ('en', '_msg','AT_FEEDBACK_GM_UPDATED_OPTIONS','Options were sucessfully updated.',NOW(),'');
INSERT INTO `language_text` VALUES ('en', '_msg','AT_ERROR_GM_UPDATED_OPTIONS_FAILED','Update options failed. Contact your administrator if it persists.',NOW(),'');
INSERT INTO `language_text` VALUES ('en', '_msg','AT_ERROR_GM_MAX_DIMENSION','Maximum dimensions of %sx%s exceeded. Reduce the height and width of the image.',NOW(),'');
INSERT INTO `language_text` VALUES ('en', '_msg','AT_ERROR_GM_MAX_FILESESIZE','Maximum files size of %sKB exceeded. Reduce the size of the image.',NOW(),'');
INSERT INTO `language_text` VALUES ('en', '_msg','AT_FEEDBACK_GM_CONFIG_UPDATED','GameMe configuration was sucessfully updated',NOW(),'');

/* Spanish */
INSERT INTO `language_text` VALUES ('es', '_module', 'gameme', 'GameMe',NOW(),'');
INSERT INTO `language_text` VALUES ('es', '_module', 'gm_gameme', 'GameMe',NOW(),'');
INSERT INTO `language_text` VALUES ('es', '_module','gm_leaders_top','Líderes (Top %s)',NOW(),'');
INSERT INTO `language_text` VALUES ('es', '_module','gm_id','ID',NOW(),'');
INSERT INTO `language_text` VALUES ('es', '_module','gm_points','Puntos',NOW(),'');
INSERT INTO `language_text` VALUES ('es', '_module','gm_level','Nivel',NOW(),'');
INSERT INTO `language_text` VALUES ('es', '_module','gm_levels','Niveles',NOW(),'');
INSERT INTO `language_text` VALUES ('es', '_module','gm_levels_awarded','Niveles otorgados',NOW(),'');
INSERT INTO `language_text` VALUES ('es', '_module','gm_description','Descripción',NOW(),'');
INSERT INTO `language_text` VALUES ('es', '_module','gm_in_position','Ud está en la posición: %s',NOW(),'');
INSERT INTO `language_text` VALUES ('es', '_module','gm_login_for_points','Login para acumular puntos',NOW(),'');
INSERT INTO `language_text` VALUES ('es', '_module','gm_your_levels_reached','Sus niveles alcanzados',NOW(),'');
INSERT INTO `language_text` VALUES ('es', '_module','gm_title','Título',NOW(),'');
INSERT INTO `language_text` VALUES ('es', '_module','gm_progress_to_next','Progreso al siguiente nivel: %s/100',NOW(),'');
INSERT INTO `language_text` VALUES ('es', '_module','gm_progress_to_next2','Progreso al siguiente nivel',NOW(),'');
INSERT INTO `language_text` VALUES ('es', '_module','gm_manage_badges','Administrar Insignias',NOW(),'');
INSERT INTO `language_text` VALUES ('es', '_module','gm_badge_id','ID de Insignia',NOW(),'');
INSERT INTO `language_text` VALUES ('es', '_module','gm_counter','Contador',NOW(),'');
INSERT INTO `language_text` VALUES ('es', '_module','gm_alias','Alias',NOW(),'');
INSERT INTO `language_text` VALUES ('es', '_module','gm_badges','Insignias',NOW(),'');
INSERT INTO `language_text` VALUES ('es', '_module','gm_badge','Insignias',NOW(),'');
INSERT INTO `language_text` VALUES ('es', '_module','gm_your_badges','Sus Insignias',NOW(),'');
INSERT INTO `language_text` VALUES ('es', '_module','gm_events','Eventos',NOW(),'');
INSERT INTO `language_text` VALUES ('es', '_module','gm_event','Evento',NOW(),'');
INSERT INTO `language_text` VALUES ('es', '_module','gm_your_alert','Sus Alertas',NOW(),'');
INSERT INTO `language_text` VALUES ('es', '_module','gm_no_alerts','No hay alertas de nivel o de insignia para mostrar',NOW(),'');
INSERT INTO `language_text` VALUES ('es', '_module','gm_your_activity_log','Su registro de actividades',NOW(),'');
INSERT INTO `language_text` VALUES ('es', '_module','gm_event_date','Fecha del Evento',NOW(),'');
INSERT INTO `language_text` VALUES ('es', '_module','gm_log','Registro',NOW(),'');
INSERT INTO `language_text` VALUES ('es', '_module','gm_alerts','Alertas',NOW(),'');
INSERT INTO `language_text` VALUES ('es', '_module','gm_count','Recuento',NOW(),'');
INSERT INTO `language_text` VALUES ('es', '_module','gm_progress','Progreso',NOW(),'');
INSERT INTO `language_text` VALUES ('es', '_module','gm_options','Opciones',NOW(),'');
INSERT INTO `language_text` VALUES ('es', '_module','gm_course_events','Eventos del Curso',NOW(),'');
INSERT INTO `language_text` VALUES ('es', '_module','gm_repetition','Repetición',NOW(),'');
INSERT INTO `language_text` VALUES ('es', '_module','gm_reach_reps','Alcanzar Reps',NOW(),'');
INSERT INTO `language_text` VALUES ('es', '_module','gm_max_points','Puntos Máximos',NOW(),'');
INSERT INTO `language_text` VALUES ('es', '_module','gm_each_badge','Cada Insignia',NOW(),'');
INSERT INTO `language_text` VALUES ('es', '_module','gm_reach_badge','Alcanzar Insignia',NOW(),'');
INSERT INTO `language_text` VALUES ('es', '_module','gm_each_points','Cada Punto',NOW(),'');
INSERT INTO `language_text` VALUES ('es', '_module','gm_reach_points','Alcanzar Puntos',NOW(),'');
INSERT INTO `language_text` VALUES ('es', '_module','gm_each_callback','Cada Callback',NOW(),'');
INSERT INTO `language_text` VALUES ('es', '_module','gm_reach_callback','Alcanzar Callback',NOW(),'');
INSERT INTO `language_text` VALUES ('es', '_module','gm_default_events','Eventos Predeterminados',NOW(),'');
INSERT INTO `language_text` VALUES ('es', '_module','gm_remove','Remover',NOW(),'');
INSERT INTO `language_text` VALUES ('es', '_module','gm_edit','Editar',NOW(),'');
INSERT INTO `language_text` VALUES ('es', '_module','gm_copy','Copiar',NOW(),'');
INSERT INTO `language_text` VALUES ('es', '_module','gm_course_badges','Insignias del Curso',NOW(),'');
INSERT INTO `language_text` VALUES ('es', '_module','gm_default_badges','Insignias Predeterminadas',NOW(),'');
INSERT INTO `language_text` VALUES ('es', '_module','gm_course_levels','Niveles del Curso',NOW(),'');
INSERT INTO `language_text` VALUES ('es', '_module','gm_icon','Icono',NOW(),'');
INSERT INTO `language_text` VALUES ('es', '_module','gm_level_name','Nombre del Nivel',NOW(),'');
INSERT INTO `language_text` VALUES ('es', '_module','gm_points_threshold','Umbral de Puntos',NOW(),'');
INSERT INTO `language_text` VALUES ('es', '_module','gm_default_levels','Niveles Predeterminados',NOW(),'');
INSERT INTO `language_text` VALUES ('es', '_module','gm_position','Posición relativa a otros',NOW(),'');
INSERT INTO `language_text` VALUES ('es', '_module','gm_show_instructor','Mostrar al instructor en el tablero',NOW(),'');
INSERT INTO `language_text` VALUES ('es', '_module','gm_leader_board','Tablero',NOW(),'');
INSERT INTO `language_text` VALUES ('es', '_module','gm_leader_length','Largo del Tablero',NOW(),'');
INSERT INTO `language_text` VALUES ('es', '_module','gm_level_number','Número de niveles (max 11)',NOW(),'');
INSERT INTO `language_text` VALUES ('es', '_module','gm_progress_for','Progreso para ',NOW(),'');
INSERT INTO `language_text` VALUES ('es', '_module','gm_view','ver',NOW(),'');
INSERT INTO `language_text` VALUES ('es', '_module','gm_addplus','Añadir +',NOW(),'');
INSERT INTO `language_text` VALUES ('es', '_module','gm_enable_edit','Habilitar edición dentro de la línea',NOW(),'');
INSERT INTO `language_text` VALUES ('es', '_module','gm_delete','borrar',NOW(),'');
INSERT INTO `language_text` VALUES ('es', '_module','gm_delete_event','Borrar Evento',NOW(),'');
INSERT INTO `language_text` VALUES ('es', '_module','gm_delete_badge','Borrar Insignia',NOW(),'');
INSERT INTO `language_text` VALUES ('es', '_module','gm_delete_level','Borrar Nivel',NOW(),'');
INSERT INTO `language_text` VALUES ('es', '_module','gm_disallow_instructors','Prohibir la personalización del instructor',NOW(),'');
INSERT INTO `language_text` VALUES ('es', '_module','gm_update_options','Actualizar Opciones',NOW(),'');
INSERT INTO `language_text` VALUES ('es', '_module','gm_edit_level','Añadir/Editar Nivel',NOW(),'');
INSERT INTO `language_text` VALUES ('es', '_module','gm_level_title','Título del Nivel',NOW(),'');
INSERT INTO `language_text` VALUES ('es', '_module','gm_short_description','Descripción Corta',NOW(),'');
INSERT INTO `language_text` VALUES ('es', '_module','gm_points_reached','Puntos alcanzados (Puntos anotados para alcanzar el nivel)',NOW(),'');
INSERT INTO `language_text` VALUES ('es', '_module','gm_update_level','Actualizar Nivel',NOW(),'');
INSERT INTO `language_text` VALUES ('es', '_module','gm_cancel','Cancelar',NOW(),'');
INSERT INTO `language_text` VALUES ('es', '_module','gm_edit_badge','Añadir/Editar Insignia',NOW(),'');
INSERT INTO `language_text` VALUES ('es', '_module','gm_save_badge','Guardar Insignia',NOW(),'');
INSERT INTO `language_text` VALUES ('es', '_module','gm_edit_event','Añadir/Editar Evento',NOW(),'');
INSERT INTO `language_text` VALUES ('es', '_module','gm_badges_so_far','Sus otras insignias ganadas hasta ahora',NOW(),'');
INSERT INTO `language_text` VALUES ('es', '_module','gm_allow_repetition','Permitir Repetición (Sí este evento se puede repetir, o No es una ocurrencia de una sola vez)',NOW(),'');
INSERT INTO `language_text` VALUES ('es', '_module','gm_reach_repetition','Alcanzar las repeticiones requeridas (Repeticiones necesarias para activar el evento de alcance)',NOW(),'');
INSERT INTO `language_text` VALUES ('es', '_module','gm_max_points_allowed','Máximo de puntos permitidos (Puntos máximos que se pueden marcar para este evento)',NOW(),'');
INSERT INTO `language_text` VALUES ('es', '_module','gm_reach_badge_id','ID del Evento de alcance (Cuando se alcanza la repetición del evento, emitir esta insignia)',NOW(),'');
INSERT INTO `language_text` VALUES ('es', '_module','gm_each_badge_id','ID de cada evento (Cuando se produzca el evento, emitir esta insignia)',NOW(),'');
INSERT INTO `language_text` VALUES ('es', '_module','gm_eachevent_points','Puntos para cada evento (Puntos otorgados por cada ocurrencia de este evento)',NOW(),'');
INSERT INTO `language_text` VALUES ('es', '_module','gm_reachevent_points','Puntos otorgados para el evento alcanzado (puntos de bonificación añadidos cuando ocurre el evento alcanzado)',NOW(),'');
INSERT INTO `language_text` VALUES ('es', '_module','gm_eachevent_callback','Cada función de callback (cuando se produce el evento, ejecutar esta función)',NOW(),'');
INSERT INTO `language_text` VALUES ('es', '_module','gm_reachevent_callback','Llegar a la función callback (Cuando se alcanza repeticiones de eventos, ejecutar esta función)',NOW(),'');
INSERT INTO `language_text` VALUES ('es', '_module','gm_reach_message','Mensaje de Llegada',NOW(),'');
INSERT INTO `language_text` VALUES ('es', '_module','gm_reachevent_message','Mensaje de Llegada (El mensaje enviado a los usuarios cuando se produce un evento de alcance)',NOW(),'');
INSERT INTO `language_text` VALUES ('es', '_module','gm_save_event','Guardar Evento',NOW(),'');
INSERT INTO `language_text` VALUES ('es', '_module','gm_yes','Si',NOW(),'');
INSERT INTO `language_text` VALUES ('es', '_module','gm_no','No',NOW(),'');
INSERT INTO `language_text` VALUES ('es', '_module','gm_gameme_notification','Notificación de ATutor GameMe',NOW(),'');
INSERT INTO `language_text` VALUES ('es', '_module','gm_no_course_badges_yet','Todavía no hay insignias del curso. Haga clic en "copiar" junto a una insignia predeterminada para moverla aquí para personalizarla.',NOW(),'');
INSERT INTO `language_text` VALUES ('es', '_module','gm_no_badges_earned','Usted todavía no ha ganado insignias. ',NOW(),'');
INSERT INTO `language_text` VALUES ('es', '_module','gm_no_course_events_yet','Todavía no hay eventos del curso. Haga clic en "copiar" junto a un evento predeterminado, para moverlo aquí para personalizarlo.',NOW(),'');
INSERT INTO `language_text` VALUES ('es', '_module','gm_no_course_levels_yet','Aún no hay niveles del curso. Haga clic en "copiar" junto a un nivel predeterminado, para moverlo aquí para personalizarlo.',NOW(),'');
INSERT INTO `language_text` VALUES ('es', '_msg','AT_WARNING_GM_SET_GAMEME_OPTIONS','Las opciones de GameMe deben establecerse en este curso. En la pestaña Administrar, abra GameMe y seleccione la pestaña Opciones. Habilitar elementos de GameMe en Administrar> Herramientas del curso.',NOW(),'');
INSERT INTO `language_text` VALUES ('es', '_msg','AT_INFOS_GM_COPY_EVENT','Copie los eventos predeterminados para modificarlos.',NOW(),'');
INSERT INTO `language_text` VALUES ('es', '_msg','AT_INFOS_GM_EDITING_DISABLED','Se ha deshabilitado la edición. Póngase en contacto con su administrador para activar la edición',NOW(),'');
INSERT INTO `language_text` VALUES ('es', '_msg','AT_INFOS_GM_COPY_BADGE','Copiar las insigniar predeterminadas para modificarlas',NOW(),'');
INSERT INTO `language_text` VALUES ('es', '_msg','AT_INFOS_GM_COPY_DEFAULT_LEVELS','Copiar Niveles predeterminados para modificarlos. Establezca el número de niveles en la pestaña Opciones.',NOW(),'');
INSERT INTO `language_text` VALUES ('es', '_msg','AT_INFOS_GM_DISPLAY_ELEMENTS','Establezca los elementos del juego para mostrarlos a los estudiantes.',NOW(),'');
INSERT INTO `language_text` VALUES ('es', '_msg','AT_INFOS_GM_SEE_PROGRESS','Seleccione un usuario en el menú de abajo para ver el progreso de esa persona. ',NOW(),'');
INSERT INTO `language_text` VALUES ('es', '_msg','AT_INFOS_GM_ENABLE_EDIT_TEXT','Haga clic en las celdas de una tabla para editar valores, haga clic para guardar. Consulte el Manual para obtener más información sobre cómo crear y modificar los Eventos Predeterminados del sistema.',NOW(),'');
INSERT INTO `language_text` VALUES ('es', '_msg','AT_INFOS_GM_EDIT_BADGE_TEXT','Arrastre insignias en la dropzone de eliminación de insignias en la primera columna, o haga clic en las celdas de una tabla para editar su valor, haga clic para guardar. Consulte el manual para obtener más información sobre la creación y modificación de las Insignias Predeterminadas del sistema.',NOW(),'');
INSERT INTO `language_text` VALUES ('es', '_msg','AT_INFOS_GM_LEVELS_TEXT','Arrastre los iconos de nivel a la dropzpne de eliminación de iconos en la primera columna, o haga clic en las celdas de una tabla para editar su valor, haga clic para guardar. Consulte el Manual para obtener más información sobre la creación y modificación de los Niveles Predeterminados del sistema. ',NOW(),'');
INSERT INTO `language_text` VALUES ('es', '_msg','AT_INFOS_GM_OPTIONS_TEXT','La mayoría de las opciones son administradas por instructores a nivel de curso, habilitados de forma predeterminada. Puede optar por impedir que los instructores modifiquen elementos del juego marcando la casilla de verificación que se muestra a continuación, permitiendo sólo que se utilicen los valores predeterminados.',NOW(),'');
INSERT INTO `language_text` VALUES ('es', '_msg','AT_FEEDBACK_GM_BADGE_COPIED','La insignia se copió correctamente. Arrastrar insignias adentro en la primera columna para cambiar una imagen de insignia. Haga clic en las celdas para editarlas, haga clic para guardar.',NOW(),'');
INSERT INTO `language_text` VALUES ('es', '_msg','AT_ERROR_GM_BADGE_COPY_FAILED','Error al copiar la insignia. Póngase en contacto con su administrador si persiste el fallo.',NOW(),'');
INSERT INTO `language_text` VALUES ('es', '_msg','AT_FEEDBACK_GM_EVENT_COPIED','El evento se copió correctamente. Haga clic en las celdas para editarlas, haga clic para guardar. ',NOW(),'');
INSERT INTO `language_text` VALUES ('es', '_msg','AT_ERROR_GM_EVENT_COPY_FAILED','Error al copiar el evento. Póngase en contacto con su administrador si persiste el fallo.',NOW(),'');
INSERT INTO `language_text` VALUES ('es', '_msg','AT_FEEDBACK_GM_LEVEL_COPIED','El nivel se copió correctamente. Haga clic en las celdas para editarlas, haga clic para guardar. ',NOW(),'');
INSERT INTO `language_text` VALUES ('es', '_msg','AT_ERROR_GM_LEVEL_COPIED_FAILED','Error en el evento del nivel. Póngase en contacto con su administrador si persiste el fallo.',NOW(),'');
INSERT INTO `language_text` VALUES ('es', '_msg','AT_CONFIRM_GM_DELETE_BADGE','¿Seguro que quiere borrar esta insignia?',NOW(),'');
INSERT INTO `language_text` VALUES ('es', '_msg','AT_FEEDBACK_GM_BADGE_REMOVED','Isignia eliminada correctamente.',NOW(),'');
INSERT INTO `language_text` VALUES ('es', '_msg','AT_CONFIRM_GM_DELETE_EVENT_ADMIN','¿Está seguro que quiere eliminar este evento? Eliminar eventos predeterminados puede causar problemas. Asegúrese de saber lo que está haciendo.',NOW(),'');
INSERT INTO `language_text` VALUES ('es', '_msg','AT_CONFIRM_GM_DELETE_EVENT','¿Seguro que quiere eliminar este evento?',NOW(),'');
INSERT INTO `language_text` VALUES ('es', '_msg','AT_FEEDBACK_GM_EVENT_REMOVED','Evento eliminado correctamente.',NOW(),'');
INSERT INTO `language_text` VALUES ('es', '_msg','AT_CONFIRM_GM_DELETE_LEVEL','¿Seguro que quiere eliminar este nivel?',NOW(),'');
INSERT INTO `language_text` VALUES ('es', '_msg','AT_FEEDBACK_GM_LEVEL_REMOVED','Nivel eliminado correctamente.',NOW(),'');
INSERT INTO `language_text` VALUES ('es', '_msg','AT_ERROR_GM_LEVEL_REQUIREMENTS','Se debe definir el título de nivel y un valor de puntos numéricos alcanzados.',NOW(),'');
INSERT INTO `language_text` VALUES ('es', '_msg','AT_FEEDBACK_GM_BADGED_ADDED','Se ha añadido correctamente la insignia. Arrastre una imagen de insignia en la zona desplegable de la primera columna para agregar/editar la insignia.',NOW(),'');
INSERT INTO `language_text` VALUES ('es', '_msg','AT_ERROR_GM_BADGE_REQUIREMENTS','Se debe proporcionar un alias, sin espacios, y un título para la insignia.',NOW(),'');
INSERT INTO `language_text` VALUES ('es', '_msg','AT_INFOS_GM_BADGE_PROPERTIES','Establezca las propiedades de la insignia aquí. Arrastre una imagen de insignia en la dropzone Insignia para la insignia nueva después de guardar.',NOW(),'');
INSERT INTO `language_text` VALUES ('es', '_msg','AT_INFOS_GM_CREATE_EVENT_TEXT','La creación de nuevos eventos también requiere agregar una secuencia de comandos coincidente al archivo events.php del módulo. Consulte la página del Manual para más detalles.',NOW(),'');
INSERT INTO `language_text` VALUES ('es', '_msg','AT_FEEDBACK_GM_UPDATED_OPTIONS','Opciones actualizadas correctamente.',NOW(),'');
INSERT INTO `language_text` VALUES ('es', '_msg','AT_ERROR_GM_UPDATED_OPTIONS_FAILED','Ha fallado la actualización de opciones. Contacte a su administrator si persiste el fallo.',NOW(),'');
INSERT INTO `language_text` VALUES ('es', '_msg','AT_ERROR_GM_MAX_DIMENSION','Se han ecedido las dimensiones máximas de %sx%s. Reduzca la altura y el ancho de la imagen.',NOW(),'');
INSERT INTO `language_text` VALUES ('es', '_msg','AT_ERROR_GM_MAX_FILESESIZE','Se ha superado el tamaño máximo de archivos de %sKB. Reduzca el tamaño de la imagen.',NOW(),'');
INSERT INTO `language_text` VALUES ('es', '_msg','AT_FEEDBACK_GM_CONFIG_UPDATED','La configuración de GameMe se ha actualizado correctamente',NOW(),'');

CREATE TABLE `gm_badges` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `course_id` int(11) NOT NULL DEFAULT '0',
  `alias` varchar(32) NOT NULL DEFAULT '',
  `title` varchar(64) NOT NULL DEFAULT '',
  `description` text,
  `image_url` varchar(96) DEFAULT NULL,
  PRIMARY KEY (`id`,`course_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

INSERT INTO `gm_badges` (`id`, `course_id`, `alias`, `title`, `description`, `image_url`)
VALUES
	(7,0,'upload_file_badge','Good use of File Storage','You have figured out how to upload files into the course.','mods/_standard/gameme/images/badges/arrow.png'),
	(8,0,'create_file_badge','Create your own files','You learned how to create new files in File Storage.','mods/_standard/gameme/images/badges/doc.png'),
	(2,0,'profile_viewed_badge','You\'re getting noticed','25 people have viewed your profile','mods/_standard/gameme/images/badges/eye.png'),
	(1,0,'profile_view_badge','You know your classmates','You have viewed 25 of your classmates\' profiles','mods/_standard/gameme/images/badges/id.png'),
	(4,0,'prefs_update_badge','You found your settings','You know how to update your personal preference, and configure ATutor to your liking. ','mods/_standard/gameme/images/badges/mixer.png'),
	(3,0,'profile_pic_upload_badge','You have a profile pic','People are more likely to interact when you have a profile picture.','mods/_standard/gameme/images/badges/adduser.png'),
	(5,0,'read_page_badge','You are well on your way','You have read 25 pages in the course. Keep going!','mods/_standard/gameme/images/badges/silver.png'),
	(6,0,'new_folder_badge','You\'re organized','You know how to create folder in File Storage to organize your files.','mods/_standard/gameme/images/badges/folder.png'),
	(9,0,'forum_view_badge','Discussion Reader','You are doing a great job reading through discussion posts in the forums.','mods/_standard/gameme/images/badges/bronze.png'),
	(10,0,'forum_post_badge','Discussion Poster','You have been a great contributor in the discussion forums.','mods/_standard/gameme/images/badges/gold.png'),
	(11,0,'forum_reply_badge','Great Feedback','You have been replying to others posts in the discussion forums','mods/_standard/gameme/images/badges/conversation.png'),
	(12,0,'blog_add_badge','Blog Poster','You\'re making great use of the course blog. Keep on posting!','mods/_standard/gameme/images/badges/email.png'),
	(13,0,'blog_comment_badge','Blog Commenter','You have been commenting on other (or your own) blog posts. Keep on commenting.','mods/_standard/gameme/images/badges/lightbulb.png'),
	(14,0,'chat_login_badge','Chat Login','You are making good use of the ATutor chat, a great place to interact live with your classmates','mods/_standard/gameme/images/badges/chat.png'),
	(15,0,'chat_post_badge','Chat Contributor','You are posting message to the chat. Keep on chatting!','mods/_standard/gameme/images/badges/bolt.png'),
	(16,0,'link_add_badge','Link Poster','You\'ve been adding links to the course resources. Keep adding!','mods/_standard/gameme/images/badges/link.png'),
	(17,0,'photo_create_album_badge','Create Album','You learned how to create an album in the Photo Gallery. Keep creating albums to share.','mods/_standard/gameme/images/badges/news.png'),
	(18,0,'photo_create_album_badge','Create Albums','You have created several photo albums. Perhaps photograhpy is your calling!','mods/_standard/gameme/images/badges/brush.png'),
	(19,0,'photo_upload_badge','Photo Uploader','You have been uploading photos into your photo gallery. Keep adding.','mods/_standard/gameme/images/badges/picture.png'),
	(20,0,'photo_comment_badge','Photo comments','You have been commenting you yours and others photos. Keep commenting for bonus points;','mods/_standard/gameme/images/badges/like.png'),
	(21,0,'photo_album_comment','Album Comment','Most people comment on photo, but you commenteed on an album for bonus points.','mods/_standard/gameme/images/badges/cards.png'),
	(22,0,'photo_description_badge','Photo Describer','Exellent job providing descriptions for you photos. ','mods/_standard/gameme/images/badges/feather.png'),
	(23,0,'photo_alt_text','Accessibility Aware','Its great you are providing Alt text for you image, to make them accessible to people with disabilities. Secret bonus points if you continue adding Alt text to new images in your gallery.','mods/_standard/gameme/images/badges/heart.png'),
	(24,0,'login_badge','Returning Visitor','You have come back quite a few times now. Keep on visiting the course for bonus points.','mods/_standard/gameme/images/badges/hot.png'),
	(25,0,'logout_badge','Security Conscious','You have been logging out, rather than leaving or allowing your session to time out. This helps improve security.','mods/_standard/gameme/images/badges/lock.png'),
	(26,0,'welcome_badge','Welcome','Welcome to the course. Finding your way here earned you your first badge. Get busy with the course to earn points and collect more badges.','mods/_standard/gameme/images/badges/acorn.png');

CREATE TABLE `gm_events` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `course_id` int(11) NOT NULL DEFAULT '0',
  `alias` varchar(32) NOT NULL DEFAULT '',
  `description` text,
  `allow_repetitions` tinyint(1) DEFAULT '1',
  `reach_required_repetitions` int(11) DEFAULT NULL,
  `max_points` int(11) DEFAULT NULL,
  `id_each_badge` int(11) DEFAULT NULL COMMENT '	',
  `id_reach_badge` int(11) DEFAULT NULL,
  `each_points` int(11) DEFAULT NULL,
  `reach_points` int(11) DEFAULT NULL,
  `each_callback` varchar(64) DEFAULT NULL,
  `reach_callback` varchar(64) DEFAULT NULL,
  `reach_message` varchar(1500) DEFAULT NULL,
  PRIMARY KEY (`id`,`course_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

INSERT INTO `gm_events` (`id`, `course_id`, `alias`, `description`, `allow_repetitions`, `reach_required_repetitions`, `max_points`, `id_each_badge`, `id_reach_badge`, `each_points`, `reach_points`, `each_callback`, `reach_callback`, `reach_message`)
VALUES
	(2,0,'profile_view','Profile view other\'s',0,10,NULL,NULL,1,10,25,NULL,'GmCallbacksClass::ProfileViewReachCallback','Congratulations, you have received a new badge for getting to know your classmates by viewing their profiles. You can earn additional points by sending a private message to a person through their profile page.'),
	(3,0,'profile_viewed','Profile viewed by others',0,25,NULL,NULL,2,25,50,NULL,'GmCallbacksClass::ProfileViewedReachCallback','Congratulations, you have received a new badge because lots of people have been viewing your profile.'),
	(4,0,'sent_message','Send a private message',0,10,NULL,NULL,NULL,25,50,NULL,NULL,NULL),
	(5,0,'profile_pic_upload','Upload a profile picture',0,1,NULL,NULL,3,100,200,NULL,'GmCallbacksClass::ProfilePicUploadCallback','Congratulations, you have received a new badge for adding a profile picture. Update your profile picture occassionally to receive additional points.'),
	(6,0,'read_list_view','View reading list details',0,15,NULL,NULL,NULL,25,50,NULL,NULL,NULL),
	(7,0,'prefs_update','Update personal preferences',0,1,NULL,NULL,4,25,250,NULL,'GmCallbacksClass::PreferencesUpdateCallback','Congratulations, you have received a new badge for updating your personal preferences.'),
	(8,0,'read_page','Pages viewed',0,25,NULL,NULL,5,10,25,NULL,'GmCallbacksClass::ReadPageCallback','Congratulations, you have received a new badge for getting a good amount of course reading done!'),
	(9,0,'new_folder','Create file storage folder',0,1,NULL,NULL,6,25,100,NULL,'GmCallbacksClass::FileStorageFolderCallback','Congratulations, you have received a new badge for learning how to create folders to organize your files. You can also earn points and badges by adding files to those folders'),
	(10,0,'upload_file','Upload to file storage',0,5,NULL,NULL,7,25,50,NULL,'GmCallbacksClass::UploadFilesCallback','Congratulations, you have received a new badge for learning how to use file storage to store your files. Create additional folders to organize your files for additional points and badges.'),
	(11,0,'create_file','Create file in file storage',0,2,NULL,NULL,8,50,100,NULL,'GmCallbacksClass::CreateFilesCallback','Congratulations, you have received a new badge for learning how to create new files in file storage.'),
	(12,0,'file_comment','Comment on a file storage file',0,5,NULL,NULL,NULL,25,50,NULL,NULL,NULL),
	(13,0,'file_description','Provide description for file storage file',0,5,NULL,NULL,NULL,50,100,NULL,NULL,NULL),
	(14,0,'forum_view','Forum discussions viewed',0,25,NULL,NULL,9,25,150,NULL,'GmCallbacksClass::ForumViewCallback','Congratulations, you have received a new badge for keeping up with reading forum posts. Continue reading forum posts, start new threads, and reply to others posts to earn additional points and badges.'),
	(15,0,'forum_post','Forum posts',0,10,NULL,NULL,10,50,100,NULL,'GmCallbacksClass::ForumPostsCallback','Congratulations, you have received a new badge for contributing new threads to the discussion forums. Continue reading forum posts, start new threads, and reply to others posts to earn additional points and badges.'),
	(16,0,'forum_reply','Forum replies',0,5,NULL,NULL,11,75,150,NULL,'GmCallbacksClass::ForumReplyCallback','Congratulations, you have received a new badge for contributing good feedback to discussion forums. Continue reading forum posts, start new threads, and reply to others posts to earn additional points and badges.'),
	(17,0,'read_time','Page view time',0,10,NULL,NULL,NULL,25,100,NULL,NULL,NULL),
	(18,0,'blog_add','Blob posts',0,10,NULL,NULL,12,25,100,NULL,'GmCallbacksClass::BlogAddCallback','Congratulations, you have received a new badge for contributing a good collection of blog posts. Continue adding to your blog, and comments on others\' blogs to earn additional points and badges.'),
	(19,0,'blog_comment','Blog comments',0,2,NULL,NULL,13,25,100,NULL,'GmCallbacksClass::BlogCommentsCallback','Congratulations, you have received a new badge for contributing good feedback, and commenting on blog posts. Continue posting to your blog, and commenting on others\' blog posts to earn additional points.'),
	(20,0,'blog_view','Blog views',0,15,NULL,NULL,NULL,15,50,NULL,NULL,NULL),
	(21,0,'blog_post_view','Blog posts viewed',0,10,NULL,NULL,NULL,10,25,NULL,NULL,NULL),
	(22,0,'chat_login','Chat login',0,10,NULL,NULL,14,5,100,NULL,'GmCallbacksClass::ChatLoginCallback','Congratulations, you have received a new badge for logging into the chat regularly. Just using the chat helps accumulate points.'),
	(23,0,'chat_post','Chat posts',0,50,NULL,NULL,15,5,100,NULL,'GmCallbacksClass::ChatPostCallback','Congratulations, you have received a new badge for keeping conversation going in the chat room. Returning to the chat room regularly earns additional points.'),
	(24,0,'link_add','Links added',0,2,NULL,NULL,16,25,50,NULL,'GmCallbacksClass::LinkAddCallback','Congratulations, you have received a new badge for making a good contribution to the course links. View links others have posted to earn additional points.'),
	(25,0,'link_view','Links followed',0,15,NULL,NULL,NULL,10,25,NULL,NULL,NULL),
	(26,0,'poll_post','Polls posted',0,2,NULL,NULL,NULL,25,75,NULL,NULL,NULL),
	(27,0,'photo_create_album','Photo album created',1,1,NULL,17,NULL,50,100,NULL,'GmCallbacksClass::PhotoAlbumCallback','Congratulations, you have received a new badge for creating a photo album. Continue adding photos to earn more points and badges.'),
	(28,0,'photo_upload','Photo uploads',0,10,NULL,NULL,19,25,50,NULL,'GmCallbacksClass::PhotoUploadCallback','Congratulations, you have received a new badge for uploading a good collection of photos. Continue adding photos to earn more points. Create additional albums to organize your photos for bonus points.'),
	(29,0,'photo_view_album','View photo album',0,5,NULL,NULL,NULL,10,30,NULL,NULL,NULL),
	(30,0,'photo_view_photo','View photo',0,25,NULL,NULL,NULL,10,25,NULL,NULL,NULL),
	(31,0,'photo_comment','Comment on a photo',0,2,NULL,NULL,20,25,75,NULL,'GmCallbacksClass::PhotoCommentCallback','Congratulations, you have received a new badge for providing comments on yours, and others photos. Continue commenting to earn additional points. You can also comment on photo albums as a whole, to earn bonus points.'),
	(32,0,'photo_album_comment','Comment on an album',0,5,NULL,NULL,21,50,150,NULL,'GmCallbacksClass::PhotoAlbumCommentCallback','Congratulations, you have received a new badge for providing comments on your\'s, and other\'s albums. Continue commenting about albums for additional points.'),
	(33,0,'photo_description','Photo descriptions provided',0,5,NULL,NULL,22,25,150,NULL,'GmCallbacksClass::PhotoDescriptionCallback','Congratulations, you have received a new badge for providing descriptions for your photos. Add alternative text to make your photos accessible to blind classmates, and earn bonus points and a badge.'),
	(34,0,'photo_alt_text','Photo Alt texts provided',0,2,NULL,NULL,23,50,250,NULL,'GmCallbacksClass::PhotoAltTextCallback','Congratulations, you have received a new badge for providing alternative text for your photos. This makes photos accessible to blind classmates using a screen reader to access the course. Providing descriptions for your photos can also earn points, and a badge.'),
	(35,0,'photo_create_albums','Photo albums created',0,3,NULL,NULL,18,50,100,NULL,'GmCallbacksClass::PhotoAlbumsCallback','Congratulations, you have received a new badge for creating multiple photo albums to organize your photos. Continue adding photos to earn more points.'),
	(1,26,'login','Login',0,NULL,NULL,1,2,10,25,NULL,'GmCallbacksClass::LoginReachCallback',''),
	(38,0,'logout','Logout (not timeout)',0,2,250,NULL,25,10,25,NULL,'GmCallbacksClass::LogoutReachCallback','Congratulations, you have received a new badge for logging out properly, instead of leaving or letting your session timeout, maintaining your privacy and security. '),
	(39,0,'welcome','First course login',1,1,250,NULL,26,250,NULL,NULL,'GmCallbacksClass::WelcomeCallback','Welcome to the course. You have earned your first badge by successfully logging in. Continue earning badges by using the features in the course, and participating in course activities.<br /><br />By participating in the course you can also earn points and advance through levels as your points grow. Follow the leader board to see your position among others in the course. Watch for hints after earning a badge, for earning additional badges and bonus points.'),
	(2,26,'profile_view','Profile view other\'s',0,10,NULL,NULL,1,10,25,NULL,NULL,NULL),
	(1,0,'login','Login',0,25,NULL,NULL,24,10,100,NULL,'GmCallbacksClass::LoginReachCallback','Congratulations, you have received a new badge for logging into the course many times. You can also earn points by logging out of the course properly, clicking the logout link, instead of just leaving or letting your session timeout.'),
	(37,0,'submit_test','Submit a test or quiz',0,5,NULL,NULL,NULL,100,250,NULL,NULL,NULL),
	(1,3,'login','Login',0,25,NULL,NULL,24,10,100,NULL,'GmCallbacksClass::LoginReachCallback',NULL),
	(3,26,'profile_viewed','Profile viewed by others',0,25,NULL,NULL,2,25,50,NULL,'GmCallbacksClass::ProfileViewedReachCallback','Congratulations, you have received a new badge because lots of people have been viewing your profile.');

CREATE TABLE `gm_levels` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `course_id` int(11) NOT NULL DEFAULT '0',
  `title` varchar(64) NOT NULL DEFAULT '',
  `description` text,
  `points` int(11) NOT NULL,
  `icon` varchar(25) DEFAULT NULL,
  PRIMARY KEY (`id`,`course_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

INSERT INTO `gm_levels` (`id`, `course_id`, `title`, `description`, `points`, `icon`)
VALUES
	(1,0,'Level 0','Welcome to the course',0,'star_empty_lg.png'),
	(2,0,'Level 1','1000 points passed',1000,'star_white_lg.png'),
	(3,0,'Level 2','2500 points passed',2500,'star_yellow_lg.png'),
	(4,0,'Level 3','5000 points passed',5000,'star_red_lg.png'),
	(5,0,'Level 4','7500 points passed',7500,'star_green_lg.png'),
	(6,0,'Level 5','10000 points passed: ',10000,'star_blue_lg.png'),
	(7,0,'Level 6','20000 points passed',20000,'star_black_lg.png'),
	(8,0,'Level 7','25000 points passed: Accomplished status, Bronze Badge',25000,'star_bronze_lg.png'),
	(9,0,'Level 8','35000 point passed: Intermediate status, Silver Badge',35000,'star_silver_lg.png'),
	(10,0,'Level 9','50000 points passed: Advanced status: Gold Badge',50000,'star_gold_lg.png'),
	(11,0,'Level 10','65000 point passed: Highest Honor: Platinum Badge',65000,'star_platinum_lg.png');

CREATE TABLE `gm_options` (
`id` int(11) unsigned NOT NULL,
  `course_id` int(11) unsigned NOT NULL,
  `gm_option` varchar(25) NOT NULL DEFAULT '',
  `value` int(11) unsigned DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

CREATE TABLE `gm_user_alerts` (
  `id_user` int(10) unsigned NOT NULL,
  `course_id` int(10) unsigned DEFAULT NULL,
  `id_badge` int(10) unsigned DEFAULT NULL,
  `id_level` int(10) unsigned DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

CREATE TABLE `gm_user_badges` (
  `id_user` int(10) unsigned NOT NULL,
  `id_badge` int(10) unsigned NOT NULL,
  `badges_counter` int(10) unsigned NOT NULL,
  `grant_date` datetime NOT NULL,
  `course_id` int(10) unsigned NOT NULL DEFAULT '0'
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

CREATE TABLE `gm_user_events` (
  `id_user` int(10) unsigned NOT NULL,
  `id_event` int(10) unsigned NOT NULL,
  `event_counter` int(10) unsigned NOT NULL,
  `points_counter` int(10) unsigned NOT NULL,
  `course_id` int(10) unsigned NOT NULL DEFAULT '0'
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

CREATE TABLE `gm_user_logs` (
  `id_user` int(10) unsigned NOT NULL,
  `course_id` int(10) unsigned DEFAULT NULL,
  `id_event` int(10) unsigned DEFAULT NULL,
  `event_date` datetime NOT NULL,
  `id_badge` int(10) unsigned DEFAULT NULL,
  `id_level` int(10) unsigned DEFAULT NULL,
  `points` int(10) unsigned DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

CREATE TABLE `gm_user_scores` (
  `id_user` int(10) unsigned NOT NULL,
  `points` int(10) unsigned NOT NULL,
  `id_level` int(10) unsigned NOT NULL,
  `course_id` int(10) unsigned NOT NULL DEFAULT '0'
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
/*
ALTER TABLE `gm_badges`
 ADD PRIMARY KEY (`id`,`course_id`);

ALTER TABLE `gm_events`
 ADD PRIMARY KEY (`id`,`course_id`);

ALTER TABLE `gm_levels`
 ADD PRIMARY KEY (`id`,`course_id`);
*/
ALTER TABLE `gm_options`
 ADD PRIMARY KEY (`course_id`,`gm_option`), ADD KEY `id` (`id`);
ALTER TABLE `gm_options`
 CHANGE `option` `gm_option` VARCHAR(25) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT 
ALTER TABLE `gm_user_badges`
 ADD PRIMARY KEY (`id_user`,`id_badge`,`course_id`);

ALTER TABLE `gm_user_events`
 ADD PRIMARY KEY (`id_user`,`id_event`,`course_id`);

ALTER TABLE `gm_user_logs`
 ADD KEY `id_user` (`id_user`);

ALTER TABLE `gm_user_scores`
 ADD PRIMARY KEY (`id_user`,`course_id`);

ALTER TABLE `gm_badges`
MODIFY `id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=27;

ALTER TABLE `gm_events`
MODIFY `id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=40;

ALTER TABLE `gm_levels`
MODIFY `id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=14;

ALTER TABLE `gm_options`
MODIFY `id` int(11) unsigned NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=410;
