<?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