pccsmysqladm/COPYING100644 0 143 43127 7172400713 13277 0ustar rootnobody GNU GENERAL PUBLIC LICENSE Version 2, June 1991 Copyright (C) 1989, 1991 Free Software Foundation, Inc. 59 Temple Place, Suite 330, Boston, MA 02111-1307 USA Everyone is permitted to copy and distribute verbatim copies of this license document, but changing it is not allowed. Preamble The licenses for most software are designed to take away your freedom to share and change it. By contrast, the GNU General Public License is intended to guarantee your freedom to share and change free software--to make sure the software is free for all its users. This General Public License applies to most of the Free Software Foundation's software and to any other program whose authors commit to using it. (Some other Free Software Foundation software is covered by the GNU Library General Public License instead.) You can apply it to your programs, too. When we speak of free software, we are referring to freedom, not price. Our General Public Licenses are designed to make sure that you have the freedom to distribute copies of free software (and charge for this service if you wish), that you receive source code or can get it if you want it, that you can change the software or use pieces of it in new free programs; and that you know you can do these things. To protect your rights, we need to make restrictions that forbid anyone to deny you these rights or to ask you to surrender the rights. These restrictions translate to certain responsibilities for you if you distribute copies of the software, or if you modify it. For example, if you distribute copies of such a program, whether gratis or for a fee, you must give the recipients all the rights that you have. You must make sure that they, too, receive or can get the source code. And you must show them these terms so they know their rights. We protect your rights with two steps: (1) copyright the software, and (2) offer you this license which gives you legal permission to copy, distribute and/or modify the software. Also, for each author's protection and ours, we want to make certain that everyone understands that there is no warranty for this free software. If the software is modified by someone else and passed on, we want its recipients to know that what they have is not the original, so that any problems introduced by others will not reflect on the original authors' reputations. Finally, any free program is threatened constantly by software patents. We wish to avoid the danger that redistributors of a free program will individually obtain patent licenses, in effect making the program proprietary. To prevent this, we have made it clear that any patent must be licensed for everyone's free use or not licensed at all. The precise terms and conditions for copying, distribution and modification follow. GNU GENERAL PUBLIC LICENSE TERMS AND CONDITIONS FOR COPYING, DISTRIBUTION AND MODIFICATION 0. This License applies to any program or other work which contains a notice placed by the copyright holder saying it may be distributed under the terms of this General Public License. The "Program", below, refers to any such program or work, and a "work based on the Program" means either the Program or any derivative work under copyright law: that is to say, a work containing the Program or a portion of it, either verbatim or with modifications and/or translated into another language. (Hereinafter, translation is included without limitation in the term "modification".) Each licensee is addressed as "you". Activities other than copying, distribution and modification are not covered by this License; they are outside its scope. The act of running the Program is not restricted, and the output from the Program is covered only if its contents constitute a work based on the Program (independent of having been made by running the Program). Whether that is true depends on what the Program does. 1. You may copy and distribute verbatim copies of the Program's source code as you receive it, in any medium, provided that you conspicuously and appropriately publish on each copy an appropriate copyright notice and disclaimer of warranty; keep intact all the notices that refer to this License and to the absence of any warranty; and give any other recipients of the Program a copy of this License along with the Program. You may charge a fee for the physical act of transferring a copy, and you may at your option offer warranty protection in exchange for a fee. 2. You may modify your copy or copies of the Program or any portion of it, thus forming a work based on the Program, and copy and distribute such modifications or work under the terms of Section 1 above, provided that you also meet all of these conditions: a) You must cause the modified files to carry prominent notices stating that you changed the files and the date of any change. b) You must cause any work that you distribute or publish, that in whole or in part contains or is derived from the Program or any part thereof, to be licensed as a whole at no charge to all third parties under the terms of this License. c) If the modified program normally reads commands interactively when run, you must cause it, when started running for such interactive use in the most ordinary way, to print or display an announcement including an appropriate copyright notice and a notice that there is no warranty (or else, saying that you provide a warranty) and that users may redistribute the program under these conditions, and telling the user how to view a copy of this License. (Exception: if the Program itself is interactive but does not normally print such an announcement, your work based on the Program is not required to print an announcement.) These requirements apply to the modified work as a whole. If identifiable sections of that work are not derived from the Program, and can be reasonably considered independent and separate works in themselves, then this License, and its terms, do not apply to those sections when you distribute them as separate works. But when you distribute the same sections as part of a whole which is a work based on the Program, the distribution of the whole must be on the terms of this License, whose permissions for other licensees extend to the entire whole, and thus to each and every part regardless of who wrote it. Thus, it is not the intent of this section to claim rights or contest your rights to work written entirely by you; rather, the intent is to exercise the right to control the distribution of derivative or collective works based on the Program. In addition, mere aggregation of another work not based on the Program with the Program (or with a work based on the Program) on a volume of a storage or distribution medium does not bring the other work under the scope of this License. 3. You may copy and distribute the Program (or a work based on it, under Section 2) in object code or executable form under the terms of Sections 1 and 2 above provided that you also do one of the following: a) Accompany it with the complete corresponding machine-readable source code, which must be distributed under the terms of Sections 1 and 2 above on a medium customarily used for software interchange; or, b) Accompany it with a written offer, valid for at least three years, to give any third party, for a charge no more than your cost of physically performing source distribution, a complete machine-readable copy of the corresponding source code, to be distributed under the terms of Sections 1 and 2 above on a medium customarily used for software interchange; or, c) Accompany it with the information you received as to the offer to distribute corresponding source code. (This alternative is allowed only for noncommercial distribution and only if you received the program in object code or executable form with such an offer, in accord with Subsection b above.) The source code for a work means the preferred form of the work for making modifications to it. For an executable work, complete source code means all the source code for all modules it contains, plus any associated interface definition files, plus the scripts used to control compilation and installation of the executable. However, as a special exception, the source code distributed need not include anything that is normally distributed (in either source or binary form) with the major components (compiler, kernel, and so on) of the operating system on which the executable runs, unless that component itself accompanies the executable. If distribution of executable or object code is made by offering access to copy from a designated place, then offering equivalent access to copy the source code from the same place counts as distribution of the source code, even though third parties are not compelled to copy the source along with the object code. 4. You may not copy, modify, sublicense, or distribute the Program except as expressly provided under this License. Any attempt otherwise to copy, modify, sublicense or distribute the Program is void, and will automatically terminate your rights under this License. However, parties who have received copies, or rights, from you under this License will not have their licenses terminated so long as such parties remain in full compliance. 5. You are not required to accept this License, since you have not signed it. However, nothing else grants you permission to modify or distribute the Program or its derivative works. These actions are prohibited by law if you do not accept this License. Therefore, by modifying or distributing the Program (or any work based on the Program), you indicate your acceptance of this License to do so, and all its terms and conditions for copying, distributing or modifying the Program or works based on it. 6. Each time you redistribute the Program (or any work based on the Program), the recipient automatically receives a license from the original licensor to copy, distribute or modify the Program subject to these terms and conditions. You may not impose any further restrictions on the recipients' exercise of the rights granted herein. You are not responsible for enforcing compliance by third parties to this License. 7. If, as a consequence of a court judgment or allegation of patent infringement or for any other reason (not limited to patent issues), conditions are imposed on you (whether by court order, agreement or otherwise) that contradict the conditions of this License, they do not excuse you from the conditions of this License. If you cannot distribute so as to satisfy simultaneously your obligations under this License and any other pertinent obligations, then as a consequence you may not distribute the Program at all. For example, if a patent license would not permit royalty-free redistribution of the Program by all those who receive copies directly or indirectly through you, then the only way you could satisfy both it and this License would be to refrain entirely from distribution of the Program. If any portion of this section is held invalid or unenforceable under any particular circumstance, the balance of the section is intended to apply and the section as a whole is intended to apply in other circumstances. It is not the purpose of this section to induce you to infringe any patents or other property right claims or to contest validity of any such claims; this section has the sole purpose of protecting the integrity of the free software distribution system, which is implemented by public license practices. Many people have made generous contributions to the wide range of software distributed through that system in reliance on consistent application of that system; it is up to the author/donor to decide if he or she is willing to distribute software through any other system and a licensee cannot impose that choice. This section is intended to make thoroughly clear what is believed to be a consequence of the rest of this License. 8. If the distribution and/or use of the Program is restricted in certain countries either by patents or by copyrighted interfaces, the original copyright holder who places the Program under this License may add an explicit geographical distribution limitation excluding those countries, so that distribution is permitted only in or among countries not thus excluded. In such case, this License incorporates the limitation as if written in the body of this License. 9. The Free Software Foundation may publish revised and/or new versions of the General Public License from time to time. Such new versions will be similar in spirit to the present version, but may differ in detail to address new problems or concerns. Each version is given a distinguishing version number. If the Program specifies a version number of this License which applies to it and "any later version", you have the option of following the terms and conditions either of that version or of any later version published by the Free Software Foundation. If the Program does not specify a version number of this License, you may choose any version ever published by the Free Software Foundation. 10. If you wish to incorporate parts of the Program into other free programs whose distribution conditions are different, write to the author to ask for permission. For software which is copyrighted by the Free Software Foundation, write to the Free Software Foundation; we sometimes make exceptions for this. Our decision will be guided by the two goals of preserving the free status of all derivatives of our free software and of promoting the sharing and reuse of software generally. NO WARRANTY 11. BECAUSE THE PROGRAM IS LICENSED FREE OF CHARGE, THERE IS NO WARRANTY FOR THE PROGRAM, TO THE EXTENT PERMITTED BY APPLICABLE LAW. EXCEPT WHEN OTHERWISE STATED IN WRITING THE COPYRIGHT HOLDERS AND/OR OTHER PARTIES PROVIDE THE PROGRAM "AS IS" WITHOUT WARRANTY OF ANY KIND, EITHER EXPRESSED OR IMPLIED, INCLUDING, BUT NOT LIMITED TO, THE IMPLIED WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE. THE ENTIRE RISK AS TO THE QUALITY AND PERFORMANCE OF THE PROGRAM IS WITH YOU. SHOULD THE PROGRAM PROVE DEFECTIVE, YOU ASSUME THE COST OF ALL NECESSARY SERVICING, REPAIR OR CORRECTION. 12. IN NO EVENT UNLESS REQUIRED BY APPLICABLE LAW OR AGREED TO IN WRITING WILL ANY COPYRIGHT HOLDER, OR ANY OTHER PARTY WHO MAY MODIFY AND/OR REDISTRIBUTE THE PROGRAM AS PERMITTED ABOVE, BE LIABLE TO YOU FOR DAMAGES, INCLUDING ANY GENERAL, SPECIAL, INCIDENTAL OR CONSEQUENTIAL DAMAGES ARISING OUT OF THE USE OR INABILITY TO USE THE PROGRAM (INCLUDING BUT NOT LIMITED TO LOSS OF DATA OR DATA BEING RENDERED INACCURATE OR LOSSES SUSTAINED BY YOU OR THIRD PARTIES OR A FAILURE OF THE PROGRAM TO OPERATE WITH ANY OTHER PROGRAMS), EVEN IF SUCH HOLDER OR OTHER PARTY HAS BEEN ADVISED OF THE POSSIBILITY OF SUCH DAMAGES. END OF TERMS AND CONDITIONS How to Apply These Terms to Your New Programs If you develop a new program, and you want it to be of the greatest possible use to the public, the best way to achieve this is to make it free software which everyone can redistribute and change under these terms. To do so, attach the following notices to the program. It is safest to attach them to the start of each source file to most effectively convey the exclusion of warranty; and each file should have at least the "copyright" line and a pointer to where the full notice is found. Copyright (C) 19yy This program is free software; you can redistribute it and/or modify it under the terms of the GNU General Public License as published by the Free Software Foundation; either version 2 of the License, or (at your option) any later version. This program is distributed in the hope that it will be useful, but WITHOUT ANY WARRANTY; without even the implied warranty of MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU General Public License for more details. You should have received a copy of the GNU General Public License along with this program; if not, write to the Free Software Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA 02111-1307 USA Also add information on how to contact you by electronic and paper mail. If the program is interactive, make it output a short notice like this when it starts in an interactive mode: Gnomovision version 69, Copyright (C) 19yy name of author Gnomovision comes with ABSOLUTELY NO WARRANTY; for details type `show w'. This is free software, and you are welcome to redistribute it under certain conditions; type `show c' for details. The hypothetical commands `show w' and `show c' should show the appropriate parts of the General Public License. Of course, the commands you use may be called something other than `show w' and `show c'; they could even be mouse-clicks or menu items--whatever suits your program. You should also get your employer (if you work as a programmer) or your school, if any, to sign a "copyright disclaimer" for the program, if necessary. Here is a sample; alter the names: Yoyodyne, Inc., hereby disclaims all copyright interest in the program `Gnomovision' (which makes passes at compilers) written by James Hacker. , 1 April 1989 Ty Coon, President of Vice This General Public License does not permit incorporating your program into proprietary programs. If your program is a subroutine library, you may consider it more useful to permit linking proprietary applications with the library. If this is what you want to do, use the GNU Library General Public License instead of this License. pccsmysqladm/INSTALL100644 0 143 1170 7172400713 13245 0ustar rootnobodyI'm terrible when it comes to writing documentation... some may say coding too... Anyway ... edit incs/dbconnect.inc $db_server = hostname $db_user = user (root) $db_passwd = user password You can create a user for the system and assign the results to $db_user and $db_passwd GRANT ALL on *.* to $userid@localhost IDENTIFIED BY 'password' with GRANT OPTION edit global.vars.php For web admin Variables on affect the function of the WebAdmin tool. Which is really BETA... $webshare = location where you store user home pages e.g. /home/www/htdocs/user/ $webpath = disregard $sqldir = disregard read the README file ... pccsmysqladm/INSTALL.SuSE6.3100644 0 143 3574 7172400714 14325 0ustar rootnobody This INSTALL howto was created by: "Kevin Donnelly" Thanks... Installation of PCCS_MySQLAdm on SuSE 6.3 - an idiot's guide! 1. Use YaST to install mod_php from the CDs. 2. Download the app from Chauncey's website and store it somewhere (eg in your /home directory). 3. Open a terminal window. 4. su to gain root access. 5. cd /usr/local/httpd/htdocs 6. tar -zxvf /pathto/download/pccs_mysqladm 7. The package will unzip into the web directory, giving folder pccs_mysqladm, with various folders and files in that. 8. chown -R nobody:nogroup pccs_mysqladm. This will give the web-browser access. 9. Press Alt+F2 to get a command line, and enter kfmsu (to get the su file manager). 10. Navigate to /usr/local/httpd/htdocs/pccs_mysqladm/incs. 11. Click on dbconnect.php to open it in Kedit. 12. Enter the details for the user you want to access MySQL as. $db_server="localhost" $db_user="root" $db_password="whatever" 13. Save and exit. 14. The mod_php package installed by SuSE 6.3 only recognises .php3 as the extension for PHP files - we need to fix that. 15. Still using kfmsu, navigate to /etc/httpd. 16. Click on httpd.conf. 17. Edit/Find. 18. Enter DirectoryIndex. 19. Change the line: DirectoryIndex index.html to DirectoryIndex index.html index.php index.php3 index.phtml 20. Edit/Find 21. Enter IfDefine PHP. 22. Change the line: AddType application/x-httpd-php3 .php3 to AddType application/x-httpd-php3 .php3 .php 23. Save and exit. 24. We now need to restart Apache, so that it can read the new httpd.conf file. (Note: ensure that Netscape Navigator is not open, and that you are not in the htdocs tree, as this seems to result in the restart failing.) 25. Open a terminal. 26. su 27. /sbin/init.d/apache restart 28. Apache will shut down, and then restart after a few seconds. 29. Open Navigator, and enter localhost/pccs_mysqladmin - the admin interface will come up. pccsmysqladm/README100644 0 143 24646 7172400713 13131 0ustar rootnobody/////////////////////////////////////////////////////////////////////////////////// //This application assumes you have some working knowledge of MySQL and PHP )+: // /////////////////////////////////////////////////////////////////////////////////// /////////////////////////////////////////////////////////////////////////////////// // If you have an suggestion, code, and/or ideas that you would like to see made // available in future release send them to me @ cthorn@wt.net // This application was written because I use MySQL at work to store information // about the network that I manage. You'll find that most of the applications // on PCCS-Linux.COM are tools that I use for various task at work. // There will be bugs because I'm the only coder and because the apps' primary // design was as a tool to help me at work, I may not notice a bug for a number // of weeks or more. So without getting an e-mail from you that a bug was found // prevents me fixing the problem. /////////////////////////////////////////////////////////////////////////////////// /////////////////////////////////////////////////////////////////////////////////// // PCCS MySQL Database Admin Tool // coder: Chauncey Thorn // email: cthorn@wt.net // url 1: http://PCCS-Linux.COM/ // url 2: http://web.wt.net/~cthorn/ // url 3: http://www.hlug.org/cthorn/ /////////////////////////////////////////////////////////////////////////////////// // Changelog // Created: 01-09-2000 // Changes will be added based on Version ///////////////////////////////////////////////////////////////////////////////////// ///////////////////////////////////////////////////////////////////////////////////// // If you are interested in adding code snippets, or help extend this application // send me a email // As you can see my documentation is very limited. If you have skills writing // help files and would like to write some for me. Please do so and send them to me... // ///////////////////////////////////////////////////////////////////////////////////// Version 1.0: Released 01-12-2000 Applications first release This is a PHP application that allow your to create database users and backup database that you manage using Mysql. "You will need to chown root:nobody on the directory you untared this tool" This application needs write permissions to the root dir $ su # chown -R root:nobody pccsmysqladm/ ////////////////////////////////////////////////////////////////////////////////////// Version 1.1: Released 01-15-2000 Added Drop DB support Extended User Management (Modify User option) Added Optimize as a option on table view Added Kill Process ////////////////////////////////////////////////////////////////////////////// Version 1.2: Released 01-21-2000 Moved global.vars.php and dbconnect.inc to incs directory Added Webadmin FileManager for Web Hosting Admin. (Allows create dirs,upload files, etc..) Added view data to table view Added support to create web user's include files in the myuser_incs dir Included patch (Interface) ////////////////////////////////////////////////////////////////////////////////////////// Version 1.2.1 Released 01-23-2000 Finished Query tool backend (working on interface) Changed the way I was getting tablenames and fields (was using SQL statements, now using mysql_list_tables and mysql_list_field functions) Modifications to main menu Added support for flushing internal tables Added create database (results generates error even though db is created ?) View Variables and Processes Worked on navigation (not complete...) Added support for changing passwords Added to more global variables mysqldbuser = the root user id mysqldbpasswd = the password These are needed to run mysqldump. ? ////////////////////////////////////////////////////////////////////////////////////////////// Version 1.2.2 Released fixed another missing require statement )+: Added <> to SQL Query Tool select options Thanks to David Bandel.. Changed Interface again Added Grant/Revoke module Removed a couple of print statements from mysqldb_admin.php3 "dbschema" Started back updating this file... //////////////////////////////////////////////////////////////////////////////// Version 1.2.3 Released bug fixes PHPgened the mysql: host,user,db tables mysqldb_user.php3, mysqldb_db.php3,mysqldb_hosts.php3 Added a flush privileges qry to the update and insert queries in the above scripts. Started creating support for multiple languages. worked on navigation (getting back to main page) Made changes to the Web Admin portion. now displaying userid_global.var.inc <-- file is written to myuser_incs ////////////////////////////////////////////////////////////////////////// Version 1.2.4 Released bug fixes removed WebAdmin module Added modified version of phpgen version, intergrated it into view tables columns phpgen modifications; genform.php3 --> mysqldb_createapp.php3 -> $numf was hacked to get is value from a select * and mysql_num_rows ytgen.php3 --> mysqldb_genapp.php3 Creating include file in the genapp/include Creating language file in the genapp/include Minor code additions; mouseovers, class statements Query tool updated; added support to write html file via a sql query. ////////////////////////////////////////////////////////////////////////// Version 1.2.5 fixed a couple of bugs fixed SecurityFocus SECURITY ALERT http://www.securityfocus.com/vdb/?id=1557 by changing dbconnect.inc -> dbconnect.php changed ALL files extensions to .php extended the QueryTool adding a free form for your SQL statements ////////////////////////////////////////////////////////////////////////// Version 1.2.6 fixed a few more bugs renamed the files in genapp from .php3 -> .php I missed these files in the 1.2.5 version. removed simple1 from the password field in mysqldb_backup.php using incs/dbconnect.php to provide user id for mysqldb_backup.php added a logging function starting to log various actions, grant/revoke, flush commands Make sure you give nobody access to write in the logs dir. I included a index.php in the incs and logs directory. You will need to modify these files... They generate false errors while sending you an email of the infraction wrote a small shscript to automate the backup of every database nightly. backup.sh ////////////////////////////////////////////////////////////////////////// Version 1.2.7 fixed bugs in the genapp/mysqldb_genapp.php In an effort to make this tool useful for the php developer also I included my installscript and backup script, generating them on the fly via a database select using fopen() fputs() fclose() If you are using this application remotely you should install apache with ssl support and create a apaches .htaccess Apache with mod_ssl Get the latest versions of mod_ssl and openssl # cd /usr/local/src # tar -xvzf /path/to/openssl-xx.tar.gz # tar -xvzf /path/to/mod_ssl-xx.tar.gz # cd openssl-xx # ./config -fPIC # make # make install # cd ../mod_ssl-xxx # ./configure -with-apache=../apache-1.3.xx # cd ../apache-1.3.xx # SSL_BASE=../openssl-xx ./configure --prefix=/home/www --enable-module=most --enable-shared=max --enable-module=ssl --enable-shared=ssl # make # make certificate # make install Test your Apache Setup # /etc/rc.d/init.d/httpd stop # /etc/rc.d/init.d/httpd startssl # enter phrase # ps ax | grep httpd Goto my site a view http://pccs-linux.com/phplinux/linux_php.html for more details on installing Apache/MySQL/PHP ////////////////////////////////////////////////////////////////////////// Version 1.2.8 - Some bug fixes - begin the process of commenting the code. - added a fix_perm script, sets file/directory perms - added support for restoring a database from a backup - modified the location of database backups to dumpfiles/ in the bin/backup.sh - new button RESTORE DB allows you to restore a database or restore to a new database from dumpfiles/ - support for the 3.23.xx series of MySQL fixed table_in_databasename - redesigning the backup system to rely on the backup.sh moving away from the mysqldb_backup.php for administrators - added a robots.txt to keep indexers from indexing the application - minor code changes... - changed the location of where genapps are scripts are created. using mkdir() function // ////////////////////////////////////////////////////////////////////////// ////////////////////////////////////////////////////////////////////////// // Install Info Installing PCCS MYSQLADM $su # cd /home/www/htdocs or to your web root # tar -xvzf /pathto/file/pccsmysqladm.tar.gz # run fix_perm.sh in the bin/ directory Open up your web browser goto: http://yourhost/pccs_mysqladm/ If you don't already have MySQL and PHP Confiugred Continue else check out the app, and I hope you find it useful. Comments, suggestions >> cthorn@wt.net Installing MySQL: $ su # cd /usr/local # tar -xvzf /pathto/mysqlsrc/mysql-3.22*gz # mv mysql* mysql # cd mysql # ./configure # make && make install # scripts/mysql_install_db # cp support-files/mysql.server /etc/rc.d/init.d/mysql # chmod +x /etc/rc.d/init.d/mysql # /sbin/chkconfig --del mysql # /sbin/chkconfig --add mysql # /etc/rc.d/init.d/mysql start Installing Apache: # tar -xvzf apache_1.3.x.tar.gz # cd apache_1.3.x # ./configure --prefix=/home/www \ --enable-module=most \ --enable-shared=max # make && make install # ln -s /home/www/bin/apachectl /etc/rc.d/init.d/httpd Add the following to your /home/www/bin/apachectl # chkconfig: 2345 10 90 # Description: Start/Stop Apache W3 Server # /sbin/chkconfig --del httpd # /sbin/chkconfig --add httpd Modify your /home/www/conf/httpd.conf Port 80 DirectoryIndex index.html index.php3 index.phtml AddType application/x-httpd-php3 .php3 .phtml Test your Apache Setup # /etc/rc.d/init.d/httpd start # ps ax | grep httpd Install PHP3: # /etc/rc.d/init.d/httpd stop # cd /pathto/phpsrc # tar -xvzf php-3.0.x.tar.gz # cd php-3.0.x # ./configure --with-mysql --with-pgsql --with-imapd --with-gd --with-zlib\ --with-apxs=/home/www/bin/apxs--with-system-regex \ --enable-track-vars # make && make install # cp php.ini-dist /home/www/conf/php.ini ReStart apache # /etc/rc.d/init.d/httpd start ////////////////////////////////////////////////////////////////////////////// Or get the binary ... rpm -ivh mysql*.rpm tar -xvzf mysql*gz cd mysql* make install //////////////////////////////////////////////////////////////////////////////////// pccsmysqladm/about_pccsmysqladm.php100644 0 143 7435 7172400714 16632 0ustar rootnobodyLICENSE: The current code should work on all Linux, Unix, *BSD systems thus making it GPL for all those platforms, however if you have to modifiy code to get it to work on a windows machine, you have made it useless to the opensource community so if you want to port this app to windows talk to me about a payment. What is this PCCS MySQLDatabase Admin Tool? PCCS MAT is a web based MySQLDatabase Admin tool written in PHP. It is being designed as a tool for managing USER connections to the MySQL DB. These connections can be Web (local) or applications like MS Access, Excel (remote). The DB admin can determine if the connection is made from anywhere, or just from a single location. Or from the localhost, however if you make it the localhost, we assumed you were wanting to setup a web application and added a setup just for web applications. We are also designing it to be the PHP web Hosting Adminstators tool. Current features and plans: Manage Database Module; View Database Tables and Optimize them. Backup Database : mysqldump --opt dbname > date-time-dbname.sql then tar -czf ./date-time-dbname-tar.gz ./date-time-dbname.sql To backup database it requires you to download the backup to a remote site. View Schema: this is just a mysqldump --opt -d (I'm working on code that will change this to Create new Database, from the selected database and grant users permissions to new database) I will give option with data (remove -d) or without. Drop Database: Prompts you before dropping database. Query Database: This section will REALLY be under development in the 1.x versions. The development plans for this feature: Report creation: you create the SQL query that brings back the data you want in a weekly, monthly, report. Save that query, define if you want it to be a cvs dump, excel file dump. Write this info to a file and make it available just by a click, then all you have to do is download the report data... View Tables: Here we allow you to optimize your database tables, view column information and display the number of records in that table. (plan to add grant and revoke support at the table level) User Management Module: This module allow the MySQL administrator to create and modify user accounts. The admin has the option to create 4 different groups of accounts. ADMIN : GRANT ALL BASIC : GRANT SELECT ... ADVANCE: GRANT SELECT, INSERT,UPDATE,DELETE OPERATOR : GRANT SELECT,INSERT,UPDATE,DELETE,FILE,INDEX,DROP,RELOAD the password is created/updated using the INDENTIFIED BY 'password' The DB admin has the option to give the user access to all databases or just one (working on code to allow multiple databases)... The Modify User option in the User Management module allow the administrator to modify current user access rights to their servers. (Needs an interface, "function before pretty") This option allows edit of the mysql.user table and the mysql.db table. The Web Application/Hosting Module: This module's design is to allow the MySQL administrator and/or Web Hosting Administrator to create accounts for applications that will connect to their servers. We plan to design this module to accept install files that tell the system how to install and setup PHP applications. (The PHP InstallScript has been released and is available at (URL) in an effort to get in out to PHP Developers). It will also support the PHP Backup Script which makes backing up Web application database. Feature to be added to this module is; define webhosting share dir variable. define a webosting skel directory: location to store PHP Applications. will be used to copy Applications that a subscriber may want. News System, Message System, FeedBack Form etc and other applications that support the phpinstallscript... from skel to a directory created for the user. create directory for userid being created pccsmysqladm/bin/ 40775 0 143 0 7172400714 12673 5ustar rootnobodypccsmysqladm/bin/backup.sh100775 0 143 1750 7172400714 14577 0ustar rootnobody#!/bin/sh # Filename: backup.sh # Function: do daily backups of databases # updated 10-07-2000 # -- added changelog to this file # Change To fit your system userid=root # On my development system I don't have the root password # You will also need add -p${password} to #password=passwd # Create a cron job to run every night at 4:30am # 30 04 * * * /patch/to/pccs_mysqladm/bin/backup.sh # Location of Mysql bin directory mysqlbinclient="/usr/local/bin/mysql -u${userid}" mysqlbindump="/usr/local/bin/mysqldump -u${userid}" # Location of Mysql Database backup directory dbbackupdir=/home/www/htdocs/pccs_mysqladm/dumpfiles $mysqlbinclient -e 'SHOW DATABASES' | sed 's/|//g' | grep -v 'Database' \ | while read dbname; do if [ -d $dbbackupdir/${dbname}_db ]; then echo -n 2>/dev/null else mkdir $dbbackupdir/${dbname}_db fi curr_time=`date | sed 's/ //g' | sed 's/:/_/g'` $mysqlbindump --opt ${dbname} > $dbbackupdir/${dbname}_db/${curr_time}.${dbname}_dumpsql.BACKUP 2>/dev/null done pccsmysqladm/bin/fix_perm.sh100775 0 143 2154 7172401774 15151 0ustar rootnobody#!/bin/sh # fix_perm.sh # PCCS MySQLDatabase Admin Tool - http://www.pccs-linux.com/pccsmysqladm # Created: 10-12-2000 # -- used to secure file system # -- added directory permissions # updated 10-15-2000 # -- changed app_path variable # -- completed script including all files # Modify the variables below # APP_PATH = path to pccs_mysqladm # APP_PATH=/home/www/htdocs/pccs_mysqladm APP_PATH=$PWD # httpdgroup = user httpd runs as httpdgroup=nobody if [ -d $APP_PATH ] ; then cd $APP_PATH chmod 644 *.php chmod 644 COPYING chmod 644 README chmod 644 robots.txt chmod 644 INSTALL* chmod 655 incs/* chmod 775 logs/ chmod 666 logs/* chmod 754 images/ chmod 775 installscript/ chmod 666 installscript/* chmod 775 dumpfiles/ chmod 666 dumpfiles/* chmod 775 exports/ chmod 666 exports/* chmod 775 genapp/ chmod 666 genapp/* chmod 775 rptfiles/ chmod 666 rptfiles/* chown root:$httpdgroup -R ./* touch logs/.INSTALLED cd - echo "Done setting permissions on directories." exit; else echo "ERROR: $APP_PATH does not exist." echo "Edit the path at the top of this script and try again." exit; fi; pccsmysqladm/dumpfiles/ 40775 0 143 0 7172400714 14113 5ustar rootnobodypccsmysqladm/dumpfiles/index.php100666 0 143 25360 7172400714 16060 0ustar rootnobody ?dbname= >
Clipboard Contents:



> Clipboard Contents:



> Clipboard Contents:



> Delete ?  


BACKUP File:


Back to Databases : MySQLDatabase Admin DB Restore Tool: ".$pwd."
BACKUP Files for Database : $dbname
$dbname 
"; ?>
BACKUP Files:
?action=createnewdb&dbname=> Restore to another Database:
>


?dbname=> Clipboard Contents:



Click Back to Database"; } else { ?>
?action=restoretonewdb&dbname=> Restore This BACKUP:



pccsmysqladm/dumpfiles/README100666 0 143 1134 7172400714 15071 0ustar rootnobodyCreated by: Chauncey Thorn This directory is where the /pathto/pccs_mysqladm/bin/backup.sh dumps databases to ... directory names are created by databasename + ext _db e.g. mysql_db I'm attempting to redesign the backup system. -- Created a sh script that should be ran as a cron job This file copies the database backups to this directory. Then I wrote code that looks for the backup files in this directory and allow you to restore from a dropdown list of backup files. The restore db option on the database page. gives you the option to restore a database or restore to a new database name. pccsmysqladm/exports/ 40775 0 143 0 7172400713 13626 5ustar rootnobodypccsmysqladm/exports/README100666 0 143 57 7172400713 14547 0ustar rootnobodyThis directory will be used for exports to csv pccsmysqladm/genapp/ 40775 0 143 0 7172404016 13374 5ustar rootnobodypccsmysqladm/genapp/webadmin_fm.php100666 0 143 23376 7172400713 16507 0ustar rootnobody >
Clipboard Contents:



> Clipboard Contents:



> Clipboard Contents:



> Delete ?  


Current File:


MAIN : WebAdmin FileManager Current Directory: ".$pwd."
Folders:
\"PHP 
Files:
New File:
 
New Folder:
 
> File Upload:
>


> Clipboard Contents:



pccsmysqladm/genapp/English.NLS100666 0 143 1464 7172400713 15447 0ustar rootnobody# English language file for PHPGen NLSCharset = ISO-8859-1 NLSListAll = List all NLSSearch = Search NLSNew = New NLSAreYouSure = Are you sure you want to delete this record? NLSSearchFor = Search for NLSSearchIn = in NLSSearchReturned = returned NLSSearchHits = hits NLSRecordsSortedBy = All records sorted by NLSSearchForm = SEARCH NLSEdit = Edit NLSDelete = Delete NLSYes = Yes NLSNo = No NLSOptional = optional NLSMustBeSpecified = must be specified NLSError = Error NLSTryAgain = Try again NLSSave = Save NLSClearAll = Clear all fields NLSPrevious = Previous NLSNext = Next NLSMonth01 = January NLSMonth02 = February NLSMonth03 = March NLSMonth04 = April NLSMonth05 = May NLSMonth06 = June NLSMonth07 = July NLSMonth08 = August NLSMonth09 = September NLSMonth10 = October NLSMonth11 = November NLSMonth12 = December pccsmysqladm/genapp/normal.pgtheme100666 0 143 624 7172400713 16320 0ustar rootnobody pccsmysqladm/genapp/README100666 0 143 475 7172400713 14341 0ustar rootnobodyThis scripts was hacked from another php application It creates a basic script with insert,delete,update,display,search support creates scriptfile .php creates language file create global include file These files will need to be modified. They are very simple... Chauncey Thorn cthorn@wt.net http://PCCS-Linux.COM pccsmysqladm/genapp/sqledit.php100666 0 143 2112 7172400713 15645 0ustar rootnobody $filename does not exist!"; echo "Return"; exit; } echo "

Edit of $file

"; echo "
"; echo ""; echo ""; echo "
"; echo "Cancel
"; echo "Filename: "; echo ""; echo ""; endif; //*Edit ?> pccsmysqladm/genapp/mysqldb_genapp.php100666 0 143 63717 7172400713 17247 0ustar rootnobody $r"; $r = ereg_replace("^[\t ]+","",$r); if ((substr($r,0,1) != "#") && ($r != "")): $vstr = chop(strstr($r,"=")); $kstr = chop(substr($r,0,strlen($r)-strlen($vstr))); $vstr = substr($vstr,1,999); $vstr = ereg_replace("^[\t ]+","",$vstr); $kstr = ereg_replace("^[\t ]+","",$kstr); //Secho "
***",$kstr,"****",htmlspecialchars($vstr),"****

"; if ($kstr != ""): $$kstr = $vstr; endif; endif; endwhile; fclose($tf); //*************** Now get server, username, passwd from form ****************** if ($servname) $db_server = $servname; if ($usrname) $db_user = $usrname; if ($passwd) $db_passwd = $passwd; //*************** Check for neccesary defaults if ($body_tag == "") $body_tag=""; if ($list_color1 == "") $list_color1="#FFFFFF"; if ($list_color2 == "") $list_color2="#EEFFFF"; if ($menu_bg_color == "") $menu_bg_color="#EEFFFF"; if ($list_table_tag == "") $list_table_tag=""; if ($form_table_tag == "") $form_table_tag="
"; if ($language == "") $language="English"; if ($limit == "") $limit=50; //*************** Parse language-file $tf = fopen($language . ".NLS","r"); while (!feof($tf)): $r = chop(fgets($tf,500)); //echo "

$r

"; $r = ereg_replace("^[\t ]+","",$r); if ((substr($r,0,1) != "#") && ($r != "")): $vstr = chop(strstr($r,"=")); $kstr = chop(substr($r,0,strlen($r)-strlen($vstr))); $vstr = substr($vstr,1,999); $vstr = ereg_replace("^[\t ]+","",$vstr); $kstr = ereg_replace("^[\t ]+","",$kstr); //Secho "
***",$kstr,"****",htmlspecialchars($vstr),"****

"; if ($kstr != ""): $$kstr = $vstr; endif; endif; endwhile; fclose($tf); //*************** Generate include file $dirprefix="php"; if(is_dir("$dirprefix$dbnamn")) { // } else { if(@mkdir("$dirprefix$dbnamn",0777)) { // print "Directory Created:" . $dirprefix . $dbnamn; if(@mkdir("$dirprefix$dbnamn/include",0777)) { // print "Include Directory Created"; } else { // print "Something wierd happen. I was able to create" . $dirprefix . $dbname . " but for some reason I can create the include dir"; } } else { // print "Failed to create:" . $dirprefix . $dbnamn . " Check File Permissions, I'm unable to create a directory"; } } $user = ""; $passwd = ""; $dirpath = $dirprefix . $dbnamn ."/"; $inc_path = "include/"; $ext = "_global.vars.inc"; $filename = "$inc_path$dbnamn$ext"; $full_name = "Chauncey Thorn"; $url = "http://web.wt.net/~cthorn/"; $cf = fopen($dirpath . $filename, "w") or die("This app requires WRITE access"); fputs($cf, "\";\n"); fputs($cf," \$result = mysql(\$dbname,\$query);\n"); fputs($cf," return \$result;\n}\n"); fputs($cf,"\n\n// BODY Colors //\n\n"); fputs($cf, "\$col_bg=\"#FFFFFF\"; // Background color\n"); fputs($cf, "\$col_text=\"#000000\"; // Text color\n"); fputs($cf, "\$col_link=\"#FFCC33\"; // Link color\n"); fputs($cf, "\$col_vlink=\"#FFFF99\"; // Visited Link color\n"); fputs($cf, "\$col_alink=\"#000000\"; // Active Link color\n"); fputs($cf, "\n\n"); fputs($cf, "\n\n// Fonts //"); fputs($cf, "\n\n\$myfonts = \"arial,helvetica\";"); fputs($cf, "\n\$fontsize = 1;"); fputs($cf, "\n\n\tfunction fontColor(\$color,\$fontsize,\$txt) {"); fputs($cf, "\n\t\tglobal \$myfonts;"); fputs($cf, "\n\t\tprint '\$txt ';"); fputs($cf, "\n\t}"); fputs($cf, "\n\n// Display Image //"); fputs($cf, "\n\n\tfunction displayImage(\$img_name) {"); fputs($cf, "\n\t\tprint '';"); fputs($cf, "\n\t}"); fputs($cf, "\n\n\n"); fputs($cf, "\n\n?>"); fclose($cf); // Create lang file // $langext = "_lang.inc"; $langfilename = "$inc_path$dbnamn$langext"; $langf = fopen($dirpath . $langfilename, "w") or die("This app requires WRITE access"); fputs($langf, ""); fclose($langf); //*************** Generate output $dirpath = $dirprefix . $dbnamn . "/"; $f = fopen($dirpath . $filnamn,"w"); fputs($f,"\n\n"); fputs($f,"\n"); fputs($f,"$dbnamn / $tabnamn\n"); $today = Date("Y-m-d H:i:s"); fputs($f,""); fputs($f,"\n\n"); fputs($f,"\n"); if ($Nycknum == "on"): fputs($f," \";\n"); fputs($f," } else {\n"); fputs($f," echo mysql_error().\"
\\n\";\n }\n?>\n"); fputs($f,"\n"); fputs($f,"\n\n"); fputs($f,"\n"); fputs($f,"\";\n\n"); $a = 1; $vf = "F1"; $vt = "T1"; $vn = "N1"; $vu = "U1"; while ($$vf !=""): fputs($f," $" . $$vf . "=chop($" . $$vf . ");\n\n"); if ($$vu != "on") { fputs($f," if ($" . $$vf . " == \"\"):\n"); fputs($f," echo \"\";\n"); fputs($f," \$ok = 0;\n"); fputs($f," echo \"\";\n"); fputs($f," endif;\n\n"); fputs($f," if (\$fields==\"\") {\n"); fputs($f," \$fields=\"". $$vf ."\";\n"); if ($$vn == "on") { fputs($f, " \$values=\"$".$$vf."\";\n"); } else { fputs($f, " \$values=\"'$".$$vf."'\";\n"); } fputs($f," } else {\n \$fields.=\",". $$vf ."\";\n"); if ($$vn == "on") { fputs($f, " \$values.=\",$".$$vf."\";\n"); } else { fputs($f, " \$values.=\",'$".$$vf."'\";\n"); } fputs($f, " }\n"); } else { fputs($f," if ($". $$vf ."!=\"\") {\n"); fputs($f," if (\$fields==\"\") {\n"); fputs($f," \$fields=\"". $$vf ."\";\n"); if ($$vn == "on") { fputs($f, " \$values=\"$".$$vf."\";\n"); } else { fputs($f, " \$values=\"'$".$$vf."'\";\n"); } fputs($f," } else {\n \$fields.=\",". $$vf ."\";\n"); if ($$vn == "on") { fputs($f, " \$values.=\",$".$$vf."\";\n"); } else { fputs($f, " \$values.=\",'$".$$vf."'\";\n"); } fputs($f, " }\n }\n"); } fputs($f, "\n"); $a++; $vf = "F" . $a; $vt = "T" . $a; $vn = "N" . $a; $vu = "U" . $a; endwhile; fputs($f," echo \"
"); fputs($f,$$vt); fputs($f,": "); fputs($f," $"); fputs($f,$$vf); fputs($f,"" . $$vt . " $NLSMustBeSpecified !
\";\n"); fputs($f," if (!\$ok):\n"); fputs($f," echo \"$NLSError!\";\n"); fputs($f," echo \"$NLSTryAgain\";\n"); fputs($f," exit;\n"); fputs($f," endif;\n"); fputs($f,"?>\n\n"); fputs($f,"\";\n"); fputs($f," } else {\n"); fputs($f," echo mysql_error().\"
\\n\";\n }\n?>\n"); fputs($f,"\n"); fputs($f,"\n\n"); fputs($f,"\n"); fputs($f,"\";\n\n"); $a = 1; $vf = "F1"; $vt = "T1"; $vn = "N1"; $vu = "U1"; while ($$vf !=""): fputs($f," $" . $$vf . "=chop($" . $$vf . ");\n"); if ($$vu != "on") { fputs($f," if ($" . $$vf . " == \"\"):\n"); fputs($f," echo \""); fputs($f,$$vt); fputs($f,": "); fputs($f," $"); fputs($f,$$vf); fputs($f,"\";\n"); fputs($f," \$ok = 0;\n"); fputs($f," echo \"" . $$vt . " $NLSMustBeSpecified !\";\n"); fputs($f," endif;\n\n"); fputs($f," if (!empty(\$fields)) \$fields.=',';\n"); fputs($f," \$fields.=\"". $$vf ."=\";\n"); if ($$vn == "on") { fputs($f, " \$fields.=\"$".$$vf."\";\n"); } else { fputs($f, " \$fields.=\"'$".$$vf."'\";\n"); } } else { fputs($f," if ($". $$vf ."!=\"\") {\n"); fputs($f," if (!empty(\$fields)) \$fields.=',';\n"); fputs($f," \$fields.=\"". $$vf ."=\";\n"); if ($$vn == "on") { fputs($f, " \$fields.=\"$".$$vf."\";\n"); } else { fputs($f, " \$fields.=\"'$".$$vf."'\";\n"); } fputs($f, " }\n"); } $a++; $vf = "F" . $a; $vt = "T" . $a; $vn = "N" . $a; $vu = "U" . $a; endwhile; fputs($f," \$result = mysqlquery(\"$dbnamn\",\"UPDATE $tabnamn SET \$fields"); fputs($f," WHERE "); fputs($f,"$F1"); if ($Nycknum == "on"): fputs($f,"=\$par"); else: fputs($f,"='\$par'"); endif; fputs($f,"\");\n"); fputs($f," if (!empty(\$result)) {\n"); fputs($f," echo \"\";\n"); fputs($f," } else {\n"); fputs($f," echo mysql_error().\"
\\n\";\n }\n?>\n"); fputs($f,"\n\n"); //****************************** Insert Style sheet ? if ($style_sheet != ""): $ssf = fopen($style_sheet,"r"); while (!feof($ssf)): $r = fgets($ssf,500); fputs($f,$r); endwhile; fclose($ssf); endif; fputs($f,"\n\n"); fputs($f,"$body_tag\n"); fputs($f,"$menu_table_tag\n"); fputs($f,"\n"); fputs($f,"0) { ?>\n&found=&start=><<<$NLSPrevious \n\n"); fputs($f," &start=0>$NLSListAll\n"); fputs($f,"\n&found=&start=>>>>$NLSNext \n\n"); fputs($f," $NLSSearch\n"); fputs($f,"$NLSNew\n"); fputs($f,"\n"); fputs($f,"\n"); fputs($f,"\n\n"); fputs($f,"\n"); fputs($f,"

$NLSAreYouSure

\n"); fputs($f,">$NLSYes   "); fputs($f,"$NLSNo\n"); fputs($f,"\n"); fputs($f,"\n\n"); fputs($f,"\n"); //fputs($f,"
\n"); fputs($f," \n"); fputs($f," \n"); fputs($f,"

$NLSSearchFor '' $NLSSearchIn '' $NLSSearchReturned $NLSSearchHits

\n"); fputs($f," \n"); fputs($f," \n"); fputs($f," $list_table_tag\n"); fputs($f," \n"); fputs($f," "); $a = 1; $vf = "T1"; $brwf = "BRW1"; while ($$vf !=""): if ($$brwf == "on"): fputs($f,""); fputs($f,$$vf . ""); endif; $a++; $vf = "T" . $a; $brwf = "BRW" . $a; endwhile; fputs($f,"\n"); fputs($f," \n"); fputs($f," \n"); fputs($f," >\n"); fputs($f," >\n"); $a = 1; $vf = "F1"; $brwf = "BRW1"; while ($$vf !=""): if ($$brwf == "on"): fputs($f," \n"); fputs($f," \n"); fputs($f," \n"); endif; $a++; $vf = "F" . $a; $brwf = "BRW" . $a; endwhile; fputs($f," \n"); fputs($f," \n"); fputs($f," \n"); fputs($f,"\n"); fputs($f,"\n\n"); fputs($f,"\n"); fputs($f,"

\n"); /* fputs($f," Welcome to .........
\n"); fputs($f,"

\n"); fputs($f,"

.......system

\n"); */ fputs($f,"\n"); fputs($f,"\n\n"); fputs($f,"\n"); //fputs($f,"
\n"); fputs($f," \n"); fputs($f,"

$NLSRecordsSortedBy \"$ORDERBY\"

\n"); fputs($f," \n"); fputs($f," \n"); fputs($f," $list_table_tag\n"); fputs($f," \n"); fputs($f," "); $a = 1; $vf = "T1"; $fn = "F1"; $brwf = "BRW1"; while ($$fn !=""): if ($$brwf == "on"): fputs($f,""); fputs($f,$$vf . ""); endif; $a++; $vf = "T" . $a; $fn = "F" . $a; $brwf = "BRW" . $a; endwhile; fputs($f,"\n"); fputs($f," \n"); fputs($f," \n"); fputs($f," >\n"); fputs($f," >\n"); $a = 1; $vf = "F1"; $brwf = "BRW1"; while ($$vf !=""): if ($$brwf == "on"): fputs($f," \n"); fputs($f," \n"); fputs($f," \n"); endif; $a++; $vf = "F" . $a; $brwf = "BRW" . $a; endwhile; fputs($f," \n"); fputs($f," \n"); fputs($f," \n"); fputs($f,"\n"); fputs($f,"\n\n"); fputs($f,"\n"); if ($Nycknum == "on"): fputs($f," \n"); else: fputs($f," \n"); endif; fputs($f,"

ID:

\n"); fputs($f," $form_table_tag\n"); $a = 1; $vf = "F1"; $vt = "T1"; $vb = "B1"; while ($$vf !=""): if ($$vb != "on"): /* A blob...., no */ fputs($f," "); fputs($f,$$vt); fputs($f,": "); fputs($f,"\n"); endif; if ($$vb == "on"): /* A blob! */ fputs($f," "); fputs($f,$$vt."\n"); fputs($f," \n"); fputs($f," 
\",\">\",\$xx);\n");
    fputs($f,"       echo \$xx ?>\n");
    fputs($f,"
\n"); endif; $a++; $vf = "F" . $a; $vt = "T" . $a; $vb = "B" . $a; endwhile; fputs($f," \n"); fputs($f,"\n"); fputs($f," >$NLSEdit\n"); fputs($f," > $NLSDelete\n"); fputs($f,"\n"); fputs($f,"\n"); fputs($f,"\n\n"); fputs($f,"$NLSEdit\";\n"); fputs($f," else:\n"); fputs($f," echo \"

$NLSNew

\";\n"); fputs($f," endif;\n"); fputs($f," ?>\n"); fputs($f,"\n"); fputs($f,"
\n"); fputs($f,"\n"); fputs($f," METHOD=POST>\n"); fputs($f,"\n"); fputs($f," \n"); $a = 1; $vf = "F1"; $vt = "T1"; $vb = "B1"; $vi = "I1"; $vm = "M1"; $vs = "S1"; $vu = "U1"; while ($$vf !=""): if ($$vs == "on"): /* An Selectlist */ fputs($f," \n"); endif; if (($$vb != "on") && ($$vs != "on")): /* A blob...., no */ fputs($f," \n"); endif; if (($$vb == "on") && ($$vs != "on")): /* A blob! */ fputs($f," \n"); fputs($f," \n"); endif; $a++; $vf = "F" . $a; $vt = "T" . $a; $vb = "B" . $a; $vi = "I" . $a; $vm = "M" . $a; $vs = "S" . $a; $vu = "U" . $a; endwhile; fputs($f,"
"); fputs($f,$$vt); if ($$vu == "on") { fputs($f,"
($NLSOptional)"); } fputs($f,": 		"); fputs($f,"\n
"); fputs($f,$$vt); if ($$vu == "on") { fputs($f,"
($NLSOptional)"); } fputs($f,": 		"); fputs($f,"\""); fputs($f,">
"); fputs($f,$$vt); if ($$vu == "on") { fputs($f,"
($NLSOptional)"); } fputs($f,":		\n"); fputs($f,"
\n"); fputs($f,"  \n"); fputs($f,"
\n"); fputs($f,"\n"); fputs($f,"\n\n"); fputs($f,"\n"); fputs($f,"\n"); fputs($f,"\n"); fputs($f,"\n"); fputs($f,"\n"); fputs($f,"
\n"); fputs($f,"\n"); fputs($f,"\n"); fputs($f,"
\n"); fputs($f,"\n"); fputs($f,"
\n"); fputs($f,"\n"); fputs($f,"\n"); fputs($f,"\n"); fclose($f); echo "

A PHP Framework has been created for table !

"; echo "

Application Script Directory: " . $dirprefix . $dbnamn; echo "

Script Include Directory: " . $dirprefix . $dbnamn . "/include"; echo "

"; echo "Script code is saved as $filnamn

"; echo "Global vars code is saved as $filename

"; echo "Language code is saved as " . $langfilename ."

"; ?> <<BACK to Admin pccsmysqladm/genapp/include/ 40666 0 143 0 7172400713 15016 5ustar rootnobodypccsmysqladm/genapp/genapp_include.php100666 0 143 10323 7172400713 17200 0ustar rootnobody\";\n"); fputs($f," \$result = mysql(\$dbname,\$query);\n"); fputs($f," return \$result;\n}\n"); fputs($f,"\n\n// BODY Colors //\n\n"); fputs($f, "\$col_bg=\"#FFFFFF\"; // Background color\n"); fputs($f, "\$col_text=\"#000000\"; // Text color\n"); fputs($f, "\$col_link=\"#FFCC33\"; // Link color\n"); fputs($f, "\$col_vlink=\"#FFFF99\"; // Visited Link color\n"); fputs($f, "\$col_alink=\"#000000\"; // Active Link color\n"); fputs($f, "\n\n"); fputs($f, "// Header Function //\n"); fputs($f, "\n\tfunction common_header(\$_title) {"); fputs($f, "\n\tglobal \$col_bg,\$col_text,\$col_link,\$col_alink,\$col_vlink;"); fputs($f, "\n\n\tprint \""); fputs($f, ""); fputs($f, "\n\t"); fputs($f, "\n\t"); fputs($f, "\n\t\t"); fputs($f, "\n\t\t"); fputs($f, "\n\t\t"); fputs($f, "\n\t\t\$_title"); fputs($f, "\n\t\n\n"); fputs($f, "\t"); fputs($f, "\n\";"); fputs($f, "\n}"); fputs($f, "\n\n// Footer //"); fputs($f, "\n\n\tfunction footer() {"); fputs($f, "\n\t\tprint\"\";"); fputs($f, "\n\t}"); fputs($f, "\n\n// Fonts //"); fputs($f, "\n\n\$myfonts = \"arial,helvetica\";"); fputs($f, "\n\$fontsize = 1;"); fputs($f, "\n\n\tfunction fontColor(\$color,\$fontsize,\$txt) {"); fputs($f, "\n\t\tglobal \$myfonts;"); fputs($f, "\n\t\tprint \"\$txt \";"); fputs($f, "\n\t}"); fputs($f, "\n\n// Display Image //"); fputs($f, "\n\n\tfunction displayImage(\$img_name) {"); fputs($f, "\n\t\tprint \"\";"); fputs($f, "\n\t}"); fputs($f, "\n"); fputs($f, "\n// Display Beginning of Table //"); fputs($f, "\n\n\tfunction displayTable_begin(\$border,\$width,\$cellspacing,\$cellpadding) {"); fputs($f, "\n\n\t\tprint \"\""); fputs($f, "\n\t}"); fputs($f, "\n\n// Display End of Table //"); fputs($f, "\n\n\tfunction displayTable_end() {"); fputs($f, "\n\n\t\tprint \"
\""); fputs($f, "\n\t}"); fputs($f, "\n\n?>"); fclose($f); ?> pccsmysqladm/genapp/mysqldb_createapp.php100666 0 143 71165 7172400713 17735 0ustar rootnobody\n Create the basic framework on the Database $dbname and table $tablename
\n"; print "

"; print " "; // print "
"; $primaryfound = 0; // if ($action == "seldone"): $res = mysql_list_fields($dbname,$tablename); for ($i = 0; $i < mysql_num_fields($res); $i++): if (! $primaryfound): if (ereg("primary", mysql_field_flags($res, $i))): ?>

This Module will create INSERT, DELETE, UPDATE, SELECT from the above database and table.
You will need to modify the script after it it generated...

MySQLDatabase Web Admin Tool

Generate PHP3 Application Framework >>>

Select theme file:
Database name:
Table name:
Enter filename for your Application:  (with .php extension)
Name of unique field:
Is unique field numeric? >
(Repeat the unique field below if you want it to be editable)
# Title Fieldname Max size Inp. size Sort by Null? Blob / text area Numeric? Pick list? Searchable? Browse?
"> " SIZE=15 MAXLENGTH=25 VALUE=""> "> > > > >
  
$r"; $r = ereg_replace("^[\t ]+","",$r); if ((substr($r,0,1) != "#") && ($r != "")): $vstr = chop(strstr($r,"=")); $kstr = chop(substr($r,0,strlen($r)-strlen($vstr))); $vstr = substr($vstr,1,999); $vstr = ereg_replace("^[\t ]+","",$vstr); $kstr = ereg_replace("^[\t ]+","",$kstr); //Secho "
***",$kstr,"****",htmlspecialchars($vstr),"****

"; if ($kstr != ""): $$kstr = $vstr; endif; endif; endwhile; fclose($tf); //*************** Now get server, username, passwd from form ****************** if ($servname) $db_server = $servname; if ($usrname) $db_user = $usrname; if ($passwd) $db_passwd = $passwd; //*************** Check for neccesary defaults if ($body_tag == "") $body_tag=""; if ($list_color1 == "") $list_color1="#FFFFFF"; if ($list_color2 == "") $list_color2="#EEFFFF"; if ($menu_bg_color == "") $menu_bg_color="#EEFFFF"; if ($list_table_tag == "") $list_table_tag=""; if ($form_table_tag == "") $form_table_tag="
"; if ($language == "") $language="English"; if ($limit == "") $limit=50; //*************** Parse language-file $tf = fopen($language . ".NLS","r"); while (!feof($tf)): $r = chop(fgets($tf,500)); //echo "

$r

"; $r = ereg_replace("^[\t ]+","",$r); if ((substr($r,0,1) != "#") && ($r != "")): $vstr = chop(strstr($r,"=")); $kstr = chop(substr($r,0,strlen($r)-strlen($vstr))); $vstr = substr($vstr,1,999); $vstr = ereg_replace("^[\t ]+","",$vstr); $kstr = ereg_replace("^[\t ]+","",$kstr); //Secho "
***",$kstr,"****",htmlspecialchars($vstr),"****

"; if ($kstr != ""): $$kstr = $vstr; endif; endif; endwhile; fclose($tf); //*************** Generate output $f = fopen($filnamn,"w"); fputs($f,"\n\n"); fputs($f,"\n"); fputs($f,"$filnamn - $dbnamn / $tabnamn\n"); $today = Date("Ymd"); fputs($f,"\";\n"); fputs($f," \$result = mysql(\$dbnamn,\$query);\n"); fputs($f," return \$result;\n}\n?>"); fputs($f,"\n\n"); fputs($f,"\n"); if ($Nycknum == "on"): fputs($f," \";\n"); fputs($f," } else {\n"); fputs($f," echo mysql_error().\"
\\n\";\n }\n?>\n"); fputs($f,"\n"); fputs($f,"\n\n"); fputs($f,"\n"); fputs($f,"\";\n\n"); $a = 1; $vf = "F1"; $vt = "T1"; $vn = "N1"; $vu = "U1"; while ($$vf !=""): fputs($f," $" . $$vf . "=chop($" . $$vf . ");\n\n"); if ($$vu != "on") { fputs($f," if ($" . $$vf . " == \"\"):\n"); fputs($f," echo \"\";\n"); fputs($f," \$ok = 0;\n"); fputs($f," echo \"\";\n"); fputs($f," endif;\n\n"); fputs($f," if (\$fields==\"\") {\n"); fputs($f," \$fields=\"". $$vf ."\";\n"); if ($$vn == "on") { fputs($f, " \$values=\"$".$$vf."\";\n"); } else { fputs($f, " \$values=\"'$".$$vf."'\";\n"); } fputs($f," } else {\n \$fields.=\",". $$vf ."\";\n"); if ($$vn == "on") { fputs($f, " \$values.=\",$".$$vf."\";\n"); } else { fputs($f, " \$values.=\",'$".$$vf."'\";\n"); } fputs($f, " }\n"); } else { fputs($f," if ($". $$vf ."!=\"\") {\n"); fputs($f," if (\$fields==\"\") {\n"); fputs($f," \$fields=\"". $$vf ."\";\n"); if ($$vn == "on") { fputs($f, " \$values=\"$".$$vf."\";\n"); } else { fputs($f, " \$values=\"'$".$$vf."'\";\n"); } fputs($f," } else {\n \$fields.=\",". $$vf ."\";\n"); if ($$vn == "on") { fputs($f, " \$values.=\",$".$$vf."\";\n"); } else { fputs($f, " \$values.=\",'$".$$vf."'\";\n"); } fputs($f, " }\n }\n"); } fputs($f, "\n"); $a++; $vf = "F" . $a; $vt = "T" . $a; $vn = "N" . $a; $vu = "U" . $a; endwhile; fputs($f," echo \"
"); fputs($f,$$vt); fputs($f,": "); fputs($f," $"); fputs($f,$$vf); fputs($f,"" . $$vt . " $NLSMustBeSpecified !
\";\n"); fputs($f," if (!\$ok):\n"); fputs($f," echo \"$NLSError!\";\n"); fputs($f," echo \"$NLSTryAgain\";\n"); fputs($f," exit;\n"); fputs($f," endif;\n"); fputs($f,"?>\n\n"); fputs($f,"\";\n"); fputs($f," } else {\n"); fputs($f," echo mysql_error().\"
\\n\";\n }\n?>\n"); fputs($f,"\n"); fputs($f,"\n\n"); fputs($f,"\n"); fputs($f,"\";\n\n"); $a = 1; $vf = "F1"; $vt = "T1"; $vn = "N1"; $vu = "U1"; while ($$vf !=""): fputs($f," $" . $$vf . "=chop($" . $$vf . ");\n"); if ($$vu != "on") { fputs($f," if ($" . $$vf . " == \"\"):\n"); fputs($f," echo \""); fputs($f,$$vt); fputs($f,": "); fputs($f," $"); fputs($f,$$vf); fputs($f,"\";\n"); fputs($f," \$ok = 0;\n"); fputs($f," echo \"" . $$vt . " $NLSMustBeSpecified !\";\n"); fputs($f," endif;\n\n"); fputs($f," if (!empty(\$fields)) \$fields.=',';\n"); fputs($f," \$fields.=\"". $$vf ."=\";\n"); if ($$vn == "on") { fputs($f, " \$fields.=\"$".$$vf."\";\n"); } else { fputs($f, " \$fields.=\"'$".$$vf."'\";\n"); } } else { fputs($f," if ($". $$vf ."!=\"\") {\n"); fputs($f," if (!empty(\$fields)) \$fields.=',';\n"); fputs($f," \$fields.=\"". $$vf ."=\";\n"); if ($$vn == "on") { fputs($f, " \$fields.=\"$".$$vf."\";\n"); } else { fputs($f, " \$fields.=\"'$".$$vf."'\";\n"); } fputs($f, " }\n"); } $a++; $vf = "F" . $a; $vt = "T" . $a; $vn = "N" . $a; $vu = "U" . $a; endwhile; fputs($f," \$result = mysqlquery(\"$dbnamn\",\"UPDATE $tabnamn SET \$fields"); fputs($f," WHERE "); fputs($f,"$nycknamn"); if ($Nycknum == "on"): fputs($f,"=\$par"); else: fputs($f,"='\$par'"); endif; fputs($f,"\");\n"); fputs($f," if (!empty(\$result)) {\n"); fputs($f," echo \"\";\n"); fputs($f," } else {\n"); fputs($f," echo mysql_error().\"
\\n\";\n }\n?>\n"); fputs($f,"\n\n"); //****************************** Insert Style sheet ? if ($style_sheet != ""): $ssf = fopen($style_sheet,"r"); while (!feof($ssf)): $r = fgets($ssf,500); fputs($f,$r); endwhile; fclose($ssf); endif; fputs($f,"\n\n"); fputs($f,"$body_tag\n"); fputs($f,"$menu_table_tag\n"); fputs($f,"\n"); fputs($f,"0) { ?>\n&found=&start=><<<$NLSPrevious \n\n"); fputs($f," &start=0>$NLSListAll\n"); fputs($f,"\n&found=&start=>>>>$NLSNext \n\n"); fputs($f," $NLSSearch\n"); fputs($f,"$NLSNew\n"); fputs($f,"\n"); fputs($f,"\n"); fputs($f,"\n\n"); fputs($f,"\n"); fputs($f,"

$NLSAreYouSure

\n"); fputs($f,">$NLSYes   "); fputs($f,"$NLSNo\n"); fputs($f,"\n"); fputs($f,"\n\n"); fputs($f,"\n"); //fputs($f,"
\n"); fputs($f," \n"); fputs($f," \n"); fputs($f,"

$NLSSearchFor '' $NLSSearchIn '' $NLSSearchReturned $NLSSearchHits

\n"); fputs($f," \n"); fputs($f," \n"); fputs($f," $list_table_tag\n"); fputs($f," \n"); fputs($f," "); $a = 1; $vf = "T1"; $brwf = "BRW1"; while ($$vf !=""): if ($$brwf == "on"): fputs($f,""); fputs($f,$$vf . ""); endif; $a++; $vf = "T" . $a; $brwf = "BRW" . $a; endwhile; fputs($f,"\n"); fputs($f," \n"); fputs($f," \n"); fputs($f," >\n"); fputs($f," >\n"); $a = 1; $vf = "F1"; $brwf = "BRW1"; while ($$vf !=""): if ($$brwf == "on"): fputs($f," \n"); fputs($f," \n"); fputs($f," \n"); endif; $a++; $vf = "F" . $a; $brwf = "BRW" . $a; endwhile; fputs($f," \n"); fputs($f," \n"); fputs($f," \n"); fputs($f,"\n"); fputs($f,"\n\n"); fputs($f,"\n"); fputs($f,"

\n"); /* fputs($f," Welcome to .........
\n"); fputs($f,"

\n"); fputs($f,"

.......system

\n"); */ fputs($f,"\n"); fputs($f,"\n\n"); fputs($f,"\n"); //fputs($f,"
\n"); fputs($f," \n"); fputs($f,"

$NLSRecordsSortedBy \"$ORDERBY\"

\n"); fputs($f," \n"); fputs($f," \n"); fputs($f," $list_table_tag\n"); fputs($f," \n"); fputs($f," "); $a = 1; $vf = "T1"; $fn = "F1"; $brwf = "BRW1"; while ($$fn !=""): if ($$brwf == "on"): fputs($f,""); fputs($f,$$vf . ""); endif; $a++; $vf = "T" . $a; $fn = "F" . $a; $brwf = "BRW" . $a; endwhile; fputs($f,"\n"); fputs($f," \n"); fputs($f," \n"); fputs($f," >\n"); fputs($f," >\n"); $a = 1; $vf = "F1"; $brwf = "BRW1"; while ($$vf !=""): if ($$brwf == "on"): fputs($f," \n"); fputs($f," \n"); fputs($f," \n"); endif; $a++; $vf = "F" . $a; $brwf = "BRW" . $a; endwhile; fputs($f," \n"); fputs($f," \n"); fputs($f," \n"); fputs($f,"\n"); fputs($f,"\n\n"); fputs($f,"\n"); if ($Nycknum == "on"): fputs($f," \n"); else: fputs($f," \n"); endif; fputs($f,"

ID:

\n"); fputs($f," $form_table_tag\n"); $a = 1; $vf = "F1"; $vt = "T1"; $vb = "B1"; while ($$vf !=""): if ($$vb != "on"): /* A blob...., no */ fputs($f," "); fputs($f,$$vt); fputs($f,": "); fputs($f,"\n"); endif; if ($$vb == "on"): /* A blob! */ fputs($f," "); fputs($f,$$vt."\n"); fputs($f," \n"); fputs($f," 
\",\">\",\$xx);\n");
    fputs($f,"       echo \$xx ?>\n");
    fputs($f,"
\n"); endif; $a++; $vf = "F" . $a; $vt = "T" . $a; $vb = "B" . $a; endwhile; fputs($f," \n"); fputs($f,"\n"); fputs($f," >$NLSEdit\n"); fputs($f," > $NLSDelete\n"); fputs($f,"\n"); fputs($f,"\n"); fputs($f,"\n\n"); fputs($f,"$NLSEdit\";\n"); fputs($f," else:\n"); fputs($f," echo \"

$NLSNew

\";\n"); fputs($f," endif;\n"); fputs($f," ?>\n"); fputs($f,"\n"); fputs($f,"
\n"); fputs($f,"\n"); fputs($f," METHOD=POST>\n"); fputs($f,"\n"); fputs($f," \n"); $a = 1; $vf = "F1"; $vt = "T1"; $vb = "B1"; $vi = "I1"; $vm = "M1"; $vs = "S1"; $vu = "U1"; while ($$vf !=""): if ($$vs == "on"): /* An Selectlist */ fputs($f," \n"); endif; if (($$vb != "on") && ($$vs != "on")): /* A blob...., no */ fputs($f," \n"); endif; if (($$vb == "on") && ($$vs != "on")): /* A blob! */ fputs($f," \n"); fputs($f," \n"); endif; $a++; $vf = "F" . $a; $vt = "T" . $a; $vb = "B" . $a; $vi = "I" . $a; $vm = "M" . $a; $vs = "S" . $a; $vu = "U" . $a; endwhile; fputs($f,"
"); fputs($f,$$vt); if ($$vu == "on") { fputs($f,"
($NLSOptional)"); } fputs($f,": 		"); fputs($f,"\n
"); fputs($f,$$vt); if ($$vu == "on") { fputs($f,"
($NLSOptional)"); } fputs($f,": 		"); fputs($f,"\""); fputs($f,">
"); fputs($f,$$vt); if ($$vu == "on") { fputs($f,"
($NLSOptional)"); } fputs($f,":		\n"); fputs($f,"
\n"); fputs($f,"  \n"); fputs($f,"
\n"); fputs($f,"\n"); fputs($f,"\n\n"); fputs($f,"\n"); fputs($f,"\n"); for ($i = 1; ; $i++) { $fn = "F$i"; if ($$fn == "") break; $ft = "T$i"; $fsrch = "SRCH$i"; if ($$fsrch == "on") { fputs($f,"\n"); fputs($f,"\n"); fputs($f,"\n"); fputs($f,"\n"); } } fputs($f,"
"); fputs($f,$$ft); fputs($f,":
\n"); fputs($f,"\n"); fputs($f,"\n"); fputs($f,"\n"); fputs($f,"
\n"); fputs($f,"
\n"); fputs($f,"\n"); fputs($f,"\n"); fputs($f,"\n"); fclose($f); echo "Now, lets see, hm.......... the answer is 42 !

"; echo "By the way..... your code is saved as $filnamn"; ?> pccsmysqladm/genapp/genedit.php100666 0 143 2112 7172400713 15617 0ustar rootnobody $filename does not exist!"; echo "Return"; exit; } echo "

Edit of $file

"; echo "
"; echo ""; echo ""; echo "
"; echo "Cancel
"; echo "Filename: "; echo ""; echo ""; endif; //*Edit ?> pccsmysqladm/images/ 40754 0 143 0 7172400713 13364 5ustar rootnobodypccsmysqladm/images/myicon.gif100644 0 143 122 7172400713 15422 0ustar rootnobodyGIF89a ‘ÿÿÿçççkkk, +œËm¢ŒâÅ1C0˜¹u‡^£fyÊ™+¾° ¦XÝfÔ#ô¾Ÿ ;pccsmysqladm/images/mysqldb.gif100644 0 143 3074 7172400713 15630 0ustar rootnobodyGIF89a00Æ4 8  QQ Q Q8I0AQ8AQ8Aq8iQqQMQqAQaiQqiQaaaaiiyyy¦ ¦8 ¦A¦8A¦8i¦YQ¶aaŽqi¦QUÿIa×qiÿY‚iq’Qy‚yq’¦q’ÿ–¶ Q†}Ž–uߎ’ŽŽ‚®Ž¢®¶’¦®ª®®ª¶¶ª®¾º¾¶’ÿ¶Ã¦¶û¦¶ÃÿÏËÏßÛßÏó÷ÿÃÿÿûÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿ!ù@,00þ€@‚ƒ4-!!  ‹Š!133ƒ’“‚3&(”‚†££%©0-0‘Ÿ• ")>9??>›“5ˆ¥£#$¨ªª"*".4°-/;·<62)72»‚4¢¥à§"ªã©%"0ž“3)8?8Õó)‚½ßÀ¨ÁÅçȬ „ÁL’ ·pèQMǃ{µðà”©ÇT»‘BEŠ’f<ñƒ‡ŽÕìp0)ƯQˆË£M’œÝúÁ0Ú&Y WŽœ¹âT¤S”"À*Œª°™è<ÚÈQ‡Ià‘T((¬S¿NaE†T«5þ$5à!/Æ”¼š”*&Ƭ5¹ ô@žq¥ çæŠR=ŠŽ£Û8,P 1Â@=ˈÀ À+‚*¿xY° là,I vʳ—AÇ >$óx2ëFèD8ˆ­`çƒÂú¨÷#Û] ’ZõÖdT‰ÁæÀ`Có³Í º`gµÜ·|ÈÀ@~5 ‹ØŠyÜp,ÀÀf>G[8ȃÒŸ18šTóPªépÃMTQ5^y²)Ûl@ Ð^C=-ôƒ …@ÐIà} EpØ\sÏi€‚ƒ(¡ä@6ühÜ#Þ þÞ0£l@zçy8ÁaØØ÷Ð=X `Aµ(Â~\AöÁû\`æ™f š2pgd4°Òð¦…öÛ8øOŸ'Œø€ ]Y(•Ž â"q!'ã(tpŸ˜Z°f›2€€ 'ÈÐÀ /Ì@£©ùrLîÙgŸPùÀ …Þ*C¤‰3€ª—ªZ#&™¥\ ë¦n~ê‚mê ¿VxájznÀ§"F(6÷H Á àJÀB¸ãðë Ã¥£¤3Vz©¦<±™l;òè°)üÐÃNüZ üE^“ìÉJ+·@"6ÜÛI;ý`î$0þ|Àß°ª/§žN0Á Pð€¦p‚f¿”ÄžÔjÈ€ Û^ ‰Ÿ2Ü»Ó Kük%0˜`»£0€l§÷@Rï <ì»/Σü /ÀÃ’$0`p­H0å” h*š`O 3ÔðÂ! ½q²À1Ô0¾úÞœ³ÓcK"¢¶XW³BŸ6C,wÄb×- Cwü±"“ öâÐ]7 W#|ë 8|Ë 93½Sàc¾6ÑÊÎ#]qk~‹é?8þÉÝØÄ|ÇLù ˆ`ãŒsN‰çrlk¨¥Î`à qŸžùÜ;Ûù•/à ~1ê¨ë> ð”ÂÉñqÈ#GpÁ ¸—¯úà#ªËЕ‚XÀô8ì€ ÇOŸ³õ;þ`Ï>Þ3HϳAüú$½¿ðçkÁH°„0Ãt-_3ùÊ—»ä¡`%·’ÿ$ñÊÏY>( ñì×´äµàÙ%aÆÃOô#áuö‰+aé@€0$øð‡@ b¡‹lˆllH¢—ÈÄ&6QpPŒ¢;pccsmysqladm/images/menu.gif100644 0 143 465 7172400713 15102 0ustar rootnobodyGIF89a„àäà”œŒ†iskTÊêÓ͸£¥£zsZC@2À·™´¨„”‹m»±‘¹œ™p\UCID5ÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿ!þMade with GIMP!ù ,@ à'Ždiž@ €1Â*fÊóì:ã3ZÉ&+…$€X¼Ï×€yJ|»‡o¬z¿ÉÙfdÕf…"¡ÍC€Ñä9~>j\~Õ=z[H`s~>]`ˆUn‹ŒŒg3oF‚"ŽiŽ{r—nG5NsL L‹/ [x/ nt ª1êÏI³ez”êS«MµŠ%¶ëجeÏN-ëUlÚ¶NÙªEË”¥Ap/–}`®Å½fΈ×/àÀƒû]j”°`ÂyÉrEì’fß¼{ ³çÏ AOö¹Y°éÓ¨5_%¬t̆]¿núñìÛ¸;pccsmysqladm/incs/ 40655 0 143 0 7172402166 13057 5ustar rootnobodypccsmysqladm/incs/global.vars.php100655 0 143 12222 7172400713 16115 0ustar rootnobody"; } // Header Function // function common_header($_title) { global $col_bg,$col_text,$col_link,$col_alink,$col_vlink; print " $_title "; } // Heading // function heading() { global $str_mainTitle; print "

