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.deHat das Thema geschlossen.
 
		