Integrate osTicket in another project

parfonium

Hello, is it possible to integrate osTicket inside of another PHP/mysql application ?

I've read posts on integrating it with a wordpress site, so I know the look of osTicket is customizable, but what about the users/login data ? How hard would it be to indicate another table where that information is stored ?

cloudpointoh

It certainly is possibly although, i'm not sure how easy it would be. The beauty of OST is it's open source, and the development community behind it is full of brilliant people. Give us a description of what you might have in mind and we'll see what we can do about leading you in the right direction.

parfonium

I have a project which uses symfony 1.4 and the "sfDoctrineGuardPlugin" plugin for managing user data.

users are stored in the following table :

--

-- Table structure for table `sf_guard_user`

--

CREATE TABLE IF NOT EXISTS `sf_guard_user` (

`id` bigint(20) NOT NULL AUTO_INCREMENT,

`first_name` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,

`last_name` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,

`email_address` varchar(255) COLLATE utf8_unicode_ci NOT NULL,

`username` varchar(128) COLLATE utf8_unicode_ci NOT NULL,

`algorithm` varchar(128) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'sha1',

`salt` varchar(128) COLLATE utf8_unicode_ci DEFAULT NULL,

`password` varchar(128) COLLATE utf8_unicode_ci DEFAULT NULL,

`is_active` tinyint(1) DEFAULT '1',

`is_super_admin` tinyint(1) DEFAULT '0',

`last_login` datetime DEFAULT NULL,

`created_at` datetime NOT NULL,

`updated_at` datetime NOT NULL,

PRIMARY KEY (`id`),

UNIQUE KEY `email_address` (`email_address`),

UNIQUE KEY `username` (`username`),

KEY `is_active_idx_idx` (`is_active`)

) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=2 ;

where algorithm is 'sha1' and 'salt' is a secret salt.

Could I edit OST to use that table for users ?