$str_mainTitle

"; } // Footer // function footer() { print""; } function refresh_meta($param) { global $PHP_SELF; print ""; } // Display Table Field // Function displayFields() { global $dbname, $tblname; $result = mysql_list_fields ("$dbname", "$tblname") or die ("Query failed"); for ($i = 0; $i < mysql_num_fields ($result); $i++) { $val = mysql_field_name ($result, $i); print "\n"; } } // Display Equate for QueryTool // Function displayEquate() { print" \n"; } } Function array2radio($arr,$name,$sel = "") { while ( list( $key, $val ) = each($arr)) { if($sel && $key == $sel) { $select_v=" checked"; } else { $select_v=""; } echo " $val\n"; } } Function mk_array($from,$to,$form="%d") { $res=array(); for($n=$from,$i=0;$n<=$to;$n++,$i++) { $res[$n]=sprintf($form,$n); } return $res; } Function mk_checkbox($name,$value,$cb_val=1) { echo "":">"); } Function callback_meta($param) { global $PHP_SELF; echo ""; } Function callback_js($param) { global $PHP_SELF; echo "\n"; } // ////////////////////////////////////////////////////////////////////////// ?> pccsmysqladm/incs/index.php100655 0 143 4717 7172400713 15004 0ustar rootnobody pccsmysqladm/incs/.htaccess100664 0 143 77 7172400713 14715 0ustar rootnobody Order allow,deny Deny from all pccsmysqladm/incs/dbconnect.php100655 0 143 2375 7172400713 15632 0ustar rootnobody"; $result = mysql($db_name,$query); return $result; } // // ///////////////////////////////////////////////////////////////////////// ?> pccsmysqladm/incs/lang_eng.php100655 0 143 6644 7172400713 15450 0ustar rootnobodySTATUS"; $str_database = "DATABASES"; $str_dbusers = "DB USERS"; $str_grant_revoke = "GRANT/REVOKE"; $str_createdb = "CREATE DB"; $str_flushtables = "FLUSH TABLES"; $str_flushhosts = "FLUSH HOSTS"; $str_flushstatus = "FLUSH STATUS"; $str_flushlogs = "FLUSH LOGS"; $str_processes = "PROCESSES"; $str_variables = "VARIABLES"; $str_webadmin = "WEB ADMIN"; $str_logout = "LOGOUT"; $str_serverInfobanner = "Server Information"; // Process List Titles $str_ps_kill = "Kill"; $str_ps_id = "Id"; $str_ps_user = "User"; $str_ps_host = "Host"; $str_ps_db = "DB"; $str_ps_command = "Command"; $str_ps_time = "Time"; $str_ps_state = "State"; $str_ps_info = "Info"; $str_sysinfobanner = "System Information"; // System Info $str_opentables = "Open Tables"; $str_openfiles = "Open Files"; $str_openedtables = "Opened Tables"; $str_questions = "Questions"; $str_runningthreads = "Running Threads"; $str_systemuptime = "System Uptime"; /////////////////////////////////////////////////////////////////////////////////////////////// // mysqldb_admin.php $str_mysqlschemadump = "MYSQL SCHEMA DUMP"; $str_processesrunningon = "Processes running on "; $str_usingmysqldbver = "using MySQL DB Version"; $str_querydb = "QUERY DB"; $str_dropdb = "DROP DB"; $str_restordb = "RESTORE DB"; $str_installscript = "INSTALL SCRIPT"; $str_viewschema = "VIEW SCHEMA"; $str_backupdb = "BACKUP DB"; $str_viewtbl = "VIEW TABLE"; $str_numtbls = "# TBLs"; // mysqldb_chgpasswd.php?action=chgpasswd $str_useradministration = "USER ADMINISTRATION"; $str_changepasswordfor = "CHANGE PASSWORD"; $str_dbuserid = "DB User ID"; $str_newpassword = "New Password"; $str_reenterpassword = "Re-enter Password"; $str_cancel = "Cancel"; $str_pwchangeorgoto = "Password Change or"; $str_gotomain = "go to Main"; $str_changepasswd = "Change Password"; // mysqldb_newuser.php3 $str_modifyuser = "MODIFY USER"; $str_username = "User Name "; $str_password = "Password "; $str_usercanconnectfrom = "User can connect from :"; $str_usertype = "USER TYPE"; $str_localhost = "LOCALHOST"; $str_anywhere = "ANYWHERE"; $str_basic = "BASIC"; $str_admin = "ADMIN"; $str_advance = "ADVANCE"; $str_operator = "OPERATOR"; $str_dbase = "DATABASE"; $str_createuserid = "Create UserID"; $str_thisusercanconnfrom = "This user can connect from "; $str_createnewacct = "Create New Account"; $str_yes = "Yes"; $str_no = "No"; // mysqldb_webadm.php3 // $str_webhostingadmin = "WEB HOSTING ADMIN"; // $str_webuserid = "Web UserID"; // $str_webuserpasswd = "Web UserPW"; // $str_lastname = "Lastname"; // $str_firstname = "Firstname"; // $str_url = "URL"; // $str_email = "E-Mail"; ?> pccsmysqladm/incs/mysqldb_functions.php100655 0 143 15752 7172400713 17461 0ustar rootnobody\n\n"); fputs($f,"\n"); fputs($f,"Web Report\n"); $today = Date("Ymd"); fputs($f,"\n"); fputs($f,"\n"); // $qry = addslashes($qry); $result = mysqlquery("$dbname",$qry) or die("Query Failed"); if (!$result) { // mysql_die(); } else { $num_rows = @mysql_num_rows($result); if ($num_rows < 1) { if (isset($zero_rows)) { echo $zero_rows; } else { echo "Empty Result Set"; } } else { if (!isset($pos)) { $pos = 0; } $pos_next = $pos + $max_rows; $pos_prev = $pos - $max_rows; if (@mysql_num_rows($dt_result)>1) { echo "Showing Records $pos - $pos_next (".mysql_num_rows($result)." Total )"; } while ($field = mysql_fetch_field($result)) { if (@mysql_num_rows($result)>1) { $sql_sort=urlencode("select * from $table order by $field->name $order"); fputs($f,"\n"); } else { fputs($f,""); } $table = $field->table; } fputs($f,"\n"); $foo = 0; while ($row = mysql_fetch_row($result)) { if ($foo < $pos_next && $foo >= $pos) { $primary_key = ""; $bgcolor = $bgcolor_one; $foo % 2 ? 0: $bgcolor = $bgcolor_two; fputs($f,""); for ($i=0; $inumeric == 1) { fputs($f,"\n"); } else { fputs($f,"\n"); } if ($primary->primary_key > 0) { $primary_key .= " $primary->name = '$row[$i]' AND"; } } if ($primary_key) { $primary_key = urlencode(ereg_replace("AND$", "", $primary_key)); $query = "&db=$db&table=$table"; } fputs($f,"\n"); } $foo++; } fputs($f,"
$field->name$field->name
 $row[$i]  ".htmlspecialchars($row[$i])." 
