"; $sql1="SELECT \"EmailAddress\" FROM \"WhiteListing\".\"SiteEmail\" where \"SiteId\" =". odbc_result($url,"SiteId") .""; $s_email= odbc_exec($db_conn,$sql1); print ""; print "
URL Priority
Verdict Previos Verdict".odbc_result($url,"PreviousVerdict")."
User Added".odbc_result($url,"User Added")." User Last Modified".odbc_result($url,"User Last Modified")."
Date Added".odbc_result($url,"DateAdded")." Date Last Modified".odbc_result($url,"DateLastModified")."
Comments

Is OEM Vendor Don't Known Yes No Is Code Signer Don't Known Yes No
Read as Popular Don't Known Yes No  
Last FP Date Last Date Contacted

Site Email
"; print "
"; } if (isset($_GET['siteid'])){ $siteid=$_GET['siteid']; // prneditbox(); } else{ print "Not Sites"; } if(isset($_POST['save_site'])){ // print "Changed save"; $url=$_POST['site_url']; $priort = $_POST['source']; $verd = $_POST['verdcit']; $comm = $_POST['comment']; $oem = $_POST['isoem']; $codesig = $_POST['iscodesgned']; $pop = $_POST['popler']; $lastfp = date("Y-m-d",strtotime($_POST['lastfp'])); $lastcont = date("Y-m-d",strtotime($_POST['lastcontact'])); $u_sql ="select \"WhiteListing\".update_site_full('$url',$priort,$verd,'$comm',$oem,$codesig,$pop,'$lastfp','$lastcont',$siteid)"; $updt_site = odbc_exec($db_conn,$u_sql); prneditbox(); //print $u_sql; } elseif(!isset($_POST['save_site']) && !isset($_POST['add_email']) && !isset($_POST['del_email'])) {prneditbox();} if(isset($_POST['add_email'])){ $mail_sql = "select \"WhiteListing\".add_email_s('".$_POST['edt_mail']."',".$siteid." )"; $add_mail = odbc_exec($db_conn,$mail_sql); prneditbox(); } if(isset($_POST['del_email'])){ $mail_sql = "select \"WhiteListing\".del_email_s('".$_POST['sel_email']."',".$siteid." )"; $add_mail = odbc_exec($db_conn,$mail_sql); prneditbox(); } ?>