45 string $userIdField =
'user_id',
46 $status = self::SHOWN_USERS
49 $cond = $status === self::HIDDEN_USERS ?
'' :
'NOT ';
53 ->from(
'ipblocks',
'hu_ipblocks' )
54 ->where( [
"hu_ipblocks.ipb_user=$userIdField",
'hu_ipblocks.ipb_deleted' => 1 ] )
55 ->caller( __METHOD__ )
66 ->from(
'block_target',
'hu_block_target' )
67 ->join(
'block',
'hu_block',
'hu_block.bl_target=hu_block_target.bt_id' )
68 ->where( [
"hu_block_target.bt_user=$userIdField",
'hu_block.bl_deleted' => 1 ] )
69 ->caller( __METHOD__ )
72 ( $status === self::HIDDEN_USERS ?
'IS NOT NULL' :
'IS NULL' );
91 $userIdField =
'user_id',
92 $deletedFieldAlias =
'hu_deleted'
96 ->
select( [ $deletedFieldAlias =>
'ipb_deleted IS NOT NULL' ] )
98 'ipblocks',
'hide_user_ipblocks',
99 [
"ipb_user=$userIdField",
'ipb_deleted' => 1 ]
103 ->table(
'block_target' )
104 ->join(
'block',
'hide_user_block',
'bl_target=bt_id' );
106 ->
select( [ $deletedFieldAlias =>
'bl_deleted IS NOT NULL' ] )
109 'hide_user_block_group',
110 [
"bt_user=$userIdField",
'bl_deleted' => 1 ]
112 ->groupBy( $userIdField );
const SCHEMA_COMPAT_READ_OLD
const SCHEMA_COMPAT_READ_MASK