Statistics/Tracking

Hi,
use View page: Before process, List page: Before processevents on the Events tab to save all changes in your log table.

Here is a sample for the view page:

global $conn,$strTableName;

$str = "select * from log_table where UserID='".$_SESSION["UserID"]."' and Table='".$strTableName."'";

$sr = db_query($str,$conn);

if ($data = db_fetch_array($rs))

{

$strUpdate = "update log_table set NumberOfViews=NumberOfViews+1 where UserID='".$_SESSION["UserID"]."' and Table='".$strTableName."'";

db_exec($strUpdate,$conn);

}

else

{

$strInsert = "insert into log_table (UserID, Table, NumberOfViews) values ('".$_SESSION["UserID"]."','".$strTableName."',1)";

db_exec($strInsert,$conn);

}

Thank you Jane. How do I track advanced searches?

Hi,

use View page: Before process, List page: Before processevents on the Events tab to save all changes in your log table.

Here is a sample for the view page:

Hi,
use List page: Before process event.

Here is just a sample:

if (@$_REQUEST["a"]=="advsearch")

{

//your code here

//all search parameters are in the $_REQUEST array

print_r($_REQUEST); //print all search parameters

}