kobeyn

Hallo Kgt I use paypal_ipn and have tried your suggetion but the code never goes in this functons. and i am forwarded to paypal page again. I think this has no relation with the paypal-ipn module. instead we should make some checks in the checout_confirmation page and if the $order->info['total'] == 0 then the next page should be chekout_success page. maybe something in this place in checkout_confirmation.php if (isset($$payment->form_action_url)) { $form_action_url = $$payment->form_action_url; } else { $form_action_url = tep_href_link(FILENAME_CHECKOUT_PROCESS, '', 'SSL'); } echo tep_draw_form('checkout_confirmation', $form_action_url, 'post'); if (is_array($payment_modules->modules)) { echo $payment_modules->process_button(); } echo tep_image_submit('button_confirm_order.gif', IMAGE_BUTTON_CONFIRM_ORDER) . '</form>' . "\n"; hier we can make a check whether the total is 0 or not and if it is then we set the $form_action_url as our new page which does the rest of the job (I don't know exactly what this new file should do!! for example insert the order to the table or something like this) could you maybe help me ? thanks a lot

I have solved this problem. This problem occurs because I have installed the german language package and the error definitions are very long. therefore it causes this error. I have changed the error definitions in german.php and now it works. but I have still other question. what happens if the amount will be 0 ? for example a product costs 10€ and I want to gift somebody this product. then I create a coupon with fixed amount 10€ but if the customer use this coupon the amount will 0 (which is correct) but still the customer is forwarded to the paypal page (with amount of 0!!!) how can fix this? many thanks

and if I write an invalid code I get the error but then I cannot continue to use oscommerce . I get this error Call to a member function add_current_page() on a non-object in /var/www/localhost/htdocs/includes/application_top.php on line 319 has onyone get this error before??

Hallo kgt, I have 2 more questions :) 1) sometimes I get an error 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 'or z2g.zone_id = 0 or z2g.zone_id IS NULL ) ' at line 5 SELECT dc2z.geo_zone_id FROM discount_coupons_to_zones dc2z LEFT JOIN zones_to_geo_zones z2g USING( geo_zone_id ) WHERE ( z2g.zone_id= or z2g.zone_id = 0 or z2g.zone_id IS NULL ) AND ( z2g.zone_country_id= or z2g.zone_country_id = 0 ) AND dc2z.coupons_id="55C4PDH9" my mysql version is 5 and I use php5 in linux server. I don't accept any zones what can be reason for this problem? 2) what happens if the amount will be 0 ? for example a product costs 10€ and I want to gift somebody this product. then I create a coupon with fixed amount 10€ but if the customer use this coupon the amount will 0 (which is correct) but still the customer is forwarded to the paypal page (with amount of 0!!!) how can fix this? many thanks regards Taylan

Hallo, I am new by oscommerce and I have a problem. I want to accept kreditkards in oscommerce. I have installed paypal ipn but in germany (where my shop located) paypal doesn't support the creditcard payment if the customer doesn't have a paypal account. And now I don't which module should I install to accept the Kreditcard payment in my shop. and the 2. question is : with paypal ipn we get a response from paypal "VERIFIED" and then we can now that the payment was succesful but how does it work with creditcards? I will be very Happy if someone can help me because I really can not find information about it. P.S the shop is in German many thanks

Hi kqt, thanks for your answer I have read from your Readme file how I shold edit paypal_ipn and then I have made this edit but with this code in the discount_order table only order id is written (no coupon code) and therefore a coupon can be used always. therefore I have written in the paypal_ipn after this code //+1.4 $sql_data_array = array('orders_id' => $insert_id, 'orders_status_id' => $order->info['order_status'], 'date_added' => 'now()', 'customer_notified' => '0', 'comments' => $order->info['comments']); tep_db_perform(TABLE_ORDERS_STATUS_HISTORY, $sql_data_array); //-1.4 following code (I have changed your code because it doesn't write any coupon Id) if( tep_session_is_registered( 'coupon' ) && is_object( $order->coupon ) ) { $sql_data_array = array( 'coupons_id' => $order->coupon->coupon['coupons_id'], 'orders_id' => $insert_id ); tep_db_perform( TABLE_DISCOUNT_COUPONS_TO_ORDERS, $sql_data_array ); } but in this case the coupon is inserted to table now and this cause the problem I have said. can you please explain me how should the logic be to use copuon with paypal ipn? maybe I understand something wrong. if I understand it correctly the code never goes to the checkout_process.php if we choose paypal_ipn??? thanks again

