Loading...
 
Features / Usability

Features / Usability


Tiki Comments HASH data

posts: 28 United States

The Tiki SQL Database Table tiki_comments has hash data (I suspect is an MD5 hash). That hash data is used in establishing a unique message_id for each comment message.

I've been unable to determine if that comment hash data is used anywhere else, and that is my first question: Is the hash data that is stored in the tiki_comments table used for anything other than in the comments_id table?
(See attachment)

If it is used somewhere else, then: Does that 'hash data' then need to be hex compliant? (The message_id is alpha-numeric, so it's not limited to just the hex '0-f' range of the hash output. ).

BONUS (curiosity) QUESTION: What record data elements are being concatenated and hashed to generate that 'unique' hash code?

--
'Why do I ask?', you ask? I'm going to be stuffing forum messages from another forum system (non-tiki) into the tiki forum, and I want to be sure that whatever data in the hash record (if any) that I associate with the message for importing is sufficiently unique and compatible if it is indeed being referred to elsewhere in the tiki CMS system.


If that data is not used anywhere else (and is merely a repository for the hashing output process to subsequently be used to generate the message_id (only), then I need not worry about it's hex-compliance, and may not even need to populate that column.

posts: 28 United States

{QUOTE(thread_id=>73529)
Is the hash data that is stored in the tiki_comments table used for anything other than in the comments_id table?
{QUOTE}

That should read:

" Is the hash data that is stored in the tiki_comments table used for anything other than in the tiki_comments table for message_id? ''


Upcoming Events

1)  18 Apr 2024 14:00 GMT-0000
Tiki Roundtable Meeting
2)  16 May 2024 14:00 GMT-0000
Tiki Roundtable Meeting
3)  20 Jun 2024 14:00 GMT-0000
Tiki Roundtable Meeting
4)  18 Jul 2024 14:00 GMT-0000
Tiki Roundtable Meeting
5)  15 Aug 2024 14:00 GMT-0000
Tiki Roundtable Meeting
6)  19 Sep 2024 14:00 GMT-0000
Tiki Roundtable Meeting
7) 
Tiki birthday
8)  17 Oct 2024 14:00 GMT-0000
Tiki Roundtable Meeting
9)  21 Nov 2024 14:00 GMT-0000
Tiki Roundtable Meeting
10)  19 Dec 2024 14:00 GMT-0000
Tiki Roundtable Meeting