Pagalbos Dėl mysql išsaugojimo duomenų

[Remiis.]

Sweiki yra tokia bėda kad kai pvz žaidime nusiperki privilegija tarkim vip, iš to žaidėjo nuskaito kreditus ir uždeda vip, tik neišsaugo mysql, ir kai atsijungi ir vėl prisijungi atgauni kreditus kiek turėjei ir nebeturi vip.

      

	        case 2: // VIP
	        {
				new krd = pDB[playerid][pKreditai];
				if(pDB[playerid][pAdminLevel]==1) return SendClientMessage(playerid,-1,"{ffcc00}[ KLAIDA ] {ffffff}Jûs jau turite VIP statusa!");
				if(pDB[playerid][pAdminLevel]==2) return SendClientMessage(playerid,-1,"{ffcc00}[ KLAIDA ] {ffffff}Jûs turite superVIP statusa!");
				if(pDB[playerid][pAdminLevel]==3) return SendClientMessage(playerid,-1,"{ffcc00}[ KLAIDA ] {ffffff}Jûs jau turite Admin statusa statusa!");
				if(krd < 30 ) return SendClientMessage(playerid,-1,"{ffcc00}[ MINI - VVP ] {ffffff}Neturite 30 kreditu nusipirkti VIP statusui!");
				else
				{
				    pDB[playerid][pKreditai]-=30;
					pDB[playerid][pAdminLevel]=1;
					SendClientMessage(playerid,-1,"{ffcc00}[ STATUSTAS ] {fffffff}Nusipirkote VIP statusa uþ 30KRD!");
				    new Query [ 200 ];
				    format(Query,sizeof(Query),"UPDATE `zaidejai` SET pAdminLevel = '%i' WHERE vardas ='%s'","UPDATE `zaidejai`SET pKreditai = '%i' WHERE vardas ='%s'",\
				    pDB[playerid][pAdminLevel],
					pDB[playerid][pKreditai],
					GetPlayerNameEx(playerid));
					mysql_query(Query);
				}
	        }

Galit pasakyti ką netaip čia įrašiau?

 

[renaldasj]

Kaip matau čia mano kurta drifto modifikacija.. Hmm !! nerašyk query , hujquery tiesiog pDB [ playerid ] [ pAdminLevel ] = 1;

[Remiis.]

Kaip matau čia mano kurta drifto modifikacija.. Hmm !! nerašyk query , hujquery tiesiog pDB [ playerid ] [ pAdminLevel ] = 1;

Taip čia tavo, bet jei gali parodyk pataisyta kodą nes nelabai supratau kurioj čia vietoi

[renaldasj]

paskutines 6 eilutes nutrink kur format query iki mysql_query

[Remiis.]

paskutines 6 eilutes nutrink kur format query iki mysql_query

Vistiek tas pats arba, aš neten trinu, gali nutrinta parodyt?

[renaldasj]

Vistiek tas pats arba, aš neten trinu, gali nutrinta parodyt?

o tu sql'e turi pAdmin? t.y koks sql gali atsiųst?

[Remiis.]

o tu sql'e turi pAdmin? t.y koks sql gali atsiųst?

Jo viskas yra Ir pAdmin ir pKreditai, duok skype arba pakviesk remigys13 atsiusiu

[renaldasj]

Jo viskas yra Ir pAdmin ir pKreditai, duok skype arba pakviesk remigys13 atsiusiu

krč, ryt vakare tebūsių aš, ždž atsiųsk koda be

[Remiis.]

     case 2: // VIP
     {
                new krd = pDB[playerid][pKreditai];
                if(pDB[playerid][pAdminLevel]==1) return SendClientMessage(playerid,-1,"{ffcc00}[ KLAIDA ] {ffffff}Jûs jau turite VIP statusa!");
                if(pDB[playerid][pAdminLevel]==2) return SendClientMessage(playerid,-1,"{ffcc00}[ KLAIDA ] {ffffff}Jûs turite superVIP statusa!");
                if(pDB[playerid][pAdminLevel]==3) return SendClientMessage(playerid,-1,"{ffcc00}[ KLAIDA ] {ffffff}Jûs jau turite Admin statusa statusa!");
                if(krd < 30 ) return SendClientMessage(playerid,-1,"{ffcc00}[ MINI - VVP ] {ffffff}Neturite 30 kreditu nusipirkti VIP statusui!");
                else
                {
                 pDB[playerid][pKreditai]-=30;
                    pDB[playerid][pAdminLevel]=1;
                    SendClientMessage(playerid,-1,"{ffcc00}[ STATUSTAS ] {fffffff}Nusipirkote VIP statusa uþ 30KRD!");
                 new Query [ 200 ];
                 format(Query,sizeof(Query),"UPDATE `zaidejai` SET pAdminLevel = '%i' WHERE vardas ='%s'","UPDATE `zaidejai`SET pKreditai = '%i' WHERE vardas ='%s'",\
                 pDB[playerid][pAdminLevel],
                    pDB[playerid][pKreditai],
                    GetPlayerNameEx(playerid));
                    mysql_query(Query);
                }
     }

