Donate to the B3 fund!

"even a small donation helps!"
Donate with PayPal!
Echelon v2 is not yet officially released! If you cannot get this dev-version installed, revert to version 1 as available in our download section.

Author Topic: Changing the mysql query that showed admins name.  (Read 1537 times)

Offline SanKen

  • Sr. Member
  • ****
  • Posts: 212
    • ProGaming - Only Multigaming is the most important
Changing the mysql query that showed admins name.
« on: December 21, 2011, 09:06:29 PM »
Code: sql [Select]

SELECT SQL_CACHE c.id as client_id, c.ip, c.name, p.type, p.time_add, p.time_expire, p.reason, p.duration FROM penalties p LEFT JOIN clients c ON p.client_id = c.id WHERE p.inactive = 0 AND p.type != 'Warning' AND p.type != 'Notice' AND (p.time_expire = -1 OR p.time_expire > $time)


I would like to pubbanslist also showed that the name of the admin banned.
query is the files https://github.com/SanKen/echelon/blob/version2/echelon/pubbans.php
example
Code: [Select]
Client Ban-id Type Added Duration Expires Reason Admins
plz help me :)
just about the mysql query. php add yourself
Very sorry for my English I do not know him enough to be understood.
That is why I use the google translator.

Offline SanKen

  • Sr. Member
  • ****
  • Posts: 212
    • ProGaming - Only Multigaming is the most important
Re: Changing the mysql query that showed admins name.
« Reply #1 on: December 22, 2011, 12:28:51 PM »
Please remove the topic. Resolved
Very sorry for my English I do not know him enough to be understood.
That is why I use the google translator.

Offline Courgette

  • Senior Dev.
  • Hero Member
  • *
  • Posts: 4883
    • Github repository
Re: Changing the mysql query that showed admins name.
« Reply #2 on: December 22, 2011, 01:37:50 PM »
Instead or removing the topic, could you explain how you solved it as it might help other community members in the future

Offline SanKen

  • Sr. Member
  • ****
  • Posts: 212
    • ProGaming - Only Multigaming is the most important
Re: Changing the mysql query that showed admins name.
« Reply #3 on: December 22, 2011, 02:23:13 PM »
Write the solution, if I finish I have another problem, do not show me bans given by b3

Here is a new query
Code: sql [Select]
"SELECT SQL_CACHE c.id as client_id, c.name, p.id as ban_id, p.type, p.time_add, p.time_expire, p.reason, p.duration, cA.name as AdminName FROM penalties p LEFT JOIN clients c ON p.client_id = c.id INNER JOIN clients cA ON p.admin_id = cA.id WHERE p.inactive = 0 AND p.type != 'Warning' AND p.type != 'Notice' AND (p.time_expire = -1 OR p.time_expire > $time)"
« Last Edit: December 22, 2011, 02:25:19 PM by SanKen »
Very sorry for my English I do not know him enough to be understood.
That is why I use the google translator.

 


Rate this page +1 at Google Search