3D Text & SQL Lite, trouble displaying specific characters? - Printable Version

+- SA-MP Forums Archive (https://sampforum.blast.hk)
+-- Forum: SA-MP Scripting and Plugins (https://sampforum.blast.hk/forumdisplay.php?fid=8)
+--- Forum: Scripting Help (https://sampforum.blast.hk/forumdisplay.php?fid=12)
+--- Thread: 3D Text & SQL Lite, trouble displaying specific characters? (/showthread.php?tid=473514)

---

3D Text & SQL Lite, trouble displaying specific characters? - [WSF]ThA_Devil - 03.11.2013

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!

---

Re: 3D Text & SQL Lite, trouble displaying specific characters? - Konstantinos - 03.11.2013

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: '

---