Help house id - 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: Help house id (/showthread.php?tid=642003)

---

Help house id PLEASE - SapMan - 23.09.2017

Well I'm creating a SQlite property system but I have a problem with the id's when I use the / create home command, the house is created just like in the db, every house is assigned an id (as if it were userid) what happens is that if I delete a property from the db suppose that if I delete the house id 1 then when I recreate a house does not assign an available id this case the id 1 is not created if it does not give the id 3. I hope I have explained well, I hope you can help me, thanks.

what I mean is: that if I create a house and there is an id available then it is created in the id (slot).

Note: I'm using INTEGER PRIMARY KEY AUTOINCREMENT

---

Re: Help house id - Kampott - 23.09.2017

If you're using PhpMyAdmin, go to the operations tab and change "AUTO_INCREMENT" to the value you need,
or, if you can only execute sql code, use this:

---