-
-
Notifications
You must be signed in to change notification settings - Fork 3.6k
Expand file tree
/
Copy pathShowGrants.php
More file actions
70 lines (57 loc) · 2.06 KB
/
Copy pathShowGrants.php
File metadata and controls
70 lines (57 loc) · 2.06 KB
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
<?php
declare(strict_types=1);
namespace PhpMyAdmin;
use function mb_strpos;
use function mb_substr;
final class ShowGrants
{
public readonly string $grants;
public readonly string $tableName;
public readonly string $dbName;
private int $tableNameEndOffset;
private int $tableNameStartOffset;
private int $dbNameOffset;
public function __construct(string $showGrants)
{
$this->dbNameOffset = (int) mb_strpos($showGrants, ' ON ') + 4;
$this->tableNameEndOffset = (int) mb_strpos($showGrants, ' TO ');
$this->tableNameStartOffset = $this->getTableNameStartOffset($showGrants);
$this->grants = $this->getShowGrantsString($showGrants);
$this->tableName = $this->getGrantsTableName($showGrants);
$this->dbName = $this->getGrantsDbName($showGrants);
}
private function getTableNameStartOffset(string $showGrants): int
{
$tableNameStartOffset = mb_strpos($showGrants, '`.', $this->dbNameOffset);
if (
$tableNameStartOffset !== false
&& $tableNameStartOffset !== 0
&& $tableNameStartOffset < $this->tableNameEndOffset
) {
return $tableNameStartOffset + 1;
}
return (int) mb_strpos($showGrants, '.', $this->dbNameOffset);
}
private function getShowGrantsString(string $showGrants): string
{
return mb_substr($showGrants, 6, (int) mb_strpos($showGrants, ' ON ') - 6);
}
private function getGrantsTableName(string $showGrants): string
{
$showGrantsTableName = mb_substr(
$showGrants,
$this->tableNameStartOffset + 1,
$this->tableNameEndOffset - $this->tableNameStartOffset - 1,
);
return Util::unQuote($showGrantsTableName, '`');
}
private function getGrantsDbName(string $showGrants): string
{
$showGrantsDbName = mb_substr(
$showGrants,
$this->dbNameOffset,
$this->tableNameStartOffset - $this->dbNameOffset,
);
return Util::unQuote($showGrantsDbName, '`');
}
}