BlackMamba

chiLL & kiLL

I run a TeamSpeak 3 server instead of mumble now. It’s the same ip as the urt server has: 87.106.10.66. Password is chillout.

Server down

2 Kommentare

My server provider has a problem. That’s why chiLL|Bomb could be unreachable today. I hope it will be back in few hours.

Update: Server should be fine now.

I added the map ut4_malibu_beta4. Now all maps of Bagheera’s list should be available on chiLL|Bomb.

I upgraded the bot on chiLL|Bomb. If something going wrong or seems to be odd please inform me.

Here a short short tutorial how to add a new app to twitter:

1. Go to https://dev.twitter.com/apps/new and login if you are not logged in already
2. Fill out the following form:

HowTo: Adding app to twitter account

Create an application


So you should get the following:
Create the access tokens for twitter api
3. Accept the “Developer Rules of the Road”, type in the captcha, and click on “Create your Twitter application” button.
4. Now you should see this page
Adding app to twitter - overview

Overview


5. Go to “Settings” and change the application type to “Read and Write” (and click on “Update this Twitter application’s settings” to save your change):
Changing application type of a twitter app

Changing application type


6. Go back to “Details”, scroll down, and create your access token by clicking “Create my access token”:
Create access tokens (twitter api)

Create your access tokens


7. Now you have all tokens you need, both consumer tokens and both access tokens. The consumer tokens identifying your application and the access tokens allows your application to access your twitter account:
Consumer and access tokens (twitter api)

Your consumer and access tokens


(The tokens you can see in the image are not vaild anymore of course.)

This how-to is helpfull if you want to use my twitter plugin for b3.

The following sql statement will give you a list of your admins with a counter, how many bans, kicks and warnings they imposed.

select
    ifnull(c.name, 'b3') as name,
    sum(case when type = 'Ban' then 1 else 0 end) as ban,
    sum(case when type = 'TempBan' then 1 else 0 end) as tempban,
    sum(case when type = 'Kick' then 1 else 0 end) as kick,
    sum(case when type = 'Warning' then 1 else 0 end) as warning
from
    penalties p
    left join
    clients c
        on
        p.admin_id = c.id
where
    p.inactive = 0
    and
    p.type != 'Notice'
group by
    c.name
order by
    count(*) desc
;

There are new maps on chiLL|Bomb available:

If you have any comments on the new maps use the forum. I’m happy about each comment.

Thank you very much, Bagheera, for your effort!

chiLL & kiLL

There are no new news about Urban Terror HD since months. Perhaps they want UrT HD to be the new Duke Nukem Forever.

Sometimes for me it’s interesting if a player is banned by two different admins due to cheating. Such players a highly suspicious to be real cheaters. Because of using b3 bot I can see the reasons for the bans in the database. I assume that reasons, which have the word wallhack, wh, aimbot, mombot or hax in it or a word starting with cheat or hack are reasons for cheating. There is an easy SQL statement to get such players (the statement shows only the players, which have at least one ban in the last month, I don’t want to get old cases):

select
    p.client_id,
    c.name
from
    penalties p
    join
    clients c
        on
        c.id = p.client_id
where
    p.type = 'TempBan'
    and
    p.admin_id > 0
    and
    (
        lower(p.reason) rlike '[[:<:]]cheat|hack'
        or
        lower(p.reason) rlike '[[:<:]]wallhack|wh|aimbot|mombot|hax[[:>:]]'
    )
    and
    p.inactive = 0
group by
    p.client_id,
    c.name
having
    max(p.admin_id)!=min(p.admin_id)
    and
    max(p.time_add) > unix_timestamp(date_add(now(), interval -1 month))
;

Hier ein rudimentärer Versuch, ein deutsches Wiki für UrT aufzubauen: bmamba.de/wiki.