scamp

Members
  • Content count

    33
  • Joined

  • Last visited

Community Reputation

0 Neutral

1 Follower

About scamp

Profile Information

  • Real Name
    Sebastian Scamp

Contact Methods

  1. Hi, I am currently trying to make a add all to cart from items in a pre-defined wishlist, that is simply grab the items in the wishlist table and move them to the cart. Any help with this would be much appreciated if someone would like to collaborate please contact me. Regards Seb
  2. Never mind found the fix of sorts :wink: made the action=wishlist_add_cart&pid.. had to edit the code but I belive it's fine. For those interrested I edited the action=cust_order to action=wishlist_add_cart&pid... in both the page and module (box) and then edited the code in application_top.php to case 'wishlist_add_cart': // while (list($key,$elem) =each ($lvnr)) { // (list($key1,$elem1) =each ($lvanz)); // tep_db_query("update " . TABLE_WISHLIST . " SET products_quantity=$elem1 WHERE customers_id=$customer_id AND products_id=$elem"); tep_db_query("delete from " . TABLE_WISHLIST . " WHERE customers_id=$customer_id AND products_quantity='999'"); $produkte_mit_anzahl=tep_db_query("select * from " . TABLE_WISHLIST . " WHERE customers_id=$customer_id AND products_id=$pid AND products_quantity"); while ($HTTP_POST_VARS=mysql_fetch_array($produkte_mit_anzahl)) { $cart->add_cart($HTTP_POST_VARS['products_id'], $HTTP_POST_VARS['products_quantity']); } } // reset ($lvanz); tep_db_query("delete from " . TABLE_WISHLIST . " WHERE customers_id=$customer_id AND products_id=$pid"); break; Hope it's of help to someone, ps I am using a old snapshot application_top.php,v 1.248 2002/09/20 regards Seb
  3. Howdy, I too have been working on a pre-defined list and have not been able to add more than 1 item to the cart from the wishlist. i.e even though the qty in the wishlist is 2 it still will only post 1 to the cart. I have attempted to use your mode as above but still no joy it atualy returned an sql error but once that was fixed still nothing. I am using a pre MS snapshot (with lots of mods late Nov 002)- any help would be most appreciated. I have been playing with this line for what seems like for ever . $cart->add_cart($HTTP_GET_VARS['pid'], 1); refgards Seb
  4. Yep you are right I should have posted a message I just assumed that DROP TABLE IF EXISTS was self explanatory. But we all now what happens when you assume. :) I install all contributions on a test site (local where I consider all information in the tables are well test information so if it's lost corrupted I just restore back to the original state, or back track until I find the problem. I hope no one is installing this or any other contribution on a live site without testing it first! I will be more mindfully of the consequences next time and put big disclaimers on my posts. On a serious note though, apologies to those that lost data, as I said I just assumed people where installing on a test site. Well that's the last time I post on these forums. :wink: Regards Seb
  5. run this, it should fix the orders table. # Table structure for table `orders` # DROP TABLE IF EXISTS orders; CREATE TABLE orders ( orders_id int(11) NOT NULL auto_increment, customers_id int(11) NOT NULL default '0', customers_name varchar(64) NOT NULL default '', customers_street_address varchar(64) NOT NULL default '', customers_suburb varchar(32) default NULL, customers_city varchar(32) NOT NULL default '', customers_postcode varchar(10) NOT NULL default '', customers_state varchar(32) default NULL, customers_country varchar(32) NOT NULL default '', customers_telephone varchar(32) NOT NULL default '', customers_email_address varchar(96) NOT NULL default '', customers_address_format_id int(5) NOT NULL default '0', delivery_name varchar(64) NOT NULL default '', delivery_street_address varchar(64) NOT NULL default '', delivery_suburb varchar(32) default NULL, delivery_city varchar(32) NOT NULL default '', delivery_postcode varchar(10) NOT NULL default '', delivery_state varchar(32) default NULL, delivery_country varchar(32) NOT NULL default '', delivery_address_format_id int(5) NOT NULL default '0', payment_method varchar(32) NOT NULL default '', cc_type varchar(20) default NULL, cc_owner varchar(64) default NULL, cc_number varchar(32) default NULL, cc_expires varchar(4) default NULL, last_modified datetime default NULL, date_purchased datetime default NULL, orders_status int(5) NOT NULL default '0', orders_date_finished datetime default NULL, comments text, currency char(3) default NULL, currency_value decimal(14,6) default NULL, customers_company char(1) NOT NULL default '', delivery_company char(1) NOT NULL default '', billing_name char(1) NOT NULL default '', billing_company char(1) NOT NULL default '', billing_street_address char(1) NOT NULL default '', billing_suburb char(1) NOT NULL default '', billing_city char(1) NOT NULL default '', billing_postcode char(1) NOT NULL default '', billing_state char(1) NOT NULL default '', billing_country char(1) NOT NULL default '', billing_address_format_id char(1) NOT NULL default '', PRIMARY KEY (orders_id) ) TYPE=MyISAM; # -------------------------------------------------------- Regards Seb
  6. Hi from memory, I had to add to orders.php, spg_suppliers_products (i think) :D I will dump the structure of the files I touched and post it here? or send me a mail and I will forward the sql to run via phpadmin. I wont get around to this until later tonight though. Also I was only playing with the contrib so there may well be other tables that need to be updated. If an update is due by the weekend it might be best to wait for the fix? Anyone no problem dumping the tables I am not at my delevopment machine at the moment hence the delay. Regards Seb
  7. Hi I just installed this contribution, very promising! Your code called for a large number of files that where not included in the SQL update file provided in the contribution, that's neither here nor there as I added them - I was intrigued by the possibility of this contribution, which I belive once complete will add a large degree of functionality that in some cases is missing in the stock distribution. I was unable to work out some sections - functions (didn't play to much with it once I discovered this thread) can you advise what is actually still in development - I saw files such as products_quantity , qty_back , qty_shp, is this to be included in the account_history_info.php? In any event I look forward to the latest update. Will you be adding it to the contributions section or a stand alone download from your site - (Since you are still testing)? Regards Seb
  8. Hello Matthew, Great looking site! kudos. A question - the news.php that you have intergrated into the site is that home grown or a contribution? I realy like it. Regards Seb
  9. Hello Matthew, Great looking site! kudos. A question - the news.php that you have intergrated into the site is that home grown or a contribution? I realy like it. Regards Seb
  10. Hi, I finaly found some time and will be finishing this hack mostly this afternoon early tomorrow, I am looking for someone to proof read the hack (my documentation skills are rusty). If you are still interested would you be kind enogh to let me know either reply email or post a message in the thread and I will forward the file to you for comment(s) prior to posting the contribution. Regards Seb PS I attempted to send a PM to your account but the forum threw back an error, and there is nothing in my sent box so if I have doubled up - applogies.
  11. Hello Linda http://www.oscommerce.com/downloads.php/co...ions,135/type,5 You may want to move to this thread - the powers that be may not like the cross posting :) http://forums.oscommerce.com/viewtopic.php...6468&highlight= Regards Seb
  12. As I quoted in the original post this mod is not all my original work and I must give credit to Ross Lapkoff for the bulk of the work. For those just wanting the main listing to show stock status his contribution is here http://www.oscommerce.com/downloads.php/co...ions,135/type,5 it will require a little bit of hacking to slip in to the current standard but it is all there. I wanted to show the status on every product page so I simply continued the mod onto the other pages. There seems to be a large amount of interest as my inbox keeps filling up with mail from webmasters that I don't know :o so I will download the current snapshot and see if I can make a contribution from it (my current code is full of other mods and sorting it out would be a nightmare) It will be a week or two though before I can get to it as we are now into a busy period for the next week or so. For those that can't wait drop me a line and I will add you to the list and forward you the files as I do them. :lol: Regards Seb
  13. :oops: that should be http://www.paladincomics.com fat fingers that's my excuse :oops: regards Seb
  14. I have just implemented a product status listing to a live store. It is a continuation of Product Listing Stock Status 1.0.0 by Ross Lapkoff. What it does - :idea: Displays product listing in main product_listing.php (in-stock -out of stock, pre-order - theorecticaly you could have a infinite number of status fields based on a set status ID. 0, 1, 2 ,3 etc ) Displays product_status in product_new.php (main page not box) Displays product status in product_info.php Displays product status in advanced_search.php Sort by product status. cart remains unchanged. Product does not disappear when status hits 0 You can see it hear (please this is a live store so if you place an order please indictate that your are from OSC and testing so that I can delete the order- btw it also has multiple add to cart installed as well) If I can get it to work with the new snap shot and interest is there I will roll it into a contribution. Can you let me know what people think, not the store just the mod. Much thanks regards Seb the url is http://www.palaldincomics.com
  15. fixed, I realy could'nt see the trees for the forest, I was'nt calling it right should have been <?php echo 'Status: ' . tep_get_products_status_name($product_info_values['products_status']); ?> :oops: