Latest News: (loading..)

ShaGGy

Member Since 24 Aug 2006
Offline Last Active Yesterday, 23:34

Find content

Community Stats

Group Community Member
Active Posts 55 (0.03 per day)
Most Active In General Add-Ons Support (33 posts)
Profile Views 4,792
Age Age Unknown
Birthday Birthday Unknown
Real Name
Les
Gender
Not Telling

Contact Information

0 Neutral

Friends

Latest Visitors

Pitpiotr
08 Feb 2012, 21:16
wHiTeHaT
05 Feb 2012, 21:11
kohalabill
22 Jan 2012, 20:46
adminj
22 Jan 2012, 20:15
jperezbadia
15 Jan 2012, 03:13

Posts I've Made

In Topic: Failed opening required 'DIR_WS_FUNCTIONScompatibility.php'

24 January 2012, 04:06

Add thesee to your includes/config.php (do not create a new one in local as instructed) and it works fine, the only problem at the moment is the account_history_info.php file that needs modifying for 2.3.1 (column left / right layout issues)

define('EMAIL_INVOICE_DIR', 'email_invoice/');
define('INVOICE_TEMPLATE_DIR', 'templates/');

// Email Invoice File Definitions
define('FILENAME_EMAIL_INVOICE', 'email_invoice.php');
define('FILENAME_EMAIL_CACHE_FILE', 'temp_cache.php');
define('FILENAME_ORDERS_INVOICE', 'invoice.php');

In Topic: Products Fields Groups

18 January 2012, 00:44

Managed to do it in the end i was omitting the left join as the line already had one but after a bit of asking around it turned out i needed to insert the left join as instructed even though there was one already in the query.

But I end up with a weird bug whereas if i add the attibs to ONE product it works fine but when i then add to a second item none of them show?

In Topic: Why is this not finding the results from the table ?

15 January 2012, 17:02

kymation, on 15 January 2012, 03:53, said:

The problem is here:

	$businesses = tep_get_businesses();

tep_get_businesses() returns an empty array if you don't specify an ID. Since that array size is zero, the pulldown array will also be empty. You need to modify the tep_get_businesses() function to return the entire list if the ID is null.

Regards
Jim

Thanks mangaged to fix it i was over velous trimming out the else commands. all working now

In Topic: Products Fields Groups

13 January 2012, 23:54

$products_query = tep_db_query("select p.products_id, pd.products_name, p.products_quantity, p.products_image, p.products_price, p.products_qty_blocks, p.products_date_added, p.products_last_modified, p.products_date_available, p.products_status, p2c.categories_id, ptdc.discount_categories_id, dc.discount_categories_name from " . TABLE_PRODUCTS . " p left join " . TABLE_PRODUCTS_TO_DISCOUNT_CATEGORIES . " ptdc on p.products_id = ptdc.products_id left join " . TABLE_DISCOUNT_CATEGORIES . " dc using(discount_categories_id), " . TABLE_PRODUCTS_DESCRIPTION . " pd, " . TABLE_PRODUCTS_TO_CATEGORIES . " p2c where p.products_id = pd.products_id and pd.language_id = '" . (int)$languages_id . "' and p.products_id = p2c.products_id and pd.products_name like '%" . tep_db_input($search) . "%' order by pd.products_name");

trying to merge this code (below) into the above code but keep getting sql syntax errors.

" . TABLE_PRODUCTS . " p LEFT JOIN " . TABLE_PRODUCT_FIELDS_GROUPS_NAMES . " pfgn on p.products_fields_group_id = pfgn.products_fields_group_id and pfgn.language_id = '" . (int)$languages_id . "' where

In Topic: Product Listing modifcation help needed

13 January 2012, 17:02

Thanks Dunweb i did have a look for a module to modify but missed that one [img]http://forums.oscommerce.com//public/style_emoticons/default/smile.png[/img]

Do you know how/what product_listing calls to get its info?