Jonathan DC

March 15, 2009

It's true, I have change it in before total (like you said) or after total and there is no discount. I tested it on IE, firefox, Opera, Safari and Netscape. The attributes have been perfectly added to shopping cart, but no discount.

I have the same problem as Sarah.

Best regards,

Jonathan

January 7, 2009

check in admin order total if 2gether is just before "total"

I've tried this too, but it doesn't work. When I put back the modules/2gether.php file that I have, it works again without the attributes. So I think it must be something in the 2gether.php file that the discount doesn't show up?

:blush: My php program skills are on a very low level , but is it possible that it has something to do with in modules/2gether.php :

echo tep_draw_form('together', tep_href_link(FILENAME_PRODUCT_INFO, tep_get_all_get_params(array('action')) . 'action=add_product'));

Thanks for your reply!

Jonathan

January 6, 2009

Hi,
Look http://addons.oscommerce.com/info/3929

Modules for Oscommerce:

http://www.aminhaloja.com.br

I tried your solution on my website. I had this contribution installed on my website 6 months ago, but never used it because of the attributes.

Problem I have: Does someone else has this problem to?

I see the attributes and when I click 'buy now' it's correct on the shopping cart (with attributes). The only problem I have is that in 'checkout_confirmation.php' the discount isn't there. I have oscommerce MS2 and activated the module in order total(admin).

Is there a solution for this problem or am I missing something? I think the problem is in the module/2gether.php file?

Many thanks!

September 4, 2008

Hi,

I have a question:

I like this contribution and for now it seems to work, but I don't need the email to friends because I use it as an orderlist and not a wishlist. Customers can put it in the orderlist before they add the items to the cart.

I am new to php, so I will ask it first if this is ok?

I deleted some code from catalog/wishlist.php so that the email code is gone. Is this right or am I gona have problems with it later?

This is where I deleted some code and this is the result:

<?php

/*******************************************************************
*********** CODE TO SPECIFY HOW MANY EMAILS TO DISPLAY *************
*******************************************************************/


if(!tep_session_is_registered('customer_id')) {

?>
<table border="0" width="100%" cellspacing="0" cellpadding="2">
     <tr>
       <td><?php echo tep_draw_separator('pixel_trans10.gif', '100%', '10'); ?></td>
     </tr>
  <tr>
       <td align="center">
		<table border="0" width="400px" cellspacing="0" cellpadding="2">
<?php 

} else {

?>
<table border="0" width="100%" cellspacing="0" cellpadding="2">      
       <td align="center">
		<table border="0" width="400px" cellspacing="0" cellpadding="2">
<?php

}

?> 		  
		</table>		</td>
  </tr>
</table>
</form>
<?php

} else { // Nothing in the customers wishlist

?>
 <tr>
<td>
<table border="0" width="100%" cellspacing="0" cellpadding="2">
  <tr>
	<td><table border="0" width="100%" cellspacing="0" cellpadding="0">
	  <tr>
		<td class="main"><?php echo BOX_TEXT_NO_ITEMS;?></td>
	  </tr>
	</table>		</td>
  </tr>
</table>	</td>
 </tr>
</table>
</form>

<?php 
}
?>
<!-- customer_wishlist_eof //-->	</td>

<!-- body_text_eof //-->
   <td width="<?php echo BOX_WIDTH; ?>" valign="top"><table border="0" width="<?php echo BOX_WIDTH; ?>" cellspacing="0" cellpadding="2">
<!-- right_navigation //-->
<?php require(DIR_WS_INCLUDES . 'column_right.php'); ?>
<!-- right_navigation_eof //-->
   </table></td>
 </tr>
</table>
<!-- body_eof //-->

<!-- footer //-->
<?php require(DIR_WS_INCLUDES . 'footer.php'); ?>
<!-- footer_eof //-->
<br>
</body>
</html>
<?php require(DIR_WS_INCLUDES . 'application_bottom.php'); ?>

I am sorry for my English, it's not perfekt. I am dutch.

Many thanks to the forum to make it all happen!

July 16, 2008

ok

found the error, it happens if you load the template... its been fixed and i will upload as soon as i straigthend out other issues

Thanks!

I have two more questions:

1. Is it normal that I can't sort the attributes like example blue, red, black,.... until I save it first when creating a new product?