\n"); fputs($f,"\n"); fputs($f,"\n"); fputs($f,"\n"); fclose($f); // display_table($result); // echo "
$where1 and $where2"; } } } //////////////////////////////////////////////////////////////////////////////////// //////////////////////////////////////////////////////////////////////////////////// function show_results($qry) { global $dbname; $border = "0"; $th_bgcolor = "#D3DCE3"; $bgcolor_one = "#CCCCCC"; $bgcolor_two = "#DDDDDD"; $max_rows = "100"; $pos = 0; print ""; $qry = stripslashes($qry); $result = mysqlquery("$dbname",$qry); if (!$result) { echo $qry . "
"; echo mysql_error(); } else { $num_rows = @mysql_num_rows($result); if ($num_rows < 1) { if (isset($zero_rows)) { echo $zero_rows; } else { echo "Empty Result Set"; } } else { if (!isset($pos)) { $pos = 0; } $pos_next = $pos + $max_rows; $pos_prev = $pos - $max_rows; if (@mysql_num_rows($dt_result)>1) { echo "Showing Records $pos - $pos_next (".mysql_num_rows($result)." Total )"; } while ($field = mysql_fetch_field($result)) { if (@mysql_num_rows($result)>1) { $sql_sort=urlencode("select * from $table order by $field->name $order"); echo "\n"; } else { echo ""; } $table = $field->table; } echo "\n"; $foo = 0; while ($row = mysql_fetch_row($result)) { if ($foo < $pos_next && $foo >= $pos) { $primary_key = ""; $bgcolor = $bgcolor_one; $foo % 2 ? 0: $bgcolor = $bgcolor_two; echo ""; for ($i=0; $inumeric == 1) { echo "\n"; } else { echo "\n"; } if ($primary->primary_key > 0) { $primary_key .= " $primary->name = '$row[$i]' AND"; } } if ($primary_key) { $primary_key = urlencode(ereg_replace("AND$", "", $primary_key)); $query = "&db=$db&table=$table"; } echo "\n"; } $foo++; } echo "
$field->name$field->name
 $row[$i]  ".htmlspecialchars($row[$i])." 
