| ||||||||||
Shopping cart software Solutions for online shops and malls | ||||||||||
|
X-Cart Home | FAQ | Forum rules | Calendar | User manuals | Login |
Age Calculation | ||||
|
|
Thread Tools | Search this Thread |
#1
|
|||||||
|
|||||||
Age Calculation
My client sells puppies and would like to include an age calculation for each dog.
I found a simple javascript that will do this, I just don't understand how to pull Variables out of the Xcart Database to make it work. http://www.javascriptkit.com/script/script2/calculateage.shtml I figured I'd have to create some extra fields, so I made Birth Month = Birth_M Birth Day = Birth_D Birth Year = Birth_Y Anyone know how to do this right so that it goes on the details and the product list page? Thanks For your help....
__________________
X-Cart 4.3 Joomla Among other things |
|||||||
#2
|
|||||||
|
|||||||
Re: Age Calculation
To pull variables from the XC Database, you must use something such as this:
{$config.Highslide.Highslide_contentId} $config is the table Highslide is the Category its in (its a column) Highslide_ContentId is the name of the dataset/row. This is in the config table of course. For yours, you'd probably want to make a hidden extra field on each product and pull it from that. |
|||||||
#3
|
|||||||
|
|||||||
Re: Age Calculation
Ok so I hid the extra fields, but what you said to do, doesn't help. I understand you're saying to pull the data from the DB, but I'm lost still.
Edit: I was looking through the DBs and I see that xcart_extra_field_values contains the data as follows: productid fieldid value 1 1 8 1 2 17 1 3 1970 I found a better script as well. http://www.hscripts.com/scripts/JavaScript/age-calculator.php
__________________
X-Cart 4.3 Joomla Among other things |
|||||||
#4
|
|||||||
|
|||||||
Re: Age Calculation
I just tested on 4.3.1 but it shouldn't be terribly different (if at all) for 4.2
In the admin area, setup 3 new fields. Birthmonth, Birthday, Birthyear. The default value doesn't matter since each product (dog) will have a unique value. Order value doesnt matter either, and make sure the value isnt shown to the customer unless you want it as so. Once you get that setup, add the birthday values for one dog (just to test). Open product.tpl (your product page) and find this line: Code:
If you want it in between those elements, open that file (product_details.tpl). I don't know how your website is, so I don't know what to look for. Just play around with adding in text between </div><div> or even inside to get the right positioning. Once you get the area you want it in, add the code into the template. You could just make a seperate .tpl altogether and include that to make the code nicer to look at and modify possibly. Looking at the code, you will need to put {literal} at the start of the code and {/literal} at the end since smarty uses the {} brackets and so does javascript. Once you add the code, you can pull the variables from the database using this: {$extra_fields.0.field_value} $extra_fields is infact the name of the array. Before I misinterpretted it as the table name. 0 is the array it looks in (0 is the first array, not 1). This is the value you would change depending on what array # your values are put into. field_value is the value of the field. I'm not 100% sure why you want a calculator for this though, as the one you provided is for humans and I think you would want a dog age calculator since their age compared to humans is done in a different way? Edit: I went ahead and made a new .tpl since you may not have known what to edit. Look for the 3 queries on the array I mentioned earlier and change them as needed. Its in the HTML part near the bottom. in dog.tpl I have this... Keep in mind, I've removed some stuff. Code:
Then you can include it via {include file="location/of/dog.tpl"} |
|||||||
#5
|
|||||||
|
|||||||
Re: Age Calculation
Quote:
I'll play around with the javascript and see what I can come up with.
__________________
X-Cart 4.3 Joomla Among other things |
|||||||
#6
|
|||||||
|
|||||||
Re: Age Calculation
Quote:
Re-read my post, I added in what you would need to use that calculator |
|||||||
#7
|
|||||||
|
|||||||
Re: Age Calculation
Quote:
Will what you did display the age in the results box based on the extra variables?
__________________
X-Cart 4.3 Joomla Among other things |
|||||||
#8
|
|||||||
|
|||||||
Re: Age Calculation
Quote:
Yes. If you look at the HTML form near the bottom, it has the {$extra_fields.x.field_value} queries. It will pull the field value of each dataset. You just need to use the right number since I don't know what yours are. That's basically all you need to change to get the calculator to pull the age correctly. Edit: Or do you mean will it auto-calculate? If so, then no. They still have to click the button. Google "onload" to find info on running javascript when the page loads. |
|||||||
#9
|
|||||||
|
|||||||
Re: Age Calculation
Yeah I meant automatically.
I think if I can get the java to build the variables based on the extra data then is should display "age" in the results window in the form.
__________________
X-Cart 4.3 Joomla Among other things |
|||||||
#10
|
|||||||
|
|||||||
Re: Age Calculation
Well I can't get it to work right and it's messing up the product details page.
http://littlepuppiesonline.msidesigns.com/product.php?productid=1&cat=10&page=1 I attached the age.tpl file I setup. Thanks for your help!
__________________
X-Cart 4.3 Joomla Among other things |
|||||||
|
|||
X-Cart forums © 2001-2020
|