Beiträge von Grapefruit

public OnFilterScriptInit()
{
LoadGZ();
M_Init();

GFPunkte_o = TextDrawCreate(19, 326, "Punkte (Owner): ");
TextDrawFont(GFPunkte_o , 3);
TextDrawLetterSize(GFPunkte_o , 0.3, 2.1);
TextDrawColor(GFPunkte_o , Blau);
TextDrawSetOutline(GFPunkte_o , 0);
TextDrawSetProportional(GFPunkte_o , 1);
TextDrawSetShadow(GFPunkte_o , 1);

GFPunkte_a = TextDrawCreate(19, 346, "Punkte (angreifer): ");
TextDrawFont(GFPunkte_a , 3);
TextDrawLetterSize(GFPunkte_a , 0.3, 2.1);
TextDrawColor(GFPunkte_a , Rot);
TextDrawSetOutline(GFPunkte_a , 0);
TextDrawSetProportional(GFPunkte_a , 1);
TextDrawSetShadow(GFPunkte_a , 1);

GFZeit = TextDrawCreate(19, 306, "Zeit: ");
TextDrawFont(GFZeit , 3);
TextDrawLetterSize(GFZeit , 0.3, 2.1);
TextDrawColor(GFZeit , HGruen);
TextDrawSetOutline(GFZeit , 0);
TextDrawSetProportional(GFZeit , 1);
TextDrawSetShadow(GFZeit , 1);

for(new i = 0; i<MAX_FRAKTIONEN; i++)ImGF[i] = 0;
return 1;
}

Davor waren oben bei LoadGZ noch prints, aber die hatte ich gestern entfernt, weil dies ging.

stock LoadGZ()
{
print("test");
new string[500], str[64];
mysql_query("SELECT * FROM gangwar");
mysql_store_result();
new i = -1, counter = 0;
while(mysql_fetch_row(string))
{
i++;
strins(string, "|", strlen(string));
new oldx=0;
new count=0;
for(new x=0; x<strlen(string); x++)
{
if(string[x]=='|')
{
count++;
new tmpstring[sizeof(string)]; tmpstring=string;
strdel(tmpstring, x, strlen(tmpstring));
strdel(tmpstring, 0, oldx+1);
switch(count)
{
case 2: GZ[i][owner] = strval(tmpstring);
case 3: GZ[i][max_x] = floatstr(tmpstring);
case 4: GZ[i][max_y] = floatstr(tmpstring);
case 5: GZ[i][min_x] = floatstr(tmpstring);
case 6: GZ[i][min_y] = floatstr(tmpstring);
case 7: GZ[i][flagge_x] = floatstr(tmpstring);
case 8: GZ[i][flagge_y] = floatstr(tmpstring);
case 9: GZ[i][flagge_z] = floatstr(tmpstring);
case 10: GZ[i][erstellt] = strval(tmpstring);
}
oldx=x;
}
}
GZ[i][zid] = i;
if(GZ[i][erstellt] != 1)continue;
format(str,64,"%d |Besitzer: '%s'",i,FrakName(GZ[i][owner]));
M_CreateZone(GZ[i][min_x],GZ[i][min_y],GZ[i][max_x],GZ[i][max_y],FrakColor(GZ[i][owner]),str,FrakColor(GZ[i][owner]));
GZ[i][pickup] = CreatePickup(1314,1,GZ[i][flagge_x],GZ[i][flagge_y],GZ[i][flagge_z],0);
GZ[i][label] = Create3DTextLabel("Tippe '/angriff', um das Gebiet anzugreifen.\nTippe '/flagge', um die Flagge zu erobern.",Rot,GZ[i][flagge_x],GZ[i][flagge_y],GZ[i][flagge_z],20,0);
counter ++;
}
return printf(" '%d' Gangzone(n) wurde(n) erfolgreich erstellt und geladen.",counter);
}
stock LoadGZ_(i)
{
new string[500], str[64];
mysql_query("SELECT * FROM gangwar");
mysql_store_result();
new counter = 0;
mysql_fetch_row(string);
strins(string, "|", strlen(string));
new oldx=0;
new count=0;
for(new x=0; x<strlen(string); x++)
{
if(string[x]=='|')
{
count++;
new tmpstring[sizeof(string)]; tmpstring=string;
strdel(tmpstring, x, strlen(tmpstring));
strdel(tmpstring, 0, oldx+1);
switch(count)
{
case 2: GZ[i][owner] = strval(tmpstring);
case 3: GZ[i][max_x] = floatstr(tmpstring);
case 4: GZ[i][max_y] = floatstr(tmpstring);
case 5: GZ[i][min_x] = floatstr(tmpstring);
case 6: GZ[i][min_y] = floatstr(tmpstring);
case 7: GZ[i][flagge_x] = floatstr(tmpstring);
case 8: GZ[i][flagge_y] = floatstr(tmpstring);
case 9: GZ[i][flagge_z] = floatstr(tmpstring);
case 10: GZ[i][erstellt] = strval(tmpstring);
}
oldx=x;
}
}
GZ[i][zid] = i;
if(GZ[i][erstellt] != 1)return 1;
format(str,64,"%d |Besitzer: '%s'",i,FrakName(GZ[i][owner]));
M_CreateZone(GZ[i][min_x],GZ[i][min_y],GZ[i][max_x],GZ[i][max_y],FrakColor(GZ[i][owner]),str,FrakColor(GZ[i][owner]));
GZ[i][pickup] = CreatePickup(1314,1,GZ[i][flagge_x],GZ[i][flagge_y],GZ[i][flagge_z],0);
GZ[i][label] = Create3DTextLabel("Tippe '/angriff', um das Gebiet anzugreifen.\nTippe '/flagge', um die Flagge zu erobern.",Rot,GZ[i][flagge_x],GZ[i][flagge_y],GZ[i][flagge_z],20,0);
counter ++;
return printf(" '%d' Gangzone(n) wurde(n) erfolgreich erstellt und geladen.",counter);
}

Und könntest du mir erklären wie ich dies auch in sscanf umschreiben könnte?

Jeffry dafür musst du dich doch nicht entschuldigen, immer hin nerv ich dich ganze Zeit mit meinen Problem und Fragen.

Also, führe jetzt den ganzen Vorgang aus, Starte den Server -> Joine auf meinen Server -> Einloggen mit RCON -> Gangzone erstellen mit /creategangzone -> 2 Punkt erstellen /creategangzone2 -> Flagge erstellen /cflagge -> Server neustarten -> Server wieder starten und gucken ob es geladen wird. -> Datenbank hat alles gespeichert.

MySQL_Log

