Linha do Texto Semiotic Classifier Game Code
Status: Beta
Brought to you by:
acris
README ====== LINHA DO TEXTO SEMIOTIC CLASSIFIER GAME ================
1. INTRODUCTION
This game works comparing the avaliation of some texts and parameters, previously selected.
For example:
you have the colors blue and red inside texts:
title: blue A
text: The sky is blue today.
title: blue B
text: I like blue songs.
title: red
text: Aples are red.
If the parameters are exact/similar and colour/efect, people will click in each title and, reading the whole text, will vote about what parameter is near from the sense of the text, in a scale from 1 to 9 colours.
Every vote is writing in a mysql database and the game returns the average of votes in order to put the title distributed in the line of texts (linha do texto) conforming the votes.
The game can be used to explain certains theorectical concepts as well as to research about contente sense of texts.
2. HOW TO INSTALL
a) You must to copy the directory linhadotexto in a php/mysql server.
b) open the config.php file in order to replace the data about database and password. Save it.
c) Create the database linhadotexto linked to the username you had created for it. The database must contain 4 tables, without data:
- jogo >> 3 fields: id_jogo (int(11), not_null, auto_increment), jogo (varchar(100), latin1_swedish_ci, not_null) and email (varchar(100), latin1_swedish_ci, not_null)
- parametro >> 4 fields: id_parametro (int(11), not_null, auto_increment), id_jogo (int(11), not_null), parametroa (varchar(100), latin1_swedish_ci, not_null) and parametrob (varchar(100), latin1_swedish_ci, not_null)
- texto >> 4 fields: id_texto (int(11), not_null, auto_increment), id_jogo (int(11), not_null), titulo (varchar(100), latin1_swedish_ci, not_null) and texto (varchar(100), latin1_swedish_ci, not_null)
- voto >> 4 fields: id_voto (int(11), not_null, auto_increment), id_jogo (int(11), not_null), id_texto (int(11), not_null) and voto (int(11), not_null)
Then it is ready for using.
3. HOW TO CREATE A GAME
- The initial page is the index.php.
- Go to "Criar" (crialinhadotexto.php).
- Put the required data: password for creating games (it is in the config.php file); your name and an valid e-mail address.
- Click on "Cadastrar".
- Find the number of your game in the listajogos.php ("Listar jogos e IDs")
EDIT/DISPOSE NEW TEXTS AND TITLES:
- Click on "Para inserir textos no novo jogo, clique aqui!" (editalinhadotexto.php)
- Repeat the game's ID in the form.
- Click on "Envia"
- Put the data in the form: password for creating games, your email, titles and texts (from 1 to 9, but you can leave white fields of texts and titles)
- Click on "Edita Texto"
EDIT/DISPOSE NEW PARAMETERS:
- Click on "Inserir/Editar Parâmetros" (insereparametro.php)
- Repeat the game's ID in the form.
- Click on "Envia"
- Put the data in the form: password for creating games, your email, the categories parametroa vs. parametrob (from 1 to 4, but you can leave white fields of texts and titles)
- Click on "Edita parâmetro"
Your game is ready! Go to the main page (Volta para a Linha do Texto) in order to initiate the game.
4. HOW TO PLAY
Read the INTRODUCTION.
5. TO DO
- bug: after voting, the game's page does not refresh automatically
- bug: the number of the new game must appear automatically in the edit page, for texts and/or parameters.
- bug: the game always shows 9 texts and titles, and 4 parameter's categories, even you decided to make a game with less than the maximum for each one.
- bug: the game does not point out if you put just one side of the categorie and left the other without data;
- the data base does not register the categorie for each vote.
- The game is in Brazilian Portuguese and the language is hard coded yet, but we have planned to make a language file for future translations.