MYSQL Loading problem - Printable Version

MYSQL Loading problem - 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)
+--- Thread: MYSQL Loading problem (/showthread.php?tid=452011)

MYSQL Loading problem - MattSlater - 19.07.2013

pawn Код:

mysql_function_query(MainPipeline, "SELECT * FROM `faction_vehicles`",  true, "OnQueryFinish", "i", THREAD_LOAD_FACVEHS);

Okay, I have these faction vehicles I load using mysql and they do load etc, but the problem is that when it loads a vehicle that is in "veh_slot" 0 from the database it will put it into the 1st slot instead of the 0th slot, so it goes up one which messes all the faction vehicles up, so how can I fix this?

Thanks

OnQueryFinish loading: http://pastebin.com/Lg2aNTZj

Re: MYSQL Loading problem - MattSlater - 21.07.2013

Bump?

Re: MYSQL Loading problem - MattSlater - 26.07.2013

Bump

Re: MYSQL Loading problem - MattSlater - 28.07.2013

Nobody can be bothered to help me, urgh please

Re: MYSQL Loading problem - Konstantinos - 28.07.2013

I didn't really understand what it's going on. By the way, is the fac_id auto-incremented?

Re: MYSQL Loading problem - MattSlater - 02.08.2013

Quote:

Originally Posted by _Zeus

I didn't really understand what it's going on. By the way, is the fac_id auto-incremented?

Basically, say in the database I have a vehicle for faction ID 1 and there is 50 maximum vehicle slots per faction, the vehicle is in vehicle slot 5. When it loads the vehicle, it will be in vehicle slot 6? Yet in the database it is listed down as 5, so it goes up.

And no it isnt auto-increment.