Hallo habe ein Problem er speichert alles richtig aber dann beim login crasht der client und im mysql_log steht das
die Datei besteht 50-60 mal daraus vorhin war sie größer als ein Gigabyte hat einer ne Idee
[15:19:51] [WARNING] CMySQLResult::GetRowDataByName - field not found ("Skin")
[15:19:51] [WARNING] CMySQLResult::GetRowDataByName - field not found ("LastX")
[15:19:51] [WARNING] CMySQLResult::GetRowDataByName - field not found ("LastY")
[15:19:51] [WARNING] CMySQLResult::GetRowDataByName - field not found ("LastZ")
[15:19:51] [WARNING] CMySQLResult::GetRowDataByName - field not found ("LastFcA")
[15:19:51] [WARNING] CMySQLResult::GetRowDataByName - field not found ("LastInterior")
[15:19:51] [WARNING] CMySQLResult::GetRowDataByName - field not found ("Geburtsdatum")
[15:19:51] [WARNING] CMySQLResult::GetRowDataByName - field not found ("RegDatum")
[15:19:51] [WARNING] CMySQLResult::GetRowDataByName - field not found ("Geschlecht")
[15:19:51] [WARNING] CMySQLResult::GetRowDataByName - field not found ("Daten")
Problem beim Speichern der letzten Position MySQL
- Devax
- Geschlossen
- Erledigt
-
-
Dann zeig uns mal, wie du es lädst.
-
public LoadPlayer(playerid)
{
new query[200],query2[128],name[MAX_PLAYER_NAME],num_rows,num_fields;
GetPlayerName(playerid,name,sizeof(name));
format(query,sizeof(query),"SELECT * FROM `spieler` WHERE `Name`='%s'",name);
format(query2,sizeof(query2),"SELECT * FROM `account` WHERE `Name`='%s'",name);
mysql_tquery(dbhandle,query,"LoadPlayer","i",playerid);
mysql_tquery(dbhandle,query2,"LoadPlayer","i",playerid);
cache_get_data(num_rows,num_fields,dbhandle);
SetPlayerColor(playerid,COLOR_WHITE);
cache_get_field_content(0,"Name",accInfo[playerid][Name],dbhandle);
cache_get_field_content(0,"Geburtsdatum",accInfo[playerid][Birthday],dbhandle);
cache_get_field_content(0,"RegDatum",accInfo[playerid][RegDatum],dbhandle);
cache_get_field_content(0,"Geschlecht",accInfo[playerid][Geschlecht],dbhandle);
pInfo[ playerid][pSkin] = cache_get_field_content_int(0,"Skin",dbhandle);
pInfo[playerid][pLastX] = cache_get_field_content_float(0,"LastX",dbhandle);
pInfo[playerid][pLastY] = cache_get_field_content_float(0,"LastY",dbhandle);
pInfo[playerid][pLastZ] = cache_get_field_content_float(0,"LastZ",dbhandle);
pInfo[playerid][pLastFcA] = cache_get_field_content_float(0,"LastFcA",dbhandle);
pInfo[playerid][pLastInterior] = cache_get_field_content_int(0,"LastInterior",dbhandle);
accInfo[playerid][Daten] = cache_get_field_content_int(0,"Daten",dbhandle);
SetPVarInt(playerid,"Eingeloggt",1);
SetSpawnInfo(playerid,0,pInfo[playerid][pSkin],pInfo[playerid][pLastX],pInfo[playerid][pLastY],pInfo[playerid][pLastZ],pInfo[playerid][pLastFcA],0,0,0,0,0,0);
SpawnPlayer(playerid);
SetPlayerInterior(playerid,pInfo[playerid][pLastInterior]);
} -
Hast du die Felder in der DB auch so benannt ?
-
SQL
`ID` int(10) NOT NULL AUTO_INCREMENT, `Name` varchar(50) DEFAULT NULL, `Skin` int(10) DEFAULT NULL, `Level` int(10) DEFAULT NULL, `Money` int(10) DEFAULT NULL, `LastX` float(20,5) DEFAULT NULL, `LastY` float(20,5) DEFAULT NULL, `LastZ` float(20,5) DEFAULT NULL, `LastFcA` float(20,5) DEFAULT NULL, `LastInterior` int(10) DEFAULT NULL,
Jap sollte stimmen
-
Sind die Daten in der Tabelle Spieler oder Accounts?
-
breadfish.de
Hat das Thema geschlossen.