| | 60 | // TICKETS - BEGIN |
| | 61 | if (!$account_delete) |
| | 62 | { |
| | 63 | $sql = "SELECT * FROM " . TICKETS_CAT_TABLE . " ORDER BY ticket_cat_id ASC"; |
| | 64 | if(!$result = $db->sql_query($sql)) |
| | 65 | { |
| | 66 | message_die(GENERAL_ERROR, "Could not query tickets categories table", $lang['Error'], __LINE__, __FILE__, $sql); |
| | 67 | } |
| | 68 | $ticket_rows = $db->sql_fetchrowset($result); |
| | 69 | $tickets_count = count($ticket_rows); |
| | 70 | $db->sql_freeresult($result); |
| | 71 | |
| | 72 | if ($tickets_count > 0) |
| | 73 | { |
| | 74 | $tickets_array = array(); |
| | 75 | $tickets_lang_array = array(); |
| | 76 | $template->assign_var('S_TICKETS', true); |
| | 77 | for($i = 0; $i < $tickets_count; $i++) |
| | 78 | { |
| | 79 | $tickets_array[] = $ticket_rows[$i]['ticket_cat_id']; |
| | 80 | $tickets_lang_array[] = htmlspecialchars(ip_stripslashes($ticket_rows[$i]['ticket_cat_title'])); |
| | 81 | } |
| | 82 | |
| | 83 | $select_name = 'ticket_cat_id'; |
| | 84 | $default = ''; |
| | 85 | $select_js = ''; |
| | 86 | $select_ticket = $class_form->build_select_box($select_name, $default, $tickets_array, $tickets_lang_array, $select_js); |
| | 87 | } |
| | 88 | } |
| | 89 | // TICKETS - END |
| | 90 | |
| | 193 | // TICKETS - BEGIN |
| | 194 | $bcc_list = ''; |
| | 195 | if (!$account_delete) |
| | 196 | { |
| | 197 | $ticket_cat_id = request_var('ticket_cat_id', ''); |
| | 198 | if (!empty($ticket_cat_id)) |
| | 199 | { |
| | 200 | $sql = "SELECT * FROM " . TICKETS_CAT_TABLE . " WHERE ticket_cat_id = " . $ticket_cat_id; |
| | 201 | if(!$result = $db->sql_query($sql)) |
| | 202 | { |
| | 203 | message_die(GENERAL_ERROR, "Could not query tickets categories table", $lang['Error'], __LINE__, __FILE__, $sql); |
| | 204 | } |
| | 205 | $ticket_row = $db->sql_fetchrow($result); |
| | 206 | $db->sql_freeresult($result); |
| | 207 | |
| | 208 | $bcc_emails = explode(';', str_replace(array("\r\n", "\n", "\r", "\t"), array('', '', '', ''),
trim($ticket_row['ticket_cat_emails']))); |
| | 209 | if (!empty($bcc_emails)) |
| | 210 | { |
| | 211 | for($i = 0; $i < count($bcc_emails); $i++) |
| | 212 | { |
| | 213 | $bcc_list .= (($bcc_list != '') ? ', ' : '') . $bcc_emails[$i]; |
| | 214 | } |
| | 215 | } |
| | 216 | } |
| | 217 | } |
| | 218 | // TICKETS - END |
| | 219 | |
331 | 'S_POST_ACTION' => append_sid('contact_us.' . PHP_EXT), | 394 | 'S_POST_ACTION' => append_sid('contact_us.' . PHP_EXT), |
332 | 'CONFIRM_IMG' => $confirm_image, | 395 | 'CONFIRM_IMG' => $confirm_image, |
333 | 'S_HIDDEN_FIELDS' => $s_hidden_fields, | 396 | 'S_HIDDEN_FIELDS' => $s_hidden_fields, |
349 | 'L_CONFIRM_CODE' => $lang['Confirm_code'], | 412 | 'L_CONFIRM_CODE' => $lang['Confirm_code'], |
350 | 'L_CONFIRM_CODE_EXPLAIN' => $lang['Confirm_code_explain'], | 413 | 'L_CONFIRM_CODE_EXPLAIN' => $lang['Confirm_code_explain'], |
351 | 'L_SPELLCHECK' => $lang['Spellcheck'], | 414 | 'L_SPELLCHECK' => $lang['Spellcheck'], |