SELECT * FROM oc_layout_module WHERE layout_id = '10' AND position = 'header_extra_info' ORDER BY sort_order

SELECT * FROM oc_layout_module WHERE layout_id = '10' AND position = 'header_top' ORDER BY sort_order

SELECT * FROM oc_layout_module WHERE layout_id = '10' AND position = 'column_left' ORDER BY sort_order

Array
(
)

SELECT * FROM oc_layout_module WHERE layout_id = '10' AND position = 'column_right' ORDER BY sort_order

SELECT * FROM oc_layout_module WHERE layout_id = '10' AND position = 'content_top' ORDER BY sort_order

SELECT * FROM oc_layout_module WHERE layout_id = '10' AND position = 'content_bottom' ORDER BY sort_order

SELECT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '0' AND cd.language_id = '1' AND c2s.store_id = '0'  AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)

SELECT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '263531' AND cd.language_id = '1' AND c2s.store_id = '0'  AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)

Affiliate Program

Affiliate Program

If you already have an account with us, please login at the login page.

To create an affiliate account, fill in the form below ensuring you complete all the required fields:

Your Personal Details

First Name

Last Name

E-Mail

Telephone

Fax

Your Address Details

Company

Web Site

Address 1

Address 2

City

Post Code

Country

Region / State

Payment Information

Tax ID

Payment Method

Cheque

PayPal

Bank Transfer

Cheque Payee Name

PayPal Email Account

Bank Name

ABA/BSB number (Branch Number)

SWIFT Code

Account Name

Account Number

Your Password

Password

Password Confirm

I have read and agree to the About Us