\n"; // display_table($result); // echo "
$where1 and $where2"; } } } ////////////////////////////////////////////////////////////////////////////////////////////////// ////////////////////////////////////////////////////////////////////////////////////////////////// function log_this($action) { $ip = $REMOTE_ADDR; if(file_exist("logs/log.txt")) { $logfile = fopen("logs/dblog.txt","a"); fputs($logfile,$ip."\t".date("dS of F Y h:i:s A")."\t" . $db_user ."\t". $action ."\n"); fclose($logfile); } else { exec ("touch logs/dblog.txt"); $logfile = fopen("logs/dblog.txt","a"); fputs($logfile,$ip."\t".date("dS of F Y h:i:s A")."\t" . $db_user ."\t". $action ."\n"); fclose($logfile); } } ///////////////////////////////////////////////////////////////////////////////////////////////// ?> pccsmysqladm/incs/logging_function.php100655 0 143 1630 7172400713 17217 0ustar rootnobody pccsmysqladm/incs/upload_function.php100655 0 143 2307 7172400713 17057 0ustar rootnobody"; print "\n"; print "\n

Upload Database Dump File"; print "\n

"; print "\n
"; print "\n"; } $default_path = "/home/www/htdocs/pccs_mysqladm/dumpfiles"; function upload_file($the_file) { global $default_path; if(file_exists($the_file)); $this_file_name = date("YmdHms") . "_dumpfile.sql"; if(!copy($the_file,$default_path . "/" . $this_file_name)) { echo "\nSomething happened"; } else { print "\nUploaded Files:
"; print "mysql -uroot -psimple dbname < $this_file_name"; // exec("/usr/local/bin/mysql -uroot -psimple dbname < $this_file_name"; } print "

