Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

after iDEAL intallation - missing payment methods


gewoon09
 Share

Recommended Posts

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

Link to comment
Share on other sites

  • 1 month later...

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

 Share

×
×
  • Create New...