pacoorozco/gamify

[THIS WON'T BE UPDATED] Gamification platform - The core of GoW!

gamify's Issues

Optimize DB schema

After some work, I think there is some changes pending on DB schema.

1. Add register_date field to members table
2. Change to DATETIME format all date's containing columns. We must change PHP code to be able to work with it. Work with dates in PHP
3. Change amount_needed, points, amount for something more coherent such us xp_points
4. Removes level_id from members and put on vmembers
5. Add total_xp_points to vmembers
6. Add level_name to vmembers

Add cleanURL to application

In order to give a more SEO application it will be great to use URLs like:

http://localhost/login
http://localhost/logout
http://localhost/register

http://localhost/quiz
http://localhost/quiz/000-000-0000-000
http://localhost/quiz/list

http://localhost/member
http://localhost/member/000-000-0000-000

We can use AltoRouter

Is possible to answer secret questions twice

He respost dues vegades seguides a la pregunta oculta i m'ha donat els punts... La teniu oberta.
Salutacions i bona feina.
Alfonso

Some DB.class functions returns incorrect values

Whe use some DB.class functions, like getOne() in SELECT without any record returned it doesn't return NULL. Instead of this return a empty array.

It must change this behaivour in order to return NULL.

return (is_array($row)) ? reset($row) : null;

change to some like this

return ($result->num_rows > 0) ? reset($row) : null;

Pagination on large lists

Adds some pagination on large lists, like "Preguntes pendents" o "Revisa Preguntes"

XSS on 'nav' field on login page

An attacker can use 'nav' input field in order to do XSS. This 'nav' input is not sanitize, more than header() function does.

A good approach is not to use this input field, using a $_SESSION instead

Add time periods to actions

For example:

• a achieve to obtain a badge is limited once a day
• you can't reply more than X questions at week

Enable notifications

Enable app to send email notifications where:

• a question is published (to admins)
• a question is published (to users with "notify me" checked)

Avoid admin users doing member actions

Users with administrator rights shouldn't execute member's actions like XP, badges...

Levels are incorrectly assigned

Member A with more experience points than member B, has a lesser level.
I think there's a problem when experience points are granted and calculate new level.

Add tags to questions

Add tags to question in order to categorize or filter questions. It will allow to create challenges or other categorized queries.

• 1 table (tag_id, tag)
• 1 table (question_id, tag_id)

We can use Bootstrap tag:
http://timschlechter.github.io/bootstrap-tagsinput/examples/

Improve Question List section

We must improve the way we show question list.
May be using a table with filters (DataTables).

Add a dispatcher for HTTP request

We want to add a HTTP dispatcher, for example Slim Framework in order to prepare this app to have REST url, API...

Separate HTML code from PHP code using templates

In some cases will be great to separate HTML code form PHP code.
This code can be reused and mantained esier than mixed HTML & PHP code

Create charts about question choices answered by ppl

It would be great if a question may include a chart with people answers.
For example:
In this question how many ppl has answered which choice.

We can use Chart.js

File uploads for admin managements functions

Code file uploads actions in order to upload images to:

• question management
• level management
• badge management

On member management is implemented profile picture uploads from v2.7, may be we can use the same or similar code