lammy

Hi I am posting a link to a post made earlier in the general support area. though my requirement specifically concerned with oscaffiliate, the problem raised here have much wider implication. That's why I posted to general support area but, sure oscaffiliate users will find the issues interesting. the link

Hi Alex Installed SDS in local system.... working Ok. Thank You Very Much. I have some doubts to clear case 1... After the order is placed... In My Account/Order Information[account_history_info.php?order_id=4] 1] affmasters - classic: 16 mb the above has 3 components ... a] affmasters, the download's name[file name:affmasters.zip] b] classic, the option c] 16 mb, the option value Now when the customer places the order orders_status... 1]pending ... ok NO download link 2] download now available ... ok download link available ... 5 downloads remaining makes a download... screen refresh ... 4 downloads remaining log-out 3] status 'update' in admin... re-login... MyAccount ... 5 downloads remaining [does system work like this or is this an error?] ========== case 2 makes a copy of the same file in the same folder 'download/aff' and named it Affmarket_2 in admin--catalog, added a new category... added Affmarket_2 as product now... Products Attributes--- Product Options same as above, value a different one from above, file group same as above, a different price..... download link available when status is download now available.... great! but when download is initiated... the dialogue box displayed old file name... i.e. affmasters.zip ... not Affmarket_2.zip for which the 2nd order wad placed! please comment on this issue... I think I have followed the steps carefully... thanks

Hi Alex Installed SDS in local system.... working Ok. Thank You Very Much. I have some doubts to clear case 1... After the order is placed... In My Account/Order Information[account_history_info.php?order_id=4] 1] affmasters - classic: 16 mb the above has 3 components ... a] affmasters, the download's name[file name:affmasters.zip] b] classic, the option c] 16 mb, the option value Now when the customer places the order orders_status... 1]pending ... ok NO download link 2] download now available ... ok download link available ... 5 downloads remaining makes a download... screen refresh ... 4 downloads remaining log-out 3] status 'update' in admin... re-login... MyAccount ... 5 downloads remaining [does system work like this or is this an error?] ========== case 2 makes a copy of the same file in the same folder 'download/aff' and named it Affmarket_2 in admin--catalog, added a new category... added Affmarket_2 as product now... Products Attributes--- Product Options same as above, value a different one from above, file group same as above, a different price..... download link available when status is download now available.... great! but when download is initiated... the dialogue box displayed old file name... i.e. affmasters.zip ... not Affmarket_2.zip for which the 2nd order wad placed! please comment on this issue... I think I have followed the steps carefully... thanks

in admin/affiliate_payment.php in version 2.6 osc_affiliate line 164 is tep_db_query("update " . TABLE_AFFILIATE_SALES . " SET affiliate_billing_status = '0' where affiliate_payment_id = '" . tep_db_input($pID) . "'"); in version 2.7 it is not there... can somebody explain the reason for this change....please. I presumed ... the logic is... not to reprocess, the once processed payments...if i am right, should we include it? Also found similar differences in admin/affiliate_affiliate.php.

Hello, do take a look at this post. Its regarding 'only customers who has placed at least an order with status > = processing and for a minimum amount of $$...only were allowed to register as affiliates' this is verified at the time of affiliate registration and at subsequent logins... an sql tested... http://www.oscommerce.com/forums/index.php?sho...=280673&hl= thanks lammy

Hello, The idea is to.... 1] Make prospective affiliates register as customers and place a minimum amount order to be able to join as affiliates. For that code [sql-qry] in affiliate_signup.php [~line 192] edited. 2] Make system check affiliate login and verify weather the affiliate is a customer and has made certain amount of purchase. For that code in affiliate_affiliate.php [~line 23] edited. Following are the codes tested and error produced... Other than affiliate table, order table too is queried.... ======== $check_email_query = tep_db_query("SELECT count(customers_email_address) AS total, currency_value, order_status FROM order WHERE order_status => '2' AND (customers_email_address = '".tep_db_input($a_email_address)."') GROUP BY customers_email_address HAVING (SUM(currency_value)=> 50)"); $check_email = tep_db_query("select affiliate_email_address from " . TABLE_AFFILIATE . " where affiliate_email_address = '" . tep_db_input($a_email_address) . "'"); $check_c_email = tep_db_fetch_array($check_email_query); if ($check_c_email['total'] < 1) { $error = true; $message = Be a customer, then register; }elseif (tep_db_num_rows($check_email)) { $error = true; $entry_email_address_exists = true; } else { $entry_email_address_exists = false; } ========ERROR===for above query====== 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 'order WHERE order_status => '2' AND (customers_email_address = '[email protected]'' at line 1 SELECT count(customers_email_address) AS total, currency_value, order_status FROM order WHERE order_status => '2' AND (customers_email_address = '[email protected]') GROUP BY customers_email_address HAVING (SUM(currency_value)=> 2) ===ERROR 2===For change ===(customers_email_address = '".tep_db_input($a_email_address)."')===to===_address)."'")=== Parse error: syntax error, unexpected T_STRING in ****\_htdocs\*****\affiliate_signup.php on line 208 ======== Now for checking customer table before affiliate allowed to login edit affiliate_affiliate.php // Check if C & A username exists $check_email_query = tep_db_query("SELECT count(customers_email_address) AS total, currency_value, order_status FROM order WHERE order_status => '2' AND (customers_email_address = '".tep_db_input($a_email_address)."') GROUP BY customers_email_address HAVING (SUM(currency_value)=> 50)"); $check_affiliate_query = tep_db_query("select affiliate_id, affiliate_firstname, affiliate_password, affiliate_email_address from " . TABLE_AFFILIATE . " where affiliate_email_address = '" . tep_db_input($affiliate_username) . "'"); $check_c_email = tep_db_fetch_array($check_email_query); if ($check_c_email['total'] < 1) { $error = true; $message = 'Be a customer, then register as an affiliate, then login'; }else{ (!tep_db_num_rows($check_affiliate_query)) { $HTTP_GET_VARS['login'] = 'fail'; # } else { $check_affiliate = tep_db_fetch_array($check_affiliate_query); ======================above too has produced an error====================== can anybody from the community help me with correct codes please help Lammy