With any luck, it'll be in PHPBB v3.2.0 but I doubt it will be any sooner. From looking at the github activity, they're working hard on it, but as mentioned in this thread, proper integration requires more internal changes than what an extension can handle in 3.1.x.R00f wrote:any News?
BTW, 2 useful info...cYbercOsmOnauT wrote:Maybe I have to ask my magic marble about your repo url... because you didn't type it into your post. And if its that much complete why didn't you give a hand to nassim? Helping others is not your job but mine?
Anyways.. thanks.. I will take a look at it and see if or not it's helpful.brunoais wrote:Look at my code in my repo.
I don't own phpBB :S. It's just that if I pointed to the phpBB branch where I'm working, you won't get just the code I made but also all the phpBB's code.cYbercOsmOnauT wrote:Oh I didn't know that the holy phpBB repository is yours.
OK. good luck.cYbercOsmOnauT wrote: Anyways.. thanks.. I will take a look at it and see if or not it's helpful.
Code: Select all
$sql = 'SELECT smiley_url, MIN(emotion) as emotion, MIN(code) AS code, smiley_width, smiley_height, MIN(smiley_order) AS min_smiley_order FROM ' . SMILIES_TABLE . ' GROUP BY smiley_url, smiley_width, smiley_height ORDER BY min_smiley_order';
For example in code we have :D, :-D and as smiliecodes for Very Happy. They all start with : but - comes before D and g in the ASCII table. Your SQL gets :-D as MIN(code). Why not :D?MySQL Documentation wrote:Returns the minimum value of expr. MIN() may take a string argument; in such cases, it returns the minimum string value.