SQL Query
#1

Код:
format(query, sizeof(query), "UPDATE `safes` SET `X` = %f, `Y` = %f, `Z` = %f, `Angle` = %f WHERE `id` = %d",x,y,z,rz,FamilySafes[safeid][ESafeSQLID]);
Is there any other way I can call this query? cause this doesn't seems to be working..


Q2: Aaand can you convert SQL to INI?
Reply
#2

You shouldn't try to convert SQL to INI... Never... Because the .ini files are written and readed by the SAMP server itself, and the DBMS (SQLite) are also written by the server itself, but there are some differences... Also the RDBMS (MySQL / MariaDB / Postgre) are using a server for the database itself so the query is processed by the database server and not your server.
Reply
#3

Better to use SQL than INI.

Not because of the 'reasons' listed above, but because SQL should be faster, and a lot more reliable than ini files.
Reply
#4

Maybe if you tell us what the problem is we could help you. SQL to INI is a downgrade.
Reply
#5

Just try to fix it but never think of going a step back[Mysql to INI] because later when you will come to know the advantages of sql, you would try to get back into sql
Reply
#6

Thank you all for the support though, I fixed the issue
Reply
#7

Should let others know how you fixed it, and why you fixed it in that way.

Could help someone in the future, who wonders if they should go through with SQL, or choose INIs.
Reply
#8

I don't see code where you're executing the query, this is done using mysql_query
Reply


Forum Jump:


Users browsing this thread: 1 Guest(s)