Jump to content


  • Content count

  • Joined

  • Last visited

Posts posted by vourlismenos

  1. Hello vourlismene eptanhsie Kerkyraie (to Vourlismenos emeis oi eptanhsioi to leme, egw apo Zakyntho)


    Forget about tbl.php and tbl_ajax.php that's the old version of A.A.S. , in the new one there's only one main file ( aas.php ) that needs to be added to filenames.php


    As for the stock quantity it will be hopefully added in the 0.3 version.


    stin idia geitonia kai oi dio :)


    Yeah don't worry about the files, it works for me anyway :)


    If you can pull this off, then oscommerce should replace their product/categories admin with yours :)

    Very well done!!!

  2. Γειa σου πaτριώτη...


    The tbl_ajax.php is included in the ext/tbl/ so no need to be added in the catalog/admin.


    Can I have some more info about quantity/stock with the attributes?


    Γειa σου πaτριώτη :)


    You are right, tbl_ajax.php is included in the ext/tbl/ but if you add


    define('FILENAME_TABLEDATA', 'tbl.php');

    define('FILENAME_TBL_AJAX', 'tbl_ajax.php');


    in admin/includes/filenames.php as the instructions say, won't it be looking for it in the catalog/admin? At least that's how I understand it, and if I remember, it didn't work completely without me copying the file there.

    Maybe I'm mistaken, but it doesn't really matter :)




    The way oscommerce works, you can add a stock quantity to a product. For example when you have a shirt you can add stock = 3. When you add attributes though, you can have a shirt with options "blue" "red" "green" (one of each = stock 3). When someone buys the green shirt, then the green shirt should be out of stock and the stock now should be 2. By default osscomerce can't do this. QTPRO (http://addons.oscommerce.com/info/7786) does that, and there is also an ajax attribute manager (http://addons.oscommerce.com/info/7786) that works along with QTPRO. I find these contributions too buggy and too difficult to use in an actual store with many products.


    If you can add that to you system it would be amazing! Maybe a future addition :)

  3. Hi John (Γιάννη)


    amazing work!


    just two things:


    In your instructions file you mention in step3:


    STEP 3:


    Add to admin/includes/filenames.php


    define('FILENAME_TABLEDATA', 'tbl.php');

    define('FILENAME_TBL_AJAX', 'tbl_ajax.php');


    you are not including the second file in the zip file (unless I'm mistaken). I had to use the one from the previous version.


    Also is there a way to combine quantity/stock with the attributes? like qtpro from example?

  4. I'm using qtpro with oscommerce 2.3 (and ajax attribute manager)


    Everything works fine, but in case I delete an order, the "restock product" option is not working. The product remains "not published"


    Also when I receive the order and go to the "orders" in the admin side, I get a qtpro warning "Warning: There are 1 sick products in the database. Please visit the QTPro doctor." related to the product that is ordered

    If I go to the qtpro doctor I get this:


    The stock quantity summary is NOT ok

    This means that the current summary of this products quantity, which is in the database, isn't the value we get if we calculates it from scratch right now.

    The current summary stock is: 0

    If we calculates it we get: 1


    The options stock is ok

    This means that the database entries for this product looks the way they should. No options are missing in any row. No option exist in any row where it should not.

    Total number of stock entries this product has: 1

    Number of messy entries: 0


    The attribute quantity remains for some reason?


    I suppose that both problems are related because when I delete the order, the qtpro warning dissapears but the product remains out of stock and stays unpublished


    Have I missed something in the installation or is there something else wrong? Any ideas?

  5. My modification posted above achieves this


    Yeah I had something different in mind, that I thought about it and decided that was useless anyway. I did use your modification and works fine, but I have a small issue. I don't know if it's something that doesn't work or some other modification that affects it.


    Basically I have vertical and horizontal images. The thumbnails of the horizontal images are stretched (the height) in order to occupy the same height as the vertical ones. Any ideas?

  6. Is there way to keep the proportions of the image but without the blank (or any colour) background? I mean the thumbnail taking the whole space even if it means that some part of the image is hidden? (overflow: hidden kind of thing)

  7. A small modification, so that people that are not logged in can fill in their telephone number:


    remove this line from contact_us.php

    echo tep_draw_hidden_field('phone',$phone);


    find this code:

    		    <td class="main"><?php echo ENTRY_EMAIL; ?></td>
    		    <td class="main"><?php echo tep_draw_input_field('email', $email, 'size="28"'); ?></td>


    and add under:


    		    <td class="main"><div class="crosspiece95"></div><?php echo ENTRY_TELEPHONE_NUMBER; ?></td>
    		    <td class="main"><?php echo (isset($account['customers_telephone']) ? $phone . tep_draw_hidden_field('phone',$phone) : tep_draw_input_field('phone', $phone, 'size="28"')); ?></td>

  8. Hi Jim,


    I already went through the guide and some other posts as well but I couldn't figure it out. I can convert simple buttons, but when values are added I kind of lose it. I'll have another look and post here, but any help would be appreciated.

  9. Since the wishlist contribution works in 2.3 with minimum changes, I've tried installing to to my site. It works fine so far, even though I'm still testing it.


    I've been having probelms with the wishlist buttons though.

    I've tried converting the two buttons in wishlist.php to the new format, but I've had no luck.


    Currently they are like this:


    <?php echo tep_image_submit('button_delete.gif', 'Delete From Wishlist', 'name="delete_prod" value="delete_prod"') . " " . tep_image_submit('button_in_cart.gif', 'Add to Cart', 'name="add_prod" value="add_prod"'); ?>


    Any ideas on how to convert them?



  10. I think I made it work in 2.3.1 without adding the bew tables in the database. At least with a quick test on my site it works.


    You have to create the extra language file that chrish123 mentions:





     osCommerce, Open Source E-Commerce Solutions
     Copyright (c) 2010 osCommerce
     Released under the GNU General Public License
     define('MODULE_BOXES_SHOP_BY_PRICE', 'Shop By Price');
     define('MODULE_BOXES_SHOP_BY_PRICE_BOX_TITLE', 'Shop By Price');
     define('BOX_HEADING_SHOP_BY_PRICE', 'Shop By Price');


    After that in catalog/includes/modules/boxes/bm_shop_by_price.php


    comment out the following:

    require(DIR_WS_LANGUAGES . $language . '/' . FILENAME_SHOP_BY_PRICE);



    $price_ranges_query = tep_db_query("select price_range_id, price_range_values from " . TABLE_PRICE_RANGES . " order by price_range_values");


    It seems to work and there is no need to change the price ranges from the databse, but only from the files.