SQLITE TABLE

[marian]

Sall am nevoe de ajutor cu o veche problema care pana la urma nu am reusit sa rezolv nimic deoaree imi dadea eroare

Comanda SQL:

new tQuery[600];

MySQL zice:

#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 'new tQuery[600]' at line 1

http://www.sa-mp.ro/forum/index.php/topic,12044.msg71836.html#msg71836

Dar acum am alta asemanatoare

servervehicles

nu stiu daca ajuta

public LoadSQLServerVehicles()
{
	new arrCoords[11][32];
	new sql[80];
	new row[512];
	new Model;
	new Float:x, Float:y, Float:z, Float:a;
	new Color1, Color2;
	new RespawnTime;
	new description[128];
	format(sql, sizeof(sql), "SELECT COUNT(*) FROM servervehicles");
	samp_mysql_query(sql);
	samp_mysql_store_result();
	samp_mysql_fetch_row(row);
	totalvehicles = strval(row);
	for(new idx = 0; idx <= totalvehicles; idx++)
	{
		format(sql, sizeof(sql), "SELECT * FROM servervehicles WHERE id=%d", idx);
	    samp_mysql_query(sql);
		//if (DEBUG) SQLLog(sql);
	    samp_mysql_store_result();
	    if (samp_mysql_num_rows() > 0)
	    {
  			samp_mysql_fetch_row(row);
			split(row, arrCoords, '|');
			Model = strval(arrCoords[1]);
			strmid(description, arrCoords[2], 0, strlen(arrCoords[2]), 255);
			x = floatstr(arrCoords[3]);
			y = floatstr(arrCoords[4]);
			z = floatstr(arrCoords[5]);
			a = floatstr(arrCoords[6]);
			Color1 = strval(arrCoords[7]);
			Color2 = strval(arrCoords[8]);
			RespawnTime = strval(arrCoords[9]);
			CarInfo[idx][cFaction] = strval(arrCoords[10]);
		}
		AddStaticVehicleEx(Model,x,y,z,a,Color1,Color2,RespawnTime);
	}
	printf("%d vehicles loaded from database", totalvehicles);
}

Va rog mult ajutatima sa rezolv aceste 2 erori servervehicle and personalcars

[marian]

scz de Double post dar va rog ajutatima ca nu ma pricep la SQL

[Guest farse]

posteaza functia SaveSQLServerVehicles sau ceva de genul.

[marian]

posteaza functia SaveSQLServerVehicles sau ceva de genul.

Save nu gasesc dar am gasit load

public LoadSQLServerVehicles()
{
	new arrCoords[11][32];
	new sql[80];
	new row[512];
	new Model;
	new Float:x, Float:y, Float:z, Float:a;
	new Color1, Color2;
	new RespawnTime;
	new description[128];
	format(sql, sizeof(sql), "SELECT COUNT(*) FROM servervehicles");
	samp_mysql_query(sql);
	samp_mysql_store_result();
	samp_mysql_fetch_row(row);
	totalvehicles = strval(row);
	for(new idx = 0; idx <= totalvehicles; idx++)
	{
		format(sql, sizeof(sql), "SELECT * FROM servervehicles WHERE id=%d", idx);
	    samp_mysql_query(sql);
		//if (DEBUG) SQLLog(sql);
	    samp_mysql_store_result();
	    if (samp_mysql_num_rows() > 0)
	    {
  			samp_mysql_fetch_row(row);
			split(row, arrCoords, '|');
			Model = strval(arrCoords[1]);
			strmid(description, arrCoords[2], 0, strlen(arrCoords[2]), 255);
			x = floatstr(arrCoords[3]);
			y = floatstr(arrCoords[4]);
			z = floatstr(arrCoords[5]);
			a = floatstr(arrCoords[6]);
			Color1 = strval(arrCoords[7]);
			Color2 = strval(arrCoords[8]);
			RespawnTime = strval(arrCoords[9]);
			CarInfo[idx][cFaction] = strval(arrCoords[10]);
		}
		AddStaticVehicleEx(Model,x,y,z,a,Color1,Color2,RespawnTime);
	}
	printf("%d vehicles loaded from database", totalvehicles);
}

Dar eroarea

Comanda SQL:

new tQuery[600];

MySQL zice:

#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 'new tQuery[600]' at line 1

Am incercat sa bag ceea ce mi-ai dat u atunci pentru personalcars dar nu a mers si mi-a dat eroare