Masinile din baza de date

[tsubasa11]

Buna.... Pentru cei care ma pot ajuta uitati ce am incercat :

In functia OnGameModeInit() am adaugat niste masini care le scot din baza de date asa:

mysql_connect(MYSQL_HOST,MYSQL_USER,MYSQL_DB,MYSQL_PASS);


  mysql_debug(1);

    new string22[556];
    format(string22, sizeof(string22), "SELECT * FROM `vehicles`");
    mysql_query(string22);

    mysql_store_result();
    new rows;
    rows = mysql_num_rows();



    new unu;
    unu=1;

    new string123[556];


    new vektor2[556];
    
    new model;
    new Float:x;
    new Float:y;
    new Float:z;
    new Float:angle;
    new color1;
    new color2;


    mysql_debug(1);
    
mysql_free_result();

    while(unu<=rows)
    {

    
    format(string123, sizeof(string123), "SELECT `model`, x`, `y`, `z`, `angle`, `color1`, `color2`  FROM `users` WHERE `id` = '%d'",unu);
    mysql_query(string123);

    mysql_store_result();


    mysql_fetch_row(vektor2);

    mysql_fetch_field_row(string123, "model");
    model = strval(string123);

    mysql_fetch_field_row(string123, "x");
    x = strval(string123);

    mysql_fetch_field_row(string123, "y");
    y = strval(string123);

    mysql_fetch_field_row(string123, "z");
    z = strval(string123);

    mysql_fetch_field_row(string123, "angle");
    angle = strval(string123);
    
    mysql_fetch_field_row(string123, "color1");
    color1 = strval(string123);
    
    mysql_fetch_field_row(string123, "color2");
    color2 = strval(string123);
    

    

     AddStaticVehicle(model,x,y,z,angle,color1,color2);


    mysql_free_result();

    unu=unu+1;
    }

Nu adauga deloc masinile .




Nu stiu, oare de ce ?

[FarSe.]

mysql_connect(MYSQL_HOST,MYSQL_USER,MYSQL_DB,MYSQL_PASS);

    mysql_debug(1);
    mysql_query("SELECT * FROM `vehicles`");
    new Float:x,        Float:y,        Float:z,        Float:angle,
        model,          color1,         color2,
        string123[50];
    mysql_store_result();
    while(mysql_retrieve_row())
    {
        mysql_fetch_field_row(string123, "model");
        model = strval(string123);

        mysql_fetch_field_row(string123, "x");
        x = floatstr(string123);

        mysql_fetch_field_row(string123, "y");
        y = floatstr(string123);

        mysql_fetch_field_row(string123, "z");
        z = floatstr(string123);

        mysql_fetch_field_row(string123, "angle");
        angle = floatstr(string123);
        
        mysql_fetch_field_row(string123, "color1");
        color1 = strval(string123);
        
        mysql_fetch_field_row(string123, "color2");
        color2 = strval(string123);

        AddStaticVehicle(model,x,y,z,angle,color1,color2);
        printf("DEBUG: %d,%.2f,%.2f,%.2f,%.2f,%d,%d",model,x,y,z,angle,color1,color2);//pe asta o poti sterge dupa
    }
    mysql_free_result();

[tsubasa11]

Iti multumesc muult ...

Esti foarte bun !

[Roberteu11]

Pai normal ca nu-ti mergea daca tu la X,Y,Z,Angle nu foloseai Float.

[tsubasa11]

Hmmm.... da am vauzut ca am gresit acolo.
Nu stiu, poate mergea si cum am facut eu daca puneam float :P ...

Dar oricum mersi frumos !