_PHPSHOP_AFFILIATE_LIST_LBL, 'affiliate', "affiliate_list"); // Enable the multi-page search result display $limitstart = mosgetparam( $_REQUEST, 'limitstart', 0); if ($keyword) { $list = "SELECT * FROM #__{sc}_vendor WHERE "; $count = "SELECT count(*) as num_rows FROM v#__{sc}_endor WHERE "; $q = "(vendor_name LIKE '%$keyword%' OR "; $q .= "vendor_store_desc LIKE '%$keyword%'"; $q .= ") "; $q .= "ORDER BY vendor_name ASC "; $list .= $q . " LIMIT $limitstart, " . SEARCH_ROWS; $count .= $q; } elseif ($vendor_category_id) { $q = ""; $list="SELECT * FROM #__{sc}_vendor, #__{sc}_vendor_category WHERE "; $count="SELECT count(*) as num_rows FROM #__{sc}_vendor,#__{sc}_vendor_category WHERE "; $q = "#__{sc}_vendor.vendor_category_id=#__{sc}_vendor_category.vendor_category_id "; $q .= "ORDER BY #__{sc}_vendor.vendor_name ASC "; $list .= $q . " LIMIT $limitstart, " . SEARCH_ROWS; $count .= $q; } else { $q = ""; $list = "SELECT * FROM #__users, #__{sc}_affiliate"; $list .= " WHERE #__users.user_info_id = #__{sc}_affiliate.user_id"; $list .= " AND #__users.id = '".$auth["user_id"]."'"; $list .= " ORDER BY company ASC"; $count = "SELECT count(*) as num_rows FROM #__{sc}_affiliate"; $list .= $q . " LIMIT $limitstart, " . SEARCH_ROWS; $count .= $q; } $db->query($count); $db->next_record(); $num_rows = $db->f("num_rows"); if ($num_rows == 0) { echo $VM_LANG->_PHPSHOP_NO_SEARCH_RESULT; } else { ?> query($list); $i = 0; while ($db->next_record()) { if ($i++ % 2) $bgcolor=SEARCH_COLOR_1; else $bgcolor=SEARCH_COLOR_2; ?> >

_PHPSHOP_AFFILIATE_LIST_AFFILIATE_NAME ?>	_PHPSHOP_AFFILIATE_LIST_AFFILIATE_ACTIVE ?>	_PHPSHOP_AFFILIATE_LIST_MONTH_TOTAL?>	_PHPSHOP_AFFILIATE_LIST_MONTH_COMMISSION?>	_PHPSHOP_AFFILIATE_LIST_ADMIN ?>
f("affiliate_id"); echo ""; echo $db->f("company"); echo " "; ?>	f("active")=='Y') echo "Yes"; else echo "No"; ?>	f("affiliate_id")."'"; $q .=" GROUP BY affiliate_id"; $dbt->query($q); if($dbt->next_record()){ printf("%1.2f",$dbt->f("stotal")); } else echo "no sales"; ?>	f("stotal")){ printf("%1.2f",$dbt->f("stotal") * ($db->f("rate")*0.01)); } else echo "none"; ?>	f("affiliate_id")) ?>">go