blob: 323f8616c999df88de53652a8690c96abf56152c (
plain)
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
class Base64
{
var $sourceObject;
var $argv;
var $version = '1.0';
function Version()
{
return $this->version;
}
function Base64($sourceObject, $argv)
{
$this->sourceObject = $sourceObject;
$this->argv = $argv;
}
function Execute()
{
return null;
}
function SetupRender()
{
if (isset($_POST['install_base64']) || isset($_POST['uninstall_base64']))
{
$this->SetupExecute();
}
else
{
$out = "This plugin allows you to install and uninstall a base64 custom function to and from your database.
You can then set \$configuration['db_encoding'] = 1 so that all data is transparently encoded and decoded
with the minimal overhead possible. Enabling data encoding has quite a few advantages: <br/><br/>
";
$out .= "<br/><br/><textarea>BASE64 Status";
if (Base64::IsBase64FunctionInstalled())
{
$out .= "\n\tChecking MySQL function....OK!";
if (!isset($GLOBALS['configuration']['db_encoding']) || $GLOBALS['configuration']['db_encoding'] != 1)
{
$out .= "\n\tChecking db_encoding status....Failed";
$out .= "\n\n---------------------------------------------------";
$out .= "\n\$configuration['db_encoding'] is set to 0. Make sure you set the value to 1 to enable data encoding.";
}
else
{
$out .= "\n\tChecking db_encoding status....OK!";
$out .= "\n\nBASE64 Status...OK!";
$out .= "\n---------------------------------------------------";
}
$out .= "</textarea><div style='padding-left:250px;padding-top:10px;'><input type='submit' value='UNINSTALL' name='uninstall_base64'/></div>";
}
else
{
$out .= "\n\tChecking MySQL function....NOT INSTALLED";
$out .= "\n\tChecking db_encoding status ignored";
$out .= "\n\n---------------------------------------------------";
$out .= "\nClick the INSTALL button below to install the base64 function to your database.";
$out .= "</textarea><div style='padding-left:250px;padding-top:10px;'><input type='submit' value='INSTALL' name='install_base64'/></div>";
}
$out .= "<input type='hidden' name='plugins' value='true'/>";
echo $out;
}
}
function AuthorPage()
{
return null;
}
function SetupExecute()
{
$out = '';
$connection = Database::Connect();
if (isset($_POST['install_base64']) && isset($_POST['install_base64']) == true)
{
$initialData = file_get_contents('../plugins/base64_install.sql');
$statements = explode('|', $initialData);
if (sizeof($statements) > 0)
{
foreach ($statements as $statement)
{
if (trim($statement) != '')
{
Database::NonQuery($statement, $connection);
}
}
}
$out .= "<textarea>INSTALL SUCCESSFUL\n\n";
$out .= "Make sure you set \$configuration[db_encoding] = 1 in the configuration file.</textarea>";
}
else if (isset($_POST['uninstall_base64']) && $_POST['uninstall_base64'] == true)
{
$initialData = file_get_contents('../plugins/base64_uninstall.sql');
$statements = explode('|', $initialData);
if (sizeof($statements) > 0)
{
foreach ($statements as $statement)
{
if (trim($statement) != '')
{
Database::NonQuery($statement, $connection);
}
}
}
$out .= "<textarea>UNINSTALL SUCCESSFUL\n\n";
$out .= "Make sure you set \$configuration[db_encoding] = 0 in the configuration file.</textarea>";
}
echo $out;
}
function IsBase64FunctionInstalled()
{
$sql1 = "show function status where Db='".$GLOBALS['configuration']['db']."' and (Name='BASE64_DECODE' or Name='BASE64_ENCODE')";
$sql2 = "show tables like 'base64_data'";
$connection = Database::Connect();
$result = Database::Query($sql1, $connection);
$result2 = Database::Query($sql2, $connection);
if ($result == 2 && $result2 == 1)
{
return true;
}
return false;
}
}
|
