SA-MP Forums Archive
Get a field on OnPlayerEnterVehicle - 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: Get a field on OnPlayerEnterVehicle (/showthread.php?tid=201448)


Get a field on OnPlayerEnterVehicle - ajwar - 21.12.2010

Hi, i want to get vehicles i am entering in, ID field in mysql, how should i do that?

Re: Get a field on OnPlayerEnterVehicle - Rachael - 21.12.2010

create a field ( column ) in your table called `ID` or something
if you use phpmyadmin, go to the `index` icon, and create an index on the column
when you have done this, edit the field, under 'extra' you can select 'auto increment'

(note: there is a way to do this with a query, check your SQL syntax guide place )

Now every time you INSERT INTO your table, the row will be assigned a unique ID number, which you can retrieve with
pawn Код:
mysql_insert_id();


Re: Get a field on OnPlayerEnterVehicle - ajwar - 21.12.2010

Thank's for post. But the problem is that, I allready have everything you said. I load vehicles using loop and every thing is just fine. But when i connect to server and i wan't to check if vehicle is locked i need to take information from the db. I need to SELECT the current vehicle's ID from the DB to get other fields using this:

pawn Код:
format(Query, sizeof(Query), "SELECT * FROM vehicles WHERE ID= %d", HERE_IS_SOMETHING_I_CANT_GET);


Re: Get a field on OnPlayerEnterVehicle - Rachael - 21.12.2010

then you need to store the sql ID in the vehicle array, and use the samp vehicle ID to get the sql ID, and use this in your query.

Really you should be using SQL to load the vehicles, and the array to manage locked / unlocked etc, but its your script .. so

Re: Get a field on OnPlayerEnterVehicle - ajwar - 21.12.2010

pawn Код:
new Query[256];
    for(new id; id < MAX_VEHICLES; id++) // Makes an loop so all vehicles get loaded.
    {
        format(Query, sizeof(Query), "SELECT * FROM vehicles WHERE ID= %d", id);
        mysql_query(Query); // Querys the "Query" Variable.
        mysql_store_result(); // Stores the result from Query
        if(mysql_num_rows()) // Checks if theres anyrow.
        if(mysql_fetch_row_format(Query,"|"))
        {
            sscanf(Query, "p<|>e<ds[25]dffffdddddddddddddddddddds[20]s[20]>",vInfo[id]);
This is where i load vehicles, but later the information i get here not works. That's the main problem.

Re: Get a field on OnPlayerEnterVehicle - ajwar - 21.12.2010

Anyone can help how to get information on other callbacks?

Re: Get a field on OnPlayerEnterVehicle - ajwar - 25.12.2010

No one?