2. I can sort the attribute description like color, size,... in admin, but it's not sorted on product_info?

I think there is something missing in this code:

$products_options_query = tep_db_query("select pov.products_options_values_id, pov.products_options_values_name, pa.options_values_price, pa.price_prefix from " . TABLE_PRODUCTS_ATTRIBUTES . " pa, " . TABLE_PRODUCTS_OPTIONS_VALUES . " pov where pa.products_id = '" . (int)$HTTP_GET_VARS['products_id'] . "' and pa.options_id = '" . (int)$products_options_name['products_options_id'] . "' and pa.options_values_id = pov.products_options_values_id and pov.language_id = '" . (int)$languages_id . "' order by pa.attribute_sort");

Is this correct?

Many thanks for the support!

July 15, 2008

I'am having a problem:

I have AttributeManager 2.8.4

I have tried to work with attribut_sort and it's works, but I have one problem with it:

When I save an attribute set with sort_order as a template and I load this template I get the following error:

Warning: reset() [function.reset]: Passed variable is not an array or object in /home/.../.../.../public_html/catalog/admin/includes/functions/database.php on line 55

Warning: Variable passed to each() is not an array or object in /home/.../.../.../public_html/catalog/admin/includes/functions/database.php on line 79

1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'where products_attributes_id =' at line 1

update products_attributes se where products_attributes_id =

[TEP STOP]

I have search for a whole day for a solutions but I can not find a solution.

June 29, 2008

I'm verry happy with this contribution and works perfect except one thing:

In admin/stats_newsletter.php

When I have for example 2 costumers sign in for newsletter the result here is:

Number of members registered with the newsletter : 0

This is the stats_newsletter.php

<?php
/*
$Id: stats_newsletter.php,v 1.1 2007/11/22 09:00:00 
Contribution by Nekosign, [email protected] 

osCommerce, Open Source E-Commerce Solutions
http://www.oscommerce.com

Copyright (c) 2002 osCommerce

Released under the GNU General Public License
*/

 require('includes/application_top.php');

?>
<!doctype html public "-//W3C//DTD HTML 4.01 Transitional//EN">
<html <?php echo HTML_PARAMS; ?>>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=<?php echo CHARSET; ?>">
<title><?php echo TITLE; ?></title>
<link rel="stylesheet" type="text/css" href="includes/stylesheet.css">
<link rel="icon" href="favicon.ico" />
</head>
<body>
<!-- header //-->
<?php require(DIR_WS_INCLUDES . 'header.php'); ?>
<!-- header_eof //-->

<!-- body //-->
<table border="0" width="100%" cellspacing="2" cellpadding="2">
 <tr>
<td width="<?php echo BOX_WIDTH; ?>" valign="top"><table border="0" width="<?php echo BOX_WIDTH; ?>" cellspacing="1" cellpadding="1" class="columnLeft">
<!-- left_navigation //-->
<?php require(DIR_WS_INCLUDES . 'column_left.php'); ?>
<!-- left_navigation_eof //-->
</table></td>
<!-- body_text //-->
<td width="100%" valign="top">	  

<table border="0" width="100%" cellspacing="0" cellpadding="2">
  <tr>
	<td><table border="0" width="100%" cellspacing="0" cellpadding="0">
	  <tr>
		<td class="pageHeading"><?php echo HEADING_TITLE; ?></td>
		<td class="pageHeading" align="right"><?php echo tep_draw_separator('pixel_trans.gif', HEADING_IMAGE_WIDTH, HEADING_IMAGE_HEIGHT); ?></td>
	  </tr>
	</table></td>
  </tr>
<?php
 if ($HTTP_GET_VARS['cpage'] > 1) $rows = $HTTP_GET_VARS['cpage'] * MAX_DISPLAY_SEARCH_RESULTS - MAX_DISPLAY_SEARCH_RESULTS;

$customers_query_raw = "select c.customers_id, c.customers_firstname, c.customers_lastname, c.customers_email_address, c.customers_newsletter , b.customers_info_id , b.customers_info_date_account_created as date_account_created
						from " . TABLE_CUSTOMERS . " c," . TABLE_CUSTOMERS_INFO . " b where c.customers_id = b.customers_info_id and c.customers_newsletter = '1'
						order by b.customers_info_date_account_created, c.customers_lastname, c.customers_firstname";


