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

Threaded Mode
Mysql server not saving
Lyksus
Big Clucker
***
Posts: 113
Threads: 29
Joined: Mar 2013
Reputation: 0
#1

09.07.2013, 10:35
Hi there,


I am having an issue here with my script and my mysql server.
What I am trying to do, is to make a quiz. The quiz works perfectly, but the things is, when you finish the quiz, it won't set the "quizcomplete" to 1. I tried a lot of things, and I can place some pawn codes in here.

pawn Код:
mysql_fetch_field_row(savingstring, "quizcomplete"); Player[playerid][QuizComplete] = strval(savingstring);
I saved it as I need to do.. Can someone help me?
I have teamviewer..
Find
Reply
XcorelloX
Little Clucker
**
Posts: 32
Threads: 2
Joined: Apr 2013
Reputation: 0
#2

09.07.2013, 10:42
The query you posted isn't saving the string, it's retrieving it from the database and saving the data to the variable.

You need to reverse the query (as below) and save it upon completion.

pawn Код:
format(savingstring,sizeof(savingstring),"UPDATE `players` SET `quizcomplete` = '1' WHERE `Username` = '%s'",GetName(playerid));
mysql_query(savingstring);
You will have to change the query a little if your table isn't called players and the Username column isn't called Username. I used GetName(playerid) too which I think you may have, if not, it's here:

pawn Код:
GetName(playerid)
{
    new name[MAX_PLAYER_NAME];
    GetPlayerName(playerid,name,MAX_PLAYER_NAME);
    return name;
}
Find
Reply
[HiC]TheKiller
High-roller
*****
Posts: 2,629
Threads: 40
Joined: Mar 2008
Reputation: 0
#3

09.07.2013, 10:43
Put

pawn Код:
mysql_debug(1);
Under OnGameModeInit and this will record all SQL queries etc and save under mysql_log in your server directory. Post the area where you're fetching the data (in your code) and the area from the MySQL log file.
Find
Reply
Lyksus
Big Clucker
***
Posts: 113
Threads: 29
Joined: Mar 2013
Reputation: 0
#4

09.07.2013, 10:50
The things is that the others working perfectly.

Look at this:.



pawn Код:
mysql_fetch_field_row(savingstring, "spawnloc"); Player[playerid][SpawnType] = strval(savingstring);
            mysql_fetch_field_row(savingstring, "noobspawntype"); Player[playerid][NoobSpawnType] = strval(savingstring);
            mysql_fetch_field_row(savingstring, "nmuted"); Player[playerid][nMuted] = strval(savingstring);
            mysql_fetch_field_row(savingstring, "nmutedtimes"); Player[playerid][nMutedTimes] = strval(savingstring);
            mysql_fetch_field_row(savingstring, "helperlevel"); Player[playerid][HelperLevel] = 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, "kicktimes"); Player[playerid][KickTimes] = strval(savingstring);
            mysql_fetch_field_row(savingstring, "bantimes"); Player[playerid][BanTimes] = strval(savingstring);
            mysql_fetch_field_row(savingstring, "tutorialcomplete"); Player[playerid][TutorialComplete] = strval(savingstring);
            mysql_fetch_field_row(savingstring, "quizcomplete"); Player[playerid][QuizComplete] = strval(savingstring);
            mysql_fetch_field_row(savingstring, "crisps"); Player[playerid][Crisps] = strval(savingstring);
            mysql_fetch_field_row(savingstring, "sprunk"); Player[playerid][Sprunk] = strval(savingstring);
            mysql_fetch_field_row(savingstring, "phonebook"); Player[playerid][PhoneBook] = strval(savingstring);
            mysql_fetch_field_row(savingstring, "bankmoney"); Player[playerid][BankMoney] = strval(savingstring);
            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, "speedomode"); Player[playerid][SpeedoMode] = strval(savingstring);
            mysql_fetch_field_row(savingstring, "slappedtimes"); Player[playerid][SlappedTimes] = strval(savingstring);
            mysql_fetch_field_row(savingstring, "job"); Player[playerid][Job] = strval(savingstring);
            mysql_fetch_field_row(savingstring, "fish1"); Player[playerid][Fish1] = strval(savingstring);
            mysql_fetch_field_row(savingstring, "fish2"); Player[playerid][Fish2] = strval(savingstring);
            mysql_fetch_field_row(savingstring, "fish3"); Player[playerid][Fish3] = strval(savingstring);
            mysql_fetch_field_row(savingstring, "fish4"); Player[playerid][Fish4] = strval(savingstring);
            mysql_fetch_field_row(savingstring, "fishingrod"); Player[playerid][FishingRod] = strval(savingstring);
            mysql_fetch_field_row(savingstring, "fishingbait"); Player[playerid][FishingBait] = strval(savingstring);
            mysql_fetch_field_row(savingstring, "health"); Player[playerid][Health] = floatstr(savingstring);
            mysql_fetch_field_row(savingstring, "armour"); Player[playerid][Armour] = floatstr(savingstring);
            mysql_fetch_field_row(savingstring, "weapon1"); Player[playerid][Weapon][0] = strval(savingstring);
            mysql_fetch_field_row(savingstring, "weapon2"); Player[playerid][Weapon][1] = strval(savingstring);
            mysql_fetch_field_row(savingstring, "weapon3"); Player[playerid][Weapon][2] = strval(savingstring);
            mysql_fetch_field_row(savingstring, "weapon4"); Player[playerid][Weapon][3] = strval(savingstring);
            mysql_fetch_field_row(savingstring, "weapon5"); Player[playerid][Weapon][4] = strval(savingstring);
            mysql_fetch_field_row(savingstring, "weapon6"); Player[playerid][Weapon][5] = strval(savingstring);
            mysql_fetch_field_row(savingstring, "weapon7"); Player[playerid][Weapon][6] = strval(savingstring);
            mysql_fetch_field_row(savingstring, "weapon8"); Player[playerid][Weapon][7] = strval(savingstring);
            mysql_fetch_field_row(savingstring, "weapon9"); Player[playerid][Weapon][8] = strval(savingstring);
            mysql_fetch_field_row(savingstring, "weapon10"); Player[playerid][Weapon][9] = strval(savingstring);
            mysql_fetch_field_row(savingstring, "weapon11"); Player[playerid][Weapon][10] = strval(savingstring);
            mysql_fetch_field_row(savingstring, "weapon12"); Player[playerid][Weapon][11] = strval(savingstring);
            mysql_fetch_field_row(savingstring, "weapon1ammo"); Player[playerid][WeaponAmmo][0] = strval(savingstring);
            mysql_fetch_field_row(savingstring, "weapon2ammo"); Player[playerid][WeaponAmmo][1] = strval(savingstring);
            mysql_fetch_field_row(savingstring, "weapon3ammo"); Player[playerid][WeaponAmmo][2] = strval(savingstring);
            mysql_fetch_field_row(savingstring, "weapon4ammo"); Player[playerid][WeaponAmmo][3] = strval(savingstring);
            mysql_fetch_field_row(savingstring, "weapon5ammo"); Player[playerid][WeaponAmmo][4] = strval(savingstring);
            mysql_fetch_field_row(savingstring, "weapon6ammo"); Player[playerid][WeaponAmmo][5] = strval(savingstring);
            mysql_fetch_field_row(savingstring, "weapon7ammo"); Player[playerid][WeaponAmmo][6] = strval(savingstring);
            mysql_fetch_field_row(savingstring, "weapon8ammo"); Player[playerid][WeaponAmmo][7] = strval(savingstring);
            mysql_fetch_field_row(savingstring, "weapon9ammo"); Player[playerid][WeaponAmmo][8] = strval(savingstring);
            mysql_fetch_field_row(savingstring, "weapon10ammo"); Player[playerid][WeaponAmmo][9] = strval(savingstring);
            mysql_fetch_field_row(savingstring, "weapon11ammo"); Player[playerid][WeaponAmmo][10] = strval(savingstring);
            mysql_fetch_field_row(savingstring, "weapon12ammo"); Player[playerid][WeaponAmmo][11] = strval(savingstring);
            mysql_fetch_field_row(savingstring, "totalminutes"); Player[playerid][TotalMinutes] = strval(savingstring);
            mysql_fetch_field_row(savingstring, "totaltimem"); Player[playerid][TotalTimeM] = strval(savingstring);
            mysql_fetch_field_row(savingstring, "totaltimeh"); Player[playerid][TotalTimeH] = strval(savingstring);
            mysql_fetch_field_row(savingstring, "totaltimed"); Player[playerid][TotalTimeD] = strval(savingstring);
            mysql_fetch_field_row(savingstring, "lastcheckm"); Player[playerid][LastCheckM] = strval(savingstring);
            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, "sweepercomplete"); Player[playerid][SweeperComplete] = strval(savingstring);
            mysql_fetch_field_row(savingstring, "truckercomplete"); Player[playerid][TruckerComplete] = strval(savingstring);
            mysql_fetch_field_row(savingstring, "deliverycomplete"); Player[playerid][DeliveryComplete] = strval(savingstring);
            mysql_fetch_field_row(savingstring, "newspapercomplete"); Player[playerid][NewsPaperComplete] = strval(savingstring);
            mysql_fetch_field_row(savingstring, "trashcomplete"); Player[playerid][PizzaComplete] = strval(savingstring);
            mysql_fetch_field_row(savingstring, "subrank"); strmid(Player[playerid][SubRank], savingstring, 0, strlen(savingstring), 24);
            mysql_fetch_field_row(savingstring, "lightmode"); Player[playerid][LightMode] = strval(savingstring);
            mysql_fetch_field_row(savingstring, "fightstyle"); Player[playerid][FightStyle] = strval(savingstring);
            mysql_fetch_field_row(savingstring, "skilllevel"); Player[playerid][SkillLevel] = strval(savingstring);
            mysql_fetch_field_row(savingstring, "age"); Player[playerid][Age] = strval(savingstring);
            mysql_fetch_field_row(savingstring, "devlevel"); Player[playerid][DevLevel] = strval(savingstring);
            mysql_fetch_field_row(savingstring, "carlicense"); Player[playerid][CarLicense] = strval(savingstring);
            mysql_fetch_field_row(savingstring, "wantedlevel"); Player[playerid][WantedLevel] = strval(savingstring);

            mysql_fetch_field_row(savingstring, "timesjailed"); Player[playerid][TimesJailed] = strval(savingstring);
            mysql_fetch_field_row(savingstring, "timesfined"); Player[playerid][TimesFined] = strval(savingstring);
            mysql_fetch_field_row(savingstring, "parkingtickets"); Player[playerid][ParkingTickets] = strval(savingstring);
            mysql_fetch_field_row(savingstring, "timeswanted"); Player[playerid][TimesWanted] = strval(savingstring);
            mysql_fetch_field_row(savingstring, "speedingtickets"); Player[playerid][SpeedingTickets] = strval(savingstring);
            mysql_fetch_field_row(savingstring, "officialwarnings"); Player[playerid][OfficialWarnings] = strval(savingstring);

            mysql_fetch_field_row(savingstring, "dayborn"); Player[playerid][DayBorn] = strval(savingstring);
            mysql_fetch_field_row(savingstring, "monthborn"); Player[playerid][MonthBorn] = strval(savingstring);
            mysql_fetch_field_row(savingstring, "yearborn"); Player[playerid][YearBorn] = strval(savingstring);

            mysql_fetch_field_row(savingstring, "facspawn"); Player[playerid][FacSpawn] = strval(savingstring);
            mysql_fetch_field_row(savingstring, "mask"); Player[playerid][Mask] = strval(savingstring);
            mysql_fetch_field_row(savingstring, "speedfine"); Player[playerid][SpeedFine] = strval(savingstring);

            mysql_fetch_field_row(savingstring, "cocaine"); Player[playerid][Cocaine] = strval(savingstring);
            mysql_fetch_field_row(savingstring, "weed"); Player[playerid][Weed] = strval(savingstring);
            mysql_fetch_field_row(savingstring, "fishinglicense"); Player[playerid][FishingLicense] = strval(savingstring);
            mysql_fetch_field_row(savingstring, "materials"); Player[playerid][Materials] = strval(savingstring);
            mysql_fetch_field_row(savingstring, "weaponlicense"); Player[playerid][WeaponLicense] = strval(savingstring);

            mysql_fetch_field_row(savingstring, "shoutanim"); Player[playerid][ShoutAnim] = strval(savingstring);
            mysql_fetch_field_row(savingstring, "ecstacy"); Player[playerid][Ecstacy] = strval(savingstring);
            mysql_fetch_field_row(savingstring, "heroin"); Player[playerid][Heroin] = strval(savingstring);
            mysql_fetch_field_row(savingstring, "harvestcomplete"); Player[playerid][HarvestComplete] = strval(savingstring);
            mysql_fetch_field_row(savingstring, "lastclothes"); Player[playerid][LastClothes] = strval(savingstring);
            mysql_fetch_field_row(savingstring, "clothesslotused"); Player[playerid][ClothesSlotUsed] = strval(savingstring);
            mysql_fetch_field_row(savingstring, "cellbattery"); Player[playerid][CellBattery] = strval(savingstring);
            mysql_fetch_field_row(savingstring, "cellplan"); Player[playerid][CellPlan] = strval(savingstring);
            mysql_fetch_field_row(savingstring, "carcharger"); Player[playerid][CarCharger] = strval(savingstring);
            mysql_fetch_field_row(savingstring, "badgenumber"); Player[playerid][BadgeNumber] = strval(savingstring);
            mysql_fetch_field_row(savingstring, "cigarettes"); Player[playerid][Cigarettes] = strval(savingstring);
            mysql_fetch_field_row(savingstring, "lighter"); Player[playerid][Lighter] = strval(savingstring);
            mysql_fetch_field_row(savingstring, "briefcase"); Player[playerid][Briefcase] = strval(savingstring);
            mysql_fetch_field_row(savingstring, "houserentkey"); Player[playerid][HouseRentKey] = strval(savingstring);
They are working perfect.
Find
Reply
« Next Oldest | Next Newest »


Forum Jump:


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