OsC list of tags/variables/placeholders

[omastroberti]

I think I found an easy way to get al this tags, variables or placeholders that OSC need/use.

After loosing some serious amount of time, I think this reply may save somebody's time...

 

So, here are the steps:

 

1) Log into your DB (i.e. by PhpMyAdmin)

2) Select your OSC DB

3) Select the "Configuration" table (#8 aproximatly)

4) Now, on the right panel, selec "Browse" (First option from left to right)

 

Here's the part where you became exiting after reading the first rows... (Store Name STORE_NAME, Store Owner STORE_OWNER, etc). Now, here you are. I think here are almost ALL the tags/variables/placeholders you can use.

 

I found wery convinient to export this table, and print it (after some excel's formatting...because is a large table) to read and study it.

 

To do that,

6) Go to Export (at the same place from Browse, but "more to the right")

7) Select "CVS data for MS Excel" (2nd option)

8) Then Check the "sent" box, to export this table and download it like a .cvs file

9) Hit continue, and save the file whereever you want.

 

I found this table very userful to edit the about_us.php file, and some other, so I can add information and tags bitween, so when I update some info, it is directly updated in the pages.

 

Like the

STORE_NAME_ADDRESS, in about_us.php, or the

MODULE_ORDER_TOTAL_LOWORDERFEE_ORDER_UNDER to write in, in the privay.php to clarify under what amount of order is the shipping free.

 

Remember, that when editing some files, you will need to add " '. " at the beginning and " .' " at the end. I.e.

 <?php
/*
  $Id: privacy.php 1739 2007-12-20 00:52:16Z hpdl $

  osCommerce, Open Source E-Commerce Solutions
  http://www.oscommerce.com

  Copyright (c) 2002 osCommerce

  Released under the GNU General Public License
*/

define('NAVBAR_TITLE', 'Confidencialidad');
define('HEADING_TITLE', 'Confidencialidad');

define('TEXT_INFORMATION', ' <p> Our Store name is <b>'. </b>STORE_NAME <b>.'</b> </p> ');
?>

 

 

So, I hope it helps

 

Cheers,

Oscar (Argentina)

 

Oscommerce List of Tags - Variables - Placeholders

 

