SQLite banned problem
#1

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

Bump
Reply
#3

Bump
Reply
#4

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.
Reply
#5

bump
Reply
#6

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
Reply
#7

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.
Reply
#8

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..
Reply
#9

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

Solved.
Reply


Forum Jump:


Users browsing this thread: 1 Guest(s)