tommy11011 Posted April 13, 2005 Share Posted April 13, 2005 I was just wondering if there were any security problems, etc.. with osc. Where can I find any other problems that need to be corrected with osc? thanks. Link to comment Share on other sites More sharing options...
Guest Posted April 13, 2005 Share Posted April 13, 2005 @david: thanks for the explantion, for a moment I thought I had overlooked some kind of "single currency checkout" setting in admin :) @tom: most probs can be found at the bug reports section: http://www.oscommerce.com/community/bugs also: http://www.securityfocus.com/bid/vendor/ can be interesting/usefull sometimes Link to comment Share on other sites More sharing options...
mJULESY Posted April 14, 2005 Share Posted April 14, 2005 Guys i cant repoduce the problem, does this mean that im ok? have tried it several times.. ?currecny = eur but to no avail.. i am only a single currency site. Cheers in advance Link to comment Share on other sites More sharing options...
Guest Posted April 14, 2005 Share Posted April 14, 2005 Guys i cant repoduce the problem, does this mean that im ok? have tried it several times.. ?currecny = eur but to no avail.. i am only a single currency site. <{POST_SNAPBACK}> it only happens with the available currencies in your store. So in your case that would mean that you append "?whatever=whatever¤cy=gbp" or "?currency=gbp" to your url's. And I tested the site but it's not ok! (assuming it's www.wifigear.co.uk) Link to comment Share on other sites More sharing options...
mJULESY Posted April 16, 2005 Share Posted April 16, 2005 it only happens with the available currencies in your store. So in your case that would mean that you append "?whatever=whatever¤cy=gbp" or "?currency=gbp" to your url's. And I tested the site but it's not ok! (assuming it's www.wifigear.co.uk) <{POST_SNAPBACK}> And now im patched, :thumbsup: thanks PandA.nl and to Bert for the code. Will pass on the good news Link to comment Share on other sites More sharing options...
cgchris99 Posted June 27, 2005 Share Posted June 27, 2005 The posted fix stops the $0 checkout but does not fix the problem of having only 1 currency. My default currency is USD so EUR should not be allowed yet it is. Thanks for any advice Link to comment Share on other sites More sharing options...
Guest Posted June 27, 2005 Share Posted June 27, 2005 The posted fix stops the $0 checkout but does not fix the problem of having only 1 currency. My default currency is USD so EUR should not be allowed yet it is. <{POST_SNAPBACK}> I don't understand what the problem exactly is, it does not seem related to this bug though. Setting a currency as default is not to disable/disallow any other currency. Link to comment Share on other sites More sharing options...
Guest Posted June 27, 2005 Share Posted June 27, 2005 I don't understand what the problem exactly is, it does not seem related to this bug though. Setting a currency as default is not to disable/disallow any other currency. <{POST_SNAPBACK}> Yeah, setting a default currency doesn't actually remove the others. Go into your Admin>Localization>Currencies and remove all the currencies you don't use (Hi-light the currency, click delete). Or better yet, go into your database and delete them there. That's what I did, and don't seem to have this bug. Link to comment Share on other sites More sharing options...
wagnerch Posted June 28, 2005 Share Posted June 28, 2005 The appropriate fix for this is on the database side, this is a MySQL feature. The column should have been created with the BINARY attribute. You can modify the column using the following statement: alter table currencies modify code char(3) binary not null default ''; After that then MySQL will only do a binary comparison. See below... http://dev.mysql.com/doc/mysql/en/case-sensitivity.html Link to comment Share on other sites More sharing options...
AverageJoe Posted June 28, 2005 Share Posted June 28, 2005 The appropriate fix for this is on the database side, this is a MySQL feature. The column should have been created with the BINARY attribute. You can modify the column using the following statement: alter table currencies modify code char(3) binary not null default ''; After that then MySQL will only do a binary comparison. See below... http://dev.mysql.com/doc/mysql/en/case-sensitivity.html <{POST_SNAPBACK}> Thanks wagnerch, worked perfectly :thumbsup: Link to comment Share on other sites More sharing options...
Guest Posted June 28, 2005 Share Posted June 28, 2005 The appropriate fix for this is on the database side, this is a MySQL feature. The column should have been created with the BINARY attribute. <{POST_SNAPBACK}> funny, I read something like that before in this thread or the the currency code column fields should be declared BINARY in the database. <{POST_SNAPBACK}> :) Link to comment Share on other sites More sharing options...
wagnerch Posted June 28, 2005 Share Posted June 28, 2005 funny, I read something like that before in this thread :) <{POST_SNAPBACK}> I guess that makes two people that have read the documentation. Link to comment Share on other sites More sharing options...
Guest Posted June 28, 2005 Share Posted June 28, 2005 I guess that makes two people that have read the documentation. <{POST_SNAPBACK}> yep :) Link to comment Share on other sites More sharing options...
Dave Grennan Posted August 21, 2006 Share Posted August 21, 2006 Hi, I just found another slant to this which I thought I'd post. When I set up my store (on local PC) all my prices were coming up as zero even without the ¤cy= querystring component. I applied all the fixes (set the code field to binary, added the code above //currency) still nothing. Then it hit me. I am using EUR and had deleted USD from the DB and added EUR, but I had not set EUR as default, therefore their was no default currency! Set EUR to default and it works great!! and no matter what i do to the querystring it still works:) Thanks, Dave Grennan. Link to comment Share on other sites More sharing options...
Dave Grennan Posted August 21, 2006 Share Posted August 21, 2006 Oh and another problem I found if you delete currencies from the DB and are stupid enough (like me) to fail to set a new default currency. If you then hit 'update currencies' then the currency is converted against the old default currency and your prices go mad!!! BTW the reason I deleted direct from the DB was that when I tried to delete a currency the correct way All I got was a 'cancel' button and no 'delete' option. (Yes i know that not this bug, just explaining why I deleted via the DB. So in short. If you delete currencies via the BD, dont forget to set a new default currency!! Dave Grennan Link to comment Share on other sites More sharing options...
Guest Posted August 23, 2006 Share Posted August 23, 2006 my problem is nearly the same i have $ as the default currency and at 2 new ones GBP and Euro after then i run in problems - because everytime i switch my site from german to english the $ shows up even if the GPB is the default currency so now i did delete the usd $ currency but all the default GBP prices are show up as Zero if i switch to german and espanyol the prices are correct in ?. the fix with oanda in the contributions doesnt work in this case and i stuck right now anyone have another idea to point me in the right direction Thank you very much Link to comment Share on other sites More sharing options...
Guest Posted August 23, 2006 Share Posted August 23, 2006 forgot the link to the contribution http://www.oscommerce.com/community/contri...search,currency Link to comment Share on other sites More sharing options...
Guest Posted August 23, 2006 Share Posted August 23, 2006 a search in the forum was the solution - it works now thank you. Link to comment Share on other sites More sharing options...
mr_to Posted September 28, 2010 Share Posted September 28, 2010 to fix the default currency or a currency exist i change the function tep_currency_exists (in general.php) even somebody demand a curency ZZZ the prices are ok (yourwebsite.xxx/xxxxx.xxx?language=en¤cy=ZZZ) remember to declare the default curency in the admin and use uppercase code (EUR,FRF,FCH ...) // Checks to see if the currency code exists as a currency // TABLES: currencies function tep_currency_exists($code) { $code = tep_db_prepare_input($code); $currency_code = tep_db_query("select currencies_id from " . TABLE_CURRENCIES . " where code = '" . tep_db_input($code) . "'"); if (tep_db_num_rows($currency_code)>0) { return strtoupper($code); } else { $code = DEFAULT_CURRENCY ; return strtoupper($code); } } in application_top.php add this line $currency = tep_currency_exists($currency); after // currency if (!tep_session_is_registered('currency') || isset($HTTP_GET_VARS['currency']) || ( (USE_DEFAULT_LANGUAGE_CURRENCY == 'true') && (LANGUAGE_CURRENCY != $currency) ) ) { if (!tep_session_is_registered('currency')) tep_session_register('currency'); if (isset($HTTP_GET_VARS['currency'])) { $HTTP_GET_VARS['currency'] = strtoupper($HTTP_GET_VARS['currency']); if (!$currency = tep_currency_exists($HTTP_GET_VARS['currency'])) $currency = (USE_DEFAULT_LANGUAGE_CURRENCY == 'true') ? LANGUAGE_CURRENCY : DEFAULT_CURRENCY; } else { $currency = (USE_DEFAULT_LANGUAGE_CURRENCY == 'true') ? LANGUAGE_CURRENCY : DEFAULT_CURRENCY; } } Link to comment Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.