Autos laden nicht

timm462f · 26. Juni 2016

Hey kann mir jemand sagen wo ich einen Fehler habe?

public OnPlayerCarsLoad(playerid)
{
new num_rows;
if(!num_rows)return 1;
for(new i=0; i<num_rows; i++)
{
new id=getFreeCarID();
cInfo[id][carmodel] = mysql_GetIntByInt("Autos","model","besitzer",PlayerInfo[playerid][pMySQLID]);
cInfo[id][besitzer] = mysql_GetIntByInt("Autos","besitzer","besitzer",PlayerInfo[playerid][pMySQLID]);
cInfo[id][c_x] = mysql_GetFloatByInt("Autos","x","besitzer",PlayerInfo[playerid][pMySQLID]);
cInfo[id][c_y] = mysql_GetFloatByInt("Autos","y","besitzer",PlayerInfo[playerid][pMySQLID]);
cInfo[id][c_z] = mysql_GetFloatByInt("Autos","z","besitzer",PlayerInfo[playerid][pMySQLID]);
cInfo[id][c_r] = mysql_GetFloatByInt("Autos","r","besitzer",PlayerInfo[playerid][pMySQLID]);
cInfo[id][db_id] = mysql_GetIntByInt("Autos","id","besitzer",PlayerInfo[playerid][pMySQLID]);
cInfo[id][id_x]=CreateVehicle(cInfo[id][carmodel],cInfo[id][c_x],cInfo[id][c_y],cInfo[id][c_z],cInfo[id][c_r],-1,-1,-1);
}
return 1;
}

loadPlayerCars(playerid)
{
new query[128];
format(query,sizeof(query),"SELECT * FROM autos WHERE besitzer='%i'",PlayerInfo[playerid][pMySQLID]);
mysql_function_query(dbhandle,query,true,"OnPlayerCarsLoad","i",playerid);
return 1;
}

Sie werden gespeichert aber nicht aus der DB geladen

Jeffry · 26. Juni 2016

new num_rows;
Zu
new num_rows = cache_num_rows();

timm462f · 26. Juni 2016

Bekomme den error

error 017: undefined symbol "cache_num_rows"

Jeffry · 26. Juni 2016

Dann hast du eine etwas ältere Version. Ändere es zu:
new num_rows, num_fields;
cache_get_data(num_rows, num_fields);

timm462f · 26. Juni 2016

Es ist version MySQL v2.1

Edit://

Jetzt bekomme ich den Fehler

error 017: undefined symbol "cache_get_data"

Jeffry · 26. Juni 2016

Ah, so alt.
Dann:
new num_rows = mysql_num_rows();

Jetzt haben wir alle Varianten durch

timm462f · 26. Juni 2016

Die Fahrzeuge sind aber immer noch nicht da

Nils24hero · 26. Juni 2016

hast du inzwischen einen mysql log?
dann bitte posten

timm462f · 26. Juni 2016

Da steht nichts von den Autos mitbei habe ich schon nachgeguckt

Nils24hero · 26. Juni 2016

dann magst du ma deine teamviewer daten geben dann schaue ich ma drüber
kannst gerne auch dazu auf meinen ts kommen
ts.mvs-reallife.de
bg

timm462f · 26. Juni 2016

Also es muss hier irgendwo liegen

public OnPlayerCarsLoad(playerid){ new query[128]; format(query,sizeof(query),"SELECT * FROM autos WHERE besitzer='%i'",PlayerInfo[playerid][pMySQLID]); mysql_query(query); SendClientMessage(playerid,COLOR_RED,"Bis hier geht es"); new num_rows = mysql_num_rows(); if(!num_rows)return 1; for(new i=0; i<num_rows; i++) { new id=getFreeCarID(); cInfo[i][carmodel] = mysql_GetIntByInt("autos","model","besitzer",PlayerInfo[playerid][pMySQLID]); cInfo[i][besitzer] = mysql_GetIntByInt("autos","besitzer","besitzer",PlayerInfo[playerid][pMySQLID]); cInfo[i][c_x] = mysql_GetFloatByInt("autos","x","besitzer",PlayerInfo[playerid][pMySQLID]); cInfo[i][c_y] = mysql_GetFloatByInt("autos","y","besitzer",PlayerInfo[playerid][pMySQLID]); cInfo[i][c_z] = mysql_GetFloatByInt("autos","z","besitzer",PlayerInfo[playerid][pMySQLID]); cInfo[i][c_r] = mysql_GetFloatByInt("autos","r","besitzer",PlayerInfo[playerid][pMySQLID]); cInfo[i][db_id] = mysql_GetIntByInt("autos","id","besitzer",PlayerInfo[playerid][pMySQLID]); cInfo[i][id_x]=CreateVehicle(cInfo[i][carmodel],cInfo[i][c_x],cInfo[i][c_y],cInfo[i][c_z],cInfo[i][c_r],-1,-1,-1); } return 1;}

