|
PCCS MySQLDatabase Admin Tool version 1.3.4
|
/ -> mysqldb_host.php
1 <?php
2 // Used PHPGen to generate most of this code
3 // Filename: mysqldb_host.php
4 // Function: provide a simple interface to the mysql host table
5 /*
6 print"
7 <HTML>
8 <HEAD>
9 <!META HTTP-EQUIV=\"Content-Type\" CONTENT=\"text/html; charset=ISO-8859-1\">
10 <TITLE>MySQL Host Privilege Table</TITLE>
11 ";
12 */
13 // updated 10-23-2000
14 // -- moving to a single file for global include files
15
16 require('mysqldb_app_includes.php');
17
18 // Use header function ...
19 common_header($str_mainTitle);
20
21 pageTop("PCCS MySQLAdmin Tool version ". $appversion,"600");
22
23
24 $link_array = array(
25 "$str_mainMenu" => "./",
26 "$str_createwebacct" => "mysqldb_create_webuser.php",
27 "LOGOUT" => "logout.php"
28 );
29
30 print "<BR>";
31 print "<CENTER>";
32 navBar($link_array);
33 print "</CENTER>";
34 print "<BR>";
35
36 if (empty($action)) $action="browselist";
37
38
39 $Select_priv_arr = array(
40 "N" => "N",
41 "Y" => "Y"
42 );
43
44 $Insert_priv_arr = array(
45 "N" => "N",
46 "Y" => "Y"
47 );
48
49 $Update_priv_arr = array(
50 "N" => "N",
51 "Y" => "Y"
52 );
53
54 $Delete_priv_arr = array(
55 "N" => "N",
56 "Y" => "Y"
57 );
58
59 $Create_priv_arr = array(
60 "N" => "N",
61 "Y" => "Y"
62 );
63
64 $Drop_priv_arr = array(
65 "N" => "N",
66 "Y" => "Y"
67 );
68
69 $Grant_priv_arr = array(
70 "N" => "N",
71 "Y" => "Y"
72 );
73
74 $References_priv_arr = array(
75 "N" => "N",
76 "Y" => "Y"
77 );
78
79 $Index_priv_arr = array(
80 "N" => "N",
81 "Y" => "Y"
82 );
83
84 $Alter_priv_arr = array(
85 "N" => "N",
86 "Y" => "Y"
87 );
88
89 $months["01"] = "January";
90 $months["02"] = "February";
91 $months["03"] = "March";
92 $months["04"] = "April";
93 $months["05"] = "May";
94 $months["06"] = "June";
95 $months["07"] = "July";
96 $months["08"] = "August";
97 $months["09"] = "September";
98 $months["10"] = "October";
99 $months["11"] = "November";
100 $months["12"] = "December";
101 ?>
102
103
104 <? /********** Delete *****************************************************/ ?>
105 <? if (isset($action) && $action == "erase"): ?>
106
107 <? $result = mysqlquery("mysql","DELETE FROM host WHERE Host='$par'");
108 if (!empty($result)) {
109 callback_js("action=browselist&start=0");
110 } else {
111 echo mysql_error()."<BR>\n";
112 }
113 ?>
114 <? endif ?>
115
116 <? /********** Store New **************************************************/ ?>
117 <? if (isset($action) && $action == "storenew"): ?>
118
119 <?//*** Check data
120 $ok = 1;
121 echo "<TABLE BORDER=0>";
122
123
124 $fields = "";
125 $values = "";
126
127 $Host=chop($Host);
128
129 if ($Host == "") {
130 $ok = 0;
131 echo "Host - must be specified !<BR>";
132 } else {
133 $fields .= ",Host";
134 $values.=",'$Host'";
135 }
136
137 $Db=chop($Db);
138
139 if ($Db == "") {
140 $ok = 0;
141 echo "Db - must be specified !<BR>";
142 } else {
143 $fields .= ",Db";
144 $values.=",'$Db'";
145 }
146
147 $Select_priv=chop($Select_priv);
148
149 if ($Select_priv == "") {
150 $ok = 0;
151 echo "Select - must be specified !<BR>";
152 } else {
153 $fields .= ",Select_priv";
154 $values.=",'$Select_priv'";
155 }
156
157 $Insert_priv=chop($Insert_priv);
158
159 if ($Insert_priv == "") {
160 $ok = 0;
161 echo "Insert - must be specified !<BR>";
162 } else {
163 $fields .= ",Insert_priv";
164 $values.=",'$Insert_priv'";
165 }
166
167 $Update_priv=chop($Update_priv);
168
169 if ($Update_priv == "") {
170 $ok = 0;
171 echo "Update - must be specified !<BR>";
172 } else {
173 $fields .= ",Update_priv";
174 $values.=",'$Update_priv'";
175 }
176
177 $Delete_priv=chop($Delete_priv);
178
179 if ($Delete_priv == "") {
180 $ok = 0;
181 echo "Delete - must be specified !<BR>";
182 } else {
183 $fields .= ",Delete_priv";
184 $values.=",'$Delete_priv'";
185 }
186
187 $Create_priv=chop($Create_priv);
188
189 if ($Create_priv == "") {
190 $ok = 0;
191 echo "Create - must be specified !<BR>";
192 } else {
193 $fields .= ",Create_priv";
194 $values.=",'$Create_priv'";
195 }
196
197 $Drop_priv=chop($Drop_priv);
198
199 if ($Drop_priv == "") {
200 $ok = 0;
201 echo "Drop - must be specified !<BR>";
202 } else {
203 $fields .= ",Drop_priv";
204 $values.=",'$Drop_priv'";
205 }
206
207 $Grant_priv=chop($Grant_priv);
208
209 if ($Grant_priv == "") {
210 $ok = 0;
211 echo "Grant - must be specified !<BR>";
212 } else {
213 $fields .= ",Grant_priv";
214 $values.=",'$Grant_priv'";
215 }
216
217 $References_priv=chop($References_priv);
218
219 if ($References_priv == "") {
220 $ok = 0;
221 echo "References - must be specified !<BR>";
222 } else {
223 $fields .= ",References_priv";
224 $values.=",'$References_priv'";
225 }
226
227 $Index_priv=chop($Index_priv);
228
229 if ($Index_priv == "") {
230 $ok = 0;
231 echo "Index - must be specified !<BR>";
232 } else {
233 $fields .= ",Index_priv";
234 $values.=",'$Index_priv'";
235 }
236
237 $Alter_priv=chop($Alter_priv);
238
239 if ($Alter_priv == "") {
240 $ok = 0;
241 echo "Alter - must be specified !<BR>";
242 } else {
243 $fields .= ",Alter_priv";
244 $values.=",'$Alter_priv'";
245 }
246
247 echo "</TABLE>";
248 if (!$ok):
249 echo "Error!";
250 echo "<BR><A HREF=javascript:history.back()>Try again</A>";
251 exit;
252 endif;
253 ?>
254
255 <?
256
257 $fields = substr($fields,1,strlen($fields)-1);
258 $values = substr($values,1,strlen($values)-1);
259
260 $result = mysqlquery("mysql","INSERT INTO host ($fields) VALUES ($values)");
261 if (!empty($result)) {
262 $result = mysqlquery("mysql","FLUSH PRIVILEGES");
263 if (!empty($result)) {
264 } else {
265 echo mysql_error()."<BR>\n";
266 }
267 callback_js("action=browselist&start=0");
268 } else {
269 echo mysql_error()."<BR>\n";
270 }
271 ?>
272 <? endif ?>
273
274 <? /********** Save edited ************************************************/ ?>
275 <? if (isset($action) && $action == "save"): ?>
276 <? //*** Check data
277 $ok = 1;
278 echo "<TABLE BORDER=0>";
279
280 $fields = "";
281 $Host=chop($Host);
282 if ($Host == "") {
283 $ok = 0;
284 echo "Host - must be specified !<BR>";
285 }
286
287 $fields.=',';
288 $fields.="Host=";
289 $fields.="'$Host'";
290
291 $Db=chop($Db);
292 if ($Db == "") {
293 $ok = 0;
294 echo "Db - must be specified !<BR>";
295 }
296
297 $fields.=',';
298 $fields.="Db=";
299 $fields.="'$Db'";
300
301 $Select_priv=chop($Select_priv);
302 if ($Select_priv == "") {
303 $ok = 0;
304 echo "Select - must be specified !<BR>";
305 }
306
307 $fields.=',';
308 $fields.="Select_priv=";
309 $fields.="'$Select_priv'";
310
311 $Insert_priv=chop($Insert_priv);
312 if ($Insert_priv == "") {
313 $ok = 0;
314 echo "Insert - must be specified !<BR>";
315 }
316
317 $fields.=',';
318 $fields.="Insert_priv=";
319 $fields.="'$Insert_priv'";
320
321 $Update_priv=chop($Update_priv);
322 if ($Update_priv == "") {
323 $ok = 0;
324 echo "Update - must be specified !<BR>";
325 }
326
327 $fields.=',';
328 $fields.="Update_priv=";
329 $fields.="'$Update_priv'";
330
331 $Delete_priv=chop($Delete_priv);
332 if ($Delete_priv == "") {
333 $ok = 0;
334 echo "Delete - must be specified !<BR>";
335 }
336
337 $fields.=',';
338 $fields.="Delete_priv=";
339 $fields.="'$Delete_priv'";
340
341 $Create_priv=chop($Create_priv);
342 if ($Create_priv == "") {
343 $ok = 0;
344 echo "Create - must be specified !<BR>";
345 }
346
347 $fields.=',';
348 $fields.="Create_priv=";
349 $fields.="'$Create_priv'";
350
351 $Drop_priv=chop($Drop_priv);
352 if ($Drop_priv == "") {
353 $ok = 0;
354 echo "Drop - must be specified !<BR>";
355 }
356
357 $fields.=',';
358 $fields.="Drop_priv=";
359 $fields.="'$Drop_priv'";
360
361 $Grant_priv=chop($Grant_priv);
362 if ($Grant_priv == "") {
363 $ok = 0;
364 echo "Grant - must be specified !<BR>";
365 }
366
367 $fields.=',';
368 $fields.="Grant_priv=";
369 $fields.="'$Grant_priv'";
370
371 $References_priv=chop($References_priv);
372 if ($References_priv == "") {
373 $ok = 0;
374 echo "References - must be specified !<BR>";
375 }
376
377 $fields.=',';
378 $fields.="References_priv=";
379 $fields.="'$References_priv'";
380
381 $Index_priv=chop($Index_priv);
382 if ($Index_priv == "") {
383 $ok = 0;
384 echo "Index - must be specified !<BR>";
385 }
386
387 $fields.=',';
388 $fields.="Index_priv=";
389 $fields.="'$Index_priv'";
390
391 $Alter_priv=chop($Alter_priv);
392 if ($Alter_priv == "") {
393 $ok = 0;
394 echo "Alter - must be specified !<BR>";
395 }
396
397 $fields.=',';
398 $fields.="Alter_priv=";
399 $fields.="'$Alter_priv'";
400 if (!$ok):
401 echo "Error!";
402 echo "<BR><A HREF=javascript:history.back()>Try again</A>";
403 exit;
404 endif;
405
406 $fields = substr($fields,1,strlen($fields)-1);
407
408 $result = mysqlquery("mysql","UPDATE host SET $fields WHERE Host='$par'");
409 if (!empty($result)) {
410 $result = mysqlquery("mysql","FLUSH PRIVILEGES");
411 if (!empty($result)) {
412 } else {
413 echo mysql_error()."<BR>\n";
414 }
415
416 callback_js("action=browselist&start=0");
417 } else {
418 echo mysql_error()."<BR>\n";
419 }
420 ?>
421 <? endif ?>
422
423 <?
424 //*** Calculate number of records
425 if (empty($found)) {
426 if (isset($action) && $action == "search") {
427 $result = mysqlquery("mysql","SELECT COUNT(*) FROM host WHERE ($whichfield LIKE '%" . $searchvalue . "%') ORDER BY $whichfield");
428 } else {
429 $result = mysqlquery("mysql","SELECT COUNT(*) FROM host");
430 }
431 $found = mysql_result($result,0,0);
432 }
433
434 if ($limit == 0) $limit = $found; ?>
435
436 <TABLE WIDTH=100% BORDER=0><TR>
437 <TD BGCOLOR="#FFFFFF">[ <A HREF="mysqldb_gr_perms.php">Grant/Revoke</A>
438 | <A HREF="<? echo $PHP_SELF ?>?action=browselist&found=<? echo $found; ?>&start=0">List all</A>
439 | <A HREF="<? echo $PHP_SELF ?>?action=searchform">Search</A> ]</TD>
440
441 </TR></TABLE>
442
443 <?
444 if (($action == "search") || ($action == "browselist")):
445 if (empty($start)) $start=0;
446 if (isset($start) && ($start>0)) {
447 echo "<A HREF=\"$PHP_SELF?action=$action";
448 if (isset($action) && $action == "search") echo "&whichfield=$whichfield&searchvalue=$searchvalue";
449 echo "&found=$found&start=",max($start-$limit,0),"\"><<<Previous $limit</A> ";
450 }
451
452 if (isset($start) && ((($start+$limit) < $found))) {
453 echo "<A HREF=\"$PHP_SELF?action=$action";
454 if ($action == "search") echo "&whichfield=$whichfield&searchvalue=$searchvalue";
455 echo "&found=$found&start=",$start+$limit,"\">>>>Next ",min($found-$start-$limit,$limit),"</A>";
456 }
457 endif;
458 ?>
459
460 <? /********** Warn Delete ************************************************/ ?>
461 <? if (isset($action) && $action == "warnerase"): ?>
462 <H1>Are you sure you want to delete this record?</H1>
463 <A HREF="<? echo $PHP_SELF ?>?action=erase&par=<? echo urlencode($par)?>">Yes</A> <A HREF=javascript:history.back()>No</A>
464 <? endif ?>
465
466 <?/********** Search *****************************************************/
467
468 if (isset($action) && $action == "search"):
469
470 $result = mysqlquery("mysql","SELECT * FROM host WHERE ($whichfield LIKE '%" . $searchvalue . "%') ORDER BY $whichfield LIMIT $start,$limit");
471 echo "<H3>Search for '$searchvalue ' in '$whichfield ' returned $found hits</H3>";
472
473 $num = mysql_numrows($result);
474 $c1 = "#EEEEEE";
475 $c2 = "#CCCCCC";
476 ?>
477 <CENTER>
478 <TABLE BORDER=0 CELLSPACING=1 CELLPADDING=1>
479 <TR>
480 <TH></TH><TH>Host</TH><TH>Db</TH>
481 </TR>
482 <?
483 $c = "";
484 for ($i =0 ;$i < $num; $i++):
485 $c = ($c == $c1)?$c2:$c1;
486 echo "<TR BGCOLOR=\"$c\">";
487 echo "<TD><A HREF=\"$PHP_SELF?action=detail&par=",urlencode(mysql_result($result,$i,"Host")),"\">",mysql_result($result,$i,"Host"),"</A></TD>";
488
489 echo "<TD>";
490 $val = mysql_result($result, $i, "Host");
491 print_sp($val);
492 echo "</TD>";
493
494 echo "<TD>";
495 $val = mysql_result($result, $i, "Db");
496 print_sp($val);
497 echo "</TD>";
498
499 echo "</TR>";
500 endfor;
501 echo "</TABLE></CENTER>";
502
503 mysql_free_result($result);
504 endif /* Search */ ?>
505
506 <?/********** Show all *****************************************************/
507 if (isset($action) && ($action == "browselist")):
508 echo "<H3 ALIGN=center>Hosts that are allowed to Connect to this server</H3>";
509
510 $result = mysqlquery("mysql","SELECT * FROM host ORDER BY Host LIMIT $start,$limit");
511 $num = mysql_numrows($result);
512 $c1 = "#EEEEEE";
513 $c2 = "#CCCCCC";
514 ?>
515 <CENTER>
516 <TABLE BORDER=0 CELLSPACING=1 CELLPADDING=1>
517 <TR>
518 <TH>Details</TH><TH>Host</TH><TH>Db</TH>
519 </TR>
520 <?
521 $c = "";
522 for ($i =0 ;$i < $num; $i++):
523 $c = ($c == $c1)?$c2:$c1;
524 echo "<TR BGCOLOR=\"$c\">";
525 echo "<TD><A
526 HREF=\"$PHP_SELF?action=detail&par=",urlencode(mysql_result($result,$i,"Host")),"\">**</A></TD>";
527
528 echo "<TD>";
529 $val = mysql_result($result, $i, "Host");
530 print_sp($val);
531 echo "</TD>";
532
533 echo "<TD>";
534 $val = mysql_result($result, $i, "Db");
535 print_sp($val);
536 echo "</TD>";
537
538 echo "</TR>";
539 endfor;
540 echo "</TABLE></CENTER>";
541
542 mysql_free_result($result);
543 endif /* Show all */ ?>
544
545 <?/********** Show detail **************************************************/
546 if (isset($action) && (($action == "detail") || ($action == "warnerase"))):
547
548 $result = mysqlquery("mysql","SELECT * FROM host WHERE Host='$par'");
549 echo "<H2 ALIGN=center>ID: ",mysql_result($result,0,"Host"),"</H2>";
550 ?>
551 <TABLE BORDER=0 CELLSPACING=2 CELLPADDING=2>
552 <?
553 echo "<TR><TD valign=middle><B>Host: </B></TD>";
554 echo "<TD valign=middle>";
555 print_html(mysql_result($result,0,"Host"));
556 echo "</TD></TR>";
557
558 echo "<TR><TD valign=middle><B>Db: </B></TD>";
559 echo "<TD valign=middle>";
560 print_html(mysql_result($result,0,"Db"));
561 echo "</TD></TR>";
562
563 echo "<TR><TD valign=middle><B>Select: </B></TD>";
564 echo "<TD valign=middle>";
565 echo $Select_priv_arr[mysql_result($result,0,"Select_priv")];
566 echo "</TD></TR>";
567
568 echo "<TR><TD valign=middle><B>Insert: </B></TD>";
569 echo "<TD valign=middle>";
570 echo $Insert_priv_arr[mysql_result($result,0,"Insert_priv")];
571 echo "</TD></TR>";
572
573 echo "<TR><TD valign=middle><B>Update: </B></TD>";
574 echo "<TD valign=middle>";
575 echo $Update_priv_arr[mysql_result($result,0,"Update_priv")];
576 echo "</TD></TR>";
577
578 echo "<TR><TD valign=middle><B>Delete: </B></TD>";
579 echo "<TD valign=middle>";
580 echo $Delete_priv_arr[mysql_result($result,0,"Delete_priv")];
581 echo "</TD></TR>";
582
583 echo "<TR><TD valign=middle><B>Create: </B></TD>";
584 echo "<TD valign=middle>";
585 echo $Create_priv_arr[mysql_result($result,0,"Create_priv")];
586 echo "</TD></TR>";
587
588 echo "<TR><TD valign=middle><B>Drop: </B></TD>";
589 echo "<TD valign=middle>";
590 echo $Drop_priv_arr[mysql_result($result,0,"Drop_priv")];
591 echo "</TD></TR>";
592
593 echo "<TR><TD valign=middle><B>Grant: </B></TD>";
594 echo "<TD valign=middle>";
595 echo $Grant_priv_arr[mysql_result($result,0,"Grant_priv")];
596 echo "</TD></TR>";
597
598 echo "<TR><TD valign=middle><B>References: </B></TD>";
599 echo "<TD valign=middle>";
600 echo $References_priv_arr[mysql_result($result,0,"References_priv")];
601 echo "</TD></TR>";
602
603 echo "<TR><TD valign=middle><B>Index: </B></TD>";
604 echo "<TD valign=middle>";
605 echo $Index_priv_arr[mysql_result($result,0,"Index_priv")];
606 echo "</TD></TR>";
607
608 echo "<TR><TD valign=middle><B>Alter: </B></TD>";
609 echo "<TD valign=middle>";
610 echo $Alter_priv_arr[mysql_result($result,0,"Alter_priv")];
611 echo "</TD></TR>";
612
613 ?>
614 </TABLE>
615
616 <?
617 if (isset($action) && $action == "detail"):
618 echo "<A HREF=\"$PHP_SELF?action=edit&par=",urlencode($par),"\">Edit</A>";
619 echo "<A HREF=\"$PHP_SELF?action=warnerase&par=",urlencode($par),"\"> Delete</A>";
620 endif;
621 mysql_free_result($result);
622 endif /* Show detail */
623 ?>
624
625 <?/********** New/Edit *****************************************************/?>
626 <?
627 if (isset($action) && (($action == "new") || ($action == "edit"))):
628 if ($action == "edit"):
629 $result = mysqlquery("mysql","SELECT * FROM host WHERE Host='$par'");
630 $Host=htmlspecialchars(mysql_result($result,0,"Host"));
631 $Db=htmlspecialchars(mysql_result($result,0,"Db"));
632 $Select_priv=htmlspecialchars(mysql_result($result,0,"Select_priv"));
633 $Insert_priv=htmlspecialchars(mysql_result($result,0,"Insert_priv"));
634 $Update_priv=htmlspecialchars(mysql_result($result,0,"Update_priv"));
635 $Delete_priv=htmlspecialchars(mysql_result($result,0,"Delete_priv"));
636 $Create_priv=htmlspecialchars(mysql_result($result,0,"Create_priv"));
637 $Drop_priv=htmlspecialchars(mysql_result($result,0,"Drop_priv"));
638 $Grant_priv=htmlspecialchars(mysql_result($result,0,"Grant_priv"));
639 $References_priv=htmlspecialchars(mysql_result($result,0,"References_priv"));
640 $Index_priv=htmlspecialchars(mysql_result($result,0,"Index_priv"));
641 $Alter_priv=htmlspecialchars(mysql_result($result,0,"Alter_priv"));
642 echo "<H2 ALIGN=center>Edit Host</H2>";
643 else:
644 echo "<H2 ALIGN=center>ADD new host connection permissions</H2>";
645 $Host="";
646 $Db="";
647 $Select_priv="";
648 $Insert_priv="";
649 $Update_priv="";
650 $Delete_priv="";
651 $Create_priv="";
652 $Drop_priv="";
653 $Grant_priv="";
654 $References_priv="";
655 $Index_priv="";
656 $Alter_priv="";
657 endif;
658
659 if ($action == "new"):
660 echo "<FORM ACTION=\"$PHP_SELF?action=storenew\" METHOD=POST NAME=phpgen1>";
661 else:
662 echo "<FORM ACTION=\"$PHP_SELF?action=save&par=",urlencode($par),"\" METHOD=POST NAME=phpgen1>";
663 endif;
664
665 echo "<CENTER><TABLE BORDER=0 CELLPADDING=2>";
666
667 //******************************** HOST (stand)
668 echo "<TR><TD ALIGN=RIGHT VALIGN=MIDDLE><B>Host: </TD><TD VALIGN=MIDDLE>";
669 echo "<INPUT NAME=Host SIZE=60 MAXLENGTH=60 VALUE='$Host'></TD></TR>";
670
671
672 //******************************** DB (stand)
673 echo "<TR><TD ALIGN=RIGHT VALIGN=MIDDLE><B>Db: </TD><TD VALIGN=MIDDLE>";
674 echo "<INPUT NAME=Db SIZE=32 MAXLENGTH=32 VALUE='$Db'></TD></TR></TABLE>";
675
676
677 //******************************** SELECT_PRIV (plist)
678 echo "<TABLE><TR><TD ALIGN=RIGHT VALIGN=TOP><B>Select: </TD><TD VALIGN=TOP>";
679 echo "<SELECT NAME=Select_priv SINGLE>";
680 array2select($Select_priv_arr,$Select_priv);
681 echo "</SELECT></TD>";
682
683 //******************************** INSERT_PRIV (plist)
684 echo "<TD ALIGN=RIGHT VALIGN=TOP><B>Insert: </TD><TD VALIGN=TOP>";
685 echo "<SELECT NAME=Insert_priv SINGLE>";
686 array2select($Insert_priv_arr,$Insert_priv);
687 echo "</SELECT></TD>";
688
689 //******************************** UPDATE_PRIV (plist)
690 echo "<TD ALIGN=RIGHT VALIGN=TOP><B>Update: </TD><TD VALIGN=TOP>";
691 echo "<SELECT NAME=Update_priv SINGLE>";
692 array2select($Update_priv_arr,$Update_priv);
693 echo "</SELECT></TD>";
694
695 //******************************** DELETE_PRIV (plist)
696 echo "<TD ALIGN=RIGHT VALIGN=TOP><B>Delete: </TD><TD VALIGN=TOP>";
697 echo "<SELECT NAME=Delete_priv SINGLE>";
698 array2select($Delete_priv_arr,$Delete_priv);
699 echo "</SELECT></TD></TR>";
700
701 //******************************** CREATE_PRIV (plist)
702 echo "<TR><TD ALIGN=RIGHT VALIGN=TOP><B>Create: </TD><TD VALIGN=TOP>";
703 echo "<SELECT NAME=Create_priv SINGLE>";
704 array2select($Create_priv_arr,$Create_priv);
705 echo "</SELECT></TD>";
706
707 //******************************** DROP_PRIV (plist)
708 echo "<TD ALIGN=RIGHT VALIGN=TOP><B>Drop: </TD><TD VALIGN=TOP>";
709 echo "<SELECT NAME=Drop_priv SINGLE>";
710 array2select($Drop_priv_arr,$Drop_priv);
711 echo "</SELECT></TD>";
712
713 //******************************** GRANT_PRIV (plist)
714 echo "<TD ALIGN=RIGHT VALIGN=TOP><B>Grant: </TD><TD VALIGN=TOP>";
715 echo "<SELECT NAME=Grant_priv SINGLE>";
716 array2select($Grant_priv_arr,$Grant_priv);
717 echo "</SELECT></TD>";
718
719 //******************************** REFERENCES_PRIV (plist)
720 echo "<TD ALIGN=RIGHT VALIGN=TOP><B>References: </TD><TD VALIGN=TOP>";
721 echo "<SELECT NAME=References_priv SINGLE>";
722 array2select($References_priv_arr,$References_priv);
723 echo "</SELECT></TD></TR>";
724
725 //******************************** INDEX_PRIV (plist)
726 echo "<TR><TD ALIGN=RIGHT VALIGN=TOP><B>Index: </TD><TD VALIGN=TOP>";
727 echo "<SELECT NAME=Index_priv SINGLE>";
728 array2select($Index_priv_arr,$Index_priv);
729 echo "</SELECT></TD>";
730
731 //******************************** ALTER_PRIV (plist)
732 echo "<TD ALIGN=RIGHT VALIGN=TOP><B>Alter: </TD><TD VALIGN=TOP>";
733 echo "<SELECT NAME=Alter_priv SINGLE>";
734 array2select($Alter_priv_arr,$Alter_priv);
735 echo "</SELECT></TD></TR>";
736
737 echo "</TABLE>";
738 echo "<INPUT TYPE=submit NAME='Save' VALUE='Save Permissions'> ";
739
740 if ($action == "new"):
741 echo "<INPUT TYPE=reset VALUE='Clear all fields'>";
742 endif;
743
744 echo "</FORM></CENTER>";
745 print "<P>";
746 print "<A HREF=mysqldb_newuser.php>Back to User</A>";
747
748 mysql_free_result($result);
749 endif; /* New/edit */
750 ?>
751
752 <? /********** Search form ************************************************/
753 if (isset($action) && $action == "searchform"):
754
755 echo "<TABLE BORDER=0 CELLPADDING=2>";
756 echo "<TR><TD ALIGN=RIGHT><B>Host:</B></TD>";
757 echo "<TD><FORM METHOD=POST ACTION='$PHP_SELF'>";
758 echo "<INPUT TYPE=HIDDEN NAME=action VALUE=search>";
759 echo "<INPUT TYPE=HIDDEN NAME=start VALUE=0>";
760 echo "<INPUT NAME=searchvalue>";
761 echo "<INPUT TYPE=HIDDEN NAME=whichfield VALUE='Host'></TD>";
762 echo "<TD><INPUT TYPE=SUBMIT VALUE='SEARCH'>";
763 echo "</FORM></TD>";
764 echo "</TR>";
765
766 echo "<TR><TD ALIGN=RIGHT><B>Db:</B></TD>";
767 echo "<TD><FORM METHOD=POST ACTION='$PHP_SELF'>";
768 echo "<INPUT TYPE=HIDDEN NAME=action VALUE=search>";
769 echo "<INPUT TYPE=HIDDEN NAME=start VALUE=0>";
770 echo "<INPUT NAME=searchvalue>";
771 echo "<INPUT TYPE=HIDDEN NAME=whichfield VALUE='Db'></TD>";
772 echo "<TD><INPUT TYPE=SUBMIT VALUE='SEARCH'>";
773 echo "</FORM></TD>";
774 echo "</TR>";
775
776 echo "</TABLE>";
777 endif;
778
779
780 pageBottom();
781 ?>
| |