Creating A Faq's page need help

deiana38 · October 27, 2012

Hi, I am trying to create a FAQ's page I have 2.3.3: I have figured out how to create a new link in the information box but what I am liking to do is put topics on Faq's page and provide questions under the topic that you can click on and it brings you to another page that has the answer. I keep looking and can not find the info to do this.

Praful Kamble · October 27, 2012

@@deiana38

There are FAQ addons available in addon section. However you can use extra info pages addon.

deiana38 · October 27, 2012

Thanks I will check in to this. I did check out extra info pages but was not sure how to go about this to link those pages

deiana38 · October 27, 2012

Do you know how to do this? Run the SQL script, by using phpMyAdmin.

October 27, 2012

@@deiana38

Log into your hosting account control panel and look for the PHPMYADMIN icon, click that and it will open your database. Copy and paste the SQL statement into the SQL tab and click go. Done.

Chris

deiana38 · October 27, 2012

hi, that is were I am getting confused because i go into my admin. and posted it and it did nothing

deiana38 · October 27, 2012

Help!!! I figured out how to install faq system and now I am not seeing a faq box in admin. or on my site I can post info to see if anyone can figure out what i did wrong.

deiana38 · October 27, 2012

<?php

/*

FAQ system for OSC 2.2 MS2 v2.1i 23.08.2007

Originally Created by: http://adgrafics.com admin@@adgrafics.net

Updated by: http://www.webandpepper.ch [email protected] v2.0 (03.03.2004)

Last Modified by Cydonian ([email protected]) (23.08.2007)

Released under the GNU General Public License

osCommerce, Open Source E-Commerce Solutions

*/

require('includes/application_top.php');

require(DIR_WS_LANGUAGES . $language . '/faq.php');

require(DIR_WS_FUNCTIONS . '/faq.php');

?>

<!doctype html public "-//W3C//DTD HTML 4.01 Transitional//EN">

<head>

</head>

<?php require(DIR_WS_INCLUDES . 'header.php'); ?>

<tr>

<td width="<?php echo BOX_WIDTH; ?>" valign="top"><table border="0" width="<?php echo BOX_WIDTH; ?>" cellspacing="1" cellpadding="1" class="columnLeft">

<?php require(DIR_WS_INCLUDES . 'column_left.php'); ?>

</table></td>

<?php

$faq_action = (isset($HTTP_GET_VARS['faq_action']) ? $HTTP_GET_VARS['faq_action'] : '');

