pawn Code:
forward loginPlayer(playerid, senha[]); public loginPlayer(playerid, senha[])
{
if(!IsPlayerConnected(playerid)) return mysql_free_result(); // Incase they're disconnected since... Sometimes queries F*"!%$" up.
new
Nome[24],
Nome2[24],
Password[129],
sQuery[128],
string[128]
;
GetPlayerName(playerid, Nome, 24);
mysql_real_escape_string(Nome, Nome2);
mysql_real_escape_string(senha, Password);
mysql_free_result();
format(sQuery, sizeof(sQuery), "SELECT * FROM players WHERE Name = %s AND Password = %s", Nome2, Password);
mysql_query(sQuery);
mysql_store_result();
if(mysql_num_rows() == 0)
{
SetPVarInt(playerid, "LA", GetPVarInt(playerid, "LA") + 1);
if(GetPVarInt(playerid, "LA") > 3) {
SendClientMessage(playerid, COLOR_RED, "Vocк errou a senha muitas vezes e foi kickado!");
Kick(playerid);
return 1;
}
else {
ShowPlayerDialog(playerid, 5000, DIALOG_STYLE_INPUT, "[Login]", "Logue-se no advanced roleplay !", "Logar", "Sair");
format(string, sizeof(string), "Senha incorreta, vocк tem %d tentativas restantes.", (3-GetPVarInt(playerid, "LA")));
SendClientMessage(playerid, -1, string);
return 1;
}
}
else
{
DeletePVar(playerid, "LA");
mysql_retrieve_row();
mysql_get_field("Password", PlayerInfo[playerid][pKey]);
mysql_get_field("id", sqlResult);
PlayerInfo[playerid][pSQLID] = strval(sqlResult);
mysql_get_field("PlayerLevel", sqlResult);
PlayerInfo[playerid][pLevel] = strval(sqlResult);
mysql_get_field("AdminLevel", sqlResult);
PlayerInfo[playerid][pAdmin] = strval(sqlResult);
mysql_get_field("DonateRank", sqlResult);
PlayerInfo[playerid][pDonateRank] = strval(sqlResult);
mysql_get_field("UpgradePoints", sqlResult);
PlayerInfo[playerid][gPupgrade] = strval(sqlResult);
mysql_get_field("ConnectedTime", sqlResult);
PlayerInfo[playerid][pConnectTime] = strval(sqlResult);
mysql_get_field("Registered", sqlResult);
PlayerInfo[playerid][pReg] = strval(sqlResult);
mysql_get_field("Sex", sqlResult);
PlayerInfo[playerid][pSex] = strval(sqlResult);
mysql_get_field("Age", sqlResult);
PlayerInfo[playerid][pAge] = strval(sqlResult);
mysql_get_field("Respect", sqlResult);
PlayerInfo[playerid][pExp] = strval(sqlResult);
mysql_get_field("Money", sqlResult);
PlayerInfo[playerid][pCash] = strval(sqlResult);
mysql_get_field("Bank", sqlResult);
PlayerInfo[playerid][pAccount] = strval(sqlResult);
mysql_get_field("Mascara", sqlResult);
PlayerInfo[playerid][pMascara] = strval(sqlResult);
mysql_get_field("Skin2", sqlResult);
PlayerInfo[playerid][pSkin2] = strval(sqlResult);
mysql_get_field("Job", sqlResult);
PlayerInfo[playerid][pJob] = strval(sqlResult);
mysql_get_field("Paycheck", sqlResult);
PlayerInfo[playerid][pPayCheck] = strval(sqlResult);
mysql_get_field("Jailed", sqlResult);
PlayerInfo[playerid][pJailed] = strval(sqlResult);
mysql_get_field("JailTime", sqlResult);
PlayerInfo[playerid][pJailTime] = strval(sqlResult);
mysql_get_field("Materials", sqlResult);
PlayerInfo[playerid][pMats] = strval(sqlResult);
mysql_get_field("Leader", sqlResult);
PlayerInfo[playerid][pLeader] = strval(sqlResult);
mysql_get_field("Member", sqlResult);
PlayerInfo[playerid][pMember] = strval(sqlResult);
mysql_get_field("FMember", sqlResult);
PlayerInfo[playerid][pFMember] = strval(sqlResult);
mysql_get_field("Rank", sqlResult);
PlayerInfo[playerid][pRank] = strval(sqlResult);
mysql_get_field("Chara", sqlResult);
PlayerInfo[playerid][pChar] = strval(sqlResult);
mysql_get_field("Skin1", sqlResult);
PlayerInfo[playerid][pSkin1] = strval(sqlResult);
mysql_get_field("BMX", sqlResult);
PlayerInfo[playerid][pBMX] = strval(sqlResult);
mysql_get_field("pSHealth", sqlResult);
PlayerInfo[playerid][pSHealth] = floatstr(sqlResult);
mysql_get_field("pHealth", sqlResult);
PlayerInfo[playerid][pHealth] = floatstr(sqlResult);
mysql_get_field("Inte", sqlResult);
PlayerInfo[playerid][pInt] = strval(sqlResult);
mysql_get_field("Local", sqlResult);
PlayerInfo[playerid][pLocal] = strval(sqlResult);
mysql_get_field("Team", sqlResult);
PlayerInfo[playerid][pTeam] = strval(sqlResult);
mysql_get_field("Model", sqlResult);
PlayerInfo[playerid][pModel] = strval(sqlResult);
mysql_get_field("House", sqlResult);
PlayerInfo[playerid][pPhousekey] = strval(sqlResult);
mysql_get_field("Car", sqlResult);
PlayerInfo[playerid][pPcarkey] = strval(sqlResult);
mysql_get_field("Appt", sqlResult);
PlayerInfo[playerid][pPapptkey] = strval(sqlResult);
mysql_get_field("Bizz", sqlResult);
PlayerInfo[playerid][pPbiskey] = strval(sqlResult);
mysql_get_field("CarLic", sqlResult);
PlayerInfo[playerid][pCarLic] = strval(sqlResult);
mysql_get_field("FlyLic", sqlResult);
PlayerInfo[playerid][pFlyLic] = strval(sqlResult);
mysql_get_field("BoatLic", sqlResult);
PlayerInfo[playerid][pBoatLic] = strval(sqlResult);
mysql_get_field("FishLic", sqlResult);
PlayerInfo[playerid][pFishLic] = strval(sqlResult);
mysql_get_field("GunLic", sqlResult);
PlayerInfo[playerid][pGunLic] = strval(sqlResult);
mysql_get_field("Tutorial", sqlResult);
PlayerInfo[playerid][pTut] = strval(sqlResult);
printf("%i", strval(sqlResult));
mysql_get_field("Cocaina", sqlResult);
drugInfo[playerid][dgCocaina] = strval(sqlResult);
mysql_get_field("Maconha", sqlResult);
drugInfo[playerid][dgMaconha] = strval(sqlResult);
mysql_get_field("Opio", sqlResult);
drugInfo[playerid][dgOpio] = strval(sqlResult);
mysql_get_field("Crack", sqlResult);
drugInfo[playerid][dgCrack] = strval(sqlResult);
mysql_get_field("Meth", sqlResult);
drugInfo[playerid][dgMeth] = strval(sqlResult);
mysql_get_field("Heroina", sqlResult);
drugInfo[playerid][dgHeroina] = strval(sqlResult);
mysql_get_field("Haxixe", sqlResult);
drugInfo[playerid][dgHaxixe] = strval(sqlResult);
mysql_get_field("Veh2", sqlResult);
PlayerInfo[playerid][pPcarkey2] = strval(sqlResult);
mysql_get_field("car3", sqlResult);
PlayerInfo[playerid][pPcarkey3] = strval(sqlResult);
mysql_get_field("Partes", sqlResult);
PlayerInfo[playerid][pPartes] = strval(sqlResult);
mysql_get_field("Pos_x", sqlResult);
PlayerInfo[playerid][pPos_x] = floatstr(sqlResult);
mysql_get_field("Pos_y", sqlResult);
PlayerInfo[playerid][pPos_y] = floatstr(sqlResult);
PlayerInfo[playerid][pPos_z] = floatstr(sqlResult);
ResetPlayerCash(playerid);
GivePlayerCash(playerid,PlayerInfo[playerid][pCash]);
if(!PlayerInfo[playerid][pReg])
{
PlayerInfo[playerid][pLevel] = 1;
PlayerInfo[playerid][pSHealth] = 0.0;
PlayerInfo[playerid][pHealth] = 100.0;
PlayerInfo[playerid][pPos_x] = NOOB_X;
PlayerInfo[playerid][pPos_y] = NOOB_Y;
PlayerInfo[playerid][pPos_z] = NOOB_Z;
PlayerInfo[playerid][pInt] = 0;
PlayerInfo[playerid][pLocal] = 1;
PlayerInfo[playerid][pTeam] = 3;
PlayerInfo[playerid][pModel] = 135;
new randphone = 10000000 + random(89999999);
PlayerInfo[playerid][pNumero] = randphone;
PlayerInfo[playerid][pPhousekey] = 255;
PlayerInfo[playerid][pPcarkey] = 999;
PlayerInfo[playerid][pPcarkey2] = 999;
PlayerInfo[playerid][pPcarkey3] = 999;
PlayerInfo[playerid][pPapptkey] = 255;
PlayerInfo[playerid][pPbiskey] = 255;
PlayerInfo[playerid][pAccount] = 0;
PlayerInfo[playerid][pReg] = 1;
GivePlayerCash(playerid, 500);
}
SetSpawnInfo(playerid, PlayerInfo[playerid][pTeam], PlayerInfo[playerid][pModel], PlayerInfo[playerid][pPos_x], PlayerInfo[playerid][pPos_y], PlayerInfo[playerid][pPos_z], 1.0, -1, -1, -1, -1, -1, -1);
gPlayerLogged[playerid] = 1;
SpawnPlayer(playerid);
if(!PlayerInfo[playerid][pDonateRank]) {
PlayerInfo[playerid][pMascara] = 0;
}
SetPlayerSpawn(playerid);
SetPlayerSkin(playerid, PlayerInfo[playerid][pSkin1]);
ClearChatbox(playerid, 10);
SendClientMessage(playerid, COLOR_LIGHTRED, "Advanced Roleplay: Testando CPU");
}
mysql_free_result();
return 1;
}