SQL TABLE

[marian]

Am facut un svr pe baza Mysql dar am o problema cand deschid svr

[14:05:23] Error in mysql_query: Table 'samp.personalcars' doesn't exist
[14:05:23] Error in mysql_store_result: Table 'samp.personalcars' doesn't exist

[Guest farse]

mysql_query("CREATE TABLE IF NOT EXISTS `personalcars` (id INT PRIMARY KEY, ..altele)")

zimi ce trebuie sa contina personalcars..

[marian]

mysql_query("CREATE TABLE IF NOT EXISTS `personalcars` (id INT PRIMARY KEY, ..altele)")

zimi ce trebuie sa contina personalcars..

.asta e problema ca nu stiu:|

[Guest farse]

cauta in gm `personalcars` si uitate ce vrea sa seteze,ceva gen INSERT INTO `personalcars` `bla`='blabla' WHERE `x`='y' sau UPDATE ...

[marian]

Ajuta la cv?

public LoadSQLCars()
{
	new car[33][64];
	new sql[300];
	new row[1024];
	format(sql, sizeof(sql), "SELECT COUNT(*) FROM personalcars");
	samp_mysql_query(sql);
	samp_mysql_store_result();
	samp_mysql_fetch_row(row);
	totalcars = strval(row);
	for(new idx = 1; idx < MAX_CARS; idx++)
	{
     	format(sql,sizeof(sql), "SELECT * FROM personalcars WHERE id=%d", idx);
	    samp_mysql_query(sql);
	    samp_mysql_store_result();
	    if (samp_mysql_num_rows() > 0)
	    {
  			samp_mysql_fetch_row(row);
			split(row, car, '|');
			CarInfo[idx][cSQLID] = strval(car[0]);
			CarInfo[idx][cModel] = strval(car[1]);
			CarInfo[idx][cLocationx] = floatstr(car[2]);
			CarInfo[idx][cLocationy] = floatstr(car[3]);
			CarInfo[idx][cLocationz] = floatstr(car[4]);
			CarInfo[idx][cAngle] = floatstr(car[5]);
			CarInfo[idx][cColorOne] = strval(car[6]);
			CarInfo[idx][cColorTwo] = strval(car[7]);
			strmid(CarInfo[idx][cOwner], car[8], 0, strlen(car[8]), 255);
			strmid(CarInfo[idx][cDescription], car[9], 0, strlen(car[9]), 255);
			CarInfo[idx][cValue] = strval(car[10]);
			CarInfo[idx][cOwned] = strval(car[11]);
			CarInfo[idx][cLock] = strval(car[12]);
			CarInfo[idx][cMod1] = strval(car[13]);
			CarInfo[idx][cMod2] = strval(car[14]);
			CarInfo[idx][cMod3] = strval(car[15]);
			CarInfo[idx][cMod4] = strval(car[16]);
			CarInfo[idx][cMod5] = strval(car[17]);
			CarInfo[idx][cMod6] = strval(car[18]);
			CarInfo[idx][cMod7] = strval(car[19]);
			CarInfo[idx][cMod8] = strval(car[20]);
			CarInfo[idx][cMod9] = strval(car[21]);
			CarInfo[idx][cMod10] = strval(car[22]);
			CarInfo[idx][cMod11] = strval(car[23]);
			CarInfo[idx][cMod12] = strval(car[24]);
			CarInfo[idx][cMod13] = strval(car[25]);
			CarInfo[idx][cMod14] = strval(car[26]);
			CarInfo[idx][cMod15] = strval(car[27]);
			CarInfo[idx][cMod16] = strval(car[28]);
			CarInfo[idx][cMod17] = strval(car[29]);
			CarInfo[idx][cPaintjob] = strval(car[30]);
			CarInfo[idx][cInsurer] = strval(car[31]);
			strmid(CarInfo[idx][cPlate], car[32], 0, strlen(car[32]), 255);
			AddStaticVehicleEx(strval(car[1]), floatstr(car[2]), floatstr(car[3]), floatstr(car[4]), floatstr(car[5]), strval(car[6]), strval(car[7]), 60000);
		}
	}
	printf("%d cars loaded from database", totalcars);
	//samp_mysql_free_result();
	return 1;
}

public LoadSQLServerVehicles()
{
	new arrCoords[13][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 = 300; idx < MAX_CARS; 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]);
			CarInfo[idx][cRentcar] = strval(arrCoords[11]);
			CarInfo[idx][cJobcar] = strval(arrCoords[12]);
			AddStaticVehicleEx(Model,x,y,z,a,Color1,Color2,RespawnTime);
		}
	}
	printf("%d vehicles loaded from database", totalvehicles);
}

[Guest farse]

Cauta ceva cu UPDATE `personalcars` pentru ca din alea nu-mi dau seama ce nume au field-urile

[marian]

Cauta ceva cu UPDATE `personalcars` pentru ca din alea nu-mi dau seama ce nume au field-urile

Nu gasesc asa cv dar am gasit

format(sql, sizeof(sql), "UPDATE personalcars SET Modelid=%d,cLocationX=%f,cLocationY=%f,cLocationZ=%f,cLocationAngle=%f,Color1=%d,Color2=%d,cOwner='%s',Description='%s',cPrice=%d,cOwned=%d,cLock=%d,cSpoiler=%d,cFrontBumper=%d,cRearBumper=%d,cExhaust=%d,cBVentRight=%d,cBVentLeft=%d,cLSideSkirt=%d,cRSideSkirt=%d,cBass=%d,cRearBullbars=%d,cFrontBullbars=%d,cWheels=%d,cHood=%d,cNitrous=%d,cHydraulics=%d,cLamps=%d,cRoof=%d,cPaintjob=%d,CarInsurer=%d,cPlate='%s' WHERE id=%d",
		/

[Guest farse]

[pawn]new tQuery[600];

strcat(tQuery,"\

CREATE TABLE IF NOT EXISTS `personalcars`\

(\

id INT PRIMARY KEY,\

Modelid INT,\

cLocationX FLOAT,\

cLocationY FLOAT,\

cLocationZ FLOAT,\

cLocationAngle FLOAT,\

Color1 INT,\

Color2 INT,\

cOwner varchar(50),\

Description varchar(50),\

cPrice INT,\

cOwned INT,");

strcat(tQuery,"\

cLock INT,\

cSpoiler INT,\

cFrontBumper INT,\

cReapBumper INT,\

cExhaust INT,\

cBVentRight INT,\

cBVentLeft INT,\

cLSideSkirt INT,\

cRSideSkirt INT,\

cBass INT,\

cRearBullbars INT,\

cFrontBullbars INT,\

cWheels INT,");

strcat(tQuery,"\

cHood INT,\

cNitrous INT,\

cHydraulics INT,\

cLamps INT,\

cRoof INT,\

cPaintjob INT,\

CarInsurer INT,\

cPlate varchar(50))");

mysql_query(tQuery);

[/pawn]

[marian]

ms dar imi da eroarea asta cand incerc so bag

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