SQLite banned problem - Printable Version

SQLite banned 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: SQLite banned problem (/showthread.php?tid=628403)

SQLite banned problem - BrianFaria - 10.02.2017

Hi, well, I want to see the reason for the ban, but I can not do it, can you help me? Thank you

Re: SQLite banned problem - BrianFaria - 10.02.2017

Bump

Re: SQLite banned problem - Infinity - 10.02.2017

Please read some tutorials on how to use sqlite. You're executing the query twice, and thus only fetch the first of two results.

Also read the rules, bumping in less than an hour is not allowed.

Re: SQLite banned problem - BrianFaria - 10.02.2017

bump

Re: SQLite banned problem - Mic_H - 10.02.2017

What do you want to do with this script?

Refer: https://sampforum.blast.hk/showthread.php?tid=262417
https://sampforum.blast.hk/showthread.php?tid=476204
https://sampforum.blast.hk/showthread.php?tid=449536
https://sampforum.blast.hk/showthread.php?tid=278188

Re: SQLite banned problem - BrianFaria - 10.02.2017

I want the reason to appear in the dialog, obviously, I did the complete code but I did not put it here, but it is necessary, and I know SQLite, I just have that doubt.

Re: SQLite banned problem - Mic_H - 10.02.2017

From the looks of it, you are 'trying' to first retrieve 100 bans in descending order by names, then trying to get their ban reason one by one...

PHP код:



format(query,sizeof(query),"SELECT DISTNCT `NAME`, ADMIN, REASON FROM `BANNED` ORDER BY `NAME` DESC limit 100");

If You are looking for the last 100 bans, you should either use Order by date or ID..

Re: SQLite banned problem - BrianFaria - 10.02.2017

No, you do not understand, I'm just trying to get the table "reason" in the dialogue, but I can not.

Re: SQLite banned problem - BrianFaria - 10.02.2017

Solved.