Thanks Bob that's the kind of thing I was thinking about.
Leon's suggestion about altering the URL and tracking via a "fake log file
using Apache" is probably a good one if I had that kind of server access. In
fact I was reading an article: http://www.alistapart.com/stories/urls/ about
just that kind of thing.
Anyway, I've got a few more things to be getting on with before that so
thanks again.
Nick
Bob Hutchinson wrote:
> 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
------------------------------------------------------------
To subscribe: [EMAIL PROTECTED]
To unsubscribe: [EMAIL PROTECTED]
Site: http://www.working-dogs.com/freetrade/
Problems?: [EMAIL PROTECTED]
