forked from MightyGorgon/icy_phoenix
-
Notifications
You must be signed in to change notification settings - Fork 0
/
functions_convertors.php
128 lines (109 loc) · 3.28 KB
/
functions_convertors.php
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
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
<?php
/**
*
* @package Icy Phoenix
* @version $Id$
* @copyright (c) 2008 Icy Phoenix
* @license http://opensource.org/licenses/gpl-license.php GNU Public License
*
*/
/**
*
* @Icy Phoenix is based on phpBB
* @copyright (c) 2008 phpBB Group
*
*/
if (!defined('IN_ICYPHOENIX'))
{
die('Hacking attempt');
}
/**
* Replace values in DB: useful for UTF8 Conversion
* Example: UPDATE ip_cms_blocks SET content = REPLACE(content, '\"', '"');
*/
function sql_replace($table, $fields, $html_encode = true, $stripslashes = false)
{
global $db, $cache;
if (empty($fields) || empty($table))
{
return false;
}
if (!is_array($fields))
{
$fields = array($fields);
}
$sql_replace_array = array();
if ($html_encode)
{
foreach ($fields as $field)
{
/*
UPDATE `phpbb_cms_block_settings` SET `content` = REPLACE(`content`, '\\"', '\"');
UPDATE `phpbb_cms_block_settings` SET `content` = REPLACE(`content`, "\\'", "\'");
UPDATE `phpbb_cms_block_settings` SET `content` = REPLACE(`content`, '&', '&');
UPDATE `phpbb_cms_block_settings` SET `content` = REPLACE(`content`, '&&', '&');
UPDATE `phpbb_cms_block_settings` SET `content` = REPLACE(`content`, '\"', '"');
UPDATE `phpbb_cms_block_settings` SET `content` = REPLACE(`content`, '<', '<');
UPDATE `phpbb_cms_block_settings` SET `content` = REPLACE(`content`, '>', '>');
*/
$sql_replace_array[] = "UPDATE " . $table . " SET " . $field . " = REPLACE(" . $field . ", '&', '&')";
$sql_replace_array[] = "UPDATE " . $table . " SET " . $field . " = REPLACE(" . $field . ", '&&', '&')";
$sql_replace_array[] = "UPDATE " . $table . " SET " . $field . " = REPLACE(" . $field . ", '\"', '"')";
$sql_replace_array[] = "UPDATE " . $table . " SET " . $field . " = REPLACE(" . $field . ", '<', '<')";
$sql_replace_array[] = "UPDATE " . $table . " SET " . $field . " = REPLACE(" . $field . ", '>', '>')";
}
}
if ($stripslashes)
{
foreach ($fields as $field)
{
$sql_replace_array[] = "UPDATE " . $table . " SET " . $field . " = REPLACE(" . $field . ", \"\'\", \"'\")";
}
}
for ($i = 0; $i < sizeof($sql_replace_array); $i++)
{
$db->sql_return_on_error(true);
$result = $db->sql_query($sql_replace_array[$i]);
$db->sql_return_on_error(false);
}
return true;
}
/**
* Convert nulls to zeros for fields which allowed a NULL value in the source but not the destination
*/
function null_to_zero($value)
{
return ($value === NULL) ? 0 : $value;
}
/**
* Convert nulls to empty strings for fields which allowed a NULL value in the source but not the destination
*/
function null_to_str($value)
{
return ($value === NULL) ? '' : $value;
}
/**
* Convert an IP address from the hexadecimal notation to normal dotted-quad notation
*/
function decode_ip($int_ip)
{
if (!$int_ip)
{
return $int_ip;
}
$hexipbang = explode('.', chunk_split($int_ip, 2, '.'));
// Any mod changing the way ips are stored? Then we are not able to convert and enter the ip "as is" to not "destroy" anything...
if (sizeof($hexipbang) < 4)
{
return $int_ip;
}
return hexdec($hexipbang[0]) . '.' . hexdec($hexipbang[1]) . '.' . hexdec($hexipbang[2]) . '.' . hexdec($hexipbang[3]);
}
/**
* Reverse the encoding of wild-carded bans
*/
function decode_ban_ip($int_ip)
{
return str_replace('255', '*', $int_ip);
}
?>