Secondary Ticket Table

tarick

Good Day,

I want to have to two very different types of tickets.

We have a need to track transaction disputes separately from service tickets.

I can modify my fields etc... quite easily however I would like to have a separate table within my database to store them. I can't seem to find where the table is in the class.tickets.php. I am not much of a coder but I think I can do this once I can find how to change the table.

Thanks any help is appreciated.

dohcjs

You would just need to change the table name referenced in the load and save methods of class.ticket.php depending on the ticket type. The table names are setup as constants in main.inc.php. Unless the table structure is going to be totally different you might consider adding a tiny int field and setting it to 1 for desputes and 0 for regular service request.

The constant for the tickets table is TICKETS_TABLE I believe, dont have the source code in front of me atm.

tarick

Thank dohcjs!.

Now I can take it from here.

Just need to define my new table and customize the various ticket needs!

Cheers!

tarick

Okay so I got it!

Had to create my new table with my fields. (obvious)

added my new tables to main.inc.php.

copied and renamed the following files to suit my needs.

tickets.php

class.tickets.php

viewticket.inc.php

editticket.inc.php

newticket.inc.php

tickets.inc.php

made changes to table references and to the includes as needed.

Hope this helps someone out. Thanks to dohcjs for pointing out where the tables are defined.