";
echo count($b1)."
";
echo count($c1)."
";
for($i=0;$i<10;$i++){
$vdata = "sky".rand(1,9999);
$CheckValue =sha1($vdata);
echo $CheckValue."
";
}
*/
$puser=1;
$duser=2;
$ppuser=3;
$td=4;
// 直銷獎金
$insertSQLp3 =sprintf("insert into order_percent(ccid,puid,duid,pmoney,pdate,pkid)
select ccid,concat('%s'),concat('%s'),p_percent6,concat('%s'), concat('6') from order_datas where p_percent7>0 AND dcode='%s'",$puser,$duser,date('Y-m-d'),$td);
// mysql_select_db($database_BE2, $BE2);
// mysql_query($insertSQLp3, $BE2) or die(mysql_error());
echo $insertSQLp3;
if($ppuser>0){
$insertSQLp2 =sprintf("insert into order_percent(ccid,puid,duid,pmoney,pdate,pkid)
select ccid,concat('%s'),concat('%s'),p_percent2,concat('%s'),concat('2') from order_datas where p_percent2>0 AND dcode='%s'",$ppuser,$duser,date('Y-m-d'),$td);
echo $insertSQLp2;
}
$insertSQLp2a =sprintf("insert into order_percent(ccid,puid,duid,depmoney,pdate,pkid)
select ccid,concat('%s'),concat('%s'),p_demoney,concat('%s'),concat('4') from order_datas where p_demoney>0 AND dcode='%s'",$duser,$duser,date('Y-m-d'),$td);
echo $insertSQLp2a;
// $insertSQLp2a
/* order_datas,mem_auto - 2% to 抽成 order_rtype */
$insertSQL3 =sprintf("insert into order_point(eccid,euid,e_type,e_ival,e_date)
select ccid,concat('%s'),concat('%s'),(p_money*0.03),concat('%s') from order_datas where p_percent=0 AND dcode='%s'",$puser,"1",date('Y-m-d'),$td);
echo $insertSQL3;
?>