Jump to content



Latest News: (loading..)

Gasse1014life

Member Since 09 Mar 2009
OFFLINE Last Active Oct 18 2012 10:11 PM
-----

Topics I've Started

v2.3.3. - Update datable on product info second table.

18 October 2012 - 08:21 PM

hi

in admin/categories.php

i have set a table who retreiving extra data for product info.

product_info data are in TABLE_PRODUCTS and TABLE_PROD_DETAIL_ATTRIB

i am able to extract info but problem when updating product,

i need help or a way, to add sql perform to update the second table
TABLE_PROD_DETAIL_ATTRIB.


i have attach admin/categories.php


around line 725 have my table,
i want to update info from these table to TABLE_PROD_DETAIL_ATTRIB

Javascript to Round to 2 Decimal

03 October 2012 - 01:14 AM

im working on a delivery add-on.
i have almost finnished.
is base on google map Apis. with api key.

i have a math formula (distance X price per Km + base fee)

result in miles show i.e. 8.3092111920 miles.
this make pricing show as 32.09334234 $

any one can help me to get the price rounded with this script please.

function initialize() {
		geocoder = new GClientGeocoder();
		gDir = new GDirections();
		GEvent.addListener(gDir, "load", function() {
			var drivingDistanceMiles = gDir.getDistance().meters / 1609.344;
			var drivingDistanceKilometers = gDir.getDistance().meters / 1000;
			var $a=2.50, $b=1, $formula  = "($a+($b*" + drivingDistanceMiles + "))";
			 document.getElementById('results').innerHTML = '<strong>Address 1: </strong>' + location1.address + ' (' + location1.lat + ':' + location1.lon + ')<br /><strong>Address 2: </strong>' + location2.address + ' (' + location2.lat + ':' + location2.lon + ')<br />' + eval($formula) + '<br /><strong>Driving Distance: </strong>' + drivingDistanceMiles + ' miles (or ' + drivingDistanceKilometers + ' kilometers)<br><iframe width="700" height="500" frameborder="0" scrolling="no" marginheight="0" marginwidth="0" src="https://maps.google.ca/maps?f=d&source=s_d&saddr=' + location1.address + '&daddr=' + location2.address + '&aq=1&t=h&hl=en&z=13&mra=ls&ie=UTF8&output=embed"></iframe>';
		});
	}

the statement to round is $formula
into
var $a=2.50, $b=1, $formula = "($a+($b*" + drivingDistanceMiles + "))";


thank you

Upload percentage done - admin

01 October 2012 - 02:39 AM

is there a way to know the percentage done when im uploading a file via admin section.???
script or add-on who can help me

thank you

Hi! - my new store opening soon - Local Delivery & Worldwide Shipping

30 September 2012 - 11:30 PM

Hi allz.

need feed back about layout and design of my new site.

is an online grocery from Quebec city, Canada soon 24hours
not opened but really soon.

I made local delivery and ship worldwide too.
is for what i have adapt my cart to get 3 kind of commerce in it.

Grocery
Candy shop
And
Online video rental.

each one will have their respective domain name
but is the same shop and same cart.

the kob is not finnished but i need feed back about layout and design.

any comments and/or idea are welcome

Main site (this is my test domain) this is not the real shop domain
http://www.kopter-adventure.info/depanneur-virtuel/index.php?language=en

see Dvd location
for second shop

see Candy
for third shop


thank you

Product exportation, v2.3.1 to 2.3.3

30 September 2012 - 08:12 PM

hi all.

i want  a new start with 2.3.3 cause after 5 year, i have do a lot of change in to  all page and database.
and an update are unthinkable. lol


i have change structure of many pages & product_info table.
and databse have been adapt to fit both versions: v.2.3.1 and 2.3.2,
and no exportation add-on is working due to this.



whats the best way to export product_info and categories Db table,
to edit for fit 2.3.3??


thank you very much.