"; } ?> pccsmysqladm/incs/allowedhost.php100664 0 0 15 7172403516 15572 0ustar rootroot192.168.2.2 pccsmysqladm/index.php100644 0 143 22212 7172400714 14055 0ustar rootnobody "; print " "; print"
"; heading(); print "  
"; print "
"; $res_version = mysql_query("SELECT Version() as version") or mysql_die(); $row_version = mysql_fetch_array($res_version); $cur_date=date("l M d, Y H:i:s"); echo $cur_date; print "  "; echo "

MySQL Server Version: $row_version[version]
"; print "


"; print "
  "; displayImage("mysqldb.gif"); print "

"; print " VIEW SYSLOGS "; print "
"; print " QUERY TOOL "; print "
"; print " $str_database "; print "
"; print " $str_dbusers "; print "
"; print " $str_grant_revoke "; print "

"; // print "
$str_createdb"; print "
"; print " $str_flushtables"; print "
"; print " $str_flushhosts"; print "
"; print " $str_flushstatus"; print "
"; print " $str_flushlogs"; print "
"; print " $str_processes"; print "
"; print " $str_variables"; print "
"; print "

\"$str_mainMenu $str_mainMenustr STATUS\"
"; print "

"; $qry = "SHOW PROCESSLIST"; $res = mysql($db_name,$qry); $ps = mysql_numrows($res); print "

"; print "

"; print "

"; $result = mysqlquery("mysql","SHOW PROCESSLIST"); $num = mysql_numrows($result); $c1 = "#FFFFFF"; $c2 = "#FFFFFF"; print "

"; for ($i =0 ;$i < $num; $i++): if ($c == $c1): $c = $c2; else: $c = $c1; endif; ?> >
$str_ps_kill $str_ps_id $str_ps_user $str_ps_host $str_ps_db $str_ps_command $str_ps_time $str_ps_state $str_ps_info
onMouseOver="window.status=''; return true;" onMouseOut="window.status=' '; return true;">****

"; print "

"; print "$str_sysinfobanner"; print "

"; for ($i =0 ;$i < $num; $i++): $result = mysqlquery("mysql","SHOW STATUS"); $num = mysql_numrows($result); $var1 = mysql_result($result,$i,"Variable_name"); $var2 = mysql_result($result,$i,"Value"); $var2 = "$var2"; if ($var1 == "Questions"): print ("$str_questions : $var2  "); endif; if ($var1 == "Uptime"): print ("$str_systemuptime : $var2  "); print "
"; endif; if ($var1 == "Open_tables"): print ("$str_opentables : $var2  "); endif; if ($var1 == "Open_files"): print ("$str_openfiles : $var2  "); print "
"; endif; if ($var1 == "Opened_tables"): print ("$str_openedtables : $var2
 "); endif; if ($var1 == "Running_threads"): print ("$str_runningthreads : $var2  "); endif; endfor; print "

"; ?>
 

pccsmysqladm/installscript/ 40775 0 143 0 7172400714 15016 5ustar rootnobodypccsmysqladm/installscript/README100666 0 143 465 7172400714 15762 0ustar rootnobodyThis script includes code from my php installscript and backup script. This script is still primary for the PHP developer Scripts function Create Installation Script for Application Create Backup script for Application I've tried to make it very easy... Chauncey Thorn cthorn@wt.net http://PCCS-Linux.COM pccsmysqladm/installscript/mysqldb_installscript.php100666 0 143 30621 7172400714 22276 0ustar rootnobodyPHP Application Install Script Creator If you are a PHP developer. Using this script you can create an PHP application Install Script

\n "; print "


Application Name:
Your Email Address:
Application Web Site Address:
Application Install Help:
Application Database Name:
Application Database UserName:
Application Database User Password:

"; } if($action == "create_script") { $scriptdir = "/home/www/htdocs/pccs_mysqladm/installscript"; /* Install Filename */ $install_filename="install.php"; $f = fopen($install_filename,"w"); fputs($f,"\n"); fputs($f,"\n"); fputs($f,"\n"); fputs($f,"\n"); fputs($f,"<?php echo \$install_apptitle ?> Installation Script\n"); fputs($f,"\n"); fputs($f,"\n"); fputs($f,"

Installation Script\n"); fputs($f,"
\" target=\"\$install_websitehelp\">Installation Help | \n"); fputs($f,"\" target=\"_blank\"> Web Site\n"); fputs($f,"

\n"); fputs($f,"\n"); fputs($f,"

\n"); fputs($f,"
\n"); fputs($f,"


\n"); fputs($f,"MySQL Server:
\n"); fputs($f,"MySQL UserName:
\n"); fputs($f,"MySQL Password:
\n"); fputs($f,"MySQL Location:
\n"); fputs($f,"Database Name:
\n"); fputs($f,"Database UserName:
\n"); fputs($f,"Database User Password:

\n"); fputs($f,"\">\n"); fputs($f,"

\n"); fputs($f,"
\n"); fputs($f,"\n"); fputs($f,"

\n"); fputs($f,"Installation Script by: www.4cm.com\n"); fputs($f," & Chauncey Thorn
\n"); fputs($f,"\n\";\n"); fputs($f," }\n"); fputs($f,"\n"); fputs($f," \$create_webuser = \"GRANT SELECT,INSERT,UPDATE,DELETE on \$db_name.* \n"); fputs($f," TO \$db_user@\$mysql_server \n"); fputs($f," IDENTIFIED by \'\$db_password\'\";\n"); fputs($f," \$cwebuser = mysql_query(\$create_webuser);\n"); fputs($f," if (!empty(\$cwebuser)) {\n"); fputs($f," // Do Nothing \n"); fputs($f," } else {\n"); fputs($f," echo mysql_error().\"
\n\";\n"); fputs($f," }\n"); fputs($f,"\n"); fputs($f," \$create_tbl = \"\$mysql_location \$mysql_exec \$db_name < \$mysql_dump\";\n"); fputs($f," exec(\$create_tbl);\n"); fputs($f,"/////////////////////////////////////////////////////////////////////////////////\n"); fputs($f," print \"\$install_apptitle has been installed.\";\n"); fputs($f," print \" Click here to test it out\";\n"); fputs($f," print \"
Please Email Any Bugs and Comments to: \$install_email.\";\n"); fputs($f,"/////////////////////////////////////////////////////////////////////////////////\n"); fputs($f,"endif;\n"); fputs($f,"?>\n"); fclose($f); $backup_filename="backup.php"; $fb = fopen($backup_filename,"w"); fputs($fb,"\";\n"); fputs($fb," print \"This Page allows you to make a backup of your database App\";\n"); fputs($fb," print \"
\";\n"); fputs($fb," print \"BACKUP APPLICATION\";\n"); fputs($fb," print \"
\";\n"); fputs($fb," \n"); fputs($fb,"\n"); fputs($fb,"endif;\n"); fputs($fb,"\$dbname = \"$installappdbname\"; //your Application Database Name\n"); fputs($fb,"\$_time = date(\"His\");\n"); fputs($fb,"\$_date = date(\"Ymd\");\n"); fputs($fb,"\$dump_filename = \"\$_date\$_time_\$dbname.sql\";\n"); fputs($fb,"\$_admtool = \"/usr/local/bin/mysqldump\";\n"); fputs($fb,"\$_gzip = \"/bin/tar\";\n"); fputs($fb,"\$dump_filename = \"\$_date\$_time_\$dbname.sql\";\n"); fputs($fb,"//\n"); fputs($fb,"// Below are the paramaters for mysqldump\n"); fputs($fb,"\$par1 = '--opt';\n"); fputs($fb,"\$par2 = '-uroot';\n"); fputs($fb,"\$db_dump = \"\$_admtool \$par1 \$par2 \$dbname > ./\$dump_filename\";\n"); fputs($fb,"\$gz_dump = \"\$_gzip -czf ./\$dump_filename.tar.gz ./\$dump_filename\";\n"); fputs($fb,"\n"); fputs($fb,"if (\$action == \"backup\"):\n"); fputs($fb,"\t\theader(\"Content-type: application/gzip\");\n"); fputs($fb,"\t\theader(\"Content-Disposition: attachment; filename=\$dump_filename.tar.gz\");\n"); fputs($fb,"\n"); fputs($fb,"\t\texec(\"\$db_dump\");\n"); fputs($fb,"\t\texec(\"\$gz_dump\");\n"); fputs($fb,"\t\treadfile(\"\$dump_filename.tar.gz\");\n"); fputs($fb,"\t\tunlink(\"\$dump_filename.tar.gz\");\n"); fputs($fb,"endif;\n"); fputs($fb,"\n"); fputs($fb,"//\n"); fputs($fb,"//////////////////////////////////////////////////////////////////////////\n"); fputs($fb,"?>\n"); fclose($fb); $dumpdir = "/home/www/htdocs/pccs_mysqladm/installscript"; $dumpdb = "/usr/local/bin/mysqldump --opt -u$db_user $installappdbname > $dumpdir/$installappdbname.mysql"; $dumpdbpw = "/usr/local/bin/mysqldump --opt -u$db_user -p$db_password $installappdbname > $dumpdir/$installappdbname.mysql"; if($db_password == "") { passthru($dumpdb,$result); } else { passthru($dumpdbpw,$result); } echo "A PHP Install Script has been created for" . $install_apptitle . "!

\n"; echo "The install script code is saved as $install_filename

\n"; echo "The backup script code is saved as $backup_filename

\n"; echo "The SQL Dump is saved as $installappdbname.mysql

\n"; } footer(); ?> pccsmysqladm/login.php100644 0 143 1325 7172403643 14044 0ustar rootnobodyApplication Not installed completely. Please run bin/fix_perm.sh"); } // DisplayLogin Function VERY SIMPLE login solution function displayLogin() { Header("WWW-authenicate: basic realm=\"PCCS MySQLDatabase Admin Tool\""); Header("HTTP/1.0 401 Unauthorized"); die("Login Failed"); } // Check to see if user is defined if(!isset($PHP_AUTH_USER)) displayLogin(); ?> pccsmysqladm/logout.php100644 0 143 224 7172400714 14216 0ustar rootnobody pccsmysqladm/logs/ 40775 0 143 0 7172404326 13072 5ustar rootnobodypccsmysqladm/logs/log.txt100666 0 143 524 7172400713 14470 0ustar rootnobodyLinux|Mozilla/4.7 [en] (X11; I; Linux 2.2.14-15mdksecure i586)|192.168.2.2|10th of September 2000 03:12:26 PM|INVALID DIRECTORY ACCESS Attempted to the logs directory!!! Linux|Mozilla/4.7 [en] (X11; I; Linux 2.2.14-15mdksecure i586)|192.168.2.2|10th of September 2000 03:13:32 PM|INVALID DIRECTORY ACCESS Attempted to the logs directory!!! pccsmysqladm/logs/dblog.txt100666 0 143 2224 7172400714 15016 0ustar rootnobody192.168.2.2,10th of September 2000 02:03:14 PM,root,SET PASSWORD FOR student1@% = PASSWORD("student1") 192.168.2.2,10th of September 2000 02:03:56 PM,root,SET PASSWORD FOR student1@% = PASSWORD("student1") 192.168.2.2,10th of September 2000 02:09:47 PM,root,SET PASSWORD FOR student1@% 192.168.2.2,10th of September 2000 02:14:27 PM,root,GRANT all ON website.contact TO student1@\'%\' 192.168.2.2,10th of September 2000 02:16:48 PM,root,GRANT all ON website.contact TO student1@\'%\' 192.168.2.2,10th of September 2000 02:19:32 PM,root,REVOKE ALL ON website.contact FROM student1@\'%\' 192.168.2.2,10th of September 2000 03:55:09 PM,root,DROP DATABASE test1 192.168.2.2,10th of September 2000 05:03:02 PM,root,FLUSH TABLES 192.168.2.2,24th of September 2000 10:10:27 PM,root,FLUSH STATUS 192.168.2.2,24th of September 2000 10:10:32 PM,root,FLUSH LOGS 192.168.2.2,07th of October 2000 07:04:33 PM,cthorn,DROP DATABASE testingdb 192.168.2.2,07th of October 2000 07:04:51 PM,cthorn,DROP DATABASE testingdb1 192.168.2.2,07th of October 2000 07:06:37 PM,cthorn,DROP DATABASE testingdb 192.168.2.2,07th of October 2000 07:13:12 PM,cthorn,DROP DATABASE testingdb pccsmysqladm/logs/badiplog.txt100666 0 143 206 7172400714 15466 0ustar rootnobodyLinux|Mozilla/4.7 [en] (X11; I; Linux 2.2.14-15mdksecure i586)|192.168.2.2|10th of September 2000 03:13:32 PM|Watch this: IP ADDRESS pccsmysqladm/logs/index.php100666 0 143 4144 7172400714 15011 0ustar rootnobody pccsmysqladm/logs/.htaccess100664 0 143 100 7172400714 14731 0ustar rootnobody Order allow,deny Deny from all pccsmysqladm/mysqldb_admin.php100644 0 143 25563 7172400714 15605 0ustar rootnobody"; if ($argv[0] == ""): $menu = "$str_mainMenu"; endif; if ($action == "dbschema"): $menu = "$str_mysqlschemadump"; endif; print "

$_title : $menu

"; print "

"; print "
"; print "

"; // Display Process list $qry = "SHOW PROCESSLIST"; $res = mysql($db_name,$qry); $ps = mysql_numrows($res); print "

"; print "$str_processesrunningon $db_server: "; print " $ps  "; print " $str_usingmysqldbver $display_mysql_version  "; print " $str_sysstatus  "; print "

"; print "[ "; print "$str_mainlnk "; print "| $str_installscriptlink "; print "| $str_readmysqldoc "; print " ]"; print "

"; print "

"; if ($argv[0] == ""): // Display Databases $result = mysqlquery("mysql","SHOW DATABASES"); $num = mysql_numrows($result); print "

"; for ($i =0 ;$i < $num; $i++): if ($c == $c1): $c = $c2; else: $c = $c1; endif; print ""; $db = mysql_result($result,$i,"Database"); print " "; print ""; print ""; print ""; print ""; print ""; print ""; endfor; print "
$str_database $str_restordb $str_dropdb $str_backupdb $str_viewtbl $str_numtbls
"; print ""; print (strtoupper("$db")); print ""; print ""; print "$str_restordb"; print ""; print "$str_dropdb"; print ""; print "$str_backupdb"; print ""; print "$str_viewtbl"; print ""; // Show tables in database $qry = "SHOW TABLES FROM $db"; $res = @mysql($db,$qry); $records = @mysql_numrows($res); if($records <= 0 ) { echo " "; } else { echo $records; } print "
"; endif; if($action =="dumpdb"): function dumpdb($dbname) { global $mysqldbuser, $mysqldbpasswd; $_time = date("H:i:s"); $_date = date("Y-m-d"); $_admtool = "/usr/local/bin/mysqldump"; $par = "--opt -u$mysqldbuser -p$mysqldbpasswd $dbname"; $command = "$_admtool $par"; echo "Database dump for $dbname"; echo "
"; echo "$_date :: $_time"; echo "

"; exec ($command, $dd, $result); $dd[] = $dd - 1; $indexLimit = count($dd); for($index=0; $index < $indexLimit; $index++) { $_dumpdata = (" $dd[$index] "); echo (" $_dumpdata
"); } } dumpdb($dbname); endif; if($action =="warn_dropdb"): // Do you really want to delete database YES or NO // print "

"; print "ARE You Sure you want to DROP DATABASE $dbname"; print "

"; print "<<< NO :"; print ": YES >>>"; print "

"; endif; if($action == "dropdb"): // Drop Database // You said delete database // $qry = "DROP DATABASE $db"; $result = mysqlquery("mysql", $qry); if(!empty($result)) { log_this($qry,"dblog.txt"); echo ""; } else { } endif; /************** if($action =="dbschema"): // Not using this code // Will more that likely remove function dumpdb($dbname,$newdbname) { global $mysqldbuser, $mysqldbpasswd; $_time = date("H:i:s"); $_date = date("Y-m-d"); $_admtool = "/usr/local/bin/mysqldump"; $_clienttool = "/usr/local/bin/mysql"; $par = "--opt -u$mysqldbuser -p$mysqldbpasswd $dbname "; $par2 = "| $_clienttool $newdbname "; $command = "$_admtool $par $par2"; // echo "Database dump for $dbname\n"; // echo "\n"; // echo "$_date :: $_time"; // echo "\n\n"; exec ($command); // $dd[] = $dd - 1; // $indexLimit = count($dd); // for($index=0; $index < $indexLimit; $index++) { // $_dumpdata = (" $dd[$index] "); // echo (" $_dumpdata\n "); // echo $_admtool and $par ; // } } // Create database from dump file // print "BACK"; endif; *********/ /// if($action =="processlist"): // Display Process List // URL: action=processlist $result = mysqlquery("mysql","SHOW PROCESSLIST "); $num = mysql_numrows($result); $c1 = "#CCCCCC"; $c2 = "#CCCCCC"; print "
"; for ($i =0 ;$i < $num; $i++): if ($c == $c1): $c = $c2; else: $c = $c1; endif; ?> >
Kill Id User Host DB Command Time State Info
?action=killprocess&par=>****

"; for ($i =0 ;$i < $num; $i++): if ($c == $c1): $c = $c2; else: $c = $c1; endif; print ""; ?>
Status Variable Value
"; print "

"; print "$str_sysinfobanner"; print "

"; for ($i =0 ;$i < $num; $i++): $result = mysqlquery("mysql","SHOW STATUS"); $num = mysql_numrows($result); $var1 = mysql_result($result,$i,"Variable_name"); $var2 = mysql_result($result,$i,"Value"); $var2 = "$var2"; if ($var1 == "Questions"): print ("$str_questions : $var2  "); endif; if ($var1 == "Uptime"): print "
"; print ("$str_systemuptime : $var2  "); endif; if ($var1 == "Open_tables"): print ("$str_opentables : $var2  "); endif; if ($var1 == "Open_files"): print ("$str_openfiles : $var2  "); endif; if ($var1 == "Opened_tables"): print ("$str_openedtables : $var2
 "); endif; if ($var1 == "Running_threads"): print ("$str_runningthreads : $var2  "); print "
"; endif; endfor; print "

