Featured New Release
Box cover for Chloe Cherry Is Euphoric
Chloe Cherry Is Euphoric
Studio: Team Skeet
Release date: 7/28/2026


all new releases
All Forums > Tech Talk > Tech Talk Forum Page 8 > No semi-colons in our ADT posts?
AuthorPost
killbillvol69 All-Star Supporter
All-Star Member


^Lucy Pinder
18631 Posts
4/08
Posted - Jul 22 2016 : 1:13AM
Hi this was posted in another thread but probably needs to be here. Drew, can you look into this? (It's happening for me as well.)
Jacco All-Star Supporter
All-Star Member

"liable to deprave and corrupt"
2673 Posts
5/04
Posted - Jul 22 2016 : 5:48AM
I assume Drew blocked it to stop some attackers trying to get it. The semi-colon is used to terminate database queries.
Jacco
Joey Starr
Senior Member

Still wanking after all these years.
8082 Posts
10/00
Posted - Jul 22 2016 : 5:49AM
Same here.
Also when I edit some of my posts, the edit works but I don't get "edited by Joey Starr...".
This is weird as it doesn't happen in all of my edited posts, sometimes the "edited by... " line shows up, sometimes it's just not there.
Joey Starr
Senior Member

Still wanking after all these years.
8082 Posts
10/00
Posted - Jul 22 2016 : 5:50AM
Actually the edit jsut doesn't work on some posts but works on other. I tried to edit the post above with no success.
Joey Starr
Senior Member

Still wanking after all these years.
8082 Posts
10/00
Posted - Jul 22 2016 : 5:51AM
But it's a porn site here! Doesn't semi-colon mean partial anal sex?
 
Drew Black
broken crankshaft

8009 Posts
9/99
Posted - Jul 22 2016 : 6:09AM
I will look at it later today. I changed some forum code recently to strip out non us-ascii characters. Someone recently started using unicode characters for a XSS attack here.
Goldstein All-Star Supporter
All-Star Member

"You have sacrificed nothing and no one."
3689 Posts
8/10
Posted - Jul 22 2016 : 6:53AM
Actually, what I've been encountering is having semi-colons inserted, not deleted, when characters the forum is not currently handling are entered.
For example, so called "smart quotes" are not being handled and a semi-colon is being inserted in its place instead.
So, when I've been copying and posting text, say from The New York Times, I've had to resort to going through the text, deleting "smart quotes" etc., and re-typing these characters in the forum(s) message window, so that these characters will render properly.
murdock
Member

I'm not an actor, but I play one on TV
911 Posts
4/06
Posted - Jul 22 2016 : 9:05AM
Indeed.
https://xkcd.com/327/
Drew Black
broken crankshaft

8009 Posts
9/99
Posted - Jul 23 2016 : 4:51PM
For the semi-colonic sensitive: I think I have fixed it and maybe handled the special quotes too
Drew Black
broken crankshaft

8009 Posts
9/99
Posted - Jul 23 2016 : 4:51PM
nope :(
edited to add: C: [enter] ###
; ; ; ;;;;;;
weee?
Edited by - Drew Black on 7/23/2016 5:08:18 PM
murdock
Member

I'm not an actor, but I play one on TV
911 Posts
4/06
Posted - Jul 23 2016 : 8:30PM
It works. I can post a semi-colon just fine.
colon_truck.jpg
;
Goldstein All-Star Supporter
All-Star Member

"You have sacrificed nothing and no one."
3689 Posts
8/10
Posted - Jul 24 2016 : 11:23AM
In a post Sunday AM, I found that:
(1) smart quotes were dropped altogether (although the forum has stopped inserting semi-colons for smart quote characters)
(2) ";en dash"; was dropped altogether (no substitutes inserted, just dropped)
I will type an ";en dash"; example here:
First, using two dashes -- instead of an ";en dash"; -- as a baseline.
Now, using an ";en dash"; where the two dashes were used as a comparison.
And now, using an ";em dash"; which is a slightly wider dash than an ";en dash"; to how this symbol renders.
After typing the comparison ";Bakhtiar"; sentences below, it would seem that The New York Times is using the wider ";em dash"; (not the ";en dash"; I originally suspected).
---------------------------------------------------------------------------------------------------------------------------------------------
Here is a sentence with the original formatting:
Once they got my H.R. statement, I was finished, finished 10 years in the business, Ms. Bakhtiar said.
And, here is the exact same sentence with my making character corrections by hand (so we can see what characters are affected):
";Once they got my H.R. statement, I was finished, finished -- 10 years in the business,"; Ms. Bakhtiar said.
#######################################################################
^^^ OK, as we can see, editing a post totally fucks-up the characters! ^^^
Here is the original post above -- copied before editing this post -- and pasted here:
In a post Sunday AM, I found that:
(1) smart quotes were dropped altogether (although the forum has stopped inserting semi-colons for smart quote characters)
(2) "en dash" was dropped altogether (no substitutes inserted, just dropped)
I will type an "en dash" example here:
First, using two dashes -- instead of an "en dash" -- as a baseline.
Now, using an "en dash" where the two dashes were used as a comparison.
And now, using an "em dash" which is a slightly wider dash than an "en dash" to how this symbol renders.
After typing the comparison "Bakhtiar" sentences below, it would seem that The New York Times is using the wider "em dash" (not the "en dash" I originally suspected).
---------------------------------------------------------------------------------------------------------------------------------------------
Here is a sentence with the original formatting:
Once they got my H.R. statement, I was finished, finished 10 years in the business, Ms. Bakhtiar said.
And, here is the exact same sentence with my making character corrections by hand (so we can see what characters are affected):
"Once they got my H.R. statement, I was finished, finished -- 10 years in the business," Ms. Bakhtiar said.
#######################################################################
Here is a screencap of my original post here -- before editing the post fucks it up -- just in case:
ADT_TextIssues.PNG
Obviously, I will now be unable to edit this post further, as everything I've typed here will become gobbledygook
Edited by - Goldstein on 7/24/2016 11:47:21 AM
Goldstein All-Star Supporter
All-Star Member

"You have sacrificed nothing and no one."
3689 Posts
8/10
Posted - Jul 24 2016 : 11:53AM
^ IMPORTANT: Since you can't see above what characters get dropped, because they're no longer there:
As of Sunday, 7/24/16 at 11:51 EDT
(1) ALL "smart quote" characters disappear
(2) ALL "en dash" disappear
(3) ALL "em dash" disappear
(4) Semi-colons get inserted for many of these characters when the above post was edited
Goldstein All-Star Supporter
All-Star Member

"You have sacrificed nothing and no one."
3689 Posts
8/10
Posted - Jul 24 2016 : 12:56PM
FYI, I'm now noticing that when people are quoting other posts in a reply, that the characters are getting f'd up and semi-colons inserted.
Notice the semi-colons added here (which I noticed as I was being quoted).
killbillvol69 All-Star Supporter
All-Star Member

^Lucy Pinder
18631 Posts
4/08
Posted - Jul 24 2016 : 6:26PM
Wonder if the plus sign is causing trouble too.
I saw someone type "#1" where usually people would type "+1"
It could have been just a typo though.
 
killbillvol69 All-Star Supporter
All-Star Member

^Lucy Pinder
18631 Posts
4/08
Posted - Jul 24 2016 : 8:16PM
Just now I tried to quote something with a semi-colon, and it gave me this: &;semi;
Drew Black
broken crankshaft

8009 Posts
9/99
Posted - Jul 24 2016 : 9:20PM
I obviously have a little more work to do on this. Actually, a lot more. I need to change the way posts are stored in the database.
And my goal in this is to strip/replace any non US-ASCII characters or strip them to nothing. Unicode and alternate character sets aren't supported. The only reason they were ever supported is because a chunk of code that's about 12 years old never as is should.
lex von v
Senior Member

2511 Posts
12/12
Posted - Jul 28 2016 : 9:41AM
About Unicode: I asked for that about a year ago (w/ negative outcome), but as of late I was able to enter the typographically correct quotes and apostrophes instead of the typewriter ones, and everything worked as desired.
@Goldstein: What you call smart quotes are the typographically correct quotes. Some algorithm called smart quotes used by some program converts the typographical quotes (") into the (66, 99)-quotes as needed. So entering a " after a space yields the '66'-quotes, while a " after a character (or a ' after a character) yields the '99'-looking quote (or the '9'-looking character). This means
Typewriter Quotes => Transform through Smart quote => Typographical Quotes (66 - 99)
When you paste an article from the NYT, you are already pasting the typographical quotes, because there's no character for a Smart Quote.
Just out of curiosity: How can unicode characters be used for some database shenanigans or XSS?
About the anti-injection stuff (probably the reason for the semicolon handling at the first place): wouldn't something like mysql_real_escape_string suffice, basically escaping quotes and backslashes the correct way before entering them into the DB?
Goldstein All-Star Supporter
All-Star Member

"You have sacrificed nothing and no one."
3689 Posts
8/10
Posted - Jul 28 2016 : 12:47PM
^ I'm not disputing any of the technical explanation(s) you offer.
I use the term Smart Quotes, to casually refer to the whole group of characters commonly referred to as "smart quotes."
Seemingly, this even includes apostrophes
killbillvol69 All-Star Supporter
All-Star Member

^Lucy Pinder
18631 Posts
4/08
Posted - Jul 28 2016 : 2:32PM
This stuff is actually quite problematic if a post is edited and then quoted.
Here's a post that was edited and then quoted twice:
semi-colon problem.JPG
I mean it's not even readable.
This one screwed with every semi-colon as well as every ampersand.
Drew Black
broken crankshaft

8009 Posts
9/99
Posted - Jul 28 2016 : 3:42PM
I'm going to work on unwinding my fuckups right now.
Drew Black
broken crankshaft

8009 Posts
9/99
Posted - Jul 28 2016 : 3:45PM
temporary fix in place now.
All Forums > Tech Talk > Tech Talk Forum Page 8No semi-colons in our ADT posts?

Previous topic: What Happens to Posts?
Next topic: Wireless back-up ?



Jump To: