Beiträge von BeatsNinja114

    Hallo,


    Ich hab leider Probleme mit dem Autohaussystem das Problem ist wenn ich ein Autohaus erstelle das es erst nach restart ein PickUp da ist, Ich habe es schon versucht etwas umzuschreiben aber leider finde ich den Fehler nicht.
    Bitte ich bräuchte hilfe wenn ihr noch Code braucht sagt es mir ruhig


    ocmd@2:ccd,createcardealer(playerid,params[])
    {
    new name[32],price,level,Float:xPos[3];
    if(pInfo[playerid][pAdmin] != 5)return 1;
    if(sscanf(params,"dds[32]",price,level,name))return SendClientMessage(playerid,COLOR_GREY,"Benutze: /ccd [Preis] [Level] [Name]");
    for(new i;i<MAX_AUTOHAUS;i++) {
    if(AHInfo[i][zCreated])continue;
    new str[256];
    GetPlayerPos(playerid,xPos[0],xPos[1],xPos[2]);
    format(str,sizeof str,"INSERT INTO `cardealers` (`Owner`, `PosX`, `PosY`, `PosZ`, `Name`, `Price`, `Level`, `LPosX`, `LPosY`, `LPosZ`, `cbought`) VALUES ('Niemand', '%f', '%f', '%f', '%s', '%d', '%d', '%f', '%f', '%f', '%f')",xPos[0],xPos[1],xPos[2],name,price,level,xPos[0],xPos[1],xPos[2],cbought);
    mysql_pquery(dbHandle,str);
    format(str,256,"SELECT * FROM `cardealers` WHERE `ID` = '%d'",i);
    return mysql_pquery(dbHandle,str,"OnQueryFinish","sd",str,QuerySelectAllCarDealers);
    }
    return 1;
    }




    for(new i;i<MAX_AUTOHAUS;i++) {
    if(!AHInfo[i][zCreated])continue;
    if(IsPlayerInRangeOfPoint(playerid,3,AHInfo[i][zPosX],AHInfo[i][zPosY],AHInfo[i][zPosZ]))
    {
    if((!strcmp(AHInfo[i][zOwner],"Niemand",true)))
    {
    if(pInfo[playerid][pMoney] >= AHInfo[i][zPrice])
    {
    if(GetPlayerScore(playerid) >= AHInfo[i][zLevel])
    {
    new q[128];
    GetPlayerName(playerid,sendername,sizeof sendername);
    pInfo[playerid][pMoney] -= AHInfo[i][zPrice];
    pInfo[playerid][pAH] = i+1;
    format(AHInfo[i][zOwner],24,"%s",sendername);
    SendClientMessage(playerid,COLOR_LIGHTGREEN,"Du hast dir das Autohaus erfolgreich gekauft!");
    SendClientMessage(playerid,COLOR_GREY,"Autohaus verwalten: /cardealer");
    KillCarDealer(i);
    format(q,128,"SELECT * FROM `cardealers` WHERE `ID` = '%d'",i+1);
    return mysql_pquery(dbHandle,q,"OnQueryFinish","sd",q,QueryCallCarDealer);
    }
    else
    {
    return SendClientMessage(playerid,COLOR_LIGHTRED,"Dein Level reicht nicht aus, um dieses Autohaus zu kaufen!");
    }
    }
    else
    {
    return SendClientMessage(playerid,COLOR_LIGHTRED,"Du hast nicht genug Geld, um dieses Autohaus zu kaufen!");
    }
    }
    else
    {
    return SendClientMessage(playerid,COLOR_LIGHTRED,"Dieses Autohaus ist nicht zu verkaufen!");
    }
    }
    }



    case QueryCallCarDealer:
    {
    cache_get_data(rows,fields);
    printf("CallCarDealer Rows: %d",rows);
    if(rows == 1) {
    for(new i;i<MAX_AUTOHAUS;i++) {
    if(AHInfo[i][zCreated])continue;
    cache_get_field_content(0,"ID",result);
    AHInfo[i][zID] = strval(result);
    cache_get_field_content(0,"Owner",result);
    format(AHInfo[i][zOwner],32,"%s",result);
    cache_get_field_content(0,"PosX",result);
    AHInfo[i][zPosX] = floatstr(result);
    cache_get_field_content(0,"PosY",result);
    AHInfo[i][zPosY] = floatstr(result);
    cache_get_field_content(0,"PosZ",result);
    AHInfo[i][zPosZ] = floatstr(result);
    cache_get_field_content(0,"Bank",result);
    AHInfo[i][zBank] = strval(result);
    cache_get_field_content(0,"Name",result);
    format(AHInfo[i][zName],24,"%s",result);
    cache_get_field_content(0,"Price",result);
    AHInfo[i][zPrice] = strval(result);
    cache_get_field_content(0,"Level",result);
    AHInfo[i][zLevel] = strval(result);
    cache_get_field_content(0,"OrderCap",result);
    AHInfo[i][zOrderCap] = strval(result);
    cache_get_field_content(0,"StoreCap",result);
    AHInfo[i][zStoreCap] = strval(result);
    cache_get_field_content(0,"LPosX",result);
    AHInfo[i][zLPosX] = floatstr(result);
    cache_get_field_content(0,"LPosY",result);
    AHInfo[i][zLPosY] = floatstr(result);
    cache_get_field_content(0,"LPosZ",result);
    AHInfo[i][zLPosZ] = floatstr(result);
    cache_get_field_content(0,"LPosA",result);
    AHInfo[i][zLPosA] = floatstr(result);
    if(AHInfo[i][cbought] == 0)
    {
    AHInfo[i][zPickup]=CreatePickup(1273,1,AHInfo[i][zPosX],AHInfo[i][zPosY],AHInfo[i][zPosZ],0);
    format(str,128,"** %s **\n Besitzer: %s\n Dieses Autohaus ist zu verkaufen!\nPreis: %s€\nLevel: %d\nAutohaus kaufen: /buy",AHInfo[i][zName],AHInfo[i][zOwner],inspoints(AHInfo[i][zPrice]),AHInfo[i][zLevel]);
    AHInfo[i][zLabel]=Create3DTextLabel(str,COLOR_AHLABEL,AHInfo[i][zPosX],AHInfo[i][zPosY],AHInfo[i][zPosZ],20,0,1);
    }
    else
    {
    AHInfo[i][zPickup]=CreatePickup(1272,1,AHInfo[i][zPosX],AHInfo[i][zPosY],AHInfo[i][zPosZ],0);
    format(str,128,"** %s **\nBesitzer: %s",AHInfo[i][zName],AHInfo[i][zOwner]);
    AHInfo[i][zLabel]=Create3DTextLabel(str,COLOR_AHLABEL,AHInfo[i][zPosX],AHInfo[i][zPosY],AHInfo[i][zPosZ],20,0,1);
    }
    return AHInfo[i][zCreated] = true;
    }
    }
    }



    case QuerySelectAllCarDealers:
    {
    cache_get_data(rows,fields);
    if(rows > 0 && rows < 6) {
    oldtime=GetTickCount();
    new idx,string[128];
    for(;idx<rows;idx++) {
    cache_get_field_content(idx,"ID",result);
    AHInfo[idx][zID] = strval(result);
    cache_get_field_content(idx,"Owner",result);
    format(AHInfo[idx][zOwner],32,"%s",result);
    cache_get_field_content(idx,"PosX",result);
    AHInfo[idx][zPosX] = floatstr(result);
    cache_get_field_content(idx,"PosY",result);
    AHInfo[idx][zPosY] = floatstr(result);
    cache_get_field_content(idx,"PosZ",result);
    AHInfo[idx][zPosZ] = floatstr(result);
    cache_get_field_content(idx,"Bank",result);
    AHInfo[idx][zBank] = strval(result);
    cache_get_field_content(idx,"Name",result);
    format(AHInfo[idx][zName],24,"%s",result);
    cache_get_field_content(idx,"Price",result);
    AHInfo[idx][zPrice] = strval(result);
    cache_get_field_content(idx,"Level",result);
    AHInfo[idx][zLevel] = strval(result);
    cache_get_field_content(idx,"OrderCap",result);
    AHInfo[idx][zOrderCap] = strval(result);
    cache_get_field_content(idx,"StoreCap",result);
    AHInfo[idx][zStoreCap] = strval(result);
    cache_get_field_content(idx,"LPosX",result);
    AHInfo[idx][zLPosX] = floatstr(result);
    cache_get_field_content(idx,"LPosY",result);
    AHInfo[idx][zLPosY] = floatstr(result);
    cache_get_field_content(idx,"LPosZ",result);
    AHInfo[idx][zLPosZ] = floatstr(result);
    cache_get_field_content(idx,"LPosA",result);
    AHInfo[idx][zLPosA] = floatstr(result);
    if(AHInfo[idx][cbought] == 0)
    {
    AHInfo[idx][zPickup]=CreatePickup(1273,1,AHInfo[idx][zPosX],AHInfo[idx][zPosY],AHInfo[idx][zPosZ],0);
    format(string,128,"** %s **\nBesitzer: %s \n Dieses Autohaus ist zu verkaufen!\nPreis: %s€\nLevel: %d\nAutohaus kaufen: /buy",AHInfo[idx][zName],AHInfo[idx][zOwner],inspoints(AHInfo[idx][zPrice]),AHInfo[idx][zLevel]);
    AHInfo[idx][zLabel]=Create3DTextLabel(string,COLOR_AHLABEL,AHInfo[idx][zPosX],AHInfo[idx][zPosY],AHInfo[idx][zPosZ],20,0,1);
    AHInfo[idx][zCreated] = true;
    }
    else
    {
    AHInfo[idx][zPickup]=CreatePickup(1272,1,AHInfo[idx][zPosX],AHInfo[idx][zPosY],AHInfo[idx][zPosZ],0);
    format(string,128,"** %s **\nBesitzer: %s",AHInfo[idx][zName],AHInfo[idx][zOwner]);
    AHInfo[idx][zLabel]=Create3DTextLabel(string,COLOR_AHLABEL,AHInfo[idx][zPosX],AHInfo[idx][zPosY],AHInfo[idx][zPosZ],20,0,1);
    AHInfo[idx][zCreated] = true;
    }
    }
    printf("<-| [MYSQL-LOAD] Es wurden %d Autohäuser geladen - Dauer: %dms",rows,GetTickCount()-oldtime);
    }
    }


    //push 3.02.2016

    Mhh Virtuelle Welt 0


    ----------
    Loaded log file: "server_log.txt".
    ----------


    SA-MP Dedicated Server
    ----------------------
    v0.3.7-R2, (C)2005-2015 SA-MP Team


    [14:13:14]
    [14:13:14] Server Plugins
    [14:13:14] --------------
    [14:13:14] Loading plugin: mysql.so
    [14:13:14] >> plugin.mysql: R39-3 successfully loaded.
    [14:13:14] Loaded.
    [14:13:14] Loading plugin: streamer.so
    [14:13:14]


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


    [14:13:14] Loaded.
    [14:13:14] Loading plugin: sscanf.so
    [14:13:14]


    [14:13:14] ===============================


    [14:13:14] sscanf plugin loaded.


    [14:13:14] Version: 2.8.1


    [14:13:14] (c) 2012 Alex "Y_Less" Cole


    [14:13:14] ===============================


    [14:13:14] Loaded.
    [14:13:14] Loading plugin: audio.so
    [14:13:14]


    *** Audio Plugin v0.5 R2 by Incognito loaded ***


    [14:13:14] Loaded.
    [14:13:14] Loading plugin: crashdetect.so
    [14:13:14] Loaded.
    [14:13:14] Loading plugin: nativechecker.so
    [14:13:14] Loaded.
    [14:13:14] Loaded 6 plugins.


    [14:13:14]
    [14:13:14] Filterscripts
    [14:13:14] ---------------
    [14:13:14] Loaded 0 filterscripts.


    [14:13:14] [crashdetect]: gamemodes/script.amx does not contain debug information
    [14:13:14] *** Audio Plugin: Started TCP server on port 7777
    [14:13:14] <-| [MYSQL] Verbindung zur Datenbank wurde erfolgreich hergestellt!
    [14:13:14] [crashdetect]: filterscripts/Maps.amx does not contain debug information
    [14:13:14]
    [14:13:14] Alle Maps wurden erfolgreich geladen!
    [14:13:14]
    [14:13:14] Filterscript 'Maps.amx' loaded.
    [14:13:14] [crashdetect]: filterscripts/AudioHide.amx does not contain debug information
    [14:13:14] Filterscript 'AudioHide.amx' loaded.
    [14:13:14]
    [14:13:14] SCRIPT - (c) by Zinne
    [14:13:14]
    [14:13:14] Number of vehicle models: 0
    [14:13:14] [connection] 127.0.0.1:54879 requests connection cookie.
    [14:13:14] [connection] 127.0.0.1:47128 requests connection cookie.
    [14:13:14] [connection] 127.0.0.1:55140 requests connection cookie.
    [14:13:14] [connection] 127.0.0.1:47076 requests connection cookie.
    [14:13:15] [connection] incoming connection: 127.0.0.1:54879 id: 0
    [14:13:15] [connection] incoming connection: 127.0.0.1:47128 id: 1
    [14:13:15] [connection] incoming connection: 127.0.0.1:55140 id: 2
    [14:13:15] [connection] incoming connection: 127.0.0.1:47076 id: 3
    [14:13:15] [npc:join] Marihuanasamendealer has joined the server (0:127.0.0.1)
    [14:13:15] [npc:join] Kokainsamendealer has joined the server (1:127.0.0.1)
    [14:13:15] [npc:join] Kokainverarbeiter has joined the server (3:127.0.0.1)
    [14:13:15] [npc:join] Marihuanaverarbeiter has joined the server (2:127.0.0.1)
    [14:13:19] ho: 0 / Erstellte Label ID: 13
    [14:13:19] Label Details: Color: 12022271 / Pos: 645.659973 / -1345.420043 / 13.546899 => 0, 1
    [14:13:19] Label Text: Hausnummer 0
    Dieses Haus ist zu verkaufen!
    Preis: 1€
    Level: 5
    Mieträume: 1
    Haus besichtigen: ~k~~VEHICLE_ENTER_EXIT~ drücken
    Haus kaufen: /buy |ENDE
    [14:13:19] ho: 1 / Erstellte Label ID: 15
    [14:13:19] Label Details: Color: 12022271 / Pos: 645.495971 / -1348.160034 / 13.546899 => 0, 1
    [14:13:19] Label Text: Hausnummer 1
    Dieses Haus ist zu verkaufen!
    Preis: 50€
    Level: 5
    Mieträume: 6
    Haus besichtigen: ~k~~VEHICLE_ENTER_EXIT~ drücken
    Haus kaufen: /buy |ENDE
    [14:13:19] ho: 2 / Erstellte Label ID: 17
    [14:13:19] Label Details: Color: 12022271 / Pos: 671.224975 / -1351.729980 / 13.544899 => 0, 1
    [14:13:19] Label Text: Hausnummer 2
    Dieses Haus ist zu verkaufen!
    Preis: 1€
    Level: 5
    Mieträume: 5
    Haus besichtigen: ~k~~VEHICLE_ENTER_EXIT~ drücken
    Haus kaufen: /buy |ENDE
    [14:13:19] <-| [MYSQL-LOAD] Es wurden 3 Häuser geladen - Dauer: 0ms
    [14:13:24] <-| [MYSQL-LOAD] Es wurden 9 Business geladen - Dauer: 1ms
    [14:13:29] <-| [MYSQL-LOAD] Es wurden 13 Fraktionen geladen - Dauer: 4ms
    [14:13:30] [npc:part] Kokainverarbeiter has left the server (3:0)
    [14:13:30] [npc:part] Marihuanaverarbeiter has left the server (2:0)
    [14:13:34] <-| [MYSQL-LOAD] Die Tabelle "Misc" wurde erfolgreich geladen - Dauer: 0ms
    [14:15:01] Server password has been removed.
    [14:22:06] [connection] 62.178.101.20:51865 requests connection cookie.
    [14:22:07] [connection] incoming connection: 62.178.101.20:51865 id: 2
    [14:22:07] [join] BeatsNinja114 has joined the server (2:62.178.101.20)
    [14:22:16] <-| [LOAD] Spieler BeatsNinja114 (ID: 2) geladen - Dauer: 0ms
    [14:22:27] ho: 0 / Erstellte Label ID: 60
    [14:22:27] Label Details: Color: 12022271 / Pos: 644.588989 / -1333.010009 / 13.554400 => 0, 1
    [14:22:27] Label Text: Hausnummer 0
    Dieses Haus ist zu verkaufen!
    Preis: 1€
    Level: 5
    Mieträume: 5
    Haus besichtigen: ~k~~VEHICLE_ENTER_EXIT~ drücken
    Haus kaufen: /buy |ENDE
    [14:22:30] Meine Welt: 0

    Mhh also die Position stimmt.



    ----------
    Loaded log file: "server_log.txt".
    ----------


    SA-MP Dedicated Server
    ----------------------
    v0.3.7-R2, (C)2005-2015 SA-MP Team


    [13:33:32]
    [13:33:32] Server Plugins
    [13:33:32] --------------
    [13:33:32] Loading plugin: mysql.so
    [13:33:32] >> plugin.mysql: R39-3 successfully loaded.
    [13:33:32] Loaded.
    [13:33:32] Loading plugin: streamer.so
    [13:33:32]


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


    [13:33:32] Loaded.
    [13:33:32] Loading plugin: sscanf.so
    [13:33:32]


    [13:33:32] ===============================


    [13:33:32] sscanf plugin loaded.


    [13:33:32] Version: 2.8.1


    [13:33:32] (c) 2012 Alex "Y_Less" Cole


    [13:33:32] ===============================


    [13:33:32] Loaded.
    [13:33:32] Loading plugin: audio.so
    [13:33:32]


    *** Audio Plugin v0.5 R2 by Incognito loaded ***


    [13:33:32] Loaded.
    [13:33:32] Loading plugin: crashdetect.so
    [13:33:32] Loaded.
    [13:33:32] Loading plugin: nativechecker.so
    [13:33:32] Loaded.
    [13:33:32] Loaded 6 plugins.


    [13:33:32]
    [13:33:32] Filterscripts
    [13:33:32] ---------------
    [13:33:32] Loaded 0 filterscripts.


    [13:33:32] [crashdetect]: gamemodes/script.amx does not contain debug information
    [13:33:32] *** Audio Plugin: Started TCP server on port 7777
    [13:33:32] <-| [MYSQL] Verbindung zur Datenbank wurde erfolgreich hergestellt!
    [13:33:32] [crashdetect]: filterscripts/Maps.amx does not contain debug information
    [13:33:32]
    [13:33:32] Alle Maps wurden erfolgreich geladen!
    [13:33:32]
    [13:33:32] Filterscript 'Maps.amx' loaded.
    [13:33:32] [crashdetect]: filterscripts/AudioHide.amx does not contain debug information
    [13:33:32] Filterscript 'AudioHide.amx' loaded.
    [13:33:32]
    [13:33:32] SCRIPT - (c) by Zinne
    [13:33:32]
    [13:33:32] Number of vehicle models: 0
    [13:33:32] [connection] 127.0.0.1:40731 requests connection cookie.
    [13:33:32] [connection] 127.0.0.1:45283 requests connection cookie.
    [13:33:32] [connection] 127.0.0.1:53696 requests connection cookie.
    [13:33:32] [connection] 127.0.0.1:55945 requests connection cookie.
    [13:33:33] [connection] incoming connection: 127.0.0.1:40731 id: 0
    [13:33:33] [connection] incoming connection: 127.0.0.1:45283 id: 1
    [13:33:33] [connection] incoming connection: 127.0.0.1:53696 id: 2
    [13:33:33] [connection] incoming connection: 127.0.0.1:55945 id: 3
    [13:33:33] [npc:join] Marihuanasamendealer has joined the server (0:127.0.0.1)
    [13:33:33] [npc:join] Kokainsamendealer has joined the server (1:127.0.0.1)
    [13:33:33] [npc:join] Marihuanaverarbeiter has joined the server (2:127.0.0.1)
    [13:33:33] [npc:join] Kokainverarbeiter has joined the server (3:127.0.0.1)
    [13:33:37] ho: 0 / Erstellte Label ID: 13
    [13:33:37] Label Details: Color: 12022271 / Pos: 645.659973 / -1345.420043 / 13.546899 => 0, 1
    [13:33:37] Label Text: Hausnummer 0
    Dieses Haus ist zu verkaufen!
    Preis: 50€
    Level: 5
    Mieträume: 1
    Haus besichtigen: ~k~~VEHICLE_ENTER_EXIT~ drücken
    Haus kaufen: /buy |ENDE
    [13:33:37] ho: 1 / Erstellte Label ID: 15
    [13:33:37] Label Details: Color: 12022271 / Pos: 645.495971 / -1348.160034 / 13.546899 => 0, 1
    [13:33:37] Label Text: Hausnummer 1
    Dieses Haus ist zu verkaufen!
    Preis: 50€
    Level: 5
    Mieträume: 6
    Haus besichtigen: ~k~~VEHICLE_ENTER_EXIT~ drücken
    Haus kaufen: /buy |ENDE
    [13:33:37] <-| [MYSQL-LOAD] Es wurden 2 Häuser geladen - Dauer: 0ms
    [13:33:42] <-| [MYSQL-LOAD] Es wurden 9 Business geladen - Dauer: 1ms
    [13:33:47] <-| [MYSQL-LOAD] Es wurden 13 Fraktionen geladen - Dauer: 3ms
    [13:33:48] [npc:part] Kokainverarbeiter has left the server (3:0)
    [13:33:48] [npc:part] Marihuanaverarbeiter has left the server (2:0)
    [13:33:52] <-| [MYSQL-LOAD] Die Tabelle "Misc" wurde erfolgreich geladen - Dauer: 0ms
    [13:35:19] Server password has been removed.
    [13:36:07] [connection] 62.178.101.20:49689 requests connection cookie.
    [13:36:08] [connection] incoming connection: 62.178.101.20:49689 id: 2
    [13:36:09] [join] BeatsNinja114 has joined the server (2:62.178.101.20)
    [13:38:55] <-| [LOAD] Spieler BeatsNinja114 (ID: 2) geladen - Dauer: 0ms
    [13:39:03] ho: 0 / Erstellte Label ID: 13
    [13:39:03] Label Details: Color: 12022271 / Pos: 645.659973 / -1345.420043 / 13.546899 => 0, 1
    [13:39:03] Label Text: Hausnummer 0
    Besitzer: BeatsNinja114
    Mietpreis: 100€
    Zimmer mieten - /rentroom |ENDE
    [13:39:15] ho: 0 / Erstellte Label ID: 13
    [13:39:15] Label Details: Color: 12022271 / Pos: 645.659973 / -1345.420043 / 13.546899 => 0, 1
    [13:39:15] Label Text: Hausnummer 0
    Dieses Haus ist zu verkaufen!
    Preis: 50€
    Level: 5
    Mieträume: 1
    Haus besichtigen: ~k~~VEHICLE_ENTER_EXIT~ drücken
    Haus kaufen: /buy |ENDE
    [13:41:36] [part] BeatsNinja114 has left the server (2:0)
    [13:41:36]
    [13:41:36] ::: MySQL Query Error :::
    [13:41:36] ErrorID: 1054
    [13:41:36] Error: Unknown column 'BankAcc' in 'field list'
    [13:41:36] Callback:
    [13:41:36] Query: UPDATE `accounts` SET `Admin` = '5', `Money` = '4999950', `Score` = '100', `Skin` = '44', `Kicks` = '0',`Bans` = '0', `Warns` = '0', `Banned` = '0', `BanGrund` = '', `Mute` = '0', `Geschlecht` = '1', `NextPayday` = '2',`Gras` = '0', `Kokain` = '0', `Grassamen` = '0', `Kokainsamen` = '0', `Joe` = '0', `Jose` = '0', `Hunger` = '10', `Durst` = '10',`Harndrang` = '10', `Haus` = '1', `Exp` = '0', `ForumAcc` = '0', `AH` = '-1', `Hitsound` = '1', `Timeban` = '0', `Carslots` = '1',`Biz` = '-1', `Tutorial` = '1', `Fraktion` = '0', `Leader` = '0', `Frakrank` = '0', `Handy` = '0', `Handynummer` = '0', `Handystatus` = '0',`Handyvertrag` = '0', `Handyguthaben` = '0', `Telefonbuch` = '0', `Benzinkanister` = '0', `Kanisterliter` = '0', `Supportpunkte` = '0',`BankAcc` = '0', `BankMoney` = '0', `BankPin` = '0', `MariLic` = '0', `KokaLic` = '0', `UnreadyMari` = '0', `UnreadyKoka` = '0', `MP3Player` = '0' WHERE `Name` = 'BeatsNinja114'
    [13:41:36] ConnectionHandle: 1
    [13:41:36]
    [13:41:36]
    [13:41:36] ::: MySQL Query Error :::
    [13:41:36] ErrorID: 1054
    [13:41:36] Error: Unknown column 'SessionAFK' in 'field list'
    [13:41:36] Callback:
    [13:41:36] Query: INSERT INTO `Logouts` (`Name`, `Date`, `Time`, `Reason`, `Sessiontime`, `SessionAFK`) VALUES ('BeatsNinja114', '16.12.2015', '13:41:36', 'Timeout/Crash', '2', '0')
    [13:41:36] ConnectionHandle: 1
    [13:41:36]


    Also das kommt.



    ----------
    Loaded log file: "server_log.txt".
    ----------


    SA-MP Dedicated Server
    ----------------------
    v0.3.7-R2, (C)2005-2015 SA-MP Team


    [13:26:05]
    [13:26:05] Server Plugins
    [13:26:05] --------------
    [13:26:05] Loading plugin: mysql.so
    [13:26:05] >> plugin.mysql: R39-3 successfully loaded.
    [13:26:05] Loaded.
    [13:26:05] Loading plugin: streamer.so
    [13:26:05]


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


    [13:26:05] Loaded.
    [13:26:05] Loading plugin: sscanf.so
    [13:26:05]


    [13:26:05] ===============================


    [13:26:05] sscanf plugin loaded.


    [13:26:05] Version: 2.8.1


    [13:26:05] (c) 2012 Alex "Y_Less" Cole


    [13:26:05] ===============================


    [13:26:05] Loaded.
    [13:26:05] Loading plugin: audio.so
    [13:26:05]


    *** Audio Plugin v0.5 R2 by Incognito loaded ***


    [13:26:05] Loaded.
    [13:26:05] Loading plugin: crashdetect.so
    [13:26:05] Loaded.
    [13:26:05] Loading plugin: nativechecker.so
    [13:26:05] Loaded.
    [13:26:05] Loaded 6 plugins.


    [13:26:05]
    [13:26:05] Filterscripts
    [13:26:05] ---------------
    [13:26:05] Loaded 0 filterscripts.


    [13:26:05] [crashdetect]: gamemodes/script.amx does not contain debug information
    [13:26:05] *** Audio Plugin: Started TCP server on port 7777
    [13:26:05] <-| [MYSQL] Verbindung zur Datenbank wurde erfolgreich hergestellt!
    [13:26:05] [crashdetect]: filterscripts/Maps.amx does not contain debug information
    [13:26:05]
    [13:26:05] Alle Maps wurden erfolgreich geladen!
    [13:26:05]
    [13:26:05] Filterscript 'Maps.amx' loaded.
    [13:26:05] [crashdetect]: filterscripts/AudioHide.amx does not contain debug information
    [13:26:05] Filterscript 'AudioHide.amx' loaded.
    [13:26:05]
    [13:26:05] SCRIPT - (c) by Zinne
    [13:26:05]
    [13:26:05] Number of vehicle models: 0
    [13:26:05] [connection] 127.0.0.1:37421 requests connection cookie.
    [13:26:05] [connection] 127.0.0.1:40746 requests connection cookie.
    [13:26:05] [connection] 127.0.0.1:48338 requests connection cookie.
    [13:26:05] [connection] 127.0.0.1:60177 requests connection cookie.
    [13:26:06] [connection] incoming connection: 127.0.0.1:37421 id: 0
    [13:26:06] [connection] incoming connection: 127.0.0.1:40746 id: 1
    [13:26:06] [connection] incoming connection: 127.0.0.1:60177 id: 2
    [13:26:06] [connection] incoming connection: 127.0.0.1:48338 id: 3
    [13:26:06] [npc:join] Marihuanasamendealer has joined the server (0:127.0.0.1)
    [13:26:06] [npc:join] Marihuanaverarbeiter has joined the server (3:127.0.0.1)
    [13:26:06] [npc:join] Kokainsamendealer has joined the server (1:127.0.0.1)
    [13:26:06] [npc:join] Kokainverarbeiter has joined the server (2:127.0.0.1)
    [13:26:10] ho: 0 / Erstellte Label ID: 13
    [13:26:10] ho: 1 / Erstellte Label ID: 15
    [13:26:10] <-| [MYSQL-LOAD] Es wurden 2 Häuser geladen - Dauer: 0ms
    [13:26:15] <-| [MYSQL-LOAD] Es wurden 9 Business geladen - Dauer: 1ms
    [13:26:20] <-| [MYSQL-LOAD] Es wurden 13 Fraktionen geladen - Dauer: 3ms
    [13:26:21] [npc:part] Marihuanaverarbeiter has left the server (3:0)
    [13:26:21] [npc:part] Kokainverarbeiter has left the server (2:0)
    [13:26:25] <-| [MYSQL-LOAD] Die Tabelle "Misc" wurde erfolgreich geladen - Dauer: 0ms
    [13:27:52] Server password has been removed.
    [13:28:16] [connection] 62.178.101.20:54560 requests connection cookie.
    [13:28:17] [connection] incoming connection: 62.178.101.20:54560 id: 2
    [13:28:17] [join] BeatsNinja114 has joined the server (2:62.178.101.20)
    [13:28:26] <-| [LOAD] Spieler BeatsNinja114 (ID: 2) geladen - Dauer: 1ms
    [13:28:48] ho: 0 / Erstellte Label ID: 58
    [13:28:56] [part] BeatsNinja114 has left the server (2:1)
    [13:28:56]
    [13:28:56] ::: MySQL Query Error :::
    [13:28:56] ErrorID: 1054
    [13:28:56] Error: Unknown column 'SessionAFK' in 'field list'
    [13:28:56] Callback:
    [13:28:56] Query: INSERT INTO `Logouts` (`Name`, `Date`, `Time`, `Reason`, `Sessiontime`, `SessionAFK`) VALUES ('BeatsNinja114', '15.12.2015', '13:28:56', 'Quit', '0', '0')
    [13:28:56] ConnectionHandle: 1
    [13:28:56]
    [13:28:56]
    [13:28:56] ::: MySQL Query Error :::
    [13:28:56] ErrorID: 1054
    [13:28:56] Error: Unknown column 'BankAcc' in 'field list'
    [13:28:56] Callback:
    [13:28:56] Query: UPDATE `accounts` SET `Admin` = '5', `Money` = '5000000', `Score` = '100', `Skin` = '44', `Kicks` = '0',`Bans` = '0', `Warns` = '0', `Banned` = '0', `BanGrund` = '', `Mute` = '0', `Geschlecht` = '1', `NextPayday` = '0',`Gras` = '0', `Kokain` = '0', `Grassamen` = '0', `Kokainsamen` = '0', `Joe` = '0', `Jose` = '0', `Hunger` = '10', `Durst` = '10',`Harndrang` = '10', `Haus` = '-1', `Exp` = '0', `ForumAcc` = '0', `AH` = '-1', `Hitsound` = '1', `Timeban` = '0', `Carslots` = '1',`Biz` = '-1', `Tutorial` = '1', `Fraktion` = '0', `Leader` = '0', `Frakrank` = '0', `Handy` = '0', `Handynummer` = '0', `Handystatus` = '0',`Handyvertrag` = '0', `Handyguthaben` = '0', `Telefonbuch` = '0', `Benzinkanister` = '0', `Kanisterliter` = '0', `Supportpunkte` = '0',`BankAcc` = '0', `BankMoney` = '0', `BankPin` = '0', `MariLic` = '0', `KokaLic` = '0', `UnreadyMari` = '0', `UnreadyKoka` = '0', `MP3Player` = '0' WHERE `Name` = 'BeatsNinja114'
    [13:28:56] ConnectionHandle: 1
    [13:28:56]


    ]


    //edit


    Das komische ich hab 3 Häuser erstellt aber nur eins wird in der Serverlog angezeigt

    hier der Code


    case QueryCallLoadHouse:
    {
    cache_get_data(rows,fields);
    if(rows) {
    new ho;
    for(;ho<rows;ho++) {
    //if(ho==0){ho++;}
    cache_get_field_content(ho,"ID",result);
    HausInfo[ho][hID] = strval(result);
    cache_get_field_content(ho,"PosX",result);
    HausInfo[ho][hPosX] = floatstr(result);
    cache_get_field_content(ho,"PosY",result);
    HausInfo[ho][hPosY] = floatstr(result);
    cache_get_field_content(ho,"PosZ",result);
    HausInfo[ho][hPosZ] = floatstr(result);
    cache_get_field_content(ho,"Level",result);
    HausInfo[ho][hLevel] = strval(result);
    cache_get_field_content(ho,"Preis",result);
    HausInfo[ho][hPreis] = strval(result);
    cache_get_field_content(ho,"Besitzer",result);
    format(HausInfo[ho][hBesitzer],24,"%s",result);
    cache_get_field_content(ho,"Bought",result);
    HausInfo[ho][hBought] = strval(result);
    cache_get_field_content(ho,"Rooms",result);
    HausInfo[ho][hRooms] = strval(result);
    cache_get_field_content(ho,"InteriorID",result);
    HausInfo[ho][hInteriorID] = strval(result);
    cache_get_field_content(ho,"Interior",result);
    HausInfo[ho][hInterior] = strval(result);
    cache_get_field_content(ho,"IntX",result);
    HausInfo[ho][hIntX] = floatstr(result);
    cache_get_field_content(ho,"IntY",result);
    HausInfo[ho][hIntY] = floatstr(result);
    cache_get_field_content(ho,"IntZ",result);
    HausInfo[ho][hIntZ] = floatstr(result);
    cache_get_field_content(ho,"Locked",result);
    HausInfo[ho][hLocked] = strval(result);
    cache_get_field_content(ho,"Rentable",result);
    HausInfo[ho][hRentable] = strval(result);
    cache_get_field_content(ho,"RentPrice",result);
    HausInfo[ho][hRentPrice] = strval(result);
    cache_get_field_content(ho,"Renter1",result);
    format(HausInfo[ho][hRenter1],24,"%s",result);
    cache_get_field_content(ho,"Renter2",result);
    format(HausInfo[ho][hRenter2],24,"%s",result);
    cache_get_field_content(ho,"Renter3",result);
    format(HausInfo[ho][hRenter3],24,"%s",result);
    cache_get_field_content(ho,"Renter4",result);
    format(HausInfo[ho][hRenter4],24,"%s",result);
    cache_get_field_content(ho,"Renter5",result);
    format(HausInfo[ho][hRenter5],24,"%s",result);
    cache_get_field_content(ho,"Renter6",result);
    format(HausInfo[ho][hRenter6],24,"%s",result);
    HausInfo[ho][hVW] = HausInfo[ho][hID]+1;
    HausInfo[ho][hOutPickup] = CreatePickup(1318,1,HausInfo[ho][hIntX],HausInfo[ho][hIntY],HausInfo[ho][hIntZ],HausInfo[ho][hVW]);
    if(HausInfo[ho][hBought] == 0) {
    HausInfo[ho][hPickup] = CreatePickup(1272,1,HausInfo[ho][hPosX],HausInfo[ho][hPosY],HausInfo[ho][hPosZ]);
    format(str,256,"Hausnummer %d\nDieses Haus ist zu verkaufen!\nPreis: %s€\nLevel: %d\nMieträume: %d\nHaus besichtigen: ~k~~VEHICLE_ENTER_EXIT~ drücken\nHaus kaufen: /buy",ho,inspoints(HausInfo[ho][hPreis]),HausInfo[ho][hLevel],HausInfo[ho][hRooms]);
    } else {
    if(HausInfo[ho][hRentable] == 1) {
    format(str,256,"Hausnummer %d\nBesitzer: %s\nMietpreis: %s€\nZimmer mieten - /rentroom",ho,HausInfo[ho][hBesitzer],inspoints(HausInfo[ho][hRentPrice]));
    } else if(HausInfo[ho][hRentable] == 0) {
    format(str,256,"Hausnummer %d\nBesitzer: %s",ho,HausInfo[ho][hBesitzer]);
    }
    HausInfo[ho][hPickup] = CreatePickup(1239,1,HausInfo[ho][hPosX],HausInfo[ho][hPosY],HausInfo[ho][hPosZ]);
    }
    Create3DTextLabel(str,COLOR_AO,HausInfo[ho][hPosX],HausInfo[ho][hPosY],HausInfo[ho][hPosZ],15,1);
    HausInfo[ho][hOutLabel]=Create3DTextLabel("Austreten:\n~k~~VEHICLE_ENTER_EXIT~ drücken",COLOR_AO,HausInfo[ho][hIntX],HausInfo[ho][hIntY],HausInfo[ho][hIntZ],5,HausInfo[ho][hVW],1);
    HausInfo[ho][hCreated]=true;
    }
    }
    }

    case QuerySelectAllHouse:
    {
    cache_get_data(rows,fields);
    if(rows > MAX_HAEUSER) return 0;
    new Float:X,Float:Y,Float:Z;
    GetPlayerPos(playerid,X,Y,Z);
    format(query,sizeof query,"INSERT INTO `haeuser` (`ID`, `PosX`, `PosY`,\
    `PosZ`, `Level`, `Preis`, `Besitzer`, `Bought`, `Rooms`,`InteriorID`,`Interior`,`IntX`,`IntY`,`IntZ`,`Rentable`,\
    `RentPrice`, `Renter1`, `Renter2`, `Renter3`, `Renter4`, `Renter5`");
    format(query,sizeof query,"%s,`Renter6`)VALUES('%d', '%f', '%f', '%f', '5', '%d', 'Niemand','0', '%d',\
    '%d', '%d', '%f', '%f', '%f', '1', '100', 'Niemand', 'Niemand', 'Niemand', 'Niemand', 'Niemand', 'Niemand')"\
    ,query,rows,X,Y,Z,pID,strval(extrastr),extraid,hIntID[extraid][0],hInteriorList[extraid][0], hInteriorList[extraid][1], hInteriorList[extraid][2]);
    mysql_pquery(dbHandle,query);


    format(str,sizeof str,"SELECT * FROM `haeuser` WHERE `ID` = '%d'",rows);
    mysql_pquery(dbHandle, str, "OnQueryFinish", "sdd", str, QueryCallLoadHouse, playerid);
    }


    so hier. Sry hat etwas länger gedauert @Jeffry

    Hallo. Ich hab ein Problem und zwar wenn ich ein Haus erstelle wird kein Text angezeigt also ob es verkauft ist oder ob es zum kaufen ist welchen Preis etc.... siehe bilder. Bitte um hilfe


    ocmd:createhouse(playerid,params[])
    {
    if(pInfo[playerid][pAdmin] == 5) {
    new p,r,int;
    if(sscanf(params,"iii",p,r,int))return SendClientMessage(playerid,COLOR_GREY,"Benutze: /createhouse [Preis] [Zimmer (max. 6)] [Interior ID (Liste: /hints)]");
    {
    if(r <= 6) {
    if(int <= 10) {
    new st[16];
    format(st,sizeof st,"%d",r);
    mysql_pquery(dbHandle,"SELECT * FROM `haeuser`","OnQueryFinish","sdddsd","SELECT * FROM `haeuser`",QuerySelectAllHouse,playerid,p,st,int);
    SendClientMessage(playerid,COLOR_LIGHTGREEN,"Du hast das Haus erfolgreich erstellt!");
    } else {
    SendClientMessage(playerid,COLOR_LIGHTRED,"Die InteriorID eines Hauses darf nicht größer als 10 sein!");
    }
    } else {
    SendClientMessage(playerid,COLOR_LIGHTRED,"Die Zimmer eines Hauses dürfen nicht mehr als 6 sein!");
    }
    }
    }
    return 1;
    }


    case QueryCallHouse:
    {
    cache_get_data(rows,fields);
    if(rows) {
    oldtime=GetTickCount();
    new ho;
    for(;ho<rows;ho++) {
    //if(ho==0){ho++;}
    cache_get_field_content(ho,"ID",result);
    HausInfo[ho][hID] = strval(result);
    cache_get_field_content(ho,"PosX",result);
    HausInfo[ho][hPosX] = floatstr(result);
    cache_get_field_content(ho,"PosY",result);
    HausInfo[ho][hPosY] = floatstr(result);
    cache_get_field_content(ho,"PosZ",result);
    HausInfo[ho][hPosZ] = floatstr(result);
    cache_get_field_content(ho,"Level",result);
    HausInfo[ho][hLevel] = strval(result);
    cache_get_field_content(ho,"Preis",result);
    HausInfo[ho][hPreis] = strval(result);
    cache_get_field_content(ho,"Besitzer",result);
    format(HausInfo[ho][hBesitzer],24,"%s",result);
    cache_get_field_content(ho,"Bought",result);
    HausInfo[ho][hBought] = strval(result);
    cache_get_field_content(ho,"Rooms",result);
    HausInfo[ho][hRooms] = strval(result);
    cache_get_field_content(ho,"InteriorID",result);
    HausInfo[ho][hInteriorID] = strval(result);
    cache_get_field_content(ho,"Interior",result);
    HausInfo[ho][hInterior] = strval(result);
    cache_get_field_content(ho,"IntX",result);
    HausInfo[ho][hIntX] = floatstr(result);
    cache_get_field_content(ho,"IntY",result);
    HausInfo[ho][hIntY] = floatstr(result);
    cache_get_field_content(ho,"IntZ",result);
    HausInfo[ho][hIntZ] = floatstr(result);
    cache_get_field_content(ho,"Locked",result);
    HausInfo[ho][hLocked] = strval(result);
    cache_get_field_content(ho,"Rentable",result);
    HausInfo[ho][hRentable] = strval(result);
    cache_get_field_content(ho,"RentPrice",result);
    HausInfo[ho][hRentPrice] = strval(result);
    cache_get_field_content(ho,"Renter1",result);
    format(HausInfo[ho][hRenter1],24,"%s",result);
    cache_get_field_content(ho,"Renter2",result);
    format(HausInfo[ho][hRenter2],24,"%s",result);
    cache_get_field_content(ho,"Renter3",result);
    format(HausInfo[ho][hRenter3],24,"%s",result);
    cache_get_field_content(ho,"Renter4",result);
    format(HausInfo[ho][hRenter4],24,"%s",result);
    cache_get_field_content(ho,"Renter5",result);
    format(HausInfo[ho][hRenter5],24,"%s",result);
    cache_get_field_content(ho,"Renter6",result);
    format(HausInfo[ho][hRenter6],24,"%s",result);
    HausInfo[ho][hVW] = HausInfo[ho][hID]+1;
    HausInfo[ho][hOutPickup] = CreatePickup(1318,1,HausInfo[ho][hIntX],HausInfo[ho][hIntY],HausInfo[ho][hIntZ],HausInfo[ho][hVW]);
    if(HausInfo[ho][hBought] == 0) {
    HausInfo[ho][hPickup] = CreatePickup(1272,1,HausInfo[ho][hPosX],HausInfo[ho][hPosY],HausInfo[ho][hPosZ]);
    format(str,256,"Hausnummer %d\nDieses Haus ist zu verkaufen!\nPreis: %s€\nLevel: %d\nMieträume: %d\nHaus besichtigen: ~k~~VEHICLE_ENTER_EXIT~ drücken\nHaus kaufen: /buy",ho,inspoints(HausInfo[ho][hPreis]),HausInfo[ho][hLevel],HausInfo[ho][hRooms]);
    } else {
    if(HausInfo[ho][hRentable] == 1) {
    format(str,256,"Hausnummer %d\nBesitzer: %s\nMietpreis: %s€\nZimmer mieten - /rentroom",ho,HausInfo[ho][hBesitzer],inspoints(HausInfo[ho][hRentPrice]));
    } else if(HausInfo[ho][hRentable] == 0) {
    format(str,256,"Hausnummer %d\nBesitzer: %s",ho,HausInfo[ho][hBesitzer]);
    }
    HausInfo[ho][hPickup] = CreatePickup(1239,1,HausInfo[ho][hPosX],HausInfo[ho][hPosY],HausInfo[ho][hPosZ]);
    }
    HausInfo[ho][hLabel]=Create3DTextLabel(str,COLOR_AO,HausInfo[ho][hPosX],HausInfo[ho][hPosY],HausInfo[ho][hPosZ],7,1);
    HausInfo[ho][hOutLabel]=Create3DTextLabel("Austreten:\n~k~~VEHICLE_ENTER_EXIT~ drücken",COLOR_AO,HausInfo[ho][hIntX],HausInfo[ho][hIntY],HausInfo[ho][hIntZ],5,HausInfo[ho][hVW],1);
    HausInfo[ho][hCreated]=true;
    }
    printf("<-| [MYSQL-LOAD] Es wurden %d Häuser geladen - Dauer: %dms",ho,GetTickCount()-oldtime);
    }
    }