[Ajuda] MYSQL - Printable Version
+- SA-MP Forums Archive (https://sampforum.blast.hk)
+-- Forum: Non-English (https://sampforum.blast.hk/forumdisplay.php?fid=9)
+--- Forum: Languages (https://sampforum.blast.hk/forumdisplay.php?fid=33)
+---- Forum: Português/Portuguese (https://sampforum.blast.hk/forumdisplay.php?fid=34)
+---- Thread: [Ajuda] MYSQL (/showthread.php?tid=562409)
+- SA-MP Forums Archive (https://sampforum.blast.hk)
+-- Forum: Non-English (https://sampforum.blast.hk/forumdisplay.php?fid=9)
+--- Forum: Languages (https://sampforum.blast.hk/forumdisplay.php?fid=33)
+---- Forum: Português/Portuguese (https://sampforum.blast.hk/forumdisplay.php?fid=34)
+---- Thread: [Ajuda] MYSQL (/showthread.php?tid=562409)
MYSQL - ZeZin - 08.02.2015
Alguem pode saber se estou com error na include plugins ou que olhas os erros?
Maioria dos erros sгo esses
pawn Код:
: error 017: undefined symbol "mysql_function_query"
:error 017: undefined symbol "mysql_function_query"
:error 017: undefined symbol "mysql_store_result"
:error 017: undefined symbol "mysql_fetch_row_format"
:error 017: undefined symbol "mysql_fetch_field_row"
:error 017: undefined symbol "mysql_fetch_field_row"
:error 017: undefined symbol "mysql_free_result"
:warning 202: number of arguments does not match definition
:warning 203: symbol is never used: "PrisonTime"
:error 017: undefined symbol "mysql_store_result"
:error 017: undefined symbol "mysql_num_row
Re: MYSQL - ZeZin - 08.02.2015
Double post mais UPP??
Re: MYSQL - Bruno_Cyra - 09.02.2015
Isso nгo й erro Mysql, erro mysql й erro de query ou conexгo, isso й erro de pawn
vocк importou a biblioteca do mysql?
pawn Код:
#include <a_mysql>
Re: MYSQL - ZeZin - 09.02.2015
#Problema resolvido tutorial estava errado tenho outra duvida para evitar criaзгo de topico nessa linha
pawn Код:
mysql_format(mysql, query, sizeof(query), "UPDATE `serve` SET `pAdmin`=%d, `Vip`=%d, `Dinheiro`=%d, `Score`=%d, `IP`=%d, `Deaths`=%d, `Kills`=%d WHERE `ID`=%d",PlayerInfo[playerid][pAdmin], PlayerInfo[playerid][Vip], PlayerInfo[playerid][Dinheiro], PlayerInfo[playerid][Score],PlayerInfo[playerid][IP],PlayerInfo[playerid][Deaths],PlayerInfo[playerid][Kills]);
mysql_tquery(mysql, query, "", "");
MYSQL LOG
PHP код:
[22:50:15] [DEBUG] mysql_format - connection: 1, len: 128, format: "UPDATE `serve` SET `pAdmin`=%d, `Vip`=%d, `Dinheiro`=%d, `Score`=%d, `IP`=%d, `Deaths`=%d, `Kills`=%d WHERE `ID`=%d"
[22:50:15] [ERROR] mysql_format - no value for specifier "%d" available
[22:50:15] [DEBUG] mysql_tquery - connection: 1, query: "UPDATE `serve` SET `pAdmin`=5, `Vip`=0, `Dinheiro`=1, `Score`=0,", callback: "(null)", format: "(null)"
[22:50:15] [DEBUG] CMySQLQuery::Execute[] - starting query execution
[22:50:15] [ERROR] CMySQLQuery::Execute[] - (error #1064) You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1
[22:50:15] [DEBUG] CMySQLQuery::Execute[] - error will be triggered in OnQueryError
Re: MYSQL - Bruno_Cyra - 09.02.2015
Parece que a variбvel query[] й muito pequena afinal o erro apresenta que a query:
Код:
"UPDATE `serve` SET `pAdmin`=5, `Vip`=0, `Dinheiro`=1, `Score`=0,"
Sу uma outra dica, eu acho que para querys que nгo mexem com valores digitados por players nгo hб a necessidade de usar o mysql_format pois nгo tem como o player fazer sql injection, o sql injetction sу й possнvel quando valores sгo digitados por players, no caso aн parece que vocк sу quer salvar atributos da conta do player que sгo calculados e nгo digitados.
Re: MYSQL - ZeZin - 09.02.2015
A query ja estб mais de 200
PHP код:
[23:16:53] [DEBUG] cache_get_field_content_int - row: 0, field_name: "Score", connection: 1
[23:16:53] [ERROR] CMySQLResult::GetRowDataByName() - invalid row index ('0')
[23:16:53] [ERROR] cache_get_field_content_int - invalid datatype
[23:16:53] [DEBUG] cache_get_field_content_int - row: 0, field_name: "Deaths", connection: 1
[23:16:53] [ERROR] CMySQLResult::GetRowDataByName() - invalid row index ('0')
[23:16:53] [ERROR] cache_get_field_content_int - invalid datatype
[23:16:53] [DEBUG] cache_get_field_content_int - row: 0, field_name: "Kills", connection: 1
[23:16:53] [ERROR] CMySQLResult::GetRowDataByName() - invalid row index ('0')
[23:16:53] [ERROR] cache_get_field_content_int - invalid datatype
[23:16:53] [DEBUG] CMySQLResult::~CMySQLResult() - deconstructor called
[23:16:57] [DEBUG] mysql_format - connection: 1, len: 500, format: "UPDATE `serve` SET `pAdmin`=%d, `Vip`=%d, `Dinheiro`=%d, `Score`=%d, `IP`=%d, `Deaths`=%d, `Kills`=%d WHERE `ID`=%d"
[23:16:57] [DEBUG] mysql_tquery - connection: 1, query: "UPDATE `serve` SET `pAdmin`=0, `Vip`=0, `Dinheiro`=0, `Score`=0,", callback: "(null)", format: "(null)"
[23:16:57] [DEBUG] CMySQLQuery::Execute[] - starting query execution
[23:16:57] [DEBUG] CMySQLQuery::Execute[] - query was successfully executed within 83.577 milliseconds
[23:16:57] [DEBUG] CMySQLQuery::Execute[] - no callback specified, skipping result saving
Re: MYSQL - StrondaXxT - 09.02.2015
linha comprida de mais
Re: MYSQL - pWesley - 09.02.2015
Usa MySQL R39-r2 e tenta usar ORM ...
Lк esse tutorial: https://sampforum.blast.hk/showthread.php?tid=499336 vai te ajudar e muito.
Re: MYSQL - Cleyson - 09.02.2015
pawn Код:
mysql_format(mysql, query, sizeof(query), "UPDATE `serve` SET `pAdmin`=%d, `Vip`=%d, `Dinheiro`=%d, `Score`=%d, `IP`=%d, `Deaths`=%d, `Kills`=%d WHERE `ID`=%d",PlayerInfo[playerid][pAdmin], PlayerInfo[playerid][Vip], PlayerInfo[playerid][Dinheiro], PlayerInfo[playerid][Score],PlayerInfo[playerid][IP],PlayerInfo[playerid][Deaths],PlayerInfo[playerid][Kills]);
mysql_tquery(mysql, query, "", "");
Re: MYSQL - Cleyson - 09.02.2015
Quote:
|
Originally Posted by Cleyson
 pawn Код:
|
como o mysql ira salvar na conta WHERE `ID`=%d se a mesma nгo foi informada.