Support Request SupportSmilies Categories

Support Section
Previous topicNext topic
User avatar

Topic Author
Midway
Translators
Translators
    Windows 7 Firefox
Magic user status: Offline
Posts: 111
Joined: Dec 8th, '14, 09:27

Smilies Categories

Post by Midway »

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?
User avatar

Sniper_E
VIP
VIP
    Windows 10 Firefox
Magic user status: Offline
Posts: 1018
Joined: Oct 14th, '14, 17:01

Re: Smilies Categories

Post by Sniper_E »

Yes
Image
No is NEVER an Option and NEVER is the only Option when it comes to Giving Up!™
User avatar

Topic Author
Midway
Translators
Translators
    Windows 7 Firefox
Magic user status: Offline
Posts: 111
Joined: Dec 8th, '14, 09:27

Re: Smilies Categories

Post by Midway »

And how ?
User avatar

Sniper_E
VIP
VIP
    Windows 10 Firefox
Magic user status: Offline
Posts: 1018
Joined: Oct 14th, '14, 17:01

Re: Smilies Categories

Post by Sniper_E »

I don't know. -- NEED MORE INFORMATION --

First we would need to know what smilies category extension you are using. :whistl:
User avatar

Topic Author
Midway
Translators
Translators
    Windows 7 Firefox
Magic user status: Offline
Posts: 111
Joined: Dec 8th, '14, 09:27

Re: Smilies Categories

Post by Midway »

Yes no problem I send you the extension by PM
User avatar

Sniper_E
VIP
VIP
    Windows 10 Firefox
Magic user status: Offline
Posts: 1018
Joined: Oct 14th, '14, 17:01

Re: Smilies Categories

Post by Sniper_E »

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
Previous topicNext topic