Redaguota Gruodžio 13, 2013, nario Remiis.

[renaldasj]

case 2: // VIP

{

new krd = pDB[playerid][pKreditai];

if(pDB[playerid][pAdminLevel]==1) return SendClientMessage(playerid,-1,"{ffcc00}[ KLAIDA ] {ffffff}Jûs jau turite VIP statusa!");

if(pDB[playerid][pAdminLevel]==2) return SendClientMessage(playerid,-1,"{ffcc00}[ KLAIDA ] {ffffff}Jûs turite superVIP statusa!");

if(pDB[playerid][pAdminLevel]==3) return SendClientMessage(playerid,-1,"{ffcc00}[ KLAIDA ] {ffffff}Jûs jau turite Admin statusa statusa!");

if(krd < 30 ) return SendClientMessage(playerid,-1,"{ffcc00}[ MINI - VVP ] {ffffff}Neturite 30 kreditu nusipirkti VIP statusui!");

else

{

pDB[playerid][pKreditai]-=30;

pDB[playerid][pAdminLevel]=1;

SendClientMessage(playerid,-1,"{ffcc00}[ STATUSTAS ] {fffffff}Nusipirkote VIP statusa uþ 30KRD!");

}

}

[Remiis.]

Vistiek taspats nusiperki privilegija , nueini i mysql vistiek rodo tiek pat kreditu, nors turetu rodyti -30

[renaldasj]

Blembački, kas per nesamonė, nebent nėra saugojimo, nors prisimenu, kad dariau. Atsiųsk stock MySQL_SAVE and load

[Remiis.]

Blembački, kas per nesamonė, nebent nėra saugojimo, nors prisimenu, kad dariau. Atsiųsk stock MySQL_SAVE and load

Duok skaipa

[bebras]

mysql log!

[Remiis.]

[23:52:24] >> mysql_store_result( Connection handle: 1 )

 

[23:52:24] CMySQLHandler::StoreResult() - Result was stored.

 

[23:52:24] >> mysql_num_rows( Connection handle: 1 )

 

[23:52:24] CMySQLHandler::NumRows() - Returned 1 row(s)

 

[23:52:24] >> mysql_free_result( Connection handle: 1 )

 

[23:52:24] CMySQLHandler::FreeResult() - Result was successfully free'd.

 

[23:52:28] >> mysql_real_escape_string( Connection handle: 1 )

 

[23:52:28] CMySQLHandler::EscapeString(admin); - Escaped 5 characters to admin.

 

[23:52:28] >> mysql_query( Connection handle: 1 )

 

[23:52:28] CMySQLHandler::Query(SELECT * FROM `zaidejai` WHERE vardas = 'Remiis' AND slaptazodis = 'admin') - Successfully executed.

 

[23:52:28] >> mysql_store_result( Connection handle: 1 )

 

[23:52:28] CMySQLHandler::StoreResult() - Result was stored.

 

[23:52:28] >> mysql_num_rows( Connection handle: 1 )

 

[23:52:28] CMySQLHandler::NumRows() - Returned 1 row(s)

 

[23:52:30] >> mysql_query( Connection handle: 1 )

 

[23:52:30] CMySQLHandler::Query(SELECT * FROM `zaidejai` WHERE vardas = 'Remiis') - Successfully executed.

 

[23:52:30] >> mysql_store_result( Connection handle: 1 )

 

[23:52:30] CMySQLHandler::StoreResult() - Result was stored.

 

[23:52:30] >> mysql_retrieve_row( Connection handle: 1 )

 

[23:52:30] >> mysql_fetch_field_row( Connection handle: 1 )

 

[23:52:30] CMySQLHandler::FetchField("x") - 1276.789794

 

[23:52:30] >> mysql_fetch_field_row( Connection handle: 1 )

 

[23:52:30] CMySQLHandler::FetchField("y") - 207.828018

 

[23:52:30] >> mysql_fetch_field_row( Connection handle: 1 )

 

[23:52:30] CMySQLHandler::FetchField("z") - 19.554687

 

[23:52:30] >> mysql_fetch_field_row( Connection handle: 1 )

 

[23:52:30] CMySQLHandler::FetchField("pSkin") - 0

 

[23:52:30] >> mysql_fetch_field_row( Connection handle: 1 )

 

[23:52:30] CMySQLHandler::FetchField("pPinigai") - 0

 

[23:52:30] >> mysql_fetch_field_row( Connection handle: 1 )

 

[23:52:30] CMySQLHandler::FetchField("pPatirtis") - 10

 

[23:52:30] >> mysql_fetch_field_row( Connection handle: 1 )

 

[23:52:30] CMySQLHandler::FetchField("pAdminLevel") - 0

 

[23:52:30] >> mysql_fetch_field_row( Connection handle: 1 )

 

