 |
|
|
|
|
# -----------------------------------------------------------------------------------------------------------------
# Application: mediaCat-GTK v2.0.7
# Written by: Geoff A. Virgo
# Email: gvirgo@mithril.com
# Webpage: www.mithril.com
# Additional Contributors: Julia A. Case <julie@MageNet.com> and Sandy McArthur Jr. <leknor@leknor.com>
# Release Date: October 25, 2001
# License: Lesser GNU Public License
#
# Your's to use as you will, but don't blame me if your computer bursts into flames!!:) You may re-distribute this
# application as you see fit as long as this section of the header remains intact.
# ------------------------------------------------------------------------------------------------------------------
#
# Source files in this distribution:
#
# mediaCat-Gtk.php -> the main script, everything starts here!!
# settings.ini -> contains the program's settings
# windowing_functions.inc -> contains all the functions used to create and display the windows
# event_handlers.inc -> contains all the signal handling functions
# db_abstraction.inc -> contains all the sql generating and database interface functions
# notebook_strings.inc -> contains all the string used on the various notebook pages
# gtkrc -> an RC file using to control widget colours
# mp3.mdb -> a sample MS Access database
# mp3.sql -> sql script to create and fill a sample mySQL database
#
# Other files:
#
# A Win32 exe file and the required dll's needed to run it
#
This application is a relatively basic database interface written with PHP-GTK+. It's purpose is to allow you to
search, update, delete, and insert records into a database storing your mp3, cd, and dvd collections. If you have any problems
installing, configuring, or running the program drop me a line via email and I'll see what I can do to resolve whatever
issues you're experiencing. Other than that, enjoy!!!!
N.B. For the purposes of the following instructions, "$x" is the path to the folder where you installed this program.
During the installation, the GTK Runtime Libraries where installed into you System PATH. If your computer had copies
of these dll's already installed, they have been backed up in either c:\windows\system or c:\winnt\system32 as "*.dll.bak".
When and if you unistall this program, these files will be restored to their original names. For Update/Upgrade Instructions
see below.
Installation:
1. Ensure you have a working PHP-GTK environment for your platform. Info about installing PHP-GTK itself, and the
binaries/binaries can be obtained from http://gtk.php.net.
2. Copy the files in this distribution to a location that seems good to you.
3. Run the MySQL script to create the database and tables, or create the DSN to the MS Access database if you're on
Win32.
Running medaCat-GTK:
Open a terminal (or DOS console) and execute the following command:
prompt>/path/to/php -q /path/to/mediaCat-GTK.php
Setting Up ODBC for MS Access:
- if the MS Access Database Drivers are already installed on you computer, the installer should have
already configured your connection for you.
- if the drivers weren't present, or the installation failed for some unknown reason:
1. Ensure that the MS Access Drivers are installed.
Click: "Start Button" -> "Settings" -> "Control Panel" -> "ODBC Data Sources (32 Bit)"
- you should see something like Microsoft Access Database in the User Data Sources window
- if the ODBC Data Sources (32 Bit) option is not in your Control Panel or you don't see an
MS Access option the drivers aren't installed
2. Click "Add"
3. Select "Microsoft Access Driver (*.mdb)" and click "Finish"
4. Enter a "Data Source Name" for the new resourse.
5. Click "Select" and browse to the sample database:
- database is located at "$x\runtime\dbs\gtk.mdb"
6. Click "Ok" and enter the name of the data source in the "DSN Name" field of the program's
settings window
Setting Up mySQL:
- if you do not already have mySQL installed:
1. Download the server and client from www.mysql.com
2. Run the installer.
- I'll assume you've accepted the default installation location for the rest of these instructions
- if you install to a different location, read the mySQL documentation regarding the my.cnf
configuration file and modify the following commands to match your environment
3. On WinME/2K/NT, mySQL can be installed to run as a service using the following command
from a DOS window:
c:\mysql\bin\mysqld-nt.exe --install
4. On Win95/98:
- place a shortcut to c:\mysql\bin\mysqld-nt.exe in the StartUp folder in StartMenu (usually
C:\Windows\Start Menu\StartUp)
5. Double click c:\mysql\bin\mysqld-nt.exe or restart your computer to start the mySQL server
- if you have mySQL already installed:
1. copy the file "$x\runtime\dbs\mp3.sql" to c:\mysql\bin\mp3.sql
2. open a DOS window and log in as a superuser
- just typing c:\mysql\bin\mysql.exe will suffice for new or unmodified installations
3. at the server's command prompt, type the following:
\. mp3.sql
4. The required database and tables have now been created. Unless you modifed the mp3.sql script
prior to running it, the program is now properly configured for mySQL access. If you did modify the
script, make the necesssary changes in the program's settings window.
Update/Upgrade Instructions:
If you have already installed MP3 Database-GTK v1.2.6 on your computer these are the steps to follow to
prevent unnecessary data loss.
1. The mp3.sql script in this distribution will drop and recreate the mp3 table in the mp3_gtk database. If
you have added records of your own that you do not wish to lose you have 2 options. You can edit the
mp3.sql file so that it doesn't drop and recreate the table. You can do a table dump on the existing mp3
table, run the mp3.sql script, and then restore your data from the dump.
2. The MS Access db included in this distribution contains the cd and dvd tables needed by the new and
improved version of the program. To get the new tables into your existing gtk.mdb database, open one
or the other in MS Access, select:
File -> Get External Data -> Import
and follow the wizard on home. If you open the new database, you'll probably need to delete the mp3 table
before you can import it from the old (read: existing) database.
3. Delete the old program files and folder. If you installed using the Win32 installer, run the uninstaller to
remove the programs registry entries.
4. If you have modified the programs settings you'll need to re-enter those since this update has additional settings
and the old settings file has to be over-written (sorry:)
|
|
|
Page generation:
0.015986 sec
|
|
