Jump to content

SaLiErY

Membru
  • Posts

    126
  • Joined

  • Last visited

Posts posted by SaLiErY

  1. [pawn]public LoadSQLProperty()

    {

    new arrCoords[30][32];

    new sql[400], row[512];

    format(sql, sizeof(sql), "SELECT COUNT(*) FROM property");

    mysql_query(sql);

    //if (DEBUG) SQLLog(sql);

    mysql_store_result();

    mysql_fetch_row(row);

    totalhouses = strval(row);

    mysql_free_result();

    for (new idx=0; idx<totalhouses; idx++)

    {

        format(sql, sizeof(sql), "SELECT * FROM property WHERE id=%d", idx+1);

        mysql_query(sql);

    //if (DEBUG) SQLLog(sql);

        mysql_store_result();

        if (mysql_num_rows() > 0)

    {

            mysql_fetch_row_format(row, "|");

        explode(row, field, "|");

        mysql_free_result();

    HouseInfo[idx][hEntrancex] = floatstr(arrCoords[1]);

    HouseInfo[idx][hEntrancey] = floatstr(arrCoords[2]);

    HouseInfo[idx][hEntrancez] = floatstr(arrCoords[3]);

    HouseInfo[idx][hExitx] = floatstr(arrCoords[4]);

    HouseInfo[idx][hExity] = floatstr(arrCoords[5]);

    HouseInfo[idx][hExitz] = floatstr(arrCoords[6]);

    HouseInfo[idx][hHealthx] = strval(arrCoords[7]);

    HouseInfo[idx][hHealthy] = strval(arrCoords[8]);

    HouseInfo[idx][hHealthz] = strval(arrCoords[9]);

    HouseInfo[idx][hArmourx] = strval(arrCoords[10]);

    HouseInfo[idx][hArmoury] = strval(arrCoords[11]);

    HouseInfo[idx][hArmourz] = strval(arrCoords[12]);

    strmid(HouseInfo[idx][hOwner], arrCoords[13], 0, strlen(arrCoords[13]), 255);

    strmid(HouseInfo[idx][hDiscription], arrCoords[14], 0, strlen(arrCoords[14]), 255);

    HouseInfo[idx][hValue] = strval(arrCoords[15]);

    HouseInfo[idx][hHel] = strval(arrCoords[16]);

    HouseInfo[idx][hArm] = strval(arrCoords[17]);

    HouseInfo[idx][hInt] = strval(arrCoords[18]);

    HouseInfo[idx][hLock] = strval(arrCoords[19]);

    HouseInfo[idx][hOwned] = strval(arrCoords[20]);

    HouseInfo[idx][hRooms] = strval(arrCoords[21]);

    HouseInfo[idx][hRent] = strval(arrCoords[22]);

    HouseInfo[idx][hRentabil] = strval(arrCoords[23]);

    HouseInfo[idx][hTakings] = strval(arrCoords[24]);

    HouseInfo[idx][hVec] = strval(arrCoords[25]);

              if(HouseInfo[idx][hVec] == 457)

    {

    HouseInfo[idx][hVec] = 411;

    }

    HouseInfo[idx][hVcol1] = strval(arrCoords[26]);

    HouseInfo[idx][hVcol2] = strval(arrCoords[27]);

    HouseInfo[idx][hDate] = strval(arrCoords[28]);

    HouseInfo[idx][hLevel] = strval(arrCoords[29]);

    printf("HouseInfo:%d Owner:%s hTakings %d hVec %d",idx,HouseInfo[idx][hOwner],HouseInfo[idx][hTakings],HouseInfo[idx][hVec]);

    }

    }

    return 1;

    }[/pawn]

    deci nu imi citeste casele deci in baza de date am bagat casele help pls!!!

  2. Buna sa fiu sincer dupa ce am "rupt internetu in 2" am gasit un tutorial de gangzonewar cum sa faci dar imi da urmatorele erori

    have a program when i compile  have 4 error pls help fix the error is

    (652) : error 017: undefined symbol "ZoneInfo"
    (653) : error 017: undefined symbol "ZoneInfo"
    (654) : error 017: undefined symbol "ZoneInfo"
    (2543) : error 017: undefined symbol "ZoneInfo"
    and the line is 652 
    new ZoneAttacker[sizeof(ZoneInfo)] = {-1, ...};
    653 
    new ZoneAttackTime[sizeof(ZoneInfo)];
    654 
    new ZoneDeaths[sizeof(ZoneInfo)];
    2543
    stock IsPlayerInZone(playerid, zoneid)
    {
        new Float:x, Float:y, Float:z;
        GetPlayerPos(playerid, x, y, z);
        return (x > ZoneInfo[zoneid][zMinX] && x < ZoneInfo[zoneid][zMaxX] && y > ZoneInfo[zoneid][zMinY] && y < ZoneInfo[zoneid][zMaxY]);
    }

    P.S tutorialu lam luat de aici http://forum.sa-mp.com/showthread.php?t=276352

  3. salut am lucrat la comanda de kick putin am facut TOT ca dialog si am o mare problema cand e sa apara in log cine la cine a da kick apare maxim 31 de caractere in mod normal al trb sa apara

    %s was kicked by %s, reason: %s (%d-%d-%d)

    dar imi apare dor va rog ajutatima sa fac sa apara tot!

    %s was kicked by %s

  4. stuntman daca nu ar fi baza de date creat ar da erore la mysql_select_db am toate setariile calumea facut dar nu stiu dc nu imi salveaza datele de pe cont si ma enerveaza de 5 zile ma chinui si nu reusesc sa fac sa merga calumea

  5. sal all  folosesc mai nou modu reaven roleplay versiunea pe baza de date mysql si cand ma inregistrez contu imi ramene salvat dar nu mi se salveaza datele care ar putea fi problema

    va rog ajutatima

    Multumesc Anticipat

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue. For more details you can also review our Terms of Use and Privacy Policy.