[MYSQL] Daten werden nicht gespeichert

SqueezyZ · 21. November 2014

Hey ho,

ich möchte, dass wen ich den Befehl "/save" eingebe die Daten von mir gespeichert werden.
So habe ich es bis jetzt gemacht:

ocmd:save(playerid,params[])
{
SavePlayerInv(playerid);
return 1;
}

Der stock dazu sieht wie folgt aus:

stock SavePlayerInv(playerid)
{
if(IsPlayerConnected(playerid))
{
if(GetPVarInt(playerid,"loggedin")==1)
{
new name[MAX_PLAYER_NAME];
GetPlayerName(playerid,name,sizeof(name));
mysql_SetInt("inventar", "b_zig", GetPVarInt(playerid,"b_zig"), "Name", name);
mysql_SetInt("inventar", "m_zig", GetPVarInt(playerid,"m_zig"), "Name", name);
mysql_SetInt("inventar", "t_zig", GetPVarInt(playerid,"t_zig"), "Name", name);
mysql_SetInt("inventar", "Mats", GetPVarInt(playerid,"Mats"), "Name", name);
mysql_SetInt("inventar", "Marihuana", GetPVarInt(playerid,"Marihuana"), "Name", name);
mysql_SetInt("inventar", "Heroin", GetPVarInt(playerid,"Heroin"), "Name", name);
mysql_SetInt("inventar", "Coins", GetPVarInt(playerid,"Coins"), "Name", name);
mysql_SetInt("inventar", "Kanister", GetPVarInt(playerid,"Kanister"), "Name", name);
mysql_SetInt("inventar", "Masken", GetPVarInt(playerid,"Masken"), "Name", name);
}
}
return 1;
}

In der Datenbank habe ich einen Table namens "inventar" und sonst ist auch alles vorhanden!
Die server.log und die mysql-log sind fehlerfrei!!!

Was mache ich falsch?

xDesertx · 21. November 2014

Wurde Account mit INSERT INTO erstellt?
Zeig trotzdem mal den log.

SqueezyZ · 21. November 2014

Myql-Log:

Code

[Fri Nov 21 16:05:34 2014] -------------------------
[Fri Nov 21 16:05:34 2014]  	Logging Started
[Fri Nov 21 16:05:34 2014] -------------------------
[Fri Nov 21 16:05:35 2014] Connected (0) to test @ localhost via TCP/IP.
[Fri Nov 21 16:05:35 2014] MySQL Server Version 5.6.20.

Und die normale Server.log:

Code

SA-MP Dedicated Server
----------------------
v0.3z, (C)2005-2014 SA-MP Team


[16:05:34] 
[16:05:34] Server Plugins
[16:05:34] --------------
[16:05:34]  Loading plugin: sscanf
[16:05:34] 


[16:05:34]  ===============================


[16:05:34]   	sscanf plugin loaded. 	


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


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


[16:05:34]  ===============================


[16:05:34]   Loaded.
[16:05:34]  Loading plugin: streamer
[16:05:34] 


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


[16:05:34]   Loaded.
[16:05:34]  Loading plugin: mysql
[16:05:34]  SA:MP MySQL Plugin v2.1.1 Loaded.
[16:05:34]   Loaded.
[16:05:34]  Loading plugin: audio
[16:05:34] [MySQL] Thread running. Threadsafe: Yes.
[16:05:34]   Failed.
[16:05:34]  Loading plugin: crashdetect
[16:05:35]   CrashDetect v4.15 is OK.
[16:05:35]   Loaded.
[16:05:35]  Loading plugin: nativechecker
[16:05:35]   Failed.
[16:05:35]  Loaded 4 plugins.


[16:05:35] 
[16:05:35] Ban list
[16:05:35] --------
[16:05:35]  Loaded: samp.ban
[16:05:35] 
[16:05:35] 
[16:05:35] Filterscripts
[16:05:35] ---------------
[16:05:35]   Loading filterscript 'cbug.amx'...
[16:05:35] 
--------------------------------------
[16:05:35]  Anti C-Bug System
[16:05:35] --------------------------------------


