Re: [PHP] Re: efficient log system

2007-06-12 Thread Richard Lynch
Since there are probably a very limited number of actions a user can take, you could probably easily reduce this by numbering each action: define(1, 'logged in'); define(2, 'logged out'); define(3, 'uploaded photo'); Your DB then table might then look like: user_id action_id notes 42 1

Re: [PHP] Re: efficient log system

2007-06-12 Thread Jim Lucas
Christian Hänsel wrote: Hello Alain, I can just tell you from my experience. I have recently created a, in my eyes, pretty big project, and wanted to track everything, starting from user navigation over search queries to login/out times, article printout times and count, photo views and every

[PHP] Re: efficient log system

2007-06-12 Thread Christian Hänsel
Hello Alain, I can just tell you from my experience. I have recently created a, in my eyes, pretty big project, and wanted to track everything, starting from user navigation over search queries to login/out times, article printout times and count, photo views and everything your mind can imagi

[PHP] Re: efficient log system

2007-06-12 Thread Colin Guthrie
Alain Roger wrote: > Hi, > > I would like to create a log system to keep a trace of all users' actions > (log-in, remove, change or update data, and so on...). > What should i do or to what should i take care to not have problem ? > > I was thinking to create a folder on my server where log files