mysql problemele.

[Sn0p]

Nisaugo eta kazko ci man i nizinau kaaip pataisiti padekit man:D

Ne ne..

 

 

Kažko tai nesaugo kadangi žinau, kad neviską parašiau nes pirma diena kaip pradėjau dirbt su mysql vėl... 

KODAS:

 

Saugojimas

    mysql_fetch_field_row( fetch,"Admin" );         playerData[playerid][Admin] = strval(fetch);

Eta krovimas

		playerData[playerid][Skin] = GetPlayerSkin(playerid);
		playerData[playerid][Pinigai] = GetPlayerMoney(playerid);
		playerData[playerid][Patirtis] = GetPlayerScore(playerid);
		playerData[playerid][Admin]; 

		format( Query, sizeof(Query),"UPDATE `zaidejai` SET skin = '%i', pinigai = '%i', patirtis = '%i', Admin = '%d',WHERE vardas = '%s'",\
		playerData[playerid][Skin], 
		playerData[playerid][Pinigai], 
		playerData[playerid][Patirtis], GetPlayerNameEx(playerid));
		playerData[playerid][Admin]; 

Kame problema

[SyncMaster]

Nisaugo eta kazko ci man i nizinau kaaip pataisiti padekit man:D

Ne ne..

 

 

Kažko tai nesaugo kadangi žinau, kad neviską parašiau nes pirma diena kaip pradėjau dirbt su mysql vėl... 

KODAS:

 

Saugojimas

    mysql_fetch_field_row( fetch,"Admin" );         playerData[playerid][Admin] = strval(fetch);

Eta krovimas

		playerData[playerid][Skin] = GetPlayerSkin(playerid);
		playerData[playerid][Pinigai] = GetPlayerMoney(playerid);
		playerData[playerid][Patirtis] = GetPlayerScore(playerid);
		playerData[playerid][Admin]; 

		format( Query, sizeof(Query),"UPDATE `zaidejai` SET skin = '%i', pinigai = '%i', patirtis = '%i', Admin = '%d',WHERE vardas = '%s'",\
		playerData[playerid][Skin], 
		playerData[playerid][Pinigai], 
		playerData[playerid][Patirtis], GetPlayerNameEx(playerid));
		playerData[playerid][Admin]; 

Kame problema

                playerData[playerid][Skin] = GetPlayerSkin(playerid);
		playerData[playerid][Pinigai] = GetPlayerMoney(playerid);
		playerData[playerid][Patirtis] = GetPlayerScore(playerid);
		playerData[playerid][Admin] = playerdata[playerid][Admin];

		format( Query, sizeof(Query),"UPDATE `zaidejai` SET skin = '%i', pinigai = '%i', patirtis = '%i', Admin = '%d',WHERE vardas = '%s'",\
		playerData[playerid][Skin], 
		playerData[playerid][Pinigai], 
		playerData[playerid][Patirtis], GetPlayerNameEx(playerid));
		playerData[playerid][Admin] = playerdata[playerid][Admin];

Bandyk taip, nežinau ar tiks, arba pažiurėk mysql log'e.

Redaguota Vasario 17, 2015, nario Ghost'as

[Sulcas]

Parodyk MySQL loga.

[Sn0p]

Ta prasme viska saugo tik Admin nesaugo

[16:11:35] CMySQLHandler::Query(UPDATE `zaidejai` SET skin = '0', pinigai = '0', patirtis = '0', Admin = '84',WHERE vardas = '') - An error has occured. (Error ID: 1064, Erreur de syntaxe prčs de 'WHERE vardas = ''' ą la ligne 1)

Redaguota Vasario 17, 2015, nario #Justas

[#Karolis]

playerData[playerid][Skin] = GetPlayerSkin(playerid);

playerData[playerid][Pinigai] = GetPlayerMoney(playerid);

playerData[playerid][Patirtis] = GetPlayerScore(playerid);

playerData[playerid][Admin] = playerdata[playerid][Admin];

format( Query, sizeof(Query),"UPDATE `zaidejai` SET skin = '%i', pinigai = '%i', patirtis = '%i', Admin = '%d',WHERE vardas = '%s'",

playerData[playerid][Skin],

playerData[playerid][Pinigai],

playerData[playerid][Patirtis],

playerData[playerid][Admin],

GetPlayerNameEx(playerid));

Redaguota Vasario 17, 2015, nario Jamaika // Karolis

[Sn0p]

                playerData[playerid][Skin] = GetPlayerSkin(playerid);
		playerData[playerid][Pinigai] = GetPlayerMoney(playerid);
		playerData[playerid][Patirtis] = GetPlayerScore(playerid);
		playerData[playerid][Admin] = playerdata[playerid][Admin];

		format( Query, sizeof(Query),"UPDATE `zaidejai` SET skin = '%i', pinigai = '%i', patirtis = '%i', Admin = '%d',WHERE vardas = '%s'",
		playerData[playerid][Skin], 
		playerData[playerid][Pinigai], 
		playerData[playerid][Patirtis],
		playerData[playerid][Admin],
                GetPlayerNameEx(playerid));

Dėkui durnos klaidos -.- 

[#Karolis]

Dėkui durnos klaidos -.- 

Jei dar kokios pagalbos reikės visada gali kreiptis į skypę - karolisss39 padėsiu visada kai galėsiu bei jei pats mokėsiu