[Pawn] Help with sqlite floats

[Turk54721]

How about changing %d to %f ?

Code:

HEALTH = '%d', ARMOUR = '%d', X = '%d', Y = '%d', Z = '%d'

?

HEALTH = '%f', ARMOUR = '%f', X = '%f', Y = '%f', Z = '%f'

and same in here:

Code:

format(Query, sizeof(Query), "INSERT INTO `USERS` (`NAME`, `PASSWORD`, `IP`, `TEAM`, `SKIN`, `MONEY`, `SCORE`, `HEALTH`, `ARMOUR`, `X`, `Y`, `Z`) VALUES('%s','%s','%s', '0', '0', '0', '0', '%d', '%d', '%d', '%d', '%d')", DB_Escape(name), DB_Escape(inputtext), DB_Escape(ip));

?

format(Query, sizeof(Query), "INSERT INTO `USERS` (`NAME`, `PASSWORD`, `IP`, `TEAM`, `SKIN`, `MONEY`, `SCORE`, `HEALTH`, `ARMOUR`, `X`, `Y`, `Z`) VALUES('%s','%s','%s', '0', '0', '0', '0', '%f', '%f', '%f', '%f', '%f')", DB_Escape(name), DB_Escape(inputtext), DB_Escape(ip));

I think I tried that, will try again when I will get home, thanks for answer.