); echo("\n"); echo("\n"); echo("\n"); echo("
\n"); echo("\n"); echo("\n"); echo("\n"); echo("\n"); } function write_ticket($pb, $app_id) { global $prefixCms; $perm=get_perm($app_id); if (!$perm["can_write"]) die("You can't access!"); $user_id=$_SESSION["sesCmsUser"]; $prob_id=$_POST["prob_id"]; $group_id=(int)$_POST["group_id"]; $sev_id=get_default_val("severity"); $stat_id=get_default_val("status"); $cname=htmlspecialchars($_POST["cname"]); $csurname=htmlspecialchars($_POST["csurname"]); $email=htmlspecialchars($_POST["email"]); $tel1=htmlspecialchars($_POST["tel1"]); $tel2=htmlspecialchars($_POST["tel2"]); $title=htmlspecialchars($_POST["title"]); //$txt=htmlspecialchars($_POST["txt"]); $txt=$_POST["txt"]; $sslink=htmlspecialchars($_POST["sslink"]); $now=time(); $customers=get_group_opt(); $err=""; if ((int)$customers[$group_id]["ticketsleft"] < 1) $err=_ERR_NOTICKETSLEFT; if ($customers[$group_id]["expdate"] <= date("Y-m-d 00:00:00")) $err=_ERR_EXPIRED; if (!is_array($customers[$group_id])) $err=_ERR_NOTACTIVE; if ($title == "") $err=_ERR_NOTITLE; if ($txt == "") $err=_ERR_NOTXT; if ($err == "") { $qtxt ="INSERT INTO ".$prefixCms."_tickets (app_id, prob_id, sev_id, stat_id, user_id, group_id, cname, csurname, email, tel1, tel2, title, txt, sslink, post_time, upd_time) "; $qtxt.="VALUES ('$app_id', '$prob_id', '$sev_id', '$stat_id', '$user_id', '$group_id', '$cname', '$csurname', '$email', '$tel1', '$tel2', '$title', '$txt', '$sslink', '$now', '$now');"; $q=mysql_query($qtxt); //echo("

$qtxt\n"); header("location: index.php?mn=tickets&op=showtickets&pb=$pb&app_id=$app_id"); } else { echo(""._ERR.": $err

\n\n"); echo("<< "._BACK."\n"); } } function edit_status($pb, $app_id, $ticket_id) { global $prefixCms; $perm=get_perm($app_id); if (!$perm["can_moderate"]) die("You can't access!"); $qtxt="SELECT stat_id FROM ".$prefixCms."_tickets WHERE ticket_id='$ticket_id'"; $q=mysql_query($qtxt); if (($q) && (mysql_num_rows($q) > 0)) { $row=mysql_fetch_array($q); } $id=$row["stat_id"]; $url="index.php?mn=tickets&pb=$pb&app_id=$app_id&ticket_id=$ticket_id&op=updateticket"; echo("

\n"); echo(""._STATUS.":
\n"); load_dropdown("stat_id", "status", $id); echo("\n"); echo("

\n"); echo("

\n"); } function edit_severity($pb, $app_id, $ticket_id) { global $prefixCms; $perm=get_perm($app_id); if (!$perm["can_moderate"]) die("You can't access!"); $qtxt="SELECT sev_id FROM ".$prefixCms."_tickets WHERE ticket_id='$ticket_id'"; $q=mysql_query($qtxt); if (($q) && (mysql_num_rows($q) > 0)) { $row=mysql_fetch_array($q); } $id=$row["sev_id"]; $url="index.php?mn=tickets&pb=$pb&app_id=$app_id&ticket_id=$ticket_id&op=updateticket"; echo("

\n"); echo(""._SEVERITY.":
\n"); load_dropdown("sev_id", "severity", $id); echo("\n"); echo("

\n"); echo("

\n"); } function edit_app($pb, $app_id, $ticket_id) { global $prefixCms; $perm=get_perm($app_id); if (!$perm["can_moderate"]) die("You can't access!"); $qtxt="SELECT app_id FROM ".$prefixCms."_tickets WHERE ticket_id='$ticket_id'"; $q=mysql_query($qtxt); if (($q) && (mysql_num_rows($q) > 0)) { $row=mysql_fetch_array($q); } $id=$row["app_id"]; $url="index.php?mn=tickets&pb=$pb&app_id=$app_id&ticket_id=$ticket_id&op=updateticket"; echo("

\n"); echo(""._AREA.":
\n"); load_dropdown("app_id", "app", $id); echo("\n"); echo("

\n"); echo("

\n"); } function edit_probarea($pb, $app_id, $ticket_id) { global $prefixCms; $perm=get_perm($app_id); if (!$perm["can_moderate"]) die("You can't access!"); $qtxt="SELECT prob_id FROM ".$prefixCms."_tickets WHERE ticket_id='$ticket_id'"; $q=mysql_query($qtxt); if (($q) && (mysql_num_rows($q) > 0)) { $row=mysql_fetch_array($q); } $id=$row["prob_id"]; $url="index.php?mn=tickets&pb=$pb&app_id=$app_id&ticket_id=$ticket_id&op=updateticket"; echo("

\n"); echo(""._AREA.":
\n"); load_problem_dropdown("prob_id", $app_id, $id); echo("\n"); echo("

\n"); echo("

\n"); } function edit_title($pb, $app_id, $ticket_id) { global $prefixCms; $perm=get_perm($app_id); if (!$perm["can_moderate"]) die("You can't access!"); $qtxt="SELECT title FROM ".$prefixCms."_tickets WHERE ticket_id='$ticket_id'"; $q=mysql_query($qtxt); if (($q) && (mysql_num_rows($q) > 0)) { $row=mysql_fetch_array($q); } $title=$row["title"]; $url="index.php?mn=tickets&pb=$pb&app_id=$app_id&ticket_id=$ticket_id&op=updateticket"; echo("

\n"); echo(""._TITLE.":
\n"); echo("\n"); echo("\n"); echo("

\n"); echo("

\n"); } function edit_txt($pb, $app_id, $ticket_id) { global $prefixCms; $perm=get_perm($app_id); if (!$perm["can_moderate"]) die("You can't access!"); $qtxt="SELECT txt FROM ".$prefixCms."_tickets WHERE ticket_id='$ticket_id'"; $q=mysql_query($qtxt); if (($q) && (mysql_num_rows($q) > 0)) { $row=mysql_fetch_array($q); } $txt=$row["txt"]; $url="index.php?mn=tickets&pb=$pb&app_id=$app_id&ticket_id=$ticket_id&op=updateticket"; echo '