-
Notifications
You must be signed in to change notification settings - Fork 0
/
Copy pathfonts.php
198 lines (140 loc) · 8.72 KB
/
fonts.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
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
<?php
include_once 'data.php';
include_once 'functions.php';
if (isset($_SESSION['auth'])) {
$ini_settings = parse_ini_file("ilibrarian.ini", true);
$default_settings = $ini_settings['fonts and appearance'];
database_connect($usersdatabase_path, 'users');
$dbHandle->beginTransaction();
$user_query = $dbHandle->quote($_SESSION['user_id']);
########## this are the new settings ##########
if (isset($_GET['change'])) {
while (list($get_setting_name, $get_setting_value) = each($_GET)) {
if(substr($get_setting_name, -5) == 'color' && ctype_xdigit($get_setting_value)) $new_settings[$get_setting_name] = substr(strtoupper($get_setting_value), 0, 6);
if(substr($get_setting_name, -6) == 'family' && ctype_print($get_setting_value)) $new_settings[$get_setting_name] = $get_setting_value;
if(substr($get_setting_name, -4) == 'size' && ctype_digit($get_setting_value)) $new_settings[$get_setting_name] = substr($get_setting_value, 0, 3);
if(substr($get_setting_name, -6) == 'height' && is_numeric($get_setting_value)) $new_settings[$get_setting_name] = $get_setting_value;
}
########## determine the new settings as the difference from the default ##########
if (!empty($new_settings)) $new_settings = array_diff_assoc($new_settings, $default_settings);
########## update the database with new settings, which differ from the default ##########
$dbHandle->query("DELETE FROM settings WHERE userID=$user_query AND
(setting_name LIKE 'top_window%' OR setting_name LIKE 'main_window%' OR setting_name LIKE 'left_window%' OR setting_name LIKE 'alternating_row%')");
while (list($setting_name, $setting_value) = each($new_settings)) {
$dbHandle->query("INSERT INTO settings (userID, setting_name, setting_value) VALUES ($user_query, '$setting_name', '$setting_value')");
}
} elseif (isset($_GET['default'])) {
$dbHandle->query("DELETE FROM settings WHERE userID=$user_query AND
(setting_name LIKE 'top_window%' OR setting_name LIKE 'main_window%' OR setting_name LIKE 'left_window%' OR setting_name LIKE 'alternating_row%')");
}
$dbHandle->commit();
########## read users settings ##########
$result = $dbHandle->query("SELECT setting_name,setting_value FROM settings WHERE userID=$user_query");
while ($custom_settings = $result->fetch(PDO::FETCH_ASSOC)) {
$custom_setting{$custom_settings['setting_name']} = $custom_settings['setting_value'];
}
if (!empty($custom_setting)) $default_settings = array_merge($default_settings, $custom_setting);
while (list($setting_name, $setting_value) = each($default_settings)) {
${$setting_name} = $setting_value;
}
$dbHandle = null;
print '<form action="fonts.php" method="GET">';
print '<table cellspacing="0" style="width: 100%">';
print "\n<tr>";
print "\n<td class=\"details alternating_row\" style=\"width: 100%\" colspan=4><b>General text</b></td>";
print "\n</tr>";
print "\n<tr>";
print "\n<td class=\"details\" style=\"width:25%\">Font:";
print "\n<input type=\"text\" size=15 name=\"main_window_font_family\" value=\"$main_window_font_family\"></td>";
print "\n<td class=\"details\" style=\"\">Text Size:";
print "\n<input type=\"text\" size=2 maxlength=2 name=\"main_window_font_size\" value=\"$main_window_font_size\"> px (10-13)</td>";
print "\n<td class=\"details\" style=\"\">Text Color:";
print "RGB# <input type=\"text\" size=6 maxlength=6 name=\"main_window_color\" value=\"$main_window_color\" title=\"hexadecimal code\"></td>";
print "\n<td class=\"details\" style=\"\">Line spacing:";
print "\n<input type=\"text\" size=3 name=\"main_window_line_height\" value=\"$main_window_line_height\"></td>";
print "\n</tr>";
print "\n<tr>";
print "\n<tr><td class=\"details alternating_row\" style=\"width: 100%\" colspan=4><b>Links, highlights</b></td></tr>";
print "\n</tr>";
print "\n<tr>";
print "\n<td class=\"details\" style=\"\">Text Color:";
print "RGB# <input type=\"text\" size=6 maxlength=6 name=\"main_window_link_color\" value=\"$main_window_link_color\" title=\"hexadecimal code\"></td>";
print "\n<td class=\"details\" style=\"\" colspan=3> ";
print "</td>";
print "\n</tr>";
print "\n<tr>";
print "\n<td class=\"details alternating_row\" style=\"width: 100%\" colspan=4><b>Titles</b></td>";
print "\n</tr>";
print "\n<tr>";
print "\n<td class=\"details\" style=\"\">Font:";
print "\n<input type=\"text\" size=15 name=\"main_window_title_font_family\" value=\"$main_window_title_font_family\"></td>";
print "\n<td class=\"details\" style=\"\" colspan=3>Text Size:";
print "\n<input type=\"text\" size=2 maxlength=2 name=\"main_window_title_font_size\" value=\"$main_window_title_font_size\"> px (10-18)</td>";
print "\n</tr>";
print "\n<tr>";
print "\n<td class=\"details alternating_row\" style=\"width: 100%\" colspan=4><b>Abstracts</b></td>";
print "\n</tr>";
print "\n<tr>";
print "\n<td class=\"details\" style=\"\">Font:";
print "\n<input type=\"text\" size=15 name=\"main_window_abstract_font_family\" value=\"$main_window_abstract_font_family\"></td>";
print "\n<td class=\"details\" style=\"\">Text Size:";
print "\n<input type=\"text\" size=2 maxlength=2 name=\"main_window_abstract_font_size\" value=\"$main_window_abstract_font_size\"> px (11-15)</td>";
print "\n<td class=\"details\" style=\"\" colspan=2>Line spacing:";
print "\n<input type=\"text\" size=3 name=\"main_window_abstract_line_height\" value=\"$main_window_abstract_line_height\"></td>";
print "\n</tr>";
print "\n<tr>";
print "\n<td class=\"details alternating_row\" style=\"width: 100%\" colspan=4><b>Form fields</b></td>";
print "\n</tr>";
print "\n<tr>";
print "\n<td class=\"details\" style=\"\">Font:";
print "\n<input type=\"text\" size=15 name=\"main_window_form_font_family\" value=\"$main_window_form_font_family\"></td>";
print "\n<td class=\"details\" style=\"\" colspan=3>Text Size:";
print "\n<input type=\"text\" size=2 maxlength=2 name=\"main_window_form_font_size\" value=\"$main_window_form_font_size\"> px (11-13)</td>";
print "\n</tr>";
print '</table>';
print '<table cellpadding="0" style="width: 100%">';
print "\n<tr>";
print "\n<td class=\"details alternating_row\" colspan=2><b>Main Panel:</b></td>";
print "\n</tr>";
print "\n<tr>";
print "\n<td class=\"details\" style=\"width: 25%\">Page Color: ";
print "RGB#<input type=\"text\" size=6 maxlength=6 name=\"main_window_background_color\" value=\"$main_window_background_color\" title=\"hexadecimal code\"></td>";
print "\n<td class=\"details\">Alternating Row: ";
print "RGB#<input type=\"text\" size=6 maxlength=6 name=\"alternating_row_background_color\" value=\"$alternating_row_background_color\" title=\"hexadecimal code\"></td>";
print "\n</tr>";
print '</table>';
print '<table cellpadding="0" style="width: 100%">';
print "\n<tr>";
print "\n<td class=\"details alternating_row\" colspan=2><b>Top Panel:</b></td>";
print "\n</tr>";
print "\n<tr>";
print "\n<td class=\"details\" style=\"width: 25%\">Page Color: ";
print "RGB#<input type=\"text\" size=6 maxlength=6 name=\"top_window_background_color\" value=\"$top_window_background_color\" title=\"hexadecimal code\"></td>";
print "\n<td class=\"details\">Text Color: ";
print "RGB#<input type=\"text\" size=6 maxlength=6 name=\"top_window_color\" value=\"$top_window_color\" title=\"hexadecimal code\"></td>";
print "\n</tr>";
print '</table>';
print '<table cellspacing="0" style="width:100%">';
print "\n<tr>";
print "\n<td class=\"details alternating_row\" style=\"width: 100%\"><b>Left Panel:</b></td>";
print "\n</tr>";
print "\n<tr>";
print "\n<td class=\"details\">Page Color: ";
print "RGB#<input type=\"text\" size=6 maxlength=6 name=\"left_window_background_color\" value=\"$left_window_background_color\" title=\"hexadecimal code\"></td>";
print "\n</tr>";
print '</table>';
print "\n<br> <input type=\"submit\" name=\"change\" value=\"Change\">";
print "\n<input type=\"submit\" name=\"default\" value=\"Use Default\">";
print '</form><br><br>';
print ' <b>Preview:</b><div style="padding:6px">
<div class="alternating_row" style="padding:6px" id="lorem-alternating-row">
<div class="titles"><span id="lorem-title">Lorem ipsum dolor sit amet, consectetur adipiscing elit.</span></div>
<span id="lorem-text">Smith, J, Carpenter, P<br>Journal of Lorem Ipsum (2011)</span>
<br><a name="" id="lorem-link">Link</a>
</div>
<div class="abstract" id="lorem-abstract">Lorem ipsum dolor sit amet, consectetur adipiscing elit. Phasellus tincidunt ipsum at nisl consequat hendrerit. Proin non tellus nisi, eu posuere erat. Ut ut ligula et dolor ultrices consectetur ut non elit. Aliquam tristique condimentum magna, id adipiscing metus semper at. Pellentesque mollis velit sit amet nunc pellentesque egestas. Aenean varius scelerisque ipsum, nec ornare ipsum lobortis vel. Nunc venenatis ornare erat eget fringilla. Cras ullamcorper dolor non massa commodo a porttitor quam gravida.</div>
</div>';
} else {
print 'Authorization required.';
}
?>