X-Cart forums

[esoftrade]

I wanted to keep track of the egoods downloads of my site.
I added the great idea from minorgod to add the downloads counter.
But I wanted more so that I can know when and from where an e-good had been downloaded.

There are only 4 simple modifications to do.

Those modifications works for xcart version 4.4.3 but may works also for newer release, it is just a matter of testing

1. Create a new table in DB in your DB console

CREATE TABLE `xcart_download_keys_downloads` (
  `download_key` char(100) NOT NULL default '',
  `id_download` tinyint(4) NOT NULL default '0',
  `date` int(11) NOT NULL default '0',
  `ip` int(11) unsigned NOT NULL default '0',
  PRIMARY KEY  (`download_key`,`id_download`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

2. Add the new table in init.php

Add the following statement in the sql_tbl array (preferably right after the download_keys statement:

PHP Code:

'download_keys'                     => 'xcart_download_keys',
         'download_keys_downloads'           => 'xcart_download_keys_downloads', 


3. Add the new table in the delete statements (keep your DB clean)

In the func_delete_product() function: in the if ($delete_all === true) section, add the complete clean of the table:

PHP Code:

db_query("DELETE FROM $sql_tbl[download_keys]");
db_query("DELETE FROM $sql_tbl[download_keys_downloads]"); 


Still in the func_delete_product() function, add a statement to delete content of the table for a given product id (when a product is removed) - you can skip this if you prefer to keep an history of all downloads, even for deleted products:

PHP Code:

db_query("DELETE FROM $sql_tbl[download_keys_downloads] WHERE download_key=(SELECT download_key FROM $sql_tbl[download_keys] WHERE productid='$productid')");
    db_query("DELETE FROM $sql_tbl[download_keys] WHERE productid='$productid'"); 


Note that this statement must be done before the delete from download_keys. Otherwise, you will not delete anything since the entries will have been deleted!


4. Update the table whenever an e-good is downloaded

In download.php, locate the following statement (line 165 for me):

PHP Code:

if (empty($id)) 
exit(); 


If you added minorgod functionality, you should have it just below.
We will add new code below again (note that minorgod functionality is not required, but it is a good to get idea).

This is to retrieve and increment the id.

PHP Code:

if (empty($id))
    exit();

$res = func_query_first("SELECT productid, expires, number_downloads FROM $sql_tbl[download_keys] WHERE download_key = '$id'");
$number_downloads=$res['number_downloads']+1;

$resDownloadTime = func_query_first("SELECT MAX(id_download) AS max_id FROM $sql_tbl[download_keys_downloads] WHERE download_key = '$id'");
if (empty($resDownloadTime)){
    $id_download=0;
} else {
    $id_download=$resDownloadTime['max_id']+1;
} 


Next, update the DB once the e-good has been downloaded:

PHP Code:

if ($fd) {

            while (
                !feof($fd)
                && connection_status() == 0
            ) {

                print(fread($fd, 8192));

                flush();

            }

            fclose($fd);

            // Update the nb of times the egood has been downloaded
            $query="UPDATE $sql_tbl[download_keys] SET number_downloads='$number_downloads' WHERE download_key='$id'";
            db_query($query);
            
            // Update the key download information with date and ip
            $query="INSERT INTO $sql_tbl[download_keys_downloads] (download_key, id_download, date_download, ip) VALUES ('$id', '$id_download', '".XC_TIME."', INET_ATON('$CLIENT_IP'))";
            db_query($query);
        } else {

            print($data);

            flush();

        } 


That's it! Let me know if this works for you or if you find any enhancement or bug.

Thanks
Fred