File Log

[eluser]haris244808[/eluser]
[quote author="TheFuzzy0ne" date="1364729894"]I think logging to the database would make much more sense. It would give you a lot more control over the data you could retrieve. For example, you'd be able to answer the following questions:

What files were created yesterday?
How many files were sent 7 days ago.
Who has created the most files?
Who has received the most files?

And the list goes on... I'm pretty sure you wouldn't be able to do that with plain text files.

Now, when a file is uploaded, the date of creation is stored in the database along with the file information. You could do with another table which tracks the movements. Every time it's sent to someone, add a row. You table would probably need to be something like this:

| file_id | sender_id | recipient_id | sent_on |

You might need to add more columns, but with that, you can index every column, and join the table to the other relevant tables.[/quote]

when u say "add new row"...u mean to insert the data and not to update it??

ex: User1(with id=1) creates a data and sends to User2(with id=2) ... now user2 modifies the data and sends it to user3..
Now when i click the log button of this file i want to show:
User1 created the file (date when was created)
User1 Sent filefilename) to USer2 (date when was sent)
User2 Edit file(filename) (date when was edited)
User 2 sent file:filename to user3 ((date when was sent))

so here i have to vreate a table 'log' an whenever smth happens to insert a new data(row) to table??