As per our discussion:
We are making a flash website for our client
we are localising for uk/fr/it/de/es/pt/dk
it has an application that sends virtual letters to santa
when a user visits the letter part of the application the website needs to contact a database to get the number of letters that have been sent. all country versions user the same database and the number sent = the total number sent.
TASK = write script for flash site to get total numbers of letter sent
When users write a letter to santa in the site they click 'send' and the flash site tells the database a letter is sent
the database must store the date/time this was sent, the country site it came from i.e. uk, the number sent (1) and the method of adding i.e. site
TASK - write script to add row in database from flash site - so site sends you just the country code and datanbase in incremented with the date/country/number (always 1 from site) and method (always 'site' from site)
Admin tool = we need an admin tool on the clients server and this will need to be made simply but securely so no danger of sql injection and config details separate from code - more details on this to come (minor stuff to drop on clients server).
So admin enters user/pass
On successful login user can
1. see total letter sent
2. see total letters sent by country
3. search total letters sent by date, as all, or specific country versions
4. Add to the number of letters sent...
The client has shops that have postboxes where kids will post real letters.
therefore the client will need to enter numbers weekly of the letters received in stores
therefore admin can add to the letters sent in which case they enter a number, select a single country OR select country 'unknown' - and they enter a number. we save this as method 'admin'.
The admin user can also see and delete all entries and filter them by 'site' and 'admin' method entries.
TASK - create admin tool
I don't think this needs to be a codeigniter project - unless you feel strongly that it does.
We are dropping this on our clients server so it will come under judgement if it is badly made or has security issues.