laflair13 Posted October 9, 2008 Share Posted October 9, 2008 Hey all, I have a script that as of now it only allows paypal as the means of payment. I am trying to ad another one (ECSuite.com) as an option of payment. I cannot find anywhere that I can intergrade it into the script. Can anyone help me do this or point me in the direction on how to do it? I looked everywhere on ECsuite for something but couldnt find anything. Here are 2 pages that I think the coding might go. functions.php <? function updateSortOrder($tablename,$sortcolumn,$idcolumn,$idvalue,$newsortno) { $strSQL="select $sortcolumn from $tablename where $idcolumn=".$idvalue; $result=mysql_query($strSQL); $oldsortno=mysql_result($result,0,$sortcolumn); if($newsortno>$oldsortno) $strSQL="update $tablename set $sortcolumn=$sortcolumn-1 where $sortcolumn>$oldsortno AND $sortcolumn<=$newsortno"; else $strSQL="update $tablename set $sortcolumn=$sortcolumn+1 where $sortcolumn<$oldsortno AND $sortcolumn>=$newsortno"; $result=mysql_query($strSQL) or die(mysql_error()); $strSQL="update $tablename set $sortcolumn=$newsortno where $idcolumn=$idvalue"; $result=mysql_query($strSQL) or die(mysql_error()); } function fixSorting($tablename,$sortcolumn,$idcolumn) { $strSQL="select count(*) CNT from $tablename"; $resultM=mysql_query($strSQL) or die(mysql_error().$strSQL); if(mysql_num_rows($resultM)==0) return false; $totalrecords=mysql_result($resultM,0,"CNT"); if($totalrecords==0) return true; $strSQL="select $idcolumn from $tablename order by $sortcolumn"; $resultSort=mysql_query($strSQL) or die(mysql_error().$strSQL); $arrUpdates=array(); $counter=0; while($row=mysql_fetch_assoc($resultSort)) { $counter++; $arrUpdates[]="update $tablename set $sortcolumn=$counter where $idcolumn=".$row[$idcolumn]; } for($i=0;$i<count($arrUpdates);$i++) mysql_query($arrUpdates[$i]) or die(mysql_error()); return true; } function getNewSortNo($tablename,$sortcolumn) { $strSQL="select max($sortcolumn) msortno from $tablename"; $resultM=mysql_query($strSQL) or die(mysql_error().$strSQL); if(mysql_num_rows($resultM)==0) $msortno=1; else $msortno=mysql_result($resultM,0,"msortno")*1+1; return $msortno; } function uploadImage($fieldname,$path,$filename) { if (isset($_FILES[$fieldname]) && $_FILES[$fieldname]['name']!="" ) { $filename = "pickserviceimg" . $pickserviceid . substr( $_FILES[$fieldname]['name'], strrpos ( $_FILES[$fieldname]['name'], ".")); if (!move_uploaded_file($_FILES[$fieldname]['tmp_name'], $path . $filename)) { return ""; } else { // echo ' good upload '; chmod ($path . $filename, 0755); return $filename; } } return ""; } function getCommaSeperatedColumn($strSQL,$column) { $resultCSC=mysql_query($strSQL) or die(mysql_error().$strSQL); $strReturn=""; $strComma=""; while($row=mysql_fetch_assoc($resultCSC)) { $strReturn.=$strComma.$row[$column]; $strComma=","; } if($strReturn=="") return "0"; return $strReturn; } function drawListBoxDB($query,$name,$valcolumn,$displaycolumn,$selected,$additional='',$option='') { $ret="<select name=$name class=textbox $additional>$option"; $rsTemp=mysql_query($query) or die(mysql_error()); while($rowTemp=mysql_fetch_assoc($rsTemp) ) { $strSelected=$rowTemp[$valcolumn]==$selected?"selected":""; $ret.="<option value='$rowTemp[$valcolumn]' $strSelected>$rowTemp[$displaycolumn]</option>"; } $ret.="</select>"; return $ret; } function drawListBoxDB_Function($query,$name,$valcolumn,$function,$selected,$additional='',$option='') { $ret="<select name=$name class=textbox $additional>$option"; $rsTemp=mysql_query($query) or die(mysql_error()); while($rowTemp=mysql_fetch_assoc($rsTemp) ) { $strSelected=$rowTemp[$valcolumn]==$selected?"selected":""; $ret.="<option value='$rowTemp[$valcolumn]' $strSelected>".$function($rowTemp[$valcolumn])."</option>"; } $ret.="</select>"; return $ret; } function getPick($pickid) { $strSQL="select * from tblpicks where pickid=$pickid"; $resultPick=mysql_query($strSQL); if(mysql_num_rows($resultPick)==0) return ""; else return format_date(mysql_result($resultPick,0,"dateadded"))." - ".mysql_result($resultPick,0,"team1").":".mysql_result($resultPick,0,"team2"); } function getMember($memberid) { $strSQL="select * from tblmembers where memberid=$memberid"; $resultPick=mysql_query($strSQL); if(mysql_num_rows($resultPick)==0) return ""; else return mysql_result($resultPick,0,"fname")." ".mysql_result($resultPick,0,"lname")." (".mysql_result($resultPick,0,"login").")"; } function drawListBoxDB2($query,$name,$valcolumn,$displaycolumn1,$displaycolumn2,$selected,$additional='',$option='') { $ret="<select name=$name class=textbox $additional>$option"; $rsTemp=mysql_query($query) or die(mysql_error()); while($rowTemp=mysql_fetch_assoc($rsTemp) ) { $strSelected=$rowTemp[$valcolumn]==$selected?"selected":""; $ret.="<option value='$rowTemp[$valcolumn]' $strSelected>$rowTemp[$displaycolumn1] $rowTemp[$displaycolumn2]</option>"; } $ret.="</select>"; return $ret; } function format_date($strdate) { if($strdate=="0000-00-00" || !$strdate) return NULL; $time=strtotime($strdate,date("Y-m-d")); return date("m/d/Y",$time); } function format_timestamp($timestamp) { $year=substr($timestamp,0,4); $month=substr($timestamp,4,2); $date=substr($timestamp,6,2); $timepart=substr($timestamp,8,2).":".substr($timestamp,10,2).":".substr($timestamp,12,2); //return "$year-$month-$date $timepart"; $datepart=strtotime("$year-$month-$date",date("Y-m-d")); //$timepart=strtotime($timepart,"His"); return date("M d, Y",$datepart)." ".$timepart; } function jsGoURL($destnationurl) { return " <SCRIPT LANGUAGE=javascript> <!-- window.location=\"$destnationurl\"; //--> </SCRIPT> "; } function getresult($status) { $arr=array(0=>"Pending",1=>"Won",2=>"Loss",3=>"Tie"); return $arr[$status]; } function getViewableall($status) { $arr=array(0=>"No",1=>"Yes"); return $arr[$status]; } function getServiceGroups($serviceid) { $strSQL="select * from tblservicegroups,tblgroups where tblservicegroups.groupid=tblgroups.groupid AND serviceid=".$serviceid; $servicegroups=mysql_query($strSQL); $strComma=""; $strGps=""; while($rowgrps=mysql_fetch_array($servicegroups)) { $strGps.= $strComma . $rowgrps[shorttitle]; $strComma=", "; } return $strGps; } function getSortLink($title,$sort,$id) { if($sort==$id) return "<a class='tHead' href='?sort=".($id+1)."'>$title</a>↑"; if($sort==($id+1)) return "<a class='tHead' href='?sort=".$id."'>$title</a>↓"; return "<a class='tHead' href='?sort=".$id."'>$title</a>"; } function smoothdate ($year, $month, $day) { return sprintf ('%04d', $year) . sprintf ('%02d', $month) . sprintf ('%02d', $day); } function date_difference ($first, $second) { $month_lengths = array (31, 28, 31, 30, 31, 30, 31, 31, 30, 31, 30, 31); $retval = FALSE; if ( checkdate($first['month'], $first['day'], $first['year']) && checkdate($second['month'], $second['day'], $second['year']) ) { $start = smoothdate ($first['year'], $first['month'], $first['day']); $target = smoothdate ($second['year'], $second['month'], $second['day']); if ($start <= $target) { $add_year = 0; while (smoothdate ($first['year']+ 1, $first['month'], $first['day']) <= $target) { $add_year++; $first['year']++; } $add_month = 0; while (smoothdate ($first['year'], $first['month'] + 1, $first['day']) <= $target) { $add_month++; $first['month']++; if ($first['month'] > 12) { $first['year']++; $first['month'] = 1; } } $add_day = 0; while (smoothdate ($first['year'], $first['month'], $first['day'] + 1) <= $target) { if (($first['year'] % 100 == 0) && ($first['year'] % 400 == 0)) { $month_lengths[1] = 29; } else { if ($first['year'] % 4 == 0) { $month_lengths[1] = 29; } } $add_day++; $first['day']++; if ($first['day'] > $month_lengths[$first['month'] - 1]) { $first['month']++; $first['day'] = 1; if ($first['month'] > 12) { $first['month'] = 1; } } } $retval = array ('years' => $add_year, 'months' => $add_month, 'days' => $add_day); } } return $retval; } ?> and payconfig.php <? session_start(); require('stts/hit.inc'); include("conn.php"); $item_name = $_REQUEST['item_name']; $item_number = $_REQUEST['item_number']; $payment_amount = $_REQUEST["mc_gross"]; $txn_id = $_REQUEST["txn_id"]; if(substr($item_number, 0, 2) == "op"){ $op_number = substr($item_number, 2); $result = mysql_query("SELECT P.onepick FROM tblmemberservices M, tblpicks P WHERE (M.serviceid * -1)=P.pickid AND M.memberserviceid = $op_number"); } else $result = mysql_query("SELECT S.cost FROM tblmemberservices M, tblservice S WHERE M.serviceid=S.serviceid AND M.memberserviceid = $item_number"); if($row = mysql_fetch_array($result)){ $cost = $row[0]; if($item_name != ""){ $result=mysql_query("SELECT cAmount FROM tbldiscounts WHERE cDiscountName = '$item_name'"); if($row = mysql_fetch_array($result)){ $cDiscount = str_replace("$", "", $row[0]); if(substr($cDiscount, strlen($cDiscount) - 1) == "%"){ $fDiscount = substr($cDiscount, 0, strlen($cDiscount) - 1); $cost = $cost * (1 - ($fDiscount / 100)); } else { $fDiscount = $cDiscount; $cost = $cost - $fDiscount; } } } if($cost < 0) $cost = 0; if($payment_amount >= ($cost - .01)){ if(substr($item_number, 0, 2) == "op") mysql_query("UPDATE tblmemberservices SET subscription = 2, status = 1, txn_id = '$txn_id', paymentmethod = 'PayPal', startdate = NOW() WHERE memberserviceid = $op_number"); else mysql_query("UPDATE tblmemberservices SET subscription = 2, status = 1, txn_id = '$txn_id', paymentmethod = 'PayPal', startdate = NOW() WHERE memberserviceid = $item_number"); print("payment ok"); } else print("no payment1"); } else print("no payment2"); print("SELECT P.onepick FROM tblmemberservices M, tblpicks P WHERE (M.serviceid * -1)=P.pickid AND M.serviceid = ($op_number * -1)"); ?> If anyone has any idea on how to do this, I would very much appreciate the help. I am lost when it comes to adding a payment gateway. If anyone is willing, I have messengers if you can help. MSN - dleflair@bellsouth.net (this is not my email) ICQ - 343207210 AIM - xplicit1324 Yahoo - laflair13 __________________ Thanks in advance David 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.