Gangzoneladefehler

Apokrate · 5. August 2015

Ich will es so machen, dass wenn keine Einträge in der Datenbank sind, erstmal nur das "geladen" wird, was ich festgelegt habe.
Ist aber etwas in der Datenbank vorhanden, so will ich das aus der Datenbank laden.

Mein Code:

mysql_tquery(dbhandle, "SELECT * FROM `gangzonen`", "LoadGangfightZones", "");

forward LoadGangfightZones();
public LoadGangfightZones()
{
new rows = cache_num_rows();
for(new i=0;i<rows;i++)
{
Gangzonen[i][GFOwnerID] = 0;
Gangzonen[i][GFGegnerID] = -1;
Gangzonen[i][GFOwnerPoints] = 0;
Gangzonen[i][GFGegnerPoints] = 0;
Gangzonen[i][GFRunningTime] = -1;
Gangzonen[i][GFPauseTime] = -1;

if(rows != 0)
{
Gangzonen[i][GFOwnerID] = cache_get_field_content_int(i,"GFOwnerID",dbhandle);
Gangzonen[i][GFGegnerID] = cache_get_field_content_int(i,"GFGegnerID",dbhandle);
Gangzonen[i][GFOwnerPoints] = cache_get_field_content_int(i,"GFOwnerPoints",dbhandle);
Gangzonen[i][GFGegnerPoints] = cache_get_field_content_int(i,"GFGegnerPoints",dbhandle);
Gangzonen[i][GFRunningTime] = cache_get_field_content_int(i,"GFRunningTime",dbhandle);
Gangzonen[i][GFPauseTime] = cache_get_field_content_int(i,"GFPauseTime",dbhandle);
Gangzonen[i][GFFlaggenOwnerA] = cache_get_field_content_int(i,"GFFlaggenOwnerA",dbhandle);
Gangzonen[i][GFFlaggenOwnerB] = cache_get_field_content_int(i,"GFFlaggenOwnerB",dbhandle);
Gangzonen[i][GFFlaggenOwnerC] = cache_get_field_content_int(i,"GFFlaggenOwnerC",dbhandle);
}
}
return 1;
}

Jeffry · 5. August 2015

Was genau ist das Problem? Was geht nicht?

Apokrate · 5. August 2015

Gangzonen[i][GFOwnerID] = 0;
Gangzonen[i][GFGegnerID] = -1;
Gangzonen[i][GFOwnerPoints] = 0;
Gangzonen[i][GFGegnerPoints] = 0;
Gangzonen[i][GFRunningTime] = -1;
Gangzonen[i][GFPauseTime] = -1;

Das wird irgendwie nicht "erstellt".

Bzw beim Saven wird es mir falsch in der Datenbank angezeigt.

Alles wird auf 0 gestzt.

Hier mein Savepublic:

forward SaveGangfightZones();
public SaveGangfightZones()
{
new string[128];
for(new i = 0; i < sizeof(Gangzonen); i++)
{
format(string, sizeof(string), "SELECT * FROM `gangzonen` WHERE `GangzoneID` = '%d'", i);
mysql_query(dbhandle, string);
mysql_store_result();
if(mysql_num_rows() == 0)
{
format(string, sizeof(string), "INSERT INTO `gangzonen` (`GangzoneID`) VALUES ('%d')", i);
mysql_query(dbhandle, string);
}
new var[526];
format(var, sizeof(var), "UPDATE `gangzonen` SET `GFOwnerID`='%d', `GFGegnerID`='%d', `GFOwnerPoints`='%d', `GFGegnerPoints`='%d', `GFRunningTime`='%d', `GFPauseTime`='%d', `GFFlaggenOwnerA`='%d', `GFFlaggenOwnerB`='%d', `GFFlaggenOwnerC`='%d' WHERE `GangzoneID`='%d'",
Gangzonen[i][GFOwnerID],
Gangzonen[i][GFGegnerID],
Gangzonen[i][GFOwnerPoints],
Gangzonen[i][GFGegnerPoints],
Gangzonen[i][GFRunningTime],
Gangzonen[i][GFPauseTime],
Gangzonen[i][GFFlaggenOwnerA],
Gangzonen[i][GFFlaggenOwnerB],
Gangzonen[i][GFFlaggenOwnerC],
i);
mysql_query(dbhandle, var);
}
mysql_free_result();
return 1;
}

Jeffry · 5. August 2015

Ok, so meinst du das.
Dann müsste es so passen:
forward LoadGangfightZones();
public LoadGangfightZones()
{
for(new i=0;i<sizeof(Gangzonen);i++)
{
Gangzonen[i][GFOwnerID] = 0;
Gangzonen[i][GFGegnerID] = -1;
Gangzonen[i][GFOwnerPoints] = 0;
Gangzonen[i][GFGegnerPoints] = 0;
Gangzonen[i][GFRunningTime] = -1;
Gangzonen[i][GFPauseTime] = -1;
}
new rows = cache_num_rows();
for(new i=0;i<rows;i++)
{
Gangzonen[i][GFOwnerID] = cache_get_field_content_int(i,"GFOwnerID",dbhandle);
Gangzonen[i][GFGegnerID] = cache_get_field_content_int(i,"GFGegnerID",dbhandle);
Gangzonen[i][GFOwnerPoints] = cache_get_field_content_int(i,"GFOwnerPoints",dbhandle);
Gangzonen[i][GFGegnerPoints] = cache_get_field_content_int(i,"GFGegnerPoints",dbhandle);
Gangzonen[i][GFRunningTime] = cache_get_field_content_int(i,"GFRunningTime",dbhandle);
Gangzonen[i][GFPauseTime] = cache_get_field_content_int(i,"GFPauseTime",dbhandle);
Gangzonen[i][GFFlaggenOwnerA] = cache_get_field_content_int(i,"GFFlaggenOwnerA",dbhandle);
Gangzonen[i][GFFlaggenOwnerB] = cache_get_field_content_int(i,"GFFlaggenOwnerB",dbhandle);
Gangzonen[i][GFFlaggenOwnerC] = cache_get_field_content_int(i,"GFFlaggenOwnerC",dbhandle);
}
return 1;
}

