Jump to content

HELP PLEASE! Need to ad payment processor to site.

laflair13

By laflair13
in Third Party Scripts

Recommended Posts

laflair13 Member

laflair13

Posted
Posted

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 - [email protected] (this is not my email)

ICQ - 343207210

AIM - xplicit1324

Yahoo - laflair13

__________________

 

Thanks in advance

David

Archived

This topic is now archived and is closed to further replies.

Go to topic listing
×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.