MySQL Inhalte werden auf "0" gesetzt?

Dom_i · 27. Februar 2015

Hey Leute,

ich habe seit längerem schon ein Problem, was ich einfach nicht gelöst bekomme...

Da mein Script viel mit MySQL arbeitet und es soweit auch alles sehr gut klappt, dachte ich auch das das so bleibt, doch
schon seit geraumer Zeit beschäftigt mich mein Fraktionskassen-System, welches nach einem restart immer zurück auf 0 gesetzt wird.

Dabei habe ich eigentlich nichts im Script so eingegeben...

Das einzige was passiert:

Speicherung-Stock:
stock KassenSpeichern()
{
new query[128];
format(query, sizeof(query), "UPDATE `kassen` SET `Geld` = '%i', `Mats` = '%i', `Gras` = '%i', `Heroin` = '%i' WHERE `Name` = 'GS'", KassenInfo[10][k_Geld],KassenInfo[10][k_Mats],KassenInfo[10][k_Gras],KassenInfo[10][k_Heroin]);
mysql_query(query);
format(query, sizeof(query), "UPDATE `kassen` SET `Geld` = '%i', `Mats` = '%i', `Gras` = '%i', `Heroin` = '%i' WHERE `Name` = 'BALLAS'", KassenInfo[11][k_Geld],KassenInfo[11][k_Mats],KassenInfo[11][k_Gras],KassenInfo[11][k_Heroin]);
mysql_query(query);
format(query, sizeof(query), "UPDATE `kassen` SET `Geld` = '%i', `Mats` = '%i', `Gras` = '%i', `Heroin` = '%i', `C4` = '%i' WHERE `Name` = 'TERROR'", KassenInfo[12][k_Geld],KassenInfo[12][k_Mats],KassenInfo[12][k_Gras],KassenInfo[12][k_Heroin],KassenInfo[12][k_C4]);
mysql_query(query);
format(query, sizeof(query), "UPDATE `kassen` SET `Geld` = '%i', `Mats` = '%i', `Gras` = '%i', `Heroin` = '%i' WHERE `Name` = 'LCN'", KassenInfo[13][k_Geld],KassenInfo[13][k_Mats],KassenInfo[13][k_Gras],KassenInfo[13][k_Heroin]);
mysql_query(query);
format(query, sizeof(query), "UPDATE `kassen` SET `Geld` = '%i' WHERE `Name` = 'Jackpot'", KassenInfo[0][k_Geld]);
mysql_query(query);
format(query, sizeof(query), "UPDATE `kassen` SET `Geld` = '%i' WHERE `Name` = 'LSPD'", KassenInfo[1][k_Geld]);
mysql_query(query);
format(query, sizeof(query), "UPDATE `kassen` SET `Geld` = '%i' WHERE `Name` = 'BND'", KassenInfo[2][k_Geld]);
mysql_query(query);
format(query, sizeof(query), "UPDATE `kassen` SET `Geld` = '%i' WHERE `Name` = 'Hitmen'", KassenInfo[3][k_Geld]);
mysql_query(query);
format(query, sizeof(query), "UPDATE `kassen` SET `Geld` = '%i' WHERE `Name` = 'Army'", KassenInfo[4][k_Geld]);
mysql_query(query);
format(query, sizeof(query), "UPDATE `kassen` SET `Geld` = '%i' WHERE `Name` = 'Medic'", KassenInfo[6][k_Geld]);
mysql_query(query);
format(query, sizeof(query), "UPDATE `kassen` SET `Geld` = '%i' WHERE `Name` = 'OAmt'", KassenInfo[7][k_Geld]);
mysql_query(query);
format(query, sizeof(query), "UPDATE `kassen` SET `Geld` = '%i' WHERE `Name` = 'News'", KassenInfo[9][k_Geld]);
mysql_query(query);
return 1;
}

OnGameModeInit (hier werden auch die ganzen Sachen geladen):
for(new i=0;i<14;i++)
{
KassenInfo[i][k_Geld] = 0;
KassenInfo[i][k_Mats] = 0;
KassenInfo[i][k_Heroin] = 0;
KassenInfo[i][k_Gras] = 0;
KassenInfo[i][k_C4] = 0;
}

