MySQL Prob with cars - Printable Version

MySQL Prob with cars - Printable Version

+- SA-MP Forums Archive (https://sampforum.blast.hk)
+-- Forum: SA-MP Scripting and Plugins (https://sampforum.blast.hk/forumdisplay.php?fid=8)
+--- Forum: Scripting Help (https://sampforum.blast.hk/forumdisplay.php?fid=12)
+--- Thread: MySQL Prob with cars (/showthread.php?tid=303427)

MySQL Prob with cars - Ber912 - 13.12.2011

Hey,
Now in right section
I have a little problem with MySQL.
I want to load the vehicles with MySQL and i have a little script.
But there is one problem, the server loads only one Car.
Code:

Код:

enum FrakCars
{
	Fraktion,
	Model,
 	Float:x,
 	Float:y,
 	Float:z,
 	Float:a,
	Color1,
	Color2,
    CarID,
}
new FrakCarInfo[50][FrakCars];

Код:

public OnGameModeInit()
{
	SetGameModeText("Blank Script");
	AddPlayerClass(0, 1244.3230,-2038.6282,59.6752,179.8692, 0, 0, 0, 0, 0, 0);
	Connect_To_Database();
	LoadFrakCars();
}

Код:

stock LoadFrakCars()
{
	new fc;
	new string[16];
	while(fc<50)
	{
 		format(string, sizeof(string),"%d",fc);
		FrakCarInfo[fc][Model] = mysql_GetInt("vehicles", "Model", "id", string);
		FrakCarInfo[fc][x] = mysql_GetFloat("vehicles", "x", "id", string);
		FrakCarInfo[fc][y] = mysql_GetFloat("vehicles", "y", "id", string);
		FrakCarInfo[fc][z] = mysql_GetFloat("vehicles", "z", "id", string);
		FrakCarInfo[fc][a] = mysql_GetFloat("Vehicles", "a", "id", string);
		FrakCarInfo[fc][Color1] = mysql_GetInt("vehicles", "Color1", "id", string);
		FrakCarInfo[fc][Color2] = mysql_GetInt("vehicles", "Color2", "id", string);
		if(FrakCarInfo[fc][Model] >= 400 && FrakCarInfo[fc][Model] <= 611)
		{
			FrakCarInfo[fc][CarID] = AddStaticVehicleEx(FrakCarInfo[fc][Model], FrakCarInfo[fc][x], FrakCarInfo[fc][y], FrakCarInfo[fc][z], FrakCarInfo[fc][a],   	FrakCarInfo[fc][Color1], FrakCarInfo[fc][Color2], -1);

		}
		fc++;
	}
	return 1;
}

Код:

stock mysql_GetInt(Table[], Field[], Where[], Is[])
{
    new query[128];
    mysql_real_escape_string(Table, Table);
    mysql_real_escape_string(Field, Field);
    mysql_real_escape_string(Where, Where);
    mysql_real_escape_string(Is, Is);
    format(query, 128, "SELECT %s FROM %s WHERE %s = '%s'", Field, Table, Where, Is);
    mysql_query(query);
    mysql_store_result();
    new sqlint = mysql_fetch_int();
    mysql_free_result();
    return sqlint;
}

Код:

stock Float:mysql_GetFloat(Table[], Field[], Where[], Is[])
{
    new query[128], Float:sqlfloat;
    mysql_real_escape_string(Table, Table);
    mysql_real_escape_string(Field, Field);
    mysql_real_escape_string(Where, Where);
    mysql_real_escape_string(Is, Is);
    format(query, 128, "SELECT %s FROM %s WHERE %s = '%s'", Field, Table, Where, Is);
    mysql_query(query);
    mysql_store_result();
    mysql_fetch_float(sqlfloat);
    mysql_free_result();
    return sqlfloat;
}

Can you tell me what is wrong?
Ber912

Re: MySQL Prob with cars - T0pAz - 13.12.2011

Have you got any error on your mysql log?