13.09.2014, 09:59
Hello!,
I don't undestand why this happend? When i go in server first time, i register and i get in server and play! But when i log out and go server aigan, then it says log in, and when i type my incorrect password, it says Wrong Password, but when i type correct password the server is restart.
SORRY FOR MY BAD ENGLISH, I HOPE YOUR UNDESTAND MY PROBLEM!
I don't undestand why this happend? When i go in server first time, i register and i get in server and play! But when i log out and go server aigan, then it says log in, and when i type my incorrect password, it says Wrong Password, but when i type correct password the server is restart.
SORRY FOR MY BAD ENGLISH, I HOPE YOUR UNDESTAND MY PROBLEM!
pawn Код:
// OnDialogResponse
if(dialogid == DIALOG_LOGIN)
{
if(!response)
{
SendClientMessage(playerid, V_PUNANE, "[VIGA]: Et mдngida, pead sa logima oma kasutajasse sisse!");
SetTimerEx("ViskaKasutaja", 100, false, "i", playerid);
}
if(response)
{
new query[200], pname[24], escapepass[100];
GetPlayerName(playerid, pname, 24);
mysql_real_escape_string(inputtext, escapepass);
format(query, sizeof(query), "SELECT `user` FROM playerdata WHERE user = '%s' AND password = SHA1('%s')", pname, escapepass);
mysql_query(query);
mysql_store_result();
new numrows = mysql_num_rows();
if(numrows == 1) MySQL_Login(playerid);
if(!numrows)
{
new teade[128];
GetPlayerName(playerid, pname, 24);
format(teade, sizeof(teade), ""White"Tere tulemast tagasi "Red""SERVERI_NIMI""White"!\n"White"Selline kasutaja nagu %s eksisteerib andmebaasis!\n\n"White"Palun logi sisse, kirjutades alla lahtrisse "Red"oma"White" parool:", pname);
ShowPlayerDialog(playerid, DIALOG_LOGIN, DIALOG_STYLE_INPUT, ""Blue"Logi sisse", teade, "Logi Sisse", "Tьhista");
GameTextForPlayer(playerid,"~r~Vale parool!",2000,6);
}
mysql_free_result();
}
}
pawn Код:
// OnPlayerConnect
IsPlayerBanned(playerid);
//================================================================//
// MySQL part //
//================================================================//
MoneyGiven[playerid] = -1;
JustLogged[playerid] = 0;
new query[300], pname[24], teade[128];
GetPlayerName(playerid, pname, 24);
format(query, sizeof(query), "SELECT IP FROM `playerdata` WHERE user = '%s' LIMIT 1", pname);
mysql_query(query);
mysql_store_result();
new rows = mysql_num_rows();
if(!rows)
{
format(teade, sizeof(teade), ""White"Tere tulemast "Red""SERVERI_NIMI""White"!\n"White"Sellist kasutajat nagu %s ei eksisteeri meie andmebaasis! \n\n"White"Palun registreeri, kirjutades alla lahtrisse oma tulevane parool:", pname);
ShowPlayerDialog(playerid, DIALOG_REGISTER, DIALOG_STYLE_INPUT, ""Blue"Registreerimine",teade, "Registreeri", "Tьhista");
}
if(rows == 1)
{
format(teade, sizeof(teade), ""White"Tere tulemast tagasi "Red""SERVERI_NIMI""White"!\n"White"Selline kasutaja nagu %s eksisteerib andmebaasis!\n\n"White"Palun logi sisse, kirjutades alla lahtrisse "Red"oma"White" parool:", pname);
ShowPlayerDialog(playerid, DIALOG_LOGIN, DIALOG_STYLE_INPUT, ""Blue"Logi sisse", teade, "Logi Sisse", "Tьhista");
IsRegistered[playerid] = 1;
}
mysql_free_result();
pawn Код:
//STOCK
stock MySQL_Login(playerid)
{
new query2[300], pname[24], savingstring[20];
GetPlayerName(playerid, pname, 24);
format(query2, sizeof(query2), "SELECT score, money, level, vip, kma, rank, kills, deaths, muted, jailed, frozen, mutedtimes, jailedtimes, frozentimes, Drift, logins, Meetrid, Kilomeetrid FROM playerdata WHERE user = '%s'", pname);
mysql_query(query2);
mysql_store_result();
while(mysql_fetch_row_format(query2,"|"))
{
mysql_fetch_field_row(savingstring, "score"); AnnaRaha(playerid, 0, strval(savingstring));
mysql_fetch_field_row(savingstring, "money"); AnnaRaha(playerid, strval(savingstring), 0);
mysql_fetch_field_row(savingstring, "level"); PlayerInfo[playerid][pLevel] = strval(savingstring);
mysql_fetch_field_row(savingstring, "vip"); PlayerInfo[playerid][pVIP] = strval(savingstring);
mysql_fetch_field_row(savingstring, "kma"); PlayerInfo[playerid][pKMA] = strval(savingstring);
mysql_fetch_field_row(savingstring, "rank"); PlayerInfo[playerid][pRank] = strval(savingstring);
mysql_fetch_field_row(savingstring, "kills"); PlayerInfo[playerid][pKills] = strval(savingstring);
mysql_fetch_field_row(savingstring, "deaths"); PlayerInfo[playerid][pDeaths] = strval(savingstring);
mysql_fetch_field_row(savingstring, "muted"); PlayerInfo[playerid][pMuted] = strval(savingstring);
mysql_fetch_field_row(savingstring, "jailed"); PlayerInfo[playerid][pJailed] = strval(savingstring);
mysql_fetch_field_row(savingstring, "frozen"); PlayerInfo[playerid][pFrozen] = strval(savingstring);
mysql_fetch_field_row(savingstring, "mutedtimes"); PlayerInfo[playerid][pMutedTimes] = strval(savingstring);
mysql_fetch_field_row(savingstring, "jailedtimes"); PlayerInfo[playerid][pJailedTimes] = strval(savingstring);
mysql_fetch_field_row(savingstring, "frozentimes"); PlayerInfo[playerid][pFrozenTimes] = strval(savingstring);
mysql_fetch_field_row(savingstring, "Drift"); PlayerInfo[playerid][Drift] = strval(savingstring);
mysql_fetch_field_row(savingstring, "logins"); PlayerInfo[playerid][pLogins] = strval(savingstring);
mysql_fetch_field_row(savingstring, "Meetrid"); PlayerInfo[playerid][Meetrid] = strval(savingstring);
mysql_fetch_field_row(savingstring, "Kilomeetrid"); PlayerInfo[playerid][Kilomeetrid] = strval(savingstring);
}
mysql_free_result();
JustLogged[playerid] = 1;
Logged[playerid] = 1;
PlayerInfo[playerid][pLogins]++;
GameTextForPlayer(playerid,"~g~Sa oled edukalt ~n~sisse logitud!",5000,5);
new st[128];
format(st,128,"{1FF231}%s {F2B01F}logis enda kasutajasse sisse !",GetName(playerid));
SendClientMessageToAll(COLOR_LIGHTBLUE,st);
CargarDatosVehiculos(playerid);
return 1;
}