MySQL speichert SpawnLoc nicht ab, alles andere aber schon

Sharpadox · 19. November 2012

Hey,

wie die Überschrift schon sagt ..

stock SavePlayer(playerid)
{
if(IsPlayerConnected(playerid) && !IsPlayerNPC(playerid))
{
if(GetPVarInt(playerid,"Eingeloggt") == 1)
{
GetPlayerName(playerid, PlayerInfo[playerid][pName], MAX_PLAYER_NAME);
mysql_SetInt("accountsdm", "Geld", GetPlayerMoney(playerid), "Name", PlayerInfo[playerid][pName]);
mysql_SetInt("accountsdm", "Level", GetPlayerScore(playerid), "Name", PlayerInfo[playerid][pName]);
mysql_SetInt("accountsdm", "Morde", PlayerInfo[playerid][pKills], "Name", PlayerInfo[playerid][pName]);
mysql_SetInt("accountsdm", "Tode", PlayerInfo[playerid][pDeaths], "Name", PlayerInfo[playerid][pName]);
mysql_SetInt("accountsdm", "AdminLevel", PlayerInfo[playerid][pAdmin], "Name", PlayerInfo[playerid][pName]);
mysql_SetInt("accountsdm", "SpawnLoc", PlayerInfo[playerid][pSpawnLoc], "Name", PlayerInfo[playerid][pName]);
}
}
return 1;
}

Diese Sachen werden alle richtig abgespeichert. Nur SpawnLoc wird nicht abgespeichert.. Aber wieso?

Easy-Games · 19. November 2012

Guten Abend,
Zeig mal bitte den Stock/Public wo du SpawnLoc Speicherst/Abrufst.

MFG
Easy-Games ~ Webmaster

Sharpadox · 19. November 2012

Oben steht ja der Stock zum abspeichern.
Hier ist mein stock zum Laden:

stock LoadPlayer(playerid)
{
if(IsPlayerConnected(playerid) && !IsPlayerNPC(playerid))
{
GetPlayerName(playerid, PlayerInfo[playerid][pName], MAX_PLAYER_NAME);
GivePlayerMoney(playerid,mysql_GetInt("accountsdm", "Geld", "Name", PlayerInfo[playerid][pName]));
SetPlayerScore(playerid, mysql_GetInt("accountsdm", "Level", "Name", PlayerInfo[playerid][pName]));
PlayerInfo[playerid][pKills] = mysql_GetInt("accountsdm","Morde","Name",PlayerInfo[playerid][pName]);
PlayerInfo[playerid][pDeaths] = mysql_GetInt("accountsdm","Tode","Name",PlayerInfo[playerid][pName]);
PlayerInfo[playerid][pAdmin] = mysql_GetInt("accountsdm","AdminLevel","Name",PlayerInfo[playerid][pName]);
PlayerInfo[playerid][pSpawnLoc] = mysql_GetInt("accountsdm","SpawnLoc","Name",PlayerInfo[playerid][pName]);
}
return 1;
}

GangstaSunny-RENAMED · 19. November 2012

Wie genau soll das den aussehen?
000X, 000Y, 000Z oder wie?

Falls ja arbeite mit MySQL-Float.

Sharpadox · 19. November 2012

Nein SpawnLoc ist ein Integer.
Weil beim registrieren kann man sich eine Location aussuchen.

1 - San Fiero City
2 - San Fiero Dorf
3 - Los Santos CIty
4 - Los Santos Dorf

Dudalus · 19. November 2012

Hi

Entwurf der Datenbank wär noch sinnvoll
MySQL Log
Server Log

Wird der Wert ingame überhaupt gesetzt ? Prüf mal per printf nach

Sharpadox · 19. November 2012

Tabelle

Spoiler anzeigen

MySQL Log

Spoiler anzeigen

Was meinst du mit Serverlog?

Dudalus · 19. November 2012

Ich meine die server_log.txt und die MySQL Log vom SA-MP MySQL Plugin

Sharpadox · 19. November 2012

MySQL Log (vom abspeichern):

Spoiler anzeigen

Code