$customers_split = new splitPageResults($HTTP_GET_VARS['cpage'], MAX_DISPLAY_SEARCH_RESULTS, $customers_query_raw, $customers_query_numrows);
$customers_query = tep_db_query($customers_query_raw);

?>
  <tr>
	  <td class="dataTableContent" colspan="3"><?php echo TEXT_DESCRIPTION; ?><strong><?php echo $customers_query_numrows; ?></strong></td>
  </tr>
  <tr>
	  <td><?php echo tep_draw_separator('pixel_trans.gif', '100%', '10'); ?></td>
  </tr>
  <tr>
	<td><table border="0" width="100%" cellspacing="0" cellpadding="0">
	  <tr>
		<td valign="top"><table border="0" width="100%" cellspacing="0" cellpadding="4">
		  <tr class="dataTableHeadingRow">
			<td class="dataTableHeadingContent" width="10%"><?php echo TABLE_HEADING_NUMBER; ?></td>
			<td class="dataTableHeadingContent" width="20%"><?php echo TABLE_HEADING_LAST_NAME; ?></td>
			<td class="dataTableHeadingContent" width="20%"><?php echo TABLE_HEADING_FIRST_NAME; ?></td>
			<td class="dataTableHeadingContent" width="30%"><?php echo TABLE_HEADING_EMAIL; ?></td>
			<td class="dataTableHeadingContent" width="25%"><?php echo TABLE_HEADING_CREATE; ?></td>
		  </tr>

<?php	  

while ($customers = tep_db_fetch_array($customers_query)) {
  $rows++;

			if (strlen($rows) < 2) {
	$rows = '0' . $rows;
  }
?>
		  <tr class="dataTableRow" onMouseOver="this.className='dataTableRowOver';this.style.cursor='hand'" onMouseOut="this.className='dataTableRow'">
			<td width="30" nowrap class="dataTableContent"><?php echo $rows; ?>.</td>
			<td class="dataTableContent"><?php echo '<a href="' . tep_href_link(FILENAME_CUSTOMERS, tep_get_all_get_params(array('cID', 'action')) . 'cID=' . $customers['customers_id']. '&action=edit') . '">' . $customers['customers_lastname'] . '</a>';?> </td>
			<td class="dataTableContent"><?php echo $customers['customers_firstname']; ?></td>
			<td class="dataTableContent"><?php echo '<a href="' . tep_href_link(FILENAME_MAIL, 'selected_box=tools&customer=' . $customers['customers_email_address'], 'NONSSL') . '">' . $customers['customers_email_address'] . '</a>'; ?> </td>
			<td class="dataTableContent"><?php echo tep_date_short($customers['date_account_created']); ?></td>
		  </tr>
<?php
}
?>
		</table></td>
	  </tr>
	  <tr>
		<td colspan="3"><table border="0" width="100%" cellspacing="0" cellpadding="2">
		  <tr>
			<td class="smallText" valign="top"><?php echo $customers_split->display_count($customers_query_numrows, MAX_DISPLAY_SEARCH_RESULTS, $HTTP_GET_VARS['cpage'], 'Totaal <b>%s</b> van <b>%s</b> (van <b>%s</b> klanten)' , '', 'cpage'); ?></td>
			<td class="smallText" align="right"><?php echo $customers_split->display_links($customers_query_numrows, MAX_DISPLAY_SEARCH_RESULTS, MAX_DISPLAY_PAGE_LINKS, $HTTP_GET_VARS['cpage'], tep_get_all_get_params(array('cpage')), 'cpage'); ?></td>
		  </tr>
		</table></td>
	  </tr>
	</table></td>
  </tr>
</table>
	</td>
<!-- body_text_eof //-->
 </tr>
</table>
<!-- body_eof //-->

<!-- footer //-->
<?php require(DIR_WS_INCLUDES . 'footer.php'); ?>
<!-- footer_eof //-->
</body>
</html>
<?php require(DIR_WS_INCLUDES . 'application_bottom.php'); ?>

In admin/mail.php

When you select send "To All Newsletter Subscribers"

It reads also 0 Subscribers.

Also in admin/stats_inactive_user.php it reads subscribe= no

This is admin/stats_inactive_user.php.

