osHelpers - Help for your osCommerce store
 
Google Base Feed Germany
iFrame Defender v1.2
oscommerce Seo
  Seo Pack 2
  SE Friendly URLs
  Session ID Removal
  Title and Meta Tags
  Google Sitemap
Magnum Shopping Cart
  Magnum MVS 8.4 Basic
osCommerce Services
  osc / cre patch
  Data Entry
  Data Extraction
  bugs and fixing
  Site Transfer
  creloaded Transfer
  Design Special
  Hosting
osCommerce Templates
osCommerce Contributions
  Credit Modules
  Features
  Images
  InfoBoxes
  Languages
  Order Total Modules
  Other
  Payment Modules
  Reports
  Shipping Modules
  Templates/Themes
  Zones
osCommerce Articles
osCommerce Tutorials
  Installing osCommerce
  Configuring your store
  Adding categories
  Adding products
  Adding product attributes
  Configuring currency
  Adding payment modules
  Adding shipping modules
  Configuring sales tax
  Editing your home page
  Editing columns
  Editing header and footer
  Creating specials
  Managing customers
  Sending out a newsletter
  Sending out email
  Managing your banners
  Backup database
CRELoaded Tutorials
  Add Administrators
  Add Article Author
  Additional Images
  Create a New Page
  Define Mainpage
  Disable cc Encryption
  Disable Company Field
  Disable Country
  Disable Date of Birth
  Display broken images
  Easypopulate Export
  Email confirmation
  Insert Faq
  Max Package Weight
  Require Terms of Use
  Affiliate Newsletter
  Enable Cache
CB Power Affiliate
Tell A Friend
 

Tell someone you know about this product.

   OSHELPERS | OSCOMMERCE CONTRIBUTIONS | OTHER | 1358   


oscommerce PrefixforDatabaseTables
[1358]
 
 
box_bg_l.gif.
"I've put this contribution together because I've seen a few related questions, and I know that some hosting packages only give you access to a single database (like mine, for example!).

The object is simple: stick a small common prefix in front of each database table in the catalog, so that you can easily tell one catalog from another within the same database.

I've done this by:
1. Adding a variable - DB_TABLE_PREFIX - to the configure.php files
2. Inserting this new variable into all the define statements for the database tables

I have also:
a. Modified the Backup tool to include the catalog's prefix in the file name and the header within the file
b. Added a checkbox to the Backup options enabling backup of just the tables matching the current catalog prefix, or the entire database
c. Modified the New Installation routines to capture and configure the table prefix, and to apply that prefix when loading the standard demo oscommerce shop
d. Modified the Update Installation routines to cope with applying an update to a catalog that already has a prefix applied to it

I have provided descriptions of the changes required for a standard 2.2MS2 release, and for a CVS release of 2.2MS1. Whether you will find the MS1 or MS2 instructions more applicable depends entirely upon your own version of osCommerce. I've done the best I can!

(Please see the readme.txt included in the package)"

 


For more information, visit the official osCommerce contribution webpage.
box_bg_r.gif.
 

osHelpers

osHelpers