After having the database layout figure out, I managed to get the the basic ‘create ticket’ up an running, it’s also possible for admins to create a ticket for other users. Admins can view the list of users and can easily edit their settings & create tickets this way.
The change gender & country issue from last week is also fixed! Also a lot of other small issues are fixed, like the install.php file is updated to the newest version.
Let’s take a quick look at the DB layout:
The database layout covers most of the future functions, the layout is the following
The classes: ticket, ticket_user, ticket_category, ticket_reply and ticket_content are already made and are used for creating the ticket.
You can also already specify a ticket category from a list loaded from the DB.
A demo version is already running on: http://hexon.neejberhood.be/~daan/ryzom_ams/www/html/index.php you can login with admin/admin
Next week I’ll try to get:
– Read ticket, reply on ticket, show ticketlist based on queues
– Focus also on the different roles: developer, moderator etc
– refine create ticket with add tags etc..
– if time permits, already take a look at the tags.
Note to myself:I have to put more functionality inside the lib, perhaps I need to refactor some parts.
Daan.codes// Coding to save the universe 