[DJ Tsunami]

1) I've already linked you to the documentation, which has some examples, so I'll just link you to the SBAdmin page. Under Public Properties you can see there's an immunity property, which you can access like this:

PHP Code:

// Find by primary key, which for most models is the ID
$admin = SBAdmin::model()->findByPk(1);

echo $admin->immunity; 


immunity is actually a magic property, which calls the getImmunity method. If you click show next to Source Code, you can see that it returns the highest immunity level of their groups, or 0 if they don't have any groups.

2) sb_server_groups_immunity is the same as SourceMod's sm_group_immunity table. It defines which groups are immune from other groups. The page to configure this hasn't been built yet though.

3) If I understand you correctly, you want to retrieve a ban, including the admin and their immunity.

PHP Code:

// Find using condition and parameters. Since the admin model also has a "name" attribute,
// we specify the table alias for the main model, which by default is "t".
$ban = SBBan::model()->with('admin')->find('t.name = :ban_name', array(':ban_name' => 'ppalex'));

// If $ban->admin is null, it's a CONSOLE ban
if(isset($ban->admin))
{
  echo $ban->admin->immunity;
} 


Note that ->with() applies eager loading, joining the sb_admins table to be able to filter on that too in your condition string. Lazy loading also works:

PHP Code:

// Find by attributes. This only works for attributes of the main model,
// so specifying a table alias would throw an error.
$ban = SBBan::model()->findByAttributes(array('name' => 'ppalex'));

echo $ban->admin->name; 


But of course it would run two queries.

I'll see if I can post some more examples this week.

[ppalex]

Thanks for the detailed answer!

immunity is actually a magic property, ... it returns the highest immunity level of their groups, or 0 if they don't have any groups.

This is that I need!

I had to understand on what basis is determined immunity to use it in my plugin. If interested in SQL it looks for me like

Spoiler

         "SELECT IF(c.length, c.create_time + c.length * 60 - UNIX_TIMESTAMP(), 0) as remaining \
                     , c.length, c.create_time, c.type, c.reason, c.server_id \
                     , IFNULL(a.id, 0), IFNULL(a.name, 'CONSOLE'), MAX(IFNULL(IF(c.server_id, sgs.immunity, sgw.immunity),0)) AS immunity \
                  FROM {{comms}} AS c \
                       LEFT JOIN {{admins}} AS a ON a.id = c.admin_id \
                       LEFT JOIN {{admins_server_groups}} AS asg ON asg.admin_id = c.admin_id \
                       LEFT JOIN {{server_groups}} AS sgw ON sgw.id = asg.group_id \
                       LEFT JOIN {{servers_server_groups}} AS ssg ON ssg.server_id = c.server_id \
                       LEFT JOIN {{server_groups}} AS sgs ON sgs.id = asg.group_id AND sgs.id = ssg.group_id \
                 WHERE c.steam_account_id = %d \
                       AND unban_admin_id IS NULL \
                       AND (c.length = '0' OR c.create_time + c.length * 60 > UNIX_TIMESTAMP()) \
              GROUP BY c.id"

looks terrible, but works good.

[Automicbomb]

Hi. So i installed this to my webserver and to my gameserver (TF2) but when i add web ban, it wont kick the client from server. Is this issue only on my end or is this option still getting wrote?

[Rytis]

Originally Posted by Automicbomb Hi. So i installed this to my webserver and to my gameserver (TF2) but when i add web ban, it wont kick the client from server. Is this issue only on my end or is this option still getting wrote?

It's not really an issue, it's just not implemented yet

[ppalex]

What mean symbols @@ around phrases @@ in translations files?

[DJ Tsunami]

It's explained at the top of the file.

[ppalex]

Originally Posted by DJ Tsunami It's explained at the top of the file.

oh, thanks.
And what i need to think about it, if i see some phrases as "@@phrase@@" on the web pages? Need I remake translation files by running 'yiic message' command?

[ppalex]

for example, even after I ran ./framework/yiic message application/messages/application.php
i have problems with some phrases (look at screenshot). In the same time i have some changes in translations file (part of diff)

-       'Bans' => 'Баны',
+  'Bans' => '@@Баны@@',
   'By' => '@@От@@',
   'Change' => 'Изменить',
   'Click' => '@@Нажать@@',
+  'Close' => '',
   'Command' => 'Команда',
   'Command executed' => 'Команда выполнена',
   'Comment' => '@@Комментарий@@',
   'Comments' => '@@Комментарии@@',
   'Confirm' => '@@Подтвердить@@',
   'Confirm RCON password' => '@@Подтвердите пароль RCON@@',
-       'Players blocked' => 'Заблокировано игроков',
   'Contact' => '@@Связаться@@',

What's wrong?

Should I manually fix this mistakes and make a pull-request?

[DJ Tsunami]

When you see @@ on web pages and the translation between them is correct, you can just remove the @@ and make a pull request. yiic message only adds the @@ when the message is not used anymore, it does not remove them when the message is used again.

You can see this with

    'Comments' => '@@Комментарии@@',

Comments were implemented recently, and it looks like I forgot to remove the @@ for Czech and Russian.

[ppalex]

Originally Posted by DJ Tsunami yiic message only adds the @@ when the message is not used anymore, it does not remove them when the message is used again.

Thanks for the explanation.