Hi kgt no I have the code that inserts the coupon as "used" in the discount_coupons_to_orders table in checkout_process.php as it is described in installation file. and it works fine with creditcard but my question is related with ipn 2.2 module. if we choose paypal_ipn as payment type then the code is not forwarded to the checkout_process.php after checkout_confirmation.php instead it is forwarded to the paypal page. and the problem is following if we choose paypal ipn the coupon is inserted in the discount_coupons_to_orders table before we go to to the checkout_confirmation page. and in checkout_confirmation page we have the chance to go to shopping cart and buy something else. but this means this coupon will be inserted 2 times to the table and if this coupon can only be used 1 time in the shop it causes a failure and we can not use it . I hope that I can explain my problem. If I couldn't please try the following then you will understand it :) create a coupon with Number Available = 1 than buy somethin in the shop in checkout_payment choose the paypal ipn. type your coupon code and continue now in checkout_confirmation page click the Cart Contents and buy something and go to checkout_payment page and this time you can not use your code because it is already written in the table. an d it means you can not use this coupon. how can we fix this? do you have any suggestion? thanks a lot

has anybody checked these errors? will be very happy if I get an answer :) best wishes

has anybody checked these errors? will be very happy if I get an answer :) best wishes

Hello again I dindn't get any answer and therefore I have tried it and it works :) but I have some questions 1) if a coupon has Number Available = 1. customer write this coupon code in checkout_payment page and then is forwarded to checkout_confirmation page at this time the coupon information is written in discount_coupons_to_orders table (which is used to check whether the coupon is still available to use - if coupon entity in this table < number available then this copuon can be used.) and if at this time customer can buy something before he press to confirm order button. but in this case he can not use this coupon because it is already written in the table. (even if customer don't use it yet) is this a bug? should we take insert table part in checkout_confirmation page? do I think something wrong? 2) I use paypal_ipn 2.2 and I have tried the both code (one of them is in contribution page added by kqt) and as following //kgt - discount coupons if( tep_session_is_registered( 'coupon' ) && $order->info['coupon'] != '' ) { $sql_data_array = array( 'coupons_id' => $order->info['coupon'], 'orders_id' => $insert_id ); tep_db_perform( TABLE_DISCOUNT_COUPONS_TO_ORDERS, $sql_data_array ); } //end kgt - discount coupons but in the readme file of Discount Coupon Codes 3.0 version there is something else ADD this code after: //kgt - discount coupons if( tep_session_is_registered( 'coupon' ) && is_object( $order->coupon ) ) { $sql_data_array = array( 'coupons_id' => $order->coupon->code, 'orders_id' => $insert_id ); tep_db_perform( TABLE_DISCOUNT_COUPONS_TO_ORDERS, $sql_data_array ); } //end kgt - discount coupons I have tried the both of them but in any case the coupon information didn't write in the discount_orders table and then I have tried it with the following code //kgt - discount coupons if( tep_session_is_registered( 'coupon' ) && is_object( $order->coupon ) ) { $sql_data_array = array( 'coupons_id' => $order->coupon->coupon['coupons_id'], 'orders_id' => $insert_id ); tep_db_perform( TABLE_DISCOUNT_COUPONS_TO_ORDERS, $sql_data_array ); } //end kgt - discount coupons and it works. can anybody check this failures give me a feedback?? many thanks best regards

Hallo thanks for this contribution I think this contribution is exactly what I need :) I have some already installed some contributions (ipn v2.2, downloadcontroller.) I have looked the packages and seen that there are several versions. to avoid a mistake I want to be sure before I start to edit my files. should I install Discount Coupon Codes 3.0 (I think this is a full package) and I sould correct this bugfix Discount Coupon Codes 3.0 checkout_process bugfix and besides them replace the includes/modules/payment/paypal_ipn.php file with in (Paypal IPN v 2.2) is this true? thanks a lot

