[virtualmarc]

I want to read out my vehicles from a MySQL Database.
This is my Source Code:

pawn Код:

new carqry[100],num_cars,i,carvid[100],carx[100],cary[100],carz[100],carangle[100],carcol1[100],carcol2[100];
    format(carqry,sizeof(carqry),"SELECT * FROM cars");
    samp_mysql_query(carqry);
    samp_mysql_store_result();
    num_cars=samp_mysql_num_rows();
    i=1;
    while(i<num_cars)
    {
      samp_mysql_get_field("vid", carvid);
      samp_mysql_get_field("x", carx);
      samp_mysql_get_field("y", cary);
      samp_mysql_get_field("z", carz);
      samp_mysql_get_field("angle", carangle);
      samp_mysql_get_field("color1", carcol1);
      samp_mysql_get_field("color2", carcol2);
      AddStaticVehicle(carvid, carx, cary, carz, carangle, carcol1, carcol2);
      i=i+1;
    }
    samp_mysql_free_result();

But I get this Error-Messages:

Quote:

C:\Dokumente und Einstellungen\Marc\Desktop\samp02Xserver.win32\gam emodes\vmtek-rl.pwn(389) : error 035: argument type mismatch (argument 1) C:\Dokumente und Einstellungen\Marc\Desktop\samp02Xserver.win32\gam emodes\vmtek-rl.pwn(754) : warning 203: symbol is never used: "AutoInfo" Pawn compiler 3.2.3664 Copyright © 1997-2006, ITB CompuPhase 1 Error.

[virtualmarc]

I've got it

This is my code (only the server crashed, because we had over 23000 Cars in the Database )

pawn Код:

new carqry[100],num_cars,carvid[100],id[100],carx[100],cary[100],carz[100],carangle[100],carcol1[100],carcol2[100],resultline[1024],i,status[100];
    format(carqry,sizeof(carqry),"SELECT * FROM cars");
    samp_mysql_query(carqry);
    samp_mysql_store_result();
    num_cars=samp_mysql_num_rows();
    i=0;
    while(samp_mysql_fetch_row(resultline))
    {
        i=i+1;
        samp_mysql_strtok(id,"|",resultline);
        samp_mysql_strtok(carvid,"|","");
        samp_mysql_strtok(carx,"|","");
        samp_mysql_strtok(cary,"|","");
        samp_mysql_strtok(carz,"|","");
        samp_mysql_strtok(carangle,"|","");
        samp_mysql_strtok(carcol1,"|","");
        samp_mysql_strtok(carcol2,"|","");
        CreateVehicle(strval(carvid), floatstr(carx), floatstr(cary), floatstr(carz), floatstr(carangle), strval(carcol1), strval(carcol2), 0);
    }
    format(status,sizeof(status),"%d Autos geladen!", i);
    print(status);
    samp_mysql_free_result();

ok doesn't work. the server crashes on load but if i comment this out it works

[[eLg]Timmy]

• Quote:

  Originally Posted by [RAZ ADreNaLiNe-DJ ] samp_mysql_free_result() => DON'T USE IT, IT WILL CRASH YOUR SERVER !!!

  ?

[virtualmarc]

mhh I removed it, but the client crashes!

[virtualmarc]

/PUSH