[PAGALBOS] Dėl mysql

[AtomicDesign]

Sveiki, šiandieną patrugdysiu bei paprašysiu jūsų pagalbos su mysql klaidomis. Taigi štai bėda tokia, jog floodiną tą pačia klaida daug kartu ir gan greitai, norėčiau paprašyti jūsų pagalbos galbūt atsirastu kas galėtu padėti. Štai klaidos: Spausti čia

 

[Vidmantas.]

[16:01:33] CMySQLHandler::Query(UPDATE `narkotikaiginklai` SET `DealersDocksHaveWeed` = '500', `DealersDocksHaveExstazi` = '500', `DealersDocksHaveCocaine` = ') - 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 ''' at line 1) 

rašybos klaida kode, gal kažkur ' ar " neteisingai naudojama

[miša.]

13 minutes prieš, Programmer. parašė:

[16:01:33] CMySQLHandler::Query(UPDATE `narkotikaiginklai` SET `DealersDocksHaveWeed` = '500', `DealersDocksHaveExstazi` = '500', `DealersDocksHaveCocaine` = ') - 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 ''' at line 1) 

rašybos klaida kode, gal kažkur ' ar " neteisingai naudojama

Programistas.

 

I.T @|>>SUPREME<<|parodyk sia eilute

UPDATE `narkotikaiginklai` SET `DealersDocksHaveWeed` = '500', `DealersDocksHaveExstazi` = '500', `DealersDocksHaveCocaine` = '

 

is pacio pwn rodyk

Redaguota Gruodžio 28, 2018, nario pesh

[AtomicDesign]

2 minutes prieš, pesh parašė:

Programistas.

 

I.T @|>>SUPREME<<|parodyk sia eilute

 

	UPDATE `narkotikaiginklai` SET `DealersDocksHaveWeed` = '500', `DealersDocksHaveExstazi` = '500', `DealersDocksHaveCocaine` = '
	

	mysql_query("SELECT * FROM `narkotikaiginklai`");

	mysql_store_result();

	if(mysql_num_rows())
	{
	    format(String, sizeof(String), "UPDATE `narkotikaiginklai` SET `DealersDocksHaveWeed` = '%d', `DealersDocksHaveExstazi` = '%d', `DealersDocksHaveCocaine` = '%d', `DealersDocksHaveHeroin` = '%d'", DealersDocksHaveWeed, DealersDocksHaveExstazi, DealersDocksHaveCocaine, DealersDocksHaveHeroin);
	    mysql_query(String);
	}
	else
 	{
 		format(String, sizeof(String), "INSERT INTO `narkotikaiginklai` (DealersDocksHaveWeed, DealersDocksHaveExstazi, DealersDocksHaveCocaine, DealersDocksHaveHeroin) VALUES ('%d', '%d', '%d', '%d')", DealersDocksHaveWeed, DealersDocksHaveExstazi, DealersDocksHaveCocaine, DealersDocksHaveHeroin);
		mysql_query(String);
	}

	mysql_free_result();

	return 1;
}

 

[Vidmantas.]

Dabar, pesh parašė:

Programistas.

ir kuo čia norėjai pasirodyt?

[mariusqw]

29 minutes prieš, |>>SUPREME<<| parašė:

	mysql_query("SELECT * FROM `narkotikaiginklai`");

	mysql_store_result();

	if(mysql_num_rows())
	{
	    format(String, sizeof(String), "UPDATE `narkotikaiginklai` SET `DealersDocksHaveWeed` = '%d', `DealersDocksHaveExstazi` = '%d', `DealersDocksHaveCocaine` = '%d', `DealersDocksHaveHeroin` = '%d'", DealersDocksHaveWeed, DealersDocksHaveExstazi, DealersDocksHaveCocaine, DealersDocksHaveHeroin);
	    mysql_query(String);
	}
	else
 	{
 		format(String, sizeof(String), "INSERT INTO `narkotikaiginklai` (DealersDocksHaveWeed, DealersDocksHaveExstazi, DealersDocksHaveCocaine, DealersDocksHaveHeroin) VALUES ('%d', '%d', '%d', '%d')", DealersDocksHaveWeed, DealersDocksHaveExstazi, DealersDocksHaveCocaine, DealersDocksHaveHeroin);
		mysql_query(String);
	}

	mysql_free_result();

	return 1;
}

 

Query Size padidink. [string]

[AtomicDesign]

56 minutes prieš, mariusqw parašė:

Query Size padidink. [string]

Kaip jis didanasi ?