Gossamer Forum
Home : Products : Gossamer Links : Discussions :

Insert Value to ClickTrack Table

Quote Reply
Insert Value to ClickTrack Table
Hi-

I have been trying to figure out a way to modify Jump.pm so that it adds a few new items to the ClickTrack table. I have added the columns: LinkOwner and the Full_Category_Name to the ClickTrack table, and would like to include this information from the Link that is being clicked. I have been trying things with the code from Jump.pm, with no luck:

-------------------------

my $click_db = $DB->table ('ClickTrack');

my $rows = $click_db->count ( { LinkID => $id, IP => $ip, ClickType => 'Hits'} );

if (! $rows) {

$db->update ( { Hits => \"Hits + 1"}, { ID => $id }, { GT_SQL_SKIP_INDEX => 1 } );

$click_db->insert ( { LinkID => $id, IP => $ip, ClickType => 'Hits', Created => \"NOW()"} );

-------------------------------

Does anyone know how this could be modified to add the LinkOwner and Full Category Name ( in addition to the IP, Creation Date, etc.) for the link being clicked on?

Any help would be much appreciated Smile

-FrankM
Subject Author Views Date
Thread Insert Value to ClickTrack Table FrankM 2272 Aug 7, 2002, 7:56 AM
Thread Re: [FrankM] Insert Value to ClickTrack Table
Andy 2228 Aug 7, 2002, 8:01 AM
Thread Re: [Andy] Insert Value to ClickTrack Table
FrankM 2218 Aug 7, 2002, 8:03 AM
Thread Re: [FrankM] Insert Value to ClickTrack Table
Andy 2213 Aug 7, 2002, 8:06 AM
Thread Re: [Andy] Insert Value to ClickTrack Table
FrankM 2207 Aug 7, 2002, 8:15 AM
Thread Re: [FrankM] Insert Value to ClickTrack Table
Andy 2199 Aug 7, 2002, 8:33 AM
Thread Re: [Andy] Insert Value to ClickTrack Table
FrankM 2183 Aug 7, 2002, 2:22 PM
Post Re: [FrankM] Insert Value to ClickTrack Table
mrcry11 2125 Mar 1, 2003, 3:19 PM