[21:51:48]
[21:51:48] ---------------------------
[21:51:48] MySQL Debugging activated (10/06/14)
[21:51:48] ---------------------------
[21:51:48]
[21:58:31] >> mysql_real_escape_string( Connection handle: 1 )
[21:58:31] CMySQLHandler::EscapeString(TaigX); - Escaped 5 characters to TaigX.
[21:58:31] >> mysql_query( Connection handle: 1 )
[21:58:31] CMySQLHandler::Query(SELECT * FROM `accounts` WHERE `Spielername` = 'TaigX') - Successfully executed.
[21:58:31] >> mysql_store_result( Connection handle: 1 )
[21:58:31] CMySQLHandler::StoreResult() - Result was stored.
[21:58:31] >> mysql_num_rows( Connection handle: 1 )
[21:58:31] CMySQLHandler::NumRows() - Returned 1 row(s)
[21:58:31] >> mysql_free_result( Connection handle: 1 )
[21:58:31] CMySQLHandler::FreeResult() - Result was successfully free'd.
[21:58:37] >> mysql_real_escape_string( Connection handle: 1 )
[21:58:37] CMySQLHandler::EscapeString(TaigX); - Escaped 5 characters to TaigX.
[21:58:37] >> mysql_query( Connection handle: 1 )
[21:58:37] CMySQLHandler::Query(SELECT `Passwort` FROM `accounts` WHERE `Spielername` = 'TaigX') - Successfully executed.
[21:58:37] >> mysql_store_result( Connection handle: 1 )
[21:58:37] CMySQLHandler::StoreResult() - Result was stored.
[21:58:37] >> mysql_fetch_row_format( Connection handle: 1 )
[21:58:37] CMySQLHandler::FetchRow() - Return: 73eef00cc792ddc37ed99c801678057f
[21:58:37] >> mysql_free_result( Connection handle: 1 )
[21:58:37] CMySQLHandler::FreeResult() - Result was successfully free'd.
[21:58:37] >> mysql_real_escape_string( Connection handle: 1 )
[21:58:37] CMySQLHandler::EscapeString(acounts); - Escaped 7 characters to acounts.
[21:58:37] >> mysql_real_escape_string( Connection handle: 1 )
[21:58:37] CMySQLHandler::EscapeString(Adresse); - Escaped 7 characters to Adresse.
[21:58:37] >> mysql_real_escape_string( Connection handle: 1 )
[21:58:37] CMySQLHandler::EscapeString(Spielername); - Escaped 11 characters to Spielername.
[21:58:37] >> mysql_real_escape_string( Connection handle: 1 )
[21:58:37] CMySQLHandler::EscapeString(TaigX); - Escaped 5 characters to TaigX.
[21:58:37] >> mysql_query( Connection handle: 1 )
[21:58:37] CMySQLHandler::Query(SELECT `Adresse` FROM `acounts` WHERE `Spielername` = 'TaigX') - An error has occured. (Error ID: 1146, Table 'samp.acounts' doesn't exist)
[21:58:37] >> mysql_store_result( Connection handle: 1 )
[21:58:37] CMySQLHandler::StoreResult() - No data to store.
[21:58:37] >> mysql_fetch_row_format( Connection handle: 1 )
[21:58:37] CMySQLHandler::FetchRow() - You cannot call this function now. (Reason: Empty Result)
[21:58:37] >> mysql_free_result( Connection handle: 1 )
[21:58:37] CMySQLHandler::FreeResult() - The result is already empty.
[21:58:37] >> mysql_real_escape_string( Connection handle: 1 )
[21:58:37] CMySQLHandler::EscapeString(accounts); - Escaped 8 characters to accounts.
[21:58:37] >> mysql_real_escape_string( Connection handle: 1 )
[21:58:37] CMySQLHandler::EscapeString(Adminlevel); - Escaped 10 characters to Adminlevel.
[21:58:37] >> mysql_real_escape_string( Connection handle: 1 )
[21:58:37] CMySQLHandler::EscapeString(Spielername); - Escaped 11 characters to Spielername.
[21:58:37] >> mysql_real_escape_string( Connection handle: 1 )
[21:58:37] CMySQLHandler::EscapeString(TaigX); - Escaped 5 characters to TaigX.
[21:58:37] >> mysql_query( Connection handle: 1 )
[21:58:37] CMySQLHandler::Query(SELECT `Adminlevel` FROM `accounts` WHERE `Spielername` = 'TaigX') - Successfully executed.
[21:58:37] >> mysql_store_result( Connection handle: 1 )
[21:58:37] CMySQLHandler::StoreResult() - Result was stored.
[21:58:37] >> mysql_fetch_int( Connection handle: 1 )
[21:58:37] CMySQLHandler::FetchRow() - Return: 1
[21:58:37] >> mysql_free_result( Connection handle: 1 )
[21:58:37] CMySQLHandler::FreeResult() - Result was successfully free'd.
[21:58:37] OnQueryError() - Called.
[21:59:13] >> mysql_query( Connection handle: 1 )
[21:59:14] CMySQLHandler::Query(INSERT INTO gangwar (id,owner,maxX,maxY,minX,minY,flaggeX,flaggeY,flaggeZ,erstellt) VALUES (0,'','2039.141113','1333.661987','2023.301147','1344.497436','2037.271728','1335.288940','10.820312','') ON DUPLICATE KEY UPDATE `owner`='',`maxX`=2039.141113,`maxY`=1333.661987,`minX`=2023.301147,`minY`=1344.497436,`flaggeX`=2037.271728,`flaggeY`=1335.288940,`flaggeZ`=10.820312,`erstellt`='';) - Successfully executed.
[21:59:15] >> mysql_query( Connection handle: 1 )
[21:59:15] CMySQLHandler::Query(UPDATE accounts SET Adresse='255.255.255.255',Adminlevel=1 WHERE Spielername='TaigX') - Successfully executed.
[21:59:25]
[21:59:25] ---------------------------
[21:59:25] MySQL Debugging activated (10/06/14)
[21:59:25] ---------------------------
[21:59:25]

Compiler: Wie du siehst keine Meldung

Pawn compiler 3.2.3664 Copyright (c) 1997-2006, ITB CompuPhase

Server_log:

----------
Loaded log file: "server_log.txt".
----------
SA-MP Dedicated Server
----------------------
v0.3z, (C)2005-2014 SA-MP Team
[10:59:00]
[10:59:00] Server Plugins
[10:59:00] --------------
[10:59:00] Loading plugin: streamer
[10:59:00] Loaded.
[10:59:00] Loading plugin: sscanf
[10:59:00]
[10:59:00] ===============================
[10:59:00] sscanf plugin loaded.
[10:59:00] Version: 2.8.1
[10:59:00] (c) 2012 Alex "Y_Less" Cole
[10:59:00] ===============================
[10:59:00] Loaded.
[10:59:00] Loading plugin: mysql
[10:59:00]
> MySQL plugin R5 successfully loaded.
[10:59:00] Loaded.
[10:59:00] Loading plugin: crashdetect
[10:59:00] CrashDetect must be loaded before 'streamer.DLL'
[10:59:00] Failed.
[10:59:00] Loaded 3 plugins.
[10:59:00]
[10:59:00] Filterscripts
[10:59:00] ---------------
[10:59:00] Loading filterscript 'gangwar.amx'...
[10:59:00] OnFilterScriptInit aufgerufen
[10:59:00] test
[10:59:00] '0' Gangzone(n) wurde(n) erfolgreich erstellt und geladen.
[10:59:00] LoadGZ ausgeführt
[10:59:00] Loaded 1 filterscripts.
[10:59:00] [MySQL]: Die Verbindung zur Datenbank wurde erfolgreich hergestellt!
[10:59:00]
----------------------------------
[10:59:00] Blank Gamemode by your name here
[10:59:00] ----------------------------------
[10:59:00] Number of vehicle models: 0

MySQL_log:

[11:02:21] >> mysql_real_escape_string( Connection handle: 1 )
[11:02:21] CMySQLHandler::EscapeString(TaigX); - Escaped 5 characters to TaigX.
[11:02:21] >> mysql_query( Connection handle: 1 )
[11:02:21] CMySQLHandler::Query(SELECT * FROM `accounts` WHERE `Spielername` = 'TaigX') - Successfully executed.
[11:02:21] >> mysql_store_result( Connection handle: 1 )
[11:02:21] CMySQLHandler::StoreResult() - Result was stored.
[11:02:21] >> mysql_num_rows( Connection handle: 1 )
[11:02:21] CMySQLHandler::NumRows() - Returned 1 row(s)
[11:02:21] >> mysql_free_result( Connection handle: 1 )
[11:02:21] CMySQLHandler::FreeResult() - Result was successfully free'd.
[11:02:24] >> mysql_real_escape_string( Connection handle: 1 )
[11:02:24] CMySQLHandler::EscapeString(TaigX); - Escaped 5 characters to TaigX.
[11:02:24] >> mysql_query( Connection handle: 1 )
[11:02:24] CMySQLHandler::Query(SELECT `Passwort` FROM `accounts` WHERE `Spielername` = 'TaigX') - Successfully executed.
[11:02:24] >> mysql_store_result( Connection handle: 1 )
[11:02:24] CMySQLHandler::StoreResult() - Result was stored.
[11:02:24] >> mysql_fetch_row_format( Connection handle: 1 )
[11:02:24] CMySQLHandler::FetchRow() - Return: 73eef00cc792ddc37ed99c801678057f
[11:02:24] >> mysql_free_result( Connection handle: 1 )
[11:02:24] CMySQLHandler::FreeResult() - Result was successfully free'd.
[11:02:24] >> mysql_real_escape_string( Connection handle: 1 )
[11:02:24] CMySQLHandler::EscapeString(acounts); - Escaped 7 characters to acounts.
[11:02:24] >> mysql_real_escape_string( Connection handle: 1 )
[11:02:24] CMySQLHandler::EscapeString(Adresse); - Escaped 7 characters to Adresse.
[11:02:24] >> mysql_real_escape_string( Connection handle: 1 )
[11:02:24] CMySQLHandler::EscapeString(Spielername); - Escaped 11 characters to Spielername.
[11:02:24] >> mysql_real_escape_string( Connection handle: 1 )
[11:02:24] CMySQLHandler::EscapeString(TaigX); - Escaped 5 characters to TaigX.
[11:02:24] >> mysql_query( Connection handle: 1 )
[11:02:24] CMySQLHandler::Query(SELECT `Adresse` FROM `acounts` WHERE `Spielername` = 'TaigX') - An error has occured. (Error ID: 1146, Table 'samp.acounts' doesn't exist)
[11:02:24] >> mysql_store_result( Connection handle: 1 )
[11:02:24] CMySQLHandler::StoreResult() - No data to store.
[11:02:24] >> mysql_fetch_row_format( Connection handle: 1 )
[11:02:24] CMySQLHandler::FetchRow() - You cannot call this function now. (Reason: Empty Result)
[11:02:24] >> mysql_free_result( Connection handle: 1 )
[11:02:24] CMySQLHandler::FreeResult() - The result is already empty.
[11:02:24] >> mysql_real_escape_string( Connection handle: 1 )
[11:02:24] CMySQLHandler::EscapeString(accounts); - Escaped 8 characters to accounts.
[11:02:24] >> mysql_real_escape_string( Connection handle: 1 )
[11:02:24] CMySQLHandler::EscapeString(Adminlevel); - Escaped 10 characters to Adminlevel.
[11:02:24] >> mysql_real_escape_string( Connection handle: 1 )
[11:02:24] CMySQLHandler::EscapeString(Spielername); - Escaped 11 characters to Spielername.
[11:02:24] >> mysql_real_escape_string( Connection handle: 1 )
[11:02:24] CMySQLHandler::EscapeString(TaigX); - Escaped 5 characters to TaigX.
[11:02:24] >> mysql_query( Connection handle: 1 )
[11:02:24] CMySQLHandler::Query(SELECT `Adminlevel` FROM `accounts` WHERE `Spielername` = 'TaigX') - Successfully executed.
[11:02:24] >> mysql_store_result( Connection handle: 1 )
[11:02:24] CMySQLHandler::StoreResult() - Result was stored.
[11:02:24] >> mysql_fetch_int( Connection handle: 1 )
[11:02:24] CMySQLHandler::FetchRow() - Return: 1
[11:02:24] >> mysql_free_result( Connection handle: 1 )
[11:02:24] CMySQLHandler::FreeResult() - Result was successfully free'd.
[11:02:24] OnQueryError() - Called.
[11:02:28] >> mysql_query( Connection handle: 1 )
[11:02:28] CMySQLHandler::Query(UPDATE accounts SET Adresse='255.255.255.255',Adminlevel=1 WHERE Spielername='TaigX') - Successfully executed.

[22:40:41] >> mysql_real_escape_string( Connection handle: 1 )
[22:40:41] CMySQLHandler::EscapeString(TaigX); - Escaped 5 characters to TaigX.
[22:40:41] >> mysql_query( Connection handle: 1 )
[22:40:41] CMySQLHandler::Query(SELECT * FROM `accounts` WHERE `Spielername` = 'TaigX') - Successfully executed.
[22:40:41] >> mysql_store_result( Connection handle: 1 )
[22:40:41] CMySQLHandler::StoreResult() - Result was stored.
[22:40:41] >> mysql_num_rows( Connection handle: 1 )
[22:40:41] CMySQLHandler::NumRows() - Returned 1 row(s)
[22:40:41] >> mysql_free_result( Connection handle: 1 )
[22:40:41] CMySQLHandler::FreeResult() - Result was successfully free'd.
[22:40:45] >> mysql_real_escape_string( Connection handle: 1 )
[22:40:45] CMySQLHandler::EscapeString(TaigX); - Escaped 5 characters to TaigX.
[22:40:45] >> mysql_query( Connection handle: 1 )
[22:40:45] CMySQLHandler::Query(SELECT `Passwort` FROM `accounts` WHERE `Spielername` = 'TaigX') - Successfully executed.
[22:40:45] >> mysql_store_result( Connection handle: 1 )
[22:40:45] CMySQLHandler::StoreResult() - Result was stored.
[22:40:45] >> mysql_fetch_row_format( Connection handle: 1 )
[22:40:45] CMySQLHandler::FetchRow() - Return: 73eef00cc792ddc37ed99c801678057f
[22:40:45] >> mysql_free_result( Connection handle: 1 )
[22:40:45] CMySQLHandler::FreeResult() - Result was successfully free'd.
[22:40:45] >> mysql_real_escape_string( Connection handle: 1 )
[22:40:45] CMySQLHandler::EscapeString(acounts); - Escaped 7 characters to acounts.
[22:40:45] >> mysql_real_escape_string( Connection handle: 1 )
[22:40:45] CMySQLHandler::EscapeString(Adresse); - Escaped 7 characters to Adresse.
[22:40:45] >> mysql_real_escape_string( Connection handle: 1 )
[22:40:45] CMySQLHandler::EscapeString(Spielername); - Escaped 11 characters to Spielername.
[22:40:45] >> mysql_real_escape_string( Connection handle: 1 )
[22:40:45] CMySQLHandler::EscapeString(TaigX); - Escaped 5 characters to TaigX.
[22:40:45] >> mysql_query( Connection handle: 1 )
[22:40:45] CMySQLHandler::Query(SELECT `Adresse` FROM `acounts` WHERE `Spielername` = 'TaigX') - An error has occured. (Error ID: 1146, Table 'samp.acounts' doesn't exist)
[22:40:45] >> mysql_store_result( Connection handle: 1 )
[22:40:45] CMySQLHandler::StoreResult() - No data to store.
[22:40:45] >> mysql_fetch_row_format( Connection handle: 1 )
[22:40:45] CMySQLHandler::FetchRow() - You cannot call this function now. (Reason: Empty Result)
[22:40:45] >> mysql_free_result( Connection handle: 1 )
[22:40:45] CMySQLHandler::FreeResult() - The result is already empty.
[22:40:45] >> mysql_real_escape_string( Connection handle: 1 )
[22:40:45] CMySQLHandler::EscapeString(accounts); - Escaped 8 characters to accounts.
[22:40:45] >> mysql_real_escape_string( Connection handle: 1 )
[22:40:45] CMySQLHandler::EscapeString(Adminlevel); - Escaped 10 characters to Adminlevel.
[22:40:45] >> mysql_real_escape_string( Connection handle: 1 )
[22:40:45] CMySQLHandler::EscapeString(Spielername); - Escaped 11 characters to Spielername.
[22:40:45] >> mysql_real_escape_string( Connection handle: 1 )
[22:40:45] CMySQLHandler::EscapeString(TaigX); - Escaped 5 characters to TaigX.
[22:40:45] >> mysql_query( Connection handle: 1 )
[22:40:45] CMySQLHandler::Query(SELECT `Adminlevel` FROM `accounts` WHERE `Spielername` = 'TaigX') - Successfully executed.
[22:40:45] >> mysql_store_result( Connection handle: 1 )
[22:40:45] CMySQLHandler::StoreResult() - Result was stored.
[22:40:45] >> mysql_fetch_int( Connection handle: 1 )
[22:40:45] CMySQLHandler::FetchRow() - Return: 1
[22:40:45] >> mysql_free_result( Connection handle: 1 )
[22:40:45] CMySQLHandler::FreeResult() - Result was successfully free'd.
[22:40:45] OnQueryError() - Called.
[22:40:58] >> mysql_query( Connection handle: 1 )
[22:40:58] CMySQLHandler::Query(UPDATE accounts SET Adresse='255.255.255.255',Adminlevel=1 WHERE Spielername='TaigX') - Successfully executed.

Die beiden Prints werden nun geladen, aber die Gangzonen nicht.

public OnFilterScriptInit()
{
M_Init();
GFPunkte_o = TextDrawCreate(19, 326, "Punkte (Owner): ");
TextDrawFont(GFPunkte_o , 3);
TextDrawLetterSize(GFPunkte_o , 0.3, 2.1);
TextDrawColor(GFPunkte_o , Blau);
TextDrawSetOutline(GFPunkte_o , 0);
TextDrawSetProportional(GFPunkte_o , 1);
TextDrawSetShadow(GFPunkte_o , 1);
GFPunkte_a = TextDrawCreate(19, 346, "Punkte (angreifer): ");
TextDrawFont(GFPunkte_a , 3);
TextDrawLetterSize(GFPunkte_a , 0.3, 2.1);
TextDrawColor(GFPunkte_a , Rot);
TextDrawSetOutline(GFPunkte_a , 0);
TextDrawSetProportional(GFPunkte_a , 1);
TextDrawSetShadow(GFPunkte_a , 1);
GFZeit = TextDrawCreate(19, 306, "Zeit: ");
TextDrawFont(GFZeit , 3);
TextDrawLetterSize(GFZeit , 0.3, 2.1);
TextDrawColor(GFZeit , HGruen);
TextDrawSetOutline(GFZeit , 0);
TextDrawSetProportional(GFZeit , 1);
TextDrawSetShadow(GFZeit , 1);
SaveGZ();
LoadGZ();
for(new i = 0; i<MAX_FRAKTIONEN; i++)ImGF[i] = 0;
return LoadGZ();
}

Die Funktion, wird leider nicht aufgerufen.

Hatte mich verschrieben, es steht unter OnFilterScriptInit könnte ich das nicht dann mit LoadGZ_ tauschen und dann denn stock LoadGZ löschen oder würde dies nicht klappen?

Es wird tatsächlich nur unter OnFilterScriptExit aufgerufen.

LoadGZ();
for(new i = 0; i<MAX_FRAKTIONEN; i++)ImGF[i] = 0;
return LoadGZ();

stock LoadGZ()
{
new string[500], str[64];
mysql_query("SELECT * FROM gangwar");
mysql_store_result();
new i = -1, counter = 0;
while(mysql_fetch_row(string))
{
i++;
strins(string, "|", strlen(string));
new oldx=0;
new count=0;
for(new x=0; x<strlen(string); x++)
{
if(string[x]=='|')
{
count++;
new tmpstring[sizeof(string)]; tmpstring=string;
strdel(tmpstring, x, strlen(tmpstring));
strdel(tmpstring, 0, oldx+1);
switch(count)
{
case 2: GZ[i][owner] = strval(tmpstring);
case 3: GZ[i][max_x] = floatstr(tmpstring);
case 4: GZ[i][max_y] = floatstr(tmpstring);
case 5: GZ[i][min_x] = floatstr(tmpstring);
case 6: GZ[i][min_y] = floatstr(tmpstring);
case 7: GZ[i][flagge_x] = floatstr(tmpstring);
case 8: GZ[i][flagge_y] = floatstr(tmpstring);
case 9: GZ[i][flagge_z] = floatstr(tmpstring);
case 10: GZ[i][erstellt] = strval(tmpstring);
}
oldx=x;
}
}
GZ[i][zid] = i;
if(GZ[i][erstellt] != 1)continue;
format(str,64,"%d |Besitzer: '%s'",i,FrakName(GZ[i][owner]));
M_CreateZone(GZ[i][min_x],GZ[i][min_y],GZ[i][max_x],GZ[i][max_y],FrakColor(GZ[i][owner]),str,FrakColor(GZ[i][owner]));
GZ[i][pickup] = CreatePickup(1314,1,GZ[i][flagge_x],GZ[i][flagge_y],GZ[i][flagge_z],0);
GZ[i][label] = Create3DTextLabel("Tippe '/angriff', um das Gebiet anzugreifen.\nTippe '/flagge', um die Flagge zu erobern.",Rot,GZ[i][flagge_x],GZ[i][flagge_y],GZ[i][flagge_z],20,0);
counter ++;
}
return printf(" '%d' Gangzone(n) wurde(n) erfolgreich erstellt und geladen.",counter);
}
stock LoadGZ_(i)
{
new string[500], str[64];
mysql_query("SELECT * FROM gangwar");
mysql_store_result();
new counter = 0;
mysql_fetch_row(string);
strins(string, "|", strlen(string));
new oldx=0;
new count=0;
for(new x=0; x<strlen(string); x++)
{
if(string[x]=='|')
{
count++;
new tmpstring[sizeof(string)]; tmpstring=string;
strdel(tmpstring, x, strlen(tmpstring));
strdel(tmpstring, 0, oldx+1);
switch(count)
{
case 2: GZ[i][owner] = strval(tmpstring);
case 3: GZ[i][max_x] = floatstr(tmpstring);
case 4: GZ[i][max_y] = floatstr(tmpstring);
case 5: GZ[i][min_x] = floatstr(tmpstring);
case 6: GZ[i][min_y] = floatstr(tmpstring);
case 7: GZ[i][flagge_x] = floatstr(tmpstring);
case 8: GZ[i][flagge_y] = floatstr(tmpstring);
case 9: GZ[i][flagge_z] = floatstr(tmpstring);
case 10: GZ[i][erstellt] = strval(tmpstring);
}
oldx=x;
}
}
GZ[i][zid] = i;
if(GZ[i][erstellt] != 1)return 1;
format(str,64,"%d |Besitzer: '%s'",i,FrakName(GZ[i][owner]));
M_CreateZone(GZ[i][min_x],GZ[i][min_y],GZ[i][max_x],GZ[i][max_y],FrakColor(GZ[i][owner]),str,FrakColor(GZ[i][owner]));
GZ[i][pickup] = CreatePickup(1314,1,GZ[i][flagge_x],GZ[i][flagge_y],GZ[i][flagge_z],0);
GZ[i][label] = Create3DTextLabel("Tippe '/angriff', um das Gebiet anzugreifen.\nTippe '/flagge', um die Flagge zu erobern.",Rot,GZ[i][flagge_x],GZ[i][flagge_y],GZ[i][flagge_z],20,0);
counter ++;
return printf(" '%d' Gangzone(n) wurde(n) erfolgreich erstellt und geladen.",counter);
}
stock SaveGZ()
{
for(new i,string[500]; i<MAX_GZ; i++)
{
if(GZ[i][max_x] == 0.0 && GZ[i][min_x] == 0.0) continue;
format(string,sizeof(string),"INSERT INTO gangwar (id,owner,maxX,maxY,minX,minY,flaggeX,flaggeY,flaggeZ,erstellt) VALUES (%d,'%s','%f','%f','%f','%f','%f','%f','%f','%s')",
i,GZ[i][owner],GZ[i][max_x],GZ[i][max_y],GZ[i][min_x],GZ[i][min_y],GZ[i][flagge_x],GZ[i][flagge_y],GZ[i][flagge_z],GZ[i][erstellt]);
format(string,sizeof(string),"%s ON DUPLICATE KEY UPDATE `owner`='%s',`maxX`=%f,`maxY`=%f,`minX`=%f,`minY`=%f,`flaggeX`=%f,`flaggeY`=%f,`flaggeZ`=%f,`erstellt`='%s';",
string, GZ[i][owner],GZ[i][max_x],GZ[i][max_y],GZ[i][min_x],GZ[i][min_y],GZ[i][flagge_x],GZ[i][flagge_y],GZ[i][flagge_z],GZ[i][erstellt]);
mysql_query(string);
}
return 1;
}
stock SaveGZ_(zoneid)
{
new string[500];
format(string,sizeof(string),"INSERT INTO gangwar (id,owner,maxX,maxY,minX,minY,flaggeX,flaggeY,flaggeZ,erstellt) VALUES (%d,'%s','%f','%f','%f','%f','%f','%f','%f','%s')",
zoneid,GZ[zoneid][owner],GZ[zoneid][max_x],GZ[zoneid][max_y],GZ[zoneid][min_x],GZ[zoneid][min_y],GZ[zoneid][flagge_x],GZ[zoneid][flagge_y],GZ[zoneid][flagge_z],GZ[zoneid][erstellt]);
mysql_query(string);
return 1;
}

[21:06:24] >> mysql_real_escape_string( Connection handle: 1 )
[21:06:24] CMySQLHandler::EscapeString(TaigX); - Escaped 5 characters to TaigX.
[21:06:24] >> mysql_query( Connection handle: 1 )
[21:06:24] CMySQLHandler::Query(SELECT * FROM `accounts` WHERE `Spielername` = 'TaigX') - Successfully executed.
[21:06:24] >> mysql_store_result( Connection handle: 1 )
[21:06:24] CMySQLHandler::StoreResult() - Result was stored.
[21:06:24] >> mysql_num_rows( Connection handle: 1 )
[21:06:24] CMySQLHandler::NumRows() - Returned 1 row(s)
[21:06:24] >> mysql_free_result( Connection handle: 1 )
[21:06:24] CMySQLHandler::FreeResult() - Result was successfully free'd.
[21:06:27] >> mysql_real_escape_string( Connection handle: 1 )
[21:06:27] CMySQLHandler::EscapeString(TaigX); - Escaped 5 characters to TaigX.
[21:06:27] >> mysql_query( Connection handle: 1 )
[21:06:27] CMySQLHandler::Query(SELECT `Passwort` FROM `accounts` WHERE `Spielername` = 'TaigX') - Successfully executed.
[21:06:27] >> mysql_store_result( Connection handle: 1 )
[21:06:27] CMySQLHandler::StoreResult() - Result was stored.
[21:06:27] >> mysql_fetch_row_format( Connection handle: 1 )
[21:06:27] CMySQLHandler::FetchRow() - Return: 73eef00cc792ddc37ed99c801678057f
[21:06:27] >> mysql_free_result( Connection handle: 1 )
[21:06:27] CMySQLHandler::FreeResult() - Result was successfully free'd.
[21:06:27] >> mysql_real_escape_string( Connection handle: 1 )
[21:06:27] CMySQLHandler::EscapeString(acounts); - Escaped 7 characters to acounts.
[21:06:27] >> mysql_real_escape_string( Connection handle: 1 )
[21:06:27] CMySQLHandler::EscapeString(Adresse); - Escaped 7 characters to Adresse.
[21:06:27] >> mysql_real_escape_string( Connection handle: 1 )
[21:06:27] CMySQLHandler::EscapeString(Spielername); - Escaped 11 characters to Spielername.
[21:06:27] >> mysql_real_escape_string( Connection handle: 1 )
[21:06:27] CMySQLHandler::EscapeString(TaigX); - Escaped 5 characters to TaigX.
[21:06:27] >> mysql_query( Connection handle: 1 )
[21:06:27] CMySQLHandler::Query(SELECT `Adresse` FROM `acounts` WHERE `Spielername` = 'TaigX') - An error has occured. (Error ID: 1146, Table 'samp.acounts' doesn't exist)
[21:06:27] >> mysql_store_result( Connection handle: 1 )
[21:06:27] CMySQLHandler::StoreResult() - No data to store.
[21:06:27] >> mysql_fetch_row_format( Connection handle: 1 )
[21:06:27] CMySQLHandler::FetchRow() - You cannot call this function now. (Reason: Empty Result)
[21:06:27] >> mysql_free_result( Connection handle: 1 )
[21:06:27] CMySQLHandler::FreeResult() - The result is already empty.
[21:06:27] >> mysql_real_escape_string( Connection handle: 1 )
[21:06:27] CMySQLHandler::EscapeString(accounts); - Escaped 8 characters to accounts.
[21:06:27] >> mysql_real_escape_string( Connection handle: 1 )
[21:06:27] CMySQLHandler::EscapeString(Adminlevel); - Escaped 10 characters to Adminlevel.
[21:06:27] >> mysql_real_escape_string( Connection handle: 1 )
[21:06:27] CMySQLHandler::EscapeString(Spielername); - Escaped 11 characters to Spielername.
[21:06:27] >> mysql_real_escape_string( Connection handle: 1 )
[21:06:27] CMySQLHandler::EscapeString(TaigX); - Escaped 5 characters to TaigX.
[21:06:27] >> mysql_query( Connection handle: 1 )
[21:06:27] CMySQLHandler::Query(SELECT `Adminlevel` FROM `accounts` WHERE `Spielername` = 'TaigX') - Successfully executed.
[21:06:27] >> mysql_store_result( Connection handle: 1 )
[21:06:27] CMySQLHandler::StoreResult() - Result was stored.
[21:06:27] >> mysql_fetch_int( Connection handle: 1 )
[21:06:27] CMySQLHandler::FetchRow() - Return: 1
[21:06:27] >> mysql_free_result( Connection handle: 1 )
[21:06:27] CMySQLHandler::FreeResult() - Result was successfully free'd.
[21:06:27] OnQueryError() - Called.
[21:13:13] >> mysql_query( Connection handle: 1 )
[21:13:13] CMySQLHandler::Query(UPDATE accounts SET Adresse='255.255.255.255',Adminlevel=1 WHERE Spielername='TaigX') - Successfully executed.

Es klappt leider immer noch nicht, trozdem Danke furs ganzen Tag helfen

Bekomme einen Error:

C:\Users\Eddy\Desktop\Projekt\Programm\gamemodes\gangwar.pwn(504) : error 024: "break" or "continue" is out of context
Pawn compiler 3.2.3664 Copyright (c) 1997-2006, ITB CompuPhase

1 Error.

Hab das nun so, aber es geht leider immer noch nicht oder muss ich hinter id = %d noch minx = %f usw.?

stock LoadGZ_(zoneid)
{
new string[500],str[64];
GZ[zoneid][zid] = zoneid;
format(string, sizeof(string), "SELECT * FROM gangwar WHERE id = %d", zoneid);
mysql_query(string);
mysql_store_result();
format(str,64,"%d |Besitzer: '%s'",zoneid,FrakName(GZ[zoneid][owner]));
M_CreateZone(GZ[zoneid][min_x],GZ[zoneid][min_y],GZ[zoneid][max_x],GZ[zoneid][max_y],FrakColor(GZ[zoneid][owner]),str,FrakColor(GZ[zoneid][owner]));
GZ[zoneid][pickup] = CreatePickup(1314,1,GZ[zoneid][flagge_x],GZ[zoneid][flagge_y],GZ[zoneid][flagge_z],0);
GZ[zoneid][label] = Create3DTextLabel("Tippe '/angriff', um das Gebiet anzugreifen.\nTippe '/flagge', um die Flagge zu erobern.",Rot,GZ[zoneid][flagge_x],GZ[zoneid][flagge_y],GZ[zoneid][flagge_z],20,0);
return 1;
}

Muss ich das bei LoadGZ_ genauso machen oder soll ich es einfach lassen, wenn ja dann funktioniert es leider immer noch nicht.

[19:57:43] >> mysql_store_result( Connection handle: 1 )
[19:57:43] CMySQLHandler::StoreResult() - No data to store.
[19:57:43] >> mysql_fetch_row_format( Connection handle: 1 )
[19:57:43] CMySQLHandler::FetchRow() - You cannot call this function now. (Reason: Empty Result)
[19:57:43] >> mysql_free_result( Connection handle: 1 )
[19:57:43] CMySQLHandler::FreeResult() - The result is already empty.
[19:57:43] >> mysql_real_escape_string( Connection handle: 1 )
[19:57:43] CMySQLHandler::EscapeString(accounts); - Escaped 8 characters to accounts.
[19:57:43] >> mysql_real_escape_string( Connection handle: 1 )
[19:57:43] CMySQLHandler::EscapeString(Adminlevel); - Escaped 10 characters to Adminlevel.
[19:57:43] >> mysql_real_escape_string( Connection handle: 1 )
[19:57:43] CMySQLHandler::EscapeString(Spielername); - Escaped 11 characters to Spielername.
[19:57:43] >> mysql_real_escape_string( Connection handle: 1 )
[19:57:43] CMySQLHandler::EscapeString(TaigX); - Escaped 5 characters to TaigX.
[19:57:43] >> mysql_query( Connection handle: 1 )
[19:57:43] CMySQLHandler::Query(SELECT `Adminlevel` FROM `accounts` WHERE `Spielername` = 'TaigX') - Successfully executed.
[19:57:43] >> mysql_store_result( Connection handle: 1 )
[19:57:43] CMySQLHandler::StoreResult() - Result was stored.
[19:57:43] >> mysql_fetch_int( Connection handle: 1 )
[19:57:43] CMySQLHandler::FetchRow() - Return: 1
[19:57:43] >> mysql_free_result( Connection handle: 1 )
[19:57:43] CMySQLHandler::FreeResult() - Result was successfully free'd.
[19:57:43] OnQueryError() - Called.

Hab das nun so gemacht, leider klappt das nicht.

stock LoadGZ()
{
new i = 0,string[500],str[64],counter = 0; for(; i<MAX_GZ; i++)
{
GZ[i][zid] = i;
format(string, sizeof(string), "SELECT * FROM gangwar");
mysql_query(string);
mysql_store_result();
format(str,64,"%d |Besitzer: '%s'",i,FrakName(GZ[i][owner]));
if(GZ[i][erstellt] != 1)continue;
M_CreateZone(GZ[i][min_x],GZ[i][min_y],GZ[i][max_x],GZ[i][max_y],FrakColor(GZ[i][owner]),str,FrakColor(GZ[i][owner]));
GZ[i][pickup] = CreatePickup(1314,1,GZ[i][flagge_x],GZ[i][flagge_y],GZ[i][flagge_z],0);
GZ[i][label] = Create3DTextLabel("Tippe '/angriff', um das Gebiet anzugreifen.\nTippe '/flagge', um die Flagge zu erobern.",Rot,GZ[i][flagge_x],GZ[i][flagge_y],GZ[i][flagge_z],20,0);
counter ++;
break;
}
return printf(" '%d' Gangzone(n) wurde(n) erfolgreich erstellt und geladen.",counter);
}
stock LoadGZ_(zoneid)
{
new string[500],str[64];
GZ[zoneid][zid] = zoneid;
format(string, sizeof(string), "SELECT * FROM gangwar");
mysql_query(string);
mysql_store_result();
format(str,64,"%d |Besitzer: '%s'",zoneid,FrakName(GZ[zoneid][owner]));
M_CreateZone(GZ[zoneid][min_x],GZ[zoneid][min_y],GZ[zoneid][max_x],GZ[zoneid][max_y],FrakColor(GZ[zoneid][owner]),str,FrakColor(GZ[zoneid][owner]));
GZ[zoneid][pickup] = CreatePickup(1314,1,GZ[zoneid][flagge_x],GZ[zoneid][flagge_y],GZ[zoneid][flagge_z],0);
GZ[zoneid][label] = Create3DTextLabel("Tippe '/angriff', um das Gebiet anzugreifen.\nTippe '/flagge', um die Flagge zu erobern.",Rot,GZ[zoneid][flagge_x],GZ[zoneid][flagge_y],GZ[zoneid][flagge_z],20,0);
return 1;
}

[19:29:56] >> mysql_store_result( Connection handle: 1 )
[19:29:56] CMySQLHandler::StoreResult() - No data to store.
[19:29:56] >> mysql_fetch_row_format( Connection handle: 1 )
[19:29:56] CMySQLHandler::FetchRow() - You cannot call this function now. (Reason: Empty Result)
[19:29:56] >> mysql_free_result( Connection handle: 1 )
[19:29:56] CMySQLHandler::FreeResult() - The result is already empty.
[19:29:56] >> mysql_real_escape_string( Connection handle: 1 )
[19:29:56] CMySQLHandler::EscapeString(accounts); - Escaped 8 characters to accounts.
[19:29:56] >> mysql_real_escape_string( Connection handle: 1 )
[19:29:56] CMySQLHandler::EscapeString(Adminlevel); - Escaped 10 characters to Adminlevel.
[19:29:56] >> mysql_real_escape_string( Connection handle: 1 )
[19:29:56] CMySQLHandler::EscapeString(Spielername); - Escaped 11 characters to Spielername.
[19:29:56] >> mysql_real_escape_string( Connection handle: 1 )
[19:29:56] CMySQLHandler::EscapeString(TaigX); - Escaped 5 characters to TaigX.
[19:29:56] >> mysql_query( Connection handle: 1 )
[19:29:56] CMySQLHandler::Query(SELECT `Adminlevel` FROM `accounts` WHERE `Spielername` = 'TaigX') - Successfully executed.
[19:29:56] >> mysql_store_result( Connection handle: 1 )
[19:29:56] CMySQLHandler::StoreResult() - Result was stored.
[19:29:56] >> mysql_fetch_int( Connection handle: 1 )
[19:29:56] CMySQLHandler::FetchRow() - Return: 1
[19:29:56] >> mysql_free_result( Connection handle: 1 )
[19:29:56] CMySQLHandler::FreeResult() - Result was successfully free'd.
[19:29:56] OnQueryError() - Called.

Jetzt klappt das speichern perfekt, aber wie ich es schon kommen sehen habe funktioniert das laden nicht Aber trozdem bedanke ich mich schonmal bei dir!

stock LoadGZ()
{
new i = 0,string[500],str[64],counter = 0; for(; i<MAX_GZ; i++)
{
GZ[i][zid] = i;
format(string,sizeof(string),"UPDATE gangwar SET owner='%s',maxX='%f',maxY='%f',minX='%f',minY='%f',flaggeX='%f',flaggeY='%f',flaggeZ='%f',erstellt='%s' WHERE id='%d'",
GZ[i][owner],GZ[i][max_x],GZ[i][max_y],GZ[i][min_x],GZ[i][min_y],GZ[i][flagge_x],GZ[i][flagge_y],GZ[i][flagge_z],GZ[i][erstellt],i);
mysql_query(string);
format(str,64,"%d |Besitzer: '%s'",i,FrakName(GZ[i][owner]));
if(GZ[i][erstellt] != 1)continue;
M_CreateZone(GZ[i][min_x],GZ[i][min_y],GZ[i][max_x],GZ[i][max_y],FrakColor(GZ[i][owner]),str,FrakColor(GZ[i][owner]));
GZ[i][pickup] = CreatePickup(1314,1,GZ[i][flagge_x],GZ[i][flagge_y],GZ[i][flagge_z],0);
GZ[i][label] = Create3DTextLabel("Tippe '/angriff', um das Gebiet anzugreifen.\nTippe '/flagge', um die Flagge zu erobern.",Rot,GZ[i][flagge_x],GZ[i][flagge_y],GZ[i][flagge_z],20,0);
counter ++;
break;
}
return printf(" '%d' Gangzone(n) wurde(n) erfolgreich erstellt und geladen.",counter);
}
stock LoadGZ_(zoneid)
{
new string[500],str[64];
GZ[zoneid][zid] = zoneid;
format(string,sizeof(string),"UPDATE gangwar SET owner='%s',maxX='%f',maxY='%f',minX='%f',minY='%f',flaggeX='%f',flaggeY='%f',flaggeZ='%f',erstellt='%s' WHERE id='%d'",
GZ[zoneid][owner],GZ[zoneid][max_x],GZ[zoneid][max_y],GZ[zoneid][min_x],GZ[zoneid][min_y],GZ[zoneid][flagge_x],GZ[zoneid][flagge_y],GZ[zoneid][flagge_z],GZ[zoneid][erstellt],zoneid);
mysql_query(string);
format(str,64,"%d |Besitzer: '%s'",zoneid,FrakName(GZ[zoneid][owner]));
M_CreateZone(GZ[zoneid][min_x],GZ[zoneid][min_y],GZ[zoneid][max_x],GZ[zoneid][max_y],FrakColor(GZ[zoneid][owner]),str,FrakColor(GZ[zoneid][owner]));
GZ[zoneid][pickup] = CreatePickup(1314,1,GZ[zoneid][flagge_x],GZ[zoneid][flagge_y],GZ[zoneid][flagge_z],0);
GZ[zoneid][label] = Create3DTextLabel("Tippe '/angriff', um das Gebiet anzugreifen.\nTippe '/flagge', um die Flagge zu erobern.",Rot,GZ[zoneid][flagge_x],GZ[zoneid][flagge_y],GZ[zoneid][flagge_z],20,0);
return 1;
}

Ich erklär es mal ausführlicher, also wenn ich Ingame mit dem Befehl /creategangzone eine Zone erstelle soll er dies Speichern. Das tut es auch nur das problem ist das er nicht eine Zeile erstellt sondern gleich 30 stück.

Es befinden sich auch Daten in gangwar in der ersten Zeile wird nur maxx und y, minx und y gespeichert dann kommen 29 Zeilen ohne Inhalt und am ende ist dann das resultat mit den ganzen daten.

[14:26:26] >> mysql_real_escape_string( Connection handle: 1 )
[14:26:26] CMySQLHandler::EscapeString(TaigX); - Escaped 5 characters to TaigX.
[14:26:26] >> mysql_query( Connection handle: 1 )
[14:26:26] CMySQLHandler::Query(SELECT * FROM `accounts` WHERE `Spielername` = 'TaigX') - Successfully executed.
[14:26:26] >> mysql_store_result( Connection handle: 1 )
[14:26:26] CMySQLHandler::StoreResult() - Result was stored.
[14:26:26] >> mysql_num_rows( Connection handle: 1 )
[14:26:26] CMySQLHandler::NumRows() - Returned 1 row(s)
[14:26:26] >> mysql_free_result( Connection handle: 1 )
[14:26:26] CMySQLHandler::FreeResult() - Result was successfully free'd.
[14:26:29] >> mysql_real_escape_string( Connection handle: 1 )
[14:26:29] CMySQLHandler::EscapeString(TaigX); - Escaped 5 characters to TaigX.
[14:26:29] >> mysql_query( Connection handle: 1 )
[14:26:29] CMySQLHandler::Query(SELECT `Passwort` FROM `accounts` WHERE `Spielername` = 'TaigX') - Successfully executed.
[14:26:29] >> mysql_store_result( Connection handle: 1 )
[14:26:29] CMySQLHandler::StoreResult() - Result was stored.
[14:26:29] >> mysql_fetch_row_format( Connection handle: 1 )
[14:26:29] CMySQLHandler::FetchRow() - Return: 73eef00cc792ddc37ed99c801678057f
[14:26:29] >> mysql_free_result( Connection handle: 1 )
[14:26:29] CMySQLHandler::FreeResult() - Result was successfully free'd.
[14:26:29] >> mysql_real_escape_string( Connection handle: 1 )
[14:26:29] CMySQLHandler::EscapeString(acounts); - Escaped 7 characters to acounts.
[14:26:29] >> mysql_real_escape_string( Connection handle: 1 )
[14:26:29] CMySQLHandler::EscapeString(Adresse); - Escaped 7 characters to Adresse.
[14:26:29] >> mysql_real_escape_string( Connection handle: 1 )
[14:26:29] CMySQLHandler::EscapeString(Spielername); - Escaped 11 characters to Spielername.
[14:26:29] >> mysql_real_escape_string( Connection handle: 1 )
[14:26:29] CMySQLHandler::EscapeString(TaigX); - Escaped 5 characters to TaigX.
[14:26:29] >> mysql_query( Connection handle: 1 )
[14:26:29] CMySQLHandler::Query(SELECT `Adresse` FROM `acounts` WHERE `Spielername` = 'TaigX') - An error has occured. (Error ID: 1146, Table 'samp.acounts' doesn't exist)
[14:26:29] >> mysql_store_result( Connection handle: 1 )
[14:26:29] CMySQLHandler::StoreResult() - No data to store.
[14:26:29] >> mysql_fetch_row_format( Connection handle: 1 )
[14:26:29] CMySQLHandler::FetchRow() - You cannot call this function now. (Reason: Empty Result)
[14:26:29] >> mysql_free_result( Connection handle: 1 )
[14:26:29] CMySQLHandler::FreeResult() - The result is already empty.
[14:26:29] >> mysql_real_escape_string( Connection handle: 1 )
[14:26:29] CMySQLHandler::EscapeString(accounts); - Escaped 8 characters to accounts.
[14:26:29] >> mysql_real_escape_string( Connection handle: 1 )
[14:26:29] CMySQLHandler::EscapeString(Adminlevel); - Escaped 10 characters to Adminlevel.
[14:26:29] >> mysql_real_escape_string( Connection handle: 1 )
[14:26:29] CMySQLHandler::EscapeString(Spielername); - Escaped 11 characters to Spielername.
[14:26:29] >> mysql_real_escape_string( Connection handle: 1 )
[14:26:29] CMySQLHandler::EscapeString(TaigX); - Escaped 5 characters to TaigX.
[14:26:29] >> mysql_query( Connection handle: 1 )
[14:26:29] CMySQLHandler::Query(SELECT `Adminlevel` FROM `accounts` WHERE `Spielername` = 'TaigX') - Successfully executed.
[14:26:29] >> mysql_store_result( Connection handle: 1 )
[14:26:29] CMySQLHandler::StoreResult() - Result was stored.
[14:26:29] >> mysql_fetch_int( Connection handle: 1 )
[14:26:29] CMySQLHandler::FetchRow() - Return: 1
[14:26:29] >> mysql_free_result( Connection handle: 1 )
[14:26:29] CMySQLHandler::FreeResult() - Result was successfully free'd.
[14:26:29] OnQueryError() - Called.
[14:26:58] >> mysql_query( Connection handle: 1 )
[14:26:58] CMySQLHandler::Query(INSERT INTO gangwar (id,owner,maxX,maxY,minX,minY,flaggeX,flaggeY,flaggeZ,erstellt) VALUES (0,'','2069.789550','1321.574584','2030.651977','1349.526123','2057.994384','1330.191040','10.897706','') ON DUPLICATE KEY UPDATE `owner`='',`maxX`=2069.789550,`maxY`=1321.574584,`minX`=2030.651977,`minY`=1349.526123,`flaggeX`=2057.994384,`flaggeY`=1330.191040,`flaggeZ`=10.897706,`erstellt`='';) - Successfully executed.
[14:26:58] >> mysql_query( Connection handle: 1 )
[14:26:58] CMySQLHandler::Query(INSERT INTO gangwar (id,owner,maxX,maxY,minX,minY,flaggeX,flaggeY,flaggeZ,erstellt) VALUES (1,'','0.000000','0.000000','0.000000','0.000000','0.000000','0.000000','0.000000','') ON DUPLICATE KEY UPDATE `owner`='',`maxX`=0.000000,`maxY`=0.000000,`minX`=0.000000,`minY`=0.000000,`flaggeX`=0.000000,`flaggeY`=0.000000,`flaggeZ`=0.000000,`erstellt`='';) - Successfully executed.
[14:26:58] >> mysql_query( Connection handle: 1 )
[14:26:58] CMySQLHandler::Query(INSERT INTO gangwar (id,owner,maxX,maxY,minX,minY,flaggeX,flaggeY,flaggeZ,erstellt) VALUES (2,'','0.000000','0.000000','0.000000','0.000000','0.000000','0.000000','0.000000','') ON DUPLICATE KEY UPDATE `owner`='',`maxX`=0.000000,`maxY`=0.000000,`minX`=0.000000,`minY`=0.000000,`flaggeX`=0.000000,`flaggeY`=0.000000,`flaggeZ`=0.000000,`erstellt`='';) - Successfully executed.
[14:26:58] >> mysql_query( Connection handle: 1 )
[14:26:58] CMySQLHandler::Query(INSERT INTO gangwar (id,owner,maxX,maxY,minX,minY,flaggeX,flaggeY,flaggeZ,erstellt) VALUES (3,'','0.000000','0.000000','0.000000','0.000000','0.000000','0.000000','0.000000','') ON DUPLICATE KEY UPDATE `owner`='',`maxX`=0.000000,`maxY`=0.000000,`minX`=0.000000,`minY`=0.000000,`flaggeX`=0.000000,`flaggeY`=0.000000,`flaggeZ`=0.000000,`erstellt`='';) - Successfully executed.
[14:26:58] >> mysql_query( Connection handle: 1 )
[14:26:58] CMySQLHandler::Query(INSERT INTO gangwar (id,owner,maxX,maxY,minX,minY,flaggeX,flaggeY,flaggeZ,erstellt) VALUES (4,'','0.000000','0.000000','0.000000','0.000000','0.000000','0.000000','0.000000','') ON DUPLICATE KEY UPDATE `owner`='',`maxX`=0.000000,`maxY`=0.000000,`minX`=0.000000,`minY`=0.000000,`flaggeX`=0.000000,`flaggeY`=0.000000,`flaggeZ`=0.000000,`erstellt`='';) - Successfully executed.
[14:26:58] >> mysql_query( Connection handle: 1 )
[14:26:58] CMySQLHandler::Query(INSERT INTO gangwar (id,owner,maxX,maxY,minX,minY,flaggeX,flaggeY,flaggeZ,erstellt) VALUES (5,'','0.000000','0.000000','0.000000','0.000000','0.000000','0.000000','0.000000','') ON DUPLICATE KEY UPDATE `owner`='',`maxX`=0.000000,`maxY`=0.000000,`minX`=0.000000,`minY`=0.000000,`flaggeX`=0.000000,`flaggeY`=0.000000,`flaggeZ`=0.000000,`erstellt`='';) - Successfully executed.
[14:26:58] >> mysql_query( Connection handle: 1 )
[14:26:58] CMySQLHandler::Query(INSERT INTO gangwar (id,owner,maxX,maxY,minX,minY,flaggeX,flaggeY,flaggeZ,erstellt) VALUES (6,'','0.000000','0.000000','0.000000','0.000000','0.000000','0.000000','0.000000','') ON DUPLICATE KEY UPDATE `owner`='',`maxX`=0.000000,`maxY`=0.000000,`minX`=0.000000,`minY`=0.000000,`flaggeX`=0.000000,`flaggeY`=0.000000,`flaggeZ`=0.000000,`erstellt`='';) - Successfully executed.
[14:26:58] >> mysql_query( Connection handle: 1 )
[14:26:58] CMySQLHandler::Query(INSERT INTO gangwar (id,owner,maxX,maxY,minX,minY,flaggeX,flaggeY,flaggeZ,erstellt) VALUES (7,'','0.000000','0.000000','0.000000','0.000000','0.000000','0.000000','0.000000','') ON DUPLICATE KEY UPDATE `owner`='',`maxX`=0.000000,`maxY`=0.000000,`minX`=0.000000,`minY`=0.000000,`flaggeX`=0.000000,`flaggeY`=0.000000,`flaggeZ`=0.000000,`erstellt`='';) - Successfully executed.
[14:26:58] >> mysql_query( Connection handle: 1 )
[14:26:58] CMySQLHandler::Query(INSERT INTO gangwar (id,owner,maxX,maxY,minX,minY,flaggeX,flaggeY,flaggeZ,erstellt) VALUES (8,'','0.000000','0.000000','0.000000','0.000000','0.000000','0.000000','0.000000','') ON DUPLICATE KEY UPDATE `owner`='',`maxX`=0.000000,`maxY`=0.000000,`minX`=0.000000,`minY`=0.000000,`flaggeX`=0.000000,`flaggeY`=0.000000,`flaggeZ`=0.000000,`erstellt`='';) - Successfully executed.
[14:26:58] >> mysql_query( Connection handle: 1 )
[14:26:58] CMySQLHandler::Query(INSERT INTO gangwar (id,owner,maxX,maxY,minX,minY,flaggeX,flaggeY,flaggeZ,erstellt) VALUES (9,'','0.000000','0.000000','0.000000','0.000000','0.000000','0.000000','0.000000','') ON DUPLICATE KEY UPDATE `owner`='',`maxX`=0.000000,`maxY`=0.000000,`minX`=0.000000,`minY`=0.000000,`flaggeX`=0.000000,`flaggeY`=0.000000,`flaggeZ`=0.000000,`erstellt`='';) - Successfully executed.
[14:26:58] >> mysql_query( Connection handle: 1 )
[14:26:58] CMySQLHandler::Query(INSERT INTO gangwar (id,owner,maxX,maxY,minX,minY,flaggeX,flaggeY,flaggeZ,erstellt) VALUES (10,'','0.000000','0.000000','0.000000','0.000000','0.000000','0.000000','0.000000','') ON DUPLICATE KEY UPDATE `owner`='',`maxX`=0.000000,`maxY`=0.000000,`minX`=0.000000,`minY`=0.000000,`flaggeX`=0.000000,`flaggeY`=0.000000,`flaggeZ`=0.000000,`erstellt`='';) - Successfully executed.
[14:26:58] >> mysql_query( Connection handle: 1 )
[14:26:58] CMySQLHandler::Query(INSERT INTO gangwar (id,owner,maxX,maxY,minX,minY,flaggeX,flaggeY,flaggeZ,erstellt) VALUES (11,'','0.000000','0.000000','0.000000','0.000000','0.000000','0.000000','0.000000','') ON DUPLICATE KEY UPDATE `owner`='',`maxX`=0.000000,`maxY`=0.000000,`minX`=0.000000,`minY`=0.000000,`flaggeX`=0.000000,`flaggeY`=0.000000,`flaggeZ`=0.000000,`erstellt`='';) - Successfully executed.
[14:26:58] >> mysql_query( Connection handle: 1 )
[14:26:58] CMySQLHandler::Query(INSERT INTO gangwar (id,owner,maxX,maxY,minX,minY,flaggeX,flaggeY,flaggeZ,erstellt) VALUES (12,'','0.000000','0.000000','0.000000','0.000000','0.000000','0.000000','0.000000','') ON DUPLICATE KEY UPDATE `owner`='',`maxX`=0.000000,`maxY`=0.000000,`minX`=0.000000,`minY`=0.000000,`flaggeX`=0.000000,`flaggeY`=0.000000,`flaggeZ`=0.000000,`erstellt`='';) - Successfully executed.
[14:26:58] >> mysql_query( Connection handle: 1 )
[14:26:58] CMySQLHandler::Query(INSERT INTO gangwar (id,owner,maxX,maxY,minX,minY,flaggeX,flaggeY,flaggeZ,erstellt) VALUES (13,'','0.000000','0.000000','0.000000','0.000000','0.000000','0.000000','0.000000','') ON DUPLICATE KEY UPDATE `owner`='',`maxX`=0.000000,`maxY`=0.000000,`minX`=0.000000,`minY`=0.000000,`flaggeX`=0.000000,`flaggeY`=0.000000,`flaggeZ`=0.000000,`erstellt`='';) - Successfully executed.
[14:26:58] >> mysql_query( Connection handle: 1 )
[14:26:58] CMySQLHandler::Query(INSERT INTO gangwar (id,owner,maxX,maxY,minX,minY,flaggeX,flaggeY,flaggeZ,erstellt) VALUES (14,'','0.000000','0.000000','0.000000','0.000000','0.000000','0.000000','0.000000','') ON DUPLICATE KEY UPDATE `owner`='',`maxX`=0.000000,`maxY`=0.000000,`minX`=0.000000,`minY`=0.000000,`flaggeX`=0.000000,`flaggeY`=0.000000,`flaggeZ`=0.000000,`erstellt`='';) - Successfully executed.
[14:26:58] >> mysql_query( Connection handle: 1 )
[14:26:58] CMySQLHandler::Query(INSERT INTO gangwar (id,owner,maxX,maxY,minX,minY,flaggeX,flaggeY,flaggeZ,erstellt) VALUES (15,'','0.000000','0.000000','0.000000','0.000000','0.000000','0.000000','0.000000','') ON DUPLICATE KEY UPDATE `owner`='',`maxX`=0.000000,`maxY`=0.000000,`minX`=0.000000,`minY`=0.000000,`flaggeX`=0.000000,`flaggeY`=0.000000,`flaggeZ`=0.000000,`erstellt`='';) - Successfully executed.
[14:26:58] >> mysql_query( Connection handle: 1 )
[14:26:58] CMySQLHandler::Query(INSERT INTO gangwar (id,owner,maxX,maxY,minX,minY,flaggeX,flaggeY,flaggeZ,erstellt) VALUES (16,'','0.000000','0.000000','0.000000','0.000000','0.000000','0.000000','0.000000','') ON DUPLICATE KEY UPDATE `owner`='',`maxX`=0.000000,`maxY`=0.000000,`minX`=0.000000,`minY`=0.000000,`flaggeX`=0.000000,`flaggeY`=0.000000,`flaggeZ`=0.000000,`erstellt`='';) - Successfully executed.
[14:26:58] >> mysql_query( Connection handle: 1 )
[14:26:58] CMySQLHandler::Query(INSERT INTO gangwar (id,owner,maxX,maxY,minX,minY,flaggeX,flaggeY,flaggeZ,erstellt) VALUES (17,'','0.000000','0.000000','0.000000','0.000000','0.000000','0.000000','0.000000','') ON DUPLICATE KEY UPDATE `owner`='',`maxX`=0.000000,`maxY`=0.000000,`minX`=0.000000,`minY`=0.000000,`flaggeX`=0.000000,`flaggeY`=0.000000,`flaggeZ`=0.000000,`erstellt`='';) - Successfully executed.
[14:26:58] >> mysql_query( Connection handle: 1 )
[14:26:58] CMySQLHandler::Query(INSERT INTO gangwar (id,owner,maxX,maxY,minX,minY,flaggeX,flaggeY,flaggeZ,erstellt) VALUES (18,'','0.000000','0.000000','0.000000','0.000000','0.000000','0.000000','0.000000','') ON DUPLICATE KEY UPDATE `owner`='',`maxX`=0.000000,`maxY`=0.000000,`minX`=0.000000,`minY`=0.000000,`flaggeX`=0.000000,`flaggeY`=0.000000,`flaggeZ`=0.000000,`erstellt`='';) - Successfully executed.
[14:26:58] >> mysql_query( Connection handle: 1 )
[14:26:58] CMySQLHandler::Query(INSERT INTO gangwar (id,owner,maxX,maxY,minX,minY,flaggeX,flaggeY,flaggeZ,erstellt) VALUES (19,'','0.000000','0.000000','0.000000','0.000000','0.000000','0.000000','0.000000','') ON DUPLICATE KEY UPDATE `owner`='',`maxX`=0.000000,`maxY`=0.000000,`minX`=0.000000,`minY`=0.000000,`flaggeX`=0.000000,`flaggeY`=0.000000,`flaggeZ`=0.000000,`erstellt`='';) - Successfully executed.
[14:26:58] >> mysql_query( Connection handle: 1 )
[14:26:58] CMySQLHandler::Query(INSERT INTO gangwar (id,owner,maxX,maxY,minX,minY,flaggeX,flaggeY,flaggeZ,erstellt) VALUES (20,'','0.000000','0.000000','0.000000','0.000000','0.000000','0.000000','0.000000','') ON DUPLICATE KEY UPDATE `owner`='',`maxX`=0.000000,`maxY`=0.000000,`minX`=0.000000,`minY`=0.000000,`flaggeX`=0.000000,`flaggeY`=0.000000,`flaggeZ`=0.000000,`erstellt`='';) - Successfully executed.
[14:26:58] >> mysql_query( Connection handle: 1 )
[14:26:58] CMySQLHandler::Query(INSERT INTO gangwar (id,owner,maxX,maxY,minX,minY,flaggeX,flaggeY,flaggeZ,erstellt) VALUES (21,'','0.000000','0.000000','0.000000','0.000000','0.000000','0.000000','0.000000','') ON DUPLICATE KEY UPDATE `owner`='',`maxX`=0.000000,`maxY`=0.000000,`minX`=0.000000,`minY`=0.000000,`flaggeX`=0.000000,`flaggeY`=0.000000,`flaggeZ`=0.000000,`erstellt`='';) - Successfully executed.
[14:26:58] >> mysql_query( Connection handle: 1 )
[14:26:58] CMySQLHandler::Query(INSERT INTO gangwar (id,owner,maxX,maxY,minX,minY,flaggeX,flaggeY,flaggeZ,erstellt) VALUES (22,'','0.000000','0.000000','0.000000','0.000000','0.000000','0.000000','0.000000','') ON DUPLICATE KEY UPDATE `owner`='',`maxX`=0.000000,`maxY`=0.000000,`minX`=0.000000,`minY`=0.000000,`flaggeX`=0.000000,`flaggeY`=0.000000,`flaggeZ`=0.000000,`erstellt`='';) - Successfully executed.
[14:26:58] >> mysql_query( Connection handle: 1 )
[14:26:58] CMySQLHandler::Query(INSERT INTO gangwar (id,owner,maxX,maxY,minX,minY,flaggeX,flaggeY,flaggeZ,erstellt) VALUES (23,'','0.000000','0.000000','0.000000','0.000000','0.000000','0.000000','0.000000','') ON DUPLICATE KEY UPDATE `owner`='',`maxX`=0.000000,`maxY`=0.000000,`minX`=0.000000,`minY`=0.000000,`flaggeX`=0.000000,`flaggeY`=0.000000,`flaggeZ`=0.000000,`erstellt`='';) - Successfully executed.
[14:26:58] >> mysql_query( Connection handle: 1 )
[14:26:58] CMySQLHandler::Query(INSERT INTO gangwar (id,owner,maxX,maxY,minX,minY,flaggeX,flaggeY,flaggeZ,erstellt) VALUES (24,'','0.000000','0.000000','0.000000','0.000000','0.000000','0.000000','0.000000','') ON DUPLICATE KEY UPDATE `owner`='',`maxX`=0.000000,`maxY`=0.000000,`minX`=0.000000,`minY`=0.000000,`flaggeX`=0.000000,`flaggeY`=0.000000,`flaggeZ`=0.000000,`erstellt`='';) - Successfully executed.
[14:26:58] >> mysql_query( Connection handle: 1 )
[14:26:58] CMySQLHandler::Query(INSERT INTO gangwar (id,owner,maxX,maxY,minX,minY,flaggeX,flaggeY,flaggeZ,erstellt) VALUES (25,'','0.000000','0.000000','0.000000','0.000000','0.000000','0.000000','0.000000','') ON DUPLICATE KEY UPDATE `owner`='',`maxX`=0.000000,`maxY`=0.000000,`minX`=0.000000,`minY`=0.000000,`flaggeX`=0.000000,`flaggeY`=0.000000,`flaggeZ`=0.000000,`erstellt`='';) - Successfully executed.
[14:26:58] >> mysql_query( Connection handle: 1 )
[14:26:58] CMySQLHandler::Query(INSERT INTO gangwar (id,owner,maxX,maxY,minX,minY,flaggeX,flaggeY,flaggeZ,erstellt) VALUES (26,'','0.000000','0.000000','0.000000','0.000000','0.000000','0.000000','0.000000','') ON DUPLICATE KEY UPDATE `owner`='',`maxX`=0.000000,`maxY`=0.000000,`minX`=0.000000,`minY`=0.000000,`flaggeX`=0.000000,`flaggeY`=0.000000,`flaggeZ`=0.000000,`erstellt`='';) - Successfully executed.
[14:26:58] >> mysql_query( Connection handle: 1 )
[14:26:58] CMySQLHandler::Query(INSERT INTO gangwar (id,owner,maxX,maxY,minX,minY,flaggeX,flaggeY,flaggeZ,erstellt) VALUES (27,'','0.000000','0.000000','0.000000','0.000000','0.000000','0.000000','0.000000','') ON DUPLICATE KEY UPDATE `owner`='',`maxX`=0.000000,`maxY`=0.000000,`minX`=0.000000,`minY`=0.000000,`flaggeX`=0.000000,`flaggeY`=0.000000,`flaggeZ`=0.000000,`erstellt`='';) - Successfully executed.
[14:26:58] >> mysql_query( Connection handle: 1 )
[14:26:58] CMySQLHandler::Query(INSERT INTO gangwar (id,owner,maxX,maxY,minX,minY,flaggeX,flaggeY,flaggeZ,erstellt) VALUES (28,'','0.000000','0.000000','0.000000','0.000000','0.000000','0.000000','0.000000','') ON DUPLICATE KEY UPDATE `owner`='',`maxX`=0.000000,`maxY`=0.000000,`minX`=0.000000,`minY`=0.000000,`flaggeX`=0.000000,`flaggeY`=0.000000,`flaggeZ`=0.000000,`erstellt`='';) - Successfully executed.
[14:26:58] >> mysql_query( Connection handle: 1 )
[14:26:58] CMySQLHandler::Query(INSERT INTO gangwar (id,owner,maxX,maxY,minX,minY,flaggeX,flaggeY,flaggeZ,erstellt) VALUES (29,'','0.000000','0.000000','0.000000','0.000000','0.000000','0.000000','0.000000','') ON DUPLICATE KEY UPDATE `owner`='',`maxX`=0.000000,`maxY`=0.000000,`minX`=0.000000,`minY`=0.000000,`flaggeX`=0.000000,`flaggeY`=0.000000,`flaggeZ`=0.000000,`erstellt`='';) - Successfully executed.

stock SaveGZ()
{
for(new i,string[500]; i<MAX_GZ; i++)
{
format(string,sizeof(string),"INSERT INTO gangwar (id,owner,maxX,maxY,minX,minY,flaggeX,flaggeY,flaggeZ,erstellt) VALUES (%d,'%s','%f','%f','%f','%f','%f','%f','%f','%s')",
i,GZ[i][owner],GZ[i][max_x],GZ[i][max_y],GZ[i][min_x],GZ[i][min_y],GZ[i][flagge_x],GZ[i][flagge_y],GZ[i][flagge_z],GZ[i][erstellt]);
format(string,sizeof(string),"%s ON DUPLICATE KEY UPDATE `owner`='%s',`maxX`=%f,`maxY`=%f,`minX`=%f,`minY`=%f,`flaggeX`=%f,`flaggeY`=%f,`flaggeZ`=%f,`erstellt`='%s';",
string, GZ[i][owner],GZ[i][max_x],GZ[i][max_y],GZ[i][min_x],GZ[i][min_y],GZ[i][flagge_x],GZ[i][flagge_y],GZ[i][flagge_z],GZ[i][erstellt]);
mysql_query(string);
}
return 1;
}

Ups, dass hatte ich ausversehen mit gelöscht, aber das problem besteht leider weiter hin.