NukeCoder

Code Authors · Joined: Dec 09, 2006 Posts: 335

Constant 'TABLE_PURCHASES' is declared twice. As the value is the same we can simply remove one.
In modules/Digital_Shop/lib/constants.php
The first declaration is on line 29, we can therefore remove the second one on line 33 so;

Code:

define('TABLE_CONFIG', 'shop_config');
define('TABLE_PURCHASES', 'shop_purchases');
define('TABLE_APPREG', 'shop_appreg');
define('TABLE_BLOCKS', 'shop_blocks');// stand alone version only
define('TABLE_SAVED_CART', 'shop_saved_carts');
define('TABLE_PURCHASES', 'shop_purchases');
define('TABLE_PURCHASE_LOG', 'shop_purchase_log');

Becomes

Code:

define('TABLE_CONFIG', 'shop_config');
define('TABLE_PURCHASES', 'shop_purchases');
define('TABLE_APPREG', 'shop_appreg');
define('TABLE_BLOCKS', 'shop_blocks');// stand alone version only
define('TABLE_SAVED_CART', 'shop_saved_carts');
define('TABLE_PURCHASE_LOG', 'shop_purchase_log');

Code Authors · Joined: Dec 09, 2006 Posts: 335

Fatal error: Call to a member function on a non-object in /my/server/path/modules/Digital_Shop/app/Shop/admin/clients-modify.php on line 29

I'm not able to provide a fix for this as the file is encoded.

Site Admin Joined: Oct 25, 2004 Posts: 921

as a temporary fix, try this... Drop this code in app/Admin/admin_auth.php

Code:

require_once SCRIPT_PATH.'lib/class.items.php';
$items = itemMan::getInstance();

This should take care of that 2nd error.

Code Authors · Joined: Dec 09, 2006 Posts: 335

I added it right after the admin authentication - works a treat, thank you!
Outstanding work!!
No more error reported and Client list and Add New Client now works.

Joined: Mar 25, 2007 Posts: 27

Tried the shop new block with no images appearing still Sad

Is there a way to assign it to home (which I did) and show only selected categories and 4 (set in admin) latest from each of those categories?
And with out the Digital Shop header and root/path?

Looking good thus far Wink

Code Authors · Joined: Dec 09, 2006 Posts: 335

I had a quick look at the blocks code and it seems to pull the thumb nail image not the item image - have you set thumb nail images for your items?

To get a specific category to show, you would need to alter the sql statements, for example in the featured block, line 13 you would need to change the WHERE clause to specify the category you wanted.
So changing

Code:

$sql = "SELECT * FROM shop_items WHERE item_special='1' ORDER BY item_name ASC LIMIT 5";

to something like

Code:

$sql = "SELECT * FROM shop_items WHERE item_cat='ZZ' ORDER BY item_name ASC LIMIT 5";

In the above example you would change 'ZZ' to whatever the category id was (you can check which one you need with phpmyadmin by browsing the shop_items table). The ASC LIMIT bit limits the number of records shown to 5 and puts them in ASCending order.
So for example, if you wanted to show the last 10 items in ascending order you can change that to ASC LIMIT 10

Joined: Mar 25, 2007 Posts: 27

Cant seem to find the way to set thumbnail images, I set to percent>save and says it was saved but I look at item again and I see the options I set are no longer there.

Any ideas?

Joined: Mar 25, 2007 Posts: 27

I used your above code for extracting the images but duplicated shop_new and replaced the items_thumb with items_image, now he question is how can I display these horizontally?

Code Authors · Joined: Dec 09, 2006 Posts: 335

I'll have a look later today and see if I can come up with anything.
I have not used the thumbnail bit either, I'm not sure if it is supposed to resize the original image or you need to specify the path to an already reduced size image.
If it resizes the main item image on-the-fly it might be useful to know what it resizes to so you have an idea if the resized image is going to look out of shape.

Site Admin Joined: Oct 25, 2004 Posts: 921

MASsIVE wrote:

Cant seem to find the way to set thumbnail images, I set to percent>save and says it was saved but I look at item again and I see the options I set are no longer there.

Any ideas?

The options won't show up again when you edit the item, they are only for new images. When you upload an image the thumbnail will be automatically generated using the resize options as long as the thumbnail folder is writable. WhenI add an image, I usually choose "Scale by width" and set the value to 140(or so). If you choose "Ignore" you would have to manually upload the thumnail.

MASsIVE wrote:

I used your above code for extracting the images but duplicated shop_new and replaced the items_thumb with items_image, now he question is how can I display these horizontally?

item_thumb is the one to use. If you want to display them horizontally, move the "<tr>" tag above the while loop and move the "</tr>" below the loop

Joined: Dec 13, 2005 Posts: 107

I seem to have a slight problem with the add client and the drop down

please see picture

As you can see if im wanting to add a user to a product , its a nightmare to be honest with 3000 users and growing it takes ages to look through as the list is not set to alphabetical order.

Perhaps a search for user could be implemented in the new release ?

As its doing my head in now !! Very Happy

Site Admin Joined: Oct 25, 2004 Posts: 921

Open lib/class.userManager.php

Find:

php:

 function listUserNames()

{

    $query = "SELECT user_id, username FROM ".TABLE_USERS;

replace with

php:

 function listUserNames()

{

    $query = "SELECT user_id, username FROM ".TABLE_USERS." ORDER BY username ASC";