|
PCCS MySQLDatabase Admin Tool version 1.3.4
|
/ -> mysqldb_help.php
1 <?php
2 ////////////////////////////////////////////////////////////////////////////////////////////////////////////
3 // coder: Chauncey Thorn
4 // email: cthorn
5 /************************************************************************
6 PCCS MySQLDatabase Admin Tool
7 Copyright (C) 1999 Chauncey Thorn
8
9 This program is free software; you can redistribute it and/or
10 modify it under the terms of the GNU General Public License
11 as published by the Free Software Foundation; either version 2
12 of the License, or (at your option) any later version.
13
14 This program is distributed in the hope that it will be useful,
15 but WITHOUT ANY WARRANTY; without even the implied warranty of
16 MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
17 GNU General Public License for more details.
18
19 You should have received a copy of the GNU General Public License
20 along with this program; if not, write to the Free Software
21 Foundation, Inc., 59 Temple Place - Suite 330, Boston, MA , USA.
22 **************************************************************************/
23 /*
24 require('login.php');
25 require('incs/dbconnect.php');
26 require('incs/global.vars.php');
27 require('incs/lang_eng.php');
28 */
29
30 // moving to a single file for global stuff
31
32 require('mysqldb_app_includes.php');
33
34
35 common_header($str_mainTitle);
36 pageTop("PCCS MySQLAdmin Tool: HELP SECTION","600");
37
38 $link_array = array(
39 "$str_mainMenu" => "./",
40 "$str_installscriptlink" => "installscript/mysqldb_installscript.php",
41 "$str_createwebacct" => "mysqldb_create_webuser.php",
42 "LOGOUT" => "logout.php"
43 );
44
45 print "<BR>";
46 print "<CENTER>";
47 navBar($link_array);
48 print "</CENTER>";
49 print "<BR>";
50
51
52
53
54 // $appname = "PCCS MySQLDatabase Admin Tool";
55 $section = strtoupper($help);
56
57 print "<b>Help Section for <font color=red>: " . $section . "</font></b>";
58 print "<P>This utility was written with administrators and developers in
59 mind.";
60 print "<HR NOSHADE>\n";
61
62 /*
63 ** Login Help
64 **
65 */
66 if($help == "login"):
67 print "<P>";
68 print "<font color=red>PLEASE NOTE</font>:
69 <u>You will still need to modify the incs/dbuserpasswd.php</u>
70 <BR>
71 That this login system is for logging it to the
72 Application and not interacting with the database.<BR>
73 You still need to have an ACCOUNT on the Database
74 ";
75 print "The login system is very simple but secure!";
76 print "<P>";
77 print "ALL you need to do is enter a userid and password that exist
78 allowing you to login.";
79 print "<P>";
80 print "<A HREF=mysqldb_help?help=helpsystem>Back to Help</A>";
81
82 endif;
83
84 /*
85 ** Help System
86 **
87 */
88
89
90 if($help == "helpsystem"):
91
92 $sections[] = "mainmenu";
93 $sections[] = "login";
94 $sections[] = "installscripts";
95 $sections[] = "usermgmt";
96 $sections[] = "dbmgmt";
97 $sections[] = "querytool";
98 $sections[] = "tools";
99 $sections[] = "syslogs";
100 $sections[] = "webaccount";
101
102 $count_sections = count($sections);
103
104 print "View : <A HREF=DOCS/COPYING>COPYING</A>
105 | <A HREF=DOCS/INSTALL>INSTALL</A>
106 | <A HREF=DOCS/README>README</A>
107 ";
108 print "<P>";
109 print "Help Section for this Application";
110 print "<P>";
111 for($i=0; $i< $count_sections; $i++) {
112 print "<LI><A HREF=".$PHP_SELF."?help=" . $sections[$i] . ">" .
113 strtoupper($sections[$i])
114 . "</A>\n";
115 }
116 print "<P>";
117 print "<A HREF=./>Back to Main</A>";
118 endif;
119
120
121 /*
122 ** Main Menu Help
123 **
124 */
125 if($help == "mainmenu"):
126 print "
127 The MAIN MENU is primary the Interface for this application.<P>
128 Providing links to screens that allow you to manage various aspects
129 of your MySQL Database";
130 print "<P>";
131 print "<A HREF=mysqldb_help?help=helpsystem>Back to Help</A>";
132
133 endif;
134
135
136 /*
137 **
138 ** User Mgmt Help
139 */
140 if($help == "usermgmt"):
141 print "
142 User Management<P>
143 <li>Template(s)</li><p>
144 <ul>
145 This option allows you to create an account using predefined
146 templates.<P>
147 <b>BASIC</b> = USAGE only<BR>
148 <b>ADMIN</b> = ALL Privs granted<BR>
149 <b>ADVANCE</b> = SELECT, INSERT, UPDATE, DELETE<BR>
150 <b>OPERATOR</b> = same as ADVANCE but with FILE, INDEX, DROP, RELOAD<P>
151 </ul>
152 <P>
153 Managing Users via MySQL permission tables
154 <P>
155 <li>ADD TO USER</li><p>
156 <ul>
157 This option adds the user to the USER table only. Any
158 permissions granted here are good for *all* databases. Additional
159 rights for any given database can be given with the Add for
160 Database option. Every user/host pair *must* have a listing here
161 since password information for the paris is stored
162 here.
163 </ul>
164 <p>
165 <li>ADD TO DATABASE</li><p>
166 <ul>
167 This will add permissions for a user/host pair to a
168 particular database.</ul>
169 <p>
170 <li>ADD TO HOST<p>
171 <ul>
172 This will add permissions for a user/host pair to a
173 particular database.
174 </ul><p>
175
176 <li>GRANT/REVOKE<p>
177 <ul>
178 This will grant/revoke database permissions to/from a user<P>
179
180 </ul><p>
181
182 ";
183 print "<P>";
184 print "<A HREF=mysqldb_help?help=helpsystem>Back to Help</A>";
185
186 endif;
187
188 /*
189 ** DB Management Help
190 **
191 */
192 if($help == "dbmgmt"):
193 print "
194 DATABASES<P>
195 <UL>
196 <LI>View Table Fields
197 <LI>View Data - Display data in table
198 <LI>View Indexes - see what indexes are on this table
199 <LI>Analyze - 3.23.xx series only (Read Mysql DOCs)
200 <LI>Check/Repair - 3.23.xx series only (Read Mysql DOCs)
201 <LI>PHP FrameWork - Generate a script that allows ADD, LIST, MODIFY and SEARCH on this
202 table
203 </UL>
204 <P>
205 OPTIMIZE DB
206 <P>
207 <UL>
208 <LI>This is a script I found and intergated look at script file mysqldb_optimize.php
209 </UL>
210 <P>
211 RESTORE DB
212 <P>
213 <UL>
214 <LI>To use this feature you need to run \$APPROOT/bin/backup.sh. Modify the
215 dbbackupdir= . Once you begin to use the backup system. Restore files will begin
216 to appear under this option
217 </UL>
218 <P>
219 DROP DB
220 <P>
221 <UL>
222 <LI> This means drop this database ? if you really didn't me to say yes and have
223 be using the backup.sh you maybe able to restore...
224 </UL>
225 <P>
226 BACKUP DB
227 <P>
228 <UL>
229 <LI>This option allows you to create a tar.gz file for download... it uses the
230 mysqldump --opt
231 </UL>
232 <P>
233 CREATE DUMP
234 <P>
235 <UL>
236 <LI>This option allow you to create a dumpfile of the selected database with or
237 without data.
238 </UL>
239 <P>
240
241 ";
242 print "<P>";
243 print "<A HREF=mysqldb_help?help=helpsystem>Back to Help</A>";
244 endif;
245
246 /*
247 ** QueryTool Help
248 **
249 */
250 if($help == "querytool"):
251 print "This is what it means.. A query tool..<P>";
252 print "First you will need to select the database to run your
253 query against. After that you will be prompted to query a single table
254 or type in your query using the freeform.<P>";
255 print "Using the single table method, we help you build your query.
256 Now if you want to query more that one table the Form Query will
257 need to be used.<P>";
258
259 $eg_qry = "SELECT User,Password
260 FROM user
261 WHERE User = 'userid'
262 HAVING Password=password('password')";
263 print "Example Query : " . $eg_qry;
264 print "<P>";
265 print "As you are creating your query you can either<P>
266 <LI>display the query results
267 <LI>have the results written to a HTML file
268 <LI>or have the results written to XML .";
269
270 print "<P>";
271 print "<A HREF=mysqldb_help?help=helpsystem>Back to Help</A>";
272 endif;
273
274 /*
275 ** Syslog Help
276 **
277 */
278 if($help == "syslogs"):
279 print "This system logs actions on the system";
280
281 print "<P>";
282 print "<A HREF=mysqldb_help?help=helpsystem>Back to Help</A>";
283 endif;
284
285 /*
286 ** Installscripts
287 **
288 */
289 if($help == "installscripts"):
290 print "
291 Primary designed for the PHP developer or PHP/Web Hosting Administrator<P>
292 This section allow you to generate PHP scripts. That will create
293 the database required to power the application being deployed.
294 <BR>
295 This system creates 2 types of scripts: PHP or Shell
296 <P>
297 ";
298 print "<P>";
299 print "<A HREF=mysqldb_help?help=helpsystem>Back to Help</A>";
300
301 endif;
302
303 /*
304 ** Tools Help
305 **
306 */
307 if($help == "tools"):
308 print "
309 These are a collection of tools that allow you to:
310 <P>
311 <ul>
312 <li>Flush Status
313 <li>Flush Hosts
314 <li>Flush Logs
315 <li>Flush Tables
316 </ul>
317 ";
318 print "<P>";
319 print "<A HREF=mysqldb_help?help=helpsystem>Back to Help</A>";
320
321 endif;
322
323 if($help == "webaccount"):
324 print "
325 Web Hosting Module<P>";
326 print "This section performs a number of task: create user, database, and a
327 number of php scripts.<P>
328 By default the application creates:
329 <UL>
330 <LI>Database Include script
331 <LI>FeedBack Form using mail()
332 <LI>Text Counter
333 <LI>Backup Script
334 </UL>";
335 print "<P>
336 Additional Scripts are available: <i>Each script has a table created for it</i>
337 <UL>
338 <LI>News System
339 <LI>Redirect Script
340 <LI>Auth Script
341 <LI>Random Script
342 <LI>Referer Script
343 <P>";
344 print "<P>";
345 print "<A HREF=mysqldb_help?help=helpsystem>Back to Help</A>";
346
347 endif;
348
349 pageBottom();
350 ?>
| |