GTAONLINE.PL :: [INNE] Zapis Mysql

Zaloguj się by uzyskać pełen dostęp. Nie masz jeszcze konta? Założ je już teraz w kilka sekund.

witam

mam problem dotycz?cy zapisu danych mysql , wszystko jest okej , ale mam problem z d?ugo?cia lini

Kod:

public OnPlayerDisconnect(playerid, reason)

{

	if( PlayerInfo[ playerid ][ loggedIn ] )

	{

		new buf[ 254 ];

		PlayerInfo[playerid][czas] = PlayerInfo[playerid][czas] + (GetTickCount()/1000) - (PlayerInfo[playerid][czas2]/1000);

		PlayerInfo[ playerid] [ score ] = GetPlayerScore( playerid );

		PlayerInfo[ playerid ][ money ] = GetPlayerMoney( playerid );

        format( buf, sizeof( buf ), "UPDATE players SET money = %d, score = %d, kills = %d, deaths = %d, lvl = %d, bank = %d, kod = %d, test = %d, admin = %d, vip = %d, czas = %d, czas2 = %d  WHERE nickname = '%s';",	PlayerInfo[ playerid ][ money ], PlayerInfo[ playerid ][ score ], PlayerInfo[ playerid ][ kills ], PlayerInfo[ playerid ][ deaths ], PlayerInfo[ playerid ] [ lvl ], PlayerInfo[ playerid ][ bank ], PlayerInfo[ playerid ][ test ], PlayerInfo[ playerid ][ admin ], PlayerInfo[ playerid ][ vip ], PlayerInfo[ playerid ][ czas ], PlayerInfo[ playerid ][ czas2 ], PlayerInfo[ playerid ][ nickname ] );

		mysql_query( buf );

	}

	return 1;

}

wyskakuje mi taki b?ad

Kod:

C:\Users\LuXoR\Desktop\SiW\gamemodes\mapa.pwn(397) : error 075: input line too long (after substitutions)

Pawn compiler 3.2.3664	 	 	Copyright (c) 1997-2006, ITB CompuPhase

1 Error.

mam za d?uga linie , wiem o tym , ale jak zrobic zeby zmiescic to w 2 liniach , juz pr?bowa?em to mi sie staty nie zapisuja

za pomoc

T? d?ug? linijk? spr?buj rozbi? w ten spos?b:

Kod:

format( buf, sizeof( buf ), "UPDATE players SET money = %d, score = %d, kills = %d, deaths = %d, lvl = %d, bank = %d,", PlayerInfo[ playerid ][ money ], PlayerInfo[ playerid ][ score ], PlayerInfo[ playerid ][ kills ], PlayerInfo[ playerid ][ deaths ], PlayerInfo[ playerid ] [ lvl ], PlayerInfo[ playerid ][ bank ]);

format(buf, sizeof(buf), "%s kod = %d, test = %d, admin = %d, vip = %d, czas = %d, czas2 = %d WHERE nickname = '%s';", buf, PlayerInfo[ playerid ][ money ], PlayerInfo[ playerid ][ score ], PlayerInfo[ playerid ][ kills ], PlayerInfo[ playerid ][ deaths ], PlayerInfo[ playerid ] [ lvl ], PlayerInfo[ playerid ][ bank ], PlayerInfo[ playerid ][ test ], PlayerInfo[ playerid ][ admin ], PlayerInfo[ playerid ][ vip ], PlayerInfo[ playerid ][ czas ], PlayerInfo[ playerid ][ czas2 ], PlayerInfo[ playerid ][ nickname ] );

I pousuwaj jak najwi?cej spacji, wtedy linia b?dzie kr?tsza i mo?e b?dzie akurat.

Pozdrawiam

w sumie to zrobi?em na 2 buf'y i odziwo mi dzia?a ;D

ale czy na pewno zda to egzamin

Quis, zrobi?em tak jak m?wi?es ale tez za d?uga linijka ;D

zobacz

Kod:

public OnPlayerDisconnect(playerid, reason)

{

	if( PlayerInfo[ playerid ][ loggedIn ] )

	{

		new buf[ 144 ];

		new buf2[ 144 ];

		PlayerInfo[playerid][czas] = PlayerInfo[playerid][czas] + (GetTickCount()/1000) - (PlayerInfo[playerid][czas2]/1000);

		PlayerInfo[ playerid] [ score ] = GetPlayerScore( playerid );

		PlayerInfo[ playerid ][ money ] = GetPlayerMoney( playerid );

		format( buf, sizeof( buf ), "UPDATE players SET money = %d, score = %d, kills = %d, deaths = %d, lvl = %d, bank = %d WHERE nickname = '%s';" , PlayerInfo[ playerid ][ money ], PlayerInfo[ playerid ][ score ], PlayerInfo[ playerid ][ kills ], PlayerInfo[ playerid ][ deaths ], PlayerInfo[ playerid ] [ lvl ], PlayerInfo[ playerid ][ bank ], PlayerInfo[playerid][nickname]);

		format( buf2, sizeof( buf2 ), "UPDATE players SET kod = %d, test = %d, admin = %d, vip = %d, czas = %d, czas2 = %d WHERE nickname = '%s';" , PlayerInfo[ playerid ][ test ], PlayerInfo[ playerid ][ test ], PlayerInfo[ playerid ][ admin ], PlayerInfo[ playerid ][ vip ], PlayerInfo[ playerid ][ czas ], PlayerInfo[ playerid ][ czas2 ], PlayerInfo[ playerid ][ nickname ] );

		mysql_query( buf );

		mysql_query( buf2 );

	}

	return 1;

}

Lukasbank, chyba b?dzie dobrze, sprawd? to najlepiej.

wsumie jest okej , wszystko pi?knie dzia?a , ale raz sie rejestruje zdob?de tam score itp , wychodze i nic mi sie nie zapisuje . wchodz? 2 raz , zdobywam staty wychodze i normalnie sie all zapisuje

nie wiem czemu za 1 raz? nie . hmm...

Mo?e po rejestracji nie ustawiasz zmiennej "PlayerInfo[ playerid ][ loggedIn ]" na true?

tak tak w???nie dobrze m?wisz ;D
doda?em po za rejestrowaniu si?

Kod:

PlayerInfo[ playerid ][ loggedIn ] = true;

i teraz wszystko dzia?a

Dzi?ki za pomoc :piwo:

i rep sie nalezy ;D