<?php
/*
 $Id: stats_inactive_user.php,v 1.2 2004/05/02 15:00:00
 osCommerce, Open Source E-Commerce Solutions
 http://www.oscommerce.com

 Copyright (c) 2004 osCommerce

 Released under the GNU General Public License
 Created by John Wood - www.z-is.net
*/
require('includes/application_top.php');?>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html <?php echo HTML_PARAMS; ?>>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=<?php echo CHARSET; ?>">
<title><?php echo TITLE; ?></title>
<link rel="stylesheet" type="text/css" href="includes/stylesheet.css">
<script language="javascript" src="includes/general.js"></script>
</head>
<body marginwidth="0" marginheight="0" topmargin="0" bottommargin="0" leftmargin="0" rightmargin="0" bgcolor="#FFFFFF">
<!-- header //-->
<?php require(DIR_WS_INCLUDES . 'header.php'); ?>
<!-- header_eof //-->

<!-- body //-->
<table border="0" width="100%" cellspacing="2" cellpadding="2">
 <tr>
<td width="<?php echo BOX_WIDTH; ?>" valign="top"><table border="0" width="<?php echo BOX_WIDTH; ?>" cellspacing="1" cellpadding="1" class="columnLeft">
<!-- left_navigation //-->
<?php require(DIR_WS_INCLUDES . 'column_left.php'); ?>
<!-- left_navigation_eof //-->
	</table></td>
<!-- body_text //-->
<td width="100%" valign="top"><table border="0" width="100%" cellspacing="0" cellpadding="2">
  <tr>
	<td>
		<table border="0" width="100%" cellspacing="0" cellpadding="0">
		  <tr> 
			<td class="pageHeading"> 
			  <?php echo HEADING_TITLE; ?>
			  <br>
			</td>
			<td class="pageHeading" align="right">
			  <?php echo tep_draw_separator('pixel_trans.gif', HEADING_IMAGE_WIDTH, HEADING_IMAGE_HEIGHT); ?>
			</td>
		  </tr>
		  <tr>
			<td class="dataTableContent"></td>
			<td class="pageHeading" align="right"> </td>
		  </tr>
		</table>
	  </td>
  </tr>
  <tr>
	<td><table border="0" width="100%" cellspacing="0" cellpadding="4">
	  <tr>
		<td valign="top">
