spawn LAG
#1

I create a SQL RP script basis on The Godfather. But now have a big problem.

When player use /login commands. They will delayed for 3 ~ 4 seconds to spawn.

pawn Код:
public OnPlayerLogin(playerid,password[]) // by Luk0r v1.0
{
    MySQLCheckConnection();
    new tmp2[256];
  new string2[64];
    new playername2[MAX_PLAYER_NAME];
    //new playernamesplit[3][MAX_PLAYER_NAME];
  GetPlayerName(playerid, playername2, sizeof(playername2));
    //split(playername2, playernamesplit, '_');
    MySQLFetchAcctSingle(PlayerInfo[playerid][pSQLID], "Password", PlayerInfo[playerid][pKey]);
    if(strcmp(PlayerInfo[playerid][pKey],password, true ) == 0 )
    {
        new Data[1024];
        new Field[64];
        new rcnt = 1;
        MySQLFetchAcctRecord(PlayerInfo[playerid][pSQLID], Data);
        samp_mysql_strtok(Field, "|", Data);
        while (samp_mysql_strtok(Field, "|", "")==1)
        {
            // The rcnt values here represent the order of the columns in the characters table, so don't mess with them
            // If you add a column to the table, just add a new line with a +1 rcnt to the block below
            // Start it at 3 to skip the first few records we don't need (id, player name, password)
            if (rcnt == 3) PlayerInfo[playerid][pLevel] = strval(Field);
            if (rcnt == 4) PlayerInfo[playerid][pAdmin] = strval(Field);
            if (rcnt == 5) PlayerInfo[playerid][pDonateRank] = strval(Field);
            if (rcnt == 6) PlayerInfo[playerid][gPupgrade] = strval(Field);
            if (rcnt == 7) PlayerInfo[playerid][pConnectTime] = strval(Field);
            if (rcnt == 8) PlayerInfo[playerid][pReg] = strval(Field);
            if (rcnt == 9) PlayerInfo[playerid][pSex] = strval(Field);
            if (rcnt == 10) PlayerInfo[playerid][pAge] = strval(Field);
            if (rcnt == 11) PlayerInfo[playerid][pWalkStyle] = strval(Field);//新增欄位
            if (rcnt == 12) PlayerInfo[playerid][pFightStyle] = strval(Field);//新增欄位
            if (rcnt == 13) PlayerInfo[playerid][pWaterValue] = strval(Field);//新增欄位
            if (rcnt == 14) PlayerInfo[playerid][pOrigin] = strval(Field);
            if (rcnt == 15) PlayerInfo[playerid][pCK] = strval(Field);
            if (rcnt == 16) PlayerInfo[playerid][pMuted] = strval(Field);
            if (rcnt == 17) PlayerInfo[playerid][pExp] = strval(Field);
            if (rcnt == 18) PlayerInfo[playerid][pCash] = strval(Field);
            if (rcnt == 19) PlayerInfo[playerid][pAccount] = strval(Field);
            if (rcnt == 20) PlayerInfo[playerid][pCrimes] = strval(Field);
            if (rcnt == 21) WantedPoints[playerid] = strval(Field);//新增欄位
            if (rcnt == 22) PlayerInfo[playerid][pKills] = strval(Field);
            if (rcnt == 23) PlayerInfo[playerid][pDeaths] = strval(Field);
            if (rcnt == 24) PlayerInfo[playerid][pArrested] = strval(Field);
            if (rcnt == 25) PlayerInfo[playerid][pWantedDeaths] = strval(Field);
            if (rcnt == 26) PlayerInfo[playerid][pPhoneBook] = strval(Field);
            if (rcnt == 27) PlayerInfo[playerid][pLottoNr] = strval(Field);
            if (rcnt == 28) PlayerInfo[playerid][pFishes] = strval(Field);
            if (rcnt == 29) PlayerInfo[playerid][pBiggestFish] = strval(Field);
            if (rcnt == 30) PlayerInfo[playerid][pJob] = strval(Field);
            if (rcnt == 31) PlayerInfo[playerid][pPayCheck] = strval(Field);
            if (rcnt == 32) PlayerInfo[playerid][pHeadValue] = strval(Field);
            if (rcnt == 33) PlayerInfo[playerid][pJailed] = strval(Field);
            if (rcnt == 34) PlayerInfo[playerid][pJailTime] = strval(Field);
            if (rcnt == 35) PlayerInfo[playerid][pMats] = strval(Field);
            if (rcnt == 36) PlayerInfo[playerid][pDrugs] = strval(Field);
            if (rcnt == 37) PlayerInfo[playerid][pLeader] = strval(Field);
            if (rcnt == 38) PlayerInfo[playerid][pMember] = strval(Field);
            if (rcnt == 39) PlayerInfo[playerid][pFMember] = strval(Field);
            if (rcnt == 40) PlayerInfo[playerid][pSMember] = strval(Field);//新增欄位
            if (rcnt == 41) PlayerInfo[playerid][pRank] = strval(Field);
            if (rcnt == 42) PlayerInfo[playerid][pChar] = strval(Field);
            if (rcnt == 43) PlayerInfo[playerid][pContractTime] = strval(Field);
            if (rcnt == 44) PlayerInfo[playerid][pDetSkill] = strval(Field);
            if (rcnt == 45) PlayerInfo[playerid][pSexSkill] = strval(Field);
            if (rcnt == 46) PlayerInfo[playerid][pBoxSkill] = strval(Field);
            if (rcnt == 47) PlayerInfo[playerid][pLawSkill] = strval(Field);
            if (rcnt == 48) PlayerInfo[playerid][pMechSkill] = strval(Field);
            if (rcnt == 49) PlayerInfo[playerid][pJackSkill] = strval(Field);
            if (rcnt == 50) PlayerInfo[playerid][pCarSkill] = strval(Field);
            if (rcnt == 51) PlayerInfo[playerid][pNewsSkill] = strval(Field);
            if (rcnt == 52) PlayerInfo[playerid][pDrugsSkill] = strval(Field);
            if (rcnt == 53) PlayerInfo[playerid][pCookSkill] = strval(Field);
            if (rcnt == 54) PlayerInfo[playerid][pFishSkill] = strval(Field);
            if (rcnt == 55) PlayerInfo[playerid][pGunSkill] = strval(Field);//新增欄位
            if (rcnt == 56) PlayerInfo[playerid][pKeySkill] = strval(Field);//新增欄位
            if (rcnt == 57) PlayerInfo[playerid][pSHealth] = floatstr(Field);
            if (rcnt == 58) PlayerInfo[playerid][pHealth] = floatstr(Field);
            if (rcnt == 59) PlayerInfo[playerid][pVirWorld] = strval(Field);//新增欄位
            if (rcnt == 60) PlayerInfo[playerid][pInt] = strval(Field);
            if (rcnt == 61) PlayerInfo[playerid][pLocal] = strval(Field);
            if (rcnt == 62) PlayerInfo[playerid][pTeam] = strval(Field);
            if (rcnt == 63) PlayerInfo[playerid][pModel] = strval(Field);
            if (rcnt == 64) PlayerInfo[playerid][pPnumber] = strval(Field);
            if (rcnt == 65) PlayerInfo[playerid][pPhousekey] = strval(Field);
            if (rcnt == 66) PlayerInfo[playerid][pPcarkey] = strval(Field);
            if (rcnt == 67) PlayerInfo[playerid][pPcarkey2] = strval(Field);
            if (rcnt == 68) PlayerInfo[playerid][pPcarkey3] = strval(Field);
            if (rcnt == 69) PlayerInfo[playerid][pPbiskey] = strval(Field);
            if (rcnt == 70) PlayerInfo[playerid][pPos_x] = floatstr(Field);
            if (rcnt == 71) PlayerInfo[playerid][pPos_y] = floatstr(Field);
            if (rcnt == 72) PlayerInfo[playerid][pPos_z] = floatstr(Field);
            if (rcnt == 73) PlayerInfo[playerid][pCarLic] = strval(Field);
            if (rcnt == 74) PlayerInfo[playerid][pFlyLic] = strval(Field);
            if (rcnt == 75) PlayerInfo[playerid][pBoatLic] = strval(Field);
            if (rcnt == 76) PlayerInfo[playerid][pFishLic] = strval(Field);
            if (rcnt == 77) PlayerInfo[playerid][pGunLic] = strval(Field);
            if (rcnt == 78) PlayerInfo[playerid][pGun1] = strval(Field);
            if (rcnt == 79) PlayerInfo[playerid][pGun2] = strval(Field);
            if (rcnt == 80) PlayerInfo[playerid][pGun3] = strval(Field);
            if (rcnt == 81) PlayerInfo[playerid][pGun4] = strval(Field);
            if (rcnt == 82) PlayerInfo[playerid][pGun5] = strval(Field);//新增欄位
            if (rcnt == 83) PlayerInfo[playerid][pGun6] = strval(Field);//新增欄位
            if (rcnt == 84) PlayerInfo[playerid][pGun7] = strval(Field);//新增欄位
            if (rcnt == 85) PlayerInfo[playerid][pGun8] = strval(Field);//新增欄位
            if (rcnt == 86) PlayerInfo[playerid][pAmmo1] = strval(Field);
            if (rcnt == 87) PlayerInfo[playerid][pAmmo2] = strval(Field);
            if (rcnt == 88) PlayerInfo[playerid][pAmmo3] = strval(Field);
            if (rcnt == 89) PlayerInfo[playerid][pAmmo4] = strval(Field);
            if (rcnt == 90) PlayerInfo[playerid][pAmmo5] = strval(Field);//新增欄位
            if (rcnt == 91) PlayerInfo[playerid][pAmmo6] = strval(Field);//新增欄位
            if (rcnt == 92) PlayerInfo[playerid][pAmmo7] = strval(Field);//新增欄位
            if (rcnt == 93) PlayerInfo[playerid][pAmmo8] = strval(Field);//新增欄位
            if (rcnt == 94) PlayerInfo[playerid][pCarTime] = strval(Field);
            if (rcnt == 95) PlayerInfo[playerid][pPayDay] = strval(Field);
            if (rcnt == 96) PlayerInfo[playerid][pPayDayHad] = strval(Field);
            if (rcnt == 97) PlayerInfo[playerid][pWatch] = strval(Field);
            if (rcnt == 98) PlayerInfo[playerid][pFishTool] = strval(Field);//新增欄位
            if (rcnt == 99) PlayerInfo[playerid][pLighter] = strval(Field);//新增欄位
            if (rcnt == 100) PlayerInfo[playerid][pCigarettes] = strval(Field);//新增欄位
            if (rcnt == 101) PlayerInfo[playerid][pCDPlayer] = strval(Field);
            if (rcnt == 102) PlayerInfo[playerid][pCrashed] = strval(Field);//新增欄位
            if (rcnt == 103) PlayerInfo[playerid][pWins] = strval(Field);
            if (rcnt == 104) PlayerInfo[playerid][pLoses] = strval(Field);
            if (rcnt == 105) PlayerInfo[playerid][pAlcoholPerk] = strval(Field);
            if (rcnt == 106) PlayerInfo[playerid][pDrugPerk] = strval(Field);
            if (rcnt == 107) PlayerInfo[playerid][pMiserPerk] = strval(Field);
            if (rcnt == 108) PlayerInfo[playerid][pPainPerk] = strval(Field);
            if (rcnt == 109) PlayerInfo[playerid][pTraderPerk] = strval(Field);
            if (rcnt == 110) PlayerInfo[playerid][pTut] = strval(Field);
            if (rcnt == 111) PlayerInfo[playerid][pMissionNr] = strval(Field);
            if (rcnt == 112) PlayerInfo[playerid][pWarns] = strval(Field);
            if (rcnt == 113) PlayerInfo[playerid][pMarried] = strval(Field);
            if (rcnt == 114) PlayerInfo[playerid][pMarriedTo] = strmid(PlayerInfo[playerid][pMarriedTo], Field, 0, strlen(Field)-1, 255);
            if (rcnt == 115) PlayerInfo[playerid][pLocked] = strval(Field);
            if (rcnt == 116) PlayerInfo[playerid][pMail] = strval(Field);//新增欄位
            if (rcnt == 117) PlayerInfo[playerid][pForum] = strval(Field);//新增欄位
            rcnt++;
        }
        samp_mysql_free_result();
    }
    else
    {
        SendClientMessage(playerid, COLOR_WHITE, " password errol");
    //fclose(UserFile);
    gPlayerLogTries[playerid] += 1;
    if(gPlayerLogTries[playerid] == 4) { Ban(playerid); }
    return 1;
    }
    PlayerInfo[playerid][pAdjustable] = 0;
    ResetPlayerMoney(playerid);
    ConsumingMoney[playerid] = 1;
    GivePlayerMoney(playerid,PlayerInfo[playerid][pCash]);
    CurrentMoney[playerid] = PlayerInfo[playerid][pCash];
    if(PlayerInfo[playerid][pReg] == 0)
    {
        PlayerInfo[playerid][pLevel] = 1;
        PlayerInfo[playerid][pSHealth] = 0.0;
        PlayerInfo[playerid][pHealth] = 50.0;
        PlayerInfo[playerid][pPos_x] = 2246.6;
        PlayerInfo[playerid][pPos_y] = -1161.9;
        PlayerInfo[playerid][pPos_z] = 1029.7;
        PlayerInfo[playerid][pInt] = 15;
        PlayerInfo[playerid][pLocal] = 255;
        PlayerInfo[playerid][pTeam] = 3;
        PlayerInfo[playerid][pModel] = 264;
        new randphone = 1000 + random(8999);//minimum 1000 max 9999 //giving one at the start
        PlayerInfo[playerid][pPnumber] = randphone;
        PlayerInfo[playerid][pPhousekey] = 255;
        PlayerInfo[playerid][pPbiskey] = 255;
        PlayerInfo[playerid][pAccount] = 50000;
        PlayerInfo[playerid][pReg] = 1;
        GivePlayerMoney(playerid, 5000);
    }
    if(PlayerInfo[playerid][pLevel] == -999) //autoban
    {
        Ban(playerid);
    }
    else if(PlayerInfo[playerid][pCK] > 0)
    {
        Kick(playerid);
    }
        new ipaddress[16];
        GetPlayerIp(playerid,ipaddress,sizeof(ipaddress));
        MySQLAddLoginRecord(PlayerInfo[playerid][pSQLID], ipaddress);

        ClearChatbox(playerid, 8);
        SpawnPlayer(playerid);
        format(string2, sizeof(string2), "welcome %s ",playername2);
        SendClientMessage(playerid, COLOR_WHITE,string2);
        printf("%s has logged in.",playername2);
    if (PlayerInfo[playerid][pDonateRank] > 0)
    {
        SendClientMessage(playerid, COLOR_WHITE," you are vip now");
    }
    if (PlayerInfo[playerid][pAdmin] > 0)
    {
        format(string2, sizeof(string2), " you are %d admin",PlayerInfo[playerid][pAdmin]);
        SendClientMessage(playerid, COLOR_WHITE,string2);
    }
    if(gTeam[playerid] == 0)
    {
        gTeam[playerid] = 3;
    }
    else
    {
        gTeam[playerid] = PlayerInfo[playerid][pTeam];
    }
    gPlayerLogged[playerid] = 1;
    format(tmp2, sizeof(tmp2), "~w~Welcome ~n~~y~  %s", playername2);
    DateProp(playerid);
    GameTextForPlayer(playerid, tmp2, 5000, 1);
    SendClientMessage(playerid, COLOR_YELLOW, motd);
    if(PlayerInfo[playerid][pFMember] < 255)
    {
      format(tmp2, sizeof(tmp2), " motd: %s.", FamilyInfo[PlayerInfo[playerid][pFMember]][FamilyMOTD]);
      SendClientMessage(playerid, COLOR_YELLOW, tmp2);
    }
    return 1;
}
How fix it ?
Reply


Forum Jump:


Users browsing this thread: 1 Guest(s)