KassenInfo[13][k_Geld] = mysql_GetInt("kassen", "Geld", "Name", "LCN");
KassenInfo[13][k_Mats] = mysql_GetInt("kassen", "Mats", "Name", "LCN");
KassenInfo[13][k_Heroin] = mysql_GetInt("kassen", "Heroin", "Name", "LCN");
KassenInfo[13][k_Gras] = mysql_GetInt("kassen", "Gras", "Name", "LCN");
//
KassenInfo[10][k_Geld] = mysql_GetInt("kassen", "Geld", "Name", "GS");
KassenInfo[10][k_Mats] = mysql_GetInt("kassen", "Mats", "Name", "GS");
KassenInfo[10][k_Gras] = mysql_GetInt("kassen", "Gras", "Name", "GS");
KassenInfo[10][k_Heroin] = mysql_GetInt("kassen", "Heroin", "Name", "GS");
//
KassenInfo[11][k_Geld] = mysql_GetInt("kassen", "Geld", "Name", "BALLAS");
KassenInfo[11][k_Mats] = mysql_GetInt("kassen", "Mats", "Name", "BALLAS");
KassenInfo[11][k_Heroin] = mysql_GetInt("kassen", "Heroin", "Name", "BALLAS");
KassenInfo[11][k_Gras] = mysql_GetInt("kassen", "Gras", "Name", "BALLAS");
//
KassenInfo[12][k_Geld] = mysql_GetInt("kassen", "Geld", "Name", "TERROR");
KassenInfo[12][k_Mats] = mysql_GetInt("kassen", "Mats", "Name", "TERROR");
KassenInfo[12][k_Gras] = mysql_GetInt("kassen", "Gras", "Name", "TERROR");
KassenInfo[12][k_C4] = mysql_GetInt("kassen", "C4", "Name", "TERROR");
KassenInfo[12][k_Heroin] = mysql_GetInt("kassen", "Heroin", "Name", "TERROR");
//
KassenInfo[0][k_Geld] = mysql_GetInt("kassen", "Geld", "Name", "Jackpot");
KassenInfo[9][k_Geld] = mysql_GetInt("kassen", "Geld", "Name", "News");
KassenInfo[7][k_Geld] = mysql_GetInt("kassen", "Geld", "Name", "OAmt");
KassenInfo[6][k_Geld] = mysql_GetInt("kassen", "Geld", "Name", "Medic");
KassenInfo[4][k_Geld] = mysql_GetInt("kassen", "Geld", "Name", "Army");
KassenInfo[3][k_Geld] = mysql_GetInt("kassen", "Geld", "Name", "Hitmen");
KassenInfo[2][k_Geld] = mysql_GetInt("kassen", "Geld", "Name", "BND");
KassenInfo[1][k_Geld] = mysql_GetInt("kassen", "Geld", "Name", "LSPD");

Bei OnGameModeExit habe ich soweit nichts mit dem F-Kassen System eingebaut...

Ich tüftel da schon etwas länger dran rum, komme aber nicht weiter...

Habt ihr eine Idee?

ENEF · 27. Februar 2015

Wo speicherst du überall die Kasse mit KassenSpeichern()

Sieht manchmal meinem system ähnlich....

Dom_i · 27. Februar 2015

Immer nachdem etwas ein- oder ausgezahlt wurde

Jeffry · 27. Februar 2015

Schalte bitte mal den MySQL Debug Modus an und poste was im MySQL Log steht, wenn du etwas einzahlst.
Wie du das machst steht hier: Tipps: Scripting-Probleme richtig erklären (Kapitel 1.4)

Dom_i · 27. Februar 2015

Er speichert es ja richtig!
Sprich nach jedem mal wenn ich etwas ein- oder ausgezahlt habe, wurde der Wert in der DB auch dementsprechend geändert!

Nur wenn ich einen restart gemacht habe, wurden die Werte alle auf 0 gesetzt!

Jeffry · 27. Februar 2015

Ahh, achso.
Werden die Sachen wie "Heroin" und "Gras" richtig geladen? Poste ggf. mal den MySQL Log vom starten des Servers.
Möglicherweise wird der Code gar nicht aufgerufen.

Übrigens, ändere beim Speichern:
new query[128];
zu:
new query[256];

Du bist da ganz knapp an der Grenze. Eins ist bei 118, die Werte die in die Platzhalter kommen könnten das überfüllen.

Dom_i · 5. März 2015

Zitat von Jeffry

Ahh, achso.
Werden die Sachen wie "Heroin" und "Gras" richtig geladen? Poste ggf. mal den MySQL Log vom starten des Servers.
Möglicherweise wird der Code gar nicht aufgerufen.

Hey Jeffry,

ich habe jetzt den Server nur einmal gestoppt, selbst da werden die MySQL Werte auf 0 gesetzt...

Genau so ist es, wenn ich den Server neustarte

Bei "OnGameModeExit" steht soweit nichts in Verbindung mit dem Kassen System, aber wieso werden dann alle Werte auf 0 gesetzt?!

Ich verzweifle langsam...

Jeffry · 5. März 2015

Hmm, kannst du dann bitte folgendes machen?

1) Setze in der Datenbank die Werte der Dinge die zurück gesetzt werden auf 50 (z.B.), dann starte den Server. Dann poste den MySQL Log dazu (paar Posts drüber steht ja, wie du den bekommst).
2.) Dann schließe den Server bitte wieder, und poste den MySQL Log der dazu kommt.

3.) Zu 1 und 2 poste bitte jeweils noch den aktuellen Code der ausgeführt wird.

Dom_i · 5. März 2015

Zitat von Jeffry

Hmm, kannst du dann bitte folgendes machen?

Ich habe die Werte eingetragen und den Server neugestartet.
Die Werte wurden ebenfalls wieder auf 0 gesetzt und folgendes steht nun in der Log:

Code