[23:52:30] CMySQLHandler::FetchField("pKreditai") - 500

 

[23:52:30] >> mysql_fetch_field_row( Connection handle: 1 )

 

[23:52:30] CMySQLHandler::FetchField("hp") - 100

 

[23:52:30] >> mysql_fetch_field_row( Connection handle: 1 )

 

[23:52:30] CMySQLHandler::FetchField("armour") - 0

 

[23:52:30] >> mysql_free_result( Connection handle: 1 )

 

[23:52:30] CMySQLHandler::FreeResult() - Result was successfully free'd.

 

[23:52:42] >> mysql_query( Connection handle: 1 )

 

[23:52:42] CMySQLHandler::Query(UPDATE `zaidejai` pPatirtis = '15' WHERE vardas ='Remiis') - An error has occured. (Error ID: 1064, You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '= '15' WHERE vardas ='Remiis'' at line 1)

 

[23:53:12] >> mysql_query( Connection handle: 1 )

 

[23:53:12] CMySQLHandler::Query(UPDATE `zaidejai` SET x = '1278.006713', y = '199.349441', z = '19.554687' WHERE vardas = 'Remiis') - Successfully executed.

 

[23:53:12] >> mysql_query( Connection handle: 1 )

 

[23:53:12] CMySQLHandler::Query(UPDATE `zaidejai` SET pSkin = '0', pPinigai = '0', pPatirtis = '15' WHERE vardas = 'Remiis') - Successfully executed.

 

[23:53:12] >> mysql_query( Connection handle: 1 )

 

[23:53:12] CMySQLHandler::Query(UPDATE `zaidejai` SET pAdminLevel ='0',pKreditai = '82' WHERE vardas ='') - Successfully executed.

 

[23:53:12] >> mysql_query( Connection handle: 1 )

 

[23:53:12] CMySQLHandler::Query(UPDATE `zaidejai` SET hp = '100.000000', armour = '0.000000' WHERE vardas = 'Remiis') - Successfully executed.

 

 

Poto viskas kartojas

[bebras]

Va tau ir problema

[23:52:42] CMySQLHandler::Query(UPDATE `zaidejai` pPatirtis = '15' WHERE vardas ='Remiis') - An error has occured. (Error ID: 1064, You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '= '15' WHERE vardas ='Remiis'' at line 1)

[Remiis.]

 

Va tau ir problema

[23:52:42] CMySQLHandler::Query(UPDATE `zaidejai` pPatirtis = '15' WHERE vardas ='Remiis') - An error has occured. (Error ID: 1064, You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '= '15' WHERE vardas ='Remiis'' at line 1)

O tai kame čia problema? tipo netokia mysql versija?

[bebras]

Čia tipo blogai parašei užklausą. Parodyk ją, pažiūrėsim, nes čia klaidos nematau.

[Remiis.]

case 2: // VIP

{

new krd = pDB[playerid][pKreditai];

if(pDB[playerid][pAdminLevel]==1) return SendClientMessage(playerid,-1,"{ffcc00}[ KLAIDA ] {ffffff}Jûs jau turite VIP statusa!");

if(pDB[playerid][pAdminLevel]==2) return SendClientMessage(playerid,-1,"{ffcc00}[ KLAIDA ] {ffffff}Jûs turite superVIP statusa!");

if(pDB[playerid][pAdminLevel]==3) return SendClientMessage(playerid,-1,"{ffcc00}[ KLAIDA ] {ffffff}Jûs jau turite Admin statusa statusa!");

if(krd < 30 ) return SendClientMessage(playerid,-1,"{ffcc00}[ MINI - VVP ] {ffffff}Neturite 30 kreditu nusipirkti VIP statusui!");

else

{

pDB[playerid][pKreditai]-=30;

pDB[playerid][pAdminLevel]=1;

SendClientMessage(playerid,-1,"{ffcc00}[ STATUSTAS ] {fffffff}Nusipirkote VIP statusa uþ 30KRD!");

new Query [ 200 ];

format(Query,sizeof(Query),"UPDATE `zaidejai` SET pAdminLevel = '%i' WHERE vardas ='%s'","UPDATE `zaidejai`SET pKreditai = '%i' WHERE vardas ='%s'",\

pDB[playerid][pAdminLevel],

pDB[playerid][pKreditai],

GetPlayerNameEx(playerid));

mysql_query(Query);

}

}

Va gi buvau parašęs

[bebras]

format(Query,sizeof(Query),"UPDATE `zaidejai` SET pAdminLevel = '%i' WHERE vardas ='%s'","UPDATE `zaidejai`SET pKreditai = '%i' WHERE vardas ='%s'",

 format(Query,sizeof(Query),"UPDATE `zaidejai` SET pAdminLevel = '%i',pKreditai = '%i' WHERE vardas ='%s'",pDB[playerid][pAdminLevel],pDB[playerid][pKreditai],GetPlayerNameEx(playerid));