|
|
'.$str_headline;
addpregnav('/'.$str_filename.'\?op=rate&uid=\d{1,}&rating=[-]{0,1}\d{1}/');
addpregnav('/'.$str_filename.'\?op=reset_rp&uid=\d{1,}/');
addpregnav('/'.$str_filename.'\?op=save_com&uid=\d{1,}/');
addpregnav('/'.$str_filename.'\?op=load_com&uid=\d{1,}/');
addpregnav('/httpreq_usermenu.php\?op=exp_[fh]ire&id=\d{1,}/');
$str_sql = 'SELECT a.name,a.acctid,rprating,comments_rp_ges,comments,comments_rp,expedition,rprating_data,
ROUND(commentlength / comments) AS comlen,
comments_rp'.($int_rated>0 ? '_ges':'').' / comments AS rp_ratio
FROM accounts a
LEFT JOIN account_extra_info USING(acctid)
LEFT JOIN account_stats USING(acctid)';
$str_count_sql = 'SELECT COUNT(*) AS c FROM accounts LEFT JOIN account_extra_info USING(acctid) LEFT JOIN account_stats USING(acctid)';
$str_sql .= $str_where.' ORDER BY '.$str_orderby.' '.$str_order;
$str_count_sql .= $str_where;
$arr_page_res = page_nav($str_filename.'?orderby='.$str_orderby.'&order='.$str_order.'&search='.urlencode($str_search_in).'&rated='.$int_rated,$str_count_sql);
$str_sql .= ' LIMIT '.$arr_page_res['limit'];
$str_trclass = 'trlight';
$res = db_query($str_sql);
if(db_num_rows($res) == 0) {
$str_out .= '| `iKeine Accounts vorhanden! (Was auch immer du dann hier treibst.. Freak!)`i |
';
}
$int_counter = 0;
while($a = db_fetch_assoc($res)) {
$int_counter++;
// Alle x Zeilen mal ne Headline
if(!(($int_counter+1) % 20)) {
$str_out .= $str_headline;
}
$str_trclass = ('trlight' == $str_trclass ? 'trdark' : 'trlight');
$str_out .= '
| '.$a['acctid'].' |
'.$a['name'].' |
'.$a['comments_rp_ges'].' |
'.$a['comments'].' |
'.$a['comments_rp'].' |
'.$a['comlen'].' |
'.$a['rp_ratio'].' |
|
|
|
';
$str_out .= ' [ +/- ]
[ RP-Posts zurücksetzen! ]
[ Expi `b'.($a['expedition'] ? 'aus':'ein').'schalten`b! ]
[ Kommentare ]
|
';
}
$str_out .= '
`c';
break;
}
page_header('Rollenspiel-Management');
addnav('Zurück');
grotto_nav();
output( $str_out );
page_footer();
?>