"; endif; if($action == "killprocess"): $qry ="KILL $par"; $result = mysqlquery($db_name,$qry); if (!empty($result)) { // } else { echo mysql_error()."
\n"; echo "$qry"; } refresh_meta("action=processlist"); endif; footer(); ?> pccsmysqladm/mysqldb_admpanel.php100644 0 143 14254 7172400714 16271 0ustar rootnobody"; $qry = addslashes($qry); $result = mysqlquery("$dbname",$qry); if (!$result) { // mysql_die(); } else { $num_rows = @mysql_num_rows($result); if ($num_rows < 1) { if (isset($zero_rows)) { echo $zero_rows; } else { echo "Empty Result Set"; } } else { if (!isset($pos)) { $pos = 0; } $pos_next = $pos + $max_rows; $pos_prev = $pos - $max_rows; if (@mysql_num_rows($dt_result)>1) { echo "Showing Records $pos - $pos_next (".mysql_num_rows($result)." Total )"; } while ($field = mysql_fetch_field($result)) { if (@mysql_num_rows($result)>1) { $sql_sort=urlencode("select * from $table order by $field->name $order"); echo "$field->name\n"; } else { echo "$field->name"; } $table = $field->table; } echo "\n"; $foo = 0; while ($row = mysql_fetch_row($result)) { if ($foo < $pos_next && $foo >= $pos) { $primary_key = ""; $bgcolor = $bgcolor_one; $foo % 2 ? 0: $bgcolor = $bgcolor_two; echo ""; for ($i=0; $inumeric == 1) { echo " $row[$i] \n"; } else { echo " ".htmlspecialchars($row[$i])." \n"; } if ($primary->primary_key > 0) { $primary_key .= " $primary->name = '$row[$i]' AND"; } } if ($primary_key) { $primary_key = urlencode(ereg_replace("AND$", "", $primary_key)); $query = "&db=$db&table=$table"; } echo "\n"; } $foo++; } echo "\n"; } } } /////////////////////////////////////////////////////////////////////////////// if($action == "getdbname") { print "
New Database
Database Name
Database Dump Filename
"; } elseif($action == "upload") { require('incs/upload_function.php'); if($task == "upload") { upload_file($the_file); } else { upload_form(); } } elseif($action == "createdb") { $qry = "CREATE DATABASE $_dbname"; // $dump_filename = "$_date$_time_$dbname.sql"; $_admtool = "/usr/local/bin/mysql"; $_gzip = "/bin/tar"; // // $dump_filename = "$dbname.sql"; // Below are the paramaters for mysql $par1 = ''; $par2 = '-uroot '; if(file_exists($dump_filename)) { $filesize = filesize("$dump_filename"); if($filesize > 0) { $process_file = "$_admtool $par1 $par2 $_dbname < ./$dump_filename"; exec ("process_file"); } else { echo $dump_filename . " Has ZERO Bytes..."; } } else { echo $dump_filename . " Does not EXSIT!. Please Make sure you uploaded it.."; } log_this($qry); show_results($qry); echo ""; } elseif($action == "flush_t") { $qry = "FLUSH TABLES"; log_this($qry,"dblog.txt"); show_results($qry); echo ""; } elseif($action == "flush_h") { $qry = "FLUSH HOSTS"; log_this($qry,"dblog.txt"); show_results($qry); echo ""; } elseif($action == "flush_l") { $qry = "FLUSH LOGS"; log_this($qry,"dblog.txt"); show_results($qry); echo ""; } elseif($action == "flush_s") { $qry = "FLUSH STATUS"; log_this($qry,"dblog.txt"); show_results($qry); echo ""; } elseif($action == "show_var") { $qry = "SHOW VARIABLES"; show_results($qry); } elseif($action == "show_ps") { $qry = "SHOW PROCESSLIST"; show_results($qry); } else { // } footer(); ?> pccsmysqladm/mysqldb_admusers.php100644 0 143 61615 7172400714 16336 0ustar rootnobody"; print "

$_title : USER ADMINISTRATION

"; print "

"; print "
"; print "

"; if ($action == "_listall"): $qry = "SELECT * FROM user ORDER BY Host"; $result = mysqlquery("mysql",$qry); $num = mysql_numrows($result); $c1 = "#CCCCCC"; $c2 = "#CCCCCC"; print "

"; print"
[S]elect [I]nsert [U]pdate [D]elete [C]reate
[D]rop [S]hutdown [P]rocess [F]ile  
[G]rant [R]eference [I]ndex [A]lter  
"; print " "; for ($i =0 ;$i < $num; $i++): if ($c == $c1): $c = $c2; else: $c = $c1; endif; $host = mysql_result($result,$i,"Host"); $User = mysql_result($result,$i,"User"); $Select = mysql_result($result,$i,"Select_priv"); $Insert = mysql_result($result,$i,"Insert_priv"); $Update = mysql_result($result,$i,"Update_priv"); $Delete = mysql_result($result,$i,"Delete_priv"); $Create = mysql_result($result,$i,"Create_priv"); $Drop = mysql_result($result,$i,"Drop_priv"); $Shutdown = mysql_result($result,$i,"Shutdown_priv"); $Process = mysql_result($result,$i,"Process_priv"); $File = mysql_result($result,$i,"File_priv"); $Grant = mysql_result($result,$i,"Grant_priv"); $Ref = mysql_result($result,$i,"References_priv"); $Index = mysql_result($result,$i,"Index_priv"); $Alter = mysql_result($result,$i,"Alter_priv"); print " "; endfor; print "
Edit Db Edit Host User S I U D C D S P F G R I A
 **   **  $host $User $Select $Insert $Update $Delete $Create $Drop $Shutdown $Process $File $Grant $Ref $Index $Alter
"; print "

"; print "<<<back to user management...   "; print "back to main...>>>"; endif; ///////////////////////////////////////////////////////////////////////////////////////////////////////// ///////////////////////////////////////////////////////////////////////////////////////////////////////// if ($action == "_edit"): $option = ""; $qry = "SELECT * FROM user WHERE Host='$Host' AND User='$User'"; $result = mysqlquery("mysql",$qry); $Host=htmlspecialchars(mysql_result($result,0,"Host")); $User=htmlspecialchars(mysql_result($result,0,"User")); $Password=htmlspecialchars(mysql_result($result,0,"Password")); $Select_priv=htmlspecialchars(mysql_result($result,0,"Select_priv")); $Insert_priv=htmlspecialchars(mysql_result($result,0,"Insert_priv")); $Update_priv=htmlspecialchars(mysql_result($result,0,"Update_priv")); $Delete_priv=htmlspecialchars(mysql_result($result,0,"Delete_priv")); $Create_priv=htmlspecialchars(mysql_result($result,0,"Create_priv")); $Drop_priv=htmlspecialchars(mysql_result($result,0,"Drop_priv")); $Reload_priv=htmlspecialchars(mysql_result($result,0,"Reload_priv")); $Shutdown_priv=htmlspecialchars(mysql_result($result,0,"Shutdown_priv")); $Process_priv=htmlspecialchars(mysql_result($result,0,"Process_priv")); $File_priv=htmlspecialchars(mysql_result($result,0,"File_priv")); $Grant_priv=htmlspecialchars(mysql_result($result,0,"Grant_priv")); $References_priv=htmlspecialchars(mysql_result($result,0,"References_priv")); $Index_priv=htmlspecialchars(mysql_result($result,0,"Index_priv")); $Alter_priv=htmlspecialchars(mysql_result($result,0,"Alter_priv")); echo "

Edit User: $User that connects from $Host

"; $user = $User=htmlspecialchars(mysql_result($result,0,"User")); print "
"; print "
Host:
User: Password:
Select
Insert
Update:
Delete
Create:
Drop:
Reload:
Shutdown:
Process:
File:
Grant:
References:
Index:
Alter:
 
"; endif; /////////////////////////////////////////////////////////////////////////////////////////////// /////////////////////////////////////////////////////////////////////////////////////////////// if ($action == "_update"): //*** Check data Input $ok = 1; echo ""; $Host=chop($Host); if ($Host == ""): echo ""; $ok = 0; echo ""; endif; if (!empty($fields)) $fields.=','; $fields.="Host="; $fields.="'$Host'"; $User=chop($User); if ($User == ""): echo ""; $ok = 0; echo ""; endif; if (!empty($fields)) $fields.=','; $fields.="User="; $fields.="'$User'"; $Password=chop($Password); if ($Password == ""): echo ""; $ok = 0; echo ""; endif; if (!empty($fields)) $fields.=','; $fields.="Password="; $fields.="password('$Password')"; $Select_priv=chop($Select_priv); if ($Select_priv == ""): echo ""; $ok = 0; echo ""; endif; if (!empty($fields)) $fields.=','; $fields.="Select_priv="; $fields.="'$Select_priv'"; $Insert_priv=chop($Insert_priv); if ($Insert_priv == ""): echo ""; $ok = 0; echo ""; endif; if (!empty($fields)) $fields.=','; $fields.="Insert_priv="; $fields.="'$Insert_priv'"; $Update_priv=chop($Update_priv); if ($Update_priv == ""): echo ""; $ok = 0; echo ""; endif; if (!empty($fields)) $fields.=','; $fields.="Update_priv="; $fields.="'$Update_priv'"; $Delete_priv=chop($Delete_priv); if ($Delete_priv == ""): echo ""; $ok = 0; echo ""; endif; if (!empty($fields)) $fields.=','; $fields.="Delete_priv="; $fields.="'$Delete_priv'"; $Create_priv=chop($Create_priv); if ($Create_priv == ""): echo ""; $ok = 0; echo ""; endif; if (!empty($fields)) $fields.=','; $fields.="Create_priv="; $fields.="'$Create_priv'"; $Drop_priv=chop($Drop_priv); if ($Drop_priv == ""): echo ""; $ok = 0; echo ""; endif; if (!empty($fields)) $fields.=','; $fields.="Drop_priv="; $fields.="'$Drop_priv'"; $Reload_priv=chop($Reload_priv); if ($Reload_priv == ""): echo ""; $ok = 0; echo ""; endif; if (!empty($fields)) $fields.=','; $fields.="Reload_priv="; $fields.="'$Reload_priv'"; $Shutdown_priv=chop($Shutdown_priv); if ($Shutdown_priv == ""): echo ""; $ok = 0; echo ""; endif; if (!empty($fields)) $fields.=','; $fields.="Shutdown_priv="; $fields.="'$Shutdown_priv'"; $Process_priv=chop($Process_priv); if ($Process_priv == ""): echo ""; $ok = 0; echo ""; endif; if (!empty($fields)) $fields.=','; $fields.="Process_priv="; $fields.="'$Process_priv'"; $File_priv=chop($File_priv); if ($File_priv == ""): echo ""; $ok = 0; echo ""; endif; if (!empty($fields)) $fields.=','; $fields.="File_priv="; $fields.="'$File_priv'"; $Grant_priv=chop($Grant_priv); if ($Grant_priv == ""): echo ""; $ok = 0; echo ""; endif; if (!empty($fields)) $fields.=','; $fields.="Grant_priv="; $fields.="'$Grant_priv'"; $References_priv=chop($References_priv); if ($References_priv == ""): echo ""; $ok = 0; echo ""; endif; if (!empty($fields)) $fields.=','; $fields.="References_priv="; $fields.="'$References_priv'"; $Index_priv=chop($Index_priv); if ($Index_priv == ""): echo ""; $ok = 0; echo ""; endif; if (!empty($fields)) $fields.=','; $fields.="Index_priv="; $fields.="'$Index_priv'"; $Alter_priv=chop($Alter_priv); if ($Alter_priv == ""): echo ""; $ok = 0; echo ""; endif; if (!empty($fields)) $fields.=','; $fields.="Alter_priv="; $fields.="'$Alter_priv'"; $qry = "UPDATE user SET $fields WHERE Host='$Host' AND User='$User' "; $result = mysqlquery("mysql",$qry); if (!empty($result)) { echo $qry; // $qry = "FLUSH PRIVILEGES"; // $result = mysqlquery("mysql",$qry); // if (!empty($result)) { // echo $qry; // echo ""; // } else { // echo mysql_error()."
\n"; // } } else { echo mysql_error()."
\n"; } endif; ////////////////////////////////////////////////////////////////////////////// ////////////////////////////////////////////////////////////////////////////// if ($action == "_listdbs"): $qry = "SELECT * FROM db WHERE User='$User' AND Host=trim('$Host') ORDER BY Host"; $result = mysqlquery("mysql", $qry); $num = mysql_numrows($result); $c1 = "#CCCCCC"; $c2 = "#CCCCCC"; print "
Host: $HostHost must be specified !
User: $UserUser must be specified !
Password: $PasswordPassword must be specified !
Select: $Select_privSelect must be specified !
Insert: $Insert_privInsert must be specified !
Update: $Update_privUpdate must be specified !
Delete: $Delete_privDelete must be specified !
Create: $Create_privCreate must be specified !
Drop: $Drop_privDrop must be specified !
Reload: $Reload_privReload must be specified !
Shutdown: $Shutdown_privShutdown must be specified !
Process: $Process_privProcess must be specified !
File: $File_privFile must be specified !
Grant: $Grant_privGrant must be specified !
References: $References_privReferences must be specified !
Index: $Index_privIndex must be specified !
Alter: $Alter_privAlter must be specified !
"; for ($i =0 ;$i < $num; $i++): if ($c == $c1): $c = $c2; else: $c = $c1; endif; print " "; $Host = mysql_result($result,$i,"Host"); $User = mysql_result($result,$i,"User"); $Db = mysql_result($result,$i,"Db"); $Select = mysql_result($result,$i,"Select_priv"); $Insert = mysql_result($result,$i,"Insert_priv"); $Update = mysql_result($result,$i,"Update_priv"); $Delete = mysql_result($result,$i,"Delete_priv"); $Create = mysql_result($result,$i,"Create_priv"); $Drop = mysql_result($result,$i,"Drop_priv"); $Grant = mysql_result($result,$i,"Grant_priv"); $Ref = mysql_result($result,$i,"References_priv"); $Index = mysql_result($result,$i,"Index_priv"); $Alter = mysql_result($result,$i,"Alter_priv"); print " "; endfor; print "
Host User Db(s) S I U D C D R G R A
$Host $User $Db $Select $Insert $Update $Delete $Create $Drop $Grant $Ref $Index $Alter
"; endif; /////////////////////////////////////////////////////////////////////////// /////////////////////////////////////////////////////////////////////////// if ($action == "_editdb"): $qry = "SELECT * FROM db WHERE User='$User' AND Host=trim('$Host') ORDER BY Host"; $result = mysqlquery("mysql", $qry); $num = mysql_numrows($result); $c1 = "#CCCCCC"; $c2 = "#CCCCCC"; print "
"; for ($i =0 ;$i < $num; $i++): if ($c == $c1): $c = $c2; else: $c = $c1; endif; print " "; $Host = mysql_result($result,$i,"Host"); $User = mysql_result($result,$i,"User"); $Db = mysql_result($result,$i,"Db"); $Select = mysql_result($result,$i,"Select_priv"); $Insert = mysql_result($result,$i,"Insert_priv"); $Update = mysql_result($result,$i,"Update_priv"); $Delete = mysql_result($result,$i,"Delete_priv"); $Create = mysql_result($result,$i,"Create_priv"); $Drop = mysql_result($result,$i,"Drop_priv"); $Grant = mysql_result($result,$i,"Grant_priv"); $Ref = mysql_result($result,$i,"References_priv"); $Index = mysql_result($result,$i,"Index_priv"); $Alter = mysql_result($result,$i,"Alter_priv"); print " "; endfor; print "
Host User Db(s) S I U D C D R G R A
$Host $User $Db $Select $Insert $Update $Delete $Create $Drop $Grant $Ref $Index $Alter
"; $qry = "SELECT * FROM db WHERE Host='$Host' AND USER='$User'"; $result = mysqlquery("mysql",$qry); // if(!empty($result)) { $Host=htmlspecialchars(@mysql_result($result,0,"Host")); $Db=htmlspecialchars(@mysql_result($result,0,"Db")); $User=htmlspecialchars(@mysql_result($result,0,"User")); $Select_priv=htmlspecialchars(@mysql_result($result,0,"Select_priv")); $Insert_priv=htmlspecialchars(@mysql_result($result,0,"Insert_priv")); $Update_priv=htmlspecialchars(@mysql_result($result,0,"Update_priv")); $Delete_priv=htmlspecialchars(@mysql_result($result,0,"Delete_priv")); $Create_priv=htmlspecialchars(@mysql_result($result,0,"Create_priv")); $Drop_priv=htmlspecialchars(@mysql_result($result,0,"Drop_priv")); $Grant_priv=htmlspecialchars(@mysql_result($result,0,"Grant_priv")); $References_priv=htmlspecialchars(@mysql_result($result,0,"References_priv")); $Index_priv=htmlspecialchars(@mysql_result($result,0,"Index_priv")); $Alter_priv=htmlspecialchars(@mysql_result($result,0,"Alter_priv")); print "

Edit access for $User on Dbase: $Db

"; print "
"; print "
Host:
Database:
User:
Select
Insert
Update:
Delete
Create:
Drop:
Grant:
References:
Index:
Alter:
 
"; // } else { // } endif; ?> pccsmysqladm/mysqldb_backup.php100644 0 143 3452 7172400714 15733 0ustar rootnobody ./$dump_filename"; $gz_dump = "$_gzip -czf ./$dump_filename.tar.gz ./$dump_filename"; if ($action == "backup"): header("Content-type: application/gzip"); header("Content-Disposition: attachment; filename=$dump_filename.tar.gz"); exec ("$db_dump"); exec ("$gz_dump"); readfile("$dump_filename.tar.gz"); unlink("$dump_filename.tar.gz"); endif; ?> pccsmysqladm/mysqldb_chgpasswd.php100644 0 143 4725 7172400714 16455 0ustar rootnobody "; print "

$_title : USER ADMINISTRATION

"; print "

"; print "
"; print "

"; if($action = "chgpasswd"): print "

Change Password for
DB User Id
New Password
Re-enter Password
"; print "
"; print " CancelPassword Change"; print " or got to Main

"; print "

"; endif; footer(); ?> pccsmysqladm/mysqldb_db.php100644 0 143 46736 7172400714 15107 0ustar rootnobody MySQL Database Privilege Table "; require('login.php'); require('incs/dbconnect.php'); require('incs/global.vars.php'); if (empty($action)) $action="browselist"; $Select_priv_arr = array( "N" => "N", "Y" => "Y" ); $Insert_priv_arr = array( "N" => "N", "Y" => "Y" ); $Update_priv_arr = array( "N" => "N", "Y" => "Y" ); $Delete_priv_arr = array( "N" => "N", "Y" => "Y" ); $Create_priv_arr = array( "N" => "N", "Y" => "Y" ); $Drop_priv_arr = array( "N" => "N", "Y" => "Y" ); $Grant_priv_arr = array( "N" => "N", "Y" => "Y" ); $References_priv_arr = array( "N" => "N", "Y" => "Y" ); $Index_priv_arr = array( "N" => "N", "Y" => "Y" ); $Alter_priv_arr = array( "N" => "N", "Y" => "Y" ); $months["01"] = "January"; $months["02"] = "February"; $months["03"] = "March"; $months["04"] = "April"; $months["05"] = "May"; $months["06"] = "June"; $months["07"] = "July"; $months["08"] = "August"; $months["09"] = "September"; $months["10"] = "October"; $months["11"] = "November"; $months["12"] = "December"; ?> \n"; } ?> "; $fields = ""; $values = ""; $Host=chop($Host); if ($Host == "") { $ok = 0; echo "Host - must be specified !
"; } else { $fields .= ",Host"; $values.=",'$Host'"; } $Db=chop($Db); if ($Db == "") { $ok = 0; echo "Db - must be specified !
"; } else { $fields .= ",Db"; $values.=",'$Db'"; } $User=chop($User); if ($User == "") { $ok = 0; echo "User - must be specified !
"; } else { $fields .= ",User"; $values.=",'$User'"; } $Select_priv=chop($Select_priv); if ($Select_priv == "") { $ok = 0; echo "Select - must be specified !
"; } else { $fields .= ",Select_priv"; $values.=",'$Select_priv'"; } $Insert_priv=chop($Insert_priv); if ($Insert_priv == "") { $ok = 0; echo "Insert - must be specified !
"; } else { $fields .= ",Insert_priv"; $values.=",'$Insert_priv'"; } $Update_priv=chop($Update_priv); if ($Update_priv == "") { $ok = 0; echo "Update - must be specified !
"; } else { $fields .= ",Update_priv"; $values.=",'$Update_priv'"; } $Delete_priv=chop($Delete_priv); if ($Delete_priv == "") { $ok = 0; echo "Delete - must be specified !
"; } else { $fields .= ",Delete_priv"; $values.=",'$Delete_priv'"; } $Create_priv=chop($Create_priv); if ($Create_priv == "") { $ok = 0; echo "Create - must be specified !
"; } else { $fields .= ",Create_priv"; $values.=",'$Create_priv'"; } $Drop_priv=chop($Drop_priv); if ($Drop_priv == "") { $ok = 0; echo "Drop - must be specified !
"; } else { $fields .= ",Drop_priv"; $values.=",'$Drop_priv'"; } $Grant_priv=chop($Grant_priv); if ($Grant_priv == "") { $ok = 0; echo "Grant - must be specified !
"; } else { $fields .= ",Grant_priv"; $values.=",'$Grant_priv'"; } $References_priv=chop($References_priv); if ($References_priv == "") { $ok = 0; echo "References - must be specified !
"; } else { $fields .= ",References_priv"; $values.=",'$References_priv'"; } $Index_priv=chop($Index_priv); if ($Index_priv == "") { $ok = 0; echo "Index - must be specified !
"; } else { $fields .= ",Index_priv"; $values.=",'$Index_priv'"; } $Alter_priv=chop($Alter_priv); if ($Alter_priv == "") { $ok = 0; echo "Alter - must be specified !
"; } else { $fields .= ",Alter_priv"; $values.=",'$Alter_priv'"; } echo ""; if (!$ok): echo "Error!"; echo "
Try again"; exit; endif; ?> \n"; } ?> "; $fields = ""; $Host=chop($Host); if ($Host == "") { $ok = 0; echo "Host - must be specified !
"; } $fields.=','; $fields.="Host="; $fields.="'$Host'"; $Db=chop($Db); if ($Db == "") { $ok = 0; echo "Db - must be specified !
"; } $fields.=','; $fields.="Db="; $fields.="'$Db'"; // $User=chop($User); // if ($User == "") { // $ok = 0; // echo "User - must be specified !
"; // } $fields.=','; $fields.="User="; $fields.="'$User'"; $Select_priv=chop($Select_priv); if ($Select_priv == "") { $ok = 0; echo "Select - must be specified !
"; } $fields.=','; $fields.="Select_priv="; $fields.="'$Select_priv'"; $Insert_priv=chop($Insert_priv); if ($Insert_priv == "") { $ok = 0; echo "Insert - must be specified !
"; } $fields.=','; $fields.="Insert_priv="; $fields.="'$Insert_priv'"; $Update_priv=chop($Update_priv); if ($Update_priv == "") { $ok = 0; echo "Update - must be specified !
"; } $fields.=','; $fields.="Update_priv="; $fields.="'$Update_priv'"; $Delete_priv=chop($Delete_priv); if ($Delete_priv == "") { $ok = 0; echo "Delete - must be specified !
"; } $fields.=','; $fields.="Delete_priv="; $fields.="'$Delete_priv'"; $Create_priv=chop($Create_priv); if ($Create_priv == "") { $ok = 0; echo "Create - must be specified !
"; } $fields.=','; $fields.="Create_priv="; $fields.="'$Create_priv'"; $Drop_priv=chop($Drop_priv); if ($Drop_priv == "") { $ok = 0; echo "Drop - must be specified !
"; } $fields.=','; $fields.="Drop_priv="; $fields.="'$Drop_priv'"; $Grant_priv=chop($Grant_priv); if ($Grant_priv == "") { $ok = 0; echo "Grant - must be specified !
"; } $fields.=','; $fields.="Grant_priv="; $fields.="'$Grant_priv'"; $References_priv=chop($References_priv); if ($References_priv == "") { $ok = 0; echo "References - must be specified !
"; } $fields.=','; $fields.="References_priv="; $fields.="'$References_priv'"; $Index_priv=chop($Index_priv); if ($Index_priv == "") { $ok = 0; echo "Index - must be specified !
"; } $fields.=','; $fields.="Index_priv="; $fields.="'$Index_priv'"; $Alter_priv=chop($Alter_priv); if ($Alter_priv == "") { $ok = 0; echo "Alter - must be specified !
"; } $fields.=','; $fields.="Alter_priv="; $fields.="'$Alter_priv'"; if (!$ok): echo "Error!"; echo "
Try again"; exit; endif; $fields = substr($fields,1,strlen($fields)-1); $result = mysqlquery("mysql","UPDATE db SET $fields WHERE User='$User' AND Host='$par'"); if (!empty($result)) { callback_js("action=browselist&start=0"); } else { echo mysql_error()."
\n"; } ?>
[ Grant/Revoke | List all | Search ]
0)) { echo "<<<Previous $limit   "; } if (isset($start) && ((($start+$limit) < $found))) { echo ">>>Next ",min($found-$start-$limit,$limit),""; } endif; ?>

