Beiträge von Maurice.

    Wie packe ich die bots in eine virtuale welt. Wenn ich denspieler in eine random welt packe? hier mal mein code: PlayerV[playerid] = random(256);
    SetPlayerVirtualWorld(playerid,PlayerV[playerid]);
    TutorialV[playerid][0] = CreateVehicle(506,-1855.5466,916.4339,34.7134,265.6235,90,71,999999);
    if(!strcmp(GetName(playerid),"Auto",true))
    {
    pInfo[playerid][pOnline] = 1;
    PutPlayerInVehicle(playerid,TutorialV[playerid][0],0);
    SetPlayerVirtualWorld(playerid,PlayerV[playerid]);
    }
    if(!strcmp(GetName(playerid),"test1",true)){ pInfo[playerid][pOnline] = 1; SetPlayerVirtualWorld(playerid,PlayerV[playerid]); }
    if(!strcmp(GetName(playerid),"test2",true)){ pInfo[playerid][pOnline] = 1; SetPlayerVirtualWorld(playerid,PlayerV[playerid]); }
    if(!strcmp(GetName(playerid),"test3",true)){ pInfo[playerid][pOnline] = 1; SetPlayerVirtualWorld(playerid,PlayerV[playerid]); }
    if(!strcmp(GetName(playerid),"test4",true)){ pInfo[playerid][pOnline] = 1; SetPlayerVirtualWorld(playerid,PlayerV[playerid]); }
    if(!strcmp(GetName(playerid),"test5",true)){ pInfo[playerid][pOnline] = 1; SetPlayerVirtualWorld(playerid,PlayerV[playerid]); }
    if(!strcmp(GetName(playerid),"test6",true)){ pInfo[playerid][pOnline] = 1; SetPlayerVirtualWorld(playerid,PlayerV[playerid]); }
    if(!strcmp(GetName(playerid),"test7",true)){ pInfo[playerid][pOnline] = 1; SetPlayerVirtualWorld(playerid,PlayerV[playerid]); }
    if(!strcmp(GetName(playerid),"test8",true)){ pInfo[playerid][pOnline] = 1; SetPlayerVirtualWorld(playerid,PlayerV[playerid]); }
    if(!strcmp(GetName(playerid),"test9",true)){ pInfo[playerid][pOnline] = 1; SetPlayerVirtualWorld(playerid,PlayerV[playerid]); }
    if(!strcmp(GetName(playerid),"test10",true)){ pInfo[playerid][pOnline] = 1; SetPlayerVirtualWorld(playerid,PlayerV[playerid]); }


    dies funzuniert aller dings nicht

    mysql_query(1,"CREATE TABLE IF NOT EXISTS `srp_accounts` (`id` int(11) NOT NULL AUTO_INCREMENT, `Name` varchar(64) NOT NULL, `Passwort` varchar(24) NOT NULL, `Level` int(11) NOT NULL, `Bargeld` int(11) NOT NULL, `Admin` int(11) NOT NULL, `Eingeloggt` int(2) NOT NULL, PRIMARY KEY (`id`)) ENGINE=MyISAM DEFAULT CHARSET=latin1;");

    mysql_format(mycon,query,sizeof(query),"INSERT INTO `warn` (Name, Grund, Admin, Datum, Uhrzeit, Warn) VALUES ('%e','%e','%e','%e','%e')",name,string3,aname,string,string2,PlayerInfo[pID][pWarn]);
    mysql_tquery(mycon,query,"","");


    so sollte es funzunieren

    Wo ist hier der fehler ? Den bei den Plugin Strickendkind. Wenn dort was falsch ist spawnt man nicht. Und ich spawne nicht. Wo ist den hier der fehler ? public LoadProperty()
    {
    new query2[256];
    // new h;
    for(new idx; idx<MAX_HOUSE; idx++)
    {
    format(query2, sizeof(query2), "SELECT * FROM `haussystem` WHERE `houseid` = %i", idx);
    mysql_query(query2);
    mysql_store_result();
    if(mysql_num_rows())
    {
    HouseInfo[idx][hEntrancex] = mysql_GetFloatByInt("haussystem", "hentrancex", "houseid",HouseInfo[idx][hID]);
    HouseInfo[idx][hEntrancey] = mysql_GetFloatByInt("haussystem", "hentrancey", "houseid",HouseInfo[idx][hID]);
    HouseInfo[idx][hEntrancez] = mysql_GetFloatByInt("haussystem", "hentrancez", "houseid",HouseInfo[idx][hID]);
    HouseInfo[idx][hExitx] = mysql_GetFloatByInt("haussystem", "hexitx", "houseid",HouseInfo[idx][hID]);
    HouseInfo[idx][hExity] = mysql_GetFloatByInt("haussystem", "hexity", "houseid",HouseInfo[idx][hID]);
    HouseInfo[idx][hExitz] = mysql_GetFloatByInt("haussystem", "hexitz", "houseid",HouseInfo[idx][hID]);
    HouseInfo[idx][hHealthx] = mysql_GetIntByInt("haussystem", "hhealthx", "houseid",HouseInfo[idx][hID]);
    HouseInfo[idx][hHealthy] = mysql_GetIntByInt("haussystem", "hhealthy", "houseid",HouseInfo[idx][hID]);
    HouseInfo[idx][hHealthz] = mysql_GetIntByInt("haussystem", "hhealthz", "houseid",HouseInfo[idx][hID]);
    HouseInfo[idx][hArmourx] = mysql_GetIntByInt("haussystem", "harmourx", "houseid",HouseInfo[idx][hID]);
    HouseInfo[idx][hArmoury] = mysql_GetIntByInt("haussystem", "harmoury", "houseid",HouseInfo[idx][hID]);
    HouseInfo[idx][hArmourz] = mysql_GetIntByInt("haussystem", "harmourz", "houseid",HouseInfo[idx][hID]);
    strmid(HouseInfo[idx][hOwner], mysql_GetStringByInt("haussystem","howner","houseid",hID),0, 256,256);
    strmid(HouseInfo[idx][hDiscription], mysql_GetStringByInt("haussystem","hdiscription","houseid",hID),0, 256,256);
    HouseInfo[idx][hValue] = mysql_GetIntByInt("haussystem", "hvalue", "houseid",HouseInfo[idx][hID]);
    HouseInfo[idx][hHel] = mysql_GetIntByInt("haussystem", "hhel", "houseid",HouseInfo[idx][hID]);
    HouseInfo[idx][hArm] = mysql_GetIntByInt("haussystem", "harm", "houseid",HouseInfo[idx][hID]);
    HouseInfo[idx][hInt] = mysql_GetIntByInt("haussystem", "hint", "houseid",HouseInfo[idx][hID]);
    HouseInfo[idx][hLock] = mysql_GetIntByInt("haussystem", "hlock", "houseid",HouseInfo[idx][hID]);
    HouseInfo[idx][hOwned] = mysql_GetIntByInt("haussystem", "howned", "houseid",HouseInfo[idx][hID]);
    HouseInfo[idx][hRooms] = mysql_GetIntByInt("haussystem", "hrooms", "houseid",HouseInfo[idx][hID]);
    HouseInfo[idx][hRent] = mysql_GetIntByInt("haussystem", "hrent", "houseid",HouseInfo[idx][hID]);
    HouseInfo[idx][hRentabil] = mysql_GetIntByInt("haussystem", "hrentabil", "houseid",HouseInfo[idx][hID]);
    HouseInfo[idx][hDate] = mysql_GetIntByInt("haussystem", "hdate", "houseid",HouseInfo[idx][hID]);
    HouseInfo[idx][hLevel] = mysql_GetIntByInt("haussystem", "hlevel", "houseid",HouseInfo[idx][hID]);
    }
    mysql_free_result();
    }
    print("Häuser geladen!");
    return 1;
    }


    und das hier: public OnPropUpdate()
    {
    new idx;
    new File: file2;
    new query2[1024];
    // new h;
    for(new h;h!=MAX_HOUSE;h++)
    {
    format(query2,sizeof(query2),"UPDATE `haussystem` SET `hentrancex` = '%f' ,`hentrancey` = '%f' ,`hentrancez` = '%f' ,`hexitx` = '%f', `hexity` = '%f', `hexitz` = '%f', `hhealthx` = '%i' WHERE `houseid`='%i'",
    HouseInfo[h][hEntrancex],HouseInfo[h][hEntrancey],HouseInfo[h][hEntrancez],HouseInfo[h][hExitx],HouseInfo[h][hExity],HouseInfo[h][hExitz],HouseInfo[h][hHealthx], h);
    mysql_query(query2);


    format(query2,sizeof(query2),"UPDATE `haussystem` SET `hhealthy` = '%i',`hhealthz` = '%i', `harmourx` = '%i', `harmoury` = '%i', `harmourz` = '%i', `hOwner` = '%s',`hdiscription` = '%s', `hvalue` = '%i',`hhel` = '%i' WHERE `houseid`='%i'",
    HouseInfo[h][hHealthy],HouseInfo[h][hHealthz],HouseInfo[h][hArmourx],HouseInfo[h][hArmoury],HouseInfo[h][hArmourz], HouseInfo[h][hOwner], HouseInfo[h][hDiscription],HouseInfo[h][hValue],HouseInfo[h][hHel], h);
    mysql_query(query2);


    format(query2,sizeof(query2),"UPDATE `haussystem` SET `harm` = '%i',`hint` = '%i',`hlock` = '%i',`howned` = '%i',`hrooms` = '%i',`hrent` = '%i',`hrentabil` = '%i',`htakings` = '%i',`hdate` = '%i',`hlevel` = '%i' WHERE `houseid`='%i'",
    HouseInfo[h][hArm],HouseInfo[h][hInt],HouseInfo[h][hLock],HouseInfo[h][hOwned],HouseInfo[h][hRooms],HouseInfo[h][hRent],HouseInfo[h][hRentabil],HouseInfo[h][hTakings],HouseInfo[h][hDate],HouseInfo[h][hLevel], h);
    mysql_query(query2);


    }
    idx = 0; // Ab hier uninterresant!
    while (idx < sizeof(BizzInfo)) // Ab hier uninterresant!
    { // Ab hier uninterresant! // Ab hier uninterresant!
    new coordsstring[256]; // Ab hier uninterresant!
    format(coordsstring, sizeof(coordsstring), "%d|%s|%s|%s|%f|%f|%f|%f|%f|%f|%d|%d|%d|%d|%d|%d|%d|%d|%d\n",
    BizzInfo[idx][bOwned],
    BizzInfo[idx][bOwner],
    BizzInfo[idx][bMessage],
    BizzInfo[idx][bExtortion],
    BizzInfo[idx][bEntranceX],
    BizzInfo[idx][bEntranceY],
    BizzInfo[idx][bEntranceZ],
    BizzInfo[idx][bExitX],
    BizzInfo[idx][bExitY],
    BizzInfo[idx][bExitZ],
    BizzInfo[idx][bLevelNeeded],
    BizzInfo[idx][bBuyPrice],
    BizzInfo[idx][bEntranceCost],
    BizzInfo[idx][bTill],
    BizzInfo[idx][bLocked],
    BizzInfo[idx][bInterior],
    BizzInfo[idx][bProducts],
    BizzInfo[idx][bMaxProducts],
    BizzInfo[idx][bPriceProd]);
    if(idx == 0)
    {
    file2 = fopen("bizz.cfg", io_write);
    }
    else
    {
    file2 = fopen("bizz.cfg", io_append);
    }
    fwrite(file2, coordsstring);
    idx++;
    fclose(file2);
    }
    idx = 0;
    while (idx < sizeof(SBizzInfo))
    {
    new coordsstring[256];
    format(coordsstring, sizeof(coordsstring), "%d|%s|%s|%s|%f|%f|%f|%d|%d|%d|%d|%d|%d|%d|%d|%d\n",
    SBizzInfo[idx][sbOwned],
    SBizzInfo[idx][sbOwner],
    SBizzInfo[idx][sbMessage],
    SBizzInfo[idx][sbExtortion],
    SBizzInfo[idx][sbEntranceX],
    SBizzInfo[idx][sbEntranceY],
    SBizzInfo[idx][sbEntranceZ],
    SBizzInfo[idx][sbLevelNeeded],
    SBizzInfo[idx][sbBuyPrice],
    SBizzInfo[idx][sbEntranceCost],
    SBizzInfo[idx][sbTill],
    SBizzInfo[idx][sbLocked],
    SBizzInfo[idx][sbInterior],
    SBizzInfo[idx][sbProducts],
    SBizzInfo[idx][sbMaxProducts],
    SBizzInfo[idx][sbPriceProd]);
    if(idx == 0)
    {
    file2 = fopen("sbizz.cfg", io_write);
    }
    else
    {
    file2 = fopen("sbizz.cfg", io_append);
    }
    fwrite(file2, coordsstring);
    idx++;
    fclose(file2);
    }
    return 1;
    }

    Hey,ho


    ich habe ein Problem undzwar lädt er das hier 20 30 50 mal ich wusste es weil ich es geprintet habe.


    Hier mal der code:
    for(new idx; idx<sizeof(HouseInfo); idx++)
    {
    format(query2, sizeof(query2), "SELECT * FROM `haussystem` WHERE `hID` = %d", idx);
    mysql_query(query2);
    mysql_store_result();
    if(mysql_ping() == 0)
    {
    HouseInfo[idx][hEntrancex] = mysql_GetFloatByInt("haussystem", "hEntrancex", "hID",HouseInfo[idx][hID]);
    HouseInfo[idx][hEntrancey] = mysql_GetFloatByInt("haussystem", "hEntrancey", "hID",HouseInfo[idx][hID]);
    HouseInfo[idx][hEntrancez] = mysql_GetFloatByInt("haussystem", "hEntrancez", "hID",HouseInfo[idx][hID]);
    HouseInfo[idx][hExitx] = mysql_GetFloatByInt("haussystem", "hExitx", "hID",HouseInfo[idx][hID]);
    HouseInfo[idx][hExity] = mysql_GetFloatByInt("haussystem", "hExity", "hID",HouseInfo[idx][hID]);
    HouseInfo[idx][hExitz] = mysql_GetFloatByInt("haussystem", "hExitz", "hID",HouseInfo[idx][hID]);
    HouseInfo[idx][hExitz] = mysql_GetIntByInt("haussystem", "hHealthx", "hID",HouseInfo[idx][hID]);
    HouseInfo[idx][hHealthy] = mysql_GetIntByInt("haussystem", "hHealthy", "hID",HouseInfo[idx][hID]);
    HouseInfo[idx][hHealthz] = mysql_GetIntByInt("haussystem", "hHealthz", "hID",HouseInfo[idx][hID]);
    HouseInfo[idx][hArmourx] = mysql_GetIntByInt("haussystem", "hArmourx", "hID",HouseInfo[idx][hID]);
    HouseInfo[idx][hArmoury] = mysql_GetIntByInt("haussystem", "hArmoury", "hID",HouseInfo[idx][hID]);
    HouseInfo[idx][hArmourz] = mysql_GetIntByInt("haussystem", "hArmourz", "hID",HouseInfo[idx][hID]);
    strmid(HouseInfo[idx][hOwner], mysql_GetStringByInt("haussystem","hOwner","hID",h), 0, 256,256);
    strmid(HouseInfo[idx][hDiscription], mysql_GetStringByInt("haussystem","hDiscription","hID",h), 0, 256,256);
    HouseInfo[idx][hValue] = mysql_GetIntByInt("haussystem", "hValue", "hID",HouseInfo[idx][hID]);
    HouseInfo[idx][hHel] = mysql_GetIntByInt("haussystem", "hHel", "hID",HouseInfo[idx][hID]);
    HouseInfo[idx][hArm] = mysql_GetIntByInt("haussystem", "hArm", "hID",HouseInfo[idx][hID]);
    HouseInfo[idx][hInt] = mysql_GetIntByInt("haussystem", "hInt", "hID",HouseInfo[idx][hID]);
    HouseInfo[idx][hLock] = mysql_GetIntByInt("haussystem", "hLock", "hID",HouseInfo[idx][hID]);
    HouseInfo[idx][hOwned] = mysql_GetIntByInt("haussystem", "hOwned", "hID",HouseInfo[idx][hID]);
    HouseInfo[idx][hRooms] = mysql_GetIntByInt("haussystem", "hRooms", "hID",HouseInfo[idx][hID]);
    HouseInfo[idx][hRent] = mysql_GetIntByInt("haussystem", "hRent", "hID",HouseInfo[idx][hID]);
    HouseInfo[idx][hRentabil] = mysql_GetIntByInt("haussystem", "hRentabil", "hID",HouseInfo[idx][hID]);
    HouseInfo[idx][hDate] = mysql_GetIntByInt("haussystem", "hDate", "hID",HouseInfo[idx][hID]);
    HouseInfo[idx][hLevel] = mysql_GetIntByInt("haussystem", "hLevel", "hID",HouseInfo[idx][hID]);
    }
    mysql_free_result();
    }

    Hi,


    ich benutze das MySQL Plugin von strickenkind und habe nun 26 errors: C:\Dokumente und Einstellungen\Maurice\Desktop\PEG -eGaming\gamemodes\gamemode_2.4.1.pwn(18759) : error 017: undefined symbol "mysql_retrieve_row"
    C:\Dokumente und Einstellungen\Maurice\Desktop\PEG -eGaming\gamemodes\gamemode_2.4.1.pwn(18761) : error 017: undefined symbol "mysql_fetch_field_row"
    C:\Dokumente und Einstellungen\Maurice\Desktop\PEG -eGaming\gamemodes\gamemode_2.4.1.pwn(18764) : error 017: undefined symbol "mysql_fetch_field_row"
    C:\Dokumente und Einstellungen\Maurice\Desktop\PEG -eGaming\gamemodes\gamemode_2.4.1.pwn(18767) : error 017: undefined symbol "mysql_fetch_field_row"
    C:\Dokumente und Einstellungen\Maurice\Desktop\PEG -eGaming\gamemodes\gamemode_2.4.1.pwn(18770) : error 017: undefined symbol "mysql_fetch_field_row"
    C:\Dokumente und Einstellungen\Maurice\Desktop\PEG -eGaming\gamemodes\gamemode_2.4.1.pwn(18773) : error 017: undefined symbol "mysql_fetch_field_row"
    C:\Dokumente und Einstellungen\Maurice\Desktop\PEG -eGaming\gamemodes\gamemode_2.4.1.pwn(18776) : error 017: undefined symbol "mysql_fetch_field_row"
    C:\Dokumente und Einstellungen\Maurice\Desktop\PEG -eGaming\gamemodes\gamemode_2.4.1.pwn(18779) : error 017: undefined symbol "mysql_fetch_field_row"
    C:\Dokumente und Einstellungen\Maurice\Desktop\PEG -eGaming\gamemodes\gamemode_2.4.1.pwn(18782) : error 017: undefined symbol "mysql_fetch_field_row"
    C:\Dokumente und Einstellungen\Maurice\Desktop\PEG -eGaming\gamemodes\gamemode_2.4.1.pwn(18785) : error 017: undefined symbol "mysql_fetch_field_row"
    C:\Dokumente und Einstellungen\Maurice\Desktop\PEG -eGaming\gamemodes\gamemode_2.4.1.pwn(18788) : error 017: undefined symbol "mysql_fetch_field_row"
    C:\Dokumente und Einstellungen\Maurice\Desktop\PEG -eGaming\gamemodes\gamemode_2.4.1.pwn(18791) : error 017: undefined symbol "mysql_fetch_field_row"
    C:\Dokumente und Einstellungen\Maurice\Desktop\PEG -eGaming\gamemodes\gamemode_2.4.1.pwn(18794) : error 017: undefined symbol "mysql_fetch_field_row"
    C:\Dokumente und Einstellungen\Maurice\Desktop\PEG -eGaming\gamemodes\gamemode_2.4.1.pwn(18797) : error 017: undefined symbol "mysql_fetch_field_row"
    C:\Dokumente und Einstellungen\Maurice\Desktop\PEG -eGaming\gamemodes\gamemode_2.4.1.pwn(18799) : error 017: undefined symbol "mysql_fetch_field_row"
    C:\Dokumente und Einstellungen\Maurice\Desktop\PEG -eGaming\gamemodes\gamemode_2.4.1.pwn(18801) : error 017: undefined symbol "mysql_fetch_field_row"
    C:\Dokumente und Einstellungen\Maurice\Desktop\PEG -eGaming\gamemodes\gamemode_2.4.1.pwn(18804) : error 017: undefined symbol "mysql_fetch_field_row"
    C:\Dokumente und Einstellungen\Maurice\Desktop\PEG -eGaming\gamemodes\gamemode_2.4.1.pwn(18807) : error 017: undefined symbol "mysql_fetch_field_row"
    C:\Dokumente und Einstellungen\Maurice\Desktop\PEG -eGaming\gamemodes\gamemode_2.4.1.pwn(18810) : error 017: undefined symbol "mysql_fetch_field_row"
    C:\Dokumente und Einstellungen\Maurice\Desktop\PEG -eGaming\gamemodes\gamemode_2.4.1.pwn(18813) : error 017: undefined symbol "mysql_fetch_field_row"
    C:\Dokumente und Einstellungen\Maurice\Desktop\PEG -eGaming\gamemodes\gamemode_2.4.1.pwn(18816) : error 017: undefined symbol "mysql_fetch_field_row"
    C:\Dokumente und Einstellungen\Maurice\Desktop\PEG -eGaming\gamemodes\gamemode_2.4.1.pwn(18819) : error 017: undefined symbol "mysql_fetch_field_row"
    C:\Dokumente und Einstellungen\Maurice\Desktop\PEG -eGaming\gamemodes\gamemode_2.4.1.pwn(18822) : error 017: undefined symbol "mysql_fetch_field_row"
    C:\Dokumente und Einstellungen\Maurice\Desktop\PEG -eGaming\gamemodes\gamemode_2.4.1.pwn(18825) : error 017: undefined symbol "mysql_fetch_field_row"
    C:\Dokumente und Einstellungen\Maurice\Desktop\PEG -eGaming\gamemodes\gamemode_2.4.1.pwn(18828) : error 017: undefined symbol "mysql_fetch_field_row"
    C:\Dokumente und Einstellungen\Maurice\Desktop\PEG -eGaming\gamemodes\gamemode_2.4.1.pwn(18831) : error 017: undefined symbol "mysql_fetch_field_row"


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



    26 Errors.


    was kann man stattdessen nehmen..


    hier mal die zeilen: format(query, sizeof(query), "SELECT * FROM `haussystem` WHERE `hID` = %d", idx);
    mysql_query(query);
    mysql_store_result();
    if(mysql_retrieve_row())
    {
    mysql_fetch_field_row(val,"hEntrancex");
    HouseInfo[idx][hEntrancex] = floatstr(val);


    mysql_fetch_field_row(val,"hEntrancey");
    HouseInfo[idx][hEntrancey] = floatstr(val);


    mysql_fetch_field_row(val,"hEntrancez");
    HouseInfo[idx][hEntrancez] = floatstr(val);


    mysql_fetch_field_row(val,"hExitx");
    HouseInfo[idx][hExitx] = floatstr(val);


    mysql_fetch_field_row(val,"hExity");
    HouseInfo[idx][hExity] = floatstr(val);


    mysql_fetch_field_row(val,"hExitz");
    HouseInfo[idx][hExitz] = floatstr(val);


    mysql_fetch_field_row(val,"hHealthx");
    HouseInfo[idx][hHealthx] = strval(val);


    mysql_fetch_field_row(val,"hHealthy");
    HouseInfo[idx][hHealthy] = strval(val);


    mysql_fetch_field_row(val,"hHealthz");
    HouseInfo[idx][hHealthz] = strval(val);


    mysql_fetch_field_row(val,"hArmourx");
    HouseInfo[idx][hArmourx] = strval(val);


    mysql_fetch_field_row(val,"hArmoury");
    HouseInfo[idx][hArmoury] = strval(val);


    mysql_fetch_field_row(val,"hArmourz");
    HouseInfo[idx][hArmourz] = strval(val);


    mysql_fetch_field_row(HouseInfo[idx][hOwner],"hOwner");


    mysql_fetch_field_row(HouseInfo[idx][hDiscription],"hDiscription");


    mysql_fetch_field_row(val,"hValue");
    HouseInfo[idx][hValue] = strval(val);


    mysql_fetch_field_row(val,"hHel");
    HouseInfo[idx][hHel] = strval(val);


    mysql_fetch_field_row(val,"hArm");
    HouseInfo[idx][hArm] = strval(val);


    mysql_fetch_field_row(val,"hInt");
    HouseInfo[idx][hInt] = strval(val);


    mysql_fetch_field_row(val,"hLock");
    HouseInfo[idx][hLock] = strval(val);


    mysql_fetch_field_row(val,"hOwned");
    HouseInfo[idx][hOwned] = strval(val);


    mysql_fetch_field_row(val,"hRooms");
    HouseInfo[idx][hRooms] = strval(val);


    mysql_fetch_field_row(val,"hRent");
    HouseInfo[idx][hRent] = strval(val);


    mysql_fetch_field_row(val,"hRentabil");
    HouseInfo[idx][hRentabil] = strval(val);


    mysql_fetch_field_row(val,"hDate");
    HouseInfo[idx][hDate] = strval(val);


    mysql_fetch_field_row(val,"hLevel");
    HouseInfo[idx][hLevel] = strval(val);


    }
    mysql_free_result();

    ok, jetzt geht es aber wenn ich in der tabelle etwas eintrage kommt der fehler wenn ich den server restarte: [MySQL] Error (0): Function: mysql_fetch_field failed, no field data.
    [19.01.2014 20:53:14] [MySQL] Error (0): Function: mysql_fetch_field failed, no field data.
    [19.01.2014 20:53:14] [MySQL] Error (0): Function: mysql_fetch_field failed, no field data.
    hier die zeilen die ich geändert habe new idx;
    mysql_query("SELECT * FROM `haussystem`");
    mysql_store_result();
    if(mysql_num_rows())
    {
    while (idx < sizeof(HouseInfo))
    {
    HouseInfo[idx][hEntrancex] = mysql_GetFloatByString("haussystem", "hEntrancex", "hOwner",HouseInfo[idx][hOwner]);
    HouseInfo[idx][hEntrancey] = mysql_GetFloatByString("haussystem", "hEntrancey", "hOwner",HouseInfo[idx][hOwner]);
    HouseInfo[idx][hEntrancez] = mysql_GetFloatByString("haussystem", "hEntrancez", "hOwner",HouseInfo[idx][hOwner]);


    HouseInfo[idx][hExitx] = mysql_GetFloatByString("haussystem", "hExitx", "hOwner",HouseInfo[idx][hOwner]);
    HouseInfo[idx][hExity] = mysql_GetFloatByString("haussystem", "hExity", "hOwner",HouseInfo[idx][hOwner]);
    HouseInfo[idx][hExitz] = mysql_GetFloatByString("haussystem", "hExitz", "hOwner",HouseInfo[idx][hOwner]);


    HouseInfo[idx][hHealthx] = mysql_GetIntByString("haussystem", "hHealthx", "hOwner",HouseInfo[idx][hOwner]);
    HouseInfo[idx][hHealthy] = mysql_GetIntByString("haussystem", "hHealthy", "hOwner",HouseInfo[idx][hOwner]);
    HouseInfo[idx][hHealthz] = mysql_GetIntByString("haussystem", "hHealthz", "hOwner",HouseInfo[idx][hOwner]);


    HouseInfo[idx][hArmourx] = mysql_GetIntByString("haussystem", "hArmourx", "hOwner",HouseInfo[idx][hOwner]);
    HouseInfo[idx][hArmoury] = mysql_GetIntByString("haussystem", "hArmoury", "hOwner",HouseInfo[idx][hOwner]);
    HouseInfo[idx][hArmourz] = mysql_GetIntByString("haussystem", "hArmourz", "hOwner",HouseInfo[idx][hOwner]);


    HouseInfo[idx][hDiscription] = mysql_GetIntByString("haussystem", "hDiscription", "hOwner",HouseInfo[idx][hOwner]);
    HouseInfo[idx][hValue] = mysql_GetIntByString("haussystem", "hValue", "hOwner",HouseInfo[idx][hOwner]);
    HouseInfo[idx][hHel] = mysql_GetIntByString("haussystem", "hHel", "hOwner",HouseInfo[idx][hOwner]);
    HouseInfo[idx][hLock] = mysql_GetIntByString("haussystem", "hLock", "hOwner",HouseInfo[idx][hOwner]);
    HouseInfo[idx][hInt] = mysql_GetIntByString("haussystem", "hInt", "hOwner",HouseInfo[idx][hOwner]);
    HouseInfo[idx][hOwned] = mysql_GetIntByString("haussystem", "hOwned", "hOwner",HouseInfo[idx][hOwner]);
    HouseInfo[idx][hRooms] = mysql_GetIntByString("haussystem", "hRooms", "hOwner",HouseInfo[idx][hOwner]);
    HouseInfo[idx][hRent] = mysql_GetIntByString("haussystem", "hRent", "hOwner",HouseInfo[idx][hOwner]);
    HouseInfo[idx][hRentabil] = mysql_GetIntByString("haussystem", "hRentabil", "hOwner",HouseInfo[idx][hOwner]);
    HouseInfo[idx][hTakings] = mysql_GetIntByString("haussystem", "hTakings", "hOwner",HouseInfo[idx][hOwner]);
    HouseInfo[idx][hVec] = mysql_GetIntByString("haussystem", "hVec", "hOwner",HouseInfo[idx][hOwner]);
    if(HouseInfo[idx][hVec] == 457)
    {
    HouseInfo[idx][hVec] = 411;
    }
    HouseInfo[idx][hVcol1] = mysql_GetIntByString("haussystem", "hVcol1", "hOwner",HouseInfo[idx][hOwner]);
    HouseInfo[idx][hVcol2] = mysql_GetIntByString("haussystem", "hVcol2", "hOwner",HouseInfo[idx][hOwner]);
    HouseInfo[idx][hDate] = mysql_GetIntByString("haussystem", "hDate", "hOwner",HouseInfo[idx][hOwner]);
    HouseInfo[idx][hLevel] = mysql_GetIntByString("haussystem", "hLevel", "hOwner",HouseInfo[idx][hOwner]);
    HouseInfo[idx][hWorld] = mysql_GetIntByString("haussystem", "hWorld", "hOwner",HouseInfo[idx][hOwner]);
    idx++;
    }
    }
    else
    {
    }
    mysql_free_result();

    Hallo ich habe ein Problem undzwar: [19.01.2014 18:46:01] [MySQL] Error (0): Failed to store result.
    [19.01.2014 18:46:01] [MySQL] Error (0): Function: mysql_num_rows called when no result stored.


    woran liegt es an das hier ? new idx;
    mysql_query("SELECT * FROM `haussystem` WHERE hOwner = '%s'",HouseInfo[idx][hOwner]);
    mysql_store_result();
    if(mysql_num_rows())
    {
    while (idx < sizeof(HouseInfo))
    {
    HouseInfo[idx][hEntrancex] = mysql_GetIntByString("haussystem", "hEntrancex", "hOwner",HouseInfo[idx][hOwner]);
    HouseInfo[idx][hEntrancey] = mysql_GetIntByString("haussystem", "hEntrancey", "hOwner",HouseInfo[idx][hOwner]);
    HouseInfo[idx][hEntrancez] = mysql_GetIntByString("haussystem", "hEntrancez", "hOwner",HouseInfo[idx][hOwner]);
    HouseInfo[idx][hExitx] = mysql_GetIntByString("haussystem", "hExitx", "hOwner",HouseInfo[idx][hOwner]);
    HouseInfo[idx][hExity] = mysql_GetIntByString("haussystem", "hExity", "hOwner",HouseInfo[idx][hOwner]);
    HouseInfo[idx][hExitz] = mysql_GetIntByString("haussystem", "hExitz", "hOwner",HouseInfo[idx][hOwner]);
    HouseInfo[idx][hHealthx] = mysql_GetIntByString("haussystem", "hHealthx", "hOwner",HouseInfo[idx][hOwner]);
    HouseInfo[idx][hHealthy] = mysql_GetIntByString("haussystem", "hHealthy", "hOwner",HouseInfo[idx][hOwner]);
    HouseInfo[idx][hHealthz] = mysql_GetIntByString("haussystem", "hHealthz", "hOwner",HouseInfo[idx][hOwner]);
    HouseInfo[idx][hArmourx] = mysql_GetIntByString("haussystem", "hArmourx", "hOwner",HouseInfo[idx][hOwner]);
    HouseInfo[idx][hArmoury] = mysql_GetIntByString("haussystem", "hArmoury", "hOwner",HouseInfo[idx][hOwner]);
    HouseInfo[idx][hArmourz] = mysql_GetIntByString("haussystem", "hArmourz", "hOwner",HouseInfo[idx][hOwner]);
    HouseInfo[idx][hDiscription] = mysql_GetIntByString("haussystem", "hDiscription", "hOwner",HouseInfo[idx][hOwner]);
    HouseInfo[idx][hValue] = mysql_GetIntByString("haussystem", "hValue", "hOwner",HouseInfo[idx][hOwner]);
    HouseInfo[idx][hHel] = mysql_GetIntByString("haussystem", "hHel", "hOwner",HouseInfo[idx][hOwner]);
    HouseInfo[idx][hLock] = mysql_GetIntByString("haussystem", "hLock", "hOwner",HouseInfo[idx][hOwner]);
    HouseInfo[idx][hInt] = mysql_GetIntByString("haussystem", "hInt", "hOwner",HouseInfo[idx][hOwner]);
    HouseInfo[idx][hOwned] = mysql_GetIntByString("haussystem", "hOwned", "hOwner",HouseInfo[idx][hOwner]);
    HouseInfo[idx][hRooms] = mysql_GetIntByString("haussystem", "hRooms", "hOwner",HouseInfo[idx][hOwner]);
    HouseInfo[idx][hRent] = mysql_GetIntByString("haussystem", "hRent", "hOwner",HouseInfo[idx][hOwner]);
    HouseInfo[idx][hRentabil] = mysql_GetIntByString("haussystem", "hRentabil", "hOwner",HouseInfo[idx][hOwner]);
    HouseInfo[idx][hTakings] = mysql_GetIntByString("haussystem", "hTakings", "hOwner",HouseInfo[idx][hOwner]);
    HouseInfo[idx][hVec] = mysql_GetIntByString("haussystem", "hVec", "hOwner",HouseInfo[idx][hOwner]);
    if(HouseInfo[idx][hVec] == 457)
    {
    HouseInfo[idx][hVec] = 411;
    }
    HouseInfo[idx][hVcol1] = mysql_GetIntByString("haussystem", "hVcol1", "hOwner",HouseInfo[idx][hOwner]);
    HouseInfo[idx][hVcol2] = mysql_GetIntByString("haussystem", "hVcol2", "hOwner",HouseInfo[idx][hOwner]);
    HouseInfo[idx][hDate] = mysql_GetIntByString("haussystem", "hDate", "hOwner",HouseInfo[idx][hOwner]);
    HouseInfo[idx][hLevel] = mysql_GetIntByString("haussystem", "hLevel", "hOwner",HouseInfo[idx][hOwner]);
    HouseInfo[idx][hWorld] = mysql_GetIntByString("haussystem", "hWorld", "hOwner",HouseInfo[idx][hOwner]);
    idx++;
    }
    mysql_free_result();
    }

    Hallo,


    Ich habe ein problem undzwar wenn ich ein race game zocken will gib es einmal ein lenkrad und ein pedal nur ich kann nur 1 sache gleichzeitig machen wieso?


    Ich habe android 2.3