osCmax v2.5 User Manual
Page 1 of 2 12 LastLast
Results 1 to 10 of 13

i need to customize in php

This is a discussion on i need to customize in php within the osCmax v2 Customization/Mods forums, part of the osCmax v2.0 Forums category; i have make one column in product and picture box table so i need to make some change in main ...

      
  1. #1
    Member
    Join Date
    Jan 2011
    Posts
    53
    Rep Power
    2


    Default i need to customize in php

    i have make one column in product and picture box table so i need to make some change in main page can u help me i need to know where is php code for top picture i have attach one picture check that, i have mark in 2 colors red is main product show and other is slid image, i need to know where select statement use for this 2 table, i need to add this code WHERE MY_COLUMN = 1 then show this product other wise no, and other thing is that that i need to add banner on right and left top, and in footer please can u tell me where is file for that also , any ways i am using oscmax v2.5beta3
    sorry here is image
    Last edited by saad_sinpk; 02-03-2011 at 12:24 PM.

  2. #2
    osCMax Development Team
    ridexbuilder's Avatar
    Join Date
    Jul 2008
    Location
    Haggisland
    Posts
    3,014
    Rep Power
    36


    Default Re: i need to customize in php

    RTFM
    Hosting plans with installation, configuration, contributions, support and maintenance.

  3. #3
    Member
    Join Date
    Jan 2011
    Posts
    53
    Rep Power
    2


    Default Re: i need to customize in php

    what do u mean by rtfm ?

  4. #4
    osCMax Development Team
    ridexbuilder's Avatar
    Join Date
    Jul 2008
    Location
    Haggisland
    Posts
    3,014
    Rep Power
    36


    Default Re: i need to customize in php

    u??? d'uh, wiki
    Hosting plans with installation, configuration, contributions, support and maintenance.

  5. #5
    Member
    Join Date
    Jan 2011
    Posts
    53
    Rep Power
    2


    Default Re: i need to customize in php

    ok sorry i think in this u can help me i am getting this error in category page
    1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '-0, MAX_CATALOG_DISPLAY_SEARCH_RESULTS' at line 1

    select p.products_model, m.manufacturers_name, pd.products_name, p.products_image, pd.products_short, p.products_id, p.manufacturers_id, p.products_msrp, p.products_price, p.products_tax_class_id, p.products_featured, p.products_quantity, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price from products_description pd, products p left join manufacturers m on p.manufacturers_id = m.manufacturers_id left join specials_retail_prices s on p.products_id = s.products_id, products_to_categories p2c left join categories c using(categories_id) where p.products_status = '1' and p.products_id = p2c.products_id and pd.products_id = p2c.products_id and pd.language_id = '1' and p2c.categories_id = '32' and find_in_set('0', products_hide_from_groups) = 0 and find_in_set('0', c.categories_hide_from_groups) = 0 order by pd.products_name limit -0, MAX_CATALOG_DISPLAY_SEARCH_RESULTS
    and this error in search
    1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '-0, MAX_CATALOG_DISPLAY_SEARCH_RESULTS' at line 1

    select distinct p.products_model, m.manufacturers_name, p.products_image, m.manufacturers_id, p.products_quantity, p.products_featured, p.products_id, pd.products_name, p.products_price, p.products_tax_class_id, NULL as specials_new_products_price, NULL as final_price from products p left join manufacturers m using(manufacturers_id), products_description pd, categories c, products_to_categories p2c where p.products_status = '1' and p.products_id = pd.products_id and pd.language_id = '1' and p.products_id = p2c.products_id and p2c.categories_id = c.categories_id and ((pd.products_name like '%test%' or p.products_model like '%test%' or m.manufacturers_name like '%test%' or pd.products_description like '%test%') ) and find_in_set('0', products_hide_from_groups) = 0 and find_in_set('0', categories_hide_from_groups) = 0 order by pd.products_name limit -0, MAX_CATALOG_DISPLAY_SEARCH_RESULTS

    [TEP STOP]

  6. #6
    Senior Member blackhawk's Avatar
    Join Date
    Aug 2009
    Location
    indiana
    Posts
    640
    Blog Entries
    1
    Rep Power
    27


    Default Re: i need to customize in php

    I think he meant, read the friendly manual

  7. #7
    Member
    Join Date
    Jan 2011
    Posts
    53
    Rep Power
    2


    Default Re: i need to customize in php

    ok i will read that but can u tell me why i am getting this error i don't think i will answer of this error in wiki or friendly manual

  8. #8
    Senior Member blackhawk's Avatar
    Join Date
    Aug 2009
    Location
    indiana
    Posts
    640
    Blog Entries
    1
    Rep Power
    27


    Default Re: i need to customize in php

    Trouble understanding you. Explain in a simple way what is your goal with the blue highlighted section you have in the image? What do you want there?
    Last edited by blackhawk; 02-03-2011 at 02:55 PM.

  9. #9
    Member
    Join Date
    Jan 2011
    Posts
    53
    Rep Power
    2


    Default Re: i need to customize in php

    see i have make new column in products database and slideshow databases table, now i want that if that column = 1 then show that product and slideshow otherwise no can u tell tell me where i add that code, in blue line there is slideshow and in red there is product

  10. #10
    osCMax Development Team
    pgmarshall's Avatar
    Join Date
    Feb 2009
    Location
    London
    Posts
    2,678
    Rep Power
    49


    1 out of 1 members found this post helpful.

    Default Re: i need to customize in php

    saad_sinpk,

    You really need to read the wiki (properly) and spend a bit of time working out how the code works before posting almost unintelligible questions about your store setup.

    You also need to make sure that when you are running off the SVN (which you are) that you update your database (every time) - either reinstall all patch through phpMyAdmin.

    MAX_CATALOG_DISPLAY_SEARCH_RESULTS is a new config setting introduced to split the max result count between admin and catalog - so if you don't upgrade your dbase whilst running SVN you are going to get a whole load of errors.

    Spend some time working it out for yourself before posting ... you will learn more in the long run and be able to build a better store.

    Or - simply wait for the stable release ...
    pgmarshall
    _______________________________

Page 1 of 2 12 LastLast

Similar Threads

  1. tep_draw_input_field -Location? customize? where?
    By Luggruff in forum osCmax v2 Customization/Mods
    Replies: 0
    Last Post: 04-05-2007, 04:17 AM
  2. Customize Center Section on Main Page
    By keithxtreme in forum osCommerce 2.2 Modification Help
    Replies: 3
    Last Post: 03-28-2004, 08:29 PM
  3. Customize Center Section on Main Page
    By keithxtreme in forum osCmax v1.7 Discussion
    Replies: 2
    Last Post: 03-28-2004, 02:33 PM
  4. How to customize the new products center block?
    By alexfize in forum osCmax v1.7 Discussion
    Replies: 0
    Last Post: 11-30-2003, 12:11 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •