Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

dmGremlin

Members
  • Content count

    68
  • Joined

  • Last visited

Everything posted by dmGremlin

  1. I've just successfully tested this mod I've been working on - it's kind of like the other contribution by this name found here http://www.oscommerce.com/community/contributions,367 except with this one, I've created a separate database table to hold individual shipping prices that you can modify in your admin like any other product variable - which means you can keep your 'weight' field and use this contribution with any other shipping modules... such as 'multi vendor shipping' if you were so inclined. If there's enough interest for this, I'll go ahead and package it as a contribution and upload it.
  2. dmGremlin

    Ebay auction manager for OSCOMMERCE

    You tried my link, but did you replace the x's with your own encrypted password...? Hmm.. I'm not sure if you already tried this, but in order to get this to work you have to turn your cookies off, then actually log in with your username and password - in the address bar then you'll see your encrypted password.... then replace the x's in my previous link with that password and it should work, and my username with your username and it should work.
  3. dmGremlin

    Ebay auction manager for OSCOMMERCE

    Also, a possible idea for the 'timing' problem, you could perhaps have a page on the admin side that stays open and uses javascript perhaps to open the ebay auction .php page and refresh it every 30 minutes, to keep itself updated... maybe not the most elegant solution, but it would function.
  4. dmGremlin

    Ebay auction manager for OSCOMMERCE

    Don't let them discourage you smitty, I think you've got a good idea here. It looks like we're having a little 'contribution rivalry' - anyway, I was just poking around Ebay today and I found you can pass your password through the address bar... although it has to be encoded somehow, so if we can figure out this how to encrypt the password in the way that ebay wants to see it, this should fix the password issue. I don't see this as changing, either, since eBay will need to have a way to function for users without cookies. i.e.: http://contact.ebay.com/aw-cgi/eBayISAPI.dll?ReturnUserEmail&requested=jwphotovideo&de=off&iid=2926539763&frm=366&acceptcookie=0&loginconfirmed=0&pass=XXXXXXXXXXX/&userid=dmg@dm-gremlin.com As you can see, I changed my password to X's - in case someone figures out how it's encoded, but this is the link that would need to be followed to find the email information page for 'jwphotovideo'... anyways, give it a go and see what you think. Actually, perhaps it wouldn't be necessary to figure out the encryption... since you can pretty easily see what your own encrypted eBay password looks like in the address bar, you could just have each user copy that bit and paste it into a definitions part in your .php file so that the program sends this unique information when trying to request the email info page. Well, perhaps one more piece in the puzzle.
  5. dmGremlin

    Ebay auction manager for OSCOMMERCE

    One good place where I check out SQL commands is in PHPMyAdmin - whenever I take any action using the html buttons, it shows me up at the top what the SQL command that it executed was... I've used this a few times to figure out the proper way to state a query. I'll look into the cookie thing. I was just reading up on cookies, trying to modify the PWA mod... I hope all is going well -D. M.
  6. I thnk one problem that might happen is if the order_info doesn't check for a password, it would be possible for a purchase/w/o/acocunt user to create a 'temporary' account with the same email address as someone else... then if that temporary account weren't cleared from the database, say because of someone exiting the shop before checkout was finished, then you'd have two accounts with the same email address - thus potentially making it impossible for the 'real' account to log in. If someone can tell me why this wouldn't be an issue, then there would be no sense in keeping the password check. What would be ideal is if all the customer information were stored in a cookie instead of stored to the database... that would finally clear up the last of the problems with the PWA mod.
  7. dmGremlin

    Ebay auction manager for OSCOMMERCE

    Hey smitty, this mod kicks ass - I've got it up on my site if anyone wants to see another working example: http://www.dm-gremlin.com/sales/current_auctions.php The ideas I have to fully implement this as per your suggestions are a little beyond my abilities to program unfortunately, but I'm going to spew forth a few thoughts anyway... the first issue would be to figure out how to get osC to automatically read when the ebay auction closes. As it stands now, the script only calls (I think) data from the ebay page when the current_auctions.php page is loaded - meaning if you were to put something in the current_auctions.php script to detect when the auction closed... and nobody opened that page after the auction closed, it wouldn't know the auction was over... so you'd have to put it somewhere else. once this issue is solved, the next step I suppose would be at the auction closing time, to parse all the information and create a product - perhaps a hidden product like it was discussed earlier in this thread - and a user account that can access that product... finally, the script would send the login details to the buyer (also possibly a problem, since you have to be logged into ebay to access the buyer's email address). Hmm... step two seems difficult, but understandable... I have no idea how I would go about solving step one and three, though I'm sure if we all put our heads together we can figure it out.
  8. I already left easy instructions on how to intigrate this contribution with Multi-Vendor shipping, and as I explained above - I'm not modding anything for MS2 at this time. You should be able to apply the same mods that were used in this topic to get this contribution to work with MS2 to get Multi-Vendor to work with MS2 - but I'm not sure. You might try looking at what mods needed to be made to the other shipping contributions (like the fedex one for example) for MS2 to give an idea of what needs to be changed in Multi-Vendor.
  9. Curl on my server is located at: "/usr/bin/curl" So when the script runs I get the typical: Fatal error: Call to undefined function: curl_init() in /home2/dmg/public_html/test/includes/modules/shipping/fedex1.php on line 165 error. I noticed that the Airborne Express contribution has in it's code a part that calls for Curl in /usr/bin/curl I.E.: exec("/usr/bin/curl -d "$request" https://eCommerce.airborne.com/$api", $response); Is there a way to modify the Curl calls in this Fedex contribution to call Curl from /usr/bin/Curl...? function _AccessFedex($data) { $ch = curl_init(); and so on is where the calls take place in this fedex module... I tried changing all the calls to something like: $ch = exec("/usr/bin/curl -d curl_init()"); while that removed the error message, it didn't seem to work (no data in the $reply string)... of course I was just guessing. I have no idea how to call a Curl command, much less from a specific location. Any ideas?
  10. I see 'This enables you to choose from the several shipping methods Airborne offers: Ground, Second Day Service, Next Afternoon, Express, Express 10:30 AM, and Express Saturday' in the methods availble in the docs... but will this module handle international shipping?
  11. Aside from trying that mod I was talking about above (actually now that I think about it more, it wouldn't work) - you could use the Multi-Vendor shipping with the Individual Shipping contribution, configure all your products that are under 75 (or 150) pounds to use UPS and use individual shipping charges for the rest. ryno - the bug you're describing is a bit odd. From my thinking, at the very worst your shipping charges would be as though you only ordered one item - but the fact that the shipping charges are '0' makes me think there might be a typo somewhere. Ok, I think I see it. Whoops. this: // mod indvship // first mod ok $this->shiptotal += ($products_ship_price * $qty); $this->shiptotal += ($products_ship_price); if ($qty > 1) { if ($products_ship_price_two > 0) { $this->shiptotal += ($products_ship_price_two * ($qty-1)); } else { $this->shiptotal += ($products_ship_price * (qty-1)); } } // end indvship should be this // mod indvship // first mod ok $this->shiptotal += ($products_ship_price * $qty); $this->shiptotal += ($products_ship_price); if ($qty > 1) { if ($products_ship_price_two > 0) { $this->shiptotal += ($products_ship_price_two * ($qty-1)); } else { $this->shiptotal += ($products_ship_price * ($qty-1)); } } // end indvship I had left off the $ from $qty. Sorry about that.
  12. Hey there Ryno267/Chuck. Nice work putting that together - feel free to post it as an addon contribution if you like. I saw that problem you mentioned, about having to have something in the second individual ship price field no matter what and thought of a solution while I was looking at the code: perhaps if you changed: // mod indvship // first mod ok $this->shiptotal += ($products_ship_price * $qty); $this->shiptotal += ($products_ship_price); if ($qty > 1) { $this->shiptotal += ($products_ship_price_two * ($qty-1)); } // end indvship to something more like // mod indvship // first mod ok $this->shiptotal += ($products_ship_price * $qty); $this->shiptotal += ($products_ship_price); if ($qty > 1) { if ($products_ship_price_two > 0) { $this->shiptotal += ($products_ship_price_two * ($qty-1)); } else { $this->shiptotal += ($products_ship_price * (qty-1)); } } // end indvship you might want to test that first, since that's just off the top of my head, but that should make it so if the second ship price field is 0 that it takes from the first price field... which might not be something everyone would want... but maybe more people would like that in there than not...and it would be easy enough to comment out. Genius also brought up an interesting point in a private message I have neglected to look at in any detail until now... as it stands now, if you have two different products in the cart, it will use the first price for the first one of each item then the second price for any quantity beyond one for each item, but say you wanted to use the second price on every item after the first item in the cart, regardless of if they are different products... this opens up a small can of worms in that you'd have to figure out how to specify which item came first - so that the first price would be accurate. Beyond that, I think you'd just have to replace one line... well I'm not entirely sure what to replace it to, but there's a function in the shopping_cart.php called 'count_contents' that seems to count the total number of things in the cart. You'd need to put an if statement that if the contents were more than 1, use the second price... I can't think of the proper 'spelling' for this offhand but if someone were to start tinkering with it, that would be a good place to start. As far as the shipping thing goes, Mark... multi-vendor shipping combined with this mod might be the way to go... but the multi-vendor mod only works with MS1 as far as I know. Assuming you're in MS1 though, just use individual shipping on all items over 75lbs and then ups for the rest... or although I'm not going to look at it right now (this whole PHP thing is making me cross-eyed) there is a way you can add a line to the top of any given shipping module (look in the catalog/includes/modules/shipping/indvship.php or ups.php) to enable or disable it... $this->enabled == true; so you could surround that with an if statement like if ($shipping_weight > 75) { this->enabled == false; } oh, and don't forget to add $shipping_weight to the global variables i.e. global $order, $shipping_weight; - but you might want to test this too as this is just off the top of my head. As far as the handling stuff, mikeinbigfork - I'm fairly sure that the multi-vendor shipping allows you to do what you're asking... you have to manually plug in the handling through the database but it's there. Haven't tested it though. Thank you Aric for porting this over to MS2. Much appreciated. As far as my whole philosophy about the MS1 - MS2 thing, I have more than 20 contributions installed on my shop, plus a bunch of mods I did myself. I was using a snapshot - post MS1 which included the security fixes but not any of the radical changes that created incompatibilities. I am anticipating that by the time I would be done making all the contributions I'm using compatible with MS2, MS3 will come out and break all of them again... so until there is some major improvement in functionality that I absolutely can't do without, all of my mods will remain based on MS1. I wish the core developers would start adding in some of the contributions to the milestones, as it would sure make upgrading a lot less painful for some of us, but that's up to them. Anyways, glad to see this contribution is useful. Sorry I don't come around here much anymore. I got kind of burnt out on coding for while.
  13. you will need to use the multi vendor shipping contribution found here: http://www.oscommerce.com/community/contributions,969 to do what you're trying to do.
  14. that's one way of doing it. An easier way since you're using phpMyAdmin would be to simply click the 'SQL' tab up top, cut and paste your query i.e.: INSERT INTO configuration_group VALUES (40, 'Accounts', 'Configuration of Account settings', 40, 1); in the big box, then hit 'Go' and you're all set.
  15. dmGremlin

    Ebay auction manager for OSCOMMERCE

    One problem I can think of for finding out the email address is that you have to be logged into ebay to get that email address. The time left though, could be done one of two ways - first way would be to get the time from your own server and then program some math to subtract one from the other to determine the time left, except if your server's time is a minute or two off from ebay's time, that might not be so good. The other way would be perhaps to get the script to open the item number's page and snag the stuff after 'time left' in the same way it snags all the info from the 'about me' page. That might be a little tricker than just grabbing the text off of the 'about me' page due to all the potential different states of the item page. Hmm, just a few of my first thoughts - I'll keep thinking about this. Thanks for posting the code.
  16. dmGremlin

    Ebay auction manager for OSCOMMERCE

    Very cool mod, smitty1 - Maybe you could post a link to your already osCommerce intigrated version so that I (and anyone else) could take a look and perhaps help with the functionality?
  17. I just got this thing up and running with no problems... I'm using a CVS snapshot from May 1. I used the 1.3.1 and the direct link thingy... so I guess try it out and take your chances. It's really easy to install or remove - and make sure you have at least one order to test on. At first glance, it looks a little outdated, and I think there might be a problem updating the shipping, as it's showing more options than I have, and i never installed a 'store pickup' shipping module, and it's not showing the other shipping modules that I DO have installed - that might take a little modding. But it functions well as best I can tell, can update quantities, set quantity to 0 to remove, etc... And MaxiDVD - just a thought, I don't have that random order id installed (where can I get it?) but it looks like the queries in update_order.php are not geared to handle anything but a number. Try changing these lines: find - $Query = "UPDATE orders SET " . join(", ",$tmp_Query) . " WHERE orders_id=$OrderID"; and change it to $Query = "UPDATE orders SET " . join(", ",$tmp_Query) . " WHERE orders_id='" . $OrderID . "'"; then find // Insert New Orders_Products Record $Query = "INSERT INTO orders_products SET orders_products_id=NULL, orders_id=$OrderID, products_id=$NewOrdersProductID, products_model='" . $Row["products_model"] . "', products_name='" . $Row["products_name"] . "', products_price='" . $Row["products_price"] . "', final_price='" . ($Row["products_price"] + ($Row["products_price"]*($Tax/100))). "', products_tax='$Tax', products_quantity=" . $NewOrdersProductQuantity; and replace that with // Insert New Orders_Products Record $Query = "INSERT INTO orders_products SET orders_products_id=NULL, orders_id='" . $OrderID . "', products_id=$NewOrdersProductID, products_model='" . $Row["products_model"] . "', products_name='" . $Row["products_name"] . "', products_price='" . $Row["products_price"] . "', final_price='" . ($Row["products_price"] + ($Row["products_price"]*($Tax/100))). "', products_tax='$Tax', products_quantity=" . $NewOrdersProductQuantity; and let me know if that works... oh, iiinetworks already thought of that. Well, that's where the two queries are at any rate.
  18. I think it varies depending on what snapshot you've got. My application top is: v 1.272 2003/03/31 17:25:36 - and has four instances of tep_session_start() after playing a little 'cut and paste battleship' I was able to get mine to work, of course the originating URL gets removed when the session expires (a little bit annoying but hey, that's the way this thing works for now) To get mine to work I inserted the code if (!$referer_url) { $referer_url = $HTTP_SERVER_VARS['HTTP_REFERER']; if ($referer_url) { tep_session_register('referer_url'); } } right above // Shopping cart actions and that did the trick. Of course, I've still got the problems of the recorded time sometimes being wildly inaccurate (besides the +2 hours for my server) and 12 hour idle times and stuff like that but now it basically works.
  19. You're most welcome, Genius! :) It sounds like you've got it all figured out, but just for the sake of the forums, yes - I did mean admin/categories.php instead of admin/catalog.php
  20. dmGremlin

    Ebay auction manager for OSCOMMERCE

    I'm glad it's working for you. After a bit of struggle, I finally figured out how to modify the hidden products contribution the way I had intended, without any additional queries. The mod is actually a fairly simple one... perhaps I'll even release it as an enhancement to the original contribution if anyone wants it. Basically what it does is changed the customers_approved and products_customers_approved to 3 digit integers - independent numbers that need to match up for the customer to see a given product, so that means you could have 1000 hidden products (or more if you wanted to expand the tables) with each customer seeing only the product that that individual customer is supposed to. Also, there is one number that can see all of the hidden products, and a definable range of hidden products that can't be seen in any of the searches and can only be found by direct request. So to sum up, to handle my future ebay auctions I will create a hidden product that can only be seen by direct request by an individual customer, after the auction closes create an account for the auction winner that can uniquely see that product, and handle the shipping costs with my individual shipping contribution handled by a modified multi-vendor shipping so that I can continue to sell other products normally through the site. That is my ebay auction handling solution. A slightly simpler method would be to use the hidden products mod 'as is' but remove the part that the mod added in the file 'product_info.php' so that anyone with a direct link to the hidden product can see it without the need to be logged in.
  21. whoops! looks like there's a typo in the code I posted, actually I just forgot to add in the closing bracket. at the very end of the code I posted on that last page, add a closing bracket thingy } to end the else statement like this: } else { $email_order = STORE_NAME . "n" . EMAIL_SEPARATOR . "n" . EMAIL_TEXT_ORDER_NUMBER . ' ' . $insert_id . "n" . EMAIL_TEXT_DATE_ORDERED . ' ' . strftime(DATE_FORMAT_LONG) . "nn"; } that should fix your parse error. Hmm... I wish I could edit my previous posts. -D. M.
  22. dmGremlin

    Ebay auction manager for OSCOMMERCE

    Ok, got the hidden product thing up and running, and even figured out a fairly easy way to modify it to allow only specific customers access to specific products, instead of a universal 'customer approved' flag, but it would double the amount of sql queries, which might make things twice as slow so I'm trying to figure out a better way. or, it would actually be fairly simple to add the code that specifies that only a certain customer can look at a certain product only to the product_info.php page without too much hassle, and without slowing down the queries on any of the other pages... that could still achieve the desired effect as described a few pages back... If anyone is interested in what I'm doing with this, let me know. Anyways, bluephoenix, did you try to input the changes manually or did you just copy over the files? I compared the files with Beyond Compare and catalogued all the changes (in my own twisted shorthand) and then put in the mods manually and it seemed to work just fine. The one place in default.php where the modifications might be giving you an error is of course in the sql queries... like this line // We are asked to show only a specific category $listing_sql = "select " . $select_column_list . " p.products_id, p.manufacturers_id, p.products_price, p.products_tax_class_id, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd, " . TABLE_MANUFACTURERS . " m, " . TABLE_PRODUCTS_TO_CATEGORIES . " p2c left join " . TABLE_SPECIALS . " s on p.products_id = s.products_id where p.products_status = '1'" . $new_products_where . " and p.manufacturers_id = m.manufacturers_id and m.manufacturers_id = '" . $HTTP_GET_VARS['manufacturers_id'] . "' and p.products_id = p2c.products_id and pd.products_id = p2c.products_id and pd.language_id = '" . $languages_id . "' and p2c.categories_id = '" . $HTTP_GET_VARS['filter_id'] . "'"; if you misplaced a " or ' somewhere while puttng in the " . $new_products_where . " that will break your query... but adding that bit into in 6 queries (and defining the $new_products_where string right above those queries) are the only changes that the hidden products mod makes to your default.php
  23. and that would be if $qty > 1 { instead of if $qty => 1 { and so on and so forth.. ahem
  24. one typo and an error in my math above. it would have to be more like $this->shiptotal += ($products_ship_price); if $qty => 1 { $this->shiptotal += ($products_ship_price_two * ($qty-1)); } otherwise it would count one too many. that should do it though.
  25. Hey thanks MaxiDVD - glad I could be helpful... :) Yeah, MS2.2 - I've done so many modifications (19 contributions and counting so far, plus a ton of my own modifications) to my store, upgrading for me could be kind of ridiculous. I've taken a peek at the workboard and the weekly updates, but I couldn't find any mention of whether or not they were including any contributions. The daily snapshot I installed my site from was only from two months ago so maybe I can manually update... I think if the PWA were to be intigrated, I would want to see a slightly different handling of the process of removing the customer account from the database, maybe even have all the customer details stored in a cookie instead, and have a duplicate checkout path for people checking out without an account that reads the info from the cookie? Either that or maybe have some kind of javascript that can tell if the user closes their browser before checkout_success and erases the temporary customer info from the database at that time through Javascriptiing... though I don't know if that's possible. As for the logic of that last bit of code... as far as I can tell, the if statement first checks to see if the customer is a 'noaccount', if so - destroys the session and redirects them... somewhere. If not, it keeps the session and redirects them somewhere else. It would be important to destroy the session if the account is a 'noaccount' but not if the user was logged in. I noticed that in later versions of the code for the rest of osCommerce, they have removed the 'NONSSL' and 'SSL' parts. I'm not entirely sure why, but I figured it might be a good idea not to add them back in. As far as the $notify_string, I really have no idea. If I were to guess, I'd say the $notify_string takes you to the last page of the checkout. My thinking was, since the essence of what this PWA addition was trying to do was simply to destroy the session at checkout if the customer was a 'noaccount', I tried to alter as little as possible from my original code to make that happen. I wish I could be more specific, but I have only a very crude understanding of php.
×