Emoji Support

  • I think Woltlab's current smilies are cute, but I would like to expand on them and more importantly, have a set of smilies that were designed with high resolution in mind.


    4k video is now standard on YouTube and Apple Retina display has become the norm on almost all Apple devices; it is a telling sign of the times that you really do want something that can stand up against high resolution.


    As luck would have it there are currently 2 open source developments regarding emoji's :)

    I've spent the last few hours trying to find the "magic code" that would make all the svg's resize properly in WBB, but sadly they all end up larger than life



    Click here for an example
    https://twemoji.maxcdn.com/svg/2764.svg


    I propose that Woltlab adds native support for standard Emoji's. :)

  • I propose that Woltlab adds native support for standard Emoji's.

    Starting with MySQL 5.5.3 the new charset utf8mb4 is added which properly support 4-Byte UTF-8 characters like Emojis. We currently require MySQl 5.1, hence we cannot support them at this time.


    As soon as MySQL 5.5 is commonly available we'll most likely make the switch and in return properly support Emojis.

  • Starting with MySQL 5.5.3 the new charset utf8mb4 is added which properly support 4-Byte UTF-8 characters like Emojis. We currently require MySQl 5.1, hence we cannot support them at this time.
    As soon as MySQL 5.5 is commonly available we'll most likely make the switch and in return properly support Emojis.

    MySQL 5.1 reached End of Life as of December 31, 2013


    http://www.mysql.com/support/eol-notice.html


    Technically, Oracle calls it "Sustaining Support"


    Oracle's Lifetime Support Policy has three options.

    • MySQL Premier Support - 5 years, starting at GA, of Premier Support that includes MySQL maintenance releases, updates, fixes (error correction), and security alerts.
    • MySQL Extended Support - 3 years of extra support including error correction, beyond the Premier Support period, for specific MySQL releases. Includes MySQL maintenance releases, updates, bug fixes (error correction), and security alerts.
    • MySQL Sustaining Support - Any time, beyond the Premier Support period. Support only. No new releases, no new fixes (no error correction for new issues), no new updates. Only pre-existing updates, fixes and alerts are available.

    In other words, end of life.

    • No update
    • No patches
    • No fixes
    • No bug resolves

    Even WikiPedia acknowledges it as "end of life"
    http://en.wikipedia.org/wiki/MySQL


    Webhostingtalk.com which is one of the largest hosting forums notes that anyone still using 5.1 is likely having security issues as a few exploits where discovered.


    I think it is safe for you to raise your standard ;)

  • As soon as MySQL 5.5 is commonly available we'll most likely make the switch and in return properly support Emojis.

    Suggest you raise your standard to MySQL 5.6 which is the current release. Further polling Webhostingtalk.com shows that most major web hosting providers who were on 5.1 upgraded to 5.6 which is the current release.


    cPanel and Direct Admin the two most known control panels (common within shared hosting) also offer MySQL 5.6 as standard. ;)



    edit:


    Side note: 5.7 while not stable is on a milestone release.

  • @Aslan EOL wont help if some webspace providers still use this version. I know one that uses PHP 5.2 as there main version of PHP. PHP 5.2+ is only available through php-cgi.

  • @Aslan EOL wont help if some webspace providers still use this version. I know one that uses PHP 5.2 as there main version of PHP. PHP 5.2+ is only available through php-cgi.

    Your argument is flawed in the most hosting providers (the majority) do not still have PHP 5.2.


    Yes, there will always be a few who will live in the stone age, but development should not target to cater the few stragglers, but rather the bulk sum.


    The bulk sum have moved on.

    • XenForo
    • Ip.Board
    • vBulletin

    No longer support 5.1

  • I just did not finish it, yet.

    I like your work. I actually respect the code that you code. But that seems to be a recurring theme.

    Last year, i just started developing an Emoji plugin.

    Would be very happy to see it (may even pay for it). :)


    As luck would have it there are currently 2 open source developments regarding emoji's :)

    I think the 1st one would work better regarding copyright

  • If I read through their code for there requirements test tool, it recommends MySQL 5.6+, but you can use MySQL 5.0.3+

    Woltlab should always strive to be better and look to the future.


    If you're using 5.0.x you're asking to be hacked. A quick Google search pulls up a few exploits

  • @Aslan Woltlab uses the 'lowest common denominator'-principle for software requirements as a lot of other companies do.

    Actually, one of the things that sold me on Woltlab was they were using the average or highest common denominator. For example always keeping their editor current and using the latest 3rd party developments such as jquery.


    The lowest common denominator is quickly becoming a dead end. If you're not looking to the future, you're already obsolete.

  • @Aslan There is a huge difference between components we actually have an influence on (3rd party libraries such as jQuery) and environments we cannot influence such as webspaces.

  • Would love to see that in color images


    That's something i already considered ;) However, the current implementation is easier when using font glyphs. But whenever i continue the development (the screens are 9 months old), i will try to use images instead :)