02.09.2012, 11:04
Sorry for triple post but It`s not working
(((
here is RegisterPlayer and LoginPlayer

here is RegisterPlayer and LoginPlayer
pawn Код:
RegisterPlayer(playerid, password[])
{
if(strlen(password) < 3 || strlen(password) >= 32)
{
new str[278];
SendClientMessage(playerid, -1, ""embed_sw"[ACCOUNT] "embed_white"Your password is too short or too long!");
format(str,sizeof(str),"{FFFFFF}Welcome,this account ("COL_RED"%s"embed_white")is "COL_RED"not{FFFFFF} registered{FFFFFF}\n"embed_white"Please enter your desired password for this account.\n\n"embed_grey"Once you are registered,do not share your passowrd with anyone besides your self.", UserStats[playerid][Name], playerid);
ShowPlayerDialog(playerid, 15000, DIALOG_STYLE_INPUT, "Register",str,"Register","Cancel");
}
CheckMySQL();
new string[128];
format(string, sizeof(string), "INSERT INTO Users (Name,Password) VALUES ('%s',sha1('%s')))", UserStats[playerid][Name], password);
mysql_query(string);
AccountExists[playerid] = 1;
SendClientMessage(playerid, -1, ""embed_sw"[ACCOUNT] "embed_white"Your account has been created, please login now!");
LoginPlayer(playerid, password);
return 1;
}
LoginPlayer(playerid, password[])
{
if(strlen(password) < 3 || strlen(password) >= 32)
{
new str[178];
SendClientMessage(playerid, -1, ""embed_sw"[ACCOUNT] "embed_white" Your password is too short or too long!");
format(str,sizeof(str),"{FFFFFF}Welcome,this account ("COL_BLUE"%s"embed_white") is already registred!\n"embed_white"Please enter the password to login\n\n"embed_grey"If you are not owner of this account leave and rejoin a different nickname.", UserStats[playerid][Name], playerid);
ShowPlayerDialog(playerid,15500,DIALOG_STYLE_PASSWORD,"Login",str,"Login","");
}
CheckMySQL();
new string[128];
format(string, sizeof(string), "SELECT * FROM Users WHERE Name = '%s' AND Password = sha1('%s')", UserStats[playerid][Name], password);
mysql_query(string);
mysql_store_result();
if(!mysql_num_rows())
return SendClientMessage(playerid, -1, ""embed_sw"[ACCOUNT] "embed_white"Incorrect password!"),ShowPlayerDialog(playerid,15500,DIALOG_STYLE_PASSWORD,"Login",""embed_white"You putted "embed_red"wrong password"embed_white".Please input right password!","Login","");
new row[128]; // The length of 1 'row' total.
new field[11][32]; // [4] = Amount of fields, [24] = Max length of the bigest field.
mysql_fetch_row_format(row, "|");
explode(row, field, "|");
mysql_free_result();
// The field starts here with 1, because the field 'Name' = 0, and we already have the name in a variable.
format(UserStats[playerid][Password], 32, "%s", field[1]);
UserStats[playerid][Admin] = strval(field[2]);
UserStats[playerid][Money] = strval(field[3]);
UserStats[playerid][Score] = strval(field[4]);
UserStats[playerid][Exp] = strval(field[5]);
UserStats[playerid][Kills] = strval(field[6]);
UserStats[playerid][Deaths] = strval(field[7]);
UserStats[playerid][Material] = strval(field[8]);
UserStats[playerid][KeysBob] = strval(field[9]);
UserStats[playerid][KeysYosi] = strval(field[10]);
GivePlayerMoney(playerid, UserStats[playerid][Money]);
SetPlayerScore(playerid, UserStats[playerid][Score]);
format(string, sizeof(string), ""embed_sw"[ACCOUNT] "embed_white"Welcome "COL_BLUE"%s"embed_white", you are now logged in! Stay ready for war!", UserStats[playerid][Name]);
SendClientMessage(playerid, -1, string);
PlayerLogged[playerid] = 1;
return 1;
}
SavePlayer(playerid)
{
new string[170];
UserStats[playerid][Score] = GetPlayerScore(playerid);
UserStats[playerid][Money] = GetPlayerMoney(playerid);
format(string, sizeof(string), "UPDATE `Users` SET `Password` = sha1('%s') WHERE `Name` = '%s'", UserStats[playerid][Password], UserStats[playerid][Name]);
mysql_query(string);
format(string, sizeof(string), "UPDATE `Users` SET `Exp` = %i WHERE `Name` = '%s'", UserStats[playerid][Exp], UserStats[playerid][Name]);
mysql_query(string);
format(string, sizeof(string), "UPDATE `Users` SET `Score` = %i WHERE `Name` = '%s'", UserStats[playerid][Score], UserStats[playerid][Name]);
mysql_query(string);
format(string, sizeof(string), "UPDATE `Users` SET `Money` = %i WHERE `Name` = '%s'", UserStats[playerid][Money], UserStats[playerid][Name]);
mysql_query(string);
format(string, sizeof(string), "UPDATE `Users` SET `Kills` = %i WHERE `Name` = '%s'", UserStats[playerid][Kills], UserStats[playerid][Name]);
mysql_query(string);
format(string, sizeof(string), "UPDATE `Users` SET `Deaths` = %i WHERE `Name` = '%s'", UserStats[playerid][Deaths], UserStats[playerid][Name]);
mysql_query(string);
format(string, sizeof(string), "UPDATE `Users` SET `Material` = %i WHERE `Name` = '%s'", UserStats[playerid][Material], UserStats[playerid][Name]);
mysql_query(string);
format(string, sizeof(string), "UPDATE `Users` SET `KeysBob` = %i WHERE `Name` = '%s'", UserStats[playerid][KeysBob], UserStats[playerid][Name]);
mysql_query(string);
format(string, sizeof(string), "UPDATE `Users` SET `KeysYosi` = %i WHERE `Name` = '%s'", UserStats[playerid][KeysYosi], UserStats[playerid][Name]);
mysql_query(string);
return 1;
}