[Thu Mar  5 12:59:46 2015] Function: mysql_query executed: "UPDATE `kassen` SET `Geld` = '0', `Mats` = '0', `Gras` = '0', `Heroin` = '0' WHERE `Name` = 'GS'" with result: "0".
[Thu Mar  5 12:59:46 2015] Function: mysql_query executed: "UPDATE `kassen` SET `Geld` = '0', `Mats` = '0', `Gras` = '0', `Heroin` = '0' WHERE `Name` = 'BALLAS'" with result: "0".
[Thu Mar  5 12:59:46 2015] Function: mysql_query executed: "UPDATE `kassen` SET `Geld` = '0', `Mats` = '0', `Gras` = '0', `Heroin` = '0', `C4` = '0' WHERE `Name` = 'TERROR'" with result: "0".
[Thu Mar  5 12:59:46 2015] Function: mysql_query executed: "UPDATE `kassen` SET `Geld` = '0', `Mats` = '0', `Gras` = '0', `Heroin` = '0' WHERE `Name` = 'LCN'" with result: "0".
[Thu Mar  5 12:59:46 2015] Function: mysql_query executed: "UPDATE `kassen` SET `Geld` = '0' WHERE `Name` = 'Jackpot'" with result: "0".
[Thu Mar  5 12:59:46 2015] Function: mysql_query executed: "UPDATE `kassen` SET `Geld` = '0' WHERE `Name` = 'LSPD'" with result: "0".
[Thu Mar  5 12:59:46 2015] Function: mysql_query executed: "UPDATE `kassen` SET `Geld` = '0' WHERE `Name` = 'BND'" with result: "0".
[Thu Mar  5 12:59:46 2015] Function: mysql_query executed: "UPDATE `kassen` SET `Geld` = '0' WHERE `Name` = 'Hitmen'" with result: "0".
[Thu Mar  5 12:59:46 2015] Function: mysql_query executed: "UPDATE `kassen` SET `Geld` = '0' WHERE `Name` = 'Army'" with result: "0".
[Thu Mar  5 12:59:46 2015] Function: mysql_query executed: "UPDATE `kassen` SET `Geld` = '0' WHERE `Name` = 'Medic'" with result: "0".
[Thu Mar  5 12:59:46 2015] Function: mysql_query executed: "UPDATE `kassen` SET `Geld` = '0' WHERE `Name` = 'OAmt'" with result: "0".
[Thu Mar  5 12:59:46 2015] Function: mysql_query executed: "UPDATE `kassen` SET `Geld` = '0' WHERE `Name` = 'News'" with result: "0".
[Thu Mar  5 12:59:46 2015] Function: mysql_real_esacpe_string executed: "1" with result: "1".

Alles anzeigen

Des Weiteren steht ein paar Zeilen da unter folgendes:

Code

