The next page SQLite - 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: The next page SQLite (/showthread.php?tid=653531)

---

The next page SQLite - Daynox12 - 06.05.2018

Hi, I need to know how to create a dialog where it shows certain data but with several example pages:
I write the clans command assuming there are 80 clans that appear only 20 in the first dialogue and with a button that says + clans, showing the following clans. I use SQLite I think the OFFSET function is used.

I await your answers.

---

Re: The next page SQLite - Logic_ - 08.05.2018

Run a query and select clans with limit 21, show the first two but store the 21st row id in a global array, when player presses the button for the next page, run a query like before but IDs must be more than the ID which is stored in that array. That's the only thing that I can think off :P

---