autos laden

Blackshadowscript · 12. April 2015

getFreeCarID()
{
for(new i=0; i<sizeof(AutoInfo); i++)
{
if(AutoInfo[i] [Fahrzeugid]==0)return i;

}
return 0;
}
public OnPlayerCarsLoad(playerid)
{
new num_fields,num_rows;
cache_get_data(num_rows,num_fields,dbhandle);
if(!num_rows)return 1;
for(new i=0; i<num_rows; i++)
{
new id=getFreeCarID();
AutoInfo[i] [model]=cache_get_field_content_int(i,"Besitzer",dbhandle);
AutoInfo[i][Besitzer]=cache_get_field_content_int(i,"model",dbhandle);
AutoInfo[i][c_x]=cache_get_field_content_float(i,"c_x",dbhandle);
AutoInfo[i][c_y]=cache_get_field_content_float(i,"c_y",dbhandle);
AutoInfo[i][c_z]=cache_get_field_content_float(i,"c_z",dbhandle);
AutoInfo[i][c_r]=cache_get_field_content_float(i,"c_r",dbhandle);
AutoInfo[id] [db_id]=cache_get_field_content_int(i,"id",dbhandle);
AutoInfo[id][Fahrzeugid]=CreateVehicle(AutoInfo[i][model],AutoInfo[i][c_x],AutoInfo[i][c_y],AutoInfo[i][c_z],AutoInfo[i][c_r],-1,-1,-1);
}
return 1;
}
loadplayercars(playerid)
{
new query[128];
format(query,sizeof(query),"SELECT * FROM Autos WHERE Besitzer='%i' ",sInfo[playerid] [db_id]);
mysql_function_query(dbhandle,query,true,"OnPlayerCarsLoad","i"playerid);
return 1;

autos werden zwar in die db gespeichert aber werden nach server restart nicht aus der db geladen ich weiss leider auch nicht wo der fehler sein könnte

Pytroxis · 12. April 2015

Schreib loadplayercars(); dahin wo der Spieler sein Passwort richtig eingegeben hat und seine ganzen Sachen geladen werde. Einfach dazu schreiben sollte dann gehen

MFG _J0K3R_

Blackshadowscript · 12. April 2015

Joker hier noch mal der ganze code der nach deiner Meinung gehen sollte:

getFreeCarID()
{
for(new i=0; i<sizeof(AutoInfo); i++)
{
if(AutoInfo[i] [Fahrzeugid]==0)return i;

}
return 0;
}
public OnPlayerCarsLoad(playerid)
{
new num_fields,num_rows;
cache_get_data(num_rows,num_fields,dbhandle);
if(!num_rows)return 1;
for(new i=0; i<num_rows; i++)
{
new id=getFreeCarID();
AutoInfo[id] [model]=cache_get_field_content_int(i,"Besitzer",dbhandle);
AutoInfo[id][Besitzer]=cache_get_field_content_int(i,"model",dbhandle);
AutoInfo[id][c_x]=cache_get_field_content_float(i,"c_x",dbhandle);
AutoInfo[id][c_y]=cache_get_field_content_float(i,"c_y",dbhandle);
AutoInfo[id][c_z]=cache_get_field_content_float(i,"c_z",dbhandle);
AutoInfo[id][c_r]=cache_get_field_content_float(i,"c_r",dbhandle);
AutoInfo[id] [db_id]=cache_get_field_content_int(i,"id",dbhandle);
AutoInfo[id][Fahrzeugid]=CreateVehicle(AutoInfo[id][model],AutoInfo[id][c_x],AutoInfo[id][c_y],AutoInfo[id][c_z],AutoInfo[id][c_r],-1,-1,-1);
}
return 1;
}
loadplayercars(playerid)
{
new query[128];
format(query,sizeof(query),"SELECT * FROM Autos WHERE Besitzer='%i' ",sInfo[playerid] [db_id]);
mysql_function_query(dbhandle,query,true,"OnPlayerCarsLoad","i"playerid);
return 1;
}
public OnPasswordResponse(playerid)
{
new num_fields,num_rows;
cache_get_data(num_rows,num_fields,dbhandle);
if(num_rows==1) //Passwort richtig
{
sInfo[playerid][eingeloggt] = 1;
SendClientMessage(playerid,helbau,"Du hast dich erfolgreich eingeloggt!");
sInfo[playerid][level] = cache_get_field_content_int(0,"level",dbhandle);
SetPlayerScore(playerid,sInfo[playerid][level]);
sInfo[playerid][Adminlevel] = cache_get_field_content_int(0,"Adminlevel",dbhandle);
SetPlayerMoney(playerid,cache_get_field_content_int(0,"money",dbhandle));
sInfo[playerid] [db_id] = cache_get_field_content_int(0,"id",dbhandle);
loadplayercars(playerid);

}
else //Passwort falsch
{

}
return 1;
}

es geht einfach nicht

Pytroxis · 12. April 2015

Weis jetzt auch nicht woran es liegt. Guck dir mal hier das Video an vlt hilft es dir ja Weiter: Klick mich

Blackshadowscript · 12. April 2015

MrMonatHD ist veraltet.

Jeffry bitte einmal dein lösungsweg

AirM4X · 12. April 2015

getFreeCarID()
{
for(new i=0; i<sizeof(AutoInfo); i++)
{
if(AutoInfo[i][Fahrzeugid] == 0)return i;
}
return 0;
}
loadplayercars(playerid)
{
new query[128];
format(query,sizeof(query),"SELECT * FROM Autos WHERE Besitzer='%i' ",sInfo[playerid] [db_id]);
mysql_function_query(dbhandle,query,true,"OnPlayerCarsLoad","i",playerid);
return 1;
}
public OnPlayerCarsLoad(playerid)
{
printf("OnPlayerCarsLoad playerid: %d",playerid);
if(!cache_num_rows())return 1;
printf("rows: %d",cache_num_rows());
for(new i;i<cache_num_rows();i++)
{
new id = getFreeCarID();
AutoInfo[id][model]=cache_get_field_content_int(i,"Besitzer",dbhandle);
AutoInfo[id][Besitzer]=cache_get_field_content_int(i,"model",dbhandle);
AutoInfo[id][c_x]=cache_get_field_content_float(i,"c_x",dbhandle);
AutoInfo[id][c_y]=cache_get_field_content_float(i,"c_y",dbhandle);
AutoInfo[id][c_z]=cache_get_field_content_float(i,"c_z",dbhandle);
AutoInfo[id][c_r]=cache_get_field_content_float(i,"c_r",dbhandle);
AutoInfo[id][db_id]=cache_get_field_content_int(i,"id",dbhandle);
AutoInfo[id][Fahrzeugid]=CreateVehicle(AutoInfo[id][model],AutoInfo[id][c_x],AutoInfo[id][c_y],AutoInfo[id][c_z],AutoInfo[id][c_r],-1,-1,-1);
}
return 1;
}

Was wird geprintet?

Blackshadowscript · 12. April 2015

ich printe eigentlich garnichts

AirM4X · 12. April 2015

Ich habe dir hier doch zwei Prints eingebaut, kommt da nichts?
public OnPlayerCarsLoad(playerid)
{
printf("OnPlayerCarsLoad playerid: %d",playerid);
if(!cache_num_rows())return 1;
printf("rows: %d",cache_num_rows());
Wenn nicht, dann lasse dir mal die Query printen ( print(query); )

Blackshadowscript · 12. April 2015

Mencent kannst du hiermit was anfangen?

----------------------------------
[13:11:52] Blackshadowscript
[13:11:52] ----------------------------------

[13:11:52] Number of vehicle models: 0
[13:11:52] num rows = 1
[13:12:08] OnPlayerCarsLoad playerid: 0
[13:12:08] rows: 2
[13:12:13] [part] Blackshadow has left the server (0:1)
[13:12:17] --- Server Shutting Down.
[13:12:17] Der Server wurde beendet
[13:12:17]

[13:12:17] ===============================

[13:12:17] sscanf plugin unloaded.

[13:12:17] ===============================

[13:12:17] plugin.mysql: Unloading plugin...
[13:12:17] plugin.mysql: Plugin unloaded.

lernen.p(640) : error 017: undefined symbol "i"
lernen.p(641) : error 017: undefined symbol "i"
lernen.p(642) : error 017: undefined symbol "i"
lernen.p(643) : error 017: undefined symbol "i"
lernen.p(644) : error 017: undefined symbol "i"
lernen.p(645) : error 017: undefined symbol "i"
lernen.p(646) : error 017: undefined symbol "i"

Jeffry · 12. April 2015

Bei welchem Code kommen denn die Errors?

Blackshadowscript · 12. April 2015

also ich habe jetzt zwar drin aber autos werden immer noch nicht geladen aus der db

Jeffry · 12. April 2015

Hm?
Sind die Errors behoben? Wenn ja, poste bitte den aktuellen Code.

Blackshadowscript · 12. April 2015

getFreeCarID()
{
for(new i=0; i<sizeof(AutoInfo); i++)
{
if(AutoInfo[i][Fahrzeugid] == 0)return i;
}
return 0;
}
loadplayercars(playerid)
{
new query[128];
format(query,sizeof(query),"SELECT * FROM Autos WHERE Besitzer='%i' ",sInfo[playerid] [db_id]);
mysql_function_query(dbhandle,query,true,"OnPlayerCarsLoad","i",playerid);
return 1;
}
public OnPlayerCarsLoad(playerid)
{
new num_fields,num_rows;
cache_get_data(num_rows,num_fields,dbhandle);
if(!num_rows)return 1;
for(new i=0; i<num_rows; i++)
{
new id=getFreeCarID();
AutoInfo[id] [model]=cache_get_field_content_int(i,"Besitzer",dbhandle);
AutoInfo[id][Besitzer]=cache_get_field_content_int(i,"model",dbhandle);
AutoInfo[id][c_x]=cache_get_field_content_float(i,"c_x",dbhandle);
AutoInfo[id][c_y]=cache_get_field_content_float(i,"c_y",dbhandle);
AutoInfo[id][c_z]=cache_get_field_content_float(i,"c_z",dbhandle);
AutoInfo[id][c_r]=cache_get_field_content_float(i,"c_r",dbhandle);
AutoInfo[id] [db_id]=cache_get_field_content_int(i,"id",dbhandle);
AutoInfo[id][Fahrzeugid]=CreateVehicle(AutoInfo[id][model],AutoInfo[id][c_x],AutoInfo[id][c_y],AutoInfo[id][c_z],AutoInfo[id][c_r],-1,-1,-1);
}
return 1;
}
public OnPasswordResponse(playerid)
{
new num_fields,num_rows;
cache_get_data(num_rows,num_fields,dbhandle);
if(num_rows==1) //Passwort richtig
{
sInfo[playerid][eingeloggt] = 1;
SendClientMessage(playerid,helbau,"Du hast dich erfolgreich eingeloggt!");
sInfo[playerid][level] = cache_get_field_content_int(0,"level",dbhandle);
SetPlayerScore(playerid,sInfo[playerid][level]);
sInfo[playerid][Adminlevel] = cache_get_field_content_int(0,"Adminlevel",dbhandle);
SetPlayerMoney(playerid,cache_get_field_content_int(0,"money",dbhandle));
sInfo[playerid] [db_id] = cache_get_field_content_int(0,"id",dbhandle);
loadplayercars(playerid);

}
else //Passwort falsch
{

}
return 1;
}

Jeffry · 12. April 2015

Das sieht alles richtig aus.
Füge bei OnGameModeInit das hier ein:
mysql_log(LOG_ALL);

Dann poste was im MySQL Log steht, wenn du dich einloggst.

Blackshadowscript · 12. April 2015

SQL

[13:20:37] [DEBUG] cache_get_field_content_int - row: 2, field_name: "Besitzer", connection: 1
[13:20:37] [DEBUG] CMySQLResult::GetRowDataByName - row: '2', field: "Besitzer", data: "0"
[13:20:37] [DEBUG] cache_get_field_content_int - row: 2, field_name: "model", connection: 1
[13:20:37] [DEBUG] CMySQLResult::GetRowDataByName - row: '2', field: "model", data: "560"
[13:20:37] [DEBUG] cache_get_field_content_float - row: 2, field_name: "c_x", connection: 1
[13:20:37] [WARNING] CMySQLResult::GetRowDataByName - field not found ("c_x")
[13:20:37] [ERROR] cache_get_field_content_float - invalid datatype
[13:20:37] [DEBUG] cache_get_field_content_float - row: 2, field_name: "c_y", connection: 1
[13:20:37] [WARNING] CMySQLResult::GetRowDataByName - field not found ("c_y")
[13:20:37] [ERROR] cache_get_field_content_float - invalid datatype
[13:20:37] [DEBUG] cache_get_field_content_float - row: 2, field_name: "c_z", connection: 1
[13:20:37] [WARNING] CMySQLResult::GetRowDataByName - field not found ("c_z")
[13:20:37] [ERROR] cache_get_field_content_float - invalid datatype
[13:20:37] [DEBUG] cache_get_field_content_float - row: 2, field_name: "c_r", connection: 1
[13:20:37] [WARNING] CMySQLResult::GetRowDataByName - field not found ("c_r")
[13:20:37] [ERROR] cache_get_field_content_float - invalid datatype
[13:20:37] [DEBUG] cache_get_field_content_int - row: 2, field_name: "id", connection: 1
[13:20:37] [DEBUG] CMySQLResult::GetRowDataByName - row: '2', field: "id", data: "79"
[13:20:37] [DEBUG] cache_get_row_count - connection: 1
[13:20:37] [DEBUG] CMySQLResult::~CMySQLResult() - deconstructor called
[13:21:10] [DEBUG] mysql_close - connection: 1
[13:21:10] [DEBUG] CMySQLConnection::Disconnect - connection was closed
[13:21:10] [DEBUG] CMySQLConnection::Disconnect - connection was closed
[13:21:10] [DEBUG] CMySQLConnection::Disconnect - connection was closed
[13:21:10] [DEBUG] CMySQLHandle::~CMySQLHandle - deconstructor called

Alles anzeigen

Jeffry · 12. April 2015

Zitat

[13:20:37] [WARNING] CMySQLResult::GetRowDataByName - field not found ("c_x")
[13:20:37] [ERROR] cache_get_field_content_float - invalid datatype

In deiner Tabelle Autos scheinen diese Koordinaten-Felder nicht zu existieren.

Blackshadowscript · 12. April 2015

ich habe es als x y z und r drin

Jeffry · 12. April 2015

Dann musst du es entweder in der Datenbank zu c_x (etc) ändern, oder im Code zu x (etc) ändern.

Blackshadowscript · 12. April 2015

es geht leider immer noch nicht obwohl ich die db geändert habe zu c_x und so

Beitrag von Blackshadowscript (12. April 2015)