Your phpBB Version: 3.3.0
Your phpBB Type: Standard phpBB
Extensions installed: No
Your knowledge: Basic Knowledge
What have you done before the problem was there?
What have you already tried to solve the problem?
Description and Message
I have an extension Smilies Categories and I would like to know if it is possible to adapt it with mchat?
Support Request Support ⇒ Smilies Categories
-
- Translators
- Status: Offline
- User theme: Dark
- Posts: 115
- Joined: Dec 8th, '14, 09:27
-
- VIP
- Status: Online
- User theme: Dark
- Posts: 1127
- Joined: Oct 14th, '14, 17:01
-
- Translators
- Status: Offline
- User theme: Dark
- Posts: 115
- Joined: Dec 8th, '14, 09:27
Re: Smilies Categories
And how ?
-
- VIP
- Status: Online
- User theme: Dark
- Posts: 1127
- Joined: Oct 14th, '14, 17:01
Re: Smilies Categories
I don't know. -- NEED MORE INFORMATION --
First we would need to know what smilies category extension you are using.
First we would need to know what smilies category extension you are using.

-
- Translators
- Status: Offline
- User theme: Dark
- Posts: 115
- Joined: Dec 8th, '14, 09:27
Re: Smilies Categories
Yes no problem I send you the extension by PM
-
- VIP
- Status: Online
- User theme: Dark
- Posts: 1127
- Joined: Oct 14th, '14, 17:01
Re: Smilies Categories
Got it thanks. Installed. I get an error when I click View more smilies so I will have to look at it later.
Code: Select all
SQL ERROR [ mysqli ]
You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'GROUP BY emotion ORDER BY smiley_order ASC LIMIT 50' at line 1 [1064]
SQL
SELECT s.*, c.* FROM (phpbb_smilies s) LEFT JOIN phpbb_smilies_category c ON (c.cat_id = s.category AND c.cat_lang = 'en') WHERE category = GROUP BY emotion ORDER BY smiley_order ASC LIMIT 50