<?php
$cust_query = tep_db_query("select customers_firstname, customers_lastname from " . TABLE_CUSTOMERS . " where customers_id = '" . (int)$HTTP_GET_VARS['id'] . "'");
$cust = tep_db_fetch_array($cust_query);
	if ($HTTP_GET_VARS['go'] == 'delete')
	{
		  echo '<br>' . sprintf(SURE_TO_DELETE, $cust[customers_firstname] . ' ' . $cust[customers_lastname]) . '<br><br><a href="' . tep_href_link(FILENAME_STATS_INACTIVE_USER,  'page=' . $HTTP_GET_VARS['page'] . '&go=deleteyes&id=' . $HTTP_GET_VARS['id']) . '">' . tep_image_button('button_delete.gif', IMAGE_DELETE) . '</a>  <a href="' . tep_href_link(FILENAME_STATS_INACTIVE_USER, 'page=' . $HTTP_GET_VARS['page']) . '">' . tep_image_button('button_cancel.gif', IMAGE_CANCEL) . '</a><br><br>';
	}
	 elseif ($HTTP_GET_VARS['go'] == 'deleteyes')
	 {
		  tep_db_query("DELETE FROM " . TABLE_CUSTOMERS . " where customers_id = '" . (int)$HTTP_GET_VARS['id'] . "'");
		  tep_db_query("DELETE FROM " . TABLE_CUSTOMERS_BASKET . " where customers_id = '" . (int)$HTTP_GET_VARS['id'] . "'");
		  tep_db_query("DELETE FROM " . TABLE_CUSTOMERS_BASKET_ATTRIBUTES . " where customers_id = '" . (int)$HTTP_GET_VARS['id'] . "'");
		  tep_db_query("DELETE FROM " . TABLE_CUSTOMERS_INFO . " where customers_info_id = '" . (int)$HTTP_GET_VARS['id'] . "'");
		  tep_db_query("DELETE FROM " . TABLE_ADDRESS_BOOK . " where customers_id = '" . (int)$HTTP_GET_VARS['id'] . "'");
		  tep_db_query("DELETE FROM " . TABLE_PRODUCTS_NOTIFICATIONS . " where customers_id = '" . (int)$HTTP_GET_VARS['id'] . "'");
		  echo '<br>' . sprintf(SIU_CUSTOMER_DELETED, $cust[customers_firstname] . ' ' . $cust[customers_lastname]) . '<br><br><br><a href="' . tep_href_link(FILENAME_STATS_INACTIVE_USER, 'page=' . $HTTP_GET_VARS['page']) . '">' . tep_image_button('button_back.gif', IMAGE_BACK) . '</a><br><br>';
	} 
	elseif ($HTTP_GET_VARS['go'] == 'deletenull')
	{
		echo '<br>' . SURE_TO_DELETE_NULL . '<br><br><a href="' . tep_href_link(FILENAME_STATS_INACTIVE_USER,  'page=' . $HTTP_GET_VARS['page'] . '&go=deletenullyes') .'">' . tep_image_button('button_delete.gif', IMAGE_DELETE) . '</a>  <a href="' . tep_href_link(FILENAME_STATS_INACTIVE_USER, 'page=' . $HTTP_GET_VARS['page']) . '">' . tep_image_button('button_cancel.gif', IMAGE_CANCEL) . '</a><br><br>';
	} 
	elseif ($HTTP_GET_VARS['go'] == 'deletenullyes')
	{
	  $siu_query_raw = "select ci.customers_info_date_of_last_logon, c.customers_id, c.customers_firstname, c.customers_lastname, c.customers_email_address, c.customers_newsletter from " . TABLE_CUSTOMERS_INFO . " ci join " . TABLE_CUSTOMERS . " c left join " . TABLE_ORDERS . " o on c.customers_id = o.customers_id where o.customers_id is NULL and c.customers_id = ci.customers_info_id  and (ci.customers_info_date_of_last_logon='0000-00-00 00:00:00' or ci.customers_info_date_of_last_logon is NULL) order by c.customers_id";
	  $siu_query = tep_db_query($siu_query_raw);
  while ($customers = tep_db_fetch_array($siu_query)) 
	  {
		  $cid=$customers[customers_id];
		  tep_db_query("DELETE FROM " . TABLE_CUSTOMERS . " where customers_id = '" . $cid . "'");
		  tep_db_query("DELETE FROM " . TABLE_CUSTOMERS_BASKET . " where customers_id = '" . $cid . "'");
		  tep_db_query("DELETE FROM " . TABLE_CUSTOMERS_BASKET_ATTRIBUTES . " where customers_id = '" . $cid . "'");
		  tep_db_query("DELETE FROM " . TABLE_CUSTOMERS_INFO . " where customers_info_id = '" . $cid . "'");
		  tep_db_query("DELETE FROM " . TABLE_ADDRESS_BOOK . " where customers_id = '" . $cid . "'");
		  tep_db_query("DELETE FROM " . TABLE_PRODUCTS_NOTIFICATIONS . " where customers_id = '" . $cid . "'");
		}	
	  echo '<br>' . sprintf(SIU_CUSTOMER_DELETED_NULL) . '<br><br><br><a href="' . tep_href_link(FILENAME_STATS_INACTIVE_USER, 'page=' . $HTTP_GET_VARS['page']) . '">' . tep_image_button('button_back.gif', IMAGE_BACK) . '</a><br><br>';
	}
	elseif ($HTTP_GET_VARS['go'] == 'deleterange')
	{
		$fromdate="$yy1-$mm1-$dd1 00:00:00";
		$todate="$yy2-$mm2-$dd2 23:59:59";
		$fromdate1="$dd1-$mm1-$yy1";
		$todate1="$dd2-$mm2-$yy2";
		echo '<br>' . sprintf(SURE_TO_DELETE_RANGE, $fromdate1 . ' to ' . $todate1) . '<br><br><a href="' . tep_href_link(FILENAME_STATS_INACTIVE_USER,  'page=' . $HTTP_GET_VARS['page'] . '&go=deleterangeyes&fromdate=' . $fromdate . '&todate=' . $todate.'&fromdate1=' . $fromdate1 . '&todate1=' . $todate1) .'">' . tep_image_button('button_delete.gif', IMAGE_DELETE) . '</a>  <a href="' . tep_href_link(FILENAME_STATS_INACTIVE_USER, 'page=' . $HTTP_GET_VARS['page']) . '">' . tep_image_button('button_cancel.gif', IMAGE_CANCEL) . '</a><br><br>';
	} 
	elseif ($HTTP_GET_VARS['go'] == 'deleterangeyes')
	{
	  $siu_query_raw = "select ci.customers_info_date_of_last_logon, c.customers_id, c.customers_firstname, c.customers_lastname, c.customers_email_address, c.customers_newsletter from " . TABLE_CUSTOMERS_INFO . " ci join " . TABLE_CUSTOMERS . " c left join " . TABLE_ORDERS . " o on c.customers_id = o.customers_id where o.customers_id is NULL and c.customers_id = ci.customers_info_id  and ci.customers_info_date_of_last_logon>='$fromdate' and ci.customers_info_date_of_last_logon<='$todate' order by c.customers_id";
	  $siu_query = tep_db_query($siu_query_raw);
	  while ($customers = tep_db_fetch_array($siu_query)) 
	  {
		  $cid=$customers[customers_id];
		  tep_db_query("DELETE FROM " . TABLE_CUSTOMERS . " where customers_id = '" . $cid . "'");
		tep_db_query("DELETE FROM " . TABLE_CUSTOMERS_BASKET . " where customers_id = '" . $cid . "'");
		tep_db_query("DELETE FROM " . TABLE_CUSTOMERS_BASKET_ATTRIBUTES . " where customers_id = '" . $cid . "'");
		tep_db_query("DELETE FROM " . TABLE_CUSTOMERS_INFO . " where customers_info_id = '" . $cid . "'");
		tep_db_query("DELETE FROM " . TABLE_ADDRESS_BOOK . " where customers_id = '" . $cid . "'");
		tep_db_query("DELETE FROM " . TABLE_PRODUCTS_NOTIFICATIONS . " where customers_id = '" . $cid . "'");
		}	
	  echo '<br>' . sprintf(SIU_CUSTOMER_DELETED_RANGE, $fromdate1 . ' to ' . $todate1) . '<br><br><br><a href="' . tep_href_link(FILENAME_STATS_INACTIVE_USER, 'page=' . $HTTP_GET_VARS['page']) . '">' . tep_image_button('button_back.gif', IMAGE_BACK) . '</a><br><br>';
	}elseif ($HTTP_GET_VARS['go'] == '' )
	{
			  echo tep_draw_form('export', FILENAME_STATS_INACTIVE_USER. '?go=deleterange');
			  echo FROMDATE." ";
			  echo tep_get_day_list('dd1');
			  echo tep_get_monthname_list('mm1');
			  echo tep_get_year_list('yy1');
			  echo " ".TODATE." ";
			  echo tep_get_day_list('dd2');
			  echo tep_get_monthname_list('mm2');
			  echo tep_get_year_list('yy2');
			  echo '   <input type="submit" value="'. SIU_DELETE .'">';
	  echo '</form>';
			  echo '<p>';
			  echo tep_draw_form('export', FILENAME_STATS_INACTIVE_USER. '?go=deletenull');
		  echo '   <input type="submit" value="'. SIU_DELETE_NULL .'">';
	  echo '</form>';
		 		 echo '<p>';
?>
		<table border="0" width="100%" cellspacing="0" cellpadding="4">
	<tr class="dataTableHeadingRow">
	  <td class="dataTableHeadingContent"><?php echo TABLE_HEADING_ID; ?></td>
	  <td class="dataTableHeadingContent"><?php echo TABLE_HEADING_CUSTOMERS; ?></td>
	  <td class="dataTableHeadingContent"><?php echo TABLE_HEADING_EMAIL; ?></td>
	  <td class="dataTableHeadingContent"><?php echo TABLE_HEADING_NEWS; ?></td>
	  <td class="dataTableHeadingContent"><?php echo TABLE_HEADING_LAST_LOGON; ?></td>
	  <td class="dataTableHeadingContent"><?php echo TABLE_HEADING_DELETE; ?></td>
	</tr>
<?php
  $siu_query_raw = "select ci.customers_info_date_of_last_logon, c.customers_id, c.customers_firstname, c.customers_lastname, c.customers_email_address, c.customers_newsletter from " . TABLE_CUSTOMERS_INFO . " ci join " . TABLE_CUSTOMERS . " c left join " . TABLE_ORDERS . " o on c.customers_id = o.customers_id where o.customers_id is NULL and c.customers_id = ci.customers_info_id order by c.customers_id";
  $siu_split = new splitPageResults($HTTP_GET_VARS['page'], MAX_DISPLAY_SEARCH_RESULTS, $siu_query_raw, $siu_query_numrows );
  $siu_query = tep_db_query($siu_query_raw);
  while ($customers = tep_db_fetch_array($siu_query)) 
  {
	if ($customers['customers_newsletter'] == '1') 
	{
		$customers['customers_newsletter'] = NEWSLETTER_YES;
	  } 
	  else
	   {
		$customers['customers_newsletter'] = NEWSLETTER_NO;
	  }
?>
  <tr class="dataTableRow"> 
	<td class="dataTableContent"><?php echo $customers['customers_id'];?></td>
	<td class="dataTableContent"><?php echo $customers['customers_firstname'] . ' ' . $customers['customers_lastname'];?></td>
	<td class="dataTableContent"><?php echo '<a href="mailto:' . $customers['customers_email_address'] . '"><u>' . $customers['customers_email_address'] . '</u></a>'; ?></td>
	<td class="dataTableContent"><?php echo $customers['customers_newsletter']; ?></td>
	<td class="dataTableContent"><?php echo tep_date_short($customers['customers_info_date_of_last_logon']); ?></td>
	<td class="dataTableContent"><?php echo '<a href="' . tep_href_link(FILENAME_STATS_INACTIVE_USER, 'go=delete&id=' . $customers['customers_id'] . '&page=' . $HTTP_GET_VARS['page']) .'">' . SIU_DELETE . '</a>'; ?></td>
  </tr>
<?php
 }
?>
  </table></td>
  </tr>
  <tr>
	<td colspan="6"><table border="0" width="100%" cellspacing="0" cellpadding="2">
	  <tr>
		<td class="smallText" valign="top"><?php echo $siu_split->display_count($siu_query_numrows, MAX_DISPLAY_SEARCH_RESULTS, $HTTP_GET_VARS['page'], TEXT_DISPLAY_NUMBER_OF_CUSTOMERS); ?></td>
		<td class="smallText" align="right"><?php echo $siu_split->display_links($siu_query_numrows, MAX_DISPLAY_SEARCH_RESULTS, MAX_DISPLAY_PAGE_LINKS, $HTTP_GET_VARS['page'], tep_get_all_get_params(array('page', 'info', 'x', 'y', 'cID'))); ?></td>
	  </tr>
   </table></td>
 </tr>
</table></td>
</tr>
</table></td>
<!-- body_text_eof //-->
 </tr>
</table>
<!-- body_eof //-->
<?php
 }

