Loading...
 
Features / Usability

Features / Usability


database question in regards to integrating Cometchat

posts: 28

The Minichat, unfortunately doesn't have very many features we would like. I'm also not convinced of security between channels. We need group control over those channels. As a result we want to integrate cometchat into our site. But I have a bit of a snag. Perhaps I just missed it when searching the database on my 14.2 installation.
Cometchat requires integration with the database, as such one requirement is to find the table that associate the "user id" to the "user name". It seems based on the names of the fields that there are levels of separation in this link that are spread across multiple tables.
Also there is a lesser requirement to find the user avatar in the database, but I'm uncertain to the location in the database if any.

Any help would be greatly appreciated.

posts: 3665 United States

You'll need to look at the following columns in the users_users table:

  • userId = user ID
  • login = user name (unless you have the "use email as login" option enabled, then you'll need the email column
  • avatarData = user avatar (as BLOB).


HTH,

- Rick | My Tiki Blog | My Tiki UserPage

Why be a dummy? Get smarty! TikiForSmarties.com
Tiki for Smarties, your source for the best (and only) Tiki books, guides, and tutorials.
posts: 28
The "Users_users" table doesn't seem to exist in my database. I do find it in the sql for the schema of 14.2 but perusing with phpmyadmin the table or any variation thereof doesn't exist.

posts: 28

NVM, I found it. my host for some reason had it hidden using their version of phpmyadmin.
Thank you very much


posts: 1 India

Hello dracozny,

If you do not have any users table in your database, please create a dummy users table with userid and username columns. This will allow you to install CometChat if you haven't installed it already. After successful installation you can enable the guest mode from the CometChat Administration Panel.
Please contact CometChat support team if any questions.

Regards,
Robert


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