CMS Made Simple Forums

Code: Select all

			FROM ".cms_db_prefix()."module_cartms_carts cart 
			INNER JOIN ".cms_db_prefix()."module_sms_categories cat ON
			cart.category_id = cat.category_id 
			INNER JOIN ".cms_db_prefix()."module_sms_products prd ON
			cart.product_id = prd.product_id 

Code: Select all

			FROM ".cms_db_prefix()."module_cartms_carts cart 
			LEFT OUTER JOIN ".cms_db_prefix()."module_sms_categories cat ON
			cart.category_id = cat.category_id 
			LEFT OUTER JOIN ".cms_db_prefix()."module_sms_products prd ON
			cart.product_id = prd.product_id 

Code: Select all

{* List of products in cart *}
{literal}
<__script__ language="JavaScript">

function UpdateQty(item)
{
	product_id = item.name;
	newQty = item.options[item.selectedIndex].text;
	<!-- I know, the following is not very neatly done, but it works. Sorry :-) // -->
	document.location.href = 'index.php?mact=CartMadeSimple,cntnt01,cart,0&cntnt01product_id='+product_id+'&cntnt01qty='+newQty+'&cntnt01perfaction=update_product';
}

</__script>
{/literal}<h4>
<div class="productlist">
{if $productcount != 0}
	<div ID="productcount">{$label_product_count}</div></h4>
{/if}
<table width="100%" border="0" cellspacing="10" cellpadding="20" bordercolor=#556677>
	{if $productcount > 0}
	<thead>
		<tr>
			<th>{$productqtytext}</th>
			<th>{$productnametext}</th>
			<th align="right">{$productpricetext}&nbsp;</th>
		  <th align="right">{$lineamounttext}&nbsp;</th>
		  <th class="pageicon">&nbsp;</th>
			<th class="pageicon"></th>
		</tr>
	</thead>
	<tbody>
		{foreach from=$products item=entry}
			<tr class="{$entry->rowclass}" onmouseover="this.className='{$entry->rowclass}hover';" onmouseout="this.className='{$entry->rowclass}';">
				<td class="productqty"><select name={$entry->product_id} onchange="UpdateQty(this);"> 
							{html_options options=$entry->qtydropdown selected=$entry->myqty}
							</select></td>
				<td class="productname">{$entry->name}&nbsp;&nbsp;&nbsp;</td>
				<td align="right" class="productprice">{$entry->price}&nbsp;</&nbsp;td>
				<td align="right" class="productamount">{$entry->lineamount}&nbsp;</td>
				<td align="right" class="productremove">{$entry->deletelink}</td>
			</tr>
		{/foreach}
	{else}
		<tr class="{cycle values="row1,row2"}">
			<td colspan='5' align='center'>{$noproductsincart}</td>
		</tr>
	</tbody>
	{/if}
</table>
{if $productcount > 0}<br>
	<div ID="totalamount"><b>{$label_total_amount}</b></div><br>
	<div ID="checkout">{$startcheckout}&raquo;</div><br>
{/if}
<div ID="continue">{$continueshopping}&raquo;</div>
</div>
<br /><br /><a href="javascript:history.back();"><span style="text-decoration: underline;"><strong><< zurück</strong></span></a></p><hr size="2" />