Replace apostrophes with accents in neo-Latin languages FLARUM sites

nova4x

WARNING !!!

HERE I PRESENT A SOLUTION I ADOPTED IN MY FLARUM PRODUCTION SITE, BUT YOU MUST KNOW WHAT YOU DO AND AT YOUR OWN RISK !!!

I'm an Italian forex professional trader and I PROUDLY master my JOB PRODUCTION SITE powered by FLARUM

Feel free to see and test it (please use FLARUM tag) at

http://nova4x.com
https://nova4x.eu

I already presented this little tip but in the wrong way

Now I'd like to fix my mistake

Indeed this solution may seem insignificant for native English speakers, but for the neo-Latin like us Italians, the French, the Spaniards and so on, accented characters are a headache

In neo-Latin we use a lot the accented characters, but now all PC have the international QWERTY keyboard

This means that there aren't accented capitals and small accented characters are very uncomfortable to reach, so we use the apostrophe

But this shortcut is both grammatically incorrect and ugly to see in the published posts

Beside in browsers with spell checkers, the site pages are full of words underlined in red as errors

You can solve the problem with 3 simple passages

1) Copy and past in a simple text editor the following code, save it as accented.sql (the name doesn't matter, but the extension MUST BE .sql)

UPDATE flarum_posts SET content = REPLACE(content,"a'","à");
UPDATE flarum_posts SET content = REPLACE(content,"A'","À");
UPDATE flarum_posts SET content = REPLACE(content,"e'","è");
UPDATE flarum_posts SET content = REPLACE(content,"E'","È");
UPDATE flarum_posts SET content = REPLACE(content,"i'","ì");
UPDATE flarum_posts SET content = REPLACE(content,"I'","Ì");
UPDATE flarum_posts SET content = REPLACE(content,"o'","ò");
UPDATE flarum_posts SET content = REPLACE(content,"O'","Ò");
UPDATE flarum_posts SET content = REPLACE(content,"pò","po'");
UPDATE flarum_posts SET content = REPLACE(content,"Pò","Po'");
UPDATE flarum_posts SET content = REPLACE(content,"u'","ù");
UPDATE flarum_posts SET content = REPLACE(content,"U'","Ù");

2) Always make a backup copy of your FLARUM database

3) Every couple of days open phpMyAdmin, IMPORT the file and GO, as in the following picture

...that's all!

jordanjay29

I'm a little uncomfortable with you linking off-site (and technically it violates our advertising guidelines) to this script and would prefer if you hosted the code here. And as discussed in your last thread on the subject, this is an advanced subject not suitable for most newbies. As such, I'd also like you to add an easily noticeable disclaimer warning people to use at their own risk.

nova4x

I agree and there is no problem, only how can I upload the script in this site?

For the warning, should I put it myself?

jordanjay29

nova4x Just include it in code tags as you did last time. And yes, you can include the warning yourself in the post.

nova4x

All done!

Excuse my mistakes, I'm only an enthusiast webmaster, and I made an enormous jump for all my followers migrating my PRODUCTION SITE in FLARUM

nova4x

I improved the solution with a php script so you have simply to call its URL also without touching or knowing phpMyAdmin or SQL

Copy the code in whatever file you want (only the extension MUST BE .php) then upload it in your site directory struct

i.e.: https://mysite/assets/mydirname/myscript.php

Then I call this url in my browser every couple of hours and it's matter of seconds

<?php
    $con = mysqli_connect('localhost', 'your_sql_user', 'your_sql_password');

if (!$con) {
    die('Could not connect: ' . mysqli_error());
}

echo 'Server connected successfully<br/>';

mysqli_select_db($con, 'your_db_name') 
    or die('Could not select database.');

mysqli_set_charset($con,"utf8");

echo 'Database connected successfully<br/>';

$sqls = array(
    "UPDATE flarum_posts SET content = REPLACE(content,'a''', 'à')",
    "UPDATE flarum_posts SET content = REPLACE(content,'A''', 'À')",
    "UPDATE flarum_posts SET content = REPLACE(content,'e''', 'è')",
    "UPDATE flarum_posts SET content = REPLACE(content,'E''', 'È')",
    "UPDATE flarum_posts SET content = REPLACE(content,'i''', 'ì')",
    "UPDATE flarum_posts SET content = REPLACE(content,'I''', 'Ì')",
    "UPDATE flarum_posts SET content = REPLACE(content,'o''', 'ò')",
    "UPDATE flarum_posts SET content = REPLACE(content,'O''', 'Ò')",
    "UPDATE flarum_posts SET content = REPLACE(content,'pò', 'po''')",
    "UPDATE flarum_posts SET content = REPLACE(content,'Pò', 'Po''')",
    "UPDATE flarum_posts SET content = REPLACE(content,'u''', 'ù')",
    "UPDATE flarum_posts SET content = REPLACE(content,'U''', 'Ù')",

    "UPDATE flarum_posts SET content = REPLACE(content,'perche''', 'perché')",
    "UPDATE flarum_posts SET content = REPLACE(content,'perchè', 'perché')",
    "UPDATE flarum_posts SET content = REPLACE(content,'Perche''', 'perché')",
    "UPDATE flarum_posts SET content = REPLACE(content,'Perchè', 'Perché')",
    "UPDATE flarum_posts SET content = REPLACE(content,'PERCHE''', 'PERCHÉ')",
    "UPDATE flarum_posts SET content = REPLACE(content,'PERCHÈ', 'PERCHÉ')"
);

foreach ($sqls as $sql)
{
    echo $sql . '<br/>';

    $result = mysqli_query($con, $sql);

    if (!$result) {
        die('Invalid query: ' . mysqli_error($con));
    }
}

/*
$sqlSource = file_get_contents('db-accents.sql');
mysqli_multi_query($con, $sqlSource);    
*/

mysqli_close($con);

JoshyPHP

I would expect this script to perform very badly on MySQL, as it will cause the entire table to be scanned (and possibly rewritten) like 20 times in a row. While it's doing that, all writes will be suspended. Depending on the storage engine, all reads may be suspended as well.

You can almost certainly create an extension that will modify the messages as they are posted, in real time, possibly using the PostWillBeSaved event.

Kyrne

JoshyPHP seems like an extensions that could be very easy to make.

JoshyPHP

Yes, but with some reserves. As I recall, PostWillBeSaved happens after the post has been parsed, which means you'd be modifying XML, where arbitrary string replacements are a liability. Perhaps it should be implemented in JavaScript instead, to perform the replacements in real time in the editor.

nova4x

Thanks for the good suggestions

I'm a professional forex trader and I migrated my previous phpbb job site to a FLARUM PRODUCTION SITE

I'm highly customizing it and It's a good relaxing activity after my trading and I appreciate all the helps

I'm more and more satisfied of FLARUM beside it's very attractive for all my followers

Fell free to see or test it (please use FLARUM TAG)

http://nova4x.com
https://nova4x.eu

In particular I'm very happy of my javascript + css trick that allows the image modal popup on click as I saw in wordpress

As you can image, simply pass the mouse over one of the images in the discussions then click it

You can find the code that I adapted from an example in another discussion here in the community forum

That's the link to the last (amateur) update of my solution and I think that could be really a good extension... and I'll appreciate every help!

https://discuss.flarum.org/d/5146-modal-image-popup-on-click-only-for-advaced-webmasters/15