function key4ce_generateID()
{
$id = mt_rand(100000, 999999);
$config = get_option('os_ticket_config');
extract($config);
$ost_wpdb = new wpdb($username, $password, $database, $host);
$count_no = $ost_wpdb->get_var("SELECT count(*) as count from " . $keyost_prefix . "ticket WHERE number = '{$id}'");
if ($count_no > 0) {
return key4ce_generateID();
}
return $id;
}
<?php
/*
Template Name: adminticketemail.php
*/
require_once WP_PLUGIN_DIR . '/key4ce-osticket-bridge/includes/functions.php';
$user_id = $ost_wpdb->get_var("SELECT user_id FROM " . $keyost_prefix . "user_email WHERE `address` = '" . $_REQUEST['email'] . "'");
$wp_user_email_id = $_REQUEST['email'];
$tic_ID = key4ce_generateID();
$checkUserID = $ost_wpdb->get_results("SELECT number from {$ticket_table} WHERE number = '{$tic_ID}'");
if (count($checkUserID) > 0) {
$tic_ID = key4ce_generateID();
}
$dep_id = $_REQUEST['deptId'];
$sla_id = 1;
$pri_id = $_REQUEST['priorityId'];
@($top_id = $_REQUEST['topicId']);
$staff_id = 0;
$team_id = 0;
$usid = $user_id;
$em = $_REQUEST['email'];
$nam = $_REQUEST['username'];
$nam = preg_replace('/[^\\p{L}\\p{N}\\s]/u', '', $nam);
$adem = $_REQUEST['ademail'];
$title = $_REQUEST['stitle'];
$dirname = $_REQUEST['sdirna'];
@($sub = Format::stripslashes($_REQUEST['subject']));
@($newtickettemp = Format::stripslashes($_REQUEST['newtickettemp']));
$ip_add = $_SERVER['REMOTE_ADDR'];
if ($keyost_version == 194 || $keyost_version == 195 || $keyost_version == 1951) {
$ticketstate = "1";
