Pagalbos dėl MySQL krovimo...

[#Karolis]

Žodžiu rišu GRP4 su mysql bet kažkas nesigauna : Gaunu tokius warningus :/ :

C:\Documents and Settings\Naujas\Desktop\LtGyvenimas\gamemodes\GRP4.pwn(5179) : warning 213: tag mismatch
C:\Documents and Settings\Naujas\Desktop\LtGyvenimas\gamemodes\GRP4.pwn(5187) : warning 213: tag mismatch
C:\Documents and Settings\Naujas\Desktop\LtGyvenimas\gamemodes\GRP4.pwn(5194) : warning 213: tag mismatch
Pawn compiler 3.2.3664	 	 	Copyright (c) 1997-2006, ITB CompuPhase


3 Warnings.

5179 eilutė -

mysql_fetch_field_row(tmp,"Job"); playerDB[playerid][specialybe] = strval(tmp);

5187 eilutė -

mysql_fetch_field_row(tmp,"Interior"); playerDB[playerid][interioras] = strval(tmp);

5194 eilutė -

return 1;

Kodas :

stock LoadPlayerData(playerid)
{
	new name[MAX_PLAYER_NAME], query[128];
	GetPlayerName(playerid, name, sizeof(name));
	format(query, sizeof(query),"SELECT * FROM vartotojai WHERE Vardas = '%s'", name);
	mysql_query(query);
	mysql_store_result();
	if(mysql_retrieve_row())
	{
 		new tmp[800];
		playerDB[playerid][pinigai] = GetPlayerMoney(playerid);
		playerDB[playerid][ieskomumas] = GetPlayerWantedLevel(playerid);
		playerDB[playerid][xp] = GetPlayerScore(playerid);
		playerDB[playerid][virtualw] = GetPlayerVirtualWorld(playerid);
		playerDB[playerid][interioras] = GetPlayerInterior(playerid);
	    mysql_fetch_field_row(tmp,"Pinigai"); playerDB[playerid][pinigai] = strval(tmp);
	    mysql_fetch_field_row(tmp,"pBanke"); playerDB[playerid][banke] = strval(tmp);
	    mysql_fetch_field_row(tmp,"pNamuose"); playerDB[playerid][namuose] = strval(tmp);
        mysql_fetch_field_row(tmp,"Biznis"); playerDB[playerid][biznis] = strval(tmp);
        mysql_fetch_field_row(tmp,"Wanted"); playerDB[playerid][ieskomumas] = strval(tmp);
        mysql_fetch_field_row(tmp,"Car"); playerDB[playerid][pcar] = strval(tmp);
        mysql_fetch_field_row(tmp,"LastSession"); gSession = strval(tmp);
        mysql_fetch_field_row(tmp,"Gang"); gplayerDB[playerid][pgang] = strval(tmp);
        mysql_fetch_field_row(tmp,"Islead"); gplayerDB[playerid][islead] = strval(tmp);
        mysql_fetch_field_row(tmp,"Lead"); playerDB[playerid][plead] = strval(tmp);
        mysql_fetch_field_row(tmp,"Kalejime"); playerDB[playerid][kalejimo_laikas] = strval(tmp);
        mysql_fetch_field_row(tmp,"Kreditai"); playerDB[playerid][kreditai] = strval(tmp);
        mysql_fetch_field_row(tmp,"vlaikas"); playerDB[playerid][vlaikas] = strval(tmp);
        mysql_fetch_field_row(tmp,"Job"); playerDB[playerid][specialybe] = strval(tmp);
        mysql_fetch_field_row(tmp,"Drabuziai"); playerDB[playerid][drabuziai] = strval(tmp);
        mysql_fetch_field_row(tmp,"Uniforma"); playerDB[playerid][uniforma] = strval(tmp);
        mysql_fetch_field_row(tmp,"Uniformd"); playerDB[playerid][uniformd] = strval(tmp);
        mysql_fetch_field_row(tmp,"Xp"); playerDB[playerid][xp] = strval(tmp);
        mysql_fetch_field_row(tmp,"Mobsas"); playerDB[playerid][mobsas] = strval(tmp);
        mysql_fetch_field_row(tmp,"Pastatas"); playerDB[playerid][cbuilding] = strval(tmp);
        mysql_fetch_field_row(tmp,"Lytis"); playerDB[playerid][lytis] = strval(tmp);
        mysql_fetch_field_row(tmp,"Interior"); playerDB[playerid][interioras] = strval(tmp);
        mysql_fetch_field_row(tmp,"Drugs"); playerDB[playerid][narkotikai] = strval(tmp);
        mysql_fetch_field_row(tmp,"vTeises"); playerDB[playerid][teises] = strval(tmp);
        mysql_fetch_field_row(tmp,"World"); playerDB[playerid][virtualw] = strval(tmp);
        mysql_fetch_field_row(tmp,"Insurance"); playerDB[playerid][draudimas] = strval(tmp);
	 }
	 mysql_free_result();
	 return 1;
}

Saugojimas :

stock SavePlayerData(playerid)
{
	new Float:pos[3], name[MAX_PLAYER_NAME], query[500];
	GetPlayerPos(playerid, pos[0], pos[1], pos[2]);
	GetPlayerName(playerid, name, sizeof(name));
	GetPlayerPos(playerid, pos[0], pos[1], pos[2]);
	playerDB[playerid][pinigai] = GetPlayerMoney(playerid);
	playerDB[playerid][ieskomumas] = GetPlayerWantedLevel(playerid);
	playerDB[playerid][virtualw] = GetPlayerVirtualWorld(playerid);
	playerDB[playerid][interioras] = GetPlayerInterior(playerid);
	playerDB[playerid][xp] = GetPlayerScore(playerid);
	format(query, sizeof(query),"UPDATE vartotojai SET Pinigai = %d, pBanke = %d, pNamuose = %d, Biznis = %d, Wanted = %d, Car = %d, LastSession = %d, Gang = %d, Islead = %d, Lead = %d, Kalejime = %d, Kreditai = %d, vlaikas = %d, Job = %d, Drabuziai = %d, Uniforma = %d, Uniformd = %d, Xp = %d, Mobsas = %d, Pastatas = %d, Lytis = %d, Interior = %d, Drugs = %d, vTeises = %d, World = %d, Insurance = %d, X = %f, Y = %f, Z = %f WHERE Vardas = '%s'",
	playerDB[playerid][pinigai],
 	playerDB[playerid][banke],
  	playerDB[playerid][namuose],
   	playerDB[playerid][biznis],
    playerDB[playerid][ieskomumas],
 	playerDB[playerid][pcar],
 	gSession,
  	gplayerDB[playerid][pgang],
 	gplayerDB[playerid][islead],
 	playerDB[playerid][plead],
 	playerDB[playerid][kalejimo_laikas],
 	playerDB[playerid][kreditai],
 	playerDB[playerid][vlaikas],
 	playerDB[playerid][specialybe],
 	playerDB[playerid][drabuziai],
 	playerDB[playerid][uniforma],
 	playerDB[playerid][uniformd],
	playerDB[playerid][xp],
	playerDB[playerid][mobsas],
	playerDB[playerid][cbuilding],
	playerDB[playerid][lytis],
	playerDB[playerid][interioras],
	playerDB[playerid][narkotikai],
	playerDB[playerid][teises],
	playerDB[playerid][virtualw],
	playerDB[playerid][draudimas],
	pos[0], pos[1], pos[2],
	name);
	mysql_query(query);
	playerDB[playerid][authstate] = 4;
	GameTextForPlayer(playerid, "Saugomas tavo þaidimas", 1000, 5);
	return 1;
}

[bebras]

"specialybe" ir "interioras" nepamišai sukurti?

[#Karolis]

"specialybe" ir "interioras" nepamišai sukurti?

Patikrinau tai kad viskas yra :/

[bebras]

O jie tikrai int? Galbūt float?

[#Karolis]

O jie tikrai int? Galbūt float?

Taip tikrai int dar va dini krovime parodyta :

playerDB[playerid][specialybe] = dini_Int(file,"Job");

SetPlayerInterior(playerid,dini_Int(file,"Interior"));

Redaguota Balandžio 18, 2014, nario Jamaika // Karolis

[bebras]

Na tada galėtum tas dvi eilutes padaryt į dvi eilutes kad matytųsi būtent kurioje warning.