SA-MP Forums Archive
SQL. - Printable Version

+- SA-MP Forums Archive (https://sampforum.blast.hk)
+-- Forum: SA-MP Scripting and Plugins (https://sampforum.blast.hk/forumdisplay.php?fid=8)
+--- Forum: Scripting Help (https://sampforum.blast.hk/forumdisplay.php?fid=12)
+--- Thread: SQL. (/showthread.php?tid=347925)



SQL. - iGetty - 03.06.2012

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!


Re: SQL. - kikito - 03.06.2012

change your format.
pawn Код:
format(query, sizeof(query), "SELECT * FROM Accounts WHERE Username = '%s'", pname);



Re: SQL. - CoaPsyFactor - 03.06.2012

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


Re: SQL. - iGetty - 03.06.2012

Quote:

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

That will select ALL of the fields, right?


Re: SQL. - AndreT - 03.06.2012

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?


Re: SQL. - kikito - 03.06.2012

Quote:
Originally Posted by iGetty
Посмотреть сообщение
That will select ALL of the fields, right?
Yes.