Apokrate · 5. August 2015

Klappt immer noch nicht.
Ist immer noch alles auf 0.

Jeffry · 5. August 2015

Hast du die Datensätze zuvor aus der Tabelle gelöscht? Wenn nein, dann mach das erst, sonst lädt er ja die Nullen aus der Datenbank.

Apokrate · 5. August 2015

Hab ich.

Jeffry · 5. August 2015

Dann mache es so, das ist auch etwas performanter:
forward LoadGangfightZones();
public LoadGangfightZones()
{
new rows = cache_num_rows(), string[128];
for(new i=0;i<rows;i++)
{
Gangzonen[i][GFOwnerID] = cache_get_field_content_int(i,"GFOwnerID",dbhandle);
Gangzonen[i][GFGegnerID] = cache_get_field_content_int(i,"GFGegnerID",dbhandle);
Gangzonen[i][GFOwnerPoints] = cache_get_field_content_int(i,"GFOwnerPoints",dbhandle);
Gangzonen[i][GFGegnerPoints] = cache_get_field_content_int(i,"GFGegnerPoints",dbhandle);
Gangzonen[i][GFRunningTime] = cache_get_field_content_int(i,"GFRunningTime",dbhandle);
Gangzonen[i][GFPauseTime] = cache_get_field_content_int(i,"GFPauseTime",dbhandle);
Gangzonen[i][GFFlaggenOwnerA] = cache_get_field_content_int(i,"GFFlaggenOwnerA",dbhandle);
Gangzonen[i][GFFlaggenOwnerB] = cache_get_field_content_int(i,"GFFlaggenOwnerB",dbhandle);
Gangzonen[i][GFFlaggenOwnerC] = cache_get_field_content_int(i,"GFFlaggenOwnerC",dbhandle);
}
for(new i=rows;i<sizeof(Gangzonen);i++)
{
Gangzonen[i][GFOwnerID] = 0;
Gangzonen[i][GFGegnerID] = -1;
Gangzonen[i][GFOwnerPoints] = 0;
Gangzonen[i][GFGegnerPoints] = 0;
Gangzonen[i][GFRunningTime] = -1;
Gangzonen[i][GFPauseTime] = -1;
format(string, sizeof(string), "INSERT INTO `gangzonen` (`GangzoneID`) VALUES ('%d')", i);
mysql_pquery(dbhandle, string);
}
SaveGangfightZones();
return 1;
}

forward SaveGangfightZones();
public SaveGangfightZones()
{
new var[526];
for(new i = 0; i < sizeof(Gangzonen); i++)
{
format(var, sizeof(var), "UPDATE `gangzonen` SET `GFOwnerID`='%d', `GFGegnerID`='%d', `GFOwnerPoints`='%d', `GFGegnerPoints`='%d', `GFRunningTime`='%d', `GFPauseTime`='%d', `GFFlaggenOwnerA`='%d', `GFFlaggenOwnerB`='%d', `GFFlaggenOwnerC`='%d' WHERE `GangzoneID`='%d'",
Gangzonen[i][GFOwnerID],
Gangzonen[i][GFGegnerID],
Gangzonen[i][GFOwnerPoints],
Gangzonen[i][GFGegnerPoints],
Gangzonen[i][GFRunningTime],
Gangzonen[i][GFPauseTime],
Gangzonen[i][GFFlaggenOwnerA],
Gangzonen[i][GFFlaggenOwnerB],
Gangzonen[i][GFFlaggenOwnerC],
i);
mysql_pquery(dbhandle, var);
}
return 1;
}

Dann erstellt es dir die Zonen wenn du den Server startest.
Lösche zuvor alle raus.

Apokrate · 5. August 2015

Jetzt werden die Zonen doppelt erstellt und die Werte sind trotzdem auf 0 .. Komisch

Jeffry · 5. August 2015

Schreibe es bitte mal so und poste dann was im Server Log steht.
forward LoadGangfightZones();
public LoadGangfightZones()
{
new rows = cache_num_rows(), string[128];
printf("LoadGangfightZones: %d rows", rows);
for(new i=0;i<rows;i++)
{
printf("Lade %d", i);
Gangzonen[i][GFOwnerID] = cache_get_field_content_int(i,"GFOwnerID",dbhandle);
Gangzonen[i][GFGegnerID] = cache_get_field_content_int(i,"GFGegnerID",dbhandle);
Gangzonen[i][GFOwnerPoints] = cache_get_field_content_int(i,"GFOwnerPoints",dbhandle);
Gangzonen[i][GFGegnerPoints] = cache_get_field_content_int(i,"GFGegnerPoints",dbhandle);
Gangzonen[i][GFRunningTime] = cache_get_field_content_int(i,"GFRunningTime",dbhandle);
Gangzonen[i][GFPauseTime] = cache_get_field_content_int(i,"GFPauseTime",dbhandle);
Gangzonen[i][GFFlaggenOwnerA] = cache_get_field_content_int(i,"GFFlaggenOwnerA",dbhandle);
Gangzonen[i][GFFlaggenOwnerB] = cache_get_field_content_int(i,"GFFlaggenOwnerB",dbhandle);
Gangzonen[i][GFFlaggenOwnerC] = cache_get_field_content_int(i,"GFFlaggenOwnerC",dbhandle);
}
for(new i=rows;i<sizeof(Gangzonen);i++)
{
printf("Erstelle %d neu", i);
Gangzonen[i][GFOwnerID] = 0;
Gangzonen[i][GFGegnerID] = -1;
Gangzonen[i][GFOwnerPoints] = 0;
Gangzonen[i][GFGegnerPoints] = 0;
Gangzonen[i][GFRunningTime] = -1;
Gangzonen[i][GFPauseTime] = -1;
format(string, sizeof(string), "INSERT INTO `gangzonen` (`GangzoneID`) VALUES ('%d')", i);
mysql_pquery(dbhandle, string);
}
print("Rufe SaveGangfightZones auf.");
SaveGangfightZones();
return 1;
}

