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";