[Thu Mar  5 12:59:46 2015] Function: mysql_real_esacpe_string executed: "kassen" with result: "kassen".
[Thu Mar  5 12:59:46 2015] Function: mysql_real_esacpe_string executed: "Geld" with result: "Geld".
[Thu Mar  5 12:59:46 2015] Function: mysql_real_esacpe_string executed: "Name" with result: "Name".
[Thu Mar  5 12:59:46 2015] Function: mysql_real_esacpe_string executed: "LCN" with result: "LCN".
[Thu Mar  5 12:59:46 2015] Function: mysql_query executed: "SELECT `Geld` FROM `kassen` WHERE `Name` = 'LCN' LIMIT 1" with result: "0".
[Thu Mar  5 12:59:46 2015] Function: mysql_store_result executed with result: "1"
[Thu Mar  5 12:59:46 2015] Function: mysql_fetch_int executed with result: "0".
[Thu Mar  5 12:59:46 2015] Function: mysql_free_result executed.
[Thu Mar  5 12:59:46 2015] Function: mysql_real_esacpe_string executed: "kassen" with result: "kassen".
[Thu Mar  5 12:59:46 2015] Function: mysql_real_esacpe_string executed: "Mats" with result: "Mats".
[Thu Mar  5 12:59:46 2015] Function: mysql_real_esacpe_string executed: "Name" with result: "Name".
[Thu Mar  5 12:59:46 2015] Function: mysql_real_esacpe_string executed: "LCN" with result: "LCN".
[Thu Mar  5 12:59:46 2015] Function: mysql_query executed: "SELECT `Mats` FROM `kassen` WHERE `Name` = 'LCN' LIMIT 1" with result: "0".
[Thu Mar  5 12:59:46 2015] Function: mysql_store_result executed with result: "1"
[Thu Mar  5 12:59:46 2015] Function: mysql_fetch_int executed with result: "0".
[Thu Mar  5 12:59:46 2015] Function: mysql_free_result executed.
[Thu Mar  5 12:59:46 2015] Function: mysql_real_esacpe_string executed: "kassen" with result: "kassen".
[Thu Mar  5 12:59:46 2015] Function: mysql_real_esacpe_string executed: "Heroin" with result: "Heroin".
[Thu Mar  5 12:59:46 2015] Function: mysql_real_esacpe_string executed: "Name" with result: "Name".
[Thu Mar  5 12:59:46 2015] Function: mysql_real_esacpe_string executed: "LCN" with result: "LCN".
[Thu Mar  5 12:59:46 2015] Function: mysql_query executed: "SELECT `Heroin` FROM `kassen` WHERE `Name` = 'LCN' LIMIT 1" with result: "0".
[Thu Mar  5 12:59:46 2015] Function: mysql_store_result executed with result: "1"
[Thu Mar  5 12:59:46 2015] Function: mysql_fetch_int executed with result: "0".
[Thu Mar  5 12:59:46 2015] Function: mysql_free_result executed.
[Thu Mar  5 12:59:46 2015] Function: mysql_real_esacpe_string executed: "kassen" with result: "kassen".
[Thu Mar  5 12:59:46 2015] Function: mysql_real_esacpe_string executed: "Gras" with result: "Gras".
[Thu Mar  5 12:59:46 2015] Function: mysql_real_esacpe_string executed: "Name" with result: "Name".
[Thu Mar  5 12:59:46 2015] Function: mysql_real_esacpe_string executed: "LCN" with result: "LCN".
[Thu Mar  5 12:59:46 2015] Function: mysql_query executed: "SELECT `Gras` FROM `kassen` WHERE `Name` = 'LCN' LIMIT 1" with result: "0".
[Thu Mar  5 12:59:46 2015] Function: mysql_store_result executed with result: "1"
[Thu Mar  5 12:59:46 2015] Function: mysql_fetch_int executed with result: "0".
[Thu Mar  5 12:59:46 2015] Function: mysql_free_result executed.
[Thu Mar  5 12:59:46 2015] Function: mysql_real_esacpe_string executed: "kassen" with result: "kassen".
[Thu Mar  5 12:59:46 2015] Function: mysql_real_esacpe_string executed: "Geld" with result: "Geld".
[Thu Mar  5 12:59:46 2015] Function: mysql_real_esacpe_string executed: "Name" with result: "Name".
[Thu Mar  5 12:59:46 2015] Function: mysql_real_esacpe_string executed: "GS" with result: "GS".
[Thu Mar  5 12:59:46 2015] Function: mysql_query executed: "SELECT `Geld` FROM `kassen` WHERE `Name` = 'GS' LIMIT 1" with result: "0".
[Thu Mar  5 12:59:46 2015] Function: mysql_store_result executed with result: "1"
[Thu Mar  5 12:59:46 2015] Function: mysql_fetch_int executed with result: "0".
[Thu Mar  5 12:59:46 2015] Function: mysql_free_result executed.
[Thu Mar  5 12:59:46 2015] Function: mysql_real_esacpe_string executed: "kassen" with result: "kassen".
[Thu Mar  5 12:59:46 2015] Function: mysql_real_esacpe_string executed: "Mats" with result: "Mats".
[Thu Mar  5 12:59:46 2015] Function: mysql_real_esacpe_string executed: "Name" with result: "Name".
[Thu Mar  5 12:59:46 2015] Function: mysql_real_esacpe_string executed: "GS" with result: "GS".
[Thu Mar  5 12:59:46 2015] Function: mysql_query executed: "SELECT `Mats` FROM `kassen` WHERE `Name` = 'GS' LIMIT 1" with result: "0".
[Thu Mar  5 12:59:46 2015] Function: mysql_store_result executed with result: "1"
[Thu Mar  5 12:59:46 2015] Function: mysql_fetch_int executed with result: "0".
[Thu Mar  5 12:59:46 2015] Function: mysql_free_result executed.
[Thu Mar  5 12:59:46 2015] Function: mysql_real_esacpe_string executed: "kassen" with result: "kassen".
[Thu Mar  5 12:59:46 2015] Function: mysql_real_esacpe_string executed: "Gras" with result: "Gras".
[Thu Mar  5 12:59:46 2015] Function: mysql_real_esacpe_string executed: "Name" with result: "Name".
[Thu Mar  5 12:59:46 2015] Function: mysql_real_esacpe_string executed: "GS" with result: "GS".
[Thu Mar  5 12:59:46 2015] Function: mysql_query executed: "SELECT `Gras` FROM `kassen` WHERE `Name` = 'GS' LIMIT 1" with result: "0".
[Thu Mar  5 12:59:46 2015] Function: mysql_store_result executed with result: "1"
[Thu Mar  5 12:59:46 2015] Function: mysql_fetch_int executed with result: "0".
[Thu Mar  5 12:59:46 2015] Function: mysql_free_result executed.
[Thu Mar  5 12:59:46 2015] Function: mysql_real_esacpe_string executed: "kassen" with result: "kassen".
[Thu Mar  5 12:59:46 2015] Function: mysql_real_esacpe_string executed: "Heroin" with result: "Heroin".
[Thu Mar  5 12:59:46 2015] Function: mysql_real_esacpe_string executed: "Name" with result: "Name".
[Thu Mar  5 12:59:46 2015] Function: mysql_real_esacpe_string executed: "GS" with result: "GS".
[Thu Mar  5 12:59:46 2015] Function: mysql_query executed: "SELECT `Heroin` FROM `kassen` WHERE `Name` = 'GS' LIMIT 1" with result: "0".
[Thu Mar  5 12:59:46 2015] Function: mysql_store_result executed with result: "1"
[Thu Mar  5 12:59:46 2015] Function: mysql_fetch_int executed with result: "0".
[Thu Mar  5 12:59:46 2015] Function: mysql_free_result executed.
[Thu Mar  5 12:59:46 2015] Function: mysql_real_esacpe_string executed: "kassen" with result: "kassen".
[Thu Mar  5 12:59:46 2015] Function: mysql_real_esacpe_string executed: "Geld" with result: "Geld".
[Thu Mar  5 12:59:46 2015] Function: mysql_real_esacpe_string executed: "Name" with result: "Name".
[Thu Mar  5 12:59:46 2015] Function: mysql_real_esacpe_string executed: "BALLAS" with result: "BALLAS".
[Thu Mar  5 12:59:46 2015] Function: mysql_query executed: "SELECT `Geld` FROM `kassen` WHERE `Name` = 'BALLAS' LIMIT 1" with result: "0".
[Thu Mar  5 12:59:46 2015] Function: mysql_store_result executed with result: "1"
[Thu Mar  5 12:59:46 2015] Function: mysql_fetch_int executed with result: "0".
[Thu Mar  5 12:59:46 2015] Function: mysql_free_result executed.
[Thu Mar  5 12:59:46 2015] Function: mysql_real_esacpe_string executed: "kassen" with result: "kassen".
[Thu Mar  5 12:59:46 2015] Function: mysql_real_esacpe_string executed: "Mats" with result: "Mats".
[Thu Mar  5 12:59:46 2015] Function: mysql_real_esacpe_string executed: "Name" with result: "Name".
[Thu Mar  5 12:59:46 2015] Function: mysql_real_esacpe_string executed: "BALLAS" with result: "BALLAS".
[Thu Mar  5 12:59:46 2015] Function: mysql_query executed: "SELECT `Mats` FROM `kassen` WHERE `Name` = 'BALLAS' LIMIT 1" with result: "0".
[Thu Mar  5 12:59:46 2015] Function: mysql_store_result executed with result: "1"
[Thu Mar  5 12:59:46 2015] Function: mysql_fetch_int executed with result: "0".
[Thu Mar  5 12:59:46 2015] Function: mysql_free_result executed.
[Thu Mar  5 12:59:46 2015] Function: mysql_real_esacpe_string executed: "kassen" with result: "kassen".
[Thu Mar  5 12:59:46 2015] Function: mysql_real_esacpe_string executed: "Heroin" with result: "Heroin".
[Thu Mar  5 12:59:46 2015] Function: mysql_real_esacpe_string executed: "Name" with result: "Name".
[Thu Mar  5 12:59:46 2015] Function: mysql_real_esacpe_string executed: "BALLAS" with result: "BALLAS".
[Thu Mar  5 12:59:46 2015] Function: mysql_query executed: "SELECT `Heroin` FROM `kassen` WHERE `Name` = 'BALLAS' LIMIT 1" with result: "0".
[Thu Mar  5 12:59:46 2015] Function: mysql_store_result executed with result: "1"
[Thu Mar  5 12:59:46 2015] Function: mysql_fetch_int executed with result: "0".
[Thu Mar  5 12:59:46 2015] Function: mysql_free_result executed.
[Thu Mar  5 12:59:46 2015] Function: mysql_real_esacpe_string executed: "kassen" with result: "kassen".
[Thu Mar  5 12:59:46 2015] Function: mysql_real_esacpe_string executed: "Gras" with result: "Gras".
[Thu Mar  5 12:59:46 2015] Function: mysql_real_esacpe_string executed: "Name" with result: "Name".
[Thu Mar  5 12:59:46 2015] Function: mysql_real_esacpe_string executed: "BALLAS" with result: "BALLAS".
[Thu Mar  5 12:59:46 2015] Function: mysql_query executed: "SELECT `Gras` FROM `kassen` WHERE `Name` = 'BALLAS' LIMIT 1" with result: "0".
[Thu Mar  5 12:59:46 2015] Function: mysql_store_result executed with result: "1"
[Thu Mar  5 12:59:46 2015] Function: mysql_fetch_int executed with result: "0".
[Thu Mar  5 12:59:46 2015] Function: mysql_free_result executed.
[Thu Mar  5 12:59:46 2015] Function: mysql_real_esacpe_string executed: "kassen" with result: "kassen".
[Thu Mar  5 12:59:46 2015] Function: mysql_real_esacpe_string executed: "Geld" with result: "Geld".
[Thu Mar  5 12:59:46 2015] Function: mysql_real_esacpe_string executed: "Name" with result: "Name".
[Thu Mar  5 12:59:46 2015] Function: mysql_real_esacpe_string executed: "TERROR" with result: "TERROR".
[Thu Mar  5 12:59:46 2015] Function: mysql_query executed: "SELECT `Geld` FROM `kassen` WHERE `Name` = 'TERROR' LIMIT 1" with result: "0".
[Thu Mar  5 12:59:46 2015] Function: mysql_store_result executed with result: "1"
[Thu Mar  5 12:59:46 2015] Function: mysql_fetch_int executed with result: "0".
[Thu Mar  5 12:59:46 2015] Function: mysql_free_result executed.
[Thu Mar  5 12:59:46 2015] Function: mysql_real_esacpe_string executed: "kassen" with result: "kassen".
[Thu Mar  5 12:59:46 2015] Function: mysql_real_esacpe_string executed: "Mats" with result: "Mats".
[Thu Mar  5 12:59:46 2015] Function: mysql_real_esacpe_string executed: "Name" with result: "Name".
[Thu Mar  5 12:59:46 2015] Function: mysql_real_esacpe_string executed: "TERROR" with result: "TERROR".
[Thu Mar  5 12:59:46 2015] Function: mysql_query executed: "SELECT `Mats` FROM `kassen` WHERE `Name` = 'TERROR' LIMIT 1" with result: "0".
[Thu Mar  5 12:59:46 2015] Function: mysql_store_result executed with result: "1"
[Thu Mar  5 12:59:46 2015] Function: mysql_fetch_int executed with result: "0".
[Thu Mar  5 12:59:46 2015] Function: mysql_free_result executed.
[Thu Mar  5 12:59:46 2015] Function: mysql_real_esacpe_string executed: "kassen" with result: "kassen".
[Thu Mar  5 12:59:46 2015] Function: mysql_real_esacpe_string executed: "Gras" with result: "Gras".
[Thu Mar  5 12:59:46 2015] Function: mysql_real_esacpe_string executed: "Name" with result: "Name".
[Thu Mar  5 12:59:46 2015] Function: mysql_real_esacpe_string executed: "TERROR" with result: "TERROR".
[Thu Mar  5 12:59:46 2015] Function: mysql_query executed: "SELECT `Gras` FROM `kassen` WHERE `Name` = 'TERROR' LIMIT 1" with result: "0".
[Thu Mar  5 12:59:46 2015] Function: mysql_store_result executed with result: "1"
[Thu Mar  5 12:59:46 2015] Function: mysql_fetch_int executed with result: "0".
[Thu Mar  5 12:59:46 2015] Function: mysql_free_result executed.
[Thu Mar  5 12:59:46 2015] Function: mysql_real_esacpe_string executed: "kassen" with result: "kassen".
[Thu Mar  5 12:59:46 2015] Function: mysql_real_esacpe_string executed: "C4" with result: "C4".
[Thu Mar  5 12:59:46 2015] Function: mysql_real_esacpe_string executed: "Name" with result: "Name".
[Thu Mar  5 12:59:46 2015] Function: mysql_real_esacpe_string executed: "TERROR" with result: "TERROR".
[Thu Mar  5 12:59:46 2015] Function: mysql_query executed: "SELECT `C4` FROM `kassen` WHERE `Name` = 'TERROR' LIMIT 1" with result: "0".
[Thu Mar  5 12:59:46 2015] Function: mysql_store_result executed with result: "1"
[Thu Mar  5 12:59:46 2015] Function: mysql_fetch_int executed with result: "0".
[Thu Mar  5 12:59:46 2015] Function: mysql_free_result executed.
[Thu Mar  5 12:59:46 2015] Function: mysql_real_esacpe_string executed: "kassen" with result: "kassen".
[Thu Mar  5 12:59:46 2015] Function: mysql_real_esacpe_string executed: "Heroin" with result: "Heroin".
[Thu Mar  5 12:59:46 2015] Function: mysql_real_esacpe_string executed: "Name" with result: "Name".
[Thu Mar  5 12:59:46 2015] Function: mysql_real_esacpe_string executed: "TERROR" with result: "TERROR".
[Thu Mar  5 12:59:46 2015] Function: mysql_query executed: "SELECT `Heroin` FROM `kassen` WHERE `Name` = 'TERROR' LIMIT 1" with result: "0".
[Thu Mar  5 12:59:46 2015] Function: mysql_store_result executed with result: "1"
[Thu Mar  5 12:59:46 2015] Function: mysql_fetch_int executed with result: "0".
[Thu Mar  5 12:59:46 2015] Function: mysql_free_result executed.
[Thu Mar  5 12:59:46 2015] Function: mysql_real_esacpe_string executed: "kassen" with result: "kassen".
[Thu Mar  5 12:59:46 2015] Function: mysql_real_esacpe_string executed: "Geld" with result: "Geld".
[Thu Mar  5 12:59:46 2015] Function: mysql_real_esacpe_string executed: "Name" with result: "Name".
[Thu Mar  5 12:59:46 2015] Function: mysql_real_esacpe_string executed: "Jackpot" with result: "Jackpot".
[Thu Mar  5 12:59:46 2015] Function: mysql_query executed: "SELECT `Geld` FROM `kassen` WHERE `Name` = 'Jackpot' LIMIT 1" with result: "0".
[Thu Mar  5 12:59:46 2015] Function: mysql_store_result executed with result: "1"
[Thu Mar  5 12:59:46 2015] Function: mysql_fetch_int executed with result: "0".
[Thu Mar  5 12:59:46 2015] Function: mysql_free_result executed.
[Thu Mar  5 12:59:46 2015] Function: mysql_real_esacpe_string executed: "kassen" with result: "kassen".
[Thu Mar  5 12:59:46 2015] Function: mysql_real_esacpe_string executed: "Geld" with result: "Geld".
[Thu Mar  5 12:59:46 2015] Function: mysql_real_esacpe_string executed: "Name" with result: "Name".
[Thu Mar  5 12:59:46 2015] Function: mysql_real_esacpe_string executed: "News" with result: "News".
[Thu Mar  5 12:59:46 2015] Function: mysql_query executed: "SELECT `Geld` FROM `kassen` WHERE `Name` = 'News' LIMIT 1" with result: "0".
[Thu Mar  5 12:59:46 2015] Function: mysql_store_result executed with result: "1"
[Thu Mar  5 12:59:46 2015] Function: mysql_fetch_int executed with result: "0".
[Thu Mar  5 12:59:46 2015] Function: mysql_free_result executed.
[Thu Mar  5 12:59:46 2015] Function: mysql_real_esacpe_string executed: "kassen" with result: "kassen".
[Thu Mar  5 12:59:46 2015] Function: mysql_real_esacpe_string executed: "Geld" with result: "Geld".
[Thu Mar  5 12:59:46 2015] Function: mysql_real_esacpe_string executed: "Name" with result: "Name".
[Thu Mar  5 12:59:46 2015] Function: mysql_real_esacpe_string executed: "OAmt" with result: "OAmt".
[Thu Mar  5 12:59:46 2015] Function: mysql_query executed: "SELECT `Geld` FROM `kassen` WHERE `Name` = 'OAmt' LIMIT 1" with result: "0".
[Thu Mar  5 12:59:46 2015] Function: mysql_store_result executed with result: "1"
[Thu Mar  5 12:59:46 2015] Function: mysql_fetch_int executed with result: "0".
[Thu Mar  5 12:59:46 2015] Function: mysql_free_result executed.
[Thu Mar  5 12:59:46 2015] Function: mysql_real_esacpe_string executed: "kassen" with result: "kassen".
[Thu Mar  5 12:59:46 2015] Function: mysql_real_esacpe_string executed: "Geld" with result: "Geld".
[Thu Mar  5 12:59:46 2015] Function: mysql_real_esacpe_string executed: "Name" with result: "Name".
[Thu Mar  5 12:59:46 2015] Function: mysql_real_esacpe_string executed: "Medic" with result: "Medic".
[Thu Mar  5 12:59:46 2015] Function: mysql_query executed: "SELECT `Geld` FROM `kassen` WHERE `Name` = 'Medic' LIMIT 1" with result: "0".
[Thu Mar  5 12:59:46 2015] Function: mysql_store_result executed with result: "1"
[Thu Mar  5 12:59:46 2015] Function: mysql_fetch_int executed with result: "0".
[Thu Mar  5 12:59:46 2015] Function: mysql_free_result executed.
[Thu Mar  5 12:59:46 2015] Function: mysql_real_esacpe_string executed: "kassen" with result: "kassen".
[Thu Mar  5 12:59:46 2015] Function: mysql_real_esacpe_string executed: "Geld" with result: "Geld".
[Thu Mar  5 12:59:46 2015] Function: mysql_real_esacpe_string executed: "Name" with result: "Name".
[Thu Mar  5 12:59:46 2015] Function: mysql_real_esacpe_string executed: "Army" with result: "Army".
[Thu Mar  5 12:59:46 2015] Function: mysql_query executed: "SELECT `Geld` FROM `kassen` WHERE `Name` = 'Army' LIMIT 1" with result: "0".
[Thu Mar  5 12:59:46 2015] Function: mysql_store_result executed with result: "1"
[Thu Mar  5 12:59:46 2015] Function: mysql_fetch_int executed with result: "0".
[Thu Mar  5 12:59:46 2015] Function: mysql_free_result executed.
[Thu Mar  5 12:59:46 2015] Function: mysql_real_esacpe_string executed: "kassen" with result: "kassen".
[Thu Mar  5 12:59:46 2015] Function: mysql_real_esacpe_string executed: "Geld" with result: "Geld".
[Thu Mar  5 12:59:46 2015] Function: mysql_real_esacpe_string executed: "Name" with result: "Name".
[Thu Mar  5 12:59:46 2015] Function: mysql_real_esacpe_string executed: "Hitmen" with result: "Hitmen".
[Thu Mar  5 12:59:46 2015] Function: mysql_query executed: "SELECT `Geld` FROM `kassen` WHERE `Name` = 'Hitmen' LIMIT 1" with result: "0".
[Thu Mar  5 12:59:46 2015] Function: mysql_store_result executed with result: "1"
[Thu Mar  5 12:59:46 2015] Function: mysql_fetch_int executed with result: "0".
[Thu Mar  5 12:59:46 2015] Function: mysql_free_result executed.
[Thu Mar  5 12:59:46 2015] Function: mysql_real_esacpe_string executed: "kassen" with result: "kassen".
[Thu Mar  5 12:59:46 2015] Function: mysql_real_esacpe_string executed: "Geld" with result: "Geld".
[Thu Mar  5 12:59:46 2015] Function: mysql_real_esacpe_string executed: "Name" with result: "Name".
[Thu Mar  5 12:59:46 2015] Function: mysql_real_esacpe_string executed: "BND" with result: "BND".
[Thu Mar  5 12:59:46 2015] Function: mysql_query executed: "SELECT `Geld` FROM `kassen` WHERE `Name` = 'BND' LIMIT 1" with result: "0".
[Thu Mar  5 12:59:46 2015] Function: mysql_store_result executed with result: "1"
[Thu Mar  5 12:59:46 2015] Function: mysql_fetch_int executed with result: "0".
[Thu Mar  5 12:59:46 2015] Function: mysql_free_result executed.
[Thu Mar  5 12:59:46 2015] Function: mysql_real_esacpe_string executed: "kassen" with result: "kassen".
[Thu Mar  5 12:59:46 2015] Function: mysql_real_esacpe_string executed: "Geld" with result: "Geld".
[Thu Mar  5 12:59:46 2015] Function: mysql_real_esacpe_string executed: "Name" with result: "Name".
[Thu Mar  5 12:59:46 2015] Function: mysql_real_esacpe_string executed: "LSPD" with result: "LSPD".
[Thu Mar  5 12:59:46 2015] Function: mysql_query executed: "SELECT `Geld` FROM `kassen` WHERE `Name` = 'LSPD' LIMIT 1" with result: "0".
[Thu Mar  5 12:59:46 2015] Function: mysql_store_result executed with result: "1"
[Thu Mar  5 12:59:46 2015] Function: mysql_fetch_int executed with result: "0".
[Thu Mar  5 12:59:46 2015] Function: mysql_free_result executed.

