Jump to content

johnson4

Members
  • Content count

    29
  • Joined

  • Last visited

1 Follower

Profile Information

  • Real Name
    Seth Johnson
  1. johnson4

    AJAX Attribute Manager support

    I have my categories.php reorganized into div (for at tabbed look) therefore I have <?php require_once( 'attributeManager/includes/attributeManagerPlaceHolder.inc.php' )?> inside a div. All works fine except that the popup prompts (and the "blackout" that appears behind them) is down and to the right about 50px. I've tried making changes to the .css file to move the blackout or the popups, but no luck. Does anyone know where/how I can move where this popup appears? Thanks for any help, Im loving this Contrib ===================EDIT================================== Here's what I tried and it almost works(could be about 10 more px to the right but much better) in attributesManager.js I commented out lines 291, 292 newBit.style.left = attributeManagerX; newBit.style.top = attributeManagerY; and changed starting at 308 // work out the center postion for the box leftPos = (((attributeManagerW - popupContents.scrollWidth) / 2) + attributeManagerX); topPos = (((attributeManagerH - popupContents.scrollHeight) / 2) + attributeManagerY); to // work out the center postion for the box leftPos = ((attributeManagerW - popupContents.scrollWidth) / 2); topPos = ((attributeManagerH - popupContents.scrollHeight) / 2); If anyone can comment on a better way to go about this please let me know
  2. johnson4

    DB Manipulation from Admin

    hahaa ya thats the kinda thing that would have me baffled for hours on end, thanks a ton, it's working great now
  3. johnson4

    DB Manipulation from Admin

    I made a file called dbclean.php and put this in it <?php require('includes/application_top.php'); $product_deletion_query = tep_db_query("select products_id from from " . TABLE_PRODUCTS . " where products_status = 0"); while ($product_deletion = tep_db_fetch_array($product_deletion_query)) { tep_db_query("delete from " . TABLE_PRODUCTS . " where products_id = '" . $product_deletion['products_id'] . "'"); tep_db_query("delete from " . TABLE_SPECIALS . " where products_id = '" . $product_deletion['products_id'] . "'"); tep_db_query("delete from " . TABLE_REVIEWS . " where products_id = '" . $product_deletion['products_id'] . "'"); tep_db_query("delete from " . TABLE_PRODUCTS_ATTRIBUTES . " where products_id = '" . $product_deletion['products_id'] . "'"); tep_db_query("delete from " . TABLE_CUSTOMERS_BASKET . " where products_id = '" . $product_deletion['products_id'] . "'"); tep_db_query("delete from " . TABLE_PRODUCTS_TO_CATEGORIES . " where products_id = '" . $product_deletion['products_id'] . "'"); tep_db_query("delete from " . TABLE_PRODUCTS_DESCRIPTION . " where products_id = '" . $product_deletion['products_id'] . "'"); } ?> I tried to run this file with a crontab but it returned Status: 404 Content-type: text/html X-Powered-By: PHP/4.3.2 No input file specified. and if I go to the file with a browser I got this 1064 - You have an error in your SQL syntax near 'from products where products_status = 0' at line 1 select products_id from from products where products_status = 0 [TEP STOP] any idea where I went wrong? Im sorry if I've done something obviously wrong, my php/mySQL skils are pretty low. Thanks again for any help you can give me
  4. johnson4

    DB Manipulation from Admin

    thanks Ill gove it a shot, If I put this in a php file and add a crontab to my server it should keep things all cleaned up. thanks again
  5. johnson4

    DB Manipulation from Admin

    I really like this cotrib Im just trying to add another function, Delete all Products that are inactive. I have a field called "products_status" in my products table and I want to be able to delete all the products that have a status of "0" This works of course "delete from products where products_status = 0" but "delete from products_to_categories where products_status = 0" doesn't cause "products_status" is not in the"products_to_categories" table. any thought on how to wright the script properly for this? thanks for any help
  6. johnson4

    Customer Add Product

    just above the piece you posted you should see //print_r( $languages); for ($i=0, $n=sizeof($languages); $i<$n; $i++) { //echo $languages[$i]['directory']; if ($languages[$i]['directory']==$language) $language_id=$languages[$i]['id']; } $categories_array = array(array('id' => '', 'text' => TEXT_NONE)); $categories_query = tep_db_query("select a.categories_id,parent_id, b.categories_name from " . TABLE_CATEGORIES . " as a," . TABLE_CATEGORIES_DESCRIPTION . " as b where a.categories_id = b.categories_id and b.language_id = " . (int)$language_id . " order by categories_name"); I changed the (int)$language_id . " order by categories_name"); at the end to (int)$language_id . " order by categories_id"); and got the result that your looking for. I've noticed though, that when ever you go beyond 2 sub-categories, they get mixed up in this drop down box. It shows up like, subcat1->category->subcat2 instade of category->subcat1->subcat2 can anyoone help me with this?
  7. johnson4

    Customer Add Product

    I've been thinking about coding in a place in the admin, that will display all the products that are waiting to be approved. I just thought I'd check and see if anyone already have made something like this. :) Thanks in advance for any help, sj
  8. I've just installed Administration Access Level Accounts 2.2 and I'm having the same problem with the catagory ID showing up but not the name.\ Anyone solved this? Thanks in advance sj
  9. johnson4

    Multi-Stores Multiple Shops Support

    Im having a strange issue. I have 2 catalogs setup with this contrib but both catalog are displaying the catagories that belong to the default store......even though the db shows the correct values in the catagories _to_store table. any idea how this is happening or how I can get the right catagories showing up?
  10. johnson4

    Integrated CC payment

    oh Im in Canada, so it won't work in canadian Dollars?
  11. johnson4

    Integrated CC payment

    Anything else out there? Paytechco is a lil to steep for me right now. thanks for the reply tho sj
  12. johnson4

    Integrated CC payment

    Hello Im looking for a payment module that doesn't take my customers outside of my catalog (during the payment proccess) And also sends the payment automaticly to my bank account. I have a Visa and MC merchant account if that helps. I like the standard credit card payment mod but I would like a system that doesn't require me to call in the payments myself. Thanks for any advise. sj
  13. johnson4

    Show/Hide Columns Infoboxes Support

    I have a catalog being shown in i-frames on 2 different sites, and on one site I would like the left column to never appear. Do you know a way to detect the location of the catalog, so that the php will hide the left column if the catalog is being viewed in site 1 and show the left column if the catalog is being viewed in site 2? Thanks for any help with this, sj
  14. I noticed a "send new password" link on the /admin/customers.php page, but file /admin/password_forgotten.php is not in the contribution. Is this something that is being developed? Or is there something I can edit in my /catalog/password_forgotten.php so it will work as /admin/password_forgotten.php? Thanks for any advice with this sj
  15. johnson4

    Canadian Email Wire Transfer

    Check out http://www.oscommerce.com/community/contri...earch,usemybank
×