forward SaveGangfightZones();
public SaveGangfightZones()
{
new var[526];
for(new i = 0; i < sizeof(Gangzonen); i++)
{
format(var, sizeof(var), "UPDATE `gangzonen` SET `GFOwnerID`='%d', `GFGegnerID`='%d', `GFOwnerPoints`='%d', `GFGegnerPoints`='%d', `GFRunningTime`='%d', `GFPauseTime`='%d', `GFFlaggenOwnerA`='%d', `GFFlaggenOwnerB`='%d', `GFFlaggenOwnerC`='%d' WHERE `GangzoneID`='%d'",
Gangzonen[i][GFOwnerID],
Gangzonen[i][GFGegnerID],
Gangzonen[i][GFOwnerPoints],
Gangzonen[i][GFGegnerPoints],
Gangzonen[i][GFRunningTime],
Gangzonen[i][GFPauseTime],
Gangzonen[i][GFFlaggenOwnerA],
Gangzonen[i][GFFlaggenOwnerB],
Gangzonen[i][GFFlaggenOwnerC],
i);
print(var);
mysql_pquery(dbhandle, var);
}
print("Fertig.");
return 1;
}

Apokrate · 5. August 2015

Code

[19:07:08] LoadGangfightZones: 1 rows
[19:07:08] Lade 0
[19:07:08] Erstelle 1 neu
[19:07:08] Erstelle 2 neu
[19:07:08] Erstelle 3 neu
[19:07:08] Erstelle 4 neu
[19:07:08] Erstelle 5 neu
[19:07:08] Erstelle 6 neu
[19:07:08] Erstelle 7 neu
[19:07:08] Erstelle 8 neu
[19:07:08] Rufe SaveGangfightZones auf.
[19:07:08] UPDATE `gangzonen` SET `GFOwnerID`='0', `GFGegnerID`='0', `GFOwnerPoints`='0', `GFGegnerPoints`='0', `GFRunningTime`='0', `GFPauseTime`='0', `GFFlaggenOwnerA`='0', `GFFlaggenOwnerB`='0', `GFFlaggenOwnerC`='0' WHERE `GangzoneID`='0'
[19:07:08] UPDATE `gangzonen` SET `GFOwnerID`='0', `GFGegnerID`='-1', `GFOwnerPoints`='0', `GFGegnerPoints`='0', `GFRunningTime`='-1', `GFPauseTime`='-1', `GFFlaggenOwnerA`='0', `GFFlaggenOwnerB`='0', `GFFlaggenOwnerC`='0' WHERE `GangzoneID`='1'
[19:07:08] UPDATE `gangzonen` SET `GFOwnerID`='0', `GFGegnerID`='-1', `GFOwnerPoints`='0', `GFGegnerPoints`='0', `GFRunningTime`='-1', `GFPauseTime`='-1', `GFFlaggenOwnerA`='0', `GFFlaggenOwnerB`='0', `GFFlaggenOwnerC`='0' WHERE `GangzoneID`='2'
[19:07:08] UPDATE `gangzonen` SET `GFOwnerID`='0', `GFGegnerID`='-1', `GFOwnerPoints`='0', `GFGegnerPoints`='0', `GFRunningTime`='-1', `GFPauseTime`='-1', `GFFlaggenOwnerA`='0', `GFFlaggenOwnerB`='0', `GFFlaggenOwnerC`='0' WHERE `GangzoneID`='3'
[19:07:08] UPDATE `gangzonen` SET `GFOwnerID`='0', `GFGegnerID`='-1', `GFOwnerPoints`='0', `GFGegnerPoints`='0', `GFRunningTime`='-1', `GFPauseTime`='-1', `GFFlaggenOwnerA`='0', `GFFlaggenOwnerB`='0', `GFFlaggenOwnerC`='0' WHERE `GangzoneID`='4'
[19:07:08] UPDATE `gangzonen` SET `GFOwnerID`='0', `GFGegnerID`='-1', `GFOwnerPoints`='0', `GFGegnerPoints`='0', `GFRunningTime`='-1', `GFPauseTime`='-1', `GFFlaggenOwnerA`='0', `GFFlaggenOwnerB`='0', `GFFlaggenOwnerC`='0' WHERE `GangzoneID`='5'
[19:07:08] UPDATE `gangzonen` SET `GFOwnerID`='0', `GFGegnerID`='-1', `GFOwnerPoints`='0', `GFGegnerPoints`='0', `GFRunningTime`='-1', `GFPauseTime`='-1', `GFFlaggenOwnerA`='0', `GFFlaggenOwnerB`='0', `GFFlaggenOwnerC`='0' WHERE `GangzoneID`='6'
[19:07:08] UPDATE `gangzonen` SET `GFOwnerID`='0', `GFGegnerID`='-1', `GFOwnerPoints`='0', `GFGegnerPoints`='0', `GFRunningTime`='-1', `GFPauseTime`='-1', `GFFlaggenOwnerA`='0', `GFFlaggenOwnerB`='0', `GFFlaggenOwnerC`='0' WHERE `GangzoneID`='7'
[19:07:08] UPDATE `gangzonen` SET `GFOwnerID`='0', `GFGegnerID`='-1', `GFOwnerPoints`='0', `GFGegnerPoints`='0', `GFRunningTime`='-1', `GFPauseTime`='-1', `GFFlaggenOwnerA`='0', `GFFlaggenOwnerB`='0', `GFFlaggenOwnerC`='0' WHERE `GangzoneID`='8'
[19:07:08] Fertig.

Alles anzeigen

Jeffry · 5. August 2015

Hast du irgendwo noch einen anderen Code, der in dieser Tabelle schreibt? Laut Log ist nämlich alles korrekt.

Apokrate · 5. August 2015

mysql_tquery(dbhandle, "SELECT * FROM `gangzonen`", "LoadGangfightZones", "");

