Beiträge von DJ Deagle

  • Inputline too long?!

    Huhuu,


    habe ein CreateHouse-stock. Darin ist ein MySQL-Query, welcher angeblich zulang für PAWNO ist...
    Hier der Error:
    C:\Users\Zinne\Desktop\samp03x_svr_R1-2_win32\gamemodes\Lifestyle Roleplay\Lifestyle.pwn(16121) : error 075: input line too long (after substitutions)
    Pawn compiler 3.2.3664 Copyright (c) 1997-2006, ITB CompuPhase



    1 Error.


    Query:
    new query[2000];
    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`,\
    `Renter6`, `Kasse`)VALUES('%d', '%f', '%f', '%f', '%d', '%d', 'Niemand', '0', '%d', '%d', '%d', '%f', '%f', '%f', '1', '100',\
    /*ERRORZEILE*/ 'Niemand', 'Niemand', 'Niemand', 'Niemand', 'Niemand', 'Niemand', '0')"\
    ,rows,X,Y,Z,Level,Price,Rooms,Interior,IntID[Interior][0],InteriorList[Interior][0], InteriorList[Interior][1], InteriorList[Interior][2]);
    mysql_query(query);


    Warum geht des niet?


    lg

  • ProxDetector Funktion

    forward ProxDetector(Float:radi, playerid, string[],col1,col2,col3,col4,col5);
    public ProxDetector(Float:radi, playerid, string[],col1,col2,col3,col4,col5)
    {
    if(IsPlayerConnected(playerid))
    {
    new Float:posx, Float:posy, Float:posz;
    new Float:oldposx, Float:oldposy, Float:oldposz;
    new Float:tempposx, Float:tempposy, Float:tempposz;
    GetPlayerPos(playerid, oldposx, oldposy, oldposz);
    for(new i = 0; i < MAX_PLAYERS; i++)
    {
    if(IsPlayerConnected(i) && (GetPlayerVirtualWorld(playerid) == GetPlayerVirtualWorld(i)))
    {
    GetPlayerPos(i, posx, posy, posz);
    tempposx = (oldposx -posx);
    tempposy = (oldposy -posy);
    tempposz = (oldposz -posz);
    if (((tempposx < radi/16) && (tempposx > -radi/16)) && ((tempposy < radi/16) && (tempposy > -radi/16)) && ((tempposz < radi/16) && (tempposz > -radi/16))) // If the player is within 16 meters
    {
    SendClientMessage(i, col1, string);
    }
    else if (((tempposx < radi/8) && (tempposx > -radi/8)) && ((tempposy < radi/8) && (tempposy > -radi/8)) && ((tempposz < radi/8) && (tempposz > -radi/8))) // within 8 meters
    {
    SendClientMessage(i, col2, string);
    }
    else if (((tempposx < radi/4) && (tempposx > -radi/4)) && ((tempposy < radi/4) && (tempposy > -radi/4)) && ((tempposz < radi/4) && (tempposz > -radi/4))) //4 meters
    {
    SendClientMessage(i, col3, string);
    }
    else if (((tempposx < radi/2) && (tempposx > -radi/2)) && ((tempposy < radi/2) && (tempposy > -radi/2)) && ((tempposz < radi/2) && (tempposz > -radi/2))) //2 meters
    {
    SendClientMessage(i, col4, string);
    }
    else if (((tempposx < radi) && (tempposx > -radi)) && ((tempposy < radi) && (tempposy > -radi)) && ((tempposz < radi) && (tempposz > -radi))) //1 meter
    {
    SendClientMessage(i, col5, string);
    }
    }
    else
    {
    SendClientMessage(i, col1, string);
    }
    }
    }
    return 1;
    }


    ganz unten in den Script und fertig.


    P.S.: Das gehört in den Scriptingbereich ;)

  • Haussystem klappt nit


    Des klappt nicht... InGame ist kein Pickup, ich kann kein /buyhouse machen NIX!


    Hier die Log:

    Code
    [12:33:21] CMySQLHandler::Query(SELECT `Bought` FROM `haeuser` WHERE `ID` = '24') - Successfully executed.
[12:33:21] >> mysql_store_result( Connection handle: 1 )
[12:33:21] CMySQLHandler::StoreResult() - Result was stored.
[12:33:21] >> mysql_fetch_int( Connection handle: 1 )
[12:33:21] >> mysql_free_result( Connection handle: 1 )
[12:33:21] CMySQLHandler::FreeResult() - Result was successfully free'd.


    24? Es gibt nur 1 Hau, aber das wird nicht geladen...


    Was is da looos?!


    /e MySQL-Log
    /e² MySQL Log in CODE eingefügt