STORE_NAME STORE_OWNER STORE_OWNER_EMAIL_ADDRESS EMAIL_FROM STORE_COUNTRY STORE_ZONE EXPECTED_PRODUCTS_SORT EXPECTED_PRODUCTS_FIELD USE_DEFAULT_LANGUAGE_CURRENCY SEND_EXTRA_ORDER_EMAILS_TO SEARCH_ENGINE_FRIENDLY_URLS DISPLAY_CART ALLOW_GUEST_TO_TELL_A_FRIEND ADVANCED_SEARCH_DEFAULT_OPERATOR STORE_NAME_ADDRESS SHOW_COUNTS TAX_DECIMAL_PLACES DISPLAY_PRICE_WITH_TAX ENTRY_FIRST_NAME_MIN_LENGTH ENTRY_LAST_NAME_MIN_LENGTH ENTRY_DOB_MIN_LENGTH ENTRY_EMAIL_ADDRESS_MIN_LENGTH ENTRY_STREET_ADDRESS_MIN_LENGTH ENTRY_COMPANY_MIN_LENGTH ENTRY_POSTCODE_MIN_LENGTH ENTRY_CITY_MIN_LENGTH ENTRY_STATE_MIN_LENGTH ENTRY_TELEPHONE_MIN_LENGTH ENTRY_PASSWORD_MIN_LENGTH CC_OWNER_MIN_LENGTH CC_NUMBER_MIN_LENGTH REVIEW_TEXT_MIN_LENGTH MIN_DISPLAY_BESTSELLERS MIN_DISPLAY_ALSO_PURCHASED MAX_ADDRESS_BOOK_ENTRIES MAX_DISPLAY_SEARCH_RESULTS MAX_DISPLAY_PAGE_LINKS MAX_DISPLAY_SPECIAL_PRODUCTS MAX_DISPLAY_NEW_PRODUCTS MAX_DISPLAY_UPCOMING_PRODUCTS MAX_DISPLAY_MANUFACTURERS_IN_A_LIST MAX_MANUFACTURERS_LIST MAX_DISPLAY_MANUFACTURER_NAME_LEN MAX_DISPLAY_NEW_REVIEWS MAX_RANDOM_SELECT_REVIEWS MAX_RANDOM_SELECT_NEW MAX_RANDOM_SELECT_SPECIALS MAX_DISPLAY_CATEGORIES_PER_ROW MAX_DISPLAY_PRODUCTS_NEW MAX_DISPLAY_BESTSELLERS MAX_DISPLAY_ALSO_PURCHASED MAX_DISPLAY_PRODUCTS_IN_ORDER_HISTORY_BOX MAX_DISPLAY_ORDER_HISTORY MAX_QTY_IN_CART SMALL_IMAGE_WIDTH SMALL_IMAGE_HEIGHT HEADING_IMAGE_WIDTH HEADING_IMAGE_HEIGHT SUBCATEGORY_IMAGE_WIDTH SUBCATEGORY_IMAGE_HEIGHT CONFIG_CALCULATE_IMAGE_SIZE IMAGE_REQUIRED ACCOUNT_GENDER ACCOUNT_DOB ACCOUNT_COMPANY ACCOUNT_SUBURB ACCOUNT_STATE MODULE_PAYMENT_INSTALLED MODULE_ORDER_TOTAL_INSTALLED MODULE_SHIPPING_INSTALLED MODULE_PAYMENT_COD_STATUS MODULE_PAYMENT_COD_ZONE MODULE_PAYMENT_COD_SORT_ORDER MODULE_PAYMENT_COD_ORDER_STATUS_ID MODULE_ORDER_TOTAL_LOWORDERFEE_FEE MODULE_ORDER_TOTAL_LOWORDERFEE_DESTINATION MODULE_ORDER_TOTAL_LOWORDERFEE_TAX_CLASS MODULE_ORDER_TOTAL_LOWORDERFEE_ORDER_UNDER MODULE_ORDER_TOTAL_LOWORDERFEE_SORT_ORDER MODULE_ORDER_TOTAL_LOWORDERFEE_LOW_ORDER_FEE MODULE_SHIPPING_FLAT_STATUS MODULE_SHIPPING_FLAT_COST MODULE_SHIPPING_FLAT_TAX_CLASS MODULE_SHIPPING_FLAT_ZONE MODULE_SHIPPING_FLAT_SORT_ORDER DEFAULT_CURRENCY DEFAULT_LANGUAGE DEFAULT_ORDERS_STATUS_ID MODULE_ORDER_TOTAL_SHIPPING_STATUS MODULE_ORDER_TOTAL_SHIPPING_SORT_ORDER MODULE_ORDER_TOTAL_SHIPPING_FREE_SHIPPING MODULE_ORDER_TOTAL_SHIPPING_FREE_SHIPPING_OVER MODULE_ORDER_TOTAL_SHIPPING_DESTINATION MODULE_ORDER_TOTAL_SUBTOTAL_STATUS MODULE_ORDER_TOTAL_SUBTOTAL_SORT_ORDER MODULE_ORDER_TOTAL_TAX_STATUS MODULE_ORDER_TOTAL_TAX_SORT_ORDER MODULE_ORDER_TOTAL_TOTAL_STATUS MODULE_ORDER_TOTAL_TOTAL_SORT_ORDER SHIPPING_ORIGIN_COUNTRY SHIPPING_ORIGIN_ZIP SHIPPING_MAX_WEIGHT SHIPPING_BOX_WEIGHT SHIPPING_BOX_PADDING PRODUCT_LIST_IMAGE PRODUCT_LIST_MANUFACTURER PRODUCT_LIST_MODEL PRODUCT_LIST_NAME PRODUCT_LIST_PRICE PRODUCT_LIST_QUANTITY PRODUCT_LIST_WEIGHT PRODUCT_LIST_BUY_NOW PRODUCT_LIST_FILTER PREV_NEXT_BAR_LOCATION STOCK_CHECK STOCK_LIMITED STOCK_ALLOW_CHECKOUT STOCK_MARK_PRODUCT_OUT_OF_STOCK STOCK_REORDER_LEVEL STORE_PAGE_PARSE_TIME STORE_PAGE_PARSE_TIME_LOG STORE_PARSE_DATE_TIME_FORMAT DISPLAY_PAGE_PARSE_TIME STORE_DB_TRANSACTIONS USE_CACHE DIR_FS_CACHE EMAIL_TRANSPORT EMAIL_LINEFEED EMAIL_USE_HTML ENTRY_EMAIL_ADDRESS_CHECK SEND_EMAILS DOWNLOAD_ENABLED DOWNLOAD_BY_REDIRECT DOWNLOAD_MAX_DAYS DOWNLOAD_MAX_COUNT GZIP_COMPRESSION GZIP_LEVEL SESSION_WRITE_DIRECTORY SESSION_FORCE_COOKIE_USE SESSION_CHECK_SSL_SESSION_ID SESSION_CHECK_USER_AGENT SESSION_CHECK_IP_ADDRESS SESSION_BLOCK_SPIDERS SESSION_RECREATE MODULE_PAYMENT_MONEYORDER_STATUS MODULE_PAYMENT_MONEYORDER_PAYTO MODULE_PAYMENT_MONEYORDER_SORT_ORDER MODULE_PAYMENT_MONEYORDER_ZONE MODULE_PAYMENT_MONEYORDER_ORDER_STATUS_ID MODULE_ORDER_TOTAL_LOWORDERFEE_STATUS MODULE_PAYMENT_CC_STATUS MODULE_PAYMENT_CC_EMAIL MODULE_PAYMENT_CC_SORT_ORDER MODULE_PAYMENT_CC_ZONE MODULE_PAYMENT_CC_ORDER_STATUS_ID

[♥geoffreywalton]

http://wiki.oscdox.com/ might help too.

 

The phpxref is old and doesn't seen to include all tables but it is a start.

[♥FWR Media]

Simpler method . .

 

catalog/inludes/header.php directly after the starting <?php .. ADD

// REMOVE ME
if ( array_key_exists('constants', $_GET) ){
 $constantsArray = get_defined_constants( true );
 echo '<h2>Displaying osCommerce Constants</h2>' . PHP_EOL;
 foreach( $constantsArray as $mainGroup => $array ){
if( $mainGroup == 'user' ){
  echo '<pre>';
  print_r( $array ) . '<hr><br>';
  echo '</pre>';
}
 }
}
// END REMOVE ME

 

Now if you access your site and add to the querystring ?constants you will get the constants printout .. no query no fuss.

 

e.g. http://www.mysite.com/index.php?constants

Don't forget to remove the code after use.