[ApolloScripter]

Hello everyone, I decided to learn MySQL and make my GM a little more practical, I followed tutorials but when testing, I come across some informalities and errors, such as those mentioned below:

PHP код:

warning 213: tag mismatch
// On this Line
IDConexao = mysql_connect(HOST, USUARIO, SENHA, DATABASE); 


PHP код:

warning 202: number of arguments does not match definition
//On this Line
mysql_format(IDConexao, Query, sizeof(Query), "INSERT INTO `ContasScore`(`Nome`, `Score`) VALUES ('%s', '%i')", PlayerName(playerid), GetPlayerScore(playerid)); 


And Errors

PHP код:

error 017: undefined symbol "mysql_tquery"
error 017: undefined symbol "mysql_format"
//On these respective lines
mysql_tquery(IDConexao, Query, "DadosRegistrados", "i", playerid);
mysql_format(IDConexao, Query, sizeof(Query), "UPDATE `ContasScore` SET `Nome`='%s', `Score`='%i' WHERE `ID`=%d", PlayerName(playerid), GetPlayerScore(playerid), PlayerInfoID[playerid]); 


There are other errors, but almost all are errors that do not recognize the command that is related to MySQL, I have already updated everything and even that did not help.

[Chyakka]

Is your 'IDConexao' variable declared as a mysql variable?

When you make your variable you need to make sure it has the prefix MySQL:, so your variable would be:

Код:

new MySQL:IDConexao;

[ApolloScripter]

Yes, it is.

PHP код:

new MySQL:IDConexao; 


[Chyakka]

What mysql plugin are you using and what version is it?

[ApolloScripter]

It is R41-4, using Windows version.

[rockys]

#include mysql

[ApolloScripter]

Quote:

Originally Posted by rockys #include mysql

Already included.

[rockys]

where you use that syntax?
and first is mysql_format no tquery

[ApolloScripter]

I used it normally in a file, so include it in GM like any other.

and "mysql_tquery", it's on another line, I just put it there to demonstrate, but I read that this is used to call some function or something like that, I may have misunderstood as well.

[ApolloScripter]

Someone?