Revize 186
Přidáno uživatelem Michal Kliment před více než 15 roky(ů)
| freenetis/trunk/kohana/application/upgrade_sql/upgrade_sql_176.php | ||
|---|---|---|
|
`value` varchar(255) COLLATE utf8_czech_ci NOT NULL
|
||
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci;",
|
||
|
|
||
|
"INSERT INTO `config` (`name`, `value`) VALUES ('db_schema_version', '176');",
|
||
|
|
||
|
"CREATE FUNCTION `ip2str`(ip INT UNSIGNED) RETURNS varchar(255) CHARSET utf8
|
||
|
DETERMINISTIC
|
||
|
RETURN CONCAT(ip>>24 & 255, '.', ip>>16 & 255, '.', ip>>8 & 255, '.', ip & 255);",
|
||
|
|
||
|
"CREATE FUNCTION `mask2str`(ipmask INT) RETURNS varchar(255) CHARSET utf8
|
||
|
DETERMINISTIC
|
||
|
RETURN inet_ntoa(0xffffffff<<(32-ipmask) & 0xffffffff);",
|
||
|
|
||
|
"CREATE FUNCTION `str2ip`(ip VARCHAR(255)) RETURNS int(10) unsigned
|
||
|
DETERMINISTIC
|
||
|
RETURN (substring_index(ip,'.',1)<<24 |
|
||
|
substring_index(substring_index(ip,'.',2),'.',-1)<<16 |
|
||
|
substring_index(substring_index(ip,'.',-2), '.',1)<<8 |
|
||
|
substring_index(ip,'.',-1))"
|
||
|
"INSERT INTO `config` (`name`, `value`) VALUES ('db_schema_version', '176');"
|
||
|
);
|
||
|
?>
|
||
Také k dispozici: Unified diff
Ze zakladního sql odstraněny sql funkce, pro správnou funkci freenetisu nutno spustit pod rootem tyto sql příkazy:
CREATE FUNCTION `ip2str`(ip INT UNSIGNED) RETURNS varchar(255) CHARSET utf8
DETERMINISTIC
RETURN CONCAT;
CREATE FUNCTION `mask2str`(ipmask INT) RETURNS varchar(255) CHARSET utf8
DETERMINISTIC
RETURN inet_ntoa(0xffffffff<<(32-ipmask) & 0xffffffff);
CREATE FUNCTION `str2ip`(ip VARCHAR) RETURNS int(10) unsigned
DETERMINISTIC
RETURN (substring_index(ip,'.',1)<<24 |
substring_index(substring_index(ip,'.',2),'.',-1)<<16 |
substring_index(substring_index(ip,'.',-2), '.',1)<<8 |
substring_index(ip,'.',-1))
TODO: Přepsat kontroler IP adres, aby tyto funkce vůbec nevyužíval.