Alles anzeigen

Der PAWN-Code dazu:

for(new i=0;i<14;i++)
{
KassenInfo[i][k_Geld] = 0;
KassenInfo[i][k_Mats] = 0;
KassenInfo[i][k_Heroin] = 0;
KassenInfo[i][k_Gras] = 0;
KassenInfo[i][k_C4] = 0;
}

KassenInfo[13][k_Geld] = mysql_GetInt("kassen", "Geld", "Name", "LCN");
KassenInfo[13][k_Mats] = mysql_GetInt("kassen", "Mats", "Name", "LCN");
KassenInfo[13][k_Heroin] = mysql_GetInt("kassen", "Heroin", "Name", "LCN");
KassenInfo[13][k_Gras] = mysql_GetInt("kassen", "Gras", "Name", "LCN");
//
KassenInfo[10][k_Geld] = mysql_GetInt("kassen", "Geld", "Name", "GS");
KassenInfo[10][k_Mats] = mysql_GetInt("kassen", "Mats", "Name", "GS");
KassenInfo[10][k_Gras] = mysql_GetInt("kassen", "Gras", "Name", "GS");
KassenInfo[10][k_Heroin] = mysql_GetInt("kassen", "Heroin", "Name", "GS");
//
KassenInfo[11][k_Geld] = mysql_GetInt("kassen", "Geld", "Name", "BALLAS");
KassenInfo[11][k_Mats] = mysql_GetInt("kassen", "Mats", "Name", "BALLAS");
KassenInfo[11][k_Heroin] = mysql_GetInt("kassen", "Heroin", "Name", "BALLAS");
KassenInfo[11][k_Gras] = mysql_GetInt("kassen", "Gras", "Name", "BALLAS");
//
KassenInfo[12][k_Geld] = mysql_GetInt("kassen", "Geld", "Name", "TERROR");
KassenInfo[12][k_Mats] = mysql_GetInt("kassen", "Mats", "Name", "TERROR");
KassenInfo[12][k_Gras] = mysql_GetInt("kassen", "Gras", "Name", "TERROR");
KassenInfo[12][k_C4] = mysql_GetInt("kassen", "C4", "Name", "TERROR");
KassenInfo[12][k_Heroin] = mysql_GetInt("kassen", "Heroin", "Name", "TERROR");
//
KassenInfo[0][k_Geld] = mysql_GetInt("kassen", "Geld", "Name", "Jackpot");
KassenInfo[9][k_Geld] = mysql_GetInt("kassen", "Geld", "Name", "News");
KassenInfo[7][k_Geld] = mysql_GetInt("kassen", "Geld", "Name", "OAmt");
KassenInfo[6][k_Geld] = mysql_GetInt("kassen", "Geld", "Name", "Medic");
KassenInfo[4][k_Geld] = mysql_GetInt("kassen", "Geld", "Name", "Army");
KassenInfo[3][k_Geld] = mysql_GetInt("kassen", "Geld", "Name", "Hitmen");
KassenInfo[2][k_Geld] = mysql_GetInt("kassen", "Geld", "Name", "BND");
KassenInfo[1][k_Geld] = mysql_GetInt("kassen", "Geld", "Name", "LSPD");

