Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

bridging osc and phpbb


dturano547

Recommended Posts

Posted

Im tyring to bridge osc and phpbb.

 

I have done some mods in the past and am learning everything as I go along so I hope this does not sound to idiotic.

 

In the begining of the install it shows:

 

#-----[ RUN SQL ]---------------------------------------------------------------

#

# This creates a new configuration value for the store URL. This URL, stored

# without prefixes or trailing slashes, is used by the phpBB software to

# create links. Also adds new configuration group for forum administrator login

# information.

#

INSERT INTO `configuration` (`configuration_id`, `configuration_title`, `configuration_key`, `configuration_value`, `configuration_description`, `configuration_group_id`, `sort_order`, `last_modified`, `date_added`, `use_function`, `set_function`) VALUES (NULL, 'Store URL', 'STORE_URL', '', 'The web address of my store (without ''http://'' and without the trailing slash).', '1', '2', NOW(), NOW(), NULL, NULL);

INSERT INTO `configuration` (`configuration_id`, `configuration_title`, `configuration_key`, `configuration_value`, `configuration_description`, `configuration_group_id`, `sort_order`, `last_modified`, `date_added`, `use_function`, `set_function`) VALUES (NULL, 'Slogan', 'STORE_SLOGAN', '', 'The slogan of your store or business.', '1', '2', NOW(), NOW(), NULL, NULL);

INSERT INTO `configuration_group` (`configuration_group_id`, `configuration_group_title`, `configuration_group_description`, `sort_order`, `visible`) VALUES (NULL, 'Forums', 'phpBB configuration', '99', '1');

#

# NOTE: you will probably want to change 'Administrator',

# '[email protected]', and 'YOUR_PASSWORD' below to match your actual phpBB

# login information.

# IMPORTANT: you MUST change GROUP_ID to the group ID # inserted by the abvoe

# configuration_group insert. Just to clarify, *remove* the text GROUP_ID

# from the statements below and REPLACE IT with the actual group_id value

# returned from the first query above.

#

INSERT INTO `configuration` (`configuration_id`, `configuration_title`, `configuration_key`, `configuration_value`, `configuration_description`, `configuration_group_id`, `sort_order`, `last_modified`, `date_added`, `use_function`, `set_function`) VALUES (NULL, 'Forum Administrator Display Name', 'FORUM_USERNAME', 'Administrator', 'The displayed username of the forum administrator.', GROUP_ID, '1', NOW(), NOW(), NULL, NULL);

INSERT INTO `configuration` (`configuration_id`, `configuration_title`, `configuration_key`, `configuration_value`, `configuration_description`, `configuration_group_id`, `sort_order`, `last_modified`, `date_added`, `use_function`, `set_function`) VALUES (NULL, 'Forum Administrator E-Mail', 'FORUM_USER_EMAIL', '[email protected]', 'The the forum administrator e-mail address for correspondence.', GROUP_ID, '2', NOW(), NOW(), NULL, NULL);

INSERT INTO `configuration` (`configuration_id`, `configuration_title`, `configuration_key`, `configuration_value`, `configuration_description`, `configuration_group_id`, `sort_order`, `last_modified`, `date_added`, `use_function`, `set_function`) VALUES (NULL, 'Forum Administrator Password', 'FORUM_PASSWORD', MD5('YOUR_PASSWORD'), 'The forum administrator password.', GROUP_ID, '3', NOW(), NOW(), NULL, NULL);

 

 

 

 

Does this mean I have to add this to my configuration file in admin in my osc site or is this what will be done when I "RUN SQL". When I extracted the mod I didnt see a sql file, is this something i have to create, insert to my site and run some type of query?

 

I hava cpanel and use navicat to edit and view my databases. I looked through the rest of the install and I can understand and perform everything but like I said im new to this and im not sure how to handle the above. Any help is greatly appreciated.

Posted

Is this the "phpBB-osCommerce Bridge" contribution? If it is, you need to run that SQL in your MySQL interface - usually phpMyAdmin. You'll find it from cPanel.

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...