forward LoadGangfightZones();
public LoadGangfightZones()
{
new rows = cache_num_rows(), string[128];
printf("LoadGangfightZones: %d rows", rows);
for(new i=0;i<rows;i++)
{
printf("Lade %d", i);
Gangzonen[i][GFOwnerID] = cache_get_field_content_int(i,"GFOwnerID",dbhandle);
Gangzonen[i][GFGegnerID] = cache_get_field_content_int(i,"GFGegnerID",dbhandle);
Gangzonen[i][GFOwnerPoints] = cache_get_field_content_int(i,"GFOwnerPoints",dbhandle);
Gangzonen[i][GFGegnerPoints] = cache_get_field_content_int(i,"GFGegnerPoints",dbhandle);
Gangzonen[i][GFRunningTime] = cache_get_field_content_int(i,"GFRunningTime",dbhandle);
Gangzonen[i][GFPauseTime] = cache_get_field_content_int(i,"GFPauseTime",dbhandle);
Gangzonen[i][GFFlaggenOwnerA] = cache_get_field_content_int(i,"GFFlaggenOwnerA",dbhandle);
Gangzonen[i][GFFlaggenOwnerB] = cache_get_field_content_int(i,"GFFlaggenOwnerB",dbhandle);
Gangzonen[i][GFFlaggenOwnerC] = cache_get_field_content_int(i,"GFFlaggenOwnerC",dbhandle);
}
for(new i=rows;i<sizeof(Gangzonen);i++)
{
printf("Erstelle %d neu", i);
Gangzonen[i][GFOwnerID] = 0;
Gangzonen[i][GFGegnerID] = -1;
Gangzonen[i][GFOwnerPoints] = 0;
Gangzonen[i][GFGegnerPoints] = 0;
Gangzonen[i][GFRunningTime] = -1;
Gangzonen[i][GFPauseTime] = -1;
format(string, sizeof(string), "INSERT INTO `gangzonen` (`GangzoneID`) VALUES ('%d')", i);
mysql_query(dbhandle, string);
}
print("Rufe SaveGangfightZones auf.");
SaveGangfightZones();
return 1;
}

forward SaveGangfightZones();
public SaveGangfightZones()
{
new var[526];
for(new i = 0; i < sizeof(Gangzonen); i++)
{
format(var, sizeof(var), "UPDATE `gangzonen` SET `GFOwnerID`='%d', `GFGegnerID`='%d', `GFOwnerPoints`='%d', `GFGegnerPoints`='%d', `GFRunningTime`='%d', `GFPauseTime`='%d', `GFFlaggenOwnerA`='%d', `GFFlaggenOwnerB`='%d', `GFFlaggenOwnerC`='%d' WHERE `GangzoneID`='%d'",
Gangzonen[i][GFOwnerID],
Gangzonen[i][GFGegnerID],
Gangzonen[i][GFOwnerPoints],
Gangzonen[i][GFGegnerPoints],
Gangzonen[i][GFRunningTime],
Gangzonen[i][GFPauseTime],
Gangzonen[i][GFFlaggenOwnerA],
Gangzonen[i][GFFlaggenOwnerB],
Gangzonen[i][GFFlaggenOwnerC],
i);
print(var);
mysql_query(dbhandle, var);
}
print("Fertig.");
return 1;
}
Nur das.

Jeffry · 5. August 2015

Was steht im Log, wenn du die Tabelle so lässt und den Server dann nochmal startest?
Gibt dir der MySQL Log etwas aus?

Apokrate · 5. August 2015

[19:43:55] LoadGangfightZones: 0 rows
[19:43:55] Erstelle 0 neu
[19:43:55] Erstelle 1 neu
[19:43:55] Erstelle 2 neu
[19:43:55] Erstelle 3 neu
[19:43:55] Erstelle 4 neu
[19:43:55] Erstelle 5 neu
[19:43:55] Erstelle 6 neu
[19:43:55] Erstelle 7 neu
[19:43:55] Erstelle 8 neu
[19:43:55] Rufe SaveGangfightZones auf.
[19:43:55] UPDATE `gangzonen` SET `GFOwnerID`='0', `GFGegnerID`='-1', `GFOwnerPoints`='0', `GFGegnerPoints`='0', `GFRunningTime`='-1', `GFPauseTime`='-1', `GFFlaggenOwnerA`='0', `GFFlaggenOwnerB`='0', `GFFlaggenOwnerC`='0' WHERE `GangzoneID`='0'
[19:43:55] UPDATE `gangzonen` SET `GFOwnerID`='0', `GFGegnerID`='-1', `GFOwnerPoints`='0', `GFGegnerPoints`='0', `GFRunningTime`='-1', `GFPauseTime`='-1', `GFFlaggenOwnerA`='0', `GFFlaggenOwnerB`='0', `GFFlaggenOwnerC`='0' WHERE `GangzoneID`='1'
[19:43:55] UPDATE `gangzonen` SET `GFOwnerID`='0', `GFGegnerID`='-1', `GFOwnerPoints`='0', `GFGegnerPoints`='0', `GFRunningTime`='-1', `GFPauseTime`='-1', `GFFlaggenOwnerA`='0', `GFFlaggenOwnerB`='0', `GFFlaggenOwnerC`='0' WHERE `GangzoneID`='2'
[19:43:55] UPDATE `gangzonen` SET `GFOwnerID`='0', `GFGegnerID`='-1', `GFOwnerPoints`='0', `GFGegnerPoints`='0', `GFRunningTime`='-1', `GFPauseTime`='-1', `GFFlaggenOwnerA`='0', `GFFlaggenOwnerB`='0', `GFFlaggenOwnerC`='0' WHERE `GangzoneID`='3'
[19:43:55] UPDATE `gangzonen` SET `GFOwnerID`='0', `GFGegnerID`='-1', `GFOwnerPoints`='0', `GFGegnerPoints`='0', `GFRunningTime`='-1', `GFPauseTime`='-1', `GFFlaggenOwnerA`='0', `GFFlaggenOwnerB`='0', `GFFlaggenOwnerC`='0' WHERE `GangzoneID`='4'
[19:43:55] UPDATE `gangzonen` SET `GFOwnerID`='0', `GFGegnerID`='-1', `GFOwnerPoints`='0', `GFGegnerPoints`='0', `GFRunningTime`='-1', `GFPauseTime`='-1', `GFFlaggenOwnerA`='0', `GFFlaggenOwnerB`='0', `GFFlaggenOwnerC`='0' WHERE `GangzoneID`='5'
[19:43:55] UPDATE `gangzonen` SET `GFOwnerID`='0', `GFGegnerID`='-1', `GFOwnerPoints`='0', `GFGegnerPoints`='0', `GFRunningTime`='-1', `GFPauseTime`='-1', `GFFlaggenOwnerA`='0', `GFFlaggenOwnerB`='0', `GFFlaggenOwnerC`='0' WHERE `GangzoneID`='6'
[19:43:55] UPDATE `gangzonen` SET `GFOwnerID`='0', `GFGegnerID`='-1', `GFOwnerPoints`='0', `GFGegnerPoints`='0', `GFRunningTime`='-1', `GFPauseTime`='-1', `GFFlaggenOwnerA`='0', `GFFlaggenOwnerB`='0', `GFFlaggenOwnerC`='0' WHERE `GangzoneID`='7'
[19:43:55] UPDATE `gangzonen` SET `GFOwnerID`='0', `GFGegnerID`='-1', `GFOwnerPoints`='0', `GFGegnerPoints`='0', `GFRunningTime`='-1', `GFPauseTime`='-1', `GFFlaggenOwnerA`='0', `GFFlaggenOwnerB`='0', `GFFlaggenOwnerC`='0' WHERE `GangzoneID`='8'
[19:43:55] Fertig.

