<?php
  
$packid=$_GET["packid"];
$userid=$_GET["userid"];
$ownansaid=$userid;
 $ownkepaid=$userid;
$ansacount=0;
echo "Packid:$packid , userid:$userid,ansacount=$ansacount";
// Include config file
require_once "configs.php";
echo "Start check ansa";
$sql="SELECT * FROM ansa join (SELECT packid,fixaid FROM lisa,fixa where fixa.id=lisa.fixaid) as b on ansa.fixaid=b.fixaid where ansa.packid=".$packid." and ansa.ownansaid=".$userid." group by ansa.fixaid";
$res = $db->query($sql);
if ($res) {
    $i=0;
    while ($row = $res->fetchArray()) {
    //    echo "{$row['username']} {$row['company']}<br>";
    $i++;
    $ansacount = $i;
    }
}
echo "ansacount =".$ansacount;
echo "Start check lisa";
$lisacount=0;
$sql="SELECT * FROM lisa,fixa where fixa.id=lisa.fixaid and packid=".$packid."  and fixa.scode like 'q%'";
$res = $db->query($sql);
if ($res) {
    $i=0;
    while ($row = $res->fetchArray()) {
    //    echo "{$row['username']} {$row['company']}<br>";
    $i++;
    $liasacount = $i;
    }
}
echo "lisacount =".$lisacount;
echo "start tranpose";
$sweight=array(0,4,2,1,1,0);//init weight into ansa
if ( $ansacount<=0 )	{
      echo "INSERT ANSA<br>";
        // Attempt select query execution
        $sql = "SELECT lisa.id as lisaid,lisa.fixaid as lisafixaid FROM `lisa`   join fixa on lisa.fixaid=fixa.id and lisa.packid=".$packid." and fixa.scode like 'q%'";
              $res = $db->query($sql);
                if ($res) {
                $i=0;
                while ($row = $res->fetchArray()) {
                    $cid=$row['lisafixaid'];
                        echo "lisa template to ansa fixaid=" . $cid . "<br>";
                        $sql = "insert into ansa  (fixaid,hid,ibox,ownansaid,packid,wbox,tbox) values ($cid,0,0,$ownansaid,$packid,$sweight[0],0),($cid,1,0,$ownansaid,$packid,$sweight[1],0),($cid,2,0,$ownansaid,$packid,$sweight[2],0),($cid,3,0,$ownansaid,$packid,$sweight[3],0),($cid,4,0,$ownansaid,$packid,$sweight[4],0),($cid,5,0,$ownansaid,$packid,$sweight[5],0)";
                        $ires=$db->exec($sql);                        
                            if ($ires) echo "Inserted";else echo "error";
                            
                    $i++;
                    }
                if ($i>0) {    echo 'OK';} else {echo "NO";}
                }      //end select lisa
    echo "start  about dyna";
    $sql = "delete from dyna  where ownerid=$ownansaid and packid=$packid";
    $ires=$db->exec($sql);                        
        if ($ires) echo "deleted";else echo "error";
         echo "lisa template to ansa fixaid=" . $cid . "<br>";
         $sql = "insert into dyna  (ownerid,packid,register) values ($ownansaid,$packid,'1')";
        $ires=$db->exec($sql);                        
        if ($ires) echo "Inserted";else echo "error";
        echo "do kepa";
        $sql = "delete from kepa  where ownkepaid=$ownkepaid and packid=$packid";
        $ires=$db->exec($sql);                        
        if ($ires) echo "deleted";else echo "error";
        $sql="SELECT *,lisa.id as lisaid,fixaid as lisafixaid FROM `lisa` join fixa on fixa.id=lisa.fixaid where  lisa.packid=".$packid." and lisa.fbox>0 group by lisa.packid,lisa.id order by lisa.lcode ";
         if ($res) {
                $i=0;
                while ($row = $res->fetchArray()) {
                    $cid=$row['lisafixaid'];
                        echo "lisa template to kepa fixaid=" . $cid . "<br>";
                        $sql = "insert into kepa  (fixaid,ownkepaid,packid) values ($cid,$ownkepaid,$packid)";
                        $ires=$db->exec($sql);                        
                            if ($ires) echo "Inserted";else echo "error(insertKepa)";
                            
                    $i++;
                    }
                if ($i>0) {    echo 'OK';} else {echo "NO";}
                }      //end select lisa inside kepa
        
} //end if ansa<=0      
echo "done";
?>
<script>
//history.go(-1);
window.location.replace(document.referrer);
</script>

Edit file:buildansap.php4611