Wie ich soweit erkennen kann, werden also die Werte vorher auf 0 gesetzt, oder irre ich mich? :o

Kaliber · 5. März 2015

Zitat von Raiffel

Wie ich soweit erkennen kann, werden also die Werte vorher auf 0 gesetzt, oder irre ich mich? :o

Ehm...mal eine doofe Frage, hast du überhaupt mit INSERT INTO was in die Datenbank geschrieben?

Dom_i · 5. März 2015

Zitat von Kaliber

Ehm...mal eine doofe Frage, hast du überhaupt mit INSERT INTO was in die Datenbank geschrieben?

Ich weiß nicht genau was du damit meinst

Ich habe sobald jemand etwas einzahlt mit dem "UPDATE" Code gearbeitet, da ich im Script mit Variablen für die Kassen arbeite. d.h.:

Der Code beim Einzahlen:

pInv[playerid][Marihuana] =pInv[playerid][Marihuana] - wert;
KassenInfo[10][k_Gras] += wert;
new str[128];
format(str,sizeof(str),"%s hat %ig Marihuana in die Fraktionskasse gezahlt! Stand: %ig",SpielerName(playerid),wert,KassenInfo[10][k_Gras]);
FrakCast(COLOR_YELLOW,str,10);
KassenSpeichern();
FrakLog10(str);

