

xp02ed
Members-
Content count
52 -
Joined
-
Last visited
Profile Information
-
Real Name
Jay
-
Gender
Male
-
sweet thanks jack its all working now see how it goes in the next week!
-
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?
-
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
-
props on update jack, awesome plugin and awesome documentation!
-
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 :(
-
[Contribution] iOSC - mobile version of OSC on your iPhone
xp02ed replied to bumbarash's topic in General Add-Ons Support
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 -
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(
-
i think i found the issue, its to do with special characters my content contains & and other characters and which it doesn't display!
-
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
-
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
-
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
-
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
-
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?
-
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
-
ignore this after waiting 1 hour and clearing caches started to show the stuff, looks like my nets cacheing