Truxton url get when

This retrieves the date and time when the URL was visited. This corresponds to the [When] column of the [WebsiteVisit] table.

Syntax

uint64_t truxton_url_get_when( uint64_t url_handle );

Parameters

url_handle

This handle comes from calling truxton_url_create(), or truxton_file_create_url().

Return value

When the URL was visited in FILETIME ticks. If no timestamp is associated with the URL, zero will be returned.

Sample

void dump_url( uint64_t url_handle )
{
   uint64_t integer_value = 0;

   char temp_string[ 1024 ];

   truxton_url_get_id( url_handle, temp_string, sizeof(temp_string) );
   printf( "URL ID is %s\n", temp_string );

   truxton_url_get_media_id( url_handle, temp_string, sizeof(temp_string) );
   printf( "Media ID is %s\n", temp_string );

   truxton_url_get_file_id( url_handle, temp_string, sizeof(temp_string) );
   printf( "File ID is %s\n", temp_string );

   truxton_url_get_account( url_handle, temp_string, sizeof(temp_string) );
   printf( "Account is \"%s\"\n", temp_string );

   integer_value = truxton_url_get_account_offset( url_handle );

   if ( integer_value == 0xFFFFFFFFFFFFFFFF )
   {
      printf( "Account offset is not known\n" );
   }
   else
   {
      printf( "Account offset is %" PRIu64 "\n", integer_value );
   }

   integer_value = truxton_url_get_url_offset( url_handle );

   if ( integer_value == 0xFFFFFFFFFFFFFFFF )
   {
      printf( "URL offset is not known, probably came from a SQLite database\n" );
   }
   else
   {
      printf( "URL offset is %" PRIu64 "\n", integer_value );
   }

   integer_value = truxton_url_get_format( url_handle );
   printf( "Format is %" PRIu64 "\n", integer_value );

   integer_value = truxton_url_get_method( url_handle );
   printf( "Method is %" PRIu64 "\n", integer_value );

   integer_value = truxton_url_get_type( url_handle );
   printf( "Type is %" PRIu64 "\n", integer_value );

   integer_value = truxton_url_get_when( url_handle );
   printf( "When is %" PRIu64 "\n", integer_value );
}

The PRIu64 in the sample code above is a standard way of formatting a 64-bit unsigned integer in C. Over the years, different compilers on different operating systems used different format specifiers for things, these PRI macros, along with some tricky string concatenation the compilers perform for you, allow you to maintain a single code base without a bunch of macro magic.