XOOPS /
XoopsCore25
| @@ 369-395 (lines=27) @@ | ||
| 366 | * |
|
| 367 | * @return int|null max length or null on error |
|
| 368 | */ |
|
| 369 | public function getColumnCharacterLength($table, $column) |
|
| 370 | { |
|
| 371 | /** @var XoopsMySQLDatabase $db */ |
|
| 372 | $db = XoopsDatabaseFactory::getDatabaseConnection(); |
|
| 373 | ||
| 374 | $dbname = constant('XOOPS_DB_NAME'); |
|
| 375 | $table = $db->prefix($table); |
|
| 376 | ||
| 377 | $sql = sprintf( |
|
| 378 | 'SELECT `CHARACTER_MAXIMUM_LENGTH` FROM `information_schema`.`COLUMNS` ' |
|
| 379 | . "WHERE TABLE_SCHEMA = '%s'AND TABLE_NAME = '%s' AND COLUMN_NAME = '%s'", |
|
| 380 | $db->escape($dbname), |
|
| 381 | $db->escape($table), |
|
| 382 | $db->escape($column) |
|
| 383 | ); |
|
| 384 | ||
| 385 | /** @var mysqli_result $result */ |
|
| 386 | $result = $db->query($sql); |
|
| 387 | if ($result) { |
|
| 388 | $row = $db->fetchRow($result); |
|
| 389 | if ($row) { |
|
| 390 | $columnLength = $row[0]; |
|
| 391 | return (int) $columnLength; |
|
| 392 | } |
|
| 393 | } |
|
| 394 | return null; |
|
| 395 | } |
|
| 396 | ||
| 397 | /** |
|
| 398 | * count users matching certain conditions |
|
| @@ 41-67 (lines=27) @@ | ||
| 38 | * |
|
| 39 | * @return int column length or zero on error |
|
| 40 | */ |
|
| 41 | private function getColumnLength($table, $column) |
|
| 42 | { |
|
| 43 | /* @var $db XoopsMySQLDatabase */ |
|
| 44 | $db = XoopsDatabaseFactory::getDatabaseConnection(); |
|
| 45 | ||
| 46 | $dbname = constant('XOOPS_DB_NAME'); |
|
| 47 | $table = $db->prefix($table); |
|
| 48 | ||
| 49 | $sql = sprintf( |
|
| 50 | 'SELECT `CHARACTER_MAXIMUM_LENGTH` FROM `information_schema`.`COLUMNS` ' |
|
| 51 | . "WHERE TABLE_SCHEMA = '%s'AND TABLE_NAME = '%s' AND COLUMN_NAME = '%s'", |
|
| 52 | $db->escape($dbname), |
|
| 53 | $db->escape($table), |
|
| 54 | $db->escape($column) |
|
| 55 | ); |
|
| 56 | ||
| 57 | /** @var mysqli_result $result */ |
|
| 58 | $result = $db->query($sql); |
|
| 59 | if ($result) { |
|
| 60 | $row = $db->fetchRow($result); |
|
| 61 | if ($row) { |
|
| 62 | $columnLength = $row[0]; |
|
| 63 | return (int) $columnLength; |
|
| 64 | } |
|
| 65 | } |
|
| 66 | return 0; |
|
| 67 | } |
|
| 68 | ||
| 69 | /** |
|
| 70 | * In PHP 7.1 Session ID length could be any length between 22 and 256 |
|
| @@ 45-71 (lines=27) @@ | ||
| 42 | * |
|
| 43 | * @return int column length or zero on error |
|
| 44 | */ |
|
| 45 | private function getColumnLength($table, $column) |
|
| 46 | { |
|
| 47 | /** @var XoopsMySQLDatabase $db */ |
|
| 48 | $db = XoopsDatabaseFactory::getDatabaseConnection(); |
|
| 49 | ||
| 50 | $dbname = constant('XOOPS_DB_NAME'); |
|
| 51 | $table = $db->prefix($table); |
|
| 52 | ||
| 53 | $sql = sprintf( |
|
| 54 | 'SELECT `CHARACTER_MAXIMUM_LENGTH` FROM `information_schema`.`COLUMNS` ' |
|
| 55 | . "WHERE TABLE_SCHEMA = '%s'AND TABLE_NAME = '%s' AND COLUMN_NAME = '%s'", |
|
| 56 | $db->escape($dbname), |
|
| 57 | $db->escape($table), |
|
| 58 | $db->escape($column) |
|
| 59 | ); |
|
| 60 | ||
| 61 | /** @var mysqli_result $result */ |
|
| 62 | $result = $db->query($sql); |
|
| 63 | if ($result) { |
|
| 64 | $row = $db->fetchRow($result); |
|
| 65 | if ($row) { |
|
| 66 | $columnLength = $row[0]; |
|
| 67 | return (int) $columnLength; |
|
| 68 | } |
|
| 69 | } |
|
| 70 | return 0; |
|
| 71 | } |
|
| 72 | ||
| 73 | /** |
|
| 74 | * Expand users password column to varchar(255) to accommodate bcrypt password_hash |
|
