[TYPO3-commerce] extensions of the extension using $this->piVars
Peter Waechtler
piet at repiet.com
Fri Oct 26 10:49:13 CEST 2007
hello again,
i am busy extending commerce a little - am wanting to show the gn_id
which is stored in the fe_users table:
function additionalMarker($markerArray,&$subpartArray,&$this) {
echo $this->piVars["order_id"];
$res = $GLOBALS['TYPO3_DB']->exec_SELECTquery
('fe_users.tx_gn_gn_id', 'fe_users, tx_commerce_orders',
'fe_users.uid = tx_commerce_orders.cust_fe_user AND
tx_commerce_orders.order_id = ' . $this->piVars["order_id"]);
$row = $GLOBALS['TYPO3_DB']->sql_fetch_assoc($res);
$markerArray['###REP_ID###'] = $row['tx_gn_gn_id'];
return $markerArray;
}
the marker is displays nicely on my local webserver. as soon as i put
the extension online - to the live server the line: echo $this-
>piVars["order_id"]; does not return anything and the of course i
get a sql error.
both systems are running typo3 4.1.2. the local machine is running on
mysql 5.0.45 and the remote on mysql 5.0.41
have you got any idea why $this->piVars["order_id"] has got a value
on the one system and is empty on the remote? all else is working fine.
thanks,
piet
More information about the TYPO3-project-commerce
mailing list