sorrryyy because of german :) it means : I want to do following : in our shop admin can create several discount coupons and send these coupons to several customers. each coupon has a discount procent , date information (how long this coupon is valid) and a unique code. each coupon can only be used 1 time and only by one customer. admin can create more than 1 coupons in concurrently(with several coupon codes but wit same expiration date and discount procent). is there any Contribution for this purpose? or is can anybody suggest me a contribution that I can easily modify for these purposes? I have already looked coupons_by_ingo it looks like very good but by this contr. one coupon can be used by all customers. (I am not sure whether a modification is possible by this cont to make each coupon for one customer) besides it there is ot_discount_coupon_codes but I'm not sure. may be can somebody suggest me something (PLEASEE) manyy thanks best regards :)

Hallo an alle, ich will folgendes machen : in unsere shop admin kann einige Coupons erstellen und diese coupons an bestimmte kunden senden. jede coupon hat eine prozentrabat und gultigkeitsdauer, jede coupon darf nur einmal und nur von einer Kunde benutzt werden. admin kann gleichzeitig mehrere coupons erstellen (also mit verschieden couponscode.) gibt es eine Contribution für solche Zwecke? oder welce Contribution könnt ihr mir empfehlen die ich mit wenigstens mühe so modifizieren kann? ich habe mir schon coupons_by_ingo geschaut es sieht ganz gut aus aber dort eine koupon kann von alle Kunden benutz werden, (ich weiss nicht ob eine änderung bei dieser möglich ist) ausserdem gibt es ot_discount_coupon_codes aber ich weiss nicht viellecht gibt es irgendwas, es genau was ich will vieeelen Dank vieleeeeeee Grüsse :)

Hallo again I couldn't find any solution yet and there is no answer. is there any solution for this problem? I would be pleased if someone can give a suggestion many thanks

thanks a lot at least that you give an answer :) this maybe a solution but if I have more options values than it is a little bit complicated and I want that to show the customer 2 options one for OS and one for versions. but Many thanks again for your suggestion

Hallo Hallo I have a shop in which only the downloadable products sold. I want to add 2 Products Options for a product and 2 options value for each of the options for example : software A has a linux version and windows version and for each operating system 2 versionen with numbers 1.0 and 1.1 also SWA-linux-v1.0 SWA-linux-v1.1 SWA-windows-v1.0 SWA-windows-v1.1 I want allow the customer to select the operating system and version in product_info page. therefore I have added 2 options (operatingsystem and version) and 2 optionsvalue for each (linux - windows / v1.0 - v1.2) in admin. but I can not combine these properties. in Products Attributes in admin. I can give as following product optionname option value download link SWA OS linux ???? SWA OS windows ??? SWA version v1.0 ??? SWA version v1.1 ??? but if I define it like this then I can see these options in product_info page but after the payment I get 2 link for the product. one for OS and one for version. I want to define it like following product optionname option value optionname optionvalue download link SWA OS linux version v1.0 SWA-linux-v10.exe SWA OS linux version v1.1 SWA-linux-v11.exe SWA OS windows version v1.0 SWA-windows-v10.exe SWA OS windows version v1.1 SWA-windows-v11.exe how can I realize this? is there any contribution for this?? please help I am searching this since a long time. many thanks

Hello I have installed paypal ipn. everything works fine I use sandbox testing environment and after I can see the e-mails with the amount informations. but the only thing that doesn't work is ipn.php :( I want to debug this code but I have found that the code never comes here. I didn't use ssl and defined the return and notify_url adddresses in paypal_ipn.php as well as in my sandbox business account as following : notify_url : mydomain/ext/modules/payment/paypal_ipn/ipn.php return : mydomain/checkout_process.php (then I have tried it with checkout_success and it seems to be better :)) after payment I will forwarded to return addresse too. as I have said the only thing that wrong is something with ipn.php !! what can be wrong? why ipn.php doesn't get any post from paypal?? I'd wonder if anybody could help me. many thanks

Hi I have the same problem did you find a solution ? thanks

ich habe die lösung gefunden und zwar wir müssen nur die folgendes command schreiben update mysql.user set password = old_password('newpassword') where user='user'; dann geht das.

ich habe was gefunden dass ich the mysql service with old passwort option starten soll. ich habe es auch versucht aber es funktioniert immer noch nicht bitte um Hilfe

Ich versuche oscommerce zu installieren aber ich bekomme diese Fehler. Client does not support authentication protocol requested by server; consider upgrading MySQL client ich benutze als server addresse localhost, ich gebe the root passwort ein und ich habe ein db mit der name oscommerce erzeugt was kann hier falsch sein?? ich benutze mysql 5.0 und hatte bisher keine probleme bei verbindungen java usw. danke grüsse