enrico34
Дебютант
Добрый вечер. При переводе сервера возникла проблемка с логином, переменных сильно много и в одном паблике они не уживаются. Разделил на два, но проблема, второй паблик при считывание начинает читать переменные сначала, и присваевает эти же значения другим переменным по второму кругу.Надо бы сделать чтоб второй начинал читать то не с начала. Вот паблики:
public OnPlayerLogin(playerid,password[])
{
if(IsPlayerNPC(playerid)) return 1;
//new sp[256];
new playername2[MAX_PLAYER_NAME];
GetPlayerName(playerid, playername2, sizeof(playername2));
new Query[256];
new Pname[24];
GetPlayerName(playerid, Pname, 24);
new escname[24];
mysql_real_escape_string(Pname, escname);
format(Query, sizeof(Query), "SELECT * FROM `users` WHERE `username` = '%s' AND `password` = '%s'", escname, password);
mysql_query(Query);
mysql_store_result();
new Result[512];
if(mysql_fetch_row(Result))
{
new EscapeName[MAX_PLAYER_NAME], Namess[MAX_PLAYER_NAME], u,n[MAX_PLAYER_NAME],k;
GetPlayerName(playerid, Namess, sizeof(Namess));
mysql_real_escape_string(Namess, EscapeName);
format(Query, sizeof(Query), "SELECT * FROM users WHERE username = '%s'", EscapeName);
mysql_query(Query);
mysql_store_result();
mysql_fetch_row_format(Result, "|");
sscanf(Result, "p<|>ds[32]s[32]ddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddd[32]",
u,n,k,
PlayerInfo[playerid][pBanned],
PlayerInfo[playerid][pCourierSkill],
PlayerInfo[playerid][pRDrugsSkill],
PlayerInfo[playerid][pPhousekey],
PlayerInfo[playerid][pPbiskey],
PlayerInfo[playerid][pBoatLic],
PlayerInfo[playerid][pMotoLic],
PlayerInfo[playerid][pAmmo2],
PlayerInfo[playerid][pAmmo3],
PlayerInfo[playerid][pAmmo4],
PlayerInfo[playerid][pPayDay],
PlayerInfo[playerid][pPayDayHad],
PlayerInfo[playerid][pCDPlayer],
PlayerInfo[playerid][pWins],
PlayerInfo[playerid][pLoses],
PlayerInfo[playerid][pAlcoholPerk],
PlayerInfo[playerid][pDrugPerk],
PlayerInfo[playerid][pMiserPerk],
PlayerInfo[playerid][pPainPerk],
PlayerInfo[playerid][pTraderPerk],
PlayerInfo[playerid][pTut],
PlayerInfo[playerid][pRent],
PlayerInfo[playerid][pWarns],
PlayerInfo[playerid][ptMoney],
PlayerInfo[playerid][ptMats],
PlayerInfo[playerid][ptDrugs],
PlayerInfo[playerid][pAdjustable],
PlayerInfo[playerid][pFuel],
PlayerInfo[playerid][pMarried],
PlayerInfo[playerid][pMarriedTo],
PlayerInfo[playerid][pWanted],
PlayerInfo[playerid][pPlant],
PlayerInfo[playerid][pTrava],
PlayerInfo[playerid][pChest],
PlayerInfo[playerid][pFWarns],
PlayerInfo[playerid][pMedicaments],
PlayerInfo[playerid][pCarKey],
PlayerInfo[playerid][pCarKeyt],
PlayerInfo[playerid][pPadarok],
PlayerInfo[playerid][pRadio],
PlayerInfo[playerid][pTestTime],
PlayerInfo[playerid][pMuted],
PlayerInfo[playerid][pMutedTime],
PlayerInfo[playerid][pReport],
PlayerInfo[playerid][pReportTimer],
PlayerInfo[playerid][pOtvertka],
PlayerInfo[playerid][pBankTimer],
PlayerInfo[playerid][pElektro],
PlayerInfo[playerid][pElektroTimer],
PlayerInfo[playerid][pAdmLog],
PlayerInfo[playerid][pKnockout],
PlayerInfo[playerid][pBankMoney],
PlayerInfo[playerid][pNonrp],
PlayerInfo[playerid][pAdminParol],
PlayerInfo[playerid][pJetPack],
PlayerInfo[playerid][pBanData],
PlayerInfo[playerid][pBanTime],
PlayerInfo[playerid][pBan],
PlayerInfo[playerid][pCreditData],
PlayerInfo[playerid][pCreditTime],
PlayerInfo[playerid][pCreditMoney],
PlayerInfo[playerid][pCredit],
PlayerInfo[playerid][pVigovor],
PlayerInfo[playerid][pOtkatBank],
PlayerInfo[playerid][pEkzRus],
PlayerInfo[playerid][pEkzIst],
PlayerInfo[playerid][pEkzEko],
PlayerInfo[playerid][pEkzObs],
PlayerInfo[playerid][pEkzMat],
PlayerInfo[playerid][pDiplom],
PlayerInfo[playerid][pGarage],
PlayerInfo[playerid][pBonus],
PlayerInfo[playerid][pOtkatmem],
PlayerInfo[playerid][pOtkatSMS],
PlayerInfo[playerid][pKredita],
CreditTimer[playerid],
PlayerInfo[playerid][pPnumber],
PlayerInfo[playerid][pCarTime],
PlayerInfo[playerid][pExp],
HospitalTime[playerid],
PlayerInfo[playerid][pOtkatGruz]);
mysql_free_result();
}
return 1;
}
public OnPlayerLogin2(playerid,password[])
{
if(IsPlayerNPC(playerid)) return 1;
new string2[256]; //new sp[256];
new playername2[MAX_PLAYER_NAME];
GetPlayerName(playerid, playername2, sizeof(playername2));
new Query[256];
new Pname[24];
GetPlayerName(playerid, Pname, 24);
new escname[24];
mysql_real_escape_string(Pname, escname);
format(Query, sizeof(Query), "SELECT * FROM `users` WHERE `username` = '%s' AND `password` = '%s'", escname, password);
mysql_query(Query);
mysql_store_result();
new Result[512];
if(mysql_fetch_row(Result))
{
new EscapeName[MAX_PLAYER_NAME], Namess[MAX_PLAYER_NAME], u,n[MAX_PLAYER_NAME],k;
GetPlayerName(playerid, Namess, sizeof(Namess));
mysql_real_escape_string(Namess, EscapeName);
format(Query, sizeof(Query), "SELECT * FROM users WHERE username = '%s'", EscapeName);
mysql_query(Query);
mysql_store_result();
mysql_fetch_row_format(Result, "|");
sscanf(Result, "p<|>ds[32]s[32]ddddddddddddddddddddddddddddddddddddddddddddffddddddfffdddddddddd[32]",
u,n,k,
PlayerInfo[playerid][pLevel],
PlayerInfo[playerid][pAdmin],
PlayerInfo[playerid][pDonateRank],
PlayerInfo[playerid][gPupgrade],
PlayerInfo[playerid][pConnectTime],
PlayerInfo[playerid][pReg],
PlayerInfo[playerid][pSex],
PlayerInfo[playerid][pAge],
PlayerInfo[playerid][pOrigin],
PlayerInfo[playerid][pMuted],
PlayerInfo[playerid][pExp],
PlayerInfo[playerid][pMoney],
PlayerInfo[playerid][pAccount],
PlayerInfo[playerid][pCrimes],
PlayerInfo[playerid][pDeaths],
PlayerInfo[playerid][pArrested],
PlayerInfo[playerid][pWantedDeaths],
PlayerInfo[playerid][pPhoneBook],
PlayerInfo[playerid][pLottoNr],
PlayerInfo[playerid][pFishes],
PlayerInfo[playerid][pBiggestFish],
PlayerInfo[playerid][pJob],
PlayerInfo[playerid][pPayCheck],
PlayerInfo[playerid][pHeadValue],
PlayerInfo[playerid][pJailed],
PlayerInfo[playerid][pJailTime],
PlayerInfo[playerid][pMats],
PlayerInfo[playerid][pDrugs],
PlayerInfo[playerid][pLeader],
PlayerInfo[playerid][pMember],
PlayerInfo[playerid][pRank],
PlayerInfo[playerid][pChar],
PlayerInfo[playerid][pContractTime],
PlayerInfo[playerid][pDetSkill],
PlayerInfo[playerid][pSexSkill],
PlayerInfo[playerid][pBoxSkill],
PlayerInfo[playerid][pLawSkill],
PlayerInfo[playerid][pMechSkill],
PlayerInfo[playerid][pJackSkill],
PlayerInfo[playerid][pCarSkill],
PlayerInfo[playerid][pNewsSkill],
PlayerInfo[playerid][pDrugsSkill],
PlayerInfo[playerid][pCookSkill],
PlayerInfo[playerid][pFishSkill],
PlayerInfo[playerid][pHealth],
PlayerInfo[playerid][pSHealth],
PlayerInfo[playerid][pInt],
PlayerInfo[playerid][pLocal],
PlayerInfo[playerid][pTeam],
PlayerInfo[playerid][pPnumber],
PlayerInfo[playerid][pPhousekey],
PlayerInfo[playerid][pPbiskey],
PlayerInfo[playerid][pPos_x],
PlayerInfo[playerid][pPos_y],
PlayerInfo[playerid][pPos_z],
PlayerInfo[playerid][pCarLic],
PlayerInfo[playerid][pFlyLic],
PlayerInfo[playerid][pFishLic],
PlayerInfo[playerid][pGunLic],
PlayerInfo[playerid][pGun1],
PlayerInfo[playerid][pGun2],
PlayerInfo[playerid][pGun3],
PlayerInfo[playerid][pGun4],
PlayerInfo[playerid][pAmmo1],
PlayerInfo[playerid][pHelper]);
mysql_free_result();
}
public OnPlayerLogin(playerid,password[])
{
if(IsPlayerNPC(playerid)) return 1;
//new sp[256];
new playername2[MAX_PLAYER_NAME];
GetPlayerName(playerid, playername2, sizeof(playername2));
new Query[256];
new Pname[24];
GetPlayerName(playerid, Pname, 24);
new escname[24];
mysql_real_escape_string(Pname, escname);
format(Query, sizeof(Query), "SELECT * FROM `users` WHERE `username` = '%s' AND `password` = '%s'", escname, password);
mysql_query(Query);
mysql_store_result();
new Result[512];
if(mysql_fetch_row(Result))
{
new EscapeName[MAX_PLAYER_NAME], Namess[MAX_PLAYER_NAME], u,n[MAX_PLAYER_NAME],k;
GetPlayerName(playerid, Namess, sizeof(Namess));
mysql_real_escape_string(Namess, EscapeName);
format(Query, sizeof(Query), "SELECT * FROM users WHERE username = '%s'", EscapeName);
mysql_query(Query);
mysql_store_result();
mysql_fetch_row_format(Result, "|");
sscanf(Result, "p<|>ds[32]s[32]ddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddd[32]",
u,n,k,
PlayerInfo[playerid][pBanned],
PlayerInfo[playerid][pCourierSkill],
PlayerInfo[playerid][pRDrugsSkill],
PlayerInfo[playerid][pPhousekey],
PlayerInfo[playerid][pPbiskey],
PlayerInfo[playerid][pBoatLic],
PlayerInfo[playerid][pMotoLic],
PlayerInfo[playerid][pAmmo2],
PlayerInfo[playerid][pAmmo3],
PlayerInfo[playerid][pAmmo4],
PlayerInfo[playerid][pPayDay],
PlayerInfo[playerid][pPayDayHad],
PlayerInfo[playerid][pCDPlayer],
PlayerInfo[playerid][pWins],
PlayerInfo[playerid][pLoses],
PlayerInfo[playerid][pAlcoholPerk],
PlayerInfo[playerid][pDrugPerk],
PlayerInfo[playerid][pMiserPerk],
PlayerInfo[playerid][pPainPerk],
PlayerInfo[playerid][pTraderPerk],
PlayerInfo[playerid][pTut],
PlayerInfo[playerid][pRent],
PlayerInfo[playerid][pWarns],
PlayerInfo[playerid][ptMoney],
PlayerInfo[playerid][ptMats],
PlayerInfo[playerid][ptDrugs],
PlayerInfo[playerid][pAdjustable],
PlayerInfo[playerid][pFuel],
PlayerInfo[playerid][pMarried],
PlayerInfo[playerid][pMarriedTo],
PlayerInfo[playerid][pWanted],
PlayerInfo[playerid][pPlant],
PlayerInfo[playerid][pTrava],
PlayerInfo[playerid][pChest],
PlayerInfo[playerid][pFWarns],
PlayerInfo[playerid][pMedicaments],
PlayerInfo[playerid][pCarKey],
PlayerInfo[playerid][pCarKeyt],
PlayerInfo[playerid][pPadarok],
PlayerInfo[playerid][pRadio],
PlayerInfo[playerid][pTestTime],
PlayerInfo[playerid][pMuted],
PlayerInfo[playerid][pMutedTime],
PlayerInfo[playerid][pReport],
PlayerInfo[playerid][pReportTimer],
PlayerInfo[playerid][pOtvertka],
PlayerInfo[playerid][pBankTimer],
PlayerInfo[playerid][pElektro],
PlayerInfo[playerid][pElektroTimer],
PlayerInfo[playerid][pAdmLog],
PlayerInfo[playerid][pKnockout],
PlayerInfo[playerid][pBankMoney],
PlayerInfo[playerid][pNonrp],
PlayerInfo[playerid][pAdminParol],
PlayerInfo[playerid][pJetPack],
PlayerInfo[playerid][pBanData],
PlayerInfo[playerid][pBanTime],
PlayerInfo[playerid][pBan],
PlayerInfo[playerid][pCreditData],
PlayerInfo[playerid][pCreditTime],
PlayerInfo[playerid][pCreditMoney],
PlayerInfo[playerid][pCredit],
PlayerInfo[playerid][pVigovor],
PlayerInfo[playerid][pOtkatBank],
PlayerInfo[playerid][pEkzRus],
PlayerInfo[playerid][pEkzIst],
PlayerInfo[playerid][pEkzEko],
PlayerInfo[playerid][pEkzObs],
PlayerInfo[playerid][pEkzMat],
PlayerInfo[playerid][pDiplom],
PlayerInfo[playerid][pGarage],
PlayerInfo[playerid][pBonus],
PlayerInfo[playerid][pOtkatmem],
PlayerInfo[playerid][pOtkatSMS],
PlayerInfo[playerid][pKredita],
CreditTimer[playerid],
PlayerInfo[playerid][pPnumber],
PlayerInfo[playerid][pCarTime],
PlayerInfo[playerid][pExp],
HospitalTime[playerid],
PlayerInfo[playerid][pOtkatGruz]);
mysql_free_result();
}
return 1;
}
public OnPlayerLogin2(playerid,password[])
{
if(IsPlayerNPC(playerid)) return 1;
new string2[256]; //new sp[256];
new playername2[MAX_PLAYER_NAME];
GetPlayerName(playerid, playername2, sizeof(playername2));
new Query[256];
new Pname[24];
GetPlayerName(playerid, Pname, 24);
new escname[24];
mysql_real_escape_string(Pname, escname);
format(Query, sizeof(Query), "SELECT * FROM `users` WHERE `username` = '%s' AND `password` = '%s'", escname, password);
mysql_query(Query);
mysql_store_result();
new Result[512];
if(mysql_fetch_row(Result))
{
new EscapeName[MAX_PLAYER_NAME], Namess[MAX_PLAYER_NAME], u,n[MAX_PLAYER_NAME],k;
GetPlayerName(playerid, Namess, sizeof(Namess));
mysql_real_escape_string(Namess, EscapeName);
format(Query, sizeof(Query), "SELECT * FROM users WHERE username = '%s'", EscapeName);
mysql_query(Query);
mysql_store_result();
mysql_fetch_row_format(Result, "|");
sscanf(Result, "p<|>ds[32]s[32]ddddddddddddddddddddddddddddddddddddddddddddffddddddfffdddddddddd[32]",
u,n,k,
PlayerInfo[playerid][pLevel],
PlayerInfo[playerid][pAdmin],
PlayerInfo[playerid][pDonateRank],
PlayerInfo[playerid][gPupgrade],
PlayerInfo[playerid][pConnectTime],
PlayerInfo[playerid][pReg],
PlayerInfo[playerid][pSex],
PlayerInfo[playerid][pAge],
PlayerInfo[playerid][pOrigin],
PlayerInfo[playerid][pMuted],
PlayerInfo[playerid][pExp],
PlayerInfo[playerid][pMoney],
PlayerInfo[playerid][pAccount],
PlayerInfo[playerid][pCrimes],
PlayerInfo[playerid][pDeaths],
PlayerInfo[playerid][pArrested],
PlayerInfo[playerid][pWantedDeaths],
PlayerInfo[playerid][pPhoneBook],
PlayerInfo[playerid][pLottoNr],
PlayerInfo[playerid][pFishes],
PlayerInfo[playerid][pBiggestFish],
PlayerInfo[playerid][pJob],
PlayerInfo[playerid][pPayCheck],
PlayerInfo[playerid][pHeadValue],
PlayerInfo[playerid][pJailed],
PlayerInfo[playerid][pJailTime],
PlayerInfo[playerid][pMats],
PlayerInfo[playerid][pDrugs],
PlayerInfo[playerid][pLeader],
PlayerInfo[playerid][pMember],
PlayerInfo[playerid][pRank],
PlayerInfo[playerid][pChar],
PlayerInfo[playerid][pContractTime],
PlayerInfo[playerid][pDetSkill],
PlayerInfo[playerid][pSexSkill],
PlayerInfo[playerid][pBoxSkill],
PlayerInfo[playerid][pLawSkill],
PlayerInfo[playerid][pMechSkill],
PlayerInfo[playerid][pJackSkill],
PlayerInfo[playerid][pCarSkill],
PlayerInfo[playerid][pNewsSkill],
PlayerInfo[playerid][pDrugsSkill],
PlayerInfo[playerid][pCookSkill],
PlayerInfo[playerid][pFishSkill],
PlayerInfo[playerid][pHealth],
PlayerInfo[playerid][pSHealth],
PlayerInfo[playerid][pInt],
PlayerInfo[playerid][pLocal],
PlayerInfo[playerid][pTeam],
PlayerInfo[playerid][pPnumber],
PlayerInfo[playerid][pPhousekey],
PlayerInfo[playerid][pPbiskey],
PlayerInfo[playerid][pPos_x],
PlayerInfo[playerid][pPos_y],
PlayerInfo[playerid][pPos_z],
PlayerInfo[playerid][pCarLic],
PlayerInfo[playerid][pFlyLic],
PlayerInfo[playerid][pFishLic],
PlayerInfo[playerid][pGunLic],
PlayerInfo[playerid][pGun1],
PlayerInfo[playerid][pGun2],
PlayerInfo[playerid][pGun3],
PlayerInfo[playerid][pGun4],
PlayerInfo[playerid][pAmmo1],
PlayerInfo[playerid][pHelper]);
mysql_free_result();
}