[19:43:55] LoadGangfightZones: 18 rows
[19:43:55] Lade 0
[19:43:55] Lade 1
[19:43:55] Lade 2
[19:43:55] Lade 3
[19:43:55] Lade 4
[19:43:55] Lade 5
[19:43:55] Lade 6
[19:43:55] Lade 7
[19:43:55] Lade 8
[19:43:55] Lade 9
[19:43:55] [debug] Run time error 4: "Array index out of bounds"
[19:43:55] [debug] Accessing element at index 9 past array upper bound 8
[19:43:55] [debug] AMX backtrace:
[19:43:55] [debug] #0 000128c4 in public LoadGangfightZones () from selfmade.amx

Die Tabelle wurde länger.

Jeffry · 5. August 2015

Wie kann es sein, dass LoadGangfightZones zwei mal zur identischen Zeit aufgerufen wird? Hast du das in einer Schleife?

Apokrate · 5. August 2015

Hatte es ausersehen doppelt drin.
Habs dann raus gemacht und neu probiert.
Erst Datenbank geleert, dann gestartet und neugestartet.

[19:43:55] LoadGangfightZones: 0 rows
[19:43:55] Erstelle 0 neu
[19:43:55] Erstelle 1 neu
[19:43:55] Erstelle 2 neu
[19:43:55] Erstelle 3 neu
[19:43:55] Erstelle 4 neu
[19:43:55] Erstelle 5 neu
[19:43:55] Erstelle 6 neu
[19:43:55] Erstelle 7 neu
[19:43:55] Erstelle 8 neu
[19:43:55] Rufe SaveGangfightZones auf.
[19:43:55] UPDATE `gangzonen` SET `GFOwnerID`='0', `GFGegnerID`='-1', `GFOwnerPoints`='0', `GFGegnerPoints`='0', `GFRunningTime`='-1', `GFPauseTime`='-1', `GFFlaggenOwnerA`='0', `GFFlaggenOwnerB`='0', `GFFlaggenOwnerC`='0' WHERE `GangzoneID`='0'
[19:43:55] UPDATE `gangzonen` SET `GFOwnerID`='0', `GFGegnerID`='-1', `GFOwnerPoints`='0', `GFGegnerPoints`='0', `GFRunningTime`='-1', `GFPauseTime`='-1', `GFFlaggenOwnerA`='0', `GFFlaggenOwnerB`='0', `GFFlaggenOwnerC`='0' WHERE `GangzoneID`='1'
[19:43:55] UPDATE `gangzonen` SET `GFOwnerID`='0', `GFGegnerID`='-1', `GFOwnerPoints`='0', `GFGegnerPoints`='0', `GFRunningTime`='-1', `GFPauseTime`='-1', `GFFlaggenOwnerA`='0', `GFFlaggenOwnerB`='0', `GFFlaggenOwnerC`='0' WHERE `GangzoneID`='2'
[19:43:55] UPDATE `gangzonen` SET `GFOwnerID`='0', `GFGegnerID`='-1', `GFOwnerPoints`='0', `GFGegnerPoints`='0', `GFRunningTime`='-1', `GFPauseTime`='-1', `GFFlaggenOwnerA`='0', `GFFlaggenOwnerB`='0', `GFFlaggenOwnerC`='0' WHERE `GangzoneID`='3'
[19:43:55] UPDATE `gangzonen` SET `GFOwnerID`='0', `GFGegnerID`='-1', `GFOwnerPoints`='0', `GFGegnerPoints`='0', `GFRunningTime`='-1', `GFPauseTime`='-1', `GFFlaggenOwnerA`='0', `GFFlaggenOwnerB`='0', `GFFlaggenOwnerC`='0' WHERE `GangzoneID`='4'
[19:43:55] UPDATE `gangzonen` SET `GFOwnerID`='0', `GFGegnerID`='-1', `GFOwnerPoints`='0', `GFGegnerPoints`='0', `GFRunningTime`='-1', `GFPauseTime`='-1', `GFFlaggenOwnerA`='0', `GFFlaggenOwnerB`='0', `GFFlaggenOwnerC`='0' WHERE `GangzoneID`='5'
[19:43:55] UPDATE `gangzonen` SET `GFOwnerID`='0', `GFGegnerID`='-1', `GFOwnerPoints`='0', `GFGegnerPoints`='0', `GFRunningTime`='-1', `GFPauseTime`='-1', `GFFlaggenOwnerA`='0', `GFFlaggenOwnerB`='0', `GFFlaggenOwnerC`='0' WHERE `GangzoneID`='6'
[19:43:55] UPDATE `gangzonen` SET `GFOwnerID`='0', `GFGegnerID`='-1', `GFOwnerPoints`='0', `GFGegnerPoints`='0', `GFRunningTime`='-1', `GFPauseTime`='-1', `GFFlaggenOwnerA`='0', `GFFlaggenOwnerB`='0', `GFFlaggenOwnerC`='0' WHERE `GangzoneID`='7'
[19:43:55] UPDATE `gangzonen` SET `GFOwnerID`='0', `GFGegnerID`='-1', `GFOwnerPoints`='0', `GFGegnerPoints`='0', `GFRunningTime`='-1', `GFPauseTime`='-1', `GFFlaggenOwnerA`='0', `GFFlaggenOwnerB`='0', `GFFlaggenOwnerC`='0' WHERE `GangzoneID`='8'
[19:43:55] Fertig.

