Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

aldaffodil

Archived
  • Posts

    220
  • Joined

  • Last visited

Posts posted by aldaffodil

  1. Super dude! ! let us know when this comes out

     

    Thanks

     

    Well, I just hit a brickwall. I downloaded the PayPal PHP SDK package to get started and all that was included was a text file that said the package would be available the last week of June. So, I guess I'll just have to keep checking until they release it and hopefully it will be pretty simple.

  2. So, why don't you all just start your own PayPal bashing post and leave this one to those who actually want to use the new service? I've used PayPal for a little over two years now and have never had one single problem. It is great for keeping costs down for small, home-office retailers like myself.

     

    I am going to try to work on a new contribution for the website payments pro, but who knows how far I'll get before it all comes crashing down :-) I am hoping to work on it tomorrow, and if I run into any problems, I'll try to post them here for a little help.

  3. Upon further reflection, I have decided to give the language_id a try.

     

    Salvo (or anyone else willing to give it a try), please try these sql statements:

      if (isset($HTTP_GET_VARS['description'])) {
       $search_query = tep_db_query("select ad.articles_name, a.articles_id, ad.articles_description from " . TABLE_ARTICLES_DESCRIPTION . " ad inner join " . TABLE_ARTICLES . " a on ad.articles_id = a.articles_id where a.articles_status = '1' and ad.language_id = '" . (int)$languages_id . "' and (ad.articles_name like '%" . $keywords . "%' or ad.articles_description like '%" . $keywords . "%' or ad.articles_head_desc_tag like '%" . $keywords . "%' or ad.articles_head_keywords_tag like '%" . $keywords . "%' or ad.articles_head_title_tag like '%" . $keywords . "%') order by ad.articles_name ASC");
     }  else {
       $search_query = tep_db_query("select ad.articles_name, a.articles_id, ad.articles_description from " . TABLE_ARTICLES_DESCRIPTION . " ad inner join " . TABLE_ARTICLES . " a on ad.articles_id = a.articles_id where a.articles_status='1' and ad.language_id = '" . (int)$languages_id . "' and (ad.articles_name like '%" . $keywords . "%' or ad.articles_head_desc_tag like '%" . $keywords . "%' or ad.articles_head_keywords_tag like '%" . $keywords . "%' or ad.articles_head_title_tag like '%" . $keywords . "%') order by ad.articles_name ASC");
     }

     

    I cannot fully test it because I do not use two languages on any of my sites. If it works for you, please let me know and I'll add it to the package.

  4. Ok, I have uploaded a new package that includes support for articles status and have somewhat improved the layout of search results.

     

    I do not think I am going to touch on the languages_id. My reasoning being that the search will most likely return english results if you enter an english keyword and will return spanish results if you enter a spanish keyword, etc.

     

    If a lot of people feel this is something that needs to be addressed, then I'll start working on it.

     

    Thanks for the feedback!

  5. Ok Everyone! I have uploaded the article search function - Please Enjoy!

     

    This contribution will add a search box that will allow you to search

    articles using Article Manager v 1.2. Article Results will give the

    Article Title with a link to the article and a 300 character

    truncation of the article. Sorry, I did not write an advanced search

    to go with this.

     

    Contribution Located at: http://www.oscommerce.com/community/contributions,2393

  6. This is the support thread for Article Search v 1.0

     

    This contribution will add a search box that will allow you to search

     

    articles using Article Manager v 1.2. Article Results will give the

     

    Article Title with a link to the article and a 300 character

     

    truncation of the article. Sorry, I did not write an advanced search

     

    to go with this.

     

    Contribution Located at: http://www.oscommerce.com/community/contributions,2393

  7. As I said before, I am trying to write a search function for the articles. I have changed it quite a bit from before and think I am pretty close.

     

    I have having trouble with this query:

     

      $search_result_query = tep_db_query("select articles_name, articles_id from " . TABLE_ARTICLES_DESCRIPTION . " where articles_name like '%" . tep_db_input($keyword) . "%' or articles_description like '%" . tep_db_input($keyword) . "%'");

     

    I am getting this error:

    Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/jalterna/public_html/catalog/includes/functions/database.php on line 99

     

    Can anyone see what's wrong with it?

  8. Ok, well, last week I decided to tackle the project of writing a search function for this articles contribution.

     

    If someone has already done this and I just don't know it...please someone tell me so I can quit fussing with it.

     

    Otherwise, I could really use some help :D

     

    I have alreayd written a post in the development forum with my problem, including code, it is at this url: http://www.oscommerce.com/forums/index.php?showtopic=107904

     

    Basically, I have the search written, and it counts the number of results correctly, but I cannot get the results to show up.

     

    The search is located at http://altdr.com and is the box titled "Search the Knowledge Base". A search for "Aloe" should bring up 12 results.

     

    can anyone help please? I know this is a contribution quite a few of us could use.

  9. Ok, I was having this problem as well. Here is the solution:

     

    Open payflowlink.php in catalog>includes>modules>payment and change the following lines:

     

                                   tep_draw_hidden_field('AMOUNT', number_format($order->info['total'], 2, '', '')).
                                  tep_draw_hidden_field('SHIPAMOUNT', number_format($order->info['shipping_cost'], 2, '', '')).
                                  tep_draw_hidden_field('TAX', number_format($order->info['tax'], 2, '', '')).

     

    to

     

                                   tep_draw_hidden_field('AMOUNT', number_format($order->info['total'], 2, '.', '')).
                                  tep_draw_hidden_field('SHIPAMOUNT', number_format($order->info['shipping_cost'], 2, '.', '')).
                                  tep_draw_hidden_field('TAX', number_format($order->info['tax'], 2, '.', '')).

     

    The problem is the missing decimal points.

  10. Ok, I figured it out. Here is the solution for getting subtopics to show in case someone else runs into the same problem.

     

    In catalog>articles.php, after:

     

     ? ?} else {
    ? ? ?$topics_query = tep_db_query("select t.topics_id, td.topics_name, t.parent_id from " . TABLE_TOPICS . " t, " . TABLE_TOPICS_DESCRIPTION . " td where t.parent_id = '" . (int)$current_topic_id . "' and t.topics_id = td.topics_id and td.language_id = '" . (int)$languages_id . "' order by td.topics_name");
    ? ?}

     

    Add:

     

     ? ?$number_of_topics = tep_db_num_rows($topics_query);
    
    ? ?$rows = 0;
    ? ?while ($topics = tep_db_fetch_array($topics_query)) {
    ? ? ?$rows++;
    ? ? ?$tPath_new = tep_get_topic_path($topics['topics_id']);
    ? ? ?$width = (int)(100 / 3) . '%';
    ? ? ?echo ' ? ? ? ? ? ? ? ?<td align="center" class="main" width="' . $width . '" valign="top"><a href="' . tep_href_link(FILENAME_DEFAULT, $tPath_new) . '">'. '<br>' . $topics['topics_name'] . '</a></td>' . "\n";
    ? ? ?if ((($rows / 3) == floor($rows / 3)) && ($rows != $number_of_topics)) {
    ? ? ? ?echo ' ? ? ? ? ? ? ?</tr>' . "\n";
    ? ? ? ?echo ' ? ? ? ? ? ? ?<tr>' . "\n";
    ? ? ?}
    ? ?}

     

    Were you see a 3 , such as 100/3, the three represents the MAX_DISPLAY_CATEGORIES_PER_ROW, so set this to however many topics you want displayed per row. I couldn't figure out where to set it, so I just hard coded it. (May the osCommerce Gods strike me down)

  11. Hello. I am having trouble getting subtopics to show. I saw that "Bravejoey" was having the same problem, but didn't see anyone reply. Does anyone know how to fix it?

    ----------------------------

    Update:

    Upon second look, I see that the subtopics are showing in the info box, but is there a way to display them in the "main screen"?

×
×
  • Create New...