Jump to content

Dan Cole

♥Ambassador
  • Content count

    2,692
  • Joined

  • Last visited

  • Days Won

    57

Everything posted by Dan Cole

  1. Dan Cole

    Unique orders status id.

    I'm looking to update an old payment module Interac Email Money Transfer and it adds an orders status id to the database to set up an order status of "Waiting for Payment". Unfortunately it just adds the orders_status_id of 4 in a table update as follows: tep_db_query("insert into orders_status (orders_status_id, language_id, orders_status_name ) values ('4', '1', 'Waiting for payment')"); In my case I already have an orders_status_id of 4 in my database so it fails. Obviously I can easily fudge the id in my case but if I'm going to upload the contribution back to the community it'll cause problems for others so I'm wondering if there is a simple way to just have it add a unique id to the database or if I need to query the database for the last added id and go from there? That too is not a problem but this has me wondering if that is the best/simplest approach. Suggestions anyone? Dan
  2. Dan Cole

    Unique orders status id.

    That's awesome and works perfectly. Thanks Matt. I appreciate it. Dan
  3. Dan Cole

    Generated link Concept

    Brilliant idea and coupled with your original suggestion of changing the access point of pages like create_account I think it would go along way to solving the bot issue. 👍 Dan
  4. Dan Cole

    HoneyPot Captcha

    I thought that was an excellent suggestion too. I think Matt @ecartz is doing some work in this area and while it might be beyond the scope of his project it is probably worth bringing it to his attention. Which I guess I just did. Dan
  5. Dan Cole

    How can i automate a SQL update query?

    I don't know if it's appropriate for your application or not but you could always trigger it on a page call...ie someone visits one of your store pages and the call gets executed. Dan
  6. Dan Cole

    Convert a magento extension to oscommerce addon

    Yup...make sure you start out with the right version of the osC software. Dan
  7. Dan Cole

    Documentation Initiative

    Absolutely. If you're going to tackle a section that is included in the existing documentation then by all means use that as a starting point. We don't want to reinvent the wheel, we're just going to improve it. The biggest challenge will be the many modules and options that have been introduced since the documentation was originally developed. Those are probably the areas that require the most effort and where the greatest need exists. Dan
  8. 'Nothing ventured, nothing gained' --- In order to achieve, you need to act and take risks. I think we can all agree that the existing documentation is a bit dated. A lot has changed since it was written and it is in bad need of an update. Doing so will no doubt require a ton of work but if we crowd source it, I'm sure we can come up with something useful for the entire community. If you want to help out and give something back this is your chance. It's an opportunity for everyone to get involved. I think a good place to start would be to document what each of the menu options, on the admin side, does. As a start and example, here is what Fredi Rubinshtein and I came up with. Navigation Bar and the NavBar Modules If you agree that something along this line in needed and would like to help out just pick a menu item and post here which item you've decided to tackle. We don't want to duplicate the effort. I'll try to keep track of who is doing what and create a bit of an index. For those tackling a menu item please try to follow the example and provide a brief explanation, with screen shots of the steps involved and what they do. It would be nice if we ended up with a document that looked as if it was part of a single effort. Let's do this. Dan
  9. Dan Cole

    Documentation Initiative

    Yeah....but that's not going to happen. I have no intentions or documenting it myself....I wanted to set things up so others can get involved and have an opportunity to advance osC. Since you'd be just doing it once and someone else will translate it, it should be no different than someone doing it in English and you translating it to Spanish. Same effort and perhaps insanity. If you're not interest...no problem. Dan
  10. Dan Cole

    Documentation Initiative

    Maybe header tags? or header modules. Just let me know what you select....regarding the screen shots maybe a fresh English install would work....you probably want a blank slate to work with anyway. Dan
  11. Dan Cole

    Documentation Initiative

    If you really want to help, that shouldn't be a problem....why don't you write it up in Spanish, do the screen shots etc and we'll get someone to convert it to English? Dan
  12. Dan Cole

    Terms of Use.

    I don't think he meant to include personal TEST sites that have nothing to do with osC or are not running on osC software but I believe he has been asked for clarification. Hopefully we'll have a definitive answer in the near future and can proceed accordingly. Dan
  13. Dan Cole

    Does osCommerce work "out of the box"?

    No problem...if there is something that is not clear regarding rule #2 lets talk about it in that other thread. Dan
  14. Dan Cole

    Does osCommerce work "out of the box"?

    Yup...just doing my job and responding to the complaints. Dan
  15. Dan Cole

    Does osCommerce work "out of the box"?

    Please take the OC chatter to the OC site. Dan
  16. Dan Cole

    Terms of Use.

    I agree and there is no reason you can't. You just need to word it appropriately and not directly link to the external site. Talking about new features and developments is one of the main reason the forum exists. Dan
  17. Dan Cole

    Terms of Use.

    Okay I'm now probably about as awake as I'll get today. I'm sure we do and I kind of liken it to our local by-laws. Generally our by-law officers expect that folks will respect and comply with the laws (rules) as enacted. That works in most cases but when those rules are violated they are enforced on a complaint type basis. The community doesn't have the resources to do otherwise so if you violate the by-laws and someone complains, they are enforced. On the other hand, if they go unnoticed or you are liked by your neighbors you're not reported and end up getting a pass. Those who are not liked are usually reported and end up receiving warnings or tickets on a regular basis. The rules on this forum tend to work this way too -- if a post is reported it is usually dealt with, generally with a warning and a reminder of what the rules are. That is how I deal with it and how I've seen this process work over the years. IMHO that is probably how it should be. I've seen this several times too and I've also seen Garys @burt response that I think referred to a subsequent post from HPDL indicating this was okay in certain circumstances. I'm not sure I've seen the post itself but it might be helpful if we reviewed that. It would be good to have some clarification on it. And lastly... As long at these are to osC test sites I don't see that being an issue. Linking to competitors software or test site running competitors software is, I think, another story. If you're saying that has been okayed by HPDL too please post it here so we can ignore those posts in the future. Okay gone to get more coffee. Dan
  18. Dan Cole

    Does osCommerce work "out of the box"?

    Moved the post that was referenced to a separate thread for further discussion. Dan
  19. Dan Cole

    Terms of Use.

    I split this topic out from another thread. I think it deserves it's own thread. I'll comment further when I wake up. Coffee is in hand. Dan
  20. Dan Cole

    Does osCommerce work "out of the box"?

    You can talk about the merits of osC without violating the terms of use. The OP wasn't asking about a competing product he was asking about osC. Dan
  21. I simply moved my existing (old) database and adjusted it to suit Phoenix. I have lots of extra data that I didn't want to lose. I could have added all the extra fields to the new Phoenix database but that would have resulted in a having copy of the old database anyway. So I took the easy way out. So far I've only run into one field that needed be added to my old database. products_gtin. I also copied over the Phoenix configuration and configuration_goups tables to my old database so I got rid of the old settings and started Phoenix fresh. Just pointing out that there are other ways to skin a cat. Dan
  22. Agree...I just wanted to make it crystal clear. Simply because it is being removed from the core doesn't mean it'll no longer be available. Dan
  23. If I'm reading things correctly...it'll become available as an app....there is just no reason for it to remain as part of the core. Removing it will give the development community free rein to build it out as they wish. Dan
  24. Dan Cole

    Jssor Slider

    Early days but it seems to work just fine Jack. Dan
×