[19:43:55] Lade 0
[19:43:55] Lade 1
[19:43:55] Lade 2
[19:43:55] Lade 3
[19:43:55] Lade 4
[19:43:55] Lade 5
[19:43:55] Lade 6
[19:43:55] Lade 7
[19:43:55] Lade 8
[19:43:55] Lade 9
[19:43:55] [debug] Run time error 4: "Array index out of bounds"
[19:43:55] [debug] Accessing element at index 9 past array upper bound 8
[19:43:55] [debug] AMX backtrace:
[19:43:55] [debug] #0 000128c4 in public LoadGangfightZones () from selfmade.amx

Restart:

[20:45:09] LoadGangfightZones: 0 rows
[20:45:09] Erstelle 0 neu
[20:45:09] Erstelle 1 neu
[20:45:09] Erstelle 2 neu
[20:45:09] Erstelle 3 neu
[20:45:09] Erstelle 4 neu
[20:45:09] Erstelle 5 neu
[20:45:10] Erstelle 6 neu
[20:45:10] Erstelle 7 neu
[20:45:10] Erstelle 8 neu
[20:45:10] Rufe SaveGangfightZones auf.
[20:45:10] UPDATE `gangzonen` SET `GFOwnerID`='0', `GFGegnerID`='-1', `GFOwnerPoints`='0', `GFGegnerPoints`='0', `GFRunningTime`='-1', `GFPauseTime`='-1', `GFFlaggenOwnerA`='0', `GFFlaggenOwnerB`='0', `GFFlaggenOwnerC`='0' WHERE `GangzoneID`='0'
[20:45:10] UPDATE `gangzonen` SET `GFOwnerID`='0', `GFGegnerID`='-1', `GFOwnerPoints`='0', `GFGegnerPoints`='0', `GFRunningTime`='-1', `GFPauseTime`='-1', `GFFlaggenOwnerA`='0', `GFFlaggenOwnerB`='0', `GFFlaggenOwnerC`='0' WHERE `GangzoneID`='1'
[20:45:10] UPDATE `gangzonen` SET `GFOwnerID`='0', `GFGegnerID`='-1', `GFOwnerPoints`='0', `GFGegnerPoints`='0', `GFRunningTime`='-1', `GFPauseTime`='-1', `GFFlaggenOwnerA`='0', `GFFlaggenOwnerB`='0', `GFFlaggenOwnerC`='0' WHERE `GangzoneID`='2'
[20:45:10] UPDATE `gangzonen` SET `GFOwnerID`='0', `GFGegnerID`='-1', `GFOwnerPoints`='0', `GFGegnerPoints`='0', `GFRunningTime`='-1', `GFPauseTime`='-1', `GFFlaggenOwnerA`='0', `GFFlaggenOwnerB`='0', `GFFlaggenOwnerC`='0' WHERE `GangzoneID`='3'
[20:45:10] UPDATE `gangzonen` SET `GFOwnerID`='0', `GFGegnerID`='-1', `GFOwnerPoints`='0', `GFGegnerPoints`='0', `GFRunningTime`='-1', `GFPauseTime`='-1', `GFFlaggenOwnerA`='0', `GFFlaggenOwnerB`='0', `GFFlaggenOwnerC`='0' WHERE `GangzoneID`='4'
[20:45:10] UPDATE `gangzonen` SET `GFOwnerID`='0', `GFGegnerID`='-1', `GFOwnerPoints`='0', `GFGegnerPoints`='0', `GFRunningTime`='-1', `GFPauseTime`='-1', `GFFlaggenOwnerA`='0', `GFFlaggenOwnerB`='0', `GFFlaggenOwnerC`='0' WHERE `GangzoneID`='5'
[20:45:10] UPDATE `gangzonen` SET `GFOwnerID`='0', `GFGegnerID`='-1', `GFOwnerPoints`='0', `GFGegnerPoints`='0', `GFRunningTime`='-1', `GFPauseTime`='-1', `GFFlaggenOwnerA`='0', `GFFlaggenOwnerB`='0', `GFFlaggenOwnerC`='0' WHERE `GangzoneID`='6'
[20:45:10] UPDATE `gangzonen` SET `GFOwnerID`='0', `GFGegnerID`='-1', `GFOwnerPoints`='0', `GFGegnerPoints`='0', `GFRunningTime`='-1', `GFPauseTime`='-1', `GFFlaggenOwnerA`='0', `GFFlaggenOwnerB`='0', `GFFlaggenOwnerC`='0' WHERE `GangzoneID`='7'
[20:45:10] UPDATE `gangzonen` SET `GFOwnerID`='0', `GFGegnerID`='-1', `GFOwnerPoints`='0', `GFGegnerPoints`='0', `GFRunningTime`='-1', `GFPauseTime`='-1', `GFFlaggenOwnerA`='0', `GFFlaggenOwnerB`='0', `GFFlaggenOwnerC`='0' WHERE `GangzoneID`='8'
[20:45:10] Fertig.

Jeffry · 5. August 2015

In dem Log sind immer noch die alten Zeiten drin.

Folgende Schritte:
Server aus machen
Server Log löschen
Server starten
Server aus machen
Server starten
Log posten

Apokrate · 5. August 2015

