Results 1 to 4 of 4
  1. #1
    Join Date
    Jun 2009
    Location
    UK: Oxford
    Posts
    1,256

    New Project - Activity Logging

    Good afternoon,

    I require some assistance from some experienced programmers. I have been invited onto a very high-profile project. Because of its nature, I cannot discuss what it is but I am able to seek assistance.

    We basically need to record the logs of EVERYONE using the website. I have suggested using a MySQL cluster. After structuring that, we now need a piece of code to record all activity for each user on the website.

    So, as soon as a user logs in, It will record...

    "User [id] Logged in"
    "Account Page > PAGE X"
    "PAGE X > PAGE Y"
    "User [id] Logged out"

    These are just examples, but anyone got an idea of how to do this?
    Garbott Ltd - Professional web development & consultancy services
    Oxford.Hosting - Prestigious shared, cloud, dedicated and gaming hosting solutions.

  2. #2
    Join Date
    Apr 2007
    Posts
    3,513
    How accurate does this need to be?

    I would be tempted to only log their IP when they first login, then at a later date you could filter the Apache logs (based on that logged IP) and work out what pages that user visited. The flaw to this would be if two users login with the same IP.

    It would be a lot less resource intensive than making a SQL update/insert each page load.

    The log filtering could also be done by a separate machine/vps to ensure it doesn't impact the front end servers performance, if thats a concern.
    - Buying up websites, side-projects and companies - PM Me! -

  3. #3
    Join Date
    Jun 2009
    Location
    UK: Oxford
    Posts
    1,256
    It does need to be pretty accurate. IP addresses are already logged on account registration.

    I have this idea the in each file we have, we place a "$file" variable. Then if this changes, to insert into MySQL the $file?

    So, for example, if user visits "[domain].com/index.php" and they are logged in, index.php will have "$file = 'index.php'". The user then goes to their account, "[domain].com/account.php", this too has "$file = 'account.php'".

    Do you know of anything that can detect a change in a variable?
    Garbott Ltd - Professional web development & consultancy services
    Oxford.Hosting - Prestigious shared, cloud, dedicated and gaming hosting solutions.

  4. #4
    Join Date
    Jun 2009
    Location
    UK: Oxford
    Posts
    1,256
    [SOLVED] PLEASE DO NOT POST INTO THIS THREAD!
    Garbott Ltd - Professional web development & consultancy services
    Oxford.Hosting - Prestigious shared, cloud, dedicated and gaming hosting solutions.

Similar Threads

  1. Paid Project: Java developer needed for basic project(s)
    By yugnats in forum Employment / Job Offers
    Replies: 9
    Last Post: 04-30-2014, 04:48 AM
  2. Project: Kemet Mall Project [Seeking PHP Developer/Company]
    By NuPixel in forum Employment / Job Offers
    Replies: 1
    Last Post: 03-21-2006, 08:46 AM
  3. Request: Graphic Designer Required on Project by Project Basis
    By crucialy in forum Employment / Job Offers
    Replies: 2
    Last Post: 12-22-2005, 08:02 PM
  4. Replies: 0
    Last Post: 05-05-2004, 02:33 AM
  5. Raq4 stopped logging (plus other logging questions)
    By Addict in forum Dedicated Server
    Replies: 3
    Last Post: 08-27-2001, 10:29 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •