henri Posted December 8, 2002 Share Posted December 8, 2002 (edited) Ok, the first Release. Differences to Steve Alpha: -Optimised a lot of SQL Querys -Bugfixes -new Database Strukture -removed not yet working things -Introduced a billing system in the Admin Get it here contributions Test it and find the bugs (hope i didn't produced some news with the last changes i did today) what do i want to do until 1.0: - registration: more fields - perhaps a change of the bannermanger - some codeoptimation (getting it to OSC-Standards) - check for unused defines and other old stuff which is in the code I will try to fix upcoming bugs very fast, new features have to wait due lack of time. Whats would be usefull: - someone makes the missing / changes the worse Buttons - Translation to german/espanol Have Fun Henri Edited October 22, 2003 by Johnson Quote Link to comment Share on other sites More sharing options...
henri Posted December 8, 2002 Author Share Posted December 8, 2002 (hope i didn't produced some news with the last changes i did today) Wat did i wrote here :?: Hope i didn't produce some new bugs with the last changes i did today Quote Link to comment Share on other sites More sharing options...
Guest Posted December 8, 2002 Share Posted December 8, 2002 Hi, the link does not work? Quote Link to comment Share on other sites More sharing options...
henri Posted December 8, 2002 Author Share Posted December 8, 2002 I see, wait untill it comes up again... Maintance... Quote Link to comment Share on other sites More sharing options...
rseigel Posted December 9, 2002 Share Posted December 9, 2002 Any way you could set up a CVS commits mailing list Henri? I really want to set this up but I want to be able to add any changes ASAP. I'll help test and submit all the bugs I can find. :onfire: Quote Link to comment Share on other sites More sharing options...
shahed Posted December 9, 2002 Share Posted December 9, 2002 Henry well done Bro, I will check it today Shahed Quote Link to comment Share on other sites More sharing options...
henri Posted December 9, 2002 Author Share Posted December 9, 2002 Any way you could set up a CVS commits mailing list Henri? I really want to set this up but I want to be able to add any changes ASAP. I'll help test and submit all the bugs I can find. :onfire: Mailing List? Yes i'll check it out as soon as posible, (don't know so much of sourceforge yet). Quote Link to comment Share on other sites More sharing options...
elbavaro Posted December 9, 2002 Share Posted December 9, 2002 Hello Henri, tried to set up the osc affiliate. running the affiliate.sql (using phpmyadmin) i get the following Error: SQL-query : INSERT INTO affiliate_payment_status VALUES ( 0, 1, 'Pending' ) MySQL said: Table 'test.affiliate_payment_status' doesn't exist With which parameters I have to insert the affiliate_payment_status table? Thanks in advance, EL Bavaro :cry: Quote EL Bavaro Link to comment Share on other sites More sharing options...
henri Posted December 9, 2002 Author Share Posted December 9, 2002 Yes just saw it, I updated the inserts for all languages and somehow put them before the create Statement. The part must look so: (remove the inserts before) DROP TABLE IF EXISTS affiliate_payment_status; CREATE TABLE affiliate_payment_status ( affiliate_payment_status_id int(11) NOT NULL default '0', affiliate_language_id int(11) NOT NULL default '1', affiliate_payment_status_name varchar(32) NOT NULL default '', PRIMARY KEY (affiliate_payment_status_id,affiliate_language_id), KEY idx_affiliate_payment_status_name (affiliate_payment_status_name) ) TYPE=MyISAM; INSERT INTO affiliate_payment_status VALUES (0, 1, 'Pending'); INSERT INTO affiliate_payment_status VALUES (1, 1, 'Payed'); INSERT INTO affiliate_payment_status VALUES (0, 2, 'Offen'); INSERT INTO affiliate_payment_status VALUES (1, 2, 'Ausgezahlt'); INSERT INTO affiliate_payment_status VALUES (0, 3, 'Pending'); INSERT INTO affiliate_payment_status VALUES (1, 3, 'Payed'); Quote Link to comment Share on other sites More sharing options...
elbavaro Posted December 9, 2002 Share Posted December 9, 2002 Thanks Henri, sql problem solved! Great work. Some minor bugs I came across (possibly my errors): 1. I inserted 3 different banners (one jpg - and two gifs) - but can not see any banner in the /catalog/affiliate_banners.php. The banner text is shown perfectly. (I remember that on your site - the banner was shown also). 2. If I insert the link into "an affiliates webpage" the banner does also not show up. 3. Having sold something to a customer via the affiliate link - the sales do show up properly in the affiliates page. But i can not Bill it. I set the threshold down to $3 but I can not get any bill having set. Whenever I press the "Start Billing"-Button it says "Your Affiliates have been sucessfully billed" - but nothing had been billed. Do I do something wrong? Well that's it for the moment - perhaps you can help me out. Best Bavarian Regards, EL Bavaro :D Quote EL Bavaro Link to comment Share on other sites More sharing options...
henri Posted December 9, 2002 Author Share Posted December 9, 2002 Hi 1+2: I think I must see it; can you mail me a url? 3: Have you set the status of the order to delivered? Quote Link to comment Share on other sites More sharing options...
elbavaro Posted December 9, 2002 Share Posted December 9, 2002 Hi Henri, 1+2 - sorry - but it is an internal server. 3 - yes - i tried it all - pending & confirmed, but neither didn't work. EL Bavaro Quote EL Bavaro Link to comment Share on other sites More sharing options...
henri Posted December 9, 2002 Author Share Posted December 9, 2002 Ok to 1: You get a img Url: http://.../affiliate_show_banner.php?ref=3569&products_id=&affiliate_pbanner_id=28 Take this URL and try it in a new Browser Window. Perhaps an error happens, if not send me an mail (with the link you get) and i send you an modified version to check for errors. you can also try:affiliate_configure.php -> set set AFFILIATE_KIND_OF_BANNERS to 1 (but then no stats) to 3: Perhaps: admin/includes/afiliate_configure.php define ('AFFILIATE_BILLING_TIME','30'); // Orders billed must be at leat '30' days old. // needed if a order is refunded Quote Link to comment Share on other sites More sharing options...
henri Posted December 9, 2002 Author Share Posted December 9, 2002 Set the Time to -1 to bill todays stuff Quote Link to comment Share on other sites More sharing options...
henri Posted December 9, 2002 Author Share Posted December 9, 2002 Ok released 0.2 - fixes the installation Bug in the sql - minor changes in the banners Quote Link to comment Share on other sites More sharing options...
nyckeln Posted December 10, 2002 Share Posted December 10, 2002 Hi! I get following error, on both admin and affiliate customer.. Any who got any idea? Best Regards! :D /Patrick Andersson Quote Link to comment Share on other sites More sharing options...
nyckeln Posted December 10, 2002 Share Posted December 10, 2002 Hi! What has "affiliate_payment_status" for function? I havent figured it out yet. :?: I inserted INSERT INTO affiliate_payment_status VALUES (5, 4, 'Mottagen'); INSERT INTO affiliate_payment_status VALUES (9, 4, 'V?ntar p? svar'); INSERT INTO affiliate_payment_status VALUES (10, 4, 'Restnoterad'); INSERT INTO affiliate_payment_status VALUES (6, 4, 'Behandlas'); INSERT INTO affiliate_payment_status VALUES (7, 4, 'Levererad'); INSERT INTO affiliate_payment_status VALUES (8, 4, 'Raderad'); INSERT INTO affiliate_payment_status VALUES (11, 4, 'F?rskott'); INSERT INTO affiliate_payment_status VALUES (12, 4, 'V?ntar p? betalning'); INSERT INTO affiliate_payment_status VALUES (13, 4, 'Betald - Uth?mtad'); I use the same orders_status in OsC admin.. Please, explain for me.. Best Regards, Patrick Andersson Quote Link to comment Share on other sites More sharing options...
nyckeln Posted December 10, 2002 Share Posted December 10, 2002 Hi! Even more errors... Hmmm When I made a test order, and then I went to affiliate_summary.php I got following error.. Fatal error: Call to undefined function: tep_round() in /affiliate_summary.php on line 45 Line 45 is.. $affiliate_conversions = tep_round($affiliate_clickthroughs/$affiliate_transactions,2)."%"; And when i goes to admin I get following error.. Fatal error: Call to undefined function: tep_round() in /affiliate_summary.php on line 41 Line 41 is.. $affiliate_conversions = tep_round($affiliate_transactions/$affiliate_clickthroughs,6)."%"; Hmmm... Best Regards, Patrick Andersson Quote Link to comment Share on other sites More sharing options...
nyckeln Posted December 10, 2002 Share Posted December 10, 2002 Hi! I forgott.. Where is the column_right.php on affiliate_summary.php (customer) I have tried to edit affiliate_summary.php, but I cant find the error. :cry: Best Regards, Patrick Andersson Quote Link to comment Share on other sites More sharing options...
henri Posted December 10, 2002 Author Share Posted December 10, 2002 tep_round is a OSC-Function in general.php Which Snapshot du you use? Try to copy it from a actuell Snapshot to general.php. If you find more of those funvctions please post it here, thn i try to find a solution. Cu Henri Quote Link to comment Share on other sites More sharing options...
henri Posted December 10, 2002 Author Share Posted December 10, 2002 Ok, i started inserting compatibility functions for older snapshots :) CVS-Only untill the next release (files: affiliate_application_top, and /functions/affiliate_functions.php in catalog and admin) >Where is the column_right.php on affiliate_summary.php I think it doesn't show up couse of the error... Quote Link to comment Share on other sites More sharing options...
nyckeln Posted December 10, 2002 Share Posted December 10, 2002 Hi! My Osc is from july 02, but I took a "new" general.php and used it instead. It works.. :) Best Regards, Patrick tep_round is a OSC-Function in general.php Which Snapshot du you use? Try to copy it from a actuell Snapshot to general.php. If you find more of those funvctions please post it here, thn i try to find a solution. Cu Henri Quote Link to comment Share on other sites More sharing options...
smigo Posted December 10, 2002 Share Posted December 10, 2002 The affiliate Sales where added like this in the database Product Price + Tax + Shipping I think the bug is in the affiliate_checkout_process I think this file is for the old oders Table. Thats why the file add the shipping. Is the bug in the first line after $affiliate_total ? my shop is 2.2 from 30.10.2002 $affiliate_total = $order->info['total']-$order->info['shipping_cost']; $affiliate_percentage = AFFILIATE_PERCENT/100; $affiliate_payment = $affiliate_total*$affiliate_percentage; if ($HTTP_SESSION_VARS['affiliate_ref']) { $sql= "insert into ". TABLE_AFFILIATE_SALES ." (affiliate_id , affiliate_date, affiliate_browser , affiliate_ipaddress , affiliate_value , affiliate_payment , affiliate_orders_id , affiliate_clickthroughs_id ) VALUES ('$affiliate_ref', '$affiliate_clientdate', '$affiliate_clientbrowser', '$affiliate_clientip','$affiliate_total', '$affiliate_payment','$insert_id','$affiliate_clickthroughs_id') "; tep_db_query($sql); } ?> Chris Quote Link to comment Share on other sites More sharing options...
henri Posted December 11, 2002 Author Share Posted December 11, 2002 Just checked it: Zwischensumme: 34.79EUR inc. Tax Tax.: 4.80EUR Shiping: 10.00EUR Nachnahmegeb?hr: 3.48EUR <- comes from a german extra modul Sum: 48.27EUR 10% Provision: 3.82EUR $affiliate_total = $order->info['total']-$order->info['shipping_cost']; $affiliate_percentage = AFFILIATE_PERCENT/100; 48.27Euro - 10.00 Euro = 38.27 Euro 38.27 Euro *10/100 = 3,82 Euro (10%) Seems to be right. (its like amazon bills here) So if you want to calc stuff without tax, you have to substract it also. If you are using this Nachname-Modul you shou subtract its cost too.. And as i recall it works with all Checkouts, cause i didn't adjust it for the new one. Quote Link to comment Share on other sites More sharing options...
nyckeln Posted December 11, 2002 Share Posted December 11, 2002 Hi! I have tried so many times, but it don?t works. I?ve got only one language id=4 INSERT INTO languages VALUES (4, 'Svenska', 'se', 'icon.gif', 'svenska', 0); And the orderstatus I want to use is 13. INSERT INTO orders_status VALUES (13, 4, 'Betald - Uth?mtad'); My admin affiliate_configure.php looks like.. define ('AFFILIATE_BILLING_TIME','-1'); // Orders billed must be at leat '30' days old. // needed if a order is refunded // CHECKIT define ('AFFILIATE_PAYMENT_ORDER_MIN_STATUS','13') // Which status must an order have, to be billed Why will it dont work?? When I press "Payment" its empty, i have made testorders, and I have set orderstatus 13 - Betald - Uth?mtad. Please.. Best Regards, Patrick Andersson Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.