3D Text & SQL Lite, trouble displaying specific characters?
#1

I have this enterance system, and I am having problem that when I save enterance with characters as . (dot) or ' the 3d text won't show up. If I save without those, It will. When using /enter or /exit it still shows: You've entered (Enterance Name). <- That contains ' . ( so it's working properly)

I am running out of ideas what's wrong with this.
Code that's being used:

No errors or what so ever.
But the 3d text is not showing while using characters: . '

When I load:
St. John's Church from database, The 3D Text Label is not showing up.
When I load:
St Johns Church, It is working then.

NVM. It started working now!
Reply
#2

You need to escape the characters and always use DB_Escape when inserting strings into a Query to prevent from being victim of SQL Injection.

If you also take a look at that function, you'll see that it uses: \'
instead of a simple character: '
Reply


Forum Jump:


Users browsing this thread: 1 Guest(s)