скачать русский перевод, моды, скины и стили для phpBB, phpBB3
).
_users, а присутствует из таблицы групп. То есть это могут быть несуществующие пользователи, оставшиеся в группеКод: Выделить всё
$sql_ary = array(
'SELECT' => 'u.user_id,Код: Выделить всё
$sql_ary = array(
'SELECT' => 'ug.user_id,
Код: Выделить всё
Array
(
[0] => Array
(
[user_id] =>
[default_group] =>
[username] =>
[username_clean] =>
[user_colour] =>
[user_type] =>
[user_rank] =>
[user_posts] =>
[user_allow_pm] =>
[group_id] => 11
)
[1] => Array
(
[user_id] =>
[default_group] =>
[username] =>
[username_clean] =>
[user_colour] =>
[user_type] =>
[user_rank] =>
[user_posts] =>
[user_allow_pm] =>
[group_id] => 11
)
[2] => Array
(
[user_id] =>
[default_group] =>
[username] =>
[username_clean] =>
[user_colour] =>
[user_type] =>
[user_rank] =>
[user_posts] =>
[user_allow_pm] =>
[group_id] => 11
)
[3] => Array
(
[user_id] =>
[default_group] =>
[username] =>
[username_clean] =>
[user_colour] =>
[user_type] =>
[user_rank] =>
[user_posts] =>
[user_allow_pm] =>
[group_id] => 11
)
[4] => Array
(
[user_id] =>
[default_group] =>
[username] =>
[username_clean] =>
[user_colour] =>
[user_type] =>
[user_rank] =>
[user_posts] =>
[user_allow_pm] =>
[group_id] => 11
)
[5] => Array
(
[user_id] =>
[default_group] =>
[username] =>
[username_clean] =>
[user_colour] =>
[user_type] =>
[user_rank] =>
[user_posts] =>
[user_allow_pm] =>
[group_id] => 16
)
[6] => Array
(
[user_id] =>
[default_group] =>
[username] =>
[username_clean] =>
[user_colour] =>
[user_type] =>
[user_rank] =>
[user_posts] =>
[user_allow_pm] =>
[group_id] => 16
)
[7] => Array
(
[user_id] =>
[default_group] =>
[username] =>
[username_clean] =>
[user_colour] =>
[user_type] =>
[user_rank] =>
[user_posts] =>
[user_allow_pm] =>
[group_id] => 11
)
[8] => Array
(
[user_id] =>
[default_group] =>
[username] =>
[username_clean] =>
[user_colour] =>
[user_type] =>
[user_rank] =>
[user_posts] =>
[user_allow_pm] =>
[group_id] => 11
)
[9] => Array
(
[user_id] =>
[default_group] =>
[username] =>
[username_clean] =>
[user_colour] =>
[user_type] =>
[user_rank] =>
[user_posts] =>
[user_allow_pm] =>
[group_id] => 16
)
[10] => Array
(
[user_id] =>
[default_group] =>
[username] =>
[username_clean] =>
[user_colour] =>
[user_type] =>
[user_rank] =>
[user_posts] =>
[user_allow_pm] =>
[group_id] => 11
)
[11] => Array
(
[user_id] =>
[default_group] =>
[username] =>
[username_clean] =>
[user_colour] =>
[user_type] =>
[user_rank] =>
[user_posts] =>
[user_allow_pm] =>
[group_id] => 16
)
[12] => Array
(
[user_id] =>
[default_group] =>
[username] =>
[username_clean] =>
[user_colour] =>
[user_type] =>
[user_rank] =>
[user_posts] =>
[user_allow_pm] =>
[group_id] => 11
)
[13] => Array
(
[user_id] => 57
[default_group] => 5
[username] => Administrator
[username_clean] => administrator
[user_colour] => BB1300
[user_type] => 3
[user_rank] => 0
[user_posts] => 160153
[user_allow_pm] => 1
[group_id] => 5
)
[14] => Array
(
[user_id] => 42566
[default_group] => 4
[username] => Aleksandr58
[username_clean] => aleksandr58
[user_colour] => 009933
[user_type] => 0
[user_rank] => 0
[user_posts] => 5079
[user_allow_pm] => 1
[group_id] => 11
)
[15] => Array
(
[user_id] => 42566
[default_group] => 4
[username] => Aleksandr58
[username_clean] => aleksandr58
[user_colour] => 009933
[user_type] => 0
[user_rank] => 0
[user_posts] => 5079
[user_allow_pm] => 1
[group_id] => 4
)
[16] => Array
(
[user_id] => 37304
[default_group] => 16
[username] => alinassersfc
[username_clean] => alinassersfc
[user_colour] => 0000BF
[user_type] => 0
[user_rank] => 0
[user_posts] => 720
[user_allow_pm] => 1
[group_id] => 16
)
[17] => Array
(
[user_id] => 37828
[default_group] => 11
[username] => AnatGraph
[username_clean] => anatgraph
[user_colour] => FF9966
[user_type] => 0
[user_rank] => 0
[user_posts] => 287
[user_allow_pm] => 1
[group_id] => 11
)
[18] => Array
(
[user_id] => 94
[default_group] => 11
[username] => Andreewih
[username_clean] => andreewih
[user_colour] => FF9966
[user_type] => 0
[user_rank] => 0
[user_posts] => 776
[user_allow_pm] => 1
[group_id] => 11
)
[19] => Array
(
[user_id] => 470
[default_group] => 4
[username] => boom
[username_clean] => boom
[user_colour] => 009933
[user_type] => 0
[user_rank] => 0
[user_posts] => 8857
[user_allow_pm] => 1
[group_id] => 4
)
[20] => Array
(
[user_id] => 48439
[default_group] => 16
[username] => Сергей4
[username_clean] => cepreй4
[user_colour] => 0000BF
[user_type] => 0
[user_rank] => 0
[user_posts] => 303
[user_allow_pm] => 1
[group_id] => 16
)
[21] => Array
(
[user_id] => 53582
[default_group] => 4
[username] => ЕгорМорозов
[username_clean] => eropмopoзoв
[user_colour] => 009933
[user_type] => 0
[user_rank] => 0
[user_posts] => 758
[user_allow_pm] => 1
[group_id] => 4
)
[22] => Array
(
[user_id] => 50254
[default_group] => 29
[username] => ЕвгенийДобролюбов
[username_clean] => eвreнийдo6poлю6oв
[user_colour] => 4000BF
[user_type] => 0
[user_rank] => 0
[user_posts] => 3
[user_allow_pm] => 1
[group_id] => 29
)
[23] => Array
(
[user_id] => 73
[default_group] => 16
[username] => kosoleg5
[username_clean] => kosoleg5
[user_colour] => 0000BF
[user_type] => 0
[user_rank] => 0
[user_posts] => 1444
[user_allow_pm] => 1
[group_id] => 16
)
[24] => Array
(
[user_id] => 7502
[default_group] => 5
[username] => KOSTEY
[username_clean] => kostey
[user_colour] => BB1300
[user_type] => 0
[user_rank] => 0
[user_posts] => 2398
[user_allow_pm] => 1
[group_id] => 5
)
[25] => Array
(
[user_id] => 49425
[default_group] => 16
[username] => mavv
[username_clean] => mavv
[user_colour] => 0000BF
[user_type] => 0
[user_rank] => 0
[user_posts] => 344
[user_allow_pm] => 1
[group_id] => 16
)
[26] => Array
(
[user_id] => 49425
[default_group] => 16
[username] => mavv
[username_clean] => mavv
[user_colour] => 0000BF
[user_type] => 0
[user_rank] => 0
[user_posts] => 344
[user_allow_pm] => 1
[group_id] => 11
)
[27] => Array
(
[user_id] => 65639
[default_group] => 11
[username] => Nikolai2
[username_clean] => nikolai2
[user_colour] => FF9966
[user_type] => 0
[user_rank] => 0
[user_posts] => 558
[user_allow_pm] => 1
[group_id] => 11
)
[28] => Array
(
[user_id] => 36193
[default_group] => 11
[username] => nikooo78
[username_clean] => nikooo78
[user_colour] => FF9966
[user_type] => 0
[user_rank] => 0
[user_posts] => 22
[user_allow_pm] => 1
[group_id] => 11
)
[29] => Array
(
[user_id] => 37846
[default_group] => 4
[username] => olegbatkov
[username_clean] => olegbatkov
[user_colour] => 009933
[user_type] => 0
[user_rank] => 0
[user_posts] => 5077
[user_allow_pm] => 1
[group_id] => 4
)
[30] => Array
(
[user_id] => 41596
[default_group] => 11
[username] => РоманСуздальцев
[username_clean] => poмaнcyздaлƅцeв
[user_colour] => FF9966
[user_type] => 0
[user_rank] => 0
[user_posts] => 199
[user_allow_pm] => 1
[group_id] => 11
)
[31] => Array
(
[user_id] => 36183
[default_group] => 4
[username] => simons65
[username_clean] => simons65
[user_colour] => 009933
[user_type] => 0
[user_rank] => 0
[user_posts] => 1297
[user_allow_pm] => 0
[group_id] => 4
)
[32] => Array
(
[user_id] => 60913
[default_group] => 16
[username] => tttddd
[username_clean] => tttddd
[user_colour] => 0000BF
[user_type] => 0
[user_rank] => 0
[user_posts] => 1508
[user_allow_pm] => 1
[group_id] => 16
)
[33] => Array
(
[user_id] => 55367
[default_group] => 29
[username] => tvizinet
[username_clean] => tvizinet
[user_colour] => 4000BF
[user_type] => 0
[user_rank] => 0
[user_posts] => 96
[user_allow_pm] => 1
[group_id] => 29
)
[34] => Array
(
[user_id] => 11642
[default_group] => 11
[username] => vladim71
[username_clean] => vladim71
[user_colour] => FF9966
[user_type] => 0
[user_rank] => 0
[user_posts] => 72
[user_allow_pm] => 1
[group_id] => 11
)
[35] => Array
(
[user_id] => 47249
[default_group] => 5
[username] => Voks
[username_clean] => voks
[user_colour] => BB1300
[user_type] => 3
[user_rank] => 0
[user_posts] => 1858
[user_allow_pm] => 1
[group_id] => 5
)
[36] => Array
(
[user_id] => 47249
[default_group] => 5
[username] => Voks
[username_clean] => voks
[user_colour] => BB1300
[user_type] => 3
[user_rank] => 0
[user_posts] => 1858
[user_allow_pm] => 1
[group_id] => 4
)
[37] => Array
(
[user_id] => 38255
[default_group] => 11
[username] => vviktorgygo
[username_clean] => vviktorgygo
[user_colour] => FF9966
[user_type] => 0
[user_rank] => 0
[user_posts] => 1139
[user_allow_pm] => 1
[group_id] => 11
)
[38] => Array
(
[user_id] => 43808
[default_group] => 11
[username] => wasjac
[username_clean] => wasjac
[user_colour] => FF9966
[user_type] => 0
[user_rank] => 0
[user_posts] => 297
[user_allow_pm] => 1
[group_id] => 11
)
[39] => Array
(
[user_id] => 8600
[default_group] => 16
[username] => wova
[username_clean] => wova
[user_colour] => 0000BF
[user_type] => 0
[user_rank] => 0
[user_posts] => 2124
[user_allow_pm] => 1
[group_id] => 16
)
[40] => Array
(
[user_id] => 66881
[default_group] => 5
[username] => zomro
[username_clean] => zomro
[user_colour] => BB1300
[user_type] => 0
[user_rank] => 0
[user_posts] => 0
[user_allow_pm] => 1
[group_id] => 5
)
[41] => Array
(
[user_id] => 289
[default_group] => 11
[username] => Юрий56
[username_clean] => юpий56
[user_colour] => FF9966
[user_type] => 0
[user_rank] => 0
[user_posts] => 2168
[user_allow_pm] => 0
[group_id] => 11
)
)
[phpBB Debug] PHP Warning: in file [ROOT]/includes/functions.php on line 4149: Cannot modify header information - headers already sent by (output started at [ROOT]/memberlist.php:207)
[phpBB Debug] PHP Warning: in file [ROOT]/includes/functions.php on line 4149: Cannot modify header information - headers already sent by (output started at [ROOT]/memberlist.php:207)
[phpBB Debug] PHP Warning: in file [ROOT]/includes/functions.php on line 4149: Cannot modify header information - headers already sent by (output started at [ROOT]/memberlist.php:207)
[phpBB Debug] PHP Warning: in file [ROOT]/includes/functions.php on line 4149: Cannot modify header information - headers already sent by (output started at [ROOT]/memberlist.php:207)Код: Выделить всё
Array
(
[0] => Array
(
[user_id] => 35514
[default_group] =>
[username] =>
[username_clean] =>
[user_colour] =>
[user_type] =>
[user_rank] =>
[user_posts] =>
[user_allow_pm] =>
[group_id] => 11
)
[1] => Array
(
[user_id] => 35161
[default_group] =>
[username] =>
[username_clean] =>
[user_colour] =>
[user_type] =>
[user_rank] =>
[user_posts] =>
[user_allow_pm] =>
[group_id] => 11
)
[2] => Array
(
[user_id] => 30096
[default_group] =>
[username] =>
[username_clean] =>
[user_colour] =>
[user_type] =>
[user_rank] =>
[user_posts] =>
[user_allow_pm] =>
[group_id] => 11
)
[3] => Array
(
[user_id] => 30985
[default_group] =>
[username] =>
[username_clean] =>
[user_colour] =>
[user_type] =>
[user_rank] =>
[user_posts] =>
[user_allow_pm] =>
[group_id] => 11
)
[4] => Array
(
[user_id] => 29182
[default_group] =>
[username] =>
[username_clean] =>
[user_colour] =>
[user_type] =>
[user_rank] =>
[user_posts] =>
[user_allow_pm] =>
[group_id] => 11
)
[5] => Array
(
[user_id] => 20672
[default_group] =>
[username] =>
[username_clean] =>
[user_colour] =>
[user_type] =>
[user_rank] =>
[user_posts] =>
[user_allow_pm] =>
[group_id] => 16
)
[6] => Array
(
[user_id] => 14514
[default_group] =>
[username] =>
[username_clean] =>
[user_colour] =>
[user_type] =>
[user_rank] =>
[user_posts] =>
[user_allow_pm] =>
[group_id] => 16
)
[7] => Array
(
[user_id] => 29181
[default_group] =>
[username] =>
[username_clean] =>
[user_colour] =>
[user_type] =>
[user_rank] =>
[user_posts] =>
[user_allow_pm] =>
[group_id] => 11
)
[8] => Array
(
[user_id] => 6243
[default_group] =>
[username] =>
[username_clean] =>
[user_colour] =>
[user_type] =>
[user_rank] =>
[user_posts] =>
[user_allow_pm] =>
[group_id] => 11
)
[9] => Array
(
[user_id] => 35514
[default_group] =>
[username] =>
[username_clean] =>
[user_colour] =>
[user_type] =>
[user_rank] =>
[user_posts] =>
[user_allow_pm] =>
[group_id] => 16
)
[10] => Array
(
[user_id] => 14644
[default_group] =>
[username] =>
[username_clean] =>
[user_colour] =>
[user_type] =>
[user_rank] =>
[user_posts] =>
[user_allow_pm] =>
[group_id] => 11
)
[11] => Array
(
[user_id] => 31690
[default_group] =>
[username] =>
[username_clean] =>
[user_colour] =>
[user_type] =>
[user_rank] =>
[user_posts] =>
[user_allow_pm] =>
[group_id] => 16
)
[12] => Array
(
[user_id] => 23326
[default_group] =>
[username] =>
[username_clean] =>
[user_colour] =>
[user_type] =>
[user_rank] =>
[user_posts] =>
[user_allow_pm] =>
[group_id] => 11
)Ну да. Кэш как всегда.
И что теперь с этим надо сделать ?
Код: Выделить всё
SELECT ug.user_id FROM phpbb_user_group ug
LEFT JOIN phpbb_users u ON u.user_id = ug.user_id
WHERE u.user_id IS NULLКод: Выделить всё
SELECT ug.user_id FROM phpbb_user_group ug LEFT JOIN phpbb_users u ON u.user_id = ug.user_id WHERE u.user_id IS NULLКод: Выделить всё
SELECT * FROM phpbb_users WHERE user_id IN (SELECT ug.user_id FROM phpbb_user_group ug LEFT JOIN phpbb_users u ON u.user_id = ug.user_id WHERE u.user_id IS NULL)Код: Выделить всё
DELETE FROM phpbb_user_group WHERE user_id IN (SELECT ug.user_id FROM phpbb_user_group ug LEFT JOIN phpbb_users u ON u.user_id = ug.user_id WHERE u.user_id IS NULL)Оооооо. Стрёмно как то. Я не этом хостинге бекапы ещё не делал. Могу накасячить. Может сделать через админку форума ?
