09.07.2012, 14:16
pawn Код:
case MySQL_QUERY_LOGIN: {
mysql_store_result();
if(mysql_num_rows() >= 1) {
mysql_fetch_row_format(string, "|");
print(string);
new ustring[5];
sscanf(string, "p<|>s[5]s[5]iiiifffffiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiis[5]s[5]s[128]iiiiiiiiiis[5]",
ustring, ustring, PlayerInfo[extraid][pCash], PlayerInfo[extraid][pModel], PlayerInfo[extraid][pCrash],
PlayerInfo[extraid][pAge], PlayerInfo[extraid][pPosX], PlayerInfo[extraid][pPosY],PlayerInfo[extraid][pPosZ],
PlayerInfo[extraid][pHealth], PlayerInfo[extraid][pArmour], PlayerInfo[extraid][pInt], PlayerInfo[extraid][pWorld],
PlayerInfo[extraid][pPayDay], PlayerInfo[extraid][pPayCheck], PlayerInfo[extraid][pBank], PlayerInfo[extraid][pConnectTime], PlayerInfo[extraid][pMember],
PlayerInfo[extraid][pRank], PlayerInfo[extraid][pWeed], PlayerInfo[extraid][pCrack],PlayerInfo[extraid][pCocaine],
PlayerInfo[extraid][pHouseKey], PlayerInfo[extraid][pBizzKey],PlayerInfo[extraid][pCarKey1], PlayerInfo[extraid][pCarKey2], PlayerInfo[extraid][pCarKey3], PlayerInfo[extraid][pAdmin], PlayerInfo[extraid][pHelper],
PlayerInfo[extraid][pBanned], PlayerInfo[extraid][pDrugTime], PlayerInfo[extraid][pHouseEnter], PlayerInfo[extraid][pBizzEnter],
PlayerInfo[extraid][pGunLic], PlayerInfo[extraid][pDriveLic], PlayerInfo[extraid][pPhoneNum], PlayerInfo[extraid][pJob], PlayerInfo[extraid][pJailed],
PlayerInfo[extraid][pJailTime], PlayerInfo[extraid][pWeapon][0],
PlayerInfo[extraid][pWeapon][1], PlayerInfo[extraid][pWeapon][2], PlayerInfo[extraid][pWeapon][3],
PlayerInfo[extraid][pWeapon][4], PlayerInfo[extraid][pWeapon][5], PlayerInfo[extraid][pWeapon][6],
PlayerInfo[extraid][pWeapon][7], PlayerInfo[extraid][pWeapon][8], PlayerInfo[extraid][pWeapon][9],
PlayerInfo[extraid][pWeapon][10], PlayerInfo[extraid][pWeapon][11], PlayerInfo[extraid][pWeapon][12],
PlayerInfo[extraid][pAmmo][0],PlayerInfo[extraid][pAmmo][1],PlayerInfo[extraid][pAmmo][2],
PlayerInfo[extraid][pAmmo][3], PlayerInfo[extraid][pAmmo][4], PlayerInfo[extraid][pAmmo][5],
PlayerInfo[extraid][pAmmo][6], PlayerInfo[extraid][pAmmo][7], PlayerInfo[extraid][pAmmo][8],
PlayerInfo[extraid][pAmmo][9], PlayerInfo[extraid][pAmmo][10], PlayerInfo[extraid][pAmmo][11],
PlayerInfo[extraid][pAmmo][12], PlayerInfo[extraid][pWantedLevel], PlayerInfo[extraid][pDonateRank],
PlayerInfo[extraid][pMask], PlayerInfo[extraid][pMaskID], PlayerInfo[extraid][pCellphone],
PlayerInfo[extraid][pCrimes], PlayerInfo[extraid][pArrest], PlayerInfo[extraid][pChanges], ustring,
ustring, PlayerInfo[extraid][pAdmName], extraid, extraid, PlayerInfo[extraid][pSex], PlayerInfo[extraid][pTut],
PlayerInfo[extraid][pCarTicket], extraid, extraid, extraid, extraid, extraid, ustring);
new ppname[24];
GetPlayerName(extraid, ppname, 24);
PlayerInfo[extraid][pCarTicket] = CMySQL_Int(ppname "Accounts", "Username", "CarTicket");
PlayerInfo[extraid][pTut] = CMySQL_Int(ppname, "Accounts", "Username", "Tutorial");
PlayerInfo[extraid][pSex] = CMySQL_Int(ppname, "Accounts", "Username", "Sex");
PlayerInfo[extraid][pChanges] = CMySQL_Int(ppname, "Accounts", "Username", "Changes");
strmid(PlayerInfo[extraid][pAdmName], CMySQL_Get(ppname, "Accounts", "Username", "AdmName"), 0, strlen(CMySQL_Get(ppname, "Accounts", "Username", "AdmName")), 255);
mysql_free_result();
OnLoginInit(extraid);
}
else
{
if(PlayerInfo[extraid][pWrongPassword] >= 5)
{
SendClientMessage(extraid,COLOR_LIGHTRED,"SERVER: You have been banned for entering the wrong password in five times.");
BanEx(extraid,"Wrong Password");
}
else
{
PlayerInfo[extraid][pWrongPassword]++;
SendClientMessage(extraid,COLOR_LIGHTRED,"SERVER: Invalid password.");
}
}
}
}
return 1;
}