Fraktionsfahrzeuge werden nicht geladen...

J0a9 · 12. Dezember 2015

Guten Abend Breadfish-Community,

komischerweise werden die Fraktionsautos nicht mehr geladen.
Alle Fraktionsfahrzeuge befinden sich in der MySQL-Datenbank.

Meine Ladefunktion ist folgendermaßen aufgebaut:

C

Function LoadFraktionsAuto()
{
	new query[56];
	format(query, sizeof(query), "SELECT * FROM fraktionsautos");
	mysql_function_query(dbhandle, query, true, "LoadFactionCars", "");
	return 1;
}

C

Function LoadFactionCars()
{
	if(!cache_num_rows())return 1;
	for(new i = 0; i < cache_num_rows(); i++)
	{
	    FactionCars[i][fdb_id]   	=   cache_get_field_content_int(1, "id", dbhandle);
	    FactionCars[i][fFraktion]  	=   cache_get_field_content_int(i, "FracID", dbhandle);
		FactionCars[i][fVehid]   	=   cache_get_field_content_int(i, "FVehId", dbhandle);
		FactionCars[i][fFaction]	=   cache_get_field_content_int(i, "FFaction", dbhandle);
		FactionCars[i][v_X]			=   cache_get_field_content_float(i, "Fv_aX", dbhandle);
		FactionCars[i][v_Y]			=   cache_get_field_content_float(i, "Fv_aY", dbhandle);
		FactionCars[i][v_Z]			=   cache_get_field_content_float(i, "Fv_aZ", dbhandle);
		FactionCars[i][v_A]			=   cache_get_field_content_float(i, "Fv_aA", dbhandle);
		FactionCars[i][fCol][0]		=   cache_get_field_content_int(i, "FCol1", dbhandle);
		FactionCars[i][fCol][1]		=   cache_get_field_content_int(i, "FCol2", dbhandle);
		FactionCars[i][fCarid] 		= 	CreateVehicle(FactionCars[i][fVehid],FactionCars[i][v_X],FactionCars[i][v_Y],FactionCars[i][v_Z],FactionCars[i][v_A],FactionCars[i][fCol][0],FactionCars[i][fCol][1],-1);
	}
	return 1;
}

Alles anzeigen

Ich finde den Fehler nicht warum das nicht geladen wird.
Kann mir einer weiterhelfen?

Lg
J0a9

Jeffry · 12. Dezember 2015

Was sagt der MySQL Log?

Und:
FactionCars[i][fdb_id] = cache_get_field_content_int(1, "id", dbhandle);
zu:
FactionCars[i][fdb_id] = cache_get_field_content_int(i, "id", dbhandle);
Das ist aber nicht der Grund für das Problem.

J0a9 · 12. Dezember 2015

@Jeffry:

Im MySQL Log stehen nur viele:

PHP

