Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

Oscommerce 2.3 - Column left and right


Guest

Recommended Posts

Hi all

 

any idea where the column_left and right php files have gone no longer in the includes folder in this version as I am trying to install a feedback contribution for my store.

 

I know that most of the boxes are now controlled from the admin..

 

Any help or comments appreciated.

 

Thanks in advance

 

Sligoman

Link to comment
Share on other sites

Hi Praful

 

Thanks for that managed to make a box but still don't know how to intergrate with the contributions that I downloaded.

 

I have marked the areas in bold text asthis is the onstep that cannot be completed with OSC 2.3

 

Thanks in advance

 

and also thanks to Aleksander

 

##################################################

 

JustBought Box

by Johannes Teitge, info@@tmedia.de

 

included on http://www.christiani.de/show

 

06/2004

 

##################################################

 

 

With this box you can show the latest bought products within a defined seconds.

To change the time use admin on Maximum Values and set Seconds of last purchase.

 

####################################################################################################

MYSQL Add

####################################################################################################

 

INSERT INTO configuration VALUES ('','Show Header of last purchase','JUSTBOUGHT_SHOWHEADER','true','Show Header of last purchase',3,0,'2004-05-11 18:14:50','2004-05-11 15:11:31',NULL,'tep_cfg_select_option(array(\'true\', \'false\'),');

INSERT INTO configuration VALUES ('','Seconds of last purchase','JUSTBOUGHT_SECONDS','31622400','Set the time range to show the last bought products',3,0,'2004-05-11 18:14:50','2004-05-11 15:11:31',NULL,NULL);

 

 

 

####################################################################################################

Copy justbought.php to /includes/boxes

####################################################################################################

 

 

####################################################################################################

includes/column_right.php or includes/column_left.php Modification

####################################################################################################

 

copy the following line on the place where you want:

 

require(DIR_WS_BOXES . 'justbought.php');

 

####################################################################################################

includes/languages/english.php Modification

####################################################################################################

 

// JUSTBOUGHT by Johannes Teitge

define('BOX_HEADING_BM_JUSTBOUGHT','just bought...');

define('BOX_TEXT_BM_JUSTBOUGHT','A customer just bought the following product:');

// JUSTBOUGHT by Johannes Teitge EOF

 

 

 

And the other contribution

 

Installation

  • Step 1 Backup --- Backup --- Backup
    • Backup your files and database before changing

    [*]Step 2

     

     

     

    Run this SQL in your Database:

     

    # # Table structure for table `feedback` #

     

     

    CREATE TABLE `feedback` ( `feedback_id` int(11) NOT NULL auto_increment, `feedback_name` varchar(30) default NULL, `feedback_company_name` varchar(30) default NULL, `feedback_contact` varchar(50) NOT NULL, `feedback_text` text character set, `feedback_rating` int(11) default NULL, `feedback_status` tinyint(1) NOT NULL default '0', `customer_id` int(11) default NULL, `date_added` datetime NOT NULL, PRIMARY KEY (`feedback_id`) );

     

     

    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 ('', 'Display Feedback ', 'FEEDBACK_DISPLAY', 'true', 'This is used to set on or off the Feedback on front End', '1', '30', NULL , '2009-03-18 12:12:12', NULL , 'tep_cfg_select_option(array(\'true\', \'false\'),');

     

    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 ('', 'Maximum No of Feedbacks ', 'MAX_FEEDBACK', '2', 'It sets the max no of feedbacks to show on the home page', '3', '30', NULL , '2009-03-18 12:12:12', NULL , NULL);

     

     

    ADMIN CHANGES

     

    In:

     

    catalog/admin/includes/boxes/customers.php

     

    Find:

     

     

    < a href="' . tep_href_link(FILENAME_ORDERS, '', 'NONSSL') . '" class="menuBoxContentLink">' . BOX_CUSTOMERS_ORDERS . '');

     

     

    Replace With:

     

     

    < a href="' . tep_href_link(FILENAME_ORDERS, '', 'NONSSL') . '" class="menuBoxContentLink">' . BOX_CUSTOMERS_ORDERS . '

    ' . '< a href="' . tep_href_link(FILENAME_FEEDBACK, '', 'NONSSL') . '" class="menuBoxContentLink">' . BOX_CUSTOMERS_FEEDBACK . '');

     

     

    In:

     

    catalog/admin/includes/boxes/filenames.php

     

    Add At last before ?>:

     

     

     

    //Store Feedback Contrib

     

    define('FILENAME_FEEDBACK', 'feedback.php');

     

    //EOF Store Feedback Contrib

     

     

     

    In:

     

    catalog/admin/includes/languages/english.php

     

     

     

    Find near about line 122:

     

    define('BOX_CUSTOMERS_ORDERS', 'Orders');

     

     

     

    Add below it:

     

     

     

    //Store Feedback

     

    define('BOX_CUSTOMERS_FEEDBACK','Feedback');

    //EO Store Feedback

     

     

    In:

     

    catalog/admin/includes/database_tables.php

     

    Add At last before ?>:

     

    define('TABLE_FEEDBACK', 'feedback');

     

     

     

    In:

    catalog/admin/includes/functions/general.php

    Add At last before ?>:

     

    function tep_customers_name($customers_id) { if($customers_id == '') return 'Guest'; $customers = tep_db_query("select customers_firstname, customers_lastname from " . TABLE_CUSTOMERS . " where customers_id = '" . (int)$customers_id . "'"); $customers_values = tep_db_fetch_array($customers); return $customers_values['customers_firstname'] . ' ' . $customers_values['customers_lastname']; }

     

     

     

    FRONT END CHANGES

     

    In:

    catalog/includes/column_right.php

    Add At Last Above ?> :

     

    // BEGIN Store Feedback

    if(FEEDBACK_DISPLAY == 'true')

    require(DIR_WS_BOXES . 'feedback.php');

    // END Store Feedback

     

     

    In:

    catalog/includes/database_tables.php

    Add At last before ?>:

     

     

    define('TABLE_FEEDBACK', 'feedback');

     

    In:

    catalog/includes/boxes/filenames.php

    Add At last before ?>:

     

    //Store Feedback Contrib

    define('FILENAME_FEEDBACK', 'feedback.php');

    //EOF Store Feedback Contrib

    In:

     

    catalog/includes/languages/english.php

    Add at last above ?>:

    //Store Feedback

    define('SHOP_FEEDBACK_TITLE', 'Store Feedback');

    //EO Store Feedback

Link to comment
Share on other sites

Hi Praful

 

As I have upgraded to OSC 2.3 I was hoping to have these Two contributions running again as I have used these for years so a bit disapionted that they are not compatible hopefully someone may upgrade them to work with OSC 2.3

 

These are the contributions:

 

http://addons.oscommerce.com/info/6550

http://addons.oscommerce.com/info/2205

 

Obveiously these are for OSC 2.2

 

Again thank you for your reply

Link to comment
Share on other sites

Archived

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

×
×
  • Create New...