[22:12:07] LoadGangfightZones: 9 rows
[22:12:07] Lade 0
[22:12:07] Lade 1
[22:12:07] Lade 2
[22:12:07] Lade 3
[22:12:07] Lade 4
[22:12:07] Lade 5
[22:12:07] Lade 6
[22:12:07] Lade 7
[22:12:07] Lade 8
[22:12:07] Rufe SaveGangfightZones auf.
[22:12:07] UPDATE `gangzonen` SET `GFOwnerID`='0', `GFGegnerID`='0', `GFOwnerPoints`='0', `GFGegnerPoints`='0', `GFRunningTime`='0', `GFPauseTime`='0', `GFFlaggenOwnerA`='0', `GFFlaggenOwnerB`='0', `GFFlaggenOwnerC`='0' WHERE `GangzoneID`='0'
[22:12:07] UPDATE `gangzonen` SET `GFOwnerID`='0', `GFGegnerID`='0', `GFOwnerPoints`='0', `GFGegnerPoints`='0', `GFRunningTime`='0', `GFPauseTime`='0', `GFFlaggenOwnerA`='0', `GFFlaggenOwnerB`='0', `GFFlaggenOwnerC`='0' WHERE `GangzoneID`='1'
[22:12:07] UPDATE `gangzonen` SET `GFOwnerID`='0', `GFGegnerID`='0', `GFOwnerPoints`='0', `GFGegnerPoints`='0', `GFRunningTime`='0', `GFPauseTime`='0', `GFFlaggenOwnerA`='0', `GFFlaggenOwnerB`='0', `GFFlaggenOwnerC`='0' WHERE `GangzoneID`='2'
[22:12:07] UPDATE `gangzonen` SET `GFOwnerID`='0', `GFGegnerID`='0', `GFOwnerPoints`='0', `GFGegnerPoints`='0', `GFRunningTime`='0', `GFPauseTime`='0', `GFFlaggenOwnerA`='0', `GFFlaggenOwnerB`='0', `GFFlaggenOwnerC`='0' WHERE `GangzoneID`='3'
[22:12:07] UPDATE `gangzonen` SET `GFOwnerID`='0', `GFGegnerID`='0', `GFOwnerPoints`='0', `GFGegnerPoints`='0', `GFRunningTime`='0', `GFPauseTime`='0', `GFFlaggenOwnerA`='0', `GFFlaggenOwnerB`='0', `GFFlaggenOwnerC`='0' WHERE `GangzoneID`='4'
[22:12:08] UPDATE `gangzonen` SET `GFOwnerID`='0', `GFGegnerID`='0', `GFOwnerPoints`='0', `GFGegnerPoints`='0', `GFRunningTime`='0', `GFPauseTime`='0', `GFFlaggenOwnerA`='0', `GFFlaggenOwnerB`='0', `GFFlaggenOwnerC`='0' WHERE `GangzoneID`='5'
[22:12:08] UPDATE `gangzonen` SET `GFOwnerID`='0', `GFGegnerID`='0', `GFOwnerPoints`='0', `GFGegnerPoints`='0', `GFRunningTime`='0', `GFPauseTime`='0', `GFFlaggenOwnerA`='0', `GFFlaggenOwnerB`='0', `GFFlaggenOwnerC`='0' WHERE `GangzoneID`='6'
[22:12:08] UPDATE `gangzonen` SET `GFOwnerID`='0', `GFGegnerID`='0', `GFOwnerPoints`='0', `GFGegnerPoints`='0', `GFRunningTime`='0', `GFPauseTime`='0', `GFFlaggenOwnerA`='0', `GFFlaggenOwnerB`='0', `GFFlaggenOwnerC`='0' WHERE `GangzoneID`='7'
[22:12:08] UPDATE `gangzonen` SET `GFOwnerID`='0', `GFGegnerID`='0', `GFOwnerPoints`='0', `GFGegnerPoints`='0', `GFRunningTime`='0', `GFPauseTime`='0', `GFFlaggenOwnerA`='0', `GFFlaggenOwnerB`='0', `GFFlaggenOwnerC`='0' WHERE `GangzoneID`='8'
[22:12:08] Fertig.

[22:12:17] UPDATE `gangzonen` SET `GFOwnerID`='0', `GFGegnerID`='0', `GFOwnerPoints`='0', `GFGegnerPoints`='0', `GFRunningTime`='0', `GFPauseTime`='0', `GFFlaggenOwnerA`='0', `GFFlaggenOwnerB`='0', `GFFlaggenOwnerC`='0' WHERE `GangzoneID`='0'
[22:12:17] UPDATE `gangzonen` SET `GFOwnerID`='0', `GFGegnerID`='0', `GFOwnerPoints`='0', `GFGegnerPoints`='0', `GFRunningTime`='0', `GFPauseTime`='0', `GFFlaggenOwnerA`='0', `GFFlaggenOwnerB`='0', `GFFlaggenOwnerC`='0' WHERE `GangzoneID`='1'
[22:12:17] UPDATE `gangzonen` SET `GFOwnerID`='0', `GFGegnerID`='0', `GFOwnerPoints`='0', `GFGegnerPoints`='0', `GFRunningTime`='0', `GFPauseTime`='0', `GFFlaggenOwnerA`='0', `GFFlaggenOwnerB`='0', `GFFlaggenOwnerC`='0' WHERE `GangzoneID`='2'
[22:12:17] UPDATE `gangzonen` SET `GFOwnerID`='0', `GFGegnerID`='0', `GFOwnerPoints`='0', `GFGegnerPoints`='0', `GFRunningTime`='0', `GFPauseTime`='0', `GFFlaggenOwnerA`='0', `GFFlaggenOwnerB`='0', `GFFlaggenOwnerC`='0' WHERE `GangzoneID`='3'
[22:12:17] UPDATE `gangzonen` SET `GFOwnerID`='0', `GFGegnerID`='0', `GFOwnerPoints`='0', `GFGegnerPoints`='0', `GFRunningTime`='0', `GFPauseTime`='0', `GFFlaggenOwnerA`='0', `GFFlaggenOwnerB`='0', `GFFlaggenOwnerC`='0' WHERE `GangzoneID`='4'
[22:12:17] UPDATE `gangzonen` SET `GFOwnerID`='0', `GFGegnerID`='0', `GFOwnerPoints`='0', `GFGegnerPoints`='0', `GFRunningTime`='0', `GFPauseTime`='0', `GFFlaggenOwnerA`='0', `GFFlaggenOwnerB`='0', `GFFlaggenOwnerC`='0' WHERE `GangzoneID`='5'
[22:12:17] UPDATE `gangzonen` SET `GFOwnerID`='0', `GFGegnerID`='0', `GFOwnerPoints`='0', `GFGegnerPoints`='0', `GFRunningTime`='0', `GFPauseTime`='0', `GFFlaggenOwnerA`='0', `GFFlaggenOwnerB`='0', `GFFlaggenOwnerC`='0' WHERE `GangzoneID`='6'
[22:12:17] UPDATE `gangzonen` SET `GFOwnerID`='0', `GFGegnerID`='0', `GFOwnerPoints`='0', `GFGegnerPoints`='0', `GFRunningTime`='0', `GFPauseTime`='0', `GFFlaggenOwnerA`='0', `GFFlaggenOwnerB`='0', `GFFlaggenOwnerC`='0' WHERE `GangzoneID`='7'
[22:12:17] UPDATE `gangzonen` SET `GFOwnerID`='0', `GFGegnerID`='0', `GFOwnerPoints`='0', `GFGegnerPoints`='0', `GFRunningTime`='0', `GFPauseTime`='0', `GFFlaggenOwnerA`='0', `GFFlaggenOwnerB`='0', `GFFlaggenOwnerC`='0' WHERE `GangzoneID`='8'
[22:12:17] Fertig.
[22:12:19] [debug] Server crashed while executing selfmade.amx
[22:12:19] [debug] AMX backtrace:
[22:12:19] [debug] #0 native mysql_close () [56ead920] from mysql.DLL
[22:12:19] [debug] #1 00013c58 in public OnGameModeExit () from selfmade.amx
[22:12:19] [debug] Native backtrace:
[22:12:19] [debug] #0 100379cc in ?? () from LIBMYSQL.dll
[22:12:19] [debug] #1 10037a7a in ?? () from LIBMYSQL.dll