[13:11:33] >> mysql_real_escape_string( Connection handle: 1 )[13:11:33] CMySQLHandler::EscapeString(accountsdm); - Escaped 10 characters to accountsdm.[13:11:33] >> mysql_real_escape_string( Connection handle: 1 )[13:11:33] CMySQLHandler::EscapeString(Geld); - Escaped 4 characters to Geld.[13:11:33] >> mysql_real_escape_string( Connection handle: 1 )[13:11:33] CMySQLHandler::EscapeString(Name); - Escaped 4 characters to Name.[13:11:33] >> mysql_real_escape_string( Connection handle: 1 )[13:11:33] CMySQLHandler::EscapeString(Sh12); - Escaped 4 characters to Sh12.[13:11:33] >> mysql_query( Connection handle: 1 )[13:11:33] CMySQLHandler::Query(UPDATE `accountsdm` SET `Geld` = '0' WHERE `Name` = 'Sh12') - Successfully executed.[13:11:33] >> mysql_real_escape_string( Connection handle: 1 )[13:11:33] CMySQLHandler::EscapeString(accountsdm); - Escaped 10 characters to accountsdm.[13:11:33] >> mysql_real_escape_string( Connection handle: 1 )[13:11:33] CMySQLHandler::EscapeString(Level); - Escaped 5 characters to Level.[13:11:33] >> mysql_real_escape_string( Connection handle: 1 )[13:11:33] CMySQLHandler::EscapeString(Name); - Escaped 4 characters to Name.[13:11:33] >> mysql_real_escape_string( Connection handle: 1 )[13:11:33] CMySQLHandler::EscapeString(Sh12); - Escaped 4 characters to Sh12.[13:11:33] >> mysql_query( Connection handle: 1 )[13:11:33] CMySQLHandler::Query(UPDATE `accountsdm` SET `Level` = '0' WHERE `Name` = 'Sh12') - Successfully executed.[13:11:33] >> mysql_real_escape_string( Connection handle: 1 )[13:11:33] CMySQLHandler::EscapeString(accountsdm); - Escaped 10 characters to accountsdm.[13:11:33] >> mysql_real_escape_string( Connection handle: 1 )[13:11:33] CMySQLHandler::EscapeString(Morde); - Escaped 5 characters to Morde.[13:11:33] >> mysql_real_escape_string( Connection handle: 1 )[13:11:33] CMySQLHandler::EscapeString(Name); - Escaped 4 characters to Name.[13:11:33] >> mysql_real_escape_string( Connection handle: 1 )[13:11:33] CMySQLHandler::EscapeString(Sh12); - Escaped 4 characters to Sh12.[13:11:33] >> mysql_query( Connection handle: 1 )[13:11:33] CMySQLHandler::Query(UPDATE `accountsdm` SET `Morde` = '0' WHERE `Name` = 'Sh12') - Successfully executed.[13:11:33] >> mysql_real_escape_string( Connection handle: 1 )[13:11:33] CMySQLHandler::EscapeString(accountsdm); - Escaped 10 characters to accountsdm.[13:11:33] >> mysql_real_escape_string( Connection handle: 1 )[13:11:33] CMySQLHandler::EscapeString(Tode); - Escaped 4 characters to Tode.[13:11:33] >> mysql_real_escape_string( Connection handle: 1 )[13:11:33] CMySQLHandler::EscapeString(Name); - Escaped 4 characters to Name.[13:11:33] >> mysql_real_escape_string( Connection handle: 1 )[13:11:33] CMySQLHandler::EscapeString(Sh12); - Escaped 4 characters to Sh12.[13:11:33] >> mysql_query( Connection handle: 1 )[13:11:33] CMySQLHandler::Query(UPDATE `accountsdm` SET `Tode` = '0' WHERE `Name` = 'Sh12') - Successfully executed.[13:11:33] >> mysql_real_escape_string( Connection handle: 1 )[13:11:33] CMySQLHandler::EscapeString(accountsdm); - Escaped 10 characters to accountsdm.[13:11:33] >> mysql_real_escape_string( Connection handle: 1 )[13:11:33] CMySQLHandler::EscapeString(AdminLevel); - Escaped 10 characters to AdminLevel.[13:11:33] >> mysql_real_escape_string( Connection handle: 1 )[13:11:33] CMySQLHandler::EscapeString(Name); - Escaped 4 characters to Name.[13:11:33] >> mysql_real_escape_string( Connection handle: 1 )[13:11:33] CMySQLHandler::EscapeString(Sh12); - Escaped 4 characters to Sh12.[13:11:33] >> mysql_query( Connection handle: 1 )[13:11:33] CMySQLHandler::Query(UPDATE `accountsdm` SET `AdminLevel` = '1' WHERE `Name` = 'Sh12') - Successfully executed.[13:11:33] >> mysql_real_escape_string( Connection handle: 1 )[13:11:33] CMySQLHandler::EscapeString(accountsdm); - Escaped 10 characters to accountsdm.[13:11:33] >> mysql_real_escape_string( Connection handle: 1 )[13:11:33] CMySQLHandler::EscapeString(SpawnLoc); - Escaped 8 characters to SpawnLoc.[13:11:33] >> mysql_real_escape_string( Connection handle: 1 )[13:11:33] CMySQLHandler::EscapeString(Name); - Escaped 4 characters to Name.[13:11:33] >> mysql_real_escape_string( Connection handle: 1 )[13:11:33] CMySQLHandler::EscapeString(Sh12); - Escaped 4 characters to Sh12.[13:11:33] >> mysql_query( Connection handle: 1 )[13:11:33] CMySQLHandler::Query(UPDATE `accountsdm` SET `SpawnLoc` = '0' WHERE `Name` = 'Sh12') - Successfully executed.

Spoiler anzeigen

server_log

Spoiler anzeigen

Code

----------Loaded log file: "server_log.txt".----------SA-MP Dedicated Server----------------------v0.3e-R2, (C)2005-2012 SA-MP Team[13:10:52] [13:10:52] Server Plugins[13:10:52] --------------[13:10:52]  Loading plugin: mysql[13:10:53]   > MySQL plugin R5 successfully loaded.[13:10:53]   Loaded.[13:10:53]  Loaded 1 plugins.[13:10:53] [13:10:53] Ban list[13:10:53] --------[13:10:53]  Loaded: samp.ban[13:10:53] [13:10:53] [13:10:53] Filterscripts[13:10:53] ---------------[13:10:53]   Loading filterscript 'lspd.amx'...[13:10:53]   Loaded 1 filterscripts.[13:10:53] <-| [MYSQL] Verbindung zur Datenbank wurde erfolgreich hergestellt![13:10:53] ----------------------------------[13:10:53]  German Team Deatchmatch [TDM] loadet...[13:10:53] ----------------------------------[13:10:53] Number of vehicle models: 32

Spoiler anzeigen

breadfish.de 11. März 2022