[16:05:35]   Loading filterscript 'map.amx'...
[16:05:35]   Loading filterscript 'AnimationSystem.amx'...
[16:05:35] 
--------------------------------------
[16:05:35]       	Anims Loading          	
[16:05:35] --------------------------------------


[16:05:35]   Loading filterscript 'MSG.amx'...
[16:05:35]   Loading filterscript 'wbb_connect.amx'...
[16:05:35] 
=== WBB_Connect: ===
WBB_Connect v. 2.0
was successfully loaded!


Copyright (c) by Hauke Marquardt
====================


[16:05:35]   Loaded 5 filterscripts.


[16:05:35] [MySQL] Connected (0) to 'test'@'localhost via TCP/IP'.
[16:05:35] [MySQL] Server Version 5.6.20.
[16:05:36] Script geladen
[16:05:36] Number of vehicle models: 99

Alles anzeigen

xDesertx · 21. November 2014

Falsche mysql version, vermutte ich mal, probiere mal diese:
http://dl-it.tk/ul-8b5k

SqueezyZ · 21. November 2014

Nene
Sonst funktioniertt ja alles was mit MYSQL zu tun hat

Wie genau nutze ich denn die INSERT funktion? :o

xDesertx · 21. November 2014

Die INSERT funktion ist zum eintragen von Spalten, schick mal bitte dein mysql_SetInt stock, und am besten einen Screenshot von deiner Datenbankstruktur in phpmyadmin, oder Navi Cat oder so:O

Jeffry · 21. November 2014

Setze mal einen print vor:
new name[MAX_PLAYER_NAME];

und schau ob der überhaupt kommt:
print("SavePlayer aufgerufen");

Wenn der print kommt, dann schalte mysql_log auf LOG_ALL an und schau nach was im mysql_log geprintet wird, wenn du den Befehl eingibst.

SqueezyZ · 21. November 2014

Zitat von Jeffry

Wenn der print kommt, dann schalte mysql_log auf LOG_ALL an und schau nach was im mysql_log geprintet wird, wenn du den Befehl eingibst.

In der Log kommt folgendes:

Code