[22:12:24] LoadGangfightZones: 9 rows
[22:12:24] Lade 0
[22:12:24] Lade 1
[22:12:24] Lade 2
[22:12:24] Lade 3
[22:12:24] Lade 4
[22:12:24] Lade 5
[22:12:24] Lade 6
[22:12:24] Lade 7
[22:12:24] Lade 8
[22:12:24] Rufe SaveGangfightZones auf.
[22:12:24] UPDATE `gangzonen` SET `GFOwnerID`='0', `GFGegnerID`='0', `GFOwnerPoints`='0', `GFGegnerPoints`='0', `GFRunningTime`='0', `GFPauseTime`='0', `GFFlaggenOwnerA`='0', `GFFlaggenOwnerB`='0', `GFFlaggenOwnerC`='0' WHERE `GangzoneID`='0'
[22:12:24] UPDATE `gangzonen` SET `GFOwnerID`='0', `GFGegnerID`='0', `GFOwnerPoints`='0', `GFGegnerPoints`='0', `GFRunningTime`='0', `GFPauseTime`='0', `GFFlaggenOwnerA`='0', `GFFlaggenOwnerB`='0', `GFFlaggenOwnerC`='0' WHERE `GangzoneID`='1'
[22:12:24] UPDATE `gangzonen` SET `GFOwnerID`='0', `GFGegnerID`='0', `GFOwnerPoints`='0', `GFGegnerPoints`='0', `GFRunningTime`='0', `GFPauseTime`='0', `GFFlaggenOwnerA`='0', `GFFlaggenOwnerB`='0', `GFFlaggenOwnerC`='0' WHERE `GangzoneID`='2'
[22:12:24] UPDATE `gangzonen` SET `GFOwnerID`='0', `GFGegnerID`='0', `GFOwnerPoints`='0', `GFGegnerPoints`='0', `GFRunningTime`='0', `GFPauseTime`='0', `GFFlaggenOwnerA`='0', `GFFlaggenOwnerB`='0', `GFFlaggenOwnerC`='0' WHERE `GangzoneID`='3'
[22:12:24] UPDATE `gangzonen` SET `GFOwnerID`='0', `GFGegnerID`='0', `GFOwnerPoints`='0', `GFGegnerPoints`='0', `GFRunningTime`='0', `GFPauseTime`='0', `GFFlaggenOwnerA`='0', `GFFlaggenOwnerB`='0', `GFFlaggenOwnerC`='0' WHERE `GangzoneID`='4'
[22:12:24] UPDATE `gangzonen` SET `GFOwnerID`='0', `GFGegnerID`='0', `GFOwnerPoints`='0', `GFGegnerPoints`='0', `GFRunningTime`='0', `GFPauseTime`='0', `GFFlaggenOwnerA`='0', `GFFlaggenOwnerB`='0', `GFFlaggenOwnerC`='0' WHERE `GangzoneID`='5'
[22:12:24] UPDATE `gangzonen` SET `GFOwnerID`='0', `GFGegnerID`='0', `GFOwnerPoints`='0', `GFGegnerPoints`='0', `GFRunningTime`='0', `GFPauseTime`='0', `GFFlaggenOwnerA`='0', `GFFlaggenOwnerB`='0', `GFFlaggenOwnerC`='0' WHERE `GangzoneID`='6'
[22:12:24] UPDATE `gangzonen` SET `GFOwnerID`='0', `GFGegnerID`='0', `GFOwnerPoints`='0', `GFGegnerPoints`='0', `GFRunningTime`='0', `GFPauseTime`='0', `GFFlaggenOwnerA`='0', `GFFlaggenOwnerB`='0', `GFFlaggenOwnerC`='0' WHERE `GangzoneID`='7'
[22:12:24] UPDATE `gangzonen` SET `GFOwnerID`='0', `GFGegnerID`='0', `GFOwnerPoints`='0', `GFGegnerPoints`='0', `GFRunningTime`='0', `GFPauseTime`='0', `GFFlaggenOwnerA`='0', `GFFlaggenOwnerB`='0', `GFFlaggenOwnerC`='0' WHERE `GangzoneID`='8'
[22:12:24] Fertig.

Jeffry · 5. August 2015

Das passt alles.

Jetzt so:
Server aus machen
Server Log löschen
Tabelle in der Datenbank leeren
Server starten
Server aus machen
Server starten
Log posten