phpBB.de - Die deutsche phpBB-Community
https://www.phpbb.de/community/
Code: Alles auswählen
// Beginn Member Number on Index
$member_num = $poster_id;
if ($member_num > 52)
{
($member_num -= 51);
}
elseif ($member_num == 2)
{
$member_num = 1;
}
// End Member Number on Index if user != bot und if user != anonymous abfragen.
Code: Alles auswählen
$sql_array = array(
'SELECT' => 'COUNT(u.user_id) AS member_id',
'FROM' => array(USERS_TABLE => 'u'),
'LEFT_JOIN' => array(
array(
'FROM' => array(GROUPS_TABLE => 'g'),
'ON' => 'g.group_id = u.group_id',
)),
'WHERE' => $db->sql_in_set('g.group_name', array('BOTS', 'GUESTS'), true) .
' AND u.user_id <> ' . ANONYMOUS .
' AND u.user_id <= ' . (int)$poster_id,
);
$sql = $db->sql_build_query('SELECT', $sql_array);
$result = $db->sql_query_limit($sql, 1);
$member_num = ($row = $db->sql_fetchrow($result)) ? $row['member_id'] : 0;
if (!$member_num)
{
$member_num = $user->lang['GUEST'];
}
$db->sql_freeresult($result);Code: Alles auswählen
phpBB Debug] PHP Notice: in file [ROOT]/viewtopic.php on line 1563: Undefined index: post_time
[phpBB Debug] PHP Notice: in file [ROOT]/viewtopic.php on line 1564: Undefined index: post_subject
[phpBB Debug] PHP Notice: in file [ROOT]/viewtopic.php on line 1566: Undefined index: enable_sig
[phpBB Debug] PHP Notice: in file [ROOT]/viewtopic.php on line 1568: Undefined index: post_edit_reason
[phpBB Debug] PHP Notice: in file [ROOT]/viewtopic.php on line 1598: Undefined index: post_id
[phpBB Debug] PHP Notice: in file [ROOT]/viewtopic.php on line 1598: Undefined index: post_id
[phpBB Debug] PHP Notice: in file [ROOT]/viewtopic.php on line 1604: Undefined index: post_id
[phpBB Debug] PHP Notice: in file [ROOT]/viewtopic.php on line 1608: Undefined index: post_id
[phpBB Debug] PHP Notice: in file [ROOT]/viewtopic.php on line 1609: Undefined index: post_approved
[phpBB Debug] PHP Notice: in file [ROOT]/viewtopic.php on line 1610: Undefined index: post_reported
[phpBB Debug] PHP Notice: in file [ROOT]/viewtopic.php on line 1612: Undefined index: friend
[phpBB Debug] PHP Notice: in file [ROOT]/viewtopic.php on line 1618: Undefined index: hide_post
[phpBB Debug] PHP Notice: in file [ROOT]/viewtopic.php on line 1619: Undefined index: hide_post
[phpBB Debug] PHP Notice: in file [ROOT]/viewtopic.php on line 1642: Undefined index: post_id
[phpBB Debug] PHP Notice: in file [ROOT]/viewtopic.php on line 1652: Undefined index: post_id
[phpBB Debug] PHP Notice: in file [ROOT]/viewtopic.php on line 1655: Undefined index: post_idDieser Beitrag wartet auf FreigabeCode: Alles auswählen
$sql_array = array(
'SELECT' => 'COUNT(u.user_id) AS member_id',
'FROM' => array(USERS_TABLE => 'u'),
'LEFT_JOIN' => array(
array(
'FROM' => array(GROUPS_TABLE => 'g'),
'ON' => 'g.group_id = u.group_id',
)),
'WHERE' => $db->sql_in_set('g.group_name', array('BOTS', 'GUESTS'), true) .
' AND u.user_id <> ' . ANONYMOUS .
' AND u.user_id <= ' . (int)$user->data['user_id'],
);
$mem_sql = $db->sql_build_query('SELECT', $sql_array);
$mem_result = $db->sql_query_limit($mem_sql, 1);
$member_num = ($mem_row = $db->sql_fetchrow($mem_result)) ? $mem_row['member_id'] : 0;
if (!$member_num)
{
$member_num = $user->lang['GUEST'];
}
$db->sql_freeresult($mem_result);Code: Alles auswählen
' AND u.user_id <= ' . (int)$user->data['user_id'], Code: Alles auswählen
' AND u.user_id <= ' . (int)$poster_id, (int)$user->data['user_id'] ist der angemeldete Benutzer. 
Code: Alles auswählen
$auth->acl($user->data); Code: Alles auswählen
$sql_array = array(
'SELECT' => 'u.user_id, COUNT(uu.user_id) AS member_id',
'FROM' => array(
USERS_TABLE => 'u'
),
'LEFT_JOIN' => array(
array(
'FROM' => array(USERS_TABLE => 'uu'),
'ON' => 'uu.user_id < u.user_id'
),
array(
'FROM' => array(GROUPS_TABLE => 'g'),
'ON' => 'g.group_id = u.group_id',
)
),
'WHERE' => $db->sql_in_set('g.group_name', array('BOTS', 'GUESTS'), true) .
' AND uu.user_id < u.user_id',
'GROUP_BY' => 'u.user_id',
);
$mem_sql = $db->sql_build_query('SELECT', $sql_array);
$mem_result = $db->sql_query($mem_sql);
$member_num = array();
while ($mem_row = $db->sql_fetchrow($mem_result))
{
$member_num[$mem_row['user_id']] = $mem_row['member_id'];
}
$db->sql_freeresult($mem_result); 
Array