[MySQL] Loading data from a row - issue
#1

Hello,

I have the following problem, for some reason the Spawn_X keeps coming out as 0.00000 (float) although it is set up properly in my Table.
The Spawn_Y and Spawn_Z is correct though, same with the ID.
The icons are wrongly placed ingame (X = 0.00000), it really is annoying and I have no clue what could be wrong.
Note: For the first row the X coord is correct, for the third+ rows they are wrong.

Table:


Script:
http://pastebin.com/m12367526

Outcome:
Код:
[17:44:40] [DEBUG] Pickup for 1 (Rent-a-Car) created. 2482.389892.2,1323.780029.2,10.820300.2
[17:44:40] [BIZ] (1) 'Rent-a-Car' loaded!
[17:44:40] [DEBUG] Pickup for 2 (Biz Test 2) created. 1.100000.2,2.200000.2,3.299999.2
[17:44:40] [BIZ] (2) 'Biz Test 2' loaded!
[17:44:40] [DEBUG] Pickup for 3 (Peters sick store!) created. 0.000000.2,0.000000.2,77.769996.2
[17:44:40] [BIZ] (3) 'Peters sick store!' loaded!
[17:44:40] [DEBUG] Pickup for 6 (~w~Random ~r~Store~w~.) created. 0.000000.2,1300.459960.2,10.820300.2
[17:44:40] [BIZ] (6) '~w~Random ~r~Store~w~.' loaded!
EDIT:
Alright, I tried converting all those to strings, that seems to work correctly since mysql doesnt support that float ranges.
But -> floatstr(); doesnt seem to have any effect, it just returns 0 and still is a string. What could I do?
Reply
#2

sscanf has a little bug for case 'f', so you need to replace that part of code with this: http://forum.sa-mp.com/index.php?top...8481#msg678481
Reply
#3

Quote:
Originally Posted by $ЂЯĢ
sscanf has a little bug for case 'f', so you need to replace that part of code with this: http://forum.sa-mp.com/index.php?top...8481#msg678481
Thanks dude, that fixed it. <3
Reply


Forum Jump:


Users browsing this thread: 1 Guest(s)