[iGetty]

I have this:

pawn Код:

format(query, sizeof(query), "SELECT Money, Level, AdminLevel, Faction, FactionRank, RegistrationStep, BirthDay, BirthMonth, BirthYear, SpawnPoint, TutorialComplete, HelperLevel, Accent, MinutesPlayed, AchievementPoints, ExperiencePoints, DonatorLevel, Deaths, Kills, Clothes1, Clothes2, Clothes3, ClothesUsed, CarLicense, HouseKey, Business1Key, Business2Key, Banned, BanReason, BannedBy, Radio, RadioWave, SubRank, CellPhone, CellPhoneNumber, Job FROM Accounts WHERE Username = '%s'", pname);
    mysql_query(query);
    mysql_store_result();
    while(mysql_fetch_row_format(query,"|"))
    {
        mysql_fetch_field_row(savingstring, "Money"); Player[playerid][Money] = strval(savingstring);
        mysql_fetch_field_row(savingstring, "Level"); Player[playerid][Level] = strval(savingstring);
        mysql_fetch_field_row(savingstring, "AdminLevel"); Player[playerid][AdminLevel] = strval(savingstring);
        mysql_fetch_field_row(savingstring, "Faction"); Player[playerid][Faction] = strval(savingstring);
        mysql_fetch_field_row(savingstring, "FactionRank"); Player[playerid][FactionRank] = strval(savingstring);
        mysql_fetch_field_row(savingstring, "RegistrationStep"); Player[playerid][RegistrationStep] = strval(savingstring);
        mysql_fetch_field_row(savingstring, "BirthDay"); Player[playerid][BirthDay] = strval(savingstring);
        mysql_fetch_field_row(savingstring, "BirthMonth"); Player[playerid][BirthMonth] = strval(savingstring);
        mysql_fetch_field_row(savingstring, "BirthYear"); Player[playerid][BirthYear] = strval(savingstring);
        mysql_fetch_field_row(savingstring, "SpawnPoint"); Player[playerid][SpawnPoint] = strval(savingstring);
        mysql_fetch_field_row(savingstring, "TutorialComplete"); Player[playerid][TutorialComplete] = strval(savingstring);
        mysql_fetch_field_row(savingstring, "HelperLevel"); Player[playerid][HelperLevel] = strval(savingstring);
        mysql_fetch_field_row(savingstring, "Accent"); strmid(Player[playerid][Accent], savingstring, 0, strlen(savingstring), 20);
        mysql_fetch_field_row(savingstring, "MinutesPlayed"); Player[playerid][MinutesPlayed] = strval(savingstring);
        mysql_fetch_field_row(savingstring, "AchievementPoints"); Player[playerid][AchievementPoints] = strval(savingstring);
        mysql_fetch_field_row(savingstring, "ExperiencePoints"); Player[playerid][ExperiencePoints] = strval(savingstring);
        mysql_fetch_field_row(savingstring, "DonatorLevel"); Player[playerid][DonatorLevel] = strval(savingstring);
        mysql_fetch_field_row(savingstring, "Deaths"); Player[playerid][Deaths] = strval(savingstring);
        mysql_fetch_field_row(savingstring, "Kills"); Player[playerid][Kills] = strval(savingstring);
        mysql_fetch_field_row(savingstring, "Clothes1"); Player[playerid][Clothes1] = strval(savingstring);
        mysql_fetch_field_row(savingstring, "Clothes2"); Player[playerid][Clothes2] = strval(savingstring);
        mysql_fetch_field_row(savingstring, "Clothes3"); Player[playerid][Clothes3] = strval(savingstring);
        mysql_fetch_field_row(savingstring, "ClothesUsed"); Player[playerid][ClothesUsed] = strval(savingstring);
        mysql_fetch_field_row(savingstring, "CarLicense"); Player[playerid][CarLicense] = strval(savingstring);
        mysql_fetch_field_row(savingstring, "HouseKey"); Player[playerid][HouseKey] = strval(savingstring);
        mysql_fetch_field_row(savingstring, "Business1Key"); Player[playerid][Business1Key] = strval(savingstring);
        mysql_fetch_field_row(savingstring, "Business2Key"); Player[playerid][Business2Key] = strval(savingstring);
        mysql_fetch_field_row(savingstring, "Banned"); Player[playerid][Banned] = strval(savingstring);
        mysql_fetch_field_row(savingstring, "BanReason"); strmid(Player[playerid][BanReason], savingstring, 0, strlen(savingstring), 128);
        mysql_fetch_field_row(savingstring, "BannedBy"); strmid(Player[playerid][BannedBy], savingstring, 0, strlen(savingstring), 24);
        mysql_fetch_field_row(savingstring, "Radio"); Player[playerid][Radio] = strval(savingstring);
        mysql_fetch_field_row(savingstring, "RadioWave"); Player[playerid][RadioWave] = strval(savingstring);
        mysql_fetch_field_row(savingstring, "SubRank"); strmid(Player[playerid][SubRank], savingstring, 0, strlen(savingstring), 24);
        mysql_fetch_field_row(savingstring, "CellPhone"); Player[playerid][CellPhone] = strval(savingstring);
        mysql_fetch_field_row(savingstring, "CellPhoneNumber"); Player[playerid][CellPhoneNumber] = strval(savingstring);
        mysql_fetch_field_row(savingstring, "Job"); Player[playerid][Job] = strval(savingstring);
    }
    print(query);
    format(query, sizeof(query), "SELECT CellBattery FROM Accounts WHERE Username = '%s'", pname);
    mysql_store_result();
    while(mysql_fetch_row_format(query,"|"))
    {
        mysql_fetch_field_row(savingstring, "CellBattery"); Player[playerid][CellBattery] = strval(savingstring);
        print(savingstring);
    }
    mysql_free_result();

It doesn't load the CellBattery, what's the problem?

Thanks!

[kikito]

change your format.

pawn Код:

format(query, sizeof(query), "SELECT * FROM Accounts WHERE Username = '%s'", pname);

[CoaPsyFactor]

I don't think you need while, cus you sent information to SQL to get only CellBatterey column

[iGetty]

Quote:

format(query, sizeof(query), "SELECT * FROM Accounts WHERE Username = '%s'", pname);

That will select ALL of the fields, right?

[AndreT]

Why do you make a separate query for it? You are already selecting from the same table before!

Also, I assume you only have ONE account with the same name. So why do you use the loop?

[kikito]

Quote:

Originally Posted by iGetty That will select ALL of the fields, right?

Yes.