gewoon09 Posted October 28, 2010 Posted October 28, 2010 hi, I tried to install iDEAL (ideal-for-oscommerce-2-2). The problem I encountered is that after installing iDEAL, it is the only available payment method at checkout_payment.php I selected 3 modules in admin: moneyorder, paylater, iDEAL. The sortorders are set as 1, 2, and 3. Moneyorder and paylater used to work just fine, before installing iDEAL. I can't figure out why they don't show up anymore. Can anyone please help me? Perhaps it has anything to do with ideal_install.php, which is as following: <?php // Load database settings require_once(dirname(__FILE__) . '/ideal/include.php'); $aQueries = array(); // Add #_transactions table $aQueries[] = "CREATE TABLE IF NOT EXISTS `" . DATABASE_PREFIX . "transactions` (`id` int(11) unsigned NOT NULL auto_increment, `order_id` varchar(100) default NULL, `order_code` varchar(100) default NULL, `transaction_id` varchar(100) default NULL, `transaction_code` varchar(100) default NULL, `transaction_method` varchar(100) default NULL, `transaction_date` int(11) unsigned default NULL, `transaction_amount` decimal(10,2) unsigned default NULL, `transaction_description` varchar(100) default NULL, `transaction_status` varchar(16) default NULL, `transaction_url` varchar(255) default NULL, `transaction_payment_url` varchar(255) default NULL, `transaction_success_url` varchar(255) default NULL, `transaction_pending_url` varchar(255) default NULL, `transaction_failure_url` varchar(255) default NULL, `transaction_params` text, `transaction_log` text, PRIMARY KEY (`id`));"; // Add default labels for iDEAL status $aQueries[] = "INSERT INTO `" . DATABASE_PREFIX . "orders_status` (`orders_status_id`, `language_id`, `orders_status_name`) VALUES ('100', '1', 'Payment success (verified)')"; $aQueries[] = "INSERT INTO `" . DATABASE_PREFIX . "orders_status` (`orders_status_id`, `language_id`, `orders_status_name`) VALUES ('101', '1', 'Payment success')"; $aQueries[] = "INSERT INTO `" . DATABASE_PREFIX . "orders_status` (`orders_status_id`, `language_id`, `orders_status_name`) VALUES ('102', '1', 'Payment pending')"; $aQueries[] = "INSERT INTO `" . DATABASE_PREFIX . "orders_status` (`orders_status_id`, `language_id`, `orders_status_name`) VALUES ('103', '1', 'Payment open')"; $aQueries[] = "INSERT INTO `" . DATABASE_PREFIX . "orders_status` (`orders_status_id`, `language_id`, `orders_status_name`) VALUES ('104', '1', 'Payment canceled')"; $aQueries[] = "INSERT INTO `" . DATABASE_PREFIX . "orders_status` (`orders_status_id`, `language_id`, `orders_status_name`) VALUES ('105', '1', 'Payment failure')"; $aQueries[] = "INSERT INTO `" . DATABASE_PREFIX . "orders_status` (`orders_status_id`, `language_id`, `orders_status_name`) VALUES ('106', '1', 'Payment expired')"; // Add dutch labels for iDEAL status $sql = "SELECT `languages_id` AS `id` FROM `" . DATABASE_PREFIX . "languages` WHERE `code` = 'nl' LIMIT 1;"; $oRecordset = mysql_query($sql) or die('QUERY: ' . $sql . ', ERROR: ' . mysql_error()); if(mysql_num_rows($oRecordset)) { $oRecord = mysql_fetch_assoc($oRecordset); if(strcmp($oRecord['id'], '1') !== 0) { $aQueries[] = "INSERT INTO `" . DATABASE_PREFIX . "orders_status` (`orders_status_id`, `language_id`, `orders_status_name`) VALUES ('100', '" . $oRecord['id'] . "', 'Betaling ontvangen (gecheckt)')"; $aQueries[] = "INSERT INTO `" . DATABASE_PREFIX . "orders_status` (`orders_status_id`, `language_id`, `orders_status_name`) VALUES ('101', '" . $oRecord['id'] . "', 'Betaling ontvangen')"; $aQueries[] = "INSERT INTO `" . DATABASE_PREFIX . "orders_status` (`orders_status_id`, `language_id`, `orders_status_name`) VALUES ('102', '" . $oRecord['id'] . "', 'Betaling in behandeling')"; $aQueries[] = "INSERT INTO `" . DATABASE_PREFIX . "orders_status` (`orders_status_id`, `language_id`, `orders_status_name`) VALUES ('103', '" . $oRecord['id'] . "', 'Betaling open')"; $aQueries[] = "INSERT INTO `" . DATABASE_PREFIX . "orders_status` (`orders_status_id`, `language_id`, `orders_status_name`) VALUES ('104', '" . $oRecord['id'] . "', 'Betaling geannuleerd')"; $aQueries[] = "INSERT INTO `" . DATABASE_PREFIX . "orders_status` (`orders_status_id`, `language_id`, `orders_status_name`) VALUES ('105', '" . $oRecord['id'] . "', 'Betaling mislukte')"; $aQueries[] = "INSERT INTO `" . DATABASE_PREFIX . "orders_status` (`orders_status_id`, `language_id`, `orders_status_name`) VALUES ('106', '" . $oRecord['id'] . "', 'Betaling verlopen')"; } } $query_html = ''; for($i = 0; $i < sizeof($aQueries); $i++) { if(mysql_query($aQueries[$i])) { // Query success } else { $query_html .= '<b>Query:</b> ' . $aQueries[$i] . '<br><b>Error:</b> ' . mysql_error() . '<br><br><br>'; } } // Validate files & directories $sBasePath = dirname(__FILE__) . '/'; $aPaths = array(); // Gateway files $aPaths[] = array('path' => $sBasePath . 'ideal', 'write' => false); $aPaths[] = array('path' => $sBasePath . 'ideal/certificates', 'write' => false); $aPaths[] = array('path' => $sBasePath . 'ideal/gateways', 'write' => false); $aPaths[] = array('path' => $sBasePath . 'ideal/gateways/gateway.core.cls.4.php', 'write' => false); $aPaths[] = array('path' => $sBasePath . 'ideal/gateways/gateway.core.cls.5.php', 'write' => false); $aPaths[] = array('path' => $sBasePath . 'ideal/images', 'write' => false); $aPaths[] = array('path' => $sBasePath . 'ideal/images/ideal.gif', 'write' => false); $aPaths[] = array('path' => $sBasePath . 'ideal/temp', 'write' => true); $aPaths[] = array('path' => $sBasePath . 'ideal/.htaccess', 'write' => false); $aPaths[] = array('path' => $sBasePath . 'ideal/config.php', 'write' => false); $aPaths[] = array('path' => $sBasePath . 'ideal/include.php', 'write' => false); $aPaths[] = array('path' => $sBasePath . 'ideal/index.html', 'write' => false); $aPaths[] = array('path' => $sBasePath . 'ideal/report.php', 'write' => false); $aPaths[] = array('path' => $sBasePath . 'ideal/return.php', 'write' => false); $aPaths[] = array('path' => $sBasePath . 'ideal/setup.php', 'write' => false); $aPaths[] = array('path' => $sBasePath . 'ideal/transaction.php', 'write' => false); $aPaths[] = array('path' => $sBasePath . 'ideal/validate.php', 'write' => false); // Application files $aPaths[] = array('path' => $sBasePath . 'includes/languages/dutch/modules/payment/ideal.php', 'write' => false); $aPaths[] = array('path' => $sBasePath . 'includes/languages/english/modules/payment/ideal.php', 'write' => false); $aPaths[] = array('path' => $sBasePath . 'includes/modules/payment/ideal.php', 'write' => false); $files_html = ''; for($i = 0; $i < sizeof($aPaths); $i++) { if(is_file($aPaths[$i]['path'])) { if($aPaths[$i]['write'] && !is_writable($aPaths[$i]['path'])) { $files_html .= 'File <b>' . $aPaths[$i]['path'] . '</b> not writable.<br>'; } } elseif(is_dir($aPaths[$i]['path'])) { if($aPaths[$i]['write'] && !is_writable($aPaths[$i]['path'])) { $files_html .= 'Directory <b>' . $aPaths[$i]['path'] . '</b> not writable.<br>'; } } else { $files_html .= 'File <b>' . $aPaths[$i]['path'] . '</b> does not exist.<br>'; } } echo ' <h1>IDEAL INSTALL LOG</h1> <p style="color: red;">Please remove this file after installation!</p> <h3>Queries:</h3> <code>' . ($query_html ? $query_html : 'No warnings found') . '</code> <h3>Files & Folders:</h3> <code>' . ($files_html ? $files_html : 'No warnings found') . '</code> <h3>Configuration</h3> <p>You can change your gateway settings in <b>/ideal/config.php</b>!</p> '; ?> Thank you in advance Quote
Denkster Posted December 19, 2010 Posted December 19, 2010 Probeer idealm contributie http://addons.oscommerce.com/info/3759 Dutch iDeal payment module Support (als het die naam mag hebben <_< ) moet je zoeken op forums.oscommerce.nl. succes Eveline Quote
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.
Note: Your post will require moderator approval before it will be visible.