switch($faq_action) {

case "Added":

$data = browse_faq($language,$HTTP_GET_VARS);

$no = 1;

if (sizeof($data) > 0) {

while (list($key, $val) = each($data)) {

$no++;

}

};

$title = FAQ_ADD . ' #' . $no;

echo tep_draw_form('faq_manager',FILENAME_FAQ_MANAGER, 'faq_action=AddSure');

include('faq_form.php');

break;

case "AddSure":

function add_faq ($data) {

$query = "INSERT INTO " . TABLE_FAQ . " VALUES(null, '$data[visible]', '$data[v_order]', '$data[question]', '$data[answer]', NOW(''),'$data[faq_language]')";

tep_db_query($query);

unset($HTTP_POST_VARS);

}

$question = (isset($HTTP_POST_VARS['question']) ? $HTTP_POST_VARS['question'] : '');

$answer = (isset($HTTP_POST_VARS['answer']) ? $HTTP_POST_VARS['answer'] : '');

$v_order = (isset($HTTP_POST_VARS['v_order']) ? $HTTP_POST_VARS['v_order'] : '');

if ($v_order && $answer && $question) {

if ($v_order) {

add_faq($HTTP_POST_VARS);

$data = browse_faq($language,$HTTP_GET_VARS);

$title = FAQ_CREATED . ' ' . FAQ_ADD_QUEUE . ' ' . $v_order;

include('faq_list.php');

} else {

$error = 20;

}

} else {

$error = 80;

}

break;

case "Edit":

$faq_id = (isset($HTTP_GET_VARS['faq_id']) ? $HTTP_GET_VARS['faq_id'] : '');

if ($faq_id) {

$edit = read_data($faq_id);

$data = browse_faq($language,$HTTP_GET_VARS);

$button = array("Update");

$title = FAQ_EDIT_ID . ' ' . $faq_id;

echo tep_draw_form('faq_manager',FILENAME_FAQ_MANAGER, 'faq_action=Update');

echo tep_draw_hidden_field('faq_id', $faq_id);

include('faq_form.php');

} else {

$error = 80;

}

break;

case "Update":

function update_faq ($data) {

tep_db_query("UPDATE " . TABLE_FAQ . " SET question='$data[question]', answer='$data[answer]', visible='$data[visible]', v_order=$data[v_order], date = now() WHERE faq_id=$data[faq_id]");

}

$faq_id = (isset($HTTP_POST_VARS['faq_id']) ? $HTTP_POST_VARS['faq_id'] : '');

$question = (isset($HTTP_POST_VARS['question']) ? $HTTP_POST_VARS['question'] : '');

$answer = (isset($HTTP_POST_VARS['answer']) ? $HTTP_POST_VARS['answer'] : '');

$v_order = (isset($HTTP_POST_VARS['v_order']) ? $HTTP_POST_VARS['v_order'] : '');

if ($faq_id && $question && $answer && $v_order) {

if ($v_order) {

update_faq($HTTP_POST_VARS);

$data = browse_faq($language,$HTTP_GET_VARS);

$title = FAQ_UPDATED_ID . ' ' . $faq_id;

include('faq_list.php');

} else {

$error = 20;

}

} else {

$error = 80;

}

break;

case 'Visible':

function tep_set_faq_visible($faq_id, $HTTP_GET_VARS) {

if ($HTTP_GET_VARS['visible'] == 1) {

return tep_db_query("update " . TABLE_FAQ . " set visible = '0', date = now() where faq_id = '" . $faq_id . "'");

} else{

return tep_db_query("update " . TABLE_FAQ . " set visible = '1', date = now() where faq_id = '" . $faq_id . "'");

}

$faq_id = (isset($HTTP_GET_VARS['faq_id']) ? $HTTP_GET_VARS['faq_id'] : '');

tep_set_faq_visible($faq_id, $HTTP_GET_VARS);

$data = browse_faq($language,$HTTP_GET_VARS);

if ($HTTP_GET_VARS['visible'] == 1) {

$vivod = FAQ_DEACTIVATED_ID;

} else {

$vivod = FAQ_ACTIVATED_ID;

}

$title = $vivod . ' ' . $faq_id;

include('faq_list.php');

break;

case "Delete":

$faq_id = (isset($HTTP_GET_VARS['faq_id']) ? $HTTP_GET_VARS['faq_id'] : '');

if ($faq_id) {

$delete = read_data($faq_id);

$data = browse_faq($language,$HTTP_GET_VARS);

$title = FAQ_DELETE_CONFITMATION_ID . ' ' . $faq_id;

echo '

<tr class="pageHeading"><td>' . $title . '</td></tr>

<tr><td class="dataTableContent">' . FAQ_QUESTION . ':</td></tr>

<tr><td class="dataTableContent">' . $delete[question] . '</td></tr>

<tr><td class="dataTableContent">' . FAQ_ANSWER . ':</td></tr>

<tr><td class="dataTableContent">' . $delete[answer] . '</td></tr>

';

echo tep_draw_form('faq_manager',FILENAME_FAQ_MANAGER, 'faq_action=DelSure&faq_id='.$val[faq_id]);

echo tep_draw_hidden_field('faq_id', $faq_id);

echo tep_image_submit('button_delete.gif', IMAGE_DELETE);

echo '<a href="' . tep_href_link(FILENAME_FAQ_MANAGER, '', 'NONSSL') . '">' . tep_image_button('button_cancel.gif', IMAGE_CANCEL) . '</a>';

echo '</form></td></tr>';

} else {

$error = 80;

}

break;

case "DelSure":

function delete_faq ($faq_id) {

tep_db_query("DELETE FROM " . TABLE_FAQ . " WHERE faq_id=$faq_id");

}

$faq_id = (isset($HTTP_POST_VARS['faq_id']) ? $HTTP_POST_VARS['faq_id'] : '');

if ($faq_id) {

delete_faq($faq_id);

$data = browse_faq($language,$HTTP_GET_VARS);

$title = FAQ_DELETED_ID . ' ' . $faq_id;

include('faq_list.php');

} else {

$error = 80;

}

break;

default:

$data = browse_faq($language,$HTTP_GET_VARS);

$title = FAQ_MANAGER;

include('faq_list.php');

break;

}

if ($error) {

$content = error_message($error);

echo $content;

$data = browse_faq($language,$HTTP_GET_VARS);

$no = 1;

if (sizeof($data) > 0) {

while (list($key, $val) = each($data)) {

$no++;

}

};

switch($faq_action) {

case "AddSure":

$title = FAQ_ADD . ' #' . $no;

echo tep_draw_form('faq_manager',FILENAME_FAQ_MANAGER, 'faq_action=AddSure');

include('faq_form.php');

break;

case "Update":

$title = FAQ_EDIT_ID . ' ' . $faq_id;

echo tep_draw_form('faq_manager',FILENAME_FAQ_MANAGER, 'faq_action=Update');

echo tep_draw_hidden_field('faq_id', $faq_id);

include('faq_form.php');

break;

default:

$title = FAQ_ADD_QUEUE . ' ' . $no;

echo tep_draw_form('faq_manager',FILENAME_FAQ_MANAGER, 'faq_action=AddSure');

include('faq_form.php');

break;

}

?>

</table>

</td>

</tr>

</table>

<?php require(DIR_WS_INCLUDES . 'footer.php'); ?>

</body>

</html>

<?php require(DIR_WS_INCLUDES . 'application_bottom.php'); ?>

deiana38 · October 27, 2012

DROP TABLE IF EXISTS faq;

CREATE TABLE `faq` (

`faq_id` tinyint(3) unsigned NOT NULL auto_increment,

`visible` enum('1','0') NOT NULL default '1',

`v_order` tinyint(3) unsigned NOT NULL default '0',

`question` text NOT NULL,

`answer` text NOT NULL,

`date` date NOT NULL default '0000-00-00',

`language` varchar(32) NOT NULL default '',

PRIMARY KEY (`faq_id`)

) TYPE=MyISAM AUTO_INCREMENT=5;

#

# Data For Table `faq`

#

INSERT INTO `faq` VALUES (1, '1', 1, 'English question 1?', 'English answer 1.', '2005-02-23', 'english');

INSERT INTO `faq` VALUES (2, '1', 2, 'English question 2?', 'English answer 2.', '2005-02-23', 'english');

INSERT INTO `faq` VALUES (3, '1', 1, 'Deutsche Frage 1?', 'Deutsche Antwort 1.', '2005-02-23', 'german');

INSERT INTO `faq` VALUES (4, '1', 2, 'Deutsche Frage 2?', 'Deutsche Antwort 2.', '2005-02-23', 'german');

INSERT INTO `faq` VALUES (5, '1', 1, 'French question 1?', 'French answer 1.', '2005-02-23', 'french');

INSERT INTO `faq` VALUES (6, '1', 2, 'French question 1?', 'French answer 2.', '2005-02-23', 'french');

INSERT INTO `faq` VALUES (7, '1', 1, 'Danske Spørgsmål 1?', 'Dansk Svar 1.', '2005-02-23', 'danish');

INSERT INTO `faq` VALUES (8, '1', 2, 'Danske Spørgsmål 2?', 'Dansk Svar 2.', '2005-02-23', 'danish');

INSERT INTO `faq` VALUES (9, '1', 1, 'Turkish question 1?', 'Turkish answer 1.', '2005-02-23', 'turkish');

INSERT INTO `faq` VALUES (10, '1', 2, 'Turkish question 2?', 'Turkish answer 2.', '2005-02-23', 'turkish');

deiana38 · October 27, 2012

<?php

/*

$Id$

osCommerce, Open Source E-Commerce Solutions

http://www.oscommerce.com

Released under the GNU General Public License

*/

// define the filenames used in the project

define('FILENAME_ACCOUNT', 'account.php');

define('FILENAME_ACCOUNT_EDIT', 'account_edit.php');

define('FILENAME_ACCOUNT_HISTORY', 'account_history.php');

define('FILENAME_ACCOUNT_HISTORY_INFO', 'account_history_info.php');

define('FILENAME_ACCOUNT_NEWSLETTERS', 'account_newsletters.php');

define('FILENAME_ACCOUNT_NOTIFICATIONS', 'account_notifications.php');

define('FILENAME_ACCOUNT_PASSWORD', 'account_password.php');

define('FILENAME_ADDRESS_BOOK', 'address_book.php');

define('FILENAME_ADDRESS_BOOK_PROCESS', 'address_book_process.php');

define('FILENAME_ADVANCED_SEARCH', 'advanced_search.php');

define('FILENAME_ADVANCED_SEARCH_RESULT', 'advanced_search_result.php');

define('FILENAME_ALSO_PURCHASED_PRODUCTS', 'also_purchased_products.php');

define('FILENAME_CHECKOUT_CONFIRMATION', 'checkout_confirmation.php');

define('FILENAME_CHECKOUT_PAYMENT', 'checkout_payment.php');

define('FILENAME_CHECKOUT_PAYMENT_ADDRESS', 'checkout_payment_address.php');

define('FILENAME_CHECKOUT_PROCESS', 'checkout_process.php');

define('FILENAME_CHECKOUT_SHIPPING', 'checkout_shipping.php');

define('FILENAME_CHECKOUT_SHIPPING_ADDRESS', 'checkout_shipping_address.php');

define('FILENAME_CHECKOUT_SUCCESS', 'checkout_success.php');

define('FILENAME_CONTACT_US', 'contact_us.php');

define('FILENAME_CONDITIONS', 'conditions.php');

define('FILENAME_COOKIE_USAGE', 'cookie_usage.php');

define('FILENAME_CREATE_ACCOUNT', 'create_account.php');

define('FILENAME_CREATE_ACCOUNT_SUCCESS', 'create_account_success.php');

define('FILENAME_DEFAULT', 'index.php');

define('FILENAME_DOWNLOAD', 'download.php');

define('FILENAME_INFO_SHOPPING_CART', 'info_shopping_cart.php');

define('FILENAME_LOGIN', 'login.php');

define('FILENAME_LOGOFF', 'logoff.php');

define('FILENAME_NEW_PRODUCTS', 'new_products.php');

define('FILENAME_PASSWORD_FORGOTTEN', 'password_forgotten.php');

define('FILENAME_PASSWORD_RESET', 'password_reset.php');

define('FILENAME_POPUP_IMAGE', 'popup_image.php');

define('FILENAME_POPUP_SEARCH_HELP', 'popup_search_help.php');

define('FILENAME_PRIVACY', 'privacy.php');

define('FILENAME_PRODUCT_INFO', 'product_info.php');

define('FILENAME_PRODUCT_LISTING', 'product_listing.php');

define('FILENAME_PRODUCT_REVIEWS', 'product_reviews.php');

define('FILENAME_PRODUCT_REVIEWS_INFO', 'product_reviews_info.php');

define('FILENAME_PRODUCT_REVIEWS_WRITE', 'product_reviews_write.php');

define('FILENAME_PRODUCTS_NEW', 'products_new.php');

define('FILENAME_REDIRECT', 'redirect.php');

define('FILENAME_REVIEWS', 'reviews.php');

define('FILENAME_SHIPPING', 'shipping.php');

define('FILENAME_SHOPPING_CART', 'shopping_cart.php');

define('FILENAME_SPECIALS', 'specials.php');

define('FILENAME_SSL_CHECK', 'ssl_check.php');

define('FILENAME_TELL_A_FRIEND', 'tell_a_friend.php');

define('FILENAME_UPCOMING_PRODUCTS', 'upcoming_products.php');

// FAQ SYSTEM 2.1

define('FILENAME_FAQ_MANAGER', 'faq_manager.php');

define('FILENAME_FAQ_VIEW', 'faq_view.php');

define('FILENAME_FAQ_VIEW_ALL', 'faq_view_all.php');

// FAQ SYSTEM 2.1

?>

deiana38 · October 27, 2012

<?php

/*

$Id$

osCommerce, Open Source E-Commerce Solutions

http://www.oscommerce.com

Released under the GNU General Public License

*/

// look in your $PATH_LOCALE/locale directory for available locales..

// on RedHat6.0 I used 'en_US'

// on FreeBSD 4.0 I use 'en_US.ISO_8859-1'

// this may not work under win32 environments..

setlocale(LC_TIME, 'en_US.ISO_8859-1');

define('DATE_FORMAT_SHORT', '%m/%d/%Y'); // this is used for strftime()

define('DATE_FORMAT_LONG', '%A %d %B, %Y'); // this is used for strftime()

define('DATE_FORMAT', 'm/d/Y'); // this is used for date()

define('PHP_DATE_TIME_FORMAT', 'm/d/Y H:i:s'); // this is used for date()

define('DATE_TIME_FORMAT', DATE_FORMAT_SHORT . ' %H:%M:%S');

define('JQUERY_DATEPICKER_I18N_CODE', ''); // leave empty for en_US; see http://jqueryui.com/demos/datepicker/#localization

define('JQUERY_DATEPICKER_FORMAT', 'mm/dd/yy'); // see http://docs.jquery.com/UI/Datepicker/formatDate

////

// Return date in raw format

// $date should be in format mm/dd/yyyy

// raw date is in format YYYYMMDD, or DDMMYYYY

function tep_date_raw($date, $reverse = false) {

if ($reverse) {

return substr($date, 3, 2) . substr($date, 0, 2) . substr($date, 6, 4);

} else {

return substr($date, 6, 4) . substr($date, 0, 2) . substr($date, 3, 2);

}

// Global entries for the <html> tag

define('HTML_PARAMS','dir="ltr" lang="en"');

// charset for web pages and emails

define('CHARSET', 'utf-8');

// page title

define('TITLE', 'osCommerce Online Merchant Administration Tool');

// header text in includes/header.php

define('HEADER_TITLE_TOP', 'Administration');

define('HEADER_TITLE_SUPPORT_SITE', 'Support Site');

define('HEADER_TITLE_ONLINE_CATALOG', 'Online Catalog');

define('HEADER_TITLE_ADMINISTRATION', 'Administration');

// text for gender

define('MALE', 'Male');

define('FEMALE', 'Female');

// text for date of birth example

define('DOB_FORMAT_STRING', 'mm/dd/yyyy');

// configuration box text in includes/boxes/configuration.php

define('BOX_HEADING_CONFIGURATION', 'Configuration');

define('BOX_CONFIGURATION_MYSTORE', 'My Store');

define('BOX_CONFIGURATION_LOGGING', 'Logging');

define('BOX_CONFIGURATION_CACHE', 'Cache');

define('BOX_CONFIGURATION_ADMINISTRATORS', 'Administrators');

define('BOX_CONFIGURATION_STORE_LOGO', 'Store Logo');

// modules box text in includes/boxes/modules.php

define('BOX_HEADING_MODULES', 'Modules');

// categories box text in includes/boxes/catalog.php

define('BOX_HEADING_CATALOG', 'Catalog');

define('BOX_CATALOG_CATEGORIES_PRODUCTS', 'Categories/Products');

define('BOX_CATALOG_CATEGORIES_PRODUCTS_ATTRIBUTES', 'Products Attributes');

define('BOX_CATALOG_MANUFACTURERS', 'Manufacturers');

define('BOX_CATALOG_REVIEWS', 'Reviews');

define('BOX_CATALOG_SPECIALS', 'Specials');

define('BOX_CATALOG_PRODUCTS_EXPECTED', 'Products Expected');

// customers box text in includes/boxes/customers.php

define('BOX_HEADING_CUSTOMERS', 'Customers');

define('BOX_CUSTOMERS_CUSTOMERS', 'Customers');

define('BOX_CUSTOMERS_ORDERS', 'Orders');

// taxes box text in includes/boxes/taxes.php

define('BOX_HEADING_LOCATION_AND_TAXES', 'Locations / Taxes');

define('BOX_TAXES_COUNTRIES', 'Countries');

define('BOX_TAXES_ZONES', 'Zones');

define('BOX_TAXES_GEO_ZONES', 'Tax Zones');

define('BOX_TAXES_TAX_CLASSES', 'Tax Classes');

define('BOX_TAXES_TAX_RATES', 'Tax Rates');

// reports box text in includes/boxes/reports.php

define('BOX_HEADING_REPORTS', 'Reports');

define('BOX_REPORTS_PRODUCTS_VIEWED', 'Products Viewed');

define('BOX_REPORTS_PRODUCTS_PURCHASED', 'Products Purchased');

define('BOX_REPORTS_ORDERS_TOTAL', 'Customer Orders-Total');

// tools text in includes/boxes/tools.php

define('BOX_HEADING_TOOLS', 'Tools');

define('BOX_TOOLS_ACTION_RECORDER', 'Action Recorder');

define('BOX_TOOLS_BACKUP', 'Database Backup');

define('BOX_TOOLS_BANNER_MANAGER', 'Banner Manager');

define('BOX_TOOLS_CACHE', 'Cache Control');

define('BOX_TOOLS_DEFINE_LANGUAGE', 'Define Languages');

define('BOX_TOOLS_MAIL', 'Send Email');

define('BOX_TOOLS_NEWSLETTER_MANAGER', 'Newsletter Manager');

define('BOX_TOOLS_SEC_DIR_PERMISSIONS', 'Security Directory Permissions');

define('BOX_TOOLS_SERVER_INFO', 'Server Info');

define('BOX_TOOLS_VERSION_CHECK', 'Version Checker');

define('BOX_TOOLS_WHOS_ONLINE', 'Who\'s Online');

// localizaion box text in includes/boxes/localization.php

define('BOX_HEADING_LOCALIZATION', 'Localization');

define('BOX_LOCALIZATION_CURRENCIES', 'Currencies');

define('BOX_LOCALIZATION_LANGUAGES', 'Languages');

define('BOX_LOCALIZATION_ORDERS_STATUS', 'Orders Status');

// javascript messages

define('JS_ERROR', 'Errors have occured during the process of your form!\nPlease make the following corrections:\n\n');

define('JS_OPTIONS_VALUE_PRICE', '* The new product atribute needs a price value\n');

define('JS_OPTIONS_VALUE_PRICE_PREFIX', '* The new product atribute needs a price prefix\n');

define('JS_PRODUCTS_NAME', '* The new product needs a name\n');

define('JS_PRODUCTS_DESCRIPTION', '* The new product needs a description\n');

define('JS_PRODUCTS_PRICE', '* The new product needs a price value\n');

define('JS_PRODUCTS_WEIGHT', '* The new product needs a weight value\n');

define('JS_PRODUCTS_QUANTITY', '* The new product needs a quantity value\n');

define('JS_PRODUCTS_MODEL', '* The new product needs a model value\n');

define('JS_PRODUCTS_IMAGE', '* The new product needs an image value\n');

define('JS_SPECIALS_PRODUCTS_PRICE', '* A new price for this product needs to be set\n');

define('JS_GENDER', '* The \'Gender\' value must be chosen.\n');

define('JS_FIRST_NAME', '* The \'First Name\' entry must have at least ' . ENTRY_FIRST_NAME_MIN_LENGTH . ' characters.\n');

define('JS_LAST_NAME', '* The \'Last Name\' entry must have at least ' . ENTRY_LAST_NAME_MIN_LENGTH . ' characters.\n');

define('JS_DOB', '* The \'Date of Birth\' entry must be in the format: xx/xx/xxxx (month/date/year).\n');

define('JS_EMAIL_ADDRESS', '* The \'E-Mail Address\' entry must have at least ' . ENTRY_EMAIL_ADDRESS_MIN_LENGTH . ' characters.\n');

define('JS_ADDRESS', '* The \'Street Address\' entry must have at least ' . ENTRY_STREET_ADDRESS_MIN_LENGTH . ' characters.\n');

define('JS_POST_CODE', '* The \'Post Code\' entry must have at least ' . ENTRY_POSTCODE_MIN_LENGTH . ' characters.\n');

define('JS_CITY', '* The \'City\' entry must have at least ' . ENTRY_CITY_MIN_LENGTH . ' characters.\n');

define('JS_STATE', '* The \'State\' entry is must be selected.\n');

define('JS_STATE_SELECT', '-- Select Above --');

define('JS_ZONE', '* The \'State\' entry must be selected from the list for this country.');

define('JS_COUNTRY', '* The \'Country\' value must be chosen.\n');

define('JS_TELEPHONE', '* The \'Telephone Number\' entry must have at least ' . ENTRY_TELEPHONE_MIN_LENGTH . ' characters.\n');

define('JS_PASSWORD', '* The \'Password\' amd \'Confirmation\' entries must match amd have at least ' . ENTRY_PASSWORD_MIN_LENGTH . ' characters.\n');

define('JS_ORDER_DOES_NOT_EXIST', 'Order Number %s does not exist!');

define('CATEGORY_PERSONAL', 'Personal');

define('CATEGORY_ADDRESS', 'Address');

define('CATEGORY_CONTACT', 'Contact');

define('CATEGORY_COMPANY', 'Company');

define('CATEGORY_OPTIONS', 'Options');

define('ENTRY_GENDER', 'Gender:');

define('ENTRY_GENDER_ERROR', ' required');

define('ENTRY_FIRST_NAME', 'First Name:');

define('ENTRY_FIRST_NAME_ERROR', ' min ' . ENTRY_FIRST_NAME_MIN_LENGTH . ' chars');

define('ENTRY_LAST_NAME', 'Last Name:');

define('ENTRY_LAST_NAME_ERROR', ' min ' . ENTRY_LAST_NAME_MIN_LENGTH . ' chars');

define('ENTRY_DATE_OF_BIRTH', 'Date of Birth:');

define('ENTRY_DATE_OF_BIRTH_ERROR', ' (eg. 05/21/1970)');

define('ENTRY_EMAIL_ADDRESS', 'E-Mail Address:');

define('ENTRY_EMAIL_ADDRESS_ERROR', ' min ' . ENTRY_EMAIL_ADDRESS_MIN_LENGTH . ' chars');

define('ENTRY_EMAIL_ADDRESS_CHECK_ERROR', ' The email address doesn\'t appear to be valid!');

define('ENTRY_EMAIL_ADDRESS_ERROR_EXISTS', ' This email address already exists!');

define('ENTRY_COMPANY', 'Company name:');

define('ENTRY_STREET_ADDRESS', 'Street Address:');

define('ENTRY_STREET_ADDRESS_ERROR', ' min ' . ENTRY_STREET_ADDRESS_MIN_LENGTH . ' chars');

define('ENTRY_SUBURB', 'Suburb:');

define('ENTRY_POST_CODE', 'Post Code:');

define('ENTRY_POST_CODE_ERROR', ' min ' . ENTRY_POSTCODE_MIN_LENGTH . ' chars');

define('ENTRY_CITY', 'City:');

define('ENTRY_CITY_ERROR', ' min ' . ENTRY_CITY_MIN_LENGTH . ' chars');

define('ENTRY_STATE', 'State:');

define('ENTRY_STATE_ERROR', ' required');

define('ENTRY_COUNTRY', 'Country:');

define('ENTRY_COUNTRY_ERROR', 'You must select a country from the Countries pull down menu.');

define('ENTRY_TELEPHONE_NUMBER', 'Telephone Number:');

define('ENTRY_TELEPHONE_NUMBER_ERROR', ' min ' . ENTRY_TELEPHONE_MIN_LENGTH . ' chars');

define('ENTRY_FAX_NUMBER', 'Fax Number:');

define('ENTRY_NEWSLETTER', 'Newsletter:');

define('ENTRY_NEWSLETTER_YES', 'Subscribed');

define('ENTRY_NEWSLETTER_NO', 'Unsubscribed');

// images

define('IMAGE_ANI_SEND_EMAIL', 'Sending E-Mail');

define('IMAGE_BACK', 'Back');

define('IMAGE_BACKUP', 'Backup');

define('IMAGE_CANCEL', 'Cancel');

define('IMAGE_CONFIRM', 'Confirm');

define('IMAGE_COPY', 'Copy');

define('IMAGE_COPY_TO', 'Copy To');

define('IMAGE_DETAILS', 'Details');

define('IMAGE_DELETE', 'Delete');

define('IMAGE_EDIT', 'Edit');

define('IMAGE_EMAIL', 'Email');

define('IMAGE_EXPORT', 'Export');

define('IMAGE_ICON_STATUS_GREEN', 'Active');

define('IMAGE_ICON_STATUS_GREEN_LIGHT', 'Set Active');

define('IMAGE_ICON_STATUS_RED', 'Inactive');

define('IMAGE_ICON_STATUS_RED_LIGHT', 'Set Inactive');

define('IMAGE_ICON_INFO', 'Info');

define('IMAGE_INSERT', 'Insert');

define('IMAGE_LOCK', 'Lock');

define('IMAGE_MODULE_INSTALL', 'Install Module');

define('IMAGE_MODULE_REMOVE', 'Remove Module');

define('IMAGE_MOVE', 'Move');

define('IMAGE_NEW_BANNER', 'New Banner');

define('IMAGE_NEW_CATEGORY', 'New Category');

define('IMAGE_NEW_COUNTRY', 'New Country');

define('IMAGE_NEW_CURRENCY', 'New Currency');

define('IMAGE_NEW_FILE', 'New File');

define('IMAGE_NEW_FOLDER', 'New Folder');

define('IMAGE_NEW_LANGUAGE', 'New Language');

define('IMAGE_NEW_NEWSLETTER', 'New Newsletter');

define('IMAGE_NEW_PRODUCT', 'New Product');

define('IMAGE_NEW_TAX_CLASS', 'New Tax Class');

define('IMAGE_NEW_TAX_RATE', 'New Tax Rate');

define('IMAGE_NEW_TAX_ZONE', 'New Tax Zone');

define('IMAGE_NEW_ZONE', 'New Zone');

define('IMAGE_ORDERS', 'Orders');

define('IMAGE_ORDERS_INVOICE', 'Invoice');

define('IMAGE_ORDERS_PACKINGSLIP', 'Packing Slip');

define('IMAGE_PREVIEW', 'Preview');

define('IMAGE_RESTORE', 'Restore');

define('IMAGE_RESET', 'Reset');

define('IMAGE_SAVE', 'Save');

define('IMAGE_SEARCH', 'Search');

define('IMAGE_SELECT', 'Select');

define('IMAGE_SEND', 'Send');

define('IMAGE_SEND_EMAIL', 'Send Email');

define('IMAGE_UNLOCK', 'Unlock');

define('IMAGE_UPDATE', 'Update');

define('IMAGE_UPDATE_CURRENCIES', 'Update Exchange Rate');

define('IMAGE_UPLOAD', 'Upload');

define('ICON_CROSS', 'False');

define('ICON_CURRENT_FOLDER', 'Current Folder');

define('ICON_DELETE', 'Delete');

define('ICON_ERROR', 'Error');

define('ICON_FILE', 'File');

define('ICON_FILE_DOWNLOAD', 'Download');

define('ICON_FOLDER', 'Folder');

define('ICON_LOCKED', 'Locked');

define('ICON_PREVIOUS_LEVEL', 'Previous Level');

define('ICON_PREVIEW', 'Preview');

define('ICON_STATISTICS', 'Statistics');

define('ICON_SUCCESS', 'Success');

define('ICON_TICK', 'True');

define('ICON_UNLOCKED', 'Unlocked');

define('ICON_WARNING', 'Warning');

// constants for use in tep_prev_next_display function

define('TEXT_RESULT_PAGE', 'Page %s of %d');

define('TEXT_DISPLAY_NUMBER_OF_BANNERS', 'Displaying %d to %d (of %d banners)');

define('TEXT_DISPLAY_NUMBER_OF_COUNTRIES', 'Displaying %d to %d (of %d countries)');

define('TEXT_DISPLAY_NUMBER_OF_CUSTOMERS', 'Displaying %d to %d (of %d customers)');

define('TEXT_DISPLAY_NUMBER_OF_CURRENCIES', 'Displaying %d to %d (of %d currencies)');

define('TEXT_DISPLAY_NUMBER_OF_ENTRIES', 'Displaying %d to %d (of %d entries)');

define('TEXT_DISPLAY_NUMBER_OF_LANGUAGES', 'Displaying %d to %d (of %d languages)');

define('TEXT_DISPLAY_NUMBER_OF_MANUFACTURERS', 'Displaying %d to %d (of %d manufacturers)');

define('TEXT_DISPLAY_NUMBER_OF_NEWSLETTERS', 'Displaying %d to %d (of %d newsletters)');

define('TEXT_DISPLAY_NUMBER_OF_ORDERS', 'Displaying %d to %d (of %d orders)');

define('TEXT_DISPLAY_NUMBER_OF_ORDERS_STATUS', 'Displaying %d to %d (of %d orders status)');

define('TEXT_DISPLAY_NUMBER_OF_PRODUCTS', 'Displaying %d to %d (of %d products)');

define('TEXT_DISPLAY_NUMBER_OF_PRODUCTS_EXPECTED', 'Displaying %d to %d (of %d products expected)');

define('TEXT_DISPLAY_NUMBER_OF_REVIEWS', 'Displaying %d to %d (of %d product reviews)');

define('TEXT_DISPLAY_NUMBER_OF_SPECIALS', 'Displaying %d to %d (of %d products on special)');

define('TEXT_DISPLAY_NUMBER_OF_TAX_CLASSES', 'Displaying %d to %d (of %d tax classes)');

define('TEXT_DISPLAY_NUMBER_OF_TAX_ZONES', 'Displaying %d to %d (of %d tax zones)');

define('TEXT_DISPLAY_NUMBER_OF_TAX_RATES', 'Displaying %d to %d (of %d tax rates)');

define('TEXT_DISPLAY_NUMBER_OF_ZONES', 'Displaying %d to %d (of %d zones)');

define('PREVNEXT_BUTTON_PREV', '<<');

define('PREVNEXT_BUTTON_NEXT', '>>');

define('TEXT_DEFAULT', 'default');

define('TEXT_SET_DEFAULT', 'Set as default');

define('TEXT_FIELD_REQUIRED', ' * Required');

define('TEXT_CACHE_CATEGORIES', 'Categories Box');

define('TEXT_CACHE_MANUFACTURERS', 'Manufacturers Box');

define('TEXT_CACHE_ALSO_PURCHASED', 'Also Purchased Module');

define('TEXT_NONE', '--none--');

define('TEXT_TOP', 'Top');

define('ERROR_DESTINATION_DOES_NOT_EXIST', 'Error: Destination does not exist.');

define('ERROR_DESTINATION_NOT_WRITEABLE', 'Error: Destination not writeable.');

define('ERROR_FILE_NOT_SAVED', 'Error: File upload not saved.');

define('ERROR_FILETYPE_NOT_ALLOWED', 'Error: File upload type not allowed.');

define('SUCCESS_FILE_SAVED_SUCCESSFULLY', 'Success: File upload saved successfully.');

define('WARNING_NO_FILE_UPLOADED', 'Warning: No file uploaded.');

// FAQ SYSTEM 2.1

define('BOX_HEADING_FAQ', 'FAQ System');

define('BOX_FAQ_MANAGER', 'FAQ Manager');

define('BOX_FAQ_VIEW', 'FAQ View');

define('BOX_FAQ_VIEW_ALL', 'FAQ View All');

// FAQ SYSTEM 2.1

?>

deiana38 · October 27, 2012

<?php

/*

$Id$

osCommerce, Open Source E-Commerce Solutions

http://www.oscommerce.com

Released under the GNU General Public License

*/

// define the database table names used in the project

define('TABLE_ACTION_RECORDER', 'action_recorder');

define('TABLE_ADDRESS_BOOK', 'address_book');

define('TABLE_ADDRESS_FORMAT', 'address_format');

define('TABLE_ADMINISTRATORS', 'administrators');

define('TABLE_BANNERS', 'banners');

define('TABLE_BANNERS_HISTORY', 'banners_history');

define('TABLE_CATEGORIES', 'categories');

define('TABLE_CATEGORIES_DESCRIPTION', 'categories_description');

define('TABLE_CONFIGURATION', 'configuration');

define('TABLE_CONFIGURATION_GROUP', 'configuration_group');

define('TABLE_COUNTRIES', 'countries');

define('TABLE_CURRENCIES', 'currencies');

define('TABLE_CUSTOMERS', 'customers');

define('TABLE_CUSTOMERS_BASKET', 'customers_basket');

define('TABLE_CUSTOMERS_BASKET_ATTRIBUTES', 'customers_basket_attributes');

define('TABLE_CUSTOMERS_INFO', 'customers_info');

define('TABLE_LANGUAGES', 'languages');

define('TABLE_MANUFACTURERS', 'manufacturers');

define('TABLE_MANUFACTURERS_INFO', 'manufacturers_info');

define('TABLE_NEWSLETTERS', 'newsletters');

define('TABLE_ORDERS', 'orders');

define('TABLE_ORDERS_PRODUCTS', 'orders_products');

define('TABLE_ORDERS_PRODUCTS_ATTRIBUTES', 'orders_products_attributes');

define('TABLE_ORDERS_PRODUCTS_DOWNLOAD', 'orders_products_download');

define('TABLE_ORDERS_STATUS', 'orders_status');

define('TABLE_ORDERS_STATUS_HISTORY', 'orders_status_history');

define('TABLE_ORDERS_TOTAL', 'orders_total');

define('TABLE_PRODUCTS', 'products');

define('TABLE_PRODUCTS_ATTRIBUTES', 'products_attributes');

define('TABLE_PRODUCTS_ATTRIBUTES_DOWNLOAD', 'products_attributes_download');

define('TABLE_PRODUCTS_DESCRIPTION', 'products_description');

define('TABLE_PRODUCTS_IMAGES', 'products_images');

define('TABLE_PRODUCTS_NOTIFICATIONS', 'products_notifications');

define('TABLE_PRODUCTS_OPTIONS', 'products_options');

define('TABLE_PRODUCTS_OPTIONS_VALUES', 'products_options_values');

define('TABLE_PRODUCTS_OPTIONS_VALUES_TO_PRODUCTS_OPTIONS', 'products_options_values_to_products_options');

define('TABLE_PRODUCTS_TO_CATEGORIES', 'products_to_categories');

define('TABLE_REVIEWS', 'reviews');

define('TABLE_REVIEWS_DESCRIPTION', 'reviews_description');

define('TABLE_SEC_DIRECTORY_WHITELIST', 'sec_directory_whitelist');

define('TABLE_SESSIONS', 'sessions');

define('TABLE_SPECIALS', 'specials');

define('TABLE_TAX_CLASS', 'tax_class');

define('TABLE_TAX_RATES', 'tax_rates');

define('TABLE_GEO_ZONES', 'geo_zones');

define('TABLE_ZONES_TO_GEO_ZONES', 'zones_to_geo_zones');

define('TABLE_WHOS_ONLINE', 'whos_online');

define('TABLE_ZONES', 'zones');

?>

October 27, 2012

@@deiana38

Ok, your first post said this "Hi, I am trying to create a FAQ's page I have 2.3.3"

The contribution you are trying to install says this "FAQ system for OSC 2.2 MS2 v2.1i 23.08.2007"

Perhaps THIS contribution would have been a better choice ???

Chris

Creating A Faq's page need help

Recommended Posts

deiana38

Praful Kamble

deiana38

deiana38

Guest

deiana38

deiana38

deiana38

deiana38

deiana38

deiana38

deiana38

Guest

Archived

Browse

Activity