[17:32:55] [ERROR] mysql_tquery - invalid connection handle (id: 0)
[17:32:55] [ERROR] mysql_tquery - invalid connection handle (id: 0)
[17:32:55] [ERROR] mysql_tquery - invalid connection handle (id: 0)
[17:32:55] [ERROR] mysql_tquery - invalid connection handle (id: 0)
[17:32:55] [ERROR] mysql_tquery - invalid connection handle (id: 0)
[17:32:55] [ERROR] mysql_tquery - invalid connection handle (id: 0)
[17:32:55] [ERROR] mysql_tquery - invalid connection handle (id: 0)
[17:32:55] [ERROR] mysql_tquery - invalid connection handle (id: 0)
[17:32:55] [ERROR] mysql_tquery - invalid connection handle (id: 0)
[17:32:55] [ERROR] mysql_tquery - invalid connection handle (id: 0)
[17:32:55] [ERROR] mysql_tquery - invalid connection handle (id: 0)
[17:32:55] [ERROR] mysql_tquery - invalid connection handle (id: 0)
[17:32:55] [ERROR] mysql_tquery - invalid connection handle (id: 0)
[17:32:55] [ERROR] mysql_tquery - invalid connection handle (id: 0)
[17:32:55] [ERROR] mysql_tquery - invalid connection handle (id: 0)
[17:32:55] [ERROR] mysql_tquery - invalid connection handle (id: 0)
[17:32:55] [ERROR] mysql_tquery - invalid connection handle (id: 0)
[17:32:55] [ERROR] mysql_tquery - invalid connection handle (id: 0)
[17:32:55] [ERROR] mysql_tquery - invalid connection handle (id: 0)
[17:32:55] [ERROR] mysql_tquery - invalid connection handle (id: 0)
[17:32:55] [ERROR] mysql_tquery - invalid connection handle (id: 0)
[17:32:55] [ERROR] mysql_tquery - invalid connection handle (id: 0)
[17:32:55] [ERROR] mysql_tquery - invalid connection handle (id: 0)
[17:32:55] [ERROR] mysql_tquery - invalid connection handle (id: 0)
[17:32:55] [ERROR] mysql_tquery - invalid connection handle (id: 0)
[17:32:55] [ERROR] mysql_tquery - invalid connection handle (id: 0)
[17:32:55] [ERROR] mysql_tquery - invalid connection handle (id: 0)
[17:32:55] [ERROR] mysql_tquery - invalid connection handle (id: 0)
[17:32:55] [ERROR] mysql_tquery - invalid connection handle (id: 0)
[17:32:55] [ERROR] mysql_tquery - invalid connection handle (id: 0)
[17:32:55] [ERROR] mysql_tquery - invalid connection handle (id: 0)
[17:32:55] [ERROR] mysql_tquery - invalid connection handle (id: 0)
[17:32:55] [ERROR] mysql_tquery - invalid connection handle (id: 0)
[17:32:55] [ERROR] mysql_tquery - invalid connection handle (id: 0)
[17:32:55] [ERROR] mysql_tquery - invalid connection handle (id: 0)
[17:32:55] [ERROR] mysql_tquery - invalid connection handle (id: 0)
[17:32:55] [ERROR] mysql_tquery - invalid connection handle (id: 0)
[17:32:55] [ERROR] mysql_tquery - invalid connection handle (id: 0)
[17:32:55] [ERROR] mysql_tquery - invalid connection handle (id: 0)
[17:32:55] [ERROR] mysql_tquery - invalid connection handle (id: 0)
[17:32:55] [ERROR] mysql_tquery - invalid connection handle (id: 0)
[17:32:55] [ERROR] mysql_tquery - invalid connection handle (id: 0)
[17:32:55] [ERROR] mysql_tquery - invalid connection handle (id: 0)
[17:32:55] [ERROR] mysql_tquery - invalid connection handle (id: 0)
[17:32:55] [ERROR] mysql_tquery - invalid connection handle (id: 0)
[17:32:55] [ERROR] mysql_tquery - invalid connection handle (id: 0)
[17:32:55] [ERROR] mysql_tquery - invalid connection handle (id: 0)
[17:32:55] [ERROR] mysql_tquery - invalid connection handle (id: 0)
[17:32:55] [ERROR] mysql_tquery - invalid connection handle (id: 0)
[17:32:55] [ERROR] mysql_tquery - invalid connection handle (id: 0)
[17:32:55] [ERROR] mysql_tquery - invalid connection handle (id: 0)
[17:32:55] [ERROR] mysql_tquery - invalid connection handle (id: 0)
[17:32:55] [ERROR] mysql_tquery - invalid connection handle (id: 0)
[17:32:55] [ERROR] mysql_tquery - invalid connection handle (id: 0)
[17:32:55] [ERROR] mysql_tquery - invalid connection handle (id: 0)
[17:32:55] [ERROR] mysql_tquery - invalid connection handle (id: 0)
[17:32:55] [ERROR] mysql_tquery - invalid connection handle (id: 0)
[17:32:55] [ERROR] mysql_tquery - invalid connection handle (id: 0)
[17:32:55] [ERROR] mysql_tquery - invalid connection handle (id: 0)
[17:32:55] [ERROR] mysql_tquery - invalid connection handle (id: 0)
[17:32:55] [ERROR] mysql_tquery - invalid connection handle (id: 0)
[17:32:55] [ERROR] mysql_tquery - invalid connection handle (id: 0)
[17:32:55] [ERROR] mysql_tquery - invalid connection handle (id: 0)
[17:32:55] [ERROR] mysql_tquery - invalid connection handle (id: 0)
[17:32:55] [ERROR] mysql_tquery - invalid connection handle (id: 0)
[17:32:55] [ERROR] mysql_tquery - invalid connection handle (id: 0)
[17:32:55] [ERROR] mysql_tquery - invalid connection handle (id: 0)
[17:32:55] [ERROR] mysql_tquery - invalid connection handle (id: 0)
[17:32:55] [ERROR] mysql_tquery - invalid connection handle (id: 0)
[17:32:55] [ERROR] mysql_tquery - invalid connection handle (id: 0)
[17:32:55] [ERROR] mysql_tquery - invalid connection handle (id: 0)
[17:32:55] [ERROR] mysql_tquery - invalid connection handle (id: 0)
[17:32:55] [ERROR] mysql_tquery - invalid connection handle (id: 0)
[17:32:55] [ERROR] mysql_tquery - invalid connection handle (id: 0)
[17:32:55] [ERROR] mysql_tquery - invalid connection handle (id: 0)
[17:32:55] [ERROR] mysql_tquery - invalid connection handle (id: 0)
[17:32:55] [ERROR] mysql_tquery - invalid connection handle (id: 0)
[17:32:55] [ERROR] mysql_tquery - invalid connection handle (id: 0)
[17:32:55] [ERROR] mysql_tquery - invalid connection handle (id: 0)
[17:32:55] [ERROR] mysql_tquery - invalid connection handle (id: 0)
[17:32:55] [ERROR] mysql_tquery - invalid connection handle (id: 0)
[17:32:55] [ERROR] mysql_tquery - invalid connection handle (id: 0)
[17:32:55] [ERROR] mysql_tquery - invalid connection handle (id: 0)
[17:32:55] [ERROR] mysql_tquery - invalid connection handle (id: 0)
[17:32:55] [ERROR] mysql_tquery - invalid connection handle (id: 0)

Alles anzeigen

sonst steht nichts drinne...

Ich versuche aber mal LOG_ALL, mal schauen da weitere Informationen stehen...

Lg
J0a9

Jeffry · 12. Dezember 2015

Scheint als rufst du die Funktion(en) vor mysql_connect auf.

J0a9 · 12. Dezember 2015

@Jeffry:

aaaaah da lag der Fehler
Und ich hab mich immer gewundert warum so viel mit "mysql_tquery" steht.

Funktioniert nun einwandfrei

Lg
J0a9

Fraktionsfahrzeuge werden nicht geladen...

breadfish.de 12. März 2022

Ähnliche Themen

Original Pure Roleplay + Datenbank

Server startet funktioniert aber nicht

Server stürzt ab

Fraktionsautos Spawnen nicht..

Server Startet nicht!

Fraktionsfahrzeuge werden nicht geladen...[MYSQL]