How about something like this?
# table name: loggit
# Switch to the new database
USE freetrade;
DROP TABLE IF EXISTS loggit;
CREATE TABLE loggit
(
ID INT(11) NOT NULL AUTO_INCREMENT,
ItemID INT(11),
Screen VARCHAR(255),
Created TIMESTAMP,
PRIMARY KEY(ID)
);
## END SQL ##
<?php
# insert a hit into loggit
# this code could be inserted into the item page and/or elsewhere
$Query = "INSERT INTO loggit SET ";
$Query .= "ItemID = " . $Item["ID"] . ", ";
$Query .= "Screen = '" . $SCREEN . "' ";
if(!mysql_query($Query, $DatabaseLink))
{
$ActionResults[] = mysql_errno() . ": " . mysql_error() .
" Query was $Query";
}
?>
You'll have to figure out your own select statements
Or try
http://yasd.dhs.org/en/apachedb.php3
This is a set of scripts, the frontend is php and the backend is perl. Requires
DBI, DBI::DBD, Time::ParseDate, mysql, Socket perl modules
Logs Apache's access_log.
Can be run as a cron job or squirted directly into mysql from apache, for
dynamic logs.
The php scripts could be tuned to haul out the hits on your cart and lookup
the item number
in your freetrade database, presenting your clients with the info they
want, (hopefully)
At 02:10 18/01/01, you wrote:
>Another shopping cart system I've worked on (Miva Merchant, which I have to
>say is painful compared to Freetrade, even my client has said so!!) has a
>logging sytem and using a log viewer the retailer could follow most visited
>items, items placed in the basket, etc.
>
>I'm curious as to whether anyone has set up a logging/tracking system for
>Freetrade or what would be the best way to go about it. It seems to me that
>this would be a major enhancement to the system.
>
>Thanks in advance,
>
>Nick Lo
>
>
>----------------------
>Lab2 Design Unit
>URL: www.lab2.com.au
>e-mail: [EMAIL PROTECTED]
>----------------------
>
>
>
>------------------------------------------------------------
>To subscribe: [EMAIL PROTECTED]
>To unsubscribe: [EMAIL PROTECTED]
>Site: http://www.working-dogs.com/freetrade/
>Problems?: [EMAIL PROTECTED]
bye
Bob Hutchinson
[EMAIL PROTECTED]
------------------------------------------------------------
To subscribe: [EMAIL PROTECTED]
To unsubscribe: [EMAIL PROTECTED]
Site: http://www.working-dogs.com/freetrade/
Problems?: [EMAIL PROTECTED]