Du nachricht wird an dem Spieler Ingame gesendet

SendClientMessage(playerid,COLOR_RED,"Bis hier geht es");
new num_rows;
if(!num_rows)return 1;
for(new i=0; i<num_rows; i++)
{
new id=getFreeCarID();
SendClientMessage(playerid,COLOR_RED,"Bis hier geht es auch");

Die 2 Nachricht wird nicht mehr angezeigt

Nils24hero · 26. Juni 2016

Spoiler anzeigen

timm462f · 26. Juni 2016

public OnPlayerCarsLoad(playerid)
{
new query[128];
format(query,sizeof(query),"SELECT * FROM autos WHERE besitzer='%i'",PlayerInfo[playerid][pMySQLID]);
mysql_query(query);
SendClientMessage(playerid,COLOR_RED,"Bis hier geht es");
new num_rows;
for(new i=0; i<num_rows; i++)
{
new id=getFreeCarID();
SendClientMessage(playerid,COLOR_RED,"Bis hier geht es auch");
cInfo[i][carmodel] = mysql_GetIntByInt("autos","model","besitzer",PlayerInfo[playerid][pMySQLID]);
cInfo[i][besitzer] = mysql_GetIntByInt("autos","besitzer","besitzer",PlayerInfo[playerid][pMySQLID]);
cInfo[i][c_x] = mysql_GetFloatByInt("autos","x","besitzer",PlayerInfo[playerid][pMySQLID]);
cInfo[i][c_y] = mysql_GetFloatByInt("autos","y","besitzer",PlayerInfo[playerid][pMySQLID]);
cInfo[i][c_z] = mysql_GetFloatByInt("autos","z","besitzer",PlayerInfo[playerid][pMySQLID]);
cInfo[i][c_r] = mysql_GetFloatByInt("autos","r","besitzer",PlayerInfo[playerid][pMySQLID]);
cInfo[i][db_id] = mysql_GetIntByInt("autos","id","besitzer",PlayerInfo[playerid][pMySQLID]);
cInfo[i][id_x]=CreateVehicle(cInfo[i][carmodel],cInfo[i][c_x],cInfo[i][c_y],cInfo[i][c_z],cInfo[i][c_r],-1,-1,-1);
}
return 1;
}

Habe es jetzt so geht aber immer noch nicht

Nils24hero · 26. Juni 2016

Spoiler anzeigen

zu

Spoiler anzeigen

und dann den server log posten

timm462f · 26. Juni 2016

Code

[22:05:14] --- Server Shutting Down.
[22:05:14] [MySQL] Error (0): Failed to exeute query. Commands out of sync; you can't run this command now.
[22:05:14] [MySQL] Error (0): Failed to exeute query. Commands out of sync; you can't run this command now.
[22:05:14] [MySQL] Error (0): Failed to exeute query. Commands out of sync; you can't run this command now.
[22:05:14] [MySQL] Error (0): Failed to exeute query. Commands out of sync; you can't run this command now.
[22:05:14] [MySQL] Error (0): Failed to exeute query. Commands out of sync; you can't run this command now.
[22:05:14] [MySQL] Error (0): Failed to exeute query. Commands out of sync; you can't run this command now.
[22:05:14] [MySQL] Error (0): Failed to exeute query. Commands out of sync; you can't run this command now.
[22:05:14] [MySQL] Error (0): Failed to exeute query. Commands out of sync; you can't run this command now.
[22:05:14] [MySQL] Error (0): Failed to exeute query. Commands out of sync; you can't run this command now.
[22:05:14] [MySQL] Error (0): Failed to exeute query. Commands out of sync; you can't run this command now.
[22:05:14] [MySQL] Error (0): Failed to exeute query. Commands out of sync; you can't run this command now.
[22:05:14] [MySQL] Error (0): Failed to exeute query. Commands out of sync; you can't run this command now.
[22:05:14] [MySQL] Error (0): Failed to exeute query. Commands out of sync; you can't run this command now.
[22:05:14] [MySQL] Error (0): Failed to exeute query. Commands out of sync; you can't run this command now.
[22:05:14] [MySQL] Error (0): Failed to exeute query. Commands out of sync; you can't run this command now.
[22:05:14] Speichere Contracts
[22:05:14] [MySQL] Error (0): Failed to exeute query. Commands out of sync; you can't run this command now.
[22:05:14] [MySQL] Error (0): Failed to exeute query. Commands out of sync; you can't run this command now.
[22:05:14] [MySQL] Error (0): Failed to exeute query. Commands out of sync; you can't run this command now.
[22:05:14] [MySQL] Error (0): Failed to exeute query. Commands out of sync; you can't run this command now.
[22:05:14] [MySQL] Error (0): Failed to exeute query. Commands out of sync; you can't run this command now.
[22:05:14] [MySQL] Error (0): Failed to exeute query. Commands out of sync; you can't run this command now.
[22:05:14] [MySQL] Error (0): Failed to exeute query. Commands out of sync; you can't run this command now.
[22:05:14] [MySQL] Error (0): Failed to exeute query. Commands out of sync; you can't run this command now.
[22:05:14] [MySQL] Error (0): Failed to exeute query. Commands out of sync; you can't run this command now.
[22:05:14] [MySQL] Error (0): Failed to exeute query. Commands out of sync; you can't run this command now.
[22:05:14] [MySQL] Error (0): Failed to exeute query. Commands out of sync; you can't run this command now.
[22:05:14] [MySQL] Error (0): Failed to exeute query. Commands out of sync; you can't run this command now.
[22:05:14] [MySQL] Error (0): Failed to exeute query. Commands out of sync; you can't run this command now.
[22:05:14] [MySQL] Error (0): Failed to exeute query. Commands out of sync; you can't run this command now.
[22:05:14] [MySQL] Error (0): Failed to exeute query. Commands out of sync; you can't run this command now.
[22:05:14] [MySQL] Error (0): Failed to exeute query. Commands out of sync; you can't run this command now.
[22:05:14] [MySQL] Error (0): Failed to exeute query. Commands out of sync; you can't run this command now.
[22:05:14] [MySQL] Error (0): Failed to exeute query. Commands out of sync; you can't run this command now.
[22:05:14] [MySQL] Error (0): Failed to exeute query. Commands out of sync; you can't run this command now.
[22:05:14] [MySQL] Error (0): Failed to exeute query. Commands out of sync; you can't run this command now.
[22:05:14] [MySQL] Error (0): Failed to exeute query. Commands out of sync; you can't run this command now.
[22:05:14] [MySQL] Error (0): Failed to exeute query. Commands out of sync; you can't run this command now.
[22:05:14] [MySQL] Error (0): Failed to exeute query. Commands out of sync; you can't run this command now.
[22:05:14] [MySQL] Error (0): Failed to exeute query. Commands out of sync; you can't run this command now.
[22:05:14] [MySQL] Error (0): Failed to exeute query. Commands out of sync; you can't run this command now.
[22:05:14] [MySQL] Error (0): Failed to exeute query. Commands out of sync; you can't run this command now.
[22:05:14] [MySQL] Error (0): Failed to exeute query. Commands out of sync; you can't run this command now.
[22:05:14] [MySQL] Error (0): Failed to exeute query. Commands out of sync; you can't run this command now.
[22:05:14] [MySQL] Error (0): Failed to exeute query. Commands out of sync; you can't run this command now.
[22:05:14] [MySQL] Error (0): Failed to exeute query. Commands out of sync; you can't run this command now.
[22:05:14] [MySQL] Error (0): Failed to exeute query. Commands out of sync; you can't run this command now.
[22:05:14] [MySQL] Error (0): Failed to exeute query. Commands out of sync; you can't run this command now.
[22:05:14] [MySQL] Error (0): Failed to exeute query. Commands out of sync; you can't run this command now.
[22:05:14] [MySQL] Error (0): Failed to exeute query. Commands out of sync; you can't run this command now.
[22:05:14] [MySQL] Error (0): Failed to exeute query. Commands out of sync; you can't run this command now.
[22:05:14] [MySQL] Error (0): Failed to exeute query. Commands out of sync; you can't run this command now.
[22:05:14] [MySQL] Error (0): Failed to exeute query. Commands out of sync; you can't run this command now.
[22:05:14] [MySQL] Error (0): Failed to exeute query. Commands out of sync; you can't run this command now.
[22:05:14] [MySQL] Error (0): Failed to exeute query. Commands out of sync; you can't run this command now.
[22:05:14] [MySQL] Error (0): Failed to exeute query. Commands out of sync; you can't run this command now.
[22:05:14] [MySQL] Error (0): Failed to exeute query. Commands out of sync; you can't run this command now.
[22:05:14] [MySQL] Error (0): Failed to exeute query. Commands out of sync; you can't run this command now.
[22:05:14] [MySQL] Error (0): Failed to exeute query. Commands out of sync; you can't run this command now.
[22:05:14] [MySQL] Error (0): Failed to exeute query. Commands out of sync; you can't run this command now.
[22:05:14] [MySQL] Error (0): Failed to exeute query. Commands out of sync; you can't run this command now.
[22:05:14] [MySQL] Error (0): Failed to exeute query. Commands out of sync; you can't run this command now.
[22:05:14] [MySQL] Error (0): Failed to exeute query. Commands out of sync; you can't run this command now.
[22:05:14] [MySQL] Error (0): Failed to exeute query. Commands out of sync; you can't run this command now.
[22:05:14] [MySQL] Error (0): Failed to exeute query. Commands out of sync; you can't run this command now.
[22:05:14] [MySQL] Error (0): Failed to exeute query. Commands out of sync; you can't run this command now.
[22:05:14] [MySQL] Error (0): Function: mysql_store_result called when no prior successful query executed. Commands out of sync; you can't run this command now.
[22:05:14] [MySQL] Error (0): Failed to exeute query. Commands out of sync; you can't run this command now.
[22:05:14] [MySQL] Error (0): Function: mysql_store_result called when no prior successful query executed. Commands out of sync; you can't run this command now.
[22:05:14] [MySQL] Error (0): Function: mysql_store_result called when no result stored. Commands out of sync; you can't run this command now.
[22:05:14] [MySQL] Error (0): Failed to exeute query. Commands out of sync; you can't run this command now.
[22:05:14] [MySQL] Error (0): Function: mysql_store_result called when no prior successful query executed. Commands out of sync; you can't run this command now.
[22:05:14] [MySQL] Error (0): Function: mysql_store_result called when no result stored. Commands out of sync; you can't run this command now.
[22:05:14] [MySQL] Closed (0). Logging ended.
[22:05:14] 


[22:05:14]  ===============================


[22:05:14]      sscanf plugin unloaded.    


[22:05:14]  ===============================


[22:05:14] 


*** Streamer Plugin v2.6.1 by Incognito unloaded ***


[22:05:14]  SA:MP MySQL Plugin v2.1.1 Unloaded.
[22:05:14]  
[22:05:14]  ====================
[22:05:14]  
[22:05:14]   Whirlpool unloaded
[22:05:14]  
[22:05:14]  ====================
[22:05:14]  


----------
Loaded log file: "server_log.txt".
----------


SA-MP Dedicated Server
----------------------
v0.3.7-R2, (C)2005-2015 SA-MP Team


[22:05:22] 
[22:05:22] Server Plugins
[22:05:22] --------------
[22:05:22]  Loading plugin: sscanf.so
[22:05:22] 


[22:05:22]  ===============================


[22:05:22]       sscanf plugin loaded.     


[22:05:22]    (c) 2009 Alex "Y_Less" Cole


[22:05:22]    0.3d-R2 500 Players "dnee"


[22:05:22]  ===============================


[22:05:22]   Loaded.
[22:05:22]  Loading plugin: streamer.so
[22:05:22] 


*** Streamer Plugin v2.6.1 by Incognito loaded ***


[22:05:22]   Loaded.
[22:05:22]  Loading plugin: mysql.so
[22:05:22]  SA:MP MySQL Plugin v2.1.1 Loaded.
[22:05:22]   Loaded.
[22:05:22]  Loading plugin: Whirlpool.so
[22:05:22]  
[22:05:22]  ==================
[22:05:22]  
[22:05:22]   Whirlpool loaded
[22:05:22]  
[22:05:22]  ==================
[22:05:22]  
[22:05:22]   Loaded.
[22:05:22]  Loaded 4 plugins.


[22:05:22] [MySQL] Thread running. Threadsafe: Yes.
[22:05:22] 
[22:05:22] Ban list
[22:05:22] --------
[22:05:22]  Loaded: samp.ban
[22:05:22] 
[22:05:22] 
[22:05:22] Filterscripts
[22:05:22] ---------------
[22:05:22]   Loaded 0 filterscripts.


[22:05:23] *** Streamer Plugin: Warning: Include file version (0x26104) does not match plugin version (0x26105) (script might need to be recompiled with the latest include file)
[22:05:23] [MySQL] Connected (0) to 'samp5626'@'87.98.243.201 via TCP/IP'.
[22:05:23] [MySQL] Server Version 5.5.49-0+deb7u1.
[22:05:23] MySQL-Verbindung wurde erfolgreich hergestellt
[22:05:23] Wetter ID: 15
[22:05:23] Lade Contracts
[22:05:23] Loading Navipunkte
[22:05:23] 8 Navi Punkte geladen
[22:05:23] Tankstelle 0 geladen
[22:05:23] Tankstelle 1 geladen
[22:05:23] Tankstellen wurden geladen
[22:05:23] Loading Radio System
[22:05:23] 0 Radio Stationen geladen
[22:05:23] Loading lohn
[22:05:23] 25 Lohn Infos geladen
[22:05:23] Loading Saveboxen
[22:05:23] 0 Safeboxen geladen
[22:05:23] 
--------------------------------------
[22:05:23]  Gangautohaus am laden.
[22:05:23]   '112' Fraktionsfahrzeuge wurden geladen & erstellt.
[22:05:23]  Gangautohaus geladen.
[22:05:23]  Staatsfraktionsautohaus am laden.
[22:05:23]   '76' Staatsfraktionsautos wurden geladen & erstellt.
[22:05:23]  Staatsfraktionsautohaus geladen.
[22:05:23] --------------------------------------


[22:05:23] Pickups Max = 2048, Current Pickups = 395
[22:05:23] Your Life - Gamemode
[22:05:23] wurde erfolgreich geladen.
[22:05:23] Number of vehicle models: 101
[22:05:54] Server password has been removed.
[22:06:16] [connection] 84.188.103.103:61326 requests connection cookie.
[22:06:17] [connection] incoming connection: 84.188.103.103:61326 id: 0
[22:06:18] [join] Tim has joined the server (0:84.188.103.103)
[22:06:29] [MySQL] Error (0): Function: mysql_num_rows called when no result stored.
[22:06:29] 0 num rows
[22:06:29] [MySQL] Error (0): Failed to exeute query. Commands out of sync; you can't run this command now.
[22:06:29] [MySQL] Error (0): Function: mysql_store_result called when no prior successful query executed. Commands out of sync; you can't run this command now.
[22:06:29] [MySQL] Error (0): Function: mysql_num_rows called when no result stored. Commands out of sync; you can't run this command now.
[22:06:29] [MySQL] Error (0): Failed to exeute query. Commands out of sync; you can't run this command now.
[22:06:29] [MySQL] Error (0): Failed to exeute query. Commands out of sync; you can't run this command now.
[22:06:29] [MySQL] Error (0): Function: mysql_store_result called when no prior successful query executed. Commands out of sync; you can't run this command now.
[22:06:29] [MySQL] Error (0): Function: mysql_fetch_field called when no result stored. Commands out of sync; you can't run this command now.
[22:06:29] [MySQL] Error (0): Function: mysql_fetch_field called when no result stored. Commands out of sync; you can't run this command now.
[22:06:29] [MySQL] Error (0): Function: mysql_fetch_field called when no result stored. Commands out of sync; you can't run this command now.
[22:06:29] [MySQL] Error (0): Function: mysql_fetch_field called when no result stored. Commands out of sync; you can't run this command now.
[22:06:29] [MySQL] Error (0): Function: mysql_fetch_field called when no result stored. Commands out of sync; you can't run this command now.
[22:06:29] [MySQL] Error (0): Failed to exeute query. Commands out of sync; you can't run this command now.
[22:06:29] [MySQL] Error (0): Function: mysql_store_result called when no prior successful query executed. Commands out of sync; you can't run this command now.
[22:06:29] [MySQL] Error (0): Function: mysql_num_rows called when no result stored. Commands out of sync; you can't run this command now.
[22:06:29] [MySQL] Error (0): Failed to exeute query. Commands out of sync; you can't run this command now.
[22:06:29] [MySQL] Error (0): Failed to exeute query. Commands out of sync; you can't run this command now.
[22:06:29] [MySQL] Error (0): Function: mysql_store_result called when no prior successful query executed. Commands out of sync; you can't run this command now.
[22:06:29] [MySQL] Error (0): Function: mysql_fetch_field called when no result stored. Commands out of sync; you can't run this command now.
[22:06:29] [MySQL] Error (0): Function: mysql_fetch_field called when no result stored. Commands out of sync; you can't run this command now.
[22:06:29] [MySQL] Error (0): Function: mysql_fetch_field called when no result stored. Commands out of sync; you can't run this command now.
[22:06:29] [MySQL] Error (0): Function: mysql_fetch_field called when no result stored. Commands out of sync; you can't run this command now.
[22:06:29] [MySQL] Error (0): Function: mysql_fetch_field called when no result stored. Commands out of sync; you can't run this command now.
[22:06:29] [MySQL] Error (0): Function: mysql_fetch_field called when no result stored. Commands out of sync; you can't run this command now.
[22:06:29] Tim hat sich eingeloggt.
[22:06:29] [MySQL] Error (0): Failed to exeute query. Commands out of sync; you can't run this command now.
[22:06:29] [MySQL] Error (0): Function: mysql_store_result called when no prior successful query executed. Commands out of sync; you can't run this command now.
[22:06:29] [MySQL] Error (0): Function: mysql_num_rows called when no result stored. Commands out of sync; you can't run this command now.
[22:06:29] [MySQL] Error (0): Failed to exeute query. Commands out of sync; you can't run this command now.
[22:06:29] [MySQL] Error (0): Failed to exeute query. Commands out of sync; you can't run this command now.
[22:06:29] [MySQL] Error (0): Failed to exeute query. Commands out of sync; you can't run this command now.
[22:06:39] [MySQL] Error (0): Failed to exeute query. Commands out of sync; you can't run this command now.
[22:06:39] [MySQL] Error (0): Failed to exeute query. Commands out of sync; you can't run this command now.
[22:06:39] [MySQL] Error (0): Failed to exeute query. Commands out of sync; you can't run this command now.
[22:06:39] [MySQL] Error (0): Failed to exeute query. Commands out of sync; you can't run this command now.
[22:06:39] [MySQL] Error (0): Failed to exeute query. Commands out of sync; you can't run this command now.
[22:06:39] [MySQL] Error (0): Failed to exeute query. Commands out of sync; you can't run this command now.
[22:06:39] erfolgreich alles gespeichert!
[22:06:41] [MySQL] Error (0): Failed to exeute query. Commands out of sync; you can't run this command now.
[22:06:41] [MySQL] Error (0): Failed to exeute query. Commands out of sync; you can't run this command now.
[22:06:41] [MySQL] Error (0): Failed to exeute query. Commands out of sync; you can't run this command now.
[22:06:41] [MySQL] Error (0): Failed to exeute query. Commands out of sync; you can't run this command now.
[22:06:41] [MySQL] Error (0): Failed to exeute query. Commands out of sync; you can't run this command now.
[22:06:41] [MySQL] Error (0): Failed to exeute query. Commands out of sync; you can't run this command now.
[22:06:41] [MySQL] Error (0): Failed to exeute query. Commands out of sync; you can't run this command now.
[22:06:41] [part] Tim has left the server (0:1)

Alles anzeigen

J0a9 · 27. Juni 2016

warum lädst du alles aufeinmal?

Wäre es nicht so schlauer:

Code

forward GameModeCarsLoad();
public GameModeCarsLoad()
{
	for(new i = 0; i < MAX_PLAYERS; i++)
	{
		new query[128];
		format(query,sizeof(query),"SELECT * FROM autos WHERE besitzer='%i'",PlayerInfo[i][pMySQLID]);
		mysql_function_query(MySQLHandle, query, true, "OnPlayerCarsLoad", "i", playerid);
	}
	return 1;
}

Alles anzeigen

Code

public OnPlayerCarsLoad(playerid)
{
    new num_fields,num_rows;
	cache_get_data(num_rows, num_fields, MySQLHandle);
	for(new i = 0; i < num_rows; i++)
    {
        new id=getFreeCarID();
        SendClientMessage(playerid,COLOR_RED,"Bis hier geht es auch");
        cInfo[i][carmodel] = mysql_GetIntByInt("autos","model","besitzer",PlayerInfo[playerid][pMySQLID]);
        cInfo[i][besitzer] = mysql_GetIntByInt("autos","besitzer","besitzer",PlayerInfo[playerid][pMySQLID]);
        cInfo[i][c_x] = mysql_GetFloatByInt("autos","x","besitzer",PlayerInfo[playerid][pMySQLID]);
        cInfo[i][c_y] = mysql_GetFloatByInt("autos","y","besitzer",PlayerInfo[playerid][pMySQLID]);
        cInfo[i][c_z] = mysql_GetFloatByInt("autos","z","besitzer",PlayerInfo[playerid][pMySQLID]);
        cInfo[i][c_r] = mysql_GetFloatByInt("autos","r","besitzer",PlayerInfo[playerid][pMySQLID]);
        cInfo[i][db_id] = mysql_GetIntByInt("autos","id","besitzer",PlayerInfo[playerid][pMySQLID]);
        cInfo[i][id_x]=CreateVehicle(cInfo[i][carmodel],cInfo[i][c_x],cInfo[i][c_y],cInfo[i][c_z],cInfo[i][c_r],-1,-1,-1);
    }
    return 1;
}

Alles anzeigen

Habe die 2 Sachen getrennt.
Dann musst du nur noch unter GameModeInit unter deiner MySQL Verbindung das hinzufügen:

Code

GameModeCarsLoad();

Eins musst du hier ändern undzwar habe ich hier MySQLHandle geschrieben, da ich nicht wusste wie du deine MySQL Verbindung benannt hast.
Bitte ändere es so wie du das definiert hast

Jeffry · 27. Juni 2016

Zitat von J0a9

Wäre es nicht so schlauer:

Nein, das sind dann X Anfragen an die Datenbank, anstatt einer. Das ist ressourcentechnisch nicht zu empfehlen.

Zwecks dem Fehler, du hast mysql_free_result vergessen:
public OnPlayerCarsLoad(playerid)
{
new query[128];
format(query,sizeof(query),"SELECT * FROM autos WHERE besitzer='%i'",PlayerInfo[playerid][pMySQLID]);
mysql_query(query);
SendClientMessage(playerid,COLOR_RED,"Bis hier geht es");
new num_rows = mysql_num_rows();
printf("%i num rows",num_rows);
for(new i=0; i<num_rows; i++)
{
new id=getFreeCarID();
SendClientMessage(playerid,COLOR_RED,"Bis hier geht es auch");
cInfo[i][carmodel] = mysql_GetIntByInt("autos","model","besitzer",PlayerInfo[playerid][pMySQLID]);
cInfo[i][besitzer] = mysql_GetIntByInt("autos","besitzer","besitzer",PlayerInfo[playerid][pMySQLID]);
cInfo[i][c_x] = mysql_GetFloatByInt("autos","x","besitzer",PlayerInfo[playerid][pMySQLID]);
cInfo[i][c_y] = mysql_GetFloatByInt("autos","y","besitzer",PlayerInfo[playerid][pMySQLID]);
cInfo[i][c_z] = mysql_GetFloatByInt("autos","z","besitzer",PlayerInfo[playerid][pMySQLID]);
cInfo[i][c_r] = mysql_GetFloatByInt("autos","r","besitzer",PlayerInfo[playerid][pMySQLID]);
cInfo[i][db_id] = mysql_GetIntByInt("autos","id","besitzer",PlayerInfo[playerid][pMySQLID]);
cInfo[i][id_x]=CreateVehicle(cInfo[i][carmodel],cInfo[i][c_x],cInfo[i][c_y],cInfo[i][c_z],cInfo[i][c_r],-1,-1,-1);
}
mysql_free_result();
return 1;
}

timm462f · 28. Juni 2016

Zitat von Jeffry

Zwecks dem Fehler, du hast mysql_free_result vergessen:

Habe es jetzt so gemacht laden aber immer noch nicht

/Edit

Würde euch eine Funktion helfen wo auch so ähnlich sachen geladen werden wie navi punkte aus der Datenbank ?

Jeffry · 28. Juni 2016

Setze bitte mal nach dem mysql_query(query); einen print hin:
printf("query = %s", query);

Was wird dir da im Server Log ausgegeben?

timm462f · 28. Juni 2016

Code

[18:59:03] Pickups Max = 2048, Current Pickups = 395
[18:59:03] Your Life - Gamemode
[18:59:03] wurde erfolgreich geladen.
[18:59:03] Number of vehicle models: 101
[18:59:36] Server password has been removed.
[19:00:30] [connection]  requests connection cookie.
[19:00:31] [connection] incoming connection:  id: 0
[19:00:31] [join] Tim has joined the server ()
[19:00:41] query = SELECT * FROM autos WHERE besitzer='12'
[19:00:41] [MySQL] Error (0): Function: mysql_num_rows called when no result stored.
[19:00:41] 0 num rows
[19:00:41] [MySQL] Error (0): Failed to exeute query. Commands out of sync; you can't run this command now.
[19:00:41] [MySQL] Error (0): Function: mysql_store_result called when no prior successful query executed. Commands out of sync; you can't run this command now.
[19:00:41] [MySQL] Error (0): Function: mysql_num_rows called when no result stored. Commands out of sync; you can't run this command now.
[19:00:41] [MySQL] Error (0): Failed to exeute query. Commands out of sync; you can't run this command now.
[19:00:41] [MySQL] Error (0): Failed to exeute query. Commands out of sync; you can't run this command now.
[19:00:41] [MySQL] Error (0): Function: mysql_store_result called when no prior successful query executed. Commands out of sync; you can't run this command now.
[19:00:41] [MySQL] Error (0): Function: mysql_fetch_field called when no result stored. Commands out of sync; you can't run this command now.
[19:00:41] [MySQL] Error (0): Function: mysql_fetch_field called when no result stored. Commands out of sync; you can't run this command now.
[19:00:41] [MySQL] Error (0): Function: mysql_fetch_field called when no result stored. Commands out of sync; you can't run this command now.
[19:00:41] [MySQL] Error (0): Function: mysql_fetch_field called when no result stored. Commands out of sync; you can't run this command now.
[19:00:41] [MySQL] Error (0): Function: mysql_fetch_field called when no result stored. Commands out of sync; you can't run this command now.
[19:00:41] [MySQL] Error (0): Failed to exeute query. Commands out of sync; you can't run this command now.
[19:00:41] [MySQL] Error (0): Function: mysql_store_result called when no prior successful query executed. Commands out of sync; you can't run this command now.
[19:00:41] [MySQL] Error (0): Function: mysql_num_rows called when no result stored. Commands out of sync; you can't run this command now.
[19:00:41] [MySQL] Error (0): Failed to exeute query. Commands out of sync; you can't run this command now.
[19:00:41] [MySQL] Error (0): Failed to exeute query. Commands out of sync; you can't run this command now.
[19:00:41] [MySQL] Error (0): Function: mysql_store_result called when no prior successful query executed. Commands out of sync; you can't run this command now.
[19:00:41] [MySQL] Error (0): Function: mysql_fetch_field called when no result stored. Commands out of sync; you can't run this command now.
[19:00:41] [MySQL] Error (0): Function: mysql_fetch_field called when no result stored. Commands out of sync; you can't run this command now.
[19:00:41] [MySQL] Error (0): Function: mysql_fetch_field called when no result stored. Commands out of sync; you can't run this command now.
[19:00:41] [MySQL] Error (0): Function: mysql_fetch_field called when no result stored. Commands out of sync; you can't run this command now.
[19:00:41] [MySQL] Error (0): Function: mysql_fetch_field called when no result stored. Commands out of sync; you can't run this command now.
[19:00:41] [MySQL] Error (0): Function: mysql_fetch_field called when no result stored. Commands out of sync; you can't run this command now.
[19:00:41] Tim hat sich eingeloggt.
[19:00:41] [MySQL] Error (0): Failed to exeute query. Commands out of sync; you can't run this command now.
[19:00:41] [MySQL] Error (0): Function: mysql_store_result called when no prior successful query executed. Commands out of sync; you can't run this command now.
[19:00:41] [MySQL] Error (0): Function: mysql_num_rows called when no result stored. Commands out of sync; you can't run this command now.
[19:00:41] [MySQL] Error (0): Failed to exeute query. Commands out of sync; you can't run this command now.
[19:00:41] [MySQL] Error (0): Failed to exeute query. Commands out of sync; you can't run this command now.
[19:00:41] [MySQL] Error (0): Failed to exeute query. Commands out of sync; you can't run this command now.

Alles anzeigen

Das kommt dann

Autos laden nicht

Ähnliche Themen

[SAMMELTHREAD] Kleine Scripting Fragen

Hilfe beim AutosSpeichern (Mysql)

Autos aus Mysql Datenbank laden

Autokauf Filterscript: Speichern und Laden

Kennzeichen Speichern lassen DINI