[Fri Nov 21 18:13:42 2014] Function: mysql_real_esacpe_string executed: "inventar" with result: "inventar".
[Fri Nov 21 18:13:42 2014] Function: mysql_real_esacpe_string executed: "b_zig" with result: "b_zig".
[Fri Nov 21 18:13:42 2014] Function: mysql_real_esacpe_string executed: "Name" with result: "Name".
[Fri Nov 21 18:13:42 2014] Function: mysql_real_esacpe_string executed: "Paco" with result: "Paco".
[Fri Nov 21 18:13:42 2014] Function: mysql_query executed: "UPDATE `inventar` SET `b_zig` = '0' WHERE `Name` = 'Paco'" with result: "0".
[Fri Nov 21 18:13:42 2014] Function: mysql_real_esacpe_string executed: "inventar" with result: "inventar".
[Fri Nov 21 18:13:42 2014] Function: mysql_real_esacpe_string executed: "m_zig" with result: "m_zig".
[Fri Nov 21 18:13:42 2014] Function: mysql_real_esacpe_string executed: "Name" with result: "Name".
[Fri Nov 21 18:13:42 2014] Function: mysql_real_esacpe_string executed: "Paco" with result: "Paco".
[Fri Nov 21 18:13:42 2014] Function: mysql_query executed: "UPDATE `inventar` SET `m_zig` = '0' WHERE `Name` = 'Paco'" with result: "0".
[Fri Nov 21 18:13:42 2014] Function: mysql_real_esacpe_string executed: "inventar" with result: "inventar".
[Fri Nov 21 18:13:42 2014] Function: mysql_real_esacpe_string executed: "t_zig" with result: "t_zig".
[Fri Nov 21 18:13:42 2014] Function: mysql_real_esacpe_string executed: "Name" with result: "Name".
[Fri Nov 21 18:13:42 2014] Function: mysql_real_esacpe_string executed: "Paco" with result: "Paco".
[Fri Nov 21 18:13:42 2014] Function: mysql_query executed: "UPDATE `inventar` SET `t_zig` = '0' WHERE `Name` = 'Paco'" with result: "0".
[Fri Nov 21 18:13:42 2014] Function: mysql_real_esacpe_string executed: "inventar" with result: "inventar".
[Fri Nov 21 18:13:42 2014] Function: mysql_real_esacpe_string executed: "Mats" with result: "Mats".
[Fri Nov 21 18:13:42 2014] Function: mysql_real_esacpe_string executed: "Name" with result: "Name".
[Fri Nov 21 18:13:42 2014] Function: mysql_real_esacpe_string executed: "Paco" with result: "Paco".
[Fri Nov 21 18:13:42 2014] Function: mysql_query executed: "UPDATE `inventar` SET `Mats` = '0' WHERE `Name` = 'Paco'" with result: "0".
[Fri Nov 21 18:13:42 2014] Function: mysql_real_esacpe_string executed: "inventar" with result: "inventar".
[Fri Nov 21 18:13:42 2014] Function: mysql_real_esacpe_string executed: "Marihuana" with result: "Marihuana".
[Fri Nov 21 18:13:42 2014] Function: mysql_real_esacpe_string executed: "Name" with result: "Name".
[Fri Nov 21 18:13:42 2014] Function: mysql_real_esacpe_string executed: "Paco" with result: "Paco".
[Fri Nov 21 18:13:42 2014] Function: mysql_query executed: "UPDATE `inventar` SET `Marihuana` = '0' WHERE `Name` = 'Paco'" with result: "0".
[Fri Nov 21 18:13:42 2014] Function: mysql_real_esacpe_string executed: "inventar" with result: "inventar".
[Fri Nov 21 18:13:42 2014] Function: mysql_real_esacpe_string executed: "Heroin" with result: "Heroin".
[Fri Nov 21 18:13:42 2014] Function: mysql_real_esacpe_string executed: "Name" with result: "Name".
[Fri Nov 21 18:13:42 2014] Function: mysql_real_esacpe_string executed: "Paco" with result: "Paco".
[Fri Nov 21 18:13:42 2014] Function: mysql_query executed: "UPDATE `inventar` SET `Heroin` = '0' WHERE `Name` = 'Paco'" with result: "0".
[Fri Nov 21 18:13:42 2014] Function: mysql_real_esacpe_string executed: "inventar" with result: "inventar".
[Fri Nov 21 18:13:42 2014] Function: mysql_real_esacpe_string executed: "Coins" with result: "Coins".
[Fri Nov 21 18:13:42 2014] Function: mysql_real_esacpe_string executed: "Name" with result: "Name".
[Fri Nov 21 18:13:42 2014] Function: mysql_real_esacpe_string executed: "Paco" with result: "Paco".
[Fri Nov 21 18:13:42 2014] Function: mysql_query executed: "UPDATE `inventar` SET `Coins` = '0' WHERE `Name` = 'Paco'" with result: "0".
[Fri Nov 21 18:13:42 2014] Function: mysql_real_esacpe_string executed: "inventar" with result: "inventar".
[Fri Nov 21 18:13:42 2014] Function: mysql_real_esacpe_string executed: "Kanister" with result: "Kanister".
[Fri Nov 21 18:13:42 2014] Function: mysql_real_esacpe_string executed: "Name" with result: "Name".
[Fri Nov 21 18:13:42 2014] Function: mysql_real_esacpe_string executed: "Paco" with result: "Paco".
[Fri Nov 21 18:13:42 2014] Function: mysql_query executed: "UPDATE `inventar` SET `Kanister` = '0' WHERE `Name` = 'Paco'" with result: "0".
[Fri Nov 21 18:13:42 2014] Function: mysql_real_esacpe_string executed: "inventar" with result: "inventar".
[Fri Nov 21 18:13:42 2014] Function: mysql_real_esacpe_string executed: "Masken" with result: "Masken".
[Fri Nov 21 18:13:42 2014] Function: mysql_real_esacpe_string executed: "Name" with result: "Name".
[Fri Nov 21 18:13:42 2014] Function: mysql_real_esacpe_string executed: "Paco" with result: "Paco".
[Fri Nov 21 18:13:42 2014] Function: mysql_query executed: "UPDATE `inventar` SET `Masken` = '0' WHERE `Name` = 'Paco'" with result: "0".