Und so wird es dann gespeichert:

stock KassenSpeichern()
{
new query[256];
format(query, sizeof(query), "UPDATE `kassen` SET `Geld` = '%i', `Mats` = '%i', `Gras` = '%i', `Heroin` = '%i' WHERE `Name` = 'GS'", KassenInfo[10][k_Geld],KassenInfo[10][k_Mats],KassenInfo[10][k_Gras],KassenInfo[10][k_Heroin]);
mysql_query(query);
format(query, sizeof(query), "UPDATE `kassen` SET `Geld` = '%i', `Mats` = '%i', `Gras` = '%i', `Heroin` = '%i' WHERE `Name` = 'BALLAS'", KassenInfo[11][k_Geld],KassenInfo[11][k_Mats],KassenInfo[11][k_Gras],KassenInfo[11][k_Heroin]);
mysql_query(query);
usw...
return 1;
}

Kaliber · 5. März 2015

Zitat von Raiffel

Ich habe sobald jemand etwas einzahlt mit dem "UPDATE" Code

Aber du kannst nur etwas Updaten, wenn schon etwas in der Tabelle existiert.

Deshalb meine Frage, ob du vorher schon was reingeschrieben hast mit INSERT INTO

mfg.

Jeffry · 5. März 2015

Wie hätte er sonst die Werte in der Datenbank ändern können?

@Raiffel:
So wie das aussieht speicherst du beim starten des Servers die Werte, und erst danach lädst du sie, heißt alles wird auf 0 gesetzt.

Kaliber · 5. März 2015

Zitat von Jeffry

Wie hätte er sonst die Werte in der Datenbank ändern können?

Oh...ja ich hab mir nicht alle Antworten durchgelesen gehabt

Dom_i · 5. März 2015

Habe den Fehler gefunden

Danke Jeffry, denn ich hatte tatsächlich die Kassen gespeichert, bevor deren Werte gesetzt wurden, also waren sie automatisch auf 0 !

Danke nochmal !

MySQL Inhalte werden auf "0" gesetzt?

Beitrag von Nexon00 (5. März 2015)

breadfish.de 12. März 2022