MyBB Community Forums

Full Version: Mybb is writing quotes on mybb_posts table with two formats ¿?
You're currently viewing a stripped down version of our content. View the full version with proper formatting.
Hi, I was doing some troubleshooting today and I noticed this:

[Image: HSRKln7.png]

So it's writing eiter [quote="iagovar" or [quote='iagovar' for no particular reason, as far I can see.

This may be causing Tapatalk have issues with quotes (IDK, just guessing).

This is an output of Excel, but it is the same with KNIME or HeidiSQL reading the DB.

Is there any explanation for this? It's causing me problems, I need to setup a regex extractor for measuring who's quoting who, but because of not having the same patter, it gets difficult.
iagovar or laer would be the name of who wrote the quoted post. pid stands for post id (the internal id of the quoted post).
(08-04-2017, 06:43 PM)laie_techie Wrote: [ -> ]iagovar or laer would be the name of who wrote the quoted post. pid stands for post id (the internal id of the quoted post).

I know that... but I fail to see how that answers my question to be honest...
By default MyBB is using double quotation marks, unless the username contains them. Then single quotes are used:
mybb/functions_posting.php at feature · mybb/mybb · GitHub

But the SCEditor uses single quotes for usernames by default
mybb/bbcodes_sceditor.js at feature · mybb/mybb · GitHub

So e.g. you're using quick reply with multiquote you get:
[quote="Username"

and if you quote a post in full editor (SCEditor) you get:
[quote='Username'
If you're using regexes to extract quotes, it's fairly easy to match either single or double quotes.