SQL entries in ticket and ticket_message
ALTER TABLE `ost_ticket_message` ADD `building` TEXT CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL AFTER `message`;
ALTER TABLE `ost_ticket_message` ADD `room` varchar(3) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL AFTER `building`;
ALTER TABLE `ost_ticket` ADD `building` TEXT CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL AFTER `subject`;
ALTER TABLE `ost_ticket` ADD `room` varchar(3) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL AFTER `building`;
/var/www/tickets/include/staff/viewticket.inc.php
After source
<tr>
<th>Building:</th>
<td><?=$ticket->getBuilding()?></td>
</tr>
<tr>
<th>Room #:</th>
<td><?=$ticket->getRoom()?></td>
</tr>
/var/www/tickets/include/class.ticket.php
In with the rest of the functions:
function getBuilding() {
return $this->row;
}
function getRoom() {
return $this->row;
}
find the following:
"//We don't really care much about the source at message level"
after the ',message line add the following two lines:
',building='.db_input($_POST).
',room='.db_input($_POST).
then find the following line:
"//We are ready son...hold on to the rails."
and after the ',subject line add:
',building='.db_input($_POST).
',room='.db_input($_POST).
Do this step twice - once for clients and once for staff:
Clients ->
/var/www/tickets/include/client/open.inc.php
Staff ->
include/staff/newticket.inc.php
after the that closes the Telephone row:
HACKED FOR CRAZYDOG07
<tr>
<td>Building:</td>
<td>
<select name="building">
<option value="">Select One</option>
<option value="North">North</option>
<option value="South">South</option>
<option value="East">East</option>
<option value="West">West</option>
<option value="Center">Center</option>
<option value="Headquarter">Headquarter</option>
</select>
Room # <input type="text" name="room" size="3" maxlength="3" value="<?=$info?>"/>
</td>
<tr>
END HACKED
