X-Cart forums

[zefon]

Here is the code to "proper case" multiple word fields like the address line in your existing database.

<?
@include_once "./top.inc.php";
if (!defined('DIR_CUSTOMER'))
@include_once "../top.inc.php";
if (!defined('DIR_CUSTOMER'))
die("ERROR: Cannot find application! Please check the configuration.");
include_once $xcart_dir."/config.php";

$field = "%FIELD_HERE%";
$table = "%TABLE_HERE%";

$data = func_query("SELECT $field  FROM $table");
foreach ($data as $k) { 
db_query("UPDATE $table SET $field ='".ucwords($k[$field])."' WHERE $field ='$k[$field]';");
echo "Convert: ".$k[$field]." => ".ucwords($k[$field])."
";
}
?>

Create a php file with this code. Repalce %FIELD_HERE% and %TABLE_HERE% strings with name of field you want to modify and name of table where this field is stored.

For example you can replace :

$field = "%FIELD_HERE%";
$table = "%TABLE_HERE%";

with

$field = "b_address";
$table = "xcart_customers";


Then just upload the file and run it. You will get an on-screen look at all the field changes. It takes a minute or to to run so be patient.

[shishapipe]

i installed this mod

it is working in the contact us

but not in the register new customer etc
i dont have ez checout like mentioned before
i have checked and checked but cant find out where i am going wrong

any help will be appreciated

[amy2203]

I'm probably being a bot thick here, but could you not acheive a similar effect using text-transform: capitalize in the css?

[Vacman]

I don't know what to say. This little mod rocks! Very cool and I have no idea how I missed seeing this 6 months ago! Very cool...

[bigmaggot]

Use smarty variable modifiers:

Use the following for Firstname / Lastname etc:
|capitalize:true

and |upper for Post Code

Examples:

<INPUT type="text" name="s_firstname" size="32" maxlength="32" value="{$userinfo.s_firstname|capitalize:true}">

<INPUT type="text" id="s_zipcode" name="s_zipcode" size="32" maxlength="32" value="{$userinfo.s_zipcode|upper}" onChange="check_zip_code()">

But haven't figure out where the the County |capitalize:true goes? Any ideas?

Andy

[shishapipe]

i have tried thsi mod

it just dosnt seem to work on 4.1.7

i have had it working on version 4.0.17

tried and trie dno joy

has anybody got a working version for 4.1.7?

would really appreciate it

thanks in advance

[inebriate]

why the loop through all the letters?

use split and then do a
o[i].charAt(0).toUpperCase()+o[i].substr(1).toLowerCase()

[kitplum]

Phil

You do the most amazing mods. This is exactly what I am looking for, but to modify litecommerce not xcart. Can you give me an idea of the complications I may run into.

Thanks

Kit

[just_me]

heh, neat mod. I got it working in conrtact.php but not in the rest.

I have a copybilling mod that also uses onChange function in register_personal_info.tpl
This is my code:

<INPUT type="text" id="firstname" name="firstname" size="32" maxlength="32" value="{$userinfo.firstname}"onChange="populateProfile(); Proper(this); return true;">

Anyone know how to properly combine the two actions for onChange?

[Vacman]

Anybody get this to work in 4.1.x? I used the same code we used in 4.0.x but it will not work.