X-Cart forums

[mffowler]

SQL PATCH FAILED AT QUERY:
INSERT INTO `xcart_modules` VALUES (74, 'Multiple_Currency', 'Enables users to select different currencies to be displayed.', 'Y')

Any other ideas?

Thanks,

Mike

[koaloa]

Hi Mike,
Well my guess is that you already have a module with id #74 on your system. I used phpMyAdmin to export the field and it put that number in there, I should have removed it to play it safe. Anyway, I'd recommend you going into phpMyAdmin and just adding a new row into the table, leaving the 'moduleid' field empty, and filling in the other fields. Let me know if you are unsure of how to do this and I'll help you out.

Alternatively, you can run this query:

INSERT INTO `xcart_modules` (module_name,module_descr,active) VALUES ('Multiple_Currency', 'Enables users to select different currencies to be displayed.', 'Y')

[Corto_Maltese]

Hello, Koaloa,

Great mod... I have an 4.0.18 xcart version, and it is almost perfect : I have not the currencies into the drop-down list, in the top_menu.tpl.
And the same question than mffowler : what is the 'shop.php, in the 'show_currency_options.tpl'.
if you can help, it will be fantastic.
Thanks.
Erick

[koaloa]

Hey guys,
My reference to "shop.php" is the main shop.php script used by X-Cart. What I'm doing is causing the original page to be reloaded with the new currency values displayed (regardless of which page of the site they are on). This is not a script I've created. It's really a detail, nothing so tricky really.

If you're not getting values to appear in your combo-box I think the problem is elsewhere. Are you sure you entered the right values into the mySQL table/database? The function "func_koa_get_currency_rates" (in the "show_currency_options.tpl" file) makes a mySQL call to get all entries from the "xcart_currencies" table, but ONLY if they have a rate value that is not equal to zero (rate != '0'). This code that populates the combo is really simple. So make sure you've set these values appropriately and you should see your combo populated.

Hope this helps.

[mffowler]

Koaloa-

I have the mod showing up and there are the default currency values in the mods admin area, but the dropdown is blank. There is no shop.php - can you think of ahything else that is missing?

Thanks,

- Mike

[koaloa]

You're right, there is no "shop.php", I think I mistakenly put that in there, but it still works as it should because there is actually no submit button, just a javascript redirect that causes the page to reload.

Back to your problem, try putting in a print statement in the func.php file (that's part of my module) to see what it finds from the database. I'm thinking you MUST not be able to retrieve the entries from the db.

I usually use a line or two like the following:

echo "<pre>";
print_r($rows);
echo "</pre>";

[Corto_Maltese]

Hi,
Just a question : why are the alter_currency rates stocked in the xcart-config table ? I do not understand well. I thought the Multiple_currency screen saved the data in the xcart-currencies table?
And, btw, I am on a 4.0.18 version. Do you think your code works well? Or do you have some idea/modification for that ? (if you have time to debug...)
Many thanks in advance
Erick

[mffowler]

Still no luck with this... dropdown remains empty...

Has nayone got this to woprk on 4.1.2?

Thanks,

Mike

[koaloa]

Hey guys,
This really boggles me why it's not working for you. Well let's try and debug this... my GUESS is that the script is not able to pull the values out of the database for some reason. To start, make a backup of the file /<your store dir>/skin1/customer/main/show_currency_options.tpl and REPLACE it with the following code. What I'm trying to do is just print what currency values are found in the database. Please let me know if the page prints out all of the currency rates in the database (this debug script is just for testing purposes, it will just print the values and then cause the script to terminate). Please show me your results. Thanks!

{* $Id: alter_currency_value.tpl,v 1.11.2.1 2006/04/29 06:36:56 max Exp $ *}
{literal} 
<script language="javascript">
<!---
function SelectLink(form, url) {
	/*alert(document.currency_select_form.currency_options.options[document.currency_select_form.currency_options.selectedIndex].value);*/
	
	window.location.href=url + "currency_code=" + document.currency_select_form.currency_options.options[document.currency_select_form.currency_options.selectedIndex].value;
}
//-->
</script>
{/literal} 
{php}
// Debug Info:
/*
echo "<pre>";
print_r($_COOKIE);
echo "</pre>";
*/
$CURRENCY_RATES = func_koa_get_currency_rates();
echo "<pre>";
print_r($CURRENCY_RATES);
echo "</pre>";

{/php}
<form name="currency_select_form" action="nothing.php" method="post">
<select name="currency_options" onChange="SelectLink(document.currency_select_form, '{php} 
$url = $_SERVER['REQUEST_URI'];
// remove any existing 'currency_code' variables.
if(strstr($url, "currency_code")) {
	// we DID find the variable, so remove it!
	$url = preg_replace("/currency_code=[a-zA-Z]+(&)?/", "", $url);
}
$parsed_url = parse_url($url);
if(!strstr($url, "?")) {
	$url .= "?";
}
//echo "query is: " . $parsed_url[query] . "<br>";
if(trim($parsed_url['query']) != "") {
	$url = trim($url, "&");
	$url .= "&";
}
echo $url; 

{/php}')">
{php}

global $smarty, $currency_code;

$CURRENCY_RATES = func_koa_get_currency_rates();

if($_COOKIE[currency_code] != "")
	$currency_code = $_COOKIE[currency_code];
	
for($i = 0; $i < count($CURRENCY_RATES); $i++) {
	$cur_rate = $CURRENCY_RATES[$i];
	$abbrev = $cur_rate->code;
	if($currency_code == "" && $abbrev == "USD")
		$selected_str = "selected=\"selected\"";
	if($currency_code != "" && $currency_code == $abbrev) {
		$selected_str = "selected=\"selected\"";
		$default_selected = true;
	}
	echo "<option  value=\"$abbrev\" $selected_str>$abbrev</option>\n";
	$selected_str = "";
}

{/php}
</select>
</form>
{php}
/*
echo "<pre>";
print_r($_COOKIE);
echo "</pre>";
*/
{/php}

[bngwarehouse]

Downloaded the Module but when I try and unzip it there is a password to extract the contents. Hmmm?