Código PHP:
<?php BEGIN__VBULLETIN__CODE__SNIPPET //
dbconnect();
$sql="update $tblrequests set categoryid='$categoryid', ";
$sql.="severity='$severity',";
$sql.="estimatedtime='$estimatedtime',";
$sql.="status='$status',";
$sql.="technicianid='$technicianid',";
$sql.="emailupdate='$emailupdate',";
$sql.="releasecall='$releasecall',";
$sql.="resolution='$resolution',";
$sql.="status2='$status2',";
$sql.="op1='$op1',";
$sql.="op2='$op2',";
$sql.="op3='$op3',";
$sql.="op4='$op4',";
$sql.="op5='$op5',";
$sql.="op6='$op6',";
$sql.="op7='$op7',";
$sql.="op8='$op8',";
$sql.="op9='$op9',";
$sql.="op10='$op10',";
$sql.="nrequest='$nrequest',";
$sql.="sorder='$sorder',";
$sql.="nrfqm='$nrfqmm',";
$sql.="pdtc='$pdtc',";
$sql.="postc='$postc',";
$sql.="nfactura='$nfactura' ";
$sql.="where ticketnumber='$ticketnumber'";
$result=mysql_query($sql);
if (!$result) {
die('Invalid query: ' . mysql_error());
}
//actualizando las fechas
$sql="update $tblrequests set fop2=now() where fop2 is null and ticketnumber='$ticketnumber'";
if($op2=="1") mysql_query($sql);
$sql="update $tblrequests set fop3=now() where fop3 is null and ticketnumber='$ticketnumber'";
if($op3=="1") mysql_query($sql);
//lo demas lo cambias siguiendo del mismo patron
...
?>