ERROR:SQLSTATE[HY000]: General error: 20018 Invalid column name 'CodigoInstitucion'. [20018] (severity 16) [SELECT PublicObrasAutores.NumeroEmpleado, PublicObrasAutores.ApellidoPaterno, PublicObrasAutores.ApellidoMaterno, PublicObrasAutores.Nombre, PublicObrasAutores.NombreCompleto FROM PublicObrasAutores LEFT JOIN PublicObrasAutoresFil ON PublicObrasAutores.RefPublicacion = PublicObrasAutoresFil.RefPublicacion WHERE PublicObrasAutores.RefPublicacion = '384348' AND PublicObrasAutores.NumeroEmpleado IS NULL AND PublicObrasAutoresFil.CodigoInstitucion IS NOT NULL;]
®
ERROR:SQLSTATE[HY000]: General error: 20018 Invalid column name 'CodigoInstitucion'. [20018] (severity 16) [SELECT PublicObrasAutores.NumeroEmpleado, PublicObrasAutores.ApellidoPaterno, PublicObrasAutores.ApellidoMaterno, PublicObrasAutores.Nombre, PublicObrasAutores.NombreCompleto FROM PublicObrasAutores LEFT JOIN PublicObrasAutoresFil ON PublicObrasAutores.RefPublicacion = PublicObrasAutoresFil.RefPublicacion WHERE PublicObrasAutores.RefPublicacion = '384348' AND PublicObrasAutores.NumeroEmpleado IS NULL AND PublicObrasAutoresFil.CodigoInstitucion IS NULL;]
®
ERROR:SQLSTATE[HY000]: General error: 20018 Invalid column name 'Institucion'. [20018] (severity 16) [SELECT Institucion FROM PublicObrasAutoresFil WHERE RefPublicacion = '384348']
®
ERROR:SQLSTATE[HY000]: General error: 20018 Invalid column name 'Institucion'. [20018] (severity 16) [SELECT Institucion FROM PublicObrasAutoresFil WHERE RefPublicacion = 384348 AND InstitucionPropia = 'S'
UNION
SELECT Adscripciones.Entidad FROM PublicacionesObras
JOIN PublicObrasAutores ON PublicacionesObras.Identificador = PublicObrasAutores.RefPublicacion
JOIN Adscripciones ON PublicObrasAutores.NumeroEmpleado = Adscripciones.NumeroEmpleado
WHERE (PublicacionesObras.FechaPublicacion BETWEEN Adscripciones.FechaDesde AND Adscripciones.FechaHasta OR (PublicacionesObras.FechaPublicacion >= Adscripciones.FechaDesde AND Adscripciones.FechaHasta IS NULL)) AND PublicacionesObras.Identificador= 384348]
SIIA Público
SISTEMA INTEGRAL DE INFORMACIÓN ACADÉMICA - PÚBLICO
Título del libro: Acm International Conference Proceeding Series Título del capítulo: Familiarity of challenges and optimal experience in movement interaction games
Autores UNAM: JUAN PABLO ROMERO MARES;
Autores externos: Idioma: Año de publicación: 2012Palabras clave:
Flow; Movement interaction; Player experience
Resumen:
This paper reports on a project that is investigating the way challenge affects optimal experience or flow in movement interaction games. There are three important conditions to promote an optimal experience: a balance between the player's level of skill and the challenges that she/he has to face, goals that are clear and compatible and immediate feedback on the gaming session. The challenge-skills balance has been considered as the most important condition. It has also been proposed that the challenges of the game are composite in the sense that they can include cognitive, physical and affective factors. However, one key question that remains to be addressed is: what makes a challenge suitable? This paper addresses this question by investigating the role that familiarity plays when players consider how suitable a challenge is, and therefore how good a game is. This investigation is performed in an empirical way. A prototype of a movement interaction game is employed to compare familiar with unfamiliar challenges and also to investigate the effect that motivating an unfamiliar challenge has in its acceptance by players. Copyright 2012 ACM.