Ich hab's aufgegeben, MYSQL Lohnsystem

.Moersy · 27. November 2015

Guten Abend liebe Breadfish Community,

ich hab es aufgegeben wieder das Problem mit MYSQL und Mir.
Diesmal ist es das MYSQL Lohn-System auf R39-2
Es sollte eigentlich alles so funktionieren aber dies tut es nicht.
Es scheint so, als würde er den Lohn nicht Speichern.

Hier wird der Lohn gespeichert

C

case 1: {LohnInfo[(PlayerInfo[playerid][pLeader])][lRang2] = geldgg; format(query,sizeof(query),"UPDATE lohn SET rang2_geld ='%d' WHERE frakid ='%d'",geldgg,PlayerInfo[playerid][pLeader]); mysql_function_query(MYSQLVerbindung,query,false,"","");}

Und wenn der Lohn laden soll wird das ausgeführt:

Code

forward loadlohn();
public loadlohn()
{
   new result[100],rows,fields,string[250],status[50],
   string2[250],query[350];
   cache_get_data(rows,fields);
   new frakstring[250],frakname[25];
   new frak = 1, fraction = 1;
   if(rows)
   {
        while(frak<rows)
        {
            fraction = frak;
            fraction -= 1;
      	    cache_get_field_content(fraction,"frakid",result);
	    print("Der Lohn wird geladen...");


	    cache_get_field_content(fraction,"rang1_geld",result);
	    LohnInfo[frak][lRang1] = strval(result);

            //XXXXX Und noch für rang 2,3,4,5,6....




        }
	printf("%d Loehne erfolgrei geladen!",test);
   }

Alles anzeigen

Colore · 27. November 2015

normal müsste es gespeichert werden ... aber nun gut
//Das ist klarer fall für @Jeffry

**Andosius** · 27. November 2015

@Colore es gibt auch andere Leute, die sich mit PAWN auskennen.
@.Moersy bitte die Tabelle, die MySQL-Logs und das Laden der Variablen posten.

.Moersy · 27. November 2015

Der Mysql - Mysql Log wo ich gerade Lohn für den Rang 1 bis 5 gesetzt habe.

Spoiler anzeigen

Und der Mysql Log aus dem Server Start:

Spoiler anzeigen

Kompletter MYSQL Log (Außer das Einstellen der Löhne)

Spoiler anzeigen

[16:51:59] [DEBUG] CMySQLConnection::Connect - establishing connection to database...
[16:51:59] [DEBUG] CMySQLConnection::Connect - establishing connection to database...
[16:51:59] [DEBUG] CMySQLConnection::Connect - connection was successful
[16:51:59] [DEBUG] CMySQLConnection::Connect - auto-reconnect has been enabled
[16:51:59] [DEBUG] CMySQLConnection::Connect - establishing connection to database...
[16:51:59] [DEBUG] CMySQLConnection::Connect - connection was successful
[16:51:59] [DEBUG] CMySQLConnection::Connect - auto-reconnect has been enabled
[16:51:59] [DEBUG] CMySQLConnection::Connect - connection was successful
[16:51:59] [DEBUG] CMySQLConnection::Connect - auto-reconnect has been enabled
[16:51:59] [DEBUG] cache_get_data - connection: 1
[16:51:59] [WARNING] cache_get_data - no active cache
[16:53:04] [DEBUG] mysql_tquery - connection: 1, query: "SELECT * FROM `playercar` WHERE `name` = 'Moersy' AND slot = '0'", callback: "LoadAccountVehicles", format: "ii"
[16:53:04] [DEBUG] mysql_tquery - connection: 1, query: "SELECT * FROM `playercar` WHERE `name` = 'Moersy' AND slot = '1'", callback: "LoadAccountVehicles", format: "ii"
[16:53:04] [DEBUG] mysql_tquery - connection: 1, query: "SELECT * FROM `playercar` WHERE `name` = 'Moersy' AND slot = '2'", callback: "LoadAccountVehicles", format: "ii"
[16:53:04] [DEBUG] mysql_tquery - connection: 1, query: "SELECT * FROM `playercar` WHERE `name` = 'Moersy' AND slot = '3'", callback: "LoadAccountVehicles", format: "ii"
[16:53:04] [DEBUG] mysql_tquery - connection: 1, query: "SELECT * FROM `playercar` WHERE `name` = 'Moersy' AND slot = '4'", callback: "LoadAccountVehicles", format: "ii"
[16:53:04] [DEBUG] mysql_tquery - connection: 1, query: "SELECT * FROM `playercar` WHERE `name` = 'Moersy' AND slot = '5'", callback: "LoadAccountVehicles", format: "ii"
[16:53:04] [DEBUG] mysql_tquery - connection: 1, query: "SELECT * FROM `playercar` WHERE `name` = 'Moersy' AND slot = '6'", callback: "LoadAccountVehicles", format: "ii"
[16:53:04] [DEBUG] mysql_tquery - connection: 1, query: "SELECT * FROM `playercar` WHERE `name` = 'Moersy' AND slot = '7'", callback: "LoadAccountVehicles", format: "ii"
[16:53:04] [DEBUG] CMySQLQuery::Execute[LoadAccountVehicles] - starting query execution
[16:53:04] [DEBUG] CMySQLQuery::Execute[LoadAccountVehicles] - query was successfully executed within 0.454 milliseconds
[16:53:04] [DEBUG] CMySQLResult::CMySQLResult() - constructor called
[16:53:04] [DEBUG] CMySQLQuery::Execute[LoadAccountVehicles] - starting query execution
[16:53:04] [DEBUG] CMySQLQuery::Execute[LoadAccountVehicles] - query was successfully executed within 0.175 milliseconds
[16:53:04] [DEBUG] CMySQLResult::CMySQLResult() - constructor called
[16:53:04] [DEBUG] CMySQLQuery::Execute[LoadAccountVehicles] - starting query execution
[16:53:04] [DEBUG] CMySQLQuery::Execute[LoadAccountVehicles] - query was successfully executed within 0.176 milliseconds
[16:53:04] [DEBUG] CMySQLResult::CMySQLResult() - constructor called
[16:53:04] [DEBUG] CMySQLQuery::Execute[LoadAccountVehicles] - starting query execution
[16:53:04] [DEBUG] CMySQLQuery::Execute[LoadAccountVehicles] - query was successfully executed within 0.169 milliseconds
[16:53:04] [DEBUG] CMySQLResult::CMySQLResult() - constructor called
[16:53:04] [DEBUG] CMySQLQuery::Execute[LoadAccountVehicles] - starting query execution
[16:53:04] [DEBUG] CMySQLQuery::Execute[LoadAccountVehicles] - query was successfully executed within 0.165 milliseconds
[16:53:04] [DEBUG] CMySQLResult::CMySQLResult() - constructor called
[16:53:04] [DEBUG] CMySQLQuery::Execute[LoadAccountVehicles] - starting query execution
[16:53:04] [DEBUG] CMySQLQuery::Execute[LoadAccountVehicles] - query was successfully executed within 0.142 milliseconds
[16:53:04] [DEBUG] CMySQLResult::CMySQLResult() - constructor called
[16:53:04] [DEBUG] CMySQLQuery::Execute[LoadAccountVehicles] - starting query execution
[16:53:04] [DEBUG] CMySQLQuery::Execute[LoadAccountVehicles] - query was successfully executed within 0.150 milliseconds
[16:53:04] [DEBUG] CMySQLResult::CMySQLResult() - constructor called
[16:53:04] [DEBUG] CMySQLQuery::Execute[LoadAccountVehicles] - starting query execution
[16:53:04] [DEBUG] CMySQLQuery::Execute[LoadAccountVehicles] - query was successfully executed within 0.136 milliseconds
[16:53:04] [DEBUG] CMySQLResult::CMySQLResult() - constructor called
[16:53:04] [DEBUG] Calling callback "LoadAccountVehicles"..
[16:53:04] [DEBUG] cache_get_data - connection: 1
[16:53:04] [DEBUG] CMySQLResult::~CMySQLResult() - deconstructor called
[16:53:04] [DEBUG] Calling callback "LoadAccountVehicles"..
[16:53:04] [DEBUG] cache_get_data - connection: 1
[16:53:04] [DEBUG] CMySQLResult::~CMySQLResult() - deconstructor called
[16:53:04] [DEBUG] Calling callback "LoadAccountVehicles"..
[16:53:04] [DEBUG] cache_get_data - connection: 1
[16:53:04] [DEBUG] CMySQLResult::~CMySQLResult() - deconstructor called
[16:53:04] [DEBUG] Calling callback "LoadAccountVehicles"..
[16:53:04] [DEBUG] cache_get_data - connection: 1
[16:53:04] [DEBUG] CMySQLResult::~CMySQLResult() - deconstructor called
[16:53:04] [DEBUG] Calling callback "LoadAccountVehicles"..
[16:53:04] [DEBUG] cache_get_data - connection: 1
[16:53:04] [DEBUG] CMySQLResult::~CMySQLResult() - deconstructor called
[16:53:04] [DEBUG] Calling callback "LoadAccountVehicles"..
[16:53:04] [DEBUG] cache_get_data - connection: 1
[16:53:04] [DEBUG] CMySQLResult::~CMySQLResult() - deconstructor called
[16:53:04] [DEBUG] Calling callback "LoadAccountVehicles"..
[16:53:04] [DEBUG] cache_get_data - connection: 1
[16:53:04] [DEBUG] CMySQLResult::~CMySQLResult() - deconstructor called
[16:53:04] [DEBUG] Calling callback "LoadAccountVehicles"..
[16:53:04] [DEBUG] cache_get_data - connection: 1
[16:53:04] [DEBUG] CMySQLResult::~CMySQLResult() - deconstructor called

Mr.Pawn · 27. November 2015

Füge bei dem Laden als letztes noch "frak ++;" hinzu.

.Moersy · 27. November 2015

LohnInfo[frak][lRang11] = strval(result);
@Der Lümmel

frak++; hat leider nicht geholfen

Mr.Pawn · 27. November 2015

Füge es mal so ein und schick uns den Print.

C

case 1: {
	new string[128];
	LohnInfo[(PlayerInfo[playerid][pLeader])][lRang2] = geldgg;
	format(query,sizeof(query),"UPDATE lohn SET rang2_geld ='%d' WHERE frakid ='%d'",geldgg,PlayerInfo[playerid][pLeader]);
	printf("QUERY: %s", query);
	mysql_function_query(MYSQLVerbindung,query,false,"","");
}

**Andosius** · 27. November 2015

Dein Code verwirrt mich, warum lässt du Integer als String speichern und wandelst diese dann wieder um?

Und schick bitte noch ein Screenshot deiner Tabelle rein.
Ich habe absolut keine Ahnung was du da versuchst.

@Der Lümmel die MySQL Logs sind vollkommen in Ordnung.
Und nun bitte vollständigen Code, ich habe keine Lust dich jedes mal nochmal darum zu bitten.

Also:
MySQL Tabelle
Enum + dazugehörige Variable
Ladecode (der obige,aber vollständig)

.Moersy · 27. November 2015

Hat sich erledigt.
Das System war von Grundauf etwas fehlerhaft.
Danke an @iEnerqie er hat mir über Teamviewer sehr gut geholfen & erklärt.
Top!

Ich hab's aufgegeben, MYSQL Lohnsystem

Beitrag von Andosius (27. November 2015)

breadfish.de 12. März 2022