Alles anzeigen

P.S: Ich habe nur in de Datenbank die Tables & Zeilen reingeschrieben, die ich brauche!
Ich habe noch nichts mit der INSERT Funktiom gemacht, brauche ich das?

Jeffry · 21. November 2014

Ja, du brauchst natürlich die Zeile in der der Name "Paco" ist, in der Tabelle der Datenbank. Sonst weiß die Datenbank ja nicht, wo die Daten hinkommen.
Da solltest du anlegen, sonst klappt es natürlich nicht.

SqueezyZ · 21. November 2014

Zitat

Da solltest du anlegen, sonst klappt es natürlich nicht.

Ich möchte aber, dass diese Zeile automatisch angelegt wird, wenn man sich registriert

Meine Frage, was muss im Register Stock angeben, damit ein Eintrag mit dem Namen des Spielers angelegt wird? :o

SqueezyZ · 21. November 2014

Zitat von Jeffry

Füge das bei der Registration hinzu:

D:\Domi\Spiele\GTA San Andreas\Selfmade\gamemodes\inventar.pwn(25497) : warning 202: number of arguments does not match definition
D:\Domi\Spiele\GTA San Andreas\Selfmade\gamemodes\inventar.pwn(25499) : error 001: expected token: "-string end-", but found "-identifier-"
D:\Domi\Spiele\GTA San Andreas\Selfmade\gamemodes\inventar.pwn(25499) : warning 215: expression has no effect
D:\Domi\Spiele\GTA San Andreas\Selfmade\gamemodes\inventar.pwn(25499) : error 001: expected token: ";", but found ")"
D:\Domi\Spiele\GTA San Andreas\Selfmade\gamemodes\inventar.pwn(25499) : error 029: invalid expression, assumed zero
D:\Domi\Spiele\GTA San Andreas\Selfmade\gamemodes\inventar.pwn(25499) : fatal error 107: too many error messages on one line

Diese Fehler habe ich bei deinem Code bekommen

new query[128],name[MAX_PLAYER_NAME];
GetPlayerName(playerid, name);
mysql_real_escape_string(name, name);
format(query, sizeof(query), "INSERT INTO inventar (Name) VALUES ('%s')" name);
mysql_query(query);

Jeffry · 21. November 2014

Sorry, hab ein "," vergessen. Ohne es zu kompilieren kommt das leider hin und wieder vor.
format(query, sizeof(query), "INSERT INTO inventar (Name) VALUES ('%s')" name);
zu:
format(query, sizeof(query), "INSERT INTO inventar (Name) VALUES ('%s')", name);

SqueezyZ · 21. November 2014

Zitat von Jeffry

Sorry,

Hey, jetzt zeigt er bei GetPlayerName(playerid, name); einen Warning an.

number of arguments does not match definition

Jeffry · 21. November 2014

Ich hab den Code oben mal gelöscht. Irgendwie hab ich da nicht das geschrieben was ich schreiben wollte.

new query[128],name[MAX_PLAYER_NAME];
GetPlayerName(playerid, name, MAX_PLAYER_NAME);
mysql_real_escape_string(name, name);
format(query, sizeof(query), "INSERT INTO inventar (Name) VALUES ('%s')", name);
mysql_query(query);

Jetzt passt es aber.

[MYSQL] Daten werden nicht gespeichert

Beitrag von Jeffry (21. November 2014)

breadfish.de 12. März 2022