Are you sure you want to delete this record?

Yes   No Search for '$searchvalue ' in '$whichfield ' returned $found hits"; $num = mysql_numrows($result); $c1 = "#EEEEEE"; $c2 = "#CCCCCC"; ?>
"; echo ""; echo ""; echo ""; endfor; echo "
User
",mysql_result($result,$i,"Host"),""; $val = mysql_result($result, $i, "User"); print_sp($val); echo "
"; mysql_free_result($result); endif /* Search */ ?> Host+User that are ALLOWED to interact with a database table"; $result = mysqlquery("mysql","SELECT * FROM db ORDER BY Host LIMIT $start,$limit"); $num = mysql_numrows($result); $c1 = "#EEEEEE"; $c2 = "#CCCCCC"; ?>
"; echo ""; echo ""; echo ""; endfor; echo "
HostUser
",mysql_result($result,$i,"Host"),""; $val = mysql_result($result, $i, "User"); print_sp($val); echo "
"; mysql_free_result($result); endif /* Show all */ ?> Host: ",mysql_result($result,0,"Host"),""; ?> "; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; ?>
Host: "; print_html(mysql_result($result,0,"Host")); echo "
Db: "; print_html(mysql_result($result,0,"Db")); echo "
User: "; print_html(mysql_result($result,0,"User")); echo "
Select: "; echo $Select_priv_arr[mysql_result($result,0,"Select_priv")]; echo "
Insert: "; echo $Insert_priv_arr[mysql_result($result,0,"Insert_priv")]; echo "
Update: "; echo $Update_priv_arr[mysql_result($result,0,"Update_priv")]; echo "
Delete: "; echo $Delete_priv_arr[mysql_result($result,0,"Delete_priv")]; echo "
Create: "; echo $Create_priv_arr[mysql_result($result,0,"Create_priv")]; echo "
Drop: "; echo $Drop_priv_arr[mysql_result($result,0,"Drop_priv")]; echo "
Grant: "; echo $Grant_priv_arr[mysql_result($result,0,"Grant_priv")]; echo "
References: "; echo $References_priv_arr[mysql_result($result,0,"References_priv")]; echo "
Index: "; echo $Index_priv_arr[mysql_result($result,0,"Index_priv")]; echo "
Alter: "; echo $Alter_priv_arr[mysql_result($result,0,"Alter_priv")]; echo "
Edit"; echo " Delete"; endif; mysql_free_result($result); endif /* Show detail */ ?> Edit Record"; else: echo "

New Record

"; $Host=""; $Db=""; $User=""; $Select_priv=""; $Insert_priv=""; $Update_priv=""; $Delete_priv=""; $Create_priv=""; $Drop_priv=""; $Grant_priv=""; $References_priv=""; $Index_priv=""; $Alter_priv=""; endif; if ($action == "new"): echo "
"; else: echo ""; endif; echo "
"; //******************************** HOST (stand) echo ""; //******************************** DB (stand) echo ""; //******************************** USER (stand) echo "
Host: "; echo "
Db: "; echo "
User: "; echo "
"; //******************************** SELECT_PRIV (plist) echo ""; //******************************** INSERT_PRIV (plist) echo ""; //******************************** UPDATE_PRIV (plist) echo ""; //******************************** DELETE_PRIV (plist) echo ""; //******************************** CREATE_PRIV (plist) echo ""; //******************************** DROP_PRIV (plist) echo ""; //******************************** GRANT_PRIV (plist) echo ""; //******************************** REFERENCES_PRIV (plist) echo ""; //******************************** INDEX_PRIV (plist) echo ""; //******************************** ALTER_PRIV (plist) echo ""; echo "
Select: "; echo "Insert: "; echo "Update: "; echo "Delete: "; echo "
Create: "; echo "Drop: "; echo "Grant: "; echo "References: "; echo "
Index: "; echo "Alter: "; echo "
"; echo " "; if ($action == "new"): echo ""; endif; echo "
"; mysql_free_result($result); endif; /* New/edit */ ?> "; echo "User:"; echo "
"; echo ""; echo ""; echo ""; echo ""; echo ""; echo "
"; echo ""; echo ""; endif; ?> pccsmysqladm/mysqldb_displayqry.php100644 0 143 10302 7172400714 16677 0ustar rootnobody Run SQL Query on Table: [ $table ] from database: [ $dbname ]

"; endif ; if($action == "read_query"): print "
Run SQL Query on Table: [ $table ] from database: [ $dbname ]

"; endif ; if($action == "get_results"): print "

"; print ""; $qry = "select * from $table"; $qry = addslashes($qry); $result = mysqlquery("$dbname",$qry); if (!$result) { // mysql_die(); } else { $num_rows = @mysql_num_rows($result); if ($num_rows < 1) { if (isset($zero_rows)) { echo $zero_rows; } else { echo "Empty Result Set"; } } else { if (!isset($pos)) { $pos = 0; } $pos_next = $pos + $max_rows; $pos_prev = $pos - $max_rows; if (@mysql_num_rows($dt_result)>1) { echo "Showing Records $pos - $pos_next (".mysql_num_rows($result)." Total )"; } while ($field = mysql_fetch_field($result)) { if (@mysql_num_rows($result)>1) { $sql_sort=urlencode("select * from $table order by $field->name $order"); echo "\n"; } else { echo ""; } $table = $field->table; } echo "\n"; $foo = 0; while ($row = mysql_fetch_row($result)) { if ($foo < $pos_next && $foo >= $pos) { $primary_key = ""; $bgcolor = $bgcolor_one; $foo % 2 ? 0: $bgcolor = $bgcolor_two; echo ""; for ($i=0; $inumeric == 1) { echo "\n"; } else { echo "\n"; } if ($primary->primary_key > 0) { $primary_key .= " $primary->name = '$row[$i]' AND"; } } if ($primary_key) { $primary_key = urlencode(ereg_replace("AND$", "", $primary_key)); $query = "&db=$db&table=$table"; } echo "\n"; } $foo++; } echo "
$field->name$field->name
 $row[$i]  ".htmlspecialchars($row[$i])." 
\n"; // display_table($result); //echo $qry; // echo "
$where1 and $where2"; } } endif; pccsmysqladm/mysqldb_export.php100644 0 143 2725 7172400714 16011 0ustar rootnobody \n"; echo "$qry"; } } export_data($tablename); $dir = "/tmp"; $export_file = $dir . "/" . $tablename . "." . $_datehashed . "." .sql; $_gzip = "/bin/tar"; $exportdir = "./exports/"; $gz_dump = "$_gzip -czf $exportdir$tablename$_datehashed.tar.gz $export_file"; exec ("$gz_dump"); print " Current Directory : $exportdir
The Export Created: $exportdir$tablename$_datehashed.tar.gz"; print "\n"; print ""; print "\n\n"; print ""; chdir("./exports"); $getDir = opendir("."); while($entryname = readdir($getDir)) { print ""; print "\n"; } closedir($getDir); print "
File NameFile Size
$entryname"; print(filesize($entryname)); print "
"; endif; ?> pccsmysqladm/mysqldb_gr_perms.php100644 0 143 10647 7172400714 16330 0ustar rootnobody"; $cur_date = date("l M d, Y H:i:s"); print " $cur_date"; print "

"; print "

Choose Database to grant/revoke permissions
"; print ""; print "
"; function displayDatabases() { global $across, $start_script; $content .=""; $result_1 = mysql_query("SHOW DATABASES"); while ($info = mysql_fetch_array($result_1)) { $a++; $content .="\n"; if ($a == $across) {$content .=""; $a=0;} } $content .= "
$info[Database] "; $content .= "$info[User]
"; echo $content; } displayDatabases(); print "
"; print "
"; print ""; print " You can also Modify Permissions via one of the mysql.* tables"; print ""; print "

"; print "[ mysql.host "; print "| mysql.user "; print "| mysql.db ]"; print "

"; print "

"; print "<<<back..."; print "

"; endif; ?> "; $res = mysql_list_tables("$db") or die("Query Failed"); while ($row = mysql_fetch_row($res)) print "[ Grant/Revoke | $row[0] ]
\n"; print "
Back"; endif; if($action =="perms"): print ""; print "Example
"; print ""; print "GRANT SELECT on $db.$tbl TO cthorn@'%'"; PRINT "
"; print "REVOKE SELECT on $db.$tbl FROM cthorn@'%'"; print ""; print ""; print "

"; print ""; print "  "; print ""; print " ON $db.$tbl "; print "  "; print ""; print " "; print "
"; print ""; print "
"; endif; if($action =="setperms"): $qry = "$opts1 $perm ON $on $opts2 $dbuser "; $result = mysqlquery("mysql",$qry); if (!empty($result)) { // log_this($qry,"dblog.txt"); } else { echo mysql_error()."
\n"; } endif; footer(); ?> pccsmysqladm/mysqldb_host.php100644 0 143 46433 7172400714 15471 0ustar rootnobody MySQL Host Privilege Table "; require('login.php'); require('incs/dbconnect.php'); require('incs/global.vars.php'); if (empty($action)) $action="browselist"; $Select_priv_arr = array( "N" => "N", "Y" => "Y" ); $Insert_priv_arr = array( "N" => "N", "Y" => "Y" ); $Update_priv_arr = array( "N" => "N", "Y" => "Y" ); $Delete_priv_arr = array( "N" => "N", "Y" => "Y" ); $Create_priv_arr = array( "N" => "N", "Y" => "Y" ); $Drop_priv_arr = array( "N" => "N", "Y" => "Y" ); $Grant_priv_arr = array( "N" => "N", "Y" => "Y" ); $References_priv_arr = array( "N" => "N", "Y" => "Y" ); $Index_priv_arr = array( "N" => "N", "Y" => "Y" ); $Alter_priv_arr = array( "N" => "N", "Y" => "Y" ); $months["01"] = "January"; $months["02"] = "February"; $months["03"] = "March"; $months["04"] = "April"; $months["05"] = "May"; $months["06"] = "June"; $months["07"] = "July"; $months["08"] = "August"; $months["09"] = "September"; $months["10"] = "October"; $months["11"] = "November"; $months["12"] = "December"; ?> \n"; } ?> "; $fields = ""; $values = ""; $Host=chop($Host); if ($Host == "") { $ok = 0; echo "Host - must be specified !
"; } else { $fields .= ",Host"; $values.=",'$Host'"; } $Db=chop($Db); if ($Db == "") { $ok = 0; echo "Db - must be specified !
"; } else { $fields .= ",Db"; $values.=",'$Db'"; } $Select_priv=chop($Select_priv); if ($Select_priv == "") { $ok = 0; echo "Select - must be specified !
"; } else { $fields .= ",Select_priv"; $values.=",'$Select_priv'"; } $Insert_priv=chop($Insert_priv); if ($Insert_priv == "") { $ok = 0; echo "Insert - must be specified !
"; } else { $fields .= ",Insert_priv"; $values.=",'$Insert_priv'"; } $Update_priv=chop($Update_priv); if ($Update_priv == "") { $ok = 0; echo "Update - must be specified !
"; } else { $fields .= ",Update_priv"; $values.=",'$Update_priv'"; } $Delete_priv=chop($Delete_priv); if ($Delete_priv == "") { $ok = 0; echo "Delete - must be specified !
"; } else { $fields .= ",Delete_priv"; $values.=",'$Delete_priv'"; } $Create_priv=chop($Create_priv); if ($Create_priv == "") { $ok = 0; echo "Create - must be specified !
"; } else { $fields .= ",Create_priv"; $values.=",'$Create_priv'"; } $Drop_priv=chop($Drop_priv); if ($Drop_priv == "") { $ok = 0; echo "Drop - must be specified !
"; } else { $fields .= ",Drop_priv"; $values.=",'$Drop_priv'"; } $Grant_priv=chop($Grant_priv); if ($Grant_priv == "") { $ok = 0; echo "Grant - must be specified !
"; } else { $fields .= ",Grant_priv"; $values.=",'$Grant_priv'"; } $References_priv=chop($References_priv); if ($References_priv == "") { $ok = 0; echo "References - must be specified !
"; } else { $fields .= ",References_priv"; $values.=",'$References_priv'"; } $Index_priv=chop($Index_priv); if ($Index_priv == "") { $ok = 0; echo "Index - must be specified !
"; } else { $fields .= ",Index_priv"; $values.=",'$Index_priv'"; } $Alter_priv=chop($Alter_priv); if ($Alter_priv == "") { $ok = 0; echo "Alter - must be specified !
"; } else { $fields .= ",Alter_priv"; $values.=",'$Alter_priv'"; } echo ""; if (!$ok): echo "Error!"; echo "
Try again"; exit; endif; ?> \n"; } callback_js("action=browselist&start=0"); } else { echo mysql_error()."
\n"; } ?> "; $fields = ""; $Host=chop($Host); if ($Host == "") { $ok = 0; echo "Host - must be specified !
"; } $fields.=','; $fields.="Host="; $fields.="'$Host'"; $Db=chop($Db); if ($Db == "") { $ok = 0; echo "Db - must be specified !
"; } $fields.=','; $fields.="Db="; $fields.="'$Db'"; $Select_priv=chop($Select_priv); if ($Select_priv == "") { $ok = 0; echo "Select - must be specified !
"; } $fields.=','; $fields.="Select_priv="; $fields.="'$Select_priv'"; $Insert_priv=chop($Insert_priv); if ($Insert_priv == "") { $ok = 0; echo "Insert - must be specified !
"; } $fields.=','; $fields.="Insert_priv="; $fields.="'$Insert_priv'"; $Update_priv=chop($Update_priv); if ($Update_priv == "") { $ok = 0; echo "Update - must be specified !
"; } $fields.=','; $fields.="Update_priv="; $fields.="'$Update_priv'"; $Delete_priv=chop($Delete_priv); if ($Delete_priv == "") { $ok = 0; echo "Delete - must be specified !
"; } $fields.=','; $fields.="Delete_priv="; $fields.="'$Delete_priv'"; $Create_priv=chop($Create_priv); if ($Create_priv == "") { $ok = 0; echo "Create - must be specified !
"; } $fields.=','; $fields.="Create_priv="; $fields.="'$Create_priv'"; $Drop_priv=chop($Drop_priv); if ($Drop_priv == "") { $ok = 0; echo "Drop - must be specified !
"; } $fields.=','; $fields.="Drop_priv="; $fields.="'$Drop_priv'"; $Grant_priv=chop($Grant_priv); if ($Grant_priv == "") { $ok = 0; echo "Grant - must be specified !
"; } $fields.=','; $fields.="Grant_priv="; $fields.="'$Grant_priv'"; $References_priv=chop($References_priv); if ($References_priv == "") { $ok = 0; echo "References - must be specified !
"; } $fields.=','; $fields.="References_priv="; $fields.="'$References_priv'"; $Index_priv=chop($Index_priv); if ($Index_priv == "") { $ok = 0; echo "Index - must be specified !
"; } $fields.=','; $fields.="Index_priv="; $fields.="'$Index_priv'"; $Alter_priv=chop($Alter_priv); if ($Alter_priv == "") { $ok = 0; echo "Alter - must be specified !
"; } $fields.=','; $fields.="Alter_priv="; $fields.="'$Alter_priv'"; if (!$ok): echo "Error!"; echo "
Try again"; exit; endif; $fields = substr($fields,1,strlen($fields)-1); $result = mysqlquery("mysql","UPDATE host SET $fields WHERE Host='$par'"); if (!empty($result)) { $result = mysqlquery("mysql","FLUSH PRIVILEGES"); if (!empty($result)) { } else { echo mysql_error()."
\n"; } callback_js("action=browselist&start=0"); } else { echo mysql_error()."
\n"; } ?>
[ Grant/Revoke | New Host | List all | Search ]
0)) { echo "<<<Previous $limit   "; } if (isset($start) && ((($start+$limit) < $found))) { echo ">>>Next ",min($found-$start-$limit,$limit),""; } endif; ?>

Are you sure you want to delete this record?

Yes   No Search for '$searchvalue ' in '$whichfield ' returned $found hits"; $num = mysql_numrows($result); $c1 = "#EEEEEE"; $c2 = "#CCCCCC"; ?>
"; echo ""; echo ""; echo ""; echo ""; endfor; echo "
HostDb
",mysql_result($result,$i,"Host"),""; $val = mysql_result($result, $i, "Host"); print_sp($val); echo ""; $val = mysql_result($result, $i, "Db"); print_sp($val); echo "
"; mysql_free_result($result); endif /* Search */ ?> Hosts that are allowed to Connect to this server"; $result = mysqlquery("mysql","SELECT * FROM host ORDER BY Host LIMIT $start,$limit"); $num = mysql_numrows($result); $c1 = "#EEEEEE"; $c2 = "#CCCCCC"; ?>
"; echo ""; echo ""; echo ""; echo ""; endfor; echo "
DetailsHostDb
**"; $val = mysql_result($result, $i, "Host"); print_sp($val); echo ""; $val = mysql_result($result, $i, "Db"); print_sp($val); echo "
"; mysql_free_result($result); endif /* Show all */ ?> ID: ",mysql_result($result,0,"Host"),""; ?> "; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; ?>
Host: "; print_html(mysql_result($result,0,"Host")); echo "
Db: "; print_html(mysql_result($result,0,"Db")); echo "
Select: "; echo $Select_priv_arr[mysql_result($result,0,"Select_priv")]; echo "
Insert: "; echo $Insert_priv_arr[mysql_result($result,0,"Insert_priv")]; echo "
Update: "; echo $Update_priv_arr[mysql_result($result,0,"Update_priv")]; echo "
Delete: "; echo $Delete_priv_arr[mysql_result($result,0,"Delete_priv")]; echo "
Create: "; echo $Create_priv_arr[mysql_result($result,0,"Create_priv")]; echo "
Drop: "; echo $Drop_priv_arr[mysql_result($result,0,"Drop_priv")]; echo "
Grant: "; echo $Grant_priv_arr[mysql_result($result,0,"Grant_priv")]; echo "
References: "; echo $References_priv_arr[mysql_result($result,0,"References_priv")]; echo "
Index: "; echo $Index_priv_arr[mysql_result($result,0,"Index_priv")]; echo "
Alter: "; echo $Alter_priv_arr[mysql_result($result,0,"Alter_priv")]; echo "
Edit"; echo " Delete"; endif; mysql_free_result($result); endif /* Show detail */ ?> Edit Host"; else: echo "

ADD new host connection permissions

"; $Host=""; $Db=""; $Select_priv=""; $Insert_priv=""; $Update_priv=""; $Delete_priv=""; $Create_priv=""; $Drop_priv=""; $Grant_priv=""; $References_priv=""; $Index_priv=""; $Alter_priv=""; endif; if ($action == "new"): echo "
"; else: echo ""; endif; echo "
"; //******************************** HOST (stand) echo ""; //******************************** DB (stand) echo "
Host: "; echo "
Db: "; echo "
"; //******************************** SELECT_PRIV (plist) echo ""; //******************************** INSERT_PRIV (plist) echo ""; //******************************** UPDATE_PRIV (plist) echo ""; //******************************** DELETE_PRIV (plist) echo ""; //******************************** CREATE_PRIV (plist) echo ""; //******************************** DROP_PRIV (plist) echo ""; //******************************** GRANT_PRIV (plist) echo ""; //******************************** REFERENCES_PRIV (plist) echo ""; //******************************** INDEX_PRIV (plist) echo ""; //******************************** ALTER_PRIV (plist) echo ""; echo "
Select: "; echo "Insert: "; echo "Update: "; echo "Delete: "; echo "
Create: "; echo "Drop: "; echo "Grant: "; echo "References: "; echo "
Index: "; echo "Alter: "; echo "
"; echo " "; if ($action == "new"): echo ""; endif; echo "
"; mysql_free_result($result); endif; /* New/edit */ ?> "; echo "Host:"; echo "
"; echo ""; echo ""; echo ""; echo ""; echo ""; echo "
"; echo ""; echo "Db:"; echo "
"; echo ""; echo ""; echo ""; echo ""; echo ""; echo "
"; echo ""; echo ""; endif; ?> pccsmysqladm/mysqldb_info.php100644 0 143 17346 7172400714 15450 0ustar rootnobody "; if ($argv[0] == ""): // Displays a blank page // We always want to pass a action to this script // $menu = "MYSQL DATABASE TABLE INFO"; else: $menu = "MYSQL DATABASE TABLE INFO"; endif; print "

