[Addons]

Ok, so: I've this variable "PlayerData[playerid][pTut]". When i register to my server this fucking variable change to 1. Ok, now i try to relog from my server and..surprise: must choose my gender, sex, spawn etc. but my level, admin, helper are saved.

Gamemode is on MySQL.

SetPlayerSpawn:

Код:

if(PlayerData[playerid][pTut] == 0)
	    {
			gOoc[playerid] = 1; gNews[playerid] = 1; gFam[playerid] = 1;
			TogglePlayerControllable(playerid, 0);
			RegistrationStep[playerid] = 1;
			ShowPlayerDialog(playerid,100,DIALOG_STYLE_LIST,"{08F618}Sex","{F63C08}1. {FFFFFF}Male\r\n{F63C08}2. {FFFFFF}Female","Select", "");
	    }

End tutorial:

Код:

ClearChatbox(i, 15);
					TextDrawHideForPlayer(i, TSTEP);
					TextDrawHideForPlayer(i, TSTEP5);
					TextDrawHideForPlayer(i, TutorialTd20);
			        TextDrawHideForPlayer(i, TutorialTd21);
			        TextDrawHideForPlayer(i, TutorialTd22);
			        TextDrawHideForPlayer(i, TutorialTd23);
					TogglePlayerSpectating(i, 0);
					TutTime[i] = 0;
					PlayerData[i][pTut] = 1;
					gOoc[i] = 0; gNews[i] = 0; gFam[i] = 0;
					TogglePlayerControllable(i, 1);
					MedicBill[i] = 0;
					SetPlayerSpawn(i);
					GivePlayerCash(i, 6000);
					SetCameraBehindPlayer(i);
					PlayerData[i][pMSG] = 0;
					format(string, sizeof(string), "UPDATE players SET Tutorial='%d' WHERE id=%d", PlayerData[i][pTut], PlayerData[i][pSQLID]);
					mysql_query(string);
					format(string, sizeof(string), "UPDATE players SET MSG='%d' WHERE id=%d", PlayerData[i][pMSG], PlayerData[i][pSQLID]);
					mysql_query(string);
					SetPlayerCheckpoint(i,1413.3684,-1700.7410,13.5423,7.0);
					CP[i] = 386;

Please help, i'm too confused.
PS: Sorry for my BAD english, i'm romanian style!

[Sithis]

Are you saving the variable in mysql when your player leaves the server or ends the tutorial?

[Addons]

Yep.

pawn Код:

format(string, sizeof(string), "UPDATE players SET Tutorial='%d' WHERE id=%d", PlayerData[i][pTut], PlayerData[i][pSQLID]);

All variables saves it in DB.

[[WSF]ThA_Devil]

how big is variable string? It's possible that it's too short for your SQL query.

Aswell, make sure you got
mysql_debug(1); under OnGameModeInit.

[taylorcro]

"UPDATE players SET Tutorial='%d' WHERE id=%d
to
"UPDATE players SET Tutorial='%d' WHERE id='%d'

maybe

[Addons]

I have "mysql_debug(1)" in GameModeInit.

I changed string in string1.

pawn Код:

new string1[128];
                    format(string1, sizeof(string1), "UPDATE players SET Tutorial='%d' WHERE id=%d", PlayerData[i][pTut], PlayerData[i][pSQLID]);
                    mysql_query(string1);

Doesn't work.

[iZN]

Using wrong syntax that's why. You don't have to use ' ' for integer or decimal.

PHP код:

UPDATE players SET Tutorial=%d WHERE id=%d 


[Addons]

Doesn't work.

[[WSF]ThA_Devil]

are you sure you're connected to DB? what does mysql_log.txt say?

[Addons]

[MYSQL]Connection to database "woody" was made!