1. SA-MP Forums Archive
  2. SA-MP Scripting and Plugins
  3. Scripting Help

Threaded Mode
In the middle of loading the player data the script stops.
Stefand
Gangsta
*****
Posts: 772
Threads: 223
Joined: Sep 2011
Reputation: 0
#1

29.01.2014, 15:28
Hello Community!

I am having an issue with my loading player data.
I recently switched from BLUE G to Strickenkid to have more usefull functions (DO NOT REPLY WITH "CHANGE BACK" Because I won't change back.)

pawn Код:
LoadPlayerData(playerid)
{
    clearPlayerChat(playerid);
    new Data[2048],Field[258],idx;
    mysql_queryS("SELECT * FROM `Accounts` WHERE `Username` = '%s'", GetName(playerid));
    mysql_store_result();
    if(mysql_num_rows() == 1){
        mysql_fetch_rowEx(Data);
        Field = strtuk( Data, idx, '|' );
        for(new s = 0; s < 120; s++)
        {
            switch(s)
            {
                case 0: Player[playerid][UserID] = strval(Field);
                case 2: strmid(Player[playerid][Password],Field,0,strlen(Field),129);
                case 3: strmid(Player[playerid][LastIP],Field,0,strlen(Field),26);
                case 4: Player[playerid][Adminlevel] = strval(Field);
                case 5: Player[playerid][Money] = strval(Field);
                case 6: Player[playerid][RegTime] = strval(Field);
                case 7: Player[playerid][LastOn] = strval(Field);
                case 8: Player[playerid][Level] = strval(Field);
                case 9: Player[playerid][Gender] = strval(Field);
                case 10: Player[playerid][Age] = strval(Field);
                case 11: Player[playerid][Health] = floatstr(Field);
                case 12: Player[playerid][Armour] = floatstr(Field);
                case 13: Player[playerid][Skin] = strval(Field);
                case 14: strmid(Player[playerid][Country],Field,0,strlen(Field),255);
                case 15: Player[playerid][Test] = strval(Field);
                case 16: Player[playerid][Faction] = strval(Field);
                case 17: Player[playerid][FactionRank] = strval(Field);
                case 18: strmid(Player[playerid][FactionRankName],Field,0,strlen(Field),255);
                case 19: Player[playerid][PrisonSelect] = strval(Field);
                case 20: Player[playerid][PrisonTime] = strval(Field);
                case 21: Player[playerid][AdminPrisonCount] = strval(Field);
                case 22: Player[playerid][SecondsLoggedIn] = strval(Field);
                case 23: Player[playerid][PlayingHours] = strval(Field);
                case 24: Player[playerid][AdminCode] = strval(Field);
                case 25: Player[playerid][PhoneN] = strval(Field);
                case 26: Player[playerid][PhoneCredit] = strval(Field);
                case 27: Player[playerid][PhoneBook] = strval(Field);
                case 28: Player[playerid][House] = strval(Field);
                case 29: Player[playerid][Hotel] = strval(Field);
                case 30: Player[playerid][Hospitalized] = strval(Field);
                case 31: Player[playerid][OnDuty] = strval(Field);
                case 32: Player[playerid][DutyClothes] = strval(Field);
                case 33: Player[playerid][LastSkin] = strval(Field);
                case 34: Player[playerid][LastX] = floatstr(Field);
                case 35: Player[playerid][LastY] = floatstr(Field);
                case 36: Player[playerid][LastZ] = floatstr(Field);
                case 37: Player[playerid][LastA] = floatstr(Field);
                case 38: Player[playerid][LastInt] = strval(Field);
                case 39: Player[playerid][LastWorld] = strval(Field);
                case 40: Player[playerid][InFactionHQ] = strval(Field);
                case 41: Player[playerid][InHouse] = strval(Field);
                case 42: Player[playerid][Helper] = strval(Field);
                case 43: Player[playerid][Moderator] = strval(Field);
                case 44: strmid(Player[playerid][BankPincode],Field,0,strlen(Field),5);
                case 45: Player[playerid][BankNumber] = strval(Field);
                case 46: Player[playerid][BankMoney] = strval(Field);
                case 47: Player[playerid][ExperiencePoints] = strval(Field);
                case 48: Player[playerid][ExperiencePointsNeeded] = strval(Field);
                case 49: Player[playerid][Coins] = strval(Field);
                case 50: Player[playerid][WalkieTalkie] = strval(Field);
                case 51: Player[playerid][WalkieFrequency] = strval(Field);
                case 52: Player[playerid][HasMask] = strval(Field);
                case 53: Player[playerid][Banned] = strval(Field);
                case 54: Player[playerid][Bans] = strval(Field);
                case 55: Player[playerid][Kicks] = strval(Field);
                case 56: Player[playerid][WeaponSlot0] = strval(Field);
                case 57: Player[playerid][WeaponSlot1] = strval(Field);
                case 58: Player[playerid][WeaponSlot2] = strval(Field);
                case 59: Player[playerid][WeaponSlot3] = strval(Field);
                case 60: Player[playerid][WeaponSlot4] = strval(Field);
                case 61: Player[playerid][WeaponSlot5] = strval(Field);
                case 62: Player[playerid][WeaponSlot6] = strval(Field);
                case 63: Player[playerid][WeaponSlot7] = strval(Field);
                case 64: Player[playerid][WeaponSlot8] = strval(Field);
                case 65: Player[playerid][WeaponSlot9] = strval(Field);
                case 66: Player[playerid][WeaponSlot10] = strval(Field);
                case 67: Player[playerid][WeaponSlot11] = strval(Field);
                case 68: Player[playerid][WeaponSlot0Ammo] = strval(Field);
                case 69: Player[playerid][WeaponSlot1Ammo] = strval(Field);
                case 70: Player[playerid][WeaponSlot2Ammo] = strval(Field);
                case 71: Player[playerid][WeaponSlot3Ammo] = strval(Field);
                case 72: Player[playerid][WeaponSlot4Ammo] = strval(Field);
                case 73: Player[playerid][WeaponSlot5Ammo] = strval(Field);
                case 74: Player[playerid][WeaponSlot6Ammo] = strval(Field);
                case 75: Player[playerid][WeaponSlot7Ammo] = strval(Field);
                case 76: Player[playerid][WeaponSlot8Ammo] = strval(Field);
                case 77: Player[playerid][WeaponSlot9Ammo] = strval(Field);
                case 78: Player[playerid][WeaponSlot10Ammo] = strval(Field);
                case 79: Player[playerid][WeaponSlot11Ammo] = strval(Field);
                case 80: Player[playerid][DutyWeaponSlot0] = strval(Field);
                case 81: Player[playerid][DutyWeaponSlot1] = strval(Field);
                case 82: Player[playerid][DutyWeaponSlot2] = strval(Field);
                case 83: Player[playerid][DutyWeaponSlot3] = strval(Field);
                case 84: Player[playerid][DutyWeaponSlot4] = strval(Field);
                case 85: Player[playerid][DutyWeaponSlot5] = strval(Field);
                case 86: Player[playerid][DutyWeaponSlot6] = strval(Field);
                case 87: Player[playerid][DutyWeaponSlot7] = strval(Field);
                case 88: Player[playerid][DutyWeaponSlot8] = strval(Field);
                case 89: Player[playerid][DutyWeaponSlot9] = strval(Field);
                case 90: Player[playerid][DutyWeaponSlot10] = strval(Field);
                case 91: Player[playerid][DutyWeaponSlot11] = strval(Field);
                case 92: Player[playerid][DutyWeaponSlot0Ammo] = strval(Field);
                case 93: Player[playerid][DutyWeaponSlot1Ammo] = strval(Field);
                case 94: Player[playerid][DutyWeaponSlot2Ammo] = strval(Field);
                case 95: Player[playerid][DutyWeaponSlot3Ammo] = strval(Field);
                case 96: Player[playerid][DutyWeaponSlot4Ammo] = strval(Field);
                case 97: Player[playerid][DutyWeaponSlot5Ammo] = strval(Field);
                case 98: Player[playerid][DutyWeaponSlot6Ammo] = strval(Field);
                case 99: Player[playerid][DutyWeaponSlot7Ammo] = strval(Field);
                case 100: Player[playerid][DutyWeaponSlot8Ammo] = strval(Field);
                case 101: Player[playerid][DutyWeaponSlot9Ammo] = strval(Field);
                case 102: Player[playerid][DutyWeaponSlot10Ammo] = strval(Field);
                case 103: Player[playerid][DutyWeaponSlot11Ammo] = strval(Field);
                case 104: Player[playerid][AntiCheatExemption] = strval(Field);
                case 105: strmid(Player[playerid][Email],Field,0,strlen(Field),255);
                case 106: Player[playerid][Warns] = strval(Field);
                case 107: Player[playerid][Badge] = strval(Field);
                case 110: strmid(Player[playerid][SecretWord],Field,0,strlen(Field),255);
                case 111: Player[playerid][DisconnectReason] = strval(Field);
                case 112: Player[playerid][Business] = strval(Field);
                case 113: Player[playerid][FightStyle] = strval(Field);
            }
            Field = strtuk( Data, idx, '|' );
        }
        //here it stops
        clearPlayerChat(playerid);
        SPD(playerid, DIALOG_AUTHENTICATION);
        TextDrawHideForPlayer(playerid, Text:LoadingTD);
        mysql_free_result();
    }else if(mysql_num_rows() == 0){
        clearPlayerChat(playerid);
        new playernamesplit[3][MAX_PLAYER_NAME], Name[MAX_PLAYER_NAME];
        GetPlayerName(playerid, Name, sizeof(Name));
        split(Name, playernamesplit, '_');

        if (!strlen(playernamesplit[0]) || !strlen(playernamesplit[1]))
        {
            KickWithMessage(playerid, COLOR_WHITE, "Unfortunately, your name is not in the proper format! Please use the format of "#COL_EMB_LIGHTBLUE"\"Firstname_Lastname\""#COL_EMB_WHITE".");
        }
        else
        {
            SPD(playerid, DIALOG_REGISTER);
            TextDrawHideForPlayer(playerid, Text:LoadingTD);
        }
    }else{
        clearPlayerChat(playerid);
        KickWithMessage(playerid, COLOR_WHITE, "There was a "#COL_EMB_RED"fatal error "#COL_EMB_WHITE"during registration! Please contact a developer.");
    }
}
And I also get this:

Код:
Pawn compiler 3.2.3664	 	 	Copyright © 1997-2006, ITB CompuPhase

Header size:          14752 bytes
Code size:          1542336 bytes
Data size:          6922932 bytes
Stack/heap size:      16384 bytes; estimated max. usage: unknown, due to recursion
Total requirements: 8496404 bytes
If someone would be so kind to help me here, or over teamviewer please contact me on St3fan[NL] @ Skype
Find
Reply
mamorunl
High-roller
*****
Posts: 1,938
Threads: 16
Joined: Feb 2007
Reputation: 0
#2

29.01.2014, 15:50
Are you sure it doesn't stop at the row before it? Or does it clear the chat and THEN do nothing?
Find
Reply
Stefand
Gangsta
*****
Posts: 772
Threads: 223
Joined: Sep 2011
Reputation: 0
#3

29.01.2014, 15:59
I tested it with Print("Checkpoint #/#); and it stopped before the clear chat.
Find
Reply
« Next Oldest | Next Newest »


Forum Jump:


Users browsing this thread: 3 Guest(s)
  1. SA-MP Forums Archive
  2. SA-MP Scripting and Plugins
  3. Scripting Help