SA-MP Forums Archive
[Ajuda] INSERT INTO - 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] INSERT INTO (/showthread.php?tid=637857)


INSERT INTO - GustavoSouza - 22.07.2017

Bom esta dando erro ao criar....

PHP код:
                new Query[100];
                mysql_format(IDConexao, Query, sizeof(Query), "INSERT INTO `Label`(`Texto`=%s, `LabelX`=%f, `LabelY`=%f, `LabelZ`=%f)", inputtext, Pos[0], Pos[1], Pos[2]);
                mysql_tquery(IDConexao, Query, "Dados1", "i", playerid);
                SendClientMessage(playerid, 0x00FF80AA, "Label Criado!");} 
e:

PHP код:
forward Dados1(playerid);
public Dados1(playerid)
{
    PlayerInfo[playerid][lID] = cache_insert_id();
    printf("DEBUG- Novo label registrado ID: %d", PlayerInfo[playerid][lID]);
    return 1;
} 
no mysql_log:

PHP код:
[15:23:01 07/22/17] [ERROR] CMySQLQuery::Execute[Dados1] - (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 '={FF0000}> Hello <, `LabelX`=132.0, `LabelY`=-67.291, `LabelZ`=1.578)' at line 1 (Query: "INSERT INTO `Label`(`Texto`={FF0000}> Hello <, `LabelX`=132.0, `LabelY`=-67.291, `LabelZ`=1.578)") 


Re: INSERT INTO - BrianFaria - 22.07.2017

testar bem

Код:
mysql_format(IDConexao, Query, sizeof(Query), "INSERT INTO `Label` (`Texto`, `LabelX`, `LabelY`, `LabelZ`) VALUES('%s','%f','%f', '%f')",
inputtext,
Pos[0],
Pos[1],
Pos[2]);
mysql_tquery(IDConexao, Query, "Dados1", "i", playerid);
SendClientMessage(playerid, 0x00FF80AA, "Label Criado!");}

forward Dados1(playerid);
public Dados1(playerid)
{
    PlayerInfo[playerid][lID] = cache_insert_id();
    printf("DEBUG- Novo label registrado ID: %d", PlayerInfo[playerid][lID]);
    return 1;
}


Re: INSERT INTO - GustavoSouza - 22.07.2017

Quote:
Originally Posted by BrianFaria
Посмотреть сообщение
testar bem

Код:
mysql_format(IDConexao, Query, sizeof(Query), "INSERT INTO `Label` (`Texto`, `LabelX`, `LabelY`, `LabelZ`) VALUES('%s','%f','%f', '%f')",
inputtext,
Pos[0],
Pos[1],
Pos[2]);
mysql_tquery(IDConexao, Query, "Dados1", "i", playerid);
SendClientMessage(playerid, 0x00FF80AA, "Label Criado!");}

forward Dados1(playerid);
public Dados1(playerid)
{
    PlayerInfo[playerid][lID] = cache_insert_id();
    printf("DEBUG- Novo label registrado ID: %d", PlayerInfo[playerid][lID]);
    return 1;
}
Antes eu tinha feito igual a isso kkk ou quase, mas enfim deu certo! Obrigado.

Re: INSERT INTO - BrianFaria - 22.07.2017

Nгo hб de que.