include("../php_scripts/connect_database.php"); include("php_scripts/session_start.php"); include("php_scripts/function_share.php"); include("php_scripts/function_list.php"); include("php_scripts/load_per_control.php"); $db_dpis2 = new connect_dpis($dpisdb_host, $dpisdb_name, $dpisdb_user, $dpisdb_pwd); $UPDATE_DATE = date("Y-m-d H:i:s"); $cmd = " select PER_TYPE ,POS_ID,POEM_ID,POEMS_ID from PER_PERSONAL where PER_ID=$PER_ID "; $db_dpis->send_cmd($cmd); $data = $db_dpis->get_array(); $PER_TYPE = $data[PER_TYPE]; if($command=="UPDATE"){ if($PER_TYPE==1) $cmd = " update PER_PROMOTE_P set PRO_SUMMARY='$PRO_SUMMARY',UPDATE_USER = $SESS_USERID, UPDATE_DATE = '$UPDATE_DATE' where SUBSTR(PRO_DATE, 1, 10)='$PRO_DATE' and POS_ID=$POS_POEM_ID and PER_ID=$PER_ID "; elseif($PER_TYPE==2) $cmd = " update PER_PROMOTE_E set PRO_SUMMARY='$PRO_SUMMARY',UPDATE_USER = $SESS_USERID, UPDATE_DATE = '$UPDATE_DATE' where SUBSTR(PRO_DATE, 1, 10)='$PRO_DATE' and POEM_ID=$POS_POEM_ID and PER_ID=$PER_ID "; elseif($PER_TYPE==3) $cmd = " update PER_PROMOTE_E set PRO_SUMMARY='$PRO_SUMMARY',UPDATE_USER = $SESS_USERID, UPDATE_DATE = '$UPDATE_DATE' where SUBSTR(PRO_DATE, 1, 10)='$PRO_DATE' and POEM_ID=$POS_POEM_ID and PER_ID=$PER_ID "; $db_dpis->send_cmd($cmd); // $db_dpis->show_error(); // echo "-> $cmd"; } // end if // echo "-> ( ".$PER_TYPE."/".$PRO_DATE."+".$POS_POEM_ID." ) +".$command.":".$cmd; if($POS_POEM_ID && $PRO_DATE){ if($PER_TYPE==1){ $cmd = " select PRO_SUMMARY from PER_PROMOTE_P where SUBSTR(PRO_DATE, 1, 10)='$PRO_DATE' and POS_ID=$POS_POEM_ID and PER_ID=$PER_ID "; }elseif($PER_TYPE==2){ $cmd = " select PRO_SUMMARY from PER_PROMOTE_E where SUBSTR(PRO_DATE, 1, 10)='$PRO_DATE' and POEM_ID=$POS_POEM_ID and PER_ID=$PER_ID "; }elseif($PER_TYPE==3){ $cmd = " select PRO_SUMMARY from PER_PROMOTE_E where SUBSTR(PRO_DATE, 1, 10)='$PRO_DATE' and POEM_ID=$POS_POEM_ID and PER_ID=$PER_ID "; } // end if $db_dpis->send_cmd($cmd); $data = $db_dpis->get_array(); $PRO_SUMMARY = stripslashes(trim($data[PRO_SUMMARY])); // echo "-> ( ".$PRO_SUMMARY." ) +".$command.":".$cmd; } ?>