Jump to content

RobAnderson

Members
  • Content count

    58
  • Joined

  • Last visited

Everything posted by RobAnderson

  1. RobAnderson

    Article Manager v1.0

    Please post any bugs and suggestions about Article Manager v1.0 in this topic. I will do my best to provide support. Thanks ;-) Rob Anderson
  2. Hi there, I have just added my very first contribution: Friendly Pricing v1.0 Description This contribution allows you to specify a friendly price for a product even though it may not be the default pricing currency. For example, let's say you want to sell some products targeted to a local market in one currency and want your prices to be friendly to your customers, e.g. 9.95 EURO. At the same time, you want to sell other products to a different market with friendly prices in a different currency, e.g. US $9.95. Now with the way OSC is currently set up, you can only specify friendly prices in the default currency. If a customer chooses another currency, then currency rates are applied and the prices get ugly, e.g. 12.67 EURO (and it will vary from day to day as the exchange rates change). So, what this contribution does is enable you to specify for each product a friendly currency other than the default. This is administered in the products page (categories.php) in the admin section. Friendly pricing works in perfectly with existing exchange rates and provided you have installed the currency in the admin section, you can specify a friendly price using that currency. If you subsequently delete the currency, prices will revert back to the default currency. Support has been built in for specials and all orders, reports and invoices have been modified to keep track of orders that may include a mixture of default and friendly pricing. Comments I am new to PHP programming (a pragmatist, not a purist), so I'm sure there may be more elegant ways to achieve the same results. If you can improve on my humble beginnings, then please contribute in this forum! Thank you, Rob Anderson
  3. RobAnderson

    Contribution: Friendly Pricing v1.0

    Hi Vladamir, I'm not sure if I entirely understand your question. If your default currency is rubles, and you are using the Friendly Pricing contribution with base currencies in USD, then yes, the ruble values will float with the currency. However, if you want nicely rounded prices in rubles, why not then just revert back to the default currency (rubles) for those products? Of course, if you do this, then the USD value will float with the currency - you can't have it both ways! (unless there is a contribution that allows currencies to be de-coupled, which could be very confusing for customers). Hope this helps, if not, please post more specific info and I'll try to help. Regards, Rob Anderson :)
  4. RobAnderson

    Contribution: Friendly Pricing v1.0

    Hi Martin, I can see what you're trying to do now and it makes perfect sense. However, I don't know of any contributions that allow that although I do know of some other people with the same requirements, e.g. moonfish (Dani). Looks like you might need to create a contribution that adds in this functionality. Time to learn PHP? ;-) Best of luck, Rob
  5. RobAnderson

    Contribution: Friendly Pricing v1.0

    Hi Martin, I don't think that the Friendly Pricing contribution will help in this case. If I understand you correctly, you are after the ability to set fixed prices for the same product in two currencies. What my contribution allows you to do is choose which currency you wish to fix the price in on a product by product basis, e.g. one product could have a fixed price of 29.90 Swiss Francs and another could have a fixed price of 19.90 Euro. However, having done this, the price will still vary from one currency to another (as you've discovered). What it doesn't allow you to do though, is create two fixed prices for the same product! Having said that, there may be one way around it with my contribution, and that would be to create a duplicate product and assign one a fixed price in one currency, e.g. 29.90 Swiss Francs and the other a fixed price in a different currency, e.g. 19.90 Euro. The only problem I can see with this is that this may cause confusion and people may wonder whether the products are actually the same as the relative prices would be different. You also open yourself up to the vagaries of currency changes, but I'm sure you're already aware of that. Sorry, that's about all I can suggest, except to keep looking for other contibutions that may have the functionality you're after (multiple-shops?). Cheers, Rob
  6. RobAnderson

    Articles mod messed up something

    Hi Billy, what Articles mod did you install (there are a few now)? Regards Rob
  7. RobAnderson

    Article Manager v1.0

    hmm, would it that hard to modify articles.php in your mod to do this? I mean, it's quite easy to order the articles by topic and date as it is, just by editing the 'ORDER BY' in the query. After that all I had to do would be to come up with a routine that lists the articles under each topic title. That way I could get rid of the topic name listed for each article on the right side of the page. I might also add that I don't use nested topic categories, just one level of them. Plus in the articles box, I have only All Articles listed. What do you think? Hi Juha, yeah, given that you're only dealing with one level of articles, then your suggestion would be the way to go. I guess I was thinking of multiple levels (and as you've seen from my bug fixes, there are some people out there that want 3+ levels of articles!!!). For my part, like you, I wrote this contribution with only one level in mind (but naturally wanted it to support more). Dang, OSC is so damn flexible, it's hard to cater for everybody ;-) Looking at what you're trying to do then, a simple sort by topics and then article name should do it with a bit of tweaking (removing the topics as you mentioned). The rest is just layout really which is straight HTML stuff. By all means send me some code if you get stuck. I'll try my best ;-) Regards, Rob BTW. How do you have only articles listed in the articles box, yet are using one level of topics. Did I miss something?
  8. RobAnderson

    Article Manager v1.0

    Hi Mike, that's a really good idea. A bit like the cross-sell module but related to topics instead of products. I'll add that to my list! Thanks very much for your suggestion, I'm going to have a lot of great ideas for the next version. I'm only sorry I don't have the time to devote to it right now (with Christmas looming). I hope you understand ;-) Regards, Rob
  9. RobAnderson

    Article Manager v1.0

    Hi Lonnie, about your search idea ;-) Hmmm, nice idea, a bit like a Yahoo directory and search combined. I was originally thinking of reproducing the default search fucntionality of OSC, i.e. search infobox and advanced search page, but I like your idea better (more functional). The problem is that it might stretch my programming skills a bit more, so if you're not in a hurry... Rob ;-)
  10. RobAnderson

    Article Manager v1.0

    Hi Juha, in response to your question: I think the best way to do this would be to modify the Browse by Categories contribution which is based on Categories/Products and change it to display Topics/Articles (the architecture is essentially the same). This should produce a similar layout to what you are after and could be inserted as a module in place of the default listing produced in the articles.php page. This may well be included in a future release, but sorry I don't have working example for you yet (Randy?). Regards, Rob
  11. RobAnderson

    Article Manager v1.0

    Article Manager v1.2 has just been released and includes a number of minor bug fixes. Please visit http://www.oscommerce.com/community/contributions,1709 to catch up on these. I would like to thank everybody who has posted suggestions for enhancements to this popular contribution (Randy et al ;-). A number of these are planned for Version 2 when I find the time to cobble them together! Suggestions include: - searching - ability to contribute articles - authors' page - lots of modules, e.g. - featured author, - news style listing - top 10 articles - topic lists See http://forums.oscommerce.com/index.php?sho...ndpost&p=270378 for a discussion on these and more... Please keep the great ideas coming ;-) Regards, Rob
  12. RobAnderson

    Article Manager v1.0

    Hi Lonnie, regarding plans for searching... I am working on this now and it will be along the lines of the products search, e.g. via a Search Articles box (optional) or a more advanced Search Articles page (with options to filter searches by topics, authors and dates). Basically a hack of the MS2 search facility ;-) I've done most of it, just need to tidy up a few things (search results) and test. Before I post, do you or others have any requests for what would be included in the search results, e.g. I'm thinking Article Name (duh), Author and Date Added. Do we need Topic and an Article Abstract?? Also, should I make these options that you can turn on or off in the admin like the basic article listing? Thoughts appreciated. Rob ;-)
  13. RobAnderson

    Article Manager v1.0

    Hi Jiten, in response to the problem deleting a topic: Yes this is a bug. To fix, in admin/includes/functions/articles.php, delete line 307, i.e. tep_db_query("delete from " . TABLE_ADDITIONAL_ARTICLE_IMAGES . " where articles_id = '" . (int)$article_id . "'"); That should enable topics that contain articles to be deleted successfully. Thanks for your help. Regards, Rob P.S. I'll roll this into v1.2 soon.
  14. RobAnderson

    Article Manager v1.0

    Excellent, I haven't had much experience with deep sites and multiple levels, so this was new for me (hence my shallow testing ;-). Just curious, I noticed there aren't similar links from the top level topics nor links going up to parent levels, so how useful is this (or have I hacked the default page too much - never did get my head around how it worked entirely!!!) Rob
  15. RobAnderson

    Article Manager v1.0

    Hi Kristofer, regarding your query: Yes it would. This fix is only required if you wish to display links to child-topics. Otherwise, just delete or comment them out and you won't have to worry about it. Glad to hear your alignment is sorted ;-) Rob
  16. RobAnderson

    Article Manager v1.0

    Hi David, regarding your question: I see no reason why not. In fact, based on other feedback, I'm getting a strong indication that a range of different modules might be in order to display articles in a range of different ways, e.g. simple articles listing for Home Page news feature, or Top 10 articles including number of times viewed. I will look at developing a few of these for Version 2 in the New Year. I simply don't have the time at the moment unfortunately. However, the basis of a module is in the catalog/articles_new.php page. You would just need to chop out the article listing part and then format it to suit. It could then be included in your Home Page quite easily. Regards, Rob ;-)
  17. RobAnderson

    Article Manager v1.0

    Hi Randy, in response to your hunt for cPath:-) $cPath in this case should be $tPath (I renamed everything I could to try and distinguish between categories c and topics t), but is generated from the wrong function, i.e. it is using the generic tep_get_path instead of tep_get_topic_path on line 138 of catalog/articles.php, i.e. $tPath_new = tep_get_path($topics['topics_id']); should be $tPath_new = tep_get_topic_path($topics['topics_id']); Try that. It does now generate a proper link to the child topic with no cPath in the URL. As mentioned earlier, I think the formatting of these links is poor and not well suited for moving between article topics. An alternative is to try my fix and do away with these links altogether. Rob P.S. Do you guys really need three or more levels of articles???
  18. RobAnderson

    Article Manager v1.0

    Hi Randy, thanks a lot for your considered feedback. I'm overwhelmed with the response so far and the great ideas keep coming ;-) Here are some quick responses to your suggestions: This is an interesting one, because my orginal intention was to have only articles posted by the site administrator or selected contributors (in which case the administrator would input them). I didn't see the contribution going the way of a"community" newsboard, like PHP-Nuke, but... I may leave this for someone who wants this as a variation, e.g Article Contributor?? Still if it was built in as an option, then you could take it or leave it I guess. Yes, this is a definite and was in fact next on my list of enhancements. So look for this in Version 2, but please if anybody wants to offer this as an add-on, please do so in the meantime. My thoughts are to add in a meta-description field in the authors_info table (to support languages) and use this as an abstract in the same way that I do for articles. Shouldn't be too difficult. Question: where to link from, the Authors box (messy if using drop-down) or the Articles box (probably better, e.g. Author List). Thoughts? This is possible right now by using the WYSIWG Editor and the Author description field. Admittedly, it is not laid out prescriptively, so you would have to do all the formatting yourself, but it does support images, links, etc. As for building in more fields for the Author, the advantage would be that it makes it easier for people to add and keep consistent, but it then limits the flexibility with which you may choose to display it. Always trying to find that balance!!! Good idea. Probably a bit beyond my skills at the moment unless I can find a good contribution to copy from (which is all I really do anyway!). Know of any like this? Also, where would you see this being displayed. As a module to plonk anywhere? Hmmm, hadn't thought of that! Again, great idea and I could see the use for it. Any suggestions of contributions that do similar things? I know how the article listing works now in terms of splitting article lists up over several pages, but that works on records, not charachters within a record. Yes, good idea for a module. And given we have an already made article abstract, it would be just a matter of using a random function to choose an appropriate article. I'll put this on my list for Version 2. Another thought I had kinda related was to merge Article reviews with Product reviews using the same box.. Thought about this too, but put it down for later. I'm pretty handy with style sheets so could develop a print media version or alternatively look at modifying the excellet PDF datasheet to display the article in PDF format. Now that would be cool! Fair bit of development time for either one...When will I sleep? Here's an ideas for anybody with search engine experience. How to incorporate the option to search either products, articles or both in the search feature (simple and/or advanced). Any takers?? Great ideas, keep them coming. My priority is on fixing bugs at the moment, but I will definetly incorporate all ideas I can into the next major upgrade (Version 2 - won't be before end of year sorry). Cheers, Rob
  19. RobAnderson

    Article Manager v1.0

    Thanks Randy, for your alternative solution to Salvo's problem. Gotta love this forum, spoilt for choice! I guess it depends on whether you need topic links from within the sub-topic pages or whether you intend to rely on the Articles Box for navigation. Your fix would enable them in the page, mine would remove them. As I haven't given much thought as to how these would be formatted, and the fact that I deliberately stripped topic images out of the articles page (or thought I had), means that the normal categoreis/image type layout may not work so well in this case. Plenty of room for others to contribute ideas... Regards, Rob
  20. RobAnderson

    Article Manager v1.0

    Hi Salvo, in response to your bug: This is a bug. Thanks for finding it ;-) I hadn't tested below the level of sub-topics (bad Robert), and on the third or deeper levels, you will get the error you mentioned. The recommended fix is in catalog/articles.php, comment out or delete lines 133 to 145, i.e. the ones shown below: // $number_of_topics = tep_db_num_rows($topics_query); // // $rows = 0; // while ($topics = tep_db_fetch_array($topics_query)) { // $rows++; // $tPath_new = tep_get_path($topics['topics_id']); // $width = (int)(100 / MAX_DISPLAY_TOPICS_PER_ROW) . '%'; // echo ' <td align="center" class="smallText" width="' . $width . '" valign="top"><a href="' . tep_href_link(FILENAME_ARTICLES, $tPath_new) . '">' . tep_image(DIR_WS_IMAGES . $topics['topics_image'], $topics['topics_name'], SUBTOPIC_IMAGE_WIDTH, SUBTOPIC_IMAGE_HEIGHT) . '<br>' . $topics['topics_name'] . '</a></td>' . "\n"; // if ((($rows / MAX_DISPLAY_TOPICS_PER_ROW) == floor($rows / MAX_DISPLAY_TOPICS_PER_ROW)) && ($rows != $number_of_topics)) { // echo ' </tr>' . "\n"; // echo ' <tr>' . "\n"; // } // } As MAX_DISPLAY_TOPICS_PER_PAGE is no longer used, you can safely ignore it. That should enable the sub-sub-topic page, description and any articles to load properly. One other thing I noticed is that there is a broken image in the top right-hand corner of any sub-sub-topic page. This was not intended as any topic images should only be enabled through additions in the WYSIWYG Editor. So, if this is bugging you, here's the fix: In catalog/articles.php, line 92, replace: <td valign="top" class="pageHeading" align="right"><?php echo tep_image(DIR_WS_IMAGES . $topic['topics_image'], $topic['topics_name'], HEADING_IMAGE_WIDTH, HEADING_IMAGE_HEIGHT); ?></td> with <td valign="top" class="pageHeading" align="right"></td> This effectively removes the broken image reference but leaves the cell intact. Hope this helps, thanks for your feedback Regards, Rob P.S. I will accumulate a few more bugs before rolling this fix into the next version. For others that have installed version 1.0 or 1.1, then these fixes are only necessary if you intend to have levels deeper than one sub-topic. Otherwise, you will probably never see them.
  21. RobAnderson

    Article Manager v1.0

    Hi Kristofer, in response to: To right align the text entries in the Authors box (presuming it's set in the configuration to display as a list, not a drop-down), in catalog/includes/boxes/authors.php, replace line 37 with: $info_box_contents[] = array('align' => 'right', 'text' => $authors_list); To right align the text entries in the Articles box, in catalog/includes/boxes/articles.php, replace line 179 with: $info_box_contents[] = array('align' => 'right', 'text' => $new_articles_string . $all_articles_string . $topics_string); That should fix them ;-) Rob
  22. RobAnderson

    Article Manager v1.0

    Article Manager v1.1 has just been released and includes the following changes: - Bug fix to article_info.php to display article if no author assigned (see previous post) - Full tell_a_friend.php file and associated language file included to simplify installation - Updated installation instructions Thanks to Dave (daithi) for these suggestions. Note: If you have installed Version 1.0, you DO NOT need to reinstall. Simply follow the instructions in the following post to fix a minor bug: http://forums.oscommerce.com/index.php?sho...ndpost&p=269972 Thanks everybody for your enthusiastic responses, it makes all those late nights worth it ;-) Regards, Rob
  23. RobAnderson

    Article Manager v1.0

    Hi Dave, well done, you found a bug ;-) While your fix will display the article (if no author is assigned), you may find that author names do not display for other articles in article_info.php as a consequence. You may also be left with the TEXT_BY entry "by" at the top right-hand corner of your Article Info page. So, you may want to try the fix below, which I will be building into v1.1 (should be posted later today). Article Manager v1.0 bug fix if no Author assigned to article. In catalog/article_info.php replace line 74 with: $article_info_query = tep_db_query("select a.articles_id, a.articles_date_added, a.articles_date_available, a.authors_id, ad.articles_name, ad.articles_description, ad.articles_url, au.authors_name from " . TABLE_ARTICLES . " a, " . TABLE_ARTICLES_DESCRIPTION . " ad left join " . TABLE_AUTHORS . " au on a.authors_id = au.authors_id where a.articles_status = '1' and a.articles_id = '" . (int)$HTTP_GET_VARS['articles_id'] . "' and ad.articles_id = a.articles_id and ad.language_id = '" . (int)$languages_id . "'"); also, in the same page, replace line 87 with: <td class="main" align="right" valign="bottom"><?php if (tep_not_null($articles_author)) echo TEXT_BY . '<a href="' . tep_href_link(FILENAME_ARTICLES,'authors_id=' . $articles_author_id) . '">' . $articles_author . '</a>'; ?></td> That should do it! Thanks very much for your feedback Dave, I really appreciate another set of eyes! Regards, Rob
  24. RobAnderson

    Article Manager v1.0

    Hi Dave Good idea, I will get this out shortly, it would simplify things a bit ;-) Just curious, if you look in the articles table in your database, is the articles_date_added field being filled in? This is what is used in article_info.php to display the expected or published date. Also, when you update an article is it saving the Article Content OK, i.e. in the articles_description table is the articles_description field being populated. If not, it may be a problem with the WYSIWYG Editor install, in which case try turning it off in the Articles manager configuration (Use WYSIWYG HTMLAREA Editor? = Disable) and see if that makes a difference. Let me know how you get on. Regards, Rob
  25. RobAnderson

    Article Manager v1.0

    Hi Kristofor, in response to: The articles_header_tags.php page should have been added earlier on in the installation. It is included in the catalog/includes/languages/english folder of the install package. As for modifying this page (as mentioned in the Post-Installation instructions), this is only required if you had previously installed Linda McGrath's Header Tags Controller. If you don't have this contribution installed, then ignore this step (but you still need the articles_header_tags.php page!) Hope this helps, Rob
×