phpBB.de

Code: Alles auswählen

#!/bin/bash
# phpBB online stats
#%# family=contrib
#%# capabilities=autoconf

MYOPTIONS=' -uxxxxxxx -pyyyyyyyyy -Dname_of_db'

if [ "$1" = "autoconf" ]; then
        echo yes
        exit 0
fi

if [ "$1" = config ]; then
        echo 'graph_title phpBB users online'
        echo 'graph_args --base 1000 -l 0'
        echo 'graph_vlabel users'
        echo 'graph_category phpBB'
        echo 'userreg.label registered'
        echo 'userreg.draw AREA'
        echo 'userguests.label guests'
        echo 'userguests.draw STACK'
        echo 'graph_total total users'
        echo 'graph_order userreg userguests'
        echo 'graph_info phpBB users online'
        exit 0
fi

function number {
        egrep '[0-9]+'
}

USERREG=$(echo "SELECT COUNT(session_id) FROM phpbb_sessions WHERE (session_time + 900) > UNIX_TIMESTAMP(NOW()) AND phpbb_sessions.session_logged_in=1"  | mysql $MYOPTIONS | number)

USERGUEST=$(echo "SELECT COUNT(DISTINCT session_ip) FROM phpbb_sessions WHERE (session_time + 900) > UNIX_TIMESTAMP(NOW()) AND session_logged_in=0" | mysql $MYOPTIONS | number)

echo "userreg.value "$USERREG
echo "userguests.value "$USERGUEST

Code: Alles auswählen

#!/bin/bash
# phpBB users
#%# family=contrib
#%# capabilities=autoconf

MYOPTIONS=' -uxxxxxxxx -pyyyyyyyyy -Dname_of_db'

if [ "$1" = "autoconf" ]; then
        echo yes
        exit 0
fi

if [ "$1" = config ]; then
        echo 'graph_title phpBB posts'
        echo 'graph_args --base 1000 -l 0'
        echo 'graph_vlabel posts / ${graph_period}'
        echo 'graph_category phpBB'
        echo 'delposts.label deleted posts'
        echo 'delposts.type COUNTER'
        echo 'delposts.draw AREA'
        echo 'delposts.cdef delposts,-1,*'
        echo 'totalposts.label total posts'
        echo 'totalposts.type COUNTER'
        echo 'totalposts.draw AREA'
        echo 'totalposts.cdef totalposts,1,*'
        echo 'graphorder delposts totalposts'
        echo 'graph_period minute'
        echo 'graph_scale no'
        echo 'graph_sums yes'
        exit 0
fi

function number {
        egrep '[0-9]+'
}

TOTPO=$(echo "SELECT MAX(post_id) FROM phpbb_posts"  | mysql $MYOPTIONS | number)

REALPO=$(echo "SELECT COUNT(post_id) FROM phpbb_posts" | mysql $MYOPTIONS | number) 

#18 and 23 are forum_ids of forums that act as a Trash-Can
TRASHPO=$(echo "SELECT COUNT(post_id) FROM phpbb_posts p, phpbb_users u WHERE forum_id IN (18,23) AND u.user_id=p.poster_id AND u.user_level < 1" | mysql $MYOPTIONS | number)

DELPO=$(expr $TOTPO - $REALPO + $TRASHPO)

echo "totalposts.value "$TOTPO
echo "delposts.value "$DELPO