?>
<!-- footer //-->
<?php require(DIR_WS_INCLUDES . 'footer.php'); ?>
<!-- footer_eof //-->
</body>
</html>
<?php require(DIR_WS_INCLUDES . 'application_bottom.php'); ?>

I don't know how to change this so it reads also from phplist.

Anybody has the same problem?

ps: sorry for my english, I'am dutch.

June 4, 2008

Someone known how to make 2gethet discount like this

to use attributes for textile.

thancks

Hi,

Does someone has a installation file to have attributes with 2gether?

I have tried the instructions of page 9 of this furum, but I'am not a PHP programmer, so I'm confused. :blink:

I think this contribution is one of the most important contributions, but attributes is also very important in my sector (audio & video).

Colors,....

If someone could make this clear for dummies like me (I tried, but I fail), others and I would much appreciate this.

I'am sorry for my english, I'am dutch.

This is one of the last things I have to do for my website, so I would be glad if someone could help me :rolleyes:

Many thanks to all

Jonathan DC

Posts

Joined

Last visited

Content Type

Profiles

Forums

Posts posted by Jonathan DC

2gether Discount

2gether Discount

2gether Discount

Wishlist 3.0 Support Thread

AJAX Attribute Manager support

AJAX Attribute Manager support

PHPList integration to OsCommerce

2gether Discount

Browse

Activity