Jump to content

Dan Coates

Members
  • Content count

    14
  • Joined

  • Last visited

1 Follower

Profile Information

  • Real Name
    Daniel Coates
  • Website
  1. Dan Coates

    "Dynamenu" for osCommerce

    Firstly, great contribution! Although I do have a slight problem with it, I am using style 1 (the vertical fly out menu), when I put the menu in column_left.php it works fine, i.e. all categories show a small arrow after them and when you hover over them the sub menu flies out. (I included as stated the footer tag in the footer for the page) But when I place it inside my own template them menu displays, but each category does not have an arrow after it, this only appears when you click the category, also the flyout only happens when you click the category not when you hover over it? Does anyone have any idea what i've done wrong? and yes I've included the footer tage in my own template as well. All styles and everything work just great, it seems very strange (I am using STS 4 contrib to make my templates) but each template this system generates still includes footer.php from the OSC includes directory which is the same file I use when it works with thedefault template. Cany anyone help? has anyone here used this contrib in conjunction with STS 4? Regards Dan
  2. Dan Coates

    [contribution] Simple Template System (sts)

    Can anyone tell me how I can alter the page which is displayed when you enter a section or sub-section using STS 4, say Graphics cards? i want to alter how it displays the items in that section, but the file it uses is index.php?cPath=1_4 If I create a file called index.php_1_4.html or however you do the extensions, it doesn't use this template? instead it shows me what I have set as the default template? How can I do this, I have all other pages altered i.e. front page, product page, checkout etc... using STS v4 but I can't alter the category or sub category section pages because they are a version of index.php could somebody please exaplain what I am doing wrong? Regards Daniel Coates
  3. Dan Coates

    Wishlist 3.0 Support Thread

    Having a wishlist problem! I installed the latest version of wishlist ona fresh install of OSC MS2, it all works except when you add an item to the list I get this error on the wishlist page, its just above the list headings, and doesn't show the item I added. It also appears in the wishlist box and when you click on the 'my wishlist' link. 1054 - Unknown column 'p.products_id' in 'on clause' select pd.products_id, pd.products_name, pd.products_description, p.products_image, p.products_status, p.products_price, p.products_tax_class_id, 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 p, products_description pd left join specials s on p.products_id = s.products_id where pd.products_id = '9' and p.products_id = pd.products_id and pd.language_id = '1' order by products_name [TEP STOP] I hope someone can tell me what i'm doin wrong! Also I have a little featurer suggestion: It would be good if you could see customers wishlists, you could then send them an email of any special offers, if you were feeling like it! Or a list in admin of the most popular wishes and you could then base your promotions on this info.... Regards, Dan
  4. I also ge tthe same problem when I tried to install the Products Extra Fields with ACA, I resorted to installing it manuall which works although the search function doesn't (I posted a question on this in the forum). My error was : Warning: include(C:/amp/xampp/htdocs/catalog/admin/includes/languages/english/modules/products/extra_fields.php) [function.include]: failed to open stream: No such file or directory in C:\amp\xampp\htdocs\catalog\admin\modules.php on line 149 Warning: include() [function.include]: Failed opening 'C:/amp/xampp/htdocs/catalog/admin/includes/languages/english/modules/products/extra_fields.php' for inclusion (include_path='.;C:\amp\xampp\php\pear\') in C:\amp\xampp\htdocs\catalog\admin\modules.php on line 149 Fatal error: Call to undefined method extra_fields::check() in C:\amp\xampp\htdocs\catalog\admin\modules.php on line 155 Regards, Dan
  5. I forgot to remove the and from the code block near the top of my post when I wrote this post, I did not include those in the file when I tried to install it, so I still have a problem (that was not it). Dan
  6. Dear All, I like the gift voucher / coupon contribution very much, I have a few suggestions for the next version and a request. First the request is this, Can somebody please please write a manual install guide, as it is completely useless if like me you have 20 other contributions installed. The only reason I have tested it was because I created a new shop on a virtual server. I know you can use a comparision program but that is not that easy with lots of contribs. My suggestions for future products are: First Suggestion Have a redeem button on the page for the particular order, that way you don?t have to remember to go to two places (incase your forget to un-queue items if you have alot of orders) Second Suggestion Have a voucher purchase that has to be either emailed to someone or posted to someone, you purchase it and it is sent to the delivery address, in admin it pops up in the queue, you release it if it was an electronic voucher (this would be a question at checkout i.e. what type of voucher would you like, e-voucher or postal, they then select the option and then either enter the email details or have an option that says send to same delivery address as rest of parcel or send to another, they then get to enter the other address) After all how many people purchase a voucher for themselves? and if you did email it to somebody they most likely think it was junk mail and delete it, even so If you do email it wouldn't it be better to give the customer the option to do it at checkout, instead of going to there account. Most people want a 'real' paper/card etc.. voucher posted to them so they can include it inside a birthday card etc... When you view the order if it was a postal voucher there is a button linking to a template which you can customise, that displays a voucher to print out with the unique voucher identifier number incorporated into it for that order, which can only be used once by anyone, you can then print this and post it, or if you choose take the identifier and enter it into a program which makes vouchers etc? In the order it could also display the voucher number, not for them just for the owner, so the owner doesn't have to click the template button if he is using the number elesewhere. If the voucher was electronic you have the option of saying queued or not and if it was postal it is automatically not queued. Also if an e-voucher it will send an email out saying that it has not been activated yet please allow X hours which you as owner can enter, also can alter the email template, just like the one when it has been activated but saying it will take up to X long to activate. Third Suggestion Facility to see vouchers connected to an order and delete it if they choose to cancel the order, if it has been activated, if it hasn?t choose to have that voucher number banned and added to a banned list, (make sure the number generator checks this list to make sure it doesn?t come up with one on it) (ability to backup this list) Fourth Suggestion Option to see each customers balance and alter it if needs be, in admin Fifth Suggestion Ability to set maximum voucher amount their account can have assigned to it, if it reaches the limit send an email saying please spend some of your account before registering activating another voucher. Sixth Suggestion Vouchers Bought List with totals of how many and total amount purchased Seventh Suggestion Total amount purchased and sent for emailed vouchers Last Suggestion! Coupons Used, and Values of Different Coupons Used, so you know how much its cost you etc?totals etc? Sorry for the long list! I'm good with ideas but not very good with php! I can do very basic stuff but nothing more otherwise I'd implement these features myself. I hope someone can implement them. Regards, Dan
  7. All, I'm having some problems getting my products extra fields contribution to work, I can install and use it fine. using manual install on virgin OSC MS2 shop. However, when try searching for anything, not just extra field content I get this error: 1066 - Not unique table/alias: 'pd' select count(distinct p.products_id) as total from (products p left join products_to_products_extra_fields p2pef on p.products_id=p2pef.products_id) left join manufacturers m on m.manufacturers_id=p.manufacturers_id, products_description pd left join specials s on p.products_id = s.products_id, categories c, products_to_categories p2c, 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 '%matrox%' or p.products_model like '%matrox%' or m.manufacturers_name like '%matrox%' or p2pef.products_extra_fields_value like '%matrox%') ) [TEP STOP] If I use the original advanced_search_result.php the search works but obviously doesn?t search the extra fields, this is the code that?s altered in the advanced_search_result.php: The installation file says to replace this line: $from_str = "from " . TABLE_PRODUCTS . " p left join " . TABLE_MANUFACTURERS . " m using(manufacturers_id), " . TABLE_PRODUCTS_DESCRIPTION . " pd left join " . TABLE_SPECIALS . " s on p.products_id = s.products_id, " . TABLE_CATEGORIES . " c, " . TABLE_PRODUCTS_TO_CATEGORIES . " p2c"; The above line does not exist in OSC MS2? with // START: Extra Fields Contribution $from_str = "from (" . TABLE_PRODUCTS . " p left join " . TABLE_PRODUCTS_TO_PRODUCTS_EXTRA_FIELDS . " p2pef on p.products_id=p2pef.products_id) left join " . TABLE_MANUFACTURERS . " m on m.manufacturers_id=p.manufacturers_id, " . TABLE_PRODUCTS_DESCRIPTION . " pd left join " . TABLE_SPECIALS . " s on p.products_id = s.products_id, " . TABLE_CATEGORIES . " c, " . TABLE_PRODUCTS_TO_CATEGORIES . " p2c"; // END: Extra Fields Contribution However, there are two lines which makeup the above lines and these are: [u]$from_str = "from " . TABLE_PRODUCTS . " p left join " . TABLE_MANUFACTURERS . " m using(manufacturers_id) left join " . TABLE_SPECIALS . " s on p.products_id = s.products_id";[/u] if ( (DISPLAY_PRICE_WITH_TAX == 'true') && (tep_not_null($pfrom) || tep_not_null($pto)) ) { if (!tep_session_is_registered('customer_country_id')) { $customer_country_id = STORE_COUNTRY; $customer_zone_id = STORE_ZONE; } $from_str .= " left join " . TABLE_TAX_RATES . " tr on p.products_tax_class_id = tr.tax_class_id left join " . TABLE_ZONES_TO_GEO_ZONES . " gz on tr.tax_zone_id = gz.geo_zone_id and (gz.zone_country_id is null or gz.zone_country_id = '0' or gz.zone_country_id = '" . (int)$customer_country_id . "') and (gz.zone_id is null or gz.zone_id = '0' or gz.zone_id = '" . (int)$customer_zone_id . "')"; } [u]$from_str .= ", " . TABLE_PRODUCTS_DESCRIPTION . " pd, " . TABLE_CATEGORIES . " c, " . TABLE_PRODUCTS_TO_CATEGORIES . " p2c";[/u] Does it mean replace both the underlined lines with the one in the installation file, or delete both of these lines and replace them with the piece of code out of the installation file? Surely that will effect the script, as each line is from a different section? The second part that has to be altered is this instead of: $where_str .= "(pd.products_name like '%" . tep_db_input($keyword) . "%' or p.products_model like '%" . tep_db_input($keyword) . "%' or m.manufacturers_name like '%" . tep_db_input($keyword) . "%'"; The install says place this: // START: Extra Fields Contribution $where_str .= "(pd.products_name like '%" . tep_db_input($keyword) . "%' or p.products_model like '%" . tep_db_input($keyword) . "%' or m.manufacturers_name like '%" . tep_db_input($keyword) . "%' or p2pef.products_extra_fields_value like '%" . tep_db_input($keyword) . "%'"; // END: Extra Fields Contribution Is there anything wrong with this code? AS I said everything else works perfectly, just the problems with the coding for the search featurer. This contribution was tried multiple times on a virgin install of OSC MS2. Hope somebody can help. Regards, Dan
  8. Dear All, I tried to install autologon 1.08 last night on a clean OSC MS2 Install and I thought it all went well with the code insertions, ive tried installing it 3 times now but when I go to my main page I revieve this error printed across the top of my screen: Warning: session_start() [function.session-start]: Cannot send session cookie - headers already sent by (output started at C:\Program Files\xampp\htdocs\Osc\catalog\includes\filenames.php:67) in C:\Program Files\xampp\htdocs\Osc\catalog\includes\functions\sessions.php on line 97 Warning: session_start() [function.session-start]: Cannot send session cache limiter - headers already sent (output started at C:\Program Files\xampp\htdocs\Osc\catalog\includes\filenames.php:67) in C:\Program Files\xampp\htdocs\Osc\catalog\includes\functions\sessions.php on line I've looked in these files and can't see anything wrong, also if I turn the autologon system off in admin I get the following arror on the same page: Warning: session_start() [function.session-start]: Cannot send session cookie - headers already sent by (output started at C:\Program Files\xampp\htdocs\Osc\catalog\includes\filenames.php:67) in C:\Program Files\xampp\htdocs\Osc\catalog\includes\functions\sessions.php on line 97 Warning: session_start() [function.session-start]: Cannot send session cache limiter - headers already sent (output started at C:\Program Files\xampp\htdocs\Osc\catalog\includes\filenames.php:67) in C:\Program Files\xampp\htdocs\Osc\catalog\includes\functions\sessions.php on line 97 Warning: Cannot modify header information - headers already sent by (output started at C:\Program Files\xampp\htdocs\Osc\catalog\includes\filenames.php:67) in C:\Program Files\xampp\htdocs\Osc\catalog\includes\application_top.php on line 517 Warning: Cannot modify header information - headers already sent by (output started at C:\Program Files\xampp\htdocs\Osc\catalog\includes\filenames.php:67) in C:\Program Files\xampp\htdocs\Osc\catalog\includes\application_top.php on line 518 Does anyone know what i have done wrong, or maybe I have missed something. Thanks in advance Daniel Coates
  9. Dear All, I like the gift voucher / coupon contribution very much, I have a few suggestions for the next version and a request. First the request is this, Can somebody please please write a manual install guide, as it is completely useless if like me you have 20 other contributions installed. The only reason I have tested it was because I created a new shop on a virtual server. My suggestions for future products are: First Suggestion Have a redeem button on the page for the particular order, that way you don?t have to remember to go to two places (incase your forget to un-queue items if you have alot of orders) Second Suggestion Have a voucher purchase that has to be either emailed to someone or posted to someone, you purchase it and it is sent to the delivery address, in admin it pops up in the queue, you release it if it was an electronic voucher (this would be a question at checkout i.e. what type of voucher would you like, e-voucher or postal, they then select the option and then either enter the email details or have an option that says send to same delivery address as rest of parcel or send to another, they then get to enter the other address) After all how many people purchase a voucher for themselves? and if you did email it to somebody they most likely think it was junk mail and delete it, even so If you do email it wouldn't it be better to give the customer the option to do it at checkout, instead of going to there account. Most people want a 'real' paper/card etc.. voucher posted to them so they can include it inside a birthday card etc... When you view the order if it was a postal voucher there is a button linking to a template which you can customise, that displays a voucher to print out with the unique voucher identifier number incorporated into it for that order, which can only be used once by anyone, you can then print this and post it, or if you choose take the identifier and enter it into a program which makes vouchers etc? In the order it could also display the voucher number, not for them just for the owner, so the owner doesn't have to click the template button if he is using the number elesewhere. If the voucher was electronic you have the option of saying queued or not and if it was postal it is automatically not queued. Also if an e-voucher it will send an email out saying that it has not been activated yet please allow X hours which you as owner can enter, also can alter the email template, just like the one when it has been activated but saying it will take up to X long to activate. Third Suggestion Facility to see vouchers connected to an order and delete it if they choose to cancel the order, if it has been activated, if it hasn?t choose to have that voucher number banned and added to a banned list, (make sure the number generator checks this list to make sure it doesn?t come up with one on it) (ability to backup this list) Fourth Suggestion Option to see each customers balance and alter it if needs be, in admin Fifth Suggestion Ability to set maximum voucher amount their account can have assigned to it, if it reaches the limit send an email saying please spend some of your account before registering activating another voucher. Sixth Suggestion Vouchers Bought List with totals of how many and total amount purchased Seventh Suggestion Total amount purchased and sent for emailed vouchers Last Suggestion! Coupons Used, and Values of Different Coupons Used, so you know how much its cost you etc?totals etc? Sorry for the long list! I'm good with ideas but not very good with php! I can do very basic stuff but nothing more otherwise I'd implement these features myself. I hope someone can implement them. Regards, Dan
  10. Dan Coates

    Autologon

    Dear All, I tried to install autologon 1.08 last night and I thought it all went well with the code insertions, ive checked them 3 times now but when I go to my main page I revieve this error printed across the top of my screen: Warning: session_start() [function.session-start]: Cannot send session cookie - headers already sent by (output started at C:\Program Files\xampp\htdocs\Osc\catalog\includes\filenames.php:67) in C:\Program Files\xampp\htdocs\Osc\catalog\includes\functions\sessions.php on line 97 Warning: session_start() [function.session-start]: Cannot send session cache limiter - headers already sent (output started at C:\Program Files\xampp\htdocs\Osc\catalog\includes\filenames.php:67) in C:\Program Files\xampp\htdocs\Osc\catalog\includes\functions\sessions.php on line I've looked in these files and can't see anything wrong, also if I turn the autologon system off in admin I get the following arror on the same page: Warning: session_start() [function.session-start]: Cannot send session cookie - headers already sent by (output started at C:\Program Files\xampp\htdocs\Osc\catalog\includes\filenames.php:67) in C:\Program Files\xampp\htdocs\Osc\catalog\includes\functions\sessions.php on line 97 Warning: session_start() [function.session-start]: Cannot send session cache limiter - headers already sent (output started at C:\Program Files\xampp\htdocs\Osc\catalog\includes\filenames.php:67) in C:\Program Files\xampp\htdocs\Osc\catalog\includes\functions\sessions.php on line 97 Warning: Cannot modify header information - headers already sent by (output started at C:\Program Files\xampp\htdocs\Osc\catalog\includes\filenames.php:67) in C:\Program Files\xampp\htdocs\Osc\catalog\includes\application_top.php on line 517 Warning: Cannot modify header information - headers already sent by (output started at C:\Program Files\xampp\htdocs\Osc\catalog\includes\filenames.php:67) in C:\Program Files\xampp\htdocs\Osc\catalog\includes\application_top.php on line 518 Does anyone know what i have done wrong, or maybe I have missed something. The only other contribution I have installed is Simple Template System Plus. Thanks in advance Daniel Coates
  11. Dear All, I tried to install autologon 1.08 last night and I thought it all went well with the code insertions, ive checked them 3 times now but when I go to my main page I revieve this error printed across the top of my screen: Warning: session_start() [function.session-start]: Cannot send session cookie - headers already sent by (output started at C:\Program Files\xampp\htdocs\Osc\catalog\includes\filenames.php:67) in C:\Program Files\xampp\htdocs\Osc\catalog\includes\functions\sessions.php on line 97 Warning: session_start() [function.session-start]: Cannot send session cache limiter - headers already sent (output started at C:\Program Files\xampp\htdocs\Osc\catalog\includes\filenames.php:67) in C:\Program Files\xampp\htdocs\Osc\catalog\includes\functions\sessions.php on line I've looked in these files and can't see anything wrong, also if I turn the autologon system off in admin I get the following arror on the same page: Warning: session_start() [function.session-start]: Cannot send session cookie - headers already sent by (output started at C:\Program Files\xampp\htdocs\Osc\catalog\includes\filenames.php:67) in C:\Program Files\xampp\htdocs\Osc\catalog\includes\functions\sessions.php on line 97 Warning: session_start() [function.session-start]: Cannot send session cache limiter - headers already sent (output started at C:\Program Files\xampp\htdocs\Osc\catalog\includes\filenames.php:67) in C:\Program Files\xampp\htdocs\Osc\catalog\includes\functions\sessions.php on line 97 Warning: Cannot modify header information - headers already sent by (output started at C:\Program Files\xampp\htdocs\Osc\catalog\includes\filenames.php:67) in C:\Program Files\xampp\htdocs\Osc\catalog\includes\application_top.php on line 517 Warning: Cannot modify header information - headers already sent by (output started at C:\Program Files\xampp\htdocs\Osc\catalog\includes\filenames.php:67) in C:\Program Files\xampp\htdocs\Osc\catalog\includes\application_top.php on line 518 Does anyone know what i have done wrong, or maybe I have missed something. The only other contribution I have installed is Simple Template System Plus. Thanks in advance Daniel Coates
×