1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181 |
<?php
/**
*
* @package Icy Phoenix
* @version $Id$
* @copyright (c) 2008 Icy Phoenix
* @license http://opensource.org/licenses/gpl-license.php GNU Public License
*
*/
define('IN_ICYPHOENIX', true);
if(!empty($setmodules))
{
$file = basename(__FILE__);
$module['1100_General']['220_Tickets_Emails'] = $file;
return;
}
if (!defined('IP_ROOT_PATH')) define('IP_ROOT_PATH', './../');
if (!defined('PHP_EXT')) define('PHP_EXT', substr(strrchr(__FILE__, '.'), 1));
require('./pagestart.' . PHP_EXT);
// DB CLASS - BEGIN
include(IP_ROOT_PATH . 'includes/class_db.' . PHP_EXT);
$class_db = new class_db();
$class_db->main_db_table = TICKETS_CAT_TABLE;
$class_db->main_db_item = 'ticket_cat_id';
// DB CLASS - END
// MODES - BEGIN
$mode_types = array('list', 'add', 'edit', 'save', 'delete');
$mode = request_var('mode', $mode_types[0]);
$mode = (isset($_POST['add']) ? 'add' : (isset($_POST['save']) ? 'save' : $mode));
$mode = (!in_array($mode, $mode_types) ? $mode_types[0] : $mode);
// MODES - END
// VARS - BEGIN
$ticket_cat_id = request_var('ticket_cat_id', 0);
$s_hidden_fields = '';
// VARS - END
if($mode != 'list')
{
if(($mode == 'edit') || ($mode == 'add'))
{
$template->set_filenames(array('body' => ADM_TPL . 'tickets_edit_body.tpl'));
if($mode == 'edit')
{
if($ticket_cat_id)
{
$sql = "SELECT * FROM " . TICKETS_CAT_TABLE . " WHERE ticket_cat_id = " . $ticket_cat_id;
if(!$result = $db->sql_query($sql))
{
message_die(GENERAL_ERROR, "Could not query tickets categories table", "Error", __LINE__, __FILE__, $sql);
}
$ticket_info = $db->sql_fetchrow($result);
$s_hidden_fields .= '<input type="hidden" name="ticket_cat_id" value="' . $ticket_cat_id . '" />';
$db->sql_freeresult($result);
}
else
{
message_die(GENERAL_MESSAGE, $lang['TICKETS_NO_TICKET_SEL']);
}
}
$template->assign_vars(array(
'TICKET_TITLE' => htmlspecialchars(ip_stripslashes($ticket_info['ticket_cat_title'])),
'TICKET_DESCRIPTION' => htmlspecialchars(ip_stripslashes($ticket_info['ticket_cat_des'])),
'TICKET_EMAILS' => htmlspecialchars(ip_stripslashes($ticket_info['ticket_cat_emails'])),
'L_SUBMIT' => $lang['Submit'],
'S_TICKETS_ACTION' => append_sid('admin_tickets.' . PHP_EXT),
'S_HIDDEN_FIELDS' => $s_hidden_fields
)
);
$template->pparse('body');
include('./page_footer_admin.' . PHP_EXT);
}
elseif($mode == 'save')
{
$ticket_cat_title = request_var('ticket_cat_title', '');
$ticket_cat_des = request_var('ticket_cat_des', '');
$ticket_cat_emails = request_var('ticket_cat_emails', '');
if($ticket_cat_title == '')
{
message_die(GENERAL_MESSAGE, $lang['TICKETS_NO_TICKET_TITLE']);
}
$inputs_array = array(
'ticket_cat_title' => ip_addslashes($ticket_cat_title),
'ticket_cat_des' => ip_addslashes($ticket_cat_des),
'ticket_cat_emails' => ip_addslashes($ticket_cat_emails),
);
if ($ticket_cat_id > 0)
{
$class_db->update_item($ticket_cat_id, $inputs_array);
$message = '<br /><br />' . $lang['TICKETS_DB_UPDATED'];
}
else
{
$class_db->insert_item($inputs_array);
$message = '<br /><br />' . $lang['TICKETS_DB_ADDED'];
}
$message .= '<br /><br />' . sprintf($lang['TICKETS_DB_CLICK'], '<a href="' . append_sid('admin_tickets.' . PHP_EXT) . '">', '</a>');
$message .= '<br /><br />' . sprintf($lang['Click_return_admin_index'], '<a href="' . append_sid('index.' . PHP_EXT . '?pane=right') . '">', '</a>');
message_die(GENERAL_MESSAGE, $message);
}
elseif($mode == 'delete')
{
$ticket_cat_id = request_var('ticket_cat_id', 0);
if($ticket_cat_id > 0)
{
$class_db->delete_item($ticket_cat_id);
$message = '<br /><br />' . $lang['TICKETS_DB_DELETED'];
}
else
{
$message = '<br /><br />' . $lang['TICKETS_NO_TICKET_SEL'];
}
$message .= '<br /><br />' . sprintf($lang['TICKETS_DB_CLICK'], '<a href="' . append_sid('admin_tickets.' . PHP_EXT) . '">', '</a>');
$message .= '<br /><br />' . sprintf($lang['Click_return_admin_index'], '<a href="' . append_sid('index.' . PHP_EXT . '?pane=right') . '">', '</a>');
message_die(GENERAL_MESSAGE, $message);
}
}
else
{
$template->set_filenames(array('body' => ADM_TPL . 'tickets_list_body.tpl'));
$sql = "SELECT * FROM " . TICKETS_CAT_TABLE . " ORDER BY ticket_cat_id ASC";
if(!$result = $db->sql_query($sql))
{
message_die(GENERAL_ERROR, "Could not query tickets categories table", $lang['Error'], __LINE__, __FILE__, $sql);
}
$ticket_rows = $db->sql_fetchrowset($result);
$tickets_count = count($ticket_rows);
$db->sql_freeresult($result);
$template->assign_vars(array(
'S_TICKETS_ACTION' => append_sid('admin_tickets.' . PHP_EXT),
'S_HIDDEN_FIELDS' => $s_hidden_fields
)
);
if ($tickets_count == 0)
{
$template->assign_var('S_NO_TICKETS', true);
}
else
{
for($i = 0; $i < $tickets_count; $i++)
{
$row_class = (!($i % 2)) ? $theme['td_class1'] : $theme['td_class2'];
$template->assign_block_vars('ticket', array(
'ROW_CLASS' => $row_class,
'TICKET_TITLE' => htmlspecialchars(ip_stripslashes($ticket_rows[$i]['ticket_cat_title'])),
'TICKET_DESCRIPTION' => htmlspecialchars(ip_stripslashes($ticket_rows[$i]['ticket_cat_des'])),
'TICKET_EMAILS' => htmlspecialchars(ip_stripslashes($ticket_rows[$i]['ticket_cat_emails'])),
'U_EDIT' => append_sid('admin_tickets.' . PHP_EXT . '?mode=edit&ticket_cat_id=' . $ticket_rows[$i]['ticket_cat_id']),
'U_DELETE' => append_sid('admin_tickets.' . PHP_EXT . '?mode=delete&ticket_cat_id=' . $ticket_rows[$i]['ticket_cat_id'])
)
);
}
}
}
$template->pparse('body');
include('./page_footer_admin.' . PHP_EXT);
?> |