$_title : $menu

"; print "

"; print "
"; print "

"; $qry = "SHOW PROCESSLIST"; $res = mysql($db_name,$qry); $ps = mysql_numrows($res); print "

"; print "

"; print "[ "; print "MAIN "; print "| READ MySQL DOCS "; print " ]"; print "

"; print "

"; ?>

> ">
Tables View Fields View Data Optimize PHP Framework Records
" CLASS=noul>View Fields " CLASS=noul>View Data " CLASS=noul>Optimize " CLASS=noul>PHP Framework
"; print "BACK"; ?>

>
Field Type Null Key Default Extra

"; print "BACK"; ?>

Rows Affected $affected_rows"; print "
Table List"; // echo ""; } else { echo mysql_error()."
\n"; } endif; if($action =="tbldetails"): // field descriptions for table // URL: action=tbldetails&dbname=databasename&tblname=tablename // $f = mysql_list_fields($dbname,$tblname); print "
"; print "Field Descriptions for Table :   ".$tblname; print ""; print ""; for($fld=0; $fld"; } print "
NAMEFLAGSLENGHTTYPE
" .$fields[$fld]["name"]."".$fields[$fld]["type"]."".$fields[$fld]["len"]."".$fields[$fld]["flags"]."
"; print "
"; endif; footer(); ?> pccsmysqladm/mysqldb_newuser.php100644 0 143 12532 7172400714 16175 0ustar rootnobody"; print "

$_title : $str_useradministration

"; print "

"; print "
"; print "

"; $qry = "SHOW PROCESSLIST"; $res = mysql($db_name,$qry); $ps = mysql_numrows($res); print "

"; print "

"; print "[ "; print "$str_mainlnk "; print "| $str_changeuserpw "; print "| $str_grant_revoke "; print "| $str_readmysqldoc "; print " ]"; print "

"; print "

"; $admin = "ALL PRIVILIGIES"; $adv_user ="SELECT,INSERT,UPDATE,DELETE"; $basic_user = "USAGE"; $operator ="SAME AS ADVANCE w/FILE,INDEX,DROP,RELOAD"; if($argv[0] == ""): print "

"; print ""; print ""; print ""; print ""; print ""; print ""; print ""; print ""; // print ""; print ""; print ""; print ""; print ""; print "
$str_username:
$str_password:
$str_usercanconnectfrom "; print " LOCALHOST: "; print " ANYWHERE: "; print "
"; print "$str_usertype:   "; print "
"; print "$str_dbase:  "; print ""; print "
"; print "
"; print ""; endif; if($action == "adduser"): if($type == "_admin"): $qry = "GRANT ALL on $dbname.* TO $user@$hostname IDENTIFIED by \"$passwd\" WITH GRANT OPTION"; endif; if($type == "_adv_user"): $qry = "GRANT SELECT,INSERT,UPDATE,DELETE on $dbname.* TO $user@$hostname IDENTIFIED by \"$passwd\""; endif; if($type == "_basic_user"): // Changing to usage: giving only connect to server $qry ="GRANT USAGE on $dbname.* to $user@$hostname IDENTIFIED by \"$passwd\""; endif; if($type == "_operator"): $qry ="GRANT SELECT,INSERT,UPDATE,DELETE,FILE,INDEX,DROP,RELOAD on $dbname.* TO $user@$hostname IDENTIFIED by \"$passwd\" "; endif; $result = mysqlquery("mysql","$qry"); if (!empty($result)) { echo "An $type Account Was Created for $user "; echo "
"; echo "$str_thisusercanconnfrom $hostname "; echo "$str_createnewacct:"; echo " $str_yes "; echo " $str_no "; } else { echo mysql_error()."
\n"; echo "$qry"; } endif; footer(); ////////////////////////////////////////////////////////////////////////////////////////// ?> pccsmysqladm/mysqldb_qrytool.php100644 0 143 16376 7172400714 16230 0ustar rootnobody"; $result_1 = mysql_query("SHOW DATABASES"); while ($info = mysql_fetch_array($result_1)) { $a++; $content .="$info[Database] "; $content .= "$info[User]\n"; if ($a == $across) {$content .=""; $a=0;} } $content .= ""; echo $content; } if($argv[0] == ""): heading(); print " "; $cur_date = date("l M d, Y H:i:s"); print " $cur_date"; print "

"; print "

Click on the Database you wish to run query against
"; print ""; print "
"; displayDatabases(); print "

"; print "

"; print "

"; print "<<<back ..."; endif; if($action == "listtbls"): print "

"; print "
\n"; print "Select a table from " .$dbname. " to run a query from...

\n"; print "\n"; print "\n"; print "\n"; /* print "\n"; */ print "\n"; print "\n"; print "

"; print "OR use the "; print "Free Form Query
\n"; print "e.g. SELECT user.User, user.Password FROM tablename WHERE lastname = 'value' AND userid = 'value'"; print "

back to databases\n"; // print "

\n"; endif; if($action == "freeform"): $today = Date("mdy"); print "

Enter Query against $dbname



HTML File Display

"; endif; if($action == "freeform_res"): include('incs/mysqldb_functions.php'); if($mode == "display") { show_results($qry); print "<<<back ..." ; } elseif ($mode == "htmlfile") { echo "Creating HTML File"; write_htmlfile($qry,$filename); print "\n
HTML File created as a result of your query: $filename"; print "
You mayEdit the file"; print "
Goto The WebAdmin FileManager >>> <<<back ... "; } endif; if($action == "searchform"): print "
"; print "
SQL Query Tool
SELECT
WHERE "; print "
AND
OR		"; print ""; print "

ORDER BY: "; print "
HTML File "; $today = Date("mdy"); print " Display
$str_querytool

<<<back ...

"; endif; if($action == "dbsearch"): print "

"; $qry = "SELECT $_sel FROM $tblname WHERE ($where1 $equate1 '" . $searchvalue1 . "' $andor $where2 $equate2 '" . $searchvalue2 . "' ) ORDER BY $order_by "; // echo "$qry"; /////////////////////////////////////////////////////////////////////////////// // print ""; include('incs/mysqldb_functions.php'); if($mode == "htmlfile"): write_htmlfile($qry,$filename); print "\n
HTML File created as a result of your query: $filename"; print "
You mayEdit the file"; print "
Goto The WebAdmin FileManager >>>"; print "
Goto DB Admin >>>"; elseif($mode == "showresults"): show_results($qry); endif; endif; footer(); ?> pccsmysqladm/mysqldb_setpass.php100644 0 143 5263 7172400713 16151 0ustar rootnobody"; print "

$_title : USER ADMINISTRATION

"; print "

"; print "
"; print "

"; if($action == "setpasswd"): $p1 = "$db_passwd1"; $p2 = "$db_passwd2"; $pw = 6; if(strcmp($p1, $p2) == 0 ) { // print "Password Match"; print "

"; $db_passwd = $p2; } else { print "Passwords DONOT Match"; } $qry = "SET PASSWORD FOR $dbuser = PASSWORD(\"$db_passwd\")"; // echo "

$qry"; $result = mysqlquery("mysql",$qry); if (!empty($result)) { // Logging this puts the users password in the logfile.. // VERY unsecure so we need to strip it out... $this_action = eregi_replace("\= PASSWORD\(\"$db_passwd\"\)","",$qry); log_this($this_action,"dblog.txt"); print "

"; print "Password Has Been Changed
"; print " Change"; print "Another Password or got to Main

"; print "

"; } else { echo mysql_error()."
\n"; // echo "$qry"; } endif; ?> pccsmysqladm/mysqldb_user.php100644 0 143 43327 7172400714 15471 0ustar rootnobodyMySQL User Privilege Table "; require('login.php'); require('incs/dbconnect.php'); require('incs/global.vars.php'); if (empty($action)) $action="browselist"; $Select_priv_arr = array( "N" => "N", "Y" => "Y" ); $Insert_priv_arr = array( "N" => "N", "Y" => "Y" ); $Update_priv_arr = array( "N" => "N", "Y" => "Y" ); $Delete_priv_arr = array( "N" => "N", "Y" => "Y" ); $Create_priv_arr = array( "N" => "N", "Y" => "Y" ); $Drop_priv_arr = array( "N" => "N", "Y" => "Y" ); $Reload_priv_arr = array( "N" => "N", "Y" => "Y" ); $Shutdown_priv_arr = array( "N" => "N", "Y" => "Y" ); $Process_priv_arr = array( "N" => "N", "Y" => "Y" ); $File_priv_arr = array( "N" => "N", "Y" => "Y" ); $Grant_priv_arr = array( "N" => "N", "Y" => "Y" ); $References_priv_arr = array( "N" => "N", "Y" => "Y" ); $months["01"] = "January"; $months["02"] = "February"; $months["03"] = "March"; $months["04"] = "April"; $months["05"] = "May"; $months["06"] = "Juny"; $months["07"] = "July"; $months["08"] = "August"; $months["09"] = "September"; $months["10"] = "October"; $months["11"] = "November"; $months["12"] = "December"; ?> "; $fields = ""; $Host=chop($Host); if ($Host == "") { $ok = 0; echo "Host - must be specified !
"; } $fields.=','; $fields.="Host="; $fields.="'$Host'"; $User=chop($User); if ($User == "") { $ok = 0; echo "User - must be specified !
"; } $fields.=','; $fields.="User="; $fields.="'$User'"; $Password=chop($Password); if ($Password == "") { $ok = 0; echo "Password - must be specified !
"; } $fields.=','; $fields.="Password="; $fields.="'$Password'"; $Select_priv=chop($Select_priv); if ($Select_priv == "") { $ok = 0; echo "Select - must be specified !
"; } $fields.=','; $fields.="Select_priv="; $fields.="'$Select_priv'"; $Insert_priv=chop($Insert_priv); if ($Insert_priv == "") { $ok = 0; echo "Insert - must be specified !
"; } $fields.=','; $fields.="Insert_priv="; $fields.="'$Insert_priv'"; $Update_priv=chop($Update_priv); if ($Update_priv == "") { $ok = 0; echo "Update - must be specified !
"; } $fields.=','; $fields.="Update_priv="; $fields.="'$Update_priv'"; $Delete_priv=chop($Delete_priv); if ($Delete_priv == "") { $ok = 0; echo "Delete - must be specified !
"; } $fields.=','; $fields.="Delete_priv="; $fields.="'$Delete_priv'"; $Create_priv=chop($Create_priv); if ($Create_priv == "") { $ok = 0; echo "Create - must be specified !
"; } $fields.=','; $fields.="Create_priv="; $fields.="'$Create_priv'"; $Drop_priv=chop($Drop_priv); if ($Drop_priv == "") { $ok = 0; echo "Drop - must be specified !
"; } $fields.=','; $fields.="Drop_priv="; $fields.="'$Drop_priv'"; $Reload_priv=chop($Reload_priv); if ($Reload_priv == "") { $ok = 0; echo "Reload - must be specified !
"; } $fields.=','; $fields.="Reload_priv="; $fields.="'$Reload_priv'"; $Shutdown_priv=chop($Shutdown_priv); if ($Shutdown_priv == "") { $ok = 0; echo "Shutdown - must be specified !
"; } $fields.=','; $fields.="Shutdown_priv="; $fields.="'$Shutdown_priv'"; $Process_priv=chop($Process_priv); if ($Process_priv == "") { $ok = 0; echo "Process - must be specified !
"; } $fields.=','; $fields.="Process_priv="; $fields.="'$Process_priv'"; $File_priv=chop($File_priv); if ($File_priv == "") { $ok = 0; echo "File - must be specified !
"; } $fields.=','; $fields.="File_priv="; $fields.="'$File_priv'"; $Grant_priv=chop($Grant_priv); if ($Grant_priv == "") { $ok = 0; echo "Grant - must be specified !
"; } $fields.=','; $fields.="Grant_priv="; $fields.="'$Grant_priv'"; $References_priv=chop($References_priv); if ($References_priv == "") { $ok = 0; echo "References - must be specified !
"; } $fields.=','; $fields.="References_priv="; $fields.="'$References_priv'"; if (!$ok): echo "Error!"; echo "
Try again"; exit; endif; $fields = substr($fields,1,strlen($fields)-1); $result = mysqlquery("mysql","UPDATE user SET $fields WHERE User='$User' AND Host='$par'"); if (!empty($result)) { /* encrypt password */ $res = mysqlquery("mysql","UPDATE user SET Password = password('$Password') WHERE User='$User' AND Host='$par'"); /* refresh the privilege table */ $result = mysqlquery("mysql","FLUSH PRIVILEGES"); if (!empty($result)) { } else { echo mysql_error()."
\n"; } callback_meta("action=browselist&start=0"); } else { echo mysql_error()."
\n"; } ?>
[ Grant/Revoke | List all | Search ]
0)) { echo "<<<Previous $limit   "; } if (isset($start) && ((($start+$limit) < $found))) { echo ">>>Next ",min($found-$start-$limit,$limit),""; } endif; ?> Search for '$searchvalue ' in '$whichfield ' returned $found hits"; $num = mysql_numrows($result); $c1 = "#EEEEEE"; $c2 = "#CCCCCC"; ?>

"; echo ""; echo ""; echo ""; endfor; echo "
HostUser
",mysql_result($result,$i,"Host"),""; $val = mysql_result($result, $i, "User"); print_sp($val); echo "
"; mysql_free_result($result); endif /* Search */ ?> Host+User that are ALLOWED to connect this server"; $result = mysqlquery("mysql","SELECT * FROM user ORDER BY Host LIMIT $start,$limit"); $num = mysql_numrows($result); $c1 = "#EEEEEE"; $c2 = "#CCCCCC"; ?>
"; echo ""; echo ""; echo ""; endfor; echo "
HostUser
",mysql_result($result,$i,"Host"),""; $val = mysql_result($result, $i, "User"); print_sp($val); echo "
"; echo "
"; mysql_free_result($result); endif /* Show all */ ?> ID: ",mysql_result($result,0,"Host"),""; ?> "; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; ?>
Host: "; print_html(mysql_result($result,0,"Host")); echo "
User: "; print_html(mysql_result($result,0,"User")); echo "
Password: "; print_html(mysql_result($result,0,"Password")); echo "
Select: "; echo $Select_priv_arr[mysql_result($result,0,"Select_priv")]; echo "
Insert: "; echo $Insert_priv_arr[mysql_result($result,0,"Insert_priv")]; echo "
Update: "; echo $Update_priv_arr[mysql_result($result,0,"Update_priv")]; echo "
Delete: "; echo $Delete_priv_arr[mysql_result($result,0,"Delete_priv")]; echo "
Create: "; echo $Create_priv_arr[mysql_result($result,0,"Create_priv")]; echo "
Drop: "; echo $Drop_priv_arr[mysql_result($result,0,"Drop_priv")]; echo "
Reload: "; echo $Reload_priv_arr[mysql_result($result,0,"Reload_priv")]; echo "
Shutdown: "; echo $Shutdown_priv_arr[mysql_result($result,0,"Shutdown_priv")]; echo "
Process: "; echo $Process_priv_arr[mysql_result($result,0,"Process_priv")]; echo "
File: "; echo $File_priv_arr[mysql_result($result,0,"File_priv")]; echo "
Grant: "; echo $Grant_priv_arr[mysql_result($result,0,"Grant_priv")]; echo "
References: "; echo $References_priv_arr[mysql_result($result,0,"References_priv")]; echo "
Edit"; endif; mysql_free_result($result); endif /* Show detail */ ?> Edit User Permission"; else: echo "

Create New User

"; $Host=""; $User=""; $Password=""; $Select_priv=""; $Insert_priv=""; $Update_priv=""; $Delete_priv=""; $Create_priv=""; $Drop_priv=""; $Reload_priv=""; $Shutdown_priv=""; $Process_priv=""; $File_priv=""; $Grant_priv=""; $References_priv=""; endif; if ($action == "new"): echo "
"; else: echo ""; endif; echo "
"; //******************************** HOST (stand) echo ""; //******************************** USER (stand) echo ""; //******************************** PASSWORD (stand) echo "
Host: "; echo "
User: "; echo "
Password: "; echo "
"; //******************************** SELECT_PRIV (plist) echo ""; //******************************** INSERT_PRIV (plist) echo ""; //******************************** UPDATE_PRIV (plist) echo ""; //******************************** DELETE_PRIV (plist) echo ""; //******************************** CREATE_PRIV (plist) echo ""; //******************************** DROP_PRIV (plist) echo ""; //******************************** RELOAD_PRIV (plist) echo ""; //******************************** SHUTDOWN_PRIV (plist) echo ""; //******************************** PROCESS_PRIV (plist) echo ""; //******************************** FILE_PRIV (plist) echo ""; //******************************** GRANT_PRIV (plist) echo ""; //******************************** REFERENCES_PRIV (plist) echo ""; echo "
Select: "; echo "Insert: "; echo "Update: "; echo "Delete: "; echo "
Create: "; echo "Drop: "; echo "Reload: "; echo "Shutdown: "; echo "
Process: "; echo "File: "; echo "Grant: "; echo "References: "; echo "
"; echo " "; if ($action == "new"): echo ""; endif; echo "
"; mysql_free_result($result); endif; /* New/edit */ ?> "; echo "User:"; echo "
"; echo ""; echo ""; echo ""; echo ""; echo ""; echo "
"; echo ""; echo ""; endif; ?> pccsmysqladm/robots.txt100644 0 143 32 7172400714 14222 0ustar rootnobodyUser-agent: * Disallow: / pccsmysqladm/rptfiles/ 40775 0 143 0 7172400714 13753 5ustar rootnobodypccsmysqladm/rptfiles/README100666 0 143 112 7172400714 14704 0ustar rootnobodyThis is the directory where I plan to dump Reports created by the system. pccsmysqladm/sqledit.php100644 0 143 2112 7172400714 14370 0ustar rootnobody $filename does not exist!"; echo "Return"; exit; } echo "

Edit of $file

"; echo "
"; echo ""; echo ""; echo "
"; echo "Cancel
"; echo "Filename: "; echo ""; echo ""; endif; //*Edit ?> pccsmysqladm/system_check.php100644 0 143 10577 7172400714 15442 0ustar rootnobody"); } else { // print $checkfile[$i] . " "; // print("File is not writable
"); } if($dirwriteerror==1) { die("

Please check your Install There where ERRORS

Directory needs to be writeable via the web... "); } else { // echo "No errors"; } } // Using this file as a indicator that the app is installed // correctly // Written to the logs directory $installedfile_name = ".INSTALLED"; /////////////////////////////////////////////////////////////////////////// // Check to make sure all functions and variables are available // // to add a file just $checkfile[] = "path to file"; $checkfile[] = "incs/dbconnect.php"; $checkfile[] = "incs/global.vars.php"; $checkfile[] = "incs/lang_eng.php"; $checkfile[] = "incs/logging_function.php"; $checkfile[] = "incs/mysqldb_functions.php"; $checkfile[] = "incs/upload_function.php"; $gethowmanyFiles = count($checkfile); for($i=0; $i<$gethowmanyFiles; $i++) { if(!file_exists($checkfile[$i])) { $missingerror=1; print $checkfile[$i] . " "; print("ERROR: File(s) are missing from the incs/ directory
"); } else { // No Errors } if($missingerror==1) { die("

Please check your Install There where ERRORS

There are core files missing from your installation. "); } else { // echo "No errors Good... "; if(!file_exists("logs/$installedfile_name")) { exec ("touch logs/$installedfile_name"); } else { $logfile = fopen("logs/$installedfile_name","a"); fputs($logfile,"ALL Core Files Exist\n"); fclose($logfile); } } } for($i=0; $i<$gethowmanyFiles; $i++) { if(is_writeable($checkfile[$i])) { $writeerror=1; print $checkfile[$i] . " "; print("File is writeable and shouldn't be
"); } else { // print $checkfile[$i] . " "; // print("File is not writable
"); } if($writeerror==1) { die("

Please check your Install There where ERRORS

There are core files that are writeable via the web... "); } else { // echo "No errors"; } } // This file logs URL REQUEST to incs/ directory // NO Required ... // if(!file_exists('incs/index.php')) { // die("For some reason the Global Variables global.vars.php does not exist. Check your install"); echo "Send an Email and log"; } else { // echo "File is there"; } // This file logs URL REQUEST to logs/ directory // NO Required ... // if(!file_exists('logs/index.php')) { echo "Send an Email and log"; } else { // echo "File is there"; } ?> pccsmysqladm/viewlog.php100644 0 143 3441 7172400714 14405 0ustar rootnobody PCCS MySQLDatabase Administration Tool

MySQLDatabase Admin Tool SYSLOG file

Below are the actions that have been taken since you installed MySQLDatabase Admin Tool

"; } ?> pccsmysqladm/webadmin_fm.php100644 0 143 23462 7172400714 15226 0ustar rootnobody >
Clipboard Contents:



> Clipboard Contents:



> Clipboard Contents:



> Delete ?  


Current File:


MAIN : WebAdmin FileManager Current Directory: ".$pwd."
Folders:
up 

Files:
New File:
 
New Folder:
 
> File Upload:
>


> Clipboard Contents: