$result = mysql_query($sql); if (mysql_error()) { trigger_error("MySQL Query Error " . mysql_error(), E_USER_WARNING); } $updaterow = mysql_fetch_array($result); $mailed_subject = $updaterow['subject']; echo "<tr><td><label for='incidenttitle'>{$strIncidentTitle}</label><br />"; echo "<input class='required' maxlength='200' id='incidenttitle' "; echo "name='incidenttitle' size='50' type='text' value=\"" . htmlspecialchars($mailed_subject, ENT_QUOTES) . "\" />"; echo " <span class='required'>{$strRequired}</span></td>\n"; echo "<td>"; if ($type == 'free') { echo "<th>{$strServiceLevel}</th><td>" . serviceleveltag_drop_down('servicelevel', $CONFIG['default_service_level'], TRUE) . "</td>"; echo "<th>{$strSkill}</th><td>" . skill_drop_down('software', 0) . "</td></tr>"; } else { echo "<label for='software'>{$strSkill}</label><br />" . softwareproduct_drop_down('software', 1, $productid); } echo "</td></tr>"; echo "<tr><td colspan='2'> </td></tr>\n"; echo "<tr><th>{$strProblemDescription}<br /><span style='font-weight: normal'>{$strReceivedByEmail}</span></th>"; echo "<td>" . parse_updatebody($mailed_body_text) . "</td></tr>\n"; echo "<tr><td class='shade1' colspan='2'> </td></tr>\n"; } echo "<tr><td><strong>{$strNextAction}</strong><br />"; // echo "<input type='text' name='nextaction' maxlength='50' size='30' value='Initial Response' /><br /><br />"; echo show_next_action(); echo "</td>"; echo "<td colspan='2'>"; echo "<strong>{$strVisibleToCustomer}</strong><br />\n"; echo "<label><input name='cust_vis' type='checkbox' checked='checked' /> {$strVisibleToCustomer}</label>"; echo help_link('VisibleToCustomer') . "<br />";
$checkcontract = mysql_query($sql); if (mysql_error()) { trigger_error("MySQL Query Error " . mysql_error(), E_USER_WARNING); } $contract = mysql_fetch_object($checkcontract); $productid = $contract->productid; if (mysql_num_rows($checkcontract) == 0) { echo "<p class='error'>{$strPermissionDenied}</p>"; include APPLICATION_INCPATH . 'htmlfooter.inc.php'; exit; } } echo "<form action='{$_SERVER[PHP_SELF]}?page=add&action=submit' method='post'>"; echo "<table align='center' width='50%' class='vertical'>"; if ($CONFIG['portal_creates_incidents']) { echo "<tr><th>{$strArea}:</th><td class='shade1'>" . softwareproduct_drop_down('software', 0, $productid, 'external') . "<br />"; echo $strNotSettingArea . "</td></tr>"; } echo "<tr><th>{$strTitle}:</th><td class='shade1'>"; echo "<input class='required' maxlength='100' name='title' size='40' type='text' "; echo "value='{$_SESSION['formdata']['portaladdincident']['title']}' />"; echo " <span class='required'>{$strRequired}</span></td></tr>"; $sql = "SELECT * FROM `{$dbProductInfo}` WHERE productid='{$productid}'"; $result = mysql_query($sql); if (mysql_error()) { trigger_error("MySQL Query Error " . mysql_error(), E_USER_WARNING); } if (mysql_num_rows($result) > 0) { while ($productinforow = mysql_fetch_object($result)) { echo "<tr><th>{$productinforow->information}"; echo "</th>";