Mysql help (i don't really know how to resolve it) EDITED - 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 help (i don't really know how to resolve it) EDITED (/showthread.php?tid=611232)

---

Mysql help (i don't really know how to resolve it) EDITED - Zeus666 - 03.07.2016

Hi. I have an Admin Jail script, connected to database. When player is not in adminjail he is pJailed = 0

when he is in AdminJail he is pJailed = 1


but, in mysql, at pJailed section, to me it shows his TIME, not if he is ajailed or not.


I want to make a table where to every account it will show

like in this picture http://i.imgur.com/LiFTqNT.png

1. [XX/ZZ/YYYY - Admin : [%s] - Time : [%d] - Reason : [%s]
2. [XX/ZZ/YYYY - Admin : [%s] - Time : [%d] - Reason : [%s]


but this for every player, like adminjail log per account.

And when he dies I don't know how to make to put him back to adminjail until his timer goes to 0.


When he quits and comes back, he falls from air.


Can you help me? Thank you

---

Re: Mysql help (i don't really know how to resolve it) EDITED - Zeus666 - 04.07.2016

halp...

---

Re: Mysql help (i don't really know how to resolve it) EDITED - [cS]Owain - 04.07.2016

You need to provide us the code you using too.

---

Re: Mysql help (i don't really know how to resolve it) EDITED - Zeus666 - 04.07.2016

Tell me what code you need

---