Latest News: (loading..)

xp02ed

Members
  • Content count

    52
  • Joined

  • Last visited

1 Follower

About xp02ed

Profile Information

  • Real Name
    Jay
  • Gender
    Male
  1. sweet thanks jack its all working now see how it goes in the next week!
  2. also when i do the manual check it send me an email saying theres a new file each time wait period of 4-5 hours shoudl i wait at least 24 hours?
  3. hoping someone can help im getting this error when i click on the admin page Warning: array_merge() [function.array-merge]: Argument #1 is not an array in /location/sitemonitor_admin.php on line 66
  4. props on update jack, awesome plugin and awesome documentation!
  5. awesome contrib! i had several contrib installed which it had a conflict and post prior diagnosed it was with the string replace of "where" in /catalog/includes/functions/database.php to fix it i went through several contributes and ensured that "where" on the query was on the same line as the whole query. example// $eg_query = tep_db_query("select distinct p.fr_currencies_id, p.products_id, p.products_image, pd.products_name, p.products_tax_class_id, products_price, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, specials_new_products_price from " . TABLE_PRODUCTS_XSELL . " xp left join " . TABLE_PRODUCTS . " p on xp.xsell_id = p.products_id left join " . TABLE_PRODUCTS_DESCRIPTION . " pd on p.products_id = pd.products_id and pd.language_id = '" . $languages_id . "' left join " . TABLE_SPECIALS . " s on p.products_id = s.products_id where xp.products_id = '" . $HTTP_GET_VARS['products_id'] . "' and p.products_status = '1' order by sort_order asc limit " . MAX_DISPLAY_XSELL); had to be changed to $eg_query = tep_db_query("select distinct p.fr_currencies_id, p.products_id, p.products_image, pd.products_name, p.products_tax_class_id, products_price, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, specials_new_products_price from " . TABLE_PRODUCTS_XSELL . " xp left join " . TABLE_PRODUCTS . " p on xp.xsell_id = p.products_id left join " . TABLE_PRODUCTS_DESCRIPTION . " pd on p.products_id = pd.products_id and pd.language_id = '" . $languages_id . "' left join " . TABLE_SPECIALS . " s on p.products_id = s.products_id where xp.products_id = '" . $HTTP_GET_VARS['products_id'] . "' and p.products_status = '1' order by sort_order asc limit " . MAX_DISPLAY_XSELL); MOVED the where up a line. i hope this helps people as i spent 2 hours figuring it out! not a pro coder :(
  6. hey guys ive been using this contrib for about a year now but using this version iOSC v1.4- mobile site fo iPhone (Update) bumbarash 3 Apr 2009 Big thanks to PIXCLINIC for pointing out, investigating and repairing this bug AJAX part didn't work correctly if you have quotes or space. addslashes() added to categories_js.php iOSC v1.3- mobile site fo iPhone bumbarash 17 Mar 2009 I see there is a new version, and a whole lot of new files which are added to the catalog directory. is there a major change? i see the files in the mobile directory have been moved to catalog but everything else seems the same? Also with the redirection, i implemented the detect browser which a few posts gave which worked perfectly but clicking on PC site now doesnt work eg : http://www.domain/?redirectCancelled=true
  7. hey jack got a question is there any plans to integrate the sort orders on articles? currently its by name on the function function tep_get_all_articles_array(
  8. i think i found the issue, its to do with special characters my content contains & and other characters and which it doesn't display!
  9. commenting the following out */ /* header("Content-type: text/xml"); echo "<?xml version=\"1.0\" encoding=\"UTF-8\"?>"; echo "<rss version=\"2.0\">"; */ it works and shows the data in <item> see here can't figure this out :S
  10. yup ive did that, i also changed the code.. here is the new article_rss.php file i modded to it shows up buy going to the url <?php /* $Id: index.php,v 1.1 2003/06/11 17:38:00 hpdl Exp $ osCommerce, Open Source E-Commerce Solutions http://www.oscommerce.com Copyright (c) 2003 osCommerce Released under the GNU General Public License */ header("Content-type: text/xml"); echo "<?xml version=\"1.0\" encoding=\"UTF-8\"?>\n"; echo "<rss version=\"2.0\">\n"; echo "<channel>\n"; require('includes/application_top.php'); function mysqlTimestamp2unix($input){ $y = substr($input,0,4);$m = substr($input,6,2);$d = substr($input,9,2); $h = substr($input,12,2);$min = substr($input,15,2);$s = substr($input,18,2); return mktime($h,$min,$s,$m,$d,$y); } //1234567890123456789 //2007-01-01 15:48:04 require(DIR_WS_LANGUAGES . $language . '/' . FILENAME_ARTICLES_RSS); $language_query = tep_db_query("select code from " . TABLE_LANGUAGES . " where languages_id = '" . (int)$languages_id . "'"); $language_code = tep_db_fetch_array($language_query); $code_lang = $language_code['code']; echo "<title>" . NEWS_TITLE . "</title>\n"; echo "<link>" . HTTP_SERVER . "</link>\n"; echo "<description>" . NEWS_DESCRIPTION . "</description>\n"; echo "<language>" . $code_lang . "</language>\n"; echo "<docs>" . HTTP_SERVER . DIR_WS_CATALOG . FILENAME_ARTICLES_RSS . "</docs>\n"; $news_query_raw = tep_db_query("select a.articles_id, a.authors_id, a.articles_date_added, ad.articles_name, ad.articles_head_desc_tag, ad.articles_description, au.authors_name, td.topics_name, a2t.topics_id from " . TABLE_ARTICLES . " a left join " . TABLE_AUTHORS . " au using(authors_id), " . TABLE_ARTICLES_DESCRIPTION . " ad, " . TABLE_ARTICLES_TO_TOPICS . " a2t left join " . TABLE_TOPICS_DESCRIPTION . " td using(topics_id) where (a.articles_date_available IS NULL or to_days(a.articles_date_available) <= to_days(now())) and a.articles_status = '1' and a.articles_id = a2t.articles_id and ad.articles_id = a2t.articles_id and ad.language_id = '" . (int)$languages_id . "' and td.language_id = '" . (int)$languages_id . "' order by a.articles_date_added desc, ad.articles_name limit " . NEWS_RSS_ARTICLE); // use language_id for language support. while ($content_rec = tep_db_fetch_array($news_query_raw)) { echo "<item>"; $headline = $content_rec['articles_name']; $mydate = mysqlTimestamp2unix($content_rec['articles_date_added']); $date = date('r',$mydate); $content_1 = $content_rec['articles_description']; $content = strip_tags($content_1); // $content_1 = substr($content_rec['articles_description'], 0, NEWS_RSS_CHARACTERS); // $content = strip_tags($content_1); // if (strlen($content_rec['content']) > NEWS_RSS_CHARACTERS) { // $content = $content . "...."; // maybe read more here? // } $article_author= $content_rec['authors_name']; // $article_url= $content_rec['articles_url']; $article_topic= $content_rec['topics_name']; $item_link = tep_href_link(FILENAME_ARTICLE_INFO, 'articles_id=' . $content_rec['articles_id'], 'NONSSL', false); echo "<title>$headline</title>\n"; echo "<pubDate>$date</pubDate>\n"; echo "<description>$content</description>\n"; echo "<author>$article_author</author>\n"; echo "<category>$article_topic</category>\n"; echo "<link>$item_link</link>\n"; echo "<guid>$item_link</guid>\n"; echo "</item>\n"; } echo "</channel>"; echo "</rss>"; ?> my current articles won't show up but when removing the xml format and just showing it, it shows the details.. hopefully that makes sense see here
  11. Hey guys ive been using this for awhile and have checked the RSS feeds. i am using the latest version RSS feeds don't seem to pickup all my articles when running this query via SQL it shows all articles select a.articles_id, a.authors_id, a.articles_date_added, a.articles_date_available, ad.articles_name, ad.articles_head_desc_tag, ad.articles_description, au.authors_name, td.topics_name, a2t.topics_id from articles a left join authors au using(authors_id), articles_description ad, articles_to_topics a2t left join topics_description td using(topics_id) where a.articles_status = '1' and a.articles_id = a2t.articles_id and ad.articles_id = a2t.articles_id and ad.language_id = '1' and td.language_id = '1' order by a.articles_date_added desc, ad.articles_name limit 10 but in the article_rss.php file it only shows 3? when i alter dates etc they all disappear? anyone got any ideas? as i cant figure it out
  12. ended up removing your function to calculate to this if( is_object( $this->coupon ) ) { $applied_discount = 0; $discount = $this->coupon->calculate_discount( $this->products[$index], $valid_products_count ); if( $discount['applied_discount'] > 0 ) $valid_products_count++; //$shown_price = $this->coupon->calculate_shown_price( $discount, $this->products[$index] ); //$this->info['subtotal'] += $shown_price['shown_price']; //$shown_price = $shown_price['actual_shown_price']; $shown_price = tep_add_tax($this->products[$index]['final_price'], $this->products[$index]['tax']) * $this->products[$index]['qty'] * tep_friendly_pricing($this->products[$index]['fr_currencies_id'])- ( $discount['applied_discount'] + $discount['discount_tax'] ); $this->info['subtotal'] += $shown_price; } else { $shown_price = tep_add_tax($this->products[$index]['final_price'], $this->products[$index]['tax']) * $this->products[$index]['qty'] * tep_friendly_pricing($this->products[$index]['fr_currencies_id']); $this->info['subtotal'] += $shown_price; } would this be bad for anything? seems to be working though
  13. Hey i use friendly pricing which kidna conflicts on checkout showing the wrong price. ON catalog/includes/classes/order.php i use this to calculate the price $shown_price = tep_add_tax($this->products[$index]['final_price'], $this->products[$index]['tax']) * $this->products[$index]['qty'] * tep_friendly_pricing($this->products[$index]['fr_currencies_id']); which i have this if( is_object( $this->coupon ) ) { $applied_discount = 0; $discount = $this->coupon->calculate_discount( $this->products[$index], $valid_products_count ); if( $discount['applied_discount'] > 0 ) $valid_products_count++; $shown_price = $this->coupon->calculate_shown_price( $discount, $this->products[$index] ); $this->info['subtotal'] += $shown_price['shown_price']; $shown_price = $shown_price['actual_shown_price']; } else { $shown_price = tep_add_tax($this->products[$index]['final_price'], $this->products[$index]['tax']) * $this->products[$index]['qty'] * tep_friendly_pricing($this->products[$index]['fr_currencies_id']); $this->info['subtotal'] += $shown_price; } although it doesnt work obviously coz of this $shown_price = $this->coupon->calculate_shown_price( $discount, $this->products[$index] ); using that custom function, i cant seem to get it to calculate this to the formula too * tep_friendly_pricing($this->products[$index] any pointers please?
  14. Hi jack i was wondering if implementing the top parent id ( top parent category ) can be easily added this is for the product_info.php page neway
  15. ignore this after waiting 1 hour and clearing caches started to show the stuff, looks like my nets cacheing