SA-MP Forums Archive
Problem with vehicles from MySQL - Printable Version

+- SA-MP Forums Archive (https://sampforum.blast.hk)
+-- Forum: SA-MP Scripting and Plugins (https://sampforum.blast.hk/forumdisplay.php?fid=8)
+--- Forum: Scripting Help (https://sampforum.blast.hk/forumdisplay.php?fid=12)
+---- Forum: Help Archive (https://sampforum.blast.hk/forumdisplay.php?fid=89)
+---- Thread: Problem with vehicles from MySQL (/showthread.php?tid=97233)


Problem with vehicles from MySQL - virtualmarc - 13.09.2009

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.


Re: Problem with vehicles from MySQL - virtualmarc - 13.09.2009

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

Re: Problem with vehicles from MySQL - [eLg]Timmy - 13.09.2009



Re: Problem with vehicles from MySQL - virtualmarc - 13.09.2009

mhh I removed it, but the client crashes!

Re: Problem with vehicles from MySQL - virtualmarc - 14.09.2009

/PUSH