[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=488446)
+- 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=488446)
MySql - goku114 - 18.01.2014
PHP код:
public OnDialogResponse(playerid, dialogid, response, listitem, inputtext[])
{
switch(dialogid){
case DIALOG01: {
new query[1024], name[MAX_PLAYER_NAME];
GetPlayerName(playerid, name, MAX_PLAYER_NAME);
format(query, sizeof(query), "SELECT * FROM `contas` WERE `usuario`= '%s' AND `senha` = %s", name, inputtext);
mysql_function_query(mysql, query, true, "q_verifyPassword", "d", "playerid");
}
case DIALOG02:{
if(strlen(inputtext)<2){
ShowPlayerDialog(playerid, DIALOG02,DIALOG_STYLE_PASSWORD, "Seja bem vindo","Digite uma senha","Registrar","Cancelar");
}else{
new query[1024], name[MAX_PLAYER_NAME];
GetPlayerName(playerid, name, MAX_PLAYER_NAME);
format(query, sizeof(query), "INSERT INTO `contas` (usuario, senha) VALUES ('%s','%s')", name, inputtext);
mysql_function_query(mysql, query, false,"", "");
SetSpawnInfo(playerid, 0, 0, 1958.3783, 1343.1572, 15.3746, 0, 0, 0, 0, 0, 0, 0);
SpawnPlayer(playerid);
}
}
}
return 1;
}
forward q_verifyPassword(playerid);
public q_verifyPassword(playerid){
new rows, fields;
cache_get_data(rows, fields);
if (rows){
SetSpawnInfo(playerid, 0, 0, 1958.3783, 1343.1572, 15.3746, 0, 0, 0, 0, 0, 0, 0);
SpawnPlayer(playerid);
return 1;
}
else
{
ShowPlayerDialog(playerid, DIALOG01,DIALOG_STYLE_PASSWORD, "Seja bem vindo 1 novamente","Olб Novamente, digite sua senha\n\nSenha Invalida","Logar","");
return 1;
}
}
criar a conta cria tudo normalzin zzzzzzz>><<
coloco qualquer senha e n da em nada tambem
Re: MySql - Gii - 18.01.2014
pawn Код:
public OnDialogResponse(playerid, dialogid, response, listitem, inputtext[]) {
switch(dialogid) {
case DIALOG01: {
if ( response ) {
new query[128], name[MAX_PLAYER_NAME];
GetPlayerName(playerid, name, MAX_PLAYER_NAME);
format(query, sizeof(query), "SELECT * FROM contas WHERE usuario = '%s' AND senha = %s", name, inputtext);
mysql_function_query(mysql, query, true, "q_verifyPassword", "d", "playerid");
}
else
Kick(playerid);
}
case DIALOG02: {
if ( response ) {
if ( strlen(inputtext) < 2 )
ShowPlayerDialog(playerid, DIALOG02,DIALOG_STYLE_PASSWORD, "Seja bem vindo","Digite uma senha","Registrar","Cancelar");
else {
new query[128], name[MAX_PLAYER_NAME];
GetPlayerName(playerid, name, MAX_PLAYER_NAME);
format(query, sizeof(query), "INSERT INTO contas (usuario, senha) VALUES ('%s', '%s')", name, inputtext);
mysql_function_query(mysql, query, false,"", "");
SetSpawnInfo(playerid, 0, 0, 1958.3783, 1343.1572, 15.3746, 0, 0, 0, 0, 0, 0, 0);
SpawnPlayer(playerid);
}
}
else
Kick(playerid);
}
}
return 1;
}
forward q_verifyPassword(playerid);
public q_verifyPassword(playerid) {
new rows, fields;
cache_get_data(rows, fields);
if ( rows ){
SetSpawnInfo(playerid, 0, 0, 1958.3783, 1343.1572, 15.3746, 0, 0, 0, 0, 0, 0, 0);
SpawnPlayer(playerid);
return 1;
}
else {
ShowPlayerDialog(playerid, DIALOG01,DIALOG_STYLE_PASSWORD, "Seja bem vindo 1 novamente","Olб Novamente, digite sua senha\n\nSenha Invalida","Logar","");
return 1;
}
return 1;
}
Vocк usou 'WERE' quando na verdade й WHERE.
DICA:
Sempre que vocк tem um problema envolvendo o MySQL verifique os LOGs(mysql_log) e veja o porque do problema!
Um cуdigo organizado й tudo!